Aishwarya Agarwal
Mumbai
Summary
IT professional with 7+ years of experience, including 3.5 years specializing in Data Analysis. Proficient in Python, SQL, Excel, Tableau and Power BI. I excel at extracting meaningful insights from complex datasets and translating them into compelling visualizations. Committed to supporting informed decision-making and contributing to strategic initiatives within organizations. Passionate about leveraging data to drive operational efficiency and enhance overall performance.
Overview
7
7
years of professional experience
Work History
Assistant Manager
Genpact
Remote
01.2022 - Current
- Working for General Electric, I developed and owned reporting for the GE Renewables business using analytical tools like Excel and Power BI.
- Provided real-time visibility into collections trends, allowing for proactive adjustments to strategies.
- Developed and maintained Power BI reports to track and report KPIs, including applied/unapplied cash, past due accounts, and daily collection amounts.
- Streamlined and automated a key business report in Power BI, saving 15 hours of manual reporting each week.
- Daily discussions with the cash application team, collection team, ERP IT, and middleware IT teams
- While working for Newell Brands, I managed and resolved customer deductions using SAP, ensuring timely and accurate deductions clearing.
- Processed deductions related to pricing discrepancies, shortages, returns, and promotions in the SAP system.
- Collaborate with business analysts, data analysts, and end-users to understand data requirements, define key performance indicators (KPIs), and translate business needs into effective visualization solutions.
- Created basic Tableau reports that highlight trends and insights, contributing to strategic planning and performance tracking across departments.
- Assisted in the data preparation process by cleaning and transforming datasets to ensure accuracy and reliability before visualization in Tableau.
- Developed interactive dashboards in Tableau that effectively visualize key business metrics, facilitating data-driven decision-making for stakeholders.
Senior Software Engineer
Cybage Software
Pune
06.2017 - 01.2022
- Working for Client - Amadeus, who hosts various hotel web services, I designed and implemented scalable, high-performance software architectures using Python, Java, and SQL, supporting complex enterprise applications.
- Built robust, high-performance backend systems handling millions of transactions per day using Python and Java.
- Conducted code reviews to ensure adherence to best practices and coding standards, optimizing performance across applications.
- Designed efficient database schemas and optimized SQL queries, improving data retrieval times and overall application performance.
- Used SQL for data extraction and transformation tasks, ensuring high data quality.
- Optimized SQL queries, improving application performance by 25% and reducing database response times.
- Developed Java applications to parse, process, and transform XML and JSON data, ensuring data integrity and compliance with business rules.
- Cleaned and organized data sets using Excel, ensuring accuracy and readiness for analysis in Tableau.
- Assisted in the development of Tableau dashboards to visualize travel and hospitality metrics, such as occupancy rates and booking trends.
- Collaborated with team members to identify data sources and create visual reports that support business decision-making.
Education
Post Graduate Program - Data Science and Business Analytics
Great Lakes Executive Learning
India10.2021
Bachelor of Engineering (B.E) - Computer Science
Pune University
Pune, India07.2017
Skills
- Python
- SQL
- Tableau
- Excel
- Power BI
- ETL
- Data Cleaning
- Data Analysis
- Data Visualization
- Business Intelligence
- Business Analysis
- Financial Analysis
- Stakeholder Management
- Agile & Scrum Methodologies
Timeline
Assistant Manager
Genpact
01.2022 - Current
Senior Software Engineer
Cybage Software
06.2017 - 01.2022
Post Graduate Program - Data Science and Business Analytics
Great Lakes Executive Learning
Bachelor of Engineering (B.E) - Computer Science
Pune University
Similar Profiles
Zaki Uddin SyedZaki Uddin Syed
ITSM Consultant (IM,PM,CM) at GenpactITSM Consultant (IM,PM,CM) at Genpact
María Fernanda Granados ArroyoMaría Fernanda Granados Arroyo
Customs Process Developer at GenpactCustoms Process Developer at Genpact
S SrinivasS Srinivas
Senior Associate at GenpactSenior Associate at Genpact
Savi JangidSavi Jangid
Management Trainee at GenpactManagement Trainee at Genpact
Shikha NishadShikha Nishad
Director of Office Operations at Information Tech Consultants Ltd-Progriz COE Pvt LtdDirector of Office Operations at Information Tech Consultants Ltd-Progriz COE Pvt Ltd