We provide IT Staff Augmentation Services!

Sql, Pl/sql developer Resume

Lake Mary, OrlandO

SUMMARY:

  • 6 years of experience in Oracle (SQL, PL/SQL), Forms, Shell Scripting and .NET.
  • Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
  • Extensive experience in developing applications using Oracle database 11g/10g/9i, on Windows/Unix/Linux Environment.
  • Strong Coding and Designing Experience in Oracle Forms, PL/SQL & SQL.
  • Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace and PL SQL Profiler.
  • Design of data models and objects including Tables, Views, and User defined Functions, Triggers and Stored Procedures for applications.
  • Experience in Dynamic SQL, Records, and Exceptional handling.
  • Expert in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages in PL/SQL to implement business logic.
  • Expertise in Writing/ Executing Stored procedures, Crystal Reports, Test Cases, Reporting defects.
  • Skilled in Database activities which include creating databases, table spaces, performance tuning, role & user management.
  • Worked closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications; refine conceptual systems design requirements into the technical design.
  • Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills
  • Facilitated sharing of knowledge through team presentations and gathering best practices.
  • Trained and led a team of four.
  • Have got multiple appreciations from the clients and business users for excellence in work and product knowledge.
  • Skillful in Remedy management Tools, ETL Tool and UNIX.
  • Domain knowledge on Insurance and Mobile Applications.

TECHNICAL SKILLS:

Languages: Oracle, PL/SQL,C,C++, ASP &VB.NET

Scripting: UNIX shell scripting.

Tools: Toad, Putty, Remedy (Tool to schedule Unix jobs), Pl/SQL Developer,Assembla

Internet Programming: JSP,HTML,XML

Packages: Micro Soft Office Suite - MS-Word, MS-Excel, MS-Power point. MS-Access

Others Tools: SQL*Loader, MS Project Professional 2003

OS: Windows XP/2000/Linux

PROFESSIONAL EXPERIENCE

Confidential, Lake Mary, Orlando

SQL, PL/SQL Developer

Environment: Oracle PL/ SQL, ASP.NET, Assembla Tool

Project Responsibilities:

  • Coordinating with offshore team and the Client for discussions/meetings to provide better solution and understanding of business requirements.
  • Identified trends and recommended proactive or remedial action to manage business situations.
  • Involved and Developed Project that maintains Data Base Objects and Reporting using PL/SQL Stored Procedures, Functions, Triggers and Packages to facilitate the cleanup of unused Oracle objects.
  • Created a discussion forum internally to log in activities that are performed daily by the distributed teams.
  • Created a Deployment check mechanism to make sure the projects that are delivered are up to the requirements provided by the client.
  • The tool can be used by the clients to interact directly with the team lead of each project, through Skype, chat or call.
  • Daily automated reports of projects are sent to the management team.
  • An Amber alert mechanism is used to trigger mail regarding projects that are in danger zone.

Confidential

Environment: Oracle 10g, ASP.NET

Project Responsibilities:

  • Involved in customization of application based on the business specification document.
  • Involved in writing custom interfaces for loading Invoice, Payment, Account Receivable data related to data base.
  • Guiding the team members for implementing complex SQL queries and tuning for better performance.
  • Involved in writing complex SQL queries and building reports based on business requirements.
  • Performed unit testing, integration testing and performance testing on the website and updating the reports in Assembla.

Confidential

Environment: PHP, XML,IOs iPhone 5, iphone6,Mobile applications

Project Responsibilities:

  • Interactive exercises, discussions and quick prototype development fed into the project roadmap, identifying areas of technical risk and developing mitigation plans DE-bugging and analyzing the applications related issues by looking into logs and configuration.
  • Involved in the simulation of production environment to enable real-time integration and testing of software under development.
  • Software build and deployment processes were automated so that the team could manage several versions of the software efficiently.
  • An automated regression test framework was created to safeguard around the software, rapidly identifying faults and ensuring the highest levels of quality across the application.
  • Updating the client every two weeks, functionality was “showcased” to the customer to review and re-prioritize work for the next iteration.
  • Agile methodology was followed to ensure quality and timely delivery.

Confidential, Hartford, CT.

Environment: Oracle Forms, PL/SQL, UNIX shell script, Remedy management Tool, TOAD.

Project Responsibilities:

  • Involved in writing data base objects to implement interface using procedure, functions and packages to enhance the application based on the client requirements using Oracle Forms, SQL and PL-SQL.
  • Improved the performance of the application by rewriting the SQL queries.
  • Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
  • Involved in enhancement of customized decision making rules/policies.
  • Performed bug fixes in the existing PLSQL packages, procedures, functions, Materialized Views using TOAD.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Working on Change requests/enhancements based requirements. This includes preparing the documents like Work Request Form, Test Case and Implementation documents and development Using Oracle SQL and PL-SQL.
  • Involved in writing new and enhancing the existing Unix Shell Scripts to configure as jobs. This job involves invoking PL SQL Procedures / Packages, automate ftp jobs from Unix Server.
  • Served as a Subject Matter expert in Loss processing and provides inputs and reviews the internal team work for technical and functional accuracy
  • Used UNIX SHELL scripts for automation of daily and weekly, and monthly jobs on IBM Tivoli Work Load Scheduler.
  • Performed the upload and download of flat files from UNIX server using FTP.
  • Participated in System Testing and UAT.
  • Involved in the functional and technical meetings for each release.
  • Provide technical leadership to team members and best practices followed.

Confidential

Environment: Oracle 6i &10 g, PL/SQL, PERL, SQL Reports, UNIX, Remedy and TOAD.

Project Responsibilities:

  • De-bugging and analyzing the applications related issues by looking into logs and configuration.
  • Involved in writing data base objects to implement interface using procedure, functions and packages to enhance the application based on the client requirements Using Oracle SQL and PL-SQL.
  • Involved in enhancement of customized decision making rules/policies.
  • Performed bug fixes in the existing PLSQL packages, procedures, functions, Materialized Views and views.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application
  • Responded to customers queries assigned as ticket based on the priority.
  • Experience in off-hours on - call support, handling resolution of issues on that are critical to the business.
  • Writing SQL queries and tuning for better performance. The tuned SQL queries will be used for designing reports..

Confidential

Environment: Tomcat, Eclipse and JAVA.

Responsibilities:

  • Was involved in the development of screens using JSP.
  • Have monitored and mentored a team of four.
  • Coordinated all activities as per schedule provided.
  • Project was selected as one of the top projects performed by the management.

Confidential

Responsibilities:

  • Analyzed and participated in the activities to control and manage busy routed traffic lines.
  • Exercised analytical skills in coming up with ideas on how to improvise the present system of navigation and both independently as well as in a team.
  • As part of the team embarked on field trips, visiting places where navigation of the router lines was carefully monitored, giving me a better understanding of telecommunications management and its accompanying systems.

Hire Now