SUMMARY

• Around 7 years of diversified experience in analysis, design, development, testing and implementation as Oracle PL/SQL Developer.
• Expertise in using Oracle 9i/10g/11g and good experience in 9i/10g/11g databases
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, Indexes, SQL *Loader, SQL *Plus, and TOAD.
• Working experience of over 5 years on Unix Shell Scripting.
• Experienced in Tuning and monitoring SQL Statements and Procedures using explain plans, hints for enhancing the performance in various schemas across databases.
• Extensively worked on Table Partitioning, Bulk Binds and Bulk Collects.
• Knowledge on DBA activities such as Performance Tuning, Backup and Recovery.
• Good Working Experience in Forms 6i/9i & Reports 6i/9i for both development and customization of several Reports as per client specifications.
• Experience on Logical & Physical design, analysis of Databases, Data Modelling, Conceptual Design and Data Architecture, data marts, and extensive use of Erwin and MS VISIO as a modelling tool. Understanding of Star Schema and Snowflake Schema.
• Sound understanding of other Relational and Normalized databases such as MS SQL Server, Sybase and MS Access, Micro Strategy.
• Experience in automating loads using process chains and use of BW Monitor to supervise data loading, data conversion, data transformations.
• Excellent understanding of the Oracle Architecture.
• Having a good noledge on Perl scripting language as well.
• Excellent understanding in the working of the Data Warehousing Environment, its Components and Architecture. Also worked on Informatica.
• Expertise in C#, Visual Basic and Active Server Pages for Applications for MS Office.
• Expertise in EXTARCTION, TRANSFORMING and LOADING (ETL) skills.
• Used the security domains like having unique passwords, not sharing the information wif the others who are not related to project work, having VPN which is having high security.
• Technical documentation of different lifecycle deliverables and user manuals.
• Expertise in all phases of the Software Development Life Cycle.
• Worked on 24*7 environments to provide production support.
• Strong oral and written communications skills, analytical and interpersonal skills.
• Good team spirit and organized working habits wif a willingness to learn new concepts

TECHNICAL SKILLS

Languages: SQL, PL/SQL, VB, ASP, Perl, Shell Scripts, C/C++, Java.

Internet Technologies: HTML, DHTML, Java Script and Xml.

Development Tools: FrontPage, Flash Mx and Dream weaver Mx

Database: Oracle 9i/10g/11g, MS Access, SYBASE

Operating Systems: Windows NT/XP/2k, UNIX, Sun Solaris, MS - DOS.

Data warehousing Tools: Informatica 7.1/8.6 Power Center, Business Objects

Other Utilities: TOAD, SQL PLUS, TIBCO, SQL Loader, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Oracle Developer

Responsibilities:

• Extensively used high level backend pl/sql programming involving different databases
• Involved in developing the procedures, functions, packages, triggers and also updating the existing ones based on the change requests.
• Involved in the analysis, design, flow, archiving of data and databases and also wif their relationships.
• Developed new fact and dimension tables which are used to extract data from different systems and criteria.
• Performed unit testing and also performance testing for data extraction.
• Prepared technical specifications document for the procedure which is used to load the tables from different databases and environments.
• Utilized tools like TOAD, SQLDEVELOPER, SQL *Plus during development of the pl/sql scripts.
• Involved in direct discussion wif the End-Users to study the requirements and halped in the development of functional specifications to meet their requirements
• Loaded data into tables using PL/SQL Scripts, SQL*Loader.
• Fine tuned SQL Queries using explain plan, hints for maximum efficiency and performance.
• Involved in the solving the tickets that are raised by the end users.
• Efficiently used the GIT version control tool for loading the scripts
• Written Bourne shell scripts for automatic execution of the stored procedures
• Creating the new tables and maintained tables for various different requirements.
• Automated the process through the cron job scheduling.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, SQL*Plus, SQLDEVELOPER, SQL Loader, Toad, Linux

Confidential, NYC, NY

Oracle Developer

Responsibilities:

• Extensively used high level backend pl/sql programming involving different databases
• Involved in developing the procedures, functions, packages, triggers and also updating the existing ones based on the change requests.
• Involved in the analysis, design, flow, archiving of data and databases and also wif their relationships.
• Developed new reports which are used to extract data from different systems and criteria.
• Performed unit testing and also performance testing for data extraction.
• Prepared technical specifications document for the procedure which is used to generate the reports from different databases.
• Utilized tools like TOAD, SQLDEVELOPER, JASPER during development of the reports.
• Involved in direct discussion wif the End-Users to study the requirements and halped in the development of functional specifications to meet their requirements
• Loaded data into tables using PL/SQL Scripts, SQL*Loader.
• Fine tuned SQL Queries using explain plan, hints for maximum efficiency and performance.
• Involved in the solving the tickets that are raised by the end users.
• Written Bourne shell scripts for automatic execution of the stored procedures
• Creating the new reports for various different requirements.
• Automated the process through the autosys job scheduling.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, SQL*Plus, SQLDEVELOPER, JASPER, SQL Loader, XML, Toad, Linux

Confidential, Chicago, IL

Oracle Developer

Responsibilities:

• Extensively used high level backend pl/sql programming involving different databases
• Involved in improving the existing procedures, functions, packages, triggers and also updating the existing ones based on the change requests.
• Involved in the analysis, design, flow, archiving of data and databases and also wif their relationships.
• Also have experience in end to end of mapping from different databases.
• Developed new forms which are used to extract data from different systems and criteria.
• Performed unit testing and also performance testing for data extraction, data conversions.
• Prepared technical specifications document for the procedure which is used to update the purchase order information from one database to another database.
• Gained the noledge on Options and Futures.
• Utilized tools like TOAD during development of the application.
• Involved in direct discussion wif the End-Users to study the requirements and halped in the development of functional specifications to meet their requirements
• Loaded data into tables using PL/SQL Scripts, SQL*Loader.
• Fine tuned SQL Queries using explain plan, hints for maximum efficiency and performance.
• Involved in the solving the tickets that are raised by the end users.
• Written korn shell scripts and perl scripting for automatic execution of the stored procedures
• Updating the existing reports and Forms wif additional functional requirements. These reports used to gather the net sales units and dollar amount information for all the stores in comparison wif the previous year.
• Automated the process through the cron job scheduling.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, SQL*Plus, TIBCO, SQL Loader, Toad, Perl, Linux

Confidential, Pasadena, CA

Oracle Developer

Responsibilities:

• Extensively used high level backend pl/sql programming involving different databases
• Involved in the development of new procedures, functions, packages, triggers and also updating the old ones based on the change requests.
• Involved in the analysis, design, flow, archiving of data and databases and also wif their relationships.
• Developed new forms which are used to extract data from different systems and criteria. The results are written to a flat file
• Performed unit testing of data extraction forms.
• Prepared technical specifications document for the procedure which is used to update the purchase order information from one database to another database.
• Utilized tools like TOAD during development of the application.
• Involved in direct discussion wif the End-Users to study the requirements and halped in the development of functional specifications to meet their requirements
• Loaded data into warehouse using PL/SQL Scripts, ETL tools, SQL*Loader.
• Extensively used the Enterprise Resource Planning modules.
• Involved in large and complex data conversion, data modeling project from the existing system to the new system which did halp End-Users to use both old and new systems and halped in the development of new system that replicates the old system as is.
• Also created the data marts for loading.
• Extensively used the fact and dimensional tables.
• Used high system securities such as unique passwords, vpn etc.
• Fine tuned SQL Queries using explain plan, hints for maximum efficiency and performance.
• Involved in the production support and solved the tickets that are raised by the end users.
• Written korn shell scripts for automatic execution of the stored procedures
• Updating the existing reports and Forms wif additional functional requirements. These reports used to gather the net sales units and dollar amount information for all the stores in comparison wif the previous year.
• Working noledge of Tivoli Process.
• Automated sFTP and FTP process.

Environment: Oracle 10g, SQL, PL/SQL, UNIX, SQL*Plus, Informatica 8.6, SQL Loader, Toad, Linux, Forms &Reports

Confidential, Sleepy Hollow, NY

Database Developer

Responsibilities:

• Understanding the business logic to modify existing SQL Code and Performance Tuning and monitoring if it requires.
• Used EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also Extensive Usage of Indexes
• Designed and developed a custom database wif some DBA skills like (Tables, Views, Permissions, Indexes)
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Good understanding on equities, risk management etc.
• Coordinate wif the front end design team to provide them wif the necessary stored procedures, packages and the necessary data.
• Involved in writing procedures, functions, triggers, and packages for new requirements.
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse.
• Involved in the analysis, design, flow, archiving of data and databases and also wif their relationships.
• Extensively worked on datamarts, fact and dimensional tables.
• Designed the Entity-Relationship model and normalized database.
• Loaded data into warehouse using External Tables, PL/SQL Scripts, ETL tools, SQL*Loader.
• Extensively used the Enterprise Resource Planning modules (ERP).
• Involved in large and complex data conversion and data modeling project
• Automated sFTP and FTP process.
• Written bourne shell scripts for automatic execution of the stored procedures
• Read data from data files and uploading that data into oracle tables using SQL*loader.
• Provided Test Data to QA team to validate front end application. Also performed unit testing.
• Involved in the production support and solved the tickets that are raised by the end users.
• Involved to prepare user level and system level maintenance documentation.

Environment: Oracle 9i/10g, Forms 9i, Reports 9i, SQL, PL/SQL, Informatica 7.1, UNIX, SQL*Plus, SQL Loader, Toad.

Confidential, MA

Oracle PL/SQL Developer

Responsibilities:

• Modifying existing SQL code and performance tuning if necessary.
• Extensively involved in writing procedures, functions, triggers, and packages.
• Involved in Unit Testing of each module.
• Extensively used Oracle Clinical applications
• Documentation of all modules for user level and system level maintenance
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also Extensive Usage of Indexes
• Involved in writing java scripts, HTML, struts etc
• Read data from flat files to oracle tables using SQL*loader
• Helped the EDI group wif PL/SQL part.
• Used ETL wif PL/SQL.

Environment: Oracle 9i, SQL, PL/SQL, Forms 6i, Reports 6i, UNIX, HTML, Business Objects SQL*Plus, SQL Loader, SQL Navigator, Toad

Confidential

Technical Developer

Responsibilities:

• Worked extensively in developing, deploying, and testing of Oracle Forms and Oracle Reports using Oracle 9i.
• Involved in gathering user requirements.
• The project involved detailed design using E-R Diagrams, Data Flow Diagrams, Data Dictionary, and System flow Charts.
• Wrote PL/SQL packages consisting of procedures and functions.
• Created Views, Triggers, Sequences.
• Involved in the Design of User interfaces
• Coding of the forms.
• Extensively used the .NET framework
• Developed the server pages wif the Visual Basic and later updated to ASP.
• Involved in tuning database and SQL statements and schemas for optimal performance.
• Generated the Reports.
• Query Optimization and tuning of database.
• Involved in writing java scripts, struts etc
• Utilized tools like TOAD during development of the application.
• Involved in direct discussion wif the End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.

Environment: Oracle 9i, Forms 6i, Reports 6i, VB, ASP, C/C++, Java, SQL, PL/SQL, SQL*PLUS, TOAD, Windows 2000