Business/Systems 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 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, Pratt Institute Brooklyn, New York

M.S. Computer Science, Pratt Institute Brooklyn, New York

TECHNICAL SKILLS / TOOLs: Microsoft Project, Visio, Microsoft Word, Excel, Cobol, RPG IV, HTML, XML, Java, JavaScript, Python, DB2, ISPF/QMF, IBM WCM, Access, Microsoft SQL Server Management Studio, Oracle 8, Easytrieve, Crystal report, OS400, SQL Server, Unix, shell scripting, AIX, VSAM, File-aid, Calligo, Daptiv, Abendaid, Endeavor, JCL, CL, IBM Cognos BI, Crystal Report, Informatica PowerCenter, ETL, Power BI, Tableau, Azure/Databricks, Expediter, Jira, ServiceNow, VersionOne, SunGard EAS, EDI, EPIC, X12, Edifecs, Changeman, Turnover, HP quality center, Remedy, SharePoint, Confluence, Github, ALM, MS PowerPoint, UML, BPMN 2.0, Visual Paradigm, Balsamic, Designer 4.0, IBM iServers, OS/390, z/390, RS/6000, IBM 3033, AS/400, SOA, SDLC, SAFe Agile methodologies

Commendation Award:

Twice received Valordictorian commendation award from client for superior work performance in technical script documentation and data analysis.

WORK EXPERIENCE:

1/2023 – present CNA Corporation, Arlington, VA

Business Systems Analyst /Technical Consultant

Contractor to FEMA.

Involve 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, data migration, and/or data cleanse activities. Extract, cleanse, transform, and scrutinize extensive and intricate datasets using Azure Databrick services and testing.

Supporting 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 usecase process model/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.

Conducted analysis on cloud-based data migration and streaming tools such as Databricks, Streamsets, Azure Data Factory to incorporate them into FEMADex application system.

Provide functional support and assist with documenting requirements, detailed design specifications, data conversion and transformation plans, business processes, and user stories based on requirements.

Platform: Jira, SQL Server, Oracle, Python, EDW Database, Databricks, Azure, SharePoint, Power BI, Tableau, Safe Agile/Scrum

2/2020 – 12/2022 Blue Water Thinking LLC/Booz Allen Hamilton Inc., Washington, DC

Business System /Technical Consultant (Contractor)

Contractor to VA supporting HealthCare Data Migration process flow diagraming and documetation

Performing data requirements analysis to support 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 rule to mitigate against 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 determie success rate & provided root cause analysis

Supported project transition of knowledge transfer to wine down

Platform: Jira, SQL Server, CDWWORK Database, SharePoint, Power BI, Safe Agile/Scrum

4/ 2016 – 12/2019, Consultant Business/Systems Analyst (Contractor)

General Services Administration, Washington, DC

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

12/2013 – 2/2016, Sr. Business Systems Analyst

(CMS-Center for Medicare & Medicaid Services)

QSSI Inc., Columbia, MD 21044, and Winsor Mill, MD

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

12/2012 – 11/2013, Sr. Business Systems Analyst (Consultant contractor)

Kaiser Permanente, Silver Spring, MD

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 perform 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

6/2005 - 5/2012, Sr. Business/Systems Analyst

LifeCare Assurance Company, Woodland Hills, CA

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 wrote 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 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. Wrote Business Impact Analysis 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 or 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

2/2004-5/2005, Sr Systems Engineer (Contractor)

EDS Corporation (Trinity), Rancho Cordova, CA

Perform research, fact-finding and business system analysis, enhancement and

maintenance of Claims application processing of CA-MMIS Medicare and Medicaid Information system. Modify and unit test programs for new requirements.

Conduct research on problem statements to determine causes and solutions to California Medicaid/Medicare application systems’ problems. Wrote program specifications for systems changes and perform project management activities.

Platform: OS/VS Cobol, VS Cobol II, CICS, DB2, IBM z/390, MVS, TSO/ISPF

References: Available Upon Request

Contact this candidate