Data Science Analytics

SHASHI K. PATHAK

*******@***.*** 214-***-****

Summary of Qualifications

Multi-disciplinary in business analysis, data science, data analytics, data visualization, SAP CRM-TPM, S&D, FI/CO, and dispute management within the CPG industry.

Proficient in use of predictive analytics and visualization with a passion for condensing large data into simple to understand story.

Consistently exceeded performance goals and was a valued system support trainer and mentor to newer analysts.

Adept at working independently and collaborating with teams across multiple functions.

Education & Certificates

Master of Science in Mathematics - Tribhuvan University, Kathmandu, Nepal

Bachelor of Science in Physics, Math & Statistics - Tribhuvan University Kathmandu, Nepal

Data Science/Data Analytics Certificate - Southern Methodist University, Dallas, TX

Technical Skills

Power BI, Tableau, R, Python, Pandas/Jupyter NB, AWS-RDS, SAS, SQL, Alteryx, HTML/CSS/JS

Advance Excel, PowerPoint, Visio, ETL/ELT, Master Data Management, R/3, ECC 6.0, S/4 HANA, SAP CRM/TPM/CBP, SAP BW S/4 HANA, SAP S&D, SAP FI/CO,

Three time CRM-TPM implementations

Strong hands-on experience in E2E process of Order to Cash and Billing processes,

Over 10 years OTC mentoring experience

Data Visualization, Data Governance, Data Modeling, Data Mining, Data Discovery, and Data Lineage

Professional Experience

Hershey’s Hershey, PA 05/2023 – 10/2023

Business Analyst-Pricing & TPM Integration, ERP S4 HANA Transformation

Design and implementation of capabilities within a global template solution of the End-To-End processes within Finance, Order to Cash, or Supply Chain.

Support Product Owner within the S/4 project phases of build, test, training and deployment of new enterprise standard functionality for core processes.

Leverage functional/technical expertise and customer knowledge to ensure the capabilities are clearly documented with User Stories with clear acceptance criteria that are aligned with the vision and expectations of the end-to-end product.

Support process documentation (process flows, business process design documents).

Identify key business scenarios for testing and ensuring such scenarios are fully tested prior to the deployment of new functionality.

Interact with the Data team to ensure that sufficient and complete data exists for testing.

Execute tactical deliverables for the overall S/4 Confirmation Phase design principles during the Agile Development Process.

Contribute to the value creation for the sub-process design and impact.

Represent the end user by ensuring key decisions are validated in the system.

Department of Homeland Security Washington, DC 01/2022 – 07/2022

Senior Business Data Analyst

Interfaced with customers and other stakeholders to develop quantitative measurements to aid in the assessment of multiple DHS program performance utilizing SQL, NoSQL, and Graph DB.

Developed concrete and demonstrable metrics and measures of program outputs and outcomes.

Mined quantifiable metrics from interviews and written narratives from program stakeholders.

Developed and reviewed program and project documentation.

Consolidated data from numerous sources to create presentations for all levels of management and stakeholders.

Captured epics and stories in Jira and participated in ceremonies.

Updated and educated stakeholders with current development and updated their current progress while engaging in validating Data Quality, Data Modeling, Data Governance, and Data Lineage.

Performed presentation/training on different programs across components and line of business.

Built dashboards and visualizations using Excel, Power BI and Tableau.

HP Hood Lynnfield, MA 06/2021 – 10/2021

SAP TPM/Pricing Analyst

Customized Fund type, Fund category and Integration with S/4 HANA TPM.

Worked closely with the functional consultants of other modules to resolve cross - functional issues in CRM- S&D, MM in S/4 HANA.

Contributed towards data migration and conversion using Migration Cockpit with Migration Object Modeler.

Planned and created Rebate Promotions; Trade and Non-Trade Allowances in CRM/TPM.

Reviewed BRD, technical specifications and SAP technical design.

Reviewed configuration for any data load issues and made appropriate changes.

Maintained customer as well as product hierarchy across ERP platform.

Validated Condition Techniques (Tables, Access Sequence, CondType and Pricing Procedure).

Participated in workshops with end users highlighting enhancement over legacy system.

Rendered post go-live support, carried out troubleshooting of various issues related to the sales service & online module of SAP CRM (mainly Product Hierarchy).

Upfield US Hackensack, NJ 11/2020 – 06/2021

Deduction Data Analyst

Coordinated with marketing, Supply Chain, Finance, Customer Service, Carriers, BPO and Broker to optimize the efficiency of deduction clearing process in a daily basis in S4 HANA.

Analyzed chargeback data from several sources and portals and presented it visually.

Resolved pricing, allowances, and transportation charges conflicts.

Helped improve logistics deduction management process both in quantity and quality.

Developed process and system efficiency along with KPI’s.

Facilitated the “Day in The Life” training for Deduction Analyst.

Mentored interns.

Worked with internal and external auditors and extended assistance as needed.

Reviewed and audited promotional settlements, vendor pmts., credit memos and deductions.

Mountain Valley Spring Water Hot Springs, AR 02/2018 – 06/2018

Financial Business Analyst

Built, managed, optimized and implemented trade promotion application system.

Mined and analyzed data from different sources for efficiency, accuracy, and profitability.

Improved the trade promotion management processes & trained end users on new reports.

Analyzed data and metrics to develop and prepare meaningful financial reports using Excel/Power BI Dashboards.

Nestlé Waters Coppell, TX 01/2004 – 12/2017

Credit Data Analyst (02/2016 – 12/2017)

Utilized various data sources to assess including ETL to optimize credit worthiness of customers ranging from $5K to $75M and minimized bad debt at risk along with maintaining integrity of master data shared by other Nestle Op-Cos.

Performed credit reviews and approved/reject credit applications based on customers’ financial strength.

Reduced orders on credit-hold by 50%, bad debt write-off by 20%, and DSO by 6%.

Created various ad-hoc trends and reports to identify potential opportunities.

Managed and supported B2B customers with timely business solutions.

Coordinated testing including developing test scripts during implementation of Global Landscaping Simplification project based on S/4 HANA.

Rolled out Internet sales functionality to different countries, mainly Caribbean Islands in SAP Hybris.

Business Analyst/Analytics (05/2008 – 02/2016)

Supervised the management of promotional spending including deductions on Club, Mass & E-Commerce channels with portfolio cumulative value of over $250 million and conducted spending analysis on contracts to determine expenditures against return on investment.

Worked as TPM Hyper Care Analyst until Jan 2012.

Developed Customized Report for accruals and Settlements in TPM.

Resolved Issues related to Promotions, Agreements and Pricing.

Helped build Target Groups, Product Segment and Attribute List in CRM.

Participated in scoping spend type, spend category, method, campaign determination and planning profiles.

Analyzed and resolved interface errors, hierarchy, pricing issues, and negotiated repays due.

Business Analyst (SAP) (02/2006 – 05/2008)

Oversaw preparation and implementation of “Go-Live” GLOBE SAP (ECC 6.0) template including testing and validating used for TPM, Dispute Management, and Customer Service.

Performed data conversion (Master Data only) from R/3 4.6C to ECC 6.0 utilizing built in tool (LSMW).

Raised gaps, provided Functional Specs, in compliance with business requirements and validated in-scope business processes in the areas of Cust Svc, Accts Rec, Dispute Management, and Trade Promotion.

Prepared Test-Scripts, performed testing of all GLOBE SAP system in the Regression, Integration, Quality and Pre-Prod cycle including Unit-Test.

Developed “Go-Live” learning and training materials and conducted the training (workshops) for users in the United States and Canada.

Trade Promotion Analyst (SAP/Siebel) (01/2004 – 02/2006)

Utilized Siebel/SAP TPM Systems to process promotional settlements, vendor payments, credit memos and deductions for direct and indirect customers.

Primary liaison between Retail Sales, Customer Service, Finance, and Customers.

Managed high profile accounts including Sam’s Club, Costco, Jetro, BJ’s, Walmart, Target, SUPERVALU, Stop & Shop, Kroger and C&S.

Led different projects in streamlining OTC and integration processes.

Contact this candidate