SUMMARY:

• Over 9 years of experience in IT highly emphasized on Data Integration and Data Quality, DBMS, SAP Business Object Data Services (BODS/BODI) along with Business Intelligence.
• Experience in integrating BODS with SAP ECC and non - SAP data sources (RDBMS) like Microsoft SQL Server, DB2, Sybase, MySQL and Oracle 12c/11g/10g/9i.
• Installed and configured the Business Objects Data Services XI 3.2/v4.0/4.1/4.2, with SAP BI, ECC AND CRM.
• Experienced in analysis and development of ETL flow design using BODS .
• Worked on migration of data from one environment to another environment (from SAP BI using BODS and Open Hub services) and experienced in push down of data in BODS.
• Worked extensively with Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting as per the business requirements.
• Experienced in designing, creation and implementation of several projects, jobs, scripts, Work Flows, Data Flows, Data stores, transformations, functions, variable, tracing debugging and migration of data across different environments.
• Performed dependency profiling, redundancy profiling and uniqueness profiling using Information Steward for Data Profiling.
• Experienced with working on Change Data Capture on both Source and Target level for Slowly Changing Dimension(SCD) Type 1, Type 2 and Type 3.
• Used SAP Business Objects and Data Services as an external system for ETL(Extraction, Transformation and Load) between ECC and BI.
• Involved in Design, development, optimization and maintenance of Business Objects Data Integrator jobs to extract data from various source systems to data marts/data warehouse various SAP modules through IDOCS.
• Loaded data into Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS by referencing SAP AIO jobs.
• Experienced in resolving the performance issues during report development and Data Integrator Data Flows dat have complex SQL queries.
• Strong debugging and problem solving skills and an ability to translate user requirements into specific technical solutions by using business insights.
• Self motivated, Excellent Communication and Interpersonal skills, TEMPeffective Organization skills and efficient time management ability, able to handle multiple tasks and work well in a team environment.
• Capable of working as a member of a team or individually with minimum supervision. Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

ETL TOOLS: SAP Business Objects Data Services 4.2/4.1/4.0/XI 3.2 SP1/ XI 3.1

EIM TOOLS: Information Steward 4.2/ 4.1/ 4.0 SAP R/3,Oracle 12c/11g/10g/9i, Microsoft SQL Server 2012/2008 R2/2008/2005, Sybase

LANGUAGES: SQL,C, C++, C# .NET, PL SQL,MY SQL

REPORTING TOOLS: Business Objects (4.0/4.1/4.2/XI 3.1/6.5),Business Objects Data Integrator,Crystal Reports XI, SIA

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr.SAP Business Objects Data Services Consultant

Responsibilities:

• Involved in Performance tuning of BODI extraction programs and decreased the time for execution of expensive jobs
• Performed installation and configuration of Data Services in Development and Production Centre.
• Configured Data Services to connect to SAP R/3
• Gathered and documented all functional requirements and converted them into technical specification documents.
• Based on Data Governance requirements of a Project Business Validation rules and audit functions were defined.
• Involved in meetings and worked with ATR team to migrate data into FIXED ASSETS Master Data and Transactional Data (Account payable and Account receivable).
• Defined file formats and data stores in database to allow Data Integrator to connect to the source or target database and files.
• Worked extensively with Match transforms, Address cleanse and Data Cleanse Transforms for US Data Cleanse in Data Quality.
• Created Jobs, Work flows, Scripts and Data flow.
• Worked extensively with flat files like .txt, .csv, .xls by creating file format in Data Services.
• Worked on Change Data Capture on both Source and Target level for Slowly Changing Dimensions(SCD).
• Converted information from SAP modules into different data bases and also in different environments which includes manufacturing, material master, basic data, FICO, mdm, sales data, purchasing and work scheduling.
• Developed complex mappings utilizing built in Data Integrator Functions including pivot, reverse pivot, table comparison, history preserving, map operations and SQL transforms.
• Worked with Information steward in data profiling for maintaining the uniqueness of data.
• Created Data Quality Scorecards using Information Steward for maintaining the data.
• Created validation rules in Information Steward for data profiling.
• Extensively used Join (Inner join and left outer join) and other functions in query transforms for joining different types of data in data services.
• Developed and delivered technical mapping documentation.
• Migrated all ETL Jobs and Data Base (Microsoft SQL server and Staging) into Production from Development Environment.
• Involved in linking Job servers on different machines to a single repository for load balancing using the Data Integrator Server Manager.
• Responsible for testing and debugging various ETL jobs.

Confidential, South Carolina

SAP Business Objects Data Services Consultant

Responsibilities:

• Interacted with users to analyze the changes for improvements requested by the users in the existing reports and developed reports to satisfy their needs and requirements.
• TEMPEffectively participated in Data Mapping Workshops and follow up meeting with the client and IT teams. Interacted with the technical teams in gathering the server information of where to install the Job Server.
• Performed installation and configuration of SAP Business Objects Data Services on Linux job server. Installation of Data Services XI 3.2 on windows server and migrated reusable objects from central repository.
• Data mapping and analysis of Gap between source and target data in BODS as per the blueprint.
• Worked on transforming existing data onto Oracle DB using tools such as Microsoft SQL server 2008 and BODS.
• Created and modified new data services jobs and mappings, update of the old jobs and mappings in accordance with the changes in Business logic/ to meet the project requirements.
• Extracting Data from different sources like flat files, excel, SQL tables etc., and loading them into requested target flat files, excel sheets, SQL tables in Data Integrator.
• Worked with various transformations like Query, Key Generation, Pivot, Map operation, Table Comparison, Hierarchy Flattening etc
• Implemented validation rules using Data Services to improve the quality of the data in warehouse.
• Created the Data Cleansing package and configured the data cleansing repository to use all data cleanse transformations.
• Downloaded the address directories from SAP support portal and placed them in a location which can be used for all address cleansing transformation procedures.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs.
• Involved in writing scripts and also used some built - in functions like To-Date, look up, Key Generation and Custom functions.
• Involved in ETL (Extraction, Transformation and Loading) processing of Data Marts using Data Integrator.

Confidential - Atlanta, Georgia

SAP Business Objects Data Services Consultant

Responsibilities:

• Involved in coordinating with application support team in regard to transport and testing strategies.
• Participated in Requirement gathering sessions and helped in developing Business Objects Data Integrator XI jobs specifications on Excel sheets based on information acquired from analysis of source data, user requirements and Business rules.
• Involved with creation of Local Repositories, Secured Central Repositories, Profiler Repositories using Microsoft SQL Server 2008 database and configured the Local, Profiler repositories with Job server and Management Console.
• Configured the Data Services to connect to the SAP R/3, CRM and BI by using transport codes.
• Migrated the Inventory Balances data using MBGMCR03 IDOC
• Executed jobs daily using the Data Services Designer and WEB administrator. Performed the manual execution of jobs and also their data validation.
• Worked extensively with Address Cleanse (USA Regulatory certified address cleanse), Data Cleanse, Match transforms(Firm address match batch) for cleansing the records in customer master, material master, vendor master.
• Used Case, Validation, Merge transforms in validation process.
• Optimized jobs with parallel execution, full and partial push - down operations.
• Exported the project form one environment (Dev/IT/Prod) to another environment in BODI environment according to the needs.
• Worked extensively on Change Data Capture on both source and Target level for SCD(Slowly Changing Dimension) and implements Type1 and Type 2 for those.
• Worked on the production support activities like performing troubleshooting and providing resolutions for the ETL issues.
• Worked with SQL Server applications like SSIS, T-SQL, SQL querying, stored procedures.
• Extracted data from IBM Main frames by creating data stores using ODBC connection based on requirement.
• Gathered information's for getting the mapping to load the data into Customer Master IDOC in meeting with SAP functional team and Legacy team.
• Worked extensively using query transform and English North American Data Cleansing, USA non-certified address cleansing, Match and Associate transform to generate Customer Master Basic Data.
• Performed the SMTP email setup by configuring the SMTP at Job Server level.

Confidential -Purchase, New York

SAP Business Objects Data Services Consultant

Responsibilities:

• Analyzed the business requirements by interacting with Project managers, business analysts, team members and thus outlining the proposed solution.
• Designed, developed, deployed and maintained universes used Business Objects Designer.
• Implemented SCD(Slowly Changing Dimensions) - Type I & II in different mappings as required.
• Gathered, analyzed and documented business requirements, functional requirements for Business Objects XIR2 Universes and reports.
• Created technical documentation for migration of reports from Development environment to Production environment.
• Worked on Data Integrator which provides an easy to use, graphical design environment dat includes data cleansing tasks.
• Worked extensively with @functions (@aggregate aware, @select, @where) in the creation of dimensions, measures and conditions and setup hierarchies for Multi dimensional Analysis.
• Tuning the queries to improve the performance of the report refresh time.
• Constructed dashboards to review data validation results.
• Implemented validation rules using Data Services to improve the quality of the data in warehouse.
• Created and implemented validation projects to ensure quality data migration. And also tune the process for resolving the performance issues.
• Created and processed ETL jobs to load and manipulate Material Master and Vendor SAP information.
• Extensively worked with various transforms in Data Integrator. Emphasized mainly on Data Cleanse Transforms like Multiple Country Address Cleanse Transformations, Match Transformations, Countryid2char.
• Performed creation, developing, publishing and scheduling of batch and real-time jobs.

Confidential

SAP Business Objects Data Services Consultant

Responsibilities:

• Created Jobs, work flows, Data flows to load data into Enterprise Data Warehouse using Data Integrator XI from different sources.
• Loaded data into Data Mart from Data Warehouse and scheduled jobs with Data Integrator Web administrator and monitored job status.
• Worked with all the transforms in Data Integrator, Data Quality and created Global, local variables in DI.
• Tuned Data Integrator Transformations and mappings to have a better performance during job execution.
• Extensively worked on Data validation and applied validation rules for improving the quality of the data.
• Created and configured Central Repository. Created groups and organized granted access to people based on roles.
• Performed importing table metadata and creating a view.
• Created various Local and Global variables. Optimized mappings to achieve faster load to test environment.
• Worked with various transformations like Query, Key Generation, Pivot, Map operation, Table Comparison, Hierarchy Flattening etc
• Developed complex mappings utilizing built in Data Integrator Functions including pivot, reverse pivot, table comparison, history preserving, map operations and SQL transforms.
• Implemented validation rules using Data Services to improve the quality of the data in warehouse.
• Created local and central repositories and designed real time and batch jobs.
• Installed Business Objects Data Integrator (BODI)
• Documented BODI mappings and scheduled jobs as per the standards of the company.
• Worked with Match transforms, address cleanse transforms.
• worked extensively with Data Integrator and Platform Transforms.
• Loaded the data into Material Master (MATMAS05), by referencing AIO methodologies.
• Worked extensively with Address Cleanse (USA Regulatory certified address cleanse)English North American Data Cleansing, and USA noncertified address cleansing.
• Moved projects from DEV to ST, ST to UAT and UAT to Production based on requirements.
• Experienced in developing jobs to load the SAP R/3 tables into staging area and developed transformations dat apply the rules given by the client and loading the data into target database.
• Created standard Desktop intelligence and web intelligence reports.
• Exposure to Data Services Architecture, Data Services objects, Data services design interface, Data stores, Importing metadata, File format.