PROFESSIONAL SUMMARY:

• 8+ years of IT experience in Requirements gathering, Analysis, Design, Development, Implementation, Modeling, Testing and support for Data warehousing applications.
• 6+ Years of Extensive DW experience using Oracle Data Integrator(ODI), Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
• Experienced in ODI solution architecting (12C, 11g & 10g).
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ELT processes.
• Worked on Oracle Data Integrator (ODI) to 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.
• Expert in 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.
• Possess clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL/ELT and life cycle development Using Oracle Data Integrator (Repository Manager, Designer, Load Plan Generator and Operator).
• Worked on Slowly Changing Dimensions and its implementation to keep track of Historical data.
• Actively involved in Performance Tuning, Error handling and production support for various projects.
• Practical understanding of the Data Modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modelling of data
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Experience in UNIX working environment, writing UNIX shell scripts for ODI pre & post session operations.
• Excellent communication and interpersonal skills.
• Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS:

ETL TOOLS: ODI 12C/11g/10g

DATA BASES/ RDBMS: Oracle 12c/11g/10g/9i/8i, SQL Server, TOAD, MS-Access

OPERATING SYSTEMS: MS Windows 10, 8.x, 7, xp, Vista, UNIX, Mac OS X, Linux, Solaris

LANGUAGES & Web Technologies: SQL, PL/SQL, XML, UNIX Shell Scripting.

ERP / Applications Servers: Oracle Applications 11i & R12, Oracle Web Logic Server 10.3.5, 11g,12C

METHODOLOGIES: Software Development Life Cycle(SDLC)- Waterfall Model, Agile, Rational Unified Process(RUP), JIRA(Ticket tracking)

PROFESSIONAL EXPERIENCE:

Confidential, Morrisville, NC

Sr. ODI/OBIEE Developer

Responsibilities:

• Involved in Analysis of the Project requirements.
• Extracting the data from various source systems.
• Involved in the Installation and Migrating of ODI 11g & 12C.
• Performed loading from flat files to Oracle in Dev. UAT and Prod Environment.
• Worked on SQL loader utilities.
• Used Shell Scripting to figure out the Files, records, directories, and troubleshoot the bad files/records.
• Created and Designed (ODI/ETL) Data Load process across the clients.
• Created ODI Package of various complexity and automated process data flow.
• Design and develop complex reports using ODI 12C.
• Performed source to Staging and staging to target mapping specifications and developed ETL / ODI code for the same.
• Worked on ODI 12c components.
• Worked on ODI inbuilt SVN and migrated ODI Objects to higher environments.
• Created Topology connection for reading xml logs and writing into oracle db.
• Created ODI Interfaces for reading data from xml using external properties and loaded into staging table.
• Created ODI Interfaces to load data into ODS for downstream systems.
• Created Source and Target systems physical and logical data server connections into ODI Topology Manager
• Created ODI Variables and used it into ODI interface, Procedure and Packages
• Created ODI Interfaces using LKM, JKM, CKM & IKM Knowledge Modules.
• Created Interfaces to load data from source systems to staging area, staging area to dimension and fact tables of Target
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files.
• Identified the source and target schemas and the ER relationships to support the business reporting model.
• Gathering requirements from users to develop interfaces, packages, Load plans.
• Created Master and Work Repository and developed the ODI mappings.
• Used Topology Manager to define data servers and physical schemas for source and target databases.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources, reverse engineering, to develop projects, and release scenarios.
• Ability to work in fast paced environment using agile concepts.

Environment: ODI 12C, 11g, RDBMS Oracle 12C, 11g, Toad (12.5, 11.x), PL SQL. EBS R12, UNIX, Agile, Oracle 11g, SQL*PLUS, SQL Developer.

Confidential, SARASOTA, FL

Sr. ODI Developer

Responsibilities:

• Responsible for developing & administrating the ELT processes using Oracle Data Integrator (ODI).
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Develop complex interfaces to load the data from the various sources into dimensions and facts.
• Worked on ODI 12c upgrade from ODI 11g.
• Testing and fixing the bugs in the interfaces and migrating them to stage and production environments.
• Participating in team planning sessions.
• Created ODI Package of various complexity and automated process data flow
• Created ODI Interfaces to load data into ODS for downstream systems
• Gathered ELT requirements from Business team and designed its high level documents.
• Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool.
• Debug the mappings using debugger to resolve code issue.
• Worked in importing data from heterogeneous data sources like Flat files, AS 400, oracle database, XML files, excel etc.
• Involved in Unit testing, User Acceptance Testing and System Testing to verify accuracy and completeness of ETL process, Prepared & documented unit test plans
• Created ODI jobs to replicate the existing process of SQL scripts Created ODI Interfaces with simple to complex transformation rules while migrating from Source to the target.
• Conducted thorough Unit Testing, System Integration testing, UAT, MTP and Production Support Co-ordination effectively.
• Used PLSQL Developer for running SQL queries.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.

Environment: ODI 12C, 11.1.1.7, 11.1.1.9, OBIA 11g, OBIEE 12c, RDBMS Oracle 12C, 11g, Toad (12.5, 11.x), PL SQL. EBS R12. DB2

Confidential - Woonsocket, RI

Sr. ODI Developer

Responsibilities:

• GG setup integrated capture to replace CDC.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, SQL Server and Oracle).
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Installing ODI 11.1. on all the environments and configuring ODI.
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule.
• Patching ODI 11.1 to 11.1.1.and Upgrading ODI from 10.1.3.4 to 11.1.1.
• Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios,ODI Functions, ODI Mappings, ODI Load Plans.
• Created the users, profiles using the ODI security manager.
• Created Packages, Scenarios and Load Plan Components, Load Plans using ODI.
• Generated Load Plans and Executed Integrated Testing over Payroll Subject Area using ODI.
• Unit, integration and system testing for all components of ETL and reporting. Prepared test cases and documented the results.
• Creating standalone agent on windows server.
• Implemented CDC through ODI Journalization Knowledge Modules (KMs).
• Developed Expressions, filter, joins, Split, Variables, user functions Using ODI
• Developed interfaces for loading the lookup and transactional data.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
• Created Dynamic and Session Variables and Performance tuned the ODI interfaces.
• Complete responsible for preparing the END to END Document.
• Worked with the team and a DBA to communicate and negotiate data needs.

Environment: ODI 11.1.1.5.0, ODI12c, WebLogic Server 11.x, Oracle 11g, SQL*PLUS, SQL Developer, Windows XP.

Confidential - Columbus, OH

ODI Developer

Responsibilities:

• Created and developed the ODI Interface metadata mappings to extract the data from SQL Server to consolidate the data into Enterprise data warehouse.
• Designed Aggregate Tables modeled the repository for improving performance of reports.
• Identified Gaps by analyzing the Datamart instance and provision of alternative solutions as well as recommendation of changes to databases.
• Designed ETL mappings for bringing in data from various data sources using ODI.
• Identified the fact and dimension tables, designed the Kimball Matrix, created the data mapping field matrix
• Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures. Also created Fragmentation content for few fact tables
• Involved in data model designs and assisted in ETL design mappings using Oracle Data Integrator (ODI) to extract the data.
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Develop data extracts from the data warehouse environment using ODI.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Extensively worked on complex Interfaces which involved slowly changing dimensions.
• Created Complex procedures and used them in the interfaces to load the data to simplify the interface design. Automated the schema name using ODI interface function in procedures.
• Performed Unit, Integration, and Regression testing to validate report and mapping
• Respectively participated in weekly Project status meetings and communicated effectively with Project Managers.

Environment: Oracle 11g, ODI 11.1.1.9, SQL, SQL*PLUS, SQL*Loader

Confidential, Dallas, TX

ODI Consultant

Responsibilities:

• Created several ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, and Security Manager) & Knowledge modules (Reverse-engineering, Journalizing, Loading, Check, Integration and Service).
• Responsible for issue resolution and performance tuning of ODI Interfaces.
• Created Source and Target systems physical and logical data server connections into ODI Topology Manager
• Created ODI Variables and used it into ODI interface, Procedure and Packages
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Created Interfaces to load data from source systems to staging area, staging area to dimension and fact tables of Target.
• Effectively interacted with the users for requirement gathering and performed GAP analysis.
• Participated in the weekly meeting to structure the timelines for the project.
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables
• Used Refresh, Set and Evaluate ODI variables types into ODI Packages
• Created Scenarios of ODI Packages for migrating code into Prod execution repository
• Migrated Code from Development to Testing to production.
• Participated in the weekly meeting to structure the timelines for the project.
• Documented the data loading scenarios in Oracle Data Integrator (ODI).
• Performed Unit, Integration and Regression testing to validate reports and data.
• Taking up the calls with the users/customers for gathering the change requests and feedback on the resolved defects

Environment: ODI 11g, SQL, Oracle 11g, Toad, MS VISIO.

Confidential

OBIEE/ ETL Informatica Developer

Responsibilities:

• Full project life cycle implementation for Business Analytics Warehouse.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Worked on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
• Reused mapping, mapplets and transformations.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Created new requests and opened Answers for adhoc reporting to the End users
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Documented all the configurations and new reports creation and published it to the end users.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Siebel Analytics 7.8, BI Apps 7.8.4, Informatica 7.1, Oracle 10g/9i, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.