SUMMARY:

• 8 years of Experience in Information Technology in designing, developing, administration and implementation of Data Warehouse Applications under different environments. Core focus on Data Warehousing OLAP tools mainly ODI.
• ODI: Extensive DW experience using Oracle Data Integrator, Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Interfaces, Scenarios, Filters, Condition, Metadata.
• Data Modeling: Data Modeling experience using Dimensional Data modeling, Star Join Schema modeling, Snow - Flake modeling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling.
• Extensively worked with large Databases in Development, Testing and Production environments.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Thorough knowledge of Software Development Life Cycle (SDLC) with deep understanding of various phases like Requirements gathering, Analysis, Design, Development and Testing
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Expertise in creating stored procedures, functions, packages, Scenarios.
• Primary responsibility includes but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing source-to-target mappings, storage capacity planning, developing ETL.
• Experience in building procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Established and maintained productive working relationship with Management, Clients and Team Members. Self-starter, entrepreneurial, highly motivated team- player with excellent communication / problem-solving skills. Quick learning ability vis-à-vis new technology. Easy adaptability to new environments.

TECHNICAL SKILLS:

ETL Tools: Oracle Data Integrator(ODI) 10G,11G, Informatica

Database: Oracle 11g/10g, Netezza.

Languages: SQL, PL SQL

Operating System: Windows 2000/XP, Windows NT, UNIX.

Database Tool: Winsql, SQL Developer, SQL Plus

EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

• Primary responsibility includes configuring (Topology) the Oracle Data Integrator (ODI) software tool in a three-tier environment.
• Gathering requirements from users to develop interfaces, packages.
• Deploying Scenarios from one environment to another environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Experience in configuring ODI Agent and creating new agents and test them in ODI 11G.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Export/Import interfaces across different environments
• Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
• Purged the logs in the operator.
• Performed sending mails to team whenever any ODI jobs are failed by using ODI tools.
• Worked in importing data from different sources like database tables, flat file.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
• Experience in increasing efficiency of data load from source to target by doing performance tuning.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.

Environment: Oracle Data Integrator (ODI) 11.1.1.7/10.1.3.5 , Netezza, winsql, WinNT/XP and UNIX.

Confidential, Houston, Texas

ETL Developer

Responsibilities:

• Primary responsibility includes analyzing the architecture of the data warehouse with the Solution architects, requirement gathering from the business for building the ELT design process for the backlog project.
• Gathering requirements from users to develop interfaces, packages, and corresponding business logics using ODI.
• Deploying Scenarios from one environment to another environment.
• Resolving issues to make sure daily loads run efficiently.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Export/Import interfaces across different environments
• Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
• Experience in running RCC (Repository consistency check) to see if master and work repositories are consistent.
• Purged the logs in the operator.
• Performed sending mails to team whenever any ODI jobs are failed by using ODI tools.
• Worked in importing data from different sources like database and flat file.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
• Experience in increasing efficiency of data load from source to target by doing performance tuning.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.

Environment: Oracle Data Integrator (ODI) 11.1.1.7/10.1.3.5 , Netezza, winsql, WinNT/XP and UNIX.

Confidential

ETL Developer

Responsibilities:

• Primary responsibility includes configuring (Topology) the Oracle Data Integrator (ODI) software tool in a three-tier environment.
• Resolving day to day production issues.
• Gathering requirements from users to develop interfaces, packages.
• Deploying Scenarios from one environment to another environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Experience in configuring ODI Agent and creating new agents and test them in ODI 11G.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Export/Import interfaces across different environments
• Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
• Purged the logs in the operator.
• Performed sending mails to team whenever any ODI jobs are failed by using ODI tools.
• Worked in importing data from different sources like database, flat files.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
• Experience in increasing efficiency of data load from source to target by doing performance tuning.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.

Environment: Oracle Data Integrator (ODI) 11.1.1.7/10.1.3.5 , Netezza, winsql, WinNT/XP and UNIX.

Confidential

ETL Consultant

Responsibilities:

• Worked along with business analysts, developers, management professionals and as well as with business users from various locations of Amway to gather requirements.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Scheduled batch jobs using ODI schedule
• Created versions for interfaces using Version control.
• Primary responsibility includes but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
• Created SQL scripts for sourcing data, including creating tables, Materialized views, stored procedures, and loading data into the tables.
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Implemented Change Data Capture (CDC) techniques on data model level and load updated data to target.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.

Environment: Oracle Data Integrator (ODI) 11g/10.1.3.5, Oracle 11g/10g, WinNT/XP and UNIX.

Confidential

Software Engineer

Responsibilities:

• Validate the required data at the database level by using tool Toad.
• Used Toad for analysis and maintained Database using DDL’s, DML’s.
• Worked with the development team to design, develop, test and implement the system.
• Designing and modifying of Database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Did data profiling, data cleansing
• Developed Database Triggers for the integrity and security purpose.
• Oracle Job Scheduling and Advanced Queuing by Scheduled and Maintain Batch jobs.
• Used PL/SQL Developer Tool to do the backend development.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Wrote complex Oracle SQL using joins, sub queries and correlated sub queries.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Develop and maintain the documentation.
• Data loading using PL/SQL.
• Used PL/SQL Developer Tool to do the backend development.
• Wrote Oracle SQL using joins, sub queries and correlated sub queries.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Develop and maintain the documentation.

Environnent : Oracle 10g, SQL Developer, PL/SQL, UNIX, MS Office.