WORK EXPERIENCE:

TEAM LEAD – Capgemini India PVT LTD, Bangalore Feb 2019 – till now

Designed and implemented advanced Power BI dashboards and automated data analysis processes using VBA, Python, and web scraping, reducing processing time by 50% and boosting operational efficiency by 90%.

Collaborated with IT, data engineers, and Azure teams to transform large datasets, develop KPIs, and ensure accurate reporting through SQL, Power Query, and integration with databases like SQL Server and Azure Synapse.

Delivered data-driven solutions by leveraging Advanced DAX, SQL, and Tableau for executive decision-making, while streamlining manual reporting processes and excelling in stakeholder communication and cross-functional collaboration.

SR MIS ANALYST – AltiSource PVT LTD, Bangalore Mar 2017 – Feb 2019

As an MIS Analyst, my primary roles include preparing comprehensive dashboards and reports by Leveraging Advanced Excel formulas, VBA, and SQL queries to extract and analyze data from various databases.

I automated reporting processes to enhance efficiency and accuracy, ensuring the timely delivery of critical business insights. Additionally, I collaborated with stakeholders to understand their requirements and translated them into actionable data visualizations and automated solutions.

SR MIS ANALYST - HGS PVT LTD, Bangalore Jan 2016 - Feb 2017

As an MIS Analyst, I worked for a Flipkart client, managing many reports related to sales, customers, revenue, and the catalog team.

Extensively used VBA to automate the reports and share the reports with higher management.

PROJECTS:

Business 360 - Brick & mortar and e-commerce POWER BI PROJECT

Designed a multi-view dashboard Dashboard Link in Power BI for 6 departments (sales, finance, supply chain, executive, marketing, and products) of AtliQ hardware to understand sales trends and facilitate data-driven decisions, which aimed to scale the business processes by 10%.

Imported 2 different data sources (MySQL, and Excel) with more than 1 million records and performed data modeling.

Optimized the report using DAX studio, which saved 30% of storage and improved performance by 10%

MYSQL PROJECT

I have worked on Data Cleaning and Exploratory Data Analysis projects focused on household income, statistics, and global life expectancy. Leveraging advanced MySQL queries, including joins, aggregations, groupings, and subqueries across multiple tables, I derived meaningful insights and created comprehensive dashboards in Power BI to visualize the data.

VBA PROJECT

Developed a VBA solution to remove duplicates by comparing two Excel files, significantly reducing manual efforts, and enhancing productivity for the operations team. This project improved efficiency by cutting the processing time from 2 hours to just 10 minutes.

Implemented Macros to reduce the manual work in the reports and automated the daily reports with VBA code which improved accuracy and efficiency and reduced the manual errors.

PYTHON PROJECT

Data Cleaning and Preparation: Utilized pandas functions to clean and preprocess data, including handling missing values, removing duplicates, and addressing outliers. Applied group by, merge, join, and concat operations to aggregate, consolidate, and integrate datasets for comprehensive analysis.

Exploratory Data Analysis (EDA): Conducted EDA to uncover patterns and relationships through statistical summaries and visualizations, preparing the data for effective use in Power BI projects, by using Python Beautiful Soup, and scrappy modules to scrap data from a website. Analyzed the data so that it could be readily used by the operations team for further insights and analysis.