SUMMARY

• Having 8 years progressive IT experience in the Data Warehousing and Business Intelligence (OBIEE/OBIA/BI Publisher) Business Requirements Analysis, Application Design, Data Modeling, Testing, Implementation, support and documentation of applications with specialization in Data Integration using Informatica, ODI.
• Hands on experience in developing ODI interfaces, packages, procedures, models, data stores and scenarios and dealing with ODI Knowledge Module like LKM, IKM AND JKM and CKM.
• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / Denormalization strategies.
• Involved in Implementing Slowly Changing Dimensions, Star Join Schema modeling, Snowflake Modeling, FACT tables, Dimension tables, denormalization.
• Extensive experience in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake schemas.
• Expertise in configuring Interactive Dashboards with drill - down and drill-across capabilities using Dashboard Prompts, Aggregate Navigation, Time series functions, Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization. Configured & published Delivers / iBots to deliver content based on schedule, automated iBots queries to obtain daily & weekly transactions by Emails.
• Identify and Created Facts, Dimensions and Hierarchies of the business model and customize the OBIEE repository (Physical, BMM and the Presentation layer).
• Broad understanding of multiple technologies - These include DBMS, ETL, Reporting, OLAP, Teradata, performance tuning for high-end hardware and storage (HP, Sun, data warehouse appliances), OS (Solaris, HP-UX, Windows, Linux).
• Expertise in configuring OBIA Financial Analytics, Procurement & Spend Analytics pointing to source systems like Oracle EBS.
• Experience in developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL. Experienced in basic and advanced Oracle SQL functions (RANK over, partition by, etc.)
• Functional knowledge experience in multiple industry domains. Profound Knowledge of SDLC and Software Testing Life Cycle. Participated in Integration, Regression, Performance and System testing.
• Experience using Oracle 11g/10g/9i, Oracle Report Writer, SQL, PL/SQL, SQL*Plus, SQL*Loader, Windows 95/98/2000/XP, Win NT 4.0 and Sun Solaris.
• Experience in designing BI publisher data model, building templates and running Jobs by bursting method for generating Invoices.

TECHNICAL SKILLS

ETL Tools: Oracle Data Integrator(ODI) 10/11g/12c, Informatica Power Center 9x/8x

Scheduling Tool: DAC 7x

Data Modeling, Data Architecture: Erwin 4.5/4.0, Logical Modeling, Physical Modeling, Dimensional Data Modeling (Star Schema Modeling, Snow Flake Schema Modeling, FACT and Dimensions Tables)

BI & Reporting: OBIEE 11G/10G/Siebel Analytics 7.8.5, OBIA, BI Publisher 11G

Databases: Oracle11g/10g/9i, PL/SQL, MS Access, Cache Database.

Operating System: Windows XP/2000/98/vista/7, Unix-AIX, HP-UX, Linux

Programming: SQL, PL/SQL, Java, C, C++, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, FL

ODI Consultant

Responsibilities:

• Working with Business Analyst, Users and Functional Analystsfor reporting requirements analysis and to define business specifications and mapping documents.
• Built ODI mappings, packages making use of ODI 12c.
• Created ODI procedure using Jython Technology to bring data from Intersystem Cache Data Base.
• Created technical specifications describing Landing, Stage & Production tables to work with DBA.
• Created mappings to get the data from CSV files and XML.
• Created mappings to handle data exceptions without using CKM knowledge module.
• Used various features of ODI 12c such expression, distinct, split.
• Implemented Change Data Capture to bring delta data from Oracle Golden Gate as Legacy System.
• Supporting overnight ETL batch which kicked off by Control M.
• Responsible for Unit Testing and make sure it gets it done through User Acceptance Testing.

Environment: ODI 11g, ODI 12c, Jython, Oracle PL SQL, DB2, Cache DB, Mainframe, WebLogic 10.3.6, Linux.

Confidential, CA

ODI/OBIEE Consultant

Responsibilities:

• Interacted withSubject Matter Experts and Functional Analystsfor reporting requirements analysis and to define business and functional specifications.
• Monitored and documentedchange requestsin requirements and ensured modified requirements are met during BI development.
• Built ODI interfaces, packages to populate Staging and Presentation.
• Created ODI J2EE Agent and deployed in WebLogic 10.3.6 and configured different data sources.
• Created and implemented handshake between ODI and Clover ETL, where dependency exists.
• Customized Email distributions to get the error messages and output from ODI PKG run. Modified Knowledge modules to customize for ETL requirements.
• Created procedures to send statistics of ODI execution daily basis.
• Worked on file download system from web portal using shell script.
• Defined topology for different data sources such DB2, Siebel, Files.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Developed mappings using ODI 12c.
• UsedOBIEE Web Catalogto set up groups, access privileges and query privileges.
• Created dimension hierarchies, aggregation criteria and multiple logical sources in the BMM layer.
• Implemented security by creating roles and web groups, and defined Object Level and Data Level Security.
• Attending the code reviews developed by the other team members and making the appropriate suggestions to match the business requirements.

Environment: OBIEE 11.1.1.6.x, ODI 11g, ODI 12c, Oracle PL SQL, DB2, Siebel, Mainframe, Endeca, Clover ETL, WebLogic 10.3.6, Linux.

Confidential, CA

ODI/OBIEE Consultant

Responsibilities:

• Analyzed business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Involved in inception of new Data Mart design related to financial data integration between Toyota Parts Data Mart, Toyota Incentive Systems.
• Built ODI transformations to cleanse, Harmonise data from multiple data sources.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history ofaccounts and transaction information
• Defined topology for Hyperion making use of prebuilt Hyperion Adaptors
• Data quality checking and interacting with the business analysts.
• Created shell script for archiving files and trigger files.
• Created Load Plan scenarios and involved in scheduling in different environments.
• Designed and developed OBIEE related works which include BMM layer: Hierarchies, proper designing of Logical Tables sources of Facts and Dim’s, setting of proper dimensionality on Facts tables, derivation of measures and applying business logic on facts measures.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Responsible for Unit Testing and helped with User Acceptance Testing.
• Managed post-production issues and delivered all assignments/projects within specified time lines.
• Tuned Informatica mappings to improve the execution time by applying suitable Partitioning mechanisms and tuning individual transformations inside the mapping.

Environment: ODI 11g, Oracle PL SQL, Hyperion Planning, XBRL, MS-Access, OBIEE 11g.

Confidential

ODI Consultant

Responsibilities:

• Worked on Implementation of OBI for Financial Analytics and Procurement and Spend Analytics.
• Met with different business teams to get the business requirements for modules like Finance and Procurement.
• Customized/Extended OOTB OBIAas per customer requirements using ODI Studio and Oracle BIEE Metadata repository (RPD) and Dashboards.
• Developed metadatarepositoryand configured metadata objects in all three layers (Physical, BMM and Presentation) using BI Administration tool.
• Designed different Procedures, Packages, Scenarios, Variables and Interfaces to populate DW.
• Importing/Exporting scenario’s over DEV to PROD as well DEV to QA repositories.
• Prepared the test Cases for executed the test cases for ETL full and Incremental loads and Dashboards and Reports for all modules.
• Created of new Dashboards and reports based on business requirements.
• Created dimension hierarchies, aggregation criteria and multiple logical sources in the BMM layer.
• Worked on user access management for different business groups based on their levels.
• Implemented best practices and methodology for configuring Oracle BI Analytics Implementation
• Knowledge on ERP (Oracle apps) OLTP application.

Environment: ODI 11g, Oracle PL SQL, Jython, .CSV, XML, Oracle DB, OBIEE 11g, OBIA 11.1.1.8.1 (

Confidential

ODI/OBIEE Developer

Responsibilities:

• Involved in requirement gathering from user through meetings, understanding the business from end userandtechnical perspective.
• Developed, maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances.
• Built transformations, configured servers and established connections to various sources and Targets.
• Extensively worked on defining Flat File, Relational Source & Targets, Designing Transformations Logic, created different Interfaces for different sources using LKM's and IKM's
• Developed different Procedures, Packages, Scenarios, Variables and Interfaces in Oracle Data Integrator.
• Supported BI Applications, analyzing and resolving overnight ETL Failures.
• Implemented best practices in Moving/Copying folders/mapping (Exporting and importing objects) between repositories and environments
• Created Parameter/Variable and using into Interfaces, Procedures and Packages.
• Implemented Synchronous and Asynchronous Change Data Capture (CDC) techniques.
• Performed ODI Scheduling - monitoring for scheduled reports & error notifications
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, AnswersandDelivers.
• Worked on improving the dashboard performance, readability,andsecurity.
• Coordinated theOBIEERPD and Web Catalog objects migration from Dev environment to QA environmentandto the Production environment.
• Worked on OBIEE Security implementation to provide data level security according to the user role.
• Implemented BI Publisher Bursting for scheduling the reports to deliver based on user role with security.
• Worked on implementing automatic cache purging after monthly data load completion by using Event pooling table.
• Extensively worked on all phases starting Requirement gathering, RPD development, security implementation, Report development and Report delivery by using Schedulers.
• Created KT transition plan for all deliverables also for production support prior to go-live.
• Suggested the system requirements for installing OBIEE environments as part of upgrading the OBIEE 10g to OBIEE 11g.

Environment: ODI 11g, Oracle PL SQL, Jython, Flat Files, XMl, Sybase, SQL DB, OBIEE11g.

Confidential

ODI/OBIEE Developer

Responsibilities:

• Involved in the installation, configuration, customization and extension of OBIEE, OBIA, andODI.
• Involved in establishing an agile framework for project development.
• Modified and created theODIKnowledge Modules such as LKM, IKM, CKM, and JKM.
• CreatedODIpackages, scenarios using interfaces, variables, procedures.
• Installed and ConfiguredODI11g 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.
• CreatedODIPackages, Jobs of various complexities and automated process data flow worked with Enterprise Manager for deployment and control of repository, web catalog and configuring parameters.
• Responsibilities included creating 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.
• Created incremental loads, facts and dimensions, designed new data elements and tables for data marts
• Used BI Publisher for generating various types of BI-pub reports that are sent to customers using RTF templates.
• 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.

Environment: ODI 11g, Oracle PL SQL, Jython, Flat Files, XML, Sybase, SQL DB.

Confidential

ODI Developer

Responsibilities:

• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used ODI designer to create interfaces, packages to facilitate data loading. Tune SQL statements to Insert and update data into the DIMENSION and FACT tables.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Designed the ETL processes using ODI Designer.
• Monitored the ETL process using Operator and Metadata.
• Designed Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse
• Error checking and testing of the ETL procedures and programs using Informatics session log
• Created variables, procedures, packages in ODI as part of Integration needs
• Used standalone agents to schedule ODI scenarios.

Environment: Oracle 10g, ODI 10g, TOAD, PL/SQL, DB2.

Confidential

ODI/OBIEE Developer

Responsibilities:

• Worked on Oracle Enterprise Manager to activate and Deploy RPD.
• Worked on the RPD for the new Subject area design for the Cash Flow Metrics Created Reports, 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.
• Testing the newly upgraded ODI 11G fixing issues related to running ODI jobs as per schedule.
• Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios, ODI Functions, ODI Mappings, ODI Load Plans. Created the users, profiles using the ODI security manager.
• Created Packages, Scenarios and Load Plan Components, Load Plans using ODI.
• Generated Load Plans and Executed Integrated Testing over Payroll Subject Area using ODI.
• 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.
• Implemented CDC through ODI Journalization Knowledge Modules (KMs)
• 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.

Environment: ODI 10g, OBIEE10g, Oracle EBS, Oracle 10g, SQL*PLUS, SQLDeveloper, Windows 2003 server.

Confidential

IT Consultant

Responsibilities:

• Wrote SQL queries (Sub queries and Join conditions) to analyze rejected records at Production.
• Wrote Stored Procedures to call load plan scenarios and to pass key parameters into control tables.
• Hands on experience in writing the Joins and sub queries.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Did data profiling, data cleansing
• Developed Database Triggers for the integrity and security purpose.
• Used PL/SQL Developer Tool to do the backend development.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Wrote complex Oracle SQL using joins, sub queries and correlated sub queries.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Develop and maintain the documentation.
• Data loading using PL/SQL.
• Used PL/SQL Developer Tool to do the backend development.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Wrote Oracle SQL using joins, sub queries and correlated sub queries.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Develop and maintain the documentation.
• Used cursors extensively in creating procedures, functions using PL/SQL
• Having the knowledge on handling the exceptions.

Environment: Oracle 9x, SQL*PLUS, SQLDeveloper, Windows 2003 server.