SUMMARY:

• Over 7 years of involvement in planning, creating and execution of ODI 12c/11g/ 10.1.3.4/10.1.3.5, Oracle PL/SQL, OBIEE 10g & 11g, 3+ years' involvement in 11g.
• Valuable knowledge of OBIEE 11g and also having hands on experience in OBIEE 10g in integration with BI publisher Extraction, Load and Transformation (ELT) using Oracle Data Integrator (ODI) 11g, Informatica 9.x/8.x/7.x and SQL, PL/SQL.
• Programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Making and tweaking dashboards and reports to meet client prerequisites.
• Responsible for fetching data from Oracle EBS in various industries like Banking, healthcare, Manufacturing, aviation, and Pharmaceutical.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using PL/SQL.
• Developed PL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Development experience with multiple applications in Oracle EBS versions 11i and/or 12x.
• Hands on experience working with Oracle Enterprise Data Quality (EDQ).
• Expert in building repositories using star schema, developing Subject Areas, and applying security (group, access / query privileges) at object and data level in Administration Tool. Hands on experience in customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher (Excel) and Delivers.
• Expert knowledge of report development execution in a complex environment.
• Experience in configuring Standalone agent & Java EE agent in ODI.
• Experience working on migration project from OWB to ODI.
• Experience in Slowly changing dimensions type 1,2, 3 and customization of knowledge modules.
• Administration of OBIEE and the OBIEE Web Catalog.
• Experience in incorporating BI Publisher with OBIEE.
• Installation, configuration of ODI in Unix / Linux environments.
• Experience inOracle supplied packages,Dynamic SQL, RecordsandPL/SQL Tables.
• Proficient in Oracle, SQL, MS/SQL.
• Excellent relational abilities, administration aptitudes, group abilities with result arranged mentality.
• Excellent communication skills, strong architectural skills, hardworking and a good team player.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications,implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Experienced in supporting performance tuning and process tuning at all levels.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Good Exposure in dimensional demonstrating.
• Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.
• Expertise in installing, configuring, and administering WebLogic Server 6.x/7.x/8.x/9.x/10.x/11.x in various environments.
• Implemented the extraction, loading, and transformation (EL - T) of data using Oracle Data Integrator.
• Expertise with all ODI graphic tools - Topology, Security Manager, Designer and Operator and configuring the ODI master and work repositories, ODI models defining and organizing the ODI project including interfaces, packages, procedures, variables and user defined-functions.
• Hands on experience working with ODI Knowledge Modules- LKM, IKM, RKM, JKM, SKMand CKM.Customized versions for the existing ODI Knowledge modules which can be re-used in data integration projects.
• Expert ability to trouble shoots and prioritizes issues.
• Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS:

• Oracle Data Integrator(ODI) 12c/11g/ 10.1.3.4/10.1.3.5, Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL
• Stored Procedures, Triggers),OBIEE 11G/10G, Exadata DMA, Exalogic,R12.2, Reports 10Gg/6i/4i
• WebLogic Server 6.x/7.x/8.x/9.x/10.x/11.x, Discoverer 10g/6i/4i, Forms 6i, XML Publisher 5.6.3/5.6.2
• Oracle Web Application Server 4.0.8, Oracle Enterprise Manager (2.1.0), General Ledger, Accounts Receivables
• Accounts Payables, Order Management, Inventory, Fixed Assets, Cash Management, Advanced Pricing, Service Contracts
• Purchasing, AOL, System Administrator, TOAD, SQL Navigator, SQL*PLUS, SQL* Loader
• Unix Shell scripts, K shell, C shell, SQL, PL/SQL, JAVA, XML, C, C++, Unix, Linux, Windows 7/ NT/XP/2000/98.

PROFESSIONAL EXPERIENCE

Confidential, Boston,MA

Sr. ODI Consultant

Responsibilities:

• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys
• Participated in all the phases of the project from Planning, Discovery, Requirements, Design, Construction, Testing, Pilot and Deployment.
• Helped data modelers in identifying data sources and calculating the formulas for calculating order retail and order cost.
• Designed the entire ODI work flow for automating the process of moving all the Financial Tables from EBS to Data warehouse.
• Wrote detailed design specs for ODI Flow. Converted the functional specs written by Data Modelers into the detailed design spec for ETL. These specs were used in the development of code using ODI.
• Involved in design and developed jobs and performed data loads and transformations using different stages of ODI and pre-built procedures, functions and packages.
• Used ODI Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Set up the Topology including physical architecture, logical architecture and context.
• Installing ODI 11.1.1.6 on all the environments and configuring ODI.
• Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios,, ODI Functions, ODI Mappings, ODI Load Plans.

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

Confidential, TX

Sr. ODI/OBIEE Consultant

Responsibilities:

• Worked on Oracle Enterprise Manager to activate and Deploy RPD.
• Extensively used Catalog Manager for migrating Web Catalog.
• Worked on Oracle Enterprise Data Quality (EDQ) .
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Responsible in the migration of data from Excel, Flat file and XML to Oracle database by using conversions and DTS utility.
• Troubles hooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• 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.
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Installing ODI 11.1.1.6 on all the environments and configuring ODI.
• Patching ODI 11.1.1.6.0 to 11.1.1.6. and Upgrading ODI from 10.1.3.4 to 11.1.1.6.4.
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule.
• 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.
• Financial Planning Manager and other developers
• As an administrator I was responsible for security across multiple users and groups.
• 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.
• Created PL/SQL stored procedures, functions and triggers for change data capture(CDC).
• 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.
• Changed knowledge modules using Java code for AP/AR for General Ledger tables in ODI.
• Performance Tuning of Reports and made required changes to repository and database.
• Complete responsible for preparing the END to END Document.
• Working on UAT data and hierarchy issues.
• Worked with the team and a DBA to communicate and negotiate data needs.

Environment: ODI 11.1.1.5.0, ODI12c, Oracle 11g, SQL*PLUS, PL/SQL, WebLogic Server 11.x, OBIEE 11.1.1.6.5, OBIA 7.9.6.3, Oracle EBS, SQL Developer, Windows XP.

Confidential, TX

Sr. ETL Developer (ODI)

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.
• Resolving day to day production issues.
• Gathering requirements from users to develop interfaces, packages.
• Deploying Scenarios from one environment to other environment.
• Customized Knowledge Modules using Java and Jython for extraction of PDF files.
• Used principles of Normalization to improve the performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdata structures.
• Developed PL/SQL Packages, ProceduresandFunctionsaccordance with Business Requirements for loading data into database tables
• 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.
• 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.
• Export/Import interfaces across different environments
• Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
• Experience in running RCC (Repository consistency check) to see if master and work repositories are consistence.
• Purged the logs in the operator.
• Performed sending mails to team whenever any ODI jobs are failed by using ODI tools.
• Worked in importing data from different sources like database, flat file, XML files, excel.
• 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.
• 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.
• Applied CDC process where we have captured only latest data to target.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.

Environment: Oracle Data Integrator (ODI) 11.1.1.7/10.1.3.5, PL/SQL, Oracle 11g/10g, SQL*Plus, OBIEE 11g, TOAD, WinNT/XP and UNIX.

Confidential, Bentonville, AR

Sr. OBIEE Lead Developer /ODI Developer

Responsibilities:

• Requirement analysis gathering, analyzing the functional and technical specifications.
• Gathered requirement and analysis for contact center telephony customized analytics.
• Migrated System to Exadata, Exalytics for OBIEE, and Exalogic for SOA.
• Install and Integrate OBIEE 11g and configure DAC and Informatica PowerCenter against Oracle R12 application on Exadata X2 and X3 and Exalogic.
• Work closely with business users to ensure completeness of requirements.
• Worked mainly on HR Analytics and worked with ETL team to develop tables and generated reports, as per requirements.
• Worked on creation of adhoc dashboards in OBIEE.
• Worked with detailed reports on various aspects of financial transactions and marketing data to brokers, historical sales, customers and financial centres on daily basis.
• Installed Oracle 11g on Exadata X2 -- provided performance tuning and optimization.
• Extracted the pre-built BI solutions of tables using Oracle BI Apps 7.9.6.(Marketing Analytics)
• Preparing MD50 and MD70 documents for the new functional requirements.
• Working on the Oracle EBS R 12,BI publisher reports, dashboards, adhoc reports.
• Implemented Security by creating roles & web groups using LDAP Authentication.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Created SQLand PL/SQL stored procedures, functions and packagesfor moving the data from staging area to data mart.
• Extensively worked on admin tool, Answers, Dashboards, BI publisher and Security for users. Worked on creating complex reports, and cutomized widgets.
• Designed, developed and modified OOTB reports and dashboards.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Configured users, roles and privileges in administration console.
• Worked on security for users based on LDAP Authentication and SSO in Production and also other Authentication types (External table authentication and Database) in other environments.
• Worked extensively on Custom Build Real-time (OLTP source) and Non Real-Time Reports to enable Market/ Corporate Users to Order Management, Installation Management and Cash Management.
• Created Test Cases based off of the design specifications.
• Created mock reports as per the user requirements.
• Developed liaison with the Business to translate Business issues into IT solutions.
• Created adhoc reports and dashboard mock up as per the requirement.
• Wrote SQL Queries to test the transformations.
• Aggregate Navigation-Creating aggregate tables using materialized views.
• Executed Test cases in all phases of testing Regression testing, Integration Testing, System testing, end-to-end testing and UAT.
• Develop Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.
• Worked on Exadata -- Apps tier and database -- configuration, administration and tuning.
• Observed configuring DAC environment created and scheduled execution plans.
• Involved in adding all the newly developed Dimension, General, Aggregate and Fact tables in to DAC and creation of new Subject Areas.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Performed Report Validation and Integration Testing and manipulations using SQL.
• Exposure and knowledge of ETL transformation using ODI.

Environment: Oracle BI Apps 7.9.6,OBIEE 10.1.3.4, Exadata, Exalogic, Exalytics, Oracle 11g, ODI, SQL, PL/SQL, DAC 10.1.3.4.1, Oracle 10g R2ERwinr7.3, SQL, SQL Developer 1.5, HTML, Solaris 5.1, Windows Server 2003.

Confidential, PA

OBIEE Developer/ETL Developer

Responsibilities:

• Implemented Financial Analytics and Procurement and Spend Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Upgraded Whole BI platform from 10.1.3.4.0 to 10.1.3.4.1 and BI Apps from 7.9.5 to 7.9.6.1.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Implemented and worked on Multi User Development Environment (MUDE).
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Experience creating, enhancing and optimizing simple to complex reports using Oracle Business Intelligence reporting tool including implementing functions to customize and enhance reports. Performed data analysis and modeling to write accurate and optimal SQL queries for BI Publisher reports.
• Responsible for day-to-day running of a busy team and able to mentor and guide team members.
• Developed PL/SQL packages and created Temp tables, which were used in Informatica and to develop reports in BI.
• Content settings, Complex joins fragmentation content and defining of Most Economical Source as per business requirement.
• Extensively involved in unit testing, peer testing and regression testing.
• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system to Data Warehouse.
• Extensively developed mappings on various business areas in the project by employing the available Transformations.
• As reporting architect on various Oracle Application implementations, made effective use of Business Intelligence as primary and adhoc-reporting tool. Defined strategies, custom designed and developed Presentation Layers, defined standards and processes for BI Development Cycle, performed BI installations, tuning, Testing and Bug fixing.
• Designed and developed Analytics Metadata Repository (.rpd) using Oracle BI by importing the required objects with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies), Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.

Environment: Oracle Applications 11i/R12 General Ledger, Account Payables, Accounts Receivables, Inventory, Purchasing, Fixed Assets, BI Apps 7.9.6, OBIEE 10.1.3.4.1 /10.1.3.4/10.1..3.3/10.1..3.2, Informatica 8.6.0, DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i,, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential

OBIEE Developer

Responsibilities:

• Created Dashboards and Answers for End user.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• 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.
• Was involved in the installing and configuring of Financial Analytics.
• Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Developed Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Responsible for extracting data from Oracle Apps Modules & loading into stage system and warehouse system.
• Created and ran Sessions & Workflows to load the data into the Data warehouse.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Configured and Scheduled Sessions and Workflows.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
• Worked on multiple folders at time to meet the dead lines of the tasks.
• Created VPD security for reports in OBIEE.
• Designed and developed logical model in BMM in Repository.
• Installed and Configured DAC.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Created custom reports in Payables in OBIEE according to user requirement.

Environment: Oracle Applications 11i/R12 iProcurement, General Ledger, Account Payables, Accounts Receivables, Fixed Assets, BI Apps 7.9.5, OBIEE 10.1.3.4.0/10.1..3.3/10.1..3.2, Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i,, SQL*PLUS, SQL*Loader, TOAD, Unix.