OBJECTIVE:

To seek the challenging position in industry that needs innovation, creativity, dedication and enable me to continue to work in a challenging and fast paced environment, leveraging my current knowledge and fostering creativity with many learning opportunities.

EXPERIENCE SUMMARY:

• Over 7 years of professional IT experience in Implementation of Data Warehouse, ETL Jobs development, PL/SQL Development, developing Reports and business Process Mapping
• Experience in understanding Business applications, Data Flows and Data Relations.
• Have involved in Analysis, Design, Development and Implementation phases of the Data warehouse applications in the business domain of Energy and Utilities & Telecom services.
• Well versed with Relational modeling and Dimensional Modeling Star and Snow Flakes schemas in building Data Warehouse.
• Experience in ETL Data stage 8.5 and 11.3 Versions, Developing Sequence and Parallel Jobs.
• Have excellent knowledge of SAP BODS 3.2 and 4.1 versions (ETL), Informatica Power center (8.6), IBM Infosphere Datastage (8.7 and 11.3) and Sound knowledge of database/code performance tuning and UNIX programming.
• Strong Knowledge on writing Simple to Complex SQL Statements and PL/SQL Programs.
• Strong Knowledge in Unix Scripting.
• Experience in Data Modeling, Tuning SQLs and PL - SQL.
• Experience in domains like Telecom (Billing, ordering, networking), Energies and Utilities and Retail
• Experience in Hive database SQL and Data lake projects.
• Experience is writing test cases and using testing tools like TDP and Quality Center.
• Experience in developing Business Objects Webi reports and Xcelsius Dashboards.
• Knowledge in Database and Data Warehouse Architectures.
• Involved in the all phases of Data warehouse life cycle.
• Trained in Data warehousing concepts and tools like SAP BODS, IBM Infosphere Datastage (8.7,11.3), MSBI, Informatica Power center 8.6, IBM Datastage, SAP BO and Oracle.

TECHNICAL SKILLS:

ETL Tool: SAP BODS (4.1,4.0,3.2) and IBM Infosphere Datastage (8.7,11.3), SAP Business objects (3.x and 4.1): IDT, Web intelligence and Dashboard Design

Database: SQL server 2008, Oracle 11g, Teradata, Oracle SQL and PLSQL

WORK EXPERIENCE:

Confidential, Middletown, NJ

Senior Developer

Environment: IBM Infosphere Datastage 8.7, SAP BODS 4.1, Linux and Oracle 11g DB

Responsibilities:

• Responsible for Creating the Design Document and Development Packages as per the Confidential & Confidential Process.
• Responsible for Designing the Data Warehouse and Implementing Star schema.
• Responsible for developing the Mapping in Datastage and BODS as per the different project needs to process the data in the staging area.
• Responsible for Loading the Target tables or External Feed Files as per the Business Requirements
• Responsible for Loading the Facts and Dimensions of a Star Schema in a Dimension Model.
• Responsible for loading the data from external files into the database tables through BODS.
• Responsible for infilling, derivation and validation of the data in the staging area by developing the mappings in Datastage and BODS as per the requirement.
• Responsible for maintaining the quality of code in the BODS.
• Responsible for developing Unit and System Test Cases and testing of the ETL jobs.

Confidential, Middletown, NJ

Developer

Environment: Linux, SAP BODS 4.1, Oracle 11g DB and Teradata DB.

Responsibilities:

• Responsible for understanding the Business process and help the Client SME in the Data model design.
• Responsible for creating the Design Document and Designing the ETL Process.
• Responsible for developing the ETL Jobs in SAP BODS to process the data in the data model from multiple source systems.
• Responsible for Loading the Target tables in the Data model as per the Business Requirements.
• Responsible for Loading the Facts and Dimensions of a Star Schema in a Dimension Model and maintain the consistency across the tables in order to facilitate better reporting for business users.
• Responsible for loading the data from external files into the database tables through BODS.
• Responsible for creating the recovery mechanism in case of job failures from the point it fails.
• Responsible for infilling, derivation and validation of the data in the data model by developing the ETL jobs in BODS as per the requirement.
• Responsible for maintaining the quality of code in the BODS.
• Responsible for developing Unit and System Test Cases and testing of the BODS jobs.
• Responsible for User acceptance testing support and support deploying the code to production.
• Responsible for creating Universe using Business Objects IDT in which I developed Classes, Sub Classless, Objects Resolved loops to get the correct join path
• Responsible for developing simple and complex reports using Webi and Rich client tools.
• Responsible for using Business Objects functionality like formulas calculation, report functions, sorting and alters in the reports.
• Responsible for creating variables, worked with @functions like @select, @prompt and @where objects, formulas to write flexible SQL queries.
• Responsible for exporting the reports into the respective Folders
• Responsible for working on Tickets based on priority and giving perfect solution to them within the SLA

Confidential, San Francisco, CA

Developer

Environment: IBM Infosphere Datastage 8.7 and 11.3, Linux and MS SQL server Database.

Responsibilities:

• Responsible for migrating existing datastage 8.7 jobs to 11.3 version.
• Responsible for understanding the existing applications and implement the new changes to them as per the requirements.
• Responsible for creating the Technical Design for the new changes required as per the requirements.
• Responsible for Developing single and multiple instance ETL jobs in Data Stage Designer and debugging the jobs using Director.
• Responsible for Creating UNIX shell scripts to call Datastage jobs.
• Responsible for Unit testing, System, Integration and Performance testing and ensure that all requirements are satisfied with Test Results.
• Responsible for Defects analysis and fixing.

Confidential, Middletown, NJ

Developer

Environment: BODS 4.0, BO xcelcius and Oracle sql.

Responsibilities:

• Responsible for Creating the Design Document and Development Packages as per the Confidential & Confidential Process.
• Responsible for Designing the Data Warehouse and Implementing Star schema.
• Responsible for developing the Mapping in BODS to process the data in the staging area.
• Responsible for Loading the Target tables or External Feed Files as per the Business Requirements.
• Responsible for Loading the Facts and Dimensions of a Star Schema in a Dimension Model.
• Responsible for loading the data from external files into the database tables through BODS.
• Responsible for setting up the rules for profiling, Validation and Infilling of the data in the staging area by developing the mappings in BODS as per the requirement.
• Responsible for maintaining the quality of code in the BODS.
• Responsible for developing Unit and System Test Cases and testing of the BODS jobs.

Confidential, Middletown, NJ

Developer

Environment: IBM Infosphere Datastage 8.7, SAP BODS 4.1, Linux and Oracle 11g DB

Responsibilities:

• Responsible for Creating the Design Document and Development Packages as per the Confidential & Confidential Process.
• Responsible for Designing the Data Warehouse and Implementing Star schema.
• Responsible for developing the Mapping in BODS to process the data in the staging area.
• Responsible for Loading the Target tables or External Feed Files as per the Business Requirements
• Responsible for Loading the Facts and Dimensions of a Star Schema in a Dimension Model.
• Responsible for loading the data from external files into the database tables through BODS.
• Responsible for infilling, derivation and validation of the data in the staging area by developing the mappings in BODS as per the requirement.
• Responsible for maintaining the quality of code in the BODS.
• Responsible for developing Unit and System Test Cases and testing of the BODS jobs.
• Responsible for maintaining and creating the universes and Webi reports.
• Modifying and creating the business objects reports based on the user requirement.
• Use of Filters, Conditions.
• Working on Universes, Query Panel, Prompts and Report Layout and re-formatting.
• End-End Testing i.e., Performing Confidential and Involved in SIT.

Confidential

Developer

Environment: SAP BODS 4.0, SAP BW 7.3, and Oracle 11g DB

Responsibilities:

• Responsible for Helping the Onsite Team for Creating the design document during design phase of the Project.
• Responsible for developing the mappings in BODS to process the data in the staging area.
• Responsible for created SAP RFC connection.
• Responsible for developing BODS jobs to extract from multiple source systems, Transform and load into SAP using IDOC.
• Responsible for Loading the Target tables or External Feed Files as per the Business Requirements
• Responsible for loading the data from external files into the database tables through BODS.
• Responsible for infilling, derivation and validation of the data in the staging area by developing the mappings in BODS as per the requirement.
• Responsible for maintaining the quality of code in the BODS.
• Responsible for developing Unit and System Test Cases and testing of the BODS jobs.

Confidential

Developer

Environment: SAP BODS 3.2 and 4.0, Unix and Oracle 11g DB

Responsibilities:

• Responsible for helping the Onsite Team to Migrate the Repositories from old to new environment.
• Responsible for preparation of Test Cases for the Code Migration.
• Responsible for testing of all the BODS Jobs execute successfully in the new environment.
• Responsible for preparation of Unit Test and System Test Cases of the Migration.

Confidential

Developer

Environment: BODS 4.0 and Oracle 11g DB

Responsibilities:

• Responsible for helping the Onsite Team for Creating the design document during design phase of the Project.
• Responsible for developing BODS mappings to migrate the data from UU data centre to ENWL data centre for both CCC and AMS.
• Responsible for preparation of Unit Test and System Test Cases of the Data Migration.
• Responsible for maintaining and creating the universes and Webi reports.
• Modifying and creating the reports based on the user requirement.
• Use of Filters, Conditions.
• Working on Universes, Query Panel, Prompts and Report Layout and re-formatting.
• End-End Testing i.e. Performing Confidential and Involved in SIT.