SUMMARY

• 8+ years of hands - on Oracle Data Integrator (ODI) and Data Warehousing experience with 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.
• Expertise in converting business requirements into functional & technical specifications.
• Also experienced in project scoping, storage size estimation, creating service level agreements and designing Decision Support Systems for tactical and strategic decision-making.
• Hands on experience on dealing with ODI Knowledge Modules like, RKM, LKM, IKM, CKM, and JKM.
• Experience in debugging Interfaces. Identified bugs in existing Interfaces.
• Experience in analyzing, requirement gathering, documenting and editing Business/User Requirements. Also worked in distinct Business segments/units, Process units, Review processes etc.
• Hands-on experience in designing, tuning, and leveraging large data warehouses using RDBMS databases applications.
• Excellent overall software development life cycle (SDLC) experience, conceptual and logical thinking, Goal oriented, self-motivated and able to work independently and as a member of a team.
• Implemented performance-tuning techniques at application, database and system levels.
• Excellent problem solving skills with a strong technical background and good communication skills.
• Ability to work in teams as well as individually, quick learner, able to meet deadlines, and exceed expectations.

TECHNICAL SKILLS

ETL Tools: ODI 11g/10g

Databases: MS ACCESS, Oracle 11g/10g/9i,SQL Server 2000/2005

Reporting Tools: OBIEE 10.1.3

Programming Languages: SQL, PL/SQL, UNIX shell scripting

Oracle Tools: SQL*PLUS, SQL Developer

Operating Systems: UNIX, Windows 98/NT/XP/2000

PROFESSIONAL EXPERIENCE

Confidential, New York

ODI Developer

Responsibilities:

• Create complex interfaces and procedures according to business requirements to work with packages for the ODI objects and scheduled them as scenarios.
• Create specifications doc for creating interfaces for record keeping.
• Use customized knowledge module that was using for previous ODI projects.
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Migrate existing SQL into Oracle Data Integrator (ODI)
• Used Loading, Integration, and Check knowledge module extensively while creating interfaces to Load Data from Sources to Target database.
• Experience with high volume datasets from various sources like Oracle, Text Files, and Relational Tables.
• Generated scenarios and used in package, also set Synchronous/Asynchronous if needed.
• Export and import the Projects and data-store from Dev to TEST environment. Also imported the scenarios in Production execution repository using operator.
• Customize Email distributions to get the error messages and output from PKG run. Modified Knowledge modules to customize it to ETL requirements.
• Convert Existing Incremental process, which uses Shell scripts, SQL scripts and PL/SQL procedure to ODI Incremental (Daily, Week & Monthly Load) process of various complexities and process.
• Optimize Email notification system to automatically notify the User about the Step in which the ODI Jobs fails.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.

Environment: ODI 10.1.3.5, Oracle 10g, SQL Server, WinSQL 9.0, Visio, Windows, Linux

Confidential

ODI Developer

Responsibilities:

• Worked with Business analyst, Management Professionals for gathering requirements and Business Analysis.
• Extensively worked on Physical, Business and Presentation Layer for developing repository.
• Used ODI for Reverse Engineering to retrieve metadata from data storage and load it to the repository
• Worked on Topology and defined Schemas and Data Servers in Physical and Logical Architecture.
• Implemented Constraints Keys, Reference Keys, Mandatory Columns, Conditions, Complex Reference to Attain Data Integrity.
• Implemented Slowly Changing Dimensions to keep track of changes on Specific Columns.
• Created and worked with different Packages, Procedures, Variables, Sequences and User Functions
• Loaded and configured various Knowledge Modules such as Loading, Integration, Check, Reverse Engineering, Journalizing, and Data Server
• Used financial analytics in EBS R12 forfinancial reporting using a single tax, banking and payment model
• Strong experience with UNIX Shell Scripting, SQL, PL/SQL Coding
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Analysis by implementing Aggregate navigation, cache management and materialized views
• Worked with different ODI Navigators such as Designer, Topology, Operator, and Security.
• Used Oracle Data Integrator security to secure any action performed by authenticated users against the design-time and run-time artifacts and components of Oracle Data Integrator.
• Designed and developed the Repository (.rpd) by importing the required Facts and Dimensions with integrity constraints into physical layer.
• Used Repository and Session variables to streamline administrative task.
• Built schema in Business model and mapping layer by using Complex Joins, created logical tables and columns, also created Hierarchy levels, level based measures for drill down capability, used Time series functions for calculating year ago and month ago assets.
• Involved in developing different Views on the dashboard and many Widgets.
• Extensively used guided navigation capability, drilldowns in reports and created dashboards.
• Designed different Error handling Method.
• Performed Integration Testing for various mappings. Tested the data and Data Integrity among various sources and targets.
• Involved in troubleshooting and debugging of report errors and metadata inconsistencies

Environment: OBIEE 10g, ODI 11g/10.1.3.x, Essbase 11g, Oracle 10g,PL/SQL, SQL*Loader, TOAD, UNIX. client

Confidential

ODI Developer

Responsibilities:

• Analyzed Business requirement, designed data model, and tuned for performance.
• Configured physical and logical schema for Oracle, and file server for development Maintained 1 master and 3 work repositories.
• Created complex interfaces and procedures according to business requirements to work with packages for the ODI objects and scheduled them as scenarios.
• Created specifications doc for creating interfaces for record keeping.
• Used customized knowledge module that was using for previous ODI projects.
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Migrate existing SQL/ Korn shell programs into Oracle Data Integrator (ODI)
• Used Loading, Integration, and Check knowledge module extensively while creating interfaces to Load Data from Sources to Target database.
• Experience with high volume datasets from various sources like Oracle, db2, Text Files, and Relational Tables.
• Schedule jobs with error and success emails.
• Generated scenarios and used in package, also set Synchronous/Asynchronous if needed.
• Exported and imported the Projects and data-store from Dev to TEST environment. Also imported the scenarios in Production execution repository using operator.
• Customized Email distributions to get the error messages and output from PKG run. Modified Knowledge modules to customize it to ETL requirements.
• Converted Existing Incremental process, which uses Shell scripts, SQL scripts and PL/SQL procedure to ODI Incremental (Daily, Week & Monthly Load) process of various complexities and process.
• Optimized Email notification system to automatically notify the User about the Step in which the ODI Jobs fails.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Unit tested all interface and variables.

Confidential

OraclePL/SQL Developer

Responsibilities:

• Involved in Impact Analysis for all major enhancements
• Software requirement specification document preparation for each enhancement
• Involved in Architecture changes for all enhancements
• Developed Custom PL/SQL packages, procedures and
• Performance Tuning of all Custom PL/SQL objects
• Involved in Post Production Support to fix the production issues
• Involved in Scheduled Release support activities
• Creation of Users, Roles & Privileges, Table/Index/ Rollback Segments and Constraints.
• Involved in the Use case analysis and Realization.
• Implemented the Production data fixes using Export/Import process
• Worked on My SQL database as part of architecture
• Unit Test cases preparation and execution

Confidential

Junior Database Developer

Responsibilities:

• Database management fundamentals including creating/updating/dropping tables, developing stored procedures, created indexes on tables, and tuning SQL, adding and dropping users, creating and maintaining backups.
• SQL Developer
• Oracle 9i and subsequent versions as released
• Building, using and maintaining complex databases
• Developed and managed materialized views
• Extracting, transforming, loading data into new or existing structures
• Designed and presented business reports, executive dashboards, and data visualizations
• Data administration, including developing and enforcing data standardization
• Designed and developed data warehouses and data marts

Environment: Oracle Business Intelligence Discoverer, MicrosoftAccess, FoxPro Excel, Word, Visio, PowerPoint, Web Development, HTML, CSS, Java Script, PHP, Graphics, AdobPhotoShop, Corel Draw

Confidential

Web Developer

Responsibilities:

• Study guide asia is a complete education portal providing extensiveinformation on the education and academic resources available in Asia.
• The website providesa wide choice of colleges and courses for the students to pursue their studies, giving detailedinformation about the courses and the colleges.
• The main aim is to guide and navigate thestudents to choose the right course from a variety of courses offered by various Colleges and Universitiesin Asia.
• The website also provides extensive information on the education loan and scholarshipfront giving step by step instruction for the students on how to go about obtaining the same, the process and procedure etc.
• The students can also take part in discussion through forums or seekguidance on choice of courses or on other aspects like communication, facing campus interviewsand other things which are both crucial as well as critical in a student’s career molding period.
• The portal also provides the students a platform to share their thoughts and express their viewson its website which would help in enhancing the scope of their knowledge providing them thenecessary courage and strength to face the real world challenges.
• The website has a page devoted to self goal setting highlighting the importance of the same in a student life. Success stories also find a place in the site to provide motivation to the students.

Environment: Classic Asp, Asp .Net, Xml, VB Scripts, JavaScript, Sql server