SUMMARY:

• 13+ years of IT experience in Application Support, Data Warehousing, Data Analytics, ETL, ODI, OBIEE, OBIA, Informatics, Oracle, Tableau 8.2 and MSSQL Server.
• 5+ years of strong background in Analysis, Design, Development, Implementation of Data Warehousing in ETL. Worked extensively in developing ETL for supporting Data Extraction, Transformation and Loading using ORACLE DATA INTEGRATOR 12.1.3.0.0/11.1.1. x/10.1.3.5
• Extensively used ODI (Oracle Data Integrator) to perform ELT from heterogeneous sources using ODI tools - Security Manger, Topology Manager, Designer and Operator.
• Excellent knowledge on the ODI Knowledge Modules such as LKM, IKM, CKM, JKM.
• Worked on SCRUM and agile Methodologies
• Worked On R code, Jython and Python languages
• Working with Service Knowledge Module Such as SKM
• Worked on Change Data Capture with JKM knowledge module
• Worked on Web logic application server for load balance and clustering
• Working experience in Creating ODI packages, scenarios using interfaces, variables, procedures and Topology including physical architecture, logical architecture.
• Implemented different OBIEE hierarchies like level based and parent child.
• Extensively used BI Publisher 11.1.1.7 for generating various types of BI-pub reports that are sent to customers using several templates/notices that are sent to applicants in BI Publisher using RTF templates.
• Working experience in Oracle BI tools (OBIEE / OBIA / ODI) Strong experience in designing data warehouses using Oracle data integrator.
• Extensively worked on Pre-packaged (Vanilla) OBIA modules like Financial Analytics, HR analytics, Supply Chain Analytics, Projects and Procurement and Spend with source as Oracle EBS R12.
• Worked on OBIEE MUDE to migrate the code from one Development to UAT and PROD.
• Implemented OBIEE Object level and Data level security in RPD and EM, Console.
• 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, Design reports and dashboards using OBIEE11G dimensional hierarchies. Design And Develop ad-hoc queries, reports and dashboards.
• Expertise in Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Developer and Data Transformation tools.
• Technical Experience in developing Informatica Mappings /Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Experience in configuring interactive Dashboards with drill-down, drill across capabilities using Filters and Dashboard Prompts, Setup groups, access privileges, Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and guided navigation links.
• Excellent knowledge and experience in data warehouse development life cycle, designing data marts, requirement analysis, dimensional modeling, implementation of STAR, Snowflake schemas; Incremental loads, Change Data Capture (CDC) and slowly changing dimensions.
• Implementation of Oracle Financials. (GL, AP, AR, CM, FA) Implementation of Oracle Inventory & Purchasing. Development experience in Oracle HRMS, Payroll. Administration and implementation of Oracle Business Intelligence using OBIEE, OBIA, ODI.
• Exclusively worked on different flavors of UNIX /Linux and Windows operating systems and good Experience in UNIX shell scripting.

TECHNICAL SKILLS:

Data Warehousing/ ELT/ETL: ODI 12c,ODI 11.1.1.x and ODI 10g (10.3.5.6),Informatica Power Center 9.x/ 8.6.1/8.1.1/8.0/7.1.2/7.1.1

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

OBI Apps Modules: Oracle Financials GL, AP, AR, Oracle SCM OM, PO, INVOracle Manufacturing OM, PO, INV, Sales Analytics, Procure and Spend Analytics, Human Resource Analytics.

BI Tools: OBIEE12c,Tableau8.2,OBIEE11.1.1.7.x/ 10.1.3.1/3.2/3.3/3.4 ,, OBIApps 7.9.5/7.9.6/7.9.6.4/11.1.7

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2000/7.0/6.0 , MySQL IBM DB2 UDB 9.0/8.0/7.0

Programming GUI: SQL, PL/SQL, SQL Plus, Unix, Perl, Shell Scripting, Transact SQL, ANSI SQL, Java/C++

OS Environment: Win 3.x/95/98/2000/XP/7, Win NT, Red Hat LINUX, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

ODI/OBIEE Lead

Responsibilities:

• Understanding business requirements and perform detailed analysis of the business need that will be driving the development work to integrate and visualize the disperse data sets in the form of business intelligence solutions and translating business needs in to data models supporting long term solutions.
• Preparing logical and physical data models as per the client requirements and coordinating with offshore team to deliver the projects on time.
• Designing and developing different data sets and data marts.
• Designing ODI Projects, Packages and Interfaces to extract the data from Oracle database. Creating and customizing ODI interfaces, mapping, joins, filters lookups to implement business rules, load plan creation and scheduling.
• Created OBIEE reports in OBIEE12c.
• Worked on R coding to customize business logic.
• Involved in Python and Jython scripting languages to minimize complex logics in ETL’s
• Involved in RPD designing for different data marts.
• Developed data level security in OBIEE based on user.
• Created hierarchies in RPD level based and parent child hierarchies.
• Worked on SCRUM and agile Methodologies for the daily activates.
• Develop, refactor and design PL/SQL code and queries as required to support the ETL prototyping activities of the data integration build prior to implementation in ODI. Troubleshoot and design the necessary UNIX bash scripting and routines to pre-process data prior to ODI ETL ingest.
• Work closely with the application management system team to efficiently migrate error free code through the ODI environments and onto the production systems and perform hand-off activities so they can support the code after delivery.
• Draft thorough, legible and easy to understand instructions for the maintenance of ETL bridges, produce administration guides and any diagram or supportive documentation needed in the operation or understanding of any of the development performed.
• Perform quality assurance testing, unit testing and integration testing on all data products designed and executed, and follow the software development life cycle best practices to maintain system availability and integrity. Raise technical issues and log them through our change management system and the software vendor, Oracle, for prioritization and resolution.
• Creating Conceptual, Logical and Physical Data Models using best practices to ensure high data quality and reduced redundancy. Performing reverse engineering of physical data models from databases and SQL scripts.
• Implementing ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Oracle and flat files in CSV and XML file formats.
• Working on Topology Manager Module to manage the data describing the information systems physical and logical architecture.
• Involving in Post Go Live Support for minor enhancements, performance optimization and development support.

Environment: s: ODI 11g, OBIEE 12c, SQL Developer, Oracle11 and Red hat Linux. Python scripting language, R code

Confidential, Santa Clara, CA

ODI Lead

Responsibilities:

• Understanding existing HAL (Hyperion Application Link) mappings.
• Preparing technical and functional design documentations
• Creating new data sources on different technologies like Oracle, SQL server and Files.
• Working with different ODI Knowledge Modules such as LKM, IKM, CKM, and JKM.
• Working with Service Knowledge Module Such as SKM
• Worked on Web logic application server for load balance and clustering
• Working with different SQL queries in ODI with YELLOW INTERFACES.
• Creating ODI packages, scenarios using interfaces, variables, procedures.
• Creating incremental loads, facts and dimensions, designed new data elements and tables for data marts
• Worked on Change Data Capture with JKM knowledge module
• Responsible for code migration from Dev to UAT and PROD environments
• Created standalone agent to automate ODI jobs and scheduling the ODI load plan and scenarios.
• Installing and Configuring ODI 11.1.1.3 on all the environments with standalone agents for custom Data Warehouse project.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Principal and Teacher Evaluation dashboard.
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution
• Implemented OBIEE Data level and Object level security in RPD
• Responsible for migrating the web catalog and RPD from DEV,UAT and PROD environments.
• Code migrated one Environment to Other Environment MUDE.
• Implemented different OBIEE hierarchies like level based and parent child.
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Created ODI Packages, Jobs of various complexities and automated process data flow

Environment: s: ODI 11.1.1.3, OBIEE 11.1.1.7.1 , SQL Developer, Toad, Oracle and Windows Server.

Confidential, Dallas, TX

ODI Lead

Responsibilities:

• Involved in the installation, configuration, customization and extension of OBIEE, OBIA, and ODI.
• Implemented different OBIEE hierarchies like level based and parent child.
• Worked with Enterprise Manager for deployment and control of repository, web catalog and configuring parameters.
• Implemented OBIEE BI publisher reports as business reqirements
• Created OBIEE Alias and Duplicate Table in Physical layer
• Responsibilities included Building of RPD application design for Physical, Logical, and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher and testing, and deployment
• Created proactive agents iBots and interactive Dashboards to alert the Administrative team about changes. Managed day-to-day Repository, Scheduler & iBots.
• Modified and created the ODI Knowledge Modules such as LKM, IKM, CKM, and JKM.
• Creating ODI packages, scenarios using interfaces, variables, procedures.
• Creating incremental loads, facts and dimensions, designed new data elements and tables for data marts
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Principal and Teacher Evaluation dashboard.
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution
• Responsible for migrating the web catalog and RPD from DEV, SIT, UAT and PROD environments.
• Installing and Configuring ODI 11.1.1.7 on all the environments with standalone agents for custom Data Warehouse project.
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Created ODI Packages, Jobs of various complexities and automated process data flow.

Environment: s: ODI 11.1.1.7, OBIEE 11.1.1.7.1 , BIApps (FinancialAnalytics), Oracle EBS 11i/R12, SQL Developer, Toad, Windows XP.

Confidential, NYC

ODI/OBIEE Lead

Responsibilities:

• Requirements Gathering and Business Analysis. Project coordination, End User meetings
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI and CDC
• Consolidated data from different systems to load Constellation Planning Data Warehouse using ODI interfaces and procedures
• Develop packages for the ODI objects and scheduled them as scenarios
• Defined ETL architecture for integrating data Confidential real time and batch processing to populate the Warehouse and implemented it using Oracle Data Integrator 12C
• Created PL/SQL stored procedures, functions and triggers for change data capture (CDC).
• Support in full legacy to ODI data conversion and Integration task
• Translated business requirements into technical specifications to build the Enterprise Data Warehouse
• Involved in system study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables
• Responsible for Data Modeling. Created Logical and Physical models for staging, transition and Production Warehouses.
• Installation and Configuration of Oracle Data Integrator (ODI)
• Responsible for creating complex mappings according to business requirements, which can are scheduled through ODI Scheduler.
• Responsible for configuration of Master and Work Repository on Oracle
• Responsible for Data Modeling. Created Logical and Physical models for staging, transition and Production Warehouses.
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts etc., to design the dashboards.
• Worked with functional and technical leads, business groups to identify, analyze, and document business requirements

Environment: ODI 11g, OBIEE 11.1.1.7, Oracle BIAPPS, Toad for Oracle, SQL Developer, MS Office, UNIX Scripting, ORACLE 11g

Confidential, CA

BI &ETL Lead

Responsibilities:

• Responsible for system analysis, effort estimation, design, development, unit testing, Implementation and Maintenance of data conversion mappings and ETL processes.
• Responsible for creating HLD and LLD documents.
• Responsible for data modeling using Erwin, Star Schema Modeling and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Worked on Informatica Power Center Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Developer and Data Transformation tools.
• Developing Informatica Mappings / Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Extensive expertise Confidential developing and scheduling ad-hoc and canned Analytics Reports using OBIEE/BI Answers, Dashboards.
• Responsibilities included Building of RPD application design for Physical, Logical, and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher and testing, and deployment.
• Developed BI using the following tools: Oracle BI Administration, Oracle BI Answers, Oracle BI Dashboards.

Environment: s: OBIEE11g/10g, (BIApps HR Analytics), Informatica, Oracle EBS 11i/R12Data Warehousing using Oracle 11g/10g, TOAD, SQL, UNIX, Shell scripting, Utilities like WINSCP, Putty

Confidential

Senior BI & ETL Developer

Responsibilities:

• Worked closely with Development managers to evaluate the overall project timeline.
• Gathering the requirements for the various projects and enhancements
• Participated in team meetings and proposed ETL Strategy and provide them best practices.
• Created incremental loads, facts and dimensions, designed new data elements and tables for data marts.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Extensively used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Provided production support by monitoring the processes and Jobs running daily.
• Deployment of applications by following the SCM processes.
• Extensively used Dimensions for version controls and deployments.

Environment: OBIEE 10g, Informatica Power Center 9.5.1/8.6.1 , Oracle 11g, Dimension,Facets application, Facets data model, Serena NWR, Serena Team Track, UNIX Solaris, Mainframe OS 390, Lotus Notes, Microsoft Office,Windows XP Professional/2002, Windows XP/2000.

Confidential

Senior BI &ETL Developer

Responsibilities:

• Installing, maintaining and supporting Informatica PowerCenter tools.
• Creating repository and integration services, maintaining user privileges and deployment activities.
• Participated in team meetings and proposed ETL Strategy and provide them best practices.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Performed tuning of Informatica Mappings for optimum performance.
• Extensively used Unix Scripting, Scheduled PMCMD to interact with Informatica Server from command mode.
• Created Shell scripts to automate the Backups, ETL Execution.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Provided production support by monitoring the processes and Jobs running daily.

Environment: Informatica Power Center 9.1/8.6.1/8.1.1 , Oracle 11g/10g, Cognos, Erwin 4.5, Essbase 11.1.1, Business Objects xi, SQL Developer, Autosys, UNIX AIX 5L version 5.1, UNIX Solaris, Linux Red-Hot, Microsoft Office, Windows XP Professional/2002, Windows XP/2000, ClearCase

Confidential

ETL- Informatica Developer

Responsibilities:

• Responsible for Power Center and Power Exchange installations, configuring Power Center domain, nodes and integration services.
• Responsible for creating repository folders and giving access to the users.
• Played a role of Informatica Developer and Lead.
• Created mappings for various sources like Oracle, SQL server, flat files and XML files to load and integrate data to warehouse.
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Scheduled sessions and work flows using Informatica scheduler and pmcmd command.
• Developed unit test cases and did unit testing for all the developed mappings.
• Provided production support by monitoring the processes running daily.
• Worked closely with reporting team and helped them whenever they had any ETL issues.

Environment: Informatica Power Center 8.1.1/7.1, Oracle 10g, Erwin 4.5, Crystal reports, EssBase, SQL server 2005, Transact-SQL, DTS, UNIX AIX 5L version 5.1, Windows XP Professional/2002, Transact-SQL, UNIX AIX4.2, Windows XP/2000.

Confidential

ETL Developer

Responsibilities:

• Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
• Responsible for migrations from Development repository to the QA and Prod repositories.
• Populated data into staging tables from flat files, XML sources, Cobol Copybooks and Relational Sources.
• Installed and Configured Informatica PowerCenter on Client and Server Machines and Configure Informatica Server and Registered Servers.
• Worked on Informatica Power Center 6.2/7.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, and Reusable Transformations.
• Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
• Developed Unix Shell scripts and Perl Scripts to extract and convert data from different legacy systems in databases.

Environment: Informatica Power Center 6.2/7.1, Power Mart, Java,J2ee, Oracle 9i/8i, SQL Server.