SUMMARY

• Senior Oracle Data Integrator ODI consultant with over 8 years of total experience having mature leadership and communication skills with an exceptional ability to plan and organize work efforts and excel in a team environment.
• Strong analytical skill analysis, requirement gathering, design, development and testing of Data warehousing applications
• Experience in ETL development through Oracle Data Integrator ODI 11G using SQL, PL/SQL and implementation of ODI packages for critical business requirement.
• Experience in DEV, SIT, UAT and Production implementation
• Experience in ODI 10G to ODI 11G Upgrade
• Efficient in all major components of ODI 11g including installation and configuration, administration, topology manager, security manager and data modeling
• Experience in using Oracle Data Integrator ODI for ETL - Extraction, Transformation and Loading of data into Data Warehouse
• Experience in Requirement gathering, Project Estimation, Design and Development and all phases of SDLC
• Experience in creating COGNOS BI reports for the customers to see the data analysis
• Very fast learner and possess high energy level to work on challenging cutting edge technologies.
• Effective communication skills and Client location work experience.
• Ability to provide effective analytical solution to key business applications/requirements.

TECHNICAL SKILLS

• ETL Tool: ODI - Oracle Data Integrator 11g
• Database: Oracle, Netezza, Sybase ASE Sybase IQ, SQL Server 2008
• Reporting Tool: COGNOS 10
• Database Tools: DB Visualizer 9, Oracle SQL Developer, Aginity Workbench 4.1 for Netezza, Microsoft SQL Server
• Programming Languages: C C
• Operating Systems: UNIX, Windows 7
• Other Tools: Control-M 7.0, HP Quality Center 11, PUTTY, Crystal Report 8.0, Sybase Power Designer 12.0

EXPERIENCE

Oracle ODI Developer/Oracle Data Integrator Senior Consultant

Confidential

Responsibilities:

• High level involvement in requirement gathering, estimation and design with customer and helping out in the data modeling and creating High level and low level Design Documents
• Design, develop, and implement custom Oracle Data Integrator ODI Modules in order to take advantage of the power of the database engine.
• Set up the Topology including physical architecture, logical architecture and context and Created new models for the data sources flat files, QAD, Oracle.
• Building the required interfaces/mappings, using Oracle Data Integrator ODI for the extraction, transformation and loading of data into the data warehouse for efficient and accurate data reporting purposes
• Developing the ETL flows to get data from Operational Data Store and loading it to target using the ELT tool Oracle Data Integrator using different Knowledge Modules.
• Expertise in jobs scheduling using Agent Scheduler
• Used ODI commands like ODIFile Move, odiFileAppend, odiFilecopy etc
• Expertise in all modules of Oracle Data Integrator ODI implementations including Repository, Topology, Contexts creations in Oracle data Integrator
• Experience in creating Cognos BI reports for the customers to see the data analysis
• Involved in functional testing, Performance testing, data validations etc.
• Worked in Client location and directly dealing with new business requirements.
• Worked in DEV, SIT, UAT Production Deployment
• Review and ensure the documentation and configuration implemented are in sync with the changes in the Requirement, Design, and Code Changes
• Consulting with customers on the entire change requests, proposing the possible solutions and implementing them.

Environment: Oracle Data Integrator 11G, Oracle 11, Windows, Cognos 10, DB Visualizer 9.0, Oracle SQL Developer 4

Team Size: 5

Oracle ODI Developer/ Oracle Data Integrator Consultant

Confidential

Responsibilities:

• Involved in requirement gathering, estimation and design with customer and helping out in the data modeling and creating High level and low level Design Documents
• Involved in ODI 11G upgrade from ODI 10G with Netezza porting from Sybase
• Developed the ETL flows to get data from Operational Data Store and loading it to target using the ELT tool Oracle Data Integrator using different Knowledge Modules.
• Worked in Repository, Topology, Contexts creation in Oracle data Integrator
• Extract, transform and load EL/T millions of data rows using Oracle Data Integrator 11g ODI
• Expertise in DEV, UAT, SIT Production Deployment
• Involved in Client management and interaction dealing directly with new business requirements.
• Involved in Performance tuning the SQL Queries and to ensuring all aspects of deliverable for Build/Code go through quality review
• Review and ensure the documentation and configuration implemented are in sync with the changes in the Requirement, Design, and Code Changes
• Consulting with customers on the entire change requests, proposing the possible solutions and implementing them.
• Expertise in all modules of Oracle Data Integrator ODI implementations
• Expertise in Control-M jobs scheduling

Environment: Oracle Data Integrator 11G, SQL, UNIX, DB Visualizer 9.0, Aginity Workbench 4.1 for Netezza, PUTTY, Control-M 7.0 job scheduling , Team Size: 11

Oracle ODI Developer/ Oracle Data Integrator Consultant

Confidential

Responsibilities:

• Developed ETL flows to get data from Operational Data Store and loading it to target using the ELT tool Oracle Data Integrator using different Knowledge Modules.
• Build the interfaces/mappings required, using Oracle Data Integrator ODI for the extraction, transformation and loading of data into the data warehouse for efficient and accurate data reporting purposes
• Involved in functional testing, Performance testing, data validations etc during the porting of warehouse from ODI 10G to 11G
• Involved in DEV, UAT, SIT Production Deployment
• Involved in Performance tuning the SQL Queries during the port to Netezza standard
• Consulting with customers on the entire change requests, proposing the possible solutions and implementing them.
• Expertise in Oracle Data Integrator ODI implementations
• Interact directly with Clients for development and enhancement.
• Involved in Tech-Lead activities
• Efficient in all major components of ODI 11g including installation and configuration, administration, topology manager and data modeling
• Documentation, coding and Unit Testing and Code Review
• Expertise in Control-M jobs scheduling

Environment: Oracle Data Integrator 10G/11G, UNIX, Netezza, Sybase IQ, DB Visualizer 8, PUTTY, Control-M 6.3, Team Size: 7

Oracle ODI Developer/ Oracle Data Integrator Consultant

Confidential

Responsibilities:

• Expertise in Oracle Data Integrator ODI implementation
• Involved in Performance tuning the SQL Queries and quality checks
• Worked on change requests, proposing the possible solutions and implementing them.
• Review and ensure the documentation and configuration implemented are in sync with the changes in the Requirement, Design, and Code Changes
• Implemented the back-end solution using Oracle Data Integrator.
• Adhere to standards and procedures mentioned in PMS and QMS in development activities.
• Efficient in all major components of ODI 11g including installation and configuration, administration, topology manager and data modeling
• Production support with on-call support
• Interact directly with Clients and Involved in Tech-Lead activities
• Documentation, coding and Unit Testing and Code Review
• Control-M jobs scheduling

Environment: Oracle Data Integrator 10G, Sybase IQ, AIX-UNIX, DB Visualizer 8, PUTTY, Control-M 6.3, Team Size: 5

Oracle ODI Developer/ Oracle Data Integrator Consultant

Confidential

Responsibilities:

• Developed and code Unit Testing Production Deployment
• Adhering to standards and procedures mentioned in PMS and QMS in development activities.
• Build the interfaces/mappings required, using Sunopsis for the extraction, transformation and loading of data into the data warehouse for efficient and accurate data reporting purpose
• Hands-on experience in Sunopsis 4.1 ETL tool
• Build the interfaces/mappings required, using Sunopsis for the extraction, transformation and loading of data into the data warehouse for efficient and accurate data reporting purposes
• Documentation, coding and Unit Testing

Environment: Sunopsis 4.1, SQL Server 2005, UNIX, Team Size: 4

Oracle ODI Developer/ Oracle Data Integrator Consultant

Confidential

Responsibilities:

• Developed and did coding, Unit Testing Production Deployment
• Adhered to standards and procedures mentioned in PMS and QMS in development activities.
• Production support with on-call support
• Technical expertise in the capacity of a Consultant includes hands-on experience in Sunopsis 4.1 ETL Tool
• Extract, transform and load EL/T millions of data rows using Sunopsis.
• Documentation, coding and Unit Testing

Environment: Sunopsis 4.1, SQL Server 2005, UNIX, Team Size: 6