We provide IT Staff Augmentation Services!

Application Developer Resume

0/5 (Submit Your Rating)

Montgomery, AL

PROFESSIONAL SUMMARY:

  • Experience in analysis, design, development, testing and implementation as ORACLE PL/SQL DEVELOPER
  • Good knowledge in Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
  • Well experienced in developing the Data mart in Star Schema and Snowflake Schema, Flat files and building the Data warehouse, Efficient in developing the Data model, ER Diagrams and organizing the data as per the Business requirements.
  • Rich Experience in developing PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Exception Handling and good in Oracle Forms and Reports.
  • Extensively used inbuilt Oracle PL/SQL packages in application development.
  • Strong in using tools such as TOAD, SQL*Plus, SQL developer, PL/SQL developer.
  • Tuned SQL queries using EXPLAIN PLAN, optimizer Hints and TKPROF utility, Indexes and performed refinement of the database design leading to significant improvement in system response time and efficiency.
  • Used bulk binding techniques like BULK - COLLECT and FORALL
  • Strong in writing Stored Procedures and SQL queries.
  • Experienced in developing batch programs by using PL/SQL and shell scripts and in using Export, Import and SQL*Loader Utilities for loading data from flat files into Oracle tables.
  • Experience in working with Forms and Reports for development and customizations as per client specifications.
  • Experienced in the development and deployment of PL/SQL packages for Retail, Financial, Manufacturing, and Software companies.
  • Experience in using oracle long data types like BLOB, CLOB
  • Extensive exposure with Oracle backend on various flavors of UNIX.
  • Experience in writing UNIX shell scripts for automating the daily processes.
  • Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.
  • Actively coordinated with Quality Team and User Acceptance Testing.
  • Knowledge of job scheduling and using version control tools like VSS, SVN
  • Strong programming and debugging skills in PL/SQL, SQL, C
  • Strong skills in objected oriented programming using C++, Java
  • Strong skills in Web Designing using HTML,CSS and JavaScript.
  • Strong Trouble-shooting, Problem solving, Analytical & Design Skills and ability to quickly master new software and adapt to changing needs.
  • Work experience in Oracle Applications 11 in ERP Manufacturing and Distribution.
  • Excellent communication skills and ability to work individually and as a member of a team.

TECHNICAL SKILLS:

Backend: Oracle 11g/10g/9i Database Enterprise Edition, Oracle 10g/9i Application Server

Frontend: Oracle Developer Suite 10g/9i/2000, SQL * Loader, SQL * Plus, FORMS Builder 6i, REPORTS Builder 6i, XML, Oracle XE 10g/11g

Programming: ORACLE PL/SQL 10g/9i/8.0, UNIX K-Shell Scripting, C,C++, JAVA, J2EE, Servlets, Java Script, Visual Basic, COBOL

RDBMS: Oracle 9i/10g/11g, MS Access 2000/2002, MS-SQL Server 2005/2000/7.0/6.5

Third Party Tools: PL/SQL Developer, TOAD 8.6/7.5/7.0, Putty, Workflows, Erwin, Oracle Applications 11

Operating System: Windows 98/2000/XP/NT, UNIX (SunOS 5.7, Solaris 8, HP-UX), Redhat Linux 3.0/4.0

Others: XML, HTML, SVN, Microsoft Visual Source Safe (VSS), IBM Rational Clear Case and Clear Quest, Caliber, CVS, Eclipse, Quality Center, Dimensions

PROFESSIONAL EXPERIENCE:

Confidential, Montgomery, AL

Application Developer

Responsibilities:

  • Created new data objects based on 11g data platform to facilitate the development.
  • Involved in front end support in development using C++, Java, HTML, CSS and JavaScript.
  • Involved in back end support in production development using PL/SQL.
  • Written and used Stored Procedures and functions using PL/SQL for common utilities.
  • Wrote scripts for development, testing and production environment.
  • Prepared program Specification and development of PL/SQL package, procedure and functions as required by the web application.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Writing validation packages using PL/SQL package.
  • Developed Installation scripts for all the deliverables.
  • Performed functional testing for the procedures and packages.
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD.
  • Involved in migrating database from oracle 10g to 11g database.
  • Involved in production support, like monitoring the performance of the UNIX jobs.
  • Researching and resolving the problems occurred with the Jobs and also involved with the end user to resolve the problems.
  • Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance.

Environment: Oracle 11g, 9i Windows, PL/SQL, SQL plus, SQL *Loader, TOAD 9.0, Explain Plan, Oracle Developer Suite 10g.

Confidential, Rutherford, NJ

Oracle PL/SQL Developer

Responsibilities:

  • Involved in SDLC gathering requirements from end users.
  • Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database.
  • Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
  • Developed Database Triggers for audit and validation purpose.
  • Used pipelined functions for faster data accessibility.
  • Writing validation packages using PL/SQL package.
  • Used PL/SQL to validate data and to populate billing tables.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
  • Developed Installation scripts for all the deliverables.
  • Performed functional testing for the procedures and packages.
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD.
  • Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Involved in migrating database from oracle 9i to 10g database.

Environment: Oracle 9i/10g, SQL, PL/SQL, Toad, SQL*Loader, SQL Navigator, Caliber, CVS, Eclipse, Quality Center, Dimensions, Windows 2000 server.

Confidential, San Jose, CA

CAM Engineering/Web Development

Responsibilities:

  • Involved in gathering requirements from end users and cleanup the data.
  • Validate the customer Gerber Data.
  • Format the customer data and load it to the Valor software.
  • Analyze the data to meet the requirements to build the PCB board.
  • Involved in writing programs in HTML, CSS and JavaScript computer programming languages.
  • Create and integrate the contents such as graphics, text, sound animation and video.

Confidential

PL/SQL Developer

Responsibilities:

  • Prepared program Specification and development of PL/SQL package, procedure and functions as required by the business users
  • Migration of the existing SQL Server procedures, function and Views into Oracles PL/SQL Packages, Procedures, Functions and views.
  • Developed Scripts for Oracle tables, views and sequences.
  • Created Indexes and partitioned the tables to improve the performance of the query.
  • Applied optimizer hints to tune the queries for faster performances.
  • Modifying the procedures, functions and views based on the changes of the business requirements in T-SQL as well as PL/SQL.
  • Involved in preparing the OMD SQL and PL/SQL coding standard and guidelines.
  • Created Reports using complex SQL queries for the clients review.
  • Designed and developed the reports for business user using Crystal Report.
  • Designed and developed the data's pre-staging and staging mechanism.
  • Created Staging Tables to handle the import data.
  • Created SQL*Loader scripts to load data into the temporary staging tables.
  • Wrote Procedures and functions for the validation of input data and to implement business rules.
  • Performed Unit Testing and Integration Testing of the application.
  • Involved in preparing documentation and user support documents.

Environment: Oracle 9i, SQL Server 2000/2005, PL/SQL, T-SQL, SQL* Loader, TOAD, Oracle forms 6i/10g, Visual Studio, Visual Studio, C#, MS- Office, Crystal Report 7.0, MS-project, Windows XP.

We'd love your feedback!