Sr. Business System Analyst Resume
5.00/5 (Submit Your Rating)
Boston, MA
SUMMARY
- 12+ 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.
TECHNICAL SKILLS
- Methodologies: SDLC, RUP, Agile, UML
- Project Management: Microsoft Project, Microsoft Office. Microsoft SharePoint
- Database Tool: Oracle10g/SQL Server/Microsoft Access/My SQL developer
- Modeling Tools: Rational Rose, Microsoft Visio
- Reporting Tools: Oracle report, Crystal Report, Tableau
- Change Management Tools: Rational Requisite Pro, Clear Quest, ALM (application life cycle management)
- Testing Tools: Rational Enterprise Suite, HP Quality Center, ALM.
PROFESSIONAL EXPERIENCE
Confidential, Boston, MA
Sr. Business System Analyst
Responsibilities:
- 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 Confidential 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 Confidential 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 (salesforce.com) 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.
Confidential, Boston, MA
Sr. Business and Data Analyst
Responsibilities:
- 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
Confidential
Lead Business Analyst
Responsibilities:
- 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 .
Confidential, Marlborough, MA
Business Analyst
Responsibilities:
- 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
Confidential, New Haven, CT
Business Systems Analyst
Responsibilities:
- 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.
Confidential, Lincoln, NE
Business System Analyst
Responsibilities:
- 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.
