SUMMARY

• Around 8 years of IT experience in implementing Data Warehouse applications, ETL and Business Intelligence applications.
• Experience in Analysis, Design, Development of various business applications in different platforms Business Objects Data Integrator 11.7/11.5, SAP Business Objects XI 4.2/3.2/3.1, BO 6.5/XIR2/XIR3, SQL Server.
• Well versed in Application Design, Data Extraction, Data Acquisition, Data Mining, Development, Implementations & Testing of Data warehousing & Database business systems.
• Data modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and Logical Data Modeling by using ERWIN 4.0/3.x and Oracle Designer.
• 2 years of Experience in implementing Guidewire DataHub 8.0 data model for Policy, Claim, and Billing Centers.
• Experience in Repository Configuration, Business Objects repository administration creating Transformations and Mappings using BODS/Data Quality 12.2/ BODI 11.7/11.5 Designer and processing tasks using Batch Jobs to move data from multiple sources into targets.
• Experience with database routines (SSIS packages, stored procedures, functions).
• 5 years of Experience in LEADING BUSINESS OBJECTS XI upgrade projects and involved in Installation, Configuration and Administration by using Business Objects Data Integrator / SAP BODS 12.2.0/11.7/6.5 /6.1 (BODI 11.5/6.5).
• Experience in creating Transformations and Mappings using SAP BODS XI 4.2/3.2/3.1 and BODI 12.2/11.7/11.5.1/6.5/6.1.
• Substantial development experience in creating Stored Procedures, PL/SQL, SQL, Packages, Triggers, Functions and Query optimization.
• Implemented SAP Rapid Marts with experience on DW, ETL and BI projects.
• Involved in identification of Facts, Measures, Dimensions and hierarchies for OLAP models.
• Experience in Data Conversion of various data sources like Oracle, SQL Server, DB2, SAP, MS Access, Sybase, Fixed Width and Delimited Flat Files, COBOL files & XML Files.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Business Objects Data Integrator (BODI), Data Services.
• Experience in creating ETL mappings using Data Integrator to move Data from multiple sources like Flat files, Oracle into a common target area such as Data Marts, Rapid Marts and Data Warehouse.
• Have clear understanding of Business Intelligence and Data Warehousing Conceptswith emphasis on ETL and Life Cycle Development, SDLC, Quality analysis, change management, compliance & Disaster recovery.
• Developed Effective Working Relationships with Client Team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work independently and use sound judgment.

TECHNICAL SKILLS

ETL: SAP Business Objects X1 4.2/4.0, BODI 11.5/7

BI tools: Business Objects BOXI-R2\6.5, Crystal Reports

Database: Oracle 11g/10g/9i, SQL Server 2008\2005, Sybase, DB2, MS Access.

Interfaces: TOAD, SQL*Loader

Languages: PL\SQL, C, C++, SQL, HTML.

Environment: s: Windows, UNIX, Linux

Concepts: RDBMS, Data Warehousing

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SAP ETL Lead

Responsibilities:

• Created Jobs in Business Object Data Services Application (BODS) and Data Integrator Application.
• Developed data flows and work flow-using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.
• Involved in Loading and transforming large sets of structured, semi structured and unstructured data. .
• Used SVN/Clear case for source control - check-ins, checkouts for all the files such as ATL files, DDLs, DMLs, Shell scripts, etc.
• Submitting a build in JIRA and Coordinating with DELTA Release team to process those build into DIT, DIT2, MOT, PIT and PROD.
• Deploying the Shell Scripts and BODS ATL file through Unix Shell Scripts.
• Deployed BODS jobs, Shell Script, Run Script, DDL, DML into DIT, DIT2, MOT, PIT & PROD environments.
• Documenting the Performance standards and filling the BODS checklist to ensure that all performance standards are met.
• Perform validations of documented procedures on QA environment and modify procedures based on Business and Functional requirements.
• Created Crystal Reports to compare the data from old to new Data Warehouse.
• Worked on storing the historical claims data jobs.
• Extensively worked on development of mappings and worked with BODS Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc.
• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.
• Used Data Services inbuilt functions like Aggregate Functions, Database Functions, Date Functions, Lookup Functions, Math Functions, System Functions and Validation Functions.
• Created Custom functions to make the code the reusable.
• Used Business Objects Data Integrator XI for ETL extraction, transformation and loading data from heterogeneous source systems.
• Created reusable components like Workflow, Data flows, batch and real time Jobs.
• Created Scripts and worked with Conditional and While Loop to implement complex logic.
• Have good knowledge about Web Admin (i.e. Scheduling, monitoring jobs).
• Resolved issues during the migration from Test to Production environment.
• Extensively used Data Integrator to cleanse and populate target database.
• Developed Internal control reports to validate the ETL load and scheduled it.
• Optimized database performance by using shortcut joins. Shortcut joins provide an alternative path between two tables. Shortcut joins can improve query performance by using shorter paths and bypassing intermediate tables.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.
• Performing troubleshooting and providing resolutions to ETL issues.

Environment: Skills: SAP Business Objects XI 4.2, Business Objects Enterprise 12.0 (Designer, Crystal reports, Web Intelligence, Import Wizard, Performance Management), SVN, Cassandra, JIRA, Oracle SQL Developer, DB2, PL/SQL, Oracle 9i/10g/11g, Microsoft SQL Server 2008, Toad for Data Analysts 3.0, T-SQL scripts.

Confidential, Austin, TX

Sr. Business Intelligence Consultant

Responsibilities:

• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements.
• Extensively worked on ETL jobs to move the data to newly developed SQL Data Warehouse.
• Involved in Data warehousing Architecture on the Design, Development, and Extraction of Data and in the Reporting structure from a Data warehouse using BI and OLAP tools.
• Maintain ETL batch jobs to support Policy Center, Billing Center and Claim Center implementation of new data warehouse model.
• Implemented Guidewire DataHub 8.0 data model for Policy, Claim, and Billing Centers.
• Work on ETL programs to support data conversion and balance and control reporting activities.
• Worked as an Admin to support Sap BODS and Central Repository in migration of the code and setup access to the users and maintain security.
• Worked as a Lead to data warehouse enhancement project related to Claim center.
• Work with Business SME’s to gather requirements, present understanding, analyze gaps and get sign-off on requirements.
• Work on ETL programs to support management reporting development.
• Planning, requirements analysis and definition, development and support for the above project.
• Help the team in resolving technical challenges such as mapping queries, architecture decisions, performance improvements etc.
• Provide industry knowledge in areas of technology expertise.
• Provide skills and knowledge transfer to full time staff members for solutions developed.
• Created document procedures for setup and maintenance of test environments according to Business and Functional requirements.
• Perform validations of documented procedures on QA environment and modify procedures based on Business and Functional requirements.
• Created Crystal Reports to compare the data from old to new Data Warehouse.
• Worked on storing the historical claims data jobs.
• Extensively worked on development of mappings and worked with BODS Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc.
• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.
• Used Data Services inbuilt functions like Aggregate Functions, Database Functions, Date Functions, Lookup Functions, Math Functions, System Functions and Validation Functions.
• Created Custom functions to make the code the reusable.
• Used Business Objects Data Integrator XI for ETL extraction, transformation and loading data from heterogeneous source systems.
• Created reusable components like Workflow, Data flows, batch and real time Jobs.
• Created Scripts and worked with Conditional and While Loop to implement complex logic.
• Have good knowledge about Web Admin (i.e. Scheduling, monitoring jobs).
• Resolved issues during the migration from Test to Production environment.
• Extensively used Data Integrator to cleanse and populate target database.
• Developed Internal control reports to validate the ETL load and scheduled it.
• Optimized database performance by using shortcut joins. Shortcut joins provide an alternative path between two tables. Shortcut joins can improve query performance by using shorter paths and bypassing intermediate tables.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.
• Performing troubleshooting and providing resolutions to ETL issues.

Environment: Skills: SAP Business Objects XI 4.2, Business Objects Enterprise 12.0 (Designer, Crystal reports, Guidewire DataHub 8.0, Web Intelligence, Import Wizard, Performance Management), IBM AS/400, IBM System I Navigator, SQL Server, DB2, PL/SQL, Oracle 9i/10g/11g, Microsoft SQL Server 2005, Toad for Data Analysts 3.0, T-SQL scripts.

Confidential, Findlay, OH

Sr. Data Migration Consultant (SAP BODS)

Responsibilities:

• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements.
• Assisted team members to develop the data services jobs and maintain standards. Successfully migrated Material Master, Customer Master, and HR Objects.
• Successfully migrated HR data from PeopleSoft to SAP HCM.
• Migrated data from multiple legacy systems and business units to a newly-implemented SAP system (SAP ECC 6.0).
• Worked as a Technical Lead for a Sap HR Migration project UK location.
• Automated Migration process with Data services 3.2 using SAP AIO Methodology
• Involved in Data warehousing Architecture on the Design, Development, and Extraction of Data and in the Reporting structure from a Data warehouse using BI and OLAP tools.
• Extensively worked on development of mappings and worked with BODS Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc.
• Involved in creating the mapping sessions from Legacy systems to SAP for all the Infotypes.
• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.
• Extensively worked on migrating different countries HR data to SAP HCM.
• Used Data Services inbuilt functions like Aggregate Functions, Database Functions, Date Functions, Lookup Functions, Math Functions, System Functions and Validation Functions.
• Created Custom functions to make the code the reusable.
• Used Business Objects Data Integrator XI for ETL extraction, transformation and loading data from heterogeneous source systems.
• Created reusable components like Workflow, Data flows, batch and real time Jobs.
• Created Scripts and worked with Conditional and While Loop to implement complex logic.
• Have good knowledge about Web Admin (i.e. Scheduling, monitoring jobs).
• Involved in creating Sales Rapid Marts to analyze the Sales Trends.
• Involved in various components in the Rapid Marts like Sales Order Section, Backlog Section, Delivery Section, Billing and Schedule Lines Section.
• Extensively worked with SQL Server applications like SSIS, Stored Procedures, SQL Querying, T-SQL and OLTP.
• Developed various SQL, PL/SQL blocks to optimize the query performance using SQL*Plus
• Resolved issues during the migration from Test to Production environment.
• Extensively used Data Integrator to cleanse and populate target database.
• Developed Internal control reports to validate the ETL load and scheduled it.
• Optimized database performance by using shortcut joins. Shortcut joins provide an alternative path between two tables. Shortcut joins can improve query performance by using shorter paths and bypassing intermediate tables.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.
• Performing troubleshooting and providing resolutions to ETL issues.

Environment: SAP Business Objects XI 3.2, BO Data Integrator XI, Web I 6.1, Deski, BO XI3.1 (Designer, Deski, WebI, Import Wizard, Performance Management), Windows, SQL, Oracle 9i/10g/11g, Encore, PeopleSoft, SAP ECC 6.0, Microsoft SQL Server 2005, T-SQL scripts.

Confidential, Los Angeles, CA

Data Migration Consultant

Responsibilities:

• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements.
• Worked on Migrating data from IBM REDBRICK legacy system and ORACLE 10g Database to SAP ECC System using an IDOC.
• Worked on Performing Delta Load using Source CDC (Change Data Capture).
• Performed Quality Assurance analysis on ETL results from other project team members using Brio Intelligence 6.6, Aqua Data Studio, and Excel spreadsheets.
• Extensively worked on development of mappings and worked with BODI Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation 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 Data Services.
• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.
• Used Data Services inbuilt functions like Aggregate Functions, Database Functions, Date Functions, Lookup Functions, Math Functions, System Functions and Validation Functions.
• Created Custom functions to make the code the reusable.
• Used Business Objects Data Integrator XI for ETL extraction, transformation and loading data from heterogeneous source systems.
• Created reusable components like Workflow, Data flows, batch and real time Jobs.
• Created Scripts and worked with Conditional and While Loop to implement complex logic.
• Extensively used Try/Catch to handle exceptions and writing Scripting to automate the Job Process.
• Have good knowledge about Web Admin (i.e. Scheduling, monitoring jobs).
• Resolved issues like loops by creating aliases and contexts as required to remove the cyclic dependencies
• Resolved issues during the migration from Test to Production environment.
• Extensively used Data Integrator to cleanse and populate target database.
• Developed Internal control reports to validate the ETL load and scheduled it.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.
• Tested and Validated BODI ETL Jobs, monitored Daily BODI ETL schedules.
• Performing troubleshooting and providing resolutions to ETL issues.

Environment: SAP Business Objects XI 3.2, BO Data Integrator XI, Web I 6.1, Deski, BO XI3.1 (Designer, Deski, WebI, Import Wizard, Performance Management), Windows, SQL, Oracle 9i/10g/11g, BRIO 6.6, Aqua Data studio6.5, Microsoft SQL Server 2005, T-SQL scripts.

Confidential, Dallas, TX

BODI Developer

Responsibilities:

• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements.
• Involved in Data warehousing Architecture on the Design, Development, and Extraction of Data and in the Reporting structure from a Data warehouse using BI and OLAP tools.
• Customized the Rapid Marts’ design, develop/customizing jobs to defined enhancements to populate the Dimensional and Fact tables to accommodate the business requirements.
• Executed / Scheduled the SAP function modules/reports in background/foreground (to accommodate Job execution in the assigned time frame window) and monitoring the function modules’ execution to guarantee the successful population of Rapid Mart tables.
• Worked with flat files from SAP, efficiently using FTP to get/put the files from/to SAP R3 Application Server for the target table population and for other transformations and custom built ABAP Transforms.
• Handling Initial/ Delta Loading of the Rapid Marts, Data Availability, Data Consistency and Data Quality.
• Extensively worked on development of mappings and worked with BODI Transformations like, Map Operation, Table Comparison, Effective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc.
• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.
• Used Data Services inbuilt functions like Aggregate Functions, Database Functions, Date Functions, Lookup Functions, Math Functions, System Functions and Validation Functions.
• Created reusable components like Workflow, Data flows, batch and real time Jobs.
• Created Scripts and worked with Conditional and While Loop to implement complex logic.
• Experience in creating Rapid Marts by extracting SAP R/3 data.
• Involved in creating Sales Rapid Marts to analyze the Sales Trends.
• Involved in various components in the Rapid Marts like Sales Order Section, Backlog Section, Delivery Section, Billing and Schedule Lines Section.
• Developed various SQL, PL/SQL blocks to optimize the query performance using SQL*Plus
• Resolved issues during the migration from Test to Production environment.
• Extensively used Data Integrator to cleanse and populate target database.
• Used Complex EXCEL formulae v lookup & H LOOKUP to generate complex Dashboards.
• Developed Internal control reports to validate the ETL load and scheduled it.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.
• Tested and Validated BODI ETL Jobs, monitored Daily BODI ETL schedules.
• Performing troubleshooting and providing resolutions to ETL issues.

Environment: SAP Business Objects XI 3.2, BO Data Integrator XI, Web I 6.1, Deski, BO XI3.1 (Designer, Deski, WebI, Import Wizard, Performance Management), Windows, SQL, Oracle 9i/10g/11g, Microsoft SQL Server 2005, T-SQL scripts.