SUMMARY

• 8 years of IT experience and strong background in Analysis, Design, Development and Implementation of Data Warehousing in ETL. Worked extensively in developing ETL for supporting Data Extraction, Transformation and Loading using ODI/Synopsis.
• Experience in building BI DW’s/performing Data Integration from source systems to EDW, ODS, BI Reporting solution systems using Oracle Data Integrator v.11g/10g (v.11.1.1.3/v.10.1.3.5).
• Expertise in Oracle Data Integrator and ETL loads.
• 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
• Translated business requirements into technical specifications to build the Enterprise Data Warehouse
• Experience of having worked with ELT Tool ODI against different databases Oracle (9i, 10g), MS SQL Server (2005, 2008), DB2 and MS Access.
• Implemented the Change Data Capture (CDC) feature of ODI to minimize the data load times.
• Installation and Configuration of Oracle Data Integrator (ODI)
• 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.
• 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.
• Expertise’s in developing Slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 and Type3 as a part of Performance Tuning.
• Strong in analysis, design, coding and a good Team player in full life cycle / SDLC support from Initial design phase to production support.
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO)
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Experienced in troubleshooting production issues and production support for projects.
• Experience in customizing mappings to transform data from a transactional database and other sources to staging tables and further to target tables.
• Used SQL Loader and PL/SQL for Conversions and validations.
• Maintained performance tuning by using SQL Trace, Indexes and Clusters
• Hands on experience on PL/SQL stored procedures, functions and triggers.
• Experience with Design, code, and debug operations, reporting, data analysis and web applications utilizing python
• Very strong experience writing API's/ and Web Services in PHP and in python.
• Utilized pythonPandas framework to provide data analysis.
• Experience in analyzing, designing, developing, implementing, tuning and supporting the Hyperion Suite of tools including Hyperion Essbase, Hyperion Planning and Hyperion Reporting
• Experience in writing Essbase Scripts and maintaining multidimensional database
• Experience in Essbase database design, cube design, Essbase Calculation Scripts, business rules, security filters and Report Scripts
• Expertise in HyperionPlanning and Enterprise Performance Management Architect & Workflow design.

TECHNICAL SKILLS

ETL Tools: ODI 11.1.1.6/10.1.3.5

Reporting Tools: OBIEE 10g/11g, BI Publisher

RDBMS: Oracle 10g/9i/8i, SQL Server 2008/2005

Programming Languages: SQL, PL/SQL, UNIX shell scripting (C/Bourne), HTML.

Operating System: Windows NT, Windows 2003/2000, XP, and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

ODI DEVELOPER

Responsibilities:

• 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.1.6 on all the environments and configuring ODI.
• Developed Expressions, filter, joins,Split,Variables,user functions Using ODI
• Use OBIEE 11g (Oracle Business Intelligence Enterprise Edition) to design and develop BI Reports and Dashboards
• 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).
• Involved in data analysis, designing, and development of data warehouse environment.
• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements and Data Analysis.
• Developed several flows and models in ODI.
• Worked on extraction, loading, transformation using ODI from Oracle and FLAT FILES.
• Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances.
• Used ODI Knowledge Modules (Reverse Engineering, Loading, Check, Integration) to create interfaces to cleanse, Load and transform the Data from Sources to Target
• Tuning Large Oracle database 6 TB onExadatasystem using AWR / ADDM / ASH.
• Tuning database instance for Wherehouse batch loads.
• Tune Analyze / Tune SQL statements for COGNOS managed reports running summary on large FACT 500 GB plus and small dimension tables, tuning complex SQL joins of Star Schema, Tune SQL Access paths, Tune SQL for cell offloading, Bloom Filter, smart scan, direct path read.
• Tune Large FACT tables 500 Gb plus and dimension tables.
• Tune Parallel servers in OracleExadataenvironment across 3 RAC instances, Configuring parallel AUTO degree and IO calibration, configuring Intra-node and inter-node parallelism, Configuring DBRM for controlling parallel degree policy, Tuning large Wherescape batch loads for inter and intra node parallelism, Tuning Wherescape FULL / INTER-Day batch load for through put using parallel servers.
• Configuring Database Resource Manager DBRM to control Degree of parallelism (DOP), cancel run away Self Service SQL statements, Session idle time out, Mapping wherescape executable to consumer groups, mapping COGNOS database reporting users to consumer groups, create plans etc.

Environment: Oracle 11g/10g, ODI 11.1.1.6, SQL Developer, OBIEE 10.1.3.x,Informatica 8.6,TOAD 9.0,MS SQL Server 2005/2008.

Confidential, Iowa city, IA

ODI DEVELOPER

Responsibilities:

• Requirements Gathering and Business Analysis. Project coordination, End User meetings
• Development and design of ODI interface flow for Upload / Download files
• 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) feeds using ODI and CDC
• Consolidated data from different systems to load Constellation Planning Data Warehouse using ODI interfaces and procedures
• 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 11g.
• Support in full legacy to ODI data conversion and Integration task
• Translated business requirements into technical specifications to build the Enterprise Data Warehouse
• Involved in system study analysis for logical/physical data model there by 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.
• Installation and Configuration of Oracle Data Integrator (ODI)
• Responsible for creating complex mappings according to business requirements, which can are scheduled through ODI Scheduler.
• Responsible for configuration of Master and Work Repository on Oracle
• 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.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Configure OracleExadataX2-2 / X5-2 machines.
• Configure Oracle database resource manager Creating policy, plans, directives and consumer groups.
• Configure interdatabase and intradatabase resource manager
• Configuring Flash cache logging for OLTP databases usingExadataSystems
• Configuring Flash cache for storing DB segments onExadataFlash cache.
• Configuring +ASM Cell DISKS, GRID Disks, ASM DISK group, Failure group, AU size on Exadatastorage cells.
• ExadataCell offloading for SQL predicate functions
• ExadataCell offloading for RMAN Incremental backup using BACKUP functions.
• AWR/ ADDM / ASH analysis forEXADATAperformance tuning

Environment: ODI 11.1.1.6, SQL Developer, Oracle 11g/10g, OBIEE 10.1.3.x, UNIX scripting, Windows NT

Confidential, Cleveland, OH

ODI DEVELOPER

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements and Data Analysis.
• Developed several flows and models in ODI.
• Worked on extraction, loading, transformation using ODI from Oracle and FLAT FILES.
• Developed specifications (Document) based on the requirements, such as Business Requirement Documents, High Level Document and Low Level Document.
• Worked with Erwin For data modeling, designed and develop Physical models, Logical models
• Used ODI Knowledge Modules (Reverse Engineering, Loading, Check, Integration and Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target.
• Created source definitions for relational and flat file sources and implemented target definitions based on star schema design.
• Created Repositories, Agent, Contexts, Data Server, and both of Physical & Logical Schema in Topology Manager
• Tuned sources, targets, mappings and sessions to improve the performance of data load into Oracle database
• Created several scripts in UNIX for data transformations to load the base tables by applying the business rules based on the given data requirements
• Created UNIX shell scripts for automating the data transformation process and check if standards are met.
• Extensively involved in developing packages in Framework manager with retrieving data from database oracle and publish those packages in to Siebel connections.
• Involved in scheduling and deploying these reports.

Environment: Oracle Data Integrator 10.1.3.5,Oracle 10g/9i, SQL Developer, WINSQL, Windows XP, UNIX Shell Scripting.

Confidential, Memphis, TN

ODI Developer

Responsibilities:

• 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.1.6 on all the environments and configuring ODI.
• Patching ODI 11.1.1.6.0 to 11.1.1.6. and Upgrading ODI from 10.1.3.4 to 11.1.1.6.4.
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule
• Created ODIProcedure, ODI Package, ODI Variables, ODI Scenarios,, ODI Functions, ODI Mappings, ODI LoadPlans
• Created the users, profiles using the ODI security manager.
• Financial Planning Manager and other developers.
• Created Reports, Dashboard Prompts and Dashboard Pages like - Budget and Actual, Balance Sheet.
• As an administrator I was responsible for security across multiple users and groups.
• 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.
• Worked on Oracle Enterprise Manager to activate and Deploy RPD.
• Extensively used Catalog Manager for migrating Web Catalog.
• 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, ODI 10.1.3.4, Oracle EBS, Oracle 11g, SQL*PLUS, SQL Developer, Windows XP.

Confidential, San Antonio, TX

ODI DEVELOPER

Responsibilities:

• Involved in data analysis, designing, and development of data warehouse environment.
• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements and Data Analysis.
• Developed several flows and models in ODI.
• Worked on extraction, loading, transformation using ODI from Oracle and FLAT FILES.
• Developed specifications (Document) based on the requirements, such as Business Requirement Documents, High Level Document and Low Level Document.
• Worked with Erwin For data modeling, designed and develop Physical models, Logical models
• Using Oracle Data Integrator Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances.
• Used ODI Knowledge Modules (Reverse Engineering, Loading, Check, Integration, and Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target.
• Created source definitions for relational and flat file sources and implemented target definitions based on star schema design.
• Created Repositories, Agent, Contexts, Data Server, and both of Physical & Logical Schema in Topology Manager
• Tuned sources, targets, mappings and sessions to improve the performance of data load into Oracle database
• Created several scripts in UNIX for data transformations to load the base tables by applying the business rules based on the given data requirements
• Created UNIX shell scripts for automating the data transformation process and check if standards are met.
• Extensively involved in developing packages in Framework manager with retrieving data from database oracle and publish those packages in to Siebel connections.
• Involved in developing many critical reports like crosstab, chart, Dashboard, Drill Through, Master detailed reports using OBIEE 10.1.3.x
• Involved in scheduling and deploying these reports.

Environment: Oracle Data Integrator 10.1.3.5,Oracle 10g/9i, SQL Developer, WINSQL, OBIEE 10.1.3.x, Windows XP, UNIX Shell Scripting.

Confidential, Bridgewater, NJ

ETL Developer

Responsibilities:

• Involved in data analysis, designing, and development of data warehouse environment.
• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements and Data Analysis.
• Developed several flows and models in ODI.
• Developed specifications (Document) based on the requirements, such as Business Requirement Documents, High Level Document and Low Level Document.
• Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances.
• Used ODI Knowledge Modules to create interfaces to cleanse, Load and transform the Data from Sources to Target.
• Created database connection, physical and logical schema using ODI Topology Manager in order to achieve the whole infrastructure. Imported tables from database, developed projects, released scenarios using ODI Designer
• Used suitable ODI Knowledge modules to achieve requirements. Extracted data from specific technology, transforming the data, checking it, integrating it, etc. Created Custom Knowledge Modules.
• Monitored sessions for executions using ODI Operator. Managed user privileges using ODI Security Manager.

Environment: ODI 10.1.3.5, Oracle 10g, SAP ERP 6.0, MS Visio, TOAD 9.0, PL/SQL, UNIX, MS SQL Server 2005/2008.

Confidential

Siebel Analytics Developer

Responsibilities:

• Monitoring use of the system, troubleshooting problems, conducting
• Developed PL/SQL stored procedures, user defined functions for complex rating calculations and bundle them into stored package that could be invoked from the Forms triggers
• Developed various UNIX Shell Scripts to automate the routine tasks
• Designed interface for the system.
• Created PL/SQL scripts for data transformation in line with program specifications.
• Creating temporary tables and indexes for loading and updating data.
• Designed and Developed Stored Procedures, Packages and Functions using PL/SQL and SQL Scripts.
• Used SQL*Loader to load data using direct and indirect path.
• Developed database Procedures to handle Partition Deletion and Truncation automatically based on data loading criteria using Dynamic SQL.
• Developed shell scripts for database replication processes.
• Table layout design, table space management and user maintenance.

Environment: Oracle 7x, SQL, PL/SQL, SQL* Plus, TOAD, UNIX