We provide IT Staff Augmentation Services!

Senior Application Developer Resume

Philadelphia, PA

SUMMARY

  • Extensive experience in writing Stored Procedures, Functions, Packages, and Triggers as re - usable application programs
  • Well versed in Data Modeling
  • Experienced in Relational Database Architecture using Oracle, MySql & MsAccess databases
  • Used SQL*Loader and PL/SQL for conversions and validations
  • Well versed in Linux/Unix Shell Scripting
  • Skilled in Object Oriented Programming
  • Developed client/server web-based applications using Java, HTML, PHP, JavaScript, CSS, and JDBC
  • Excellent in programming and quick problem solving skills
  • Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask

TECHNICAL SKILLS

Platform: Intel, SPARC, Dell Power Edge 2800, IBM & HP

Operating Systems: UNIX - Solaris 10/9/8, Linux - Ubantu, Linux - Red Hat Enterprise Linux, Windows family

Databases: Oracle 9i/10g/11g, MS Access and MY SQL

Tools: SQL L VI text editor, Eclipse, Toad, SQL Developer, SQL Plus, SQL*Loader, JDBC, Re Crystal reports, PVCS, Autosys, MS Office, MS Visio & ERwinLanguages: UNIX PL/SQL, SQL, Unix/Linux Shell Scripting, Java, C, Java Script, PHP, Cold FusionVBScript, HTML, CSS and XML

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Senior Application Developer

Responsibilities:

  • Work with business to gather user requirements for Eligibility and Claims for new Confidential clients.
  • Modified PL/SQL procedures and packages to load Eligibility for new and existing clients per business requirements.
  • Develop and Test connect direct (NDM) shell scripts to transfer files to data movement.
  • Enhance Perl scripts for Precerts and PL/SQL packages for daily jobs per business requirements.
  • Maintain extracts that send eligibility data downstream from HC ICMS.
  • Worked with offshore teams to make sure projects were delivered on time.
  • Monitored 17 jobs for any issues or failures.
  • Analyze processes for performance issues and tuned processes as necessary.
  • Assist business with data analysis for any inconsistencies with Eligibility load.
  • Attend daily meetings for various Agile projects to coordinate with business.

Environment: Oracle 11g, UNIX, PL/SQL Developer, Perl, Agile, VSS 6.0, HPSM.Visio, Rally, Agile

Confidential, Towson, MD

Senior Analyst / Application Developer

Responsibilities:

  • Developed and recommended strategies and specifications for data solutions based on analysis of the business goals, objectives and needs.
  • Created logical and physical diagrams for new I&A application.
  • Played a lead role in the data conversion process.
  • Converted legacy I&A data from source to target environment using PL/SQL and bulk loading techniques.
  • Coordinated with Java developers to develop and test PL/SQL packages, stored procedures, functions and triggers to integrate with application.
  • Analyzed AWR reports to find problematic queries.
  • Tuned and optimized queries to fix performance issues.
  • Loaded test data from CSV files using SQL Loader for QA team.

Environment: Oracle 11g, UNIX, Java 1.6, WebSphere 7, Agile, PL/SQL Developer, SVN, TeamTrack, Erwin.

Confidential, Austin, TX

PL/SQL Developer

Responsibilities:

  • Gathered user requirements for various custom applications such as MEP, RAD, Physical Inventory and LOE for golf smith.
  • Retrofitted, created and tested custom packages, stored procedures and functions to integrate with Oracle EBS R12.
  • Worked with developers to design and integrate programs with .NET applications
  • Developed shell scripts to provide batch processing and ftp transactions for physical inventory application
  • Provided production support for order import from POS and WEB.
  • Tested Jobs for performance issues and tuned queries.
  • Setup system profiles in Oracle Apps.
  • Created concurrent batch jobs for automating programs in Oracle Apps.
  • LOE (Order Entry) Developed application so users / customers can enter orders from POS/Phone/ WEB. Developed validations for orders such as checks for fraudulent IP Address.
  • MEP (Marketing Enhancement Program) - Enhanced MEP application to provide users with fixed dollar and percentage rates.
  • RAD (Receiving and Distribution) Enhanced application so users can cancel purchase orders and sales orders.

Environment: Oracle 11g, Oracle application R12 (Order Management, Inventory, TCA), Red Hat Linux, PL/SQL Developer, Tortoise SVN, TrackIT.

Confidential, Englewood, CO

PL/SQL Developer

Responsibilities:

  • Actively involved in gathering requirements from Business Users and converting them into system requirement specifications and creating detailed use - cases and design documents. .
  • Designed, developed, and maintained PL/SQL packages and procedures as re-usable application programs that translated complex business logic in accordance with Java EJB code.
  • Created tables, sequences, and indexes.
  • Developed batch scripts which provided parallel processing for subscriber accounts.
  • Performed unit testing, end-to-end testing and documented cases.
  • Tuned and optimized queries as part of the development process and for production support.
  • Utilized version control for new code changes.
  • Used import/export utility to migrate data from production to development.
  • Coordinated with offshore team in the development and testing phases.
  • Created TRD (Technical requirements documentation) and DFD (Data flow diagrams) for new code.
  • Analyzed system problems and prepared software change requests.
  • Provided 24 x 7 on call production support for bi-weekly calculation processes.
  • Played a lead role in daily SCRUM meetings.

Environment: Oracle 10g on UNIX, OLTP, Windows NT, Shell Scripts, PL/SQL, XML, Java, Weblogic server, Toad, PVCS, Autosys, Erwin.

Confidential, Evansville, IN

Oracle Developer

Responsibilities:

  • Research and document data requirements, data collection, administration policy, data access rules and security
  • Collect and document user requirements
  • Design, construct, modify, integrate, implement and test data models
  • Wrote PL/SQL Stored Procedures, Packages, Functions and Triggers
  • Performed unit testing of pl/sql stored procedures.
  • Create database objects (tables, sequences, and indexes)
  • Co - ordinate with other teams of data administrators in the development and implementation of data policies, standards and models.
  • Write scripts related to stored procedures and triggers
  • Manage data security
  • Design and implement a backup & recovery mechanism

Environment: Oracle 11g, MS Excel & MS Project, Toad, SQL Loader

Hire Now