CAREER SUMMARY:

• 14 years of experience in leading and delivering projects in Enterprise Data Warehouse,DataMarts & Reporting using software technology specific to SAP - Business Objects Data Services (BODS), SAP- BW/HANA, ABAP, SAP-ECC,SRM,Crm, standard and custom implementation involving all phases of SDLC - Analysis, Design, Development, Testing, Go-live, Support & Maintenance.
• Experience includes 5 years of SAP BODS, 8 years of SAP BW, 1-year of ABAP.
• Experienced working with business analysts, end users and IT management in proposing and implementing solutions using SAP- BI tools.
• Proficient in analyzing and translating business requirements, functional specifications to technical specifications.
• Experienced in data modelling and implementation of Data Warehouse and DataMart’s.
• Experienced in extraction, transformation and loading (ETL) data from flat files, CSV files, SAP- ECC, SRM, CRM SAP-BW/HANA, Microsoft SQL Server Database, and Oracle.
• Experienced leading projects and functional areas individually within specified architectural & delivery frame work.
• Experience in working on projects under multi-vendor management.
• Experience includes full cycle implementations, upgrade projects, support and maintenance projects.
• Performed Job roles of BI Developer, BI System Analyst, Project Lead, Functional Lead, On-Site coordinator.
• Extensively worked on integration of Business Objects Data Services with SAP and Non-SAP Data Sources like Microsoft SQL Server, Oracle, DB2, Mainframes, Flat Files and Legacy System files.
• Experience working with BW-Open Hub Services to extract data from SAP BI to HANA using Data Services.
• Experience in technical upgrade of BODS from lower version 3.X to 4.X
• Expertise in BODS code migration using Check-In/Out of Central/Local Repository.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor, and error) and by examining the target data.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories.
• Involved in design, development, optimization and maintenance of BODS jobs to extract data from various sources to data marts/data warehouse.
• Experience working with ETL using IDOCS, XML files, EDI files, custom functions and stored procedures.
• Extensively worked with ABAP dataflows to extract the data from SAP Applications.
• Created requirement specifications by interacting with business representatives and designed Star schema, logical and physical database designs.
• Created Test Plan document, Test Cases using SQL scripts to perform unit and integration testing.
• Experience working with BODS-Rapid Marts.
• Experience working on Microsoft SQL Server, Oracle and HANA as Database.
• Experience with analysis, design, development, customizations and implementation of standard SAP BW.
• Experience in working with data sources, DTP, transformations, DSO, info cubes, multi providers, OpenHub, APD, info packages, process chains, routines and transport management.
• Experience in working on Front end reporting using BEx query designer -conditions, filters, jump queries, formulas, CKF,RKF,variable exits .
• Experience in working on Extractions- Application extractions, custom extractions, Flat file extractions, and creation of generic data sources, text data sources using tables, views and function module using RSO2 and enhancing standard data sources using exits.
• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation.
• Support Maintenance - Data load management, Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP data extraction and Loading (Full /Delta -Load) in layered EDW architecture, and BW Transports.
• Experience in ABAP coding - creating custom extractor, enhancing data sources using CMOD exits, info pack routines, transformation routines, bex variable exit.

TECHNICAL SKILLS:

ERP : SAP-ECC,SRM,CRM

ETL : SAP Business Objects Data Services(BODS)-3.2/4.2

Reporting Tools : SAP-Business Objects(BOBJ),BW-Bex, Cognos

Database : Microsoft SQL Server(2005,2012),Oracle-11g,HANA1.0

Transport management : SAP-CTS and SAP-Rev Track

Languages : SQL-RDMS, ABAP/4

PROFESSIONAL EXPERIENCE:

Senior Systems Analyst

Confidential

Environment: BODS 3.2 and BODS 4.2, SAP ECC, Microsoft SQL Server (2005 &2012), DB2, Mainframes(iSeries), BO- Rapidmarts, BOBJ 3.1

Responsibilities:

• Worked with directors of WH-operations, e-commerce, Sales and Finance in discovery of operational improvement measures and proposing solution using SAP BODS tool.
• Work with SAP Functional consultants, AutoZone teams for gathering requirements to build new interfaces between IMC and AutoZone.
• Designed and Developed ETL jobs for interfaces and reporting solutions.
• Advance Shipment Notification interface, Inventory feed interface, SAP-Deutsche Bank vendor payment interface, SAP FI-GL Summary to AZ PeopleSoft interface, AutoZone return orders interface, VDP- Vendor Direct Procurement-Interface for Inventory (EDI file ETL)and ASN’s(XML file ETL), AutoZone BREMBO PO to SAP interface,
• Freight reporting ETL Job, WH-Transfer order reporting ETL Job, Sales Force Automation Reports
• BODS Upgrade project - 3.2 to 4.2 version
• Lead phase 1 Upgrade project BODS 3.2 to BODS 4.2 working with external vendor.
• Work on phase 2 Upgrade project (technical upgrade) BODS 3.2 to BODS 4.2.
• Responsible for maintenance and production support activities like load monitoring, planning and executing system outages.
• Fine Tuning of BODS dataflow to ensure full-push down to improve the performance.
• Implemented the control frame work for monitoring the daily loads and generate a report for checking the health of the critical jobs.
• Implemented control frame work for the hourly scheduled loads.
• Supported BOBJ developer and Report users with data lineage requests.

SAP BODS/BW Consultant

Confidential, San Jose, CA

Environment: BODS 4.2, BW7.3onHANA,Enterprise HANA, BOBJ4.1 Tools: HPQC, Share Point

Responsibilities:

• Worked on maintenance and support of BODS&BW data load monitoring and system outages.
• Design and develop BODS job for extracting FI-GL line item data from BW to HANA.
• Completion of tasks assigned as part of Company Split-2CO Project.
• Tasks involved deletion of objects from BODS. Creation and testing of new data store connections, and execution of jobs.
• Testing of connections in IDT, testing BOBJ Webi reports and Dashboard’s.
• Selective deletion of data from info cubes and loading data, reconciliation of data after system copy. Checking the existing views in HANA studio after system copy.

Confidential, Burbank, CA

Environment: BODS 3.2/4.1 BO-Rapid Marts, SAP-BW7.1,ECC,SRM SQL: Embarcadero Rapid SQL (Oracle 11g)

Tools: HPQC,HPSM, Rational

SAP BI Lead/BODS Developer

Responsibilities:

• As BI Lead, was responsible for SLA’s and Project deliveries using the onsite offshore model, Lead team of 3-BW and 1-BODS consultant.
• Work with Onsite Business analysts in understanding the problem statement and identifying solutions using BODS-Rapidmarts.
• As BODS developer responsible for completing the enhancements to the existing BODS-Rapid marts -providing sizing and estimates, writing technical specification, completing development, testing, preparation of data for UAT & SIT, prepare cut over and move to production activities.
• Used BODS Transforms-Case, Table Comparison, Merge, Query, Scripts for variable initializations, creation of jobs, workflows, dataflows and abap Data Flows.
• Used RapidSQL for Oracle DB related tasks.(Table creation, addition of new fields, writing sql to trouble shoot data issues)
• Involved in data load time improvement of BODS Jobs to meet client SLA’s by consolidating the individual jobs removing dependencies using export execution command.
• Involved in upgrade of BODS - 3.2 to 4.1 .
• Prepared Upgrade plan, configured Data Stores, used CMC, managed repositories, completed change of ABAP flows and corresponding R3 programs (change from Generate and Execute to Execute Preload), check out and check in of objects in multi developer environment using central repo, performing testing of jobs, moving objects across QA and Production.
• Responsible for planning and execution of BODS-RapidMart production outage activities in line with SAP ECC production system down time’s. Involved in creation of new job schedules, activation, and deactivation and changing of existing job schedules in DS Management console.
• Completed POC for SAP SRM data extraction using RFC data transfer method and BODS.
• With multi-vendor management in place collaborated with Oracle DB team for space maintenance issues (HCL), XEROX team for server issues, SAP for BODS system issues.
• Pre pared Run Books during KT to new vendor.
• Worked with users and business analysts in new requirement gathering, translate them into technical specifications.
• Responsible for creation and assignments of Task in Rational Tool.
• Participate in CAB meetings.
• OSS notes review and assignment using Panaya tool.
• SPOC for BW/BODS incident management, support and projects.

Confidential, Southbury, CT

Environment: SAPBW7.0, SAP-ECC, CRM, Rev Track BEx,, Cogno’s 8.0.

Tools: Lotus, Rational, MS-Project

SAP BW Functional Lead

Responsibilities:

• As a Functional Lead responsible for areas of FSCM-BD, BW MD, CRM-Channel Partner Management, SD and CRM-IBASE. Own End to End requirements in these areas.
• Tasks involved requirement gathering, feasibility study, perform gap analysis, preparing functional and technical specifications, working with offshore development team in completion of development and work with process team for the UAT and FVT testing completion. Post testing work on move to production activities and hand over to COE team.
• Participated in workshops during blue print phase.
• Participated in establishing the EDW architecture framework.-Data retention strategy, layered architecture, regional data bifurcation.
• Responsible for regional data bifurcation design and implementation.
• Complete POC and demonstrate result to process team and end users.
• Design and developed interfaces using Open Hubs for providing data to downstream systems.
• Involved in establishing the process for addition and changes to master data objects in the SAP N+1 landscape.
• Responsible for resolution of issues during UAT and FVT testing phases.
• Responsible for completing master data loads during cut over and production moves.
• Responsible for hyper care and handover to COE post go live.
• Responsible for performing gap analysis to add local requirements for future roll out after pilot project live.
• Responsible for ECC master data DQ checks using BW-Open hubs.

Confidential

Environment: SAP-ECC,SRM,BW7.0, BW3.5

BW-Developer& Project Lead

Responsibilities:

• Was responsible for handling the BW3.5 and BI 7.0 projects implementation.
• Lead team of 2-ABAP, 1 -Basis,1 -APO, 2-BW consultants.
• Responsible for Task planning, distribution and object delivery.
• Involved in analysis, design, and implementation of BI7.0 project.
• Prepared development framework based on the document provided by SAP field services team.
• Responsible for Transport management using STMS.
• Responsible for documentation.
• Proposed development naming standards, document templates for planning and MOM, efficiently managing onsite-offshore communication and client meetings in conveying the product limitations.

Confidential

Environment: BI7.0

Onsite Test Lead Coordinator

Responsibilities:

• As a lead responsible for planning and creation of processes for the execution of the market test for AsiaAMET regions.
• Responsible for prioritizing, scheduling and allocating tasks.
• Responsible for overall issue resolution process and monitoring issue logs.
• Responsible for the coordination and synchronization of the regional activities with the global implementation team in UK.
• Responsible for leading the regional business analyst’s team.
• Communicate activities and progress to the Business and IT directors of the Confidential -iFinance project.