SUMMARY:

• Development, Support, Maintenance of Oracle based ERP applications
• Fifteen year’s experience with all aspects of application support, development, systems analysis, functional analysis, testing, software design, modification and implementation using standard, AGILE and other iterative system development life cycle methodologies
• Fifteen year’s experience with Oracle 7.34,8i,9i,10g,11g, Reports 2.5 - 10g & Forms 4.5-6i-10g, PL/SQL, UNIX, HTML, TOAD, SQL Server 2005, SQL Server 2008, Visual Studio, TFS, Crystal Reports ver. 10 - XI, C#, .Net Framework 2.0-3.5, Windows, SQL, T-SQL, SQL*Plus, PL/SQL Developer, Oracle Designer 9i, Clintrial, Business Objects, MS Excel, MS Word, MS Access, Visio, Visual Source Safe, TOAD, SQL Developer
• Seven years technical, functional and end-user support of various .Net & Oracle-based applications new development, application support and enhancements
• Strong Customer Service skills that emphasize customer experience with over 30 years troubleshooting hardware and software

EMPLOYMENT:

Oracle Developer

Confidential

Responsibilities:

• Support and maintain Proship shipping application
• Process Ad Hoc transactions and reports for order and shipping processes
• Support, Develop and Maintain in - house order/shipping ERP application on Oracle 11g
• Troubleshoot, track and resolve software issues on ticket system
• Maintain, troubleshoot and configure application servers
• Application design using standard and AGILE system development life cycle methodologies
• Develop and enhance application user interface using Oracle Fusion Middleware Forms 11g
• Develop and enhance PL/SQL packages, procedures, functions and triggers to support system wide changes or resolve trouble tickets
• Developed UNIX, SQL and PL/SQL scripts
• Strong listening skills to assess complicated failure description to facilitate troubleshooting procedures
• Proficient in the use of PL/SQL Developer and Excel to create Ad Hoc reports for Manager

Oracle Developer

Confidential

Responsibilities:

• Support and maintain three manufacturing ERP applications on Oracle 11g - Oracle Manufacturing 11i standard and customized modules, a fully custom and a third party order entry application
• Troubleshoot, track and resolve software issues on Sharepoint-based ticket system
• Facilitate functional design and functional documentation with subject matter experts and monitor project progress
• Maintain and track version control of all objects across seven database instances using PVCS
• Application design using standard and AGILE system development life cycle methodologies
• Develop and enhance application user interface using Oracle Forms 6i and reports using Oracle Reports R6i
• Develop and enhance PL/SQL packages, procedures, functions and triggers to support system wide changes or resolve trouble tickets
• Define, monitor and maintain system processes in Concurrent Manager tool
• Tuned code changes using Explain Plan, TKPROF and database monitoring tools
• Write technical design and enhancement documentation
• Developed UNIX, SQL and PL/SQL scripts
• Proficient in the use of TOAD and other database tools SQL Navigator or SQL Developer

IT Support Technician

Confidential

Responsibilities:

• Troubleshoot PC, PBX and network issues within a 600 station call center
• Maintain GPO and security groups for over 350 users in Windows Active Directory
• Troubleshoot devices with customers assistance via phone in often adverse situations
• Educate users in usage and general maintenance of computer and telecom equipment
• Trained and accomplished in the use of network troubleshooting tools and techniques
• Work in fast-paced, detail-driven technical environment requiring strong listening/communication skills
• Monitor and update trouble tickets and service requests with Remedy tracking system

IT Manager

Confidential

Responsibilities:

• Maintained, configured and troubleshot PCs and servers to support business function
• Optimized system’s performance and provided 24/7 support of systems
• Installed, configured and administered network technologies
• Backup Management, Reporting and Recovery
• Plan and lead training sessions for Windows XP and Office Suite
• Microsoft Office Suite Word, Excel, Access and Projects 2007

Programmer/Analyst

Confidential

Responsibilities:

• Designed, developed, business and systems analysis of a state services client tracking software application
• Developed PL/SQL packages and procedures in Oracle 10g to process business functions for a .Net front end
• Design of application used AGILE system development life cycle
• Developed C# classes to cleanse and format checks of data between .Net application and legacy system
• Processed and tracked trouble tickets to address post-production issues with software
• Developed .Net classes with Visual Studio 2008 using C# to process queries, updates, inserts and deletions
• Tested and reported on prospective database programming and modeling tools
• Wrote test plans and test cases to validate software changes per federal regulatory requirement
• Completed unit and user acceptance testing of changes and documented outcomes per established test plan process
• Wrote functional and design documents per federal regulatory requirement
• Technical liaison between state agency and project development team
• Troubleshot issues via direct interaction with customers/SME to define nature of issue
• Strong written and verbal skills
• Proficient in the use of TOAD and other database tools SQL Navigator or SQL Developer
• Microsoft Office Suite Word, Excel, Access and Visio

Programmer/Analyst

Confidential

Responsibilities:

• Designed, developed and analyzed business and system requirements of a state services client tracking softwareApplication using AGILE system development life cycle
• Developed PL/SQL packages, procedures and triggers to extract and translate data from Oracle 9i then export to an off campus SQL Server 2000 database
• Developed C# classes with Visual Studio 2005 to process XML files
• Loaded XML files into SQL Server via SFTP
• Created weekly progress reports and updated project manager ad hoc as a lead programmer analyst
• Developed scripts to build database objects i.e. tables, constraints, tablespaces and document their use
• Developed SQL Server stored procedures to cleanse and format data required by Federal regulation
• Developed test cases and wrote test plans then completed unit testing and user acceptance testing
• Wrote user requirements, change and implementation documentation
• Wrote functional and design documents per federal regulatory requirement
• Tuned code changes using Explain Plan, TKPROF and database monitoring tools
• Use of TOAD as well SQL Navigator

Oracle Developer

Confidential

Responsibilities:

• Designed, developed and analyzed business and system requirements of user requirements for state food protection agency incident tracking system
• Developed and tested Oracle Forms 6i and Reports 10g
• Developed PL/SQL Procedures, Functions and triggers in Oracle 10g supporting in-house business requirements of agency software application
• Completed unit and user acceptance testing of changes and documented outcomes per established test plan process
• Wrote functional and design documents per federal regulatory requirement
• Use of TOAD and SQL Developer

Data Warehouse Developer

Confidential

Responsibilities:

• Designed, developed and implemented Oracle 10g packages and stored procedures to extract, translate and load (ETL) large volumes of data using Oracle techniques, functions and utilities
• Tuned code using Explain Plan, TKPROF and database monitoring tools
• Developed, tested & documented changes to in-house ETL packages
• Developed testing environments to successfully test changes to ETL packages
• Completed unit and user acceptance testing of changes and documented outcomes per established test plan process
• Wrote functional and design documents, testing plans, implementation guides & Visio diagrams such as E/R and data flow diagrams
• Wrote scripts, change requests and attended Change Control Board review meetings to insure proper implementation of code changes
• Use of SQL Navigator and SQL Developer

Systems Analyst

Confidential

Responsibilities:

• Customer support of the Oracle-based application, troubleshot, developed and implemented corresponding changes
• Developed PL/SQL Functions, procedures and Packages in Oracle 10g
• Developed, supported and documented database Oracle PL/SQL packages and stored procedures for the Clintrial development tool
• Develop and enhance application user interface using Oracle Forms 6i and reports using Oracle Reports 6i
• System analysis of data management requirements for FDA regulated trial studies
• Troubleshot, processed and tracked trouble tickets/change requests using the Remedy tracking tool
• Wrote and ran formal test cases and developed, maintained supporting documentation per FDA system validation procedures
• Wrote test plans, functional and design documentation to support validation of code changes
• Microsoft Office Suite Word, Excel, Access and Visio

Oracle Designer/Business Objects

Confidential

Responsibilities:

• Designed, developed and analyzed business and system requirements in support of various departmental functions
• Developed Business Object universes to support user-defined and/or ad hoc reports in Business Objects 6.5.1
• Developed reports in the Business Objects Full Client Reporting tool using Oracle Designer 9i as an object repository and data source
• Completed unit and user acceptance testing of changes and documented outcomes per established test plan process
• Wrote functional and design documents, testing plans, implementation guides & Visio diagrams such as E/R and data flow diagrams
• Wrote scripts, change requests and attended Change Control Board review meetings to insure proper implementation of code changes
• Microsoft Office Suite Word, Excel, Access and Visio

System Analyst

Confidential

Responsibilities:

• Designed, developed and analyzed business and system requirements of data warehousing architecture and applications in Oracle Designer 9i
• Developed PL/SQL packages, procedures and functions in Oracle 9i to populate a Department of Defense (DOD) financial data warehouse on a UNIX system with Oracle Designer 9i
• Developed and wrote design level documentation of a large Financial Management System
• Developed and wrote logical design documentation consisting of context diagrams, data flow diagrams, logical data models and entity relationship diagrams (ERD)
• Analyzed and troubleshot end-user problems with DOD financial accounting system
• Peer reviewed user requirements to develop functional and technical documentation
• Microsoft Office Suite Word, Excel, Access and Visio