Mary Jean McGowan

*** ****** **** ****

Lansdale, PA 19446

aczf3n@r.postjobfree.com

610-***-**** (cell)

SUMMARY:

Business Reporting and Information Systems professional with twenty years of experience in Business Analysis, Project Management and Applications Development.Experienced in providing sophisticated technical solutions and project direction for complex multi-technology, cross-functional projects. Experienced in identifying long-term functional requirements, and in developing project implementation plans to meet business unit requirements. Experienced in all phases of the System Life Cycle including analysis, development, testing and project management.

EDUCATION:

Temple University, Philadelphia Pa

Bachelors.in Business Administration 5/1979

TECHNOLOGIES:

Access 97, 2002, 2003, 2007,2010

Ab Initio BRE

Excel 2003, 2007,2010

ILOG 6 BRE

VBA

Visual Basic

Visio

SQL

TSQL -Transact SQL

Sybase

Microsoft Reporting Services

Hyperion

SQR

ClearQuest

ClearCase

MS Project

SQL Navigator

Oracle

SQL Developer

Microsoft Sharepoint

Cognos

C

Cenalar FSB

June 2015 - Present

Senior Service Reporting Business Analyst

Anaylysis and development of business area Scorecard System for 43 separate Business areas.

Analysis and Development of Project Management System for Project Reporting Team.

Cigna February 2015 - June 2015

Senior Service Reporting Business Analyst

Anaylysis and development of Scorecard Reporting System in support of Mail Order Pharmacy Division.

TD Bank –Infotek Consulting July 2014 December 2014

Information Analyst

Supported Analysis for a Smart Efficiency project which recommended process improvements for External Resource Utilization. Developed a MS Access database, queries and macros to report Contract, Temporary and Consulting spend from a variety of data sources. Database queries served as the data source for Excel Pivot tables and Graph Pivots.

Recommendations will impact 172 Million Dollars of US Annual Spend for Temporary, Consulting and Contracting resources. Data supported presentations for recommendation to made to Senior Staff.

Tyco International - Robert Half April 2014-July 2014

IT Project Manager

Served as project manager over the Migration and upgrade of 7 Finance applications which include Oracle and SQL server upgrades.

-Supported on-boarding of Contractors.

-Developed, baselined and maintained Project plans.

-Developed project status scorecards.

-Coordinated with overall corporate project timelines and objectives.

-Managed 5 local projects.

-Additionally managed off-shore technical projects in Mumbai, India and England.

-Held team conference calls, maintained meeting agendas.

-Recorded meeting minutes.

-Managed issue tracking and resolution.

-Maintained SharePoint environment.

Air Products – CAI Consulting January 2014 – February 2014

Consultant

Support for MS Access Upgrade of billing system interface to SAP. System bills and provides detailed Invoices and reporting for over 1 billion annually for gas pipeline sales for North America, Europe, Asia and South America.Served as Technical Lead. Supported Executive reporting portal.

Merck – Paragon Consulting August 2013 to December 2013

Lead MS Access Application Developer

Customer Analysis and Contract Management - Vaccine Division

Supported the Remediation of Pricing applications in MS Access 2010 to link to new structures of the Align system. Application calculates Tier Level pricing for domestic hospitals and medical providers. Supported modifications required in critical pricing reporting which is consulted as the base for all sales. It is utilized by domestic Vaccine Marketing Reps and Product Managers. Updated Price guidelines in Excel.

PHH September 2008 to June 2013

Project Lead/ Operational reporting.

Lead MS Access Application Developer.

Supported Reporting Environment which generated over 1100 Scheduled business reports Monthly.

Supported analysis and modifications required by change requests.

Served as the Project Lead and Developer supporting development projects for 14 Applications which generate over 200 generatr over custom reports.

Functions:

-Business Analysis

-Development of process flow diag

-Project Management

-Development of Requirements Documentation

-Technical Lead, Responsible for overall approach to the application design.

-Data Definition and Data Modeling

-GUI Interface design and development.

-Reporting Portal design and development.

-Database security and Development of Admin level Reporting and Maintenance functionality

-Development of Team Player Foms / Interfaces

-Development of Queries and Pass through queries and stored procedures to large Oracle and Sybase Databases.

-Development of File import procedures.

-Development of Scheduled Overnight Reporting and download procedures.

-Development of Custom reporting environments which generate custom reports to Excel and PDF formats.

-Development of VBA Code Modules

-Data Mining

-Data Validation and Standardization

-Beta and Regression Testing

-Development of Test Plans and Test Scripts

-Management of User Acceptance testing

-Development of Technical Reference Documentations

-Version control

PHH PROJECTS INCLUDE:

- STARS Team - PRUW Database

Developed MS Access application for managing STARS Project Underwriting data and

reporting on over 7000 mortgages. Application includes automated daily download from Oracle data sources. Implemented 26 automated custom reports in Excel and PDF formats.

STARS Team – STARS Appraisal Data

Developed MS Access application for managing STARS Appraisal Data to provide individual State level Reporting for Appraisal Management. Implemented executive reporting portal with 33 custom automated financial reports to Excel and PDF formats.

Repurchase Indemnification Database

Developed MS Access application for Tracking, Managing status and providing reporting on over 100 Billion dollars in Mortgages. These loans include those which have Repurchase or Indemnification Requests from current investors. Application includes automated download processes from Oracle and Sybase environments. Implemented automated generation of 19 financial reports to Excel and PDF formats.

Productivity Reporting Applications in MS Access

Developed three applications for Productivity Reporting:

Stars Productivity Order Tracking (SPOT)

Flood Accounting, Credit Tracking System (FACTS)

Stars DLD Productivity Database (DLD)

Applications included Team Player Interfaces, Database Downloads and an executive reporting portal bfor 32 Administrative Reports.

Master Securities Forward Transaction Agreement (MSFTA)

Developed MS Access application to support the Secondary Marketing Process for residential Mortgages including the tracking and document generation of daily transactions with External Financial Institutions / Counterparties This application was responsible for the Generation and tracking of External Call Proposals, Call Summary Reports and 15 tracking reports. . Implemented automated generation of financial reports to Excel and PDF formats.

Decision Analyzer.

The Decision Analyzer determined eligibility of Residential Mortgages for Secondary or Interim Funding Solutions. The MS Access rule based Application managed over 1.5 Billion Dollars in I Interim Financing solutions for the Residential Mortgage Market. Responsibilities include: Gathering, Specification Development, System Analysis and Design, Technical Lead, Development and Project Management. . Implemented automated generation of 8 financial reports to Excel and PDF formats.

Legal Portal -

Implemented SQR improvements to criteria selection screens and 8 reports of the Hyperion Legal Portal Reporting system. Improved processing speed.

AmeriHealth Administrators April 2008 -to August 2008

Supported Analysis and Client Reporting Services for Self Insured Plans.

J P Morgan Chase ( Consulting RMS Computer corp. NY, NY)

Business Analyst - Credit Card Data Warehouse September 2007 – April 2008

Supported the Chase Credit Card Data Warehouse applications in support of more than 90 million credit cards and 15 million daily card transactions. Responsible for system analysis, maintaining relationships with key business leaders, Project Management and resource allocation.

Portfolio Offer Engine – Supported rule based system for Credit Card Incentive offers.

Served as Analyst on Proof of Concept for replacement of the Business Rules Engine.

Worked with Business Leads and Project Sponsors to develop a system scorecard to compare features of AbInitio BRE and ILOG 6. This cost benefit for this application exceeded 20 million dollars annually.

Customer Data Warehouse – Improved process by building parameters to report customer profitability. Improvements to save over 12 million dollars in company expenses.

Authorization Data Warehouse – Defined requirements and Functional for Visa Risk Reporting. Improvements..

Acurian, Inc./ Devon Consulting October 2006 – June 2007

Project Analyst

Development and support of MS Access applications in support of patient recruitment campaigns for Clinical Trials. Support of Interface to Oracle environment.

Partnered with Team leads to establish timelines and project deliverables in support of patient recruitment projects.

Defined and improved applications and documentation.

Provided process training to Site Services Support Staff.

Automated standard processes as scheduled overnight processes.

Maintained project task lists and training materials to create consistent project setup and maintenance procedures.

Implemented Automated Calling Systems.

Helped to and maintain relationships with outsourced vendors involved in project execution

Main Line Software Consulting May 2006 - Aug 2006

Client: Centocor, Inc. - A Division of Johnson & Johnson, Inc.

Project Manager

Development of a web based resource for medical providers. Topics included drug benefits and risks for Rheumatoid Arthritis and Crohn’s disease products.

Partnered with Workstream leads to establish timelines and project deliverables.

Defined and managed detailed project timelines for over thirty resources including technical development, Medical Publishing, Regulatory and Administrative resources.

Managed Project Scorecard process and monitored document deliverables.

Defined and improved process flows and documentation.

Provided process training to Medical Writers.

Merck & Co., Inc. Jan 2001 - Apr 2006

Senior Systems Analyst/MS Access Developer

CDP Sharepoint Portal System:

Served as a member of the Design team.

Partnered with Team members to gather Functional Requirements and assist in implementation of a Sharepoint Portal Environment to support ten unique business Areas within the Clinical Development Area.

Financial Planning Systems - CDP Resource Planning System: MS Access based System for Project Resource and Budget Planning for all Phase 4 Clinical Trials.

Partnered with Business Team members to gather Functional Requirements.

Defined process flow documents.

Developed Specification Documents and Use Cases in accordance with Company Systems Lifecycle Standards

Defined and implemented process improvements to MS Access code. The resulting impact was that regeneration was reduced from a three-hour process to a 15-minute process. This modification allowed RPS to become a more interactive and effective planning tool. Approximately 15 man-hours were saved on a weekly basis.

Implemented MS Access import/export features.

Coordinated with Desk Side Support to develop Win-install to standardize RPS Upgrades.

Developed Project plan to manage time line.

Implemented 27 major reporting enhancements.

Updated User Documentation and provided user training.

Served as key technical support.

Executive Reporting Systems Project: Generation of Executive Summary Reports to manage Clinical Resource Time and budgets. Interfaced with Managers to define IS Resource Requirements Forecasts. Monitored Plan vs. Actual Resource and Budget Utilization. Reports were available in a variety of formats including Cognos, Brio and Sharepoint team sites.

Developed Functional Requirements and Technical Design Documents in accordance with Company Systems Lifecycle Standards.

Served as administrator.

Developed SQL and 15 Cognos Reports.

Developed Sharepoint site.

Developed and implemented a formal Test Plan and Test Scripts.

Independence Blue Cross – AmeriHealth Apr 1999 – Dec 2001

Senior Systems Analyst – Government Programs.

Supported Government reporting requirements for Texas Medicaid.

Served as Systems Analyst and Project Manger for Medicaid Reporting for the State of Texas.

Implemented improvements in the Project Management process.

Supported Year 2000 initiatives for Texas Medicaid.

Originally served as consultant, hired as a full time employee October 1999.

Maxim Group Consulting Jun 1996 – Apr 1999

Consultant

Served as a consultant supporting client requirements for a variety of Fortune 100 clients.

Hartford Insurance – Year 2000 Compliance.

Served in project management and MS Access Technical support roles. One hundred and fifty PC based applications were tested for Y2K Compliance and remediated as part of this effort.

Fleet Credit Card – Capstone Rule Based System.

Supported Fleet Capstone Rule Based System using Oracle version 7.4.

Increased productivity of Credit Card Verification to exceed 4000 applications per Hour.

Smith Kline Beecham Clinical Labs Billing and Accounts Receivable Systems.

Served as a key MS Access developer for this system that supported over 50 Million dollars of Accounts Receivables Monthly. Implemented downloads between Mainframe and Client Server based Systems. Developed a comprehensive reporting system.

Whitehall International Wyeth-Ayerst Pharmaceutical Financial Planning System.

Served as Lead Analyst and MS Access Developer of an automated system to track financial forecasting, product Launch and Sales Forecasting for Over the Counter Products in 45 countries. System was implemented in Access97.

Consulting Services May 1979 – Apr 1996

Contact this candidate