Mark C.  Rego
2709 Ebys Dr.
Connersville, Indiana 47331 USA 
765-827-0444
markrego@gmail.com

Background:

Professional with management and supervisory work experience.  SAP R/3 Functional HR and Business Warehouse Certified.  Software development in many languages on many system platforms.  Extensive nationwide travel.  Bachelor of Science degree in Information and Computer Science.  Have tackled challenges in many industries including Telecommunications, Health Care, Insurance, Financial Services, Warehousing, Manufacturing, Petrochemicals, Pharmaceuticals, Public Sector, and Defense/Aerospace.  Routinely praised for work ethic, professional dedication, resourcefulness, and creativity.  Goal Oriented.  Technical experience with SAP, Unix, VMS v6.1, MS Windows, ABAP, SQL, C/C++, FORTRAN, BASIC, Visual Basic, Ada, PL/I, COBOL, Oracle, MS Access, MS Excel.  US Citizen.  
 
Experience:
 
January 2006 – August 2006, May 2007 – December 2007

Rolls-Royce Corporation.  Indianapolis, Indiana. IT Manager/Consultant. SAP R/3 MM Purchasing System.  Designed and built Shared Services Purchasing Center database with GIS for a $300 million/year center with over 2000 suppliers toward a first year goal of saving $4.2 million/year (actual savings was $12 million).  This reporting tool provides a comprehensive view of spending, collecting data from multiple sources across North America.  Metadata, MS Word, Excel, MS Project, MS Access 2000, Visual Basic, SQL, HTML, SAP Query, QuickViewer..  SAP 4.6c and BW 3.0.  Project scheduling, design, data ETL (extraction, transformation, load), and data mining for multiple North American sites.  RICEF (Reports, Interfaces, Conversions, Enhancements, Forms). Risk management, business analytics.  Parallel testing.  SDLC (Software Development Life Cycle) design methodology.  Full life cycle.

September 2006 – April 2007

Electronic Data Systems.  Indianapolis, Indiana.  SAP R/3 HRMS Payroll project implementor.  Went live April, 2007.  ABAP Interface design/development.  Time management, benefits. Union environment. QA Testing.  Data Migration and conversion for Organizational Management (OM) and Personnel Administration/Development (PA/PD) using LSMW.  SAP SD, MM purchasing reporting system modifications. Bar code conversion. Peoplesoft, SQL.  SharePoint.  SAP ECC 5.0.  Conducted Peer Reviews.   Troubleshooter.

October 2005 – December 2005
 
US Army DFAS (Defense Finance and Accounting Service)/Accenture.  Sr. Techno- Functional Designer.  Blueprint, design of GFEBS (General Fund Enterprise Business System) project.  World’s largest financial ERP project with up to $1 Billion in disbursements per day.  Replacement of DoD legacy financial systems.  SAP R/3 5.0.  LSMW (Legacy Systems Migration Workbench).  SAP  BAPIs/BADIs.  Management of SharePoint system.  Public Sector Management (PSM).  US Federal Intra- government Payments and Collection (IPAC) interface design.  

July 2005 – September 2005

Bucher and Christian.  Indianapolis, Indiana.  Sr.  SAP Data Migration Manager.  SAP R/3 Data Analysis and Conversion for Eli Lilly and Company.  MS Access, Oracle 9.2, SQL/PLUS, PL/SQL, SAP 4.6C, Excel 2000, ABAP, Lotus Notes 6.5, Quest Software's TOAD, Mercury Quick Test Pro.  SAP Bank table master data and Purchase-To-Pay (P2P) Vendor manufacturing partners, pricing scales, purchasing information, etc.  involving SAP Modules MM, SD, and FI.  ETL global legacy data conversion.  SAP GTS (Global Trade Services) and compliance management.  FDA GMP development standards.  

September 2001 - April 2005

Coca-Cola Company.  Atlanta, Georgia.  Sr.  SAP Consultant, HR/BW Lead.  SAP R/3 4.6C, SAP HR ERP implementation.  Blueprint, design, Configuration/data conversion.  BW 2.1, generic extractors.  Peoplesoft 2.2 integration.  Interface design and development for benefits and payroll data.  ABAP, LSMW, ALV reports.  RICE (Reports, Interfaces, Conversions, Enhancements). User role definition.  Analysis of HR historical and legal EEO reporting requirements.  Implementation of HR legacy systems conversion.  HR Time Management reporting.  HR Requirement and gap analysis.  HR Business metrics.  Unit testing.  Full life cycle.  Methodology tools. MS Word, Excel, Powerpoint, Project.
 
May 2000 - May 2001
 
marchFIRST.  ERP Center of Excellence.  Denver, Colorado.  Consulting Manager.  Held highest management level classification.  Business development.  Created client project proposals (including fit/gap analysis and feasibility studies) and presentations.  Trained consultants for future HR customer projects.  SAP R/3 4.6C HR and BW 2.0B Functional.  Go-To resource for top management information and analysis.  Reported to VP.  HR Star Schema and InfoCube design and generation.  Enhancement of HR business content.  Documentation.  Gap analysis.  MS Office (Excel, Word, Powerpoint, Project).  

August 1999 - November 1999

Eli Lilly and Company.  Indianapolis, Indiana.  SAP BW Consultant.  Provided technical leadership to a matrixed team.  SAP BW 2.0 and SAP R/3 4.5A.  Business Warehouse HR development.  Followed FDA GMP and CSVP pharmaceutical industry standards.  Star Schema and InfoCube design and generation, generic extractors.  Multi-national BW HR implementation.  HR Personnel Administration, Time Management, and Payroll Infocube design.  HR Query and report requirements and definition.  Infopacket delivery scheduling, authorization profiles and security design.  Defined update rules, transfer structures, determined data granularity, aggregations, and hierarchies.  Documentation and complete regression testing with Mercury Interactive Test Director utility, Quick Test Pro (QTP).  Unit test plans.  HR Requirement and gap analysis, business metrics.  Full life-cycle.  MS Excel.  

January 1998 - April 1999

Lucent Technologies.  Greensboro, North Carolina.  SAP Consultant.  SAP R/3 4.0B and 3.1H ERP (Enterprise Resource Planning) package.  Responsible for all master data loading and data conversion for one of the largest SAP HR implementations in the world (145,000 active workers).  HR Functional configuration.  ABAP/4 coding Peoplesoft HRMS 7.5.  Integration with HR Payroll and organizational management.  Custom data extracts and BDC (Batch Data Conversion) interfaces.  CTS.  RICE. Unit test plans.  Lotus Notes 4.5.  UNIX.  Oracle 7.3.1.  IDOCs, ALE.  Technical team lead.  MS Project 98, Word, Excel.  Gap analysis.  Went live October 1998.  Full life-cycle.  Proprietary methodology tools.  Peoplesoft SQL.
 
May 1997 - November 1997
 
Northrop Grumman.  Electronic Sensors and Systems Division.  Baltimore, Maryland.  SAP Consultant.  SAP R/3 3.0F HR module.  Personnel Administration (PA) and Personnel Development (PD).  Time Management implementation, data conversion, inbound interfaces.  IMG, Data Dictionary.  Business workflow analysis.  Deloitte and Touche Consulting/ICS UPI development tool.  ABAP/4 coding, unit testing, reports.  Mentored employees.  UNIX.  SAP Dialog programming, menu painter, screen painter.  Oracle SQL.  CTS.  SAP user exits.  CATS (Cross Application Time System).  SEI software development life-cycle methodology.  Requirement and gap analysis.  RICE. Windows NT 4.0.  
 
January 1997 - May 1997

Georgia-Pacific.  Atlanta, Georgia.  SAP Consultant for Fortune 100 SAP implementation.  SAP R/3 3.0F HR module.  Personnel Administration (PA).  Health and Welfare (benefits) vendor outbound interfaces and reporting.  EDI development.  Deloitte and Touche Consulting/ICS UPI development tool.  ABAP/4 coding, unit testing.  Mentored company employees.  Method R/3 methodology tool.  RICE.

November 1995 - November 1996 
 
New Era of Networks, Inc.  (Now part of Sybase) Englewood, Colorado.  Project Leader.  Senior member of start-up company.  Various healthcare and financial (back office) projects.  Solaris 2.5, SCO UNIX, Visual C++ 2.2, Windows NT 3.51, Word 7, PowerPoint 7, Excel, MS SQL Server 6.0, Sybase, Oracle 7, MS Transact SQL, ABAP/4.  Developed patented publish-subscribe message oriented middleware EAI (Enterprise Application Integration) package,  advanced training course materials, project plans, C++ coding standards, and new hire orientation materials.  Reviewed technical manuals and API designs.  Implemented SWIFT and HL7 EDI protocols.  Initiated SAP partnership proposal.  Customer proposal support.  Recruited personnel.  Conducted tool evaluations of OOD CASE tools (Rational Rose Platinum Software's Paradigm Plus), and Mercury Interactive's LoadRunner.  Served on company's HR Employee Development committee.  Reported to VP.  

May 1995 - October 1995
 
HBO & Company/Clinicom.  Boulder, Colorado.  Project Manager/Consultant.  Pharmacy clearinghouse data communication and Electronic Data Interchange (EDI) software using NCPDP formats and protocol.  OpenVMS 6.1, C, RMS, DCL, PowerHouse.  Responsible for designs, scheduling, and interviewing.  Data modeling.  

October 1994 - April 1995
 
FHP Health Care (now PacifiCare Health Systems).  Denver, Colorado.  Project Manager/Consultant.  Managed migration of FOCUS, SAS, COBOL, and PowerHouse HMO accounting/reporting software in preparation for HEDIS.  Converted system to Oracle RDB data warehouse.  Made budgets, created schedules, interviewed potential new-hires, directed analysts and programmers, and designed new system.  Data modeling, Arthur Andersen FOUNDATION project management and CASE tools: Project Workbench, DESIGN/1.  Capitation, Coordination of Benefits, and Claims business analysis.  Familiarity with ICD9 and CPT4 codes.  Software architect.  DEC AXP (Alpha) Open VMS 6.1, VAX/VMS 5.5, DCL, SQL92, Oracle's RDB v6.0, MS Office: MS WORD v6.0, EXCEL v5.0, MS Project, COGNOS PowerHouse 7.10E (QUIZ, QTP, QUICK), Visio.  RICE. Built reporting system accounting for $500 million in annual billing.  
 
May 1994 - August 1994
 
Harris Corporation.  Information Systems Division.  Omaha, Nebraska.  Sr. Consultant.  Developed flight plan building software for Air Force Tactical Air Command/Global Weather Service.  VAX/VMS, FORTRAN-77, Ingres, DOD Standards 2167A, 490A.  

October 1993 - April 1994
 
Dow Jones & Company, Inc.  Information Services Group.  Princeton, New Jersey.  Consultant.  Business news and financial information services.  Database design and development.  C, VMS, MMS, CMS, DCL, TPU, BASIC PLUS, Motif, VAXstation 3100.  Recruited personnel.
 
August 1993 - October 1993
 
Health Net, Inc.  (Health Systems International, Inc.) Woodland Hills, California.  Consultant.  Data Modeling.  Conducted transaction analysis for all database I/O transactions.  Capitation application software.  VAX VMS, RDB, SQL, COBOL, CMS, CDD/PLUS, Entity Relationship Diagrams.
 
March 1993 - June 1993
 
MCI Telecommunications.  Colorado Springs, Colorado.  Consultant for Fortune 25 company.  Telephony.  Real-time communications software development.  Asynchronous processing.  800/900 intelligent call distribution.  VAX VMS v5.5, C language.  VAXstation 3100, DECset: CMS, MMS.  

January 1993 - March 1993
 
Litton Industrial Automation Software Systems.  San Diego, California.  Consultant.  VAX/VMS v5.5, ACMS v3.3, SQL, RDB v4.2, CDD/PLUS v5.1, C language.  Data modeling.  Warehouse distribution software development and testing.  Recruited/ managed personnel.
 
March 1992 - October 1992
 
Communiqué Telecommunications, Inc.  Ontario, California.  Consultant.  MIS software development: Sales, Billing, customer records verification software.  Automated telemarketing record keeping.  Developed detailed reports on sales, intra- and inter-LATA estimated usage, etc.  VAX/VMS v5.4, C, PL/I, RDB, SQL, FORTRAN-77, PowerHouse, DCL, data modeling, Entity Relationship Diagrams.  Conducted company meetings and training sessions.  

February 1991 - March 1992
 
Honeywell Industrial Automation and Control (now Raytheon).  Phoenix, Arizona.  Consultant.  Data Base Administrator.  Petrochemical process control, event history reporting.  Developed data communications software.  VAX/VMS v5.4, FORTRAN-77, PowerHouse 4GL v6.10C, DCL, TPU, SQL.  Data architecture and data modeling.  
 
June 1990 - October 1990
 
On site for Austin Consulting in Martinsville, Virginia.  Consultant.  Tultex.  Textile/apparel manufacturing warehouse distribution center management software development.  Systems analysis, design, and implementation.  Performance evaluation of application software.  User interface design/development.  Master scheduling software.  DECintact, data modeling, structured analysis, C language.  QA test and integration.  CMS, MMS,  Datatrieve, DCL, RMS, VAX/VMS, CDD/PLUS.  
 
April 1990 - June 1990
 
On site for Digital Equipment Corp. (now Hewlett Packard) in Denver, Colorado:  Consultant.  Ported PICK relational database system from UNIX to VAX/VMS for Unidata (now merged with Vmark Software to form Ardent).  Inter-process communication, lock management, C language, RMS, DCL, VAXset tools: MMS, CMS, CDD/PLUS.

 April 1989 - March 1990
 
On site for Digital Equipment Corp., in Memphis, Tennessee.  Consultant.  Project leader.  Directed staff of five.  Broadcast industry office automation.  Designed system architecture planned migration, project scheduling, made staff  assignments, trained programmers.  Responsible for product design, development, and testing.  VMS v5.2, DCL, C, BASIC, JYACC JAM, RICE (Reports, Interfaces, Conversions, Enhancements).
 
September 1988 - March 1989
 
Liberty Mutual Insurance.  Portsmouth, New Hampshire.  Consultant.  Conducted DEC VAX/VMS and Apple Macintosh training.  Database design and three-tier client/server performance analysis.  Evaluation of Macintosh tools.  

November 1987 - August 1988
 
TRW, Inc.  Space and Defense Sector (now Northrop Grumman). Redondo Beach, California.  Consultant.  Design and creation of a Computer Aided Manufacturing shop floor control database system for tracking .050-micron integrated circuits.  Work-In- Progress and  MRP management software.  VAX/VMS, Consillium COMETS (Workstream), TDMS, C, Datatrieve, and FORTRAN-77.  

August 1987 - October 1987

jeTech Data Systems (as elabor acquired by ADP).  Sherman Oaks, California.  Consultant for startup.  Time clock management system development.  IBM PC, MS Windows, C language.
 
June 1986 - August 1987
 
Quotron Systems/Citicorp.  Los Angeles, California.  Sr.  Systems Analyst.  Migrated AT&T UNIX System V.3.2 utilities (including Korn shell) to a 68020 based mini-computer.  Maintained Wide-Area-Network communication software to communicate with IBM 3274 based SNA/SDLC protocol.  C language, C shell, Bourne shell, awk, sccs, uucp.  
 
September 1985 - April 1986
 
Software Techniques, Inc.  Cypress, California.  Sr.  Systems Analyst for startup.  In-Depth knowledge of VMS v4.3 system services, RMS, and run-time  library routines.  C language.  Working knowledge of disk structure internals and system performance tuning.  Developed technical and user documentation.  Software testing.  Received first company award for creativity.  Reported to Vice President.
 
May 1984 - August 1985
 
TRW, Inc.  Electronics and Defense Sector (now Northrop Grumman).  Redondo Beach, California.  Sr.  Systems Analyst.  Upgraded, maintained, and tested system services software that performed system initialization, reconfiguration, and failure recovery for a distributed VAX-based USAF OTH radar system.  Responded to problems found during integration and kept all software related documents and customer agreements updated.  Mil standards 2167, 490A, 483.  Also, developed a USN OTH radar system Operator Interface prototype and related tools.  Facility setup, system management, user training.  Implemented Human Factors design objectives for Man-Machine Interface.  Familiar with military documentation and software development standards.  FORTRAN-77, VAX/VMS, US DoD Secret level security clearance.  QA testing.
 
August 1981 - April 1984
 
Decision/Making/Information.  (later Wirthlin Worldwide, now part of Harris Interactive) Santa Ana, California.  Sr.  Analyst.  Corporate MIS for major public opinion research organization.  RSTS/E and UNIX (4.1 Bsd) operating systems.  Programming in DEC BASIC-PLUS and BASIC-PLUS II languages.  Managed computer systems.  Wrote wide variety of software for over 200 client projects including White House polls.  Worked closely with company's political and market research staff.  Defined and developed research projects.  Trained users and operators.  Analyzed US Census data.  Developed sampling methodology.  Created software for system resource accounting, budgeting, and manpower scheduling.  Linear Programming optimization software.  Datatrieve.  

Education:
 
May - July 1999 SAP Partner Academy SAP R/3 HR 4.0 Functional certified.  SAP BW Functional certified.  
 
June 1977 - June 1981

University of California, Irvine.  Irvine, California.  B.S.  degree in Information and Computer Science awarded June, 1981.  Course work in artificial intelligence, information theory, combinatorics, operations research, financial mathematics, compiler design, system performance evaluation, analysis of algorithms, business administration, and logic circuit design.  

Professional Affiliation:

IEEE (Institute for Electronic and Electrical Engineers)