Sathish Kumar Ramanathan
Coimbatore
Summary
Experienced Senior Reporting Analyst with a strong focus on Business Intelligence and Analytics, adept at working with large datasets to develop insightful, actionable reports. Proficient in delivering impactful data visualizations, in-depth analysis, and comprehensive reporting to support strategic decision-making. Advanced expertise in Power BI, QlikView, and Power Query for dynamic report generation and data transformation. Skilled in extracting transactional data from SAP to conduct detailed pricing, savings, and financial performance analysis. Proven track record of delivering monthly KPI, spend, savings, and rebate reports for Europe, APAC, and global stakeholders. Hands-on experience with BEx Designer/Analyzer for building and managing complex queries in SAP BW. Developed automated email solutions using Power Apps to streamline communication and improve operational efficiency. Experienced in designing Power BI dashboards for channel sales, enabling real-time insights, and improved process transparency. Strong ability to conduct stock audits and effectively reconcile physical versus system inventory.
Overview
17
17
years of professional experience
Work History
Sr. Reporting Analyst
Avantor (VWR Lab Products Private Limited - Part of Avantor)
Coimbatore
09.2013 - Current
Roles and Responsibilities:
- Reported directly to the Global Customer Metrics Director in Belgium for the European and APAC regions.
- Prepared and analyzed profitability and revenue reports, providing actionable insights for business decision-making.
- Developed and managed complex queries in QlikView for comprehensive report generation.
- Created and maintained multiple queries using BEx Designer/Analyzer within Business Warehouse.
- Extracted pricing information from SAP transactions to analyze savings, margins, and financial performance.
- Managed and delivered monthly KPI reports for European, APAC, and global customers, focusing on spend, usage, and KPI performance metrics.
- Produced various ad-hoc reports, including Savings Analysis, Pricing Analysis, End-of-Condition Reports, and Profit & Loss statements.
- Additionally, I have taken the internal sales reporting.
Training and Documentation:
- Served as a Process Trainer for new team members, ensuring smooth onboarding and knowledge transfer.
- Maintained the team’s ISO documentation in preparation for audits, ensuring compliance with industry standards.
- Managed various team tracking systems, including Attendance, Leave Planner, Weekly and Monthly KPI Metrics, Productivity Allocation, and IS-related information.
Team Collaboration and Reporting:
- Acted as the Eclat SPOC (5S methodology) for process improvements and operational efficiency.
- Prepared monthly team review presentations (PPT) for internal meetings to assess progress and performance.
Quality Assurance:
- Utilized various methodologies to capture and address errors in reports, improving accuracy, and reducing discrepancies.
- Leveraged multiple inspection tools to monitor and maintain team quality scores.
- Implemented corrective actions to minimize errors and enhance overall report quality.
MIS EXECUTIVE
KUEHNE+NAGEL C/o MAHALAXMI CARGO SERVICES
Coimbatore
10.2011 - 09.2013
Client of Vodafone Cellular Ltd.
Sr. Asst. System Operations
SINDHU CARGO SERVICES LTD
Coimbatore
09.2008 - 09.2011
Client of VODAFONE ESSAR CELLULAR LTD
Education
MBA - International Business
School of distance Education, Bharathiar University
Coimbatore, India01.2014
BSC - Computer Science
T S A College
Coimbatore, India01.2008
Skills
- Microsoft Office Suite
- Data cleaning and transformation
- SAP expertise
- Data analysis and visualization
- Power BI and QlikView proficiency
- Power Query skills
- BEx Designer/Analyzer tool
- Warehouse management systems
Projects and Process Improvement:
- Regeneron Channel Sales Report in Power BI, created a fully interactive dashboard analyzing customer-facing sales performance across regions, enabling actionable sales insights, and decision-making
- Global EPP Dashboard in Power BI, built a global Environmentally Preferable Products dashboard to support sustainability initiatives, tracked EPP spend, and compliance across countries and suppliers
- Bulk Email Automation in Power Apps, developed an automated solution to dispatch multiple email reports, streamlining communication, and reducing manual workload across the reporting team
Personal Information
- Date of Birth: 08/14/1987
- Gender: Male
- Nationality: Indian
- Marital Status: Married
- Language Know: English, Tamil and Telugu
Proclamation
I hereby declare that the above-mentioned information is correct, and I bear the responsibility for the correctness of the above-mentioned
Coimbatore, Sathish Kumar Ramanathan
Timeline
Sr. Reporting Analyst
Avantor (VWR Lab Products Private Limited - Part of Avantor)
09.2013 - Current
MIS EXECUTIVE
KUEHNE+NAGEL C/o MAHALAXMI CARGO SERVICES
10.2011 - 09.2013
Sr. Asst. System Operations
SINDHU CARGO SERVICES LTD
09.2008 - 09.2011
MBA - International Business
School of distance Education, Bharathiar University
BSC - Computer Science
T S A College
Similar Profiles
Palash RajaniPalash Rajani
Assistant Manager - Accounting at Resonant Clinical Solutions Divested from VWR Lab Products Pvt Ltd(Part of Avantor)Assistant Manager - Accounting at Resonant Clinical Solutions Divested from VWR Lab Products Pvt Ltd(Part of Avantor)
Kirubhasini DevarajanKirubhasini Devarajan
ASSOCIATE – MARKET SOURCING at VWR PART OF AVANTORASSOCIATE – MARKET SOURCING at VWR PART OF AVANTOR
Dinsey StervinDinsey Stervin
Laboratory Production Operative at VWR International, part of AvantorLaboratory Production Operative at VWR International, part of Avantor
DHANASEKARAN RAJUDHANASEKARAN RAJU
IT Project Manager at DXC TechnologyIT Project Manager at DXC Technology
Kumar ThangavelKumar Thangavel
Technical Lead at AppViewXTechnical Lead at AppViewX