Kumaran RSV
Bangalore
Summary
Strategic professional in business operations known for high productivity and efficiency in task completion. Specialize in process optimization, project management, and data analysis, ensuring streamlined workflows and enhanced operational efficacy. Excel in communication, problem-solving, and leadership, leveraging these soft skills to drive team success and achieve organizational goals.
Overview
14
14
years of professional experience
Work History
Business Intelligence Administrator / Developer
Sagent Pharma Services (India) Private Limited
Hyderabad
02.2024 - Current
- IQVIA/IMS EDW Data Processing: Perform monthly ingestion and processing of IQVIA/IMS data, identifying and updating new NDCs in the Enterprise Data Warehouse (EDW). Coordinate with stakeholders for validation and execute Talend ETL workflows to integrate new data.
- Competitive Pricing Analytics: Analyze weekly competitive pricing data by matching market trends, validating price submissions, and ensuring accurate reporting for sales representatives.
- EPCIS Tracker Dashboard Management: Oversee and update the EPCIS Tracker Dashboard, providing visibility into newly submitted and processed products and representatives on a monthly basis.
- ABaC Stats Dashboard Monitoring (EDW_PRD): Conduct daily monitoring of ETL data flow within the EDW_PRD environment using Talend. Troubleshoot and resolve data pipeline issues to ensure seamless processing of requests.
- Finance Inventory Month-End Snapshots (EDW_PRD): Execute month-end financial inventory snapshots, reviewing data integrity and ensuring accurate reporting in the EDW_PRD system.
- TIC Production Email Workflow Troubleshooting: Diagnose and resolve issues within the TIC Prod email workflow, ensuring smooth data processing and pipeline continuity.
- Demantra Supply Plan Remapping: Assist in restructuring the supply planning pipeline within Demantra, optimizing workflows, and enhancing process efficiency.
Analytics Consultant
Wells Fargo
Bangalore
01.2023 - 02.2024
- BI Dashboard Development and Support: Assist the Financial Delivery unit in developing, maintaining, and optimizing Tableau and Power BI dashboards to support financial technology initiatives.
- Project Management & Analytics: Lead and contribute to key projects such as Glidepath, Location Strategy, Golden Copy, Weekly Loans & Deposits, developing interactive dashboards in Power BI, Tableau Desktop, and Tableau Server for data visualization and reporting.
- Advanced Data Visualization: Design and implement heat maps, waterfall charts, bar charts, column charts, and geographic maps to enhance financial reporting and insights.
- KPI Metrics & Time Intelligence: Develop and implement key financial metrics, including MTD, QTD, and YTD reports, leveraging time intelligence functions in Power BI and Tableau.
- Cross-Functional Collaboration: Work closely with Project Managers, business stakeholders, and offshore teams to gather data requirements, optimize reporting workflows, and enhance collaboration for improved efficiency.
- Data Quality & Issue Resolution: Investigate and implement solutions for data quality issues, ensuring the accuracy and reliability of financial reports and dashboards.
- Agile Project Management: Utilize Agile methodologies (Kanban, Jira) to track progress, manage tasks, and drive continuous improvements in BI development and reporting processes.
Business Intelligence Developer
Strat sol Software Systems Pvt. Ltd
Bangalore
06.2022 - 03.2023
- Performed complex SQL queries for creating reports using SSRS, Tableau, Power BI, MicroStrategy.
- Prioritized and organized tasks to efficiently accomplish service goals.
- Engaged with business users to gather, define and document reporting requirements.
- Optimized data gathering processes, analysis procedures, and visualization strategies.
Senior Consultant in Data Engineering and BI
Bristlecone India Pvt limited
Bangalore
07.2021 - 06.2022
- Worked closely with stakeholders to identify business issues.
- Managed multiple client engagements simultaneously while adhering to tight deadlines.
- Developed and maintained databases for tracking projects, clients, and financial records.
- Collaborated closely with project managers, designers, and other developers in order to complete tasks efficiently and effectively.
Senior Reporting Analyst
Exxon Mobil
Bangalore
01.2017 - 07.2021
- Worked with cross-functional teams to achieve goals.
- Monitored KPIs to identify inefficiencies and risks.
- Streamlined reporting processes by evaluating data sources, compiling data and redesigning output.
- Implemented unique methods and methodologies, which helped reduce, and resolve issues.
Senior Executive
Infinite Computer Solutions India Pvt Limited
Bangalore
02.2016 - 12.2016
Sales Analyst
Akamai Technologies India Pvt. Ltd
Bangalore
07.2014 - 06.2015
Order Management Analyst
Oracle India Pvt. Ltd.
Bangalore
03.2011 - 06.2014
Education
Banking And Finance
Sisa High School
Bangalore03-2008
Skills
Technical Skills:
- Tableau Desktop, Server
- Tableau Administrator
- Power BI Desktop, Server, DAX, Power Query, and Paginated Reports
- SQL
- ServiceNow (ITOM, ITSM)
- ETL Tools: Talend ETL Tool, Alteryx (Basics)
Soft skills:
- Analytical thinking
- Creativity
- Communication Skills
- Adaptability
- Teamwork
Timeline
Business Intelligence Administrator / Developer
Sagent Pharma Services (India) Private Limited
02.2024 - Current
Analytics Consultant
Wells Fargo
01.2023 - 02.2024
Business Intelligence Developer
Strat sol Software Systems Pvt. Ltd
06.2022 - 03.2023
Senior Consultant in Data Engineering and BI
Bristlecone India Pvt limited
07.2021 - 06.2022
Senior Reporting Analyst
Exxon Mobil
01.2017 - 07.2021
Senior Executive
Infinite Computer Solutions India Pvt Limited
02.2016 - 12.2016
Sales Analyst
Akamai Technologies India Pvt. Ltd
07.2014 - 06.2015
Order Management Analyst
Oracle India Pvt. Ltd.
03.2011 - 06.2014
Banking And Finance
Sisa High School
Similar Profiles
Pranav ParekhPranav Parekh
Manager - IT Projects & Facilities at Advanz Pharma Services (India) Private LimitedManager - IT Projects & Facilities at Advanz Pharma Services (India) Private Limited
Saurabh Kumar SinghSaurabh Kumar Singh
Sr. Solution Specialist at Noventiq Services India Private Limited(Former Softline Services India Private Limited)Sr. Solution Specialist at Noventiq Services India Private Limited(Former Softline Services India Private Limited)
Pallavi Siddhesh SawantPallavi Siddhesh Sawant
Manager – Global Regulatory Affairs at FinOrion Pharma India Private Limited (Subs. of Orion Corporation)Manager – Global Regulatory Affairs at FinOrion Pharma India Private Limited (Subs. of Orion Corporation)