SUMMARY:

• 6+ years of IT experience in Implementation, Design and Development of Client/Server & Web - server applications using Oracle on UNIX & Windows Platforms.
• Expertise in Oracle 12c/11g/10g/9i/8i, SQL, PL/SQL, and UNIX shell scripting.
• Experience in application software analysis, design, development, implementation, maintenance, and documentation of commercial applications through out various phases of project life cycle.
• Proficiency in analysis, design, development, testing, implementation, and maintenance of applications in Oracle Forms and Reports and client/server configurations.
• Experience with Database developmen Confidential , ETL, OLTP and OLAP analysis and reporting processes.
• Interacting with Business users, gathering and analyzing requirements.
• Experienced in System Analysis, design and implementation . Logical and physical data modelling . Monitor database performance & Tuning
• Good understanding of Oracle data dictionary and normalization techniques. Experienced in Oracle 10g/9i/8i/8.x/7.x systems, SQL*Loader, Export, Import and SQL*Plus.
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships.
• Hands-on experience with Oracle Forms and Reports 11g/10g.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Experience in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL. Enforcing data integrity using integrity constraints & database triggers.
• Experience in generating customized Forms and Reports using Oracle Forms and Reports.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures. Loading data from flat files into database tables using SQL*Loader.
• Automating data loading, extraction, reports generation using UNIX Shell scripting (Bourne shells).
• Wrote and modified Oracle PL/SQL, Sql statements procedures and functions that are called in the Java Scripts
• Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Experience in developing applications using forms (11g/10g/9i/ 6i) and reports (11g/10g/9i/ 6i) . Well experienced in backend programming (Triggers, Procedures, and Functions) using Oracle 11g/10g/ 9i/8i/8.x and web enabled application development and deployment using Oracle application server.
• Experienced in loading data using SQL *loader and using SQL *Plu s.
• Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc. for optimization process.
• Expertise in Performance tuning and improved Reports performance in Tableau using extracts and context filters and custom SQL
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan
• Developed Data Mapping and Data Conversion scripts using SQL, PL/SQL.
• Written complex SQL’s using joins, sub queries and correlated sub queries.
• Wrote Test cases and performed data validation and process testing for application moving into production. Excellent in problem solving, logical and analytical abilities.
• Team Player with Analytical skills, ability to quickly adept to new environment and available as needed for .
• Ability to work independently and as part of a team, deliver under pressure and tight deadlines.

TECHNICAL SKILLS:

RDBMS & software: Oracle 12c/11g/10g/9i/8i, Developer 11g/10g/9i/6i suite (Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i), Oracle Designer 2000/6i, SQL*PLUS, Server Manager/SQL*DBA, Export/Import, SQL*Loader, JIRA, Tortoise SVN, Erwin, Toad, Oracle Enterprise Manager Informatica Power Center 9.5/9.1, Flat Files, Excel Files and reports.

Languages: SQL, PL/SQL, Unix shell scripting (Bourne shells)

Windows: 2000/NT/98/95, Red hat Linux, MS-DOS

Languages and Web Technologies: SQL, PL/SQL, Java, XML, HTML/XHTML.

WORK EXPERIENCE:

Confidential, Manhattan, NY

Oracle Developer

Responsibilities:

• Involved in all stages of software lifecycle development. Analyze, design, develop, testing and production release for data base objects.
• Interacted with business users to understand the business requirements and explained them what to do in technical point of view for requirement.
• Developed database objects for integrating the Gas Work Tracker user interface application which was developed by Oracle Forms.
• Involve in all phases of software development life cycle like gathering the requirements, designing the technical document, developing the oracle objects and testing it before going to live.
• Developed Stored Procedures, Functions, Packages and SQL Scripts for database transactions using PL/SQL in Oracle 11g and Java.
• Created interface screens and reports using Oracle Forms 11g/12c and Oracle Reports 11g/12c .
• Migrated the Oracle forms and Reports from 11 g to 12c .
• Developing PL/SQL Procedures Confidential the database level that were used in the mappings through Stored Procedure Transformation.
• Created new project in TFS for Python programming to get the latitude and longitude based on location using google maps API.
• Developed Python code using UI for Geocoding process to get the latitude and longitude depends on address with Google API.
• Developed new database objects like materialized views and created database links to get the latest permit information from one system to another system.
• Performed query tuning and System Performance tuning of Oracle Databases and User applications. working on Advanced PL/SQL techniques including Collections, Materialized views, external table and Bulk Collect for batch transition process.
• Generated reports on weekly and monthly basis as data is loading into target tables correctly or not. wrote a shell script for deleting backup files and repeated files in land directory for every object.
• Working on SQL, PL/SQL development and database support as well as maintenance.
• Developing Oracle DB modules, database triggers, cursors, stored procedures Utilized SQL*Loader to load flat files database tables.
• Working on SQL, PL/SQL and Java API development and database support as well as maintenance.
• Prepared and execution of test plans for unit & system testing.
• Analyzing advanced code with Oracle concepts and query plans, query tuning, partitioning and optimizer hints.
• Coordinate code builds between environments.
• Monitoring the scripts and batch jobs in lower environments to check the performance and result. Monitor the system performance and tuning the SQL codes by reading the explain plans.

Environment: Oracle 12c/11g, Oracle forms 12c/11g, Oracle Reports 12c/11g, SQL, PL/SQL, UNIX, Oracle Sql developer, Toad, TFS, Python 3.2, shell Scripts, SQL*Loader, Windows.

Confidential, Monroeville, PA

Oracle PL/SQL Programmer

Responsibilities:

• Working on SPARCS application and making existing changes and developing new code to enhancing the functionality of the application.
• Developed a process for transitioning patient information and prescription information from legacy Oracle Forms Application to New Oracle database schema tables.
• Wrote stored procedures to parse and analyses CLOB data for business needs.
• Developed a process of sending prior authorization for refund transaction for credit card payment transactions.
• Developed Oracle forms to select the type of payment to pay for specialty drugs.
• Developed many stored procedures and functions to suit business needs and accomplish business objectives
• Development of database triggers, cursors, packages, procedure & functions using PL/SQL & SQL.
• Working on merging anthem patients to SPARCS application.
• Worked on end to end flow in Data Warehouse.
• Involved in transition patients from SPARCS to SPRx application which is built on Java UI.
• Maintain the Packages and Procedures version of changes in SVN.
• Documenting the modifications and enhancements made to the application systems and databases as required by the project.
• Providing support in end to end integrations.
• Developed SQL*loader scripts to load data in the custom tables.
• Developed PL /SQL code for updating payment terms.
• Prepared Handbooks for the application.
• Preparation and execution of test plans for unit & system testing.
• Analyzing the test results and recommending modifications to the applications to meet project specifications
• Developing and implementing the test validations of the applications specifications
• Monitored performance and optimized SQL queries for maximum efficiency.
• Performed unit testing and integration testing for various development applications in ORACLE 12c/11g.
• Supported project application which is built on Informatica mappings and transformations.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Experience in UNIX shell scripts in writing deployment code for migrations.
• Developed PL/SQL Procedures Confidential the database level that were used in the mappings through Stored Procedure Transformation.
• Creation of interface screens and reports using oracle forms and oracle reports.
• Handled various exceptions to troubleshoot PL/SQL code.
• Created indexed views, and appropriate indexes to reduce the running time for complex queries
• Monitoring the system performance and tuning the SQL codes by reading the explain plans.
• Experience in scheduling the jobs in Tivoli.
• Coordinating code builds between environments.
• Used ETL to load the data from various sources into EDW.
• Analyses the warehouse data provided reports for the same.
• Involved in Code Review, Code Walk Through, and Unit Testing.

Environment: Oracle 12c/11g, Oracle forms 11g, Oracle Reports 11g, SQL, PL/SQL, UNIX, Oracle Sql developer, Toad, TFS, shell Scripts, SQL*Loader, Windows.

Confidential, Mclean, VA

Oracle PL/SQL Developer

Responsibilities:

• Analyzing the new Requirements and preparing the design documents.
• Worked on migration of 4G LTE data from multiple legacy systems to EDW for better decision making.
• Developed Oracle Extracts scripts to extract the data and created the staging tables to transform (to map) the data and load into target tables using Unix load scripts .
• Analyzed data, designed and developed Oracle forms 11g queries, layout, report triggers, parameter form, data models etc.
• Developed new codes for data load and modified the existing load scripts to load data into Data Warehouse from different sources as per the requirement.
• Developed Stored Procedures, Functions, Packages and SQL Scripts for database transactions using PL/SQL.
• Development of database triggers, cursors, packages, procedure & functions using PL/SQL & SQL.
• Worked on end to end flow in Data Warehouse.
• Documenting the modifications and enhancements made to the application systems and databases as required by the project.
• Created Triggers, Stored Procedures, Packages and SQL Scripts.
• Developed PL /SQL code for updating payment terms.
• Preparation and execution of test plans for unit & system testing.
• Analyzing the test results and recommending modifications to the applications to meet project specifications
• Developing and implementing the test validations of the applications specifications
• Wrote efficient stored procedures for the optimal performance of the system
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling
• Worked in debugging and tuning the PL/SQL code, explain plan and tuning queries for the Oracle database
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Generated context filters and used performance actions while handling huge volume of data.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Experience in UNIX shell scripts in writing deployment code for migrations.
• Developed PL/SQL Procedures Confidential the database level that were used in the mappings through Stored Procedure Transformation.
• Creation of interface screens and reports using oracle forms and oracle reports.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Utilized SQL*Loader to load flat files database tables.
• Handled various exceptions to troubleshoot PL/SQL code.
• Formulated procedures, functions
• Created indexed views, and appropriate indexes to reduce the running time for complex queries
• Monitoring the system performance and tuning the SQL codes by reading the explain plans.
• Experience in scheduling the jobs in Autosys
• Coordinating code builds between environments.
• Used ETL to load the data from various sources in to EDW.
• Tested the various ETL processes that were developed to fetch data from various feeds coming from Admin System
• Analyses the warehouse data provided reports for the same.
• Involved in Code Review, Code Walk Through, and Unit Testing.

Environment: Oracle 11g, SQL, Oracle Forms & reports 11g, Informatica Power Center, PL/SQL, Explain Plan, Microsoft Excel, UNIX, Toad, Oracle Sql developer, shell Scripts, SQL*Loader.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed Oracle forms, database triggers, cursors, stored procedure
• Developed PL/SQL Packages, Functions. Utilized SQL*Loader to load flat files database tables.
• Utilized PL/SQL developer tool in developing all back-end database interfaces
• Worked on responsible for performing code reviews.
• Developed user documentation for all the application modules. Also, responsible for writing test plan documents and unit testing for the application modules.
• Loaded data from Existing database schema to new schema using Oracle Packages.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like UTL FILE.
• Utilized SQL*Loader to load flat files database tables.
• Involved in the ETL process of developing new tables from the existing views and materialized views.
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Creating SQL, Object Views, and PL/SQL database objects. Developed the stored procedures for data transformation purposes.
• Fixing bugs per the software change requirement.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Worked in SQL, PL/SQL development and database support as well as maintenance.
• Involved in performance tuning - analyzing query plans, query tuning, partitioning and optimizer hints.
• Created database scheduler scripts and applications using UNIX shell scripts, SQL *Plus script.
• Upgraded, maintained and troubleshooter for Oracle Forms and Reports.

Confidential

PLSQL Developer

Responsibilities:

• Worked with team leader, Business Analyst to achieve the company goal.
• Gathered requirement documents coordinating with Business Analyst and other team members.
• Analyzed the Business Requirements Specification Documents and Source to Target Mapping.
• Created different types of object like table, store procedure, Index, Views etc.
• Documents and identified the test requirements.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements
• Pull data on regular basis for business user

Environment: Oracle 9i, PL/SQL, SQL Plus, SQL*LOADER, Windows, UNIX, Explain Plan.