Summary

• Over 8 years of experience in Information Technology in designing, developing, architecture, administration and implementation of Business Intelligence, Data Warehouse Applications under different environments. Core focus on Data Warehousing OLAP tools, BI and PL/SQL.
• Experience in various domains like Education, HealthCare, Finance, Retails Insurance and Manufacturing.
• Extensively worked with large Databases in Development, Sandbox, Testing and Production environments.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Worked on ODI 11g and 12c studios.
• Using Data Warehousing tools like OBIEE, ODI. Exclusively worked on OBIEE Administration Physical, Business Model Mapping, and Presentation Layers , Answers, Dashboards, Catalog Manager.
• 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.
• Worked on slowly changing dimensions SCD , Change data capture CDC as part of data warehousing concepts.
• Oracle Data Integrator ODI reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Primary responsibility include 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.
• Specialized in developing stored 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

Experience

Confidential

Sr. ODI Developer

Responsibilities:

• Primary responsibility include 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
• Resolved day to day production issues.
• Gathering requirements from users to develop interfaces, packages, Load plans.
• Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
• Performed calculation if delta Incremental data through UNIX scripts.
• Increased performance of loads by applying proper Hints, Indexes, Analyzing master tables and explain plans to check cost.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
• Worked on setting up crontabs on UNIX servers for scheduling the jobs.
• Worked on using files system DSV as source and finally load data to target which is oracle tables.
• Worked on using Oracle loader utility for loading data from file to tables using external table concept.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• 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.
• Used User functions for converting date format from AS400 to Oracle.
• Implemented Synchronous and Asynchronous Change Data Capture CDC techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• 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.

Environment: Oracle Data Integrator ODI 11g/10.1.3.4, Oracle 11g/10g, SQL Plus, TOAD, WinNT/XP and UNIX.

Confidential

Sr. ODI Developer

Responsibilities:

• Primary responsibility include 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 ELT.
• Provided best practices which need to be followed for object migration between environments.
• Gathering requirements from users to develop interfaces, packages, Load Plans.
• Performed loading of delta changes to target table with CDC and Time stamp process.
• Performed Versioning of odi objects using external versioning tools and using internal odi versioning using Solutions.
• Upgrading from ODI 11G to ODI 12c environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 12c.
• After Upgrading in Development environment performed export and import.
• Used Smart export and import for finding dependencies to perform export and import of odi objects.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Experience in running RCC Repository consistency check to see if master and work repositories are consistence.
• Experience in using new concept called mapping which is newly introduced in ODI12c. Created mappings with joining multiple sources and loading to multiple tables using IN and OUT connectors
• Worked on Physical and Logical tabs where in physical tab we can choose KM's and in logical tab we can create mappings.
• Worked on Reusable mappings which is newly introduced in ODI 12c.
• Worked on using component panel where we can use functionalities like aggregate, dataset, split, filter, join, set, sort.
• 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 such as using Hints, Indexes, Analyzing tables, Explain plan.
• 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 11g/10.1.3.4, Oracle 11g/10g, SQL Plus, TOAD, WinNT/XP and UNIX.

Confidential

Sr. ODI Developer

Responsibilities:

• Primary responsibility include 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
• Resolving day to day production issues.
• Gathering requirements from users to develop interfaces, packages.
• Deploying Scenarios from one environment to other environment.
• Upgrading from ODI 10G to ODI 11G environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
• Experience in setting up crontabs for scheduling jobs on UNIX server.
• After Upgrading in Development environment performed export and import
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Experience in running RCC Repository consistency check to see if master and work repositories are consistence.
• 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
• Working closely with Informatica team for performing mapping and data loading which is same as ODI tool.
• 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 11g/10.1.3.4, Oracle 11g/10g, SQL Plus, TOAD, WinNT/XP and UNIX.

Confidential

Sr. ODI Developer

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.
• Oracle Data Integrator ODI reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide various brand level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Worked on Customized Knowledge modules such as AMWAY V04 IKM ORACLE MERGE/PROCEDURE and AMWAY LKM SQL to ORACLE V3 NO ISOLATION LEVEL .
• Worked on Job Master for performing Change data capture.
• Worked on Slowly Changing Dimension SCD .
• Primary responsibility include 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 Synchronous and Asynchronous Change Data Capture CDC techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Validate the required data at the database level by using tool Toad.
• Used Toad for analysis and maintained Database using DDL's, DML's.

Environment: Oracle Data Integrator ODI 11g/10.1.3.4, Oracle 11g/10g, SQL Plus, TOAD, WinNT/XP and UNIX.

Confidential

Sr. ODI / OBIEE Consultant

Responsibilities:

• Used JRN FLAG to indicate the type of change where It takes the value I for an inserted/updated record and D for a deleted record.
• 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.
• Oracle Data Integrator ODI reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide various brand level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Primary responsibility include 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 Synchronous and Asynchronous Change Data Capture CDC techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Validate the required data at the database level by using tool Toad.
• Used Toad for analysis and maintained Database using DDL's, DML's

Environment: Oracle Data Integrator ODI 11g/10.1.3.4, , Oracle 11g/10g, SQL Plus, TOAD, WinNT/XP and UNIX.

Confidential

ETL Developer

Responsibilities:

• Designed, created and documented multiple interfaces of using the Informatica Power Center.
• Created many complex Informatica Mappings and Mapplets to build key interfaces using transformations reusable transformations Source Qualifier, Update Strategy, Lookup, Expressions, and Aggregator for loading the data into Data Warehouse.
• Created concurrent and sequential tasks and session in the workflow manager, and executed the tasks in workflow monitor and did troubleshooting based on the session logs.
• Optimal utilization of object-reusability features like reusable transformations, Mapplets, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
• Performed Database and Informatica performance tuning and implemented the session partitions, changes to database by re-building the indexes, analyzing the objects etc.
• Developed many Shell Scripts for pulling data from remote machines, Backup/Migration of metadata from version, development and production, FTP, untar sending files to source directory, managing sessions files in the server directory.

Environment: Informatica Power Center 6.x, Oracle9i, Sun Solaris