We provide IT Staff Augmentation Services!

Odi Technical Consultant Resume

NY

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, 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, 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.

Environment: Front end: Dot Net, Visual Studio, XML.

Hire Now