Megan Bennett
Parkersburg,WV
Summary
I am an experienced financial systems analyst equipped to drive system improvements and optimize processes. I have a strong focus on collaboration and achieving results. Experience managing financial systems, data analysis, and implementing technology solutions. My experience in government security has assisted with user acceptance testing and knowing what the system can and cannot display based on government guidelines, PII and to ensure they are up to date with software requirements. I have a strong background in financial reporting and collecting, data entry, and audit reviews.
I have been working 100% remotely since 2020 and worked a hybrid schedule before that. I currently hold a security clearance.
We are currently in the process of relocating to Summerville, SC area.
Overview
21
21
years of professional experience
Work History
Senior Financial Systems Analyst
Bureau of the Fiscal Service
11.2023 - Current
- Currently serving as a senior subject matter expert for government applications TAAPS and Buybacks
- Performs internal system acceptance to deliver well-tested enhancements and meet business requirements
- Maintains documentation of all implemented changes within the financial system environment, simplifying future audits or reviews
- Supports contingency exercises multiple times a year to ensure applications can be recovered during a disaster or outage
- Provides team trainings of new processes of applications when needed
- Performs submission of auction financial settlement contingency queries in SQL
- Plays a key role in resolving complex technical issues related to the financial system by collaborating closely with developers and operations to determine resolution and timeline.
- Supports government Buyback operations and troubleshooting efforts
- Supports TAAPS operations and troubleshooting efforts
- Supports production auctions of bonds, notes, bills, and FRN’s that over billions of dollars
- Reviews, updates and provides feedback for Standard Operating Procedures
- Completes and researches departmental requests by due date
- Supports audit reviews and provides demonstrations to requesting department
- Leads User Acceptance Testing that is in an Agile fashion to ensure all business requirements are met for current code release
- Evaluate system performance regularly, recommending improvements based on findings
- Currently performs Buyback User Acceptance Testing in Salesforce system
- Tests contingency scenarios for Buybacks using Postman system
- Schedules meetings and obtains resources for User Acceptance Testing from all areas involved
- Leads the requirements development process
- Writes scripts and test cases to support new code requirements and leads the development of scripts and test cases with UAT team
- Works with developers, product owners, and operations to improve quality of the testing and makes suggestions to improve testing and deliverables
- Updates existing scripts and test cases as needed
- Tracks defects and communicates them to management, developers, and all stakeholders involved
- Sets up the testing environment before UAT testing begins to ensure version is updated, dates are rolled, and runs processing jobs
- Collaborates with upper management to drive strategy and implement new processes
- Leads and designs test plans before User Acceptance Testing starts and updates while testing is ongoing
- Communicates observations and applications concerns with Operations and Management to obtain feedback
- Creates tickets in JIRA when necessary and when issues arise
- Ensures all validations are completed and finished before due date
- Coordinates production deployments and performs validations to ensure code was deployed correctly
- Completes post release documentation activities
- Provides feedback of testers to their supervisors after User Acceptance Testing
- Responsible for running SQL queries while auctions are ongoing to ensure participants are not having log in issues and running queries for our documentation
Financial Systems Analyst
Bureau of the Fiscal Service
09.2019 - 11.2023
- Served as the government application IPAC and GINV subject matter expert
- Optimized financial system performance with regular maintenance and updates
- Wrote and updated test scripts and test plans for system requirements
- Executed system requirement scripts in the applications G-Invoicing and IPAC to ensure code and upgrades are functioning correctly and securely
- Executed scripts for debugging and negative testing
- Preparation work and creation of test plans before user acceptance testing begins
- User acceptance testing of new functionality and regression testing of applications
- Worked closely with Federal Reserve Bank for system requirement changes before and during User Acceptance testing
- Documented and presented defects found while testing and suggest possibility of changes to the Federal Reserve Bank, Product Owner, and Fiscal Accounting Management
- Attended sprint review, sprint planning, and PI planning for IPAC and G-Invoicing to better understand current issues and upcoming changes
- Assisted with sending out mass emails and updating Must See Message for application updates or outages
- Performed health checks for releases or security deployments after hours and relays when issues arise, or deployment is complete to management and product owners
- Reviewed and updated release notes and reference guides before they are updated in Production
- Assisted with IPAC billable status requests, approval of special requirements requests, and Agency Location Code (ALC) code requests
- Performed IPAC’s monthly measurements and statistics reports
Financial Systems Analyst
Bureau of the Fiscal Service
04.2018 - 09.2019
- Provided guidance and support in cybersecurity for Debt Information Management System (DIMS)
- Maintained and developed policies and procedures pertaining to IT Security Guidelines
- Facilitated Security Assessment and Authorization Reviews
- Worked with multiple departments to obtain appropriate evidence for security assessments, audits, and data calls
- Updated Fiscal Service Assessment and Authorization Tool to make sure it is in compliant with all security controls
- Prepared Risk Acceptances, POA&M’s, or Ongoing Maintenance for security control issues
- Reported to supervisor on progress for meeting deadlines and establish milestones for completion of assignments, projects, and tasks
- Reviewed and updated approved security contingency plans, disaster recovery exercise procedures, and incident response plans
- Worked with the appropriate departments when systems need de-commissioned
- Ensured assigned application users are recertified by the applicable deadlines
- Conducted briefings and meetings on information technology security related subjects tailored to variety of audiences
- Worked with other team members to confirm thoroughness, regulatory policy, compliance, and accuracy
- Facilitated cybersecurity activities to ensure confidentiality, integrity, and availability of systems to minimize the risk of unauthorized access, use, disruption, modification, or destruction
- Conveyed technical information to operational staff
- Entered POA&Ms, Risk Acceptances, and Ongoing Maintenance into the Aggregate Risk Disposition tracking system
- Entered all POA&Ms into Treasury FISMA Inventory Management System
- Created Security Impact Analysis form when new products, upgrades, or system modifications arise
- Created 7005 form when a removal of equipment or information is requested
- Coordinated walkthrough with outside auditors to ensure documentation requested was being reviewed in a safe manner
- Facilitated audit requested information to auditors during audit season
- Participated in cross-departmental meetings to ensure accurate reporting of financial metrics and system designs
Accounting Technician
Bureau of the Fiscal Service
01.2016 - 04.2018
- Provided step by step instructions to walk customers through creating various documents and transactions once the document is created
- Handled high call volume (30 plus calls daily) in a helpdesk setting with precise and quick resolutions
- Logged all customer interactions through HP Service Manager and escalated when needed to the appropriate department
- Troubleshooted various document issues that required technical skills as well as attention to detail
- Trained multiple technicians on financial systems PRISM and IPP
- Enabled and disabled accounting values in Oracle
- Setup new user access and provided roles and responsibilities in Oracle
- Experience with setting up security groups, business rules, approval routing, tables and accounting structures in financial systems
- Provided helpdesk training for the financial systems and provided current handouts and training material
- Participated in implementing customers by identifying their accounting needs and setting up the financial systems to meet their needs
- Produced reports and queries from various systems and databases
- Troubleshooted scenarios that had problems by testing or recreating the issue for proper resolution in support instances
- Maintained flexibility and professionalism when unexpected projects and duties arise
- Entered numbering mask for fiscal years
- Saved audit documentation for Oracle user access forms and AFF values
- Provided precise oral and written communication in a customer service environment and group settings
- Monitored interfaces between Oracle and PRISM transactions to ensure there were not any issues that needed to be reported and resolved
- Experience with the IPP system and determining invoice status and award documents that relate to accounts payable
- Assisted with the DHS- OIG conversion project team converting and analyzing documents into PRISM testing instance and PRISM production instance
Executive Assistant
Keystone Mountain Lakes Regional Council of Carpenters
02.2012 - 01.2016
- Experience with wage rate negotiations and employer and union local contracts daily
- Provided data for prevailing wage rates and submissions yearly
- Validated, analyzed, monitored, maintained and reviewed contracts and internal agreements
- Responsible for preparing meeting documents and pamphlets
- Assisted in the development of comprehensive material for reports, briefings and meetings of mid level management
- Independently researched complex accounting, collection, disbursement, and other financial issues
- Responsible for examining, analyzing, and interpreting accounting data, records, and reports
- Assisted in recommendations to committees about financial and company decisions
- Prepared letters to employees regarding changes in work environment
- Prepared letters to contractors regarding issues with reports
- Prepared correspondence to multiple entities regarding contract changes
- Conducted meeting times and destinations
- Experience with workloads and making sure work was completed efficiently
- Verified proper grammar, punctuation, and spelling for professional letters
- Prepared annual budgets and analyzed them
- Prepared, reviewed, monitored and analyzed reconciliations, monthly bookkeeping, overages and shortages, and bank statements for management
- Researched issues with posted or missing posted items to accounts receivable and accounts payable
- Responsible for audit preparation, participating on audits, reviews, and studies of financial statements and operations
- Reviewed routine, complex and unusual documents to verify accounting data, mathematical accuracy and to perform reconciliation of accounts
- Worked closely with other staff members in a team environment to accomplish office initiatives and support functions
- Submitted wage rates for appropriate contracts into database
- Savings/Vacation money payout to thousands of members that was from their employer as part of wages
- Prepared reports for attorneys to submit letters to either the members or employers
- Experience in preparing wage sheets and submitting them to employers
- Composed written correspondence to appeals employers sent regarding liquidated damages and interest and how the committees decided to address them
- Assisted employers with filling out monthly reports and submissions
- Responsible for entering members union dues payments into a national data base system
- Precise reconciling and analyzing daybooks for union dues payments on a weekly basis
- Made bank deposits of member’s monthly union dues payment on a weekly basis
- Monitored union dues payments, arranging, and preparing separate accounts for each union local
- Monitored, analyzed, and reviewed records of personnel to include all vacation, holidays, and sick days
- Ordered office supplies, forms, and verified the receipt of such
- Relayed messages interoffice and to mid-level management and union members
- Troubleshooted and resolved members issues primarily or refer to appropriate secondary intervention
- Managed executive calendars, scheduled meetings and appointments and coordinated travel arrangements
- Researched and arranged catering for lunch meetings
- Handled confidential and sensitive information with discretion and tact such as PII
Fringe Benefit Processor
Keystone Mountain Lakes Regional Council of Carpenters
07.2004 - 01.2016
- Experience with wage rate negotiations and employer and union local contracts
- Provided data for prevailing wage rates and submissions yearly
- Validated, analyzed, monitored, maintained and reviewed contracts and internal agreements
- Responsible for preparing meeting documents and pamphlets
- Assisted in the development of comprehensive material for reports, briefings and meetings of mid level management
- Independently researched complex accounting, collection, disbursement, and other financial issues
- Assisted in recommendations to board members about financial and company decisions
- Prepared letters to employees regarding changes in work environment
- Prepared letters to contractors regarding issues with reports
- Prepared correspondence to multiple entities regarding contract changes
- Verified proper grammar, punctuation, and spelling for professional letters
- Prepared and analyzed annual budgets
- Responsible for audit preparation, participating on audits, reviews, and studies of financial statements and operations
- Worked closely with other staff members in a team environment to accomplish office initiatives and support functions
- Daily basis performed data entry of fringe benefits and deductions into database Emerald Trac for all carpenter and millwright union members that worked in West Virginia
- Every month appropriately distributed money to 45 entities that was collected and entered into the Emerald Trac database
- Balanced month end collections and submitted ACH Bank Submissions to the appropriate 45 funds collected for
- Processed paid invoices through Emerald Trac database system
- Entered monthly payouts to the 45 funds collected into QuickBooks
- Submitted wage rates for appropriate contracts into database
- Savings/Vacation money payout to thousands of members that was collected from their employer as part of wages
- Prepared reports for attorneys to submit letters to either the members or employers
- Experience in preparing wage sheets and submitting them to employers
- Composed written correspondence to appeals employers sent regarding liquidated damages and interest and how the committees decided to address them
- Assisted employers with filling out monthly reports and submissions
- Entered members union dues payments into a national data base system
- Precise reconciling and analyzing records for union dues payments on a weekly basis
- Relayed messages interoffice and to mid-level management and union members
- Troubleshoot and resolved members issues primarily or refer to appropriate secondary intervention
- Made hotel reservations and provided directions for out of area employees and customers
Education
Associate Degree - Applied Science, Business Administration
West Virginia University of Parkersburg
Parkersburg12.2009
Skills
- Pays close attention to details and information
- Works efficiently in a team setting and individually
- Knowledge with Microsoft Word, Excel, and PowerPoint
- SQL and databases
- SharePoint, QuickBooks, Emerald Trac system
- Excellent keyboard and calculator skills
- Learns new skills quickly and prioritizes effectively
- Precise with attention to detail
- Self-Motivated
- Works well with deadlines
- Proficient in the understanding of accounting concepts and principles
- Experience creating folders and adding documentation into Teams
- Experience with Outlook, Teams, and Zoom
- Experience with Salesforce
- Experience with JIRA
- Financial statement analysis
- Financial systems implementation
Timeline
Senior Financial Systems Analyst
Bureau of the Fiscal Service
11.2023 - Current
Financial Systems Analyst
Bureau of the Fiscal Service
09.2019 - 11.2023
Financial Systems Analyst
Bureau of the Fiscal Service
04.2018 - 09.2019
Accounting Technician
Bureau of the Fiscal Service
01.2016 - 04.2018
Executive Assistant
Keystone Mountain Lakes Regional Council of Carpenters
02.2012 - 01.2016
Fringe Benefit Processor
Keystone Mountain Lakes Regional Council of Carpenters
07.2004 - 01.2016
Associate Degree - Applied Science, Business Administration
West Virginia University of Parkersburg
Similar Profiles
Kelsay ProffittKelsay Proffitt
Legal Instrument Examiner at Bureau of Fiscal ServiceLegal Instrument Examiner at Bureau of Fiscal Service
MADISON MCCUEMADISON MCCUE
Human Resources Assistant at Bureau of the Fiscal ServiceHuman Resources Assistant at Bureau of the Fiscal Service
Christopher MurnahanChristopher Murnahan
O365 Admin, Cyber Security, IT Project Management at Bureau Of The Fiscal ServiceO365 Admin, Cyber Security, IT Project Management at Bureau Of The Fiscal Service
Paige SamsPaige Sams
Cashier/Customer Service Representative at TJ Maxx, TJX CompaniesCashier/Customer Service Representative at TJ Maxx, TJX Companies
SHELIA GILBERTSHELIA GILBERT
Authorization Specialist at Parkersburg CardiologyAuthorization Specialist at Parkersburg Cardiology