Mayank Ratnam
Data Analyst
Bengaluru,KA
Summary
Data-driven professional with a strong analytical mindset and expertise in quantitative tools. Skilled in identifying patterns and trends in large datasets to drive business decisions. Seeking a growth-oriented role to leverage my skills while continuing professional development.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Sales Operations Analyst
Fiery
05.2023 - Current
- Built and optimized complex Power BI reports to deliver real-time insights for sales tracking.
- Created analytical reports to assess sales performance, comparing actual results against targets across regions.
- Identified top-performing products and representatives to support data-driven sales strategies.
- Developed custom DAX measures for advanced calculations, enhancing analysis of sales trends and financial metrics.
- Designed data models to ensure seamless integration of diverse data sources, improving consistency across reports.
- Implemented VBA macros to automate reporting processes, reducing manual work by 70% and increasing accuracy.
- Leveraged AI-assisted development to accelerate DAX, VBA, and Power BI model design, improving development speed and analytical accuracy.
- Automated distribution of emails using Power Automate significantly enhances efficiency in weekly and quarterly communications.
- Validated pricing data in SAP, ensuring accurate uploads for Order Management and preventing discrepancies.
Sales Operations Analyst
Micro Solution
08.2020 - 05.2023
- Developed detailed operational dashboards in MS Excel, Power BI, and cross-verified the results with SQL.
- I analyzed the demographic sales and kept track of the inventory requirements using MS SQL.
- Designed and built custom dashboards to present reports to the company management, using analytical tools like Power BI.
Management Trainee
Gravita India Limited
04.2019 - 05.2020
- Executed a project with a $700,000 budget and completed it on time.
- Worked using SAP SD ERP, on creating quotes, sales orders, order acknowledgments, invoices, customer and material master data, and vendors.
- Used analytical tools like SQL and Tableau for making presentations and sales analyses for the CEO.
Trainee Engineer
B.N Civitech Private Limited
12.2015 - 02.2017
- Understood project requirements and completed all duties assigned by the Supervisor.
- Worked in a manufacturing plant and successfully collaborated with team members to carry out tasks.
Education
PGDM - Operations and Marketing
Taxila Business School
Jaipur05-2019
B. Tech. - Mechanical Engineering
Sri Sukhmani Institute of Engineering And Technology
Chandigarh06-2015
Skills
- Power BI development
- Data visualization and dashboards
- Power Query and DAX calculations
- Advanced Excel and VBA automation
- Power Automate workflows
- Business and data analysis
- Sales performance analysis
- Operations management
Certification
SAP Global Certification - Sales & Distribution, ERP 6.0 EhP7
Languages
- English, full professional proficiency
- Hindi, native, or bilingual proficiency
Timeline
Sales Operations Analyst
Fiery
05.2023 - Current
Sales Operations Analyst
Micro Solution
08.2020 - 05.2023
Management Trainee
Gravita India Limited
04.2019 - 05.2020
Trainee Engineer
B.N Civitech Private Limited
12.2015 - 02.2017
PGDM - Operations and Marketing
Taxila Business School
B. Tech. - Mechanical Engineering
Sri Sukhmani Institute of Engineering And Technology