SUMMARY

• Over 15 + years of IT experience, 12 years of SAP ERP, 5 years in Business Intelligence and Data Warehousing using Business Objects Data Services and Data Quality.
• 10+ SAP implementations, Upgrades and support projects in SD/MM/FICO/ABAP areas.
• Installed & configured Data Services XI 3.2 and Upgraded from Data Services XI 3.2 to 4.2
• Expertise in EIM suite tools like SAPBODS, Information Steward, and Data governance end to end implementation.
• Administration of BODS/BOBJ Basis on windows and Unix platforms, management console, and CMC
• Experience in Performing column profiling, address profiling, dependency profiling, redundancy profiling, uniqueness profiling, creating complex validation rules, rule bindings, defining rules task and view results
• Heavy ETL (Extract, Transform, and Load) and Data Profiling experience from source systems including Flat Files, Legacy systems and SAP using SAP Data Services (BODI/BODS 3.x/BODS 4.x)
• Experience in implementing and testing of Stored procedures, Views, Packages, Database triggers, cursors, functions at database level using PL/SQL
• Performed Data Extractions from SAP - R/3 to SAP-BI using Extraction methods like LO Cockpit and Generic for SD and MM Modules, Business Contents Extraction from Generic Data Sources like Views/tables
• Extensively worked on integration of Business Objects Data Services with SAP MODULES (Finance, HR & CRM), SAP MDM and Non-SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2008/2005/2000 , DB2, JD Edwards Mainframes, Flat Files and Legacy System files.
• Expertise in BODS code migration using Check-In/Out of Central/Local Repository across the environments.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Expertise in BODS Change Data Capture
• Involved in design, development, optimization and maintenance of BODS jobs to extract data from various sources to data marts/data warehouse various SAP modules through IDOCS.
• Experience in working with ABAP dataflows to extract the data from SAP Applications.
• Expertise on Data Quality Solution Data Cleanse, Address Cleanse, Match and Associate transforms using US Postal Soft, Cleansing packages, Global Address directories.
• Used BO Information Steward to integrate with SAP BODS/Data Quality and DQM solution.
• Worked on Data Governance and Master Data Management using SAP MDM, BO Information Steward
• Worked on different optimization techniques like push down operations, parallel execution, Partitioning and indexing for improving the performance of the job
• Prepared test scripts and test cases to validate data and maintaining the data quality.
• Experience working with SAP BW Open Hub Services to push data out of SAP BI using Data Services.
• Configured the Data services to connect to the SAP R/3, CRM and BI
• Have thorough knowledge on Legacy System Migration Workbench (LSMW).
• Ability to understand the business environment and translate business requirements into technical solutions.
• Define business, financial and operations requirements and system goals working with decision makers and end users, analysing and translating business needs to technical requirements.
• Lead and analyse design sessions in prototyping new systems to enhance business processes, operations and information process flows, tools, methodologies and standards for requirements gathering, documentation and analysis, Experience with ENH packs, System Upgrades, OSS notes.
• ALE/IDOC administration, Parallel Processing of Dialog/Background Jobs, SPTA Framework.
• Expert in SAP ECC - OOPS Programming, Workflow, Interface design - RFCs, BAPI, BDC, Call Transaction, LSMW, ALV, SAP Script/Smart/Adobe forms, Data Dictionary design, expertise in ABAP debug and SQL tracing tools, BTE, User Exit, BADI, Enhancement & Switch Framework.
• PI sustainment support includes the monitoring, enhancement and optimization of external interfaces, SXMB MONI, PI Interfacing, PI Inbound/outbound proxies.
• Instant traceability with impact analysis and data lineage capabilities that include the data quality process
• Broad source and target support applications (for example, SAP), databases with bulk loading and CDC changes data capture

TECHNICAL SKILLS

ETL tools: SAP BO Data Services 4.x(Information Steward, IPS), SAP BODS XI 3.2 Data Quality, Data Insight, Data Federator, SSIS.

SAP: SAP R/3, ECC 6.0, SAP CRM 7.0, SAP MDM

Reporting tools: Business Objects XI 4.0, Web Intelligence, Crystal Reports, Business Objects Dashboards (Xcelsius)

Software/Databases: Oracle 9i/8i/7i,SQL Server 2000/2005/2008 , MS Access, MySQL

Data Modelling: Erwin 4.0/3.5, Oracle Designer 2000/6i

Databases, Tools & Utilities: Oracle 11g/10g/9i/8i/8.0.5, SQL Server, DB2, IMS, SQL*Plus

Languages: SQL, PL/SQL, C, C++, Java, HTML, XHTML, Shell Scripts

PROFESSIONAL EXPERIENCE

Confidential, TX

SAP BODS/IS Consultant

Responsibilities:

• Involved in requirement gathering, analysis,datamodelling and extraction in Database environment using Business Objects DataServices
• Worked with Rapid deployment solutions for Initialize/Load the data for Lookup tables.
• Designed complex SAP Data Services job flows to extract from/load to SAP systems such as SAP ECC, BW, HANA as well as non-SAP systems such as Oracle, MS SQL Server
• Experience with DI transforms such as Query, Validation, Case transforms as well as DQ transforms such as Match, Associate, Data Cleanse & Address Cleanse.
• Configured DS components including job server and repositories.
• Setting up DS data stores to connect to variety of data sources such as SAP HANA, SAP R/3, SAP BW, Oracle.
• Established Data Governance around SAP Master Data objects like Customers, Materials, Vendors etc. using SAP BODS/BO Information Steward/DQM
• Performed Source data assessment and identified the quality and consistency of the source data by using Information Steward.
• Installed BO Information Steward, cleansing package, address directories, dashboards and Integration to BODS 4.2.
• Performed data assessment, analysis and applied rules in Information Steward.
• Extensively worked on Data Insight and Matapedia modules in Information Steward.
• Installed address directories, build cleansing rules logic to BO Data Quality.
• Worked on extracting the data from ECC 6.0 and loaded into BW 7.0 using Data Services XI 4.0 SP1 as an ETL tool for Data Quality.
• Involved in working with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality and Prepared test scripts and test cases to validate data and maintaining the data quality.
• Worked on Data Quality transforms like Global Address Cleanse, Data Cleanse, Match, Associate, Country id, USA Regulatory Address Cleanse for Profiling and Cleansing
• Fine tuning jobs for high volume and complex transformation scenarios
• Good Experience of SAP Information Steward Components like Data Insight, Metadata Management, Metapedia and Cleansing to create data quality rules and dictionaries to standardize the data
• Developed and executed advanced data profiling, data validation scenarios. Building IS scorecards and custom Business Objects reports for Data Quality reporting
• Prepared ETL technical design and Source to Target mapping documents.
• Developed jobs to extract data from SAP Extractors & Tables

Environment: SAP Business Objects Data Services 4.2 (Data Services ETL)

Confidential, Coppell, TX

Sr SAP BODS - Information Steward Consultant

Responsibilities:

• SAP BODS and Information Steward Consultant for development of solution around Master Data for implementing Data Governance platform, support data migration, data warehousing solutions
• Upgraded and maintaining the SAP Business Object Data Services XI 4.2, and Data Quality Components for Cleansing packages
• Configured the SAP BI7.0, SAP 4.6C and ECC 6.0 Data Store connections to SAP BODS 4.2
• Defined Data Stores to allow Data Services to connect to the source or target database.
• Created new mappings and updated old mappings per changes in Business logic.
• Designed Jobs and Complex Workflows and Dataflow for ETL to Enterprise Data Warehouse
• Worked on developing BODS ETL code for initial, historical and delta loads to EDW.
• Established Data Governance around SAP Master Data objects like Customers, Materials, Vendors etc. using SAP BODS/BO Information Steward/DQM
• Worked extensively on Address Cleanse (USA Regulatory certified address cleanse), Data cleanse, match transforms (Firm address match batch) for cleansing the legacy records in Customer Master, Material Master and Vendor Master tables.
• Extensively worked on the Data Quality features using Geo-Coder and Global Address Cleanse
• Performed Source data assessment and identified the quality and consistency of the source data by using Information Steward.
• Extensively worked on Data Insight and Metapedia modules in Information Steward.
• Support definition of Data Quality metrics, and will perform Data Profiling and Cleansing
• Administered the SAP BODS/IS/BOBJ systems.
• Successfully upgraded from SAP BODS/IS 4.1 to 4.2on clustered environments.
• Used Central Management Console for Creating users and user groups, restricted access of the users.
• Responsible for the administration of the SAP systems, this includes installations, upgrades, performance, security, sizing, support, system copies and connectivity.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: SAP EIM Suite, SAP Business Objects Data Services 4.x, SAP Information Steward 4.x, SAP BOBJ 4.1 SP4, SAP R/3 4.6C, SAP ECC 6.0, SAP CRM 6.0, SAP BI 7.0, Win shuttle 10.5, Oracle, Windows 2008 R2 Servers, Windows 7

Confidential, Radnor, PA

SAP BODS Consultant

Responsibilities:

• Gathered Business Requirements with the Business users, involved in the Analysis, Design, Development and Production phases of the projects.
• Work with database technologies like Microsoft SQL Server 2008 R2, Oracle 11g and SAP HANA 1.81.2
• Worked on Flat Files and Tables (SAP and Non-SAP) as sources and loaded into the EDW.
• Extensively worked on delta type 1, type 2 loads to EDW.
• Position responsible for monitoring and performance tuning jobs.
• Position is responsible for ensuring each reported problem are resolved in a timely manner, tracked per standards, and escalated problems are resolved as appropriate.
• Extensively used ETL to load data from central Data Warehouse into Data Marts.
• Work with Engineering team to build proof of concept to use as templates to extract data from SAP sources using standard and custom SAP BI extractors and ABAP dataflow
• Build a batch processing control mechanism using ETL control schema on target SQL
• Successful proof of concept delivery with optimized setup of BODS extraction programs
• Lead 3 SAP BI/BO EDW projects from concept to delivery with full lifecycle projects
• Migrated data objects from SAP BI 3.5/7.0 to a new SAP BODS 4.0 extraction.
• Worked extensively on troubleshooting the implementation of the Custom Extractors using SAP BODS for SAP CC/CI and OER modules.
• Successfully resolved several issues by closely working with SAP on the SAP BI extractor integration to BODS on the ODQMON (operational delta queue monitoring)
• Optimized SAP BI extractor designs to extract Millions of records for full and delta extracts to work in conjunction with SAP BODS extraction.
• Developed custom BODS recovery mechanisms to recover failed delta extracts
• Supported in resolution of critical SAP BI issues in production.
• Build a support organization for production, on-boarded resources
• Installed SAP BODS 4.1 on sandbox and evaluated to build a roadmap for upgrade.

Environment: SAP Business Objects Data Services XI 4.2(Data Services ETL), SAP BI 7.0, SAP HANA SP7, ECC 6.0, Microsoft Server 2008,2012

Confidential

Senior OTC Systems Analyst/ CRM Data Migration Consultant

Responsibilities:

• BO Data Services Developer/Administrator working on Data Conversion and Data Migration Project for upgrading SAP R/3 4.6c to SAP ECC 6.0
• Build Data Migration Strategy, Cut over plan and reconciliation process for Data Conversion
• Installing and maintaining the SAP Business Object Data Services XI 4.0, and Data Quality Components for Cleansing packages
• Analysis and Development of the requirements with the business users and write ETL technical specifications and Designed ETL Templates.
• Worked on activating the standard Business Content InfoCube0SD C03 Sales Overview, 0PUR C01 Purchasing Data and 0PUR C02 Vendor Evaluation.
• Developed Flat files data extraction from SAP R/3 4.6 and loaded the Data into the SAP ECC
• Worked with SAP R/3 4.6 Data Migration team to build flat files that support the LSMW and BAPI and BDC programs.
• Developed flat files from SAP R/3 4.6 to troubleshooting the errors in Dry run and Integration test
• Used Complex SQL and ETL Transformation for Data Migration Process.
• Supporting the post go-live activities on all the BOBJ objects Master and Transactional.
• Extensively worked on R/3 Dataflows to extract data from SAP R/3 and SAP ECC 6.0 for lookups to cleanse and load Customer Master Data in OTC Cycle and CRM modules.
• Gathered requirements for Cleansing the Customer Master with the business rules and facilitated mapping for data migration to SAP ECC 6.0 from SAP R/3, E-Selling Web Customers etc.
• Developed the roadmap for data governance organization to support SAP MDM and data stewards using SAP MDM
• Worked on SAP MDM (Master Data Management) in integrating to SAP ECC/CRM systems.
• Installed BO Information Steward, cleansing package, address directories, dashboards and Integration to BODS 4.0/4.1.
• Daily usage of ETL tools such as SAP BODS, LSMW, IDOC’s etc.
• Developed Batch Jobs to in corporate the Cleansing rules for Cleansing the Customer Master Data using Data Quality to check for Completeness, Conformity, Consistency and Cleansing.
• Developed and customized the De-Duplication reports, before and after reports using BODS to delegate the reports timely across to global regions.
• Contributed in loading data from various data sources like Oracle, SQL Server, SAP R/3 4.6, Fixed Width and Delimited Flat Files, MS Access & XML Files.
• Specific responsibilities include the support of the SAP functional areas in Finance (FI/CO), Sales and Distribution (SD), RRB, Revenues & Earnings and related applications.
• Responsibility for day-to-day procedures related to the identification, prioritization, and resolution of SAP and related application problem tickets, including the monitoring, tracking, coordination, and resolution of SAP support tickets
• Custom enhancements of the MM, SD, PM, FI, WM modules, CRM WebUI, Enhancements with EEWB, AET, SAP CRM Middleware.
• Developed SAP ABAP programs, ABAP WebDynpro using ABAP objects. Also, done Migration of existing Smart Forms to PDF forms, used FM GM RRB RUN.
• Custom Fields in MIGO/MIRO - MB MIGO BADI/MRM ITEM CUSTFIELDS validation to check an accounting document OB28, various call up points substitution via OBBH pricing in purchasing documents. - BADI ME DEFINE CALCTYPE
• Creating Context-Based Adaptations and Enhancing, Adapting FPM Applications on SAP
• Used explicit configuration to assign additional WebDynpro components as user specific
• Views using UIBBs - FPM LIST UIBB, FPM FORM UIBB, FPM TABBED UIBB
• Create actions for the views and implement simple event handlers
• IDOC: The remittance advice text is preceded by <7XX> and is referred to as 700 remittance advice text in IDOC (IDOC - PEXR2002, Message Type - REMADV) and Payment IDOC (IDOC - PEXR2002, Message Type - PAYEXT).

Environment: SAP Business Objects Data Services 4.0, SAP R/3 4.6C, SAP ECC 6.0, SAP CRM 6.0, SAP BI 7.0, Oracle, Windows Servers 2003(Servers)

Confidential

Senior SAP OTC Systems Analyst

Responsibilities:

• Developed new layout set for shipper declaration of dangerous goods both Air and ocean and created new print programs which will be executed from delivery output type ZOHZ
• Actively Involved System preparation, OSS notes, SPDD, Upgrade of the System and SPAU Phase, testing of critical Business processes and Post upgrade activities so that the business continuity after the upgrade is ensured.
• Testing of Batch jobs using Autosys and Post upgrade activities so that the business continuity after the upgrade is ensured.
• Developed several SAP adobe Interactive and classical reports required for production planning/ sales, which includes information on inventory, material transfer, order volume, freight carrier payments and sales requirement, Workflow modifications.
• Developed Interfaces in ABAP for sales orders in SD and invoice outbound to vendors
• Designed and Developed Zebra Barcode Label to print barcode label. The label/card displays basic material information and a barcode.
• Developed a customized PDF form for Payment advice (F110) from F110 AVIS INT via FBZP.
• Developed outbound and inbound interfaces, BDC programs for custom-defined tables, Master Data Management like LSMW, BDC Data Conversions and ABAP Web Dynpro using ABAP OOPS.

Confidential

Senior Systems Analyst

Responsibilities:

• Developed ALV interactive report like CS12 that identifies spare parts in a Bill of Material (BOM).
• Developed a BDC program to upload the Material Master (MM) data and to upload Physical Inventory (PI) data, Master Data Management like LSMW, BDC Data Conversions.
• Modified existing Smart form for Goods Receipt slip to include Delevan specific information.
• Designed and Developed Zebra Barcode Label to print barcode label. The label/card displays basic material information and a barcode.
• Created/Modified existing Smart forms for Order Acknowledgment, Repair Quotation, Free-of-Charge types.
• Developed a Sub screen tab in Customer/Vendor transactions to store and access multiple customer Shipment Account numbers for each customer.
• Developed custom transactions, screens and programs which enable the use of RF (Instrument) transactions (LM01) for processing Goods Receipt for Purchase Order, put away of Purchase Order, Transfer Stock, Picking for Production Order, Material Inquiry and Picking for Sales Delivery.

Confidential

Senior SD/MM Systems Analyst

Responsibilities:

• Developed Technical specification documents for Developing Field Stock Automation Screen.
• Developed Module Pool Programs, Transaction and function modules to Process Material Bundles in Field Stock Automation custom screen.
• Each Bundle contains several materials with different product hierarchy levels.
• Developed a Drill-Down Report to display State, County, Tax Code, City, Tax Jurisdiction and Tax Base, Tax percent, State Tax, County tax, City tax, etc.
• The report data is derived from accounting documents posted against the Use Tax Payable account, specified in the selection screen.

Confidential

Senior BCS/BW Technical Consultant

Responsibilities:

• Developed a smart form to print, Material, Supplier code, manufacturing date, material description, etc., on a bar coded label after packing the material in outbound delivery.
• Modified the existing print program for displaying delivery number in bar coded tags.
• Converted delivery note SAP script into smart form.
• Created a report to indicate delivery quantity, storage location, available quantity, picking quantity for each item in a delivery.
• Involved in generating Interactive Reports to give details on sales order, vendors, customers and stock for a material.