Mark J. A. Neumann
http://www.oocities.org/mark_neumann_oracle
Mark_Neumann_Oracle@yahoo.com
Executive Profile: Junior Oracle 10g database administrator, consultant, and management
Summary of Qualifications:
Do you want your projects done within budget, on time and with a professional atmosphere? I have an extensive education and award-winning project history. Currently, I am studying for my Oracle 10g DBA certification at Oracle Corporation. My variety of skills will definitely make a positive contribution. I am proficient in many computer software packages and have the customer service skills you expect.
I have experience in IT roles including Consultant, Microsoft SQL Server 2000 DBA, Data Analyst, Web Designer, Software Metrics Engineer, Oracle Senior System Analyst, Data Coordinator, Systems Analyst, Senior Programmer Analyst, Computer Applications Analyst and Project Leader. My Oracle 10g skills are most current and 10g certification is in process. I possess skills and experience in Web Design and Infrastructure and have utilized multiple operating systems/platforms in various corporate environments. I have worked with and supported multiple enterprise applications including Peoplesoft, SAP, Oracle and Lawson applications. My conscientiousness for quality and results has been recognized with awards and acknowledgment throughout my career. I communicate well and am proactive in my outlook.
Job Position Titles:
1) Oracle 10g Database Administrator -- DBA
2) Computer and Information Technology Managers
3) Computer Engineers, Applications Software
4) Database Administrator
5) Consultant
Technical Experience
Design Methodology: TIP process, Rational Rose, Stradis, SDM 70
CASE Tools: Designer 2000, IEF/ADW/IEW
Database / File: Oracle 10g, Microsoft SQL Server 2000, IBM DB2, Oracle 11i, Oracle 8.1.7 Enterprise, Oracle 8i, Oracle 7.x, Oracle 6.x, Oracle, SQL Server, XML, DB2, IMS, IDMS, IDMS/R, ADS/O, VSAM, Informix, INGRES, ISAM, Entrude, Enform, DBASE III/V, DATAFLEX, Access, Visual FoxPro
Database Tools: Oracle 10g Enterprise Manager, Microsoft SQL Server 2000 DTS, Oracle 11i, Oracle 8.1.7 Enterprise, Oracle 8 Enterprise Manager, Web-Enabled, Designer/2000, Object Database Designer, Developer/2000, Sedona, Oracle SQL Loader
Application Tools: Oracle 11i Financial Statement Generator, Oracle 11i General Ledger, Oracle Financial Analyzer Release 6.2, Oracle Developer, Focus, Oracle Forms, Oracle Reports, PowerBuilder, SQL Windows, Telon, Clipper, Easytrieve Plus
ERP Application: Oracle Applications, Oracle Financial Applications, Oracle HRIS, PeopleSoft HRMS, SAP
Scripting Languages: Bourne shell, C shell, CLIST, UNIX Shell, Korn shell, MVS/JCL, VI Text Editor,
Project Management: Microsoft Project
Interfaces: COM/DCOM, Dreamweaver, JDBC/ODBC
Web Development: Dreamweaver, Cold Fusion, HTML, HTML_JavaScript, Java, Oracle WebServer, Front Page, Redbrick, VBScript, VI Editor
On-line / Interactive: CICS, TSO/ISPF
Operating Systems: UNIX, HP/UX, MS-DOS, OS/2, OS/400, Solaris, VMS, Novell Netware, VM/CMS, MVS/XA, DOS/VSE, IBM 9x/2000/XP, IBM Windows/NT, Tandem TACL
Productivity Tools: Btrieve, FileAid, Lotus Notes, Xpeditor
Program Languages: Microsoft Visual FoxPro, Ada, ADS/O, C, C++, COBOL, COBOL II, Datatrieve, Java, PL/1, Oracle PL/SQL, RPG, RPG/400, SAS, SQL, PL-SQL, Visual Basic 5/6, Visual C++, SQL *Plus, OCI, TCP/IP, XML, LOB, ODBC, Open Data Access, Oracle Objects for OLE, JDBC, Rational Rose, Business Objects, Rational Rose and Apex, PeopleCode, PeopleTools, SQR, MVS JCL, JES2, DOS JCL, SQL CICS, DB2, SAP, Visual Basic (VB), VC++, Access, PeoplesoftJunior , Java, FTP, Natural 2, Fortran, Basic, SAS, Easytrieve Plus, Imagine, Accolade, APS, Transform
Telecommunications: 3COM, MS Mail, Ethernet/Fast Ethernet, ISO/OSI, MS Outlook, Novell NetWare, TCP/IP, Token Ring, Groupwise, Windows NT Operating System, FTP
Hardware: Sun Microsystems, IBM 3090, 3081‑K, 3033, 4381, 36, Tandem Himalaya K2000,
DEC VAX
Applications: ProcessPro, Oracle 11i Financial Statement Generator, Oracle 11i General Ledger, Oracle Financial Analyzer Release 6.2, Software Metrics, Software Lifecycle Modeling, Data/Object Modeling, Stored Procedures, Triggers, Report Writing, Data Warehousing, Quality Assurance, Technical Writing, Data Security, Database Tuning, Oracle Y opened standards NCA for network computing, Workflow, CSQE and CQA, ISO, Quality System Regulation Requirements, Verification and Validation, Web Development of CMM, Oracle Financial Applications, Forms 4.5, Reports 2.5 and 6i, Oracle HRIS, PeopleSoft HRMS, Integrated Financial Planning, Lawson, Contract Accumulates Cost System, Charge Back, Accounts Receivable, Property Accounting System, Sales and Analysis, Bill of Materials, Machine Rental and Utilization, General Ledger, Accounts Payable, Fixed Assets, Revenue, Materials Management System, Material Requirement Planning, Manufacturing Resource Planning, Rideshare, Traditional Incentive Systems
Project History
Consultant
Mettropolitan Health Plan
Miccrosoft SQL Server 2000 Consultant/Data Analyst Consultant
s Expert for all SQL server related questions for MHP as well as being a data integration specialist.
s Technical leader in all aspects of DB management and integration.
s Responsible for installing software, plan database, back up the database, monitor database performance.
s Ability to meet deadlines and work under pressure.
s Fine attitude and demonstrated a willingness to learn systems quickly.
Consultant/Web Designer
s Responsible for installing software, plan database, back up the database, monitor database performance.
s Created web pages.
s Strong presentation, communication and customer service skills, analytical skills for credit analysis and resolving problems. Ability to meet deadlines and work under pressure.
s Able to work independently working out of home.
s Great communication and interpersonal skills.
Microsoft SQL Server 2000 DBA Consultant/Programmer
s Developed nationally marketed ERP software for the process manufacturing industry.
s Evaluate the database server hardware.
s Install the Microsoft SQL 2000 software.
s Plan the database.
s Create and open the database.
s Back up the database.
s Enroll system users.
s Implement the database design.
s Recover from database failure.
s Monitor database performance.
s Created a Windows-based product that seamlessly integrates all aspects of manufacturing plan operations, from beginning sales order entry through manufacturing, packaging, shipping and accounting.
s Customized software to meet client specifications.
s Converted EMR ProccessPro product to Windows based Microsoft SQL 2000 and Visual FoxPro.
s Knowledge with SQL, accounting and manufacturing software systems.
Consultant
BAEE Systems/United Defense/FMC Corporation
Sofftware Metrics Engineer Consultant/Oracle DBA Consultant
Teaam Crusader Software Metrics Development
Team Crusader Cadre of Distinction Winner
Armament System Division’s (ASD) Applause Award Winner
s Established a Crusader Metrics system that collects data from existing project databases, stores the data in the Crusader Metrics repository, and produces reports in support of project management, Crusader Software Process Improvement, and the ASD division metrics repository. System implements these functions with minimal human intervention. Most reports are created from project databases “untouched by human hands”.
s Wrote system in Oracle 8.1.7, SQL Loader, Oracle on UNIX, Oracle on NT, UNIX shell scripts, SQL server, Web Dreamweaver, Business Objects, UNIX scripts, Rational Rose, Apex, Ada Analyzer Metrics Collection and related tools, Requirement and Traceability Management (RTM), Microsoft Office software suite, and Crusader IDE.
s Researched software databases.
s Crusader Software Metrics team member.
s Did Oracle and SQL database administration work.
s Did software analysis work on report writing tools.
s Took Business Objects data management courses.
s Maintained and created instances, modified and created database structures.
s Participated in database logical and physical design.
s Identified strategy and database requirements for future application development.
s Wrote UNIX shell scripts to automate various database functions.
s Established a division-wide metrics repository on July 3, 2001 for software programs to use to plan, estimate, and manage projects and processes using shared data on the Intranet. The ASD Metrics Repository PAT team identified and focuses on the needed solution to enable the division to operate at Level 3 as defined by the SEI Software Capability Maturity Model. To attain SEI Software level 3 for the division, the ASD Metrics Repository PAT was chartered to address the weaknesses and issues related to the establishment and use of a division wide metrics repository for software engineering.
s ASD Software Metrics Team member.
s Defined the data set to be collected by the software programs for inclusion in the repository.
s Populated the repository with validated data from the Crusader software program.
s Completed projects within time and budget.
May 1999 – November 1999
Consultant
United States Post Office
Oracle Senior System Analyst Consultant
United States Post Office 1999 Supplier of the Year Award Winner
s Analysis and testing of multiple systems written in Oracle, Oracle Financials, Oracle HRIS, Visual Basic, Peoplesoft, ACCESS, COBOL, COBOL II, C, Focus, IDMS, ADSO, FlashPoint and Huron Object Star for Y2K compliance.
s Independent Verification and Validation (IV&V) of date sensitive variables.
s Create test and analysis plans on a number of systems that are written in Oracle.
s Create component date handling characteristic profiles, compliance test scripts, and test completeness matrix reports for delta certification using Endevor, PVCS and SourceSafe.
s Knowledge of full system life cycles, quality assurance practices and tools.
s Automated and manual testing experience in the client server environments.
s Gave programming/system specifications to team of programmers.
s Documented all modifications, new development and system changes using Microsoft Excel and Word.
s Completed projects within time and budget.
Technisource/IntelliMark/StaffMark/Brady Company
November 1998 – April 1999
Consultant
Pillsbury
Data Coordinator Consultant
s Integrated Heinz Bakery data into Pillsbury systems.
s Completed analysis of multiple systems from Heinz and Pillsbury.
s Coordinated project with Heinz, Year 2000, SAP, Peak, Oracle, COBOL II upgrade, multiple system upgrade projects, support groups and end users.
s Gave programming/system specifications to team of programmers that coded changes in Oracle, DB2, IDMS, FOCUS, COBOL and COBOL II.
s Documented all modifications, new development and system changes using Lotus Notes, Microsoft Excel and Word.
s Completed projects within time and budget.
HealthSystem Minnesota
August 1997 - November 1998
Systems Analyst
s Provided programming/system support and development for Business Office and Accounting.
s Converted Lastword 1.12 to Lastword 4.2 for the year 2000.
s Worked to upgrade the Tandem System for the year 2000.
s Provided programming/system support for the Lawson and Lastword interfaces.
s Supported the Lawson system.
s Designed seminars for learning Lastword application to users and IM.
s Provided programming/system support and development for Business Office and Accounting.
s Completed user requests in a number of systems within time and budget.
Northland Insurance Companies
October 1992 - August 1997
Senior Programmer Analyst
s Provided programming/system support and development of agency interface systems.
s Provided support for the AS/400 to mainframe interfaces.
s Created Special Risk Facilities agent interface.
s Designed the Loss Control System using CICS and COBOL.
s Worked to convert data for the year 2000.
s Created the Premium Audit System using CICS and COBOL.
s Developed the Motorcycle Quotation System.
s Designed the Credit Reporting System using COBOL and Access.
s Completed user requests in a number of systems within time and budget.
Carlson Companies Inc.
November 1991 - October 1992
Senior Programmer/Analyst
s Designed motivation frequency development systems with user groups.
s Gave work direction in supporting systems to others.
s Designed the Becton-Dickinson System using COBOL and DB2.
s Created the Liberty Mutual Insurance System using COBOL II and IDMS ADS/O.
s Developed the Celotex System using COBOL and DB2.
s Completed user requests in a number of systems within time and budget.
BAE Systems/United Defense/FMC Corporation
September 1990 - November 1991
Computer Applications Analyst
s Provided user liaison, system development, and project control of financial related systems.
s Performed project administration for projects and developed estimates.
s Designed the Integrated Financial Planning System using COBOL and DB2.
s Developed and modified several DB2 programs using Easytrieve Plus, SAS and COBOL.
s Created the Machine Rental and Utilization System using SAS, DB2, IMS, and TOTAL.
MTC
December 1988 - September 1990
Project Leader
s Responsible for user liaison, system specification, design, and project control.
s Performed detailed evaluation of systems to ensure procedural integrity.
s Migrated the Rideshare, City of Minneapolis, Park and Ride applications.
s Evaluated new packages to replace Material Management system.
s Completed Project Management training.
s Directed company United Way's campaign.
May 1986 - December 1988
Programmer/Analyst
s Designed new programs and enhancements for manufacturing and accounting applications.
s Developed a manufacturing tracking system using CICS and IDMS.
s Created reports, inquires, interactive and batch programs to satisfy user requests.
Education
Oracle University
Oracle Database 10g: Administration Workshop 2 In process, 2005
Oracle Database 10g: Administration Workshop 1 Certificate, 2005
North Hennepin Community College
Web Design Certificate, 2004
University of Wisconsin - Milwaukee
Bachelor of Business Administration, May 1986
Major(s): Management Information Systems
Finance
Production & Management Science