Pratibha Dwivedi

• Developing data platform solutions for unsupported and legacy ERP (retail services) systems by migrating them into CRM Dynamics 365 CE and F&O systems, building ENT DWH in Azure Synapse Analytics and delivering analytical/operational reporting solutions via Power BI.
• Conducting requirement gathering sessions with business and capturing it as DevOps PBIs for Retail services reporting solutions like Install Job Cost, P&L, Large Service Customer, Demand/Inventory, WIP along with Invoice Aging Dashboard and ad hoc operational reports.
• Working with BOS integration team to ensure flawless integration of data from future F&O and CE solution of the legacy ERP data.
• Redesigned legacy Retail Services reports semantic model for 13 reports to fetch data from a single shared data set instead of 13, resulting in refresh time and query processing cost saving by 95%.
• Leading the offshore HIT and vendor team for production issues over daily stand-up MS Teams call and managing it on ticketing system and DevOps.
• Developing Reporting Project Development & Production Deployment Process Lifecycle standards for the entire organization yielding into support turnover efficiency by 70%.
• Supporting and stabilizing existing/legacy BI solutions developed in SSAS tabular model, SSRS, Excel and Power BI.
• Automating ticketing system, scheduled jobs, user access, and data extractions via APIs through Power Automate.
• Conducting requiremen.t gathering session with business users and designing solutions for projects like Store Connect, Human Capital, Customer 360, Commercial Insights, NA Equipment Inventory and Shipments.
• Developed and implemented Power BI deployment CI/CD pipelines and version control using DevOps and Power BI premium deployment pipelines, reducing 80% manual efforts of maintaining and deploying new/updated Power BI reports.
• Re-activated PUG community across the organization for Power Users enabling Self Service BI model and introducing novel reporting methods.
• Directed and trained 30+ business groups by providing technical & strategic reports.
• Managed and ensured solutions which met 100% of business needs and requirements.
• Certifying 250+ Power BI data models and introducing self service models across the organization, leading to the growth of new users by 45%.
• Led the development of ODS layer for Live and Operational Reporting for Orders data across the organization (Equipment, Manufacturing, Performance Parts and Sales Orders) via different ERP systems CRM, DB2, Oracle, Flat Files and AS400.
• Leveraged and introduced the Power BI Premium feature of AI in Power BI to assist with Sales Forecasting, Financial Analysis and Customer Segmentation.
• As a Power BI Admin added and maintained 400+ On-Prem Gateway Data Sources, redesigned Workspace to separate the semantic models from Reports, developed a Universal Usage Metrics reports using Audit Logs, set up development and deployment guidelines/checklist and setup a Monitoring Hub for tracking Daily Semantic Model (Power BI) refreshes.

● Worked with VP of Operations to deliver multiple customized dashboards and reports for Operations, LAB Billing, Account Management, Inventory and Call Center Department, implementing role-based security in the semantic layer.

● Developed Data-flows to prepare multiple Data-Marts in the absence of DWH, to facilitate the consumption of data for the analytical reporting.

● Published/Deployed different reports to designated workspaces, assign permissions to users, configured gateways and provided end user training.

● Used Python Pandas and Scikit-Learn to preprocess the data, including data imputation, outlier detection, label encoding, scaling, resampling, and feature engineering to avoid multicollinearity issue.

● Designed, developed, and delivered Project Portfolio management Content Pack in for PAC IT team to manage projects, portfolios, and resources, along with Usage tracking report by working with business on critical KPIs like resource capacity, demand/availability, cost, and work health.

● Delivered and automated Power BI usage tracking/audit log reports for Power BI users utilizing shell scripting.

● Documented User Manual, Development and Deployment process for Power BI report to service, along with providing KT to end users.

● Deployed and configured On-Premises Data Gateway connecting to multiple data sources like SQL Server, Oracle, Excel, SharePoint, and flat files.

● Developed various analytical dashboards on Inventory, Orders, Sales, and P&L that depicted KPIS enabling end-user to make informed decisions.

● Redesigned and fine-tuned existing SSIS jobs by re-writing stored procedures, UDFs and views to improve the performance.

● Extracted 1000 gigabytes of data and analyzed 5000 missing and redundant files, generating reports for the CISCO Development Tool to monitor bounce rate, user sessions on various platforms to analyze the developer’s behavior.

● Developed ETL jobs to create pipelines to account for network data extraction, cleaning and transforming the data, using SQL scripts.

● Developed SSIS packages to import/export data from SQL Server 2012 and flat files to perform incremental loads from the transactional data.

● Created parameterized and paginated reports with drill down and drill through capabilities in SSRS.

● Developed SSRS Reports for FIFA games 2010’s Customer Service Portal and optimized stored procs (SSIS) that improved the efficiency by 70%.

● Led to the optimization of On-Hand Inventory by 90% by developing Stored Procedures to pull, analyze & monitor sales trends, seasonality via SSRS reports.