PROFESSIONAL SUMMARY:

• 7+ years of experience in Information Technology in ODI 10g &11g (Oracle DataIntegrator), Data Warehousing and Business Intelligence applications using ODI and Oracle Applications.
• Worked on technologies like Oracle, Oracle Data Integrator, and Dimensional Data modeling using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Performed Data Extraction, Loading and Transformation in data ware house environment.
• Designed and developed interfaces to load the data from multiple sources like relational databases, flat files into oracle database.
• Developed packages, scenarios using interfaces and variables.
• Handled Topology, Designer, Operator in Oracle Data Integrator.
• Debugging the master jobs and packages by using operator navigator.
• Implemented SCD Type2 on Dimension tables.
• Good Understanding about ODI Architecture.
• Worked with knowledge modules like LKM, IKM and CKM.
• Worked with Standalone and J2EE Agents.
• Ability to work individually as well as in a team with excellent problem solving skills.
• Knowledge on data ware housing concepts like schemas and approaches.
• Knowledge in developing packages, functions, stored procedures, triggers, tables, table spaces, indexes, customized views utilizing ORACLE PL/SQL database programming language.
• Experience in PL/SQL Packages, Stored Procedures, Functions, Cursors, triggers and Dynamic SQL.
• Developed PL/SQL code for efficient retrieval and manipulation of complex data sets using back end PL/SQL packages, procedures, functions, triggers.
• Proficient in all DBA responsibilities such as user management (synonyms/privileges, roles, quotas, table, table partitioning, index, sequence), space management (table spaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity).
• Experience in Performance Tuning & Optimization of SQL statements.
• Performed DBA tasks like Installing oracle software, planning the database, creating and opening database, back up the data base and enroll system Users.

TECHNICAL SKILLS:

OLAP Tools: OBIEE 11/10, OBIA, BI / XML Publisher, Siebel Analytics 7.8.2,Hyperion Essbase 9.3.1

RDBMS: Oracle 11g/10g/9i/8i

Applications: Oracle E - Business Suite Releases 11.x(GL, AP, AR, PO)/R12, Siebel CRM

Oracle Tools: Oracle Discoverer, Oracle Reports, Oracle Forms, SQL*Loader,SQL Developer

ETL Tools: Informatica Power Center 8.2/7.1/5.1, Informatica PowerMart 5.0/4.7,DAC, ODI 11/12 g

Data Modeling: MS Visio, Erwin.

Languages: VB, PL/SQL, Java Script, VB Script, Toad

Operating Systems: Windows XP/00/NT/98/95, Linux, UNIX (Solaris)

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

ODI Developer

Responsibilities:

• Developed complete specifications for required ETL mappings.
• Developed interfaces for multiple sources such as Relational database, SQL server, Flat files for Extraction, Transforming and Loading data.
• Assisted Data Architect in designing by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and usedODIfor reverse engineering to retrieve metadata from data storage and load it to the repository.
• Worked on ODI Designer to create Interfaces, procedures, packages and Scenarios to extract the data from multitude of sources, cleaned and loaded into target.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Implemented data transformation strategies by using LKM, RKM, IKM, CKM and JKMKnowledge modules.
• Implemented Change Data Capture (CDC) feature of ODI to refresh the data in EnterpriseData Warehouse (EDW).
• Installed and configuredODI12con windows environments.
• Upgraded the repository from 11g to 12c
• Implemented mappings inODI12cusing Aggregate, Expression, Filter, Dataset, Join and lookup to load the data from multiple sources.
• Performed unit testing, system integration testing and assisted with UAT team.
• Created a utility to take the daily backups of the repositories.
• Analyzed currentODIpackages and provided suggestion for performance improvement by using tkprof and explain plan.
• Created PL/SQL procedures, functions and triggers for performance improvement and also for the tasks outside of ODI.
• Created Data Lineage documents for reports.
• Involved in designed customized interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.

Environment: ODI 12c, ODI 11.1.1.6, Oracle DB 11g, Oracle Exadata, SQL Server, OBIEE 11.1.15/BI Publisher, SQL Developer.

Confidential, Houston, TX

ODI Developer

Responsibilities:

• Installed ODI and Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Troubleshoot the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, MS SQL server, Oracle.
• Did reverse engineering for the data sources and targets.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Designed the ETL flow for SUN accounting general ledger system to reuse the existing logic of TM1 accounting system to meet the tight deadlines.
• Coordinated with the offshore UK team. Helped them to define the source view for sun accounting system and in resolving the access issue.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
• Performed SQL and PL/SQL programming for ODI and oracle.
• Created PL/SQL stored procedures, functions and triggers.
• Developed interfaces for loading the lookup and transactional data. Performed daily duties in operations to ensure the company meet its weekly and monthly objective.
• Identified the granularity level of the data required for the analysis. Developed Metadata repository by importing required objects, Configured the business model layer & presentation layer as per the reporting requirement.
• Directly involved in database tuning and query performance tuning to achieve maximum performance while retrieving data from database structures.
• Understanding the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.
• Performed Data Validation in the reports and dashboards.
• UsedFilters(global and local) and provided customizedPromptsto avoid excessive data showing up in the reports.
• Provided production support for end-users of the systemwhich included the, responding to questions, resolving problems, and providing ad-hoc reporting.

Confidential, Houston, TX

ODI Developer

Responsibilities:

• Worked with the Business analysts and analyzed various sources for requirements gathering, business analysis, testing, metrics and project coordination.
• Analysis and design of ETL Processes design documents and detail design documents.
• Prepared the Technical Assessments, Technical Specification, Technical Design Documents based on the functional, publishing requirements.
• Worked with Data Modeler on Physical and Logical Model designs.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms and created mapping documents between source and targets.
• Used Topology Manager for creating Physical and Logical schemas for every source and target of warehouse.
• Used ODI Designer to develop process for extracting, cleansing, transforming, integrating and loading data into data ware house.
• Developed Interfaces, Packages and Procedures using Oracle Data Integrator (ODI) for loadinginto warehouse from various sources like databases, flat files.
• Having knowledge in ODI setup, Master Repository, work Repository, Project Models, sources, targets, Interfaces, Packages, Scenarios, Knowledge Modules, metadata.
• Reverse engineered source and target system schemas using ODI before starting development.
• Migrated code from one environment to another environment with DBA’s coordination and other dependent teams in project.
• Generated scenarios and deployed them using ODI Operator for code migration one environment to another environment.
• Used various knowledge modules and customized them if required based on source and target technologies for developing Interfaces using ODI.
• Involved in production support of ODI jobs by monitoring, debugging them using operator.
• Worked in importing data from different sources like database, flat file, XML files, excel.
• Created interfaces and packages for creating flat files from database.
• Created ODI Procedures for complex logic which is not possible to implement using interfaces and packages.
• Used ODI built-in version control feature for maintaining versions of ODI ETL components.
• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Analysis of business functionality with the client and the developers.
• Depending on the requirements created and modified SQL and PL/SQL database objects liketables, indexes, views, stored procedures, functions, packages, Triggers, synonyms, Materialized views, analytical functions to make new enhancements or resolve problems.
• Performance Tuning done by using Explain plan and query optimization techniques and created necessary indexes.
• Worked with Bulk Collects to improve the performance of oracle procedures.
• Developed various complex queries to generate various reports to predict business trend.
• Performed Performance Tuning using the DBMS PROFILER package and collections and bulk collections.
• Prepared Test cases and testing procedures for the ETL interfaces and packages.
• Generated Threshold reports by executing the shell script from ODI based on the requirement.
• Tools: Accurev4.7.3, JIRA, BeyondCompare2,TextPad.

Environment: Oracle Data Integrator (ODI 10g/11g), Oracle 10g/11g, PL/SQL, PL/SQL Developer 8.0.4, Shell scripting, SQL*loader, UNIX/LINUX, Windows NT.

Confidential, Dallas,TX

ODI Developer

Responsibilities:

• Expertise includes analysis, design, development and testing of data warehousing application using Oracle Data Integrator ODI.
• Developed and worked with Master and work repositories using the Repository management tools.
• Configuring the physical and logical architecture schemas using Topology Manager.
• Developed and managed the physical and logical models and performed reverse engineering.
• Designed and developed ODI interfaces using Designer and imported knowledge modules (LKM,IKM, CKM, etc) to load and transform the data from various data sources.
• Developed various ODI interfaces to load data from Flat file and relational sources like xml, xls to Oracle Data Mart.
• Expertise on database design - Creation of data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the DB.
• Good understanding of the Data modeling (Dimensional & Relational) concepts like Star-SchemaModeling, Snowflakes Modeling, fact and dimension tables modeling of data at all the three levels: view, logical & physical.
• Worked with Metadata Navigator, which enables users to access information through a Web interface.
• Experience in real time data movement and change data capture technologies.
• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.

Confidential, Atlanta, GA

ODI/OBIA Developer

Responsibilities:

• Designed the interfaces to implement ETL strategy to populate the data from various sources using ODI.
• Scheduled and administered database queries for off hours processing by creating ODI Load plans and maintained schedules.
• Worked with Oracle BI App modules HR and Financial Analytics by configuring ODI packages with BI Apps domain files.
• Implemented HR and Financials Subject Area in OBIEE Presentation Layers and re-created Web focus Reports in OBIEE with Additional functionality of Drill down, Navigation, Narratives and showcased the data in Tabular and Pivot reports along with Charts and Graphs.
• Created ODI design documents from the existing Information mappings. Used these design documents in development of ODI interfaces/packages.
• Estimated ETL project tasks and helped project manager define scope.
• Analyzed data issues reported by production team and provided solutions.
• Performed environment migrations between the Development, Quality Assurance, and Production environments.
• Developed and customized the physical layer, Business Model and Mapping (BMM) layer and presentation layer as per the business requirements.
• Implemented Data-level security and Object-level Dashboards/Reports security amongusers, groups and web-groups.
• Created proactive agents and configured interactive dashboards to alert the employees as per the requirements.
• Optimized and enhanced the performance of OBIEE reports/Dashboards.
• Setup Multi User Development Environment (MUD) in OBIEE.
• Created different types of customized Drill-down and aggregation reports to meet the client requirements.
• Scheduled reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Extensive trained the end users on OBIEE report and dashboard creation.

Environment: ODI 10.1.3.4, OBIA 7.9.6.3, Oracle on Demand OBIEE 10.1.3.5, Oracle BI Applications HR and Finance analytics, Oracle Applications R12, TOAD.

Confidential, New Haven, CT

ODI Developer

Responsibilities:

• Profit AX is a proprietary system of Confidential & Company, which presents information on Customer.
• Profitability at various levels (Customer, Relationship, Officer, AU, Organizational Unit (OU), etc.) in total or by product. Information is displayed for single and multiple time periods as specified by the User.
• System has two basic modes of usage: Inquiry and the Report Module. In addition, the Profit MAX System has a set of utilities accessible through a menu system such as File Upload, Customer Account Search, Relationship Structure, and Compensation Assignment.
• Worked closely with Business Analysts in understanding the Analytics Requirements and createdBusiness Models for Generating Reports as per the requirements.
• Developed statements of work, interviewed potential candidates and assisted in knowledge transfer for consultants.
• Created need/want analysis matrix for stakeholders to help them set project priorities and scope.
• Managed teams of 4 - 6 consultants for a consulting company specializing in Internet application development .
• Analysis and design of current ETL implementation.
• Worked on the newly developed internal billing system called IRB.
• As per the business requirement created source to target mappings usingfilters, joinsand different SQL expressions.
• Worked with Data modeleron logical and physical modeldesigns.
• Worked closely with developers in process of standardizing job parameters, job flows, audit process and rollback strategies that hold major attention for the successful implementation of DW Incremental.
• UsedTopology ManagerModule to manage the data describing the information systems physical and logical architecture.
• Used theOracle Data Integrator Designerto develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Responsible in configuring Data Servers used in the project using Topology Manager.
• Played a crucial role in assigningUSER PROFILESto developers.
• Interacted with SME's to gather subject area specific requirements and developed Packages using the developed interfaces, procedures and variables.
• Used pl/sql functions to perform control logic.
• Debug the sessions by utilizing the logs of the sessions.
• Responsible forMetadata Administrationand managed models andreverse engineering.
• Responsible forTopology Administrationand performed actions through the topology manager module.
• Performance Tuning of ETL jobs by providing appropriate knowledge modules.
• Creating backups for the interface and also exporting and importing the interfaces from one project to another.
• Worked on error handling for complex interfaces.
• ETL jobs creation & customization using Oracle Data Integrator (ODI).
• Extensively experience in development of E-LT and ETL Mapping in Oracle Data Integrator.
• Created security settings to setup groups, query privileges and access privileges.

Environment: OBIA 7.9.6.4, OBIEE 11.1.1.7, Red Hat Linux, Oracle SQL Developer, ODI.

Confidential, Iselin, NJ

OWB & ODI Developer

Responsibilities:

• Implemented SCD Type 1 and Type 2 using ODI.
• Developed specifications (Document) based on the requirements, such as Businessrequirement Documents, High Level Document and Low Level Document.
• Extensively used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Implemented Change Data Capture (CDC) feature of ODI to minimize the data load times.
• Created Repositories for DEV and migrated it to QA environment.
• Set up the Topology including physical architecture, logical architecture and contexts.
• Implemented and enhanced different Knowledge Modules in mappings for loading and integrating the data from sources to targets.
• Designed Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse.
• Performed reverse engineering for the data sources and targets.
• Developed, supported and maintained ETL (Extract, Load and Transform) processesusing Oracle Data Integrator (ODI).
• Analyzed Session log files in operator navigator to resolve errors in mapping andmanaged session configuration.
• Used markers and memos to distinguish interfaces and projects for ease to otherdevelopers.
• Worked closely with the Data Architects in doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Performed unit and system testing for ETL Packages.
• Created PL/SQL procedures, functions and triggers for tasks outside of ODI.
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.

Confidential

Oracle Apps Developer

Responsibilities:

• Analyzed the business requirements for the enhancements needed in the administration application and related policy modules.
• Designed and developed conversion programs of Customers, Invoices and Items.
• Developed AP Out bound interface program to send the payment information to bank .
• Involved in performance tuning of Interface programs ( PL/SQL)
• Created database objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers.
• Created database packages with related functions and procedures.
• Provided support to QA team.
• Developed and Executed of the Functional Test Cases.
• Tracked defects and provided solutions for the defects which existed in the claim data.