SUMMARY

• 7+ years of professional experience in IT industry as Oracle PL/SQL Developer, Oracle Forms/Reports Developer.
• Proficient in analyzing the end user requirements and converting them into efficient Technical Solutions.
• Worked in different phases of Software Development Life Cycle which include Analysis, Design, Development, Testing and Implementation.
• Strong Knowledge on oracle architecture and database design.
• Experience in Database design using Normalization and E/R Diagrams.
• Design and Generation of different Database Objects like Tables, Views, Synonyms and Sequences, PL/SQL packages and Database Triggers.
• Excellent SQL skills experienced in writing complex SQL queries using inline views, Analytical functions and Aggregate functions.
• Strong knowledge in Oracle Cursor management, Exception Handling and also experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints and Optimizing the oracle reports.
• Implemented PL/SQL advanced topics like System variables, Ref Cursors, Dynamic SQL, Collections, and UTL FILE to read and write the files.
• Optimized existing queries for better performance and less impact on database.
• Expertise in scripting for automation, and monitoring using Shell, PHP, Python & Perl scripts.
• Expertise in using tools such as SQL*Plus, TOAD, SQL Developer and SQL*Loader.
• Experience in the requirement gathering, product mapping, developing solutions, programming, documentation and defining - executing test plans.
• Excellent presentation, training and documentation skills, Excellence in maintaining communication at par among the stakeholders.
• Quick Learner with the ability to grasp new concepts and apply them efficiently in related work assignments.
• Hard working, aggressive in acquiring new skills, ability to excel under pressure, innovative, self motivated and good problem solving skills.
• Good Communication and Interpersonal Skills, resulting in excellent rapport with employees and executive management.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i, DB2, MS SQL Server, and MS-Access.

Programming Languages: JAVA, PLSQL,SQL, HTML,CSS, C/C++, UNIX Shell Scripting, XML ERP Technology - Oracle Applications; WEB Technology - JAVA

Technologies: Oracle Workflow, HTML JDeveloper, Oracle Reports Developer, Oracle Workflow Builder, TOAD, SQL*Plus

Tools: PLSQL Developer, SQL Developer, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), XML Publisher, VSS (Configuration Management Tool), SVN, BOXI 3.1, JIRA bug tracking

Framework: Oracle Application Framework (OAF)

Utilities: Winscp, Putty, SVN

GUI: Forms/Reports Builder 9i/10g/11g

Operating System: Unix, Solaris, Linux and Windows

PROFESSIONAL EXPERIENCE

Confidential, Roseland, NJ

Senior Oracle SQL, PL/SQL developer

Responsibilities:

• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Implemented Complex business Logic as per the client requirement.
• Writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like SQL* plus.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Developed Reports to extract the monthly sales information.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Involved in testing all forms, PL/SQL code for logic correction. Performed Unit testing on queries and reports.
• Developed User Interfaces (forms 10g )
• Having good knowledge on UNIX operating system.

Environment: Oracle 11g, PL/SQL, TOAD, Forms10g, Reports10g, MS Windows XP/ 7

Confidential, Dallas, TX

Senior Oracle SQL, PL/SQL Developer

Responsibilities:

• Generated weekly, monthly, yearly reports for insurance plans based on the customer’s choice
• Expertise in designing and creation of database objects like tables, views, PLSQL stored procedures, Functions, Packages
• Extensively used Sub-queries and Joins in stored procedures
• Extensively worked on PL/SQL code in creating various versions for different databases and created new code for the new clients as per the requirement.
• Used SQL*Loader to migrate flat files data to Oracle Tables
• Worked with Putty and HP quality center for version control
• PL/SQL extensively utilized to implement the business functionalities
• Involved in enhancing pre-existing code by implementing & closing tickets raised by cross functional team requirements
• Performance Tuning done by using explain plan and query optimization techniques.
• Worked with business group to create the functional requirements
• The database design responsibility included the conceptual data model design using ER diagrams, logical database design and physical implementation of the database
• Made necessary changes to existing Database Objects and added new whenever required
• Created complex database triggers using PLSQL
• Done unit testing and module testing
• Prepared the necessary documentation and design specifications of project

Environment: UNIX, Oracle 11g, PL/SQL Developer, SQL*Plus, Putty, WinSCP, Toad, HP Quality center version control, Work Load control Center.

Confidential

Oracle SQL, PL/SQL developer

Responsibilities:

• Part of the Michelin ERP Backbone team as an Oracle Apps technical consultant. The project was to upgrade Michelin's existing Oracle applications from 11i to R12 e-Business suite and to develop complex inbound and outbound interfaces across the modules.
• Responsible for the understanding of Standard Functionality, working in accordance with the Functional design document and creating Technical design document.
• Designed and developed Database Objects, OAF pages, Oracle Workflows, Oracle reports, and Interfaces, Customized and personalized standard pages
• Responsible for grooming and guiding the team members with both functional and technical aspects of project

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Part of the CRM application team as a software developer/Module Lead/Onsite coordinator. The team customized the CRM application specific to the market users and rolled out the application followed by supporting the application. Team was responsible for handling 32 different markets such as Australia, Belgium, Germany, and Sweden. CRM application was a user interface to maintain the consumer, dealers details associated to the vehicles for Confidential and developed using Java and PLSQL.
• Designed, developed, tested and deployed Database Objects for the Application Enhancements. Analyzed existing PLSQL program that required tuning and modifications
• Involved in Project Management Activities like maintaining and presenting the Project during the Client Visits, involved in creating the Quarterly decks representing the Application Stability needed for upper management.
• Provided weekly and monthly Status reports to Management, published the weekly DASHBOARD for the project.
• Responsible for on time delivery of the releases, responsible for resolution of the tickets within SLA compliance & satisfaction of the users
• Leading the Team at Offshore, providing technical help and guidance to team, to achieve its objectives within the planned time

Environment: UNIX, Oracle 11g, PL/SQL Developer, SQL*Plus, Putty, WinSCP, Toad, HP Quality center version control, Work Load control Center.

Confidential

Oracle Apps Technical consultant

Responsibilities:

• Part of the Ultimatix Self Service team as an Oracle Apps technical consultant/ Software Engineer. We developed a browser based Self Service application of the Project Accounting Form based version that provided a better interface to Project Accounting users with business specific help page and tips. Automated and streamlined manual activities such as credit notes approval and generation
• Developed OAF pages, Oracle Workflow, database objects and customized, and personalized standard solution. Involved in Unit Testing and Integration testing
• Trained team members on Oracle Application framework, Oracle Workflow, PLSQL, Organized training on new interface for users resulting in smooth transition of application.

Environment: Oracle 9i/10g, Developer/2000 (Forms 6i, Reports 6i), PL/SQL, SQL*Plus, TOAD, Reports, SQL *Loader, WINDOWS, MS Office