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.
• Experience in implementation, customization and migration of Oracle 10g, 6i Forms, Reports, Workflow, Conversion and Interface.
• 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 creating packages in COGNOS framework manager and reports using COGNOS report studio
• Experience in scheduling jobs using shell scripts and cronjobs

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, SQL Server 2005/2008, MySQL, Oracle 10g, 6i Forms

Oracle Software: TOAD, SQL*PLUS, SQL Developer, Oracle 9i/10g/11g, SQL Assistant, Forms, Reports, 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++, Pro *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, Detroit, MI

Oracle Developer

Responsibilities:

• Understanding of the Functional specifications, based on that prepared design documents.
• Developed and created various scenarios for testing the code.
• Designed and Implemented Table Partitioning for a quick data retrieval
• Enhanced and developed the customer search form with additional features using oracle forms
• Worked in 3 - tier architecture where Oracle forms is the front end, Tuxedo as middle tier and Oracle database as backend
• Wrote Pro *C code for handling the middle tier (Tuxedo) data connecting Oracle Forms and Oracle database
• Maintained large Packages, Procedures, Functions, Views, Triggers
• Developed SQL scripts for data load.
• Utilize tools like TOAD, SQL Developer, Putty, Win SCP, Clear case, Oracle Forms during development of the application.
• Use existing Stored Procedures, Functions, SQL statements and Packages for developing and enhancing the requirements using TOAD.
• Design new canvases, develop code and test the functionality.
• Maintained Unix shell scripts and running the required batch jobs
• Involved in code fixes, unit testing and documentation

Environment: Oracle 11g, Oracle Forms 6i, SQL, PL/SQL, SQL*PLUS, TOAD, SQL Developer, Pro*C, SQL*Loader, UNIX, Win SCP, Putty, MS Office, Clear Case, Quality Center, IBM Notes .

Confidential, Detroit, 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
• Performance tuning and PL/ SQL tuning
• Used TKPROF SQL scripts to monitor the performance.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Designed and coded UNIX shell scripts to schedule ad-hoc PL/SQL procedures
• Extensive experience in working with different FTP clients such as IpSwitch, winSCP for extracting data from sources to own destination.
• Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Worked on COGNOS to create packages using Framework manager and publishing to Cognos Report Studio
• Designed templates in Cognos Report studio and created reports using packages and manually writing queries in Query Explorer - SQL Query
• Loading of data from external systems using SQL*LOADER
• Worked on FOTA escalations for the GAA application
• Worked on different external modules like EPS, EPW, EPM, VHM, ECC, Radio, Battery Drain issues

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.
• Developed customized application using Oracle Forms and Reports
• Created inbound, outbound interfaces and Conversions for core modules of oracle Application
• 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.
• 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, 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), Bulk collect 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.
• Created and enhanced various reports using SSRS.
• Designed and developed SSIS packages
• Created SQL Reports using SQL Server 2008/2005
• Wrote stored procedures to implement complex business rules. Also used Triggers, Views, Lists.
• Developed standalone application to generate monthly report for open Items and created Manual
• Planned, Designed and Implemented Table Partitioning for improving performance.
• Performed unit testing and regression testing of the application.

Environment: SQL Server 2008, SSIS, SSRS, PL/SQL, Oracle 11g/10g, SQL* plus, TOAD, Windows 2007, Windows server 2003, MS Office, 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.