SUMMARY

• 8+ years of experience in Analysis, Design, Development, Administration, Testing, Support and user training of Data Warehousing and Business Intelligence applications using ODI, and Oracle Applications.
• Excellent experience in Dimensional Data modelling using Star Schema/Snowflake modelling, FACT & Dimensions tables, Physical & logical data modelling.
• Highly experienced in using Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into Enterprise data warehouse (EDW).
• Well - versed in Data Transformations and Data Migrations using Oracle Data Integrator 10g/11g from heterogeneous sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files and XML Files to perform ETL operations.
• Skilled in using ODI graphical interface modules - Security Manger, Topology Manager, Designer and Operator with versions ODI 10g/11g. Strong experience in Dimensional Modelling using Star and Snow Flake Schema, Identifying Facts and
• Dimensions, Physical and logical data modelling using ERwin and ER-Studio.
• Expertise in ETL methodology for supporting data extraction, loading and transformation processing using ODI Power Center.
• Expertise in ODI setup, Master Repository, Work Repository, Projects, Models, Packages, Interfaces, Scenarios, Filters, Metadata and extensively worked on ODI knowledge modules (LKM, IKM, CKM, RKM and JKM).
• Excellent experience in designing and implementing complex ETL/ELT jobs.
• Expertise in creating and implementing functionalities like Dimensional Hierarchies, Measures, Aggregation rules, Level based measures, Rank functions, Time Series Objects.
• Familiar with database performance tuning by implementing materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and analyzing query execution using the explain plan.
• Worked extensively on debugging, troubleshooting the defects and production issues in the areas of ODI jobs.
• Highly experienced in working with OBI Answers, OBI Dashboards, BI Publisher and OBI Delivers.
• Involved in developing conversion and interface program in Oracle AP, AR, GL, INV and OE modules.
• Extensively involved in developing Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Involved in performance tuning of Oracle SQL, PL/SQL queries.
• Extensively worked with third party database tool like SQL Developer.
• Excellent client coordination, experience working closely with them in order to understand their requirements, issues and suggesting relevant solutions.
• Self-starter, highly motivated team- player with excellent communication / problem-solving skills, quick learning ability, easily adaptable to new environments.
• Recognized by managers and colleagues as a strong, positive leader and a sharp strategic thinker.

TECHNICAL SKILLS

ETL Tools: ODI 10g,11g,12c

Databases: Oracle 9i,10g,11g, Sql Server (2008 & 2012)

Hardware & Operating Systems: Linux, HP Unix, Windows 9x/2000/NT/XP, Windows Server 2005, 2008 R2

Programming Languages: SQL, PL/SQL, T-SQL

Data Modeling: MS Visio Diagrams / Erwin, Designer 2000

PROFESSIONAL EXPERIENCE

Confidential, Richmond VA

Sr. ODI Developer

Responsibilities:

• Developed complete specifications for required ETL mappings. Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data Sources / targets.
• Performed the unit testing, system integration testing and assist with user acceptance testing
• Documented the ETL detailed design and test results.
• Created and maintained integration process using ODI and load rules
• Liaisoned with Oracle support for Service Requests (SRs) and resolution of any issues
• Documented new requirements, recommended and implement solution
• Coordinated testing and changes to the application, Ensured data quality throughout entire ETL procedure
• Developed technical understanding of the application, as well as, an understanding of how the business uses this information and the data flows from system to systemin order to define and execute cross-functional data movements for business intelligence
• Worked with multiple sources such as Relational database, SQL server, Flat files for Extraction, Transforming and Loading data.
• 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.
• Developed and maintained project plans to manage scope and estimated delivery schedules on the project.
• Created a utility to take the daily backups of the repositories.
• Created Data Lineage documents for repositories.

Confidential, Richmond, VA

Sr. ODI 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 Informatica 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.
• Implemented Data-level security and Object-level Dashboards/Reports security among users, groups and web-groups.
• Created proactive agents and configured interactive dashboards to alert the employees as per the requirements.
• Created different types of customized 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. Drill-down and aggregation reports to meet the client requirements. 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

Confidential, CA

OWB & ODI Developer

Responsibilities:

• Implemented SCD Type 1 and Type 2 using ODI.
• Developed specifications (Document) based on the requirements, such as Business Requirement Documents, High Level Document and Low Level Document.
• Conducted research and analysis of business requirements, problems and available technologies to define systems solutions that increase efficiency and effectiveness.
• Involved in translating functional requirements into technical requirements. analyzed and used various data sources - DB, XML, Excel, and OLAP.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modelling.
• Customized and developed RPD (Physical, BMM and Presentation Layer).
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics web.
• Performed Unit, Integration, and Regression testing to validate report. Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards.
• Analysis and design of ETL processes.
• Worked in the implementation of DW Incremental (pull and load) that constitutes different subject areas
• Like (Payroll, Financial Transaction, Compensation Request, Agreement, Party, Contact Point) for different source systems.
• Interacted with business analysts and modelers for better understanding of individual subject areas and modified specifications to reflect accurate user needs.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Worked with Data modeleron logical and physical modeldesigns
• Worked closely with team leads in process of standardizing job parameters, job flows, audit process and
• Roll back 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.
• Configured and setupODI,, master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata.
• Responsible forMetadata Administrationand managed models andreverse engineering.
• Responsible forTopology Administrationand performed actions through the topology manager module.
• UsedKnowledge Modules (KM)to load and transform the data from different data sources
• Used surrogate key assignment and change data capture

Confidential, FL

ODI Developer

Responsibilities:

• Installed ODI and Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Trouble shooted 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.
• Did 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 (rpd) 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 training, responding to questions, resolving problems, and providing ad-hoc reporting.

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.