SUMMARY

• Around 6 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.
• 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 with 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 with Project Management, Business Analyst and Department management teams.
• Flexible, enthusiastic and project-oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

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

Other Technologies: HP Project and Portfolio Management (PPM), 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

Data Warehousing: Star & Snow-Flake Schema Modeling, Erwin, Sybase Power Developer, SSIS, SSRS, OWB, ODI

Dev. Tools: Windows/Linux/Mac OS Environment, Eclipse, Git, XCode, CVS.

Tools: TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Crystal Reports, Forms 6i/9i/10g, Reports 6i/9i/10g, Work Flow Builder and XML Publisher.

PROFESSIONAL EXPERIENCE

Confidential, Houston

Oracle PL/SQL Developer

Responsibilities:

• Interacted with the clients to understand the requirements and Designing module wise Oracle 11g database structure and its implementation on the client server.
• Coordinated with the front-end design team to provide them with 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.
• 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 within 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.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Provided Tier3 Application support with 24/7 production support.

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

Confidential, Columbus, Ohio

Oracle PL/SQL Developer

Responsibilities:

• 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 with 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 with 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, then Validate data and then 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.

Confidential, Alpharetta, GA

Oracle PL/SQL Developer

Responsibilities:

• 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 with 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 i.e., Compound triggers.
• Used Global Temporary tables to access the repeated data within 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.

Confidential, Albany, NY

Oracle PL/SQL Developer

Responsibilities:

• 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 with 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 with 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 has 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 Acknowledgement and Sub inventory quantities report.

Environment: Oracle Apps Implementation Releases (12.0.3), Jdev (10.1.3.3) SQL, PLSQL, XML Reports 6i, Forms6i, BI Publisher, Windows 7 and UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• 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: Oracle Applications SCM Modules, Oracle Discoverer Admin and Desktop, PLSQL, Forms 6i, Reports 6i, SSH (UNIX), Windows XP.