PROFESSIONAL SUMMARY:

• Around 6 years of experience in Business Intelligence, Data Warehousing and Database Applications including Analysis , Design, Development, Testing and Support using ODI 11.1.1.7 /12c, OBIEE 10.x/11g and BI APPS .
• Extensive ODI Development experience in Health, Banking, Insurance, Financial industries with a strong understanding of data & analytics.
• Profound knowledge on all ODI components - Topology, Security Manager, Designer and Operator.
• Hands on experience 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.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Extensively worked on Dimensional modelling, Data migration, Data cleansing and Data Staging of operational sources using ELT processes and providing datamining features for data warehouses.
• Implemented the Change Data Capture (CDC) feature of ODI to minimize the data load times.
• 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 creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, Relational Database Models and Data Integrity in observing Business Rules.
• Familiar with Oracle EBS concepts of Financial Analytics, Spend Analytics and Supply Chain modules.
• 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 analysing the needs of the user and creating new BI reports according to the user requirement in OBIEE.
• Experience in Setting up Dynamic, System and Non-System Variables.
• Development of Business Reports, Business Alerts with help of Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel i-Bots, Oracle BI Publisher to create reports from multiple data sources.
• 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.
• Extensive experience in writing SQL Queries and PL/ SQL.
• A Self-starter with a positive attitude, willingness to learn new concepts and to accept challenges, as well a very good team player.

TECHNICAL SKILLS:

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

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

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

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

Reporting Tools: OBIEE 10.x/11g, XML/BI publisher, Discoverer , reports6i/10g

DB Tools: TOAD, SQL Developer

Other Tools: MS Office, Microsoft Project, Adobe Photoshop and Adobe Dreamweaver

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

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

ODI 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 ODI Topology 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.
• 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.
• Analysed business requirements of the project and wrote technical specs for the implementation.
• Analysed the user requirements and created BI reports in different subject areas.
• 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 using Oracle BI Apps pre-build rpd’s (Financial, Supply Chain and Order 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 to Date 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 CatLog.

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/11.1.1.8.1 , Oracle 12c/11g, SQL Developer 4.x, Toad 10.x, PLSQL, SQL.

Confidential, Houston, TEXAS

ODI/ BI DEVELOPER

Responsibilities:

• Actively involved in all the phases of project - development, testing, deployment and support.
• Created ODI design documents from the existing mappings and used these design documents in development of interfaces/packages.
• Responsible for upgradation to 12c and fixed issues during installation and upgradation.
• Built the Interfaces with ODI 11g Designer using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored procedures.
• Responsible for creating interfaces, procedures, packages and load plans using ODI and monitored the workflow run and statistic properties on ODI Operator.
• Hands on experience working with ODI Knowledge Modules- LKM, IKM, RKM, JKM and CKM. Customized versions for the existing ODI Knowledge modules which can be re-used in data integration projects.
• Optimized the Knowledge modules for increasing the efficiency of jobs as a part of performance tuning.
• Involved in Performance tuning for sources, targets, interfaces and sessions.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads and Data Transformations.
• Gathered requirements from the customer, designed the technical specs and technical documentation, developed Interfaces and Workflows as per the business requirement, tested the application and deployed it to production.
• Worked with the OBIA Financial Analytics Suite using OBIEE 11.1.1.7.x and customized the dashboards and metrics for reporting.
• Designed, documented and tested logical and physical data models optimized for operational and analytical reporting
• Created Income Statements and Balance Sheet reports from GL, Top 10 supplier and Invoice reports from AP, Aging Reports from AR.
• Used BI Publisher and created complex pivot table reports and cross-tabular reports using connected queries of data models with parameters passed from data model as well as parameters.
• 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.
• Used various templates in BI Publisher to publish the reports as per user requirements.
• Customized the Oracle stored procedures to aggregate the data into different metrics based on Business Unit using PL/SQL.
• Presented demo sessions of the BI tool in many offsite locations of the client and won appreciation from the executive teams.
• Effectively communicated and collaborated with cross-functional business partners and made them love the flexibility the OBIEE tool has to offer.
• Used PLSQL Developer for running SQL queries.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.

Environment: ODI12, 11.1.1.7.x(Topology manager, Repository Manager, Designer, Load Plan Generator, and Operator), Oracle 11g, OBIA (Inventory, Sales, Bill of Material, Order fulfilment, Shipping) OBIEE 11.1.1.7.x, PLSQL Developer, SQL, PLSQL.

Confidential

ODI Developer

Responsibilities:

• Involved in data analysis, designing and development of data warehouse environment. Developed and implemented a strategy for the install and configure of Oracle Data Integrator11g.
• 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.
• Monitored sessions for executions using ODI operator. Managed user privileges using ODI Security Manager .
• Associated with Production support team in various performances related issues.

Environment: ODI 10g/11g, PL/SQL, SQL Navigator, Teradata, SQL Assistant.