We provide IT Staff Augmentation Services!

Senior Plsql Developer Resume

PROFESSIONAL SUMMARY:

  • Working as a Consultant in the current organization with around 7.10 years of IT experience as an Application Developer using SQL, PL/SQL, UNIX technologies.
  • Hands on Experience on PL/SQL, Shell scripts Development.
  • Hands on experience on application development and deployments.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

SKILLS PROFILE:

Operating System: Windows XP/2003/Seven and Unix.

Environment: Oracle, Unix.

Database: Oracle, Microsoft SQL Server.

Internet Tools: HTML, JSP.

Languages: SQL, PL/SQL, Unix, Shell Scripting.

Other: Oracle PL/SQL Developer, TOAD, Putty, Pivotal Tracker, JIRA, GIT, HP - ALM, BMC Remedy Tool, SQL*Plus, SQL*Loader, Finacle Software

PROFESSIONAL EXPERIENCE:

Confidential

Senior PLSQL Developer

Responsibilities:

  • Participate in project planning and analyze Business Requirements.
  • We used to follow Kanban methodology.
  • Daily meeting and discussions and update the stories in JIRA.
  • Involved in Analysis, Design and Development of application.
  • Creating and deploying the Release Bundle for every Sprint.
  • Creating the Program specs and Release Notes/Instructions.
  • Performance tuning, internal code reviews and defect fixing.
  • Production release support.

Environment: Oracle, PL/SQL Developer, Unix, Putty, Pivotal Tracker, GIT, HP-ALM

Consultant

Senior Oracle Developer

Responsibilities:

  • Participate in project planning sessions with Supervisors, other team members and Onshore Client team members.
  • We used to follow Agile methodology.
  • Involved in Analysis, Design and Development of application.
  • Creating and deploying the Release Bundle for every Sprint.
  • Analysis on the existing projects to leverage to fulfil the current requirement and making sure exisitng applications will not be impacted.
  • Performance tuning, internal code reviews and defect fixing.
  • Stage and Production release support.

Environment: Oracle, PL/SQL Developer, Unix, Putty, Pivotal Tracker, GIT, HP-ALM

Confidential

Oracle Developer

Responsibilities:

  • Attending Meetings with Client team members to analyze Business Requirements and translate it into working software.
  • We used to follow Agile methodology.
  • Involved in Analysis, Design, Development and Performance tuning of application.
  • Creating and deploying the Release Bundle for every Sprint.
  • Creating the Program specs and Release Notes/Instructions.
  • Defect fixing.
  • Deployment in lower environments.

Environment: Oracle, PL/SQL Developer, Unix, Putty, Pivotal Tracker

Confidential

Oracle Developer

Responsibilities:

  • Participate in project planning sessions with Supervisors, other team members and Onsite/Offshore Client team members to analyze Business Requirements and translate it into working software.
  • We used to follow Agile methodology.
  • Daily meeting and discussions and update the stories in the Pivotal Tracker.
  • Involved in Analysis, Design and Development of application.
  • Creating and deploying the Release Bundle for every Sprint.
  • Creating the Program specs and Release Notes/Instructions.
  • Analysis on the existing projects to leverage to fulfil the current requirement and making sure exisitng applications will not be impacted.
  • Performance tuning.
  • Internal code reviews.
  • Defect fixing.
  • Stage and Production release support.

Environment: Oracle, PL/SQL Developer, Unix, Putty, Pivotal Tracker

System Analyst

Confidential

Responsibilities:

  • 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.
  • Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
  • Loaded Data into Oracle Tables using SQL Loader.
  • Experience in SQL performance tuning
  • Create and maintain a unified, multi-tiered reporting system to replace ad-hoc individual reports. Create and maintain essential business systems on corporate intranet.
  • Designed and created database tables, views and stored procedures.
  • Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.

Environment: Oracle, PL/SQL Developer, Unix, SQL*Loader, Putty, JIRA, Filezilla

Software Developer

Confidential

Responsibilities:

  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to Central Server.
  • 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.
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Performed SQL and PL/SQL tuning.
  • Worked with business users and application developers to identify business needs and provide solutions.
  • Created many report scripts as per the Business requirement.

Environment: Oracle, Unix, PL/SQL Developer, Toad, SQL*Loader, Putty, Citrix, Filezilla, Teradata Sql Assistant, BI SAS Reports, BMC Remedy, BSCS, Cognos Reporting Tool.

Software Engineer

Confidential

Responsibilities:

  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Created PL/SQL scripts.
  • Maintained documentation for technical systems.
  • Maintaining Shell Scripts for invoking SQL scripts and scheduled them using crontab.
  • Extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
  • Involved in the continuous enhancements and fixing of production problems.

Environment: TOAD, Putty, SQL*Plus, SQL*Loader, Ftp, Finacle Software, HP Open view.

Hire Now