Dweet
Dweet
Open to Permanent
Open to Permanent

Prabanchan Subramanian

Data Analyst with 6+ years of experience with dual Master's degree.
About

Business Intell igence & Data Analyst  A Data Enthusi ast with 6+ years of experience.  Open to full-time (CDI) opportunities in France.  Looking forward to deploying my analytical and problem-solving skills.

Previous Brands
Amaris Consulting
AVIV Group
AXA Partners
Cognizant
Work Experience
Data Analyst -Growth & Strategy Analytics
Feb ‘23 - Now
AVIV Group

• Responsible for the development and implementation of advanced analytics to help the AVIV Strategy & Transformation team to turn strategy into Objectives & Key Results (OKR). • Prepare, present and communicate impactful analysis results and recommendations to support strategic & transformation projects. • Support the Leadership team in decision-making for the AVIV'S overall strategy with insights gained from competitor analysis. • Develop impactful KPI dashboards in Tableau using data from Google Analytics, AWS Athena. • Involved and Contributed to the Monthly Steering Committee meeting to support and oversight KPI's evolution for France, Germany & Belgium. • Designed optimized SQL queries to increase the efficiency by 30% and cut costs by 20%.

BI Consultant
Feb ‘22 - Feb ‘23
Amaris Consulting

• Led a team of 3 Data Analysts and successfully delivered Data Quality BI projects in Power BI that involved Data Preparation, Cleaning, Transformation and Analysis activities. • Monitoring and Troubleshooting Data Refresh, Gateway issues of Power BI reports, datasets. • Performed Data exploration, Analysis in Google Big Query and created Data Quality dashboards using Google Data Studio. • Analyzed the root causes in SAP SuccessFactors modules for technical and process improvements. • Managed stakeholders and involved in improving the Data Quality and implementing Data Governance principles in an Agile environment.

HR Data Analyst (Internship)
Nov ‘20 - Apr ‘21
AXA Partners

• Part of the Global HR Analytics Team contributing to the Business Workforce Evolution & Strategic Workforce Planning (SWFP). • Responsible for creating monthly dynamic HR dashboards using Power BI with workforce metrics, KPI's and creating BI reports. • Managed 15 stakeholders for Validation of Data Collection, Data Quality, Data consistency, Data Evolution during the Social Data Reporting (SDR) campaign for META, ASIA & Northern EUROPE region and improved the Data Quality to 97%. • Developed SWFP Data model in Power BI to strategically plan the recruitment cycles across Regions, Departments and Business Units.

Programmer Analyst
Feb ‘15 - Aug ‘19
Cognizant

• Responsible for cleaning and transforming raw data into actionable insights and presenting it to the Leadership teams. • Created quarterly BI reports and dashboards using Tableau and analyzed sales data and trend patterns. • Hands-on experience working with complex SQL queries to extract required business data for ad-hoc analysis. • Collaborated with cross-functional teams to drive impactful business insights.

Languages
French - Work Proficiency
English - Fluent
Education & Training
EPITA: École d'Ingénieurs en
‘19 - ‘21
Master of Science in Business Analytics
Symbiosis International University
‘16 - ‘18
Master of Business
SASTRA University
‘10 - ‘14
Bachelor of Technology
Paris, France