PROFESSIONAL SUMMARY:

• 7+ years of overall 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
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Experience with all ODI tools - Topology, Security Manager, Designer and Operator.
• Experienced in setting up ODI standalone Agents and J2EE Agents on WebLogic server based on requirements.
• Experienced in setting up/manage source and target system connections (Topology Manager) in ODI.
• Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked with knowledge modules like LKM, IKM and CKM in ODI.
• Performance Tuning of ETL jobs by providing appropriate knowledge modules.
• Debugging the master jobs and packages by using operator navigator.
• Developed packages, scenarios using interfaces and variables.
• Experience in desining and developing interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.
• Knowledge on dataware housing concepts like schemas and approaches.
• Have extensive skills in client interaction, communication and in support.
• Strong in ETL Testing by using SQL.
• Used ODI commands like ODI File Move, ODI FileAppend, ODI Filecopy etc
• Performance tuned the ODI interfaces.
• Experience in SQL and PL/SQL programming for ODI and oracle.
• Working knowledge experience on Analysis, Design, Development, Implementation of Data Warehousing in ETL process using ODI 12
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Develop operational process and procedures for monitoring ODI scenarios & agents for production troubleshooting and analysis.
• Scheduled batch jobs using ODI scheduler.
• Used Topology Manager module to manage the data describing the information systems physical and logical architecture.
• Used different Knowledge Modules (KM) to load and transform the data from different data sources
• 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
• Experience in Installation and configuration of Informatica Power Center 7.x/8.x/9.x and creating Mappings, Mapplets, Sessions and Workflows.
• Troubleshooting production issues and gave post production support for couple of projects.
• Experience in DAC (Data Warehouse Administration Console) with Importing Subject Areas, Creating Execution plans, registering the Informatica Work flows, Metadata management and Scheduling.
• Experienced indesigning customized interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Proficient withBI Publisherreports and using various templates to publish the reports as per user requirements
• Exposure to Insurance, Banking, Financial, Healthcare, Industrial sectors and business with regard to Data warehouse development.
• Good experience in Linux and writing shell scripts.
• Excellent Management skills, analytical and dynamic troubleshooting skills, Multi tasking, Posses good communication skills, Quick learner and adapts to new environments easily.

TECHNICAL SKILLS:

Reporting Tools: OBIEE 10.3.1.x/11g, BI Apps, BI Publisher

ETL Tools: Oracle Data Integrator 11g/12c,Informatica Power Center9.x/ 8.x/7.x

Business Intelligence: Oracle Business Intelligence Application 7.9.6.Sx

RDBMS: Oracle11/10g, 9/8i, MS SQL Server 2003/2000, Access7.0/2000

Tools: Toad, SQL*Loader, SQL Developer, T-SQL

Operating Systems: Linux EL5, Windows NT/2003/2008, Windows 95/98/00/xp, Linux, Solaris

Scheduling tools: DAC (Data Warehouse Administration Console)

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Internet Technologies: HTML, XML, ASP, ASP.net, JSP, VBScript and JavaScript

PROFESSIONAL EXPERIENCE:

Confidential

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 - XML files,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.
• Did reverse engineering for the data sources and targets.
• 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.
• 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.
• Coordinated with the offshore INDIA team. Helped them to define the source view and in resolving the access issue.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle.
• Automated the process of generating scenarios for interfaces, packages.
• Used different Knowledge Modules (KM) to load and transform the data from different data sources
• 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.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Performed unit and integration testing. Created various test scenarios to test the application.
• Conducted code reviews and planned the knowledge transfer to client.

Environment: Oracle Data Integrator 11g/12C,Oracle Commerce, BI Apps 11.1.1.7.1 , Oracle Business Intelligence 11g, Oracle 11g, Oracle DB, Windows XP/ NT/2003, TOAD

Confidential, Indianapolis, IN

OBIEE / ODI Developer

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.
• Did reverse engineering for the data sources and targets.
• 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.
• 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.
• Implemented BI Publisher and created business reports using BI Publisher.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards

Environment: Oracle Data Integrator 11g/12C, Oracle Business Intelligence 11g,BI Publisher 11g(11.1.1.7), Oracle 11g, Oracle DB, Windows XP/ NT/2003, UNIX, Linux, Shell scripting, TOAD

Confidential, Indianapolis, IN

OBIEE / 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
• Performance tuned the ODI interfaces.
• Optimized the knowledge modules to improve the functionality of the process.
• Conducted code reviews and planned the knowledge transfer to client.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• 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 INPRS personnel.
• Facilitated the development & documentation of additional data quality test cases.
• Worked closely with Business users. Provided options and alternative solutions to Business during data anomalies etc
• 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 INPRS team.
• Developed, initially tested & documented OBIEE scorecards content for top ten KPIs.
• Support testing and debugging including skills transfer and support transition to INPRS.
• Involved in documenting, tracking and resolving issues during testing and skills/knowledge transfer to INPRS personnel.

Environment: Oracle Data Integrator 11g/12,Oracle EBS, BI Apps 11.1.1.7.1 , Oracle Business Intelligence 11g, Oracle 11g, Oracle DB, Windows XP/ NT/2003, UNIX, Linux, Shell scripting, TOAD

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.
• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Loaded the flat files data using Informatica to the staging area.
• Involved in the ETL design and its documentation.
• 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.
• Involved in extracting the data from the Flat Files and Relational databases into staging area
• Monitored Workflows and Sessions using Workflow Monitor.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• 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.
• Involved in creating Dimensional Hierarchies to support drill downs.
• Designed Security to provide controlled access to the data
• 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 Performance tuning at Informatica level and at Data base level.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
• Re-organized pages & reports into new dashboards.
• Monitoring Incremental & Full load throughDAC.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

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

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’s from 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
• Monitored performance by creating OBIEE’s Usage metrics. Improved performance by using aggregate navigation, indexes and materialized views.
• Copied existing RPD’s from server into the local machine for testing and tuning of dashboards.
• Created Metadata Dictionary for all the subject areas created.
• Migrated RPD and Catalog changes from DEV to QA and PROD.
• Received excellent feedback from Users, Accounting Manager and Director of Business Intelligence.
• 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.
• Involved in Logical and Physical Database design and Star Schema design, Snow flake Schema, Fact tables and Transaction tables.
• 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, Oracle Business Intelligence 10.1.3.4, BI Apps, 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.
• Re-organized pages & reports into new dashboards: CORE GL, AP, AR.
• 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.
• Migrated Analytics RPD and Webcat from one environment to another.

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.
• Designed and developed packages and PL/SQL programs to find the given word matches in the text stored in columns.
• 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.