SUMMARY:

• Around 11 years of IT experience in System Analysis, Design, Development, Testing in Data Warehousing.
• Expertise in Installing, Configuring, Upgrading SAP Business Objects Data Services(BODS) (Designer, Repository Manager, Server Manager, Data Quality transforms, Metadata Reports, Configuring / Controlling Job Server and Central Management System (CMS) Web Admin) on both windows and Linux.
• Expertise in developing BODS ETL framework that includes Data Quality, Error Handling mechanisms that helps in delivering automation ETL tasks.
• Worked on improving performance tuning techniques to reduce execution time and provide data on time.
• Experience in designing and developing ETL flows based on user requirements and delivering projects on time.
• Integrated BODS jobs with different source and target systems like Flat files, Oracle, SQL server, AS400, SAP ECC, SAP BW(Both as Source and Target) and ODBC connections.
• Prioritized BODS jobs and scheduled ETL jobs daily, weekly and monthly loads.
• Applied various transformations logic techniques to do data cleaning, Data conversions.
• Developed custom scripts, reusable components, Complex SQL statement within SAP data Services.
• Used different BODS transforms like Query, Merge, Case, Table Comparison, Date Generation based on user requirement.
• Extensively usedData Services Management Consoleto schedule and execute jobs, manage repositories and perform metadata reporting.
• Strong understanding of OLAP Data warehouse concepts, Dimensional Data Model, Star Schema, Snowflake Schema.
• Applied Data warehouse techniques and implemented slowly changing dimension one, two using SAP Data Services.
• Implemented SAP Data Services integration with SAP BW systems.
• Loaded data into BW Data sources/Infosources(PSA tables).
• Configured all BODS jobs in BW infopackages and executed them through BW process chains.
• Minimal knowledge on SAP BW objects/Development.
• Worked as a single and delivered projects TEMPeffectively and also with multiple teams.
• Communicated TEMPeffectively with all other people, Business users, team members to get clear information on the projects tasks.
• Available for 24/7 production calls and fixed very high priority issues to make sure there are no impacts on the target audience.

TECHNICAL SKILLS

ETL: BO Data Services 3.2, 4.0, 4.1, 4.2., SAP BW

Databases: HANA SP8, Oracle 10G/11i, MS SQL Server 2008/2012.

Reposting Tools: SAP Business Objects 4.x(Design Studio(IDT and UDT)

Operating Systems: Win 2008/2012, UNIX AIX, Linux.

Data profiling: SAP Information steward 4.2

PROFESSIONAL EXPERIENCE:

Confidential, CO

ETL Developer

Responsibilities:

• Analyzed requirements and created a high level and low - level technical design for dataWarehouse projects through Business Objects Data Services.
• Developed Full Functional ETL jobs based on the Business specifications.
• Created mappings with proper DI transformations between source and target databases with Business Objects Data Services.
• Extracted data from SAP BW as source and Target.
• Experience in using BW Infopackages/process chains for executing BODs jobs.
• Involved in Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Used various transformations such as Query, Validation, Case, Reverse Pivot, Table Comparison, Custom Function etc., Metadata and Transactional Reports.
• Wrote custom functions and implemented functions as per the requirements.
• Applied Performance tuning techniques efficiently to populate high volume data.
• Continuous monitoring the execution, transformation and loading process in Data Marts.
• Used EXPLAIN Table plans to tune the SQL Queries / Data flows and tracking execution plans.

Environment:, SAP Data Services, Business Objects 4.x, SAP BW, Flat files, Oracle, SQL Server.

Confidential, SFO, CA

ETL Consultant

Responsibilities:

• Assist in designing the data model for the stopwatch portal.
• Design the ETL Process for populating the data model.
• Develop the ETL data flows using DI tool.
• Design and implemented the error table logic for all the fact tables thru ETL.
• Code around 250 data validation checks as per the business logic.
• Prepare test cases to check data output from ETL.
• Data Validation implemented thru SQL code as well as thru ETL tool.
• Data validation for almost every column coming from CSV source file.
• Did root-cause analysis for the data validation failed records.
• Report data validation failed cases to the client with maximum explanation and in most cases a possible solution or fix for the bug.
• Fix bugs in the ETL code without any impact on delivery.
• Worked in implementing event-driven job execution using PL/SQL stored procedure and Scripts.
• Provide leadership and guidance to the team to maintain high standard of Quality Assurance.
• Evangelize best design and coding practices and quality standards among the team members.
• Review performance, provided feedback and recommended appropriate actions for the development work assigned to the team.
• Impart training about the functional as well as the technical side of the project to the team members d new joiners to the team.

Environment: SAP BO Data Services 12.x, Business Objects, Oracle, AS400.

Confidential, Herndon, VA

BI Developer

Responsibilities:

• Involved in gathering of business requirements by interaction with business users and SME’s.
• Convert Business requirements in to Functional / Technical Specifications, prepare High Level / Detail Design Documents, Mapping Documents, GAP Analysis Report, Transactional Reports.
• Redesign existing database model to relational data mart (Star Schema) populating / refreshing Fact (Detail) using First / Delta feeds and Dimension (Master) tables implementing First / Slowly Changing Dimension.
• Created independent multiple jobs to have full control for enhancements, execution and performance.
• TEMPEffective in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Implemented Ralph Kimball’s Subsystems of ETL like Extract, Clean, Conform and Deliver.
• Record Execution Status during the process of ETL, the source data passes through proper staging (Persistent / Transient) and load Data Mart tables.
• Use client-specific ETL standards for objects in designing Data Services jobs to have synch with other DW projects.
• Scheduled job groups through Batch files to have flexibility in grouping and to execute them in parallel.
• Used transformations efficiently to build the jobs TEMPeffectively and to have optimized performance, push-down logic and proper usage of the Cache Options.
• Modify / Tune large and complex pre-existing ETL mappings to implement client-specific standards.
• Performed Unit testing, end to end testing, deployed and documented ETL jobs and the process.

Environment: Business Objects, SAP BO Data Services 11.x MS SQL Server, CSV files.

Confidential

Associate

Responsibilities:

• Worked in implementation of SAP Data Migration process (Mapping - Filter - Validation
• Enrichment) efficiently, in defining process to export the integrated data from various
• Systems into files for the Business-users’ modifications (Import/Export Process) andgetting the modifications to the integrated data (Load Difference).
• Worked in translation of Business Process Document to Functional Specification and toTechnical Specifications for several Masters and Transactional Tables.
• Customization and Implementation of SAP Data Migration best practices and implementTechniques in the ETL Flows.
• Worked in customizing / defining process for De-Duplication, Filter, Validation, DataCleansing and Enrichment stages to handle data from various source systems, applyValidation rules and apply the enrichment rules.
• Worked in implementing/customizing the SAP BODS Baseline Jobs for tables likeCustomer, Material, BOM, Work Center / Resources, Recipes, Scheduling Agreements,Sales Orders, AR, AP, GL, Fixed Assets, etc.
• Handled Administration tasks like Installation / Configuration / Up-gradation of DataServices components (Job Servers, Job Server Groups and Repositories), Code Promotion / Version Management using Central Repository.
• Worked in implementation of BO Product Suite and addressing issues spanningAdministration, Version Management and Performance.

Environment: Business Objects Data Integrator for ETL 6.5.x, Oracle, Business Objects.