SUMMARY

• Oracle Certified PL/SQL Developer with 8+ years of programming experience with emphasis on Analysis, Design, Development, Testing, Implementation and Management of projects using Oracle (SQL, PL/SQL)
• Solid experience in translating business requirements into creation ofDatabase Objects.
• Extensive experience in writingSimpleandComplex SQLs, PL/SQL Functions and Procedures, Packagesand creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Expertise in Client-Server application development using Oracle 12c/11g/10g/9i, PL/SQL, SQL *PLUS, TOAD, SQL DeveloperandSQL*LOADER.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience indeveloping formsbased onviews, tables and proceduresin tabular and form layouts.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modellinganddesign techniques.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, and Analytical functions, Materialized Views, Query Re-WriteandTransportable tablespaces.
• Experience in advanced PL/SQL concepts likeBulk Collectandforall.
• Expertise inDynamic SQL, Records, Arrays and Exception Handling.
• Highly skilled inPerformance tuning- analyzing query plans and query tuning using the tools such asEXPLAIN PLANand usehintswherever required.
• Experience in writing Technical design documents and developing unit test documents.
• Served as the key point of contact/Liaison between onsite and offshore and coordinated and followed up with the offshore team to accomplish the milestones as per the project timeline.
• An effective communicator with excellent analytical, team building and coordination skills.
• Flexible in work and proactive.
• Authorized to work in USA.

TECHNICAL SKILLS

OPERATINGSYSTEM: Windows7/8/10, UNIX, LINUX.

TOOLS: IBM DataStage, Toad, SQL Developer& PL/SQL Developer, BMC Remedy

CONCEPTS: OOPS, RDBMS.

DATABASES: Oracle 11g/10g, Oracle 9i, IBM DB2, SQL Server.

WEB TECHNOLOGIES: JavaScript, HTML, XML

VERSION CONTROL: Polytron Version Control System (PVCS), SVN Tortoise.

PROFESSIONAL EXPERIENCE

Confidential

Sr PL/SQL Developer

Environment: PL/SQL, ETL, Unix, Oracle DB 11g, TOAD

Responsibilities:

• Coordinating with client for requirement gathering, clarification and providing solutions for several problems
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Served as liaison between third party vendors, business owners, end users and technical team. Proven ability in communicating highly technical contents to non-technical people.
• Experience in leading a team.
• Extensive involved in project environment and working as part of a large multi-skilled project team
• Involved in project planning, organizing, monitoring, and controlling projects using appropriate tools and techniques
• Experience in gathering data, performance analysis and providing presentation to the client.
• Experience in managing, teach and mentor team members
• Involved in regular Production support activity.
• Involved in query optimization and performance tuning.
• Involved in Development and Created PL/SQL stored procedures, functions and packages.
• Developed materialized views for data replication in distributed environments.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Confidential

Sr PL/SQL Developer

Environment: PL/SQL, ETL, Unix, Oracle DB 11g, TOAD, Shell Scripts, AUTOSYS

Responsibilities:

• Involved in all phases including Requirement Analysis, Design, Coding, Testing and Documentation.
• Translated the business processes into PL/SQL Packages and Procedures.
• Design developed new BOA program using PL/SQL which added more functionality, extended the existing BOA program and AML Check Process
• Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL.
• Participated in the development and maintenance of a Date Warehouse Routine Load Schedule.
• Involved in business requirements gathering to enable Data Integration across all business groups.
• Extensive involvement with the Quality Assurance team for building exhaustive set of test cases.
• Implemented logic to control job dependencies between the workflows solely through the use of event-raise and event-wait tasks and entries made by ETLs in pilot database tables.
• Worked on making session runs more flexible through the use of mapping parameters and variables by using parameter files and variable functions to manipulate them.
• Implemented Slowly Changing Dimensions (Type-2).
• Identified and resolved the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Performed the Unit and Integration Testing which validated that the data is mapped correctly which provides a qualitative check of overall data flow.
• Prepared the coding standards and quality assurance policies and procedures.

Confidential

Principal Consultant-Support

Environment: Flex cube 12.0.3,Oracle 11g,Unix

Responsibilities:

• Analysis of Functional and design specification.
• Enhancement of PL/SQL code, Screen level Xml as per the requirement.
• Improving the performance of the date base objects to reduce the execution time.
• Developed and maintained proper data extraction processes.
• Creation of Unit test plan and performing independent unit testing to make sure the enhancement is working fine.
• Interaction with client to facilitate smooth implementation.

Confidential

Senior Support Analyst

Environment: Oracle 10g, Datastage7.5, Business Objects 5.1, Unix

Responsibilities:

• Playing the role of L2 resource between the client and other vendors.
• Playing an interface role between client and L3 resources by communicating in Japanese.
• Responsible for extracting huge data for the client using latest querying styles.
• Improved the performance of all monthly and daily batch scripts by oracle performance tuning.
• Responsible for generating the monthly data extractions and Standard Operating Procedure activities.
• Releasing Change requests in production for Data warehousing related activities.
• Primary resource for all major modules of this project.

Confidential

Production Support Staff

Environment: Sql, Pl/Sql, Forms 6i

Responsibilities:

• New Business and Contract Management Production support team member.
• Responsible for extracting huge data for the client using latest querying styles
• Improved the performance of all monthly and daily batch scripts by oracle performance tuning.
• Responsible for generating the monthly re quoted proposals and pre - renewal batches.
• Daily fixing of all change request and system change management (SCM) requests and to close and update the status of issues on JIRA (tool to raise issue)
• Responsible as a single point of contact of all Data related to AUTO Insurance of AXA for the Financial Services Agency (FSA) Audit.