SUMMARY

• Over 9+ years of experience in Application Development using Oracle SQL, PL/SQL, and Developer Forms and Reports.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Strong Knowledge on oracle architecture and database design.
• Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.
• Experience in Database design using Normalization and E/R Diagrams.
• Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Good knowledge in using PL/SQL Wrappers to protect the PL/SQL procedures and packages.
• Extreme Use of exception handling methods along with Pragma Exception init in order to associate our own created exception names.
• Experience in using several built - in database packages such as DBMS JOB, DBMS OUTPUT, UTL FILE, and DBMS SQL to name a few.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Expertise in loading data from legacy systems using SQL*Loader.
• Good knowledge in front end development using oracle forms/reports6i/9i/10g.
• Experience in creating master detail forms and adding alerts.
• Experience in deploying forms and reports on the web.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• Experience in developing both web layout and paper lay out reports in various styles based on the user requirements.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Good in creating users and maintaining their roles and responsibilities.
• Experience in writing Technical design documents and developing unit test documents.
• Experience with coding in Core Java, JSP & Servlets and HTML.
• Strong interpersonal skills, ability to interact with people Confidential all levels. Good communication and presentation skills.

TECHNICAL SKILLS

Databases: Oracle 10g/11g/12c, SQL Server, MS Access.

Scripting: SQL, UNIX Shell Scripting, JQuery, AJAX, JSON.

GUI: Oracle Forms 6i/9i/10g and Reports 6i/9i/10g and VBA.

Languages: C, C++, PLSQL, HTML, CSS, JavaScript, CORE JAVA.

Tools: SQL Developer, PL/SQL Developer, TOAD, SQL plus, Aptana, FilezillaWinSCP, Putty, firebug.

Applications: MS Office and MS Visio, MS Excel, MS Outlook.

Operating Systems: Windows 10, Windows 7, Windows Vista, XP, UNIX, Linux.

Versioning Systems: Tortoise SVN and GIT

PROFESSIONAL EXPERIENCE

Confidential - Las Vegas, NV

Oracle PL/SQL Developer

Responsibilities:

• Plan, align respective deliverables, and deliver them according to the client’s Requirements.
• Identify Impacts to the existing system and Map the Changes, align them to current Requirements, and develop according to those requirements.
• Create/Maintain Procedures, Packages, Functions, Indexes, Triggers, and other Database Objects.
• Design and develop PL/SQL packages for transactional data processing in Oracle.
• Identify, Analyze & Resolve Performance Bottlenecks by Tuning, Optimizing Queries, Re-factoring PL-SQL Code / index structures / Partitions.
• Create Ajax Calls and JavaScript for the User Interface and write relative Mod-PLSQL / JS implementations for the same.
• Post Deliverable Support to QA & UAT.
• Analyze existing Business Modules and identify Key innovations that could improve Business.

Environment: Oracle 12c, Mod-PL/SQL, PL/SQL, UNIX, Ajax, Java Script, HTML5, CSS, GIT, AGILE.

Confidential - Charlotte, NC

Oracle PL/SQL Developer

Responsibilities:

• Responsible for transforming the Business requirements into Functional specs and technical design documents.
• Creating and maintaining database objects like Tables, Views, Indexes, Constraints, Sequences, indexes, Triggers, grants and Synonyms.
• Creating packages, procedures, functions to meet the requirements. Maintaining and supporting all the database changes throughout the lifecycle.
• Involved in various data conversions that are necessary for the application using PL/SQL advanced topics like Bulk Collect, For All.
• Involved in writing appropriate Cursors, Ref cursors, Collections, Records for accessing complex data resulted from joining of large number of tables.
• Checking the performance of the overall application and tune the SQL Queries and performance tuning of the database where exactly it is necessary using TKPROF and explain plan.
• Worked with SQL loader, Created control file scripts to dump the data in to the mapping tables and process the data accordingly.
• Involved in writing of packages to handle and process the messages using AQ oracle advanced queues.
• Worked with UTL FILE to write the files. Involved in generating new files, modifying or updating the existing files as needed and monitoring them if they are successful during NOPS/DOPS.
• Worked on the creating custom functions using Excel VBA programming.
• Thoroughly involved in unit testing, creating unit test documents and involve in peer reviews, code reviews, follow ups and status updates to closely monitor the development throughout its life cycle.
• Constantly tracking the defects logged by the testing teams and business using IBM Clear Quest tool and working on the defect fixes through the release.
• Validating all the database changes with validation scripts when the changes are moved to different environments and supporting them.
• Adapt to multiple roles by assisting business teams in Oracle, Java, power builder and mentoring team members.

Environment: Oracle 11g, SQL, PLSQL, PL/SQL developer, TOAD, Windows XP.

Confidential - Grand rapids, MI

Oracle PL/SQL developer

Responsibilities:

• Provided production support and resolved production issues in a timely and efficient manner.
• Responsible for gathering business process information and reviewing functional requirements.
• Interacted with the business users or customers and collected the requirements that are required for solving issues.
• Responsible for design review, unit level testing, Module level testing and Application testing.
• Verified scheduler jobs, logs and weekly report for discrepancies and inconsistencies to ensure accuracy of data in the database.
• Prepared DML scripts as a part of testing various modules that are being modified and also created DDL scripts that are required for the updates on the applications.
• Involved in development of oracle back-end objects like database triggers, Views, Global Temporary tables, DB Links, Sequences and Synonyms.
• Fixing the problems in PL/SQL code and escalating the issues in severe cases to the development and other support teams about possible impact on the application functionality.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKprof, Autotrace and DBMS APPLICATION INFO.
• Involved in Troubleshooting performance issues and bugs within packages and stored procedures using dbms output and explain plan.
• Developed Master Detail reports in Reports 10g to meet the requirements of end users within the system.
• Designed and modified various user interface data entry forms, complex and template forms in Forms 10g.

Environment: Oracle 11g, SQL, PL/SQL, SQL developer, TOAD, UNIX, Perl, Forms 10g, Reports 10g, Windows 7 and SQL Plus.

Confidential - Atlanta, GA

Oracle PL/SQL developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document and prepared data dictionary document.
• Created different schemas and maintained schema objects.
• Creation of new packages and modification of existing codes to resolve application bugs.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.
• Used advanced queuing concept to deque the exceptions raised during the cron job execution which will be notified by mail using UTL MAIL package and enque it into main table for error reprocessing.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Used hints in select statement for improving the performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKprof, Autotrace and DBMS APPLICATION INFO.
• Performed replication testing for the Golden Gate which is used for data replication.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting errors when occurred.

Environment: Oracle 11g, SQL*Loader, SQL, PL/SQL, SQL developer, UNIX, Windows 7, Golden Gate, SQL Plus.

Confidential - Cincinnati, OH

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Created technical design document from the business requirements.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from external files.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Used bulk collections, indexes, materialized views to improve the sql and plsql performance.
• Automated 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 custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Implemented Oracle Advanced Queuing to send messages to JMS sever.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, KORN Shell script, SQL developer, Oracle Forms 10g, Reports10g.

Confidential - Tallahassee, FL

Oracle Developer and Analyst

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created and Modified PL/SQL Triggers, Procedures, Functions and packages.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER etc.
• Developed complex SQL queries, triggers for building reports using Form, form letter and mailing label report styles.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
• Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

Environment: Oracle 10g, Oracle developer suite, PL/SQL Developer, UNIX Shell Scripting, Toad, SQL*PLUS.

Sr. Oracle PL/SQL Developer

Responsibilities:

• Wrote PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL.
• Created database triggers, sequences, stored procedures, and other database objects using Toad.
• Developed data model, PL/SQL Queries, SQL Query tuning process, and Schemas.
• Developed the application using JavaScript, Ajax and XML to make the application work as per Clients requirements.
• Formulated SQL queries, functions and processes as per customization requirement for Oracle APEX.
• Provided Oracle APEX guidance & support to technical staff on application maintenance and SDLC process.
• Designed multiple new features in consolidation application related to Bank app search.
• Created and designed new web pages using HTML5, CSS3, and JavaScript.
• Performed migration of the apex application from development to the UAT for every defect fix and new enhancement.
• Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used various LOVS (List of Values) and record groups Confidential various points in the runtime.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases. Worked on enhancements & defects as per the business requirements.
• Tuned performance using various tools like TKPROF and AUTOTRACE.
• Built new functionality and improve processing time through code optimizations and indexes.
• Did Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions, and DB Triggers.
• Validated the functions and procedures inside the package using the various fields in Oracle APEX.

Environment: Oracle 11g, SQL, PL/SQL, Confidential -SQL/MS SQL, Toad 12, SQL Developer, TOAD Data Modeler, UNIX Shell, SQL *Loader, Oracle APEX 4.2, HTML, CSS, JavaScript, Windows, MS- Excel 2013, notepad++, and Agile.