TERRY MCELROY III

# * ****** ***** ***** abnsb8@r.postjobfree.com

O’Fallon, MO 63368 314-***-**** mobile

SUMMARY OF QUALIFICATIONS

Experienced senior manager: Strong operational and corporate IT background. Managed help desks, infrastructure

support teams, response teams and dedicated support personnel. Experienced in people management, operational

management and business development. Experienced at managing and working within large corporate business, finance,

government and quasi government establishments. Call management software implementation, which required business

analysis and Business Process Re-engineering (BPR) prior to implementation. A versatile manager with highly

developed communication and organizational skills and a proven track record for service delivery in a variety of

technical environments. Ability to foster strong personal and working relationships with clients, suppliers and

colleagues.

Experienced project manager/Business Analyst: Carried full project life cycle responsibilities including

feasibility studies, project initiation, requirements research, business impact assessments, product evaluations,

project plans, defining critical paths, risk mitigation, change control, staff management, status reporting, testing,

deployment and project closure. Experience includes managing budgets, timelines, & resource allocation tracking

(MS Project). Methodologies include Rational Unified Process (RUP), and the Software Engineering Institute

Capable Maturity Model (CMM/CMMI). Assembled cross-functional teams. Managed project lifecycle (definition,

design, engineering, development, testing, provisioning, documentation, support).

Customer/vendor relations manager - Excellent communications, team-building, and conflict management skills.

Diplomatically resolved issues involving vendors (domestic and international), internal customers, and client

companies. Project manager for numerous system upgrades. Led applications development teams that provided

solutions for growing data management needs. Senior Project Manager with experience managing multiple,

concurrent infrastructure, implementation and process analysis projects.

Enterprise Resource Planning (ERP): Analyze, design, implement, and maintain activities associated with ERP.

Facilitate cross-functionally to ensure all teams utilize correct information. Prepare status reports, progress reports,

and documentation. Manage the compilation and entry of required information from a variety of departments in line

with the service level agreement. Provide support to resolve operational ERP queries, maintaining the integrity of

the information and process.

PROFESSIONAL EXPERIENCE

Wachovia / A. G. Edwards, St. Louis, Missouri 09/16/2008-Present

Consultant (Strategic Staffing Solutions) - Senior Project Analyst

• Responsible for tracking and documenting AGE/Wachovia Off-Shore application decommission deliverables.

• Coordinate the communication plan for the Portfolio for all application decommission deliverables including delivery

and sign-off with application and project/program stakeholders.

• Measure and monitor progress at clearly defined points in the process to ensure that the project is delivered on time,

within budget, and that it meets or exceeds expectations for the team.

• Review the overall development and integration of deliverables for the Portfolio.

• Ensure that all requirements, project plans, and changes to commitment are communicated to all affected team

members for the Portfolio.

• Coordinate Decommission delivery and dependencies with various Decom delivery centers including AMPS and Data

Archival.

• Follow all quality assurance processes, including periodic reviews and transitions for the Portfolio.

• Ensure that the end product fulfills the requirements and meets the business sponsor's expectations for the Portfolio.

• Schedule and conduct decommission project related meeting and prepare meeting minutes.

• Research, gather and document requirements for Decommissioning AGE Legacy Application.

• Research, gather and document requirements for Migrating AGE Legacy Application to Wachovia Securities existing

IT system.

• Research, gather and document requirements for Archiving AGE Legacy Application.

• Liaison for project lead for making decommission decisions involving Solutions Architecture, Data Management,

Records Management, and Hardware Decommissioning work stream.

Environment: PeopleSoft, Windows 2003, MS Access, Web based Apps, Methodology (UML, RUP), MS Project,

Requisite Pro, Visio, Oracle 9.x, Crystal Reports, Unix, Advanced Query Tool, Remedy, Clear Quest, Clear

Case, Cobol.

Sara Lee Corporation, St. Louis, Missouri 04/16/2007-9/12/2008

Consultant (EDS / HP ) - Project Manager / Senior Business Analyst

• Project Manager, Sr. Analyst and Developer. Special Earnings Project / WorkBrain and Kronos. (payroll and time

keeping system). Managed the implementation of the Employee Special Earnings Hourly Wage Adjustment

program for Sara Lee Union employees in collaboration with the new Union contract for overtime, shift, and special

assignment job duties. Responsible for analyzing, collecting and documenting the business requirements and

defining the most suitable and efficient technical solution that meets the Unions contractual requirements.

Personally designed and developed MS Access system to track and calculate Special Earnings adjusted pay for

qualifying Union employees.

• Sr. Business Analyst in support of ADP, SAP data acquisition, reports and menu design/modifications.

• Perform Integration Testing and assist with User Acceptance Testing.

• Requirements gathering for application enhancements, report generation, and problem solving.

• Sr. Business Analyst, Employee Stock Purchasing Project.

• Sr. Business Analyst for Automated Payroll Deductions process (United Way, Stocks-Bonds, Union Dues).

Environment: ADP, SAP, MS Project, Visio, Oracle 9.x, Windows 2003, MS Access, Web based Apps, Advanced Query

Tool, Toad, Methodology (UML, RUP), (WorkBrain, and Kronos time keeping systems).

A. G. Edwards, St. Louis, Missouri 04/03/2006-04/16/2007

Consultant(Solutions Consulting) - Senior Business Analyst / Project Manager / Product Manager

• Provides senior level Business analyst service in support of the following applications..:

o Compliance Management Reporting System, Branch Supervision, Account Profile.

• Perform Integration Testing and assist with User Acceptance Testing.

• Used Business Objects to generate reports to validate data conversion from Mainframe to Client Server.

• Requirements gathering for application enhancements, report generation, and problem solving.

• Sr. Business Analyst, AIM Project (Decommission of Compliance Main Frame Application)

• Product Manager for Compliance, Law, and Internal Audit Applications.

• Platform Migration Project Manager. Certify Compliance Applications (Integration, UA and Production testing) for

system upgrades.

Environment: PeopleSoft, Windows 2003, MS Access, Web based Apps, Methodology (UML, RUP), MS Project,

Requisite Pro, Visio, Oracle 9.x, Crystal Reports, Unix, Advanced Query Tool, Remedy, Clear Quest, Clear

Case, Cobol.

Peabody Energy, St. Louis, Missouri 02/07/2006-04/03/2006

Consultant (Teksystems) - Senior Business Analyst

• Provides senior level Business analyst service in support of the following applications..: Allegro Coal Trade, Sale

Invoicing and Revenue System, Risk Tracker, Domino Doc, Tax Forecasting, and Surety Bond.

• Perform Integration Testing and assist with User Acceptance Testing.

• Requirements gathering for application enhancements, report generation, and problem solving.

• Functional Analyst for upgrading Allegro version 6.09 to Allegro version 7.6.

Environment: PL/SQL, Windows 2000, MS Access, Web based Apps, Methodology (UML, RUP), MS Project, Visio,

Oracle 9.x, Crystal Reports, Hyperion, Business Objects.

Wells Fargo & Company – St. Louis, MO 05/02/2005-12/30/2005

Consultant (KForce Consulting) - Senior Business Analyst / Project Manager

• Provided senior level systems analyst service in support of the Capital Markets Investment Analytics team as

assigned. Works with business and WFS team members to define and document, business processes, business

requirements, functional specifications, technical specifications, and test plans. Acts as a liaison between client area

and technical organization by planning, conducting, and directing the analysis of highly complex business problems

to be solved with automated systems. Provides technical assistance in identifying, evaluating, and developing

systems and procedures that are cost effective and meet business requirements. Works with user groups to provide

training, resolve questions, assess user needs, and recommend changes.

• Gathered Business Requirements from Business team to generate Ad-Hoc reports using Business Objects.

• Prepares specifications for system changes. Recommends and initiates systems testing. Acts as an internal

consultant within technology and business groups by using quality tools and process definition/improvement to re-

engineer technical processes for greater efficiencies.

• Identify, communicate and help resolve production issues.

• Manage the system’s production issues by maintaining a comprehensive list of issues, regularly collecting and

reporting status on open issues, and driving resolution of open issues.

• Collect and redirect information to create weekly, monthly and quarterly production status reports for management.

• Maintain application documentation current for the systems you are responsible for.

• Identify, analyze, and document user’s needs for ongoing system enhancements to meet changing market conditions,

regulatory and productivity needs. Coordinate the enhancement implementations using change control procedures.

• Manage the Tier 3 project process; receive, scope and size new requests. Track and provide periodic status for open

requests. Negotiate priorities with business users. Maintain and update SOW and provide schedule oversight and

tracking for active projects.

• Representative for enterprise projects as assigned: Provide a group focal point for project scoping, requirements

definition, project planning, test planning and status reporting.

• Lead and/or assist in Business Requirements Documentation (BRD) creation by utilizing domain, data and process

knowledge along with analysis skills to identify and quantify business needs.

• Develop and consolidate effort estimates for projects.

• Provides forecast input to managers and project managers.

• Analyze business requirements and provide input to solutions, functional and technical designs and specifications,

and trouble specifications/requirements. Create and manage group work plans.

• Work closely with business leaders to understand business needs and advise on technology solutions and

opportunities.

• Work closely with WFS team members outside of Mortgage IT to understand enterprise directions.

• Work closely with Mortgage IT development colleagues to coordinate enterprise initiatives and planning.

• Strengthen working relationships with the business partners in Capital Markets.

• Author and maintain service level agreements (SLAs). Every application we manage will have a signed off SLA in

place. No Exceptions.

• Review and update SLAs quarterly.

• Establish a monitoring and reporting process for all SLAs.

• Resolve all security contingencies in a timely manner (no overdue contingencies).

• Implement appropriate capacity planning processes in alignment with WFS Scorecard requirements.

• Work with management to set training goals for the year.

• Contribute timely and accurate information to project reporting, time reporting, and productivity measures.

Environment: WinSQL, PeopleSoft 8.x, Unix, Windows 2000, MS Access, Web based Apps, Methodology (UML, RUP),

ClearCase, ClearQuest, MS Project, Remedy, Visio, DB2

Maveric Tube Corporation – St. Louis, MO 02/02/2005-05/02/2005

Consultant (Kelly Mitchell Group) - Senior Business Analyst

• Assigned Lead Analyst for converting Oracle Financials HR system to PeopleSoft 8.8 HRMS system.

• BA in charge of converting Oracle Time and Labor system to PeopleSoft Time Tracking system.

• BA in charge of implementing Labor codes with cross referenced Benefits code table.

• Worked with Business and Technical team members to define and document, business processes, business

requirements, functional specifications, technical specifications, and test plans.

• Prepared specifications for system changes.

The BOEING Co. - St. Louis, MO 10/2001 – 12/2004

Consultant(Teksystems) - HRMS Senior Business Analyst

• Security Admin. Responsible for setting up employee access accounts and specifying access rights and roles specific

to PeopleSoft panels, tables, reports, Password resets, (employee access imitation) etc

• Lead Business analyst during conversion of Cognose System to PeopleSoft v7.5, v8.0 and PS v8.8 which included

aligning HR segments of PS system with noted areas of requirements from HR Representatives and HR Managers.

For example, Job codes, Employee Indicator/type/status -(perm, temp, contractor, hourly, salary), salary grade,

Union or Non-Union, etc

• Analyzed and documented Workforce Administration, Job Administration, Employee management, Time Keeping,

and Payroll segments within the PeopleSoft environment based on HR Generalist requirements.

• Instrumental in the development of PeopleSoft Employee Self Service Portal.

• Instrumental in the development of PeopleSoft Managers Portal.

• Extensive use of PeopleTools Query manager for developing queries and reports.

• Managed Request for personal and global HR related queries.

• Analyzed and assisted in the development of PS HR Department table tree structure.

• Analyzed specific system applications, provided implementation and sustaining support, including subsequent

integration with associated applications or systems. Conducted analysis and research of information requirements

for departmental systems. Provided guidance and training to customers in the use of applications, data files, and

databases to retrieve and manipulate data effectively. Assisted customers in resolving application problems from

customer's identification of problem through service restoration. Participate in all phases of the systems life cycle,

using common software development processes. Interfaced with application users, other department application

maintenance personnel, programmer/analysts, and other technical support personnel.

• Investigated, analyzed, and resolved complex application questions and problems. Conversant with database

standards, security, methods, and tools. Developed advanced reporting and software to support application

processes. Consulted with customer to recommend system changes and enhancements. Prepared business case

analyses. Developed program plans using established system methodology for major system enhancements.

• Develop PeopleSoft HRMS queries. Maintenance of PeopleSoft panel designs.

• Develop MS Access database, forms and queries. Develop Unix / Java / SQLPlus scripts.

• Develop Brio queries, reports and data export. Modify Java scripts to end user requirements.

• Conducted meetings to determine Business rules/requirements for Data Warehouse tables.

• Extensive use of Remedy and KANA (Action Request System and case management tools).

• Developed Process Flows. Level 2 support for Enterprise Data Warehouse team.

Environment: PeopleSoft 7.5 - 8.x, Oracle 8.x, PL/SQL, SQLPlus, Unix, Brio 6.x, Windows 2000, MS Access, Web based

Apps, Methodology (UML, RUP, RAD, Waterfall), ClearCase, ClearQuest,

EDWARD JONES - St. Louis, MO 04/1999 - 04/2001

Project Manager / Programmer Analyst

Managed, designed, developed, and implemented new projects.

• Constructed project plan for project completion using Applix Autoplan software and MS Project.

• Coordinated Infrastructure requirements with partnering departments for system requirements.

• Worked with DASD team to insure proper space requirements are met for large volumes of data.

• Worked with FTP team to coordinate process for moving data from Mainframe to Client-Server.

• Worked with production control to set up run schedules for time variant and date specific jobs.

• Created production job (JCL/PROC/CNTL.CRD) for weekly/monthly/yearly extract process.

• Created code extraction programs using COBOL, MVS and Unix FOCUS.

• Used PL/SQL procedures and Java Scripts for development of extracting data from staging tables and inserting data

into Data Warehouse Datamarts.

• Used PL/SQL as a procedure for dropping and recreating Oracle tables.

• Created load control cards and load scripts(PL/SQL and Java scripts) to load data to Oracle database on Unix

environment.

• Conducted Kickoff meetings with department heads to gain knowledge of information they felt would be useful to

their department.

• Determine Business rules and requirements gathering for Data Warehouse tables.

• Extensive use of Unix, SQLPlus, PL/SQL, FOCUS/WebFOCUS and Brio(OLAP tool).

• On-Call Support for existing production Data Warehouse Jobs.

• Created Oracle Table Design, Data Dictionary, Views and Data Access Methods.

• Created data extract and load process (Oracle Load scripts, control cards, Indexes).

• Created Logical ER, Multidimensional and Fact Qualifier data models using ERwin.

• Created Oracle packages, procedures, views, triggers and objects.

• Designed and developed Oracle 8i database structures for OLAP tools (ie. Brio).

• Integrated tool bars within WebFOCUS designed reports.

• Set up export options for user defined canned reports.

• Performed analysis, logical and physical design for Data Warehouse and Datamarts using ERwin.

• Combined efforts with HR-PeopleSoft team to create Views for data extract.

Environment: Methodology (PMI, UML, RUP, RAD), Oracle, PL/SQL, SQLPlus, COBOL, IDMS, VSAM, Unix, ERwin,

Sys390, Windows NT, DB2, Platnum, MS Project, Vertools, Applix, Autosys, Netscape Composer, FOCUS/WebFOCUS,

Java, Brio

SRA INTERNATIONAL - St. Louis, MO 08/1998 - 04/1999

Consultant / Project Manager - Team Lead

• Planned and executed system testing, functional testing, and integration testing of USPS information systems.

• Prepared test plans in accordance with USPS standards. Documented test scenarios and detailed test procedures.

• Prepared expected results and tested databases. Prepared scripts to support automated builds of test databases.

• Year 2000 observation, Modification and Manual line of code review (COBOL, Visual Basic 4.0 Pascal, Fortran,

C++, Access).

• Coordinated with the maintenance staff to increase understanding of problem reports and identify possible solutions.

Also, comply with the USPS standard procedures to support requirements management, matrix, configuration

management(ENDEVER, etc Contingency Planning.

Environment: Methodology (UML, RUP, RAD ), Oracle, Visual Basic, Fortran, C++, MS Access, Pascal, COBOL, Unix,

Sys390, Windows NT, Endever

MASTERCARD, INTERNATIONAL - St. Louis, MO 01/1996 - 07/1998

Consultant (Teksystems/Maxim Group) Project Manager / Supervisor (04/1997-07/1998)

• Managed a staff of 10 to 15 employees as well as new and existing RPS projects: Extensive testing of Y2K

Modules; Converted RPS Application from COBOL I to COBOL II; Application support for Windows NT.

• Managed project for Banknet File Express conversion to Connect Mailbox CTC using Procomm Plus as the new

Communication Application and MS Project to manage project flow.

• Windows NT and Business support for electronic file transfer system. Used Visual Basic, SQL Server and MS

Access to develop member database and certify (test) member files for ACH and CIE file format.

• Exercised administrative duties between departments. Coordinate responsibilities, requirements and timeframes for

implementing members.

• Project leader responsible for the design and implementation of an interactive data base system containing a screen-

oriented Payment retrieval system. This system supports Structured Analysis by providing an automated Payment

flow system for tracking information associated with a customers trace number.

Project Manager (01/1996-04/1997)

• Managed, planned and coordinated $16.4 million project to install Credit Card Processing

communication equipment for over 80 major banks and Credit Card processing centers. Managed the

replacement of outdated Series1 communication systems with modern Y2k compliant Unix based

communication processing system.

• Supervised software engineering team, network engineering and vendor testing team to insure quality

replacement of Series1 communication system.

• Determined current and future technology needs and defined system architecture for online credit

card transactions.

• Certify MasterCard products and services for new and existing members; Type I & II online Authorization

testing; INET(Clearing file) testing.

• Provided installation, testing, training and support for network application interfaces such as Bisync, SNA,

Channel and X.25.

• Provided general technical support and detailed knowledge of MasterCard products/services and

hardware/software to member banks and credit card processors.

Environment: Methodology (UML, RUP, RAD), COBOL, Oracle, Unix, ERwin, Sys390, Windows NT, MS Project,

Procomm Plus, MS Access, MS SQL Server, Visual Basic, Netscape Composer, Bisync, SNA, Channel and X.25

SOUTHWESTERN BELL - St. Louis, MO 05/1995 - 01/1996

Consultant / Programmer

• Developed and supported SWBC new design of Phone bill reporting, inserts and Itemizations.

• Verified reports using Microsoft Access and Visual Basic to maintain, and correct discrepancies.

• Constructed and maintained phrase tables for bill itemization and data inserts.

• Maintained code and data extract from legacy system using COBOL.

Environment: Visual Basic, MS Access, COBOL, Sys390, Windows NT

BLUE CROSS BLUE SHIELD - St. Louis, MO 04/1994 - 04/1995

Consultant (Howard Systems) / Programmer

• Analyzed, designed and implemented code for weekly, monthly, annual reports.

• Developed and maintained existing code for Claims and Membership departments using CICS, MVS, JCL, TSO,

ISPF, IDMS & DB2 database.

Environment: COBOL, CICS, MVS, JCL, TSO, ISPF, IDMS & DB2, Sys390

CINCOM SYSTEMS - St. Louis, MO 04/1993 - 04/1994

Level 2 Support

• Supported software such as DOS, OS/2, Novell Network and LAN Manager.

• Supported - Mantis, AD/Advantage, SQL Windows, PC/Contact, Expert Rule and Quest.

• Software installation and modification of documentation.

Environment: Novell, DOS, OS/2, SQL Windows, PC/Contact, Windows 3.1, LAN Manager, Quest

COMPUTER ENTERPRISE - St. Louis, MO 06/1992 - 04/1993

Systems Analyst / Development

• Provided system implementation, design, software installation and support for contracted clients (MS Access, Dbase

IV, Lotus, Word Perfect, Q&A).

• Network trainee: Installed network cards and cabling for small LAN networking systems; Accounting and general

business programming.

Environment: MS Access, Dbase IV, Lotus, Word Perfect, Novell, MS Windows

UM, ST. LOUIS - St. Louis, MO 05/1991 - 05/1992

Program Coordinator

• Responsible for job placement and performance supervision of high school students in work environments such as

the IRS, Federal Reserve Bank, Regional Hospital.

• Oversight of compliance between students and job recruiting officers.

• Developed program objectives and status reports for administrators.

Environment: Unix, Windows, Macintosh, Lotus 123, DOS

SURVIVAL TECHNOLOGY, INC. - St. Louis, MO 10/1989 - 05/1991

Process Analyst

• Developed inventory control of pharmaceutical devices using DBASE III.

• Developed software using Pascal for import, export and purchase order reports. Developed the training program for

new co-op students and employees.

Environment: DBASE III, Pascal, DOS

FOOD AND DRUG ADMINISTRATION - St. Louis, MO 08/1987 - 07/1988

Programmer

• Maintained existing COBOL programs; Automated electronic mail system.

• System presentations and employee training.

• Developed database system for drug monitoring.

• Coded and modified specific programs for chemists' use.

Environment: COBOL, Pascal, DOS, Focus, Z4

TECHNICAL EXPERTISE

Languages PL/SQL, SQLPlus, Visual Basic, Web FOCUS, FOCUS, Brio 6.x, HTML Internet, C/C++, PowerBuilder,

SQL Windows, COBOL, Mantis, Unix Scripting, Fortran, Pascal

Operating Systems Windows 3.1, Windows NT, Windows95-98-2000, UNIX, MVS, DOS

Database Oracle, SQL Server, Teradata, IDMS, DB2, Microsoft Access, Quest

Tools Microsoft Project, Toad, ERwin, Microsoft Office, ENDEVER, DMLO, Net Meeting,

WebEx, Remedy, KANA, Requisite Pro, Clear Case, Clear Quest

Other PeopleSoft 7.5 – 8.8, OOD/OOP, TCP/IP, OLE, ODBC, IDD, OLAP, Web Browsers,

Netscape Composer, MS Front Page, Data Modeling, Data Warehousing Design, Project

Management, Configuration Management, DSS, Business Intelligence

EDUCATION

B.S. MIS, University of Missouri-St. Louis

Data Modeling Certificate - Data Warehousing Institute

Project Management Certificate - Center for Corporate Education

Unix Certificate - Laine Educational Enterprises, LTD

Oracle DBMS & PL/SQL - Laine Educational Enterprises, LTD

Windows NT Certificate - New horizons Learning Center

University of Missouri-St. Louis Chancellors Certificate:

Computer Hardware and Software Applications

Core Skill Set

Project Management

Business Analysis

System Analysis

Enterprise Resource Planning

PeopleSoft HRMS System

Data Warehousing

Data Modeling

Software Development

Network Administrator - Windows NT 4.0

Reference: Available upon request

Contact this candidate