SUMMARY:

• Almost 9+years of IT experience in full Software Development Life Cycle (SDLC) specializing in the areas of business requirement analysis, design and implementation of Oracle PL/SQL developer.
• Proficient in understanding business processes / requirements and translating them into technical requirements. Communicating with business customers and End Users in understanding and gathering requirements.
• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance.
• Strong Knowledge on oracle architecture and database design.
• Excellent conceptual knowledge of Oracle 9i/10g, PL/SQL. Extensive and proven experience writing simple and complex SQL queries using Joins, Analytical Functions, Inline views.
• Extensive experience as Oracle Application Technical Developerin implementation, upgrade and customization of Oracle e - Business Suite Applications(R12, 11i).This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Extensive experience writing Database Triggers, Stored Procedures, Functions, Cursors and Packages using PL/SQL.
• Experience in advanced PL/SQL concepts for Bulk Operations using Bulk collect, Bulk Exception, Collection and FORALL.
• Expertise in implementing the complex business requirements and creating business rules using Oracle Data Integrator(ODI) 11g/10g and exposure to ODI 12c.
• Experience in Database design using Normalization and E/R Diagram.
• Extensive experience in database programming using SQL and PL/SQL following industry best practices.
• Provided technical support to users in GIS and data efforts.
• Good Knowledge of Multi organization Access control (MOAC) architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Strong knowledge in front end development using oracle forms/reports6i/9i/10g.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• UsedGithubrepository to run the Jenkins job for Continues Integration.
• Experienced in deploying Customizations, Extensions and Personalization's in Standard and Custom Built Oracle Forms, Self Service Pages (OA Pages), workflows, AME, etc.
• Designed and developed interfacefor online and mobilebankingapplications.
• Implemented Single Node instance toRACand added instance to the existingRAC.
• UploadedCrystal Reportsusing Crystal ReportsEnterprise Server.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications
• Expertise in loading data from legacy systems using SQL*Loader.
• Strong experience with building / administering12c/11g RAC on ASM environments running on Linux, Solaris.
• Experience in Database modeling and database object definitions using tools like Oracle Designer.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Strong knowledge on OLAP components development.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Experience in writing Technical design documents and developing unit test documents.
• Supported integration and end user testing with efficient defect management process.
• Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Strong Analytical, Problem solving and communication skills.
• Extensively involved in communicating with the onsite users in resolving the issues and contributing my part of technical support to the team.

TECHNICAL EXPERTISE:

Databases: Oracle11g/10g/9i, SQL Server, MS Access.

Scripting: SQL, PL/SQL, UNIX Shell Scripting.

Languages: C, C++, XML, HTML.

Operating Systems: Windows 2000/XP, UNIX, LINUX

GUI: Oracle Forms 6i/9i/10g/11g and Reports 6i/9i/10g/11g.

PROFESSIONAL EXPERIENCE:

Confidential- Oneonta, NY

Sr. Oracle PLSQL Developer

• Design, develop and conduct unit test plans for ensuring application code is functioning correctly.
• Strong knowledge on converting SQR reports into PL/SQL .
• Experience in Banner8 and diagnose, repair and maintain connections from Banner to 3rd party applications.
• Experince in Argos Datablocks.
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Worked closely with front-end engineer to design and tweak RESTFUL APIused by the frontend.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Created Stored Procedures for Batch Processing and also involved in moving large data using Bulk Insert for all methods.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
• Supporting team on database issues.
• Have supported huge data load (ETL) and report generation process as DBA in Warehouse environment.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Worked on upgrade project fromSOA11g to SOA12c.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms 10g.
• Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote UNIX scripts to automate loading files into database using error handling and notification.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Involved in Troubleshooting performance issues and bugs within packages and stored procedures using DBMS output and explain plan.

Environment: Oracle Applications R12, SQR,Banner8,Banner9,Oracle 12c,Oracle Data Integrator 11g, Oracle 11g,Oracle Forms 10g, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Korn), SQL*loader, Stored Procedures/Triggers, XML.

Confidential- New York, NY

Sr. Oracle PLSQL Developer

Responsibilities:

• Responsible for requirements analysis, database design, development and unit testing of the application.
• Involved in the full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• 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 Queries, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Maintain the Oracle 11g RAC environment and troubleshoot performance problems.
• Install & Manage Oracle Application server 11g cluster for Oracle forms & reports for high volume reporting applications.
• Responsible for the completion of process analysis, identifying procedural and control deficiencies, recommending and implementing solutions as it related topayroll systems.
• Worked with client to build two new capability team usingagile values and principles. All team members were new toagileand did not have any type of formal .
• Designed database tables using various normalization techniques and database rules.
• Experience with industry standard methodologies such asAgilein various software development project.
• Design & Implement a Role Based Access Control(RBAC) consistent with OracleBest Practices for logical access controls.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Supporting huge data load (ETL) and report generation process as DBA in Warehouseenvironment.. Extensive knowledge on ETL and reporting query tuning in date warehousesystem.
• Created DBMS SCHEDULER enables scheduling and automated execution of PL/SQL blocks, stored procedures, and external procedures and executables.
• Ensured data integrity between systems (Oracle AgilePLM) and system documentation.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked with PEGA developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Created some oracle objects for OLAP.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle Applications R12, Oracle 12c,Oracle Data Integrator 11g, Oracle 11g,Oracle Forms 10g, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Korn), SQL*loader, Stored Procedures/Triggers, XML.

Confidential - Denver, CO

Sr. Oracle Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Interacted with business team to extract all the requirements and prepare the URS documents.
• Provided troubleshooting assistance to all issues and concerns related to Oracle forms.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Extensive use of Oracle APEX to generate complex reports using MODPLSQL .
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
• Generated PL/SQL scripts to create and drop a number of database objects including tables, primary keys, Views, Indexes, constraints, packages, sequences, synonyms and grants.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Migrated DB tables from Oracle 10g to Oracle 11g and altered tables with new data types .
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Install & Manage Oracle Application server 11g cluster for Oracle forms & reports for high volume reporting applications.
• Worked with functional consultant to implement Banner agent.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Created user, views and tablespaces, allocation of appropriate tablespace quotas with necessary privileges and roles for Oracledatabases.
• Supported Banner Student System, troubleshooting and resolving problems supported multi-campus Banner users by writing detailed user menu procedures for individual Banner and customized processes also assisted Banner users with verbal instructions to resolve any problems. converting HR/Payroll and Student modules data from Legacy system SQL server database to Banner system Oracle database using PL/SQL
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Involved in the full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Generated PL/SQL scripts to create and drop a number of database objects including tables, primary keys, Views, Indexes, constraints, packages, sequences, synonyms and grants.
• Install & Manage Oracle Application server 11g cluster for Oracle forms & reports for high volume reporting applications.
• Actively involved with DBA for deployment of objects to production environment.
• Tuned Report performance by using latest Oracle built in functions and writing complex SQL statements.
• Developed the shell script, SQL*Loader script, and most of PL/SQL stored procedures, triggers and Views to handle the Online and Batch process .
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Generated quick reports to clients using ODBC connection to Oracle database.
• Design & Implement a Role Based Access Control (RBAC) consistent with OracleBest Practices for logical access controls.
• Worked on Production tickets, received production calls and worked on troubled reports.
• Developed test plan documents for all back end database modules.
• Responsible for documentation of the interfaces.
• Writing Unix Shell Scripts to run batch jobs, automated processes, and to automate routine systems administration tasks.

Environment: Oracle Applications R12, Banner,Oracle Data Integrator11g, Oracle 10g,Oracle Forms 10g, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Korn), SQL*loader, Stored Procedures/Triggers, XML, Sun Solaris 5.6.

Confidential - Chicago, IL

Sr. Oracle Developer

Responsibilities:

• Analysis of business requirements and converting business rules into design software to meet the requirements.
• Created SQL*Loader control files for loading the data from flat files to staging area tables.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Creating the database objects like tables with necessary constraints, views, sequences and reverse engineer in ODI Designer (Model) to use in package/interface.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER, etc.
• Participated in the installation and configuration of OracleBI EE 11.1.1.7 andOracle DataIntegrator11g.
• Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Created Bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

Environment: Oracle Applications R12,Oracle Data Integrator 11g,Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g.

Confidential, Pittsburg, PA

Sr. Oracle Developer

Responsibilities:

• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Developed and modified procedures, functions, triggers, forms, reports and deployed the changes in the system.
• Developed user interfaces using Oracle Forms.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Responsible for creation of new users and setting up privileges and policies for protection of data.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 9i, Reports9i.

Confidential - Peoria, IL

PL/SQL Developer

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Created database Triggers for the security purposes.
• Involved in Control File Format in SQL*LOADER.
• Creating SQL, Object Views, and PL/SQL database objects. Written the interface stored Procedures for data transformation.
• Performed Performance Tuning using the DBMS PROFILER package, this checks the run time Behavior.
• Developed test plan documents for all back end database modules.
• Responsible for documentation of the interfaces.
• Developed User Interfaces (forms 6i ), Stored Procedures ( PL/ SQL), Reports (sql )
• Writing Unix Shell Scripts to run batch jobs, automated processes, and to automate routine systems administration tasks.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.

Environment: Oracle database 9i, Forms 6i, PL/SQL, SQL Plus, SQL*LOADER, TKPROF, TOAD, and UNIX.

Confidential

Oracle Developer

Responsibilities:

• Involved in various stages of the project life cycle mainly requirements, analysis, design, coding, testing, and implementation of the application.
• Working with cross-functional teams studying the impact analysis and was involved in converting the business requirements into technical design document.
• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Modified several SQL*Loader scripts to handle new feeds from different sources and load data into the database from several sources.
• Data was loaded into temporary table from a flat file and then into interface tables.
• Used TOAD and SQL Developer tool for application development.
• Support and modify existing code.
• Extensively used error and exception handling techniques.
• Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day modified.
• Involved in development, maintenance ofTriggers, Joins, Cursorsand Views.
• Performed database Normalization and de-normalization tasks.
• Involved in managing application user setup, defining responsibilities.

Environment: Oracle 9i, SQL*Loader, SQL*Plus, TOAD.