SUMMARY

• Twelve year's experience with all aspects of application support, development, systems analysis, testing,
• software design, modification and implementation using standard, AGILE and other iterative system
• development life cycle methodologies
• Twelve year's experience with Oracle 7.34,8i,9i,10g,11g, Reports 2.5-10g Forms 4.5-9i-10g, PL/SQL, UNIX, HTML, TOAD, SQL Server 2005, SQL Server 2008, Visual Studio 2005 - 2008, 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
• Five years technical/end-user support of various .Net Oracle-based applications new development,
• application support and enhancements
• Strong documentation skills writing design and functional documents, implementation plans,
• implementation scripts, test plans, test cases, completed unit and user acceptance testing
• Strong communication, organizational and problem solving skills

EMPLOYMENT

Oracle Developer

Confidential

• 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
• Develop and enhance PL/SQL packages, procedures, functions and triggers to support system wide changes or resolve trouble tickets
• Develop and enhance application user interface using Oracle Forms 6i and reports using Oracle Reports R6i
• Application design using standard and AGILE system development life cycle methodologies
• Maintain and track version control of all objects across seven database instances using PVCS
• Troubleshoot, track and resolve software issues on Sharepoint-based ticket system
• 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
• 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

IT Support Technician

Confidential

• Troubleshoot PC, PBX and network issues within a 600 station call centerMaintain 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

• 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 2007 - 2010 Word, Excel, Access and Projects 2007

Programmer/Analyst

Confidential

• 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 2007 - 2010 Word, Excel, Access and Visio

Programmer/Analyst

Confidential

• Designed, developed and analyzed business and system requirements of a state services client tracking software
• Application 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
• Microsoft Office Suite 2007 - 2010 Word, Excel, Access and Visio
• Strong Oral and written skills

Oracle Developer

Confidential

• protection agency incident tracking system
• Designed, developed and analyzed business and system requirements of user requirements for state food
• Developed and tested Oracle Forms 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
• Strong Oral and written communication skills
• Use of Windows XP and Microsoft Office Suite 2007 - 2010 Word

Data Warehouse Developer

Confidential

• Designed, developed and implemented Oracle 10g packages and stored procedures to extract, translate and load ETL large volumes of data using RDBMS 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
• Use of Windows XP and Microsoft Office Suite 2007 - 2010 Word, Excel, Access and Visio

Systems Analyst

Confidential

• 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
• 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 2007 - 2010 Word, Excel, Access and Visio

Oracle Designer/Business Objects

Confidential

• 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 2007 - 2010 Word, Excel, Access and Visio

System Analyst

Confidential

• 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 2007 - 2010 Word, Excel, Access and Visio

Programmer/Analyst

Confidential

• Designed, developed and implemented system analysis in support of distribution center's IT requirements at-large
• Troubleshot and tracked trouble ticket software issues in Oracle Financials version 7 applications generated by in-house help desk
• Supported, developed, tested and implemented management and user-defined enhancements of in-house third-party Oracle-based applications
• Developed applications and reports for end users in various Oracle Financials modules such as accounts receivable, accounts payable, order entry, inventory and marketing
• Developed reports in Oracle Developer 2000 Reports 4.5 on Sun Solaris with UNIX Windows NT client/server systems Developed functions, procedures, packages, triggers report triggers with SQL, PL/SQL
• Developed UNIX, SQL and PL/SQL scripts
• Help Desk end-user support of system problems on third-party Oracle-based applications
• Proficient with T.O.A.D. Tool for Oracle Application Developers