SUMMARY

• 11+ years of extensive development experience in Oracle 9i/10g/11g/12c PL/SQL, Performance Tuning, Informatica9.6/10.1 as Developer and lead in Agile Methodology Projects. Working at direct client location since last 5+ years and 2+ years of working experience in USA. Experience in Telecom and Finance domains.
• 11+ 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.
• 6+ Years development Experience using ETL tool Informatica 8.6/9.1/9.6/10.1 and Scheduling tool Autosys/Control M.
• 1 Year Experience to Amazon Redshift, Bigdata Hive - SQL and Sqoop for a POC project.
• Experience in writing the UNIX shell scripts and Python scripting.
• Extensive experience working on version control tools like CICD Stash/Git, Clearcase.
• Ability to create and manage Indexes, using hints, Partitions on tables for tuning the database and enhance performance.
• 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 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.
• Experience into Data warehouse, ETL process, Designing and code review
• Awarded employee of the quarter for tuning a critical process of Fidelity to bring it down to 10 minutes from 40 minutes.
• Automated migration task of 340+ Informatica workflows and reduced the manpower required from minimum 340+ working days to 1 week.
• Awarded for tuning a critical overnight process for British Telecom and reduced runtime from overnight processing to 4 hours.
• Proficient in client interaction, analyzing, translating business requirements to technical requirements and Troubleshooting at all levels.
• Knowledge of Oracle Forms and Reports 6i.
• Strong communication, interpersonal, organizational, presentation skills, highly motivated, team player, quick learner. Willingness to learn new technologies, openness to new ideas.

TECHNICAL SKILLS

Programming Languages: PL/SQL, Core Java

Scripting Languages: Unix Shell Scripting, Python 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

Languages: English (Fluent), Hindi (Fluent)

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle developer

Responsibilities:

• Interface with Business for scope and requirement analysis
• Prepare analysis document and review with product owners.
• 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.
• Resolve any database performance issues.

Confidential

Senior Oracle developer

Responsibilities:

• 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.
• Prepare Design Document, TSD documents, Existing system analysis
• Worked as Team lead, Individual contributor and backup Scrum Master.
• Interface with Business for scope and requirement analysis
• Prepare analysis document and review with product owners.
• 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.
• Resolve any database performance issues.

Confidential

Senior Oracle developer

Responsibilities:

• 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.
• Prepare Design Document, TSD documents, Existing system analysis
• Interface with Business for scope and requirement analysis
• Prepare analysis document and review with product owners.
• 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.
• Resolve any database performance issues.

Confidential

Senior Oracle 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.

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.
• 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.
• 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.

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.
• Involved in Bug fixing & E2E testing.
• Involved in support during the production code deployment.
• Involved in coding and testing various Packages, Procedures and Functions.
• Tuned and Optimized the SQL statements using Explain Plan.

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 ValueFirst Company.
• Was responsible to maintain the dependencies of all Procedures, Function, Packages.
• Implemented complex business rules with integrity constraints and Database Triggers.