SUMMARY:

• Around 11+ Years of extensive development experience in Oracle PL/SQL, Performance Tuning, Informatica 10.1 as Developer and lead in Agile Methodology Projects and in Telecom and Finance domains.
• 10+ Years of strong development/Data modeling experience in OLAP & OLTP Systems with Oracle 9i/10g/11G/12C PL/SQL.
• 8+ Strong experience into efficient code writing and Performance Tuning at all levels.
• 5+ Years development Experience using ETL tool Informatica 8.6/9.1/9.6/10.1 and Scheduling tool Autosys/Control M.
• Ability to create and manage Indexes, using hints, Partitions on tables for tuning the database and enhance performance.
• Experience to Redshift, Bigdata Hive - SQL and Sqoop for POC project.
• Well conversant in translating business requirements into creation of database objects: tables, synonyms, views, indexes, constraints, triggers, materialized views and Table Partitions.
• Experienced in oracle advanced concepts such as Cursors, Ref cursors, Dynamic SQL, BULK Processing, Exception Handling & Collections (Varrays, Nested tables and associative arrays).
• Expertise in Query Optimization (Nested Loop Join, Hash Joins, Inline views), debugging and Tuning for improving performance of the applications.
• Extensive experience in scheduling Oracle PL/SQL Batch jobs using control M, Autosys and DBMS JOBS Scheduler.
• Tremendous experience in data/object migration, data mapping and data cleanup projects using Oracle PL/SQL.
• Experience in writing the UNIX shell scripts to automate manual processes.
• Knowledge of Oracle Forms and Reports 6i.
• Extensive experience working on CICD Stash/Git, Clearcase.
• Experience in the field of Software Design, Development and Implementation life cycle (SDLC/AGILE)including analysis, design, architecture, development, testing, implementation, and maintenance and production support of application software.
• Proficient in client interaction, analyzing, translating business requirements to technical requirements and Troubleshooting at all levels.
• Strong communication, interpersonal, organizational, presentation skills, highly motivated, team player, quick learner.

TECHNICAL SKILLS:

Programming Languages: PL/SQL, Core Java

Scripting Languages: Unix Shell Scripting

Databases: Oracle 9i/10g/11g/12c, SQL Server 2008, DB2, RedShift, Sybase

Tools: TOAD, Control M, Autosys, Putty, SQL Developer

Operating Systems: UNIX, DOS, Win 98/2000/XP.

Oracle Utilities: SQL*LOADER, UTL FILE, Export/Import functionality

Version Control Software: GIT, Stash, Clear case

Applications: MS Office(MS Word, Excel, Access, Power point) and MS Visio

Methodologies: Waterfall Model, AGILE Methodology

ETL Tools: Informatica Power Center 8.6/9.1/9.6/9.1

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Senior Oracle Developer

Responsibilities:

• Analyze the functional & technical requirements of the project.
• Perform code review and make changes/improvements as required.
• Prepare Data Model and end2end design document and review with architect.
• Daily Scrum Team Standup, Sprint Closure and retrospective with scrum team, Backlog grooming sessions with Scrum Team.
• Prepare Data Model and end2end design document and review with architect.
• Involved in various phases of System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database.
• Loading data into database tables using SQL*loader and ETL from flat files.
• Review the design of the solution with Architecture Review Board
• Writing SQL, PL/SQL queries to extract data from different source systems.
• Preparing UNIX shell scripts and create Informatica workflows as per requirement.
• Create new database objects such as Tables, Index, Collections, triggers, packages, procedures for developments, enhancements.
• Working on the UNIX framework to automate ETL jobs using shell Scripting.
• Create new database objects such as triggers, packages, procedures for application developments, enhancements and releases. Performance Tuning and Code Review.

Environment: Oracle SQL, PL/SQL, ETL, UNIX Shell Scripting, Informatica 10.1, Control M.

Confidential, Durham, NC

Senior Oracle Developer

Responsibilities:

• Review the design of the solution with Architecture Review Board
• Tune the SQL queries whenever there is a performance issues.
• Writing SQL, PL/SQL queries to extract data from different source systems.
• Working on the UNIX framework to automate ETL jobs using shell Scripting.
• Prepare Data Model and end2end design document and review with architect.
• Daily Scrum Team Standup, Sprint Closure and retrospective with scrum team, Backlog grooming sessions with Scrum Team.
• Preparing UNIX shell scripts and create informatica workflows as per requirement.
• Create new database objects such as Tables, Index, Collections, triggers, packages, procedures for developments, enhancements.
• Resolve any database performance issues.
• Writing SQL, PL/SQL queries to extract data from different source systems.
• Working on the UNIX framework to automate ETL jobs using shell Scripting.
• Create new database objects such as triggers, packages, procedures for application developments, enhancements and releases. Performance Tuning and Code Review

Environment: Oracle SQL, PL/SQL, ETL, UNIX Shell Scripting, Informatica 9.6, Control M.

Confidential, Durham, NC

Senior Database Developer

Responsibilities:

• Involving in design, coding and unit testing phase of the projects as part of enhancements or new functionality implementation.
• Worked as onsite coordinator which involves assigning work to the offshore team, code review, get the work status from team and monitor the progress of print module during different phases of project.
• Maintain the multiple data models for the different applications and ensure that they are in sync with the latest enhancement of the functionality.
• Maintain the existing SQL and PL/SQL code and perform the changes in the code as per requirement for enhancements and releases.
• Create new database objects such as triggers, packages, procedures for application developments, enhancements and releases.
• Prepare Data Model and end2end design document and review with architect.
• Daily Scrum Team Standup, Sprint Closure and retrospective with scrum team, Backlog grooming sessions with Scrum Team
• Writing SQL, PL/SQL queries to fulfill project requirement and development.
• Preparing UNIX shell scripts and create Informatica workflows as per requirement.
• Create new database objects such as Tables, Index, Collections, triggers, packages, procedures for developments, enhancements.

Environment: Oracle SQL, PL/SQL, ETL, UNIX Shell Scripting, Informatica 10.1, Control M

Confidential, Durham, NC

Senior Oracle PLSQL Developer

Responsibilities:

• Worked on the defect fixes and support activities during Integration and User acceptance testing phases of testing
• Involved in support during the production code deployment.
• Involved in code review and performance tuning of the code when required.
• Daily Scrum Team Standup, Sprint Closure and retrospective with scrum team, Backlog grooming sessions with Scrum Team
• Writing SQL, PL/SQL queries to fulfill project requirement and development.
• Preparing UNIX shell scripts and create Informatica workflows as per requirement.
• Create new database objects such as Tables, Index, Collections, triggers, packages, procedures for developments, enhancements.

Environment: Oracle SQL, PL/SQL, ETL, UNIX Shell Scripting, Informatica 10.1, Autosys.

Confidential

Oracle PLSQL Developer

Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Triggers, Procedures, Functions, Packages to provide backend security and data consistency.
• Worked in creation of views for hiding of actual Tables and Queries.
• Created PL/SQL functions to facilitate business functions and calculations.
• Involved in coding and testing various Packages, Procedures and Functions.
• Was responsible to maintain the dependencies of all Procedures, Function, and Packages.
• Implemented complex business rules with integrity constraints and Database Triggers.
• Developed Packages to validate the business rules on the data while inserting, updating data into tables.

Environment: Oracle SQL, PL/SQL, Control M, Toad.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Triggers, Procedures, Functions, Packages to provide backend security and data consistency.
• Worked in creation of views for hiding of actual Tables and Queries.
• Created PL/SQL functions to facilitate business functions and calculations.
• Involved in coding and testing various Packages, Procedures and Functions.
• Was responsible to maintain the dependencies of all Procedures, Function, and Packages.
• Implemented complex business rules with integrity constraints and Database Triggers.
• Developed Packages to validate the business rules on the data while inserting, updating data into tables.
• Tuned and Optimized the SQL statements using Explain Plan.

Environment: Oracle 9i, SQL, PL/SQL, PL/SQL Developer, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Triggers, Procedures, Functions, Packages to provide backend security and data consistency.
• SPOC for top customer of the company by Value-First Company.
• Was responsible to maintain the dependencies of all Procedures, Function, and Packages.
• Implemented complex business rules with integrity constraints and Database Triggers.

Technology: Oracle SQL, PL/SQL, SQL Server 2005