SUMMARY

• Around 9+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS)
• Strong Experience in Interface programs to import data from legacy systems and excellent skills in writing PL/SQL stored procedures, functions, packages, triggers and cursors.
• Proficient in Oracle Tools such as TOAD 10.6, SQL * Loader, Oracle SQL Developer and Oracle utilities like DBMS PIPE, UTL FILE, Exp, Imp and Data pump.
• Extensively worked in Reports and writing Stored Procedures, Packages.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Handled Production issues wif high pace and efficiency. Optimized existing queries for better performance and less impact on database.
• Strong noledge in Oracle Cursor management, Exception Handling and also experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf and Indexing and Optimizing the oracle reports.
• Used Ref cursors and Collections, Bulk Collect and Bulk Binding for accessing huge volume of data.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques
• Implemented the business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from the tables.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files
• Experience wif file transfer protocols SFTP and FTP.
• 24/7 Production Support & Maintenance
• Monitoring Autosys Jobs, CRON jobs and verifying the logs and identifying the root cause if the jobs are failed.
• Worked wif the users to identify the business requirements and integrated them into the front end applications and coordinating the Off - shore team.
• A Self-starter wif a positive attitude, willingness to learn new concepts and accept challenges.
• Excellent analytical and problem solving skills and can work independently
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
• Experience wif AGILE Methodologies.

TECHNICAL SKILLS

Operating Systems: Windows XP/NT/2000, 98/95/Vista, DOS, Solaris 10, Unix, Linux.

Database: Oracle 11g,10g, 9i, 8i, 7.x, MS Access and SQL Server 2000,2005.

Programming languages: ANSI C, C++, Java, SQL, PL/SQL programming.

Database Tools: Toad, PLSQL Developer, SQL Navigator, SQL Tools, Erwin.

Utilities: UTL FILE, DBMS PIPE, Exp, Imp and Data pump.

Web Technologies: HTML, XML.

Script Languages: Shell, Perl scripting.

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts, and ETL.

PROFESSIONAL EXPERIENCE

Confidential, Weehawken, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Requirement gathering from the existing applications and end users and worked wif the Architects and Tech Leads for architecting the product as per the business requirements
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and triggers.
• Translated user requirements into data flows, detail technical specifications and database requirements
• Developed, modified, and queries for data retrieval and modification.
• Createdindexes on the tables for faster retrieval of the data to enhance performance
• Used PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.
• Created tables wif constraints applicable to the business rules.
• Used TOAD &SQLDeveloperfor debugging application
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application..
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file the file and remove the junk characters from the file before loading them into the base tables
• Modified Reports to suit client requirements.
• Monitoring Autosys Jobs, CRON jobs and verifying the logs and identifying the root cause if the jobs are failed.
• Ftp the files for the files processing.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Interacting wif the users and troubleshooting the problems involved wif the development of stored procedures, triggers and wif the privileges.
• Involved in developing scenarios for Unit, Integration testing to ensure dat all the components work correctly when integrated.
• 24/7 Production Support & Maintenance
• Monitoring Autosys Jobs, CRON jobs and verifying the logs and identifying the root cause if the jobs are failed.
• Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, coding and testing.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Windows 7, Oracle12c, SQL, PL/SQL, Sybase, SQL*Loader, Informatica 9.0, UNIX, Autosys, CRON Jobs.

Confidential, Conway, AR

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in writing Stored Procedures / Functions / Packages / Triggers/advanced objects like V-arrays, Nested Tables, Records and PL/SQL tables in Oracle.
• Data Migration / Loading / Export / Import/SQL*Loader.
• Writing Unix Shell Scripts to automate backend jobs
• Loading non-oracle data Converting into the Oracle Database using SQL*Loader.
• Co-ordination wif various third party vendors during business impacting changes and deployments.
• Attending calls wif the Business and Offshore team on daily basis for Requirement clarifications and delivery Issues.
• Identifying risks proactively and proposing solutions to resolve them.
• Sending Weekly status reports to Onsite and Offshore leads.
• Developed several custom Forms to interact wif data tables and schema.
• CreatedSQL scriptsand writtenProceduresusingPL/SQLto load data from flat files into new tables (using both UTL and SQL Loader - for different cases).
• Explain Plan, Tkprofwas used for checking the performance of queries.
• Modified and updated existing custom forms to adapt to new database schema.

Environment: Windows 7, Oracle11g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Informatica 9.0, UNIX. JIRA.

Confidential, Carmel, IN

Sr. Oracle PL/SQL Developer

Responsibilities:

• Interacted wif Business Analysts and Users in requirement gathering.
• Worked on Full SDLC. System Requirements, Implementation, Integration, Unit testing, Peer reviews, Version Manager tools, Bug tracking system tools, Test cases, Test data, Test Plan, Change Requests, Risk Management and Production support.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Created materialized views, Inline Views & normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Created triggers for data security & Consistency
• Developed procedures, functions and packages for new requirements
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database using shell scripts
• Developed packages for processing data in the staging tables according to the Clients requirements
• Developed and created various scenarios for testing the code
• Debugged existing code for business logic issues.
• Production support for the current application and fix/rewrite the PL/SQL code if any ticket assign from users.
• Wrote custom support modules for upgrade implementation using Pl/Sql, Unix Shell Scripts.
• Support modules for implementation usingPL/SQL Scripts, Unix Shell Scripts.
• Developed UNIXshell scriptsto automate the REOMB batch process and ftp’d the output files from programs to remote printerto generate the static physical reports.
• Used various protocols and connectors like SFTP, FTP.
• Worked atconceptual/logical/physical data model level using Erwin according to requirements.
• Worked on Agile application development methodologies

Environment: Oracle10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, UNIX, JIRA, Java, Ervin r7.1

Confidential, OKC, OK

Oracle PL/SQL Developer

Responsibilities:

• Involved in Requirement gathering and writing Functional and Technical documents.
• Designed/Coding/developed/Modified new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors as part of Project/Application requirements.
• Tune the SQL queries and complex procedures to improve performance.
• Created database triggers for data security & Consistency.
• Developed procedures, functions and packages for new requirements.
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database using shell scripts.
• Developed packages for processing data in the staging tables according to the Clients requirements.
• Implemented PLSQL Concepts for better performance of PLSQL Applications.
• Oracle Forms developed and deployed in allUNIX environmentthrough Dev, Test, and Prod in an Oracle Applications environment.
• Support modules for implementation usingPL/SQL Scripts, Unix Shell Scripts.
• Translated business requirements and software design specifications into Oracle Forms applications.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Developed and created various scenarios for testing the code.
• Debugged existing code for business logic issues.
• Used UTL FILE package for writing DBMS OUTPUT messages to file.

Environment: Oracle10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Java, SQL Navigator, Sub Version, Mercury Quality Control, UNIX, JIRA

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in analyzing the system and business.
• Tuned the SQL Queries to improve the system performance.
• Developed complex SQL queries for generating reports of various modules.
• Involved in analyzing and validating data migrations from the old system to highly relational database system.
• Involved in writing complex queries for the project as required using Toad and Oracle SQL Developer.
• Used PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.
• Used SQL*LOADER for loading full and delta files of candidate details.
• Used oracle XML Functions in SQL Queries to generate data in hierarchal structure.
• Modified and Debug the Functions, Procedures and Triggers as per the requirement
• Involved in Bug Fixing and Unit and Integration Testing.
• Involved in the restructuring and fine tuning of the existing SQL Queries according to the new requirement.

Environment: Oracle 11g/10g, Toad, Oracle SQL Developer, SQL*LOADER, UNIX, Windows XP.

Confidential, Hodgkins, IL

Programmer Analyst

Responsibilities:

• Interacted wif Business Analysts and Users in requirement gathering.
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Translated user requirements into data flows, detail technical specifications and database requirements
• Developed, modified, and optimized queries for data retrieval and modification.
• Used PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.
• Created tables wif constraints applicable to the business rules.
• Developed Unix shell scripts to extract data from the Production database & refresh the data warehousing application on a daily basis.
• Created tables, Tablespaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Wrote control files for data loading using SQL*Loader.
• Wrote UNIX shell scripts for automating regular data loading jobs.
• Interacting wif the users and troubleshooting the problems involved wif the development of stored procedures, triggers and wif the privileges.
• Involved in developing scenarios for Unit, Integration testing to ensure dat all the components work correctly when integrated.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle8i/10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Perl, .Net, Java, Toad, Clear Case, AIX-UNIX

Confidential

Software Engineer

Responsibilities:

• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Extensively used PL/SQL for designing/Coding packages, stored procedures, functions and database triggers.
• Extensively used PL/SQL to extract data from different tables wif 20 Million records in some of the tables.
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used.
• Incorporated validation rules for promotion history table and updating tables.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Also my role includes testing the data in addition to re-designing the database. Front end using Forms 4.5 and Reports 2.5.

Environment: PL/SQL, SQL*Plus, Exp, Imp and Windows NT.