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 teh 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 teh Oracle Architecture.
• Having a good noledge on Perl scripting language as well.
• Excellent understanding in teh working of teh 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 teh security domains like having unique passwords, not sharing teh information wif teh 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 teh 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 teh procedures, functions, packages, triggers and also updating teh existing ones based on teh change requests.
• Involved in teh 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 teh procedure which is used to load teh tables from different databases and environments.
• Utilized tools like TOAD, SQLDEVELOPER, SQL *Plus during development of teh pl/sql scripts.
• Involved in direct discussion wif teh End-Users to study teh requirements and helped in teh 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 teh solving teh tickets that are raised by teh end users.
• Efficiently used teh GIT version control tool for loading teh scripts
• Written Bourne shell scripts for automatic execution of teh stored procedures
• Creating teh new tables and maintained tables for various different requirements.
• Automated teh process through teh 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 teh procedures, functions, packages, triggers and also updating teh existing ones based on teh change requests.
• Involved in teh 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 teh procedure which is used to generate teh reports from different databases.
• Utilized tools like TOAD, SQLDEVELOPER, JASPER during development of teh reports.
• Involved in direct discussion wif teh End-Users to study teh requirements and helped in teh 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 teh solving teh tickets that are raised by teh end users.
• Written Bourne shell scripts for automatic execution of teh stored procedures
• Creating teh new reports for various different requirements.
• Automated teh process through teh 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 teh existing procedures, functions, packages, triggers and also updating teh existing ones based on teh change requests.
• Involved in teh analysis, design, flow, archiving of data and databases and also wif their relationships.
• Also has 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 teh procedure which is used to update teh purchase order information from one database to another database.
• Gained teh noledge on Options and Futures.
• Utilized tools like TOAD during development of teh application.
• Involved in direct discussion wif teh End-Users to study teh requirements and helped in teh 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 teh solving teh tickets that are raised by teh end users.
• Written korn shell scripts and perl scripting for automatic execution of teh stored procedures
• Updating teh existing reports and Forms wif additional functional requirements. These reports used to gather teh net sales units and dollar amount information for all teh stores in comparison wif teh previous year.
• Automated teh process through teh 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 teh development of new procedures, functions, packages, triggers and also updating teh old ones based on teh change requests.
• Involved in teh 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. Teh results are written to a flat file
• Performed unit testing of data extraction forms.
• Prepared technical specifications document for teh procedure which is used to update teh purchase order information from one database to another database.
• Utilized tools like TOAD during development of teh application.
• Involved in direct discussion wif teh End-Users to study teh requirements and helped in teh development of functional specifications to meet their requirements
• Loaded data into warehouse using PL/SQL Scripts, ETL tools, SQL*Loader.
• Extensively used teh Enterprise Resource Planning modules.
• Involved in large and complex data conversion, data modeling project from teh existing system to teh new system which did help End-Users to use both old and new systems and helped in teh development of new system that replicates teh old system as is.
• Also created teh data marts for loading.
• Extensively used teh 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 teh production support and solved teh tickets that are raised by teh end users.
• Written korn shell scripts for automatic execution of teh stored procedures
• Updating teh existing reports and Forms wif additional functional requirements. These reports used to gather teh net sales units and dollar amount information for all teh stores in comparison wif teh 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 teh 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 teh change request.
• Good understanding on equities, risk management etc.
• Coordinate wif teh front end design team to provide them wif teh necessary stored procedures, packages and teh 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 teh data warehouse.
• Involved in teh analysis, design, flow, archiving of data and databases and also wif their relationships.
• Extensively worked on datamarts, fact and dimensional tables.
• Designed teh Entity-Relationship model and normalized database.
• Loaded data into warehouse using External Tables, PL/SQL Scripts, ETL tools, SQL*Loader.
• Extensively used teh 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 teh 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 teh production support and solved teh tickets that are raised by teh 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 teh 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.
• Teh 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 teh Design of User interfaces
• Coding of teh forms.
• Extensively used teh .NET framework
• Developed teh server pages wif teh Visual Basic and later updated to ASP.
• Involved in tuning database and SQL statements and schemas for optimal performance.
• Generated teh Reports.
• Query Optimization and tuning of database.
• Involved in writing java scripts, struts etc
• Utilized tools like TOAD during development of teh application.
• Involved in direct discussion wif teh End-Users to study teh 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