PROFESSIONAL SUMMARY:

• Arround 10 years of experience in development, testing and implementation of application software.
• Proficient in Oracle programming, Packages, Procedures, Functions, Cursors and Triggers in PL/SQL.
• Expertise in SQL Plus and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Partitioning, Indexes, query rewrite, Joins, Inline views, Global Temporary Tables, data screening).
• Expertise in Oracle advanced features like REGEXP, Collections, Ref Cursors, Native Dynamic SQL, Analytic functions, External Tables and PL/SQL Collections.
• Used System Packages, Tables, Hints to tune queries for better performance.
• Expertise in ClearCase versioning tool including ClearCase Explorer, Merge Manager, Type Explorer.
• Experience in ETL Data Modeling: Star - Schema Modeling, Snowflake Modeling, FACT and Dimension tables.
• Experience in Data Warehousing: Informatica Power Center 7.x/8.x (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager).
• Developed some UNIX Shell scripts to automate database operation and database monitoring.
• Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources using PL/SQL, Shell Scripts export/import and SQL*Loader.
• Worked as Associate Database Administrator including creating schemas, creating roles, developing oracle backup, recovery strategy and scripts.
• Self-managed, team-player, pro-active and highly organized.
• Excellent communication skills.

TECHNICAL SKILLS

Databases: Oracle 11g/10g, MS Access/Excel, MySQL, SQL Server 2000/2005.

Scripting: SQL, PL/SQL, Unix Shell Scripting, Pro*C, Perl, T-SQL

Languages: C, C++, Java, VB.NET

Operating Systems: Windows NT/2000/XP Professional, Apple Macintosh, HPUX, Solaris 7.0/8.0, UNIX, RedHat LINUX

Designing Tools: SQL*Loader, ERwin, Microsoft Visio, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr Oracle Developer

Responsibilities:

• Lead in Production monitoring for PBSD. Trained developers in monitoring the daily production run.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
• Worked on Logical and Physical Data Modeling.
• Involved in Production Build and Release of applications. Every release involves adding new features or enhancements to the application.
• Involved in Build and Deploying Database, Raw Data Upload (RDU) and Schedule components.
• Supported for Hawk Monitoring tasks, Involved in creation of hawk rule bases including error reports and dependencies of the Tasks and Runs.
• Supported 24/7 shift system and worked as On-call support. Review all alert mails which are coming into mail box.
• Responsible to solve support tickets(Alacrity, ECMS, Peregrine) in Remedy Tool.
• Testing the interfaces in DEV, PreQA, QA, UAT by coordinating with source and target applications.
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Used batch scripts to loop from database to database, to perform system-wide functions.
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.
• Worked with Dynamic SQL, Global Temporary Tables.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.
• Worked on Clearcase Explorer to deploy files and manage versions.
• Automating data loading, extraction, report generation using UNIX shell scripting. Worked on merging and deploying the files in the Development, QA, and Production.

Environment: Oracle 11g, UNIX, SQL, SQL*Plus, PL/SQL, SQL*Loader, Rational ClearCase Explorer, Batch, ERwin, PVCS, TOAD, PuTTY, Lotus Notes 6.5

Confidential, Cisco, CA

Oracle/ETL Developer

Responsibilities:

• Involved in design of logical and physical data model of the components.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Designed star schema using dimensional modeling and created fact tables and dimensional tables.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
• Successfully Implemented Slowly Changing Dimensions. Used Type 2 dimension to keep the history changes.
• Created complex Functions, Stored Procedures and Packages by using PL/SQL. Sub-queries and Joins were extensively used in stored procedures.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, SQL Trace, TKPROF Tools, Indexing and Partitioning of tables.
• Worked on Oracle advanced concepts with Oracle Objects including Collections, Types, and Objects. Used Collections like variable arrays, nested tables extensively.
• Worked as Oracle system operator (Associate DBA) with database logical design for new applications ER diagram, primary, foreign keys, building data warehouse.
• Developed some UNIX Shell scripts to automate database operation and database monitoring.
• Worked on Performance Tuning of SQL after analyzing the table.

Environment: Oracle 10g, PowerCenter 8.2, UNIX, SQL, SQL*Plus, iSQL Plus, PL/SQL, SQL*Loader, Batch, Java, JDBC, XML, HTML, PVCS, TOAD

Desktop Switching Business

Confidential

Responsibilities:

• Worked on Logical and Physical Data Modeling.
• Created PL/SQL Stored Procedures, Functions, Packages Cursors, Exception Handling and Triggers for moving the data and controlling the data flow.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
• Written Java code to interact User-Interface with database using JDBC.
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.
• Worked with Dynamic SQL, Global Temporary Tables.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Designed ER Diagrams using UML Models (Visio) and Relational data Models for applications.
• Involved in loading the data from Source Tables to ODS (Operational Data Source) Tables using Transformation in SSIS.
• Extensively used SSIS Packages to load data from various formats into a warehouse; created and processed cubes.
• Wrote SQL Queries, involved in SQL Tuning by creation of indexes and rebuilding queries using Explain Plan.
• Created Logical and Physical Database design. Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Designed ER Diagrams using UML Models (Visio) and Relational data Models for applications.
• Written complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Created complex functions, stored procedures and packages by using PL/SQL. Sub-queries and Joins were extensively used in stored procedures.
• Worked on Oracle advanced concepts with Oracle Objects including Collections, Types, and Objects.

Environment: Oracle 10g, PL/SQL, TOAD Master’s

Early Childhood Software

Confidential

Responsibilities:

• Responsible for collecting information about technical resources.
• Designed the logical and physical database to store the content.
• Implemented interface (contains background, buttons, images except characters) after completing the design of the database.
• After the completion of the interface, worked on ActionScript to link flash pages.
• Worked on data storage using MySql.
• Involved in writing PL/SQL Stored Procedures, Functions and Packages.
• Created database tables with complex constraints applicable to the business rules
• Created a very user-friendly GUI interface, with extensive use of features of Oracle Forms 4.5.
• In order to keep all the activities of the company under control, various reports like field clinic report, voucher payments report and analysis reports were generated.
• Constant monitoring and performance tuning of Oracle database and checking the most expensive queries.
• Create dynamic HTML pages with XML, JavaScript and CSS for their software product.
• Built PHP and CSS system for controlling text display issues cross-platform and cross browser.
• Involved in unit testing and integration testing.
• Involved in requirements gathering, Analysis, Design and Development of the project.