SUMMARY

• 7 years’ experience in Oracle Database Development, Database Maintenance, Coding, Design, testing Methodologies and Production Support.
• PL/SQL: 7 years of back - end programming experience using PL/SQL, SQL, T SQL, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes
• Databases: Oracle 11g/10g/9i, MS Access 7.0.
• Knowledge of data modeling techniques includes virtually every flavor of Entity-Relationship (ER) modeling, Physical and Logical data modeling
• Strong exposure in writing simple and complex SQL, PL/SQL Functions and Procedures, Packages, Triggers, Materialized views etc
• Experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production
• Proficient in requirements gathering and analysis, validation, Business Requirements Specifications and Functional Specifications.
• Expertise in using Oracle 10g/11g enterprise edition
• Proficient in query optimization and effective database management of different Databases
• Strong exposure in writing simple and complex SQL, PL/SQL Functions and Procedures, Packages, Triggers, Materialized views etc.
• Excellent skills in design and development of applications using Oracle 10g/9i, SQL, PL/SQL
• Strong team player with excellent communication skills.
• Working knowledge of data modelling using ERWIN.
• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.

TECHNICAL SKILLS

Tools: TOAD, Pl/SQL developer, SQL * Plus, SQL Developer, SQL Loader

Databases: Oracle 11g/10g/9i.

Programming: SQL, PL/SQL, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Worked in Agile methodology for the implementation of the project.
• Gather requirements from business analysts and implement the requirements.
• Write PLSQL code wrapper scripts in UNIX shell for code deployments in various environments and extensive use of UNIX shell scripting for creating and data sourcing and loading.
• Use various techniques like SQL LOADER, and UTL FILE concepts to load feeds from flat files into the tables from source systems.
• Involve in designing data models for reporting team using ERWIN.
• Implement business functionalities in PLSQL (packages, stored procedures, functions etc.).
• Extensive use of SQL analytical functions for creating business reports.
• Involve in table redesigning with implementation of Partitions Tables and Partition Indexes to make Database Faster and easier to maintain.
• Use standard packages like UTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKCOLLECT in writing database procedures, functions and packages.
• Create builds to promote code to higher environments using clear case .

Wells Fargo Bank, Charlotte, NC

PL/SQL developer

Roles and Responsibilities

• Made enhancements in stored procedures and functions to implement business functionality.
• Worked on creating stored procedures and functions.
• Involved in SDLC documenting process.(Documenting code changes and unit testing results in SDLC document)
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases
• Extensively used cursors in the procedures and functions.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring
• Working knowledge of Autosys.
• Worked on enhancements and bug fixes.
• Prepared and updated design specifications.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.

Environment: Toad, PL/SQL, oracle 11G, Autosys, SVN, SQL Developer

Confidential, New York, NY

PL/SQL developer

Responsibilities:

• Analyzed the current system and the modules it offers to understand the high-level process.
• Acted as a PL/SQL developer in P1 DST project and in RRG P1 project
• Worked with Business Analyststo do detailed business analysis and make workflowson the various risk factors (common factor risk, specific risk, total risk, value at risk) and the calculation models.
• Validating the data at the database using SQL Worksheet, PL/SQL Developer
• Created the shell scripts and the jobs in autosys for the BAU functioning of the project.
• Documented detailed Business Requirements (BRD) for the enhancements required by the business in the existing modules and the new features required.
• Worked on Data Mapping for the external feed.
• Collaborated with PMO in developing Project Plans, doing business analysis, preparing Business Requirements Document, Functional Specification Document and Testing during SDLC/RUP.
• Conducted sessions with the developers to discuss the feasibility of various requirements.
• Interacted with the offshore team regarding FRD as needed.
• Created SQL queries for technical analysis of data.
• Facilitated UAT to guarantee accurate and required functionality.
• Assisted in preparing user manual and providing demos to end-users.

Environment: Toad, Abinitio, PL/SQL, T-SQL, oracle 11G, perl/shell script, sybase

Confidential, MD

PL/SQL Developer

Responsibilities:

• Write Technical Specifications based on business requirements to provide account level financial summary reports to the business customers
• Perform Data Mapping and develop ETL Specification documents
• Develop ETLs using PL/SQL in Oracle 10g & 11g to extract, transform and load data from OLTP into Warehouse
• Utilized PL/SQL nested tables for conditional trafficking of data within ETL process.
• Massaging & filtering of data by developing reusable PL/SQL functions
• Performance tuning using Oracle Hints and Result caching where appropriate.
• Utilized PL/SQL bulk collect feature to optimize the ETL performance.
• Develop Korn shell scripts to set up batch jobs on Unix Solaris 10 server.
• Developed frontend interfaces with mod-pl/sql
• Document application from a technical maintenance point of view and host a knowledge transfer session.
• Maintain and Enhance Oracle PL/SQL batch process for claims based billing and reporting system
• Debugging Production issues using Toad 9.7 debugger
• Used SQL Trace and TKProf for analyzing performance issues
• Perform Root Cause Analysis to identify and deploy bug fixes
• Prioritize Recurring productionissues for permanent solutions using Pareto Analysis

Environment: Oracle 10g, 11g, SQL, PL/SQL, Toad 9.7, SQL Developer, SUN Solaris, CVS, PVCS, Mod-PL/SQL, UNIX Scripting

Confidential, Culver city, CA

Responsibilities:

• Designing and preparing technical documents after analyzing functional requirement documents.
• Coding and development of packages in packages, procedures, cursors, tables, views andfunctionsas per the business requirements.
• Unit Testing.
• Supported QA and resolved the defects raised by QA.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions.
• Written complex SQLs using joins, sub queries and correlated sub queries.
• Handled errors using system defined exceptions and user defined exceptions.
• Involved in creating INDEXESto avoid the need for large-table, full-table scans for fast retrieval of data from database objects.
• Used Collectionsfor accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching

Confidential, San Jose, CA.

Responsibilities:

• Coding and development of packages in PL/SQL using advanced concepts (10g).
• Unit Testing.
• Supported QA and resolved the defects raised by QA.
• Playing an active role in preparing Quality documents like technical documents, Defect Tracking Form and Issue Log etc.
• Involved in creating database objects like like tables, views, procedures, functions and packages using Oracle.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Written complex SQLs using joins, sub queries and correlated sub queries.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages, procedures, cursors, tables, views andfunctions.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Involved in creating INDEXESand performance tuning.

Confidential, SanJose, CA.

Responsibilities:

• Developing SQL and PL/SQL scripts for problem solving.
• Generating reports using Report builder.
• Developing Shell Scripts.
• Establish onsite/offshore communication between onsite users and offshore project teams.
• Tracking and ensuring timely deliveries as per SLAs committed to the client.
• Interacting with the client and project teams to ensure issue resolution and to provide technological and business solutions to the clients.
• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, PL/SQLandTOAD.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Used Ref cursorsandCollectionsfor accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Confidential

Responsibilities:

• Have done research on Service providers in different fields like education, medical, healthcare, business etc.
• Analysis of the specifications provided by the clients
• Design and Development.
• Created the Table structures.
• Database management
• Coding database manipulations, Stored Procedure changes and creating new stored procedures in Oracle.
• Unit testing.
• Involved in Logging and Tracking the defects