SUMMARY:

• As a certified CSM and accomplished project manager, Mac Sterling has an extensive and successful record of completing projects on time and within budget.
• Has been responsible for budgets and scheduling of various sized projects (including EVMS project tracking).
• Responsible numerous ETL functions (for very large data analysis, mapping, cross mapping, scrubbing, and conversions)
• Has managed legacy and web based client server applications in maintenance, development, conversions, implementations and QA/QC environments.
• Has been responsible for overseeing development, all phases of testing, installation and implementation of multimillion dollar systems.
• Is intimately familiar with several System Development Life Cycle (SDLC) methodologies, as well as manual and automated testing procedures.
• Has been a Developer, Business Analyst, Systems Analyst, QA Analyst, Project Leader, Project Manager and Department head in all phases of IT.
• Has been a Project and Release Manager on multimillion dollar projects, and Manager of Computer Operations.
• Has produced all levels of documentation (Technical Specifications, Business Requirements, Testing plans and requirements, Use cases, etc.) He has managed all phases of conversion projects including business requirements, data analysis, scrubbing, conversion and verification, reconciliation and reporting).
• Has worked with internal and external vendors, concurrent multinational clients, directly with Sr. Level management and intercompany IT committees.

TECHNICAL SKILLS:

• APPLICATIONS: Custodial and Mutual Funds, Portfolio Manage management, Trust Management, Retirement Plans Processing, 401(k), ETL Projects, extremely large data conversions, Numerous Account reporting projects Insurance Claims and Commissions (health/casualty/property/group health), Hospital Billing Systems, Health care claims processing, small medical practice software, Tax Reporting, Payroll, Bills of Material, EPA Reporting systems, Corporate and U. S. Government Management Systems
• TOOLS Greenhopper, JIRA, Jenkins, QMF, QMF FOR WINDOWS, DL/I, TSO/ISPF, Windows, Word, Excel, Visio, Power Point, Access, Crystal Reports, Windows, HP Quality Center (Mercury Winrunner, Test Director, Quick Test) JAD sessions
• DATABASE SQL server (various client server applications), Access, DB2, IMS dB, SYSTEM 2000, DATACOM, dBase

PROFESSIONAL EXPERIENCE:

Confidential, Boston

Technical Project Manager

Responsibilities:

• Review of alternative software to replace Confidential ’s Corporate project management system.
• Responsible for evaluating existing and 4 alternative software packages to maintain control over all projects within the Confidential family of companies.
• The tasks involved reviewing each software package for compatibility with the current system, it's interface with Jira, Jenkins, Stash, and ability to be compatible with Confidential 's cyber security requirements. The deliverable was a two level presentation, one (a single page document) for the executive committee to approve a budget projection which would allow further study, and the second was a 15 page breakout to substantiate time and cost (the final estimate was about $7 million for the project).

Confidential, Morgan City, LA

Project Manager

Responsibilities:

• Responsible for analyzing business requirements, and subsequent selection, purchasing, and installation of hardware and software for an office network
• Researched, purchased and installed application software (inventory, equipment maintenance, accounting, Project tracking and maintenance)
• Installed and trained personnel in use of Microsoft Office software
• Scrum Master Create product Backlogs, User stories, Sprints and sprint meetings. Daily meetings with Product Owner

Confidential

Technical Project Manager

Responsibilities:

• Coordinating a system integration / stress test spanning 8 systems requiring over 500,000 user logons and subsequent multiple transactions moving between the systems
• Assist in definition of and monitoring of requirements for each system in the test environment
• Tracking progress in an Agile/Scrum environment as Scrum Master using Jira, Confluence and Greenhopper.

Confidential

Project Manager & Lead QA

Responsibilities:

• Overall responsibility was to monitor and support database and application servers for the Confidential . (SQL Server application)
• As Release Manager, Supported migration and implementation of releases of software using TFS (both development and production problems) through the various environments (DEV / QA / UAT / and Prod).
• Assist QA team with Sharp and ERS test planning and testing (Citi’s Hedge fund applications). Create SQLs to scan databases before and after QA testing.
• Data Analysis, Data Mapping and Systems Reconciliation for data transfer between several systems
• Insure correct database configuration subsequent to database reloads
• Monitor and update application (Sharp) users, security, and internal parameters.
• Prepare and submit VT and VR tickets to process various database inquiries and updates
• Prepare RFCs (Request for Change) to install release updates and database inquiries and updates.
• Coordinate with business personnel during testing and software installation
• Coordinate with developers during installation and testing of software.
• Prepare and review software installation documentation
• Responsible for version control system (TFS) for software installation in QA / UAT / Production environments.
• Generate Adhoc reports and extracts (MS SQL) for product management
• Regression testing using HP Quick Test

Confidential

Senior Management Consultant (Project Manager )

Responsibilities:

• Worked as the assistant to the Director of Software Management to help organize and manage fact finding and scheduling of interdisciplinary procedures for a major system enhancement.
• Schedule and manage meetings
• Set agenda for management meetings
• Track and report on all action items assigned to all team managers
• Create progress and status reports on all projects for Director of Software Management
• Scrum Master in charge of systems testing using Scrum stories, testing sprints, daily meetings, and reporting to Director of Software Management.

Confidential

Project Manager, Data Analyst

Responsibilities:

• Confidential provides consulting services to project - oriented professional service firms. The supported systems are both Windows and Browser based client server applications
• In addition to initial consulting we provide implementation support (including data scrubbing, purging, data mapping and conversion), business management and procedures, and invoice and report customization using Access and SQL.
• Business process analysis (Interviews with principals, managers and accounting staff)
• Detailed data analysis and mapping
• Assist in installation of software Modules
• Data Scrubbing, Data conversion (ETL), system reconciliation
• Creating new reports from the new databases
• Testing / data validation
• Subsequent assistance as needed

Confidential

Senior Data Analyst

Responsibilities:

• Responsible for Database Quarterly purge and test bed regeneration processes.
• Numerous Account reporting projects
• Sr Analyst on project converting fund number format (extensive data analysis and mapping) throughout the transfer Agency database.
• Required inspection and changes to numerous programs, screens and processes on a legacy COBOL system.

Confidential

Project Manager

Responsibilities:

• Project leader in the QA department during a conversion from a legacy main frame system to a web based / client server application for a transfer agency application.
• Account reporting in preparation for testing
• Responsibilities included overall Data analysis of verification of converted files (ETL), test planning, creation of high level test matrix, and use cases, as well as responsibility for Test Director software (HP - QTP)

Confidential, Smithfield, RI

Senior Quality Analyst, Project Leader

Responsibilities:

• Project Leader in the Quality Assurance division as a Senior Quality Analyst on numerous Confidential system projects, including the several annual purge projects (including data analysis and mapping and account reporting), Annual Maintenance Fee Project, 529 Roll project and several others.

Confidential, Boston

Senior Data Analyst

Responsibilities:

• Member of a Quality Assurance team validating a web based illustration front system for a term life insurance product.
• Tasks included evaluation of BA and programming requirements and creating and executing test plans to validate multiple software products.
• Winrunner, Test Director, Excel and Word were the tools used.

Confidential

Project Manager, Data Analyst

Responsibilities:

• Confidential provides consulting services to project-oriented professional service firms.
• The supported systems are both Windows and Browser based client server applications
• In addition to initial consulting we provide implementation support (including data scrubbing, purging, data mapping and conversion), business management and procedures, and invoice and report customization using Access and SQL.
• Business process analysis (Interviews with principals, managers and accounting staff)
• Detailed data analysis and mapping
• Assist in installation of software Modules
• Data Scrubbing, Data conversion (ETL), system reconciliation
• Creating new reports from the new databases
• Testing / data validation
• Subsequent assistance as needed

Confidential

Data Analyst

Responsibilities:

• Data Analyst on a team converting a portfolio analysis process from a client server application to a mainframe process.
• Various account reporting tasks to analyze data before and after conversion
• Specific tasks included (ETL) table definition and creation, data analysis, mapping, scrubbing and conversion, program design, writing, testing and implementation. In addition, other responsibilities included maintenance tasks throughout the system.

Confidential

Project Manager

Responsibilities:

• Business Analyst and Release Manager in the 401(k) division. Responsibilities included analysis and creation of proposals and Business Requirement Documents for all levels of modification to the Omni-Plan system.
• Previously coordinated a Mainframe / client/server 401(k) compliance application.
• Responsibilities included interfacing with the Vendor, ISD staff, Compliance personnel, Network administration and the Client Services department, insuring the smooth transition of network reconfiguration, implementation of software upgrades to the mainframe and client/server package and overseeing Y2K testing and certification.

Confidential

Tech support manager

Responsibilities:

• Provided maintenance and support to the existing system until the conversion was completed.
• Responsibilities included primary on call support (7X24) for the production system, general maintenance, tax processing, user interface, system support, conversion testing, and disaster recovery team member. (system was over 20 years old and incurred nightly errors.
• In a Datacom data base structure, responsibility was fixing, adding, or removing records that were causing problems as well as write quick programs to modify the files.

Confidential

Project Lead

Responsibilities:

• Responsibilities include analysis and support of the corporate mainframe, Trust Management System (TMS) and a vendor supplied, LAN based tax-reporting system.
• Additional responsibilities involve assisting the Tax Department by writing software to extract and transfer data between the LAN and the mainframe.
• Member of a team developing online and batch software to prepare overseas funds for daily valuations.
• Duties include analysis, design, coding and testing of multiple new and existing screens and batch updates of fund tables.

Confidential

Project Manager

Responsibilities:

• Responsibilities included: systems analysis of DST.'s TA2000 system and Kemper’s MAS system, data mapping of over 160 files (including SWIFT and ACH), conceptual design, detail design, program specifications, and file analysis and definition for the purpose of creating a conversion system for 4.2 million customers and 50 billion dollars in assets.
• Additional duties included Data analysis, mapping, scrubbing and conversion, design and programming of a customer consolidation process and complete conversion account reporting for reconciliation processes as well as extensive interviewing of systems and user personnel.
• Served as Release Manager of project.

Confidential

Interim Dept. Manager

Responsibilities:

• Included were analysis of the application and software and developing methods and programs to extract a representative subset of the data to be used for specific systems testing.
• Additionally, created the capability of non technical personnel to establish multiple appropriate concurrent database test beds.
• Release Manager for software upgrades for application.
• Additional tasks included developing testing methodologies and procedures, duplicating the production on-line environment as well as developing DASD management procedures and managing the year end 1099/W2P IRS reporting projects for several years.
• Responsible for Data due diligence for sale of system/department to First Denver Bank

Confidential

Data Analyst

Responsibilities:

• Data Analyst with responsibility of searching all archived files for specific data for specified accounts.

Confidential

Project Leader

Responsibilities:

• Project leader for a team, which designed and wrote a new commercial insurance billing subsystem including on-line front-end, data capture subsystem, back-end billing processing and main frame to PC interface, PC subsystem and electronic billing via PC communications.
• Subsequently was project leader for a team that made major modifications to Confidential 's Medicaid Billing system

Confidential

Consultant

Responsibilities:

• Adapted a private practice medical system to utilize UB82 and UB92 for Confidential of Rhode Island dialysis center billing. Subsequentially further modified the system for Massachusetts Confidential .

Confidential

Project Manager

R esponsibilities:

• Project Manager of a team of programmers and analysts for a Confidential, system wide master file conversion effort (ETL) to expand several critical fields.
• Duties involved data analysis, data mapping, and analysis of over 1,000 jobs and programs, conversion of programs, JOB streams and PROCs, unit through full systems tests and implementation of changes.
• Tasks included QSAM to VSAM file conversion, expanding all files containing critical fields and modifications of all reports displaying converting fields.

Confidential

Team Leader

Responsibilities:

• Leader of consulting team, brought in to clean up over 150 outstanding problem reports dealing with extended benefits.
• Responsibilities included research into system, analysis of problem, organizing team, and management of programmers work as well as overseeing implementation of changes.

Confidential

Project Manager

Responsibilities:

• Project manager in charge of the installation of a purchased IMS payroll system serving 70,000 to 80,000 employees.
• Tasks include planning, scheduling and implementation of project tasks of 20 analysts and programmers.
• Specific responsibilities included establishing and scheduling all tasks, hiring and administration of 8 consultants and 12 employees to assist Confidential & Shop to establish conversion requirements. Additional responsibilities include being the primary contact person with the package vendor.

Confidential

Department Manager

Responsibilities:

• Department Manager of Computer Systems on a $5 billion nuclear plant construction site responsible for establishing a local computer department on site, as well as long range planning, development, and implementation of all applications software, and management of all related and operations personnel.
• Additional duties included assessment, planning, and acquisition of all computer hardware for 10-year life of the project.
• Also prepared annual near term budgets reviewed and reconciled computer cost reports and prepared variance reports, and was Stone & Webster’s representative on the project IT committee (included Department of Energy, TVA, Westinghouse, Stone & Webster and several smaller organizations)

Confidential

Project Manager

Responsibilities:

• Project Manager in charge of a team of programmers charged with the design, programming, implementation, documentation.
• The system was a multi database IMS system which the team designed and implemented.