SUMMARY

• Over 7 years of IT experience in Business Intelligence and Data Warehousing, Data Migration, Data Cleansing withBusiness Objects Data Services/ Data Quality.
• Installed, configured BOData Services XI 3.2, 4.1,4.2and 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.
• Expertise in BODS, Information Steward, Data governance end to end implementation.
• BODS/Data Qualityin 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/OutofCentral/Local Repository.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor, and error)
• Extensively used Data Services Management Console to schedule and executejobs, 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.
• 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.
• 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.2 SP1, (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),WebIX1 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, Kansas, MO

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
• 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), Datacleanse, 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.
• Working on multiple projects for Data Migration and EDW as ETL developer.
• Data Migration of Master data objects like Customer, Vendor, and Material objects and also Transaction objects like Open AP,AR, Sales Orders, Purchase Orders, GL Account posting etc.
• Experience in source data and Confidential data requirements and mapping using SAP BODS.
• Good in ETL using source systems, data integration, security, data quality.
• Worked on the POC to extract data from SAP Open Hub tables.
• Extracted data from various sources such as SAP ERP, SAP BW, HANA, POS, P2P OTC and other applications to stage on staging database and load to Confidential SAP ECC
• Experience in data migration test cycles and mock cutover for several iterations.
• Worked on building pre-load and post-load validations and generated exception reports
• Used MS Excel and VLOOKUP functions to validate data loads, exceptional reports
• Worked on SAP Data Quality, using data quality transforms to cleanse customers and vendors
• Helped data loads teams in building simple LSMW programs and BDC sessions
• Worked in all SAP Functional module SD/MM/HCM, PP, FSCM, QM, PM and FI .
• Worked on using SAP BODS integration with SAP BW and SAP HANA.
• Build ETL soltuions to ETL data from ECC using SAP BW Data source in SAP ECC to extract data using BODS Data Extractors with ODQ API and ODQMON.
• Post production support for data layering, data fixes

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

Confidential, Chattanooga, TN

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

SAP 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

BODS ETL 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.