We provide IT Staff Augmentation Services!

System Application Developer Resume

4.00/5 (Submit Your Rating)

Washington, DC

Summary

  • Nearly 5 years of experience in the Oracle PL/SQL Developer/Tester in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS)
  • Strong RDBMS concepts including expertise in pl/SQL queries like DML, DDL, Stored Procedures, Views, User Defined Functions (UDF), Triggers, and Cursors etc.
  • Experienced in SQL Optimization, performance monitoring and tuning.
  • Experienced in programming as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling(logical and physical), and Implementation of Business Applications using the Oracle Relation Database Management System(RDBMS)
  • Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques
  • Experience in Microsoft Sql Server 2005, Microsoft Excel, Microsoft Access. MySql.
  • Experience in Shell Scripting.
  • Experience in Software Development Life Cycle
  • Strong, clear communication and interpersonal skills

Key Skills

Operating System:

Windows Vista/XP/NT/2000,98/95, DOS, Unix, Linux

DBMS

SQL, PL/SQL, Triggers, Stored Procedures and functions, Standard Packages, SQL*Plus, SQL*Loader,Performance tuning, Ref Cursor.

Tools Used

Oracle 8i/9i/10g, SQL Developer, Toad, ERWIN, Excel, Access, Sql Server 2005, HP Quality Center, HP Perfomance Center

Scripting

Unix Shell Scripting

ProfessionalExperience

Confidential,Washington, DC Oct 2010 to till date

Position: Banking System Application Developer

  • Designing the advance SQL queries for data retrieval
  • Develop Procedure, Function , Packages to support internal application
  • Also Create, Modify and Maintain SQL queries and Procedure.
  • Designing the Dynamic SQL to get better performance.
  • Creating New Tables or Modified Existing Tables.
  • Communicate issues and progress to project manager
  • Involved in solving day-to-day problems, giving support to the users and assigned application.
  • Investigate & implement to the application.
  • Write test case on HP Quality center and test the Application.
  • Write Design document for Maintenance.
  • Perform Load Test on Application.

Confidential, Houston, Texas Jun 2010 to Sep 2010

Position : Oracle PL/SQL developer

Responsibilities:

  • Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.
  • Collaborated with the application developers in data modeling and E-R design of the systems.
  • Also created, modified, maintained and optimized SQL database.
  • Maintained the documents and create reports for the business analysts and end-users.
  • Responsible for the management of the database performance, backup, replication, capacity and security.
  • Developed SQL*loader scripts to load data in the custom tables
  • Communicated issues and progress to project manager
  • Involved in solving day-to-day problems, giving support to the users
  • Developed scripts for checking oracle errors in alert log and trace files

Environment::

Oracle 10g, SQL, PL/SQL, Oracle forms and Reports, TOAD, SQL*Loader, Unix Shell Scripting, MS Windows XP, Microsoft Access, Microsoft Excel

Confidential, Gujarat , IndiaJune 2006 to Dec 2007

Position:Oracle Developer

Responsibilities:

  • Involved in the complete life cycle of the product from requirements gathering to end of system testing.
  • Worked on developing a financial application system to handle all the bank transactions usingSQL,PL/SQL,Developer 2000(Forms4.5 and Reports2.5) on Windows environment.
  • Worked as a librarian to maintain the system application design using Designer2000 tools.
  • Used SQL*Loader to load the database from flat files.
  • Created new Tables, Indexes, and Sequences where needed.
  • Created database triggers for data security & Consistency.

Environment::

Oracle 8i, SQL, SQL*Plus, PL/SQL,SQL*Loader, Microsoft Access, Microsoft Excel, Developer2000 (Forms 4.5 and Reports2.5) and Unix Shell scripting.

Education

Masters of Science, Bachelor of Engineering,

Related Coursework

Introduction to database system (part1 and part2),Introduction to SQL and PL/SQL, Advance Pl/SQL, Data Communication and Networking(Part 1& 2), Microprocessor & Interfaces, Advance Microprocessor, E-commerce Data Encryption & Security, Wireless Communication, Wireless Sensor Network, Analog VLSI, Digital Signal Processing, Fiber Optic Communication, Computer Network (Part1& 2), VLSI Testing , VLSI Digital System Design, Low power VLSI, RF CMOS VLSI, Analog VLSI.

Professional certification

Exam 1Z0-051 Oracle Database 11g :SQL Fundamental 1
Exam 1z0-144Oracle Database 11g: Program with PL/SQL(pursuing)

Technical Training
Oracle Database 10g: SQL and PL/SQL
Oracle Database 10g: Advance SQL Queries.
HP Quality Center
HP Performance Center

We'd love your feedback!