Project Management Business Process
Resume:
pg. *
Sheryl M. Murphy
Willis, MI 48191 Cell 734-***-****
***************@*****.***
PROFESSIONAL SUMMARY
Innovative, results-driven Analyst with years of experience leading and contributing to the development of cost-effective solutions that increase operating efficiency and enhance marketing capabilities.
Highly analytical with “big picture” vision. Proficient at working with corporate leaders to create informative analytics used in the decision-making process.
Solid organization, time management and motivational skills; consistently able to deliver top-quality projects under the tightest deadlines.
KEY COMPETENCIES PROFESSIONAL EXPERIENCES
Reporting & Analytics
Development
Customer Relationship
Management
Business Process Re-
engineering
Current & Future State Process
Modeling
Project Management
Training / Mentoring
Strategic Planning
Six Sigma & PMI Training
Agile, Use Cases, Story
Boards, Test Cases…
Tykey Home Solutions / Property Mgmt
Aerotek
MB Financial
VACO
Dycom Industries
Ford Motor Company
2017 – 2024
2018 – 2019
2012 – 2018
2011 – 2012
2011
2005 – 2011
U.S. Air Force
University of Phoenix, Southfield, MI
MBA, Business Administration, 12/2007
Project Management Certification, 02/2002
B.S., Business/Information Systems, 04/2001
Key Accomplishments:
Implemented interface to be used by Counterparty team to manage the wholesale account relationship, replacing an external application and saving the company 12 – 18k monthly
Partnered with business to create reporting, database, and other analytics that resulted in an estimate 6.45 FTE reduction
Automated review of lineage workbooks, reducing the review process from 4 days to less than an hour
Received Silver Award for successfully managing assimilation of the business partner portfolio application into the alliance support organization.
Activities Performed:
Manage Change Requests for Reporting Data
Warehouse, included gathering of requests,
working with the business to document
requirements and prioritization, and coordination
with IT support team to get the work done
Actively training other junior analysis, increasing overall business knowledge and technical skills in the use of MS Access, SQL Server Reporting
Services, and SQL.
Work with leadership to build out the algorithms and models use in Capacity Modeling to ensure
capacity meets the current and future business
needs in a cost-effective manner
Prioritization of requests and distribution of work amount team members
Manage Basel II project for mortgage servicing systems, worked with business to identify data points used in the mortgage process, complete data lineage workbooks. Completed data quality reviews. Worked with Data
Governance team to add identified attributes to the data dictionary
Support Continuous Improvement with through process analysis
Coordinated project between IT and Operational Excellence team at MB to gather the information required by FNMA, standardize the data communications, delivering the required changes in time to meeting the government mandates
pg. 2
PROFESSIONAL EXPERIENCE
Tykey Home Solutions / Property Mgmt.
Operating Manager
10/2017 – 04/2024
6 year 2 months
Duties include:
Work with team and investors to identify rehab projects
Develop project budgets
Tracking, Planning and Management of residential redevelopment projects from conception to completion
Negotiating and oversee Contractors, review the work completed daily
Worked with Investors in the development of budgets, monitor compliance, and ensure projects completed on time and within budget
Manage Rentals, market for new tenants, manage work requests, gather rent, and manage eviction process
Spearhead the collection of rents with a less than 60 day past due average on the books. Enforce deadlines and penalties for late payments.
Work with past due rents to set up payment plans.
Define and set up systems for collecting rent from tenants., and a method to check all rents have been paid as agreed.
Training employees in office process and procedures Aerotek
Senior Data Analyst
Client: MB Financial Bank
6/2018-6/2019
12 months
Duties include:
Support various MS Access databases, SSRS reporting during the ramp down of the mortgage division
Provide support to leadership and various business through the running of queries and other support requests MB Financial Bank formerly Cole Taylor Mortgage
Senior Data Analyst
* First six months as a contractor under R3
08/2012-6/2018
5 years 10 months
Duties include:
Developed MS Access interface which supports large areas of the business workflow process which reduce the need for added headcount and increase data available for improved production report, leadership dashboards, and capacity planning analytics
Designed, Implemented, and maintained a data warehouse created to support the Risk Management Team. This warehouse grew into the Reporting and Analytics Warehouse used for reporting company wide. This database gather data from number of sources – Excel spreadsheet, flat files, and several transactional databases. To load the database, I used a variety of techniques: MS Access, SQL, SQL Procedures, functions, triggers, and SSIS.
Created of KPI, Production Tracking, Workflow, Capacity Planning as well as other analytic reports used by the business leadership
Responsible for prioritization of requests, distribution of work amount team members
Actively training other junior analysis, increasing overall business knowledge and technical skills in the use of SQL Server Reporting Services and SQL.
Development of structured (canned) reporting; as well as ad hoc reporting to meet the needs of the business
Partnership with the business to gather requirements, document, build and maintain simple to complex MS Access interfaces in support of the mortgage business units
Documented and Implemented procedures and processes used by team to manage daily work
Supervision of other analysts on teams, training, prioritization and communication to business-on-business needs Key Accomplishments:
Implemented interface to be used by Counterparty team to manage the wholesale account relationship, replacing an external application and saving the company12 - 18,000 monthly pg. 3
Partnered with business to create reporting, database, and other analytics that resulted in an estimate 6.45 FTE reduction in 2015
Won multiple customer service (WOW) awards
VACO
Senior Business Analyst
Client: Ally Bank
10/2011 – 08/2012
11 months
Duties include:
Supported Basel II project for mortgage servicing systems, worked with business to identify data points used in the mortgage process, complete data lineage workbooks. Completed data quality reviews. Worked with the Data Governance team to add identified attributes to the data dictionary
Participating with BA team to gather requirements for Basel II project, from mortgage business partners
Gathering business requirements to support the calculator and risk modeling tools by collaborating with business partners and other key technical resources across the organization.
Lead on development of the data lineage workbooks, including data quality reviews, data governance, and reporting
Documented data lineage for Servicing systems, documented business rules, data quality requirements, and develop test cases
Work with Technical Team to understand data mappings from source systems to design Mortgage Data warehouse being implemented to support Basel II compliance Key Accomplishments:
Automated review of lineage workbooks, reducing the review process from 4 days to less than an hour Dycom Industries, West Palm Beach, FL
Senior Business Analyst
02/2011 – 09/2011
8 months
Duties include:
Traveling to the subsidiaries owned by the company to gather requirements for the replacement of an internally written Crew Production System
Support internal application by gathering enhancement requirements, document requirements, working with the developer to design and test changes
Complete Gap Analysis of two systems which perform functionality like the internal Crew Production System Key Accomplishments:
Participated in the deployment of a reporting database for the internal Crew Production System; documented requirements, performed testing, and provided support after the launch Ford Motor Company, Dearborn, MI
Business Analysis/Team Lead/Project Manager
02/2005 – 02/2011
6 years
Duties include:
Prioritizing the work done by the development team as well as business analysis – responsible for the collection and documenting of application requirements for a variety of enterprise applications.
Gather, review and negotiate priority for changes to a large call center application, Developed complex SQL and PL/SQL
Execute Gap Analysis on Enterprise mapping process, identify gaps between existing application and customer need
Designed and developed applications based on requirements. Create a variety of documentation include Requirement, Use Case, Logical and Physical model, and Test cases
Managed the development of applications using global resources
Ensured system and software architecture properly addressed availability, scalability, capacity, failover/backup/recovery components.
Key Accomplishments:
Identified and mitigated end-of-life issues for large call center application pg. 4
Modified Stock Administration application to allow for the dynamic identification and maintenance of Stock Award, reducing the award process from 3 months to hours
Participated in benchmarking initiative to improve Establishment mapping processes MILITARY EXPERIENCE
U.S. Air Force
EDUCATION
University of Phoenix, Southfield, MI
MBA, Business Administration, 12/2007
Project Management Certification, 02/2002
B.S., Business/Information Systems, 04/2001
TECHNICAL
SKILLS
Databases: Oracle 8x/7x, SQL Server, Sybase 2000/7.0, MS Access, Teradata Platforms: Windows, Linux, UNIX (Sun Solaris), VAX Languages: Visual Basic, VBA, VBScript, HTML, SQL, JavaScript, CGI-PM, Perl 5, Perl, UNIX scripting (Korn and C), VI Editor, ODBC Software: MS Office Suite, Outlook, MS Project, Internet Explorer, LoadRunner, WinRunner, Documentum, WordPerfect
Hardware: Dell PC, Compaq PC, IBM PC, Micron Laptop, Ring Methodologies: CMM, PMI, Six Sigma
Contact this candidate