SUMMARY

• 8 years of Experience years of experience of IT experience which includes Analysis, design, development, Testing and Implementation of complete Software development life cycle and all aspects of gathering Business Requirements.
• Experience in Working in Oracle Customer care and Billing (CCB), Oracle Network Management System (NMS) and made reports for Meter Reading. Conducted meetings requirements with business users. Experience in Oracle Utility Analytics (OUA).
• Experienced in using Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into Enterprise data warehouse (EDW).
• Experience in ODI designer, Topology, Operator, Master repository, work repository creation and deployment, dimensional modeling - star and snowflake schemas, data marts, fact and dimension tables identification, and OLAP.
• Experienced in BI Administration tool. Good Knowledge on data modeling, data warehousing, Kimball Methodologies/Techniques.
• Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Interactive Dashboards and drill down capabilities using global and Filters and Security Setups.
• Worked with developing two complete life cycles of OBIEE 11g reports. Created/Modified Metadata repository (.RPD) and Configured Metadata Objects using Siebel Analytics Server Admin tool.
• Extracted data from different sources like Oracle Tables, views and flat files, Hyperion implemented Business logic and loaded into target warehouse (Oracle).
• Created Informatica Mappings and Mapplets using active and passive transformations and have the experience in using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management.
• Experience in debugging Interfaces. Identified bugs in existing Interfaces.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse (data warehousing) for developing the mappings using Transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Sequence generator, joiner and Router Transformations etc.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Expert in writing SQL queries and PL/SQL Development, Stored Procedures / Functions/ Packages / Database Triggers, Exception Handlers, Cursors.
• Expertise in BI Publisher, Developing and designing the template in rich text format (RTF) and portable document text format (PDF).
• Developed Test Cases and Test Strategies. Analyzed Business Workflow and assisted in Data Mapping.
• Excellent problem-solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

Reporting Tools: OBIEE 10g/11g/12c, OBI Publisher 11g, Oracle BI Apps 7.9.6/7.9.5 , Tableau 9.2

ETL Tools: ODI 11G,12C, Informatica 9.x/8.x, DAC10.x, 11.x

Database Systems: Teradata 14.0, SQL Developer, DB2, MS SQL Server, MS Access, Oracle 9i/10g/11g/12c (SQL, PL/SQL, T-SQL, NoSQL, Procedure, Views, Materialized View, Table Partitioning, Backups, Explain Plan), Oracle EBS R12, WINSQL 9.0

Languages: C, C#.NetScripting Languages ASP.Net, CAML Query, XML, XPath, UNIX Shell script

Data Modeling: Data Modeler, ERWIN 7.2

Operating Systems: Windows 2010/2007/XP, Windows Server 2008/2003, Linux

Web Technologies: CSS, HTML, XML

Software Tools: ACTIVE DIRECTORY, Essbase Studio, Microsoft Office/Visio/Project 2010, Microsoft Visual Studio 10, SharePoint Designer 07, WinSCP

PROFESSIONAL EXPERIENCE

Confidential - IL

ETL/OBIEE Developer

Responsibilities:

• Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Worked on the Technical and Functional Design Business Requirements gathering, and documented the Technical Design Documents, Functional Design Documents and Data Lineage Documents as per the business rules.
• Provided best practices which need to be followed for object migration between environments.
• Gathering requirements from users to develop interfaces, packages, Load Plans.
• Performed the unit testing, system integration testing and assist with user acceptance testing
• Documented the ETL detailed design and test results.
• Created and maintained integration process using ODI and load rules
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Spearhead development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.
• Developed custom Informatica v8.x mappings and workflows for data extract (with data change capture mechanism) from Siebel OLTP environment to Oracle Business Analytics Warehouse
• Responsible for providing first level operational support for development and production database systems.
• Develop Comprehensive monitoring an Alerting. Experience with shell scripting and Python.
• Implemented Synchronous and Asynchronous Change Data Capture CDC techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Validate the required data at the database level by using tool Toad

Confidential - Evansville, IN

ODI/OBIEE Developer

Responsibilities:

• Requirements Gathering and Business Analysis. Project coordination, End User meetings
• Development and design of ODI interface flow for Upload / Download files
• Work as a part of DevOps team to upgrade multiple existing ODI versions to a single unified version.
• 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, SQL SERVER) feeds using ODI.
• 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. Troubleshoot ODI/WebLogic issues
• Defined ETL architecture for integrating data at real time and batch processing to populate the Warehouse and implemented it using Oracle Data Integrator Enterprise Edition 12C.
• Installation and Configuration of Oracle Data Integrator (ODI)
• Create and Customize the Physical Layer, Business Model and Mapping Layer and Presentation Layer in OBIEE Repository using Administration Tool.
• Develop Reports/Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector and Tabular with global and Local filters) using OBIEE.
• Worked with Business users for Gathering Requirements for Meter Reading Assignments. Experienced in Oracle CCB.
• Gathered Requirements and Made reports using OBIEE. Closely worked with Oracle utility analytics as well.
• Worked on making Functional Design Documents (FD) as well
• 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 ODI Packages, Jobs of various complexities and automated process data flow.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using OBIEE.
• Implemented Data Level and Object Level Security using External Table Authentication, as well as Presentation Services.

Environment: ODI (Oracle Data Integrator) 12c, SQL Developer, Oracle 11g/10g, OBIEE, UNIX scripting

Confidential - Seattle, WA

ODI/OBIEE Consultant

Responsibilities:

• Primary responsibility includes installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL
• Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Extensively involved in production issues.
• Gathering requirements from users/business to develop interfaces, packages, Load plans.
• Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
• Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and production support.
• Worked with Business users for Gathering Requirements for Meter Reading Assignments. Experienced in Oracle CCB.
• Gathered Requirements and Made reports using OBIEE. Closely worked with Oracle utility analytics as well.
• Worked on making Functional Design Documents (FD) as well.
• Extensively used OBIEE Administration Tool for customizing and modifying the physical, business, and Presentation layer of the repository.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using OBIEE
• Extensively used ODI to load data from Oracle, XML files and flat files
• Worked closely with the end users/business and designing the documents to the track changes.
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.

Environment: Oracle Data Integrator 12c, BI Apps 11g, OBIEE 12.2.1.1, Oracle database, MS SQL Server, Windows 7, UNIX/Linux, Shell scripting, TOAD, SVN.

Confidential - San Jose CA

ETL(ODI)/OBIEE Developer

Responsibilities:

• Worked on the Technical and Functional Design Business Requirements gathering, and documented the Technical Design Documents, Functional Design Documents and Data Lineage Documents as per the business rules.
• Provided best practices which need to be followed for object migration between environments.
• Gathering requirements from users to develop interfaces, packages, Load Plans.
• Performed loading of delta changes to target table with CDC and Time stamp process.
• Performed Versioning of ODI objects using external versioning tools and using internal ODI versioning using Solutions.
• Upgrading from ODI 11G to ODI 12c environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 12c.
• After Upgrading in Development environment performed export and import.
• Used Smart export and import for finding dependencies to perform export and import of ODI objects.
• Experience in Dimensional Modeling such as star schema, snowflake schema, creating Facts, Dimensions and Measures.
• Experience in running RCC Repository consistency check to see if master and work repositories are consistence.
• Experience in using new concept called mapping which is newly introduced in ODI12c. Created mappings with joining multiple sources and loading to multiple tables using IN and OUT connectors
• Worked on using component panel where we can use functionalities like aggregate, dataset, split, filter, join, set, sort.
• Assisted in building the Functional and Technical test scripts for the regression testing of the dashboards and the publisher reports in OBIEE.
• Involved in both OBIEE and ODI upgrades from 11g to 12c
• Performed production support for the project, restarted and maintained the OBIEE Servers.
• Developing BIP reports, writing complex SQL queries as per the business requirement

Confidential -Greenville, SC

ODI/OBIEE Developer

Responsibilities:

• Deployed various components of ODI, setup the topology navigator (physical and logical architecture, agents and context), security navigator (profiles and user permissions).
• Worked along with business analysts, developers, management professionals and as well as with business users from various locations of Amway to gather requirements.
• Experience in Dimensional Modeling such as star schema, snowflake schema, creating Facts, Dimensions and Measures.
• 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.
• Creating/customizing the OBIEE Repository and reports based on the new requests from business users.
• Executed monthly financial modeling, budget improvement, processed expense reports and implemented time series modeling in OBIEE.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration
• Used Oracle Data Integrator Designer ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Oracle Data Integrator ODI reduce the dependency on Excel and other proprietary tools for data entry and reporting and provide various brand level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Extensively worked with different ODI Knowledge modules (LKM, CKM and IKM) and customized the Knowledge modules multiple times especially IKM to implement SCD
• Primary responsibility includes but not limited to installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Contributed to build business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue, customer retention and salesperson productivity.
• Worked on Dimensional modeling by converting transactional data into the analytical data.
• Built OBIEE reports against to the Oracle DB and configured the RPD connectivity with Oracle Data source.
• Created Logical Tables, Dimensions, Facts and additional Metadata in the Business Layer by using Administration tool.
• Worked extensively on BMM (Business Model and Mapping) layer to develop various business models using Star Schema and Snowflake Schema.
• Develop Comprehensive monitoring an Alerting. Experience with shell scripting and Python.
• Implemented Synchronous and Asynchronous Change Data Capture CDC techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Validate the required data at the database level by using tool Toad.

Confidential -Boston MA

ODI/OBIEE Developer

Responsibilities:

• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets
• Good experience in developing EL-T (Extraction, Transformation and Loading) procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables.
• Performed the unit testing, system integration testing and assist with user acceptance testing
• Documented the ETL detailed design and test results.
• Created and maintained integration process using ODI and load rules
• Perform the unit testing, system integration testing and assist with user acceptance testing
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Spearhead development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.
• Developed custom Informatica v8.x mappings and workflows for data extract (with data change capture mechanism) from Siebel OLTP environment to Oracle Business Analytics Warehouse
• Responsible for providing first level operational support for development and production database systems.
• Designed data models for the custom tables.
• Worked with OBIEE Installation, Oracle BI Server, Presentation Server, Oracle BI Administration Tool and Oracle BI Publisher.
• Developed OBIEE repository to on top of Sales, Marketing data warehouse
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Involved in creation of dynamic variables and used them in the reports.
• Developed multiple reports and used value interaction to navigate to other reports. Created complex dashboards and reports.

Confidential

OBIEE Developer

Responsibilities:

• Worked with OBIEE Installation, Oracle BI Server, Presentation Server, Oracle BI Administration Tool and Oracle BI Publisher.
• Developed OBIEE repository to on top of Sales, Marketing data warehouse.
• Used the OBIEE 10.1.3.3/10.1.3.4 Admin tool to develop and enhance meta-data.
• Performed the detailed design of Reports / Dashboards and Analytical Data Model (Metadata /.rpd).
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event polling strategies in the repository.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.
• Viewing report data in BI publisher using templates.
• Creating reports based on BI Answers request.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.3/10.1.3.4 , Oracle 10g, TOAD, SQL Developer Windows-XP.