SUMMARY:

• 8.5 years of expertise in design, configuration, development, testing and implementation of Data warehousing and Oracle Business Intelligence Applications.
• Good understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• Technical Expertise in ETL Tools ODI (11g and 12c).
• Worked in the Development of Oracle BI Foundation Suite ODI (11g/12c), OBIEE 11g, and OBIA 11g.
• Advanced skills in Business Intelligence, Data Warehousing, RDBMS and reporting applications.
• Expertise in steering the entire phase of Software Development Life Cycle entailing Software Requirement Specification, Designing (Conceptual Designing), Coding, Testing (Unit testing and Integrated testing).
• Proficient in client interaction, requirements analysis, project work planning and management including design, development, implementation and maintenance of applications.
• Product Development experience and involved in design and architecture of Analytical reporting applications.
• Technically adept in DataMart, OLAP technologies like Oracle BI Applications and ORACLE 11g.
• Experienced in developing ETL for supporting Extraction, Transformation and Loading using ODI 11g/12c.
• Worked on couple of source systems flat files, Microsoft SQL server and oracle as target.
• Worked extensively with complex Interfaces/Mappings using ODI.
• Created Master and Work repositories in Oracle Data Integration tool 11g/12c.
• Installed J2EEAgents and standalone agents.
• Worked on topology by defining Physical Architecture (Data server and physical schemas), Logical Architecture (Logical schemas) and Contexts.
• Experience with different types of components in ODI like Filters, Joiners, Unions, Lookup, Aggregator, Sort, Filter etc.
• Extensively used ODI Knowledge Modules like LKM, IKM, RKM, and CKM.
• Experience with Slowly changing dimension methodology (SCD) and Change Data Capture ( Confidential ).
• Created ODI Interfaces for transforming Source data into Target data format.
• Worked on creating Variables, Sequences, Procedures, Packages, Scenarios and Control Tables.
• Worked on Loops in Packages and created parallel, serial steps in Load plans.
• Evaluate, design, build up, apply, and support Business Intelligence technical solutions using oracle.
• Used ODI toolbox Objects such as odiSendMail, OdiFileWait, OdiWatForChildSession and reference Functions like getPrevStepLog () Method, getTargetTable () Method, getInsertCount (), getErrorMessage (), getUpdateCount (), getErrorCount () etc.
• Scheduled Load plans using scheduler in ODI, customized odiSendMail object to send email to administrator with number of inserts, interface execution time or with error message.
• Worked on Loops in Packages and created parallel, serial steps in Load plans.
• Knowledge on JSON/NoSQL.
• Good knowledge on service knowledge module (SKM).
• Good expertise on ODI Administration.
• Expertize on PL/SQL programming.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing Physical layer, Business Model and Mapping, and Presentation layer of OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
• Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake schemas.
• Skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Worked with customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Expert in using OBIEE Answers to create queries, format views, charts, user Interactivity and dynamic content to enhance the user experience.
• Experienced in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
• Developed Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Very Good experience with Data warehousing and OLAP technology - designing star schema, snowflake schema, fact and dimension tables, physical and logical data modeling using Erwin/MS Visio/Smart Draw.
• Good understanding of Oracle EBS R12.
• Experience with Oracle BI Apps (OBIA) 7.9.x/11g modules- HR, and Finance.
• Good knowledge on Tableau.

TECHNICAL SKILLS:

BI Tools: OBIEE 11g/10g, Discoverer /9i/10g/11g, OBIA 11g/7.9, BI Publisher 10g/11g, Forms 6i/9i/10g/11g, Reports 6i/9i/10g/11g.

ETL Tools: Oracle Data Integrator 11g/12c. Informatica V9.1/8.6/8.5

Databases: Oracle RDBMS, Oracle 8i /9i/10g/11g, MS SQL Server 2000/2003/2008

Languages: SQL, PL/SQL, C, C++, Java, JSP, XML, PERL

Operating System: UNIX, Linux (Red hat enterprise),Solaris and WINDOWS 98/2000/NT/XP

Other Tools: Toad, SQL Navigator, SQL*Plus, SQL*Loader.

PROFESSIONAL SUMMARY:

Confidential, Austin, TX

ODI & OBIEE Developer

Responsibilities:

• Created models for the data sources - flat files, MS SQL server, Oracle.
• Worked on Join and Look up interfaces, Variables, Scenarios, Packages, parallel and serial steps in load plans.
• Worked on all 4 types of variables refresh variables, Set Variables, Declare variables, Evaluate Variables.
• Worked extensively with complex Interfaces/Mappings using ODI.
• Created Master and Work repositories in Oracle Data Integration tool 11g/12c.
• Installed and worked on J2EEAgents and standalone agents.
• Worked on topology by defining Physical Architecture (Data server and physical schemas), Logical Architecture (Logical schemas) and Contexts.
• Experience with different types of components in ODI like Filters, Joiners, Unions, Lookup, Aggregator, Sort, Filter etc.
• Worked on Loops in Packages and created parallel, serial steps in Load plans.
• Design, build, apply, and support Business Intelligence technical solutions using oracle.
• Used ODI toolbox Objects such as odiSendMail, OdiFileWait, OdiFileCopy, OdiFileMove, OdiWaitForChildSession and reference Functions like getErrorCount (), getPrevStepLog () Method, getTargetTable () Method etc.
• Scheduled Load plans using scheduler in ODI, customized odiSendMail object to send email to administrator with number of inserts, interface execution time or with error message.
• Extensively Worked in Version Control, Customization of Knowledge Modules.
• Did reverse engineering for the data sources and targets.
• Extensively used ODI Knowledge Modules like LKM, IKM, RKM, and CKM.
• Experience with Slowly changing dimension methodology (SCD) and Change Data Capture ( Confidential ).
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle Data Integrator (ODI).
• Designed the ETL flow existing system to reuse the existing logic of to meet tight schedules.
• Responsible for developing PL/SQL Procedures/Functions and called from ODI.
• Involved in unit testing, integration testing and system Testing and maintain detailed project documentation.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Designed, implemented and tested security privileges on Dashboards and Reports.
• Worked using Catalog Manager to migrate Web Catalog among Instances.
• Customized Out of the Box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics and Procurement and Spend Analytics.
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Customization and enhancement of standard Oracle applications reports in Account Payables module like Invoice Aging Report, Invoice Validation report, Cash requirement reports.
• Scheduled Load plans using scheduler in ODI.

Environment: PeopleSoft 9.2,OBIEE 11.1.1.7, OBIA 11g, MS SQL,OBIA 11g, Oracle Data Integration 11g/12c, PL/SQL, Oracle RDBMS, DAC 11.1.1, SQL*Loader, TOAD. Oracle Exadata database machine.

Confidential, Pittsburgh, PA

ODI & OBIEE Developer

Responsibilities:

• Worked with Business Owners to gather requirements and work closely with reporting team in a BA/Developer Capacity.
• Created Mock ups, Business Requirements Documents, test case documents with business user inputs.
• Creation of Dimensions, Facts for the Star schema design.
• Developed parallel jobs with collection of all source stages, target stages and processing stages like Aggregator, Transformer, look-up, join etc.
• Worked with ODIRefFunctions like get columns, get previous session Log Details, Get Inserts, Updated on Target Table, Get Error message, get execution time etc.
• Worked on Various kinds of ODI Toolbox objects/Components.
• Created Load Plans with Parallel and serial steps for data processing.
• Used all 4 types of variables in ODI packages.
• Worked variables refresh variables, Set Variables, Declare variables, Evaluate Variables.
• Created and tested ODI packages and Scenarios for Unit and Integration Process.
• Responsible for developing, support and maintenance of ETL processes using ODI
• Responsible for developing PL/SQL Procedures/Functions and called from ODI
• Responsible for handling CR’s (Change Requests) and enhancements for existing application following change management process
• Assisted DBA with upgrading ODI 10g to ODI 11g
• Assisted Client testing team with test data preparation for all releases
• Participated in code reviews, did code migration from DEV to TEST, staging and production environment using ODI Export/Import.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Helped QA team in writing the appropriate test scenarios.
• Experience in Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports).
• Created the physical and complex joins in the Physical and Business layers.
• Created Repository Groups and Web Groups and assigned users to configure security in OBIEE.
• Worked on Dashboard and Page level prompts and Report filters.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Developed Order/Invoice Detail Report, Sales Tracking Report, and Back Order Detail Report in Order Management.
• Customized Employee listing report Invoices on Hold report and Suppliers report as per the business requirements.
• Customized AR aging reports in Accounts Receivable (AR) and Chart of Account Detail Reports.

Environment: Oracle Data Integrator 11g, OBIEE 11g, ODQ, PL/SQL, SQL, Oracle RDBMS, SQL Loader, PeopleSoft, Toad, Flat files, Oracle 11g, Shell Programming, Toad, SQL Developer, Unix scripting, Windows XP Professional.

Confidential, Austin, TX

OBIEE Developer

Responsibilities:

• Designed Metadata repository - Physical, BMM and Presentation Layer.
• Defined Connection Pools to the Source Data Mart tables in the Physical Layer.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• Created Presentation catalogs for Sales and Month End Account measures.
• Siebel Analytics Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching).
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created Repository Groups and Web Groups and assigned users to configure security in the Siebel Analytics Server.
• Defined Session variables in the repository to populate the current date filters.
• Worked on Dashboard and Page level prompts and Report filters.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System to staging system and to the target Analytics Warehouse.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Modified several Customized Reports like Credit/Debit Memo Report, Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports as per changing business needs using XML/BI Publisher.
• Developed Responsible for creating backend procedures and triggers.
• Developed Involved in creating various reports which include tabular, Group by matrix and form letter types.

Environment: Oracle 9i, Siebel CRM 7.8, OBIEE 10g, PL/SQL,XML/BI Publisher, Discoverer3.1, Informatica 6.2, SQL Loader, TOAD, UNIX.

Confidential, Fairfield, NJ

Siebel Analytics Developer.

Responsibilities:

• Designed Siebel Metadata repository.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• Created Presentation catalogs for Sales and Month End Account measures.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels.
• Created item classes, conditions and joins using Discoverer Administrator.
• Registered functions using Discoverer Administrator.
• Developed workbooks in various formats like tabular, page detail tabular, cross-tab and page detail cross-tab format using Discoverer Desktop and Plus.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• Customized various standard reports like Purchase Order Summary, Purchase Orders Outstanding, Purchase Order Detail Report, Invoice Detail Report, Invoice Payment Register, Invoice Payment Outstanding, General Ledger Account Analysis Report etc using Reports 6i.
• Developed new forms using TEMPLATE.FMB and customized existing forms in the OM module according to the client’s requirements.
• Worked on tuning the SQL queries using the tuning utilities TKPROF in UNIX.

Environment: Oracle 9i, Windows/NT, PL/SQL, Siebel CRM 7.8, Analytics 7.7, Reports 6i, Discoverer 4i, TOAD 7.3, SQL Loader.

Confidential, Pittsburgh, PA

Siebel Analytics Developer.

Responsibilities:

• Worked on metadata repository development, Testing and delivering reports to users on time.
• Defined Connection Pools to the Source Data Mart tables in the Physical Layer.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• Created Presentation catalogs for Sales and Month End Account measures.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created Repository Groups and Web Groups and assigned users to configure security in the Siebel Analytics Server.
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels.
• Interacted with functional consultants for mapping legacy data to Oracle tables.
• Developed conversion mapping documents (CV40) to map legacy journal entries, inventory items, and AP vendors and purchase orders to Oracle 9i.
• Developed several workbooks using Discoverer Desktop Scheduled workbooks using Discoverer Desktop.
• Designed and developed reports like pack slip report, trip report, Open Purchase order report, AR aging report and AP trial balance report and registered the developed reports using AOL.

Environment: Oracle 9i, Siebel CRM 7.8, Analytics 7.2, Informatica 6, PL/SQL, Discoverer, Reports 6i and Toad.