SUMMARY:

• 6+ years of experience in IT field as Oracle PL/SQL Developer.
• MMIS project experience with state government contracts.
• Expertise in RDBMS concepts such as Schemas, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, Anonymous Blocks, Directories, Sequences, and Synonyms.
• Extensive experience in developing and modifying PL/ SQL objects such as Stored Procedures, Functions, Packages, Views, Materialized Views, and Triggers.
• Experience in working Oracle and various database tools like TOAD and SQL Developer.
• Familiar with SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Proficient in all the phases of Software Development Cycle (SDLC) and various methodologies like Waterfall and Agile SCRUM.
• Working knowledge of Extract Transformation Load ( ETL) process to transfer data between different databases.
• Implemented various Error/Exception Handling methods using system - defined exceptions and user-defined exceptions.
• Good knowledge in front end development using O racle forms/reports.
• Experience in deploying forms and reports on the web.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• Excellent experience in creating Test Cases, Test Plans based on requirements.
• Excellent problem solving and analytical skills.

TECHNICAL SKILLS:

Databases: Oracle, SQL Server, DB2, MS Access

Languages: SQL, PL/SQL

Tools: TOAD, SQL Developer, PL/SQL Developer, SSIS

ETL Tools: Informatica

Web Technologies: HTML, XML

Testing Tools: HP Quality Center, Mercury QTP, Clear Quest

WORK EXPERIENCE:

Confidential, Indianapolis, IN

PL/SQL Developer

Responsibilities:

• Created Stored Procedures, Functions, Database, Packages, tables, indexes, views, synonyms, sequences using SQL and PL/SQL.
• Extensively used Framework Manager , Query Studio and Report Studio for model design , ad-hoc reporting and advanced report authoring.
• Have experience on ETL tool Decision Stream
• Extensively used PL/SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules.
• Worked with Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
• Analyzed the system requirements and performed logical and physical design of the database.
• Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors.
• Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
• Created shell scripts and updated the scripts as per the requirement.
• Created application schema as tables, view and indexes and customized the stored procedures and database triggers in PL/SQL.
• Exception handling and cursor management in PL/SQL.
• Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do the transactions.
• Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per the requirements.
• Coded UNIX shell scripts to execute Oracle Custom Packages and Procedures.
• Designed Conversion and Interface Programs using PL/SQL procedures and packages.
• Analysis, Development, Testing and Implementation using Oracle.
• Used Oracle Forms and Reports as GUI for Oracle Applications and development of high performance technical solutions to meet the challenging business demands to the clients.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services ( SSIS )

Confidential, Richmond, VA

PL/SQL Developer

Responsibilities:

• Created many Generic Stored Procedures, Functions, Database, Packages, tables, indexes, views, synonyms, sequences using SQL and PL/SQL.
• Performance monitoring and tuning on UNIX systems. Develop step-by-step method using predesigned worksheets to eliminate much of guesswork in performance monitoring and tuning.
• Extensively used PL/SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
• Analyzed the system requirements and performed logical and physical design of the database.
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors.
• Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
• Created shell scripts and updated the scripts as per the requirement. Experienced in Automation using Shell Scripting.
• Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.
• Created application schema as tables, view and indexes and customized the stored procedures and database triggers in PL/SQL.
• Exception handling and cursor management in PL/SQL.
• Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do the transactions.
• Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per the requirements.
• Coded UNIX shell scripts to execute Oracle Custom Packages, Procedures and OWB ETL mappings on weekly/monthly basis.
• Designed Conversion and Interface Programs using PL/SQL procedures and packages.
• Analysis, Development, Testing and Implementation using Oracle.
• Used Oracle Forms and Reports as GUI for Oracle Applications and development of high performance technical solutions to meet the challenging business demands to the clients.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services ( SSIS )

Confidential, Mclean, VA

PL/SQL Developer

Responsibilities:

• Analyzed System Requirements to create high level and detail design documents with the assistance of requirements team and Architects.
• Worked closely and supported members of teams such as Architecture, Change management, Database Management, Technical operations, System Test, UAT, Requirements and Business teams during entire life cycle of the project.
• Coded UNIX shell scripts to execute Oracle Custom Packages, Procedures and OWB mappings.
• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions, Triggers, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Helped testing team in setting up environments by doing data refresh.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Developed Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project.
• As a key PL/SQL developer, defined the required analytics to design, develop financial routines, and assisted various work streams in identifying, and resolving data irregularities. Establish management reporting processes and requisite supporting technology.
• Used Explain Plan, Analyze, Hints to tune queries for better performance and also Extensive Usage of Indexes.
• Worked with SQL loader and control files to load the data from external sources to different schema tables.
• Implemented features including Materialized Views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Coded UNIX shell scripts for the execution of user reports.
• Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables.
• Created database objects like SQL Queries, tables, Joins, Stored procedures using Oracle Utilities like PL/SQL, SQL* Plus, SQL Server.

Confidential

PL/SQL Developer

Responsibilities:

• Created many Generic Stored Procedures, Functions, Database Triggers, Packages, tables, indexes, views, synonyms, sequences using SQL and PL/SQL.
• Extensively used PL/SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.
• Analyzed the system requirements and performed logical and physical design of the database.
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors.
• Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.
• Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.
• Created application schema as tables, view and indexes and customized the stored procedures and database triggers in PL/SQL.
• Exception handling and cursor management in PL/SQL.
• Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do the transactions.
• Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per the requirements.
• Designed Conversion and Interface Programs using PL/SQL procedures and packages.
• Analysis, Development, Testing and Implementation using Oracle 10g/9i.
• Used Oracle Forms and Reports as GUI for Oracle Applications and development of high performance technical solutions to meet the challenging business demands to the clients.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services ( SSIS )