SUMMARY

• Over 9 + years of IT experience as Developer/Technical Lead in Business Intelligence and Data Warehousing using Business Objects Data Services and Data Quality.
• Installed & configured Data Services XI 3.2 and Upgraded from Data Services XI 3.2 to 4.2
• Expertise in EIM suite tools like SAP BODS, Information Steward, and Data governance end to end implementation.
• Administration of BODS/BOBJ Basis on windows and unix platforms, management console, and CMC
• Expertise in all areas of SAP BW Implementation viz. Modeling, Extraction, Staging, Performance tuning, Reporting, BW Business Content and Transportation of Objects.
• Technically sound in Modeling - Designed and developed Info objects, InfoCubes, Multicubes, InfoSources, DTP, DSOs, Transformations, Multi-Provider, Info Sets
• 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.
• Extensively worked in design of work flows, data flows, scripts and complex transforms using different data integrator, platform and data quality transforms.
• Expertise in BODS code migration using Check-In/Out of Central/Local Repository across the environments.
• 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 and perform metadata reporting.
• Expertise in data warehousing techniques like Slowly Changing Dimensions (SCD) phenomenon, surrogate key assignment and Change Data Capture (CDC).
• 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/DataQuality and DQM solution.
• Worked on Data Governance and Master Data Management using SAP MDM, BO Information Steward
• Prolifically worked on systems support, performance tuning, backup and recovery, space management and maintenance
• Prepared test scripts and test cases to validate data and maintaining the data quality.
• Experience working with 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.
• Excellent communication with exceptional problem solving, including technical writing, presentation and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel.

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/4, ECC 6.0, SAP CRM 7.0, SAP MDM

Reporting tools: Business Objects XI 4.0, WebI, Crystal Reports, Xcelsius

Software/Databases: Oracle 9i/8i/7i,SQL Server 2000/2005/2008 , MS Access 97/2000Data Modeling 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, Shell Scripts, PeopleCode, SQR

Operating Systems: MS-DOS, Windows 7/XP/2000/NT/98, UNIX

Other Tools: PeopleSoft, TOAD, MS Office Products (Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

SAP BODS/IS Consultant

Responsibilities:

• Involved in requirement gathering, analysis,datamodeling and extraction in Database environment using Business Objects DataServices
• 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, MS SQL Server
• 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.0/4.1.
• Performed data assessment, analysis and applied rules in Information Steward.
• Extensively worked on Data Insight and Metapedia 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 XI 4.2 (Data Services ETL), Microsoft Server 2008,2012

Confidential, Atlanta, GA

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 problems are resolved in a timely manner, tracked according to 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, Houston, TX

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 according to 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.2 on 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.
• Also worked as Winshuttle Administrator.
• 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, Winshuttle 10.5, Oracle, Windows 2008 R2 Servers, Windows 7

Confidential, Findlay, OH

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 with business users in development of functional Specification documents (WRICEF) for Master data and Transactional data for SAP FI/CO and Supply Chain Modules -MM,PP,IM,APO
• Worked on activating the standard Business Content InfoCube 0SD 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 Order to Cash 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.

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, Clearwater, FL

Sr. BO Data Services Developer

Responsibilities:

• Sr. BO Data Services Developer/Technical lead for Development on EDW
• Requirements gathering from business users to support the Solution Architecture for EDW.
• Supported the Solution Architect for BODS Technical features to integrate with SAP systems and provide solution to establish the ETL Framework around SAP BODS.
• Involved in meetings with functional users, to determine the flat file layouts, data types and naming conventions of the column and table names.
• Defined Data Stores to allow BO Data Services to connect to the source or target database.
• Developed ETL jobs to move data from multiple sources to Enterprise Data Warehouse
• Installed & configured Data Services XI 3.2 SP1 in Development & Production Server.
• Developed jobs by extracting the SAP R/3 tables and loaded into staging area and done transformations that apply the business rules provided by the client requirement and loaded the data into the target SQL Server Database.
• Worked with tables involving Hierarchies and resolved them using Hierarchy flattening whenever required.
• Implemented use of SAP ABAP dataflows to extract data from SAP Applications ECC, BW etc..
• Performed data assessment, analysis and applied rules in Information Steward.
• Developed integration between different systems (Siebel, BW, SAP, SQL Server, MS Access )
• Performed different types of Delta logics and worked on Change Data Capture (CDC) on both Source and Target level for Slowly Changing Dimension (SCD) Type 1, Type 2 and Type 3.
• Implemented Delta recovery solution for failed objects like auto-recovery etc..
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, data flow’s and targets in order to provide maximum efficiency and performance.
• Involved in writing DI scripts and also used some built-in function like Lookup ext and Custom Functions like sending Email via SMTP for error notification and exception handling.
• Developed unit test and integration test cases to cover all the business scenarios.
• 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 Business Object Data Services XI 3.2 SP1 (Designer, Repository Manager, Management Console, Server Manager), SQL Server 2008, JD Edwards, Windows 7

Confidential, Waukegan, IL

Sr. BO Data Services Developer

Responsibilities:

• Lead Developer for Proof of Concept of Consumer Master data cleansing and data migration using SAP Business Objects Data Quality for SAP CRM
• Evaluated the existing architecture on Unix AIX and DB2 database environment, identified issues, missing components, proposed resolutions and fixed issues around the sizing, security and performance.
• Gathered requirements for (Consumer) Customer Master data cleansing for Accounts, Contacts and Addresses for Canadian records
• Worked on setting up Siebel integration with BO Data Services for data extracts.
• Installed address directories, cleansing packages for US and Canadian data and additional components for address directories in BO Data Quality.
• Cleansed and standardized the consumer data and build the address keys and contact keys for de-duplication using sound-ex and break key techniques.
• Provided the cleansed data to load data into SAP CRM to ABAP resources using LSMW
• Worked on integration of BO Data Services to SAP CRM application by setting up the RFC connection for extracting and loading data for SAP CRM using BO Data Services.
• Setup real-time address cleansing interface using SAP BO Data Quality packages and required connections parameters and address BADI integration at POC level.
• Setup the ABAP data flow for data extracts and setup the Unix shared directories for data loads and ABAP programs for SAP CRM and IDOC interface with BO Data Services.
• Build Data Cleansing and Data Governance organization approach and methodology to identify KPI’s and Metrics around data objects and report out.

Environment: Business Objects Data Services XI 3.2 (Data Services/Data Integrator-ETL), Siebel CRM, SAP CRM 7.0, Unix AIX 6.1, DB2 V9.5

Confidential, OKC, OK

Sr. BO Data Services Consultant

Responsibilities:

• Sr. BO Data Services Consultant for SAP Data Migration project.
• Mentoring and co-coordinating with offshore team on business queries, reviewing and guiding on the technical implementation of team at off-shore.
• Troubleshooting BODS connectivity issues with source systems and SAP BAPI integration.
• Extensively worked on AIO (All In One) methodology, SAP preferred Data Migration methodology
• Developed a code migration methodology for SAP BODS across Dev, Test, Prod landscape
• Guide the client team in establishing the dependencies on the data load objects, and preparing project plan with dependencies and cut-over strategy
• Creating a load structure which can feed to SAP- LSMW loads.
• Closely interacted with SAP load team to fix the load errors at ETL end.
• Creating dynamic error report on error data and analysis to provide inputs to business.
• Created reusable BODS code components to load data from legacy source to SAP ECC.
• Created temples for loading data to SAP-LSMW and held tight integration for AIO BAPI objects
• Managing development team to adhere to project schedule and optimize the resources for quick turnaround on bugs and testing.
• Analyzed the session, event and error logs for trouble shooting mapping sessions.
• Created test cases for carrying out unit testing and part of functional testing.
• Worked with Variables and Parameters in the mappings to pass the values between sessions
• Responsible for documentation, version controlling of schema and version releasing.
• Prepared Data Migration cut-over plans, mock data loads, performance improvement initiatives

Environment: Oracle 10g, Oracle, Informatica 8.6, Windows 2000,TOAD,SAP ECC.

Confidential, Telford, PA

ETL/BODS Developer

Responsibilities:

• Sr. BO Developer for BODS ETL Devlopment on EDW and Reporting team
• Performed extensive data analysis to support business decisions, provided data solutions by performing Risk and Gap Analysis.
• Good understanding of the SAP FI, HR, Supply Chain Management (SCM) data models and business processes involved in SAP.
• Worked on SAP Business Objects RapidMarts
• BO-DI ETL Developer for data extraction from EDW
• Worked on data extraction (ETL) from the EDW of SAP BI reports, SAP ECC6.0 transaction data of SAP FI, HR and SCM (Sales and Inventory) using Business Objects SAP RapidMarts
• Worked with SAP Data Source drivers such as SAP R/3, SAP BW
• Extensively used ETL - Business Objects Data Integrator tool
• Developed Batch Jobs and Realtime jobs, with IDOCs
• Worked on BODI-Transforms; Query, Row Gen, Key Gen, Date Gen, Merge, Case, Pivot, Reverse Pivot, R/3 Data Flow, Data Transport, CDC, Hierarchy Flattening, Table Comparison, History Preserving, Data Transfer etc….
• Worked on Crystal Xcelsius for complex reports on multidimensional parametric reports
• Active involvement and established some process improvements for increased efficiency in the analysis and delivery of reports.
• Provided SAP users the functionality of scheduling and distributing reports on BO WEBI
• Involved in Migration of Repositories from Development, Test and Production
• Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.
• Developed and designed the process flows for various SCM reporting needs.
• Performed data analytics using MS Excel, automated the report formatting with macros.
• Extensively worked on MS Access to generate the Ad hoc reports.
• Developed complex reports in business objects (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Created user Prompts, Conditions and Filters to customize the report generation
• Used Alerts to improve the readability of the report. Extensively used Calculations, Variables, Drill down, Slice and Dice, Alerts in the creation of reports.
• Involved in the installation and configuration of BO XI R2 Desktop Intelligence.
• Involved in upgrading and troubleshooting of Migration of BO 5.1 reports to BO XI.

Environment: Business Objects Data Services XI 3.1, Business Objects 5i/XIR2, Business Objects Info View (WEBI), Oracle 10g, SAP R/3, ECC 6.0, BW UNIX, WindowsXP, Rapid SQL, Web logic

Confidential, Jersey city, NJ

ETL /BO Reporting Developer

Responsibilities:

• Responsible for design, development and extraction from SAP R/3 4.3 system and develop Flat File to match the LSMW and BAPI codes
• Extensively worked on BODI Master Data cleansing to load data into SAP R/3 using LSMW
• Extracted data from SAP R/3 MM, SD and FI modules for data cleansing and informatica for Vendor Master, Customer Master, Material Master and other Master Data objects.
• Involved in Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Reporting for the MM, SD, and FI/CO modules using DI.
• Worked with ABAP developers to load the data using LSMW in Dev, QA and Production
• Involved in requirement gathering and data analysis for reporting from business users.
• Major involvement in tuning the mappings, to perform maximum efficiency
• Created Universes, Classes and Objects. Created and BO Administration
• Created objects (dimension, detail, condition, measure).
• Involved in development of reports like Account Analysis Reports, Cost-Detail reports
• Involved in writing the Detail Level Documentation for most of the reports.
• Involved in deploying the reports to the Repository through Broadcast Agent Server.
• Defined the Custom Scope of Analysis for the Development of Drillable Reports.
• Analyzed and Explored reports using Slice and Dice and Drill Down functionality.
• Automated document Scheduling, Publishing and Distribution for WebI and Info view
• Involved in Integration of the Reports to the portal from Repository.

Environment: Business Objects Data services XI3.1 Accelerated 11.7.2.2,Business Objects XI R2(Supervisor, Designer, Reporter), WebI, Crystal Report 2008API, Xcelsius 4.5,DB2,MS Access, Windows 2000 Server, Unix, Oracle 9i, SQL*Plus, PL/SQL, TOAD, Erwin 3.1.