PROFESSINAL SUMMARY:

• Over 7 years of programming experience as an Oracle Developer/ ETL Developer.
• Extensively participated in Analysis, Design, Data Modeling Logical and Physical , and Implementation of Business Applications in Client/Server architecture and OLAP.
• 2 years of hands-on experience using Oracle Data Integrator ODI .
• Strong Knowledge and hands on experience in ETL tools such as ODI Oracle Data Integrator and OWB Oracle Warehouse Builder .
• Excellent knowledge in using slowly changing dimension concepts such as SCD Type 1 and Type 2 for data loading.
• Expertise in using dimensional modeling techniques for designing data warehouses.
• Strong Knowledge and experience in setting up data servers for various technologies like oracle, file and XML using ODI Topology Manager.
• Good experience in ODI job monitoring, debugging failed jobs and production support using ODI operator.
• Expertise in creating ODI interfaces for various source and target technologies.
• Good knowledge in star and snow flake schema and created ODI interfaces for loading data into star schema based tables.
• Good Knowledge and experience in customizingknowledge modules based on requirements.
• Generated Scenarios and scheduled them using ODI Operator.
• Extensively worked on Oracle Data Integrator ODI Topology manager, Designer, Operator and security manager.
• Good experience in trouble shooting of the packages.
• Extensive experience in using various transformation operators while designing OWB mappings.
• Good knowledge in using OWB for implementing ETL from source to target by developing mappings and process flows.
• Performed Extraction, Transformation, and loading ETL data from various sources into Data Warehouses.
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive experience in database programming using SQL and PL/SQL following industry best practices.
• Expertise in creating stored procedures, functions, packages, collections and bulk collectionsusing PL/SQL.
• Extensive Experience on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL, SQL Loader using SQL, PL/SQL and UNIX Shell Scripting.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Worked with various performance tuning techniques using tools provided by Oracle like Explain Plan, created necessary indexes, and DBMS PROFILER.
• Extensive Programming experience in designing reports using Reports 10g, 9i/6i and designed user interfaces with Forms 10g, 9i, 6i
• Supported integration and end user testing with efficient defect management process.
• Strong Analytical, Problem solving and communication skills.
• Strong communication and inter-personal skills at the technical and user level.
• Participated in creating ETL design and architecture documents and source, target mapping documents.

TECHNICAL SKILLS:

• Software: Microsoft Office Excel, Word, Power Point, and Access , Visio
• Operating Systems: Solaris, Windows
• Languages: PL/SQL, SQL, Java, UNIX, SAS, Perl
• Web Technologies: HTML, JavaScript, JSP, CSS, and XML.
• Database Environments: Oracle 9i/10g/11g
• Tools: Oracle Forms/Reports, ETL,JDeveloper, Oracle Application Express, SQL plus, SQL Navigator, SQL Developer, Eclipse, Exceed, Adobe Web Premium CS3, Macromedia Dreamweaver, Oracle Enterprise Manager
• File Transfer Tools:FTP, Putty, Humming Bird, WinSCP

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ODI/PLSQL Developer

Responsibilities:

• Worked with analysts in analyzing various sources for testing, metrics, project coordination, business analysis and requirement s gathering.
• Designed ETL process design documents and detail design documents.
• Developed various ODI interfaces to load data from Flat file Relational Sources to Oracle Data Mart.
• Designed mapping documents between source and targets, mapped sources and targets as per specifications.
• Created logical and physical schemas for every source and target of warehouse with the help of Topology manager.
• Used the ODI Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Developed interfaces, procedures, packages, and scenariosusing ODI for loading warehouse from various sources like flat files, databases, csv files.
• Participated in code reviews to understand the testing needs of the change components.
• Used ODI for Reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used Knowledge Modules KM and customized them as per business requirement.
• Created ODI procedures for complex logics that is not possible to implement using interfaces and packages.
• Worked with Metadata Navigator, which enables users to access information through a Web interface.
• Involved in the Analysis, Design, Coding and Testing of the application.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• 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/ SQLscripts for migration of data between databases.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, complex database triggers and data migration scripts.
• Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER.
• Created Relational database design using ERwin tool, i.e. created Logical data base design and then created physical database design,Identified Fact Tables, Dimension Tables.
• Worked on production support and resolved the issues occurred with jobs.
• Created test cases and testing procedures for ETL interfaces and packages.

Environment:Oracle Data Integrator11g, Oracle 10g/11g, PL/SQL, SQL Loader, UNIX, Shell Scripts, and Erwin.

Confidential

Sr. Oracle /ODI Developer

Responsibilities:

• Expertise includes analysis, design, development and testing of data warehousing application using Oracle Data IntegratorODI.
• Worked with Master and work repositories using the Repository management tools.
• Configuring the physical and logical architecture schemas using Topology Manager.
• Developed and managed the physical and logical models and performed reverse engineering.
• Used Knowledge Modules KM and customized them as per business requirements.
• 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, procedures, packages and scenarios to load data from flat files, databases, csv files.
• Expertise on database design - Creation of data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the Database.
• Good understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflake 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.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• 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 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.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL trigger, sequence, stored procedure .

Environment: Oracle Data Integrator 10g, Oracle 10gR2, Oracle Forms 10g,PL/SQL, TOAD, SQL Developer, Shell scripting, SQL loader, XML.

Confidential

Oracle Developer

Responsibilities:

• Reversed engineered existing database and refined existing database schema to make more effective and efficient database model.
• Prepared the Technical Design according to the business requirements.
• Made one universal data model combining four different application databases Mortgage database, Investment Database, Accounts Database, Bonds Database to make one comprehensive financial application.
• Migrated the application from Non-relational to relational database application.
• Created suitable data models for existing application data from XML and mapped it with new table schema
• Took the initiative and migrated more than 80 existing Excel reports into Crystal reports Web based reports using the Oracle Cartridges.
• Documented comprehensive data dictionary for each application data field.
• Created DDL for various modules of data model for testing and implementation.
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers with extensive use of cursors, complex joins, date functions and string handling functions to implement business rules into the application.
• Wrote T-SQL procedures and functions.
• Wrote large complex SQL scripts DDL / DML for database object management and space management to move / rebuild indexes / tables and reporting packages.
• Created views to apply security policies and also created materialized views to achieve performance gain.
• Imported data from flat flies using SQL Loader.
• Created detailed source target database mapping with transformation required.
• Discussed migration policies with other developers and DBAs for quick and error-free migration between heterogeneous databases.
• Discussed the data model with application users to refine the design and made changes accordingly.
• Wrote custom procedures and functions to transfer data from various sources to universal application database.
• Knowledge transfer to incoming DBA and other team members.

Environment:Oracle 9i/10g/11g, MS SQL Server 2000, T-SQL, RHEL, MS Visio,Data Modeler, Windows, shell scripting, Toad, PL/SQL, XML, MS Excel

Confidential

PL/SQL Developer

Responsibilities:

• Involved in writing complex queries to generate reports as per client request.
• Tuning SQL's for enhancing the load performance.
• Involved in the unit test and system test of the new environment for resolving the issues according to the service level agreements.
• Developed Interfaces to connect the non-oracle databases MS SQL Server and PowerBuilder from the Oracle Production System.
• Data extraction/Transformation/Cleaning/Loading has been implemented using SQL Loader and PL/SQL.
• XML was used to push/pull the data to and from an External Source.
• Created several libraries, packages, triggers, alerts, menus, procedures, functions to perform online screen validations and back end processing.
• SQL rule-based optimization was used in obtaining fast execution with the help of indexes.
• SQL Loader has been created to load flat file data into table.
• Contributed to tuning the SQL queries, create database objects and optimally set storage parameters for tables and indexes.
• Created and customized forms using Oracle Forms 8i.
• Generated and published reports using Crystal reports 10.
• Tested and maintained of various application modules.
• Supported from offshore for implementation.
• External tables have been configured to by pass the SQL Loader process.
• Triggers have been created to notify the support group of any problems in the function of databases by sending automated emails to students.

Environment:Oracle 9i, SQL, SQL Loader, PL/SQL, Developer 2000, Crystal Reports 10, Oracle Forms 9i, Windows XP, UNIX, Shell, Toad, XML

Confidential

Oracle Developer

Responsibilities:

• Developed functions, procedures and packages as re-usable application programs that translated complex business logic using PL/SQL and SQL to transform data between source staging area to target staging area. Extensively used PL/SQL tables, cursors and exception handling.
• Created database objects like Tables, Sequence, Synonyms, Views, and Materialized Views.
• Involved in developing interactive forms and customization of screens using Oracle Forms.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Maintenance included enhancing the existing stored programs, forms and reports with additional procedural and non-procedural programming logic to meet complex user requirements and fixing the bugs on priority basis.
• Importing data from different varieties of sources like flat file, excel file or Oracle dump file into Oracle database source schema tables using SQL loader.
• Responsible for creating and maintaining the Table spaces, Users and assigning Roles and Privileges.
• Developed, Tested and Migrated the Oracle PL/SQL scripts to Production.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems.
• Extensively worked on developing KORN shell scripts for scheduling the jobs using CRONTAB and invoking the procedures through shell scripts.
• Involved in implementing bug fixes and enhancements within packages, forms, and reports.
• Responsible for preparing user manuals and quick reference guides.

Environment:OracleForms and Reports, PL/SQL, SQL Navigator, Oracle Enterprise Manager, Exceed, Humming Bird, JSP, Java Script, HTML