Shivali Gupta

Project/Client – S&W Energy for ReNew Power

• Implemented business intelligence solutions to increase operational efficiency by 25%
• Developed end to end dashboard in Power BI in a team of 6 by identifying the KPIs based on business requirement (Material Consumption, Equipment Warranty Tracker & Inventory Tracker)
• Identified, analyzed and interpreted trends or patterns in complex data sets with thousands of records in Oracle and Excel, which were cleansed using Power Query & Data modelling in Power BI
• Designed DAX queries to create measures & calculated columns in Power BI as per user requirement. Also created KPIs, Line charts, Bar, Map visualizations. Delivered drill-through reports with top N analysis

Project/Client - Incentive Compensation for Johnson & Johnson

• Coordinated in a team of 20 people in Incentive Compensation program that included processing sales data for various MarketRx in life science area (Immunology & Virology)
• Assessed & extracted required data from raw sales feed & customer - address feed to analyze performance for 1000s of sales representatives at various levels (DRT) & produced final credited sales for individual rep and territory wise using advanced Excel spreadsheet functions, modifying VBA scripts and SQL
• Incorporated business rules for computing monthly, quarterly & annual compensation (time worked in their territory, profit gained and leaves taken) for reps as per their sales performance in their assigned regions and brands
• Generated eligibility reports and IC scorecard reports which value millions of dollars with 100% accuracy along with timely delivery
• Produced contest reports to calculate the top performers in each region & awarding them based on their performance

Project/Client - IRMA Campaign Testing for Novartis

• Lead team of 5 in Campaign Testing by performing manual regression testing on IRMA integrated platform where IRMA database acted as conduit between websites, 3rd party fulfillment vendors & CRM applications
• Translated functional requirements and specifications into end-to-end test plans & test cases for fulfillment services for Consumers(patients) for Campaign Marketing Management for around 20 therapeutic areas
• Produced consumer test data for over 100 test cases in many of the brand campaign testing, both in back & future dates using SOAP UI & SQL for multiple flows as per requirement document
• Validated fulfillment requests posted by epsilon team & acknowledgement requests shared by third party vendor after which the campaign brands went live. Reduced the overall testing time by 2 weeks

Project/Client - MSD-UK DICE for Merck

• Enhanced the pre designed models & added new business requirements in the Dynamic SQLs & existing Informatica mappings improving the performance by 35%
• Utilized SAP Power Designer for generating scripts and UDI Studio for generating DDLs, DMLs & TPAR files. Used Autosys to create scheduling jobs & JIRA board to maintain team progress
• Maintained code versions on Stash using SourceTree

Project/Client - Consumer Data Hub for Philips

• Gathered requirement & evaluated source and target systems, translated mapping documents into Informatica mappings to extract data from 3 different sources like flat files, Oracle tables and SFDC and populate them to Oracle tables. Developed tables, views & materialized views using SQL
• Identified & documented detailed business rules and use cases based on requirements
• Operated on different transformations like Aggregator, Filter, Router, Sequence Generator, Expression, Source Qualifier, Sorter, Rank, Union, Joiner, Lookup, Update Strategy etc
• Responded to and remedied critical issues to limit downtime.