SUMMARY

• Around 9+ years of experience in Sr. ODI/OBIEE, Data Warehousing and Database Applications including Analysis, Design, Development, Testing and Support usingODI 11.1.1.7 /12 c, Informatica (8.x,9.x), OBIEE 10.x/11g and BI APPS with excellent Communication, Problem Solving, and Analytical abilities.
• Expertise on all ODI components - Topology, Security Manager, Designer and Operator.
• Hands on expertise on working with ODI Knowledge Modules like LKM, IKM and JKM, CKM. Extended the base ODI Knowledge Modules to create customized versions that are re-used across other data integration projects.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Experience in configuring and developing the Analytics/OBIEE repository, which involves Schemas Import, Implementing the business logic by customization, Dimensional Hierarchies, Level Based Measures, Security Management such as Data level /Object level Security, Variables, Initialization blocks.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Implemented the Change Data Capture (CDC) feature of ODI to minimize the data load times.
• Experience in designing and developing end-to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence (OBIEE), including 3 full life cycle implementations.
• Experience in ETL Tools like Oracle Data Integrator (ODI), OWB and reporting tools like OBIEE 10g, 11g.
• 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.
• Expert in data warehousing techniques/concepts such as data cleansing, Surrogate key assignment, Slowly Changing Dimensions SCD TYPE 1, SCD TYPE 2, Change Data Capture (CDC).
• Experienced in Data Analysis, Data Migrations, Data Profiling and Data quality and Data Cleansing
• Worked on OLTP Data Modeling, OLAP Data modeling and have good knowledge on data warehousing concepts.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, Relational Database Models and Data Integrity in observing Business Rules.
• Experienced in designing customized and complex interactive dashboards in OBIEE using drill down/ drill up, guided navigation, prompts, filters and variables.
• Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables besides configuring object level and database level security.
• Skilled in configuring OBIEE Metadata objects including repository variables, initialization blocks, connection pools using ODBC, OCI and Universal Adapters.
• Performed the changes to the physical layer, Business Model and Mapping Layer and Presentation Layer in an OBIEE Repository for all new objects that needed to be added.
• Experienced in analyzing the needs of the user and creating new BI reports according to the user requirement in OBIEE.
• Development of Business Reports, Business Alerts with help of Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel ibots, Oracle BI Publisher to create reports from multiple data sources.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Good knowledge in working with FTP and development tools like SQL developer.
• Exposure to handling Data from various sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files and XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems. Also worked for Data loading using UNIX shell scripts, SQL*Loader.
• Skilled in Unix Shell Scripting and experience on different UNIX platforms.
• Excellent Communication and Documentation skills, ability to learn and adopt new ideas and technologies, Self-motivated and result-oriented.

TECHNICAL SKILLS

ETL Tools: ODI (Oracle Data Integrator) 12c, 11x, Informatica 9

Reporting Tools: OBIEE 11g, BI Publisher, Tableau 9.2

Languages: SQL, PL/SQL, HTML, CSS, JavaScript, XML, C, C++

Database Systems: Oracle 12c/11g/10g/9i/8x, SQL Server 2000/2005, SQL*Plus, SQL*Loader

Data Modeling: ER win Data Modeler r8 / r7, ER Studio, Dimensional Data Modeling, Star and Snow flake model, ETL, ELT, OLTP, OLAP, SQL, PL/SQL, Stored Procedures, Triggers, Data Loading and Integration.

Operating Systems: Windows XP, Windows 7, Windows 8, Linux/UNIX

Scripting Language: UNIX Shell Scripting, TIDAL, Autosys, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Quincy, MA

Sr. ODI/OBIEE Developer

Responsibilities:

• Involved in all the phases of the project from Planning, Discovery, Requirements Gathering, Design, Construction, Testing, Pilot and Deployment.
• Involved in the Installation of ODI 11.1.1.7 and ODI 12C Upgradation.
• Used ODI 11.1.1.7 and ODI12c designer and implemented knowledge modules like LKM, IKM, CKM, RKM and JKM when needed.
• Used ODITopology Manager graphical tool to manage the data describing the information systems physical and logical architecture.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Good working knowledge with ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Monitored sessions for executions using ODIoperator. Managed user privileges usingODISecurity Manager.
• Created complex Interfaces and implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3) for data loads.
• Created Interfaces to implement one time as well as Incremental loads.
• Used Interface Variables, Interface Parameters and Session Parameters to increase the re-usability of the Interfaces.
• Implemented performance tuning logic on targets, sources, interfaces, sessions to provide maximum efficiency and performance.
• Used ODI knowledge modules to implement SCD logic and Update logic.
• Developed load plans using Load Plan Generator and monitored the results using ODI Operator.
• Analyzed business requirements of the project and wrote technical specs for the implementation and created BI reports in different subject areas.
• Developed Tableau visualizations and dashboards using Tableau Desktop for the CHIA project.
• Implemented Tableau workbooks from multiple data sources using Data Blending and presented it the clients.
• Provided 24/7-production support for Tableau users.
• Involved in the Installation of OBIEE 11g (BI Administration Tool, Oracle BI Enterprise Manager, WebLogic server and BI Publisher) in Linux environments.
• Expertise in converting and usingOracle BI Appspre-build rpds (Financial,Supply ChainandOrder Management) according to business requirements.
• Created Logical Tables, Logical Columns and calculated measures and metrics as per the business need.
• Created complex requirements like Dimension hierarchies, time comparisons and share measures along with ranks.
• Developed Month Ago, Year Ago Measures for Comparison of Facts and Used Time Series Functions and toDate Functions Extensively.
• Developed new Balance sheet, income statements, AP aging and AR aging reports and dashboards, etc. as per business requirements.
• Implemented Oracle BI security at the data and object levels and utilized variables and initialization blocks in the repository.
• Created operational reports with BI Publisher integrated with OBIEE.
• Created variables in OBIEE for use with reporting - Repository Variables, Session Variables, Presentation Variables and Initialization blocks.
• Managed and provided permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.

Environment: ODI 12.2.1.0/11.1.1.9. x (Repository Manager, Designer, Load Plan Generator, and Operator), OBIEE 12.2.1.0/11.1.1.9. 0, OBIA 11.1.1.10.1, Oracle 12c/11g, SQL Developer 4.x, Toad 10.x, PLSQL, SQL

Confidential - Lake Forest, CA

ETL/OBIEE Developer

Responsibilities:

• Prepared detailed Level of Effort analysis for data integration projects.
• Design and develop major components of the ETL process using Oracle Data Integrator.
• Installation and Configuration of Oracle Data Integrator (ODI). Responsible for configuration of Master and Work Repositories on Oracle.
• Responsible for designing, developing, and testing of the ETL strategy to populate the data from various source systems (Flat files, Oracle, DB2) feeds using ODI and Change Data Capture (CDC).
• Hands on experience on working with ODI Knowledge Modules like, Golden gate, knowledge module LKM, IKM and JKM, CKM.
• Knowledge in performing the customizations to the ODI Knowledge Modules as part of tuning the Knowledge Module Code based on the requirements.
• Involved in system study analysis for logical/physical data model thereby 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.
• Responsible for creating complex mappings according to business requirements, which are scheduled through ODI Scheduler.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Good working knowledge with ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.

Environment: ODI 11.1.1.7, OBIEE 11.1.1.7, OBIA 11.1.4, Oracle 11g, SQL Loader

Confidential - Newport, NJ

Sr. OBIEE Developer

Responsibilities:

• Involved in data analysis, designing and development of data warehouse environment.Developed and implemented a strategy for the install and configure of Informatica 9.1.
• Interacted with Business Users and Business Analysts for gathering new business requirements and also understood the current requirements and Data Analysis.
• Created Repositories, Agent, Contexts, Data Server, and both of Physical & Logical Schemas in Topology Manager.
• Various kinds of transformations were used to implement simple and complex business logic.
• The mappings involved extensive use of transformations like Filter, Router, Expression, and Union for loading data into target tables.
• Developed and maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema.
• Create Oracle Workflow and schedule jobs.
• Used Lookup Transformation to access data from tables, which are not the source for mapping.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Used SQL tools like SQL Navigator to run SQL queries and validate the data in warehouse.
• Used workflow manager and work flow monitor to run and monitor jobs.
• Analyzing the source data and deciding on appropriate extraction, transformation and load strategy.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Associated with Production support team in various performances related issues.
• Created Interactive Dashboards, Answers and Administering Oracle BI Apps Applications.
• Worked with Oracle BI Server, Presentation Server, Repository development and Oracle BI Administration.
• Analysis, Design, development and customization of Reports and Dashboards in OBIEE and daily client interaction. Preparation and execution of the test plans.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Worked with all three layers in the repository - Physical, Business, and Presentation Layer.
• Worked on security for users based on LDAP, External table Authentication and Database Authentication Types.
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Created reports according to user requirements and also created corresponding dashboards for the reports.
• Actively involved in deployment and post release support.
• Exposure to Cognos 8 in building packages and reports and other BI tools like Tableau 8.3

Environment: OBIEE 10.1.3.2, Oracle E-Business Suite 9i, Informatica, OBAW, Oracle10g, XML (BI) Publisher, SQL Developer, PL/SQL, Tableau 8.3.

Confidential - Basking Ridge, NJ

Sr. OBIEE/ETL Developer

Responsibilities:

• Designed and Developed Informatica mapping and sessions to create flat files.
• Developed PL/SQL Stored Procedures, Packages.
• Developed Database triggers for implementing Business logic.
• Involved in Informatica Administration activities such as creating & managing Informatica users, groups and privileges.
• Involved in taking backup of the repository, restoring repository etc.
• Tuned the performance of Mappings, Sessions, relational source and targets.
• Interfaced Trillium to cleanse, de-duplicate and identify household Customers.
• Prepared Software engineering quality documents related to design, development, testing as per CMM standards.
• Developed mapping (interfaces) data transfer strategy from data sources to target systems.
• Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Responsible for developing OBIEE repository RPD from the scratch using the best practices for the three layers.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Developed Oracle BI Metadata BI Administration tool repository using.
• Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Developed extract logic mappings and configured sessions.
• Used aggregator, router, joiner, stored procedures, look up, filter, source qualifier and update strategy transformations extensively.
• Created reusable transformations and mapplets to use in multiple mappings.
• Handled the performance tuning of Informatica mappings.
• Developed Shell Scripts as per requirement.

Environment: Informatica 8.x, OBIEE 11G, Oracle 10g.