Professional Summary

• Over 8 years' experience as a Software Programmer and Oracle PL/SQL Developer/Programmer in Application Development and Production Support.
• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Strong in using tools such as TOAD, Benthic, SQL Plus, SQL Developer and SQL Loader.
• Experience using Bulk processing, ETL operations using ODI Oracle Data Integrator , REF cursors, collections, DBMS packages.
• Extensive experience in Analysis and Design of Database. Created ER Diagrams on ERwin, Microsoft Visio.
• Experience in schema structure design and involved in estimation and optimization of data storage.
• Experience in utilizing External Tables, merge statement, Pipelined functions.
• Expert in Performance Tuning Query Optimization of SQL statements using EXPLAIN PLAN, SQLTRACE, TKPROF, HINTS, Index.
• Comfortable with working with Composite Data Types.
• Experience in Debugging, Testing, and Deploying the Applications.
• Experience in different phases of Software Development Life Cycle which include Analysis, Design, Development and Testing.
• Developed business Reports using Cognos, APEX
• Successfully utilized performance enhancements features of Oracle to optimize the batch processes.
• Strong technical aptitude, ability to rapidly assimilate and design practical applications of new technology.
• Good team player and ability to work independently.
• Excellent logical and analytical skills, enthusiastic, excellent interpersonal communication skills.
• Commitment to excellence proven by an outstanding career track.

Technical Skills

• Databases: Oracle 10g/11g, SQL Server, MS-Access.
• Database Tools: Toad, Oracle SQL Developer, SQL Plus, Benthic.
• Reporting Tools: Cognos 8.0
• ETL Tools: ODI 11.x, Informatica 7.x, 8.x, Datastage
• OS: Windows 7, Windows XP professional.
• Unix: Putty, WinSCP
• Web Design Tools: Adobe Dreamweaver CS3, Eclipse, XML, Notepad.
• Management Tools: MS Project 2007, Visual Project Maps, HP PPM, DAPtiv.
• Documentation: MS Office 2010.
• Other tools: Microsoft Visual Studio 2003/2005, Microsoft Visio.

Professional Experience

Confidential

Role: Sr. Oracle PL/SQL Developer

Software: Oracle 11G, Oracle SQL Developer, Subversion, Tortoise SVN, UNIX, Sharepoint, Agent Ransack.

Responsibilities:

• Attended weekly meetings and interacted with client to gather business requirement.
• Performed extensive requirement analysis using source to target mapping documents.
• Created external tables to load data from various files supplied by data supplier.
• Created tables, constraints, indexes and synonyms
• Created oracle pl/sql packages, procedures, functions, triggers, cursors.
• Used Bulk processing to load large data. Used Bulk collect collections and FORALL
• Wrote complex Oracle SQL code containing materialized view logs, analytical functions, Regular expressions, sub queries, joins, dblinks to publish data from source to target.
• Worked with Architects, Lead Developers, DBA's, and end users in specifications, design, development, testing and implementation of the project
• Performed performance tuning by analyzing query plans. Suggested partitions, index, optimizer hints, multi-table inserts.
• Used scheduler to run chain of jobs based on dependency.
• Strong unit, integration and system testing skills.
• Played Major role in the planning, testing, and implementation of system improvements and conversions.
• Identified bugs and logged them for tracking and auditing purposes.
• Performed End-to-End testing on the release version using Subversion.

Confidential

Role: Oracle PL/SQL Developer with ODI oracle data integrator

Team Size: 30

Responsibilities:

• Preparation of documentation Business functionality, Process, Technical system Design
• Performed extensive requirement analysis including data analysis and GAP analysis
• Performed moderately complex development tasks following SBS system development life cycle.
• Created data models/mappings/packages/Scenarios/load plans in Oracle Data Integrator, wrote underlying Oracle SQL code containing views, analytical functions, Regular expressions, sub queries, joins, flashback tables, dblinks to publish data from source to target.
• Created tables, constraints, indexes, sequences, synonyms
• Created oracle pl/sql packages, procedures, functions, triggers to load data from legacy database to raw tables.
• Worked with Architects, Lead Developers, Data Analysis, DBA's, and end users in the specification, design, development, testing and implementation of publishing services
• Researched and understood the business and technical requirements for a publishing process/system, including target environment and performance criteria suggested technical approaches to management on projects
• Major role in the planning, testing, and implementation of system improvements and conversions.
• Involved in code review.
• Strong unit, integration and system testing skills.
• Developed steps for Unit Testing and Test scenarios / Test Plans with QA Team
• Performed End-to-End testing on the release version using AccuRev for the software application and detected track bugs using JIRA.
• Identifying the bugs and logging them for tracking and auditing purposes
• Used to APEX for reporting.

Confidential

Role: Oracle PL/SQL Developer

Team Size: 12

Software: Oracle 10g, Toad, Cognos 8.0, VAX, Jira.

Responsibilities:

• Involved in requirement gathering and analysis phase.
• Created Database Objects such as indexes, functional based indexes, sequences, synonyms, views and materialized views.
• Developed PL/SQL packages, stored procedures, functions and triggers to business requirements.
• Extensively used oracle collections like nested tables and associative arrays.
• Utilized Oracle's bulk processing techniques like Bulk Collect and FORALL.
• Conducted extensive performance tuning using Explain Plan and TKPROF utilities.
• Excellent is using Oracle Analytical functions.
• Wrote Pipelined functions to migrate data from the External files into the oracle Database.
• Utilized Dynamic SQL to build SQL statements dynamically at runtime.
• Sub-queries and joins were extensively used in stored procedures.
• Analyzed the whole process flow, PL/SQL packages, log files, error files, locations and descriptions.
• Involved in Code Review and User Acceptance Testing UAT of the application.
• Tested new enhancements and fixed various bugs before Deployment into the Production environment.
• Developed business Reports using Cognos 8.
• Creating automated jobs to perform the task using VAX.
• Involved in preparing System documentation such as Technical Specifications, functional specifications, release notes, Unit Test Plan, Data Flow Diagram using MS-Word, Visio and other documentation.
• Understanding the process and Interacting with functional team to resolve the issues in the given objects.
• Used Jira to manage task and to view project deadlines.

Confidential

Role: Oracle PL/SQL Developer

Team Size: 20

Software: Oracle 9i, SQL Developer, Informatica 8.1, UNIX, Putty, WinSCP, CA Workflow Automation Tool, HP Overview Service Desk, Version Control Tool PVCS , HP PPM.

Responsibilities:

• Created Database Objects such as indexes, sequences, synonyms, views and materialized views.
• Developed PL/SQL packages, stored procedures, functions and triggers to business requirements.
• Conducted extensive performance tuning using Explain Plan and TKPROF utilities.
• Involved in the Analysis and Data Modeling of Logical to Physical data models.
• Wrote Pipelined functions to migrate data from the External tables into the oracle Database.
• Analyzed the whole process flow, log files, error files, locations and descriptions, PL/SQL packages, process codes and descriptions.
• Developed various reports using UNIX.
• Involved in Code Review and User Acceptance Testing UAT of the application.
• Tested new enhancements and fixed various bugs before Deployment into the Production environment.
• Creation of incidents using HP Overview Service Desk.
• Creating automated jobs to perform the task using CA Workload Automation.
• Involved in creating System documentation such as Technical Specification, Unit Test Plan, System Flow Diagram and Data Flow Diagram using MS-Word, Visio.
• Involved in preparing functional specifications, release notes and other documentation.
• Used HP Project and Portfolio Management Center module to manage task and to view project deadlines.

Confidential

Role: Software Developer

Team Size: 10

Software: SQL Developer, Benthic, Siebel, Argus safety 6.0, Windows XP, Lotus Notes and MS Office.

Responsibilities:

• Developed various PL/SQL packages, procedures functions tailored to business requirements.
• Involved in the process of creating database objects such as tables, views, materialized views, synonyms, indexes and sequences.
• Worked on ER Diagrams ERD , Data flow diagrams based on the requirement.
• Extensively worked with Ref Cursors to support .Net code.
• Used Dynamic SQL to create procedures to match required functionalities.
• Successfully utilized performance enhancements features of Oracle to optimize the batch processes.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Used Pre Post Stored Procedures for Source/Target to perform additional checks before loading the data with respect to table size check and recreating indexes.
• Involved in extensive server side and client side validations.
• Involved in the continuous enhancements and fixing of production problems.