OBJECTIVE

Drive designing, developing and maintaining large business applications such as data migration, integration, conversion, data warehouse and Testing for a midsize to fortune 500 companies. Deliver scalable and expandable applications, leveraging industry expertise in Design, Data Modeling, Development, Implementations and Testing of Data warehousing and Database business systems for Retail, Health Care, Pharmaceutical, Insurance, Financial Industries.

PROFESSIONAL SUMMARY

More than Five Plus 5 Years of Data warehousing ETL experience implementing Data Warehousing Applications including Analysis, Architecture, Design, Development, Support using Oracle Data Integrator 11g/10.1.3.4/10.1.3.3/Sunopsis, ETL, Datamart, OLAP, OLTP, Hyperion, BMC Control M, IBM Maestro. Data Cleansing experience with ODQ .

Confidential

• Extensively worked on Oracle Data Integrator ODI Topology manager, Designer, Knowledge Modules, Operator and trouble shooting of the packages.
• Expertise includes analysis, design, and development, testing of data warehousing application using Oracle Data Integrator ODI Topology Manager, Security Manager, Designer, Knowledge Modules and Operator .
• Implementation of Oracle Data Integrator / Sunopsis at RCCL, BMS, BCBSFL. Customizing ODI Knowledge Modules as per client needs.
• Configuring of ODI Information Systems and migrating data from Oracle, DB2, SQL Server, JMS XML Queues and files into ODS and Data Warehouse. Standardize address using Oracle Data Quality Trillium .
• Assist in establishing ODI ETL standards and Change Management procedures.
• Expertise in developing Strategies for Extraction, Transformation and Loading mechanisms using ODI. Five Plus 5 Years of Data Modeling experience using Erwin, Power Designer, Visio, Oracle Designer.
• In-depth experience in Star / Snow Flake Schema, Conceptual, Logical and Physical Modeling.
• Five Plus 5 Years of Business Intelligence experience using OBIEE, Business Objects XI/6.5/6.0/5.1/5.0, OBIEE, Cognos Series 7.0/6.0, QlikView 9.0/8.0/7.0, MS Excel, MS Access Reports.
• Five Plus 5 Years of extensive Database experience using Oracle 11g/10g/9i/8i/, MS SQL Server 2008/2000/7.0/6.5, Teradata V2R6/V2R5, DB2 8.0/7.0/6.0, MS Access7.0/2000, SQL, PL/SQL, SQL Plus, SQL Loader and Developer 2000. Hands on Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Packages.
• Worked with Oracle, SQL Server DB2 UDB Stored Procedures, Table Partitions, triggers, SQL queries, PL/SQL packages, IBM SQL Procedural Language and loading data into Data Warehouse/Data Marts using Informatica, DB2 Load, Import Utilities, SQL Loader. Worked with Teradata Procedures.

CAREER EXPERIENCE

Confidential

Lead ODI - ETL Developer

Achievements:

• Reviewed functional and non-functional system requirements and constructed a conceptual design and detailed designs that align processes and technologies to achieve business objectives.
• Worked with Cognos to generate report and these reports were sent through web-browsers to the client. Responsible for performance tuning of ETL jobs.
• Extensively used ODI for ETL purposes.
• Assisted in preparing the SOA Designed document with Data Preparation, Data Procession and Data Completion Stage for end-to-end ODI OBIEE process.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Created ODI Interfaces under Projects to populate the target.
• Created Filter on the source with the execution location on source.
• Created ODI Interfaces using ODI Knowledge modules Reverse Engineering, Journalizing, Loading, Check, Integration, Service
• Worked on Loading and Integration KM in Flow tab in ODI Interfaces.
• Worked on the heterogeneous source by applying joins with execution location as Target.
• Worked on Insert and Update of the Target by associating the Update Key on the Target.
• Created ODI Datastores in the Model to store the metadata Reverse Engineered from Sources.
• Imported XML files with hierarchies are maintained under Hierarchy.
• Corrected the erroneous records of target by checking control and errors.
• Worked on ODI Topology, created Data Server, Physical Schema Data and Work under data server, Logical Schema as alias for Physical Schema.
• Performance tuning of databases and ODI Interfaces.
• Created Context DEV, UAT and PROD to attach more than Physical Schemas to Logical Schema. Implemented CDC through ODI Journalization Knowledge Modules KMs .
• Created Procedure to delete the staging tables, Variables Last Value and used it in the ODI Package. Created ODI Scenario from Packages as the changes in packages and procedure are not reflected in it Created Profiles, User through ODI Security Manager Interface
• Implemented SCDs using ODI.
• Worked with the PL/SQL, SQL Loader, Toad to check for the quality of data as per the business needs
• Worked extensively with Oracle SQL and PL/SQL Coding.
• Responsible for adding patches to Bsara such as hotfixes.
• Assisted in importing clients database as Dummy DB in to BMC to diagnose and fix problems caused by hotfixes of BMC.
• Created scripts to run on clients Database to diagnose problems and imported the results in form of .csv files and fixed the bugs.
• Current client experience: Lead developer for the project which lead to development of QuickView DW for extracting data from various EMRs, financial systems, billing systems, and integrates it into a single Longitudinal Nationwide Data Warehouse that feeds these applications.

Confidential

ETL Developer /ODI SUNOPSIS DEVELOPER

Responsibilities:

• Coordinating with the functional team to understand the Budgeting and Forecasting process of the Health Ministry. Created Web Forms and Smart View templates for the users to load their budget and forecast information into Planning.
• Created Substitution Variables, Business Rules, Calculation Scripts, Report Scripts and Load rules in Essbase. Involved in installation, configuration and security setup for Oracle Data integrator 10.1.3.6 on Windows 2003 Platform across all the environments.
• Coordinating with Oracle DBAs in creating master and work repositories for Oracle data integrator ODI . Reverse Engineering the Hyperion Planning App using RKM Hyperion Planning in Oracle Data Integrator ODI to create Target Data stores for loading metadata into Planning.
• Creating Metadata Load files for Account, Entity and various other dimensions using the Columns present in the Data stores.
• Configuring a File store, to host all the load files used by ODI.
• Created the data stores necessary for data load into Essbase Cubes using RKM Hyperion Essbase in Oracle Data Integrator ODI .
• Creating the Load rules necessary for the data load in Essbase. These Load rules will be leveraged by the ODI for data load.
• Finally creating the Interfaces necessary for Metadata load and Data load in ODI and also creating necessary transformations required for the Data load.
• Loading Actuals and Budget data for GL Stat accounts into appropriate Essbase cubes using Oracle Data Integrator ODI interfaces.
• Exporting Budget data from Essbase to PeopleSoft using ODI and Report Scripts.
• Automating the Metadata load, Data load and Exports by creating Packages, Scenarios and finally scheduling Scenarios using scheduler within ODI.
• Creating, provisioning, and maintaining user security across all Hyperion modules using Hyperion Shared Services. Creating dimension security in planning based on the user requirements and refreshing the database and security filters frequently to accommodate these changes in Essbase cubes.
• Creating Income Statement, Balance Sheet Report, Cash Flow and several other financial reports using financial reporting studio.
• Managing the Database connections and security for the reports in Workspace.
• Training users in Smart View, Hyperion Workspace, and Financial Reporting Studio.
• Coordinating with Oracle On Demand OOD team during Migration of planning applications across different environments.
• Performance tuning Cube Optimization of the Essbase cubes for the faster data load, better calculation time and for faster retrieval of the reports using the Dense/Sparse settings and Cache settings.
• Created Maxl scripts batch scripts for process automation.
• Created Technical Documentation and provided support for testing knowledge transfer activities..

Confidential

Lead ETL - ODI Consultant

Responsibilities:

• Identified customer requirements, wrote functional designs, reviewed technical designs, developed test schedules and reviewed testing plans, documented development and results of these plans.
• Gathered requirements and design of Data warehouse and Data mart entities.
• Developed various ODI interfaces to load data from Flat file Relational Sources to Oracle DataMart.
• Topology Manager is used to create database connection, physical and logical schema in order to achieve the whole infrastructure.
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Customized Knowledge modules LKM, RKM, IKM and JKM.
• Implement 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, etc.
• Used Range, List, Hash and Range-List partitioning method.
• Created Bitmap Index as well implemented different Optimizer Hints for tunings.
• Used ODI Operator to monitor sessions.
• Security Manager is used to manage user privileges.
• Developing of complex Interfaces and packages using ODI tool.
• Analysis and designing of Interfaces pipelines in ODI.
• Used Topology Manager to schedule scenario-using Agent.
• Worked extensively on Physical Layer, Business Layer and Presentation Layer .RPD to get new column as per BU.
• Creating or Modifying Answers and Dashboards as per user requirement.
• Created Views, wrote functions, Procedures, Packages in PL/SQL.
• Testing data and comparing data with prototype data mart
• Developed OBIEE repository by creating Physical, Business and Mapping and Presentation layers using OBIEE 10.1.3.2 Administration tool.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards.
• Created Views, functions, Procedures and Packages in PL/SQL.
• Used Oracle Metalink support for product issue.
• Performing Test cases and various test scenarios to validated seeded OBIEE reports.

Environment: Oracle Data Integrator 10.1.3.4, OBIEE 10.1.3, Answers and Dashboards, OBIEE Administrator, Oracle 10g, iBods, Visio, Essbase 9.3.1

Sr. ODI Developer

Confidential

• Customized Email distributions to get the error messages and out put from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements.
• Using ODI, Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances. Built transformations, configured servers and established connections to various sources and targets
• Migrated and Converted the flat source files from multiple sources to ORACLE 9i.
• Involved in design, development of ODI formerly known as Sunopsis for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
• Created, modified, and administered analytics Intelligence Dashboards with links to web sites HTML text links to documents and embedded content, such as images, text, charts, and tables.
• Worked on Oracle Applications 12.1.2 project from Order to Cash involving mainly in Finance modules.
• Involved in creating and solving Defects and working with Oracle Corp on Oracle SR's for Oracle Apps 12.1.2 AR module.
• Actively involved in validating Finance modules AR, AP, GL user scenarios and upgrading from 12.0.4 to 12.1.2 Oracle Apps Instances.
• Designed and developed the Siebel Analytics Metadata Repository .rpd using Siebel Analytics Server Admin tool by importing the required objects Dimensions, Facts Aggregates with Referential Integrity constraints into
• Physical Layer using connection pool, developing multiple dimensions Drill-down Hierarchies Logical Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Siebel Security Setup groups, access privileges , Metadata objects and Web Catalog objects Dashboard, Pages, Folders, Reports .
• Developed many Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters using Siebel Analytics Web. Suppliers are to be defined at instance level and Sites addresses are at Affiliate level.

Environment: Sunopsis/ODI, OBIEE, GDW, Oracle Applications 11.0.4,12.1.2, SQL Server, Toad, Erwin 7.2sc