Senior Consultant Resume
South Harwich, MA
SUMMARY:
- 23 plus years of SAP experience in Technical and Functional roles
- Have worked on multiple new SAP ERP implementations since 1994 - basically all data migrations
- Experience in various industries including the Public Sector (LMP Army Project)
- Seasoned in SAP data migrations, data cleansing, transformations, importing, and validations
- Experience leading data migration projects involving groups from IT and Business
- Experience with rollouts and all Cutover activities for organizations
- Experience in Finance, Sales Distribution, Manufacturing, Plant Maintenance, Production Planning, HCM
- Experience managing internal and external (offshore and non-offshore) resources
- Hands on experience with SAP ABAP, SQL, and various data migration toolsets (LSMW, BDC, BAPI, IDoc, ABAP, SAP ADM (Advanced Data Migration)
- Experienced in gathering requirements, architecting and designing solutions, writing specifications, development, testing, execution, code reviewing, mentoring, and assignment of tasks
- Experienced in business supporting roles (technical and functional)
TECHNICAL SKILLS:
SAP Modules: SD, MM, FI, CO, PM, PP, QM, EWM, PM, EC, CS, TR, PS, PA-BN (HCM), IS-Oil, RFID, AIE, BC, BI, SRM, PLM, SCM, EP, OTC, RTR, ETR, PSC, PTP, EHS, BPC, STP, APO, CAMS MII, LMP AMMO-AIT, ETL, Data Migrations
Databases: MS SQL Server 2012, DB2, Oracle, Informix, MS Access
Software: ABAP, Visual Basic, JavaScript, XHTML, COBOL
Operating Systems: Windows NT, Solaris, HP-UX, AIX
SAP Releases: SAP ECC 5.0 - ECC 6.0, R/3 3.0b through 4.7, R/2 version 5.0d
Tools: HP Quality Center, Solution Manager, LiveCompare, ARIS, Rev-Trac, AKO
WRICEF: Workflow, Reports, Interfaces, Conversions, Enhancements, Forms
Migration tools: SAP IDOC, SAP BAPI, SAP Standard Programs, SAP Call Transaction, SAP BDC, SAP LSMW, SAP ADM (Advanced Data Migration Accelerator, certified in dspMigrate, MS SQL, MDM (Master Data Management)
Other: MS Access, Excel, Word, Power Point, MS Project, Visio, Outlook, Lotus Notes
WORK HISTORY DETAILS:
Confidential, South Harwich, MA
Senior Consultant
Responsibilities:
- Focused on data migration, information governance, master data management (MDM)
- Currently the SD Pricing lead for Philips. A Global Project (Netherlands, Japan, Costa Rica, Hong Kong, US). Working on merging the pricing data in different currencies from an acquired company (Volcano) from AX system to SAP
- Certified in SAP ADM (Advance Data Migration) dspMigrate and SQL
- Utilized dspMigrate, SQL Server, BDC, ABAP, LSWM, and IDoc toolsets to edit check and migrate the data
- Using SQL scripting, created the source and target rules and target exports to edit check and create the files
- Created custom reporting for Philips and led data cleansing activities
- Conducted data mapping workshops with the different regions within various time zones
- Created the structures, tables, reporting within dspMigrate and SQL Server
- Pricing data consisted of pricing with scales and without scales
- Pricing consisted of conversion from legacy customer and material to SAP equivalents; including currency conversions from CHF, DKK, GBP, NOK, PLN, SEK, and EUR to US
Confidential, Marlton, NJ
SAP Data Migration Lead/Functional Plant Maintenance Consultant
Responsibilities:
- PM details included: Notifications, Orders, Maintenance Plans and Items, Scheduling, Task Lists, Equipment, Functional Locations, Work Centers, Strategies, Classes and Characteristics, and Catalogs
- AMMO-AIT Solution (IM/WM) details included: Physical Inventory, Goods Issue, Goods Receipt, Bin to Bin movements, customized Task Orders for material movements, Warehouse Requests
- Led and Supported data migration objects for Confidential: Material Master, G/L Balances, Pricing, Inventory Balances, STO (Stock Transport Orders), Batches, Purchase Orders and Purchase Requisitions, Sales Orders, Sales Order History, Accounts Payable (A/P), Accounts Receivable (A/R), and Shadow Postings.
- Worked hands-on and led data conversions from Legacy systems to SAP for EIB, SFA, NSFA for all the Army depots
- Additional responsibilities included conducting data workshops, data mapping, defining data structures, data transformations, data schemas, and data cleansing for all the Army depots, including Confidential (Crane).
- Worked on change requirements, design documents, technical specifications, test scripts, and functional specs
- Coded the following data objects for EIB in ABAP: Catalogs, Functional Locations, Maintenance Plans, Maintenance Items, and Maintenance Strategies
- Supported the following data migration objects for EIB, SFA, NSFA for all the Army depots, including Confidential: BOMs, Characteristics, Classes, Equipment Master, Functional Locations, Measurement Documents, Measurement Points, Serial Number Profile, Production Versions, Routings, Inspection Characteristics/Plans, Maintenance Inventory, Work Centers, Routing Approval History, Tool Part Masters, Tool Kits, WIP Tracking Locations/Conveyances, Standard Plans, CAPP Plans, Work Instructions, Skill Certifications, Planned Working Time, Material Master, Chief Relationship, and Communication Infotype.
- Led a group of senior technical and functional consultants
- Cutover and Data Migration Lead for 1st phase Go-Live (June 2015) for 3 depots. 2nd phase went live in May 2016
- Cutover & Data Migrations Lead for Non-Army Managed Inventory project ( Confidential )
Confidential, Ohio
SAP (ERP) Development Manager
Responsibilities:
- New SAP Global Project (data migration) with SAP modules mentioned below
- Workflow project PR/PO, cFolders (PLM), Logistical Tracking (Shipment information) via Portal
- China forms project
- Vietnam Regulatory Requirements Project in 3 Phases with External Vendor in Vietnam
- EHS Project (OH, IM, IH) in 3 phases,
- QM Project
- MES Interface Project
- Microsoft BPC to SAP BPC 7.5 Netweaver Project
- Mesa/Vietnam New Plant Project
- Portal Project (Sales Overview)
- SRM Arriba Project
- GPP APO Project
- SAP SNC Project
- Sales Quotation Project
- Incoterms Project
- Payment Terms Project
- SRM Upgrade Project
- SRM Vendor Self Registration Project
- Worked successfully in a highly fast paced environment under highly stressed situations
- Saved project costs by analyzing resources bandwidths and effectively applying the resources where needed
- Built a high performing team which in turn controlled costs
- BizTalk was used as the Middleware for interfaces
- Provided direction and coordinated activities for data conversions between Legacy and SAP
- Interviewed ABAP resources, recommended, selected, and managed all their activities including administrative
- Managed 30+ ABAP developers for on Phase 1 of the SAP project from November 2009 until July 2010
- Formed a FORMS team (7 developers) and led the team from start to finish
- Formed the SAP Phase 2 team for a 1-year project and led and managed from start to finish - Go Live 8/2011
- Managed and ensured tasks and activities moved forward using HP Quality Center
- Provided status to PMO on all development efforts
- Attended Team Lead and PMO meetings daily
- Lead weekly meetings with onshore & offshore developers on status, identify issues, and trainings
- Ensure team followed ABAP coding and naming standards for quality
- Transport Requests were release by only me to provide control of what objects are going into system
- Provided transport process and communicated this to whole team
- Reviewed and signed off on Technical Specifications for quality assurances
- Worked on vendor selections, SOWs, RFIs
- Providing guidance to Confidential for on-going projects and support
- Manage Remedy incidents for support
- On call 24/7 for Production issues
Confidential, Greenwood Village, CO
Senior SAP Technical Consultant
Responsibilities:
- Worked within SAP ABAP with RFP team for proposal of SAP Upgrade project from ECC 5.0 to ECC 6.0; represented the technical side and provided presentation on offerings
- Developed a custom data conversion to format credit card transactions to an acceptable SAP format for SAP’s credit card clearing program (SAP Module FI-TV) which enabled users to easily identify transactions for expense reports
- Debugged the FI-TV module to trouble shoot issues for Functional Analyst’s
- Developed interface to bundle sales invoices into a flat file which was ftp to 3rd party vendor for printing (SAP SD)
- Modified address window of Purchase Order form ( Confidential )
Confidential, Indiana
Senior SAP Development Lead
Responsibilities:
- Lead ABAP developer/Architect, project coordinator, workflow administrator, and SAP technical support
- Led the following projects using onshore/offshore resource:
- Data Conversion SAP Global Project (New Implementation)
- Data Conversion Plant Maintenance Project
- SAP CS (Customer Service)
- Transfer Pricing project
- Collaborated with multiple teams: VP of Information Systems, Manager of Application Development, Functional, Basis, BW, Offshore, RFID, and Plant Maintenance teams
- Coordinated, developed, and cross trained on interfaces for Purchase Order, Purchase Requisitions, and Goods Receipt using XI and IDocs between Confidential and SAP for Global Maintenance project; enhanced the PO COMMON Shop Papers using SAPSCRIPT; coordinated and worked with data conversion team on the following data objects using LSMW: work centers, create catalogs, functional locations, equipment, assign equipment to class, assign class values to equipment, create equipment BOM HDR Stock, equipment BOM stock change, change equipment BOM to add non-stock parts, create function location BOM HDR stock items, create equipment task list, add group counter to existing task list, and add long text to existing task list
- Developed Repair, Repair Quotation, and Service Notification Confidential and coordinated work effort with offshore team for SAP CS Project
- Re-wrote entire SAP Workflow for Non-PO Invoice Verification and supported and modified the following workflows: PO Invoice Verification, Travel & Expense, Customer Pricing, PO Approval Process, and PR Approval Process
- Developed the following reports (ALV and Classical): Material Master Audit, T & E Compliance, A/P Invoices Paid, A/R Credit Notes Tickler, Price Quantity Change Audit, Material Document based on Quality Hold, and Single Level Bill Inquiry; supported and modified the following reports: Warehouse Productivity, Warehouse Count Accuracy, Customer Price List, Pick Quantity Discrepancy, Repair Cost Analysis, Credit Memo Breakdown, Open Sales Order Change, Sales Order Price Change, Single Level Bill Inquiry, and Daily Back Order Critical Item List, and Peak Usage
- Developed the data conversions using LSMW or BDC for SAP Global Project
- Modified an enhancement (Dialog Programming) called Quality Hold on Inventory which puts a hold on a specific material’s stock quantity based on storage location and plant
- Responsible for support of all SAP objects (200+) developed for SAP Global, Plant Maintenance, SAP CS, Transfer Pricing, and RFID projects
- Cross trained on RFID and AIE (Auto-Id Enterprise) for stock transport orders
- Wrote technical specifications, unit and string testing plans, conducted code and technical spec reviews, liaison between functional and offshore teams, conduction status meetings with offshore, wrote reports to management
- Developed a BI extract program to select material specific data (stock on hand, unit of measure, plant, material, etc…) based on selection criteria enabled via Datasource change; supported BI team with trouble shooting
- Provided ABAP support to HR, BI, MDM, Basis, and Business Analyst teams
- Mentored and trained junior SAP developer
- Selected vendors and assisted on SOWs for Plant Maintenance project
Confidential, Phoenix, AZ.
SAP ABAP Consultant
Responsibilities:
- Monitored: IDOCs (Inbound/Outbound) and resolved any issues; interface files sent and received using SAP BC (Business Connector) middleware solution; in addition, reviewed SAP daily and monthly jobs
- Provided ABAP Production Support
Confidential, South Plainfield, NJ.
SAP MDM Functional Consultant/Test Team Lead
Responsibilities:
- Developed a test project plan on MS Project; a defect recording mechanism; developed test cases; developed performance, volume and stress test plans; developed a training plan for the customer
- Implemented and configured validation rules based on Adidas business rules, data structures, mapping, and data model; analyzed physical data model utilizing Power Designer 10 and exported rule definitions
- Wrote technical specifications, test cases, and naming standards for validation rules
- Created syndication data mappings for extraction of MDM Supplier Master and Reference data for syndication to 6 legacy systems and 1 to SAP FI
- Loaded the material hierarchy in 1 week to meet a one-week critical go live deadline for SAP Mexico
- Created table of hierarchy type, used Import Manager to successfully load material hierarchy using Excel
- Reviewed data using MDM Data Manager
- Provided live demonstrations of MDM to potential customers throughout USA
Confidential, Canonsburg, PA
Senior SAP ABAP Consultant/Technical Team Lead/Architect
Responsibilities:
- Developed enhancement for Product Costing of IS Oil (Downstream) MAP (Marketing, Accounting and Pricing) which included area menu, interactive reporting, and dialog programming
- Developed Late Payment Fee form using SapScript
- Configured credit card authorization results and settlement (Outbound and Inbound interfaces); created output file formatted for EDI and sent via EDI to authorization house for authorization code; authorization code results were returned via EDI file to settle in SAP in SAP SD module
- Developed interface to receive A/R invoice files from various countries & posted using standard FI posting program
- Applied user-exit to populate Sales Order, quantity in SKU, and billing line items on the accounting document
- Applied user-exit to populate material group in the Representative Material field for PCA (Profit Center Accounting)
- Supported and modified the following: report to populate account balances, overdue items, and cash discounts for Chevron customer base; EFT programs that sent/received payments to and from customer
- Wrote functional & technical specs with security measures; wrote unit, string, test plans & turnover documents
- Participated in integration testing, testing scripts, and transaction scenarios
- Sole ABAP developer on an SAP upgrade project from 4.0b to 4.6c in collaboration with Basis and Functional Analysts
- Worked on and solved many issues involved with upgrade; utilized OSS to research and solve the upgrade issues
- Developed report to calculate Daily Sales Outstanding (SAP SD)
- Developed the following reports: Depreciation of assets by aircraft, audit report of invoices for auditors, Aging report, maintenance and rents on Confidential ’s airplanes, and Purchase Order report associated with assets
- Developed a dialog program to allow users to view, download, and update files in SAP
- Configured warning messages to be issued out as error when duplicate invoices were entered
- Developed: an inbound interface between PMI and SAP of invoices and applied G/L postings in SAP; program to download cleared checks from Bank One and post the G/L postings in SAP; utility program to upload journal entries from Excel spreadsheet to SAP; program to update customer table to synchronize financial table (actuals)
- Added reports to a variety of report trees in SAP
- Mentored junior SAP developers
- Provided SAP Production support
- Managed 5 employees, cross trained, and led effort to implement conversions, reporting, and interfaces for SAP FI
- Was responsible for ensuring OSS notes were intact after application of Legal Change or HOT packages for Finance
- Researched issues on OSS and appropriately applied OSS Notes
- Created and implemented an MS Access database for tracking and monitoring the entire project’s tasks
- Mentored and trained junior SAP developers
- Developed custom ABAP data conversions for Bank Master data and G/L balances; wrote journal entry upload interface that used Excel and Visual Basic and RFC to help with the data conversions of G/L balances
- Developed custom ABAP to call FTP process to transport Bank files; an ABAP to load activity types price planning from EXCEL spreadsheet (transaction KP26); an SAP dialog program to add, change, or delete custom tables
- Modified function module to translate legacy accounting codes to SAP equivalents; modified SAP's search help AANLC to do lookup by location and for search help DEBIK to search by accounting clerk field; modified screen's program attributes to make Reference field required on SAP standard screen for asset retirements
- Developed Group Depreciation of assets application using IOWA Curves for Public Utilities. It included reports, updates, transactions, and user-exits). Utilized a book on IOWA Curves to extract requirements & formulas
