| MARY LYONS | Pittsburgh, PA |
| Email Address: lyons88@verizon.net | Phone: 412-421-1924 |
Home BNY Mellon CVS Highmark MSA TBG PNC Bettis MCS Fiserv Thrift Drug Contracts
BNY Mellon, Client Services, Chief Administrative Office (Celerity Contract - 6/1/10 - 9/08/10)
Business Analyst
Analyzed current pricing procedures for Letters of Credit by conductging meetings with sales force to document current processes and map procedures utilizing Visio.
Developed Treasury Services procedures for User Defined Policies and Service Provider Management Program. Published Treasury Services Information Security Newsletter on BNY Mellon intranet utilizing Miocrosoft Publisher.
Utilized Microsoft Access, Excel, Viso, Publisher and Word to in development of executive reports, newsletters, data analysis and to outline procedures / processes.
Worked with various depatment managers to develop procedures and work flows to assist in identifyng all project aspects and define responsibilities. Utilized Visio for work flow clarity among departments as well as sequence of procedures..
Developed Mircosoft Access database fro the Credit Department to maintain relationship daa of client products and services for risk analysis. Worked with end users to develop database and reports. Semi-automated Visio charts via consolidating the dat aand exporting to Excel to link with Visio
Data Analysis
- Analyzed client relationships and utilization of product services to assign risk score to parent company
- Developed Access database to determine client relationship, develop ad-hoc report to keep credit risk up-to-date, and developed reports for management review.
- Worked with end user and Vice Predisent of Credit to determine client relationships and identify key elements for analysis.
Technical Writing
- Newsletter
- Management and Administrative Technical Procedures
- Microsoft Access development
- Technical Specifications to document Access database.
BNY Mellon, Project Coordinator (Celerity Contract - 8/09 - 12/09)
Project Coordinator
Worked with department heads in software implementation for numerous European sites to bring them on-board with Bank of New York, Mellon security stanadards. Assignments included development of standardized procedures, templates and methodologies for development of training documentation, analysis of existing Microsoft Access database and develop tracking tools for Certification software implementation.
Successfully implemented a number of productivity enhancements including automation of existing processes, templates and tacking tools utilizing Microsoft Access, Project and Excel. Analyzed existng Microsoft Access database. Make recommendations on improving the productivity of the database thru several automated processes to improve efficiency, reduce reduncancy and improve data integority.
Utilized Microsoft Project, Excel and Word to track projects; developed executive reports and training material for management and end users.
Managed all aspects of Technical Training Guides and developed central platform design for traning materials. Managed communication channels for role out of Certification process
Data Analysis
- Analyzed monthly reporting process for automated software process utilization
- Recommended modifications to Access Database to increase productivity
- Analyzed Excel spreadsheets to automate processes
Technical Writing
- Project Planning Guidelines
- Management and Administrative Technical Procedures
- Software Training Procedures
- Technical Specifications
