SUMMARY

• About 9 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications using the Oracle Relational Database Management System (RDBMS), SQL, and PL/SQL on different platforms like Windows, UNIX and Linux.
• Good experience of Performance Analysis and SQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, Explain Plan.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on database.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Hints, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Proficient in Oracle 12C/11g/10g/9i/8i/7.3, PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Experience with data flow diagrams, data dictionary technique
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table Partitioning.
• Experience in creating shell script, to data loads from flat files into the database.
• Developed many front-end applications using APEX 4.2.2
• Assist in design and development of large-scalePerlapplications and Created Perl scripts usingDBI/DBDfor data extraction
• Experience in FTP to SFTP file system migration
• Experience in Informatica migration from 9.1 to 10.0
• Worked on Oracle Forms 12c/11g/10g/9i/6iReports 11g/10g/9i/6i.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Extensively used PL/SQL to build Oracle Reports 12c/11g/10g and views for processing data, enforcing referential integrity and needed business rules.
• Experienced in Tuning Queries for better performance with large volume of data. Extensive experience in developing applications using XIDOCS Forms / Reports.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes usingUNIXshell scripting,SQL,PL/SQL,andSQLLoader.
• Reasonable understanding in CORIC reporting tool
• Expertise in implementing ETL (extract, transform and load) by using) Informatica and Oracle Data Integrator.
• Experience in migration of source code using version control system - GIT, Stash, Source Tree.

TECHNICAL SKILLS

Operating systems: UNIX, LINIX, Windows VISTA/XP/2000/98, MS DOS, MAC

Languages: SQL, PL/SQL, Unix Shell Scripts, HTML, XML.

RDBMS: Oracle 12c/11g/10g/9i/8i, MS-SQL Server 2000/2005, Sybase, DB2, MS Access.

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer, TOAD, Rapid SQL

GUI Tools: APEX 4.2,3.2, Golden gate, Autosys, Control-M, JIRA and QC quality center.Informatica 9.1/10

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Oracle PL/SQL Developer

Responsibilities:

• Development, documentation, Design, Code reviews and unit testing of database
• Creating Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms and User Defined Data Types, Dynamic SQL, Global Variables
• Developing Informatica Work flows, Mapping and stage load
• Scheduling and supporting Control M and Autosys Scheduler jobs.
• Maintenance/Support of the existing components including database and batch for all the Tracks.
• Data engineer Support, Maintenance and Development for downstream support systems. Used Explain Plan for performance tuning of the code.
• Migrated the script changes from development to test and production environments.
• Involved in System Testing and UAT (User Acceptance Test) with multiple Business Scenarios.
• Co-wrote Test plan and Created Test Scenarios.
• Support that involves trouble-shooting, problem analysis and solving user problems.
• Part of all agile ceremonies including daily scrum, Release planning, Iteration planning etc.
• Created shell scripts for data loads.

Environment: Oracle12C/10g/11g, SQL*Plus, SQL, PL/SQL, SQLDeveloper, EXPLAIN PLAN, Informatica, XDIOC and CORIC reporting tools.

Confidential, Durham, NC

Senior Data Engineer

Responsibilities:

• Development, documentation, Design, Code reviews and unit testing of database
• Creating Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms and User Defined Data Types, Dynamic SQL
• Developing Informatica Work flows, Mapping and stage load
• Scheduling and supporting Control M and Autosys Scheduler jobs.
• Maintenance/Support of the existing components including database and batch for downstream consumers.
• Provided an automated script solution and developed to reduce manual intervention on data requests from source systems and downstream as well
• Data engineer Support, Maintenance and Development for downstream support systems.
• Part of all agile ceremonies including daily scrum, Release planning, Iteration planning etc.

Environment: Oracle 11g/12c, Oracle, Apex4.2.2, SQL Developer, HP QC, Informatica Power Center 10,Putty,GIT hub, ODI, SQL*Plus, SQL, PL/SQL, SQLDeveloper

Confidential, Durham, NC

Oracle PL/SQL Developer/ Oracle Apex Developer

Responsibilities:

• Developed, modified, and optimized complex queries for data retrieval and modification.
• Involved in designing and developing various interactivereportswith column filters for managing Applications usingOracleApplication Express.
• Involved in SSO Configuration set for Users
• Created a data design for dynamic report lay out driven from data base completely
• Developed and modified PL/SQL, procedures, functions, triggers, reports as per business requirements
• Created and configured session as well as used various partitioning techniques such as key-range, hash key and round robin partitioning to provide faster execution of ETL process
• Provided end user training and Production System Support.
• Used various transformations like Source qualifier, expression, joiner, router, and filter.
• Developed and supported four User Interface Tools from Scratch in Oracle Application Express.

Environment: Oracle, Apex4.2.2, SQL Developer, HP QC, Informatica Power Center 9.1, ODI HTML, Java Scripting, PL/SQL, Data Modeling, Autosys JIL Scripting

Confidential

Senior System Analyst/ Oracle PL/SQL Developer

Responsibilities:

• Responsible for creation of technical specifications document for various mappings. & End user training to the business users.
• Involved in the design, development and implementation of Customer Analytics Data mart.
• Used various transformations like Source qualifier, expression, joiner, router, and filter.
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Developed and modified PL/SQL, procedures, functions, triggers, reports
• Provided end user training and Production System Support.

Environment: Putty, Rapid SQL, Toad, HP - Quality Center, Informatica Power Center 9.1

Confidential

System Analyst/Developer

Responsibilities:

• Worked in Structured Rules Language.
• Enhanced stored Process Logic in Sybase Database
• Performed Tuning to optimize the application Performance
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.

Environment: Putty, Rapid SQL, Toad, HP - Quality Center, Perl script, Shell scripts, UNIX, PL/SQL