Remote Virtual Assistant - IT & Analytics Expert
Resume:
KAREN MONGAN
*************@*****.***
Retired Agile Information Technology Expert with experience in healthcare (VA Office of Research and Development - Clinical Trial Databases, Maryland Hospital Association – Performance Measures and Electronic Health Records (EHR), government (SSA- Benefits and Disability), banking (MBNA), and private industries. Achievements in programming, SQL development, relational and dimensional modeling, data analysis and business requirements elicitation.
EDUCATION
Towson University
Bachelors in computer science
CERTIFICATIONS
Certified Professional Scrum Master (PSM) Scrum Alliance
Certified Pega 8.5 Systems Architect
Certified SAS Base Programmer
WORK EXPERIENCE
Khols Department Store
50 Osborne Pkwy
Forest Hill, MD 21050
Retail Sales Associate
05/2025–Current
Actively maintained a positive attitude and extensive knowledge of product offerings to direct customers to the merchandise they were seeking. Maintained credit card quotas and engaged customers in a polite and professional manner. Cross functional and always willing to lend a hand and go above and beyond to benefit the store and the maintain the customer’s positive experience.
Peraton/ NorthropGrumman
2810 Lord Baltimore Blvd.
Winsor Mill Blvd, MD 21244
01/2015 – 10/2022
Senior Business Analyst - Remote
03/2021–10/2022
Part of an agile team supporting the automation of SSA benefits notices and other SSA communications. Modified Business Process Workflow maps as required and identified during SCRUM sessions. Hosted weekly backlog grooming and stand-up sessions and created and completed user stories and documented the Key Performance Indicators (KPI) for each story. Primary accomplishment was developing the Jira that enabled the successful transfer of responsibility for notice automation to the notice owners and enabled the team to better spend their time on infrastructure, security, and process improvements.
Senior Business Analyst - Remote
03/2020-03/2021
Part of an agile team supporting the Information Technology Modernization for T2 benefits. Created and captured requirements and KPIs for the conversion of mainframe system functions to a web-based system and modified Business Process Workflow maps as required and identified during SCRUM sessions. Elicited and documented system, database, and user requirements for the new system. Primary accomplishment was the successful completion of the T2 Web conversion.
Business Analyst
01/2019-03/2020
Part of an Agile team supporting the SSA Enterprise Data Exchange (EDEN) team’s move to a Pega project. Elicited user requirements and developed and tested Behavior Data Driven (BDD) APIs using Cucumber and developed and documented the KPIs. Assisted in the creation and population of the EDEN Database using DB Visualizer. Developed and executed SQL queries to verify the proper execution of the APIs. Modified Business Process Workflow maps as required and identified during SCRUM sessions. Primary accomplishment was the successful execution of the first set of APIs and verification through SQL database queries. While waiting to join the EDEN project, compiled the monthly Management Information Reports and identified and reported errors.
Data Modeler
03/2018 -12-2018
Part of an agile team supporting the Information Technology Modernization team database conversion. Assisted the team by reverse engineering databases and creating Erwin models to represent logical data subject areas. Combined tables to represent a single source of data, which resided in multiple legacy systems. Also, assisted with the cleaning and publishing the SSA Data Models to the Erwin Data Portal. Primary accomplishment was the completion of the first IT MOD combined Title 2 Data Model.
Business Analyst
01/2015 – 03-2018
Supported the Title 2 (T2) Treasury File Update by mapping existing Treasury Payment Files to Treasury’s new XML format. Queried and developed Mainframe Datasets and used FTP and Statistical Analysis Software (SAS) to retrieve and analyze the payment data files to prepare data to send to Treasury. Sent the file to Treasury and created and executed test cases in HP Application Lifecyle Management system (ALM). Developed Business Process Workflow to support the new process. Primary accomplishment was the successful send and receipt of the Treasury file in the new format.
Amaram/Leidos
7152 Lord Baltimore Blvd.
Winsor Mill Blvd, MD 21244
Business Analyst
08/2014–01/2015
Elicited requirements for the Disability Collection Program System (DCPS) application. Developed the Business Process Workflow Model using Visio and identified GAPS and differences in the business processes for Disability Case Processing between states while working on the Disability Case Processing System (DCPS) project for SSA.
Primary accomplishment was developing a standardized report template for all states.
Maryland Mayor’s Office
100 N. Holliday St.
Baltimore, MD 21202
Data Analyst/SQL programmer
09/2013 – 02/ 2014
Developed SQL queries to extract data for setup into the Client Track application. Customized and modified the code within the Client Track application.
Developed business requirements for necessary modifications. Scheduled and taught end-users on the Client Track application. Primary accomplishment developing data model for data extraction from the existing Excel database.
Baltimore Research and Development Foundation
59 Avenue
Perry Point, MD 21902
Data Analyst/Research Specialist
12/2013 – 08/2014
Cleansed data for GEMS 1a project. Analyzed external customer needs, coordinated, and/or modified detailed functional requirements in terms of existing and projected interface capabilities. Made Application Programming Interface modifications as required by the customer to enhance existing API functionality.
The Highland School
2409 Creswell Rd.
Bel Air, MD 21015
Teaching Assistant
09/2012 – 05/2013
Provided educational and instructional assistance to children with learning differences such as ADHD, non-verbal learning disorders and dyslexia.
Maryland Hospital Association
6820 Deerpath Rd.
Elkridge, MD 21075
Business Analyst/ Data Analyst and SQL Developer
12/2007 – 09/2009
Developed and ran SQL daily on the multi-dimensional cubes after nightly rebuilds. Conducted effective requirements reviews to improve quality of the deliverables and developed associated business requirements, meeting agendas and meeting minutes documents. Defined testing objectives to verify that the end-users’ and project stakeholders’ requirements are met and surpassed. Provided programming, training and data solutions for end-user concerns with DataSphere, the Performance Measure Software which ran checks against the ICD 9 Codes
Collaborated on the in-process relational data warehouse development and mapped data for entry into the in-process relational data warehouse.
Veterans Assistance Office of Research and Development
10 North Greene Street
Baltimore, MD 21201-1524
Business Analyst/ Data Modeler
01/2006 -10/2007
Using Erwin, consolidated data from 4 experimentation databases for use in joining with the Maryland Health Department Database.
SKILLS
Agility (Previously Version One)
Business Requirements development and analysis
Jira
SQL, SAS, Oracle
Multi-Dimensional and Relational DB Modeling
Tableau and other Reporting and Analytic Tools
MS Forms, MS PowerPoint, MS Excel, Sharepoint and Confluence
Programming (Pega, Cucumber, ADA, Paradox, SQLBASE, APL
Contact this candidate