We provide IT Staff Augmentation Services!

Plsql Developer Resume

SUMMARY:

  • 4+ year of experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health Care - and - Banking Sectors
  • Possess strong analytic and trouble shooting skills
  • Experience with Database maintenance including monitoring and maintenance tasks
  • Proficient in developing and maintaining Unix shell scripts as well as programming in PL/SQL
  • Experience of Performance Tuning & Optimization of SQL statements using various types of Indexes and Explain plan.
  • Ability to create and modify Oracle objects such as tables, indexes, constraints, packages, procedures, functions, views, synonyms & sequences.
  • Solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart mapping.
  • Involved in all phases of the SDLC (Software Development Life Cycle) models (like Agile methodology, waterfall model)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Well versed in Normalization and De normalization techniques for optimum performance in relational and dimensional database environments.
  • Proficient in writing PL/SQL procedures with use of Cursors, Collections, Nested Tables and Bulk Processing.

TECHNICAL SKILLS:

Databases: Oracle9i/10g/11g, SQL Server

Languages: Unix, SQL, PL/SQL, C, C++

Application Development Tools: Toad, Power Designer, SQL Developer, Informatica

Operating System: MS-DOS, Windows 98/2000/XP/Vista/7/8/8.1, UNIX

Other Skill: Project Management Plan, Functional Specifications documentation, Business requirement document, MS Office, MS Visio, System Architect, MS Project 2003/2007, Reports, End User Documentation, Testing

PROFESSIONAL EXPERIENCE:

PLSQL Developer

Confidential

Responsibilities:

  • Working as developer for 835 Payment File Processing.
  • Conducting meeting with business analyst to understand the requirement document.
  • Developed analytical design document, User Interface document, test case documents and production turn over kit for assigned projects.
  • Working with Change management team &DBA team to deploy code in non-production and production - environment.
  • Conducting meeting with release management team to monitor proper deployment of the project.
  • Developed tables, stored procedures, functions, packages, triggers and user query.
  • Assisting QA team to solve any query raised during the testing time.
  • Created user query and scheduled queries in User query tool.
  • Created plv jobs and with the support of production support team scheduled to run through cron job.
  • Worked with production support team during warranty phase of the project.
  • Maintained, troubleshoot, optimizes and improved existing database applications and database objects.

Technologies: Oracle 11g

Oracle Developer

Confidential

Responsibilities:

  • Developed package to encrypt password & PII information available in tables
  • Developed trigger to audit DML changes occurred on configuration tables by capturing data into audit & history table
  • Worked with DBA team to restore data from Production to lower environment as database refresh process & performed various validations after restoration of data.
  • Developed package to copy account data of specified tables from production to lower environment within given specific date
  • Developed procedure to purge the older data
  • Tune queries and re-write the code of packages to enhance performance of the job
  • Developed logical & physical data models using Power- designer
  • Verification of data between two database
  • Tuned existing packages using Explain plan & Tk-Prof utility
  • Created tables, stored procedures, packages, constraints, types, sequences, Index, triggers, views and shell scripts

Oracle Developer

Confidential

Responsibilities:

  • Involved in requirement phase, design phase, development phase, testing phase and support to production team during deployment of code in production.
  • Developed procedures, triggers, functions, tables, constraints, Indexes and collections to implement business logic.
  • Created forms for activities related to HRMS.
  • Created user query and sNcheduled cron jobs to run query on daily basis.
  • Imported data from database using the external table and SQL Loader.
  • Optimized existing jobs using SQL & PL/SQL tuning methodologies and toolkits
  • Performed data backup and recovery task
  • Maintained, troubleshoot, optimizes and improved existing database applications and database objects

Technologies: Oracle 10g

Hire Now