Systems Analyst Business

JANET L. COHEN

Henrico, VA *****

SENIOR BUSINESS SYSTEMS ANALYST

GENERAL SUMMARY

Technical career includes 15+ years as a dedicated and leading senior-level analyst for Fortune 500 companies, State government, and public utilities. Delivers focused results using comprehensive analytical and organizational abilities, demonstrates a strong ability to interpret complex business challenges and perform data analysis. Excellent communication skills used to collaborate with all project resources ensuring successful goal and deadline completion. Provides strategic business solutions to enterprise-wide technology initiatives.

AREAS OF EXPERTISE

Software Development Lifecycle (SDLC)

Agile/Scrum/Kanban

Requirements Elicitation

Team Leadership

Root Cause Analysis

Project Planning & Level of Effort Estimates

Data Queries and Analysis

Communication

Resource Management

Process Flow Diagrams

Problem Resolution

User Interface Design

TECHNICAL SKILLS SUMMARY

MS Office Products: Visio, SharePoint 2010, MS Office 2016/Office 365, Windows 10, SQL 2012, Team Foundation Server (TFS), SnipIt

Google Suite (Workspace) Gmail, Calendar, Chat, Drive

Programming Languages: UNIX, SQL, R, .Net, ASP

Software Tools/Applications: SAP, TRS (Trouble Reporting System), SnagIt, SailPoint (IAM), HP Quality Center (ALM), PeopleSoft, Meter Data Management (MDM), PowerTrack, SIMS Work Orders system, Azure DevOps, JIRA, ServiceNow, Oracle eBusiness Suite

Database Query Tools: SQL Developer, Toad, PL/SQL Developer, R Studio

Audio-Conferencing Tools: MS Teams, WebEx, Internal bridge lines

Technology Operations: Distributed systems, middleware, databases,

network, and mainframe services (Unisys/IBM)

EDUCATION / CERTIFICATION

MSIS, Information Technology Management

Virginia Commonwealth University, Richmond, Virginia

BS, Business Computing

Webber International University, Babson Park, Florida

Certified Data Science Professional

Collabera Technologies Private Ltd.

PROFESSIONAL EXPERIENCE

Sr. Business Systems Analyst August 2023 – March 2025

Virginia Department of Transportation, Richmond VA

Serving as Sr. Business Systems Analyst on Agile team:

oUndergoing major rewrite of legacy systems that track and manage all work done by the agency to maintain roads and bridges, local roads, state-wide highways, etc.

oWriting user stories for requirements and test cases, executing test cases related to the original stories.

Serving as Sr. Business Systems Analyst on Production Support (incident response) Kanban team:

oSharing responsibility of managing incident response tickets that come into the board.

Project work:

oCreating user stories, acceptance criteria for various items

oCreating test strategy docs, metadata docs

oDeveloping test plans, suites, and cases for testing

oCreating defects and managing through to successful completion

oPartcipating in Lessons Learned exercises with team at end of each sprint and Program Increment (PI)

Sr. Business Systems Analyst January 2023 – July 2023

Dominion Energy, Richmond VA

Serving as Sr. Business Systems Analyst on the Outage Distribution team:

All projects:

oPerformed standard BSA functions on both capital and O&M projects such as documenting business/functional requirements, creating/executing test plans, and collaborating with business stakeholders throughout projects to keep them informed and obtain their buy-ins on system activities.

oLast supported 5 different applications for all tasks regarding the CORE project (conversion to SAP)

oUsed SAP to create and manage outage work orders.

oWrote technical specifications for developers.

oCreated process flows (using Visio) as needed to drive discussions and provide clarity.

oTracked and managed department defects using Quality Center/ALM

oEngaged with developers and business stakeholders to provide support needed for QA testing.

oCollaborated with technical resources to remediate Production problems as needed and present possible solutions to business stakeholders.

oWorked with JIRA to manage project tasks and requirements, ServiceNow for new module designed for external Internet Service Providers (ISPs)

Sr. Business Systems Analyst March 2020 – December 2022

Dominion Energy, Richmond VA

Serving as Sr. Business Systems Analyst on the IT Metering team:

All projects:

oPerformed standard BSA functions on both capital and O&M projects such as documenting business/functional requirements, creating/executing test plans, and collaborating with business stakeholders throughout projects to keep them informed and obtain their buy-ins on system activities.

oCreated Requirements Traceability Matrix to manage requirements.

oLast supported 3 different applications for requirements, etc. regarding the CORE project (conversion to SAP)

oUsed SAP to create and manage meter service orders.

oWrote technical specifications for developers.

oCreated process flows (using Visio) as needed to drive discussions and provide clarity.

oTracked and managed department defects using Quality Center/ALM

oEngaged with developers and business stakeholders to provide support needed for QA testing.

oCollaborated with technical resources to remediate Production problems as needed and present possible solutions to business stakeholders.

oWorked with Azure DevOps to manage project tasks and requirements.

Sr. Business Analyst March 2019 – March 2020

Virginia Housing Development Authority, Richmond VA

Served as Sr. Business Analyst under PMO on various projects:

All projects:

oPerformed standard BA functions such as keeping and distributing meeting minutes, documenting business requirements, and collaborating with test team on system testing.

oCreated process flows (using Visio) as needed to drive discussions and provide clarity.

oUsed Kanban to document and track projects and their associated tasks.

oPerformed Project Manager duties during resource gaps.

Information Security Office (ISO): Remediated audit findings regarding digital assets at rest (policies, standards, and guidelines) through a series of projects designed to limit electronic risks:

oCollaborated with PM and technical staff on research and feasibility studies to address gaps in IT risk policies as they relate to databases and file shares.

oPartnered with technical resources to understand data flows and created/updated physical and logical network diagrams using Visio.

Customer-facing web site redesign:

oPartnered with PM to maintain project momentum after earlier loss of project management resources.

oFacilitated meetings with three vendors, multiple business partners, and various IT resources to record and distribute meeting minutes as needed, coordinated communications between all parties, and provided all support functions such as on-site vendor visits.

oElicited functional requirements and oversaw approvals in a timely manner.

Sr. IAM Business Systems Analyst September 2017 – February 2019

Virginia Department of Taxation, Richmond VA

Served as Business Analyst for enhancement and maintenance of an access provisioning application (SailPoint). Work followed Agile/Scrum methodology.

Used Gmail and Calendar

Drafted user documentation to improve ease and use of systems.

Ran intelligence reports to analyze data and facilitate strategic decisions.

Created process flows using Visio to document system designs and influence improvements.

Provided back-up for system admin and monitored user-support email mailbox to address production issues and user inquiries.

Collaborated with team (manager, two developers, and system admin) to determine problem solutions and system enhancements to address audit findings.

Identified problem areas and generated creative solutions to eliminate them.

Provided expert-level analysis of system data, running system reports, analyzing data using advanced Excel functions and Pivot Tables, discovering inconsistencies, reconciling discrepancies, preparing files for entitlement imports and batch requests.

Developed full understanding of workflows to fulfill access requests and complete annual certification for troubleshooting purposes.

Wrote and executed SQL queries to analyze application data and drive discussions.

Business Systems Analyst June 2017 – August 2017

Wells Fargo, Richmond VA

Worked with Brokerage Technology group to support conversion from IBM MQ to IBM Business Process Manager with focus on Retail ACH transactions. Project followed Agile methodology.

Served on technical analysis team to review ‘as is’ system process flows (IBM Process Designer) and begin discussions about ‘to be’ models.

Created high-level stories from current system analysis discussions.

Business Systems Analyst January 2017 – May 2017

Federal Reserve Bank of Richmond, Richmond VA

Worked with Business Continuity (BC) team to convert current Business Continuity Management (BCM) application, which serves 12 US Districts, to a more scalable and supported application. As an interim solution, a SharePoint site-based process was created that required site builds for 140+ departments, conversion of all current documentation from separate chapters to one single PDF document and completed move of final conversions to SharePoint sites. They were eventually imported to the final third-party solution. Project followed an iterative, multi-wave methodology.

Served as Technical Control Analyst for three Districts to make all changes needed.

Created FAQ, process flows for technical resources, reference documents, and other support documents as needed for all 12 District BC teams.

Business Analyst September 2016 – October 2016

Virginia Supreme Courts, Richmond VA

Served as Business Analyst and QA Tester for various projects under the Office of the Executive Secretary (OES).

Performed interviews with HR and Building Security to determine current and future processes around badging and parking assignments for newly hired employees of all types (State, non-State [contractors], Magistrates, and other special courts employees). Final process eliminated redundancy and clarified process for all parties including hiring managers.

Created process flows using Visio and accompanying documentation for new processes.

Sr. IAM Business Systems Analyst February 2016 – September 2016

Virginia Department of Taxation, Richmond VA

Served as Business Analyst, PM, Project Coordinator, Test Lead, & Training Collaborator for a remediation project focused on an audit finding related to a security access provisioning application. Focus was on operational risk management and compliance support within enterprise technology functional area. Project followed Agile/Scrum methodology.

Used Gmail and Calendar

Served as organization’s Point of Contact (POC) for replacement of legacy application request system with a Commercial Off-The-Shelf (COTS) solution (SailPoint). This required constant communication with project sponsors, IT managers at all levels, and third-party vendor PM and developers as well as the ability to develop and manage business relationships.

Participated in daily scrum meetings to discuss daily status, problem areas, escalation of issues, and determine high-impact user stories.

Worked with Business Owners, Business Analysts, and Technology Teams to analyze and design Access Identity solutions.

Acted as a liaison between the business area and technical resources by planning, conducting, and directing the analysis of the legacy, in-house built access-identity application and a newer, more robust system.

Prioritized work, met deadlines, achieved goals, and worked under pressure in a dynamic and complex environment.

Provided technical assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements.

Hosted all required meetings (WebEx and internal, face-to-face) for the organization to collaborate on changes needed for the new system, reconciliation with the old system.

Facilitated meetings with participants at various levels of experience from different functional areas to assess needs, oversee testing, and ensure satisfaction with final outcome.

Worked with 60 Business Owners of security groups for one application to reorganize groups and certify assigned users.

Collaborated with HR team to identify processes for on-boarding, off-boarding, and maintenance of staff records, utilized Visio to show process flow of tickets and owners at each step.

Prepared specifications for system changes. Gathered business and functional requirements to support implementation of new provisioning application.

Wrote and executed SQL queries to analyze application data and drive discussions.

Participated in transforming strategic enterprise architecture and design principles into specific system requirements and specifications.

Determined the actual inventory of all applications & databases to be onboarded in the new system and those that may have needed to remain in the current system.

Recommended and initiated systems testing. Coordinated data maintenance with technical resources, ran queries to validate current data and results from testing.

Identified key system impacts, ensured all coding was made accurately, and collaborated on testing execution to validate final results.

Facilitated QA and Users Acceptance Testing (UAT) by serving as POC, provided system understanding support as needed.

Partnered with training resources to serve as POC, provided system understanding and documentation as needed.

Provided direction and guidance to less experienced staff.

Developed full understanding of workflows to fulfill access requests and complete annual certification for troubleshooting purposes.

Business Systems Analyst October 2014 – February 2016

Allianz Global Assistance, Richmond VA

Served as Business Systems Analyst for a profitable medium-sized company in the travel insurance industry. Supported corporate technology projects of various sizes, following SDLC methodologies.

Gathered business, functional/non-functional, and technical requirements for COTS ERP application (PeopleSoft), SAP Financials, and other applications to support new partnership with an external company and call center, crossing multiple work streams.

Acted as a liaison between the business area and technical resources by planning, conducting, and directing the analysis of various insurance products.

Created process models with Visio and screen mock-ups as needed (using SnagIt)

Worked with technical and QA resources to clarify requirements, demonstrate how to use system functionality, and review test scripts through all phases of testing.

Used PeopleSoft tools to create SQL queries for data analysis.

Technical Business Analyst September 2013 – May 2014

Wells Fargo, Richmond VA

Technical Business Analyst January 2012 – September 2013

Virginia Department of Social Services, Richmond VA

Served as Technical BA in support of multiple Software Development Life Cycle (SDLC) projects relating to Human Resources (COTS ERP application [Oracle e-Business Suite, HR module]) and tax credit programs (Access/VB software/Oracle Apex software)

Gathered business, functional/non-functional, and technical requirements; use software tool (ReqPro) to manage and document requirements.

Served as Lead BA to train and guide the use of defect and requirements tools.

Acted as a liaison between the business area and technical resources by planning, conducting, and directing the analysis of an existing client-server application to accommodate changes needed to align with business decisions.

Acted as an internal consultant within technology and business groups by using quality tools (Visio) and process definition/improvement to re-engineer technical processes for greater efficiencies.

Served as owner of team SharePoint web site which included design and content as well as buy-in from team on final results.

Executed risk practices such as: risk identification within IT environment, risk evaluation, risk treatment, risk consulting, and controls assessment for one project.

Provided policy risk oversight, project risk oversight, change risk oversight, audit response, and compliance management for one project.

Wrote and executed SQL queries to analyze data, drive requirements discussions, and verify test results.

Technical Business Analyst April 2011 – June 2011

nTelos, Waynesboro, VA

Technical Business Analyst, AVP (Assistant VP) Level September 2009 – March 2011

JP Morgan Chase, Tampa, FL

Created Requirements Traceability Matrix to manage requirements.

Business Systems Analyst March 2005 - October 2008

Capital One, Richmond, VA

Business Systems Analyst (mainframe) March 2000 – February 2004

Florida Department of Revenue, Tallahassee, FL

Worked on SAP team for conversion of legacy systems by learning to use SAP and create data files from legacy systems and uploaded to SAP for future use.

Worked with Web team to provide in-depth analysis of newly-acquired electronic form design software and created technical specifications for future form designs. Created and designed over 50 forms using GUI objects and VBA scripts to set and manipulate related events and properties.

Wrote embedded SQL statements within COBOL code and select queries for data research.

Contact this candidate