Application Developer Resume
Towson, MD
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
- Proficient in creating and optimizing reports using Crystal reports, Oracle Reports & MS Access
- 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 & ERwin
Languages: UNIX Unix/Linux Shell Scripting, Perl, Java, C, Java Script, PHP, Cold Fusion, SQL, PL/SQL VBScript, HTML, CSS and XML
PROFESSIONAL EXPERIENCE:
Confidential, Towson, MD
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.
- Played Confidential lead role in the data conversion process.
- Converted legacy Confidential & Confidential 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.
- Managed and Deployed database scripts to Confidential and CMS environments.
Environment: Oracle 11g, UNIX, Java 1.6, Websphere 7, 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.
- 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 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 Confidential lead role in daily SCRUM meetings.
Environment: Oracle 10g on UNIX, OLTP, Windows NT, Shell Scripts, Oracle reports, PL/SQL, XML, Java, Weblogic server, Toad, PVCS, Autosys, Erwin.
