Monica Henderson

Certified in Microsoft Word 2019, Microsoft Excel 2019, Microsoft PowerPoint 2019, Microsoft Access 2016, Microsoft Outlook 2019, Microsoft Teams 2019, SharePoint 2016, MS Project 2016; Visio 2016 Typing 70 - 75wpm. SharePoint – (Power Automate Workflows, Power Apps), Jira, Confluence, ERP System, Microsoft Power BI, Tableau Reporting, SAP Reporting. SAP Concur Travel and Expense, Business Objects 4.3, Adobe Acrobat(read/write) 6.0, CISCO Security Products, Clarity, Salesforce, QuickBooks Pro, Oracle System, Oracle General Ledger, PeopleSoft, Deep Blu Inventory System, Cognos, Impromptu 6.0, Business Management System, STAMP Budget Management System, Maximo, Plan View.

Excellent with operational/statistical and trending/forecasting reporting (analytical skills) through MS Excel creating pivot tables/charts, and macros, etc. Very organized, detail-oriented professional with excellent written and verbal communication skills (ability to communicate in a clear and concise manner), as well as problem solving skills. Proven ability to develop executive ready communications and presentations.

Proven ability to manage multiple and often competing priorities in a global and fast-paced environment. Multi-task person/self-starter that requires minimum supervision and has great prioritizing skills. A team player with excellent interpersonal skills that can effectively interface with all levels of Cross Functional Teams and Stakeholders to gather business requirements, etc.

Technical Business Analyst - LPL Financial/Cloud Office - Charlotte, NC

(2025-02 - 2026-04)

Supported the Advisor Digital Office Migration Project which involves data collation and analysis that informs migration wave scheduling. Supported the project team responsible for the migration of 50,000+ mailboxes from a single on premises Exchange organization to multiple distinct M365/EXO tenants.

• Collated and analyzed previously gathered data to help determine optimal migration candidates (Headcount) within waves in Excel performing functions such as VLOOKUP/IF Function/Pivot Tables, etc. to determine the Headcount for nightly scheduled users
• Utilized the SQL Left Outer Join to keep the End User Headcount correct and to ensure no End User is missing from the file
• Utilized SQL Query to uniform/format End User data – Remove spaces, etc.
• Monitored Migration User Team Channel/Microsoft Outlook for Incoming request for Users migration, questions and to give process directions
• Assisted Product Owner with documentation and process requirements utilizing Confluence
• Created, updated and maintained weekly status reports including burndown charts, identified risks, blockers and reported process issues needing attention and updated PowerPoint presentation for Leadership
• Utilized ServiceNow by entering in complex migration request also, monitor Migration User Team Channel/Microsoft Outlook for incoming requests for Users migration/questions and to give process directions, etc.
• Created CDE files for DBA Advisors in AZURE for Third Party Vendor to complete DBA migrations
• Assisted Product Owner with creating User Stories/Sprints/Epics as well as queries in Jira for Project tracking and to extract data. Creating Documentation to maintain Confluence pages for policy, procedure and communication purposes.
• Created dash boards/charts/graphs for project reporting and workflow/process flows in Visio, etc.
• Collaborated with operations teams to create, track, and maintain risk portfolio deliverables.
• Monitored and tracked continuous risks and control effectiveness through ad-hoc reporting.
• Generative AI – (Copilot) - Communications use to drafted emails, write reports and refined language for multilingual teams. Data Analysis to summarize large datasets, highlight key trends, and to perform analysis on specific data reporting, etc.

Business Analyst – Client Operations - FEMA - Charlotte, NC

(2024-09 - 2025-01)

Managing the daily administrative duties by governing the project meetings – distributing agendas, presentations/financials that are required for the meeting. Taking minutes and managing the action items for team members/stakeholders, etc. Scheduling break-out meetings to action items are being managed to move forward within the project direction.

• Assisted in Client Operation to visualize data and create data processes to solve problems. Process mapping in visual data tools. (Visio, PowerPoint, Power BI, Excel, etc.)
• Coordinated operational and strategic activities internally to improve customer experience and strengthen corporate processes across onboarding
• Handled a wide variety of complex and confidential situations and is responsible for confidential and time-sensitive material.
• Managed Third Party Vendors (Inspectors) Contracts – ensuring all communications with Vendors - policy and procedures are adhered to and communicated properly.
• Prepared budget materials, financial reports and statements for multiple projects, input data and financial transactions into various systems. Analyze data and ad hoc reporting / utilizing advanced MS Excel skills – vlookups, pivot tables, Power BI and various excel functions.

Infrastructure Risk Lead – EOL/Business Analyst - Bank of America - Charlotte, NC

(2022-03 - 2024-03)

Managed Infrastructure Risk (Cybersecurity Vulnerabilities) (VGC/VGL) - End of Life Technology vulnerabilities through the remediation process.

• Managed the Bi-Weekly Governance call and distributing minutes and updates per meeting.
• Ensure all vulnerabilities are covered in the ERP process by assisting/communicating/escalating all remediation plans/action steps, etc. with the Application Managers/Global Information Security/teams, etc.
• Managed all Application requests for new commitment dates to ensure in Compliance and Completed Quality Assurance for the remediation plans ensuring all mitigating controls are in place, policy etc.
• Conducted risk assessments to identify control gaps, evaluating operational risks, and implementing remediation plans
• Created Process mapping in Visio, PowerPoint, etc. working with the Developers and Design teams.
• Pulled Performance Overview data (Plans vs Actuals), etc. from Technology Infrastructure Operations
• Reporting and Analytics - Tableau and different programs to capture and track metrics and perform trend analysis. Produce pivot tables/pivot charts/graphs reporting, as well PowerPoint presentations to tell the story, etc. as requested from management.
• Collaborated with operations teams to create, track, and maintain risk portfolio deliverables.
• Assisted Product Owner to translate business needs into user stories, acceptance criteria, process flows, and solution requirements in JIRA
• Created user stories/sprints/epics and monitored/tracked in Kanban board to produce a roadmap and to track milestones for data analysis and reporting.
• Managed SharePoint site and Confluence – created the forms/design/lists/workflows/functionality and granted permissions to site, also migration.

Business Analyst - Wells Fargo - Charlotte, NC

(2020-10 - 2022-03)

Managed DLM Dept. initiatives/eCapabilities across the board - aligning, gathering all requirements to produce/create User Interphase SharePoint Sites.

• Managing DocuSign/Document Inventory/ADA (American Disability Act) SharePoint Sites
• Focusing on making environments and information perceivable, operable, understandable, and robust for everyone, benefiting individuals with disabilities
• Provisioned and terminated user accounts, managed distribution groups, and reset passwords in Active Directory
• Created Power Automate Form workflows from SharePoint lists for Project Analytics and Reporting
• Created automated workflows, building approval processes, and integrating data across apps like SharePoint, Teams, and using triggers, actions, and conditions
• Run the SQL Extraction Query to extract data from Excel file
• Utilized SQL Query to remove duplicate records/rows
• Leveraged Copilot to build flows through natural language prompts, notes
• Implemented content and development strategy in an online environment
• Power Query - connected to data sources, cleaning data, handling missing values, and shaping data for analysis.
• Pulled data/analyzing data from Power BI for comparison/trending/forecasting also utilizing Power queries in excel.
• Managed Site Admin duties: adding users, monitored/controlled levels of access permissions (AD, IAM, PAM, etc.) configuring site settings, managing content, troubleshooting issues, etc.
• Maintained collaboration portals and team tools.
• Provided testing support to UAT teams by acting as a bridge between business requirements and technical execution to ensure the software functions exactly as intended.

Business Analyst - Duke Energy - Charlotte, NC

(2018-01 - 2020-09)

Managed the daily (PIR) entry and reporting from Plan View, Such as Contractor Safety Stats/Injury types reporting; assigned and closed Corrective Actions/Apparent Cause Analysis/Root Cause Analysis; Enter Field Observations, Evaluations, and Investigations, etc. For Nuclear Energy, Vegetation and Construction.

• Maintained and tracked Contractors Head Count Reporting for Carolinas/Florida/Midwest; Contractor Alliance MRM KPI Reporting; Locates Reporting; Contractors Scorecards; Work Orders; Construction Ad Hoc Reporting, etc.
• Provisioned and deprovisioned over 200 new user accounts weekly using Active Directory (ADUC), assigning appropriate security groups, permissions.
• Audited Active Directory domains to remove over 500 obsolete users and computer accounts.
• Created Power Automate Form workflows from SharePoint lists for Project Analytics and Reporting

Charlotte-Mecklenburg Urban League Technical Training· Certification West Charlotte Senior High School· Diploma Gwinnett Technology College· Microsoft Office Certification Central Piedmont Community College· Notary Public