Post Job Free

Resume

Sign in

Sr. Business Systems Analyst

Location:
Norwalk, CA, 90651
Posted:
May 15, 2020

Contact this candidate

Resume:

Name: Deepti G

Contact No: 404-***-****

Email Id: adc8pc@r.postjobfree.com

Professional Summary:

Over Seven years of diverse progressive experience in Information Technology, with emphasis on Business Analysis and Software Development.

Expertise in working with Business Analysis, Risk Analysis, Business Process Models, Business Flow Diagrams and Business Requirement Documents.

Comfortable in working with different requirement gathering techniques like Brainstorming, JAD sessions, Focus Analysis, Reverse Engineering, Survey, Document Analysis, Interview, Prototyping and Observation

Good working knowledge in Enrollment, Billing, Claims, CMS regulation, HIPAA regulations, 834 Enrollment and 837 claims transactions for health care industries.

Experienced in working with TrizettoFacets on Provider Life cycle, Members Enrollment and Claims modules

Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, RiskAnalysis.

Experience Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents

Expertise in creating Use case diagrams, Activity Diagrams, Sequence diagram, Business work flows with complete understanding of various SDLC life cycle concepts.

Extensive experience in modeling the AS IS and TO BE ecommerce solutions

Extensive exposure of working in projects related to data and system integrations needed due to Merger and acquisitions.

In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).

Experience in the ETL (Extract, Transform and Load) process used to migrate data into new platforms using Informaticatool and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).

Hand on Experience in the back-end applications of data validation process using SQL

Experienced in performing Business Process Analysis to check the compatibility of the existing system infrastructure with the new business requirements and in translating business requirements, user expectations into detailed specifications by using various Text formats & Unified Modeling Language (UML).

A self-starter and good at making healthy and productive working relationships in internal, external, independent, and team environments

Result oriented, highly motivated, organized and eye for detail with excellent communication and interpersonal skills. Ability to adapt and quickly learn new technologies.

Technical Skills

Operating Systems: Windows 98/NT/2000/XP/7, Citrix, VSE Mainframe.

Languages: C, C++, Visual Basic, SQL/PLSQL

Databases: MS-Access03/07/10, SQL Server, Oracle, DB2.

Tools: MS Visio, Rational Rose, Rational Clear Case, RationalRequisitePro.

Bug Tracking Tools: Mercury Test Director, Rational Clear Quest

Testing Tools: Test Director, Load Runner, Quality Center

Client: PROSPECT MEDICAL HOLDINGS, Norwalk, CA Aug 19 – Present

Sr. Business Systems Analyst

Role and Responsibilities:

Gathering requirements from business users based on new market rules and Desk level procedures.

Worked with Architects to Create Data flow model for Government owned Facilities, and for new oncoming ROSTERS.

Work on EDI transaction sets to create mapping for Authorizations and Claims

Followed the UML based methods using MS Visio to create Use Case diagrams, State chart diagrams and Sequence Diagrams.

Act as a liaison between the business stakeholders and delivery team through the project life cycle to communicate and validate requirements and ensure that technical delivery team has full understanding of business goals and objectives as stated in the requirements.

EDI Mapping to process medical authorization in Pega.

Assisted developers with mapping rules and business logic.

Provide Business Requirement Documentation (BRD) for the customers after through market and technology research and by analysing current market trends.

Created a Traceability Matrix to maintain the Traceability of the requirements.

Facilitated Joint Application Requirement (JAR) sessions to identify business rules and requirements with Business Teams.

Wrote SQLQueries to create tables, stored procedures, triggers and performed data analysis, data mapping, data reporting using MicrosoftSQL Server Management Studio.

Involved in the development of system test plan and test scripts using business and system required documents.

Worked closely with Project Managers, Developers and QA team to translate functional designs into technical design documents.

Worked on EDI transactions, submitting and tracking claims until adjudication and Remittance Advice.

Manually created records through GUI to create Network rows for existing TIN/NPI combinations.

Prepared Business Requirements Document (BRD) and then converted business requirements into Functional Requirements Specification (FRS).

Coordinated with Developers and testing teams to facilitate the projects.

Participated in JAD sessions to identify the business needs and determine the impact on current and proposed projects.

Clarification of requirements to Development and testing teams.

Worked with Users to make sure Claims get Adjudicated correctly for the new providers added into the Network.

Set Flags for Government run Facilities to process claims with different rules

Environment:EDI, RUP, MS Office suite, MS-Access 07, VBA, MS Excel, SQL Server 08, VB script, Quality centre 9.0.

Client: Cigna, Columbus OH Sep 18 – Jul 19

Sr. Business Systems Analyst

Role and Responsibilities:

Gathering requirements from business users based on new market rules and Desk level procedures.

Worked with Architects to Create Data flow model for Government owned Facilities, and for new oncoming ROSTERS.

Created business requirements document (BRD) & functional requirements document (FRD) to map the business rules as documented.

Built databases in Microsoft Access07 as per new market guideline based on business rules and Desk level procedures, to asses Data Cleansing.

Created Test data and test cases in MS Excel to test numerous scenarios, for setting up Providers in FACETS.

Worked with Facets Architects to get in-depth knowledge on Providers life cycle and how can Members and Claims get affected with Providers Network setups.

Did Reconciliation of Data on Providers back-end table to gauge the quality and enhance quality of existing entities.

Worked with Facilities to get the correct count on number of Members/ Eligibility and Demographic information to set, Groups/Subgroups/Subscribers/Members accurately in facets

Reconciled the Relation tables to ensure the dependencies does match with Health products selected.

Built Automated system to Add, Terminate and update existing data based on incoming weekly ACT files from existing Rosters.

Created Audit Adhoc update system to capture any changes that were skipped.

Worked with Operational and Implementation team to build a system where loading Providers and Eligibility checks can be made successfully which overcomes efforts of keying records through GUI.

Did Post load Check through GUI to make sure provided updates/Demographic information is loaded accurately.

Manually created records through GUI to create Network rows for existing TIN/NPI combinations.

Reported Vendors about the data issues and Data Quality when required.

Created a Mapping document to map Codes provided by Vendor/Roster/Government owned Facilities to match the codes that are acceptable in Facets.

Created Pivot tables to show the oncoming new Adds vs Terms from new vendors.

Worked with Operational team and End users to ensure the quality of data to help them get agreements from new providers.

Worked with Users to make sure Claims get Adjudicated correctly for the new providers added into the Network.

Set Flags for Government run Facilities to process claims with different rules.

Environment: Facets 4.71, RUP, MS Office suite, MS-Access 07, VBA, MS Excel, SQL Server 08, VB script, Quality center 9.0.

Client: Nordstrom, New York City, NY May 17 – Aug 18

Business Systems Analyst

Role and Responsibilities:

Analyze, gather and document user stories for Consolidated Audit Trail (CAT) as per the technical Facilitated sponsors meeting along with product owner to understand and define Business needs and defined the scope.

Assisted Product Owner in gathering the business needs and creating & prioritizing the Product Backlog.

Participated in session for estimating the efforts required for each user stories along with Scrum team (used poker method).

Explained the technical aspects of the requirement to the product owner and assisted in the splitting of user stories and planning prioritizing the user stories for the sprints.

Tracked and logged the issues/ defects in JIRA and assigned and assigned to a responsible person. And generated status reports.

Detail understanding the business logic and defining the requirements and conversed them to the developers.

Gathering and documenting business requirements from stakeholders along with product owner.

Organizing periodic meetings to discuss requirements, status, issues, and risks between various stakeholders.

Created standards/guidelines for Business Process Modelling, Workflows, and Data Dictionary and Requirements Specifications.

Conducted GAP Analysis of the current (AS-IS) and future (TO-BE) processes to identify the requirements.

Responsible to understand and convert stakeholder needs to business requirements.

Hands on experience in creating screen-mockups for GUI, according to the requirements and provide feedback on the screen design and reviewed it with the users.

Worked with Product Owner to define product features and identify epic & user stories.

Made sure that define user stories followed the INVEST model and define Acceptance Criteria for user stories.

Participated in all Scrum ceremonies, Product Grooming and Refinement, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective.

Coordinated relationships with business & technical teams to detail user stories (requirements) to be approved for Sprint & Release plans through the SDLC.

Maintained Requirements traceability.

Acted as an Ad-hoc Scrum Master and conducted daily standups whenever required.

Tracked project progress with the help of the Burndown Chart and Burnup Chart.

Experience in creating UAT test plan document and specifying entry criteria,exit criteria, test plans, test scripts, setting up UAT environment. Logged identified and tracked UAT defects in Jira and assigned it to the responsible team.

Environment: Agile-Scrum, Jira, Mock flow, ServiceNow, MS Excel, MS PowerPoint, MS Visio, SharePoint, RTM

Client: Wells Fargo, Charlotte, NC Jan15 – Apr 17

Business Analyst

Wells Fargo is a community based financial services company with businesses including banking, insurance, investments, mortgage, and consumer and commercial finance. Currently working on the Equities Team “Consolidated Audit Trail” formed to implement CAT against OATS as per the FINRA Plan.

Role and Responsibilities:

Analyze, gather and document user stories for Consolidated Audit Trail (CAT) as per the technical specifications guide provided by FINRA for Industry Members

Design Visio Workflows to lay out end to end process flow from generating data, validating data and submitting the data to CAT Plan Processor.

Conducting discussions with Fidessa (Order Management System) to understand the process of generation of File, and with Broadridge to perform validations as per FINRA Processing Steps before submitting the files

Interviewed Regulatory Operations Users, Trade Support and Fidessa to design scenarios which will eventually be used to test the system post deployment

Performed process analysis, interviewed stakeholders and designed a flow in MS Visio to improve the process using lean six sigma techniques. Identified KPIs and measured the response time pertaining to each step-in order to remove inefficiencies. Automated three steps and identified loopholes collaborating with business and technology teams. Finally improved the process of report creation by 30% in terms of duration. Also eliminated probability of manual errors by automating the process.

Designed product backlog for Sprints, to be ready for File Submission, Data Integrity, and Industry Testing to meet CAT timeline.

Tracked stories, assigned tasks, and performed capacity planning using Rally, also tracked the burn down charts in presence of Product Owner and SME.

Created process wireframe and mockups (UI Design) for better understanding and reviews.

Coordinated with the business users, external vendors, File Transfer team and senior management to perform Program Increment Planning and backlog refinement.

Updated Test Plan, Test Scenarios, and Minutes of Meetings to SharePoint Sites in order to track and update project documentation efficiently and kept the links attached to Rally for references

Analyzed business needs and translated (documented) them into functional and technical requirements in association with SMEs and business users. Wrote stories with detailed acceptance criteria’s to validate that the solution meets the business needs

Facilitated Daily Scrum, Scrum of Scrum, Sprint Planning, Backlog Grooming, Sprint Retrospective and Demonstration meetings with internal team, and Business Users to monitor project progress using Rally

Assisted QA team to automate Functional and Performance test scenarios and designed a test methodology to ensure strict adherence to the user stories.

Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test.

Provided support for User Acceptance Testing with UAT cases and resolved issues with the users.

Environment: Agile (Scrum), Rational Requisite Pro, SQL Server 2008, MS SQL Server Management Studio 9.0, Quality Center, VBA, SAS, MS Office (MS Excel, MS Access, MS Word, MS Power Point), MS Visio.

The Finish Line Inc, Indianapolis, Indiana Mar 13 – Dec 14

Sr. Business Analyst

Finish Line Inc operates an ecommerce retail website. The transactional database driven ecommerce website is supported by an ERP system with a SQL Server back-end. The ERP system ties together different aspects of the website including inventory management, customer accounts, shopping cart, credit card processing and other ecommerce functionalities. The aim of the project was to enhance the functionalities of various existing applications linked to ecommerce and implement ATG Content Administration, a Web content managementsolution.

Role and Responsibilities:

Support requirements triage in MQC to select release specific requirements – identify relationships and dependencies between requirements, estimate technical effort and perform Impact Analysis.

Facilitated JAD sessions and design meetings with the Stakeholders, SME’s and Leads of Interfaces.

Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.

Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.

Worked with users closely to understand the content managementrequirements

Manage changes to requirements through change control -Clear case, MQC, Documentum.

Planned and defined system requirements to Wireframe with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies

Prepared use cases and functional specifications for the content managementsystem

Generated wireframes and prototype for the GUI.

Used CSS, HTML and JavaScript for GUI front end designing and validations.

Involved in Java Design and API construction, created various reusable components and API.

Used SDLC (System Development Life Cycle) methodologies like the RUP and the Waterfall.

Created business requirement documents and integrated the requirements and underlying platform functionality.

Interfaced between Business new product builders and System platform builders.

Worked with systems area to translate business needs into system requirements.

Created screen-mockups to review the requirements and provide feedback on the screen design. Also, used Microsoft Paint to create ad-hoc screen mock-up to review with the users.

Produced metrics which provide management insight into the requirements process, to include, status, size, volatility, quality, effort, etc. Visio, Rational Tools, Traceability Matrixes.

Performed after Action/Post Milestone Reviews and quality reviews to ensure that developed software products met the business needs.

Environment: Windows XP/2000, MySQL, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, JavaScript, MS Visual Source Safe, AGILE, Interwoven Test Director 7.6, Quick Test Pro (QTP)

Star Health Insurance, India Sep 12 – Feb 13

Business Systems Analyst

Role and Responsibilities:

Gathered Business Requirements, analyzed data/workflows, defined the scope, and performed GAP analysis.

Met with client groups to determine User Requirements and Goals, thus converting User Requirements into Business Requirements and User and Functional Requirement Specification.

Involved in designing and developing Data-Flow diagrams, E-R diagrams, and logical and physical database design.

Facilitated collection of Functional Requirements from system users, and prepared Business and TechnicalRequirementSpecification documents.

Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, defined milestone deliverables, and established critical success factors.

Gathered requirements during inception phase, documented and delivered functional specification documents, and assisted architecture analysis and design using UML and Rational tools.

Analyzed business and technical requirements, thus creating the Business Use Case (BUC) and Application Use Case (AUC) documents. Written Business Use Cases, Business Rules, logical analysis and change management of requirements.

Project lead (technical and functional) for stream: Correspondence. This covers various types of letters/mails/forms and checks that are dispatched from NJM premises to its policyholders and claimants.

Facilitated Joint Application Requirement (JAR) sessions to identify business rules and requirements with Business Teams.

Worked extensively with SMEs and performed Gap analysis to arrive at the gaps between current and future systems and the modules to be impacted.

Translated business functionality and opportunities into clear, precise and easy-to-read functional specifications, technical specifications with data mapping and application process flow and facilitated Joint Application Development (JAD) sessions with programmers.

Involved in creation of Data Dictionary describing data model of claim center database for WC Claims Integration and Reporting. Used Erwin to design conceptual, logical data model enforcing the data integrity and preventing use of redundant data within and between systems.

Wrote SQLQueries to create tables, stored procedures, triggers and performed data analysis, data mapping, data reporting using MicrosoftSQL Server Management Studio.

Formulated integration test plans, test cases, test scripts and executed integration testing with assistance in UAT.

Environment: Agile (Scrum), Rational Requisite Pro, SQL Server 2005, MS SQL Server Management Studio 9.0, Quality Center, VBA, SAS, MS Office (MS Excel, MS Access, MS Word, MS Power Point),MS Visio.

Education:B.D.S. from CKS Theja Dental College in Tirupati.



Contact this candidate