Senior Analyst
PROFILE:
Ø 12 years of hands-on ABAP technical experience in RICEF objects with several SAP modules:
SD (order, pricing, billing), MM (material master, purchasing), IM (goods movements), LE (delivery,
shipment, transportation), WM, PP/PM, FI/CO, ABAP/HR and BW/BO.
- Functional and configuration working knowledge of above SAP modules.
- Key member in 4 SAP Implementations, 2 SAP upgrades, 2 plant roll-outs and Y2K remediation with
active participation in all phases: requirements, blueprint, realization, prototyping, testing, go-live, rollout,
OSS Notes, enhancements and post implementation support.
- Experience in project management, project delivery methodology, system development life cycle.
- Expertise in developing proofs of concept, feasibility study, gap analysis and RICEF design.
- Proven expertise in collecting business requirements and developing SAP functional specifications.
- Experience convert functional specs into technical specifications, review off-shore developed code.
- Experience in SAP Development, Conversion, Upgrade, Migration, Maintenance, Production Support.
- Background in: Root cause analysis, Troubleshoot, Debug, Performance tuning SAP applications.
- Integration of SAP with other ERP and legacy systems using SAP BC, web Methods, PI/ XI.
- BW/BI experience in loading strategies for master data, transactional data and delta uploads.
Developed Query Designer and Web application designer to create Queries.
- Supervised, mentored coworkers and designed SAP applications to enhance productivity.
- Saved $10M through increased disc space availability by archiving SAP objects. Maximized SAP functionality by eliminating 20% in-house code towards goal to minimize customization.
- Improved execution by 15% for 10 most critical custom transactions through performance tuning.
- Achieved 91% SLA resolution through root cause analysis and fixes. Reduced job failures by 99.9% by fixing critical SAP-Legacy interfaces.
- Proactively implemented transactions that eliminated late night monitoring of interfaces by technical resources. This significantly increased the productivity by eliminating lack of sleep.
- Created custom transactions that automated mass processes/updates. Gained 60% productivity and 100% user-satisfaction
- Analytical, detail oriented, focused and self-motivated. Excellent communication skills. Committed to high standards of performance. Capacity to work well independently and in a team-oriented setting.
- Consulting experience with Fortune 500 clients covering broad range of industries: manufacturing, advertising, insurance, telecommunications, banking, retail, health and importer/distributors.
SAP SKILLS: Ø SAP Releases: SAP R/3: 3.0F, 3.1I, 4.6B, 4.6C, SAP ECC 5.0 & 6.0
- SAP Functional: SD, MM/IM, PP/PM, WM/LES, FI/CO, HR, BW 3.5 and NW BI, BO, SOLOMAN.
- SAP BW/BI, BO: Query Design, Extraction, Key Figures, Report/ODS/cube/multi-provider, Web i .
- SAP Technical: ABAP/4 Workbench, ABAP/HR, ABAP-Objects, Data Dictionary, SAP Script/Smart/Adobe
Forms, IDOC, ALE/EDI, BDC, Call Transaction, BI, DI, LSMW, Painter Menu/Screen/Report,
Dialog Programming, Reports (Standard, Interactive, ALV), CATT, eCATT, Enhancements/
Modifications, Exits User/Field, BADI, RFC, BAPI, Performance Tuning, Archiving, BSP,
Web Dynpro, Workflow, OSS Notes, Batch Job Management, Debug/Troubleshooting.
- SAP Integration: SAP Business Connector, web Methods, SAP PI/XI, XML and HTML, Mercator.
- SAP-RF: SAP Console, RF Data Integrator (CIM Concepts), SAP customized WM.
SAP EMPLOYMENT HISTORY:
- 09/2011 – 12/2011: Confidential,Schaumburg, IL
- 06/2010 - 08/2011: Confidential,Long Grove, IL
- 11/2009 - 05/2010: Confidential,Pittsburgh, PA
- 06/2007 - 10/2009: Confidential,Schaumburg, IL
- 10/2004 - 05/2007: Confidential,Naperville, IL
- 10/1998 - 09/2004: Confidential,Lake Forest, IL
SAP EXPERIENCE:
Senior Analyst at Confidential: Confidential,IL 9/2011 – 12/2011
Support, modify existing programs and develop new interfaces in global instance of HCM.
- Add Custom Action Types for Costa Rica: Analyzed 30+ objects (interfaces, reports, methods, fm) to
identify relevant existing logic for inclusion of new action types, modified, tested, documented changes.
- ROSS Ledger Translation: Identified all objects containing third party ledger translation logic. Modified
ledger retrieval by adding company code and profit center. Tested and created change documentations.
- Delete Pernr: Created custom delete action types. Modified relevant objects, tested and documented.
- Source Scan: Developed interactive report that searched up to nine strings from reports, includes,
pools(subroutine, module, function, class, type). Proved highly efficient and productive tool in where-in used search of action types.
- Transport Report: Developed ALV drill-down report to track transports and tasks by various selections.
- Scrambling Program: Developed code to scramble certain sensitive fields in IT0001, IT0002, IT0006,
IT008, IT0021, IT0105, IT0167, IT0168, IT0759, IT9005, IT9006, IT9015 when test clients refreshed with
production data.
- Enhanced SM30: Added buttons and pop-up screens in header and detail screens of maintenance view of custom table by customizing SAPLSVIM and using ST event.
Senior Analyst at importer/distributor client: Confidential,Long Grove, IL 6/2010 – 8/2011
Highly customized implementation of SAP modules: MM/IM, SD, FI, Logistic Execution (delivery, shipment,
transportation), WM/RF and BW/BI modules.
- SAP Scripts/Smart Forms: Developed new and modified existing layout sets in PO, MM/IM, SD, PP, WM modules including VDA Automotive Smart Forms. Created new output types and forms to print pallet/HU labels from VT0xN. Designed custom ABAP print program and smart forms for check printing for several banks. Modified ASN and packing slips to display all items from PO whether shipped or otherwise. Output types updated for external send and print programs modified to email PO directly. Dynamically included TXTID via VTKO-TAXNAM-ADR. Included material level internal note (Basic tab/Additional Functions) in picking ticket (object MATERIAL, id VER). Created UCC128 shipping label from IDOC E1EDT20/E1EDT37.
- RF Implementation: Most WM transactions were customized for RF functionality. Developed functionality of automatic PGI by delivery after loading all handling units by customizing LM31 (load by delivery) and LM61 (GI by delivery). Enhanced RF picking and confirm TO lines based on custom flag in LIKP. Added functionality to automatically perform ‘CMPL’ function after a full pallet has been pick confirmed to enhance user productivity.
- ABAP and ALV: Uploaded material memo in MM0x and MD04 (object MDTXT, id LTXT) from excel. A wrapper was created to check existence of data file before submitting RSEINB00 in batch job. Created custom report ZRLLI0400 for input in LI04 to print material short text longer than 20 characters in physical inventory documents. Developed custom copy control report ZRV15CC09 from template RV15CC01 for copying condition type ZR00 in table 509 from sales office->sales office. This has increased much user productivity. This copy control is not offered as standard SAP functionality.
- User Exits and BADI: Created warning message during VK11 (pricing condition record creation) when material sales price is lower than material standard price. Added G/L account description and cost center description in PO Account Assignment tab (ME22N). Enhanced VA05 (list of sales order) to display ‘ship-to address’ at item level. The warning message in VI01 (shipment cost document) upon entering certain condition type has been changed to required. Enhanced MM01 to propose next consequent external alpha material number. Added a custom field to VL06O (standard display variant to delivery monitor). Added customer tab and customer field ‘Asset Number’ at PO creation and automatically copied this field to header text field in MIRO transaction upon entering PO number and finally automatically populated this field into line item of transaction FAGLB03 (GL open item balances). Enhanced SE16 for MARA lookup of material number based on alternate input (ATWRT, EAN11, KDMAT etc). Automatic update of delivery date in Header Shipment/Unload tabs of VL32N (inbound delivery) upon input in certain custom field. Added field ‘customer PO’ in custom tab of VL32N (inbound delivery) to be updated from incoming IDOC DELVRY01 from EDI. Created warning message when certain condition types exist in the sales order but not certain sales partners exist or vice versa using implicit enhancement. Automated highly manual and extremely time consuming process of calculations from spreadsheets to identify Indian product that qualify for 0% duty import in USA by creating new costing variant in CK11N and calculate ‘percentage
of selling cost’ for Indian origin materials in EXIT_SAPLCK21_002 and populated this value in newly
created custom field in purchasing view of the material master(MM0x).
- SAP Query: Developed a complex query to pull orders and invoices for any pricing condition type.
- IDOC Extension: Extended segment INVOIC01/Z1TRANS and populated sales order header custom field ‘program type’ (IDOC_OUTPUT_INVOIC/EXIT_SAPLVEDF_002). Enhanced SHPMNT03/ZSHPMNTX and populated sales order item level custom field ‘delivery call #’ (EXIT_SAPLV56K_002).
- LSMW: Defined class/characteristics in CMIR and loaded values via LSMW.
- Bartender Label Printing: Developed several labels (Master and Set box) using Bartender with input from custom extraction of data from SAP tables. Created ABAP program to pull characteristic values from CMIR in a text file that automatically invoked Bartender labels using Commander as Service. This has tremendously increased user productivity.
- BI/BW Generic Data Source: Created several generic data sources, structures and function modules after template RSAX_BIW_ GET_DATA_SIMPLE. Created SAP fm to simulate SM21 (system log) and called this fm in Generic Data Source extractor by Function module.
Functional Analyst at manufacturing client: Confidential,Glenview, IL 11/2009 – 5/2010
Project involved roll-out at Canada and Woburn plants integrating non-SAP warehouses with SAP
Logistic Execution (delivery, shipment, transportation) modules.
- SAP and decentralized SAP WM: Configured ALE: Logical Systems, distribution model, ports, partner profile, RFC destinations for transfer requirements/Transfer order.
- Decentralized SAP WM and non-sap external WM: Enhanced TO creation and TO confirmation.
- Functional Specs: Gathered business requirements, developed functional specifications for BOL, picking
and packing list and created layout designs.
- Configuration: Configured output and print determinations for triggering above forms at shipment
completion interfaced with external warehouse systems. Developed copy controls for text-ids.
- Analysis: Conducted detailed requirement analysis of implementing legacy report Inter-Company Sales Report by Place of Manufacture/Location in SAP.
Senior Analyst at manufacturing client: Confidential,Rolling Meadows, IL 8/2008 – 10/2009
Client had concurrent SAP upgrades and several legacy systems integrating with SAP SD (order, pricing,
billing), MM (purchasing) and LE (delivery, shipment) and SOLMAN modules.
- QA test SAP upgrade: Automated creation of SAP return sales orders with reference to the
original invoice via eCATT chaining 14 SAP transactions. Trained client in SAP eCATT tool.
- Performance tune Info Record -Servigistic interface: Identified bottlenecks and recommended
strategies to enhance code and reduce interface time between SAP purchase agreement
extracts, DB2 mainframe, middleware IFDB and ETL Servigistics applications.
- Conflict Resolution in SAP upgrades: Critically analyzed 53 ABAP programs common to parallel
upgrades running on same SAP instance for conflict in logic, interface and user-exits.
- Enhanced productivity in user-id creation: Developed ABAP program to mass create SAP user-id
in remote destinations using BAPI with input from local excel file having user data and roles.
- Break-Fix: Fixed logic to suppress re-reporting of the same machine while buyback and re-sale occurs at later period in SAP-iMAPPs interface. Resolved several warranty system user tickets .
- Create Technical Requirements: Analyzed process flows of .NET extranet GIR and Java extranet SMAP
and its components: BAPIs, custom ABAP programs, Workflows and XMLs. Developed strategies to automate interface using SAP Business Connector and WSDLs.
- Integrate SAP and Snap-On: Replaced multiple FTP, batch job and LSMW steps between SAP and
SnapON interface with efficient middleware webMethods using RFC, BAPI and xml to post account
receivable invoices, credits and update machine data.
- ALV Reports: Created AP post audit, Delete Open Delivery referenced with Open Order reports.
Senior Analyst at advertising client: Confidential,Wood Dale, IL 6/2007 – 7/2008
This large and complex project involved integration, using SAP Business Connector(BC), of existing Philip
Morris, IVR and Sales Order Entry with SAP SD (order, pricing, billing), LE (delivery, shipment) modules.
- Business User Interaction: Led requirement gathering from business users, SAP and AS/400
stakeholders. Enhanced and updated poor functional specs for completeness and accuracy.
- Technical Design: Created several comprehensive technical specs identifying all possible business scenarios. Researched and identified RFCs, BAPIs, IDOC. Implemented RFC wrappers to simplify middleware BC logic and improve performance. Configured ALE scenarios for BC.
- Integration Testing: Architect of Test Driven Development (TDD). Created test cases for all scenarios and
verified them for accuracy and completeness. Coordinated end-to-end integration testing for the
SAP-BC-PM interfaces.
- Supervision: Guided and mentored SAP BC developers implementing the technical specs.
Senior Analyst at manufacturing client: Confidential,Highland Park, IL 2006 – 5/2007
Involved in all aspects of implementation of SD (order, pricing, billing), LE (delivery, shipment) modules.
- Blue Print/Requirements: Played active role in FRICE profiles creation, feasibility and gap analyses. Developed record layouts for master data. Prototyped interfaces with XI.
- Realization/Technical Design: Created 20 technical specifications for off-shore coding. Using ALE/IDOCS designed interfaces with XI. Created ALV reports, Smart Form/Sap Script forms and User Exits. Code review and performance tuned off-shore developed code. Developed LSMW for master data.
- Integration Testing: Key role as troubleshoot, issue resolution. Updated specs from change management.
- Stabilization/Production Support: Developed and monitored metrics on critical process to alert proactively business and functional resources for bottle necks. On call 24/7 for production issues.
- BI Development: Designed custom Data-Source, Info-Source, Extractor, Info-Cube and ODS.
Stream-lined data loading strategies for master data, transactional data and delta uploads.
Developed Query Designer and Web application designer to create Queries.
Senior Analyst at manufacturing client: Confidential,Chicago, IL 2004 – 2005
Participated in go-live for SEQUIOA & Mexico plants and Kraft products acquisition with SAP SD (order,
pricing, billing), MM (master, purchasing), LE (delivery, shipment) modules.
- SAP Script/Smart Forms: Developed multiple language pre-printed layout sets showing single &
multiple columns per page, labels/logos, configured output types, modified SAP print programs
- ALV Reports: Created for Standard Price, Purchase Price Variance, COPA Planned Valuation.
- User Exit/BADI: Implemented for Sales History, Document Info Record, and Purchase Order.
Senior Analyst at manufacturing company: Confidential,Lake Forest, IL 1998 – 2004
Led technical and functional support during implementation of SAP MM, IM, PP, PM, WM modules and
subsequent plant role outs, upgrades and Y2K Remediation.
- Project Management: Led requirements gathering, feasibility, gap analyses, set mile stones, translated
business requirements into technical specs. Applied top-down methodology.
- Upgrades: Actively involved in 3.1I, 4.6B, 4.6C upgrades. Researched and applied OSS notes. Updated
custom codes. Created test scripts. Verified custom transactions and interfaces.
- Plant Rollouts: Configured PM functional locations and work centers. Uploaded data from MS Access.
Created batch job and variants. Configured IMG settings for PP and PM modules
- Y2K Remediation: Investigated & modified custom objects/interfaces and tested for compliance.
- SAP-RF Support: Increased shop floor efficiency by 90% by creating critical RF transactions
in MM/IM and WM/LE modules using Data Integrator middleware and SAP Console
- Dialog Modules: Enhanced and fixed incorrect logic of custom transactions in PP and WM/LE
- User Exits: Implemented user exit in inbound IDOC for transfer of independent requirements in
DM/SOP module and for auto batch number assignment for goods receipt in IM module.
- SAP Script/Smart Forms: Developed several layout sets in PO, MM/IM, SD, PP and WM modules
- Productivity Gain: Replaced inefficient Master Recipe functionality with extremely efficient CAPP
process for calculation of quantity of Batch Roll Stock and Scrap in BOM using custom tables and
table maintenance transactions. This enhanced productivity from three weeks to one day.
- Performance Tuning: Extensively performance tuned custom reports: Material Utilization, Efficiency
Utilization, Production Order Reconciliation, Downtime, Scrap Direct Issue by Shift Operator.
- Interactive Reports: Created complex interactive report for Mass Production Order Cost Analysis & Mass
TECO of Finally Confirmed Production Orders. This allowed to interactively measure cost variances of
order material, non-poly, labor and machine overhead. This functionality did not exist in SAP and was
among top ten critical transactions.
- ALE: Configured partner profile for inbound IDOC for updating S076 planning table. Changed IDOC
header records to first of the month to fix periodicity error. Added logic in IDOC to delete entries in
planning table for materials no more required by DSM. Resolved IDOC failures in DSM/SOP interface at
upgrade to 3.1I, 4.6B and 4.6C. Daily monitored IDOC failures, edited and reloaded
- Mentored and extended technical help to co-workers
MAINFRAME: Ø 14 years of IT experience in mainframe and client-server. 1984 – 1998
SKILLS: Ø COBOL,PL/I, CICS, IMS DB/DC, DB2, MICRO FOCUS COBOL, MODEL 204, dBASE/CLIPPER
Ø Statistical Packages: SAS, SPSS, BMD, BMDP, DATATEXT
EXPERIENCE:
Ø Confidential,Northbrook IL: Improved efficiency of insurance applications by 50%
- Confidential,Hammond, IN: Led client/server development for mainframe upload from PC.
- Confidential,Chicago, IL: Implemented banking systems applications.
- Confidential,Oak Brook, IL: Enhanced sales systems.
- Confidential,Oak Brook, IL: Enhanced Sales Reject System.
- Confidential,Long Grove, IL: Implemented Insurance Commercial Line.
- Confidential,Atlanta, GA: Migrated mainframe system to dBase application in PC.
- Confidential,Orlando, FL: Enhanced cost accounting systems.
- Confidential,Chicago, IL: Established statistical support facility.
EMPLOYMENT:
- 1994 - 1998: Confidential,Mountain Lakes, NJ
- 1989 - 1994: Confidential,Oak Brook, IL
- 1987 - 1989: Confidential,Mountain Lakes, NJ
- 1984 - 1986: Confidential,Chicago, IL