SUMMARY

• Over Seven years of experience in Information Technology including RDBMS, Internet and Client Server applications.
• Experience in all phases of the project life cycle
• Experience in Oracle Programming and Application Development
• Excellent experience in Software Development using Oracle 7.3.x,8.0.x,8i,9i,10g,11g
• Strong Programming skills in SQL*PLUS, PL/SQL for developing Oracle stored procedures, functions, packages, database triggers
• Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections
• Experience in UNIX including Korn Shell Scripting
• Having noledge and experience in Java
• Proficient in developing Oracle forms using Forms6i
• Expertise in database and 3-tier application design
• Strong interpersonal skills, ability to interact wif people Confidential all levels. Good communication and presentation skills

TECHNICAL SKILLS

RDBMS: Oracle 10g/9i/8i/7.x(SQL,PL/SQL,Stored Procedures, Triggers), MS-Accessserver, MY-SQL, and Netezza

Operating Systems: Ms-Dos, Windows 9x/2000/xp/NT/Vista, UNIX and LINUX

Packages: Ms-Office and Visual Basic6.0

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java Script, HTML, DHTML, C, C++, PERL, Pro *C, AutoSys jil scripting

Other Tools: Developer 2000(Forms 6i, Reports 6i), SQL*Loader, TOAD, PL/SQL Developer, Sql Navigator, Putty, WinSCP, PVCS, WinSql and Eclipse, MS Visio, Autosys, HP Open View, Snag It, PUTTY, Tidal Soft, Exceed, Crontab, AutoSys, FTP, SFTP

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Oracle Developer

Responsibilities:

• Extensively used PL/SQL, SQL & UNIX
• Developed Oracle Packages, Procedures, Functions, SQL Scripts and Triggers to implement business requirements
• Ran explain plans, created indexes and implemented query hints to tune SQL queries for optimum results
• Used Microsoft Visio for Dataflow and Entity relationship diagram
• Developed UNIX shell scripts to run sqlloader processes to insert records to the database
• Developed UNIX Korn shell scripts to implement file transfers using Secure File Transfer Protocols
• Developed Forms and Reports using Forms 6i and Reports 6i
• Worked on database conversion from Oracle to Netezza
• Written extensive queries in Netezza and tuned the queries for maximum efficiency
• Understand business requirements, design and document technical design for the business requirements
• Expert noledge of the AutoSys job scheduler including the AutoSys JIL scripting language
• Created complex SQL and used JDBC connectivity to access the database
• Worked closely wif the Administrator for proper backup and recovery plans
• Supported testing, integration system test, implementation
• Wrote system documentation for all projects in my area of responsibility
• Worked on-call support wif availability after hours and weekends

Environment: Oracle 10g/9i, SQL* LOADER, PL/SQL, Java, Unix Shell scripts, Toad, SQL Navigator, UNIX, Win 2000, Autosys, PUTTY, Eclipse 3.2

Confidential, Saint Paul, MN

Oracle Developer

Responsibilities:

• Involved in analysis, database design, coding, and implementing
• Understand business requirements, design and document technical design for the business requirements
• Loaded data into multiple tables using SQL Loader
• Used extensively PL/SQL, to develop packages, stored procedure, functions and database triggers
• Tuned SQL queries to improve performance
• Used Microsoft Visio for Dataflow and Entity relationship diagram
• Developed procedures, functions for different forms
• Used Java to do the batch processing, Having good noledge on java batch processing and UNIX korn jobs
• Used different joins, sub-query and nested query in SQL query, for reports
• Extensively used PL/SQL in reports to perform calculation and to get desired output
• Developed single HTML page to serve as a centralized menu for the web application, and then broadcast URL
• Developed automated notification of Emails, using Unix shell script, to the users in case of failure in the process from time to time
• Implemented the technical and functional aspects of DEPOT project
• Interacted wif end user for problems faced and providing necessary technical support by fixing the bugs
• Testing, Integration System test, Implementation (test wif users) and documented the entire project

Environment: Oracle 9i, SQL*PLUS, SQL* LOADER, PL/SQL, Reports 6i, HTML, Java, Unix Shell scripts, Windows NT

Confidential, Atlanta, GA

Oracle Developer

Responsibilities:

• Extensively used PL/SQL, SQL & UNIX
• Written Packages, Procedures, Functions, Cursors and Triggers to perform business operations
• Tuned SQL queries for optimum results
• Loaded data into multiple tables using SQL Loader
• Used Microsoft Visio for Dataflow and Entity relationship diagram
• Created indexes for the system performance
• Monitored application output file generation process, and performed manual operations in sending files to client FTP sites
• Having good noledge on AutoSys & Kron jobs
• Involved in uploading of the data from flat files into Databases and validated the data wif PL/SQL procedures
• Worked wif front-end team to support the Application & Worked on developing application components using Java
• Worked closely wif the Administrator for proper backup and recovery plans
• Interacted wif end user for problems faced and providing necessary technical support by fixing the bugs

Environment: Oracle 10g/9i, SQL* LOADER, PL/SQL, Java, Unix Shell scripts, Toad, SQL NavigatorUNIX, Win 2000.

Confidential

Software Programmer / Analyst

Responsibilities:

• Involved in database design, coding and implementation
• Developed scripts to create database tables, indexes, synonyms, and grants
• Developed UNIX shell scripts to run SQL*Loader processes to insert records to the database
• Ran explain plans, created indexes and implemented query hints to tune SQL queries for optimum results
• Developed PL/SQL modules to create packages, stored procedures, functions and database triggers
• Used Microsoft Visio for Dataflow and Entity relationship diagram
• Developed automated email notification using Unix shell scripts
• Developed Unix Korn shell scripts to extract data from the Production database for daily reports
• Used XML to display the reports/forms
• Created complex SQL and used JDBC connectivity to access the database
• Preparation of ERD/Data Modeling Design
• Developed Javascript behavior code for User Interaction
• Involved in the debugging of the applications

Environment: Oracle 9i, SQL*PLUS, SQL* LOADER, PL/SQL, Reports 6i, HTML, Java, Unix Shell scripts, Windows NT

Confidential 

Programmer

Responsibilities:

• Design & Developed tables, stored procedure, functions, indexes
• Involved in database design and development of the application
• Having noledge on complete SDLC structure
• Having experience on Implementation, testing & documentation
• Extensively used SQL and PL/SQL
• Developed C and C++ modules to implement business requirements

Environment: C, C++, Oracle 7.3, PL/SQL, Forms, Report, Windows 95