Mark C

Mark C. Rego

765-827-0444

Background: Professional with management and supervisory work experience. Bachelor of Science degree in Information and Computer Science. SAP R/3 Functional HR and Business Warehouse Certified. Business requirement need analysis, systems integration, management consulting, enterprise resource planning. Software development in many languages on many system platforms, both greenfield and brownfield projects. Have tackled challenges in many industries including Telecommunications, Health Care, Insurance, Financial Services, Warehousing, Manufacturing, Petrochemicals, Pharmaceuticals, Public Sector, Consumer Products, Opinion/Market Research, Media/Broadcasting, and Defense/Aerospace. Proven track of efficiently leading the functional team to achieve project goals on time. Business blue-print, configuration, testing, post go-live support, and production support. Expertise in performing configuration reviews for the work completed by team members to ensure correctness and enforce guidelines and standards. Provided necessary guidance to fellow team members to resolve configuration and process issues. Ability to manage multiple concurrent assignments and effectively communicates key project successes, milestones, issues and risks. Strong research and analytical skills, documentation and end user training skills. Excellent problem solving, decision making, communication and interpersonal skills. Good Team Player. Routinely praised for work ethic, professional dedication, resourcefulness, and creativity. Solution Leader, consistent overachiever, dependable decision maker, energetic. US Citizen.

Technical Expertise and Demonstrated Skills: SAP R/3, Unix, VMS v6.1, MS Windows, ABAP, SQL, Transact SQL (T-SQL), SQL Server, C/C++, FORTRAN, BASIC, Visual Basic, Ada, PL/I, COBOL, Pascal, Oracle, MS Access, MS Excel., MS Word, MS Project, MS Powerpoint, Visio. ABAP Developers Workbench. Methodologies/conceptual frameworks/development models: RUP (Rational Unified Process), Agile, Extreme Programming (“XP”), RAD (Rapid Application Development), JAD (Joint Application Development), and Waterfall. Sharepoint administration. Model Driven Engineering, Business Process Modeling, As Is-To Be.

Professional Experience:

January 2006 – August 2006, May 2007 – present

Rolls-Royce Corporation. Indianapolis, Indiana. IT Manager/Consultant. SAP R/3 MM Purchasing System. Defined project scope, managed project schedule, work plans. Project launch, planning, coordination with stakeholders, timelines, benchmarks. 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, consolidating data from multiple sources across North America. Metadata, data modeling, MS Word, Excel, MS Project, MS Access 2003, Visual Basic, ABAP, SQL, HTML, SAP Query, QuickViewer. SAP 4.6c and BW 3.0. BW (AKA BI) reporting, 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), Waterfall methodology. Statement of Work document. Full life cycle.

September 2006 – April 2007

Electronic Data Systems. Indianapolis, Indiana. SAP R/3 HRMS Payroll project implementor. Went live April, 2007. Configuration of Payroll Processing (RPCALC, Pre-DME, etc) including Third Party Remittance, Rules/schema Payroll schema, sub schema, rules, operation, employee subgroup and functions configuration. Retro-calculation, claims clearing, Gross to net calculations, Check replacements, reversals and manual checks. Rules including X010, U000, X510. Wage type processing configuration/valuation (earnings, deductions, gross up, tax advance, imputed income etc.)
Process model: Configuration including Regular and Off cycle / bonus, correction, on-demand, etc
Remuneration statement configuration. Payroll posting to G/L, Month-end accruals, Payroll calendar,
Payroll Reports including Payroll reconciliation, wage type reporter. ABAP Interface design/development, BAPIs. Time management, benefits. Union environment. QA Testing. Data Migration, scrubbing, and conversion from Peoplesoft for Organizational Management (OM) and Personnel Administration/Development (PA/PD) using LSMW, BDCs. SAP SD, MM system modifications, IMG. Bar code conversion. Peoplesoft, SQL. SharePoint. SAP ECC 5.0. Developed performance benchmarks, conducted Peer Reviews. Troubleshooter responsible for the development and testing of all interfaces.

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 ABAP, BAPIs/BADIs. Management of SharePoint system. Public Sector Management (PSM). US Federal Intra- government Payments and Collection (IPAC) interface design. IMG, ALE, IDOCs.

July 2005 – September 2005

Eli Lilly and Company. Indianapolis, Indiana. SAP Data Migration Manager. Defined project schedule, work plans, acceptance plan. SAP R/3 Data analysis and conversion. Maintained Traceability matrix. MS Access, Oracle 9.2, SQL/PLUS, PL/SQL, SAP 4.6C, Excel 2000, ABAP, Lotus Notes 6.5, Quest Software's TOAD, Mercury Interactive (HP) Quick Test Pro. Scrubbed SAP Bank table, material master data for 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. Defined and assigned personal areas, personal sub areas, employee groups, employee sub groups, etc. Configured organization units, jobs, positions, work schedules, wage types, calendars, actions. Customized infotypes, dynamic actions and features. BW 2.1, data modeling, generic extractors. ALE, IDOCs. Peoplesoft 2.2 integration. Interface design and development for benefits and payroll data. IMG, ABAP, BAPI, BADI, LSMW, ALV reports. RICE (Reports, Interfaces, Conversions, Enhancements). User roles/authorization profile definition and refinement. Analysis of HR historical and legal EEO reporting requirements. Implementation of HR legacy systems conversion. HR Time Management reporting. HR Requirement and gap analysis. Full international currency conversions supported. HR Business metrics. Unit testing. Full life cycle. Created development standards, naming convention and best practice documentation.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. Program Management (governance, standards, infrastructure, planning), Business development, strategic planning, project plans, scope agreement. Championed and 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. Primary resource for top management’s information and analysis. Reported to VP. IMG, HR BI Star Schema and InfoCube design and generation. Enhancement of HR business content. Documentation. Gap analysis. MS Office (Excel, Word, Powerpoint, Project, Access).

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. ABAP. Business Warehouse HR development. Followed Computer Systems Validation Policy (CSVP) validation and FDA GMP pharmaceutical industry standards. Star Schema and InfoCube design and generation, generic extractors, OLAP. Multi-national and multi-language 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. Interface with 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, Access. 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. Defined project scope, schedules, plans, design, user acceptance. Created development standards, naming convention and best practice documentation. Program Management (governance, standards, infrastructure, value chain integration, planning). 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 (T-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 (IBM Rational Rose, Platinum Software's Paradigm Plus), and Mercury Interactive's (HP) LoadRunner. Development according to RUP methodology. Served on company's HR Employee Development committee. Product Life Cycle (PLC). 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, Cognos PowerHouse. Responsible for designs, scope definition, scheduling, work assignments, user acceptance, and interviewing. Data modeling. Waterfall methodology.

October 1994 - April 1995

FHP Health Care (now PacifiCare Health Systems). Denver, Colorado. Project Manager/Consultant. Managed migration of FOCUS, SAS, COBOL, and Cognos PowerHouse. Built new HMO accounting/reporting software in preparation for HEDIS. Converted system to Oracle RDB data warehouse. Made budgets, created schedules and work plans, interviewed potential new-hires, directed analysts and programmers, and designed new system. User acceptance verification. 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. CONUS, OCONUS navigation. VAX/VMS, FORTRAN-77, Ingres, DOD Standards 2167A, 490A. Extreme Programming (XP) development model.

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. Waterfall methodology.

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. Product Data Management (PDM), Order entry, Pick, Pack, Shipping, and Inventory process control. 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, Cognos PowerHouse, DCL, data modeling, Entity Relationship Diagrams. Conducted company meetings and training sessions. Waterfall methodology.

February 1991 - March 1992

Honeywell Industrial Automation and Control. Phoenix, Arizona. Consultant. Data Base Administrator. Petrochemical process control, event history reporting. Developed data communications software. VAX/VMS v5.4, FORTRAN-77, Cognos 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. Product Data Management (PDM), Order Entry, Pick, Pack, Shipping, and Inventory process control. 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, work plans, trained programmers. User acceptance definition. 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. Product Life Cycle (PLC). Reported to Vice President.

May 1984 - August 1985

TRW, Inc. Electronics and Defense Sector (now Northrop Grumman). Redondo Beach, California. Sr. Systems Analyst/Member Technical Staff. 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. Project enforced strict Waterfall methodology. 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. Created data traceability matrix. 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. Software 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 1999 - July 1999

SAP Partner Academy SAP R/3 HR 4.0 Functional certified which includes HR050 Business Processes – HR, HR305 Configuration of Master Data, HR505 Organizational Management, HR306 Configuration of Time Recording, and HR400 Payroll Configuration.

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.