Jagannath Prasad Jena
About Jagannath Prasad Jena
Jagannath Prasad Jena is an MIS Reporting Analyst at Procter & Gamble in Mumbai, Maharashtra, India, with expertise in Power BI tools, VBA Macros automation, and data management using SAP Business Warehouse.
Current Role at Procter & Gamble
Jagannath Prasad Jena has been working as an MIS Reporting Analyst at Procter & Gamble since 2016. His role is based in Mumbai, Maharashtra, India. In this capacity, he is responsible for preparing and presenting monthly and quarterly financial evaluation reports to senior financial leaders. He ensures data accuracy and integrity while providing variance analysis and interpreting trends between planned/forecasted and actual financial data.
Previous Experience at Birla Tyre India
From 2009 to 2014, Jagannath Prasad Jena worked at Birla Tyre India as Regional Sales Coordination in Mumbai, Maharashtra, India. During his tenure, he was involved in coordinating sales activities and ensuring seamless communication between the regional sales teams.
Background in Business Support at SMERA Ratings
Jagannath Prasad Jena served as Assistant Manager Business Support at SMERA Ratings Ltd from 2007 to 2008. Based in Mumbai, Maharashtra, India, his responsibilities included supporting business operations and ensuring the effective management of business processes.
Early Career at Reliance Industries Limited
From 2004 to 2007, Jagannath Prasad Jena worked as an MIS Executive at Reliance Industries Limited in Navi Mumbai, Maharashtra, India. In this role, he focused on data management and reporting tasks, involving extensive use of MIS systems to support business operations.
Education at Berhampur University
Jagannath Prasad Jena studied Arts at Berhampur University from 1996 to 1999, where he achieved a Bachelor's degree. This educational background laid the foundation for his career in data management and reporting.
Technical Expertise and Skills
Jagannath Prasad Jena possesses expertise in using Power BI tools such as Power Query, Power Pivot, Power View, and Power Map for data cleaning and visualization. He specializes in VBA Macros automation processes, including programming charts, pivots, and user-defined functions. Additionally, he has experience in creating complex queries, joins, views, and procedures using MS Access and SQL Server. Jagannath also utilizes SAP Business Warehouse's Materials Management and Sales and Distribution modules for data management.
Data Analysis and Reporting Skills
Jagannath Prasad Jena conducts retailing data analysis across various channels, including High Frequency Stores, Modern Retailing, and Emerging Channels. He performs reconciliation of annual business operation planning and high-level forecasting for specific verticals, providing vital insights and analysis to support business decisions.