Aayush Pandey
AP
Aayush .
Project Management • Data Analyst • Product Analyst
Download CV

Hi, I'm Aayush Pandey

I'm a |

I am Data Analyst building automation and analytics solutions that improve processes, ensure compliance and deliver measurable business value.

  • Target roles: Project Management, Data Analyst, Product Analyst
  • Open to: Full-time roles & Entry-level project/analyst positions
  • Based in: India · Available for remote/hybrid opportunities
Download CV Get in touch

About Me

I'm a results driven analyst who delivers automation, robust reporting and stronger control environments. My work reduces manual effort, improves data accuracy, and frees stakeholders to focus on decisions.

What I bring

  • Project coordination: stakeholder mapping, milestones, and on-time delivery
  • Automation: Python pipelines, audit automation (CaseWare/IDEA) and ETL processes
  • Data analysis: SQL, data modelling, reporting & dashboards
  • Audit & compliance: ITGC testing and control remediation support
  • Product thinking: Metrics & KPIs, User Centered Problem Solving

Career focus

I am pursuing roles where I can combine project management with analytics — leading cross functional projects, building analytic insights for product decisions and automating operational workstreams to scale impact.

Short-term goal: Transition to a Project Manager / Product Analyst role that uses my analytics and automation background.

Experience

Data Analyst

MM Nissim and Co LLP, Noida · Aug 2024 – Present
  • Automated TDS, GST and audit processes using Python, Excel and IDEA/CaseWare — reduced manual effort by ~40%.
  • Designed & optimized 50+ SQL queries to power monthly financial exception reports — reduced turnaround by 35%.
  • Improved Python ETL scripts to cut processing time from ~10 mins to ~7 mins per dataset (~30% speedup).
  • Performed ITGC audits to strengthen internal controls and regulatory compliance.
  • Coordinated timelines & deliverables across audit and automation projects.

Data Analyst Intern

Excelinnova Consultancy Services · Apr 2024 – Jul 2024
  • Managed ETL pipelines handling 50,000+ records/day with 98% accuracy in transformations.
  • Built an AI-based language conversion model to support multilingual workflows — improved communications by 30%.
  • Supported project tracking for >6 projects ensuring timely reporting and cross-team alignment.

Junior Executive — Customer Success

Witzeal Technologies, Gurgaon · Sep 2022 – Aug 2023
  • Reduced average customer resolution time from 5 hours to 4 hours (~20%) by root cause analysis.
  • Partnered with product teams to improve usability — achieved +10% CSAT improvement.
  • Resolved 200+ customer queries/month with ~90% first-touch resolution.

Selected Projects

PhoenixAIScan

Pre-Execution AI Code Risk Scanner. Scans AI-generated code before execution, detects dangerous operations, highlights risky lines, and explains impact in plain English.

Python FastAPI Security AI Safety
GitHub Case Study

Change Request Workflow Automation

Automated change request approval workflow with email notifications, audit trails, and role-based approvals.

n8n Google Apps Script Automation
GitHub Case Study

AutoSync SFTP Automation Tool

Open source Python tool to sync remote SFTP folders, detect changes, create audit logs and send email notifications.

Python SFTP Audit
GitHub Case Study

Excel Batch Cleaner

Python utilities to clean, merge and standardise large Excel datasets to prepare for analytics and reporting pipelines.

Python Pandas ETL
GitHub

File Update Reporter

Automation that tracks file modifications and generates audit friendly change reports.

Python Monitoring
GitHub

Consumer Behavior in Spatial Shopping

Research project using Python & IBM SPSS to segment shoppers and recommend targeted campaigns.

Python SPSS Clustering

The Impact of Insomnia on Health

Regression analysis with R and Excel to study the correlation between insomnia and health outcomes.

R Regression

Education

🎓

MBA — Project Management (Online)

Manipal University Jaipur · 2024–2026
📊

PG Diploma — Data Analytics

Guru Gobind Singh Indraprastha University · 2023–2024
💻

BCA — Bachelor of Computer Applications

Maharaja Surajmal College, IPU · 2018–2022

Skills & Tools

Programming & Analysis

PythonSQLRpandasNumPy

Data & BI

Power BITableauExcelETL

Audit & Compliance

IDEAITGCControl RemediationUAM

Product & PM

Stakeholder MgmtAgileRoadmapsKPIs

Contact Me

If you're hiring for Project Management, Data Analyst or Product Analyst roles — let's talk.

Email
aayush2k@gmail.com
Phone
+91 99717 35999
LinkedIn
linkedin.com/in/aayush-pandey2/
GitHub
github.com/vielnos
Email Me Download CV
0%
Automation
Reduction
0+
SQL Queries
Optimized
0%
ETL
Accuracy