SUMMARY:

• Experienced in Application Development using Oracle 11g/10g/9i, PL/SQL, SQL*Loader, Physical database design, Logical database design, Gap Analysis, Data Exports & Imports, Application Support, Performance Tuning, Oracle Tuning & Optimization.
• Experienced in interacting with Business Users, Business Analysts and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Programming experience using PL/SQL, SQL, Packages, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes (B - tree Index, Bitmap Index), Views, Materialized Views, Database Links, and Export/Import Utilities.
• Experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, Packages, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables.
• Worked on PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Expertise in loading data from legacy systems using SQL*Loader, UTL FILE.
• Ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Experience in the full System Development LifeCycle (SDLC) with understanding of a variety of technologies and platforms such as web, client/server, entity-relationship diagrams (ERDs), relational database concepts and object-oriented programming.
• Excellent analytical, problem solving, communication and inter-personal skills to supervise and interact with individuals at all levels.
• Automated executing script files through UNIX using Autosys.
• Excellent written and oral communication skills with a result-oriented attitude.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, C++, Autosys

TOOLS: TOAD, PL/SQL, SQL Developer 3.0, Oracle 8i/9i/10g/11g, MS SQL Server 2000/2005, MS Access, SQL*Plus, SQL* Loader, Dreamweaver, MS office 2007, 2010, Erwin, MS Visio, Putty.

Operating System: Windows 7, Windows Vista, XP, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Senior Oracle PL/SQL Developer

Confidential, Charlotte, NC

Responsibilities:

• Involved in the analysis, design, and development and testing phases of Software Development Life Cycle (SDLC).
• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Built complex queries using SQL and wrote stored procedures &packages using PL/SQL.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
• Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
• Involved in day-to-day duties of DBA work like taking backup and recovery of database environment.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• Developed PL/SQL ETL scripts to transfer data across the schemas and databases.
• Involved in development and scheduled jobs using Autosys for automation.
• Unit testing on PL/SQL Packages and procedure, functions according to business requirement.
• Managed and resolved design issues during deployment.
• Involved in tuning and optimization of SQL statements.
• Involved in writing test scripts, unit testing, system testing and documentation.
• Documented every phase like Technical specifications, source to target mappings, data and release notes.
• Worked with production support team in resolving production issues.
• Assisted in testing and deployment of the application.
• Maintain (Add/Delete/Modify) Jobs based on business requirement using AutoSys.
• Supported code deployment from lower to higher environment.

Environment: ORACLE 11g/ 10g, SQL*Plus, PL/SQL, SQL*Loader, Autosys, TOAD, SQL Developer, UNIX, MS Visio, Windows XP/ 7.

Senior Oracle PL/SQL Developer

Confidential, Jersey City, NJ

Responsibilities:

• Responsible for the complete design/implementation of the Oracle Database structure. Used waterfall model for development purpose.
• Designed solutions to database level based on previous survey requirements. Defined and implemented the new database structure with the proposed solutions using Toad Data modeller.
• Designed technical design documents for ETL process.
• Analyzed and upgraded Amisys Surround Code (Shell Scripting, PL/SQL and COBOL) for the project.
• Involved in designing physical and logical data model.
• Implemented the Usage of System Change Number (SCN) in order for getting the Flashback Database and development of the copy program.
• Performance tuned the existing modules to reduce the execution time using Bulk Collect and Global Temporary Tables etc.
• Performance tuned Interfaces, queries through use of indexes, ranks, Oracle hints.
• Created PL/SQL Stored Procedures, Functions and Triggers for accumulator and other process.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
• Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates.
• Used exception handling extensively for ease of debugging and displaying error messages in the application.
• Worked on Staff History, Client Statement and Employee Demographics reports.
• Involved in end-to-end system Testing, Performance and regression testing and data validations and Unit Testing.

Environment: ORACLE 11g, SQL*Plus, PL/SQL, SQL*Loader, TOAD, SQL Developer, UNIX, Autosys, MS Visio, Windows XP/ 7, COBOL.

Oracle PL/SQL Developer

Confidential, Evansville, IN

Responsibilities:

• Collecting and analyzing the user requirements and preparing the user requirements documents.
• Designed Entity-Relationship model and other design features.
• Created new End User Layer (EUL) for Oracle Discoverer version 10g (9.0.4). Created business areas, complex folders, custom folders, simple folders and reports.
• Designed and developed DOT, Corrosion, Compliance, Leak Survey, Work Reminder discoverer reports. (200+ reports)
• Involved in the data-conversion process for Maximo.
• Developed Design Summary Report to aid the engineers in estimating the total cost of the Project.
• Deployed reports in Oracle Application Server 10g AS Portal.
• Developed database objects (packages, procedures, triggers, views, etc.) to provide custom functionality within Maximo environment.
• Designed and developed Work Order Detail Report, Load Unbalance, Load Reading and Counter Log, List reports using Oracle reports 10g.
• Development, Deployment and Maintenance of JSP Reports, ST TOOL and RTview.
• Extensively used TOAD and SQL Developer tool for effective application development.
• Responsible for oracle SR (Service Request) creation and follow-ups to resolve critical issues.
• Prepared Documentation of all the errors faced while deployment of reports in Portal, Application server.
• Created several Interactive Dashboards in 10g & 11g with drill downs and write back.
• Developed and modified several Maximo Reports in Reports 10g, OBIEE and Discoverer.

Environment: Maximo, SQL*Loader, PL/SQL, UNIX, Toad, Discoverer 10g, Reports 9i, RTview, Oracle Application Server, Oracle Enterprise Manager.

Oracle PL/SQL Developer

Confidential, NYC, NY

Responsibilities:

• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Collaborated with the DBA in creating tables required for the application.
• Used PL/SQL Database triggers to implement business rules.
• Performed staging, and cleansing of data as per requirement.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
• Extensively used SQL to create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Involved in writing complex/ad-hoc queries to generate reports as per client request as a part of production support.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
• Developed numerous SSIS packages to pull in the data from heterogeneous data sources.
• Worked thoroughly on coding and debugging of Stored Procedures, functions, packages, cursors and other Oracle objects to implement Business Rules.
• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints to develop better SQL Queries.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Worked on ETL’s for migration of data from one database to another database.
• Created indexes as a part of tuning.
• Issued Grants to the business users for appropriate Database tables, views.
• Interacted with production support team regarding production issues.
• Documented and transferred knowledge regarding the various projects.

Environment: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, UNIX.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Extensive understanding on high level business scenario of the company's financial functional structure.
• Involved in Requirement gathering & Analysis, Database designing and normalization of database tables.
• USED SQLCODE returns the current error code from the error stack SQLERRM returns the error message from the current error code.
• Involved in the development of database objects.
• Involved in Oracle User creation & assigning Roles & Privileges.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Writing Tuned SQL queries for data retrieval involving complex join conditions.
• Wrote stored procedures, functions, Packages, Triggers.
• Involved in writing cursors and handling exceptions.
• Used Import/Export utilities of Oracle.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.

Environment: Oracle 9i/10g, Windows XP, PL/SQL, SQL*PLUS, SQL Developer, UNIX, Autosys.

Associate Consultant (Oracle PL/ SQL Developer)

Confidential

Responsibilities:

• Analysis and gathering of new business requirements from the business resources.
• Transformed Business requirements to functional and technical specifications.
• Created Packages, Procedures, functions, tables, Primary keys and foreign keys in Oracle 10g using Toad for Oracle.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Worked with DBAs to tune long running queries and to analyze query execution plan.
• Worked with Collections to reduce overhead involved with cursor looping. Bulk fetched the data from SQL engine into collection.
• Extensive exposure in using dbms stats package. Worked on gathering stats at different granularity levels and different estimate percentages.
• Co-ordination with various problem resolution groups like Database, UNIX teams.
• Automated repetitive processes by writing shell scripts.
• Automated executing script files through UNIX using AutoSys.
• Provided daily support for multi-task development, and worked on DEV/QA testing and interacting job between DEV/ QA/ PROD environment. Work with QA team to debug/fix issues.
• Resolved Priority Production Support Issues and Defect Fixes.

Environment: Oracle 10g, SQL, PL/SQL, Windows XP, Redhat Linux, UNIX, AutoSys, DBArtisan, TOAD, SQL Developer, SQL Plus, Rational Clear case, Perforce.