SUMMARY

• 8+ years of IT experience in complete Software Development Life Cycle (SDLC) in Client/ Server, Database, Oracle Data Warehouse and Business Intelligence applications in Windows and Linux/Unix environments from initiation through design, development, deployment and post go - live support.
• Working knowledge experience on Analysis, Design, Development, Implementation of Data Warehousing in ETL process using ODI 12c/11g and Informatica
• Worked with knowledge modules like JKM,LKM, IKM and CKM in ODI.
• Developed packages, scenarios using interfaces and variables.
• Experience in designing and developing interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.
• Used ODI commands like ODI File Move, ODI FileAppend, ODI Filecopy etc
• Experience in SQL and PL/SQL programming for ODI, Informatica and oracle.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Extensive experience in developing the load plans, packages and job scheduling.
• Worked on slowly changing dimensions SCD, Change data capture CDC as part of data warehousing concepts.
• Experienced in building/customizing ETLs from Source Systems such as EBS to DataWarehouse
• Knowledge of Database architecture for OLTP and OLAP applications, Data Analysis, ETL, Reporting processes in developing Data marts and Enterprise Data Warehouse.
• Complete Knowledge of data warehouse methodologies (Ralph Kimball, Inman), ODS, EDW and metadata repository
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) andMappingsusingInformatica Designerand processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Experience in creatingReusable Tasks(Sessions,Command,Email) andNon-Reusable Tasks.
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Experience in Designing Informatica logic for SDE, SIL Mappings and Workflows, DAC Subject areas and Execution plans.
• Experience in usingData Warehouse Administration Console (DAC 10.1.3.4)for scheduling and executing Incremental ETL loads.
• Experience in Scheduling and monitoring Informatica sessions in DAC.
• Troubleshooting production issues and gave post production support for couple of projects.
• Experienced indesigning customized interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers includingPhysical, Business Model and Mapping, and Presentation layer.
• Experienced in migration of OBIEE reports and dashboards between dev/test/prod environments.
• Experience in setting up a Multi-User Development Environment (MUDE) and using OBIEE Answers to run queries to test and validate the repository.
• Extensive experience in creating executive reports withBI Publisherintegrated with OBIEE.
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Experience in creating executive reports withBI Publisherintegrated with OBIEE.
• Exposure to Insurance, Banking, Financial, Healthcare, Industrial sectors and business with regard to Data warehouse development.
• Good experience in Linux and writing shell scripts.
• Expertise in building Relational Databases using SQL Server and Oracle and knowledge of Essbase server upgrades.

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business suite R12/11i OM, INV, GL, AP, AR, AOL.

Business Intelligence: OBIEE 11.1.1.7, OBIEE 12C/11g, OBIA/BI APPS11g/7.9.6.x/7.9.5, OBIA 11.1.1.8,BI Publisher, (Web, Answers, Dashboards)

ETL Tools: ODI 11g/12C, Informatica 9x/8x/7x

Databases: PeopleSoft, Oracle EBS, Oracle Commerce, Oracle 8i/9i/10g/11g/12C, DB2, Redshift, Teradata

Other Tools: TOAD, Oracle SQL Developer, DAC (7.9.4, 7.9.5, 10.1.3.4.1 )

Languages: Java, HTML, XHTML, XML, VBScripts, Javascript, C++

Operating System: Windows NT/2000/2003/XP, UNIX, Linux and Mainframes

Scripting Languages: UNIX shell scripts and K shell

PROFESSIONAL EXPERIENCE

Confidential, Chicago, Illinois

OBIEE/OBIA Developer

Responsibilities:

• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Customized ETLs from Source Systems such as EBS to DataWarehouse
• Created variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Creating and customizing ODI interfaces, mapping, joins, filters lookups to implement business rules.
• Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Customized and extended dimension tables like W PARTY D and W SUPPLIER ACCOUNT D. Added new columns to these tables as per the requirement.
• Customized and extended fact tables like W PROJ FORECAST F and W AP XACT F.
• Developed custom mappings and extended the existing out of the box (OOTB) mappings in ODI to add additional attributes to the warehouse tables.
• Created numerous Views, Materialized Views, Stored Procedures andFunctions which were used in ODI and OBIEE
• Migrated the ODI scenarios across different using PPM packages.
• Responsible for creating Test plans and co-ordinate with Testing Teamin executing test plans for the ETL Interfaces.
• Involved in creation of complete new folders and mappings utilizing the universal adapters to bring in data from third party source systems
• Worked on BI Procurement and Spend Analytics 7.9.6.3.
• Involved in development of new training sets with transactions having no Purchase Orders and made sure these transactions were classified in accordance with the EBS categories assigned for PO Suppliers.
• Performance tuningof ODI ETL and OBIEE Queries.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to data warehouse (OLAP) system.
• Built the physical layer, BMM layer and the presentation layer of a repository by using star and snowflake schemas.
• Created different types of Customized Reports Drilldown,Aggregationto meet client requirements.
• Customized the repository with new custom functionally and developed new Reports / Dashboards with differentAnalytics Views.
• Set up Multi User Development Environment (MUDE) to enable multiple developments of different projects.
• Worked with EBS teams to co-ordinate and validate the data sourcing chances to OBIEE as part of EBS upgrade.
• Involved in development of test scenarios and test cases and tested the reports for performance.
• 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.
• Performance Tuningof Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Performance tuningof ODI ETL and OBIEE Queries.
• Responsible for updating/ tracking and documenting the development changes at bothETL levelandrpd level.

Environment: Oracle EBS R12.1.3, OBIA/BI APPS 12C/11.1.1.8, BI Publisher, Oracle Business Intelligence 12C/11g,ODI 12C/11g, Oracle DB 12C/11g, HP ALM, SQL, PL/SQL, TOAD.

Confidential, Cleveland, Ohio

OBIEE/OBIA Developer

Responsibilities:

• Installed configured and extended financial, procurement and spend analytics 11.1.1.8.
• Configured and setup ODI,master repository, work repository, Models, sourcesandKnowledge Modules.
• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load toOracle Business Analytics Data Warehouse OBAW.
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets includingEssbase,Relational Database Management serversincluding Oracle RDBMS, SQL Server, and IBM DB2 andflat filesincluding CSV, Excel, XML file formats.
• Worked onTopology Managermodule to manage the data describing the information systems physical and logical architecture.
• Extended W AP INV DIST F table to add additional attributes from R12 as per reporting needs.
• Part in implementing OracleBI Appsusing ODI and OBIEE application tools.
• Project involves building anOrder Management and Supply Chain Analyticsby souring data from transactional OLTP system and loading them to the Oracle Business Analytics Warehouse OBAW and creating user friendly Dashboards.
• Used Type1 SCD and Type2 SCD mappings to update slowly Changing Dimension Tables.
• Customized and developedRPD (Physical, BMM and Presentation Layer).
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Designed and developed variousInteractive Dashboards, reports and direct SQL reports with drilldowns, guided navigation, filters, and prompts.
• IntegratedBI Publisherwith OBIEE to build reports in word, excel and doc format.
• ConfiguredBI SchedulerandOracle BI Delivers- iBotsto deliver alerts and publish updated content to subscribed users as per the schedules and requirements.

Environment: Oracle EBS R12.1.3,OBIA/BI APPS 11.1.1.8, ODI 12C/11g,BI Publisher, Oracle Business Intelligence11g,Oracle 11g, TOAD

Confidential, Minneapolis, Minnesota

OBIEE/ Lead ODI Developer

Responsibilities:

• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Installed the J2EE ODI Agents on WebLogic server as part of ODI setup.
• Responsible for setting up ODI in all the environments (DEV, UAT and PROD) which includes all the tasks from Installing and configuring ODI to releasing the environment to users (client installations and other related tasks).
• Troubleshooted 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.
• Migrate the ODI scenarios across different environments (from Dev to UAT and then to Prod) using smart export and import.
• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load toOracle Business Analytics Data Warehouse OBAW.
• Automated cache purging process using iBots and configured cache management at various layer i.e. BI server presentation server browser etc.
• ImplementedCDC(Change Data Capture) to capture the changes on the source.
• Performance Tuning of ETL jobs by providing appropriate knowledge modules.
• Used Topology Manager module to manage the data describing the information systems physical and logical architecture.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle.
• Did SQL programming for ODI and oracle.
• Developed interfaces for loading the lookup and transactional data.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Performance tuned the ODI interfaces.
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Conducted code reviews and planned the knowledge transfer to client.

Environment: ODI 11g/12C,BI PublisherOracle, Commerce, OBI Apps11.1.1.8, DAC 11G, Oracle Business Intelligence 11g, Oracle 11g, TOAD

Confidential, Indianapolis, IN

OBIEE / OBIADeveloper

Responsibilities:

• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, MS SQL server, Oracle.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Developed interfaces for loading the lookup and transactional data.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Used Topology Manager module to manage the data describing the information systems physical and logical architecture.
• Develop operational process and procedures for monitoring ODI scenarios & agents for production troubleshooting and analysis.
• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load toOracle Business Analytics Data Warehouse OBAW.
• Automated cache purging process using iBots and configured cache management at various layer i.e. BI server presentation server browser etc.
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Develop the migration process required to migrate the ODI configuration through various test environments including the production and contingency environments.
• Performance Tuning of ETL jobs by providing appropriate knowledge modules.
• Configured connection pool for the database connection in the Physical Layer
• Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.
• Integrated BI Publisher with OBIEE. Created Templates such as Employee Detail, Reports, Prompts such as Customer Name in BI Publisher
• Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per the requirement.

Environment: Oracle EBS R12.1.1,ODI11g/12C, Oracle Business Intelligence 11g,BI Publisher 11g(11.1.1.7), Oracle 11g, BI Apps7.9.6.4,Oracle DB

Confidential, Indianapolis, IN

OBIEE / Lead ODI Developer

Responsibilities:

• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Created ETL for sourcing the data received in Excel files for tracking error logs
• Created new models for the data sources - flat files, MS SQL server, Oracle.
• Did SQL and PL/SQL programming for ODI and oracle.
• Created ODI packages, scenarios using interfaces, variables.
• Used ODI commands like ODI File Move, ODI FileAppend, ODI Filecopy etc
• Optimized the knowledge modules to improve the functionality of the process.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Working knowledge experience on Analysis, Design, Development, Implementation of Data Warehousing in ETL process using ODI 12
• Delivered ODI packages to support the 10 identified KPIs, documentation and skills knowledge transfer to Confidential personnel.
• ImplementedCDC(Change Data Capture) to capture the changes on the source.
• Worked closely with Business users. Provided options and alternative solutions to Business during data anomalies etc
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Developed test cases and performedUnit Testing and Integration Testingof the Repository and Web Catalogs.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Designed and developed variousInteractive Dashboardsand reports with drilldowns, guided navigation, filters, and prompts.
• Participated in all the phases of project - development, testing, deployment and support.
• Experience in analyzing the processes while considering Key Performance Indicators (KPI’s).
• Develop, test & document data feeds / cleansing using ODI for top 10 KPIS including skills transfer to Confidential team.
• Developed, initially tested & documented OBIEE scorecards content for top ten KPIs.
• IntegratedBI Publisherwith OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.
• Developed templates and reports inOracle BI Publisherin rtf format.
• Involved in documenting, tracking and resolving issues during testing and skills/knowledge transfer to Confidential personnel.

Environment: Oracle Data Integrator 11g, Oracle EBS, BI Apps7.9.6.4, Oracle Business Intelligence 11g,BI Publisher, Oracle 11g, Oracle DB

Confidential, Novato, CA

OBIEE / Informatica Developer

Responsibilities:

• Developed and implemented the ETL approach from staging to target which is common irrespective of source system using Informatica.
• Created ETL for sourcing the data received in Excel files for vendor processed payments
• Worked on creating reports using the existing/ extending metadata content to fulfill the report requirements.
• Automated the feed transfer inbound/ outbound between BioMarin and Concur.
• Worked on the creation of the dashboards for the reports developed in step 2 to provide easy access to the data.
• Modified SDE,SIL mappings of financial analytics to Extract the data from Oracle EBS into EDW
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Created Shell Scripts for coping the files from Concur site to OBIEE server
• Developed ETLs to source the data from SAE into EDW.
• Created complex mappings which involved Slowly Changing Dimensions
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer
• Worked on the Multidimensional data model to store the data provide support for reporting
• Created an RPD model for reporting through BI answers.
• IntegratedBI Publisherwith OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.
• Developed templates and reports inOracle BI Publisherin RTFformat.
• Involved in creating Dimensional Hierarchies to support drill downs.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked on creating Reports and Dashboard to provide access to the employee level data.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.

Environment: Oracle Business Intelligence 11g,BI Apps 7.9.6.4, BI Publisher, DAC, Oracle 11g, Oracle DB, Windows XP/ NT/2003, UNIX, Linux, Shell scripting, TOAD

Confidential, Minneapolis

OBIEE Developer / ETL Consultant

Responsibilities:

• Implemented OBIEE with Financial and Procurement & Spend Analytics against Oracle EBS
• Gathered user requirements by conducting interviews, identifying ISW reports and created SR’s and CR’sfrom the gathered requirements.
• Managed repository during the development using OBIEE 10.1.3.4 Admin Tool.
• Worked on SDE and SIL mappings for different Source containers like Oracle R12
• Worked on Core Modules like GL, AP, and AR.
• Used flat files to source the data from flat files into DW using Informatica Mappings, Sessions and Workflows
• Created Metadata Dictionary for all the subject areas created.
• Migrated RPD and Catalog changes from DEV to QA and PROD.
• Restarting the BI Servers with RPD changes, Running Cache Scripts and Catalog Merging on Dev and QA environments on Linux.
• Created Presentation catalogs, Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Worked on Answers, Dashboards and Security for users. Worked on creating complex reports.
• Worked on Single Sign On security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository. Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Closely worked with ETL team to configure Informatica connections, source DB connection and target DB connection in DAC.
• Knowledge on configuring new customized mappings and work flows in DAC for new customized subject area.
• Experience in configuring DAC to run nightly data loads on daily basis.
• Worked on Data Extraction Transformations, Loading, Conversions and Analysis.

Environment: Oracle EBS R12.1.1, Oracle Business Intelligence 10.1.3.4, BI Apps7.9.6.3, BI Publisher, DAC, BI Office, OBIA 7.9.6.3, Oracle 11g, Windows XP/ NT/2003, UNIX, Linux, Shell scripting

Confidential, Woodland Hills, CA

OBIEE Analytics / ETL Consultant

Responsibilities:

• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Worked on Answers, Dashboards and Security for users and creating complex reports.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Created various Static and Dynamic variables for different report and Security requirements.
• Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Configured implicit fact columns. Enabled and administered Usage Tracking by using direct insert method.
• Configured Delivers (iBots) to alert the users based on the user needs.
• Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
• Deployed Informatica workflows to the DAC, created dependency and dependent hierarchical tasks and streamlined the Execution Plans with their respective tasks in DAC.
• Monitored the daily Incremental Loads in Production environment and fix any issues during the Load.
• Worked on Informatica OOB and customized SDE and SIL mappings for different Source containers like Oracle R11
• Worked on the Time Series Wizard and implemented time comparison measures.
• Used Column Filter Prompts and provided Dashboard Prompts appropriately to avoid excessive data showing up Reports.
• Used various transformations Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence for mappings based upon the requirement.
• Created Custom mappings to update Facts and Dimensions and worked on performance tuning of various transformations.

Environment: Oracle Business Intelligence 10.1.3.3,BI Apps, BI Publisher, DAC, Oracle EBS R11,Oracle Financial Analytics 7.9.6.2, Windows 2k, DAC 10.1.3.4, OBIA 7.9.5, Oracle 10g, TOAD.

Confidential

Siebel Developer / Informatica Programmer

Responsibilities:

• Worked with Informatica PowerCenter Source Analyzer, Data Warehousing designer, Mapping Designer & Mapplet, and Transformations for creating Mappings.
• Extensively worked on Answers, Dashboards and Security for users. Worked on creating complex reports using Seibel.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Developed and Scheduled workflows using workflow Manager created and modified parameter files according to the business requirements.
• Used aggregator, sequence Generator, expression, transaction control, Normalize transformations.
• Performed requirement gathering, scope analysis and finalizing the functional points.
• Designed and developed design document for common functions and packages.
• Created DDLs to create the staging, dimension and fact tables in the Data Warehouse.
• Developed and tested PL/SQL procedures, functions and packages.
• Developed wrapper programs using shell scripts.
• Also, developed Perl programs for pattern matching utilities.
• Implemented Materialized views, Bulk binding and Collections to achieve performance for PL/SQL programs.
• Prepared technical specifications and common function manuals for the releases.

Environment: Informatica Power Center 5.1, BI Analysis, PL/SQL, Oracle 8.1, SQL Server 2000, XML, PL/SQL, Perl 5.6 and UNIX, Linux, Shell Scripting, TOAD.