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 teh 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 teh ease of debugging and displaying teh error messages in teh application. Handled Production issues with high pace and efficiency. Optimized existing queries for better performance and less impact on database.
• Strong knowledge in Oracle Cursor management, Exception Handling and also experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf and Indexing and Optimizing teh 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 teh business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from teh tables.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files
• Experience with file transfer protocols SFTP and FTP.
• 24/7 Production Support & Maintenance
• Monitoring Autosys Jobs, CRON jobs and verifying teh logs and identifying teh root cause if teh jobs are failed.
• Worked with teh users to identify teh business requirements and integrated them into teh front end applications and coordinating teh Off - shore team.
• A Self-starter with 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 with 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 teh existing applications and end users and worked with teh Architects and Tech Leads for architecting teh product as per teh 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 teh tables for faster retrieval of teh data to enhance performance
• Used PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.
• Created tables with constraints applicable to teh business rules.
• Used TOAD &SQLDeveloperfor debugging application
• Handled errors using Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application..
• Wrote Unix Shell Scripts to process teh files on daily basis like renaming teh file, extracting date from teh file, unzipping teh file teh file and remove teh junk characters from teh file before loading them into teh base tables
• Modified Reports to suit client requirements.
• Monitoring Autosys Jobs, CRON jobs and verifying teh logs and identifying teh root cause if teh jobs are failed.
• Ftp teh files for teh files processing.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Interacting with teh users and troubleshooting teh problems involved with teh development of stored procedures, triggers and with teh privileges.
• Involved in developing scenarios for Unit, Integration testing to ensure dat all teh components work correctly when integrated.
• 24/7 Production Support & Maintenance
• Monitoring Autosys Jobs, CRON jobs and verifying teh logs and identifying teh root cause if teh 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 teh Oracle Database using SQL*Loader.
• Co-ordination with various third party vendors during business impacting changes and deployments.
• Attending calls with teh 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 with 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 teh 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 with 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 teh 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 teh staging tables according to teh Clients requirements
• Developed and created various scenarios for testing teh code
• Debugged existing code for business logic issues.
• Production support for teh current application and fix/rewrite teh 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 teh REOMB batch process and ftp’d teh output files from programs to remote printerto generate teh 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 teh 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 teh staging tables according to teh 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 teh 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 teh system and business.
• Tuned teh SQL Queries to improve teh system performance.
• Developed complex SQL queries for generating reports of various modules.
• Involved in analyzing and validating data migrations from teh old system to highly relational database system.
• Involved in writing complex queries for teh 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 teh Functions, Procedures and Triggers as per teh requirement
• Involved in Bug Fixing and Unit and Integration Testing.
• Involved in teh restructuring and fine tuning of teh existing SQL Queries according to teh new requirement.

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

Confidential, Hodgkins, IL

Programmer Analyst

Responsibilities:

• Interacted with 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 with constraints applicable to teh business rules.
• Developed Unix shell scripts to extract data from teh Production database & refresh teh 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 with teh users and troubleshooting teh problems involved with teh development of stored procedures, triggers and with teh privileges.
• Involved in developing scenarios for Unit, Integration testing to ensure dat all teh 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 teh build rules, writing teh code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Mapping Operational Repository to Business Repository elements and incorporating teh 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 with 20 Million records in some of teh tables.
• Based on teh user selection and finally storing teh output as a flat file for further processing for teh 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 teh performance tuning of teh programs, ETL Procedures and processes.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Also my role includes testing teh data in addition to re-designing teh database. Front end using Forms 4.5 and Reports 2.5.

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