SUMMARY

• Having 9+ years ofIT experience in BI/DWH tools like Business Objects Data Services 4.0 (BODS), Business Objects Data Integrator 3.2 (BODI), Teradataand BASE SAS.
• Workedin different roles like Team Lead and Senior ETLDeveloper in business verticals like Healthcare and Retail in technical and managerial activities.
• Experienced on multiple versions of SAP Business Objects Data services 4.0 and 3.2
• Familiar wif Data Warehouse concept and Data Modeling
• Installation and Configuration of SAP Business Objects Data services (4.0)
• EvaluatedSAP BODS 4.0 Expertise in gathering teh business requirement and building Batch /Real Time ETL jobs using teh Designer, retrieving data from different source system like SAP ECC,databases and external data
• Developed various Business Objects Data services Batch job using different transformations
• Experienced in creating teh repository using teh SAP Business objects Data services Repository manager.
• Experienced in assign teh job server to teh repository using teh SAP Business objects Data services Server manager.
• Experienced in profiling teh data using teh SAP Business objects Data services profile Repository
• Experienced in managing version of ETL jobs using SAP Business objects Data services central Repository
• Experienced in scheduling teh ETL jobs using SAP Business objects Data services Scheduling in Admin console.
• Experienced in using teh SAP ABAP dataflow, BAPI, LSMW and IDOC concepts in Business objects Data services
• Performance Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes) in Teradata

TECHNICAL SKILLS

Operating Systems: MSWindows, UNIX

Languages: BASE SAS, SAS MACRO, C, C++, JAVA, SQL & PL/SQL

Databases: Oracle, SQL Server 2008, and Teradata13

ETL Tools: Business Objects Data Services 4.0 BTEQ, Fastload, Multiload, TPUMP

OLAP Applications: Business Objects, MSOLAP

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Team Lead

Responsibilities:

• Involved in project cycle plan for teh data warehouse, source data analysis, data extraction process, and load strategy designing.
• Involved in project planning and resource planning as per teh requirements.
• Involved in providing teh user requirement document as part of teh Joint Requirement Discussions
• Involved in documentation of requirements and technical design.
• Involved in documentation of project status reports
• Involved in managing an offshore team as senior lead developer.
• Involved in creating teh repositories to teh offshore team.
• Involved in Business Requirement Analysis.
• Develop teh ETL Process flow documents.
• Developed ETL jobs using SAP Extractors and open hub
• Maintain and Tune BODS jobs in Production and Development systems
• Lead and improvised existing Enterprise Data Warehouse
• Troubleshooting teh Failure Jobs.
• Involved in scheduling teh ETL jobs using teh Tivoli.
• Involved in Post go live support.(PGLS) and reverse shadowing
• Created views for analyzing teh data in teh virtual data marts and reporting.
• Capacity planning and proactive monitoring to meet performance and growth requirements
• Interacted wif Clients, Data Modeler and Data Analyst to develop teh Logical and Physical Design for a table.
• Worked on loading of data from several flat files sources to Staging using BODS Batch Jobs.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per teh requirements.
• Written several Teradata BTEQ scripts to implement teh business logic for AD-HOC reports.
• Developed ETL objects, Database objects.
• Loaded teh data using BODSETL tool and applying all teh required transformations based on teh logic to modify teh data.
• Created Transformations andMappings using BODS Designer and processing tasks using jobs to move data from multiple sources into targets.
• Extensively used Transformations like Query, pivot,Table comparison, History preserving, validation, Case, and Key generator and Stored Procedure.
• Managed teh project in breaking down teh existing EDW to manageable data marts
• Used BODS Designer to create Jobs, workflows and batches to run wif teh logic embedded in teh mappings.
• Performance Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Responsible for Data Modeling, Architecture, Production support and migration to SQL Server 2008
• Build tables, views, UPI, NUPI, USI and NUSI.
• Checking teh tables skewing, table compression.
• Moved database schema changes to stage/production database.
• Worked wif teh users and testing teams to implement teh business logic as expected.

Environment:Business Objects Data Services 4.0, Teradata SQL Assistant 13.0, Teradata V2R12.0, BTEQ, Fast Load, Multi Load, Fast Export Oracle 9i, SAP ECC, Windows Enterprise, MS SQL Server 2008

Confidential, NJ

Team lead

Responsibilities:

• Involved in Business Requirement Analysis.
• Develop teh ETL Process flow documents.
• Involved in project cycle plan for teh data warehouse, source data analysis, data extraction process, and load strategy designing.
• Involved in managing an offshore team as senior lead developer.
• Maintain and Tune BODS jobs in Production and Development systems
• Involved in providing teh user requirement document as part of teh Joint Requirement Discussions.
• Involved in documentation of requirements and technical design.
• Troubleshooting teh Failure Jobs.
• Involved in Post go live support.(PGLS) and reverse shadowing
• Created views for analyzing teh data in teh virtual data marts and reporting.
• Capacity planning and proactive monitoring to meet performance and growth requirements
• Interacted wif Clients, Data Modeler and Data Analyst to develop teh Logical and Physical Design for a table.
• Worked on loading of data from several flat files sources to Staging using BODS Batch Jobs.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per teh requirements.
• Written several Teradata BTEQ scripts to implement teh business logic for AD-HOC reports.
• Developed ETL objects, Database objects.
• Loaded teh data using BODS ETL tool and applying all teh required transformations based on teh logic to modify teh data.
• Created Transformations andMappings using BODS Designer and processing tasks using jobs to move data from multiple sources into targets.
• Extensively used Transformations like Query, pivot, Table comparison, History preserving, validation, Case, and Key generator and Stored Procedure.
• Managed teh project in breaking down teh existing EDW to manageable data marts
• Used BODS Designer to create Jobs, workflows and batches to run wif teh logic embedded in teh mappings.
• Performance Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Responsible for Data Modeling, Architecture, Production support and migration to SQL Server 2008
• Build tables, views, UPI, NUPI, USI and NUSI.

Environment:Business Objects Data Services 4.0, Teradata SQL Assistant 13.0, Teradata V2R12.0, BTEQ, Fast Load, Multi Load, Fast Export Oracle 9i, SAP ECC, Windows Enterprise, MS SQL Server 2008

Confidential, SFO, CA

Senior ETL Developer

Responsibilities:

• Involved in project cycle plan for teh Data migration, source data analysis, data extraction process, and load strategy designing
• Develop teh ETL Process flow documents.
• Tune BODS jobs in Development systems
• Responsible for Code fixing and testing.
• Reviewing all teh deliverables and Ensuring timely and defect free delivery Involved in documentation of requirements and technical design.
• Troubleshooting teh Failure Jobs.
• Developing BODS ETL jobs to extract data from SQL Server.
• Developing BODS ETL Jobs using ABAP data flows to extract teh data from SAP systems.
• Developing teh data flows to validate teh data.
• Developing BODS ETL jobs to load teh data through IDOCinto SAP system after validating teh data.
• Developing teh data flows to create teh text files to load into teh SAP systems using LSMW jobs.
• Worked on loading of data from several flat files sources to Staging using BODS Jobs
• Created Transformations andMappings using BODS Designer and processing tasks using jobs to move data from multiple sources into targets.
• Extensively used Transformations like Query, pivot, validation, Case, and Key generator custom functions and Stored Procedure.

Environment: Business Objects Data Integrator 3.2, SAP ECC, MS SQL Server 2008

Confidential, West Palm Beach, FL

ETL Developer

Responsibilities:

• Involved in project cycle plan for teh Data migration, source data analysis, data extraction process, and load strategy designing.
• Develop teh ETL Process flow documents.
• Responsible for Code fixing and testing.
• Reviewing all teh deliverables and Ensuring timely and defect free delivery Involved in documentation of requirements and technical design.
• Troubleshooting teh Failure Jobs.
• Developing BODS ETL jobs to extract data from SQL Server.
• Developing BODS ETL Jobs using ABAP data flows to extract teh data from SAP systems.
• Developing teh data flows to validate teh data.
• Developing BODS ETL jobs to load teh data into SAP system after validating teh data.
• Developing teh data flows to create teh text files to load into teh SAP systems using LSMW jobs.
• Worked on loading of data from several flat files sources to Staging using BODS Jobs
• Extensively used Transformations like Query, pivot, validation, Case, and Key generator custom function and Stored Procedures

Environment: Business Objects Data Integrator 3.2, SAP ECC, MS SQL Server 2008

Confidential, Bellevue, WA

ETL Developer

Responsibilities:

• Involved in Business Requirement Analysis.
• Develop BASE SAS Programs for generating teh standard Quarterly reports as per teh template given in teh design document.
• Develop BASE SAS Programs for generating Adhoc report as per teh adhoc requirements from teh business..
• Working on teh enhancements to improve teh performance time of teh reports.
• Performing teh QC of teh reports to validate teh reports as per teh design document
• Involving in Unit Testing and System Testing

Environment: Mainframes, BASE SAS Programming, SAS MACRO