SUMMARY

• A competent professional over 5 years of extensive experience in developing oracle applications using Oracle 12c/11g/10g/9i/8i, PL/SQL, in diverse sectors including Finance, banking, Healthcare, and Manufacturing.
• Well versed in developing various database objects like Tables, Packages, Stored Procedures, Functions, Triggers, Indexes, Constraints, Materialized Views and others in Oracle 12c/11g/10g /9i database.
• Extensive experience in Performance tuning and optimization using execution plans.
• Design and Develop Oracle Interfaces and Conversions using SQL Loader.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi - tier and client/server architectures.
• Extensively worked in Client-server application development using Oracle Forms Builder 11g/10g/6i, Reports 11g/10g/9i/6i, BI Publisher.
• Migrated oracle forms from Version 6i to 10g and 11g. Enhanced functionality by using latest features and utilities.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Extensive experience in Data Migration, ETL & Content Management, implemented various Extraction, Transformation and Loading architectures involving tools and technologies such as ETL Tools, XML, XML Schema, SQL Loader, PL/SQL, Materialized views.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind (forall) features with Collections instead of using cursors and FOR loops, and DBMS PROFILER package and GET TIME in DBMS UTILITY package
• Developed various reports including master detail reports with multilevel grouping.
• Experience in developing and modifying existing UNIX shells scripts and scheduling the jobs using Autosys, Control-M and monitor the batch processing.
• Proficient in loading data from flat files into database tables using External Tables, UTL Utilities.
• Experience in BI suite - using integration services (SSIS), ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports.
• Expert in creating various types of reports like complex drill down, drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience working with Core Java and Java Multi-Threading application.
• Experience in Java/J2EE, Hibernate, Spring arch, Html, JSP, .NET.
• Used Pragma Autonomous Transactionto avoid mutating problem in database trigger.
• Worked on automating data loading, extraction, reports generation using UNIX Shell scripting.
• Experience in handling very large data files using Export-Import Utilities and SQL*Loader.
• Extensive programming knowledge in PL/SQL, SQL*Plus, TOAD, SQL*Loader.
• Wrote stored procedures and UNIX scripts as a part of ETL Process.
• Worked in C language and Oracle database programming (PL/SQL, Pro*C) on UNIX, Windows and Web-based applications.
• Experience working in processes like Agile Scrummodel and Water fall model life cycles.
• Efficient in creating Test cases and performed data validation and process testing for application moving into production.
• Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure the timely release of project.
• Proven ability to work efficiently in both independent and team work environments.
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open items.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i/8i,, SQL Server 2005/2009, DB2

Languages: SQL, PL/SQL, C/C++, JAVA, .net, XML, XSLT, UNIX Shell Scripting, Java Scripting.

Oracle Tools/ GUI: Forms 11g/10g, Reports 11g/10g

Database Tools/ Query Tools: TOAD, PLSQL Developer, SQL*DEVELOPER, SQL*Loader, Oracle SQL*Plus, SQL Navigator, BI Publisher.

ETL/ Data ware housing Tools: Oracle Data Integrator, Oracle Warehouse Builder, ODI, Informatica

Reporting Tools: Qlik View 11.2/10.0/9.0

Web Technologies: HTML, HTML5, XML

Oracle Utilities: SQL Loader, UTL FILE, TRACE, TKPROF, DBMS Utilities, etc.

Operating Systems: Windows Family, Mainframes, HP Unix, Sun Solaris, Linux

Version Control Systems: Visual Source Safe, IBM Rational Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Southfield, MI

Oracle PL/SQL Developer

Responsibilities:

• Developing highly complex applications using Oracle 11g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Participated in system analysis and data modelling, which included creating Tables, Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Utilized External tables to load flat files into database tables.
• Created PL/SQL based ETL process to transfer data from sources.
• Developed conversion programs to bring Legacy details into Oracle table using External tables, PL/SQL Package and populated data into base tables.
• Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, various Complex Triggers.
• Designed and developed Web-enabled Oracle Forms & Reports.
• Developed UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
• Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters and Program Units by using PL/SQL procedures and functions.
• Analyzed data, designed and developed Oracle forms, layout, report triggers, parameter form, data models.
• Tested the Forms, debugged and fixed it after the testing.
• Scheduled jobs using crontab in UNIX.
• Worked on PL/SQL tool TOAD to run SQL queries to validate the data.
• Developed forms using forms 9i based on business requirements.
• Using UNIX Shell scripting created batch jobs to create index and analyze tables once the imports are done.
• Monitor operational environment to ensure internal and customer Service Level Agreements are met.
• Worked in Visual Studio to maintain the code change sets.
• Testing of production fixes in the test environments to ensure they have resolved given issue as well as ensure production fixes do not cause other issues.
• Extensive knowledge and experience in Team Foundation Server including re-designing the old methodology used.
• Ability to design, develop, and conduct unit test plans to ensure application code is functioning correctly.
• Worked on all type of Analytical Functions (RANK, DENSE RANK, LAG, LEAD, FIRST, LAST etc.).
• Active in coding some of the Core Java implementations, used Core Java concepts such as collections, generics and multi-threading.
• Experience working with Core Java and Java Multi-Threading application.
• Worked on JSPs, Java Script, CSS and tag libraries on the UI side.
• Patient dealing with demanding users coming from different cultures and countries.
• Responsible for performance tuning activities in oracle.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks as well as performance tuning.

Environment: UNIX, oracle forms10g, oracle Reports, Oracle Database 11g, TOAD, PL/SQL, Oracle Developer Suite 10g, PUTTY.

Confidential, Rochester, NY

Oracle Forms and Reports developer

Responsibilities:

• Developed highly complex applications using Oracle 10g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and worked on Oracle databases which is to develop and maintain for the real production environments.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Participated in system analysis and data modeling, which included creating Tables, Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Utilized SQL*Loader to load flat files into database tables.
• Created PL/SQL based ETL process to transfer data from sources.
• Used OracleJDeveloper to support JAVA, JSP and HTML codes used in modules.
• Used PL/SQL developing to load data from the source table to the target table based on the business logic.
• Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
• Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, various Complex Triggers.
• Designed and developed Web-enabled Oracle Forms & Reports.
• Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters and Program Units by using PL/SQL procedures and functions.
• Analyzed data, designed and developed Oracle forms, layout, report triggers, parameter form, data models.
• Developed complex triggers in reports before/after for validation of user input on the application system.
• Extensive experience in developing applications using Java and related technologies using WATERFALL and AGILE (SCRUM) methodologies.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix.
• Developed UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
• Worked on Oracle Web Apache Server for configure of upload and download with the required Oracle forms refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.
• Tested the Forms, debugged and fixed it after the testing.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Responsible for performance tuning activities in oracle.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Worked and developed different forms and reports.

Environment: Oracle 10g, Oracle forms 11g/10g, Oracle Reports 9i, SQL Developer, Erwin, TOAD, Query Direct, SQL Plus, SQL * Loader, Aginity, PgAdmin, Tableau.

Confidential

Jr. Oracle PL/SQL Developer

Responsibilities:

• Developed the SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views.
• Created database Triggers for the security purposes.
• Loaded the data into database using the SQL*Loader from various sources.
• Creating SQL, Object Views, and PL/SQL database objects. Developed the stored procedures for data transformation purposes.
• Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Developed test plan documents for all back-end database modules.
• Responsible for unit testing, and documentation of the interfaces.

Environment: Oracle 10g, Oracle forms 6i/10g, Oracle Reports 6i, EBS, Unix, TOAD, SQL*Plus, SQL*Loader, XML Publisher, Shell Scripting.