SUMMARY:

• Over 6 years of IT experience in Business Intelligence and Data Warehousing, Data Migration, Data Cleansing with Business Objects Data Services/ Data Quality.
• Installed, configured BO Data Services XI 3.2, 4.1,4.2 and Upgraded Data Services XI 3.2 to 4.0, 4.1 to 4.2
• Extensively worked on integration of Business Objects Data Services with SAP MODULES (Finance, HR, RMCA, and GTS) and Non - SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2014/2012/2008 r2/2008, Flat Files and Legacy System files.
• BODS/DataQuality 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 approach using Check-In/Out of Central/Local Repository.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor, and error)
• Extensively used Data Services Management Console to schedule and execute jobs,Manage repositories and perform metadata reporting.
• Expertise in data warehousing techniques for data cleansing, Slowly Changing Dimensions (SCD) surrogate key assignment and Change Data Capture (CDC), Data Modeling
• 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.
• Hands on Knowledge on Data Quality concepts and familiarity with setting up Data Cleanse, Address Cleanse, Match and Associate transforms.
• Batch Jobs: Experience in Batch Jobs and CDC functionality with SAP extractors
• ODQMON: Experience on ODQMON flow with SAP extractors
• BI/BW Administration Workbench: Good Knowledge in designing and maintaining DSO objects, Info Objects, Transformations, Data Transfer Process (DTP), Info Sources, Info Packages, DataSources and Monitoring, Open Hub Destinations and Analysis Process Designers.
• Process Chains: Good experience in process chains, trouble shooting and maintenance of process chains in various SAP BI projects.
• Datasource Enhancements: Good knowledge on enhancement of DataSources in SAP R/3 and enhancement of Business Content in SAP BI/BW.
• R/3 Extraction: Worked on data extraction from SAP R/3 Data Sources using LO Cockpit and Generic Extractors, as well as from non-SAP Sources like SQL Server and Flat files.
• BI/BW Data Loading: Experience in Delta and Full Uploads using Process Chains and Info Packages to automate data loads into BI/BW.
• Open Hub Services: Worked on exporting data to various third party applications, like SQL Server etc., through database tables, flat files and third party tools.
• Handled all the BI activities as part of SAP EhP6 upgrade, BW activities in BW upgrade for 7.4
• My experience includes system support, performance tuning, backup and recovery, space management, maintenance and troubleshooting.
• 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.2(Information Steward, IPS), SAP BODS XI 3.2SP1, (Designer, Repository Manager, Management Console, Server Manager), XI 3.1, XI R2 (11.7.2.2)

SAP: SAP ECC 6.0, SAP CRM 7.0

Reporting tools: Business Objects XI 3.1 (Central Management Console, Central Configuration Manager, Central Management Server, LSMW, Import Wizard, WebI, Designer, InfoView, Performance Manager, Dashboard Manager), Business Objects Data Integrator, Business Objects 6.5 (Reporter, Designer, Supervisor), Broadcast Agent (Document Agent/Publisher), WebI X1 3.1/XI R2/R1,Crystal Reports XI R 2/10.0/9.0/8.0, Live office.

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

Data 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, People Code, SQR

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

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. BO Data Services/SAP BI Developer

Responsibilities:

• Installing and maintaining the SAP Business Object Data Services 4.2 support pack 3, and Data Quality Components for Cleansing packages
• Installed & configured Data Services and Upgraded from Data Services 4.1 to 4.2
• Experienced with SAP RMCA and SAP GTS modules.
• Experienced in connecting SAP BI7.3 and ECC 6.0 to SAP BODS 4.2
• Configured ODP Objects 0FC INVDOC 01, 0FC PAY and 0FC INVDOC 02 in RMCA Module.
• Configured DataStore for GTS modules and worked on the GTS extractors Header and Item data
• Worked on integration of BO Data Services to SAP ECC application by setting up the RFC connection for extracting and loading data for SAP BO Data Services.
• Developed Flat files data extraction from SAP ECC and loaded the Data into the SAP ECC
• Worked on the POC to extract data from SAP Open Hub tables and Implemented Solution
• Worked on the POC to extract data by using standard ECC extractors and load to EDW
• Build solutions to extract data for various data objects FI-GL, FI-AP, FI-AR data from SAP ECC and SAP BW to load the Staging for downstream reporting.
• Extracted the GL data from open hub tables in BW to provide to downstream BI
• Worked extensively with ABAP dataflows, ECC Extractors and ABAP developers to work through the development and issue resolutions
• Worked with BAPI/IDOC integration using BODS to Extract or Load data.
• Used Complex SQL and ETL Transformation for Data migration Process.
• Analysis and Development of the requirements with the business users and write ETL technical specifications and Designed ETL Templates.
• Used Complex SQL and ETL Transformation for Data migration Process.
• Supporting the post go-live activities on all the BOBJ objects Master and Transactional.

Environment: SAP Business Objects Data Services 4.2, SAP ECC 6.0, SAP BI 7.3, and SQL Server 2014

Confidential, Columbia, MD

SAP BO Data Services/SAP Data Migration Developer

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
• Configured the SAP BI7.0, SAP 4.6C and ECC 6.0 Data Store connection to SAP BODS 4.0
• 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 Dataflow 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.
• 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.
• Extensively worked on the Data Quality features using Geo-Coder and Global Address Cleanse
• 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, MN

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, PA

Sr. BO Data Services Developer

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.