MARY LYONS | Pittsburgh, PA |
Email Address: lyons88@verizon.net | Phone:   412-421-1924 |
Home      Highmark      BNY Mellon      MSA      PNC      Bettis      MCS      Fiserv     Thrift Drug     Contracts    
- Hired in Quality Assurance, Executive Benefits and promoted to Applications Developer, IT department within a three-month period.
- Audited PPG and Henkel reports for Executive Benefits Department. Analyzed existing reports and redesigned databases (Microsoft Access and VBA) to automate the reporting processes. Created automated audit checks to ensure data accuracy. Automation of processes allowed end users to spend more time in final report analysis rather than correcting data errors. Reduced processing time by 60% .
- Project manager role in designing of MBNA, Alcoa, PPG and Commission databases. Meetings were held with management level personnel to review procedures and requirements and to track project progression. Responsible for mapping infrastructure of databases, automation of source client data, database redesign, and creation of error tracking mechanisms to assure data integrity. These process improvements increased productivity by 50%.
- Responsible for redesigning Alcoa Total Compensation Statements process to automate client data loads and reporting process. Mapped all data sources and created templates to assure consistency of data flow and redesigned database to automate a number of manual processes.
- Responsible for training end users and producing instructional material for both end users and technical personnel. Included instructions within the database design, pop-up message boxes, prompt messages for variable data, and error tracking within the databases via utilization of Microsoft Access and Visual Basic. Conducted training sessions for user groups.
- Utilize Crystal Reports for Quantech report development.
Reason for leaving: Corporate downsizing after company realigned affiliation with TBG Financial.
Computer Expertise
- Microsoft Product Line
- Crystal Reports
- HTML
Technical Writing
- Procedures
- End User Instructions - Manuals and On-Line Documentation
- Technical Specifications and Mapping