SUMMARY

• Over 7+ Years of Experience as an Oracle PL/SQL Developer with Proficiency in Oracle … SQL, Oracle PL/SQL, Oracle Form Builder … Report Builder 10g/9i/6i, C, Java, UNIX Shell Scripting.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports) Oracle Developer Suite 10g and other front - end tools.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Extensive working knowledge in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility&TKProf.
• Extensive experience in using Cursors and Ref-cursors for processing of data.
• Good Knowledge on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records and Types.
• Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and bulk variables.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Experience in UNIX Shell Scripting.
• Worked with query tools like Toad, SQL*Plus, PL/SQL Developer.
• Enforcing experience in data integrity using integrity constraints and database triggers.
• Expertise in handling errors using Exceptions.
• Experience in creating MaterializedViews and DB links.
• Strong understanding of Object Oriented Analysis and Design.
• Extensively worked on Materialized Views, Database links and Table partitioning.
• Excellent experience in writing UNIX shell scripts, scheduling Korn jobs and DBMS packages.
• Experience in logical and physical design of Databases, Data Modeling and Data Architecture.
• Excellent experience in Performance tuning SQL queries to optimize system performance.
• Proficient experience in optimization of ETL procedures and packages.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS

RDBMS: Oracle 9i/11g/10g

Languages: SQL,PL/SQL,UNIX shell scripting

Operating Systems: Windows 7/XP, Unix.

Modeling tool: Microsoft Visio

Other Tools: PLSQL Developer, SQL*Plus, SQL developer, TOAD, SVN

PROFESSIONAL EXPERIENCE

Confidential, Silver Springs, MD

Oracle PL/SQL Developer

Responsibilities:

• Analysis, design, development of database packages using PL/SQL.
• Involved in the creation of database objects like tables, views, stored procedures, functions, DB triggers, Indexes and Collections.
• Created Cursors and Ref Cursors in the PL/SQL Blocks.
• Involved in Tuning the SQL and PL/SQL Procedures,
• The project is related to database application which uses oracle database and Oracle 10g stored procedures/triggers etc for execution.
• Developed, Tested and Migrated UNIX Shell Scripts.
• Involved in Data loading and Extracting functions using SQL*Loader.
• Responsible for development and testing of conversion programs for importing data into Oracle database utilizing PL/SQL, SQL*Loader and UNIX shell scripts, to load data from flat files to Oracle database.
• Worked on Data base Extracts and creating stage tables and loading the date in DWH.
• Worked on Migration of processes from servers to different upgraded servers.
• Actively involved in Technical Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
• Code review of fixed issue.
• Documentation of user manual and other generic documentation required for the module.
• Responsible for designing, developing, specification of test plans.
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• Involved in database Performance Tuning and monitoring.
• Responsible for monitoring the performance and stability of the software during performance test prior to going- live.

Environment: Oracle 10g, Toad 9.0, PL/SQL Stored Procedures, Packages, Triggers, REF Cursors, Visual Safe Source, Oracle Application Server10g, SQL Developer, SQL*Plus, SQL *Loader, Explain Plan, Putty, Winscp, Unix Korn and Shell Scripting, XML, Windows 7.

Confidential, Herndon, VA

Oracle PL/SQL Developer

Responsibilities:

• Designed workflows to do the Extract, Transformation and Load of data.
• Actively involved in requirement gathering and review meetings.
• Analyzing the data model to understand the relationships.
• Archive application data from live and retired applications
• Create Optim directories, dB alias and install database clients used by Optim.
• Determining the criteria for archiving and purge of each application.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Performed Data Migration as a part of enterprise data warehouse project.
• Responsible for scheduling Optim extract and load jobs.
• Experience in writing Files using procedures for logging result.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
• Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.
• Used SQL Loader to upload the information into the database and using FILE packages write data to files.
• Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling.
• Used PL/SQL, SQLLoader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.

Environment: Oracle 11g, 10g R1 and R2, Sun Solaris, RHEL 4, Windows 2003 with Active Directory, OEM, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, STATSPACK, Crystal Reports.

Confidential, Bloomfield, CT

Oracle PL/SQL Developer

Responsibilities:

• Involved in the maintenance and support of the existing applications.
• Understanding and Analysis of the ESQL in Message Broker.
• Analyzed data flow in the business process.
• Involved in DBA tasks such as database maintenance, performance tuning and query optimization.
• Involved in Tunning the SQL Queries.
• Tuned SQL queries, structure of the code and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Heavily optimized the code for high performance.
• Tested Queries in different environments (DEV, QA, UAT, and PROD)
• Performance tuning and optimization achieved through the management of indices, query execution plans and optimizing the SQL scripts.
• Involved in Tuning Database & Application performance using Explain Plan.
• Worked with analysts, users, and other IT technical professionals to understand requirements.
• Developed documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules..
• Creation of unit test cases, test case review and testing.
• Involved in production support issues.

Environment: Oracle 10g, Toad 11.5, IBM websphere Message Broker, ESQL, PL/SQL, Fiddler, Oracle Application Server10g, SQL Developer, SQL*Plus, Putty, Winscp, Explain Plan, UNIX Korn and Shell Scripting, Windows 7.

Confidential, Kennilworth, NJ

Oracle PL/SQL Developer

Responsibilities:

• Responsible for collecting requirements from the business users and developing technical specifications from it.
• Preparing and talking to business owners about enhancements and modification of problems.
• Involved in writing and updating procedures, functions, cursors, triggers, and packages for new requirements or change requests. Changed existing logic within the packages for optimum Performance.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL*Plus, SQL*Loader, Toad
• Involved in comparing the features of the tools like Rapid SQL and SQL Developer.
• Involved in migration of elements from Oracle to EnterpriseDB and checking the performance.
• Involved in Analyzing the Performance of the testing tool Quest Code Tester.
• Prepared the technical and functional test plans for the developed procedures
• Also responsible for unit testing, SIT, UAT and documentation
• Used SQLLOADER to load data into database
• Involved in creating shell scripts to send emails and to invoke PLSQL scripts.
• Performed tuning and optimization on SQL queries using SQL trace and Explain Plan.
• Involved in creating various classes, methods and packages in Core Java
• Tested the original and optimized codes thoroughly for failures before exporting to other environments
• Responsible for trouble shooting backend production problems and provided production support

Environment: Windows 2000, UNIX, Oracle 9i/10g/11g, PL/SQL, SQL, TOAD 9, SQL Developer, SQLLOADER, Perl, Quest Code Tester, Core Java, Javascript