Profile

Professional Experience

Business/Finance Data Analyst

May 2019 – July 2019

Pactiv Corporation, USA

Summary:

Pactiv is the world’s largest manufacturer and distributor of food packaging and foodservice products, supplying packers, processors, supermarkets, restaurants, institutions and foodservice outlets across North America. Headquartered in Lake Forest, Illinois, its digitalization team is focused toward providing visualizations to the leadership for it continuous success and improvement.

  • Developed and published dashboards on tableau server for visualizing Tier Room KPIs such as CaseFill, Schedule compliance and 15 others for 40+ different manufacturing plants at Pactiv across North America.
  • Blended data from HANA, SQL and Oracle data sources to streamline the ETL process, reducing load on tableau servers by 25%.
  • Created a robotic process for automating the invoice and BOL generation process for auditing using RPA, reducing process time by 40-45%.
  • Provided operational insight by working cross-functionally with the operations and supply chain teams for extracting data using HANA and SQL.

Graduate Assistant at the College of Business

April 2018 – April 2019

University of Illinois at Chicago, USA

Summary:

Located in the heart of one of the world’s great cities, the University of Illinois at Chicago is a vital part of the educational, technological and cultural fabric of the region. As Chicago’s only public research university with more than 31,000 students, 16 colleges, a hospital and a health sciences system, UIC provides students access to excellence and opportunity.

  • Worked with the College of Business Administration as a front end developed for enhancing and adding modules to its website businessconnect.uic.edu.
  • Maintained and enhanced syllabus website used by professors and students using Python and Django framework -hosted on IIS.
  • Maintained users accounts, controls access, and account securities on Active Directory for the College of Business.
  • Automated the process of offer letter generation for the human resource department at UIC using Sharepoint, Designer and InfoPath.

Programmer Analyst

January 2016 - December 2017

Cognizant Technology Solutions

Summary:

Cognizant is an American multinational corporation that provides IT services, including digital, technology, consulting, and operations services. It is headquartered in Teaneck, New Jersey, United States.

  • Designed individual client schemas and developed healthcare modules for Clients such as Ford, Michelin and Verizon for managing DB, DC and HW data for its employees. Estimated task in story and then tracked those tasks using hours in JIRA.
  • Devised Rapid M solution to automate data management process for each enrollment period, reducing manual processes by 20%.
  • Integrated Google Analytics on existing modules, reducing time to market individual client portals.
  • Developed workflows using SharePoint InfoPath for early completion and notification of QA and PROD fixes, reducing time delays by 7-8 %.

Business Analyst Intern

June 2014 – August 2014

Genpact Headstrong Capital Markets, India

Summary:

Genpact Headstrong Capital Markets is a global consulting and IT services company with a specialized focus in capital markets. With more than 20 years of experience consulting with 9 of the world’s top 10 investment banks.

  • Involved in the documentation, prototyping, testing and optimization of Caremark invoice application system.
  • Implemented automated prototypes for record management using agile methodologies which increased automation by approximately 10%.
  • Designed visualization to display revenue reports and product purchases for CVS pharmacies.
  • Formulated and optimized reports for invoices and provided detailed analysis of its household products.
Created by Harsh Misra®