Oracle PLSQL Developer Resume

Summary

• 7 years of programming experience as anOracle SQL, PL/SQL Developerin Analysis, Design,Data Modeling(Logical and Physical) and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Strong knowledge in front-end development usingOracle forms/reports6i/9i/10g.
• Strong Knowledge onOracle architectureanddatabase design.
• Have a strong knowledge on Dataware-housing concepts and implementation using Oracle ware housing.
• Experience in creatingstored procedures, PL/SQL Packages, TriggersandFunctions. Strong knowledge in Oraclecursor management and exception handling.
• Expert in creatingViews, Stored Procedures, effective functionsand appropriateTriggersto facilitate efficient data manipulation and data consistency.
• Excellent conceptual knowledge of Oracle 9i/10g, PL/SQL.
• Hands on experience indesign, developmentof end user screens and reports usingForms and Reports 9i and Oracle Developer Suite 10g.
• Experience in deploying forms and reports on the web.
• Expert knowledge in using data modeling tools likeERWIN and ER diagrams, Normalization Techniques for designing database with Relational technology.
• Extensive experience in developingUNIX Shell scriptsand scheduled jobs on UNIX server using Crontab utility.
• Expert in using PL/SQL advanced topics likeSystem variables, Ref Cursors, Dynamic SQL, Collections, UTL_FILEto read and write the files.
• Expertise in DatabasePerformance TuningandOptimization of SQLstatements usingOracle Hints, Explain plan, Tkprof, SQL*TraceandTable partitioning.
• Experience in retrieving data from external data Files and loaded into oracle tables using tools likeUTL_FILE, SQL*Loaderand External Tables.
• Experience in troubleshooting various aspects of the client/server architecture in both UNIX and Oracle setting.
• Identified several SQL and PL/SQL bottlenecks using PL/SQProfiler(packageDBMS_PROFILER),explain plan, auto trace.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Strong interpersonal skills, ability to interact with people at all levels.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities. Able to explain technical concepts and communicate with users and system administrators at all levels.

Education

• Bachelors in Technology from Dr. MGR University, INDIA.
• OCAOracle 9i Certified Associatein 9i SQL/PLSQL 1Z0-007 Certification.

TECHNICAL SKILLS

Programming Languages

C, C++, SQL, PL/SQL

Markup Languages

HTML, XML

Databases

Oracle 11g/10g/9i, MS ACCESS

Data Modeling Tools

ERwin, ER Studio, SQL Developer Data Modeler, Visio

IDE

SQL*PLUS, SQL worksheet, iSQL*PLUS, TOAD, PLSQL Developer, SQL Developer, SQL Navigator

Source Control Software

Visual Source Safe, Clear Case, CVS

Other Tools

Microsoft office suite, Microsoft Visio

Operating Systems

UNIX (Solaris/HP-UX), Windows Server 2000/2003

PROFESSIONAL EXPERIENCE

Operating System:

Windows XP/NT/2000,98/95, DOS, Unix, Linux

DBMS:

SQL, PL/SQL, Triggers, Stored Procedures and functions, Standard Packages, SQL*Plus, SQL*Loader, Import/Export, Performance tuning.

Development Tools

Oracle Forms, Oracle Reports,Crystal Reports

Tools Used:

Oracle 8i/9i/10g, SQL Developer, Toad, Designer 6i, SQL Navigator ,ERWIN, Excel, Access, Sql Server 2005

Scripting:

Unix Scripting ( sh, csh, ksh and bash)

Professional experience:

Client: Confidential, Richfield, OH Nov’11- Present
Role: Oracle PL/SQL Developer
Description:Confidential business solutions have individual and institutional customers worldwide. It offers a variety of products and services. It is one of the largest hardware company, based on tools. It is one of the most admired companies in United States of America. The order management dashboard is the tool used by GM project Managers and customer care agents to check the status of multiple customer orders. Using this dashboard, customer care agents were able to track and manage order status of all customer purchases with visibility from order to delivery in a near real-time manner.

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Createdcustom PL/SQLprocedures to read data from flat files to dump into Oracle database using SQL * Loader.
• DevelopedPL/SQL Proceduresanddatabase triggersfor the validation ofinput data and to implementbusiness rules.
• Created database objects likepackages, procedures, and functions accordingto the client requirement.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools like EXPLAIN PLAN,TKPROF, SQL TRACE and DBMS_SQLTUNE.
• Worked withBulk Collectsto improve the performance of multi-row queries by reducing the context switching.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Used bulk processing forbetter performanceand easy retrieval of data, being a part of performance tuning of the procedures and packages.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL_FILEpackage.
• Creation of database objects like tables, views, materialized views, procedures, packages using oracle tools likeSQL developer.
• Implemented several triggers to maintainDatabase Securityby auditing log table to track information about users and to know which user is doing what operation.
• Created database links to retrieve data from multiple servers.
• Extensively usedForallandBulk collectto fetch large volumes of data from table.
• Created and run batch files on regular basis.
• Createdrecords, tables, collections(nested tables and varrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous_Transactionto avoid mutating problem in database trigger.
• Wrote complexSQL queriesincluding sub queries for fasterdata retrievalfrom multiple tables.
• Extensively used the advanced features ofPL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Created and modified severalUNIX shellScriptsaccording to the changing needs of the project and client requirements.
• Used the standard Oracle packageDBMS_SCHEDULERto automate/schedule jobs on daily, weekly and monthly basis andto run jobs in parallel to improvetime-constrained performance.
• Designed, developed and tested Forms and Reportsas per client requirements and making themweb enabledusing Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Involved in the development of forms using various canvases like content, stacked, tabbed, horizontal and vertical toolbar and using appropriate triggers as required by the application.
• DevelopedList of Values, Record Groups, and triggers for different data blocks to improve the functionality of the forms using Oracle Forms 9i.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.

Environment:

Oracle 10g/11g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports 10g, MS office.

Confidential, Rochester, NY Oct’10- Nov’11
Role: Oracle PL/SQL Developer

The�Operational Data Store (ODS) is built to store daily Membership, Group information from Legacy systems. This ODS is used for various applications and projects like COBR (Coordination of Benefits-Recertification) and for Reporting. This ODS gets the data from several legacy systems which runs on daily Kill & Fill process. This is also used by Enterprise Data Warehouse to store all the historical information.

Responsibilities:

• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Worked as part of the development team, along with the Systems Analysts/Business Analysts.
• Analyzed and fixed the data discrepancies between various systems and identified bad data caused due the data migration from various legacy systems.
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers, extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects to improve performance.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS_PROFILER.
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance.
• Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
• Effectively used Triggers to track the user profile updates and to send the messages to downstream systems.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, db links and privileges.

Environment:

Client : Confidential, Chicago, IL Jan’10 – Sep’10 Role : Oracle PL/SQL Developer

Description:Confidential is simplifying its billing systems and processes by moving to a single billing platform for all lines of business within the Company. This Billing Simplification project (BSP) approach is expected to improve its overall customer experience. In the initial phase, only Personal Lines of Auto and Fire have been chosen for implementation.

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Involved in designing ER diagram using Erwin, to set the logical and physical relationships of database.
• Developed the shell script, SQL*Loader script, and most of PL/SQL stored procedures, triggers and views to handle the Online and Batch process.
• Developed documentation of all the modules and explaining all the procedures used in the project.
• Created database Triggers for the security purposes.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Wrote Stored Procedures (PL/ SQL) for implementing complex business logic.
• Creating SQL, Object Views, and PL/SQL database objects. Written the interface stored Procedures for data transformation.
• Performed Performance Tuning using the DBMS_PROFILER package, this checks the run time behavior.
• Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.
• Used TOAD, PL/SQL developer tools for faster application design and development, Performance tuning, SQL tuning.
• Involved in Troubleshooting performance issues and bugs within packages and stored procedures using DBMS_OUTPUT and Explain Plan.
• Developed test plan documents for all back end database modules responsible for documentation of the interfaces.
• Developed User Interfaces (forms 10g).
• Writing Unix Shell Scripts to run batch jobs, automated processes, and to automate routine systems administration tasks.

Environment:

Client: Confidential, Denver, CO Sep’08 – Dec’ 09

Description: Confidential is a leading asset manager offering individual investors and institutional client\'s complementary asset management disciplines through the firm\'s global distribution network. Enterprise Information Management (EIM) is the project that deals with the company\'s trade, dealer, and financial advisor information stores in different sources. EIM projects build a common platform as a data warehouse that is used for reporting purposes.

Responsibilities:

• Developed various PL/SQL objects like procedures, functions, packages and triggers in accordance with the business needs.
• Involved in interacting with the end-user (client) to gather business requirements and modeling the business requirements.
• Participated in analyzing the requirements for the logical and physical design of the database.
• Knowledge of Normalization, Data Warehousing, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc
• Loading data into test warehouse for the business analyst to perform QA testing using SQL Loader utility.
• Experience with merging data files coming from the customer into the existing data warehouse.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote shell scripts to automate loading files into database using crontab, error handling and notification.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Presented several technical presentations on Oracle database operation.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.

Environment : Windows 2000/XP, HP-Unix 11.0,Oracle 9i/10g, SQL, PL/SQL, UNIX Shell scripts, Toad, SQL Loader.

Client: Confidential, VA Jan’08- Aug’08
Role : Oracle PL/SQL Developer

Description: Confidential is dedicated to build logic running behind credit card application to approve or decline an applicant or sending an application for manual review in case of missing information from three financial bureaus or applicant and also in special cases.

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System design documents, Flows, Test Plan preparations and Development of Business Process and Work Flow charts.
• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Involved in Creation of tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Created Materialized views to calculate aggregated data, such as Sum of monthly revenue.
• Developed complex ORACLE stored procedures and packages to calculate borrower\'s debt ratio, property taxes, mortgage insurance, regular/ irregular payments, etc.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Used Triggers in Customizing Error conditions.
• Developed / modified PL/SQL code like stored procedures, packages etc for interfaces.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed PL/SQL code for updating payment terms.
• Supported DBA team for the data migration from oracle 9i to 10g.
• Creation of Forms, Pop-up Menus and maintaining Master Detail relationship.
• Used various LOVS (List of Values) and record groups at various points in runtime.
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Development of PL/SQL program units and sharing them among multiple applications for processing business logic in the database.
• Testing all forms, PL/SQL code for logic correction.

Environment: Oracle 9i (SQL, PL/SQL), SQL*loader, Toad 9.0.1, Forms/Reports 6i, UNIX, MS Office.

Client: Confidential May’05 - Nov’07
Role : Oracle PL/SQL Developer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Developed PL/SQL scripts for Data cleansing.
• Developed UNIX shell scripts that help as a scheduler for data load.
• Made timely changes and fixes to all the modules on reported problems from the database administrator.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed SQL tuning using Explain Plan, Hints and indexes.
• Worked extensively on exception handling to trouble-shoot PL/SQL code.

Environment: Oracle 8i, PL/SQL, TOAD, MS Office and Windows 2000 server.