Akshay Bhatia

Experience

• 

  Square Yards

  Sept 2016 - Feb 2018

  Buisness development manager

  • Collaborated with stakeholders to gain acomprehensive understanding of the data andbusiness requirements.• Leveraged Google Analytics to analyse websitetraffic and developed a dashboard using Google DStudio to present findings on customer behaviorhelped improve user experience.Skills: Microsoft Excel Google Analytics GoogleData Studio MicrOsoft PowerPoint

• 

  Airtel

  Mar 2018 - Jun 2020

  Business Data Analyst

  • Generated weekly data insights using Excel pivottables and charts for external stakeholders.• Cross-referenced multiple data sources totransform and clean data using Excel and PowerQuery to populate the internal database on a weeklybasis.• Implemented a dashboard in Tableau for analysisand visualization of customer survey data.Skills: Microsoft Excel· Stakeholder ManagementTableau · Microsoft Power Query Microsoft OfficeCoordinate data collection with external partners and internally manage datasets.§ Proficiently use statistical programming software such as STATA, Python, SPSS, R, SAS (STATA preferred) to create statistical, regression, and econometric models. § Generate statistical models and advanced code for conducting student outcome analyses.§ Create, restructure, and manage large datasets, files, and systems.§ Conduct qualitative and quantitative research and use mixed-method approaches to data analysis.§ Write technical memos that document data processing decisions and summarize the quality of data.§ Analyze and synthesize research findings into key insights for stakeholders§ Create research papers and policy briefs.§ Assist in the design, implementation, and enforcement of data infrastructure,security and system policies.Desired Administrative Skills: § Ability to work in a team-oriented, fast-paced environment managing multiple priorities§ Project management and organizational skills§ Research, writing, and communication skills§ Ability to communicate results of complex analytic findings to both technical and non-technical audiencesExhibit strong analytic, technical, trouble-shooting, and problem-solving skills.§ Experience with Microsoft Office (especially Word, PowerPoint, Access, and Excel) Show less

• 

  TradeIndia.com - Infocom Network Private Limited

  May 2022 - now

  Senior Subject Matter Expert

  • Led data analysis and reporting for US mobile usagcampaigns as Single Point of Contact (SPOC).• Collaborated with cross-functional teams andexternal stakeholders to drive cost savings.•Generated planned and ad-hoc data analysisreports using advanced Excel and VBA.• Developed interactive dashboards for KPl trackingusing Power Bl and DAX.• Implemented data models and automated the ETLprocesses for Power BI dashboards.• Cleaned, transformed and analysed complex largedatasets using SQL and Python.• Automated the ETL process to populate the internadatabase using Python (Pandas).Key Achievements:• Achieved $19K monthly reduction in overspend byoptimising existing cost-saving strategy.•Saved 30 hours monthly by automating 10+ datacleaning and transformation tasks using Python.• Reduced 95% monthly data preparation time byautomating ETL process for populating internaldatabase.Skills: SQL· Microsoft Excel· Microsoft Power BIPython (Programming Language)· StakeholderManagenment VBA Excel· DAX· Microsoft PowerQuery- Statistical Data Analysis Extract, TransformLoad (ETL) · Data Modeling Key PerformanceIndicators Service-Level Agreements (SLA)·Microsoft Office Show less