PROFESSIONAL SUMMARY:

• 8+ years of IT experience in Requirements gathering, Analysis, Design, Development, Implementation, Modeling, Testing and support for Data warehousing applications.
• Extensive DW experience using Oracle Data Integrator(ODI), Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
• Experienced in ODI & OBIEE solution architecting (12C, 11g & 10g) and have a strong understanding on Weblogic Version: 10.3.5 & 12.2.1.0.0 as an Application server.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ELT processes and providing data mining features for data warehouses, and Scheduling - DAC .
• Experienced on creating BI reports in different subject areas, critical analysis and upgrade of the existing reports.
• Worked on using BI reporting tools like Oracle Business Intelligence Enterprise Edition (OBIEE) 12C/ 12.2.1.0/11.1.1.9.0/10.1.3.4 , Oracle BI Publisher.
• Very good in Debugging, Optimizing the Analytics Dashboards/ Reports and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports.
• Expert in Oracle EBS R12 configuring, designing, development, implementation and using Oracle BI Apps pre-build RPD’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements.
• Configured Oracle Business Intelligence Application (OBIA) 11.1.1.8.1 HR Analytics, Financial Analytics, Sales & Marketing Analytics, and Supply chain, Retail and Procurement & Spend Analytics, Pharma Analytics.
• Worked on Oracle Data Integrator (ODI) to reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Expert in 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.
• Possess clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL/ELT and life cycle development Using Oracle Data Integrator (Repository Manager, Designer, Load Plan Generator and Operator).
• Worked on Slowly Changing Dimensions and its implementation to keep track of Historical data.
• Actively involved in Performance Tuning, Error handling and production support for various projects.
• Implemented different Caching techniques to improve the performance of BI server.
• Experienced in troubleshooting installation issues, production issues and production support for projects.
• Experienced in analysing the needs of the user and creating new BI reports according to the user requirement in OBIEE.
• Practical understanding of the Data Modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modelling of data
• Extensive experience in building Interactive Dashboards with drill-down, drill-across capabilities using global, local Filters, Guided Navigation, Business rules, selection steps, prompts, etc.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Experience in UNIX working environment, writing UNIX shell scripts for ODI pre & post session operations. experience in designing and developing solutions using the Curam platform.
• Excellent communication and interpersonal skills.
• Ability to work effectively as a team member as well as an individual.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).

TECHNICAL SKILLS:

BI TOOLS (Infrastructure & Applications): OBIEE 10g/11g/12C, BI publisher 10g/11g, EBS Financial, OBIA R12, 7.9.6.3, 7.9.6.1(Financial Analytics, HR Analytics, Sales, Service, Marketing, Supply Chain, Manufacturing, Procurement.)

ETL TOOLS: ODI 12C/11g/10g, DAC 10.1.3.4.1 , Informatica Power Center 9x

DATA BASES/ RDBMS: Oracle 12c/11g/10g/9i/8i, SQL Server, DB2 UDB, TOAD, MS-Access, AS 400, Hyperion System 9

OPERATING SYSTEMS: MS Windows 10, 8.x, 7,xp, Vista, UNIX, Mac OS X, Linux, Solaris

LANGUAGES & Web Technologies: SQL, PL/SQL, XML, UNIX Shell Scripting, Java, JVS, C++,C, HTML/XHTML.

ERP / Applications Servers: Oracle Applications 11i & R12, Oracle Web Logic Server 10.3.5, 11g,12C

METHODOLOGIES: Software Development Life Cycle(SDLC)- Waterfall Model, Agile, Rational Unified Process(RUP), JIRA(Ticket tracking)

WORK EXPERIENCE:

Confidential, Morrisville, NC

Sr. ODI/OBIEE Developer

Responsibilities:

• Involved in Analysis of the Project requirements.
• Extracting the data from various source systems.
• Involved in the Installation and Migrating of ODI 11g & 12C.
• Performed loading from flat files to Oracle in Dev. UAT and Prod Environment.
• Worked on SQL loader utilities.
• Used Shell Scripting to figure out the Files, records, directories, and troubleshoot the bad files/records.
• Created and Designed (ODI/ETL) Data Load process across the clients.
• Created ODI Package of various complexity and automated process data flow.
• Worked with OBIEE Installation, Oracle BI Server, Presentation Server and ODI.
• Design and develop complex reports using ODI/OBI 12C.
• Implementation of Object level security for the Dashboards and OBIEE reports.
• Developed OBIEE Repository at three layers (Physical, Business model and Presentation Layers).
• Performed source to Staging and staging to target mapping specifications and developed ETL / ODI code for the same.
• Created Topology connection for reading xml logs and writing into oracle db.
• Created ODI Interfaces for reading data from xml using external properties and loaded into staging table.
• Created ODI Interfaces to load data into ODS for downstream systems.
• Created Source and Target systems physical and logical data server connections into ODI Topology Manager
• Created ODI Variables and used it into ODI interface, Procedure and Packages
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Created Interfaces to load data from source systems to staging area, staging area to dimension and fact tables of Target
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables.
• Interacted with the client for requirement gathering and prepared OBIEE documents.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files.
• Identified the source and target schemas and the ER relationships to support the business reporting model.
• Gathering requirements from users to develop interfaces, packages, Load plans.
• Created Master and Work Repository and developed the ODI mappings.
• Used Topology Manager to define data servers and physical schemas for source and target databases.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources, reverse engineering, to develop projects, and release scenarios.
• Developing reports using JavaScript is a plus.
• OBIEE Administration and complete understanding of deployment procedures and automate the process.
• PL/SQL and Oracle/MS SQL server database.
• Ability to work in fast paced environment using agile concepts.
• Deployment of the OBIEE RPD to the BI Presentation Services.

Environment: ODI 12C, 11g, OBIEE 12c, RDBMS Oracle 12C, 11g, Toad (12.5, 11.x), PL SQL. EBS R12, UNIX, Agile, OBIEE 11.1.1.6.5 , OBIA 7.9.6.3, BI 12c,Oracle BI Publisher, Argus 7.0.1, Argus 8.1, Oracle EBS, Web Logic Server 11.x, Oracle 11g, SQL*PLUS, SQL Developer.

Confidential, SARASOTA, FL

Sr. ODI/OBIEE Developer

Responsibilities:

• Responsible for developing & administrating the ELT processes using Oracle Data Integrator (ODI).
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Develop complex interfaces to load the data from the various sources into dimensions and facts.
• Testing and fixing the bugs in the interfaces and migrating them to stage and production environments.
• Participating in team planning sessions.
• Created ODI Package of various complexity and automated process data flow
• Created ODI Interfaces to load data into ODS for downstream systems
• Gathered ELT requirements from Business team and designed its high level documents.
• Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool.
• Debug the mappings using debugger to resolve code issue.
• Worked in importing data from heterogeneous data sources like Flat files, AS 400, MDMS, Hybris, database, XML files, excel etc.
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Migrated Code from Development to Testing to production.
• Involved in Unit testing, User Acceptance Testing and System Testing to verify accuracy and completeness of ETL process, Prepared & documented unit test plans
• Created ODI jobs to replicate the existing process of SQL scripts Created ODI Interfaces with simple to complex transformation rules while migrating from Source to the target.
• Conducted thorough Unit Testing, System Integration testing, UAT, MTP and Production Support Co-ordination effectively.
• Used PLSQL Developer for running SQL queries.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Customized the Oracle stored procedures to aggregate the data into different metrics based on Business Unit using PL/SQL.
• Extensive experience in working with OBIEE and OBIA Answers, Delivers, iBots, and Intelligent Dashboards
• Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.

Environment: ODI 12C, 11.1.1.7, 11.1.1.9, OBIA 11g, OBIEE 12c, RDBMS Oracle 12C, 11g, Toad (12.5, 11.x), PL SQL. EBS R12. DB2

Confidential, Woonsocket, RI

Sr. ODI/OBIEE Developer

Responsibilities:

• Worked on Oracle Enterprise Manager (OEM) to activate and Deploy RPD.
• Extensively used Catalog Manager for migrating Web Catalog.
• Worked in developments of analytics Reports using OBIEE Answers and assign them to specific Dashboards with Oracle Financials EBS as source of data from the modules like AP, GL and FA
• GG setup integrated capture to replace CDC.
• Experience in installing, maintaining, upgrading and patching Golden Gate.
• Worked on the RPD for the new Subject area design for the Cash flow Metrics Created Reports, Dashboard 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.
• Installing ODI 11.1. on all the environments and configuring ODI.
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule.
• Patching ODI 11.1 to 11.1.1.and Upgrading ODI from 10.1.3.4 to 11.1.1.
• 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.
• Financial Planning Manager and other developers
• As an administrator I was responsible for security across multiple users and groups.
• Created Packages, Scenarios and Load Plan Components, Load Plans using ODI.
• Generated Load Plans and Executed Integrated Testing over Payroll Subject Area using ODI.
• Provide ad hoc ability in the OBIEE system for query and build reports.
• 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.
• Unit, integration and system testing for all components of ETL and reporting. Prepared test cases and documented the results.
• Created PL/SQL stored procedures, functions and triggers for change data capture (CDC).
• Creating standalone agent on windows server.
• Implemented CDC through ODI Journalization Knowledge Modules (KMs).
• Developed Expressions, filter, joins, Split, Variables, user functions Using ODI
• 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.
• Performance Tuning of Reports and made required changes to repository and database.
• Complete responsible for preparing the END to END Document.
• Working on UAT data and hierarchy issues.
• Worked with the team and a DBA to communicate and negotiate data needs.

Environment: ODI 11.1.1.5.0 , ODI12c, WebLogic Server 11.x, OBIEE 11.1.1.6.5 , OBIA 7.9.6.3, Oracle EBS, Oracle 11g, SQL*PLUS, SQL Developer, Windows XP.

Confidential, Westlake, TX

ODI / OBIEE Developer

Responsibilities:

• Created and developed the ODI Interface metadata mappings to extract the data from Exhibition Event Master and EBS Apps to consolidate the data into Enterprise data warehouse.
• Involved in system performance tuning to improve the performance from OBIEE report/dashboard wise and RPD.
• Designed Aggregate Tables modeled the repository for improving performance of reports.
• Identified Gaps by analyzing the Datamart instance and provision of alternative solutions as well as recommendation of changes to databases.
• Designed ETL mappings for bringing in data from various data sources using ODI.
• Identified the fact and dimension tables, designed the Kimball Matrix, created the data mapping field matrix
• Developed multiple Dimensions with multiple Drill-Down Hierarchies in Business Model Layer and customization of Presentation catalogs in Presentation Layer
• Configured more than 90 Measures in the Business Model Layer that are not critical to performance and mapped them to multiple logical source tables
• Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures. Also created Fragmentation content for few fact tables
• Involved in data model designs and assisted in ETL design mappings using Oracle Data Integrator (ODI) to extract the data.
• Modify existing ETL jobs in Oracle Data Integrator(ODI).
• Develop data extracts from the data warehouse environment using ODI.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Developed OBIEE dashboards using JavaScript and Cascading style sheets.
• Created Roles/Groups in OBIEE to provide the access to multiple departments without relying on the responsibilities.
• Integrated LDAP server in order to authenticate the users along with Native authentication. Maintained the groups in LDAP and applied the security on user level.
• Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
• Extensively worked on complex Interfaces which involved slowly changing dimensions.
• Created Complex procedures and used them in the interfaces to load the data to simplify the interface design. Automated the schema name using ODI interface function in procedures.
• Customized requests and modified the OBIEE Dashboard using cascading style sheets
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Performed Unit, Integration, and Regression testing to validate report and mapping
• Respectively participated in weekly Project status meetings and communicated effectively with Project Managers.

Environment: OBIEE 11.1.1.5.x, BI Publisher, Oracle 11g, ODI 11.1.1.9, SQL, PL/SQL, Informatica-Power Center 9.6, SQL*PLUS, SQL*Loader

Confidential, Columbus, OH

ODI / OBIEE Developer

Responsibilities:

• Gathering requirements from users to develop interfaces, packages, Load plans.
• Created Master and Work Repository and developed the ODI mappings.
• Used Topology Manager to define data servers and physical schemas for source and target databases.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources, reverse engineering, to develop projects, and release scenarios.
• Worked on using component panel where we can use functionalities like aggregate, dataset, split, filter, join, set, sort.
• Worked on Physical and Logical tabs where in physical tab we can choose KM's and in logical tab we can create mappings.
• Worked with OBIEE Administration tool, Security, Repositories creation and management (Online and Offline).
• Developed data across all the three layers-Physical, Business Models and Mapping, Presentation layer.
• Oracle EBS R 12/11.5.10.2 and OBIEE integration and LDAP Single Sign-on configuration.
• Developed customized dash boards, score cards and ad-hoc reports.
• Collaborated with the end-users, pilot users to identify their needs and improve the data delivery.
• Worked with PDF, Excel and word templates using BI-Publisher.
• Interfacing with management on all Oracle EBS project related issues, changes, reporting
• Developed additional views (narrative, pivot, chart views) for the data returned by the Query in order to visualize the data in different ways.
• Designing ETL Data Flow Mappings using OWB for data integration preparing a data warehouse creating mapping from source systems to Data warehouse targets from Oracle R12 EBS applications database and several other data sources.
• Data Modeling done with Multidimensional Architecture (Star Schema, Snow Flake Schema).
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Worked on different caching techniques, trouble shooting techniques to improve the performance of the system.
• Created test plans and performed unit testing to test the reports and dashboards.

Environment: (OBIEE) 11g, Oracle EBS R12, Informatica-Power Center 9.5.1, Oracle R12 EBS, Oracle 11g, Windows, SQL Server, Linux, Erwin 7.

Confidential, Dallas, TX

ODI/OBIEE Consultant

Responsibilities:

• Created several ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, and Security Manager) & Knowledge modules (Reverse-engineering, Journalizing, Loading, Check, Integration and Service).
• Responsible for issue resolution and performance tuning of ODI Interfaces.
• Created Source and Target systems physical and logical data server connections into ODI Topology Manager
• Created ODI Variables and used it into ODI interface, Procedure and Packages
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Created Interfaces to load data from source systems to staging area, staging area to dimension and fact tables of Target.
• Installed OBIEE 11.1.1.5 on Solaris and configured horizontal scaling for high availability. Upgraded OBIEE reports and BI Publisher reports from 10.1.3.4 to 11.1.1.5.
• Effectively interacted with the users for requirement gathering and performed GAP analysis.
• Participated in the weekly meeting to structure the timelines for the project.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created dimension hierarchies, logical levels, level keys, and level based measures,.
• Used the expression builder utility for the new logical columns in the BMM layer and created various calculation measures and Time series measures.
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables
• Used Refresh, Set and Evaluate ODI variables types into ODI Packages
• Created Scenarios of ODI Packages for migrating code into Prod execution repository
• Migrated Code from Development to Testing to production.
• Participated in the weekly meeting to structure the timelines for the project.
• Documented the data loading scenarios in Oracle Data Integrator (ODI).
• Performed Unit, Integration and Regression testing to validate reports and data.
• Implementation of the logic and developing the Reports, and Gap Analysis and Data Sanity Check.
• Taking up the calls with the users/customers for gathering the change requests and feedback on the resolved defects

Environment: ODI 11g, OBIEE 11.1.1.7/10.1.3.4 , SQL, Oracle 11g, Toad, MS VISIO, EBS 11.

Confidential

OBIEE/ ETL Informatica Developer

Responsibilities:

• Full project life cycle implementation for Business Analytics Warehouse.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Experience with ETL/ETI (Informatica) (Extraction Transform and Loading, Extraction Transform and Import) data from production database to data warehouse database
• Worked on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
• Reused mapping, mapplets and transformations.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Created new requests and opened Answers for adhoc reporting to the End users
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Documented all the configurations and new reports creation and published it to the end users.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Siebel Analytics 7.8, BI Apps 7.8.4, Informatica 7.1, Oracle 10g/9i, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.