Business Systems Analyst
Resume:
Business/System Analyst
Summary:
Performed business systems investigation/feasibility studies/business case, evaluation and analysis of existing business systems and proposed systems, and accounting systems procedures, operations for various business clients, including computerized systems.
Expertise in creating BRD, technical design, functional, program specifications. Analytical and problem-solving skills, business rule definition, requirement traceability matrix, business process modeling, risk assessment analysis, business impact analysis, human-centered design, SQL, agile/scrum and project management.
Education:
B.S. Information Systems Management
M.S. Computer Science
Technical Skills / Tools:
Microsoft Project Visio Microsoft Word Excel HTML XML Java C# JavaScript Python DB2 Access Oracle SQL Server ETL Informatica Power BI Tableau Azure cloud/Databricks Notebook Jira ServiceNow SunGard EAS/ERP EDI EPIC X12 Edifecs SharePoint Confluence Github ALM Cypress MS PowerPoint UML BPMN 2.0 Balsamic SDLC SAFe Agile methodologies
Commendation Award:
Twice received Valedictorian commendation award from client for superior work performance in technical script documentation and data analysis.
Professional Experience:
CNA Corporation, Arlington, VA Jan 2023 – present 2024
Systems Engineer/Business Systems Analyst
Contractor to FEMA.
Involved in the analysis and design of FEMADex (FEMA Data Exchange) – a data analytics and reporting platform that replaces’ the Agency’s Enterprise Data Warehouse (EDW) with a modern cloud-based solution.
Elicitation of requirements from end-users for interface, created data mapping for data migration, and/or data cleanse activities. Extract, cleanse, transform, and scrutinize extensive and intricate datasets using Azure Databrick services and testing.
Supported Data Migration Planning and Data Management documentation relating to data governance, profiling, and testing.
Created user stories for the implementation of FEMADex features and capabilities. Sync with stakeholders to gather data migration requirements from the legacy EDW system to FEMADex.
Created MVP use case process model/mapping/diagrams using Visio Professional/BPMN notation for FEMADex application system.
Wrote multiple systems’ Interface Control Document (ICD) which specifies the interfaces between two applications using JDBC direct connection and RESTful API, including documentation.
Conducted research and analysis on cloud-based data migration and streaming tools such as Databricks, Stream sets, Azure Data Factory to incorporate them into FEMADex application system.
Provide functional support and assist with documenting requirements, detailed design specifications, data management, data conversion and transformation plans, business processes, and user stories based on requirements.
Platform: Jira, SQL Server, SQL, Oracle, Python, EDW Database, Databricks, Azure, SharePoint, Cypress, Power BI, Tableau, Safe Agile/Scrum
Blue Water Thinking LLC/Booz Allen Hamilton Inc., Washington, DC April 2020 – Dec 2022
Business System /Technical Consultant (Contractor)
Contractor to VA supporting HealthCare Data Migration process flow diagraming and documentation.
Performing data requirements analysis to support EDW legacy system data migration to DMLSS.
Performing data analysis of ETL pre-load and post-load to DMLSS
Support data migration using SQL queries to analyze data exception issues in compliance with Data Governance
Perform Data analysis of legacy system data for completeness, consistency, and accuracy in compliance with Data Governance using SQL query.
Analyze load data and validate non-compliance errors and create business rules to mitigate data errors.
Supporting Data Migration ETL SQL Server script technical writing task & documentation
Performing data analysis of data validation: pre-load and post-load to DMLSS Supply Chain application to determine success rate & provided root cause analysis.
Supported project transition of knowledge transfer to wind down.
Platform: Jira, SQL Server, CDWWORK Database, SharePoint, Power BI, Safe Agile/Scrum
Karsun Solutions LLC/ General Services Administration, Washington, DC April 2016 – Dec 2019
Consultant Business/Systems Analyst (Contractor)
Supported GSA OAM team/stakeholders on eOffer/eMod application system and multiple application systems development.
Worked on development of process workflow for eOffer/eMod application system.
Involved in the analysis & design of CR 1649 Change Request application system with stakeholders.
Wrote a business requirements document to provide an understanding of the features and functions of CR 1649 process automation (User stories, Workflow diagrams, UI wireframes, Functional requirements document (FRD)
Created process model using BPMN notation for product/services procurement.
Worked on creating the “AS-IS” and proposed C3-Closeout workflow diagrams for the process automation.
Worked on MMTI phase II business requirements and wrote Executive Business Case I & II (EBC I) to justify the need for enhancement and proposed new systems.
Working on FPT Products/Services enhancement template mapping and business requirements analysis and documentation (User stories, Workflow diagrams, UI wireframes, Functional requirements document (FRD)
Worked on documentation and creating FPDS-NG user manual for FAS User support desk Systems Administrator and OCMS user manual for the IT system support desk.
Commence on the compilation of Subk processes for proposed system enhancement.
Performed analysis and design of Email automation system, including creating the BRD and data mapping
Performed database consolidation and migration of legacy systems – data mapping.
Performed business/systems requirements analysis of Contract Acquisition Lifecycle Management System (CALMS) – developed Process maps, Traceability matrix, User Stories, and Acceptance Criteria
Platform: Jira, ECMS, FS19 Database, SharePoint, Balsamic, Safe Agile/Scrum
QSSI Inc., Columbia, MD 21044, and Winsor Mill, MD Dec 2013-Feb 2016
(CMS-Center for Medicare & Medicaid Services)
Sr. Business Systems Analyst (Lead)
Supported technical integration for the Affordable Care Act’s Federally Facilitated Marketplace (FFM) healthcare application system and Marketplace Lite (App 2.0) system development, testing and implementation for CMS.
Analyzed FFM business requirements and Use Cases to ensure the requirements across the Marketplace systems are in alignment.
Analyzed App 2.0 business requirements User stories and map those requirements to application development strategy.
Liaise with technical team and stakeholders to resolve conflicts in business requirements and technical issues for BRD documentation.
Wrote App 2.0 Business requirements documents (BRD) from consolidated user stories and created business process models (BPM), Use Cases (UML), workflow/process flow diagrams from requirements and technical documents.
Wrote SLS Business requirements documents (BRD) from consolidated user stories and created workflow/process flow diagrams from requirements and technical documents.
Worked with the technical team to create 834 enrollment transaction’s business requirements document (BRD), including data transaction validation, EFT, EDI processing and reporting.
Participated in deep-dive JAD sessions, testing, and implementation meetings, taking notes and distributing meeting minutes.
Created and consolidated App 2.0 Weekly Implementation Update reports on UAT, systems deployment and implementation for managements
Created App 2.0/FFM/HUB Integrations/Collaborations Diagrams for QSSI/CMS management.
Created App 2.0/FFM and Inbound 834/EFT/EDI processes’ Standard Operating Procedure (SOP) manuals for Help Desk and the XOC operators/Users.
Involved in the Medicaid & Chip Business Information Solution (MACBIS) – Healthcare Quality measures’ (AQM, CQM, HHQM, SPQM) reporting JAD and Grooming sessions.
Created business process models, worked with Appian application tool for record management and workflow processing for testing.
Platform: MySQL, Mark logic, Java, Jira, HP Quality Center, ALM, Balsamig, Visual Paradigm, Agile/Scrum
Kaiser Permanente, Silver Spring, MD Dec 2012-Nov 2013
Sr. Business Systems Analyst (Consultant contractor)
Support Business Users in KMATE - TMS (The Membership System) and MBE – (Medicare/Medicaid Business Engine) application systems error and resolutions.
Wrote system specifications for Medicare membership enrollment delivery process solution to CMS.
Wrote functional requirement specifications, requirements traceability matrix, Use Cases (UML), and performed logical solution design for implementation of VA Medicaid Eligibility/Enrollment management information systems engine.
Conduct requirements determination with business user onshore/offshore.
Conduct data research and analysis to resolve healthcare Medicare/Medicaid eligibility, enrollment, Part D and other billing issues.
Worked on business requirements for the implementation of the Medicare Prescription Drug, improvement, and modernization Act changes for “Medicare Advantage” and Part D coverage.
Resolved Kbridge interface and data issues between TMS and EPIC HealthConnect
Generate Quarterly Audit Reconciliation report for compliance department.
Extract, Transform and Load – data for business users to manipulate into reports.
Platform: SQL, Cobol, DB2, RS 6000 servers, X12, Cache, Mumps, Informatica PowerCenter, ETL, Kbridge, EPIC/HealthConnect
LifeCare Assurance Company, Woodland Hills, CA June 2005 - May 2012
Sr. Business/Systems Analyst
Project lead for the analysis and design of Life Care insurance claims processing and payment system, including California healthcare Medicare Part D and Medicare supplement. Wrote and created BRD, SRS, SDD, business rules table. Assisted in systems implementation, QA and UAT
supported 834/820/837 format changes, schema changes and some internal reporting, EDI 834/820/837 format set up, billing and claims processing.
Assisted in the analysis and design of a web portal “Quoting Facility Application”. Responsible systems requirement determination, writing systems requirement specifications, wireframes, and test plans.
Worked on billing subsystem problems. Investigate, analyze, and resolve issues with monthly premium billing. The system is supposed to carry forward premiums that are past due to the next billing cycle, send notices before payment due date and not lapse policies. Create BRD and write specifications (SRS) for system changes.
Performed fact-finding, data gathering and wrote Systems Requirements Specifications for various projects, ex - Data Feed design, extraction & Data Warehouse Implementation.
Involved in projects enhancing the PDA system to improve data reconciliation to supporting daily/monthly/ad hoc reports for Marketing, POS, Claims, Compliance, Accounting, and client companies. Conducted JAD sessions to elicit requirements.
Created physical and logical models of existing and new systems with Data Flow Diagrams.
Created processes & data models (ERD), built data dictionary, Use Case, Class & Interactions Diagrams
Performed system design and wrote program specifications.
Involved in Data Feed design, extraction & Data Warehouse implementation.
Participated in projects enhancing the PDA system to improve data reconciliation to supporting daily/monthly/ad hoc reports for Marketing, POS, Claims, Compliance, Accounting, and client companies.
Performed gap analysis, data mapping & conversion for implementation of the SunGard ERP/EAS accounting system. Created an Excel spreadsheet containing data elements of old GL data and new GL data. Identify obsolete, valid, blank data elements and data to be migrated. Wrote specifications for interface data migration/integration.
Engaged in Business Continuity and Disaster Recovery planning analysis. Conducted Business Impact Analysis and produced report. Develop DR Test Scripts. Implement DR tests.
Perform Risk Assessment and recommended improvements at various IT security levels.
Develop project management lifecycle and system development lifecycle standards by designing templates, including Object-Oriented Analysis for LifeCare Assurance Company
Create SQL programs to extract and create data feed files that are FTP to third party clients for data warehousing and mining.
Generate ad-hoc reports for Users using SQL, AS/400 queries, and Crystal Report on database files.
Generate and extract data using SQL queries for data analysis.
In all cases, used either/both simple and complex queries/SQL.
Used Visio to create artifacts: BPM, DFD, ERD, HLD, UML diagrams, Workflow diagrams.
Perform requirements elicitation through interviews, surveys, questionnaires, system studies, site observation, use cases, process modeling, business analysis, workflow analysis, document analysis, and data analysis. Mentor junior Business Systems.
Platform: SQL, DB2, AS400/i5/OS v5R3, IBM/HP Servers, 2003 Server, EZView, RPG IV, Cobol, SQL/400, JAVA, C#, HTML, IBM-WCM, Crystal Report
Contact this candidate