Aayush Pandey — Portfolio

Hi, I’m Aayush Pandey

Project-focused Analyst building automation and analytics solutions that improve processes, ensure compliance and deliver measurable business value. I blend Python automation, SQL, audit experience (ITGC) and stakeholder coordination to deliver projects on time. Currently pursuing an MBA in Project Management.

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

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. I thrive at the intersection of project delivery, analytics and product facing problem solving translating ambiguous problems into clear deliverables with measurable outcomes.

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, Business Alignment

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, improving milestone adherence.

Data Analyst Intern

Excelinnova Consultancy Services Pvt Ltd — 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 Private Limited, Gurgaon — Sep 2022 – Aug 2023

Reduced average customer resolution time from 5 hours to 4 hours (~20%) by root cause analysis and process changes.
Partnered with product teams to improve usability achieved +10% CSAT improvement.
Resolved 200+ customer queries/month with ~90% first-touch resolution, aiding 12% retention improvement.

Selected Projects

Change Request Workflow Automation

Automated change request approval workflow with email notifications, audit trails, and role-based approvals. Designed to improve governance, traceability, and turnaround time in IT operations.

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. Designed for repeatable, auditable file movement in compliance environments.

GitHub
Case Study

Excel Batch Cleaner

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

GitHub

File Update Reporter

Automation that tracks file modifications and generates audit friendly change reports integrates with version control and storage systems.

GitHub

Consumer Behavior in Spatial Shopping

Research project using Python & IBM SPSS to segment shoppers (online vs offline) and recommend targeted campaigns based on cluster analysis.

The Impact of Insomnia on Health

Regression analysis with R and Excel to study the correlation between insomnia and health outcomes; presented actionable findings.

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

Python, SQL, R, pandas, NumPy, Matplotlib

Data & BI

Power BI, Tableau, Excel (advanced), ETL pipelines

Audit & Compliance

IDEA, UAM testing, ITGC testing, Control remediation

Product & PM

Stakeholder management, requirement gathering, roadmap coordination, metrics & experimentation

Contact Me

If you’re hiring for Project Management, Data Analyst or Product Analyst roles - let’s talk. I focus on delivering automated solutions, clean data pipelines and on-time project delivery.