SUMMARY:

• Over 9 years of IT experience and strong background in Data Modeling, ELT Design, Analysis, Development, Testing, Performance Tuning, Implementation, Troubleshooting and error handling in the field of Data Warehousing in ELT process using ODI and Well experienced in all phases of System Development Life Cycle (SDLC).
• 5+ years of experience on ODI (Oracle Data Integrator).
• Expert in design, development and implementation of ELT code.
• Worked extensively with complex interfaces using ODI.
• Expertise in implementing complex business rules by creating ODI interfaces.
• Extensively used Integration Knowledge modules (IKM) to efficiently transformed data from staging area to the target tables by generating the optimized native SQL
• Designed and developed complex Interfaces using oracle data integrator (ODI)that involved Slowly Changing Dimensions, Error handling, SCD types, CDC and Business logic implementation.
• Created ODI (Data Integration) design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Experience in Installation and upgradation of ODI.
• Proficient in Oracle Data Integrator - ODI, Quest TOAD, SQL*PLUS, PL/SQL.
• Developed database objects like functions, Store Procedures, triggers and packages using PL/SQL.
• Expertise in dynamic SQL, collections, exception handling, database design.
• Experience 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 modeling. Extensive experience with Fact, dimensional tables, slowly changing dimensions, Physical and Logical Data Modeling.
• Experience in Performing various DML, DDL etc operations on Netezza database by using Netezza work bench.
• Knowledge on Golden Gate and web meathods.
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Ability to produce clear documented and commented code.
• Experience on working with Financial teams
• Excellent analytical and interpersonal skills and strong ability to perform as a team.

TECHNICAL SKILLS:

Tools: Oracle Data Integrator(11g,12c), Informatica, Datastage, Alteryx, PL/SQL.

Operating System: Windows, Linux, SCO Unix

Data bases/APPS: Oracle, Netezza, SQL Server, Essbase

DB Tools: TOAD, SQL Developer, Aginity

Reporting Tools: OBIEE 10.x/11g, Power Bi, Hyperion

Other Tools: Winscp, FileZillas, Putty, TFS 2013

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. ETL/ODI Developer

Responsibilities:

• Perform changes om ODI flows configuration and PL/SQL components to resolve incidents.
• Perform ODI servers recycle & trouble shoot any issues on server cluster instances and flows deployments.
• Identify and eliminate recurring issues on ODI flows configuration and batch jobs optimization on ODI Ent & ODI BI Apps.
• Monitor tickets, critical jobs, alerts and interfaces for issue similarities on ODI platform and data flows.
• Housekeeping activities of ODI platform, ODS and data flows.
• Co-ordinate with the client infrastructure & vendor team for OS, network and hardware level patches.
• Installation of certificates & ODI product patches, co-ordinate firewall rules open.
• Monitoring of implemented ODI flows and rerouting tickets as needed.
• Work with Oracle support team on ODI product issues, patches.
• Automated alerts creation, server metrics collection and reporting on ODI platform components using OEM.
• Perform ODI flows enhancements deployment & verification.
• Modifying load plans run, debug and batch jobs in ODI Enterprise and Bi Apps.
• Performing maintenance on OBIEE backend tables and views.

Confidential, Rochester, NY

ODI Developer

Responsibilities:

• Participated in gathering requirements, analysis, design, modeling, development, testing and implementation needed for loading and updating the warehouse.
• This project involved extraction of data from multiple sources and transform the data as per the business logic and is loaded into the Netezza data warehouse which is finally used for reporting.
• Used Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Created ODI objects like Mappings, Packages, Variables, procedures and sequences as per the requirements.
• Worked with setting up topology connections like File to Netezza, Oracle to Netezza and Oracle to Oracle on multiple environments.
• Implemented SCD type-2 process as per the updated KM and automated to run weekly loads.
• Automated flat file process of different formats to run weekly loads.
• Used ODI scheduler for scheduling jobs in development and used Tidal to schedule jobs in production.
• Created ODI load plans from scenarios to run series and parallel steps of various complexities.
• Worked with widely modified Knowledge modules both LKM and IKM and build ODI mappings accordingly.
• Tracing the source data for OBIEE reports by going through back end SQL and built appropriate processes using ODI.
• Involved in migration project from IBM Datastage to ODI 12c.
• Maintains Netezza database like creating views from external databases by using synonyms, granting permissions to marketing users as per their need and requirements and creating other database objects.
• Building SQL manually and documenting it to get approved from the appropriate teams before building ETL code.
• Documenting updated or newly build codes. Pushing and pulling codes to Source tree (Bit Bucket).
• Figuring out environment differences between Oracle and Netezza to avoid bottle necks and long time running jobs.
• Migrated ODI objects to various environments by using Smart imports and exports.
• Performed various DML, DDL operations on Netezza database by using Aginity Netezza work bench.
• Wrote several Netezza SQL scripts to load the data between Netezza tables.
• Used NZSQL/NZLOAD utilities to load data from flat files to Netezza database
• Improved the performance of batch with optimizing and tuning the Netezza SQLs to Redesigning ODI mapping to handle multiple updates and deletes.
• Performed Unit Testing, User Acceptance testing to verify whether the data was loaded into target is accurate to meet the user requirements.
• Participating in User Meetings, gathering requirements and translating user inputs into technical specification documents.
• Worked with Alteryx as this tool is used by end users. Performed installations, setting up connections and job monitoring.
• Involved building reports using Alteryx.
• Applying key distribution based on the tables relations as well as based on query.
• Extensive querying using TOAD to monitor quality and integrity of data.
• Developed complex SQL queries to perform the back-end testing of the Oracle database using SQL commands.
• Worked with Agile team.
• Performed end to end life cycle of the project.

Environments: ODI 12.2.1, Toad 12.10, Aginity Workbench 4.1.1, Oracle 12c, Netezza.

Confidential, Victor, NY

ODI Developer

Responsibilities:

• Gather requirements and create detailed documentation of business systems and user needs, including workflow, program functions, and steps required to develop or modify systems. Uncover and resolve ambiguous and invalid requirements.
• Design, build, and support integrations using Oracle Data Integrator (ODI) to implement data and master data flows across multiple systems and technologies.
• Load metadata and data into Essbase and planning applications using ODI Packages.
• Automate and Execute Hyperion Business rules through ODI
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Designed ODI interfaces, packages, procedures from the existing database objects.
• Created Views, wrote functions, Procedures, Packages in PL/SQL for ODI process.
• Unit tested ODI mappings and procedures and documented all test cases.
• Automate and Execute Hyperion Business rules through ODI
• Load data into HFM (Hyperion Financial Management) using OIA through ODI interfaces.
• Extract Hyperion Plan data to SQL using ODI Packages
• Migrated Code from Development to Testing to production.
• Created tables and views in Netezza and reverse engineered them into ODI.
• Monitoring the ETL jobs and troubleshooting the errors using the operator logs
• Depending on the requirements created and modified SQL and PL/SQL database objects like tables, indexes, views, stored procedures, functions, packages, Triggers, Materialized views, analytical functions to make new enhancements or resolve problems.
• Worked with the procedure that automates table partition processes.
• Used Yellow Interfaces for developing most complex interfaces in processes when code is developed from views.
• Updated knowledge modules as per Business requirement.
• Worked with multiple sources such as Relational database, Flat files for Extraction Transforming and Loading data into target tables and Hyperion cubes.
• Created reports Using Hyperion Financial Reporting, Smart View and Excel Add-ins.
• Develop and maintains Hyperion Planning forms, business rules, and security and in performing Hyperion Planning Administration tasks.
• Experience with optimizing business rules and calc scripts.
• Automated ODI jobs using TIDAL.
• Worked with Agile team. Used Rally to track the status of the assigned tasks.

Environment: ODI 11.1.1.7.0 , SQL developer, TIDAL, Oracle EPM 11.1.2.4

Confidential, Ada, Michigan

ODI Developer

Responsibilities:

• Understanding Business Requirements and design the implementation model for data load.
• Strong SQL and data analysis capabilities.
• Experience with dimensional data modeling, logical and physical design if data warehouse structures within an Oracle environment.
• Hands-on experience with ETL toolsets (ODI, PL/SQL).
• Implemented a process to replace Change Data Capture (CDC) in ODI which increases efficiency of the job.
• Expertise using Topology, Knowledge Modules, Change Data Capture, Metadata, Web Services.
• Created complex mappings with business logic to extract data from SQL Server.
• Experience in performance tuning, partitioning strategies.
• Developed PL/SQL stored procedures, functions, packages, views, materialized views, triggers using PL/SQL Developer.
• Defined Views and materialized views for simplifying reporting queries and to improve performance. Performed Query optimization and PL/SQL tuning to maximize performance
• Experience designing, building, and supporting data integrations with BI Technology and BI Applications.
• Solid understanding of Oracle database management such materialized view, explain plan etc.
• Involved in Gap Analysis, Requirement Gathering, Functional/Technical Specifications, Development, Deployment and Testing.
• Implemented error logging logic to capture the rejected/wrong data in the mapping for further analysis.
• Created packages and its scenario to automate loading jobs.
• Created ODI Interfaces to load data into dimension and fact tables for traffic and billing data mart.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Created ODI Package of various complexity and automated process data flow.
• Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.
• Implemented procedures in ODI to execute pre-and post-process commands such as disable and enable Indexes.
• Export/Import interfaces, packages and it's scenarios across different environments.
• Used IKM, LKM, JKM & CKM knowledge modules to create ODI Jobs for data loading.
• Performed source to Staging and staging to target mapping specifications and developed ETL / ELT ODI code for the same.
• Created ODI Interfaces with simple to complex transformation rules while migrating from Source to the target.
• Improved Analytics Response-time by Performance management using optimization efforts such as implementing the aggregate tables and reports change.

Environment: ODI 11g (11.1.1.7), Toad 12.5, SQL developer, PL/SQL, Power Bi

Confidential, Libertyville, IL

ODI Developer

Responsibilities:

• Gathered business requirement and prepared mapping specs.
• Configured physical and logical topology.
• Reverse engineered source and target models.
• Worked on LKM (File to sql, sql to sql), IKM (Oracle global insert, Oracle incremental update), CKM (CKM oracle), RKM (Standard)
• Worked in a project that is migrating from Big data to ODI.
• Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files (.txt, .csv, .xlxs) into oracle database.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Created reusable mappings to implement in main mappings.
• Created complex mappings with business logic to extract data from SQL Server.
• Understanding the current complex system and developing Oracle SQL and PL/SQL scripts to populate BI tables used for JDA Reporting.
• Created ODI packages and procedure to execute on fly.
• Wrote SQL,T-SQL, PL/SQL, SQL*Plus programs required to retrieve data using Cursors and Exception handling.
• Used global and project variables (declare, evaluate, refresh).
• Created scenarios with multiple variables input/default values.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Created complex mapping with multiple source columns data to 1 target column.
• Import/Export development code to test and production environment.
• Versioned all ODI objects, unit test documents, and scripts to TFS.
• Created alerts process to send email notification via OdiSendMail.
• Unit tested ODI mappings and procedures and documented all unit test cases.
• Worked with OWB for relational, dimensional and metadata modeling. Built ETL solutions using OWB for various automated data migration processing.

Environment: ODI 12.1.3, PL/SQL, OBIEE, Microsoft SQL Server Management Studio, SQL Developer 4.0, SharePoint 2010, UNIX, Putty

Confidential, Dallas, Tx

ODI Developer

Responsibilities:

• Understanding the Functionality of GPC's Application and Business requirements.
• Interacting with client for appropriate requirement specifications.
• Did extensive data analysis using source data and UI to understand the data, to assist data modeler in designing the databases, to identify bad data, to help Business in improving and redefining the requirements.
• Identifying source data that concerns specifying business rules to transform source information into key indicators.
• Modeling the data structure of the target warehouse to store the required information.
• Populating the indicators by implementing business rules
• Measuring the overall accuracy of the data by setting up data quality rules
• Designed, developed ODI (Oracle Data Integrator) (Data Integration) objects for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
• Developed PL/SQL packages for Customer tracking, summary of sales order, Shipment and invoice, Sales Order information by customer, order etc.
• Extensively used Integration Knowledge modules (IKM) to efficiently transformed data from staging area to the target tables by generating the optimized native SQL
• Designed and Created the Process flows, ER-Diagrams, High Level architecture diagrams.
• Designed and developed complex Interfaces using oracle data integrator (ODI)that involved Slowly Changing Dimensions, Error handling, SCD types, CDC and Business logic implementation.
• Created ODI (Data Integration) design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Wrote unit test cases, test scenarios, unit test documents and verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Helped QA team in writing the appropriate test scenarios.
• Using ODI (Data Integration), 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.
• Designed, developed and modified materialized Views, Tables, Packages, and Functions and Stored Procedures.

Environment: ODI 11g, Oracle 11g, Microsoft SQL Server Management Studio, SQL Developer 4.0, SharePoint 2010, UNIX, PL/SQL, SQL, SQL Loader, Toad, ETL, Erwin 7.x, Flat files, Oracle 11g/10g, MS SQL Server 2010.

Confidential

Informatica Developer (Internship)

Responsibilities:

• Extensively used various Data Cleansing and Data Conversion Functions in various transformations.
• Designed Mappings using B2B Data Transformation Studio.
• Involved in Dimension modeling of Data warehouse designed the business process, grain, dimensions and measured facts.
• Created necessary repositories using repository manager to handle the metadata in the ETL process.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, duplicate elimination and exception handling and monitoring capabilities of IDQ.
• Used IDE to identify data duplication, understand the quality of data and report generation.
• Experience on ETL Informatica 9.x/8.x (Power Center), IDQ, B2B DX/DT v 8.0.
• Migrated the code into QA (testing) and supported QA team and UAT (User).
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Implemented data warehousing techniques for Data cleansing, Slowly Changing Dimension Phenomenon's (SCD) and Change Data Capture (CDC)
• Developed SSIS packages to extract data from different sources like OLTP databases, Excel files, Flat files, from FTP servers about Time Warner's usage data.
• Applied various SSIS transformations like look-up, conditional-split, derived column data conversion extensively.
• Responsible to collaborate with DBA and Data Architects on implementation of database changes.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Worked on database links, SQL joins loops, aliases, views, aggregate conditions and wrote various stored procedures, Functions and Triggers for processing business logic in the database.
• Assisted in design and maintenance of Metadata environment.
• Extensively worked with multi-dimensional expression data.
• Involved in scheduling the Informatica jobs and UNIX scripts and Oracle procedures.
• Resolving if any issues in transformations and mappings during the development.
• Interacted with end users, regularly to generate the reports required.
• Designed and created an Autosys job plan to schedule our processes.
• Created Partitions through the session wizard in the Workflow Manager to increase the performance.

Environment: Informatica Power Center 8, UNIX, SQL Server, OBIEE