Business Analyst Data

Nimesh Prajapat

Business Analyst

Email : ******************@*****.*** Mobile : 732-***-****)

LinkedIn: https://www.linkedin.com/in/nimesh-pba/

SUMMARY:

•Over 10 years of Experience as Business Analyst in IT industry domain Healthcare, Banking, Financial, Insurance include understanding of Business Requirement Gathering, Business Analysis, Joint Application Development (JAD) sessions with clients and referring to accessible documentation and procedure.

•Worked on all phases of Software Development Life Cycle (SDLC) possesses expertise to validate and test multi-tier, scalable, web-enabled business applications include Regression Testing and User Acceptance Testing.

•Expertise in creating project artifacts such as Business Requirements Document (BRD), Use Case Documentation, Requirements Traceability Matrix (RTM), Business Rules Spreadsheet (BRS), Functional Requirements Document (FRD), Data Mapping Document, and Systems Requirements Specification.

•Excellent experience in performing gap analysis for large and complex applications and extensively used MS Visio, MS PowerPoint, MS Excel, MS Word and MS outlook.

•Agile project experience in delivering Process Models, writing user stories, prototyping, journey, use cases and activity diagram.

•Experience communicating with Subject Matter Experts (SMEs) and Clients (business users) in performing requirements gathering, business analysis, data analysis and documentation.

•Experience in SQL queries for data validation at backend in SQL.

•Good Working Knowledge of HIPAA Regulations and Medicare Claims Processing.

•Knowledge of managed claims management process, Knowledge of Medicaid and Medicare Services. Health Assessment Systems, HL7 Standards, HIPAA, PPACA (Patient Protection and Affordable Care Act), Compliance issues, LOINC and SNOMED Mapping, HL7 Message Validation, ICD 9, Electronic Health Records, Electronic Medical Records.

•Trained in Test Case walk through of the Business and Development team to fetch feedback and approval sign-off.

•Experience in Using JIRA, MIRO, MS Azure board for User Story requirements management throughout the Agile Sprints and product development life cycle.

•Experience with various elicitation techniques and JAD sessions for requirement gathering for migration of legacy application with new functionality.

•Strong knowledge of Use Cases, and Activity Diagrams.

•Proficient in design and execution of Test Strategy, Test Plan, Test Scenarios, and Test Cases based on the requirements for the applications.

•Hands-on in using SQL queries to perform Data Analysis and Data Mapping on Oracle & Microsoft SQL Server Databases.

•Experience writing Use cases and producing Use Case Model, Analysis model, Behavior diagrams (Sequence diagrams, Collaboration diagrams) and Class diagrams based on UML Methodology & Business process flow diagrams using MS Visio.

•Good understanding of Agile (Scrum) software development lifecycle includes sprint planning meeting and sprint backlog, scrum meetings, daily stand up and Retrospective.

•Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.

•Excellent skills in Project and Performance Management to support Strategic Planning, Goal Setting, Strengthen Accountability, Enhance Decision Making, and Improve Customer Service.

TECHNICAL SKILLS:

Methodologies

Joint Application Development (JAD), Rational unified Process(RUP), UML, Waterfall, Spiral, Rapid Application Development (RAD), SDLC Policies

Business Modeling Tools

MS Visio, Rational Rose, Business Process Modelling Notation (BPMN), Unified Modelling Language Diagrams (UML), SharePoint.

Project Management Tools

JIRA, MIRO, MS Project, Power BI, Tableau

Statistical and Database Management Software

MS Access, Oracle, SAS, SQL

Defect tracking tools

JIRA, Power BI, Bug Host, Clear Quest, Version Control Systems, Microsoft Visio.

CRM

Sales force, Smart Office

Languages

Python, HTML, C, Visual Basic

Work Experience:

Client: Marriott Int., MD Nov 2021 – Present

Role: Business Analyst

Responsibilities:

Involved in defining the scope and implementing business rules of the project, gathering business requirements and documentation.

Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.

Created SAS dataset from tables in Database using SAS/Access. Retrieved the data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.

Develop and maintain client profiles including analysis of present position and creation of balance sheet and net worth statement. Ensure risk profiles, goals, objectives and asset allocations are appropriate.

Functionality enhancement for the new eligible employees for the annuity life insurance. And new rules for the retirement benefits.

Setup the general guidelines of the new benefits that wear organization decided to offer for the future retirement.

Review and monitor operating reports, annual audited financial statements and tax returns to evaluate asset performance.

Prepare written internal and external reports such as risk assessments, watchlist write-ups, portfolio management plans, operational analyses, and routine updates.

Represent the company showcase portfolio from the past investment for future expansion of the organization.

Deliver full range of Goals -Based Wealth Management strategies and tools and leverage specialists as appropriate.

Partner with internal specialists (e.g., W M bankers, Retirement specialists, PBIG, Trust and Insurance experts) and external advisors to deliver holistic goals-based financial solutions

Identify and establish target niche client segments and establish a strong reputation within those markets, as well as the designations to support the practice’s specialization

Identified and clearly defined functional issues and support IT development staff throughout the design, development, unit testing, and implementation phases of the software development life cycle (SDLC).

Understand the As Is system and develop the To Be system concept and prepare the System Process Maps.

Working along with Software Development Engineer in Test (SDET) team and is responsible for developing and executing comprehensive suites of automation test plans and test cases.

Handling the middle office requirement from the non stake holder where a variety of IT, compliance and risk management tasks need to perform.

Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.

Interfaced with business user s to verify business rules and communicated changes to ETL development team.

Tested Complex ETL Mappings and Sessions based on business user requirements and business rule to load data froom source flat files and RDBMS tables to target tables.

Business Analysis reports development efforts by working closely with Micro strategy and ETL teams.

Enterprise narrow track traceability of the features that need to go live on world wild via MS Power BI.

Creating the dashboard via tool Power BI for having all team on same page for track progress of the PI planning.

Involved in all phases of Software Development Life Cycle (SDLC) and implemented multiple product development initiatives.

Generate the test cases for the annuity life protection functionality for the team.

Wrote complex SQL query and store procedure pull the required data from POSTGRE's database and feed into Tableausoftware for analysis purpose.

Wrote Test Cases and performed User Acceptance Testing, documented the in-detail defects using the Defect Tracking report.

•Involved in compatibility testing with other software programs, hardware, Operating systems and network environments.

Client: General Electric, MA Feb 2019 – Aug 2021

Role: Business Analyst / Back office

Responsibilities:

Interacted with clients to finalize the Business Requirements for the application and involved with Business Process Analysis.

Part of the couple of other team project with their sub client on fulfillment the business requirement.

Performed the Requirement Analysis and documented the structured requirements management and Business Process management.

Align the enterprise portal for the daily news and migration of global world.

As a middle office work was responsible to performed risk management, information technology, accounting, and legal support.

Responsible to extract specific data set from Operation database ODS by using PL/SQL query to data cleansing process and new feed processing purpose.

Derived As-Is and To-Be Scenarios and performed Gap Analysis and Impact Analysis.

Worked on government business requirement fulfillment for the client to track progress of the project.

Involved in ETL specification designing for incoming feed coming from various data source and Data manipulation on it.

Develop source-to-target mapping documents by analyzing data content and physical data.

Perform daily back office work that need to collaborate in the joint application development to mimic the legacy system.

Good Knowledge of Data Warehouse Architecture and Designing Star Schema, Snowflake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling.

Responsible for Integration of Legacy system to load legacy data set and incoming new data feed for TA and data.

Manage requirement with the help of Rational Requisite Pro.

Analyzed system requirements, developed detailed Test Plan, Test Cases, and test scripts for testing the functionality, GUI, and security.

Produced the visual models for the application using Rational Rose to create Use Cases, State Charts, Sequence Diagrams and Activity Diagrams.

Performed Risk Analysis of the requirements to identify the key business risk areas for the project and prioritized the application development and testing.

Facilitated weekly meetings with the review teams to improve the QA process.

Used PowerPoint presentations for conducting walkthroughs with the stakeholders.

Client: Rite Aid, NJ Dec 2016 – Dec2018

Role: Business Analyst

Responsibilities:

Prepared the Functional Specification Document FSD and Software Requirement Specifications SRS as per SEI-CMM standards.

Conducted the JAD Sessions with stakeholders and developers to have a clear picture of a project.

Conducted interviews with key stakeholders to analyze existing data and gather requirements.

Used UML to create use case diagrams, sequence diagrams and activity diagrams

Worked on improvement of Claims Reimbursement User Interface for a better experience and incorporate changes as per HIPAA 4010 /5010 guidelines using the gap analysis.

Prepared FHIR guidelines for EMS disaster management.

Developed flowchart and process diagram using MS Visio.

Wrote SQL scripts for creating performance evaluation reports

Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly.

Performed Backend testing by using PL/SQL queries to test the integrity of the application was in regular contact with Business partners on the status of issues, action plans and timeframe for resolution throughout the development cycle.

Identified bugs during the test phase and reported them using HP Quality Center.

Maintained Traceability Matrix throughout the project.

Developed Test Cases and Test Plans on the basis of requirements and also did manual testing of the functionality of the application to ensure that the application is able to handle a lot of data

Conduct Presentations periodically to the management and end users during various phases of Software Development Life Cycle SDLC.

knowledge of HL7, Fast Healthcare Resources, Consolidated Clinical Document Architecture (CCDA) interfacing/challenges of data exchanges via import/export.

Extensively Knowledge in the Member Enrollment and Billing information.

Knowledge and Experience on Membership, Billing, Claims Payment Processing in relation to HIPAA,EDI 4010, 5010 X12, ICD-9 ICD-10, codes 834, 837,835, and 270, 271.

Worked on HIPAA EDI transactions such as 835(medical claim payments), 837(medical claims), 276(claim status), 277(claim status response), 278(Health care service review information), 270(eligibility inquiry), 271 (eligibility response).

Conducted UAT, documented and reported user feedbacks to management team, and developed training materials for different end users and assisted in users training for the new system.

Gathering requirements for a data collection and reporting system

Researching various topics, scheduling meetings and documenting meeting minutes.

Analyze patient accounts and clarify any information needed to correctly answer patient's questions regarding their account.

Performing application support monitoring system interfaces, generating reports, researching data issues, documenting support requests.

Client: Daiwa Capital Markets, NY Sept 2014 – Nov 2016

Role: Business Analyst/ Data Analyst

Responsibilities:

Effectively elicited requirements from stake holders and facilitated communication between Business and the Technical team.

Create and manage internal and external communication initiatives across business lines and clients

Responsible for multiple back office analytical functions across the derivatives trading desk.

Identify and assess new and existing risk and elevate any concerns to Capital Markets Senior Management to mitigate bank exposure or potential loss.

Lead various process improvement projects within Capital Markets and ensure timely and accurate

results of all project deliverables.

Created and maintained project tasks in Jira, providing daily status reports to project and senior level management.

Successfully implemented Jira as the project and task management tool of choice for IT, Marketing and other business units.

Created and implemented a process for Incident and Change management utilizing Jira and Jira Service Desk.

Co-managed all aspects of ecommerce within our company, ensuring all projects were done on time to maximize sales revenue.

Involved in the customization of the Salesforce app using Lightning resources.

Used the data files provided to load data from the legacy system to the new salesforce instance.

Worked on Agile and Scrum Methodology for Salesforce lightning implementation.

Collected detailed requirements for ecommerce systems including our B2C websites, eBay store, YouTube channel and mobile properties.

Trained users on new and existing functionality within the CRM tool.

Build Salesforce reports and dashboards, customizing them as per user requirements.

Performing Salesforce administration related to new users’ setup and role update.

Assist in entering and updating Issues (Epics, Stories, and Tasks) into JIRA Agile application.

Used Swagger and Postman for Rest web services testing.

Modified existing applications to a suite of microservices and all microservices to facilitate deployment using Junit frameworks for unit testing.

Experienced first-hand the best/worst practices for integrating microservices into an existing system architecture.

Designed and developed customer, messaging, appointment, product microservices complete with discovery registration code.

Draft daily hedge strategy reports detailing market analysis, adjusted portfolio coverage and executed trades during the day to brief the Director of Capital Markets and COO/CAO of the organization.

Handling request of Front Office partners to ensure as part of middle office projections correspond with trader estimates while substantiating any discrepancies that may rise.

As a part of middle office admin responsible for managing risk and corporate strategy, and the back office provides analysis, technical, and administrative support services.

Design, Integrate and implement controls to prevent operating exposures and increase business improvements in Capital Markets area.

Involved in UI requirements and creating Wireframes to help developers build the application

Assisted in analysing the various data feeds from different sources upstream and downstream eCommerce / PM for Marketing initiatives including email campaigns and online content for product promotions.

Developing training materials for Scrum Masters to use in facilitating Agile ceremonies.

Presenting training materials and mentoring Agile teams on Scrum best practices.

Documented and analysed SQL queries against various databases and generate reports as per company requirements and exporting to Excel for presentation to upper management.

Created adhoc reports on Tableau to determine campaign spend based on impressions, ad type, publisher type, and device type.

Played a key role in the planning, testing, and implementation of the new enhancements and conversions.

Client: Wockhardt Health, India Jan 2012 – Jun 2014

Role: Data Analyst / QA

Responsibilities:

Establish program level processes, execution and continuous improvement of Agile process for the team and project.

Conducting training for teams on team collaboration and effective use of confluence.

Configuring Microsoft Azure as a cloud service provider for project requirements.

Creating Functional test cases and execution of test cases in the ALM tool.

Working with MS Office Suite for preparing status reports.

Coordinated with the developers and IT architects to design the interface of the new system according to the X12 (270, 276, 278, 834, 837 (I, P, D) and 820) standards.

Creating business process flow diagrams and charts using MS Visio.

Integration of genomic database access credentials with client Identity, access and compliance solutions.

Assure compliance with project timelines, identify impediments to progress and create solutions to increase project velocities.

Drove Scrum team progress to overcome obstacles and realize success throughout the life of each sprint.

Escalating risks and issues that impact scope and timelines in Scrum of Scrums.

Motivate team players with excellent business, analytical, communication, presentation, and management, technical and written skills.

EDUCATIONS:

MBA Institute of Management and Research, Jalgaon, MH, India – June 2011

B.Com. Arts Commerce and Science College, Navapur, MH, India – July 2008

Contact this candidate