Supply Chain Bi Analyst Resume
3.00/5 (Submit Your Rating)
SUMMARY:
- Information Technology Professional with about 9+ years of techno functional experience in implementing solutions in consumer goods, manufacturing, pharmaceutical and insurance industry. Hands on experience of working in SAP support projects and implementations.
- 4+ yearsof experience in SAP MM/SD/ABAP.
- Knowledge onOrder to cash (OTC)processes.
- Experience in facilitating meetings to determine client requirements and converting the requirements to system specifications and have worked in all phases of the System Development Life Cycle.
- Well - versed with the SQL queries of different types like Data Manipulation Language (DML) to perform data analysis and verification.
EMPLOYMENT HISTORY:
Confidential
Supply Chain BI Analyst
Responsibilities:
- Running reports daily to support the seasonal/non-seasonal supply planning BI processes.
- Used Excel & Business Objects Analysis Query for running the reports.
- Troubleshooting issues identified by the users.
- Publishing order reports to Tableau server.
- Extracting and downloading reports using JDA software.
- Performing data validation and data verification in Excel reports before submitting to SharePoint.
- Used Microsoft Azure storage to upload production files into Tableau.
Confidential
SAP Consultant
Responsibilities:
- Experience with S/4 HANA.
- Used JIRA to raise, track and fix defects.
- Supported issues related to inventory management process, FI posting of inventory.
- Supported purchase requisitions, purchase orders, sales orders processes.
- Hand on experience in material requirement planning, subcontracting process including inventory postings.
- Conduct Business Requirement gathering workshop and created Business Blueprint documents for subcontract procurement process.
- Technically skilled in Excel Data Analysis to provide data cleansing support and validation. of data for use in presentations, metrics, and reporting of information.
- Responsible for communicating status to project managers, team members and management. Work with technical teams to create and maintain test plans.
- Performed quality assurance (QA) testing and sign-off of assigned software functionality.
Confidential
SAP Consultant
Responsibilities:
- Configuration of OTC Process from sales order to invoicing.
- Configured and customized sales, delivery and billing document types, item and schedule line categories, customer master data in SAP SD/MM.
- Custom development of classical and interactive ALV reports with selection screens retrieving data from various SAP standard tables belonging to different SAP functional modules.
- Used Excel pivot tables and V-lookups to manipulate large amounts of data in order to perform data analysis.
- Used complex SQL Queries for data manipulation and analysis of business metrics.
- Performed functional acceptance testing, system testing and guided the user acceptance testing phase.
Confidential, Parsippany, NJ
Business Analyst
Responsibilities:
- Worked closely with business stakeholders to gather business requirements, develop system requirements, functional design for developing Web Methods application.
- Co-ordinated the development work, developed test strategy and performed functional testing.
- Involved in Production Deployment planning, Post go live stabilization and ongoing maintenance.
- Involved in writing SQL queries for analysis on business requirements and validating data.
- Developed excel and VBA macros to analyze/update the large amounts of data and worked closely with business in identifying the potential solutions.
Confidential, Parsippany, NJ
Business Analyst
Responsibilities:
- Involved in analysis, design, development and implementation of software applications and Life Science industries application with Pharmaceutical and Contract Research Organizations. Have consulted and implemented fully according to FDA regulations and guidelines, and company SOPs. Experience in generating Data validation and Data derivation procedures.
- Worked on objectives as assigned and interacted with the project team to organize timelines, responsibilities, and deliverables.
- Developed and maintained good communications and working relationships with teams and external clients.
- Managed multiple tasks and responsibilities in high-pressure environments.
Confidential, Paramus, NJ
IT Specialist (SAP )
Responsibilities:
- Automated the Cancellation and Reschedule for Electronic Order(s) Line Items / Schedules
- Worked closely with the end users to gather requirements.
- Suggested changes to the business requirement and created the system requirement documentation.
- Enhanced the Order Response inbound idoc processing function module to perform upfront validations on the inbound electronic Vendor responses.
- Developed generic function modules to output the Hands-Free release 2 utility reports.
- Developed the test strategy and performed testing.
- Reviewed, analyzed and performed troubleshooting of the test issues to ensure defect free implementation.
- Analyzed and resolved the production issues related to utilities and interfaces (EDI, WOI, OSCWI).
- Resolved issues related to ORDERS, ORDRSP, INVOIC idoc issues.
- Successfully prototyped an electronic storage of PDF invoice output in the IBM GSA system. PDF conversion and storage of PDF file in the AIX system was achieved using logical printer device with PDF driver and the command set option in the printer setup.
- Good understanding of SAPsecurity authorization objects
- Developed custom extract programs to extract the needed OSC Lenovo Historical data from the SAP system. Extracted data sent to Lenovo in a machine-readable format to allow Lenovo to use for Auditing, Reporting and Analysis needs.
- Evaluated the requirements, developed, unit tested and deployed customer ABAP extract programs of change history data of sales orders, purchase orders, contracts, and vendor master.
- Worked with client liaisons to confirm and document requirements.
- Worked on SAP SD and MM modules.
- Led team in resolving issues during deployment.
- Created custom extracts of sales orders, purchase orders, customer master and vendor master data into AIX files to allow FTP using custom developed ABAP programs.
- Involved in evaluation, requirement analysis and enhancement of existing extract programs to meet business requirements.
- Created the SAP authorization and AIX asset protection requirements and worked closely with the system management and test teams to get the tasks accomplished. Involved in the deployment activity and post production support.
- Developed the test strategy and performed testing.
Confidential, Morristown, NJ
Co-Op Global Development Programmer / Analyst
Responsibilities:
- Created transactional database reports and forms using Advanced Business Application Programming (ABAP/4), the native language for SAP.
- Worked in data transformation/loading in SAP BW application.