Prabhakaran Kesavan
Coimbatore
Summary
Highly skilled Senior Data Analyst with extensive experience in transforming complex datasets into actionable insights, optimizing data processes, and enhancing decision-making capabilities. Proficient in dashboard visualization, Advanced Excel, data modeling, and advanced analytics and process automation. Demonstrated expertise in project management, business intelligence, and ETL processes. Adept at collaborating with cross-functional teams to drive organizational efficiency and continuous improvement. Committed to leveraging data to foster professional growth and support strategic objectives.
Overview
19
19
years of professional experience
1
1
Certificate
Work History
Senior Data Analyst
RPM Global Business Capability Center Private Ltd
03.2023 - Current
- End-to-End Dashboard Development: Developed and implemented comprehensive KPI dashboards in Power BI for different entities within RPM International, integrating user feedback to deliver actionable insights for Accounts Payable and Receivable, improving operational efficiency and providing actionable insights for strategic decision-making.
- Data Modeling and DAX Calculations: Created complex data models in Power BI, optimizing relationships between multiple tables to ensure efficient data retrieval. Utilized DAX (Data Analysis Expressions) to implement calculated measures and columns for advanced analytics.
- Interactive Reports and Drill-Down Analysis: Developed highly interactive reports with drill-down capabilities, allowing users to explore data at various levels (e.g., by geography, time period, or product category), empowering business leaders with deeper insights.
- Custom Visualizations and Themes: Created custom visualizations (e.g., waterfall charts, funnel charts) to meet specific business needs and tailored report themes to align with corporate branding, ensuring a visually appealing and consistent user experience.
- Row-Level Security (RLS) : Implemented Row-Level Security to restrict data access within Power BI, ensuring users only see data relevant to their role or department, enhancing both security and user experience.
- Power BI Service and Data Refresh: Published reports and dashboards to Power BI Service, scheduled automated data refreshes, and shared reports with stakeholders via Power BI apps to ensure timely and seamless access to the latest insights.
- Performance Optimization: Optimized Power BI reports for performance by managing data load, reducing model size, and improving query execution times, ensuring faster and smoother user interaction with large datasets.
- Collaborative Power BI Workspace Management: Managed collaborative workspaces in Power BI, ensuring teams had appropriate access to reports and dashboards. Facilitated report sharing and collaboration across departments while maintaining control over sensitive data.
- Custom Report Slicing and Filtering: Implemented custom slicers, filters, and bookmarks to enable users to create personalized views of the data, making reports more dynamic and customizable for diverse business needs.
- Power BI Training and Documentation: Trained business users and junior analysts in Power BI best practices, empowering them to generate their own reports and analyze data independently. Developed user guides and documentation to ensure proper usage and report maintenance.
Sr. Business Data Analyst - MI & Reporting, A&I
Tata Consultancy Services
10.2009 - 03.2023
- Worked on 400+ reports for multiple stakeholders, delivering actionable insights and supporting strategic objectives.
- Developed interactive Excel dashboards using advanced features such as pivot tables, slicers, and conditional formatting to present real-time financial and operational data for senior leadership, enabling quick decision-making and performance tracking.
- Designed custom dashboards and MIS reports for senior leadership, providing critical business insights and KPI tracking.
- Collaborated with clients to understand business needs, translating them into Excel-based solutions to enhance data reporting.
- Developed Excel VBA automation, reducing report generation time from 10 minutes to less than 1 minute, saving over 60 hours annually.
- Created Ad-hoc reports to support various departments within corporate lending, based on the client requirements ensuring fast and accurate insights for decision-making.
- Improved data quality by implementing validation procedures, reducing reporting errors.
- Trained junior analysts on best practices in data analytics, fostering continuous learning and growth within the team.
Process Associate
Fidelity Investments Business Services (Pvt)
05.2005 - 06.2006
- Responsible for carefully scrutinizing and processing e-checks with reference to other documents attached to check and crediting amount to their respective loan or PF (401 K) account and rejecting inappropriate ones.
- To perform in team and ensure apt processing of work items accurately and at right time to ensure highest customer satisfaction.
- Collaborated with team members for enhanced process efficiency and productivity.
- Managed multiple tasks simultaneously, ensuring timely completion of all assignments.
- Communicated effectively with colleagues and supervisors to resolve issues promptly and accurately.
Education
MBA - Finance & Marketing
ICFAI Bangalore
Bengaluru, India04.2009
Bachelor of Arts - Finance And Computing
Sri Krishna College of Arts & Science
Coimbatore04.2005
Skills
- Power BI, DAX, Power Query
- SQL
- Python (Pandas, Matplotlib, Seaborn)
- Data and Analytics
- Advanced Excel, VBA
- Project Management
- Requirements Elicitation
- Needs assessments
- Process Improvement
- Data Modeling
- ETL processes
- Business Intelligence
Certification
- Project Management Professional (PMP), Project Management Institute - June 2019
- IIT Palakkad Applied Data Science Certification, Indian Institute of Technology, Palakkad - February 2023
- Teradata SQL for Data Warehouses, Teradata - April 2015
- Intermediate Python, DataCamp - April 2022
Languages
English
Advanced (C1)
Hindi
Advanced (C1)
Tamil
Intermediate (B1)
Telugu
Intermediate (B1)
Timeline
Senior Data Analyst
RPM Global Business Capability Center Private Ltd
03.2023 - Current
Sr. Business Data Analyst - MI & Reporting, A&I
Tata Consultancy Services
10.2009 - 03.2023
Process Associate
Fidelity Investments Business Services (Pvt)
05.2005 - 06.2006
MBA - Finance & Marketing
ICFAI Bangalore
Bachelor of Arts - Finance And Computing
Sri Krishna College of Arts & Science
- Project Management Professional (PMP), Project Management Institute - June 2019
- IIT Palakkad Applied Data Science Certification, Indian Institute of Technology, Palakkad - February 2023
- Teradata SQL for Data Warehouses, Teradata - April 2015
- Intermediate Python, DataCamp - April 2022
Similar Profiles
DHRUV RAJVANSHIDHRUV RAJVANSHI
Trust & Safety Specialist at AIRBNB GLOBAL CAPABILITY CENTER PRIVATE LIMITEDTrust & Safety Specialist at AIRBNB GLOBAL CAPABILITY CENTER PRIVATE LIMITED
Rajesh ARUMUGHAMRajesh ARUMUGHAM
Divisional Manager at Daimler India Commercial Vehicles Private Limited, Global Capability CenterDivisional Manager at Daimler India Commercial Vehicles Private Limited, Global Capability Center
Vikas TanejaVikas Taneja
SME at Airbnb Global Capability CenterSME at Airbnb Global Capability Center