NITISH KARNATAKAM
Bengaluru,India
Summary
A focused Senior Data Analyst with 8+ years of experience in business reporting & data Analysis including data gathering, creating
insightful analytical solutions to help business understand complex problems. Automate & Streamline tedious processes as applicable.
Overview
8
8
years of professional experience
1
1
Certification
Work history
Senior Reporting & Business Insights Specialist
Merck Group
Bengaluru
2022.06 - Current
- Reengineered the reporting landscape and complex data models using python which has reduced the processing and updation time from 150 hours to 18 hours per month on KPI's on Forecasting, Actuals & budget allocated in IT department across R&D function
- Managing a team 4 members on reporting and generating insights out of powerbi and Tableau dashboard.Based on the dashboard , the project leads are optimizing their projects forecasted against the actuals where the chances of overforecasting is optimized now
Associate Manager/ Data Insights and Analytics
Novartis
Hyderabad
2018.09 - 2022.06
- Digitalization of Sales and Business Planning Process -2022 at Novartis -Led the digitalization of Sales and Business Planning Process from OLAP based reporting to qliksense visualization by collaborating with APAC and European teams
- Star of the Quarter in Automation of existing process – 2021 at Novartis - saved 150 hours of manual work annually by developing an Alteryx-based solution to streamline data flow coming from multiple systems - SAP and SharePoint
- Designed an engaging qliksense mrom( maintenance, repair and operations) dashboard to report the cost of the spareparts being utilized at different inventories globally which has cut the costs by 10% for organization and procurement team
Analytics advisory analyst
Accenture
Bangalore, India
2017.09 - 2018.07
- Designed an headcount dashboard in qliksense for different department which helped the attrition and recruitment activities for HR
- Quality & Risk Management; tracking team metrics and make sure to achieve more than 99% throughout the year
Created templates using Tableau and Power BI for business pitch during client visit (Retail, Telecom) - Driving different team initiatives like efficiency identifying the efficiency creation opportunities, developing of POC to present to Accenture leadership team and clients etc.
Senior Associate/Reporting Specialist
Genpact
Bengaluru
2015.07 - 2017.09
- Worked with CPG retail clients like Walmart, Pepsi, Mars, and Mondelez, through the IRI research firm
- Automated excel reports using VBA which has reduced time of almost 100 hours per month which has improved the delivery rate for the clients
- Identified room for process improvements and automation to increase operational accuracy and efficiency.
- Trained the management on advanced excel and macros and led a team of 10 people in developing the dashboards and deliver to clients with 100% quality and accuracy with in timelines - weekly & monthly reports
Education
MBA - Marketing & Systems
2013
B-Tech - Computer Science
2011
Skills
- Advanced Excel & VBA
- Alteryx
- Tableau
- Power BI
- SAP ERP
- SharePoint
- Python
- Financial Reporting
- Supply Chain Operations
- Retailing operations
- Business Intelligence Analysis
- S&BP process
- Forecasting and Actuals Reporting
- Forecast Accuracy
Certification
Tableau Desktop Certified Professional Certification - Edureka T9N7QFUE (Apr 2022- Ongoing) Alteryx Foundational Micro-Credential - Alteryx (Issued Aug 2022 - Expired Aug 2024)
Languages
English
Fluent
Timeline
Senior Reporting & Business Insights Specialist - Merck Group
2022.06 - Current
Associate Manager/ Data Insights and Analytics - Novartis
2018.09 - 2022.06
Analytics advisory analyst - Accenture
2017.09 - 2018.07
Senior Associate/Reporting Specialist - Genpact
2015.07 - 2017.09
Dayananda Sagar College of Management & Information Technology - MBA, Marketing & Systems
G. Pulla Reddy Engineering College - B-Tech, Computer Science