Rohit Rao
Bayonne,NJ
Summary
Perceptive Senior Business Analyst with 10+ years driving successful business processes for Pharmaceutical and Insurance companies. Dedicated to maximizing impact of key performance metrics to enhance and expand business operations. Known for leveraging both macro and micro-scale analyses to generate holistic images of ongoing business operations for immediate actionability.
Overview
10
10
years of professional experience
Work History
Sr. Business Analyst
Persistent A/c ThermoFisher Scientific
11.2020 - Current
- The project is a Clinical Trials Division initiative to track near real-time temperature, location and shipment milestones during the In-transit process
- The SaaS based web solution will be used by Thermo Fisher’s CTD businesses along with temperature & location data from various sensor devices and shipment carrier milestones
- Enable additional data gathering (both non-sensor event updates and active sensor tracking) and visibility capabilities unified in a single centralized platform
- Allow internal users and customers self-service tracking of the status and condition (particularly temperature) of product shipment across the distribution supply chain
- Allow for immediate intervention based on temperature trends, conditions, and excursions of a product shipment
- Responsible to accumulate and draft useful prerequisite like Functional Specification Document (FSD) and Business Requirement Documents (BRD)
- Solution to be Categorized into "Practical" and "Non-Functional" prerequisites
- Utilitarian prerequisites indicate what the arrangement should do, and Non-Functional necessity alludes to extra, Technical, Operational and Performance upgrades
- Schedule conversations to conclude in scope and out of degree prerequisites and, plan and indicate work breakdown structure (WBS)
- To foster cycle models and undeniable level information model, for example, Entity Relationship outlines
- Conduct Market examination to decide whether Partnering, combining or stripping are practical choices to address business needs
- Perform hole examination among current and future state, evaluate alternatives for accomplishing future state and suggest most elevated worth methodology
- Understand all the present status components and incorporate those with the arrangement to make it compelling
- Design and foster a useful model to approve the viability of the arrangement (Proof of Concept/PoC)
- Conducted JAD meetings to accumulate and report business necessities
- Work intimately with Architect group and draft possible Techno-Functional engineering configuration reports
- Prepare configuration records like HLDs (High Level Design) and LLDs (Low Level Design) with the assistance of UML (Unified Modelling language) outlines, for example, Entity Relationship graph, Class chart, Sequence graph, Data Flow chart.
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
- Guided teams and refined Agile techniques throughout journey and evolution of delivery cycles, establishing documentation framework to support Agile methodology implementation with Waterfall-centric delivery team.
- Developed diverse reporting packages to meet individual needs of sales, marketing, product management and senior leadership.
- Created new analytical systems to boost vital business metrics visibility.
- Executed analysis of risks and identified risk mitigation strategies.
- Identified process inefficiencies through gap analysis and outlined sensible solutions.
Sr. Business Analyst
Persistent Systems A/c Colonial Surety
Jersey City, NJ
03.2020 - 11.2020
- Building digital Insurance product (Property and Casualty) platform for customers to purchase Insurance policies in real time
- Primary purpose is to offer its Customers 24*7 anywhere, anytime digital access to purchase as well manage insurance policy transactions using any digital channels e.g. Website, Mobile App or other media devices
- Products: Professional Liability, Cyber Liability, EPLI, General Liability, Business Owners Policy
- Work closely with stakeholders to identify requirements and specify accurate business needs that must be addressed by the solution
- Solution to be Categorized into “Functional” and “Non-Functional” requirements
- Functional requirements specify what solution must do, and Non-Functional requirement refers to additional, Technical, Operational and Performance improvements
- Schedule discussions to finalize in scope and out of scope requirements and , schedule and specify work breakdown structure (WBS)
- To develop process models and high-level data model such as Entity Relationship diagrams
- Understand current state elements and integrate those with solution in order to make it effective
- Extend or modify system to serve new purposes or automate workflow
- Work towards backend integration to support new front- end features
- Prepare test strategy, test procedures and test data documentation
- Document functional test cases describing main and alternate workflows
- Document non-functional test cases describing performance parameters
- Measure test coverage using code coverage tools
- Execute functional & non-functional test cases
- Validate functional & non-functional test case results meet acceptance criteria
- Record the deviations & observations at each step and report them in defect tracking tools
- Detailed analysis of the state filings and proposing solution to the client
- Functional Mapping exercise for ERC+ software, ISO products
- Understanding of ERC+ and ISO Net applications from Verisk and correlate between Colonial State filing requirement till ERC+ application solution
- Prioritize the deviations & defect and track them until closure.
Sr. Business Analyst
AIG Insurance
Houston, TX
06.2019 - 03.2020
- Participated in usability testing meetings and created a tracker to document users’ feedbacks, provide solutions and presented those to the project team
- Involve in post-implementation training and support
- Conducting gap analysis and audience analysis to recognize the end users of the product
- Experience in creating user manuals and other training documents
- Author end-user questionnaires to ensure that product users understand the product functionalities
- Work closely with the UI team to model the screens, which met user, defined requirements and also company standards
- Diagrams to represent information provided by the Business Owners
- Work with Client to gather information about the documents and business processes
- Conduct Brainstorming session with management, vendors, users and other stakeholders for the open and pending issue and come up with a solution
- Reviewed test results and coordinated with the testing, development team and marketing user to correct the issues
- Created data mapping documents for the migration of data from transactional OLTP database to OLAP databases of Property & Casualty related policy and claim data to different environments while enhancing the system
- Created PL/SQL Procedures to implement Property & Casualty related business logics and created database objects like Tables, Stored procedures, indexes, Sequences, Views and rules etc
- Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing
- Interact with business associates and help them to recognize the need for preparation leading up to activation/implementation and how to add that into the effort deliverables
- Work as a liaison in an Agile environment between technology and the business clients to improve business processes and support critical business strategies
- Worked with SME’s of different groups to gain detailed knowledge of Investments and Capital Market and to understand the cross impacts of the system
- Strong Knowledge on Guide wire Configuration, Integration, Rating and Conversion & Guidewire Implementation for Property and Casualty Lines of Business
- Extensive Understanding & Experience of Migrating Insurance Suite Solutions to Guidewire Solutions & Experienced in Implementing Guide wire Policy Centre And Claim Centre
- Experience working with Duck Creek PAS (Policy Administration System) Suite
- Involved in generating Test cases for Property and Casualty Insurances for Different Levels of Business
- Interviewed area experts or SME’s asking detailed questions and carefully recorded the requirements in a format that can be reviewed and understood by both business and technical team
- Utilized data flow diagrams, use case diagrams and process flow
- Create knowledge management articles for the claim handlers, claim representatives and agents to enable them to serve the policyholders effectively
- Supported rapid turnaround for ad-hoc analysis, developed use cases, researched and resolved issues
- Demonstrated experience in conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance
- Performed data integration and data mapping management along with data cleansing while migrating data from legacy system to Guide wire Policy Center
- Strong Knowledge on Guide wire Configuration, Integration, Rating and Conversion & Guidewire Implementation for Property and Casualty Lines of Business
- Researched and Analyzed business needs and ways to improve property and casualty specifically policy contracts and processes administration
- Worked with Guide wire Claim Center's rich functional depth to end-to-end claims lifecycle management improvements and gathered requirements around Underwriting, Billing, Insurance Claims Processing and Policy Administration System
- Testing Mainframe applications for modifications made
- Analyzed the existing business process flows for Equities and Derivatives to gain understanding of the existing system and documented the business process flows for the proposed system
- Business flows documented contained information flowing from upstream applications to the downstream applications and any impact made using GUI by the users
Business Data Analyst
US Bank
New York, NY
01.2019 - 05.2019
- The scope of the project is to build data driven strategies to support business operations
- The goals were to produce to assist senior management for more effective decision making on CCAR regulatory reporting
- Analyses of various fixed income trading, data requirements and validate data sourced from various Bank databases; implementation of KYC/AML/BASEL regulations and agile methodology is used through all phases of the project
- Analyzed and Documented Business Requirement Document (BRD), Functional Specification Documentation, and System Requirement Documentation, using UML methodologies
- Experienced with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act
- Executed all aspects of business analysis, reporting, database management, and financial analysis
- Conducting Smoke Testing, UAT testing, User Interface testing, functional testing, Integration testing, Regression testing, Back- end testing, UI testing, Parallel testing, Rules testing
- Ensuring efficient and effective project delivery through the use of project meetings, follow-ups, detailed and well thought out schedule/planning efforts, identification of risks and escalation points, and the production of quality project artifacts
- Interacting with the business users to gather requirements based on the CCAR Regulation for Financial Statements, Interest Rate, Credit Ratings, FRY9C and Investment Securities
- Conducted User Acceptance Testing (UAT) to ensure all the business requirements have been fulfilled by the application
- Involved in development phase meetings for Business Analysis and Requirements Gathering
- Created functional specifications requirements for reconciliations of FR Y-14A and FR Y-14Q reports
- Developing and maintaining effective working relationships within the Compliance department and with other internal and external stakeholders
- Liaised with institutional investors and private banks for derivatives product and service retailing
- Prepared project plan for building ORACLE database and implementing ETL and constantly updated SharePoint site
- Participated in Regulatory Reporting and CCAR teams and assisted the team with their data needs and performed UAT tests on their new models
- Implement tactical and strategic solutions to remediate data quality issues and ensure accurate trade reporting
- Updated Data mapping documents and business requirement documents based on database changes, business rules or selection criteria
- Provided support to the Derivatives desk such as investigations, adjustments to trades, manual EV uploads, etc
- Knowledge of Commercial Lending Systems like Loan IQ
- Familiarity with Consumer Lending Processes
- Thorough knowledge of financial and investment management industry in diverse areas such as Risk management and analyses, Portfolio management, Fund accounting, Fixed income instruments, MBS, and amongst other major aspects of Investment Banking and Investment Management
- Work closely with accounting team in month-end closing, forecasting, monthly accruals, fixed asset management (depreciation), capitalization, and other key issues as they rise to minimize risks and variance to plan, forecast, and target
Business Analyst
ABB India Limited
Bengaluru, Karnataka
12.2011 - 12.2017
- Expertise in engaging closely with the development team to verify that business needs are fulfilled and deliverables are produced within specified budget, quality and time
- Expert in elicitation of with business requirements with enterprise wide cross-functional business units
- Responsible for motivating and mentoring Agile best practices for multiple Scrum teams, product owners and stakeholders within the Development organization
- In-depth knowledge and experience of analysing AS-IS business process, creating To-Be business process, conducting feasibility study, cost benefit Analysis and risk analysis
- Worked in all Scrum Master responsibilities like facilitating Scrum Ceremonies of Sprint Planning, Sprint Review, Daily Scrum, Sprint Retrospective
- Facilitated scrum ceremonies, creating tasks by using SMART criteria, story mapping, coached team to be self-organized and on agile principles, logged and resolved impediments, adept at conflict management and resolution
- Worked on the entire life cycle for requirements management - identifying, defining and delivering the requirements
- Assisting in creating Project Plan, Road Map and participating in Feasibility and Estimation meetings along with business owners and architects
- Gathered requirements by conducting interviews with end users, identified, defined and mapped the business rules to business requirements
- Metrics tracked are Velocity, daily burned hours, committed vs Delivered velocity, Story and task progress status, Impediments & Defects/Bugs Raised per Sprint
- Facilitated Scrum ceremonies & created burn-up & burn-down for higher management reporting
- Scheduled and facilitated Sprint Planning, Daily Stand-Up, managed Sprint Demo & Sprint Retrospective meetings
- Ensuring story has enough detail, story points, dependency and relationship using agile tool JIRA
- Performed Gap Analysis of Business rules, Business and system Flow
- Prepared Use Cases, functional & system requirement specifications along with other supportive documents like process models, data flow diagrams, screen mock ups and UML diagrams
- Conducted Joint application development (JAD) sessions with stakeholders throughout System Development Life Cycle (SDLC) to resolve any open Issues
- Identifying subject-matter experts from business users’ end and driving the product backlog meetings
- Generating user stories with the business users
- Creating user stories with detailed acceptance criteria (Customer satisfaction criteria) to elicit clear and deliverable business needs as an Agile Business Analyst
- Conducting Sprint planning meetings with technical team and business users, to prioritize the user stories for particular stories for the Sprint
- Contributing to the product refinement sessions by assessing the business points and story points to prioritize the user stories
- Dig the requirements with Regulatory Head for the Pre-analysis and find the Gaps for the Mandates to match the CFTC guidelines
- Participating in the sprint retrospective meetings to analyze the team’s capacity
- Expert in breaking down the epics, categorizing the themes and story mapping of user stories
- Mapping system requirements with Test Cases, manually executed test cases in QC, ensured traceability of Test Cases back to the Business Requirements
- Built out a state-of-the-art data front end trading system and data warehouse, bond pricing, and analytic engine for Fixed Income and credit derivatives
- Prepared user guides and performed UAT with Business Users as and when deliverables were deployed by technical team and uncover the latent defects in the system
- Implemented data access, storage and validation routines on the database server using SQL
- Involving programmers and quality assurance team in conducting stress test and load test
- Effectively handling sign off process with stakeholders at different levels and executing good conflict resolution approaches
- Reporting status, milestones, and project plan tracking to project management on a weekly basis.
Education
Master of Science (MS) - Management Information Systems
Pace University
Manhattan, NY05.2019
B.E - Electrical Engineering
Pune University
India09.2010
Skills
- User Acceptance Testing (UAT)
- Business Process Mapping
- Predictive Modeling
- Data Warehousing
- SQL
- Tableau
- User Expectations
- Agile and Scrum Environments
- Identifying Risks
- Process Flow Diagram Creation(MS Visio)
- R, Python
- Data and Analytics
- SDLC Methodology
- Requirement Management(JIRA)
- REST API
Websites
Timeline
Sr. Business Analyst
Persistent A/c ThermoFisher Scientific
11.2020 - Current
Sr. Business Analyst
Persistent Systems A/c Colonial Surety
03.2020 - 11.2020
Sr. Business Analyst
AIG Insurance
06.2019 - 03.2020
Business Data Analyst
US Bank
01.2019 - 05.2019
Business Analyst
ABB India Limited
12.2011 - 12.2017
Master of Science (MS) - Management Information Systems
Pace University
B.E - Electrical Engineering
Pune University
Similar Profiles
Christine GlodyChristine Glody
Inventory Analyst II at Cole-Parmer (Division of Antylia Scientific formerly ThermoFisher Scientific)Inventory Analyst II at Cole-Parmer (Division of Antylia Scientific formerly ThermoFisher Scientific)
ROHAN SHAHROHAN SHAH
Processing Technologist at Thermofisher ScientificProcessing Technologist at Thermofisher Scientific
KATHERINE REMERKATHERINE REMER
Customer Service Representative at Thermofisher ScientificCustomer Service Representative at Thermofisher Scientific
RICHARD ELMORRYRICHARD ELMORRY
Recreation Therapist at Optima Care Castle HillRecreation Therapist at Optima Care Castle Hill
Halelyah ThomasHalelyah Thomas
General Manager at Cool Sips LLCGeneral Manager at Cool Sips LLC