SUMMARY

• Around 6+ years of experience in various phases of software development life cycle, including Designing, Development and Testing of business applications using Oracle 9i/10g/11G.
• Experience in interacting with Users, analyzing client business requirements, performing design analysis and developing according to design specifications.
• Proficient in developing and maintaining various PL/SQL Database objects like Packages, Functions, Stored Procedures, Triggers, Tables, Views, Materialized Views, Indexes, Sequences, Partitions, etc.
• Created PL/SQL procedures, packages, functions and other database objects to generate back - end and front-end reports.
• Exposure to Waterfall and AGILE software development methodologies.
• Experience in Application Development using Reports and SSRS.
• Adept in using Oracle Tools like SQL Developer, SQL* Plus, Toad, SQL Loader, Data Loader, SQL navigator.
• Extensive knowledge in design and modeling database-using Erwin.
• Experience in using SQL *Loader and External Tables for Export/Import of data and Quest tools (TOAD, Navigator) under UNIX and Windows NT.
• Proficient in designing, modeling, creating and maintaining Oracle database.
• Experience in Performance Tuning & Optimization of SQL statements.
• Excellent logical and analytical skills, interpersonal & communication skills and strong ability to perform as part of a team.
• Familiar with Functional, Unit, System and Integration testing.
• Good understanding of Data modeling concepts ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Extensive experience in database administration, backup, recovery, performance and tuning.
• Proficient in writing UNIX Shell scripts.
• SQL Tuning/ Optimizing Queries and creation of indexes for faster database access and better query performance in database by creating explain plan for query and indexing the required columns.
• Proficient in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica Power Center.
• Possess good Performance/Time Management and Organizational skills.

TECHNICAL SKILLS

Programming languages: SQL, PL/SQL, Unix Shell Scripting, C, C ++, C#, Java

Case Tools: SQL *Plus, SQL*Loader, Explain plan, Oracle Reports, SSRS Reports, Toad

Packages: Microsoft Access, MS Office ( MPP, MS Excel, MS Word), E-Business Suite 11.5.10.2

Operating Systems: UNIX, Windows XP/ 98/2000/2008

Tools: TOAD, SQL Navigator, Forms /Reports Builder 6i, Visual Studio 2010 .

Scripting Languages: UNIX Shell scripts, HTML, Java Script

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Senior Oracle PL/SQL Developer

Responsibilities:

• Interacted with business analysts for Business rules and Functionality Specifications.
• Implemented high-level business logic embedded in SQL stored procedures.
• Involved in writing, Designing, modifying, and testing modules using SQL.
• Designed and developed database objects such as Packages, procedures, functions and cursors.
• Designed and developed Programs for data integration from external source or interface flat files into database tables using External Tables.
• Extensively worked on Query Tuning for better performance of sql queries used in various stored procedures.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Designed and created Database objects: tables, Indexes, Views, Procedures, Packages and Triggers.
• Created database triggers so as to check database integrity and storing historical data.
• Created sequences and views of the database tables.
• Developed Unix shell scripts to execute Oracle packages/procedures using automated scheduler
• Scheduling and monitoring batch jobs using Tivoli
• Provided 24x7 PROD support for the Application after the release.

Environment: Oracle 11g, PL/SQL, External Table, TOAD 8.0, Unix, Tivoli

Confidential, Beaverton, Oregon

Senior Oracle PL/SQL Consultant

Responsibilities:

• Analyzed the Business requirements of the project by studying and understanding the Business Requirement Specifications Documents.
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL.
• Used advanced Bulk Binds techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• Involved in working with implicit cursors, explicit cursors, and REF CURSORS.
• Experience in using various oracle PL/SQL collections like varrays, nested tables, associative arrays with INDEX BY VARCHAR2
• Leveraged Explain Plan and TKPROF to improve query performance.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Extensively used Dynamic SQL for DDL and DML commands in PL/SQL. The procedures are built to generate reports with dynamically varying conditions based on the input parameters passed.
• Created Daily, Weekly and Monthly Reports as per business needs using Oracle Reports Builder 10g.
• Created batch jobs in regular maintenance and production support to load the data using UNIX shell scripting.
• Worked in all deployment processes to QA, UAT, Production and DR Environments.
• Handled various errors thrown throughout the integration process and coordinated with the team.
• Involved in scrum meetings, Business requirements meetings.

Environment: Oracle 10G, PL/SQL, SQL*Loader, Toad, UNIX Shell Programming Oracle Reports Builder 10g, MS Access 2000, Excel and Windows NT.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in almost all Software Development Lifecycle (SDLC) phases
• Implemented PL/SQL procedures, packages, Functions and triggers as required.
• Built complex queries using SQL and written stored procedures using PL/SQL and called from C# .Net program.
• Worked in Production Support Environment as well as QA /TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Involved in Logical & Physical Database Layout Design.
• Involved in developing UNIX shell scripts required for maintaining and processing job
• Worked on ETL tools like Power Center 8.0 which are used for data integration and also mapping the data.
• Worked with Informatica to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Involved in supporting/fixing production defects and day to day business transaction issues.
• Using Erwin created the database and database objects as per the Business requirement documents.
• Extensively utilized TOAD for performance tuning by generating Explain Plans.
• Optimized SQL Queries by performance tuning using Explain plan, creating Indexes for reporting requirements and providing hints as of when required.
• Used Tortoise SVN Version Control for changing the codes.
• Created comprehensive test plans and result test cases and scripts for unit and integration testing.

Environment: Oracle 10G, TOAD 8.0, PL/SQL, Informatica Power Center 8.0, Microsoft Visual Studio 2010, SQL*Plus, .NET, UNIX, Tortoise SVN.

Confidential

Oracle Developer

Responsibilities:

• Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, coding and testing.
• Analyzed and Reviewed the Business Specification Documents.
• Developed Database procedures and functions to handle data manipulations and Computations on Server.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Creating the Mappings using Informatica to create the input feed according to the standard format work file to process for accounting engine.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Worked on writing Autosys JIL files for job scheduling .
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages..
• Involved in creating user documentation and providing End user training.

Environment: Oracle 10G, PL/SQL, WinNT 4.0, AIX4.3.2, Autosys.

Confidential

Software Programmer

Responsibilities:

• Involved in scrum meetings, Business requirements meetings.
• Extensively used Export/Import Utilities for performing logical backups and transferring data between other Applications
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.
• Used Unix shell scripts for automating batch jobs processing. Developed UNIX shell scripts for batch jobs
• Was responsible for tuning the SQL statements using Explain Plan, SQL Trace, TKPROF
• Used Materialized views in places where the data does not change very frequently. Gathered data into PL/SQL tables for validating and loaded into Oracle tables using BULK loader utility.
• Extensively involved in various phases of testing the products before migrating Production, from Unit testing through regression, UAT and performance testing

Environment: Oracle 9i, PL/SQL, SQL*Loader, HP UNIX

Confidential 

Oracle Developer

Responsibilities:

• Creation of database objects such as tables, views, database triggers, sequences, synonyms, Partitioning the tables, and indexes.
• Responsible for the creation of Packages, Functions and Procedures
• Performed Testing of the Packages, Procedures and Functions.
• Fine Tuning of the SQL Statements to improve the database Performance.
• Involved in migration from Oracle 9i to Oracle 10g database.

Environment: Oracle 9i, Oracle 10G, PL/SQL, SQL Plus, Designer, Sun Solaris 2.6 UNIX.