Sign in

Business systems analyst

Quincy, MA, 02171
December 09, 2019

Contact this candidate


Alisa Feng Xu


She is looking for C2C position local to MA


●10 + years of professional experience as Business System Analyst with expertise in Software Development Life Cycle (SDLC) and project lifecycle across industries primarily in Finance, HealthCare and Retail.

●Certified Scrum Master Proficient in using Agile Scrum methodologies, following sprint/standup sessions and write user stories, assign tasks to individual team members, analyzing the Iteration Burndown charts and Cumulative flow charts, logging and reviewing defects

●Extensive experience in the development, implementation and integration strategies towards a team oriented environment, utilizing quantitative and qualitative analytical skills with a strong communication skill.

●Experience in business requirements gathering and writing including the EDI transactions 270/271, 835, 276/277 and other health care projects include Medical Loss Ratio (MLR), ICD9/10Healthcare Web Portal. Well Versed on HIPAA regulations and requirements

●Extended experience in document functional specification, process specification, data element specification, security specification an in BDD (Business Design Document) and BRD (Business Requirement Documents) along with use case and work flow diagram.

●Skilled in interviewing business stakeholders and customers and providing recommendations to resolve issues for various business/technical groups & defining strategic solutions to business problems in a multiple projects environment

●Expertise in eliciting detailed requirements specifications through JAD sessions, interviews, on site meetings with business users & development team

●Demonstrated documentation skills in preparing Functional Specification Document (FSD), User Cases, Test Case, Test Scenarios, and Test Plans for E2E testing

●Proficient in Change Management process and version control, create and maintain project change request (PCR)

●Experience with data analysis, data mapping, and data-masking, cross-functional application/ domain dependencies.

●Deep understanding of Salesforce lighting components data architecture and Admin functionalities.

●Adept in writing SQL queries for data extraction, manipulation, analysis, and validation, generating user reports and proficient knowledge of Relational Database Management Systems (RDBMS), and Data Warehousing.

●Experienced Business Process Reengineering and Business Process Documentation (BPD) with prime focus on claims adjudication, provider, eligibility criterion and authorization for Medicaid and Medicare programs

●Proficient in IBM Mainframe using IBM Rumba

●Analyzed & Designed Use Case using UML methodology, Sequence, Process diagrams, Cross functional dependencies diagrams, High level E2E application flow diagrams

●Experienced working with Quality Assurance (QA) team in Program level E2E testing and UAT Testing

●Actively involved in developing, executing and managing User Acceptance Testing (UAT) and Change Management.

Professional Experience

Commonwealth of Massachusetts -Department of Transportation

Aug 04 2018- Now

Lead Business Analyst

MassDOT `s General Counsel`s office(GCO) is one of the few shared services under Secretary of Transportation providing legal services to both Massachusetts Department of Transportation(MassDOT) and Massachusetts Bay Transportation Authority (MBTA). The GCO serve all MassDOT and MBTA legal need include General Claim from Public,Tort litigation, Commercial Transactions, Employment Labor law etc. .GCO is in need of a Case Management solution to assist users at all levels with record keeping, case management, document management, calendaring, schedule management, management case reporting needs. I am hired as the lead business analyst from IT to bring the solution to GCO .

Role and Responsibility:

Elicit high level business requirements form the managing counsel of each center of excellence

Work with procurement counsel to develop RFQ for CommBuys posting.

Lead vendor selection process by set up demonstrations with eligible Vendors and stake holders at MassDOT, Proving summary and scoring Matrix to IT and Business Senor Leaders

Providing support to Product Owner to secure funding from Capital Funding Review Board .

Check Vendor references and support SOW development

Authored detailed business requirements for Claim and Litigation, Employment and Labor Center of excellences

Develop AS-Is and To-Be workflows for MassDOT and MBTA General Claim,Litigation, Employment and Labor Matters,Billing and Finance.

Elicited detail business requirements from users at all levels from intake specialist, claim specialist, responsible counsel, practice lead,managing counsel and general counsel

Collaborate with MassDOT and MBTA DBA teams to generate current data files from multiple applications include (InsLaw for MBTA claim, Time Matters for MassDOT Labor Relation)

Developed department wide workload template for legal staff maintained logs

Oversee and Validate the overall data migration services provided by cloud Case Management Solution Vendor

Manage Vendor Communication by communicate detailed requirements to Vendor solution Team though daily Scrum Meeting and Weekly Status update Meeting.

Manage Vendor delivery to meet deadline by phase implementation

Collaborate with MBTA and MassDOT services desk teams to develop support Matrix.

Coordinate with business owner to support UAT testing for different user groups . Authored UAT testing document .

Support ADA Testing Vendor by coordinate with implementation partner.

Mentor new business analyst to meet pressing detailed requirement elicitation deadline, developed new Business analyst on boarding check list.

Maintain project SharePoint Site and user story backlog broad using Microsoft Team Services.

Collaborate with Salesforce implementation partner to evaluate legal App build on existing salesforce Organization .

Evaluate potential legal applications provided by implementation partner from Salesforce AppExchange.

Partner with KPMG management consultants to define future state of the organization .

TJX Company, Marlborough, MA

April 2016 –Present

Senior Business Analyst

TJX Company is the largest international apparel and home fashions off-price department store chain in the United States. Supply Chain include DC (Distribution Center) Management, Transportation Logistic, and ticketing applications. I worked as senior business system analyst support supply chain projects that include New Ticket Provider Project, Expand DC receiving door beyond 99, Change Request Canadian DC Reports, TAG Remediation, Global Merchandise initiative Europe Phase II Designation Data conversion Project. HomeGoods 1000 store.

●Work as Senior Business analyst under Business Analysis Center of Excellence that follow TJX proprietary development methodology.

●Authored Supply Chain workflow document using MS Visio for New BA orientation

●Developed a standard process document/template to activation DC (Distribution Center) labor incentive projects and New DC opening projects

●Worked on multiple projects that include JDA Transportation system, SCAN (warehouse management system), TAG client/user facing ticket system and VR (Vendor relation) management system

●Facilitate business requirements elicitation sessions with logistic specialist on Vendor relation team to documents business requirement for new ticket provider projects.

●Support and Provide approval for new pre-ticket provider projects technical design.

●Coordinate and facilitate UAT Testing Plan sessions with TJX business user team and new ticket vendor. Document UAT testing plan and obtain approval from business executive sponsors.

●Facilitate UAT sessions, documented UAT Testing results and UAT testing evidence documents in TJX proprietary integrity application to satisfy SOX audit requirements.

●Supported Canadian Change request project mainly in UAT Phase, obtain UAT Approval, implementation approval and Go-live approval from respective executive sponsors.

● Supported UAT and production change request for expand processing door beyond 99 projects

●Authored user training documents for 99 door projects support project throughout the transition period until project successfully transitioned to GPS (Global Production Support) team.

●Worked on global ticketing solution project for initial project discovery phase, developed RFI (Request for Information) document to circulate

●Perform As-is analysis for TAG current enterprise ticketing solution to provide insight for potential new vendor.

●Authored high level business requirements for new ticketing solution.

●Deep understanding of SOX IT compliance requirements for IT Data Conversion and Data Migration. Authored Data Conversion Functional Design Document, Conversion Mapping Document Conversion BA Test Case Document, Conversion Test Evidence Document.

●Profile and analyze source conversion data using IMS Mainframe File Aid, DB2 Data Studio, SQL server management studio, support conversion program design with data profiling results

●Authored 5 set of Conversion Documents support TJX Europe merchandizing, planning and Distribution functions

●Mange conversion testing result and defect in HPQC, support Development trouble shooting.

●Conduct complex Mainframe to DB2 and DB2 to DB2 Conversion Detail Walk through sessions with Europe functional BAs, and Business stakeholders to facilitate business project sign off

●Support HG 1K Store Project Release C UAT testing plan and End to End testing plan involve Store Operation, Sales Audit Reporting, Merchandise Planning, Merchandise Allocation, Distribution Center Operation

● Worked with Application SEMs from Various Business Functional team, Authored UAT testing script for each planned release, mange UAT using HPQC

MFS (Massachusetts Financial Services), Boston, MA

August 2015 – April 2016

Senior Business System Analyst

MFS CC (Client Connect) program initiative is a strategic effort to achieve organization vision to “build world class client services”. CDM (Client Data Management) and DQ (Data Quality) Projects are at the heart of the program to build a single version of the truth for MFS Fund Distribution leveraging Informatica MDM (Master Data Management) and Informatica DQ (Data Quality) tools .MDM project lays the foundation for the program to provide enterprise level “Golden record” meanwhile aid MFS core sales system transfer to DST Sales Connect, aid migrating Legacy CRM system to, support upgrade Territory Management and sales commission system to New IBM solution, provide trustworthy client data to Sales Data Mart and EDW(enterprise data warehouse).

●Review existing Data Quality project implementation plan provide by Accenture team, present recommendation for EPMO to plan Data Quality Project phase 2.

●Collaborate with EIM (Enterprise information Management) data stewards by providing technical support and leading conversation in the process of creating enterprise client reference data with global client relationship SMEs and sales strategy specialists and global data stewards involved.

●Authored client reference LOV (list of values), provide support for EIM to produce client data terms using Informatica Metadata Manager.

●Validate and approve SLX (SalesLogix) to MDM STM (Source to Target) mapping document delivered by vendor and maintain track change/update logs in ALM (Application Lifecycle Management) tool.

●Authored legacy CRM system SLX frontend to backend mapping document.

●Translate business requirements into functional and non-functional specification and maintain the traceability back to business requirements.

●Maintain SLX system code value map to EIM maintained future state LOV, keep transformation logic up to date, and communicate update with solution team.

●Log changes and facilitate the communication necessary changes between QA and Dev. Team via ALM.

●Performed document analysis for DST Sales Connect, ACS, DNB (Dun & Bradstreet), MMD (Money Market Directory). Produced MFS MDM master list of attributes for the above 4 sources.

●Performed sample data quality analysis for the 4 future inbound feed. Generate MDM specific quality report. Further refine the scope of work for phase 2.

●Participate in CC program 2-day off-site workshop and subscribe CDM project. Produced CC program CDM top 10 dependencies and project milestones list. Provide senior management with high level timeline and dependency estimate at program level, pointed out the most important dependency is Business readiness.

●Authored DST, ACS, DNB, MMD code list to MFS MDM enterprise LOV mapping document.

●Collaborate with Dev. and QA team to clarify requirements and facilitate phase 2 initial communication.

●Manage requirements and traceability using ALM, periodically generate traceability report for senior management and project reporting purpose.

●Maintain cross project technical dependencies track list which between MDM and legacy CRM to SFDC ( migration, Territory Management and Commission system, core sales system upgrade and EDW sales data mart.

●Applied previous MDM Match and Merge Process best practice to assist vendor in Match and Merge rule fine-tuning exercise. Maintain Match and Merge changelog.

●Document enterprise level data governance, data quality, and data policy rules. Work as a liaison between EIM and solution team.

Commonwealth / State of Massachusetts-EOHHS, Boston, MA

August 2013 – August 2015

Senior Business and Data Analyst

Master Data Management (MDM) Project is a cross-state agencies data coloration initiative, aiming at create a statewide central client/recipient enterprise level shared database for Executive office of Health and Human Services (EOHHS/EHS) and other 16 sister agencies. The project includes the infrastructure which is the core MDM engine leveraging IBM initiate, legal efforts that involve EOHHS and multiple EOHHS sister agencies, and enterprise wide shared interface to support secure data sharing. Project was successfully delivered to Initial set of business user and enterprise application support teams. MDM project won the “Top 10 most innovative project in Massachusetts award in 2014.

●Project followed EHS product delivery methodology

●Participated in overall HIX (Health insurance Exchange) eligibility design session, elicited HIX business requirement and Initial Data elements discovery session.

●Closely work with EHS enterprise architect to finalize the final MDM data elements. Authored high level

●Authored MDM Program Interface Guide Document to circulate among phase II participating agencies boost the communication between MDM program and participating agencies.

●Facilitate JAD session to obtaining data from participating agencies technical development group

●Act as point contact for data elements and file quality clarification.

●Prepared MDM Overview Document for MDM program manager to communicate with EHS Law maker to develop Data Sharing Agreement (DSA), and EHS secretaries to draft MDM program policy memo.

●Prepared MDM use case and MDM overview deck for EHS CIO and Lead architect to present in state innovation council

●Documented MDM vision document that specify the high-level user and system expectation for MDM initiative. Present MDM vision document on MDM project intake meeting.

●Authored MDM business requirement document and maintain source to MDM mapping document for MMIS and BEACON feeds.

●Assisted MDM program manager to set up MDM Jira site and being active project Admin on MDM Jira site, generate daily/ weekly JIRA ticket status report to track project status.

●Being a Project Admin at MDM Mass Forge collaboration site and manage shared documents and code drop point.

●Authored MDM use case document to capture user workflow

●Authored MDM Functional Specification Document and UI wireframe

●Support at Development phase for interagency and cross-functional support team communication

●Communicate with Access Identity Management system (AIMS) technical team and business operation team to fulfill MDM security and legal requirements.

●Contribute in Test Case development session and authored MDM reporting module test cases and MDM portal UAT test case.

●Performed MDM portal UAT Testing and contribute in defect triage call.

●Set knowledge transfer session with business user and authored MDM member locator portal user manual.

●Conduct one on one interview session with MMIS data warehouse team and develop MDM data feed best practice guide.

●Utilize MDM initiate workbench, imitate Inspector and SQL developer to conduct MDM data health check and authored MDM data quality report on a monthly basis.

●Act as data steward to check data quality and build up data manipulation rules to communicate with data governance committee.

●Understand IBM initiate algorithm and work closely with Initiate Architect to fine tune initiate engine.

●Work closely with data governance committee to build up MDM data governance rules and document data patterns using Initiate generated pair analysis.

●Worked as project coordinator facilitate between MDM technical implementation team and MDM operation support team, developed MDM data quality operation support user guide. Conducted knowledge transfer session with new data stewards hired.

●Work closely with EOHHS technical support groups to perform enterprise level application support

HP / State of Rhode Island

January 2013 – July 2013

Business Analyst

HP Enterprise Services is a fiscal agent for 20 states Title XIX account. State of Rhode Island decided to upgrade secured DHS IWS (Interactive Web Services) to a modern user -friendly HP corporate owed HCP (healthcare provider portal) which is been successfully implemented by multiple Title XIX Accounts and commercial insurance companies. The initial phase of the project meant to migrate eligibility search, claim search, and file exchange (Upload/Download) function to HCP mean while EDI Coordinator is able to maintain the same level provider security and access.

●Follow HP SDLC (System Development Life Cycle) methodology thought out the entire project.

●Attend to account level Projects interdependency meeting with other on-going projects as a business analyst from Web Portal Team; identify projects that affect the portal migration.

●Work closely with 5 states initiative Translator Update project and ACA (Affordable Care Act) 270/271XML solution project, and ACA (Affordable Care Act) 276/277XML solution project

●Part of breakup Rhode Island MMIS elegy-engine and claim search engine initiative team, assisted with system Architect propose impact analyst and feasible study for breakup the MMIS engines.

●Work closely with multiple platforms SE (System Engineer) JAVA (IWS), Dot Net (HCP), XML from other accounts come up with Web Services solution to substitute elegy-engine and claim search–engine.

●Performed Gap analyst and impact analyst between IWS and HCP.

●Authored As- Is RI IWS Process flow and data flow diagrams and developed To-Be RI HPES HCP Process and data flow diagrams using MS Visio 2010.

●Meeting pressing deadline complete SOW (Statement of Work) and BDD (Business Design Document), presenting internal -walkthrough, internal QC, external –walkthrough and get immediate sign-off.

●Work with EDI Coordinator, Provider outreach, RI Medical Assistance team to determine Provider Outreach, come up with a Solution that keeps IWS and HCP in parallel running before 3-month hard cut-off.

●Conduct intensive workshop with HCP product team and RI Provider Assistance Team to come up with RI specific provider friendly UI design and screen Wireframe using MS Visio.

●Developed RI MMIS Proprietary to HIPAA 270/271 mapping document and HIPAA 270/271 to HPES Provider and Member Portal mapping documents. Conduct Gap Analysis among the above-mentioned format.

●Using MS Project to monitor multiple parallel on-going project milestones

●Documented RI specified Use Case for eligibility verification functional area. Identified functional flow for both eligibility search and claim search for proposed Java Jolt solution and Dot Net Web services solution.

●Documented Test cases for UI Testing and inter-system testing.

●Using Toad for Oracle to prepare date for Portal Model Office Testing and Production Testing, using Model office to conduct UI Testing, and prepare Production for Provider UAT testing.

●Assisted with existing IWS user migration Team to migrate existing user /Trading partner credential and Trading Partner access by using SSO (single sign on) secured by SAML (Security Assertion Markup Language)

●Part of the team that eliminate Tuxedo services as a required path for incoming and outgoing HIPPA transaction to Corel MMIS system.

●Part of PEZ upgrades team to implement PEZ direct upload (837/270/276) and download (835/271/277) tough Web server.

●Documented step by step user help file and business user process flow chart for Portal authorized user and RI HPES Medicare Assistance help desk.

WellPoint, New Haven, CT

November 2011 – December 2012

Business Systems Analyst

The purpose of the Medical Loss Ratios (MLR) projects is to build a tactical and strategic solution that will be used by Finance personnel at WellPoint to produce the HCR MLR Blanks and Rebates as specified by the National Association of Insurance Commissioners (NAIC) and as required by the Public Health Service Act (Medical Loss Ratio), which was added by Patient Protection and Affordable Care Act (PPACA) on MAR 2010.

●Contributed as Business Analyst to MLR (Medical Loss Ratio) End to End Compliance Core Team, on Program Level which consists of seven MLR projects.

●Gathered requirements for Finance & Accounting applications (Corporate Domain) for preparing Requirement Specification Document.

●Collaboration in daily Scrum/stand up, readiness meetings and sprint planning meetings to establish wish list, a sprint backlog, and decides how to implement those pieces.

●Working knowledge of agile development methodology to adapt the change for simple clean implementation and designs

●Applications include FSAH (Finance Service of Accounting and Hub), IFSGL (Integrated Finance Service General Ledger) and GLPP (General Ledger Pre-Processor).

●Actively interact with stakeholders from Plan, Member, Claim, and Billing and Corporate domain.

●Using MS Visio to develop BPMN, prepare for business process document (BPD) to ensure proper interaction between applications.

●Gathered requirements from stakeholders through surveys, prototyping and observing from UI (user Interface) of the existing system, took screen mock-ups (wireframes)

●Developed data trace mapping to identify the critical paths for E2E testing to be conducted.

●Identified critical domain junction points and cross application junctions’ points along with how data is transferred. (File creation, API, etc.)

●Interacted with different project teams, SMEs, PMs in order to prepare E2E data mapping.

●Tagged the requirements using Requisite Pro for traceability and management purpose.

●Defects tracking using HP Quality Center.

●Identified the data flows and data dependencies in order to build the Test Execution Plan.

●Involved in UAT Testing of Finance and Accounting applications and created several artifacts such as Application Mapping, Data Masking, Cross Function dependencies, and UAT files timelines.

●Provided knowledge transfer (KT) to E2E compliance testing team in order to test the MLR attributes flows in each application.

●Used UML methodology for developing use cases, and diagrams for showing user and system interaction.

●Developed and managed defects impacted application sheet in order to track each application testing and meeting time lines.

●Used project management techniques to establish roles and responsibilities, monitor project and request status and workload, and ensure deliverables of high quality, effectiveness and timeliness.

●Manage assigned enhancements, automations and implementations from concept through implementation.

●Create, develop and maintain project schedules for key deliverables by developing project plan, monitoring milestone completion and coordinating project progress.

State of Nebraska, Lincoln, NE

March 2010 – October 2011

Business System Analyst

This project was upgrading an existing EDI system, initiate the system for dual purposes: First, this system is used as a National HIPAA 5010 EDI testing tool, 5010 test-data generating, typically for Medicare, Medicaid or Commercial Payer HIPAA 5010 Projects or HIPAA Training. The second use is for an affordable 5010 desktop solution for Providers.

●Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. This includes HIPAA 4010; 837, 835, 270/271, and others. Provided healthcare provider problem resolution.

●Arranged JAD sessions with business users and development team to drive out detailed business requirements.

●Also, worked on 837 and 835 projects, including syntax and business rules for X12 HIPAA 4010 and 5010 validations for loops, segments, elements, qualifiers and code sets.

●Authored Data flow diagram, sequence diagrams and business process models that describe would comply with ICD-10.

●Documented Business Requirement Documents by interacting with Businesses and various stake holders.

●Designed Test cases, Test plan creation and Companion Guide from development stage to production, including both internal and external requirements.

●Developed unit testing documentation using Excel. Artifacts were created and listed for UAT validation. Writing/validating Use Case Documents.

●Managed Financial Processing that served as primary lead for corporate financial systems, including accounting processes for accounts receivable and accounts payable systems. Manage financial spreadsheets and vendor accounts. Spearhead collection processes and manage accounts receivable personnel.

●Followed Unified Modeling Language (UML) methodology using Requisite Pro and Rational Rose to create/maintain: Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.

●Tested and delivered Inbound/Outbound interfaces for 837/835 transactions.

Humana Health Insurance, Louisville, KY

May 2008 – February 2010

Business System Analyst

As a part of the project I worked on Claims processing module of the Group Approval Process (GAP). The claims processing module involved Receipt and Verification of Claim Forms (837) and Claims Attachments (275), Claims Enquiry and Response (276/277), Adjudication, Health Care Claim Payment/Advice (835) as per HIPAA guidelines

●Elicited requirements from Subject Matter Experts and documented them per the needs and requirements of the project.

●Analyzed the functional details of various modules in mainframe and did the GAP Analysis with the new system.

●Prepared the Business Requirement Document (BRD) and functional requirement document (FRD) for the enhancement of the existing services

●Analysis and Design of existing transaction sets, and modification of these transaction sets to ensure HIPAA compliance

●Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business flows and determine whether any current or proposed systems are impacted by the new development efforts

●Created workflow diagrams, UML diagrams, process models, activity diagrams, use cases, swim lanes, for incorporating design changes in the order creation/ management system

●Coordinated the upgrade of Transaction Sets 837P, 835 and 834 to HIPAA compliance.

●Did gap analysis for HIPAA 4010 837P and 835 transactions and HIPAA 5010 837P and 835 transactions.

●Utilized Agile Methodology to configure and develop process, standards and procedures

●Re-engineering and capturing of transactions with legacy systems [Enrollment -834, Eligibility Transaction (270/271), Claims (837), Claim Status Request and Response (276/277), Remittance (835)].

●Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, plan codes, benefit set-ups, fee schedules, provider pricing, capitation set-ups, etc. from Legacy system.

●Performed Migration and Validation as per the SDLC standards.

●Developed logical & physical modeling as per business requirements.

●Prepared Test cases, Conducted Integration tests and User Acceptance Tests.

Sterling Health Insurance, Bellingham, WA

March 2007 – April 2008

Business Analyst

The Company had developed an application for Managing and processing Claims - Claims Management and Reconciliation (CMR). Patient's information, history about disease and medication is collected and stored in the CMR Health Information Management/Enterprise Document Management System. I worked on enhancements and fixes to the Claim Engine with the various Business Owners.

●Gathered Requirements from various Business Areas like Claims, Provider Relations, Enrollment, Finance and Benefits Administration for their updates to the Claim Processing Engine.

●Delivered platform related specifications such as security, performance, and capacity, Standard code sets such as ICD-9, HIPAA EDI, CPT and DRG etc.

●Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).

●Analyzed Business Requirements and developed Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams Activity Diagrams and State Chart Diagrams using Microsoft Visio and Rational Rose according to UML methodology thereby defining the Data Process Models.

●Created activity report, logical components and deployment views to extract business process flows and workflows involved in the project.

●Checked the

Contact this candidate