SUMMARY

• Total IT: 7 + years of IT Experience including analysis, design, support and maintenance of Oracle Database systems on both UNIX and NT platforms.
• Oracle: 7 years of solid database experience on Oracle 10g/9i, PL/SQL, SQL*Loader, Physical database design, Logical database design, Gap Analysis, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning & Optimization.
• PL/SQL: 7 years of back - end programming experience using PL/SQL, SQL, T SQL, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes (B-tree Index, Bitmap Index), Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
• Databases: Oracle 11g/10g/9i, MS Access 7.0.
• Data Cleansing: 6 years of Data Cleansing experience using PL/SQL, SQL Coding, UNIX Shell scripting.
• Knowledge of data modeling techniques includes virtually every flavor of Entity-Relationship (ER) modeling, Physical and Logical data modeling.
• UNIX: 5 years of UNIX experience on Unix Shell Scripting, cron tab, Sun Solaris, Windows 2000, Windows NT 4.0, and Windows 98/95.
• Strong exposure in writing simple and complex SQL, PL/SQL Functions and Procedures, Packages, Triggers, Materialized views etc.
• Proficiency in using Analytical functions, UTL FILE and DBMS LOB packages.
• Experienced in environments requiring direct customer interaction during design specification, development, and acceptance testing and implementation phases.
• Proficiency in solving issues after an application release in production.
• Proficient in leading a team by providing them direction, knowledge transfer and assistance in work.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Ability to learn new technologies at rapid speed.

TECHNICAL SKILLS

Databases: Oracle 10g/9i, MS Access 2000, SQL*Plus.

Reporting Tools: Developer 2000, Oracle Forms 6i/9i, Reports 6i/9i, Discoverer, BOXI R2.

Programming and GUI: SQL, PL/SQL, SQL*Loader, SQL*Plus, TOAD, PL/SQL developer, SQL Navigator,Unix Shell Scripting, BODI.

Environment: Sun Solaris 2.6, Sun OS, MS DOS 6.22, Windows 3.x/95/98/2000, Windows NT 4.0, IBMcompatibles.

Job Scheduler: Tidal, Autosys, Oracle job scheduler.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr Oracle Developer

Responsibilities:

• Gathered and analyzed requirements from business users.
• Created database objects like tables, synonyms, sequences and views.
• Created, edited procedures and functions for improved business requirements.
• Used SQL Loader to load data into the database coming from Metavance and Standby Databases.
• Wrote complex PL/SQL packages for Customer Interfaces, Payment Interfaces and Broker Commissions for Oracle Applications.
• Used Materialized Views, Hints, SQL Trace / TkProf, Indexes for query tuning and optimizations.
• Used BULK COLLECT, and External Tables for improving performance on the Enterprise DataWarehouse.
• Created Test Cases, Technical Design Documents, Install Plans and worked with Release Engineering teams.
• Used ClearCase, ClearQuest, and Sharepoint for defect creation/resolution, documentation, development tracking and Code repository.
• Worked with BOXI universe and Webi Reports along with Discoverer reports.
• Collaborated with Data Warehouse Architect in writing SQL scripts, Shell Programs, Data Flows, and more.
• Worked with Oracle Forms 6i and Reports 6i.
• Supported development, test and the production databases.
• Used SQL Developer and TOAD to develop code.

Environment: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, UNIX

Confidential, Pennington, NJ

Sr. Oracle Developer

Responsibilities:

• Gathered and analyzed business requirements from end users.
• Worked with applications specialists to understand the new data requirements.
• Collaborated with the DBA in creating tables required for the application.
• Used SQL*loader to load the data from the files provided by the interfacing applications.
• Wrote high level specifications and detailed specifications.
• Wrote PL/SQL Database triggers to implement business rules.
• Used ETL software to extract, transform and load needed data.
• Performed staging, and cleansing on data per requirement.
• Wrote PL/SQL Stored Procedures, Functions, Packages to implement Business Rules.
• Worked with DBA on logical and physical data models, and metadata repository.
• Trained analysts and developers in design tools and data modeling techniques.
• Extensively used SQL to create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Performed data partitioning.
• Used explain plan to increase performance of SQL statements.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Merged data from one database to another database.
• Created indexes as a part of tuning.
• Documented every phase like Technical specifications, source to target mappings, data models (using ERwin), UAT (tests cases and results), and release notes.
• Migrated enhancement from appropriate Dev Area to Test Areas/prod Areas.
• Issued Grants to the business users for appropriate DM tables to design their Universes.
• Wrote UNIX shell scripts to load data.
• Interacted with production support team regarding production issues.
• Documented and transferred knowledge regarding the various projects.
• Attended meeting with business analyst to get new requirements for the application.

Environment: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, ERwin, UNIX, BODI

Confidential, Eden Prairie, MN

Senior Oracle Developer

Responsibilities:

• Gathered requirements from business users and performed analysis.
• Reviewed and Analyzed Business Specification Documents.
• Extensively involved in the requirement analysis, development, writing test cases, and unit testing.
• Designed and created Database objects.
• Wrote PL/SQL procedures and packages as per requirement.
• Wrote complex SQL queries.
• Created views for better performance.
• Created indexes for faster access of tables.
• Worked on Materialized Views and Query Rewrite.
• Wrote scripts to merge data from one system to another system.
• Used SQL*Loader to load data from flat files (excel/access) to Oracle database.
• Used explain plan to improve database performance.
• Involved extensively in the analysis and tuning of the Application code (SQL).
• Increased performance by fine-tuning PL/SQL Procedures.
• Wrote shell scripts for scheduling jobs.
• Used PVCS for source code configuration management.
• Assisted in testing and deployment of the application.

Environment: Oracle 9i, PL/SQL, PL/SQL, Forms 6i, Reports 6i, Shell scripts.

Confidential, Edison, NJ

Senior Oracle Developer

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Involved in Database Design and development.
• Worked on SQL*Loader to Extract, Load and Transform data from varied data sources like Flat files and Oracle.
• Performed Data Upload for all static tables using SQL*Loader.
• Performed logical backups and transferred data between other Applications.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL.
• Designed and Developed Oracle PL/SQL and Shell Scripts.
• Performed Data Conversions and Data Cleansing.
• Worked on Packages to encapsulate procedures and functions.
• Dropped and recreated the indexes on tables for performance improvements.
• Provided 24X7 Production Support of multiple database systems deployed on UNIX and NT platforms.
• Designed and developed UNIX Shell Scripts to handle pre and post session processes.
• Created and executed Crontab jobs.
• Involved in writing test scripts, unit testing, system testing and documentation.
• Performed performance tuning on Production, QA and Development Servers.

Environment: Oracle 9i, PL/SQL, SQL, Forms 6i, Reports 6i, HP UNIX Shell Scripting, Developer 2000, Crontab

Confidential, MA

Oracle Developer

Responsibilities:

• Gathered requirements from business users and made analysis based on the requirements.
• Data Files of different formats from Mainframe systems were loaded into staging environments using SQL*Loader and then used PL/SQL code to perform data transformations and implement business logic.
• Wrote PL/SQL Stored Procedures, Packages to implement Business Rules.
• Built complex queries using SQL.
• Worked on materialized views.
• Used Explain Plan to improve the performance.
• Created views to increase the performance.
• Involved in development and tuning of SQL code used for risk management and trading.
• Created indexes for faster access of tables, which was helpful for performance tuning.
• Built Reports using PL/SQL Procedures from the report table.
• Created various scripts to handle file processing of different formats.
• Extensively used Analytical Functions for writing Complex SQL queries to generate reports.
• Developed UNIX Shell scripts to extract and convert data from different legacy systems in databases.
• Documented procedures and packages.
• Created Test cases based on the functional requirements.
• Assisted in testing and deployment of the application.

Environment: Oracle 9i/10g, Toad 8.0, SQL, SQL*Loader, PL/SQL, Forms 6i/9i, Reports 6i/9i, UNIX, Pro*c, Crontab, Win XP.

Confidential, Jersey City, NJ

Oracle Developer

Responsibilities:

• Wrote stored procedures for application using PL/SQL.
• Created Functions, Triggers and procedures for implementing complex database intensive business rules.
• Managed tables, indexes, constraints, views, synonyms and stored program units.
• Created Bourne Shell scripts and Bash Shell Scripts for automating tasks as well as for creating extracts.
• Wrote PL/SQL cursors for transaction processing.
• Implemented triggers, Created/Modified/Reviewed Procedures, Packages, functions and cursors based on the business rules.
• Written Queries for the management in the form of stored procedures and packages.
• Tuned SQL Queries for better performance.
• Developed & debugged PL/SQL.
• Created and Execute SQL optimization queries.
• Involved in analysis of new business requirements and major developments.
• Coded and debugged the stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Written shell scripts for rebuilding existing databases to keep up with the latest developments.
• Performed tuning for PL/SQL procedures and packages and modified code accordingly to improve performance.
• Created indexes and partitions on various tables in order to enhance performance.
• Provided production support and played a major role in debugging errors during implementation and deployment.
• Modified code to maintain user jobs running on regular intervals performing data transfer from staging area to log tables.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Integrated, tested, debugged and implemented application systems.
• Optimized SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modified some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways.
• Extensively worked on client information stored in Oracle database using GUI interface.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Wrote complex stored procedures and triggers and optimized for maximum performance.
• Wrote Unix Scripts for event automation.
• Used Analytical functions in SQL to generate reports that gave details about number of records processed.

Environment: Oracle PL/SQL, UNIX Shell Scripting, SQL*Plus, SQL*Loader, oracle 8i

Confidential, VA

Oracle Developer

Responsibilities:

• Created and Compiled the Converted objects in Oracle database.
• Performed Unit and System Testing, Optimized SQL Statements wherever required for better performance, handled scheduling of Jobs, generated DDL scripts and entity relationships using ERwin.
• Debugged and fixed the resulting defects from the testing process, Monitored / Tuned the databases by using tools like Oracle Enterprise Manager, Created dictionary of attributes reused, Transferred and loaded data, Developed user documentation for the case management module, Developed physical data models and star schemas by applying Oracle PL/SQL.
• Developed tables, views, stored procedures, functions, and user-defined datatypes.
• Created table structures along with the triggers, indexes like bitmap and function based indexes.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Maintained the data integrity and security using constraints and database triggers.
• Involved in programming database triggers for automatically updating the tables and views.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR Loops, WHILE loops while developing procedures.
• Implemented table partitioning and sub-partitioning to improve performance and data management.
• Troubleshoot performance issues within packages and stored procedures using explain plan and DBMS OUTPUT.
• Responsible for tuning the application with the help of team members & Oracle support.
• Improved the query performance using better joins and hints appropriately.
• Developed packages, procedures and functions for complex reports.
• Used SQL*Loader for loading the data into the tables from files.
• Developed batch programs using UNIX shell scripts.
• Participated in the design and code reviews and verified compliance with the project’s plan.
• Documented the whole process flow, PL/SQL packages, locations and descriptions, and possible error messages.

Environment: Oracle 8i, PL/SQL, Oracle Developer 2000 and Windows 98