OBJECTIVE:

Seeking a position as a Technical Developer/Analyst in a company where I can use my technical as well as domain skills from my 7 plus years of IT experience for organizational and individual development. Aspiring to be suitably placed in an esteemed organization where I can effectively contribute my skills and be a valuable addition to the organization.

EXPERIENCE SUMMARY:

• Self - motivated technology analyst around 7 years of experience in the Software Development Industry.
• Experience in Information Technology in designing, developing and implementation of Business Intelligence, Data warehouse applications under different environments.
• 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.
• Involved in Functional requirements gathering for implementing Different modules.
• Skillful with Requirement Analysis and FIT GAP analysis
• Expertise in configuring the ODI Master and Work repositories, ODI models, and ODI Change Data Capture (CDC) mechanism.
• Involved in full life-cycle development from business requirements, project planning, conceptual design, capacity planning, technical architecture, system implementation, maintenance & supporting OBIA implementations.
• Imported data from various Sources transformed and loaded into Data Warehouse Targets using ODI
• Expertise in Working with ODI Designer, Topology Manager, Operator, Security Manager.
• Experienced in defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions and knowledge modules.
• Proficient with 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.
• Experienced in customizing Knowledge Modules.
• Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL to improve query
• Develop, Tune SQL’s on larger volumes of databases/tables.
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Extensive experience in writing complex SQL Queries and PL/SQL, T-SQL scripts
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, Relational Database Models and Data Integrity in observing Business Rules
• Scheduled ETL jobs for 24*7 through ODI-Agents, successfully implemented Load Balancing Concept on the production servers
• Excellent support to QA team to help them understand the requirements in order to ensure all the deliverables were tested thoroughly.

TECHNICAL SKILLS AND EXPERTISE:

Programming Languages: SQL, PL/SQL,XML

Operating Systems: Windows XP, Windows 7, Windows 8, Linux/UNIX

Database: Oracle 12c/11g/10g, SQL Server 2000/2005

ETL Tools: ODI (Oracle Data Integrator) 12c, 11x,10x, OWB 10x

Reporting Tools: OBIEE 10.x/11g

DB Tools: TOAD, SQL Developer, DbVisualizer

Other Tools: MS Office, Microsoft Project

PROFESSIONAL EXPERIENCE:

Confidential, Webster, NY

ODI Developer

Responsibilities:

• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Extract, Transform and loaded data to ERD database.
• Created and maintained project tasks and schedules.
• Provided programming estimates, identified potential problems and recommended alternative solutions.
• Worked in close cooperation with project managers and other functional team members to form a team effort in development.
• Collaborated with other members of the product development team.
• Defined ETL architecture for integrating data at real time and batch processing to populate the Warehouse and implemented it.
• Responsible for creating complex mappings according to business requirements, which can are scheduled through ODI Scheduler.
• Develop packages for the ODI objects and scheduled scenarios using them.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Serialized and paralleled existing Load plans to perform better on their dependencies.
• Coordinated configuration of back-end components in support of application development.
• Worked on Adeptia to develop web forms and run different workflows.
• Involved in Prod and Non - Prod support to resolve issues.

Environment: ODI 11g, OBIEE11g/12c, Golden Gate, SQL Developer, TOAD, Oracle 11g, Windows, Red Hat Linux.

Confidential, Charlotte, NC

ODI Developer

Responsibilities:

• 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.
• Optimized the knowledge modules to improve ETL and query performance in OBIA
• Responsible for designing, developing, and testing of the ETL strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI.
• Imported ODI and OBIEE metadata to implement OBIA for Non Oracle Data source
• Consolidated data from different systems to load Constellation Planning Data Warehouse using ODI interfaces and procedures.
• Develop packages for the ODI objects and scheduled scenarios using them.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Worked on analysis, Design and Development of RPD and Dashboard /Reports.
• Customized OBIA ETL mappings and table extensions to design the Star Schema and populate the Data warehouse based on business requirements.
• Worked with BI Architect on the design of logical and physical data models using Star Schema and dimensional data modeling.
• Tracing the sql query for better performance and part of performance tuning Activity.
• Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.

Environment: ODI 11g/12c, OBIEE 11g/ 11.1.1.9.0 , OBIA 11.1.1.8.1 , SQL Developer, DB2, Oracle 11g/10g, Windows.

Confidential, Hartford, CT

ODI Developer

Responsibilities:

• Requirements Gathering and Business Analysis. Project coordination, customer meetings.
• Development and design of ODI interface flow for Upload / Download files.
• Installation and Configuration of Oracle Data Integrator (ODI). Responsible for configuration of Master and Work Repositories on Oracle.
• Responsible for designing, developing, and testing of the ETL strategy to populate the data from various source systems (Flat files, Oracle, DB2) feeds using ODI and Change Data Capture (CDC).
• 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.
• Knowledge in performing the customizations to the ODI Knowledge Modules as part of tuning the Knowledge Module Code based on the requirements.
• Defined ETL architecture for integrating data at real time and batch processing to populate the Warehouse and implemented it using OBIEE 11g.
• 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.
• Responsible for creating complex mappings according to business requirements, which can are scheduled through ODI Scheduler.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Good working knowledge with ODI Operator for debugging and viewing the execution details of interfaces and packages.

Environment: ODI(Oracle Data Integrator) 11g (11.1.1.6/10.1.3.5 ), OBIEE 10g, SQL Developer, DB2, T-SQL, DTS, Oracle 11g/10g, UNIX scripting, Windows NT.

Confidential, Bridgewater, NJ

ETL Developer

Responsibilities:

• Supporting/ Enhancing / optimizing current SOON processes involving Policy and Claims data mart.
• Upgrading from current Single user/Single repository/multiple configuration OWB environment to Industry’s best practice Multi user/Multiple repository environment.
• Planning and Designing upgrade plan from OWB 10.2 to 11.2.
• Designed and implemented Constraints project in Policy data mart using Erwin, Also worked on fine tuning the ETL load and user reports.
• Gathered requirements from business and created functional specifications.
• Designed and created logical/physical data modelsbased on business requirements.
• Studied current state and designed future state in OWB and derived ETL strategy.
• Developed Mappings to populate data marts using OWB.
• Used debugger to evaluate ETL timings and optimized SQL’s in mappings to run faster.
• Created Process flow modules to define mapping sequence.
• Optimized mappings by using Aggregator, filter, Joiner, Expression, Lookups.
• Involved in Unit Testing, Integration Testing, and System Testing.
• Created UNIX shell scripts to automate batch jobs through cron.
• Developed test cases for each and every module developed and documented all the production support issue solutions to a repository.
• Interacted with the interfacing teams as a part of issue analysis and new enhancements received in order to get a clear idea of the requirements.
• Provided proactive solutions to the client with respect to the existing issues in the application and suggested optimal solutions for them.
• Gained good domain knowledge on Healthcare process.

Environment: OWB 10.2, PLSQL, SQL Developer, Oracle 11g/10g, Windows, Linux

Confidential

SQL Developer

Responsibilities:

• Created Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections
• Developed the ETL process using SQL*Loader, PL/SQL Package UTL File
• Ran batch jobs for loading database tables from Flat Files using SQL*Loader
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling
• Participated in Performance Tuning using Explain Plan
• Created number of Database Triggers using PL/SQL
• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL
• Performed Unit test, Integration Test and wrote the test plan, also provided technical documentation
• Created database objects like Tables, Views, Materialized Views, Procedures and Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables
• Excellent .net code debugging capabilities used for root cause analysis
• Developed interface scripts for data uploading and downloading from upstream and downstream systems.
• Handled production support with excellent efficiency by resolving the support issues on time within the SLA and suggested the best optimized solutions.
• Improved the performance of interface jobs as well as the application performance by enhancing the performance of database objects and reducing the cost of database calls on each page call.
• Implemented materialized views in the application to enhance the performance of data loading jobs.
• Excellent hands on experience working with Unix and oracle in developing the interface scripts.
• Provided excellent work environment to the clients by communicating proactively with the clients on the issues raised and by involving in the business requirements phase as well.

Environment: PLSQL, SQL Developer, Oracle 11g/10g, Windows, Linux