Strategic Data Analytics & ERP Solutions Expert

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, Alteryx, SAS, SQL, Mongo DB, R, Python,Pandas/Jupyter NB, AWS-RDS, HTML/CSS/JS

Gathering Business Requirements (BRD).

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, Vistex (Price, Rebate, Channel, Trade Promotion, and Vendor Chargeback).

• Three times 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 ensuring 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 02/2016 – 12/2017 Credit Data Analyst

• 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.

Nestlé Waters Coppell, TX 05/2008-02/2016

Business Analyst/Analytics

• 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.

Nestlé Waters Stamford, CT 02/2006-05/2008

Business Analyst (SAP)

• 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 with 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 US and Canada.

Nestlé Waters Coppell, TX 01/2004-2/2006

Trade Promotion Analyst (SAP/Siebel)

• 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.

Nestlé Waters Coppell, TX 01/1999-12/2003

Accounts Receivable Analyst

• Managed accounts receivables portfolio (Clubs/ Mass) with cumulative value range of $45 to $65 million dollars.

• Applied proactive philosophies and coordinated efforts with account representatives of high-risk accounts to accomplish resolution of past-due invoices, open payments, open credits, unearned cash account discounts and customer payment disputes, resulting in improved DSO by 10% and exceeding performance goals.

• Responded to customer service coordinators of retail and distribution call centers to satisfactorily resolve customer’s claims, including credit/debit memos, while maintaining a professional and positive demeanor.

• Led project to successfully resolve and correct $1.3 million dollars in unapplied credits to customer’s account.

• Prepared monthly management summary reports including Key Performance Indicator (KPI) reporting.

Nestlé Waters Coppell, TX 06/1997-12/1998

Deduction Analyst

• Managed account portfolios with cumulative value in excess of two million dollars; responsible for order management, pre-invoice edit and deduction processes for accounts in the Central and Southeast regions of the US.

• Interacted with regional managers, business partners, customers, grocery finance and credit personnel in providing feedback and guidance on minimizing and controlling deductions.

• Facilitated the timely clearing of deductions, and reported and processed unauthorized deductions for repayment.

• Analyzed the monthly management reports to identify trends and variances.

Contact this candidate