Rachel Lock
Zebulon,NC
Summary
Seasoned Business Analyst offering 10 years of success in problem solving, improving processes, and exceeding requirements in team environments. Strong communicator accomplished at leveraging past lessons to inform future decision-making.
Overview
12
12
years of professional experience
Skills
- Microsoft Office Suite
- PowerBI
- IBM COGNOS Report Studio
- SQL, HTML, CSS, Python
- Web-Based Reporting Tools
- JIRA/Rally
- Agile/SCRUM
- CyberArk
- Business & Technology Liaison
- Project / Product Management
- Stakeholder Requirements Elicitation
- Workflow / Current State Analysis
- Business Process Optimization
- Process Documentation
- Strategic Planning
- Business Process Mapping
Accomplishments
- Recognized in the FM Global's Globalink magazine for a 50,000% efficiency gain in developing business plan reports.
- Increased report utilization by 75% by conducting a deep-dive analysis into loan and investment data and upgrading reports for internal stakeholders and investors.
- Led the consolidation and standardization of over 150 process documents, showcasing expertise in process optimization.
- Increased team productivity by 200% by creating an Excel workbook tool for the team of stakeholders to track and visualize a summary of a complex workflow to measure our KRAs at-a-glance.
- Successfully streamlined over 30 processes , resulting in a 15% increase in overall productivity.
- Identified and implemented a process improvement for service notifications, resulting in a 500% efficiency gain .
Affiliations
Director of Zebulon Downtown Development Association (NC Main Street & Rural Planning Center)
Work History
Senior Operations Analyst
Arch Mortgage Insurance
08.2022 - 04.2023
- Served as a Business and Technology Liaison between business stakeholders and IT and identified communication pain points and gaps in process documentation
- Increased report utilization by 75% by conducting a deep-dive analysis into loan and investment data and upgrading reports for internal stakeholders and investors
- Created and implemented an action plan for documentation consolidation and standardization of over 150 process documents
- Eliminated process duplication by consolidating mailbox intake processes of 15 mailboxes.
Cybersecurity Analyst
Truist Bank
05.2020 - 08.2022
- On the IAM / PAM team: tracked, analyzed, then streamlined process workflows for our team, resulting in the remediation of 1,500 servers and 45,000 instances of service and human accounts for MRA guideline adherence
- Increased team productivity by 200% by creating an Excel workbook tool for the team of stakeholders to track and visualize a summary of a complex workflow to measure our KRAs at-a-glance
- Created detailed process documentation for the workflows I streamlined
- Contacted server/application owners to review and approve access for over 1,500 servers
- Collaborated with account and application owners to vault and onboard over 45,000 instances of service accounts and human accounts in CyberArk; either domain, local server accounts, databases, or applications within 2 week turnaround deadlines in order to meet MRA federal regulatory guidelines
- Extracted and analyzed data from Active Directory and PRIVA to identify accounts/users with over-privileged access on Primary Accounts for Secondary Account creation and bulk onboarding into Centrify/CyberArk
- Tracked remediation efforts through Rally Agile platform and Agile-based team collaboration.
Senior Data and Business Analyst (Contract)
MetLife
04.2019 - 02.2020
- Collaborated with team leads to create documentation and deliver project management tools to meet IT requirements
- Identified and implemented a process improvement for service notifications resulting in a 500% efficiency gain
- Gathered and translated high-level business requirements into functional metrics
- Served as alternate ScrumMaster on teams
- Collaborated across diverse teams in assisting with solution documentation and project management tools to meet IT requirements
- Identified, tracked, and analyzed key metrics that impact projects using multiple tools and systems
- Developed and documented business processes for application analysis training materials.
IBM COGNOS Developer (Contract)
MetLife
04.2019 - 02.2020
- Developed over 10 ad-hoc reports and 15 Report Templates for Project and Approval Tracking for stakeholders
- Developed a dashboard Project Fitness Audit report for managers to identify and mitigate requirements deficiencies in PM processes and data entry
- Identified and streamlined over 30 processes that had a company-wide impact and increased productivity by 15%
- Collaborated with stakeholders to understand business needs and translate to technical reporting requirements
- Analyzed and interpreted data sources in warehouse for consolidation into reporting outputs.
Manager/Process Development
Boulevard West
02.2018 - 02.2019
- Managed all aspects of kitchen operations including recipe creation and implementation, food production, and training
- Developed Raw Materials Cost Analysis for all products
- Maintained inventory and ordering
- Documented workflows and recipe instructions.
Senior Business Analyst / IBM COGNOS Developer
FM Global - Reston, VA
12.2010 - 07.2015
- Received company-wide recognition for developing business plan reports for managers, creating a 50,000% efficiency gain for all operations
- I was featured in the company Globalink magazine
- Developed 20+ managerial reports resulting in a 50,000% efficiency gain
- Project Manager for construction plan review department
- Elicited business and technical requirements from stakeholders
- Documented requirements, use cases, process flow charts, and procedures
- Provided department training on systems and process updates
- Reviewed all client-facing documentation for brand recognition and adherence.
Education
Associate of Applied Science - Culinary Arts
Wake Tech Community College
Raleigh, NC01.2006
Some College (No Degree) - Communications
University of North Carolina At Wilmington
Wilmington, NCTimeline
Senior Operations Analyst
Arch Mortgage Insurance
08.2022 - 04.2023
Cybersecurity Analyst
Truist Bank
05.2020 - 08.2022
IBM COGNOS Developer (Contract)
MetLife
04.2019 - 02.2020
Senior Data and Business Analyst (Contract)
MetLife
04.2019 - 02.2020
Manager/Process Development
Boulevard West
02.2018 - 02.2019
Senior Business Analyst / IBM COGNOS Developer
FM Global - Reston, VA
12.2010 - 07.2015
Associate of Applied Science - Culinary Arts
Wake Tech Community College
Some College (No Degree) - Communications
University of North Carolina At Wilmington
Similar Profiles
Nathan AlwoodNathan Alwood
Insurance Broker at Arch Benefits Insurance GroupInsurance Broker at Arch Benefits Insurance Group
Will BakerWill Baker
National Trading Team Underwriter at Arch Insurance, UK RegionalNational Trading Team Underwriter at Arch Insurance, UK Regional
Ayushi BhardwajAyushi Bhardwaj
Business Analyst at Arch InsuranceBusiness Analyst at Arch Insurance
Justin JohnsonJustin Johnson
Construction Superintendent at R.L.Pullen & Associates, Inc.Construction Superintendent at R.L.Pullen & Associates, Inc.
Christina E. MummChristina E. Mumm
Senior Program Manager at General Dynamics Information Technologies (GDIT)Senior Program Manager at General Dynamics Information Technologies (GDIT)