SUMMARY:

• Over 8+ years of experience in Information Technology in designing, developing, architecture, administration and implementation of Business Intelligence, Data Warehouse Applications under different environments.
• Core focus on Data Warehousing OLAP tools, BI and PL/SQL. Experience in various domains like HealthCare, Finance, Retails Insurance and Manufacturing.
• Extensively worked with large Databases in Development, Testing and Production environments.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Worked on ODI 11g and 12c studios. Using Data Warehousing tools like OBIEE, ODI.
• Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager.
• 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 Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked on slowly changing dimensions (SCD), Change data capture (CDC) as part of data warehousing concepts.
• Oracle Data Integrator (ODI) 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.
• Primary responsibility include 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.
• Designed and implement complex ETL/ELT jobs.
• Expertise in providing end-to-end business Intelligence solutions using (OBIEE 10g/11g) with greater emphasis on BI Administration Tool and BI Analytics web, Dashboard Creation, Answers, BI Publisher.
• Expertise in creating and implementing functionalities like Dimensional Hierarchies, Measures, Aggregation rules, Level based measures, Rank functions, Time Series Objects.
• Worked extensively on debugging, troubleshooting the defects and production issues in the areas of ODI jobs and OBIEE reports.
• Specialized in Business Intelligence Reports using OBIEE, which provided adequate reporting facilities to the management system facilitating the decision making process and to provide report metrics.
• Expertise in communicating with business users during various phases of requirement gathering and Software development
• Participated in train the trainer sessions.
• Expert level of understanding in architecture and implementation of features related to all major releases of Oracle Data Integrator.
• Experience in Data transformation using Informatica.
• Extensive experience with end user requirement gathering and converting Business requirement into technical specification.
• Possess analytical skills, ability to communicate effectively with all levels of management, and ability to share knowledge in testing, data integration, reporting, and documentation.
• Worked in complete SDLC & Production Support and experience working in Oracle Architecture.
• Expertise in unit testing at various levels of the ETL as well as SQL, UNIX etc.

TECHNICAL SKILLS:

ETL Tools: ODI 12c, ODI 11g, ODI 10g, Informatica 7.1.1

Databases: Oracle … Oracle Exadata, Sql Server (2008 & 2012)

Hardware & Operating Systems: IBM, Sun, Linux, HP Unix, Windows … Windows Server 2005, 2008 R2

Programming Languages: SQL, PL/SQL, Rman, Java, C, PRO*C, Shell Scripts

Data Modeling: MS Visio Diagrams / Erwin, Designer 2000

Development Tools: Oracle Grid, Toad, Oracle Forms & Oracle Reports, SQL *Plus, SQL *Loader, Nosql, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential Eric, PA

Sr. ODI Consultant

Responsibilities:

• Gathered ETL, BI requirements.
• Installed OBIEE and ODI on clients, servers, and remote machines
• Extracted data from SQL Server 2005 and flatfiles to Oracle 11g.
• Replicate SSIS process to Oracle via ODI.
• Created complex process with ease to load complete legacy SQL Server database data to Oracle via ODI 12C.
• Migrated procedures, functions, tables, views, and other objects to target database (Oracle).
• Extracted Unix, windows, and fileserver flat files (Text, .csv, .xlsx, .xml) to Oracle via ODI process.
• Created ODI global and project variables to facilitate ODI 12C process.
• Created ODI and Oracle sequences.
• Created inbound and outbound reusable mappings to in corporate in other mappings.
• Created complex process to split bad and good records in different tables and send good records to final target system.
• Created ODI packages for success and failure sessions with odisendmail alert.
• Created ODI project variables (set, declare, refresh, and evaluate).
• Created multiple target mappings from single source file.
• Monitor Oracle Data Integrator components availability and performance out-of-the- box access historical data, track logs, and receive email notifications of potential error sessions.
• Trace end-to-end Oracle Data Integrator Sessions activity, review execution statistics and drill- down from a particular Step or Task into a detailed report of Oracle databases activity.
• Used ODI 12C components (Aggregate, dataset, distinct, expression, filter, join, lookup, set, sort, split).
• Configured ODI topology (Physical architecture, logical architecture, and context).
• Moved code from dev environment to test to prod.
• Created standard reverse engineering models for flatfiles, SQL Server, and oracle.
• Debugged ODI 12C log to edit code and restart the error session to start from where it failed.
• Schedule scenarios in Operator in DEV/QA/Prod. Error handling by monitoring the job execution in Operator and fixing the code.
• Testing the integrations developed, create SIT test scripts, validate test results, upload the SIT scripts on share point site and participate in UAT sessions.
• Tune SQL statements based on the execution plan
• Worked closely with Project Manager for ROME in order to provide time estimates for the project.
• Worked on optimizing and testing codes for defect free delivery.
• Mentored Interns on ODI development concepts.

Environment: ODI 12.1.3, OBIEE 11.1.1.7, ORACLE 11.2.0.4, WebLogic Server 10.3.6.0.2 , SQL Developer 3.2, Toad 11.6, putty, Filezilla 3.10.1.1

Confidential, San Francisco, CA

Sr. ODI Developer

Responsibilities:

• Designed the interfaces to implement ETL strategy to populate the data from various sources using ODI.
• Created ODI interfaces, functions, procedures, packages, variables, scenarios to migrate the data.
• Scheduled and administered database queries for off hours processing by creating ODI Load plans and maintained schedules.
• Used various knowledge modules to clean, load and transform data from source to target.
• Customized knowledge modules in ODI according to the business requirements.
• Implemented Change Data Capture through ODI using Journalising Knowledge modules (KM's) to minimise the data load times.
• Loaded multiple files into oracle using external tables.
• Worked with Oracle BI App modules HR and Financial Analytics by configuring ODI packages with BI Apps domain files.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Worked on using files system (DSV) as source and finally load data to target which is oracle tables.
• Worked on using Oracle loader utility for loading data from file to tables using external table concept.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Created SQL scripts for sourcing data, including creating tables, Materialized views, stored procedures, and loading data into the tables.
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Used User functions for converting date format from AS400 to Oracle.
• 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.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse.
• Estimated ETL project tasks and helped project manager define scope.
• Analyzed data issues reported by production team and provided solutions.
• Associated with Business Intelligence team in creating reports, dashboards.

Environment: ODI 10.1.3.4, Oracle BI Applications HR and Finance analytics, Oracle Applications R12, Flat Files, TOAD.

Confidential, Mclean, VA

ODI Consultant

Responsibilities:

• Analyzing and designing mapping with requirement documents.
• Installing ODI 11G on standalone systems, remote desktop, and server on Linux box.
• Cloning work and master repository.
• Upgrading ODI 10.1.3.5 to 11.1.1.7.
• Setup and maintain multiple instances and repositories for multi-user environment.
• Configured ODI physical and logical schema with Context.
• Deploy and configure J2EE services for scheduling ODI jobs.
• Monitoring jobs through ODI Console.
• Established standards, guidelines, and practices for DW development.
• Configured Changed Data Capture and used Journalized Knowledge Module.
• Created standard reverse engineering models.
• Created temporary and permanent data store interfaces according to the requirement .
• Created load plans, packages, procedures, variables, and generated scenarios.
• Extracted data from various sources Legacy and flat files including XML and loaded into target Oracle system.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Migrated scenarios from ODI designer into SIT and production environments.
• Tuning and error handling in the ETL process.
• Created Views, Functions, Procedures and Packages in PL/SQL for ODI process.
• Improved the performance by implementing partitioning strategies and also monitored ODI generated SQL for performance tuning.
• Estimated ETL project tasks and helped project manager define scope.
• Analyzed data issues reported by production team and provided solutions.
• Associated with Business Intelligence team in creating reports, dashboards.

Environment: Oracle Data Integrator (ODI) 11g/10.1.3.4, Oracle 11g/10g, SQL*Plus, TOAD, WinNT/XP.

Confidential

OBIEE Developer

Responsibilities:

• Performed daily duties in operations to ensure the company meet its weekly and monthly objective.
• Identified the granularity level of the data required for the analysis. Developed Metadata repository (rpd) by importing required objects, Configured the business model layer & presentation layer as per the reporting requirements.
• Created OBIEE Star Schema in RPD semantic layer based of 3NF data model to allow Ad-hoc reporting and creation of Standard reports.
• Directly involved in database tuning and query performance tuning to achieve maximum performance while retrieving data from database structures.
• Understanding the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document.
• This involved interacting with the business users and understanding the requirements.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Created different types of Ad-hoc queries/ Customized Reports (Drilldown, Aggregation, Levels) and assigned them to application specific dashboards in order to meet business requirements.
• Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Coordinated the OBIEE rpd and web catalog objects migration from DEV environment to QA and to the production environment.
• Provided production support for end-users of the system which included the training, responding to questions, resolving problems, and providing ad-hoc reporting.

Environment: OBIEE 10.1.3.4, Oracle10g, Windows XP, PL/SQL, SQL *Plus, TOAD.