SUMMARY

• Around 7 + years of hands on experience in the software industry with the know - how of the Software Development Life Cycle through Requirement Gathering, Design & Development, Testing, Implementation and Production Support, Documentation and Delivery.
• Highly experienced in Software Design, Analysis, Coding, Development and Testing with specialization in ORACLE based Client-Server & Three-Tier Computing Architecture, Database Design and Development, Implementation, Production Support & Maintenance and Quality Assurance.
• Extensively worked in Client-Server application development using Oracle /9.x,/8.x,/7.x Forms 9i/6i/6.0/4.5, Reports 9i/6i,SQL, PL/SQL.
• Excellent command over Oracle SQL, PL/SQL, SQL*Loader, Java and HTML.
• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Extensive experience in Analysis and Design of Database. Created ER Diagrams on ERWIN using Normalization Techniques.
• Experience in Schema Structure design. Involved in estimation and optimization of Data Storage.
• Experience in Performance Tuning & Optimization of SQL statements.
• Used TKPROF and Explain Plan for Optimization.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Good understanding of the Oracle database, related utilities and tools.
• Participate in data architecture evaluation of application products, database design and implementation of new procedures to utilize new technologies.
• Experience in code migration, database change management and data management through the various stages of the development life cycle.
• Strong technical aptitude; proven ability to rapidly assimilate and design practical applications of new technology.
• Exceptional career track marked by motivation, dedicated follow-through, and unwavering commitment to excellence.

TECHNICAL SKILLS

• Oracle 10g/9i/8i/8/7.x
• SQL
• PL/SQL
• Microsoft SQL server 7.0
• MS-Access v2.0 and higher
• HTML 3.0 and higher
• XML
• Java 1.5 (applets Servlets)
• JSP
• Java Script
• JDBC
• C
• C++
• Unix (HP and SUN SPARC)
• Windows 95/98/NT/2000
• Linux
• Developer 10g/9i/6i/2000 Release 1 & 2
• Reports 10g/9i/6i/3.0
• Forms 6i/9i
• OAS 4.0.8 /9iAS
• MS Office 95/97/2000
• PVCS Tracker 6.0
• MS Visual Source Safe 6.0
• TOAD v6.1.6.2-g/7.4
• SQL * Navigator
• SQL LoaderERWIN

PROFESSIONAL EXPERIENCE

Confidential, Dallas,TX

Senior Oracle Developer

Responsibilities:

• Design and implement Human Resource Data Mart from PeopleSoft.
• Developed PL/SQL packages,procedures,functions as per business requirements.
• Manual extraction of data (ETL) from peoplesoft using PL/SQL and loaded into staging tables.
• Extensively used UTL FILE packages to write an outbound interface program.
• Created the fact tables and dimension tables.
• Written procedures to load the data into the fact and dimension tables.
• Created indexes to increase performance and complex SQL queries for joining multiple tables.
• Tuned and Optimized the SQL statements to improve the performance of the application using Explain Plan and SQL trace utilities.
• Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Created Materialized views for faster query performance.
• Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors.
• Migrated the data from development to test environment for UAT testing.
• Involved in UAT,Integration and system testing.
• Written Unix Shell scripts for the automation of the packages,procedures and functions.
• Converted many sql scripts to packages to improve the performance in loading.
• Active participation in requierement gathering from clients.
• Handle the user tickets and resolve the issues.

Environment: Oracle 9i, 10g, SQL, PL/SQL, UNIX (Sun-Solaris box), Shell Scripting

Confidential, Memphis, TN

Oracle Developer

Responsibilities:

• Involved in System Analysis.
• Involved in the analysis, design of the tables.
• Involved in Coding and Testing of the application.
• Created Procedures, Functions and packages using PL/SQL.
• Involved in Manual Testing of Application.
• Involved in requirement gathering.
• Had daily meetings with business people to gather requirements.
• Prepared BRS for the SBTM Project.
• Involved in naming conventions and coding standards for Tables, Columns, Procedures and function.
• Written various Triggers, Stored Procedures to perform or automate many of the tasks.
• Written SAS scripts to pull data from ISH (EDW - Enterprise Data Ware House).
• Used UTL FILE packages to write the data from Oracle tables to a flat file.
• Written UNIX shell scripts to automate the scripts using Kshell.
• Developed UNIX Scripts to create FTP Jobs and data upload.
• Used TOAD, SQLPlus, SQL Assistance.
• Involved in UNIT and Integration testing.
• Worked in DEVELOPMENT, STAGE and PRODUCTION environment.

Environment: Oracle RDBMS 9i, 10g, TOAD 8.5.3, SQLPlus, SunSolaris, Windows 2000,Bluzonex7.1.

Confidential, Memphis, TN

Oracle Developer

Responsibilities:

• Involved in testing the application.
• Created Procedures, Functions and packages using PL/SQL.
• Involved in validating the data that comes from the third party vendor.
• Generated scripts to pull data form different sources and automated the scripts.
• Had daily meetings with business people to gather requirements.
• Cron job has been set for the shell scripts written.
• Written sas scripts to pull data from ISH .
• Used TOAD, SQLPlus, SQL Assistance

Environment: Oracle RDBMS 9i, 10g, TOAD 8.5.3, SQLPlus, SunSolaris, Windows 2000,Bluzonex7.1

Confidential, Lakeforest, IL

Oracle Developer

Responsibilities:

• Involved in System Analysis.
• Coordinated between management, users and technical teams for Requirement Gathering.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 10g.
• Involved in Code Standardization and Documentation.
• Involved in database Performance Tuning and Optimization of SQL queries.
• Used TKPROF and Explain Plan for Optimization.
• Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic.
• Designed the screens through which the end users could control the quote.
• Wrote PL/SQL programs for the commission agreement and to pass said agreements to the printer, which can be forwarded to the data center or the local printer
• Designed and Developed User Interface using Forms 6i and Reports 6i.
• Created Control Files and used SQL* Loader to upload bulk data.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Responsible for troubleshooting the errors that occurred when the production and testers hit a roadblock.
• Developed UNIX Scripts to create FTP Jobs and data upload.
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment: Windows NT, Oracle RDBMS 10g, PVCS, TOAD, PL/SQL Developer, Forms 6i,Reports 6i PL/SQL, Erwin, SQL Scripting, Unix Scripting

Confidential, Arlington Heights, IL

Responsibilities:

• Worked extensively in Designing, Developing, and Testing of Oracle PL/SQL and Developer9i Reports.
• Wrote SQL Scripts for creation of database tables, synonyms, sequences and created users, roles and privileges.
• Written Stored Procedures, Functions and Packages using PL/SQL.
• Written Control Files for Loading ASCII/Flat files onto the Oracle database using SQL * Loader.
• Used TKPROF and Explain Plan for Optimization of SQL queries.
• Good working knowledge of PL/SQL and UNIX in Production Support.
• Created and tested numerous Forms and Reports using Oracle Forms 6i & Reports 6i.
• Involved in direct discussion with the Functional/End-Users to study the system requirement and Develop Functional and Technical Specifications to meet their requirements.

Environment: Windows NT, Oracle RDBMS 9i, PVCS, TOAD, PL/SQL Developer, PL/SQL, Pro*C, Erwin, SQL Scripting, Forms 6i,Reports 6i, HP - Unix.

Confidential, Milwaukee, WI

Oracle Developer

Responsibilities:

• Responsible for the development and maintenance of the Inventory Control and Client Contract modules.
• Interacted with the business users on a regular basis to collect Business Requirements and Specifications.
• Used Designer 6i for Data Modeling, Design Specifications and to analyze Dependencies.
• Developed and debugged the Application Screens and Reports using Developer 6i.
• Tested new enhancements and bug fixes before Deployment into the Production environment.
• Worked as part of a team to launch new Application Releases under strict time deadlines
• Coded database Triggers, Package, Functions, and Procedures using PL/SQL; and maintained the scripts for various data feeds.
• Optimized and Tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Responsible for designing and maintaining fully integrated and multiple levels help system for the modules.
• Prepared functional specifications, release notes, training materials and other documentation.
• Provided Cross Training to Team Members on the Developer tools.

Environment: Oracle RDBMS 9i, Designer 6i, Developer 9i (Reports 9i), PL/SQL, SQL*Plus Reports, SQL*Loader, Windows 2000

Confidential

DEVELOPER/ANALYST

Responsibilities:

• Responsible for Design, Development, Testing and Deployment of custom OLTP system and application.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Involved in defining User Requirements, Data Modeling, Query Tool Selection, User Interface Design, and Client presentations.
• Designed frameworks in which database administration and applications development can deliver client solutions.
• Involved in maintaining data integrity between Oracle and SQL Server databases.
• Developed PL/SQL scripts to Validate and Load Data into interface tables.
• Involved in designing and aiding coding of Functional Specifications for the development of user interfaces.
• Extensively involved in Requirements Gathering and Data Gathering to support developers in handling the design specifications.
• Created and tested numerous Forms and Reports using Oracle Forms 6i & Reports 6i
• Investigated software bugs and interacted with developers to resolve Technical issues and Contributed proposals, documentation and training.

Environment: Oracle 8i, PL/SQL, SQL*Plus, Windows NT 4.0, PL/SQL, Stored Procedures, Views, Triggers, Designer 2000, Oracle Developer (Reports), Forms 6i.

Confidential

Oracle Programmer Analyst

Responsibilities:

• Functioned as an analyst for the planning, analysis, design and development phases of the application.
• Involved in the database designing and maintenance.
• Worked on various backend Procedures and Functions using PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Involved in the development of procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Generated reports for management to review for system functionality as against the old legacy system.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing procedures and functions.

Environment: Oracle 8i, SQL, PL/SQL, Developer 6i (Oracle Reports 6i), Sun Solaris and Windows NT.

Confidential

Application Developer

Responsibilities:

• Development of transaction details.
• Development of enquiry module, Meal Plan module.
• Creating Database objects like tables, Views, index, Triggers, Packages.
• Designed daily bookings report, Cancellation report, and arrival list report.
• Provided Production Support to the Local Office.
• Modifications to the system, including enhancements, addition of new modules.
• Performed System study, analysis and redesign of the existing system.
• Did black box testing.

Environment: SOLARIS 2.6, ORACLE 8i, PL/SQL, SQL *PLUS