Aashay Dubey Mobile: 9870898804, Email: aashay.dubey.iitkgp@gmail.

com
3+ years in Data & Business Analytics | Linkedin: https://www.linkedin.com/in/aashay-dubey/
4.5+ years in IT & Management Consulting Address: Tardeo Road, Mumbai -7

Summary
Aashay has overall 4.5+ years of experience and is business/data analytics professional. He has led & delivered Customer & Commercial
analytics, Data Quality & Governance projects in Technology, Data/Digital domain across healthcare, finance, life sciences and banking industries

WORK EXPERIENCE
■ ZS Associates: Associate Consultant [Management Consulting(Domain - Healthcare)] [May’22-Present]
● Designed dashboards through creation of data visualization of key financial metrics providing insights, improving business processes.
● Delivered operational excellence through effective data management & salesforce optimization strategies leading to sales growth of 15%

Project: Implementation of Self-Service Portal - a Tableau dashboard for customers & accounts (Providers)
○ Conducted in-depth data discovery for GPO business using SQL/Snowflake to identify business logic of key metrics & potential process gaps
○ Led a team of 8+ associates to build a Tableau dashboard comprising of complex calculations, LODs, parameters, row level security (RLS) &
interactive visualizations for reporting of financial metrics; Enabled Providers to access financial information with uptime of 99%
○ Conceptualized UI design for 5 customer user personas by conducting stakeholder interviews for KPI prioritization; Designed wireframes &
Figma mockups incorporating 15+ metrics across multiple views which was translated into the Tableau dashboard.
○ Collaborated with cross-functional business & technical stakeholders across multiple teams and geographies to understand current SAP
Supply Chain; Identified data challenges and suggested possible improvements boosting adoption rate of portal/dashboard by 25%
○ Responsible for business development through writing Request for Proposal(RFP), Business Requirement Documents (BRD), Requirement
Specification Document (RS), user stories, business rules & acceptance criteria in Jira across 10+ EPICS
○ Developed data governance strategy through identifying process bottlenecks and associated rules improving data flows, relationships,
lineage & mappings enabling effective data ingestion across various platforms; Designed current and future state process flow diagrams.
Project: Implementation of Performance Summary and BU Level Summary Reports – a Power BI dashboard for ZS & Client Leadership
○ Built reports & visualizations using SQL, DAX, Power BI & Power Query providing strategic insights to create effective salesforce strategies.
○ Collaborated with business users to understand functional and data requirements and translate them into insightful Power BI dashboards.
○ Developed data models and complex visualizations through effective Extract – transform – load (ETL) operations from various data sources.
○ Partnered with the ZS & client leadership to Perform ad-hoc analysis and generated insights based on the sales patterns & trends.
○ Visualized sales & financial trends for various products to provide summary of sales figures & salesforce metrics facilitating business
leaders to diagnose issues & risks helping decision-making; Delivered a profit margin improvement of 15% in subsequent quarter.
Project: Consultant for a healthcare manufacturer; design, execution & delivery of Incentive Compensation(IC) programs
○ Enabled a US Fortune 500 healthcare firm in their operations and compensation design for 2000+ field reps managing annual pay-outs of
USD 20+ million; Derived analytical insights from IQVIA datasets to optimize sales targets & improve salesforce effectiveness.
○ Led a targeting, segmentation, goal setting & payout initiatives through contests & plan change recommendations that scoped the most
valuable accounts in the Cardiology market segment or therapeutic area, increasing sales by 4% within a quarter.
○ Conducted Exploratory data analysis of large data sets using Python to understand data and identify patterns, trends, and outliers.

■ Infosys: Senior Systems Engineer (Commercial Banking & IT Operations) [Jul’16-Jan’19]

● Project: Build automated solutions for manual processes – CASA, Finacle Core Banking(CBS) & Remittance system
○ Spearheaded the implementation of a Robotics Process Automation(RPA) solution for a banking client working as a techno-functional
consultant across cross-functional teams, improving automation rate to 50% & minimizing delivery time by 20%
○ Performed root cause analysis of critical bot architecture issues ; Automated 7 workflows using agile framework for SDLC.
○ Used web-scrapping techniques to extract & organize financial data in Python using Selenium & Django.
○ Developed & validated data quality rules of data models in financial logic to enable decisions across risk, fraud & operations.
○ Understood loan disbursal process i.e., application & credit profile screening, compliance, and post disbursal services to create a roadmap
through building proof of concepts (POC) for automation solution for transformation of loan management.

EDUCATIONAL QUALIFICATIONS:

Course/Examination Institution/University CGPA/% Year

MBA IIT Kharagpur, Vinod Gupta School of Management 8.13 2022

Bachelor of Engineering (B.E. EXTC) DJ Sanghvi College, Mumbai University 8.77 2016

CERTIFICATIONS and SKILLS

■ Proficient in data visualization and analytics tools - SQL, Tableau, Excel, Python, Power BI, Advanced Excel, MS Office – PowerPoint, Word
■ Proficient in project/product management & automation tools - JIRA, Figma, Wireframes, Java, Selenium, Automation Anywhere
■ Experience in Requirements Gathering & Business Analysis, Stakeholder Management, Project Management & Digital Transformation
■ Experience with handling large datasets – Sales, Financial & Lifesciences IQVIA Sales/Provider datasets
■ Certified in RPA Business Analyst Foundation course by UiPath on Digital Process Transformation.
■ Certified in Machine Learning & Data Science by Udemy; trained on statistical techniques & algorithms.