SUMMARY

• 8 Years of IT experience on Data Warehousing, Business Intelligence and PLSQL Development.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support
• Worked on technologies like Oracle, Oracle Data Integrator.
• Have experience in data Extraction, Loading and Transformation in data ware house environment.
• Demonstrated expertise utilizing ELT tools, including Oracle Data Integrator (previously known as Sunopsis)
• Designed and developed mappings to load the data from multiple sources like Relational databases, flat files into oracle database.
• Developed packages, scenarios and Load plans.
• Good knowledge about Topology, Designer, Operator in Oracle Data Integrator.
• Good Understanding about ODI Architecture.
• Worked with knowledge modules like LKM, IKM and CKM.
• Good Knowledge about Standalone Agent and J2EE Agent.
• Coded SQL/PL - SQL and SQL* Loader for high volume data warehouse instances.
• Ability to work individually as well as in a team with excellent problem solving skills.
• Knowledge on data ware housing concepts like schemas and approaches.
• Good analytical, programming and debugging skills.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, Sybase ASE, Sybase IQ, SQL Server

Languages: PLSQL, SQL, Java, C, HTML, XML

Oracle Tools / Components: TOAD for Oracle, SQL *Plus, SQL *Loader, BI Publisher Reports, SVN, FTP, Putty, WinScp, Unix, SQL Developer

Data Warehouse (ELT) Tool: Oracle Data Integrator (ODI) 11g, 12c.

PROFESSIONAL EXPERIENCE

Confidential, Stony Brook, NY

ODI Technical Consultant

Responsibilities:

• Analyzed functional & technical design documents.
• Participated in Data Modeling and Data model review.
• Installed and configured ODI Tool with Oracle, MS SQL Server and flat files.
• Extensively used ODI (Oracle Data Integrator) ELT tool to create Data ware hosing OLAP model.
• Created master & work repositories and configured ODI connections for source and target systems in topology.
• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, MS SQL server, Oracle.
• Did reverse engineering for the data sources and targets.
• Developed mappings for loading the lookup and transactional data.
• Created ODI packages, scenarios using mappings, variables, procedure.
• Worked with multiple sources such as Relational database, Flat files for Extraction, Transforming and Loading data into target tables.
• Monitoring the execution logs in operator.
• Experienced in Working with Load Plans and Scenarios.
• Implemented Send E mail to the DBA on interface execution failure.
• Working knowledge of Knowledge Modules (LKM, IKM, JKM and CKM).
• Implemented SCD type1 and SCD type2.
• Have knowledge about Changed Data Capture.
• Participated in all phases of project development, testing, deployment and support.
• Created various test scenarios to test the application.
• Delivered the assignments before the deadlines.
• Conducted code reviews and planned the knowledge transfer to client.

Environment: Oracle Data Integrator 12.0.1.2, Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 , TOAD 9.7.2.5, Oracle Database 10g, SQL Developer, Java, XML Publisher Reports, PL/SQL, WINSCP, Unix, SVN, XML Editor and TOAD.

Confidential, Stony Brook, NY

ODI Developer

Responsibilities:

• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Prepared technical designs for ODI mappings.
• Contributed to logical and physical data modeling for the new data warehouse.
• Experience in development of ETL (Data Extraction, Transformation and Loading)Mapping using Oracle Data Integrator for loading the data from heterogeneous source systems.
• Created and executed mapping using Slowly Changing Dimensions Type 2, Slowly Growing Target, and Simple Pass Through.
• Developed mapping for fact loading from various dimension tables.
• Participated in code reviews. Did code promotions from Dev to test, staging and production environment using ODI.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Created new models for the data sources - flat files, MS SQL server, Oracle.
• Created ODI packages, scenarios using mappings, variables, procedure
• Debug the sessions by utilizing the log of the sessions.
• Loading metadata from flat file source system into RDBMS target system.
• Performance Tuning in Oracle Data Integrator.
• Resolved ODI related issues faced by the team members.

Environment: Oracle 11g, Sybase 12.5, Toad, Oracle Data Integrator 12.0.1.2, MS Excel.

Confidential, Durham, North Carolina

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Designed database tables using various normalization techniques and database rules.
• Involved in the continuous enhancements and fixing of production problems.
• Developed and test of SQL, PL/SQL code in database triggers, Stored Procedures, Functions and Packages as per requirement.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILE package.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools like Toad, PL/SQL DeveloperandSQL* plus.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Developed and executed the Unit test cases, Test plan.
• Developed / enhanced new/existing forms for ease of maintenance.
• Mentor the team members in the implementation.
• Coding, Unit Testing and peer reviewing according to technical specification.

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Designed and Developed the Data model on various modules like Admin, Audit, Workflow, Template engine etc.
• Maintained the Data Dictionary for the designed Data Model.
• Developed the data base diagrams for the various modules.
• Developed the PL/SQL quires for the development team.
• Developed the various PL/SQL objects like Procedure, Functions, and Packages etc to perform the background operations.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign keyconstraints.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Developed the code to execute the jobs at specific time in a day/week/month.
• Provide data model guidance to the development team.