Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rehan Syed

Chicago,IL

Summary

Experienced Business Analyst and Solutions Engineer with 10 years of experience in healthcare, insurance, and financial industries. Skilled in data analysis, SQL, ETL, data warehousing, data mining, mapping, modeling, and reporting. Proficient in Power BI, Tableau, and other data visualization tools. Demonstrated expertise in designing and implementing business process and system solutions throughout the software development life cycle. Strong knowledge of Agile Scrum and Waterfall Model. Excellent communication skills with a proven ability to build relationships with teams, stakeholders, and end-users. Effective at managing multiple priorities in a fast-paced environment.

Overview

11
11
years of professional experience

Work History

Business Analyst

BMO
Chicago, IL
05.2022 - 06.2024
  • Responsible for gathering and documenting requirements through User Stories and Business Requirements
  • Enhanced efficiency by developing precise Acceptance Criteria and test cases in Jira
  • Managed and maintained updated BRD for each work stream, and tracked dependencies between work streams and BDB.
  • Conducted in-depth requirement document analysis to determine dependencies and effort required to ensure seamless integration.
  • Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of user manuals for customers.
  • Wrote test cases in MS Excel for user registration, access to training material, and activity log-in. Renewed the test cases and finalization.
  • Prepared Visio and SharePoint workflows for system integration and migration.
  • Tracked and monitored remediation of bugs on HP ALM.
  • Utilized Jira to design testing parameters and write instructional documents
  • Identified potential risks and challenges associated with integration and migration, developing mitigation strategies.
  • Identified opportunities for integrating systems, technologies, and data from both banks.
  • Involved in assessing the compatibility of existing systems, evaluating potential risks, and proposing strategies for seamless integration.
  • Conducting risk assessments, creating contingency plans, and ensuring compliance with regulatory requirements.
  • Performed analysis and documentation for system migration of Wealth Management.
  • Performed reconciliation of data from source to target for data migration efforts.
  • Collaborated with key stakeholders to gather requirements, managing product backlog, and sprint planning.
  • Performed end-to-end project requirements analysis and story card development in Jira.
  • Facilitated effective communication and collaboration by organizing backlog grooming sessions, sprint planning meetings, and daily stand-ups.
  • Ensures that the team has a clear understanding of the backlog items, their priorities, and any changes or updates.
  • Provide regular updates to stakeholders on the progress of backlog items and any potential impacts on timelines or scope.
  • Managed and maintained Jira to handle project backlog effectively
  • Created healthy backlogs and manages epics as required based on system integrations.
  • Manage RA Capacity and project planning document.
  • Responsible for requirements meetings, gathering requirements, and obtaining sign-off from the stakeholders.
  • Collaborate with the Scrum Master in Estimation and Velocity Planning, Daily Stand-up, and Review Meetings.
  • Developed reporting mockup for reporting changes and enhancements.
  • Interacted with the project team to assign priority to projects based on dependency and criticality.
  • Developed reports or created dashboards, providing financial-related information to make informed business decisions.
  • Defined key data points and data sources to track against measurable performance indicators and produce useful reports.
  • Delivered timely support by tracking issues and communicating resolutions to end users.
  • Collaborated with stakeholders to define features, integrations and partnerships.

Salesforce Product Owner- Business Analyst

Humana Health Care
03.2021 - 04.2022
  • Developed, executed and monitored detailed project schedules for each environment
  • Identified risks in project schedules and communicated mitigations/ recommendations to stakeholders
  • Hands - on experience with all phases of the deliverable (SDLC): from collecting requirements, planning, development, execution (drive WBS, schedule, budget, issue/risk mgmt.) thru deployment & acceptance
  • Analyze Impacts to Macess and Initiate project Intake for team
  • Coordinate with business on Budget allocation
  • Manage Backlog for project intake
  • Coordinate with Business on UAT test time lines
  • Facilitated and led group discussions to elicit requirements in Joint Application Development (JAD) sessions by communicating with documented business requirement document working prototype and workflow diagrams
  • Deployed, configured and supported the prototype application for its demo /UAT for various line of business, prepared deck for UAT & gathered feedback and followed up with further updates on the prototype and related documents
  • Working on Custom objects, Custom fields, Pick list, profile based Page layouts, Workflows and Approvals, Validation Rules, Custom Tabs, Custom reports, Report and Dashboards, Email and Templates according to application requirements
  • Working as a Salesforce Business/System Analyst involved majorly in business and functional Requirements gathering and analysis, translating the requirements into specifications, solution designing, documentation, acting as a link between developers, subject matter experts and end users, performing gap analysis
  • Worked on Agile and Scrum Methodology for Salesforce custom app implementation
  • Created new custom objects, assigned fields, designed page layouts, custom tabs, components, custom reports
  • Collaborate with Sales and Support management to drive CRM process improvement, using business process modeling and other techniques
  • Designed Web User interface for Enrollment process and pharmacy claims systems
  • Broke down Major features into User stories
  • Collaborate with Sales and Support management to drive CRM process improvement, using business process modeling and other techniques
  • Produce site map, user flows, wireframes, page layouts and UI specification deliverables for hand-off to technology and QA
  • Communicate effectively with both technical and non-technical individuals at all levels
  • Create future state vision from initial site map or skeletal frame using Balsamiq, Figma or Sketch
  • Create initial web concepts using low to high fidelity prototypes and wireframes, integrating user-centered design, technology, and business strategy
  • Create current state analysis and feature function lists.

Business analyst/Solutions Engineer

Simplify HealthCare
Aurora, IL
07.2019 - 02.2021
  • Establishes a product vision and roadmap to help position the module for growth and scalability.
  • Collaborates with the IT team to ensure solution architecture and workflow support the business processes.
  • Collaborates with the Business Analysts and Solution Architect to continually mature the backlog, focusing on profitability of the product (ROI)
  • Lead business review sessions and user acceptance testing sessions to ensure product design meets requirements, reducing rework and accelerating pace of delivery.
  • Analyzed client document and prepared logic documents for development teams to configure system.
  • Review and understand CMS regulations, data files, and requirements that support Medicare D premium billing processes.
  • Worked on CMS Center for Medicare and Medicaid Services checklist, MITA, HIPAA, and GAP analysis.
  • Performed gathering, analyzing, negotiating, and refining requirements from the client, business unit, and, in turn, communicating the same to the development and testing team to get it developed, implemented, and tested.
  • Own end-user communication and training strategy on defined module.
  • Validate training material and help create rollout plans for new system enhancements.
  • Coordination with Business and On-site development team, and to mentor the offshore development team.
  • Created QA test plans, test cases for functional and integration testing, and conducted UAT.
  • Effectively communicated with the stakeholders to get a better understanding of the business process and reporting needs.
  • Assist the QA Team in defining test scope, testing strategies, and helping design test data.
  • Responsible for providing mitigations to maintain integrity and consistency of data across various components in the Module.
  • Managed Reporting user stories in DevOps.
  • Planned and conducted various elicitation techniques to collect and document all the functional and non-functional requirements for the developers using set formats.
  • Conducted walkthrough sessions with developers and testers.
  • Conducted GAP analysis, impact analysis at all levels.
  • Provided clarifications and project updates to offshore.
  • Identified UI requirements, created wireframes, prototypes, and UI specifications.
  • Created use cases, wireframes, and state diagrams to demonstrate software architecture and interaction of system components before prototyping.
  • Conducted walkthroughs with business and development teams.
  • Identified use cases and wrote use case narratives.
  • Managed projects and served as primary liaison between client and multiple internal groups to clarify goals and meet standards and deadlines.

Product Manager/ Business Analyst

Master card
White Plains, NY
01.2019 - 07.2019
  • The project was to upgrade a web-based application to the existing web products to integrate various features that would give the customers consolidated view for e-portfolio management online collaboration system
  • Also, I worked on the implementation of the e-portfolio/Finance reporting system which was migrated from the legacy system
  • I performed both Business Analysis and Data Analysis for the e-portfolio consolidation project on the web interface and the reporting interfaces
  • Interviewed business area experts, asked detailed questions and carefully recorded the requirements in a format that can be reviewed and understood by both business teams and technical teams
  • Utilized Agile Methodology to configure and develop process, standards and procedures
  • Analyzed and wrote business requirements and system specification using Rational Requisite Pro
  • Built comparison Reports for Asset/Transaction Data
  • Created UML diagrams so that developers and other project members can understand the business workflow
  • Gathered requirements for financial reports
  • Responsible for gathering requirements and writing User Stories and Business Requirements
  • Presented the project results to the finance management using MS Power Point
  • Supervise regular status meetings and supply appropriate management reporting
  • Reported the defects in ALM and collected Test Matrices weekly from defects database to keep track of defects
  • Managed all the requirements in MS Word templates, making requirements available to all team members
  • MS Excel Spreadsheet development VBA, Forms, Vlookup, Hlookup, Match, Pivot Tables
  • Participated in testing and implementation activities to ensure attainment of desired Business-Systems outcomes (in accordance with established requirements)
  • Assisted team members in preparing Test Data for UAT Testing when requested
  • Conducted meetings with UAT team for the discussion of issues encountered by them during their testing.

Business Systems Analyst

Delta Dental
Oakland, CA
01.2018 - 12.2018
  • The project involved enhancing current systems to support a strategic change and simultaneously performing data analysis and developing reports for upcoming deployment, to monitor performance, and adhere to compliance guidelines.
  • Communicated with product owners to have a clear picture of the core purpose of the project and reviewed the product backlog to prioritize the user stories to be developed in the release.
  • Worked with the team to perform sprint planning, review, and retrospective meeting.
  • Organized and conducted JAD sessions to gain consensus on various issues related to the enhancement project.
  • Managed user stories on Jira.
  • Experienced working throughout the SDLC life cycle with phases such as planning, requirement gathering, design, and actively involved in development, testing, deployment, and maintenance.
  • Worked closely with subject matter experts to identify and analyze the core requirements and key features of the ongoing project.
  • Created a Requirement Traceability Matrix and ensured that requirements were available to all team members.
  • Supporting clients' HEDIS processes and reporting needs and helping them reach new levels of performance.
  • Deep understanding of HEDIS Reporting, Medical Record Abstraction, Quality Improvement, and Data Analysis.
  • Designed high-level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse, which encompasses server name, database name, accounts, tables, and direction of data flow. Column Mapping and Metadata.
  • Used SQLs to test various reports and ETL load jobs in development, QA, and production.
  • Coordinated work plan between project manager and development teams.
  • Ensured that all release and deployment packages can be tracked, installed, tested, verified, and/or uninstalled or backed out, if appropriate.
  • Used Microsoft SQL for writing SQL queries to access data from the data warehouse.
  • Developed reports in SAP Business Objects for the users and management for effective decision making.
  • Worked with data models with complex relationships in Power BI and connected different data sources to Power BI Desktop.
  • Effectively communicated with the stakeholders to get a better understanding of the business process.
  • Planned and conducted various elicitation techniques to collect and document all the functional and non-functional requirements for the developers using set formats.
  • Executed SQL queries to test the database for provider records.
  • Tested the final application for usability testing to verify whether all the user requirements were captured by the application.
  • Tested SQL queries to validate values of reports.
  • Gathered, outlined and reviewed business requirements.
  • Formulated and designed computer systems using data modeling, information engineering and structured analysis.

Business Systems Analyst

Perot systems
Hyderabad, India
08.2013 - 12.2014
  • The project was to enhance the enrollment application that can automate the different EDI transactions, such as 834 - Benefit Enrollment and Maintenance, 820 - Payment Order and Remittance Advance, and 999 - Implementation Acknowledgement and TA1.
  • Created Business Requirement Documents (BRD), Functional Requirement document (FRD) test plan for defining project plans, technical issues, system requirements specifications, and delivering project/status reports
  • Worked closely with SMEs and identified and analyzed the core requirements and key features of the ongoing project.
  • Created Requirement Traceability Matrix (RTM) and ensured that requirements were available to all team members also urged communication and collaboration among team members
  • Identified Use Cases from Business Requirements and created UML diagrams like use case diagram and activity diagram using MS-Visio for various stakeholders.
  • Coordinated work plan between project manager and development teams using Microsoft Project.
  • Optimize customer-preferred user experience through email, SMS, and direct mail.
  • Replace slow and expensive, paper-based workflows with automated, intelligent processes.
  • Analyzed forms and successfully cross-walked details to corresponding ANSI X12 formats.
  • Involved with the Quality Assurance Team to develop and design test plan and test cases.
  • Tested the final application for usability testing to verify whether all the user requirements were catered to by the application.
  • Created ETL data mapping documents during migration of data.
  • Involved in validating data before and after the data conversion process.
  • Created inbound and outbound EDI Business Process flow diagrams of the AS-IS Process to understand the current and future workflow to incorporate the various changes using MS Visio.
  • Led the Change Control Process for changes submitted for the BRD, once the document was submitted to the IT department.
  • Tested SQL Queries to validate values of reports.
  • Coordinated with the PM, Business, and the QA team for conducting a thorough analysis of the execution, control, design, development, and testing of the Enrolment system.
  • Maintained the organization's standard documentation format for developing test plans, test cases, defect reports, pre-testing grid for HCS diagnosis file and HCS Procedure file, data mapping, and data migration.
  • Worked on different healthcare insurance plans and Mass Adjustment, including co-payments, deductibles, number of visits, services code, and location, in network or out of network.
  • Ensured that all release and deployment packages can be tracked, installed, tested, verified, and/or uninstalled or backed out, if appropriate.
  • Managed Change Requests from stakeholders by conducting extensive Impact Assessments to capture the expected result of such changes.
  • Used Microsoft SQL for writing SQL queries to access data from DB2 Mainframe, Sharp HealthCare data warehouse.

Education

Master of Science - Management Information Systems

University of Illinois At Springfield
Springfield, IL
10-2017

Bachelor’s In Computer Science Engineering -

Osmania University
Hyderabad
01.2013

Skills

  • SQL server
  • Rational Requisite Pro
  • JIRA
  • HP ALM
  • DevOps
  • Informatica
  • Tableau
  • SAP Business Objects
  • Qualtrics
  • Figma
  • Balsamiq
  • Business Planning
  • Technical Writing
  • Data Mapping
  • Data Analysis
  • Workflow Analysis
  • Campaign Performance Tracking
  • Requirements Gathering
  • Cost-benefit analysis
  • Gap analysis
  • Competitive Analysis
  • Project Management
  • Forecasting and planning
  • Microsoft Office Suite
  • Product Development
  • User Acceptance Testing
  • BI tools expertise

Timeline

Business Analyst

BMO
05.2022 - 06.2024

Salesforce Product Owner- Business Analyst

Humana Health Care
03.2021 - 04.2022

Business analyst/Solutions Engineer

Simplify HealthCare
07.2019 - 02.2021

Product Manager/ Business Analyst

Master card
01.2019 - 07.2019

Business Systems Analyst

Delta Dental
01.2018 - 12.2018

Business Systems Analyst

Perot systems
08.2013 - 12.2014

Master of Science - Management Information Systems

University of Illinois At Springfield

Bachelor’s In Computer Science Engineering -

Osmania University

Similar Profiles

CREATE PROFILE
Rehan Syed