SUMMARY

• Over Seven years of experience in Application Development using Oracle SQL and PL/SQL.
• Experience in all phases of the project Life cycle Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation and Support.
• Proficient in SQL and PL/SQL programming - Creating Stored procedures, Functions, packages, cursors, ref cursors, Nested Tables, triggers, associative arrays and user defined types.
• Strong Experience in ORACLE Databases, SQL SERVER, PL/SQL, SQL* Loader, and UNIX environment.
• Strong experience in table and Index partitioning.
• Expertise in Performance Tuning of complicated Procedures, Packages and all kind of SQL queries by using SQL Trace, Explain Plan.
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors.
• Expertise in developing External Tables, JOINS, INDEXES AND SEQUENCES.
• Experience with various DDL operations like Creation of Indexes, Materialized Views and Partitioning tables.
• Designing, Coding, Testing and implementation of High Availability Distributed System.
• Expertise in performance Tuning of SQL queries and complex procedures to improve performance & decrease response time utilizing Explain Plan and Hints.
• Expertise in using HTML, CSS, JQuery, JavaScript, and Ajax inAPEXapplications to have client side programming and validations.
• Experience in Data Migration, SQL Loader.
• Expertise in Creating SQL Loader Scripts to load data from flat files into database and exporting data to flat files using UTL FILE package.
• Expert in Incident Management working through critical incidents. Manning command center and conducting Incident resolution bridge calls.
• Excellent problem solving and decision making skills.
• Proven leadership and organizational abilities.
• Quick learner with ability to master new concepts and applications.

TECHNICAL SKILLS

Operating Systems: Windows … Linux.

Programming languages: C, core Java, SQL, PL/SQL programming.

Web Technologies: HTML, XML.

Tools: Toad, SQL Developer, PL/SQL Oracle Developer, Oracle Forms/Reports 6i/9i/10g, SQLPlus.

Database: Oracle … MySQL, MS SQL Server 2012

Others Object Oriented: Designing Methodology, RDBMS Concepts.

PROFESSIONAL EXPERIENCE

PL/SQL Developer

Confidential - Bloomington, MN

Responsibilities:

• Handling the data requests from multiple clients.
• Handling complex sql scripts for data retrieval.
• Generating files based on daily requests.
• Using UNIX for file transfer to client side.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Performing DML operations for daily activities.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Involved in standardization and creation of common error handling process which can be plugged in ETLjobs to log and report different errors or validation failures.
• Designed and developed User Interface forms and reports usingAPEX, Bootstrap Framework and AngularJS for the custom applications and built interactive navigation system for the application.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Designed application framework and developedOracleAPEXApplication.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Involved in version controlling ofETLjobs during migration using TFS tool.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Java.

Oracle PL/SQL Database Developer

Confidential

Responsibilities:

• Interact with Development Teams and Managers to analyze business needs.
• Translate the business requirements into technical requirements, conduct meetings for approvals.
• Transformed data from one server to other servers using tools like Spool, SQL loader.
• Documented the ETL process for future references.
• Created new Tables, Indexes, views, synonyms and Sequences where needed.
• Create complex PL/SQL Packages, Procedures and Functions as per the requirement.
• Developed and created the new database objects including tables, views, indexes, stored procedures and Handled different types of predefined and user defined Exceptions.
• Extensively used PL/SQL Collections, Bulk Collect, for all, Table Types, And Record Types.
• Extensively used UTL FILE package to read and write to OS files and create data feeds to downstream systems.
• Move data between different database environments using Import/Export.
• Created Table partitions and materialized views to improve the performance of slow running queries.
• Wrote complex shell scripts for processing of the files.
• Created Test scripts and involved in Unit, Integration and System testing and User Acceptance Testing.
• Wrote FTP scripts for transferring files, FTP checks to ensure complete file transfers.
• Automated the process of migration from oracle to SQL server by using AUTOSYS.
• Used Rapid SQL & Toad for Oracle to access DB, write packages, procedures & functions.
• Guide/help team members in resolving technical issues.
• Provide 24/7 on call production support and resolve production issues immediately

Environment: Oracle 9i (9.2.0.1.0), Oracle 10.0.2, SQL, PL/SQL, Toad for Oracle, SQL Server Management Studio, UNIX, Windows.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Involved in the Design and Documentation.
• Involved in Mathematical analysis and forecasting algorithms.
• Involved in Complex Costing calculations.
• Used regression functions to forecast the load.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Used collection / PL - SQL Objects to enhance the performance.
• Used Explain plan to figure out the cause for poor performing queries.
• Performed unit and integration testing of the applications created using Oracle Forms 10g and PL/SQL modules and used PVCS for version control in team development.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Created Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Provided production support: solving defects, code debugging.

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10.6.

Programmer

Confidential

Responsibilities:

• Designed / developed tables, views, various SQL queries, procedures and functions.
• Involved in designing the Schemas and Objects.
• Involved in the maintenance and enhancement of the application
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables
• Exporting & importing data from different data source from & into Oracle.
• Developed scenarios for Unit, Integration testing to ensure that all the components work
• Correctly when integrated.

Environment: Oracle 10g/11g, Linux, Windows, Visual Basic and TOAD.