Business Analyst

Sudeep Banerjee

Business Analyst

•Over *+ years of industry experience in IT as Business Analyst including a strong understanding of Business Process Flows, Case Tools, and Business Analysis.

• Experience includes working with offshore companies including Wipro and Tata motors.

•Masters of Science in computer science from one of the top universities of technology NYIT Manhattan with extensive experience in the development, implementation and integration of processes within a team oriented environment, utilizing quantitative and qualitative analytical skills.

•Worked independently on a library system project using ASP.NET for the final year college project.

•As a Project Coordinator coordinated involvement of personnel from other departments and information technology groups to facilitate successful project implementations.

•Strong Knowledge of SDLC methodology, project life cycle, and project management.

•Excellent communication and presentation skills. Experience working with business users as well as senior management.

•Extensive experience to analyze and document business requirements and functional specifications.

•Used Master Data Management (MDM) for several different reference guidelines in healthcare.

•Experience in writing queries/scripts for Data Analysis and Manipulation in MS Access and MySQL using SQL scripts.

•Strong Knowledge of Agile methodology, UML, RUP, Rational Rose, Visio Pro etc.

•Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Task Diagrams, Flow Charts, Activity Diagrams, Class Diagrams, Business Intelligence Tools etc.

•Good knowledge of Business Process Flows/ Modeling, Case Tools, Business Re-Engineering, Business Intelligence and Data Warehousing.

•Experience in conducting GAP Analysis, User Acceptance Testing (UAT), SWOT Analysis, Cost Benefit Analysis and ROI Analysis, NPV, conducting feasibility studies, scope.

•Creative abilities and capable of forming and maintaining positive and productive team environments.

•Experienced in using DB2 tools, Mainframe.

•Excellent Analytical Skills in Data Mining, Performance Management and Project Management to support strategic planning, goal setting, strengthen accountability, enhance decision-making, and improve customer service.

•Knowledge of EDI and Internet Protocol.

•Worked on EHR and EMR.

•Experience in conducting Joint Application Development (JAD) sessions for requirement gatherings, analysis, design, SCRUM, and Rapid Application Development (RAD) sessions to converge early toward a design and blue print acceptance to the customer, and to limit a project’s exposure to the forces of change.

•Effective time management skills and the consistent ability to meet client deadlines.

•Excellent project management skills and proficient in using MS Project.

•Experienced in writing complex and technical reports for a varied high caliber audience.

•Knowledge of Touch point Analysis, LET, Process management

TECHNICAL SKILLS & EXPERTISE

Methodologies

Waterfall, SDLC, Agile(SCRUM), UML, JAD, RUP,

MS Office Tools

MS Visio, MS Outlook, MS Word, MS Excel, MS Excess, MS PowerPoint and SharePoint

Databases

SQL Server, Oracle, DB2 and MS Access

Operating Systems

Windows, MAC, OSX, LINUX

Testing Tools & Defects Tracking

HP ALM, SOAPUI, JIRA, Clear Quest, Team Foundation Server (TFS).

Project Mgmt., Design & Case tools:

MS Project, Visio Pro, Rational Rose

Professional Experience

City Of Seattle, Seattle, WA Jan 2018 to Present Implementation Partner - 3Di Systems Federal Project

Business Analyst

Summary:

For over 20 years, 3Di has designed and delivered business-driven information technology solutions that have enabled our clients to become more responsive to market opportunities and operational requirements, improve productivity and reduce IT services costs.

Responsibilities:

•Served as critical liaison between business, technical, program and offshore teams

•Worked for City Of Seattle’s Grant Management project.

•Worked for City Of Seattle’s Correspondence Management project.

•Created Use cases and High level requirement document.

•Created wireframes depicting user interfaces for front-end systems.

•Modified and created interactive wireframes using Axure RP 8.

•Involved in creating and reviewing use case documents.

•Worked closely with UX designer to explain the functionalities for the new application.

•Created different UX designs and flows in Axure and published it.

•Maintained an interactive spreadsheet for requirements gathering, decisions, follow ups and comments.

•Understood the flow of complex grant management system from Pre-Awarding to Post-Awarding process.

•Worked on the adding the different attributes for different department via data matrix sheet.

•Worked closely with the client’s and performed risk analysis.

•Reviewed the entire process of Grants management and correspondence management.

•Assigned task and tracked defects using JIRA.

•Scheduled meetings with offshore teams and took lead in communicating the requirements, issues and deadlines.

•Involved in User Acceptance Testing (UAT) for different projects and facilitated project delivery by creating and executing test cases, test plans and design reviews and walk-throughs to validate designs.

•Performed complex design analysis. Ensured appropriate implementation of Agile methodology.

•Researched alternative approaches and performed cost benefit and risk analysis.

•Responsible for escalating implementation and helped in assigning issues to appropriate persons or groups for faster resolution

•Worked on streamlining SharePoint to meet project policies and processes.

•Responsible for defining the scope of the Renewal project and implementing business rules.

•Maintained strong communication and written skills with all areas of the project along with exceptional time management skills for quality control tasks.

•Worked closely with stakeholders to understand their Business Processes, including current state and the desired "to-be" state and documentation of requirements and conceptual design from which application and solutions are developed.

•Worked with other business analysts to created, brainstormed and redesigned User Interface.

•Coordinated with the development team in documenting End User Manual.

•Used JIRA Agile for Scrum by prioritizing the different types of issues (epics, bugs, user stories) and used the agile simplified workflow to track them in a timely manner.

Work Environment: Jira, MS Office (Word, Excel, PowerPoint, Outlook, Share Point, Project,), Windows 10.1, Axure RP 8, WebEx, Amazon Chime

Symphony Corporation, United States Department of Agriculture Madison, WI July 2016 to Nov 2017

Lead Business Analyst & Project Coordinator Federal Project

Summary:

For over 18 years, Symphony has been providing best-of-breed technology solutions and managed services to leading healthcare organizations to achieve quality, safety and cost efficiency goals. Symphony brings significant experience to the implementation and integration of point-of-care clinical management (EHR) and ERP systems as well as applications development, population health management, hosting, and related maintenance and support services. Health care organizations benefit from our ability to deliver a full spectrum of technology services in both clinical and administrate areas. Symphony’s managed services include healthcare IT outsourcing, professional services, consulting, hosting solutions and remote technical support.

Responsibilities:

•Worked for USDA (United States Department Of Agriculture)

•Worked for FAS (Foreign Agriculture Services).

•Gathering, elicitating and analyzing requirements using Use case design documents, flow charts, class diagrams and used modelling techniques like use case diagrams & context diagrams.

•Created various documents like the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS).

•Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.

•Worked for AMS (Agriculture Marketing Services) and FAS(Foreign Agriculture Services)

•Worked with clients to better understand their needs and present solutions using complete Agile approach.

•Scheduled Sprint session on every day basis.

•Scheduled Weekly status meetings and took the lead.

•Created use case diagrams, activity diagrams, and flow charts to depict the interaction between the various actors and the system.

•Scheduled one on one meeting with stakeholders.

•Worked on TFS (Team Foundation server). Managed the hours of team members.

•Using JIRA AGILE compiled the Scrum artifacts such as the control chart, burndown chart, velocity chart, sprint report, cumulative flow diagram and gadgets such as agile sprint health and agile sprint burndown.

•Created Weekly status report, Minutes of meeting.

•Provided solutions to the client for any critical issues or bugs.

•Provided support to Quality Assurance on development of test approaches.

•Created release notes after the deployment in PROD.

•Designed various mock up screens using Visio pro.

•Scheduled and Presented demo sessions to clients for each sprint.

•Provided first call resolution to the users.

•Created Milestones for the project by discussing it with the team and client.

•Made delivery of each milestone on time as the highest priority.

•Worked on the Spotfire Reporting.

•Worked on eTDE (Electronic Trade Document Exchange) and eDOCS (Electronic Document Creation System) for USDA websites.

•Documented Entity association with multiple commodities.

•Documented detailed Use case on eTDE Reporting capabilities.

•Designed multi-lingual screens for USDA website to include additional screens including reports.

•Assisted with presentations making Stakeholders understand about how the changes would affect different modules to help the end users with the registration process.

•Involved with the Test planning, test development and test execution.

•Involved in preparing Test Plans based on User Requirements Document (URD) and prepared the Test Cases.

•Worked on maintenance of port lists across the globe.

•Worked as a Project Coordinator.

•Provided training to new team members including developers, business analysts and quality analysts.

•Monitored and tracked project’s progress and handle any issues that arise.

•Created project estimates and resource plans for systems solutions.

•Ensure project billable milestones are sent for invoicing once completed.

•Documented meeting agendas, minutes, scheduling meetings, status reports, share department documents, SharePoint and others.

•Contributed to project estimates (e.g. Budget Guidance).

•Took responsibility to explain the show stoppers to the client while development and deployment phase.

•Maintained weekly project activity and progress reports.

•Reported and escalated any issues to management as needed.

•Used Rational Requisite Pro and Rational Rose to create and maintain activity diagrams, sequence diagrams, and collaboration diagrams

•Involved in budget planning meetings with the clients and also helped to estimate the timelines.

Work Environment: TFS, MS Office (Word, Excel, PowerPoint, Outlook, Visio, Share Point, Project, One Note), SQL, Windows 10.1, SCRUM, JAD, RUP, Agile, Remote access, Lync 2015,Go to meeting, Adobe, Spot fire.

State Of Oregon/ Hewlett Packard Enterprise, Madison, WI Apr 2015 to Jun 2016

Business Analyst

The Hewlett Packard (HP), since 1995 become the national leader in providing immunization system support, In 2015 Hewlett Packard (HP) was transformed to Hewlett Packard Enterprises (HPE) with over 100 staff members providing immunization support services of system Maintenance, Enhancements, training, Helpdesk Support, and Implementation. Currently HPE is providing its services up to 18 states in USA. HPE provides solutions such as digital imaging and electronic health records (EHRs) at the point of care, as well as provide telemedicine and other productivity – enhancing technologies that can help improve patient care and address the chronic shortage of healthcare professionals.

Responsibilities:

•Gathered requirements Primary source : Interoperability – Oregon Health Authority ( Oregon immunization Program/Alert IIS)

•Analyzed the business requirement using various business requirement-gathering techniques.

•Worked in an Agile environment, organized and coordinated project management activities to some extent.

•Managed and prioritize a backlog of user stories.

•Estimated the initial stage of enhancements. Also, presented the estimate with the enhancements to HPE red- team to get it approved.

•Designed various mock ups and wireframes using Ms Visio and Pencil tool.

•Worked on Data exchange and Data quality.

•Prepared UML artifacts viz. Use Cases, Activity Diagrams, recommended by RUP (Rational Unified Process) for Requirements.

•Determined feasibility of business requirements

•Created High – level requirement document and various functional designed documents.

•Worked on report generation for Internal and external partners.

•Recommend changes to support business needs and processes.

•Worked on data validation to ensure data quality.

•Created a Report available through the reports menu to external users, which includes adding filters by timeframe, user- defined parameters, drill down capacity that provides output for sending org level, owing org level, patient level.

•Worked for the Enhancements to improve EHR and EMR systems.

•Developed test cases and was involved in GUI, Positive-negative, end to end and regression testing.

•Developed Project estimates.

•Worked on EDI ANSI X12 transaction and XML files.

•Worked on Model automated reporting that captures data quality metrics on required fields and strongly recommended fields (i.e., CDC core data elements), at the provider org level.

•Worked on Vaccine tracking requirement for a client where they wanted to update the tables for Trade Name of Vaccine group in the Oregon Health Authority Immunization Registry.

•Involved in Regression testing, UAT testing on address retention.

•Worked on design of a new U.I for patients to be inactivated.

•Performed project estimation with team members and other financial authorities involved.

•Supported development team in unit testing by providing testing data during User Acceptance Testing (UAT) phase.

Work Environment: Soap U.I, MS Office, MS Spreadsheet, MS Office (Word, Excel, PowerPoint, Outlook, Visio, Share Point, Project, One Note), SQL, Windows 7, SCRUM, JAD, RUP, Agile, Remote access, Lync 2015, Skype for business.

State of Maryland, Linthicum Heights, MD Jun 2013 – Apr 2015 Sr. Business Analyst

Cognizant being the implementation partner is one of the leading Healthcare transformation enterprises. The changes it has implemented were relating to Health Insurance Exchange (HIX) and Eligibility and Enrollments in Compliance with Affordable care Act (ACA) to improve and access quality healthcare. The primary function of this role included scope definition, specification, requirement gathering and eligibility determination to fulfill the requirements of the Maryland Health Insurance Exchange (MD-HIX) which in turn will assist in determination of the eligibility of individuals enrolling on the Health Insurance Exchange portal.

Responsibilities:

•Participating in reverse engineering method, comprising of documenting a FSD (Functional Specification Document), which outlines the Workflows, Use Case diagrams, Reports and Technical Requirements explaining the HIX application and portal for following needs from Business Units: functionality and its benefits; features and attributes; integration; Business Rules; processing new application, health plans and claims; frontend and backend interfaces.

•Gathering data and performing analysis on frontend and backend interfaces of HIX Web application/portal.

•Retiring MD21 legacy application and replacing it HIX Web Portal.

•Engaging in analysis and testing of ‘as-Is’ State of Payments data exchanged between MD 21 MMARS (Middleware) and MD 21, in comparison to ‘To-Be’ State of similar Payments processing flow in MD HIX.

•Organizing and evaluating data in regards to migration of data comprising of claims, payments and remittance from MD 21 to HIX.

•Worked within the organization utilizing the X12 healthcare claims electronic transactions.

•Analyzing and designing Integration workflow displaying HIX interaction with other systems consisting of MMIS (Medicaid Management Information System), Medicare Claims Processing Systems and other Healthcare Systems at State, Federal level as well as Third Party Companies.

•Interacting with EDI and ICD operations team and technologists in monitoring the conversion of these protocols and standards for HIPAA 4010 to 5010.

•Conducted Analysis and Design of existing transaction sets, and modification of these transaction sets to ensure HIPAA compliance.

•Performed data analysis, created data mapping and data interface documents and kept the documents updated with changes in requirements and functional specifications.

•Worked on developing the business requirements and use cases for automating the billing entity and commission process.

•Coordinated the upgrade of Transaction Sets 837 HIPAA compliance.

•Documented gap analysis for HIPAA 4010 837P Transactions and HIPAA 5010 837P Transactions.

•Involved in impact analysis of HIPAA 5010 835 and 837P Transaction sets on different systems

•Created mapping table for the Transactions accepted by the Sybase translator move into an Interface Database for 837 Transactions.

•Wrote SQL queries related to NPI and Data migration from ICD 9 to ICD 10.

•Worked on streamlining SharePoint to meet project policies and processes.

•Collaborated with Business Units regarding different Work streams including: Infrastructure of Contact Center, Call Center and IVR; Enrollment and Eligibility; Contractual Policies; CRM; and Health Plan Policies.

•Writing Test Cases/Test Scripts for System, System Integration and UAT concerning HIX and its communication with other Systems.

•Worked with QA and checked in the requirements in HP ALM

Work Environment: MS Office; MS Visio; ICD-10 and ICD-9; GUI; Quality Center; Agile Scrum; XML; UAT; and SQL Server, HIX, MMIS, MMARS, ACA

McKesson, San Francisco, CA Jan 2011 to May 2013

Business Analyst

Responsibilities:

Gathering, elicitating and analyzing requirements using Use case design documents, flow charts and class diagrams.

Comprehensive understanding and analyzing of Curam Case Management functionality and associated business processes of a Social Security organization.

Responsible for defining the scope of the Renewal project and implementing business rules for the project involving both Medicaid and Medicare.

Lead fit/gap sessions mapping requirements to standard Curam Based Application Suite features and functions.

Provided major information on the Curam data model and explained entities and attributes in the model and the relationships between them.

Played a vital role in translating BRD into functional specifications and test plans

Worked in Agile/Waterfall hybrid environment, organized and coordinated project management activities to some extent.

Created test cases using the IBM Curam Application tool for both ATST and STST regions with the help of IEG (Intelligence Evidence Gathering2)

Worked extensively on both the Case worker and Citizen Portals for creating cases in the New Eligibility System (NES)

Successful implementation of the Curam product in our project at the state level(MN sure)

Reported Application tool defect during making of Test cases in ATST and STST regions.

Helped write JIRAs(defects) and PMOs(change requests) with the Eligibility/Enrollment Team so that the defects could be fixed and thereby enhance the use the IBM application tool.

Reviewed, analyzed, and evaluated the business data systems that provide data to various data sources like SSA, IRS, Equifax and Fed Hub

Created several test cases in Case worker and Citizen Portals using various scenarios related to health programs like MA/BHP/PTC/QHP and Medicare part A through D.

Experience in MS SQL server MS Access, SQL

Report cases that have not gone through with the team so that the issue could be escalated and JIRAs could be written.

Molina Healthcare, Trenton, NJ

Business System Analyst Aug 2008 to Dec 2010

Responsibilities:

Responsible for the development and implementation of HIPAA EDI 834, 270.

Wide understanding on Healthcare products, HIPAA standards, EDI formats, plans, benefits and coverage.

Created a Functional specification Document for Eligibility Benefit Enquiry (EDI 270/271) service flow.

Involved in Agile grooming session, scrum meetings, tracked User stories and tasks using Rally software.

Worked on EOB report generation and Provider Remittance Advice generation using Crystal Reports.

Involved in the scope defining process of ICD 9-10 conversion.

Worked with in the areas of Clinical, Corporate and Finance, Pharmacy, Sales, Provider Network, identified the use of ICD 9 codes, and prepared documents for the conversion of ICD 9-10 and vice versa.

Gathered requirements and developed Use Cases by interacting with different Functional Groups for ICD 9-10 Conversion.

Performed impact analysis for deadliness of ICD-10 conversion.

Assist coders to be competent in using ICD-10-CMS/PCS

Created UI specification document for the business users to feed data into healthcare web application.Conducted analysis of HIPAA compliance and took part in discussions for designing the healthcare transactions to be HIPAA 5010 compliant

Defined Functional Test Cases, documented, Executed test script in Facets system.

Implemented ETL process for Eligibility, Claims and benefits loads using SSIS package through TWS jobs.

Responsible for implementing BizTalk orchestrations, services and publishing messages to extract EDI 834 file, transforming, implement business logic and loading it into Database.

Conducted JAD sessions, attended meetings and involved in weekly deliverables for IT approval.

Involved in creating test plans, test data for EDI 270/271 service transactions.

Extensive experience in Oracle 10g/9i, MS SQL server, MS Access, SQL.

Work Environment: MS Office (Word, Excel, PowerPoint, Outlook, Visio, Share Point, Project, One Note), SCRUM, SQL, Six Sigma, SWOT, Gap Analysis, Lean Management, UML JAD, RUP, Agile, SDLC.

EDUCATION:

2004 - 2008

Bachelor’s in Computer science from West Bengal Institute Of Technology

2013 -2015

Masters Of Science in Computer science from New York Institute Of Technology

Contact this candidate