SUMMARY

• Over 10 years of experience working in IT Industry with in the field of SAP Business Objects.
• Data processing knowledge in Designing and Implementing Data Warehouse applications, mainly Transformation processes using ETL tool SAP Data Services.
• Expertise in Data Warehouse Implementation.
• Experience in SAP BOBJ EIM Tools - Data Services (BODI/BODS)
• Experience in extracting data from SAP ERP System (Tables, Hierarchies and RFC Function Modules) using SAP BOBJ Data Services (BODS/BODI).
• Experience in extracting data from SAP BW Info Providers using Open Hub Destination and loading data to SAPBW Info Providers using BODS.
• Having good experience with SAP Infrastructure in duel Landscape and connectivity.
• Experience and knowledge in the Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL)
• Expertise in scheduling and monitoring daily, weekly and monthly loads for master data and transaction data. Handling tickets as per SLA and rectifying loading issues. Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator.
• Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.
• Strong experience in using BODS as an external system for ETL between ECC and BI.
• Worked at multiple levels as an experienced subject matter expert in SAP infrastructure sizing and automated performance testing.
• Extensive experience performing EDM Enterprise Data Management and MDM Strategy.
• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Strong experience in cleansing the data using Data Quality transforms.
• Having good experience with design, Data quality, high volume transaction consumption, Tuning real time Web Services, Configuration & implementation in SAP ECC, (both as a source and target).
• Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
• Developed conditioned, looped scripts for data load using Winshuttle Transaction.
• Data modeling (Dimensional & Relational) concepts including Star-schema modelling, Snowflakes modeling, fact and dimension tables.
• Having good knowledge on TFS and SAP Lumira.
• Installed and Configured Business Objects Enterprise Suite, Business Objects Data Services/Data Integrator/Data Quality & Data Insight with proper IQ and OQ documentation.

TECHNICAL SKILLS

ETL: Business Objects Data Services (BODS), Data Integrator (BODI), SAP BO Data Services 4.2/4.1/4.0/XI3.2/3.1/3.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2/11.7/11.5, SQL 2008 R2 SSIS.

BI Tools: Business Objects XI 4.2, IDT, Universe Designer, Desktop Intelligence, BI Launch pad, Web Intelligence/Info view Publishing Wizard, CMC, Live Office, EPM Dash boards, Crystal Reports 2008/XI/10/9.0

ETL Tools: Informatica 9.1/8.5/7.1, BO Data Services XI 4.2/3.2, BO Data Integrator 11.5

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005, Tera data V12, IBM DB2 V8

Data Modelling: Dimensional Data Modelling, Star Schema Modelling and Snow-Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modelling.

Front End Tools: Erwin 4.1, TOAD

ERP: SAP R3, SAP BW/BI 7.0

Operating Systems: UNIX, Linux, AIX, Solaris, MS-Dos, Windows NT 4.0/2000/2003/2008 r2/XP/Vista/7

Databases: Oracle, Teradata, Sybase,DB2, MS Access, MS SQL Server 2008 R2/2005

PROFESSIONAL EXPERIENCE

Confidential, Allentown, PA

SAP BO/BODS Consultant

Responsibilities:

• Worked on different master data objects like General Ledger Balances, Purchase outline agreements.
• Worked with business in different mock cycles to obtain zero tolerance for bad data.
• Performed post load validation procedures after loading the data into SAP and validated the results with business.
• Develop profiling queries/validation programs to cross check all the data before and after the data loading into S/4 HANA.
• Created Users, Roles and provided repository access to the users and in creation of local and central repositories.
• Developed financialWebi reports and Xcelcius dashboards. Involved in production support activities and solved tickets based on financialWebi reports and Xcelcius dashboards.
• Created Batch jobs using BODS ETL Tool to extract SAP and Non- SAP Data.
• Created Universes usingIDT and connected to multiple data sources
• CreatedWebi reports on relational Database that helps in ranking purposes.
• Developed Webi reports onSAP Bex queries using BICS in Web Rich Client.
• Having good Data modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Work in an Agile Methodology.
• Having good experience with writing SQL Scripts.

Environment: SAP Business Objects 4.2, MS Excel source, SAP ECC, SAP S/4 HANA, SQL Server, and Windows.

Confidential, Minneapolis, MN

SAP BO/BODS CONSULTANT

Responsibilities:

• Suggested best practices for business to validate the data and implement master data governance.
• Engineered the frame work to resolve the data issues from the manually constructed files with different transforms in SAP BODS.
• Worked on extracting the data from different legacy sources and excel files.
• Worked on different master data objects like class characteristics, work center, task list etc.
• Performed post load validation procedures after loading the data into SAP and validated the results with business.
• Involved in the brain storming sessions with business from source to target mapping/business process re-engineering sessions.
• Proactively identify project risks and create feasible solutions. Escalate cross-functional issues and identify SMEs required for resolution.
• Worked with business in different mock cycles to obtain zero tolerance for bad data.
• Obtained 100% clean data to the business with lookup, mandatory, format and business validation procedures.
• Access data though virtual tables using Smart Data Access fromSybase and Oracle DBs.
• Worked on extracting data from SAP BW Info Providers using Open Hub Destination and loading data to SAPBW Info Providers using BODS.
• Designed, Created, and implemented Universes, Interactive Analysis Reports,Web rich Client, Crystal Reports, and Dashboard designer Dashboards using best practices
• Develop profiling queries/validation programs to cross check all the data before and after the data loading.
• Created Pre-Canned and Ad-hoc reports using Business Objects Web Intelligence (Webi) Rich Client by utilizing BICS Connection and Universes.
• Responsible for migrating of BEx queries intoBO Webi reports extended to Xcelsius Dashboards.
• Extensively Worked inSAP Live Office to create connections betweenWebi and Xcelsius Dashboards.
• Extensive experience withWebi in creating queries and reports that further used in the Dashboard Designer.
• Created complex Crystal reports inIDT depending on client requirement.
• Refactored the validation job based on the AIO job in SAP.
• Updated the mapping documents and performed gap analysis from source to target. And worked in a Agile Methodology.
• Created global variables, substitution parameters and local variables for all the jobs to promote the conditional execution of part of code and to improve performance.

Environment: SAP Business Objects Data services 4.2, MS Excel source, SAP ECC target, SAP BO, SQL Server, and Windows.

Confidential, Irvine, CA

SAP HANA/BODS CONSULTANT

Responsibilities:

• Involve in data migration and conversion activities that include extraction, transformation, migration, validation and reconciliation of data at offshore location.
• Involved in information gather phase
• Migrated MS SQL Database into SAP HANA.
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views.
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application.
• Involved in SAP HANA Security including User Management, Roles, and Privileges, Reporting, Accessing Analytical and Calculation views from EXCEL.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
• Provide guidance to internal IT key users to design and develop data loaders/templates to fit the business requirements.
• CreatedWebi reports on relational Database that helps in ranking purposes.
• Created crosstab data inWebi and developed the WEB Services for theWebi report that can be directly used in the Dashboard Designer.
• Develop profiling queries/validation programs to cross check all the data before and after the data loading.
• Identify problematic areas and conduct research to determine the best course of action to correct data.
• Proactively identify project risks and create feasible solutions. Escalate cross-functional issues and identify SMEs required for resolution.
• Develop conversion programs using ABAP and LSMW.
• Involve in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Lead and support the data migration strategy and processes to enable efficient and effective deployment data conversion.
• Developed Webi reports onSAP Bex queries using BICS in Web Rich Client
• Worked with MDM data which will allow the client to resolve issues with the quality of data, maintain consistent classification and identification of data, and data-reconciliation issues.
• Implementing MDM was going to resolve unstructured data problem for the client. We reviewed structured data tables, records, semi-structured data XML.
• Configured BODS to replicate data fromSybase to HANA DB, used scripts to handle delta, Monitored and troubleshot the replication errors.
• Extensively involved in configuration of Material master record, vendor master record, Master Data for Vendor, Customer, Materials and Bill of Materials (BOM), Recipe management.
• Gathered and analysed the requirement to replicate the ECC content in HANA using data provisioning. Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Created virtual info provider based on HANA models.
• Created WEBI report based on HANA models using IDT.
• Worked on extracting data from SAP BW Info Providers using Open Hub Destination.
• Developed Dynamic Dashboards (XCelsius) using HANA Views and worked on Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Used IDT to create connections and universes to the BEX Queries and HANA Calculation Views.
• Developed scripts for data load using Winshuttle Direct.
• Perform review of the Technical Designs, ETL Code and Unit Test Plan.
• Worked in a Agile Methodology.
• Worked with the infrastructure team to define reference architecture of the various reporting tools.
• Work with downstream application users to gather reporting/data requirements.

Environment: SAP Business Objects Data Services 4.2, Data Quality, HANA 1.0 SP2, SAP R/3 ERP 6.0, MS Access, SQL Server 2008

Confidential, Livonia, MI

SAP BODS /IS Lead Consultant

Responsibilities:

• Involved in profiling the vendor data (completeness and consistency).
• Involved in profiling vendor data of OR9 available in ODS (SQL Server).
• Configured profiling the business rules.
• Reviewed list of potential duplicate vendors.
• Lead and support the data migration strategy and processes to enable efficient and effective deployment data conversion.
• Work with also defining an EDM / Master Data Management Strategy. This included using SAP MDM tool for data domains of Customer Master, Material Master, and Vendor Master.
• Defined business rules of match/merge logic (duplicates identification) and address cleansing.
• Validate and implement business logic mentioned in the specs to build in both Information Steward and Business Objects Data Services (BODS).
• Worked on extracting data from SAP BW Info Providers using Open Hub Destination.
• Involved in designing the approach document and the mapping rules defined by the customer.
• Build and Bind rules to corresponding view or table
• Create Tasks, Rules, Views
• Data profiling experience from source systems including SAP application/ SAP BW, Flat Files, and Legacy systems using SAP Data Services (BODI/BODS).
• Developed Webi reports onSAP Bex queries using BICS in Web Rich Client.
• Tasks were exported from Development to Quality Environment using Information Steward.
• Record final scores, failed records and total records count after the task is complete
• Validating ETL design and development.
• Worked in a Agile Methodology.
• CreatedWebi Reports and generated graphs for multi-dimensional analysis using Slice & Dice, Drill Up and Drill Down functionality, Breaks, Sorts, Ranking, Prompts, Report Filtering, Query Filtering and Sections.
• View term definitions, synonyms, keywords to help ensure appropriate terms are being used.
• After approval of the term, associate a metadata or the Data insight object with the term.
• Execute, Monitor and Trace jobs using Data Services Management Console

Environment: SAP Business Objects Data Services 4.2 (SAP BODS/BODI 4.0/3.2/3.1)/ BODI 11.2.2/ BODI 11.5.1, Information Steward 4.2, MS SQL Server

Confidential, Waltham, MA

SAP BO/BODS Consultant

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Developed Source to Target Mapping as per the requirements.
• ETL Design (converting business functional specifications into mappings/workflows), testing and code migration to difference environment.
• Performance tuning using Recovery mechanisms for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows and data flows.
• Involved in writing DS scripts and also used some built-in functions and Custom Functions.
• Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, Query, SQL Query Transform, Table Comparison, Case, Validation, and Merge etc. in Data flows.
• Used SAP MDM tool for data domains of Customer Master, Material Master, and Vendor Master.
• Involved in System integration testing along with other team members using various source data scenarios.
• Experienced in scheduling and monitoring of jobs using DS management console during pre-production phases.
• Worked extensively with data profiling tools (sap information steward 4.0) for ongoing project to understand the quality of data before loading into the SAP.
• Experienced in ETL Methodologies using Business Objects Data Services 4.2 with Data Quality & Data Profiling
• Worked with SAP Infrastructure in duel Landscape.
• Worked on Creating Repository and associating the Job server to it.
• Created Batch jobs using BODS ETL Tool to extract SAP and Non SAP Data and Build the EDW.
• Daily Job monitoring for regular scheduled jobs.
• Analytic view for Sales Order Analysis to build multipleWEBI reports and dashboard for Open Sales Order analysis.
• Successfully worked on master data preparation including conversion, cleansing, migration and WinShuttle/SLMW troubleshooting during the load.
• Used Debugger to troubleshoot the mappings between source and target tables.
• Designed Business objects semantic layers (Universe) with SAP Warehouse and Non SAP warehouse.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis
• Contacting the Business Analysts/Users to develop, document and to evolve process and data models based upon their input and feedback.
• Thorough understanding of theSybase Near-line Storage.
• Worked on extracting data from SAP BW Info Providers using Open Hub Destination.
• Created complex SalesWebi reports using multiple data providers.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Created different reports containing charts showing revenue, booking, and backlog and operating income by different verticals and Company codes.
• Worked in a Agile Methodology.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Environment: SAP BODS 4.2, Information steward, SAP ECC, SAP BO XIR4, MS SQL Server 2008, Oracle 10g, SharePoint

Confidential, Dallas, TX

SAP BO/BODS Consultant

Responsibilities:

• Extraction of Data from Legacy Source system to Staging Area.
• Involved in sap R/3 source extraction by using sap Source Extractors using BODS 4.0.
• Executing Batch Jobs that Contain ERP and R/3 Data Flows Generation of flat files
• Working with DATA TRANSPORT Files Method to Specifies a staging file for data extracted from SAP ERP or R/3.
• Involved in High Level design, Low level Design document, Unit Test Case and Integration Test case Preparation, Performance, and improvement of ETL
• Involved in Normalized the existing model, Debugging existing ETL and Develop new ETL code.
• Data modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and Logical Data Modeling by using ER-WIN V7/4.X/3.x and Oracle Designer.
• Experience in Migration of Jobs and workflows from Development to Test and to Production Serverstoperform the integration and system testing.
• Involved in extracting data from SAP R/3 OLTP System and generated ABAP code.
• Involved in Installation, Configuration and Administration by using Business Objects Data Integrator 12.2.0
• Involved in Migration of Mappings from BODI 6.5 to BODI 12.2.0 and migrated the code from development to Test database and to production db.
• Extensively worked on development of mappings and worked with BODI Transformations like Reverse Pivot, Map Operation, Table Comparison, Effective Date, History Preserving, Row Generation, Key Generation, Query, Case, Merge, Validation, Pivot Etc.
• Involved in Data Profiling like source column data profiling, detail data profiling and used validation and address cleansing transformations by using Data Quality In SAP BODI 12.2.0
• Have good knowledge on all kinds of lookups (Lookup Seq, Lookup Ext, Lookup).
• Extensively worked with Local Repositories, Central Repositories, Job Server and Web Admin client tolls.
• Created Custom functions to make the code reusable and created reusable components like Workflow, Data flows, Batch and Real Time Jobs.
• Worked extensively with data profiling tools (sap information steward 4.0) for ongoing project to understand the quality of data before loading into the SAP.
• Worked with multiple levels as an experienced subject matter expert in SAP infrastructure.
• Extracting data from SAP BW by using Source &Target Extractors and involved in text data processing.
• Have good knowledge about Web Admin &SAP Data Services Management Console (i.e. Scheduling, monitoring jobs).
• Involved in administrative tasks like Repository Configuration, Job Server configuration, Central Repository configuration, Job Scheduling, Monitoring.
• Worked in a Agile Methodology.
• Worked with Tivoli scheduling tool for scheduling, holding and cancelling the jobs.
• Resolved high, medium tickets raised by the users and provided required support.

Environment: SAP Business Objects Data Services 4.0 (SAP BODS/BODI 4.0/3.2/3.1)/ BODI 11.2.2/ BODI 11.5.1, SAP BW, SAP R/3 Source & Target Extractors, ERWIN V7 / 4x,DB2,UNIX, ORACLE 10G, SAP R/3, SQL, PL/SQL, Windows NT/2000/XP. Pharmacia

Confidential

SAP BODS Consultant

Responsibilities:

• Led a group of BODS Developers.
• Led the group in all the migration phases: Profiling, Cleansing and ETL development.
• Migrated customer and vendor from different legacy systems to SAP ECC.
• Setup BODS environment right from installation, configuration, authorization and testing the components.
• Involved in gathering all the requirements related to ETL and interacted with SMEs to understand the data flow and integration of SAP & Non-SAP data.
• Used Pivot and Reverse Pivot Transforms, to map the columns according the Dashboard Schema tables as per Dashboards requirement.
• Implemented version management on top of the BODS local Repository by using the Central Repository.
• Implemented using BODS features like Query, Merge, Row Generation, Lookup, Hierarchy Flattening, Key Generation and Table Comparison.
• Implemented Slowly Changing Dimensions (SCDs).
• Tested all the BODS ETL Jobs in DEV environment by loading sample data, validated and fixed the bugs.
• Deployed all the BODS ETL Jobs from DEV to PRD after testing all the Jobs with the provided test scripts.

Environment: SAP Business Objects Data Services 4.0 (SAP BODS/BODI 4.0/3.2/3.1)/ BODI 11.2.2/ BODI 11.5.1, SQL Server, BODS 4.0, Oracle.

Confidential

SAP BODS Consultant

Responsibilities:

• Implemented version management on top of the BODS local Repository by using the Central Repository.
• Implemented using BODS features like Query, Merge, Row Generation, Lookup, Key Generation, and Table Comparison.
• Implemented Slowly Changing Dimensions (SCDs).
• Developed a standard BODS ETL Job to load the Time Dimension table using Data Integrator Transform DATE GENERATION.
• Applied BODS performance tuning techniques viz parallel processing (Degree of Parallelism), Multithread, Partitioning, and Database Throughputs to improve job performance.
• Developed code with standard IDOC’s for transformation of SAP extracted data and loading it to SQL Server Table.
• Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.
• Involved in writing DS scripts and also used some built-in functions like Search, Replace, Lookup ext and Custom Functions whenever an exception is raised.
• Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
• Involved in System integration testing along with other team members using various source data scenarios.

Environment: SAP Business Objects Data Services 4.0 (SAP BODS/BODI 4.0/3.2/3.1)/ BODI 11.2.2/ BODI 11.5.1BODS 3.2, SQL Server, Flat-files