Senior Consultant Resume

SUMMARY

MS SQL Server Integration professional with deep experience implementing SQL Server Management Studio (SSMS), and Integration Services (SSIS).
Ten - plus years of successful experience as an IT System / Business Analyst responsible for in-house, Confidential and SAP Solutions. Creates value for stakeholders by providing requirements gathering, technical configuration, testing, data validation, documentation, and services.

TECHNICAL SKILLS

Productivity: SAP: ECC, BW, Reporting, ABAP, CPI-DS, IBP

Product Lifecycle: Windows

Confidential ERP, PL/SQL: Bills of Material

Excel: SQL Navigator

Routing: PowerPoint

SQL Plus: Supply Chain Modeling

Word: MS SQL Server

Inventory Management: Outlook, COBOL. Work in Process, Visio, IMS, MRP / DRP, Lucidchart, Paradox, Sourcing and Purchasing, Notepad++, Business Reporting, Scrum Certified

PROFESSIONAL EXPERIENCE

Confidential, Meridian, Idaho

Senior Consultant

Responsibilities:

Performed analysis with Clients to understand source of data points and gaps for building solutions
Designed ETL (Extract, Transformation and Load) from SAP ECC or BW to SQL Server via SQL Server Integration Services (SSIS) to build integration with the Adexa planning system
Developed via T-SQL all tables, indexes, procedures, functions, queries, and Agent jobs required for solution (SSMS)
Coordinated the SQL Server Integration Services (SSIS) between SAP and SQL Server. Also, SQL Server to SAP IBP
Developed monitor procedures that ensures data integrity in SQL Server
Developed custom BOM/Sourcing Explosion in SQL Server that creates a full view of Supply Chain
Developed all procedures to transform all the SAP data into Adexa data requirements
Created the Agent jobs that executes the procedures to transform data into Adexa format. Also, submits Adexa plan runs and monitors and reports results
Created numerous queries for business that report master and transactional data. And queries used for trouble shooting
Created SQL Server Query and Transactional SQL

SAP IBP (Integrated Business Planning) Integration

Provided analysis for Clients to understand source of data points and gaps for building solutions
Built extractions for Master data and Transactional data from SAP ECC to SAP BW for large Pharmaceutical companies and Jet Engine companies
Designed and lead the dev team on custom BOM, Routing and MRP Elements extracts
Designed ETL (Extract, Transformation and Load) that utilized SAP Cloud Platform Integration (CPI-DS) that extracts data from SAP (ECC and BW) and loads into SAP Integrated Business Planning (IBP)
Designed custom BOM, Routing and MRP Elements SAP ECC extracts
Designed custom BOM/Sourcing Explosion in SAP ECC that creates a full view of Supply Chain
Designed custom Forecast Upload process into SAP ECC
Developed SAP Reports (SQ00)
Technical lead on all integration

Confidential, Allentown, PA

IT System

Responsibilities:

Proficient in applications internally built as well as the Confidential and SAP application suites
Transitioned from SAP Application Suite to Confidential Application Suite
Designed and developed Material, Bills of Material, Routing, Transportation Lanes, On-hand and Work in Progress inventory extracts from SAP to Confidential
Built a 7B1 RosettaNet solution with Contract Manufacturers to track the supply chain through manufacturing
Implemented a custom Global Product Structure to identify all manufacturing paths for the supply chain; from Finished Good products through subcontractors to vendors
Established a real time reporting structure in SAP to keep the business updated throughout its daily lifecycle; designed and produced reports to highlight batch genealogy through the supply chain using standard SAP tables and reporting
Built interfaces into the SmartOps application to complete safety stock analysis throughout the supply chain, providing master data of material, bills of materials, transportation lanes and plant information from SAP into the application

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship