We provide IT Staff Augmentation Services!

Sr Pl/sql Developer Resume

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.

Hire Now