PROFESSIONAL SUMMARY:

• Over 7 years of programming experience as an Oracle Developer/ETL Developer in Analysis, Design, and Implementation of Business Applications in OLTP, Client/Server architecture and data warehouse applications.
• 2 years of hands-on experience using Oracle Data Integrator ODI and Oracle Warehouse Builder OWB .
• Proficient in analyzing the end user requirements and converting them into efficient Technical Solutions.
• Extensively worked on Oracle Data Integrator ODI Topology manager, Designer, Operator.
• Created various data integration project components Interfaces, Packages, Procedures using Oracle Data Integrator's Designer.
• Good conceptual knowledge and experience in creating ODI scenarios and scheduled using agents at regular intervals.
• Strong Knowledge in using various knowledge modules and customizing knowledge modules.
• Strong knowledge and Experience on ODI jobs monitoring, debugging any failed jobs and production support using ODI's Operator.
• Strong knowledge in developing mappings, process flows using Oracle warehouse builder for implementing ETL from source to target systems.
• Migrated Oracle Warehouse Builder Mappings and process flows from one environment to other using collections.
• Extensive experience in using various transformation operators while designing OWB mappings.
• Good Experience in developing PLSQL Stored Procedures, Functions, Packages, using features like Cursors Ref Cursors, Analytical Functions, Collections, Exception Handling, Materialized views, Objects, Autonomous Transactions, Dynamic SQL.
• Experience in development of applications using Oracle 10g/9i/8i, SQL, PLSQL, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i.
• Expertise in loading data from legacy systems using SQL Loader.
• Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
• Extensive experience in analysis and design of database, database modeling, ER Diagrams, normalization and de-normalization.
• Tuned complex SQL queries using Explain plan and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Good understanding of Relational database design and developed various data models using ERWIN and Oracle Designer.
• Experience in writing Technical design documents and developing unit test documents.
• Experience with software Development life cycle SDLC process.
• Excellent Logical and Analytical Skills, Enthusiastic, and good Interpersonal Skills.

TECHNICAL SKILLS:

WORK EXPERIENCE:

Confidential

ODI/Oracle Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Designed and created Mapping documents, ETL architecture documents and specifications.
• Created source to target mapping documents by analyzing various source systems.
• Participated in discussions with Project Manager, Business Analysts and Team Members on any technical or Business Requirement issues.
• Developed various Interfaces, Packages and Procedures using ODI to load data from Flat file Relational Sources to Data Warehouse.
• Development of detailed specifications for data management scripts.
• Designed Documents for performing unit testing and string testing of developed code.
• Good experience in ODI components like designer, topology manager, operator and on other ODI concepts Master Repository, work Repository, Project Models, sources, targets, Interfaces, Packages, Scenarios, Knowledge Modules, metadata.
• Used the ODI Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Extensively used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Used ODI for Reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used topology manager for registering source and target technologies along with logical and physical schemas.
• Used Knowledge Modules KM and customized them if required to load and transform the data from different data sources.
• Used ODI Operator for migrating code from one environment to another by generating and deploying scenarios
• Used surrogate key assignment and change data capture.
• Developed complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Used Operator for production support and debugging of ODI jobs
• Created SQL Loader control files for moving the data from flat files to staging area tables.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER.
• Developed UNIX shell scripts in VI Editor with embedded SQL Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.

Environment: Oracle Data Integrator ODI 10g/11g , Oracle 10g/11g, PL/SQL, PL/SQL Developer 8.0.4, Shell scripting, SQL loader, UNIX/LINUX, Windows NT.

Confidential

ODI/Oracle Developer.

Responsibilities:

• Expertise includes analysis, design, development and testing of data warehousing application using Oracle Data Integrator ODI.
• Developed and worked with Master and work repositories using the Repository management tools.
• Implemented data warehouse using dimensional modeling concepts with star schema.
• Configuring the physical and logical architecture schemas using Topology Manager.
• Developed and managed the physical and logical models and performed reverse engineering.
• Designed and developed ODI interfaces using Designer and imported knowledge modules LKM, IKM, CKM, etc to load and transform the data from various data sources.
• Developed various ODI interfaces to load data from Flat file and relational sources like xml, xls to Oracle Data Mart.
• Expertise on database design - Creation of data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the DB.
• Good understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables modeling of data at all the three levels: view, logical physical.
• Worked with Metadata Navigator, which enables users to access information through a Web interface.
• Experience in real time data movement and change data capture technologies.
• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems ETL Operations using PL/SQL and SQL Loader.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL trigger, sequence, stored procedure .

Environment: Oracle Data Integrator, Oracle 10g, Oracle Forms 10g, PL/SQL, TOAD, SQL Developer, Shell scripting Bourne and Korn , SQL loader, Stored Procedures/Triggers, XML, Sun Solaris 5.6.

Confidential

Oracle Developer.

Responsibilities:

• Involved in design of database and created database objects.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Developed and modified procedures, Function, triggers, forms, reports and deployed the changes in the system.
• Developed user interfaces using Oracle Forms.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Performed load and integration tests on all programs created and applied version control procedures to ensure that programs are properly implemented in production.
• Responsible for creation of new users and setting up privileges and policies for protection of data.

ENVIRONMENT: Oracle 9i, SQL, PL/SQL, SQL Loader, KORN Shell script, Oracle Forms 9i, Reports9i.

Confidential

Oracle Developer.

Responsibilities:

• Actively involved in interacting with front end Java developers, and gathered User Requirement and Online System Specification.
• Created new logical and physical database design to support multi-year conferences for the tables of employees, histories, skills, experience and payroll.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Normalized to 3NF to acquire least data repetition required by business.
• Migrated old data from Flat Files, Excel File and legacy System into the new database using SSIS.
• Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Extensively worked with Dynamic SQL, Composite data types Global Temporary Tables.
• Filtered bad data from legacy system using various T-SQL, and implemented constraints and triggers into new system for data consistency.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Implemented security by creating User logins, Roles and granting Users access to the database according to their role.
• Used UTL JOB to automate the plsql procedures and packages.
• Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Oracle 9i, SQL Server 2000, Windows 2003, UNIX, SQL, PL/SQL, T-SQL, SQL Loader, ERwin and SQL Navigator.

Confidential

Oracle developer

Responsibilities:

• Responsible for analyzing business functionality for the back end processes.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in the Star schema model.
• Developed ETL processes for Data Extraction, Data Mapping and Data Conversion using PL/SQL scripts and load data into warehouse Schemas.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Combined data from heterogeneous data sources such as flat files and oracle database tables. Used UNIX Shell Korn Scripts and Scheduled cron jobs to automate the process of Extraction, Transformation and Loading the data into Data Warehouse.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL LOADER.
• Involved in creating user interface Forms and adhoc reports using Oracle Forms/Reports 6i.
• Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle 8i, SQL, PL/SQL, SQL Loader, SQL Plus, Oracle Forms 6i, Reports 6i, Windows 2000.

Confidential

Oracle Developer

Responsibilities:

• Custom tables and new custom objects were designed as per business requirements.
• Created database triggers to validate complex integrity.
• PL/SQL Procedures, functions, cursors, triggers and packages were created using TOAD.
• Developed and maintained Oracle Forms and Reports for various applications using SQL Plus and PL/SQL.
• Developed PL/SQL procedures to support Forms and perform standalone functions.
• Developed complex SQL Queries and used in creating Reports and Forms.
• UNIX shell scripting was used for scheduling batch jobs. The system was used to run batch processes and reports that utilized PL/SQL and Oracle Reports.
• Responsible for SQL tuning using Explain Plan and SQL trace facilities.
• Performed unit testing and Integration testing for the scenarios mentioned in the test scripts.

ENVIRONMENT: Oracle 8i, Solaris, Reports 6i, Forms 6i, TOAD, SQL Loader, PL/SQL, SQL Plus.