Sameer Mandaogade
Data Analytics Professional
Gurugram
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
5
5
years of professional experience
17
17
years of post-secondary education
3
3
Languages
Work History
Senior Data Analyst
Essex Lake Group LLC
11.2021 - Current
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.
Lead Associate
WNS Global Services Pvt ltd
06.2020 - 11.2021
- Being a part of digital transformation team, my roles revolves around developing BI tools for operations which helps them in time saving and better decision making
- Managed and communicated with stakeholders for gathering business requirements and objectives, designed various SQL scripts for data extraction, data cleaning, data manipulation in Power BI reports with multiple data sources
- Work closely with stakeholders across the business on projects with dashboard development or data analysis using Power BI Desktop
- Transformed conventional reports in excel to interactive automated dashboard in Power BI which results in cost cutting of 2.5 FTE's
- Lead a team of 3 members
- Tool and languages used: MS-EXCEL, Power BI, MSSQL, SAP, VBA
Analyst
Genpact India
02.2019 - 05.2020
- Being a part of FP&A team my KRA's revolved around Commercial decision support
- Worked on creating new models for better decision making through dynamic analysis of business performance and drivers of business performance
- Developed a RPA solution using MS Power BI (included development of relational data base model in Power BI and calculation of DAX measures) that automated 25-30 excel reports altogether in one single module
- Productivity saving of ~1000-1200 hrs
- Annually
- Worked on helping on shore client in automation to increase productivity
- Automation includes coding in VBA and using advanced excel techniques to create automated templates showcasing information in organized manner which helps in decision making
- Worked on development of POC on Microsoft Power BI and Excel
- POC's were used to make new and existing clients aware about Genpact's transformation capabilities
- Worked mutually with digital transformation team within Genpact and helped them in transforming old traditional dashboards in new visually appealing dashboards using advanced excel techniques and MS Power BI tool
Education
Bachelor of Technology, First Class Distinction - Electronics Engineering
VJTI Mumbai
Mumbai 04.2001 - 04.2018
12th - Science Stream
M.P Deo Dharampeth Science College
10th - undefined
South Point School
Skills
- MS Power BI
- Tableau
- SQL
- SAS
- MS Excel
- VBA
- Python
Personal Information
Date of Birth: 04/08/96
Timeline
Senior Data Analyst
Essex Lake Group LLC
11.2021 - Current
Lead Associate
WNS Global Services Pvt ltd
06.2020 - 11.2021
Analyst
Genpact India
02.2019 - 05.2020
Bachelor of Technology, First Class Distinction - Electronics Engineering
VJTI Mumbai
04.2001 - 04.2018
12th - Science Stream
M.P Deo Dharampeth Science College
10th - undefined
South Point School
Similar Profiles
VEMULAPALLI JAGADEEPVEMULAPALLI JAGADEEP
Solution Intelligence Analyst | at Essex Lake GroupSolution Intelligence Analyst | at Essex Lake Group
MAHESH BUDDEMAHESH BUDDE
Solution Intelligence Analyst at Essex Lake GroupSolution Intelligence Analyst at Essex Lake Group
Alex BorstAlex Borst
Restaurant Consultant at Round Lake Group LLCRestaurant Consultant at Round Lake Group LLC