PROFESSIONAL SUMMARY

• Over 9+ years of IT experience as an Oracle PL/SQL developer with the strong background of working knowledge in all the phases of System Analysis, Designing, Testing, Development & Support of Oracle 12c/11g/10g with strong analytical, programming skills and having solid functional experience in the production, development, implementation and the maintenance of oracle database.
• Excellent hands - on experience in PL/SQL and well versed with advanced PL/SQL Concepts viz. cursors, exceptions, database triggers, database packages, procedures & functions, Dynamic SQL.
• Proficient in utilities such as SQL*Plus, Import/Export and tools such as Toad, SQL Developer.
• Excellent conceptual knowledge of Oracle10g/11g/12c, PL/SQL and SQL.
• Excellent SQL skills, experience in writing complex queries and working with database objects (i.e. tables / views etc).
• Experience in Query Optimization, performance and tuning (PL/SQL) using Explain Plan, Indexing and Hints.
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Experienced in working with many complex SQL queries with joins, date functions, cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.
• Experience in different phases of Oracle Application implementation life cycle including Technical Design, Data Conversion, Forms design and Reports development, Unit Testing, Integration Testing, End User Training and production Support.
• Expert in maintaining data integrity using various constraints and database triggers.
• Experience withAGILE Methodologies and ServiceNow tool.
• Excellent conceptual knowledge ofOracle E-Business Suite/ Applications 10g and 11gdeployment requirements, Coding/Development, Customizations, Testing, and Functional User Training.
• Extensively involved in all the phases of SDLC (Software Development Life Cycle). Preparation of impact analysis, Coding, System Test Plan, Testing, Code Review, coordinating user training, UAT, Project demonstration, Implementation and Maintenance.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels of Business, Engineering, QA and other teams involved with System Development Life cycle.
• Flexible and versatile to adapt to new environment and working on new projects and Committed to continuous improvement, excellent communications, and project management skills.
• Good knowledge of using Function Based Indexes, Sequences and Inline Views.
• Good knowledge of Snowflake cloud data warehouse and Erwin which is an ETL tool.
• Expert knowledge in using data modeling tools like ER diagrams with Normalization Techniques for designing database with Relational technology.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g/12c/18c, MS SQL Server 2008R2/2008/2014

Languages: SQL, PL/SQL, UNIX shell scripts, XML, HTML, Java, Python

Tools: SQL Developer, SQL*Plus, SQL*Loader., TOAD, Erwin 7.2, Version one, Service now, SharePoint

Application Packages: MS Office

Operating Systems: Windows 2000/NT/XP, UNIX, Windows Server 2003, Windows 8/10 XP.

Architecture: RDBMS, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Oracle Developer

Responsibilities:

• Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
• Actively involved in scrum meetings for requirement analysis, task analysis, progress discussions
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
• Develop stored procedures for database operations and manage database upgrades in timely manner.
• Involved in implementation and testing ofOracle Applications FinancialR12 GL, AP, AR and CMmodules.
• Identify and quantify data issues within the organization and assist in the development plans to resolve data issues.
• Wrote UNIX Shell scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file.
• Design scripts and develop tools to automate periodic task and improve monitoring of system.
• Create PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Develop materialized views for data replication.
• Involved in the continuous enhancements and fixing defects for existing code in production environment.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Collaborate with various departments and perform research on all data processing functions.
• Worked in Identifying and requirements and developing models according to the customer’s specifications and drafting detailed documentation for the same.
• Partitionedthe fact tables to enhance the performance.
• Participated in peer review meetings and performed individual code reviews with the Data
• Create and manages test scripts for the development releases.
• Create bitmap indexes on low cardinality columns as they result in reduced response time for queries & reduction of storage space.
• Gather business requirements and provide reports for the project.
• Developed test plans, scripts and conducted testing in ALM (Application Life Cycle Management Tool) for quality assurance.
• As a part of support activity resolve incidents by provided with proper root cause investigation.
• Created database tables and wrote database triggers applicable to business rules.
• Used Snowflake functions to perform semi structures data parsing entirely with SQL statements.
• Involved in creating and changing Business objects, windows, data windows, functions and menus using Power Builder.
• Involved in the development of Code using Power Builder 12.
• Application development & maintenance support for database objects.
• Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Involved in walkthrough sessions with business users during Analysis and Designing phase.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.

Environment: Oracle 11g/12c/18c, SQL Developer, SQL * Plus, DB visualizer, UNIX, Windows, SQL, PL/SQL, Erwin, Version One, Service now, ALM.

Confidential

Oracle Developer

Responsibilities:

• Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
• Actively involved in scrum meetings for requirement analysis, task analysis, progress discussions
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
• Develop stored procedures for database operations and manage database upgrades in timely manner.
• Identify and quantify data issues within the organization and assist in the development plans to resolve data issues.
• Wrote UNIX Shell scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file.
• Design scripts and develop tools to automate periodic task and improve monitoring of system.
• Develop materialized views for data replication.
• Involved in the continuous enhancements and fixing defects for existing code in production environment.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Collaborate with various departments and perform research on all data processing functions.
• Worked in Identifying and requirements and developing models according to the customer’s specifications and drafting detailed documentation for the same.
• Partitionedthe fact tables to enhance the performance.
• Participated in peer review meetings and performed individual code reviews with the DataArchitect attaching unit testing results.
• Create and manages test scripts for the development releases.
• Create bitmap indexes on low cardinality columns as they result in reduced response time for queries & reduction of storage space.
• Gather business requirements and provide reports for the project.
• Created database tables and wrote database triggers applicable to business rules.
• Application development & maintenance support for database objects.
• Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Involved in walkthrough sessions with business users during Analysis and Designing phase.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.

Environment: Oracle 11g/12c, SQL Developer, SQL * Plus, UNIX, Windows, SQL, PL/SQL, Erwin, ALM.

Confidential, Herndon, VA

Oracle PL SQL Developer

Responsibilities:

• Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
• Actively involved in scrum meetings for requirement analysis, task analysis, progress discussions
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
• Develop stored procedures for database operations and manage database upgrades in timely manner.
• Identify and quantify data issues within the organization and assist in the development plans to resolve data issues.
• Wrote UNIX Shell scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file.
• Design scripts and develop tools to automate periodic task and improve monitoring of system.
• Develop materialized views for data replication.
• Involved in the continuous enhancements and fixing defects for existing code in production environment.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Collaborate with various departments and perform research on all data processing functions.
• Worked in Identifying and requirements and developing models according to the customer’s specifications and drafting detailed documentation for the same.
• Partitionedthe fact tables to enhance the performance.
• Participated in peer review meetings and performed individual code reviews with the DataArchitect attaching unit testing results.
• Create and manages test scripts for the development releases.
• Create bitmap indexes on low cardinality columns as they result in reduced response time for queries & reduction of storage space.
• Gather business requirements and provide reports for the project.
• Created database tables and wrote database triggers applicable to business rules.
• Application development & maintenance support for database objects.
• Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Involved in walkthrough sessions with business users during Analysis and Designing phase.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.

Environment: Oracle 11g/12c, SQL Developer, SQL * Plus, UNIX, Windows, SQL, PL/SQL, Erwin.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Wrote Procedures, packages, SQL sub queries & PL/SQL fundamentals to ensure that data is populated into the correct tables & data integrity is maintained.
• Developed applications by using SQL queries & implemented PL/SQL codes by using Procedures, Functions, triggers & Packages.
• Experience in different phases of Oracle Application implementation life cycle including Technical Design, Data Conversion, Forms design and Reports development, Unit Testing, Integration Testing, End User Training and production Support.
• Executed & maintained SQL & PL/SQL statements to insert update & delete database applications by using tables, views, constraints & packages.
• Involved in installation and configuration of Oracle APEX listener and Application Express on customer servers.
• Designed, developed & maintained oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops.
• Analyzed & overviewed the database design for better understanding the relations, associations & dependencies within the database.
• Created SQL Loader scripts to load data into the temporary staging tables.
• Extensively used SQL loader to load data into the database.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables & efficient database design.
• Utilized performance enhancements feature of Oracle to optimize query & the batch processes.
• Created procedures & workflows pertaining to the collection & assessment of information.
• Optimized the queries.
• Performance tuning of SQL Stored Procedures.

Environment: Oracle 11g, Oracle 10g/9i, Oracle 10g development suite, SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, UNIX, Windows.

Confidential, Beaverton, OR

Sr.PL SQL Developer

Roles and Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers and functions
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Loaded source data (flat data files, XML files) into Oracle database tables using SQL Loader.
• Transform source data (flat files and tables) based on client business rules, then load into staging tables, followed by SQL scripts to load from staging tables to target.
• Troubleshoot performance tuning issues, using Oracle explain plan to determine resolutions.
• Created documentation of all projects/tasks. Writing Functional Technical Specifications.
• Recommended fixes and solutions when reported by clients or through my own investigation.
• Creation of unit test plans and unit test documentation
• Performed testing, writing load scripts, technical installation documents, also worked as DBA / Developer / Extract, Transform and Load (ETL) processes needed to develop, manage, maintain, performance tune star and snowflake data warehouses
• Used TOAD for program development. Used Dynamic SQL, Database designing, Performance tuning, Database developing, Bulk processing using collections.
• Worked with Java and ETL developers to design dimensional data models and code
• Resolving data issues, writing various technical documentation, verbal and written communication skills, problem solving skills, customer service and interpersonal skills.

Environment: Oracle 11g, Oracle 10g/9i, SQL*Loader, SQL Plus, MS Access, UNIX Shell script, TOAD, UNIX, Windows.

Confidential

PL SQL Developer/Production Support

Responsibilities:

• Monitoring the batch job in UNIX environment.
• Developed the PL/SQL procedures for retrieving the data for oracle database.
• Interacted with Team in Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system
• Developed SQL Stored Procedures, Tuned SQL Queries (using Indexes).
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Incorporated the functionality for tax calculation for AR invoice.
• Worked on tax engine for AP invoice to incorporate the functionality for new warehouse in contract manufacturer.
• Developed new report for Fixed Assets to find out the assets assigned to terminate employees and assigning them to their managers/supervisors.
• Developed new report for Purchase Requisitions approved within specified date range.
• Provided techno functional support for production issues in Forms, Reports, Pl/Sql Packages/ Procedures.
• Developed Outbound Interface for generating CSV file on DB server by using the UTL FILE Package.
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: Oracle 10g, SQL Developer, SQL*Plus, PL/SQL, Query Analyzer, UNIX Batch Jobs