System Application Developer Resume
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