SUMMARY

• Around 7+ years of total experience as an Oracle PL/SQL developer with design, development, and testing of business applications such as OLTP, OLAP, Enterprise, web based, Client/Server architectures.
• Worked extensively on technologies like Oracle 9i/10g/11g, SQL, PL/SQL.
• Expert in Oracle Import/Export utilities, Oracle SQL* Loader, SQL Navigator, SQL Developer, SQL*Plus, TOAD, PL/SQL Developer, ETL Process and Data Migration, SQL Server Integration Services (SSIS).
• Worked on export/import commands to move the structure and the data from development to production.
• Expertise in creating stored procedures, functions, packages, collections and bulk collections using PL/SQL.
• Assisted DBA in performing various DDL works like Creation of Schemas, tables, Indexes, Materialized Views, and Partitioning tables.
• Worked on Oracle 10g Enterprise manager and Configured Listener and Network configuration.
• Worked in Agile Methodology.
• Experience in designing ER diagrams, logical and physical Data Models, Use Case/Class/Sequence diagrams using tools like MS Visio, Power Designer and ERWIN.
• Deep understanding of Software Development Life Cycle (SDLC) and implemented various models like Waterfall model, Agile model.
• Interacted with Clients, Project Managers to gather the Business Requirements and developed the technical specification document.
• Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.
• Experience in COGNOS for reporting
• Experience in scheduling jobs using shell scripts and cronjobs

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, SQL Server 2005/2008, MySQL, Microsoft Access

Oracle Software: TOAD, SQL*PLUS, SQL Developer, Oracle 9i/10g/11g, SQL Assistant, TKPROF, EXPLAIN PLAN, SQL*Loader, Export, Import

Other Software’s: MS Visio, MS Project, MS Office

Scripting: HTML, XML, CSS, Korn & Bourne Shell Scripting

Languages: SQL, PL/SQL, C, C++

Other Tools: COGNOS, Quality Center, Win SCP, Putty

Operating systems: Windows 2007/2003/2000/ XP/NT/98, Enterprise Redhat Linux, Unix

Methodologies: SDLC, Agile, Iterative and incremental

PROFESSIONAL EXPERIENCE

Confidential, MI

Pl/Sql Developer

Responsibilities:

• Worked on VSMS - Vehicle Services Management System
• Attend daily stand ups to update the status of the work flow and get new requirements
• Reflash the vehicles with the latest software version for different modules
• Upload the software package in VSMS and validate the enrollment process and success rate
• Retrieve the VINs from database according to the requirements to enroll in VSMS
• Monitor the enrollment process, status of the vehicle reflash process
• Trouble shoot the failed VINs while enrolling, Reflash failed VINs
• Created tables for various projects to load millions of records
• Experience in creating pl/sql procedures according to the requirements
• Handled performance tuning for the SQL queries
• Expert in COGNOS for reporting and distributing the data to the team
• Developed shell scripting for running the procedure and scheduling using cronjob
• Used WIN SCP for creating directories, folders, files and file transfer
• Worked on Putty to login to UNIX and run the shell scripts
• Worked on FOTA escalations for the GAA application
• Worked on different external modules like EPS, EPW, EPM, VHM, ECC, Radio, Battery Drain issues
• Wrote SQL Queries to retrieve various data requirements

Environment: SQL Developer, TOAD, MS Office, Putty, WIN SCP, COGNOS, UNIX, ORACLE 11g, PL/SQL

Confidential, New York

Pl/Sql Developer

Responsibilities:

• As a developer responsible for analysis, requirements gathering, documentation of functional/technical specifications, development, testing, and production support.
• Depending on the functionality, Created different database objects like Tables, Constraints, Procedures, Functions and Packages.
• Involved in the design, development, debugging, testing, documentation, maintenance and supporting the Privacy application.
• Writing high quality and well documented code according to standards.
• Resolved many of the existing and new bugs in the whole application and added new functionalities to the application.
• Developed complex SQL queries using Joins, nested queries, Set operators, in line Views, Analytical functions, Regular expression, in built Packages, Functions and clauses.
• Involved in the data migration to publish the Accounts in Operations processing platform systems.
• Analyzed code, DML actions to perform production support.
• Worked on the database where replication occurs using oracle streams.
• Created Indexes on Tables, columns to minimize query time and for better performance.
• Responsible for making decisions on coding standards and documentation.
• Preparing documentation for requirements, design, install and Unit testing.
• Developed an effective Error Mechanism for the application using pl/sql routine to send automated emails, created Error-Log Tables and used Autonomous transactions.
• Analyzed and rectified bugs reported during System Testing and User Acceptance Testing and postproduction support.

Environment: SQL, PL/SQL, Oracle 11g, SQL* plus, TOAD, Windows 2007, MS Office, UNIX, Putty, HP ALM/Quality Center 11, Cognos, Informatica

Confidential, New Jersey

Pl/Sql Developer

Responsibilities:

• As an Oracle developer responsible for analysis, requirements gathering, data mapping, development and testing.
• Created several database objects like Tables, Views, Triggers, Packages, Procedures and functions.
• Used complex SQL queries to accomplish the functionality of the project.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Developed the PL/SQL applications using advanced features like Native dynamic SQL (NDS), Bulkcollect and INDEX BY TABLES.
• Modified and debugged several SQL queries and PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and HINTS.
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and for better performance.
• Created Shell script to load data from the flat files into database tables.
• Planned, Designed and Implemented Table Partitioning for improving performance.
• Performed unit testing and regression testing of the application.

Environment: SQL, PL/SQL, Oracle 11g/10g, SQL* plus, TOAD, Windows 2007, Windows server 2003, MS Office, Tortoise SVN, UNIX Shell Scripting, Linux, and Solaris.

Confidential

Pl/Sql Developer

Responsibilities:

• Developed complex applications usingPL/SQL,OracleForms and Reports to suit business needs
• Responsible for creating stored procedures, packages, functions and triggers.
• GeneratedPL/SQLpackages with dynamic SQL queries as per the requirements.
• Successfully created various Database Objects such as temporary tables,PL/SQLtables, views, materialized views, Indexes, sequences.
• Performed Database Application Level Tuning and Coordinated directly with the end users to understand the Business Requirements and convert them into functional and technical specifications.
• Proved to be a responsible resource to handle performance tuning of SQL queries andPL/SQLstored procedures using Indexes and optimizing hints.
• Drew ER - diagram and workflow chart for better understanding.
• Extensively used theOracleutilities such as Export/ Import, SQL*Loader, SQL Trace, TKPROF and day-to-day activities of different databases.

Environment: Oracle 10g, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, Oracle SQL Developer, SQL*Plus, SQL*Loader, TOAD.