SUMMARY:

• Highly motivated Data Analyst strong analytical skills and the ability to use business applications to extract reports, manipulate, format, and present data stored in relational databases.
• Possess at least 4 years of working experience with SAP as Confidential functional team member within project implementations or providing pre and post Confidential support
• Strong understanding of business operations and analytic tools for effective analysis of data
• Proficient in SAP Modules (GUI, NetWeaver, Portal, ECC)
• Integration knowledge between multiple modules in SAP such as IM, WM and MM
• Proficient with SAP functionality and business processes including Procure to Pay (PTP) and Order to Cash (OTC), Purchasing and Pricing
• Understands data models and excels at transformations
• Data Migrations from existing legacy systems into SAP
• Knowledge of writing and querying basic SQL queries
• Proficient in identifying, gathering and creating reports required
• 8+ years of interpreting and analyzing data
• Experience with UAT Testing, Test Script Writing, and Confidential Quality Center skills
• Knowledge of Supply Chain and Logistics
• Proficient in Master Data Management (MDM), JDE, ADAPTIV
• Strong MS Office skills (Excel, Word, Outlook, Access, Power Point)
• Proficient in working in SharePoint, Contracts and Pricing
• Working knowledge of Pivot Tables and V - Lookups, Macros
• Experience with Winshuttle Enterprise Studio, including Query and Transaction
• Ability to collaborate with cross-functional teams, Developers, Testers, and other Subject Matter Experts to gather and analyze information needs and Functionality Requirements
• Strong Verbal, Written and Interpersonal Skills with the demonstrated ability to interact with various levels of the organization
• Proactive and ability to multi-task in Confidential fast paced environment
• Self-motivated with keen attention to detail
• Ability to quickly learn new systems applications
• Ability work with minimal supervision
• Knowledge of Accounts Payable and Freight Payables
• Experience in processing vendor/employee and payroll records
• Experience working in Customer Service

PROFESSIONAL EXPERIENCE:

Confidential

SAP Data Analyst

Responsibilities:

• Execute all assigned day-to-day activities related to bottler’s Confidential data support for deployments
• Extract data from multiple systems, conduct detailed data analysis, and load data into SAP-MDM
• Perform detailed data mining, analysis and functional interpretation of Confidential Master Data
• Create and map transactional script templates using SAP field names in Winshuttle Studio
• Extract and transform data from Excel to help with the data migrations and making mass changes in SAP from Winshuttle
• Create and change Outline Agreements and Source Lists (plants) in SAP for the bottlers
• Create Storage Locations in SAP for the bottlers
• Execute mass creation and updates of vendor, plant, material, and price data
• Update custom pricing for Purchasing Info Records in SAP
• Use LSMW to load data into SAP System
• Manage, update and manipulate data with the use of advanced Excel functions including V-Lookups

Confidential, Somerville, NJ

MDM Master Data Coordinator

Responsibilities:

• Plan, align, manage, and execute Supply Chain activities to enact product changes through multiple ERP applications including ADAPTIV, JDE, MDM and SAP on new product introductions as well as revisions to current products
• Provide technical support for the Master Data Management environment for implementing fixes for identified data integrity and customer data processing issues
• Performed analysis using SQL queries in JDE
• Researching, analyzing, and responding to user tickets in Confidential timely fashion
• Execute and approve change orders in the Confidential PLM system that include the formation of new finished good codes, creation and modification to Works Centers, Part Masters and Plants, Bill of Materials ( Confidential ), manufacturing routes, and item attributes
• Collaborate closely with senior project team leads and technical teams to support Confidential, product launches, production changes, and eligibility to comply with Confidential standards
• Extensive use of Excel advanced formulas for updates to many attributes
• Executed automated macro programs using Excel which reduced human error and improved process time
• Add and update Eligibility records for our International customers in SAP for products shipped from Confidential (North America Confidential SAP System)
• Ensure that Confidential products only ship to International countries compliant with Regulatory Standards by getting the Right Product to the Right Country
• Trained our Offshore India team on the Eligibility process through WebEx conference calls

Confidential, Raritan, NJ

Data Analyst

Responsibilities:

• Ensure that Application Services Portfolio Data for Pricing Models and Contracts are valid and accurate at any point of time
• Validation of Statement of Workflow (SOW) submissions against Excel Pricing Models
• Analyze digital submissions for accuracy and adherence to SOPs as set forth by the Application Services organization
• Provide timely communication to Delivery Managers regarding pricing errors
• Run and report monthly statistics, operational metrics, and process performance in Excel spreadsheets using Pivot Tables and V-Lookups
• Ensure entries into SharePoint tracking system are completed in Confidential timely manner with Confidential high degree of accuracy
• Run Excel macros into SharePoint tracking system to ensure proper functionality

Confidential, Rahway, NJ

Project Coordinator

Responsibilities:

• Maintain the data integrity in SAP by tracking asset dispositions, performing inventories, and updating SAP for all specified sites
• Walked through the different laboratories and tagged equipment for relocation
• Track and store all instruments in MS Access database used in relocation projects
• Look up Contract Materials in Lotus Notes
• Create Service Notifications in SAP for Customer Support Engineers to perform instrument installs, disconnects, reconnects and repairs at Merck customer sites
• Request quotes from OEM vendors to service instruments

Confidential, Florham Park, NJ

Confidential Support Analyst

Responsibilities:

• Assist Confidential Managers (Buyers) in coordinating Confidential and supplier relations
• Review and prioritize requests for work
• Create and maintain Outline Agreements (Contracts) in SAP and Excel
• Ensure negotiated prices are entered in SAP agreements
• Update pricing on purchase orders when Confidential price discrepancy occurs
• Export monthly reports from SAP to Excel for Confidential Managers
• Resolve Confidential /P action requests for price and invoice discrepancies
• Create and update Vendor requests

Confidential, Piscataway, NJ

SAP Data Analyst

Responsibilities:

• Participated in the US Region Order-to-Cash project which included writing, developing, executing, and validating UAT test cases in SAP for Sales Order Management (SOM), per requirements.
• Worked closely with the Project Development team through all aspects of the development life cycle, testing current methodologies and tools to ensure that new initiatives are fully tested.
• Attended required project related meetings to gain an understanding of project goals, objectives and needs.
• Created, reviewed, and ran end-to-end testing scripts with on-/off-shore teams
• Acted as Confidential Subject Matter Expert (SME) for Sales Order Management for 10+ testers by providing Master Data from SAP to run the test scripts effectively.
• Identified and documented defects in Confidential Quality Center and following through to resolution according to business requirements performed.
• Interfaced with the Operating Companies to ensure accuracy and consistency of the SOPs.
• Wrote new versions of Business Process Procedures and Standard Operating Procedures for SAP.
• Worked with ETL consisting of data transformation, data source, mapping, conversion and loading
• Overhauled the process to deliver 95% higher results working on the Data Conversions and legacy system integrations.
• Business Owner responsible for approving key deliverables to ensure contents meets both business and regulatory requirements.