PROFESSIONAL SUMMARY:

• Around 9 years of experience in Analysis, Design, Development and Data processing using Oracle Technology on different platforms.
• Extensively worked on PLSQL - Functions, Stored Procedures, Cursors, Triggers and Packages.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table Partitioning.
• Experience wifData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modellinganddesign techniques.
• Expertise in Client-Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Proficient in advance features of PLSQL programming like Records and Collections, Bulk load, Bind variables, Ref Cursors and Dynamic SQL.
• Good Knowledge on Client-Server application development using Oracle PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.
• Experience in designing, modeling, performance tuning and analysis, implementing process using ETL tool Pentaho data Integration tool for data extraction, transformation and loading process.
• Mediation experience in handling Cedar, Cisco, Broad soft, EMI, AMA, IMS and Huawei Switch raw files wif TBMS product.
• Good experience in UNIX and Perl scripts to create reports and logs based on the business prerequisites.
• Worked in Agile Methodology.
• Worked on version control tools such as GitHub, ALM and used JIRA bug tracking tool.
• Experienced in Production Support Role 24/7 to resolve the issues using in a ticketing system.
• Collaborate well wif Project Management, Business Analyst and Department management teams.
• Flexible, enthusiastic and project-oriented team player wif excellent communication skills wif leadership abilities to develop creative solution for challenging requirement of client.
• Worked extensively onRef Cursor, External TablesandCollections.
• Expertise inDynamic SQL, CollectionsandException handling.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Good noledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c, DB2/UDB, SAP Tables and MS Access

Other Technologies: HP ALM/QC, Oracle E-Business Suite 12, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM)

Programming Languages: SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, XML, HTML

Dev. Tools: Windows/Linux/Mac OS Environment, Eclipse, Git, XCode, C.VS and Visual studio

Tools: TOAD, SQL*PLUS, SQL Developer, SQL*Loader and XML Publisher.

PROFESSIONAL EXPERIENCE:

Sr. Oracle PL/SQL Developer

Confidential, Charlotte, NC

Responsibilities Include:

• Interacted wif the clients to understand the requirements and Designing module wise Oracle 11g database structure and its implementation on the client server.
• Coordinated wif the front-end design team to provide them wif the necessary stored procedures and packages and the necessary insight into the data.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Involved in ETL coding using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in writing the database triggers to furnish the audit details.
• Troubleshoot performance issues and bugs wifin packages using DBMS output, explain plan.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developed Unix Shell Scripts to automate backend jobs, load data into the database.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Partitioned the fact tables and materialized views to enhance the performance.
• Define data transfer process through asynchronous web service using REST (HTTP).
• Solid skills to configure Exadata to meet company internal security requirement.
• Fix open ticket as created by users that includes code modification and issue data analysis.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Involved in analysis of report design requirements and actively participated and interacted wif Technical Manager and worked wif Business Analyst to understand the business requirements Provide full support for the team regarding issues, feature discussions and enhancements.
• Worked on DB table partitioning and deploying various methods of indexing like local indexes and global indexes for tables wif huge volumes of data.
• Involved in writing and maintaining many PL/SQL stored procedures and SQL queries for populating the historical and daily data in production using TOAD.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Provided Tier3 Application support wif 24/7 production support.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX Shell Scripting.

Sr. Oracle PL/SQL Developer

Confidential, NYC, NY

Responsibilities Include:

• Participating in Requirement Gathering sessions wif end users.
• Design and Development of the Oracle 12c Code and DB Objects like Tables, Procedures, Functions, Packages and Sequences, according to the System Requirements of the different modules to do the data quality testing.
• Perform tuning of PL/SQL scripts and SQL statements or large datasets.
• Analyze business data using Toad software on Oracle.
• Communicating wif users to collect requests for improving of the data quality.
• Creating and making enhancements to UNIX scripts.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Created shell script to run data stage jobs from UNIX and tan schedule dis script to run data stage jobs through scheduling tool.
• Creating Technical Design for the application, working wif the Infrastructure team.
• Involved in the application development, Peer reviews and Unit Testing.
• Interaction wif the clients on the requirements.
• Analyzing and fixing the issues in the DB and ETL objects.
• Requirement Analysis for the Development of the Change Requests (CRs).
• Preparation of Approach Documents, Release Notes, Unit and Module Test Cases, Application and System set-up Documents.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Involved in writing complex scripts for Data Transformation, ETL process (Extract, Transform & Load).
• Implemented ETLInformatica designs and processes for the load of data from the sources to the target warehouse.
• Responsible for determining the bottlenecks and fixing the bottlenecks wif performance tuning.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, join types and operations and providing hints.
• Review data transformation rules
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Working wif the DBAs and Environmental Engineering teams on the Code deployment.

Environment: Oracle 12c, Web Services, Quality Stage 8.1, OracleSQL,PL/SQL, TFS (Visual studio), Telerik, XML, SQL, PLSQL, SQL Tuning, WinSCP, Putty.

PL/SQL Developer

Confidential, Washington, D.C

Responsibilities Include:

• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Azure Networking-VNET, VPN-S2S, P2S, Express route, Sonic WALL, SSL, Azure VMs, Azure Web/App, Azure Logic Apps, Azure Functions, Azure POWER BI, Azure Billing, Azure Subscription and Account management, Azure NSG, Azure Load Balancer, AZURE ASM to ARM migration.
• Fix open ticket as created by users that includes code modification and issue data analysis.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along wif AWR & ADDM reports.
• Created Shell scripts to access data and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
• Optimized the performance using PL/SQL table types and record types.
• Did SQL and PL/SQL programming for ODI and oracle.
• Developed AR Credit memo and AR Customers forms.
• Worked extensively wif ODI Designer, operator and metadata Navigator.
• Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the clean-up process.
• Played a major role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
• Participate in upgrading Oracle database(s) and Oracle Warehouse Builder to Version 11.2.0.4
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed DAO layers in applications to access the db objects from Java.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, join types and operations and providing hints.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
• Wrote SQL queries to developed test data for use during test execution.
• Perform Inbound Interface by creating Temporary tables, tan Validate data and tan Load into Interface Tables by using SQL Loader.
• Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers.
• DataStage jobs were scheduled, monitored, performance of individual stages was analyzed, and multiple instances of a job were run using DataStage Director.
• Created complicated reports using reporting tool Cognos.
• Used DS Erwin MetaBroker to import Erwin 4.x Metadata into Data Stage Repository.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g.

Sr. Oracle Developer

Confidential, TX

Responsibilities Include:

• Involved in all phases of SDLC from requirement, design, development, and testing.
• Wrote packages, stored procedures for storing the client information and modifying the views to resolve any possible bugs.
• Created database objects such as tables, views, synonyms, indexes and sequences.
• Created views based on multiple tables and performed data changes using Instead of triggers for the underlying tables.
• Setup run time environment, creating and maintaining shell scripts to run stored procedures, packages to populate the valid data in staging tables and invalid data into error tables which will be sent back to sender notifying the errors.
• Constructed the required data involving complex JOIN statements, including outer-joins, intersect and union all.
• Worked wif Collections and improved the performance of multi-row queries by using Bulk Collect and Bulk binds.
• Used DBMS JOB to automate the regular tasks and improve time-constrained performance.
• Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
• Wrote SQL, PL/SQL programs to retrieve data from data repository using cursors and exceptional handling.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Created PL/SQL Procedures, Functions, Triggers and Packages to meet the business requirement of the project.
• Avoided mutating table errors using the new functionality in Oracle 11g me.e., Compound triggers.
• Used Global Temporary tables to access the repeated data wifin a session and improved the performance.
• Used SQL loader for importing the flat files which consists of several records of customer's information into the different tables in the database.
• Performed Unit testing using the PL/SQL code.

Environment: Oracle 11g, SQL, PL/SQL, EXPLAIN PLAN, SQL developer, UNIX.

Sr. PL/SQL Developer

Confidential

Responsibilities me

• Development and Testing of business-critical PL/SQL objects.
• Developed Database Objects like PLSQL Packages/ Procedures/ Triggers/ Views/ Tables.
• Analyzing Data that is interfaced to Externals systems
• Optimizing PL/SQL code and SQL queries by using Explain Plan, Analyze, Indexes and Hints.
• Wrote many database triggers using PL/SQL for validation and business rules.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, mentor others wif the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Customized forms to make changes related to R12 for MOAC changes and tables changes
• Developed major enhancements required for business process to Cash and Procure-to-Pay cycles
• Redeveloped various custom components for R12 upgrade which invoices PL/SQL packages, views, Triggers, Value sets, AOL components.
• Development of a custom PL/SQL report to generate report output in excel format using the customized OWA SYLK package.
• Performance enhancements of critical Objects.
• Responsible for Unit testing, Issue resolution during QA testing and UAT.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination wif the application development team
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed a Custom Invoice Print report, which handles multiple layouts and multiple languages. The invoice report TEMPhas been designed and developed to print on a pre-printed layout.
• Create and define template and data definitions for Open Purchase Order report. Conditionally display company logo information based on run time parameters.
• Created and customized reports using XML Publisher/BI Publisher in Mail Order Acnoledgement and Sub inventory quantities report.
• Coded database triggers, packages, functions, procedures using PL/SQL and maintained the scripts for various data feeds.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets.
• Generated SQL and PL/SQL scripts to install Create and Drop database objects, including Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.
• Documentation of functional document MD70 which includes all the components that needs to be developed as part of the requirement - packages, procedures, table creation scripts etc.
• Providing support at customer site by solving bugs/problems and providing requested business information by building queries and/or extracting required data.
• Code reviews to achieve code optimization to enhance performance.
• Preparation of Unit Test Cases, Defect logs and Issue Log.
• Administrating various support and analytical activities on a regular basis.
• Migration among different environment (Dev\Test\Prod) using ITG Migration.
• Enhancement based on change request mechanism of Dev Track.

Environment: PLSQL, SSH (UNIX), Windows XP