PROFESSIONAL SUMMARY

Seeking a lead or senior Oracle software/developer position. Over 20 years experience in the fields of systems analysis and computer software design and implementation. Proficient in a variety of computer languages and with a number of computer systems and software packages. Over 10 years experience working in a Client-Server environment.

TECHNICAL EXPERTISE

Languages: SQL, PHP, HTML, XML, XLST, Silverlight, C/C++, Visual Basic
Software: Windows 2000/XP, UNIX, A/UX, X Windows, Motif
Databases: Oracle, MySQL, MS Access, Paradox, dBase
Test Software: Autotester, XRunner, MS Test
Protocols: DTP, TCP/IP, X.25
Other Software: Oracle JDeveloper, XMLSpy 2010, Sharepoint, Telerik, Toad, ASP.NET, C#, Cognos, Crystal Reports, ERwin
Hardware: Pentium (PC & compatible), Sun Workstation, MacIntosh IIFx workstation
Awards: National Guard Minuteman Award; National Guard letter of thanks; National Guard Certificate of Commendation

EDUCATION:
MSIS, Information Systems

PROFESSIONAL EXPERIENCE

November 2011 to September 2012 – Oracle Developer, Confidential,As an Oracle Developer, Mr. Mann is part of a team developing a classified e-commerce application on an Oracle platform. His tasks include:
- Developing PL/SQL stored procedures and triggers incorporating XML and XLST files, and web service using Oracle’s Enterprise Service Bus scripts to process data received from external sources into a database.
- Developing PL/SQL stored procedures and triggers to process ETL flat files into a database.
- Developing PL/SQL stored procedures and triggers to automate different components of the application.

May 2010 to May 2011 – Principal Systems Analyst, Confidential,As a Principal Systems Analyst, Mr. Mann was part of a team developing a Web Portal application using a Silverlight front-end and SQL Server back-end on a Windows platform.
- Served as the functional DBA as well as performing developmental tasks
- Generated, maintained, and integrated two separate database applications into a single database application. He worked with the customer to acquire needed external data sources, links, and any special formats needed for inbound and outbound data for the new system. Generated separate ERD diagrams, data dictionaries, and data mappings from existing Microsoft Access front-end legacy databases into a single new database.
- Developed and tested SQL Server scripts to migrate the legacy data using integrity checks from both database applications into the new application using SQL Server and Sharepoint. This included bulk loading from data files and processing data from legacy tables.
- Developed a data migration plan outlining the process involved to migrate the data.
- Involved with the user interface by adding customer-defined external web links and developing additional popup help information in Silverlight, ASP.NET, C#, and Telerik for the front-end.
- Developed an application in Microsoft Access to serve as the project’s requirements database. This application provides tracking, traceability, and reporting of the various requirements of the web portal application.

February 2009 to March 2010 – Senior DBA, Confidential,. As a Senior DBA, Mr. Mann maintained a classified Oracle 11g database.
- Provided backups, maintained tablespaces, troubleshooting, updated the production and test platforms as needed, developed and tested oracle triggers on the different tables, developed SQL scripts for the schemas, performed data modeling, and database documentation as needed.
- Wrote an export/import function for a web interface using embedded SQL to an oracle database to aid in moving data from a development platform to the production platform to reduce data defects by standardizing the output and input formats used.

March 2007 to January 2009 – Senior Oracle Developer, Confidential,A Boeing Company.
- Part of a team that developed an e-commerce application using MySQL database on a Red hat linux platform. Tasks included DBA duties and aided in developing the front end in PHP and HTML with CSS.
- Part of a team that developed and maintained an e-commerce application using Oracle 10g on a Red hat linux platform. His tasks included DBA duties, developed a scripts to process the data into the database, and developed customized reports for the customer. In addition, he developed scripts for a data migration effort to process the data from the current version to the new version of the software.

March 2005 to March 2007 – Application Support Specialist, Confidential,As an Application Support Specialist, Mr. Mann was part of a team working on a classified database system working closely with the customer, developers, and maintained the current application.
- Interfaced daily with the customer by providing timely and special ad-hoc reports using different reporting packages including Cognos and Crystal Reports.
- Involved with troubleshooting and correcting the assigned tasks in Oracle forms and Visual Basic screens, recommended and developed enhancements for new application requirements
- Participated in data migration from the 8i platform to a 10g platform; including data cleanup in preparation for the migration.

July 2004 to February 2005 – Functional Analyst III, Confidential,As a Functional Analyst III, Mr. Mann was part of a team integrating two procurement systems with a financial interface for the Department of Commerce. Comprizon.Suite is a web-based product with Oracle as a backend, used to create requisitions that initiate the procurement process. The requisitions are then sent to a financial system for approval. Once approved, the requisitions are returned to Comprizon.Suite, where the procurement process continues. The requisitions are sent to a client/server based Comprizon.Buy for the procurement awarding, modifications, and closeout process. This included writing the functional specifications for the Comprizon.Suite and Comprizon.Buy for the new interface. He also wrote test scripts for the Comprizon.Suite portion of the software.

January 2001 – April 2004 – Programmer/Analyst Lead, Confidential,
- As a Systems Administrator for Open Allotment, Mr. Mann was responsible for maintaining the Automated Fund Control Order System (AFCOS)/Standard Army Financial System (STANFINS)/State Automated Budget System (SABS) system for the users. This included system testing, setting up user system access, trouble shooting issues as they arise, and interfacing with developers, DBAs, and end users.
- He also led a team of programmers coding, enhancing, troubleshooting, and documenting a State Accounting, Budgeting, Execution and Reservations system (SABERS) Client/Server application in a Unix platform. Recommended database changes and developed SQL scripts that modified the database at field sites when releasing software; coordinated yearly end of year software and script changes for SABERS as directed by the customer; and migrated and coordinated SABERS forms, program, and database tables from an Oracle 7.3 platform to an Oracle 8i platform. In addition, he worked closely with the field sites resolving a variety of issues.

January 1999 – January 2001 – Sr. Programmer/Analyst II, Confidential,As a Senior Programmer/Analyst II, Mr. Mann led the SABERS team described above.

November 1997 – January 1999 - Computer Consultant, Confidential,
- As a Computer Consultant, Mr. Mann was part of the SABERS team described above.
- He was also part of a team enhancing an application in a 2-tier client server environment written in C that accessed an Oracle database in a Unix environment using Tuxedo. Mr. Mann was involved with coding and testing.

November 1996 - November 1997 - Programmer, Andrulis Confidential,As a Senior Programmer/Analyst, Mr. Mann was part of a team that developed a 3-tier client-server application using a VB front end through a Tuxedo communication package to access services written in C on a unix platform to the Oracle database.

April 1995 - November 1996 - Programmer/Analyst II, Confidential,As a Programmer/Analyst II, Mr. Mann worked on a variety of projects and assignments. This included:
- Converted a series of multimedia cbt software lessons from a DOS to a Windows environment.
- Developed SQL scripts 2-tier client-server environment between Oracle backend on a unix platform and Lightship on a Windows frontend platform.
- Provided technical support for the integration of the Army Operational Logistics Data Model with the DoD Corporate Logistics Data Model and submission of the model and metadata to DISA for approval and inclusion in the DoDEDM and the DDDS.
- Developed a text and picture recognition program using Visual Basic and Pen software interfacing with a multimedia program using bitmaps.
- Developed a software test plan and test scripts for the Joint Logistics Management Information System (JL-MIS) written in VB and MS Access; and aided in the Dod-STD-2167A documentation process.
- Modified the Computer Managed Instruction SYStem (CMISYS) and the Submarine On-Board Training (SOBT) products written in C++ on a Windows platform used in training to meet new requirements.

January 1992 - March 1995 - Senior Programmer/Analyst Mil/Sci., Confidential,As a Senior Programmer, Mr. Mann worked on a variety of projects and assignments. This included:
- Thrift Investigations Management System (TIMS), his tasks included maintaining the software versions at different sites (development, testing, and field) using PAN/LCM, developing and standardizing procedures to automate where possible the upkeep of the software using Paradox 3.5 and DOS 5.0.
- Office of Contractor and Oversight Surveillance Investigative Tracking System (OCOSITS), his duties included programming reports, test script development, system testing, and Resolution Trust Corporation (RTC) documentation standard efforts.
- Office of Contractor and Oversight Surveillance Status System (OCOS3), his duties included report programming, test script development, system testing, and RTC documentation.
- Defense Systems Analysis Support (DSAS), provided technical support for the data-preprocessor in the STRAT DEFENDER 2000 Air Defense Model, which tracks planes and missile trajectories. Developed and improved routines enabling cloud cover usage in the model.
- Warfighting and Intelligence Systems Dictionary for Information Management (WISDIM), provided support for the Joint Staff and other DoD agencies. His tasks included aiding in design, coding an installation script in C Shell and SQL*Plus, implementation, testing, DoD-STD-2167A documentation, and porting of the WISDIM application written in SQL*Forms for an Oracle database from Oracle version 5.1 in a PC environment to version 6 in a Mac IIFx Workstation. Developed tools in Microsoft C to aid in analyzing the application forms on the PC 386 platform.
- Mapping and Graphic Information Capability (MAGIC), provided technical support. MAGIC is a software package that has the capability to perform data retrieval and manipulation operations, business graphics displays, and geographic and geodetic mapping displays that supports the Worldwide Military Command and Control System (WWMCCS). Tasks included enhancing, debugging, testing using XRunner, configuration management of code using SCCS, and porting the current graphics system from a Sun Workstation written in BSD System 5 version of C on a Unix platform to a Mac IIFx Workstation System 5 with extensions version of C on a unix platform. Also involved to improve software quality at CBSI by being part of a team developing software inspections.