SUMMARY:

• Around 7+ years Information Technology experience including 5 years of experience in Business Intelligence Applications using Oracle Data Integrator (ODI) / Oracle Business Intelligence (OBIEE). Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, Informatica, DAC ETL tool‘s, System Analysis, Design and Data Modeling.
• Extensively used ODI (Oracle Data Integrator) to perform ELT from heterogeneous sources using ODI tools - Security Manger, Topology Manager, Designer and Operator with versions ODI 10g(10.1.3.5,10.3.5.6) and ODI 11.1.1.x.
• Good Experience in Oracle Business Intelligence with version 10g and 11g.
• Worked on different Modules in OBIA like finance,Suppy chain and order management, Procurement and spend analytics .
• Good experience in implementing the EBS SSO Integration and Ldap Integration with OBIEE and windows active Directory Authentication.
• Good Experience in implementing the Act as, Writeback, Usage tracking Functionalities in OBIEE.
• Excellent knowledge on the ODI Knowledge Modules such as LKM, IKM, CKM, JKM.
• Good experience in Installing and ConfiguringODI environment.
• Upgrading ODI from 10.1.3.C to 11.1.1.X on multiple platforms.
• Patching ODI 11.1.1.6.0 to 11.1.1.6.4 .
• Created ODIProcedure,ODIPackage, ODI Variables, ODI Scenarios,, ODI Functions, ODI Mappings, ODI LoadPlans
• Created users, profiles and assigned objects in security.
• Created context in ODI mapped Physical architecture and logical architecture
• Loaded data from flat files,xls file to target schema in ODI.
• Worked on ODI components expression,lookup,join,split,sort,distinctinmappings.
• Moved data from dev to test and test to prod using smartexport and import in ODI.
• Hands on experience in Change data capture(CDC) using journalizing knowledge module.
• Working in design, development and configuration of RPD, Dashboards, Reports, Analysis& Interactive Reporting, OBIEE 11g new functionality and implemented Filters, Scheduled Reports, Prompting, Drill Thru, Multi-lingual reporting, Performed XML Manipulation. Design reports and dashboards using OBIEE11Gdimensional hierarchies. Design and dashboards.
• ETL processes for a data warehouse implementation of Oracle EBS R12 using, including experience in data extraction, scrubbing, cleansing, transformation, dimension and fact building, loading, as well as in-depth knowledge of and experience with SCD, Incremental Update, and tuning of large volume extracts for efficiency of both space and time.
• Implemented Multi-user Development Environment (MUDE) Using Oracle BI Administration Tool.
• Worked in setting up security and architecture with OBIEE 11g /10g by using web logic admin console and enterprise manager.
• Determine the technical feasibility of the requirements against the OBIEE capabilities.
• Collecting the artifacts and connection details for the object to be upgrade for OBIEE, OBIA, INFORMATICA and DAC.
• Hands on experience with ETL, Dimensional Modeling & Business Intelligence & capability with the performance tuning of the OBIEE application suite.
• Strong experience in developing warehousing applications and customizing Reports using OBIEE 11.1.1.6, 11.1.1.5 10.1.3.4. x/10.1.3.2.x, XML/BI Publisher, BI Answers.
• Management(Data level/Object level security), Variables, Initialization blocks and cache management.
• Worked on Setting up Dynamic, System and Non-System Variables.
• Extensively worked on Power Center Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, MappletsDesigner, Mapping Designer, Repository manager.
• Technical Experience in developing Informatica Mappings / Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Experienced with designing ETL execution plan and scheduling task using DAC.
• Expertise in Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL.

TECHNICAL SKILLS:

Methodologies: Dimensional Data Modeling Logical / Physical

OBIEE Tools: OBIEE 11.X/10.X, OBIA 7.9.5/7.9.6/ & DAC.

ELT/ETL Tool: ODI12c, ODI 11.1.1.X, Informatica 8.6.0/8.6.1/9.0.1, Informatica on Demand.

OBI Apps Modules: Supply Chain, OM, Financial &Sales Analytics.

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

Query Tools: SQL, PL/SQL, TOAD

Languages: C/C++, C#, XML, HTML,Java.

Operating Systems: Windows 98/00/NT/XP, Redhat Linux, Windows 2000/2003/2008 R2

Other: Visio, MS Office, Adobe Acrobat.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

ODI/OBIEE Developer

Responsibilities:

• Worked on Oracle Enterprise Manager to activate and Deploy RPD.
• Extensively used Catalog Manager for migrating Web Catalog.
• Worked on the RPD for the new Subject area design for the Cash flow Metrics
• Created Reports, Dashboard Prompts and Dashboard Pages like - Budget and Actual, Balance Sheet.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, Active Directory-LDAP, 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.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 ODIProcedure,ODIPackage, ODI Variables, ODI Scenarios,, ODI Functions, ODI Mappings, ODI LoadPlans
• 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.
• Provide ad hoc ability in the OBIEE system for query and build reports.
• Configured the OBIEE repository(Physical, BMM and Presentation layer)
• Created dimension hierarchies and aggregates in the BMM layer.
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements.
• Performed Data Validation of data in the reports and dashboards.
• 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 Tuningof 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, ODI 10.1.3.4,OBIEE 11.1.1.6.5, OBIA 7.9.6.3, Oracle EBS, Oracle 11g, SQL*PLUS, SQL Developer, Windows XP

Confidential

ODI /OBIEE Developer

Responsibilities:

• Requirement analysis gathering, analyzing the functional and technical specifications.
• Creating separate environments for Development, QA and Production.
• 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.4 .
• Testing the newly upgraded ODI 11G, fixing issues related to upgrading and running ODI jobs as per schedule
• Worked on Static control and flow control in odi
• Worked on Error tables and flow tables.
• Creating standalone agent on windows server.
• Configuring windows standalone agents with OPMN and running windows agents as services.
• Creating packages for Historical loadand incremental load and running the jobs through agents.
• Installed and Setup ODI Master Repository, Work Repository, Execution Repository
• As an administrator I was responsible for security across multiple users,Profile and objects.
• Responsible for moving scenarios across multiple environments.
• Created Different user groups based on user role and responsibility.
• Scheduling, monitoring jobs daily and data load from scheduled jobs.
• Imported tables using connection pool and designed Star schema.Technical Impact analysis on ETL/OLAP design.
• Mapped presentation layer objects to Oracle BI Answers.
• Used BI publisher for static reports and configured IBOT to schedule the BI reports.
• Created Dashboard, portal, and ad-hoc reports In Oracle BI Presentation services.
• Defined Security Level in OBIEE.
• Managed the catalog manger in OBIEE.
• Developed RPD from scratch for custom warehouse to create OBIEE interactive reports.
• Created presentation and server variables for reports.
• Created global prompts to use across the Dashboard pages.
• Performance tuned the existing parameters to improve and enhance the performance to load data for OBIEE reports development.

Environment: ODI11.1.1.6 and 11.1.1.6.4, OBIEE 10.1.3.4.1/11.1.1.6, OBIA, Oracle 11g, Windows XP, Windows server 2003, RPD

Confidential, WA

OBIEE Developer

Responsibilities:

• Studied 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 Project Scoping, Project Organization and Management including Business & IT Requirements, Priorities.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed Expression calculation,join,split,filter,procedures,varibales,packages using ODI
• Created FACT table Calculation in RPD
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Created Global and project variables in ODI
• Experience in BI Applications in development of rpd, data models and integrating with EBS, SFDC for development
• Created Facts like Opportunity, Project for Project Portfolio Subject Area.
• Created Metrics like Conversion rate, Amount in USD.
• Created Customized Dashboards like Pipeline, Project Portfolio catering to provide insight into the sales / marketing / financial data.
• Developed Dimension Hierarchies in BMM layer in RPD
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
• Developed custom reports using Answers and assigned them to application specific dashboards and dashboard prompts.
• Created BI Publisher report based on Answers report
• Worked on OBIA on Supply Chain module in organizing data and implementing security.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes and managed day-to-day Repository, Scheduler&iBots.
• Managing appropriate security privileges on subject areas (Data Level) and dashboards (Object Level) according to business requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Integrating and automating Informatica workflow loads using DAC.
• Created tasks and execution plans in DAC and scheduling the ETL run.
• Developed customized mappings, sessions and workflows for some of the Subject Areas, using the Informatica Power Center Designer, Power Center Workflow Manager.
• Created new reports in BI Publisher and made substantial modifications to existing reports, to meet new needs.
• Involved in unit testing, integration testing, Functional testing to analyze and fix the issues encountered.
• Performed end-user to develop ad-hoc reports using OBIEE Answers.

Environment: OBIEE 10.1.3.4, RPD, OBIA 7.9.6, Oracle EBS, ODI 10g, Oracle 11g,OBIA, SQL*plus, PL/SQL, TOAD, DB2, Quality Center, Windows XP,DAC,Informatica 8.0.X

Confidential, CA

OBIEE Developer

Responsibilities:

• Installation, Configuration and Administration of Informatica Power Center Client, Server(8.6.0), Oracle 10g and OBIEE 10.1.3.4
• 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.
• Extracted data from various source systems like relational data bases, Flat files and data into the data warehouse using Informatica On Demand.
• Extensively used Informatica On Demand for replicating the data from Sales Force to local Database.
• Developed new Adapters using Informatica 8.6.1, complete end to end development against Salesforce.com source.
• Extensively worked in developing SalesForce Adapters for Sales and Opportunities.
• Worked on extracting the legacy data from the application.
• Created Facts like OpportunityLineitem, OpportunityHistory, Sales, Budget, Goals and dimensions like Opportunity, PriceBookEntry, User, Region, Account,
• Created reusable transformations and Mapplets and used them in mappings.
• Performed Execution plans in the DAC Console.
• Custom built the OBIEE repository (RPD) from the scratch with 4 Facts and 9 Dimensions and 4 conformed Dimensions.
• Created metrics like MTD Sales, QTD Sales, YTD Sales, MAGO Amount, QAGO Amount and MTD Expected Revenue, Opportunity Amount.
• Performed high level and detailed design of the star schema as well as the reporting metadata.
• Analyzed reporting requirements for dashboard reports and created dashboard prompts.
• Created some Reports for analyzing the Trend in Opportunities, sales and Sales Reps Efficiency.
• Developed complex and rich Reports using pivots tables, charts, and view selector. Used global and local Filters for data abstraction.
• Developed various test scripts for business users for UAT and assisted them to use and understand the functionality of the tool.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
• Developed process for object level migration of web catalog, for post-production release of - enhanced and bug fixed reports
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements..
• Complete responsible for preparing the END to END Document.

Environment: OBIEE 10.1.3.4, Informatica 8.6.0, DAC 10.1.3.4,OBIA, Informatica On Demand, Sales Force, Flat Files, Oracle10g, Windows XP, PL/SQL, TOAD.

Confidential

PLSQL/ETL Developer

Responsibilities:

• Developed Syndicated oracle packages to include the rolling 24-month syndicated third party data that was mainly in flat files.
• Involved in designing the PL/SQL procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables.
• Provided support activities to their existing warehouse by developing new PL/SQL programs to support their existing structure and also data validation.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Performed mapping gap analysis between existing OTB mappings and already existing tables to support the new requirements.
• Developed complex new Informatica ETL process and Mappings &Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator) and Workflows with Sessions / Tasks.
• Designed and documented multiple interfaces using the Informatica Power Center.
• Developed many complex Informatica mappings and mapplets to build key interfaces using transformations & reusable transformations (Source Qualifier, Update Strategy, Lookup, Expressions and Aggregator) for loading the data into DW.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable / parameters for simplifying complex mappings.
• Performed Database and Informatica performance tuning and implemented the session partitions, changes to database by re-building the indexes, analyzing the objects etc.
• Developed many Shell Scripts for pulling data from remote machines, Backup / Migration of metadata from version, development and production, FTP, untar& sending files to source directory, managing sessions files in the server.
• Extensively developed complex PL/SQL packages for ETL.

Environment: Oracle 9i, TOAD, PL/SQL, Informatica 6.x/7.x, OBIA,Windows XP, Sun Solaris.

Confidential

SQL & PL/SQL Developer

Responsibilities:

• Participated in Requirements review
• Involved in developing E-R model (Entity-Relationship)
• Developed the SQL queries to create tables and Views.
• Developed PL/SQL procedures, functions, Triggers using TOAD.
• Loaded Data using SQL loader and developed the control files for the same.
• Developed custom reports using SQL*Plus.
• Wrote and executed test plans, maintained versions of change components to ensure accuracy and update.
• Tested the software using many methodologies like Functional Testing, Load testing, and Regression Testing. Tuned few queries to resolve Performance issues.
• Used SQL Loader to dump the data provided in the form of flat files from the legacy system into normalized staging tables.
• Developed workbooks and worksheets using Oracle Discoverer for custom queries for analyzing data.

Environment: Oracle 8i, TOAD, SQL Loader, Oracle reports, Oracle Discoverer