SUMMARY

• Over seven years of IT experience in system analysis, design, testing, and development of business applications using Oracle 11g/10g/9i.
• Strong programming knowledge in Oracle 10g/9i, PL/SQL, SQL*Plus, SQL*Loader, Developer 2000 (Oracle Forms, Oracle Reports).
• Experience in development of Procedures, Functions, Packages and Database Triggers.
• Expert in TOAD, Export, Import and SQL*Loader Utilities.
• Good knowledge in SAS programming and development.
• Developed various applications using Oracle built - in packages such as DBMS SQL, UTL FILE.
• Experience in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Extensively worked on Table Partitioning, Bulk Binds and Bulk Collects.
• Knowledge on DBA activities such as Performance Tuning, Backup and Recovery.
• Good Working Experience in Forms 6i/9i & Reports 6i/9i for both development and customization of several Reports as per client specifications.
• Developed and implemented transaction management using Oracle features like Savepoint, Rollback, Autonomous transaction and User Defined Exceptions.
• Expertise includes Oracle PL/SQL, SQL* Plus, SQL Loader, Constraints, Triggers, Cursors, Exception (error) handling, Views and Packages.
• Well versed with PL/SQL Collections and Dynamic SQL.
• Experience on Logical & Physical design of Databases, Data Modelling, Conceptual Design and Data Architecture and use of Erwin and MS VISIO as a modelling tool.
• Working Knowledge of UNIX Shell Scripting like automating routine tasks using UNIX Shell Scripting and Oracle DBMS JOBS.
• Extensive Data warehousing experience using Cognos 8.4 and Report Net 1.1.
• Excellent understanding of the Oracle Architecture.
• Experience with Production Support and maintenance projects.
• Technical documentation of different lifecycle deliverables and user manuals.
• Ability to adapt to a rapidly changing environment. Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.

TECHNICAL SKILLS

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

GUI: Developer 2000 (Forms & Reports), Discoverer 4i, Graphics 6i, VB

Languages: SQL, PL/SQL, SAS, Pro* C, Shell Scripting, C, C++, XML, HTML

Tools: Cognos 8.4, Report net 1.1 MR3, Enterprise Guide 4.2, Oracle Enterprise Manager, ADI, TOAD, SQL*Navigator, UTL, Forms Builder, Reports Builder, Schema Builder, Procedure Builder, Graphics Builder

Administration: Oracle DBA, Server Manager, SQL*Loader, Export, Import

Operating Systems: Windows (8/7/XP Professional/NT/2000/98/95), MS-DOS, UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE

Sr. PL/SQL Developer

Confidential, Addison, IL

Responsibilities:

• This project is involved in developing and supporting PLSQL extract processes for data warehousing systems which included code fixing, adding new business logic to existing process, tuning and fixing performance issues.
• Worked with Business Systems Analysts to understand and implement functional and non-functional requirements into the project.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers and collections.
• Use of explain plan, analyze, hints to tune queries for better performance and also Extensive usage of Indexes.
• Designed and developed technical designs for Automation process and also created detail design documentation for all the processes that I have developed.
• Experience with ticketing systems as part of analysis, development and production support projects.
• Involved in troubleshooting/supporting and fixing defects for users by resolving day to day production issues.
• Analyze and resolve, or recommend solutions to highly complex technical problems such as performance issues and data quality issues.
• Worked with Oracle DBA’s to trouble shoot and resolve extract process performance issues.
• Worked with the testing team in fixing bugs for the system; Unit testing, running the test Cycles, system integration.
• Resolved various performance issues in the large pl/sql processes by re-developing all the processes.
• Developed various reports as per the requirements using Cognos 8.4 BI. Also, created ad-hoc reports for Internal and External clients using Query Studio.
• Tested and validated the report output against the database to measure performance of the Report.
• Deployed the packages and reports from development to test environment and test to production environment.
• Restarting Cognos Services to apply configuration settings on maintenance day which occurs every month or whenever required doing so.
• Worked on designing and developing reports, web applications using Apex.
• Proven ability to support multiple projects, under tight deadlines with competing priorities and complexities.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, UNIX, SQL*Loader, COGNOS 8.4 BI, APEX 4.1

PL/SQL Developer

Confidential, Memphis, TN

Responsibilities:

• Worked with Business Analysts to understand the business requirements and perform analysis of the data they obtained daily.
• Involved in gathering user requirements.
• Performed database design and development to support the business needs of Channel Marketing group.
• Designed both lookup and business rules table structures and created stored procedures to meet the system requirements.
• Developed PL/SQL packages consisting of procedures, functions, cursors for various calculations in the application.
• Used indexes, views, sequences and partition tables to optimize the queries.
• Performed application tuning for slow running queries using Explain plan.
• Involved in tuning database and SQL statements and schemas for optimal performance.
• Loaded data from flat files into tables by using the SQL * Loader and then validate the data with summary tables.
• Used Toad to run queries to validate database updates.
• Involved in Database Testing (Oracle), loaded the test data into Oracle database by writing SQL queries and PL/SQL procedures.
• Used UTL FILE to extract the data from Oracle tables onto a file for Business needs.
• Assisted in Data Migration using Oracle tools like Export/Import Utilities.
• Offer timely response and resolution of emergency production issues and errors.
• Involved in reviewing of Tech Designs which supports the application.
• Ability to influence key business decisions through analysis and user insight studies.
• Responsible for manipulating, transferring and managing data in SAS.
• Analyzed the data from flat files, and developed SAS programs using Enterprise Guide 4.2.
• Extensive use of PROC SQL to perform queries and join tables.
• Developed UNIX shell scripts to automate the application process.
• Validated the data sets and compared the results to meet the requirements.

Environment: Oracle 9i/10g, SQL, SQL*PLUS, SQL*Loader, TOAD, SAS, PL/SQL, UNIX, SAS Enterprise Guide 4.2

Oracle Developer

Confidential, Atlanta, GA

Responsibilities:

• Responsible for requirements analysis, design and development of the system.
• Analyzed the database design for better understanding of the relations, associations and dependencies within the database.
• Analysis of business functionality with the client and business analysts.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Generation of ‘data feed' (for various customers, coverage’s etc.) using SQL for the back office units for data reconciliation.
• Ensure conformance to code standards and documentation requirements.
• Reviewed user application requirements.
• Worked extensively on tuning SQL queries and database modules for optimum performance.
• Created database objects like indexes, functions, triggers, synonyms, analytical functions to meet System Requirements.
• Tuned queries to use table Partitions for complex queries include joins and date ranges. Also used SQL TRACE, TKPROF for SQL tuning.
• Validations were done in front-end and as well in back-end using triggers.
• Developed interfaces using Oracle advanced concepts and creating packages, procedures and functions to load data into targeted Oracle database tables.
• Used UTL FILE to extract the data from Oracle tables onto a file for Business needs.
• Developed UNIX shell scripts to automate repetitive database processes.
• Performance Tuning was done using explain plan and query optimization techniques.
• Implemented modifications to improve performance of long running batch jobs with the help of changes in SQL statements, indexes and Explain Plans.
• Strong troubleshooting/production support skills and interaction abilities with end users.
• Involved in Unit test, Integration testing of the Modules, Regression test and System testing.
• Interacted with the users from development phase through production phase of the project.
• Involved in integration and User Acceptance Testing and Production support.

Environment: Oracle 10g/11g, SQL, SQL*PLUS, SQL*Loader, TOAD, SQL Developer, PL/SQL, Oracle, UNIX.

PL/SQL Developer

Confidential, Hartford, CT

Responsibilities:

• Gathered and documented business requirements. Created initial conceptual design and entity relationship diagrams and created the database objects.
• The project involved detailed design using E-R Diagrams, Data Flow Diagrams, Data Dictionary, and System flow Charts.
• Developed procedures, packages, and functions to update and maintain the database.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Used Oracle PL/SQL procedures for migrating data from interchange to present DSS (Design Sub system).
• Wrote PL/SQL procedures & triggers to validate database records.
• Wrote Scheduler Scripts in UNIX to run the developed PL/SQL scripts.
• Loaded data from flat files into tables by using the SQL * Loader.
• Involved in performance tuning of the application.
• Analyzed test results to tune SQL statements for improved performance of the stored procedures and created indexes on tables on a case-by-case basis.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Worked on various backend Procedures and Functions using PL/SQL.
• Involved in maintenance of database schema based on requirements changes and enhanced change requests.
• Designed, developed and customized Reports using Oracle Reports 6i according to the business requirements.
• Developed reports using REFCURSOR to improve performance for complex queries.
• Assisted in developing templates and proof of concepts for all the reporting applications.
• Developed various PL/SQL processes to extract data from different sources.
• Developed user documentation for all the application modules.
• Involved in the development of the entity relationship diagrams for the source and target tables.
• Prepared Test cases and testing procedures for the DSS system.
• Involved in Unit Testing and Integration Testing of the Modules.
• Involved in Performance testing the application with production data.

Environment: Oracle 9i/10g, SQL, SQL*PLUS, SQL*Loader, TOAD, SQL Developer, PL/SQL, UNIX

Oracle Developer

Confidential, Windsor, CT

Responsibilities:

• Involved in direct discussion with the End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.
• Worked with Business Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Involved in database design and development.
• Analyzed the table structures and their integrity constraints to enhance the system.
• WrotePL/SQL packages consisting of procedures and functions. Also, created Views, Triggers and Sequences.
• Involved in creating Indexes and Table partitions.
• Query Optimizationand tuning of database.
• Developed complex SQL and PL/SQL queries using joins, sub queries and correlated sub queries.
• Loaded the data from/to the tables by kicking off SQL*LOADER scripts.
• Reviewed and analyzed the program code developed using PL/SQL, identified bugs and bottlenecks and rectified errors.
• Involved in migration of data from MS Access to Oracle database.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Involved in maintenance of database schema based on requirements changes and enhanced change requests.
• Actively involved in System Testing and deploying the codes.
• Prepared Technical documentation and Unit testing scripts.

Environment: Oracle8i, SQL, PL/SQL, SQL*PLUS, TOAD and Windows 2000.