SUMMARY

• Around 7 Years of Experience as an Oracle PL/SQL Developer with Proficiency in Oracle 11g/10g/9i/8i, SQL, Oracle PL/SQL, Oracle Form Builder 10g/9i/6i, Report Builder 10g/9i. Software Development Life Cycle (SDLC) involving Design, Development, Integration, Implementation and Testing of applications in Client/Server, N - tier Architecture based on Microsoft .NET technologies and SQL Server.
• Expertise in VB6.0,VB.Net, C#.Net Application programming along with Hands on Experience in writing Complex Stored Procedures in T-SQL under SQL 2005/2008 Server, Oracle 10g/11g.
• Well versed at coding program using different databases as back-end and other Languages for user interface and reporting tool like Crystal report, Visual Basic 6.0/ VBA, Macros using MS Excel and MS Access/SQL Server, ORACLE for back-end for a new system development or system modification for a new change request.
• Experience in designing developing application using PERL.
• Experienced in all aspects of Software Development Life-Cycle(SDLC) from inception to delivery including requirements gathering, use cases, functional specification, design, estimation, implementation and debugging, documentation and maintenance.
• Expertise in creating PL/SQLpackages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migratecomplex data sets in Oracle Databases.
• Extensive experience in business and systems Developer roles identifying problems and/or opportunities and defining solutions through direct involvement in all facets of the software development project lifecycle and thorough experience in client interaction.
• Worked with query tools like Toad, SQL*Plus, PL/SQL Developer,Sql Developer.
• Enforcing experience in data integrity using integrity constraints and database triggers.
• Expertise in handling errors using Exceptions.
• Experience in creating Materialized Views and DB links.

TECHNICAL SKILLS

Languages: C#, Visual Basic, PL/SQL,VB.Net,Perl

Databases: SQL Server, Oracle 11g/10g/9i/8i, MYSQL

Oracle Tools: SQL developer, TOAD, SQL * Loader, SQL*Plus, PL/SQL Developer,Oracle Forms and Reports 10g/9i/6i, ireports(D2K), PVCS and kintana

.NET Platforms: .NET Framework (2.0,3.5,4.0,4.5)

Version Control: Microsoft Visual Source Safe (VSS)

Reporting: Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed Perl and Shell scripts for upload of data feed into database.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed Oracle Scripts, Packages, triggers, Function and Procedures for Business rules check to implement business rules.
• Developed and implemented the new flow of Component trades which includes loading the feed file in Perl/Unix shell.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Reports as per management requirements and making them web enabled using Oracle Reports builder 6i and Oracle Forms builder 6i respectively.
• Archived many applications in the existing system and retrieval of necessary data from them. reformed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF,
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used ORACLE sql DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL* Loader, Oracle Reports 6i, TOAD, Windows 7, UNIX, Perl, Agile SCRUM.

Confidential, NC

Oracle PL/SQL Developer

Responsibilities:

• Worked as Oracle Developer performing data analysis and data conversion. Developed custom reports.
• Gathered the requirements from the business users, analyzed and translated into detailed technical specifications.
• Written complex SQL queries and developed PL/SQL Stored Procedures, Functions, Packages, Triggers, Materialized Views.
• Tuned the SQL queries to improve performance.
• Responsible for enhancement of standard and custom reports using Oracle Report Builder.
• Created UNIX Shell scripts for scheduling periodic load processes.
• Created control files for data loading. Used SQL loader tool to load the data.
• Did unit testing of customizations.
• Responsible for the technical and user documentation of the customizations.

Environment: Oracle 9i,10g,11g, Oracle Enterprise Manager, Oracle Grid control,, C#.Net, RHEL, HP-UX, HACMP, PL/SQL, AIX, Citrix, DBArtisan, TOAD, SQL *Plus, SQLServer 2005, 2008R2, SSMS, Tortoise SVN

Confidential, San Jose, CA

Oracle PL/SQL Developer

Responsibilities:

• Worked with Business Analysts to understand the Business requirement details.
• Did technical analysis for deciding the approach to implement these requirements using Oracle database as backend.
• Designed and modified the Data Model to add new Tables and modify existing tables as per new business requirements in the Project.
• Created new database objects such as Tables, Views, Indexes, Sequences, Grants and Synonyms, DB Links as per the requirement.
• Did designing and development of new PL/SQL Code as well as enhanced the existing PL/SQL Code which involved creating new PL/SQL Packages, Functions, Data types and Objects.
• Worked on setting up new database schemas in Development environment.
• Created PL/SQL Cursors, Ref Cursors.
• Did Exception/Error Handling using Named and Un-named Exceptions and defined Exceptions.
• Performed Unit Testing of developed code.
• Did performance tuning of SQL queries and PL/SQL scripts with help of oracle tools like explain plan.
• Worked with Quality Analysts to identify the defects existing in already developed PL/SQL code and fixing the bugs to work as per business test cases.
• Assisting junior perl developers in the development of script.
• Created Kintana Packages and lines for Production Code Release.
• Offshore team Co-Ordination.
• Prepared Technical and Release documentation.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, PVCS,C#.Net, Perl, Kintana, Windows 7, MS office.

Confidential

Developer

Responsibilities:

• Involved in Complete development, maintenance, and integration of Pipe, Glass and Transport Industry base ERP.
• Involved in Complete development and integration Infrastructure inventory management system.
• Gathering the functional requirements from users and converting them into Technical requirements.
• Perform gathering requirements, design high level and low level design documents.
• Design and implement presentation layer and Sql server and Oracle backend database.
• Experience in designing & creating databases in Oracle 10g.
• Created complex database packages, procedures, functions, triggers, views, materialized views using Oracle, SQL and PL/SQL.
• Optimize and test the final product and implement at user side (Ametek Process Instruments - THERMOX, Kopp Glass Inc., Art and Glass EVERGREEN, FUSO, TPRS, GLAXY etc...).
• Used SQL* Loader and export/import mechanism for data migration for bulk upload.

Environment: SQL Server 2005, Oracle10g, TOAD, VB, Visual Studio 2010, C# .net, Crystal Reports.