Name: Prani
Email: kartheek@techsmartglobal.com
phone:732-313-2517
Title: Sr Business Analyst
SUMMARY OF PROFESSIONAL SKILLS:
· Business Analyst with excellent understanding of Business Requirement gathering, Business Analysis, Business Process Model and Notation (BPMN).
· Well versed in generating and evaluating Functional Requirement Documents (FRD), Business Requirement Documents (BRD), and Work Breakdown Structure (WBS).
· Experience in using business modeling tools like MS Visio and Unified Modeling Language (UML) for creating Use Case Diagrams, Business Process Models, Process Flow Diagrams, Class Diagrams, and Activity Diagrams, Sequence Diagrams, and workflow diagrams.
· Have knowledge on in the process definition and potential reengineering followed by design, build, test and deployment of the RPA solution
· Broad knowledge of business processes, with hands on experience on Software development Life Cycle (SDLC) and Provide developers with appropriate documentation and coordinate project execution.
· Strong Project Management skills including planning, scheduling, monitoring, and budgeting with proficiency in MS Project for planning & reporting.
· Theoretical knowledge on how the UiPath offers a user-friendly dashboard with simple drag-and-drop functionalities like how UiPath doesn’t require any programming language knowledge which makes the RPA functionalities in a much simpler way than any other RPA tools whereas BluePrism needs a basis of programming to manage the business objects
· Good knowledge on other RPM tools like Automation Anywhere.
· Excellent understanding of Data services, Data ETL using SQL query tools and applications.
· Conduct data analysis to ensure accuracy and write SQL queries for testing of integration services
· 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.
· Design and implementation knowledge of process-automation. In addition, have knowledge of RPA tools like Blue Prism, Automation Anywhere, is an added advantage.
· Strong experience in RUP Business Modeling process, complete UML artifacts related to Business Modeling, Requirement Elicitation, Analysis, Specification, Traceability, Validation and Verification.
· Performed GAP Analysis, SWOT Analysis, User Acceptance Testing (UAT) and Cost Benefit Analysis.
· Proficient in design and execution of Test Strategy, Test Plan, Test Scenarios, and Test Cases based on the requirements for the applications.
· Designed solutions using RPA best practice and maintain technical responsibility for project delivery and an ability to develop RPA prototypes and Proofs of Concept
· Experience in Develop, Review, Execute, Maintain Test Plans, Test Cases, Test Procedures and Traceability Matrix. Experience conducting JAD (Joint Application Development) sessions with Stakeholders and Business Partners to resolve issues.
· Ability to support and sustain a positive work environment that fosters team performance with effective communication and client relationship development and Team Leader skills.
SKILLS:
Languages: Java, .net, SQL
BI Tools: Power BI, Tableau
Requirement & UX: Backlog grooming, Data Modeling
Microsoft Office: Word, Excel, MS Access, Visio, Outlook, PowerPoint
Project Methodologies SDLC, Agile, Waterfall
Databases: MySQL, DB2, MS-Access 2012, Teradata
PM Tools: MS project, MS SharePoint
CERTIFICATIONS:
Certified Scrum Master
Certified Business Analysis Professional
Certified Software Quality Analyst
PROFESSIONAL EXPERIENCE:
Delta Dental of Michigan, Michigan Jan 2021 – Present
Business Analyst
Project: Worked with claims team which deals with customer insurance claims. This system allows to send the reminders via Text messages, Phone call and email Id and also include Healthcare Lines of Business, Products, Claims Processing, Claims Pricing, EDI and Mandates experience.
● Prepared documents for Business Requirements Document, Systems Requirements Specification, High-Level Design Documents, and traceability mapping/matrix with the assistance from the business group, and the IT team members.
● Gather Business Requirements using different requirement techniques like interviews, surveys, use case outlines and brainstorming and participated in REMS (Risk Evaluation and Mitigation Strategy)
● Functioned as the primary liaison between the business stakeholders, operations, and the development team throughout the project cycle.
● Gained extensive knowledge and understanding of MITA, MMIS, Electronic Medical Health Record EMHR and Pharmacy Benefit Management PBM.
● Worked with Prescriber Border State regulation of MA - Health connector and HIE related to pharmacy.
● Experience in Informatica Code migration through Copy Folder/Export and Import of Objects/ Deployment groups and Tracking on-going Informatica Platform issues via JIRA/Confluence.
● Querying the Informatica Metadata tables depends on the business requirement.
● Involved in the creation and maintenance of the workflow plans and artifacts
● Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and creation of technical design (UI screen) using MS
● Involved in full life cycle of Business Objects reporting Application.
● Responsible for identifying the scope for Medicaid & Medicare (Part A, B, D) projects. Gathered business requirements for Patient Pay Amount, Covered Plan Paid Amount (CPP), Non-Covered Plan Paid Amount (NPP) and documented them.
● Knowledge with one or more RPA technologies such as UiPath, automation Anywhere, or BluePrism, where Blue prism can automate back-office operations and Ui-Path and automation anywhere work on both front and back-office automation.
● Implemented RPA that include process definition (and potential re-engineering) followed by design, build, test and deployment of the RPA solution
● Designed and implemented basic SQL queries for testing and report/data validation
● Access full range of Thunderhead Resources to build letter templates and packs within Thunderhead in line with the business requirement and Experience with Epic Healthcare Information Systems.
● Documents – Ensure group benefit booklets, contract documents, Summary of Benefits and Coverage, renewal and various letters are favorable to group relations and compliant with all corporate legal requirements.
● Knowledge on UiPath, which is one of the RPA tools that is used on the Windows desktop for automation. This UiPath tool helps in removing human intervention by automating repetitive or redundant tasks.
● Configuring new RPA processes and objects using core workflow principles that are efficient, well structured, maintainable, and easy to understand
● Knowledge on the UiPath which is relatively code-free language and UiPath promotes operational costs by reducing manpower.
● Expert in analysis, design, development, and implementation of Business Intelligence (BI) solutions focused on streamlining data for operational, functional, and enterprise level reporting.
● Work with Business Intelligence tools such as QlikView and Business Objects to develop reports and provide data to stakeholders
● Assist with training of on-site QNXT configuration team on applications and best practices.
● Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems were impacted by the EDI X12 Transaction, Code Set and Identifier Aspects of HIPAA.
● Knowledge on how BluePrism offers drag and drop features for automating processes and facilitates accuracy by eliminating clerical errors.
● Created Business Requirement Document and Functional Requirement Document. Created Use Cases, Use Case Diagram, Activity Diagram, and other Flow Charts to define the business process.
● Facilitated Joint Application Development sessions with end user, expert team, business intelligence team, SME's, QA team, Walk Through and Signoff with Stakeholders as required.
● Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
● Designed and development Test Cases based on functional requirements for institutional and professional claims for EDI and HIPAA transactions 837/835, 834, 276/277, 270/271 testing.
● Performed System testing of the Claims processing systems (Pricing Rules, Duplicate/Limits validation, Member Eligibility, Provider Enrollment, et al).
● Experience producing ETL/ELT using SQL Server Integration Services.
● Conducted business-impact assessment and the results were compared with the new HIPAA 5010 standards to determine the current level of compliance and developed an action plan for approval by the project steering committee.
● Developed plan for data feeds and data mappings for integration between various systems, including XML, to follow ICD-10 Code Set and ANSI X12 5010 formats.
Environment: Agile, MSOffice, SharePoint Server office 365/2013/2010, Visual Studio, MS Project, Git, MS Visio, UAT (User Acceptance Test Environment), HTML, Tableau, Ninja SAS, SQL Server, JavaScript, Azure Devops, Jenkins
Ca lamp, CA March 2020 –Dec 2020
Business Analyst
Project: Migrating Monolithic applications to micro services and Enhancement to the Management System and Validation transactions
● Documented business process and analyzed procedures to see that they would meet required business needs.
● Created Use Case diagrams, use cases and Activity diagrams by using MS Visio and Conducted GAP Analysis and further developed process mapping for future business needs.
● Planning, developing and implanting strategies in long-term and short-term projects to meet business goals.
● Created Test Conditions from business requirement document and functional requirement document.
● Validated Professional and Institutional Subscriber Counts data, Processed and Adjudicated the Subscriber Counts data according to test scenarios.
● Worked as a point of communication to stakeholders to give relevant project information.
● Presented fundamental and deployment strategies a self-sufficient, automated data center to senior management.
● Wrote SQL scripts for creating performance evaluation reports
● 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.
● Gathered business requirements, analyzed data/workflows, and defined the scope, financial projections, and cost/benefit analysis.
● Designed dynamic client-side JavaScript codes to build web forms and simulate process for web application, page navigation
● Highly skilled in integrating data from a variety of sources. Experienced working within and leading multifunctional teams tasked with delivering custom Business Intelligence (BI) solutions.
● expertise in using Client - Side development technologies like JavaScript, JQuery, AngularJS, Ajax, Web-Based and Rest style services.
● Identify areas of improvement within QNXT and write and submit PDRs to TriZetto.
● Analyze and develop gap and custom solutions when QNXT system cannot meet required business need.
● hands on experience in developing web-based applications using JavaScript, JQuery, AJAX and AngularJS
● Documented Sequence Diagrams and Logical views using MS Visio for clear understanding of the requirements by the development team.
● Identify new business intelligence tools and technologies
● Background in data documentation including data/process flow diagrams, data narratives, data dictionaries, including proficiency in Microsoft Visio/Excel
● Validated Requirement Traceability Matrix (RTM) and to manage all day-to-day activities for the project including status, schedule, and risks for the entire project across all involved groups.
● Developed prototype of new information processing application. Met with client groups to determine User Requirements and Goals and thus converted User Requirements into Business Requirements.
● Responsible for creating UML Modeling Plans, Use Cases, Process Flows, Wire Frames, and business requirements documentation using MS Visio.
● Conducted functional requirement reviews and walkthroughs with the designers, developers, and stakeholders and coordinated for daily backup procedures.
● Conducted sign-off meetings with IT teams to lock down the requirements. Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other.
● Worked with Web publishing and Web content lifecycles.
Environment: Agile, MSOffice, SharePoint Server office 365/2013/2010, Visual Studio, MS Project, Git, MS Visio, UAT (User Acceptance Test Environment), HTML, TOAD, Ninja SAS, SQL Server, JavaScript, Azure Devops, Jenkins
Client: ADP, Pune, India July 2017 –July 2019
Business Analyst
Project: A leave management system is an all-in-one platform that handles all employee vacation requests while ensuring smooth functioning of their operations.
· Developed Business Requirements Document and Functional Requirements Document.
· Participated in Joint Application Development sessions, One-on-One Interviews and Phone Conferences by convening project sponsors, end-user representatives, development team members, subject-matter experts, technical personnel, and different stakeholders to communicate their perspectives with each other, resolve any issues and come to consensus.
· Interaction with operational staff at all levels in gathering requirements relating to application design.
· Interacted with Technical team to understand Operational and Technical functions of the existing Cap leakage control.
· Created high quality functional requirement specifications and supporting documents for business.
· Under general direction, gathered, defined, and documented highly complex business requirements.
· Performed GAP Analysis to identify the current situation and the future state want to reach on the current website.
· Interviewed manager, end users Marketplace seller individually or by group, held brainstorming meeting and teleconferences to elicit requirements.
· Gathered requirements pertaining to various features designing an interface that best suits department needs using wireframe diagrams.
· Helped transform the business requirements to functional requirements.
· Helped in creating a dynamic website using CMS Content Management System.
· Wrote and prioritize User stories in product backlog for each sprint.
· Defined, explained, and set goals with end users to attain a high level of project transparency.
· Used MS SharePoint to management requirement document and track requirement.
· Created Requirement Specification Documents after conducting interviews with End-Users, JAD Sessions, Brainstorming sessions.
· Used JIRA extensively to do planning, tracking, release management, issue management, scrum boards and reporting for all projects and used Confluence.
· Develop Project charter and obtained approvals.
· Wrote User Stories along with Acceptance Criteria as a part of the AGILE methodology using Confluence.
Environment: Agile, MS Office Suite, MS Visio, Snagit v 9.1.3, Smart Draw, SQL Server, JIRA/Confluence, RESTful
Client: TATA Consultancy Services Pvt. Ltd., Mumbai, India Nov 2015 –June 2017
Business Systems Analyst
Project: Development of a Mobile Application platform for controlling the operations under the project of GE
· Responsible for all the new Initiatives coming in to Interact with the application.
· Acting as Liaison between Business and the IT team by actively participating in all meetings with CRM provider and updating and maintain the CRM software configuration
· Responsible to see that the user stories created by business team reflect the actual need of the requirement from an IT standpoint and has all the necessary information required by the Dev team to start Implementation.
· Maintained CRM will help contribute to enhancing the business outcomes, by ensuring Recommended Actions and Alignments with Improved Profitability
· Driving the design approach for all the new requirements and functionalities proposed by the business.
· Created Requirement Specification Documents after conducting interviews with End-Users, JAD Sessions, Brainstorming sessions.
· Coordinated in Impact Analysis, reviewing the Client Requirements and Business Specifications, analyzing the impacts and feasibility.
· Acted as a liaison between the Customer and development team in designing and implementing functionalities, creating documentation for training and Help Desk teams.
· Performed User Acceptance Testing (UAT) immediately after every build, communicated process changes, enhancements, and modifications to the team.
· Responsible for daily stand ups as well with the Dev team, Tracking the status.
· Co-ordinating with the Offshore team and going over all the issues being faced by team pertaining to the requirements and the design.
· Accomplished experience through whole SDLC from requirement analysis till deployment and creating process flows for all the requirements.
· Reviewing all the Test cases from the QA team and helping them with the testing part and the defects
· Maintaining all the Documentation and the Sequence diagrams responsible to depict all the requirements for all the new projects coming into the application.
· Used JIRA extensively to do planning, tracking, release management, issue management, scrum boards, and reporting for all projects and used Confluence.
· Responsible for maintaining the JIRA board and Planning of the Iterations and Proficient in creating complex packages within SSIS.
· Involved in Performance tuning the Stored Procedures to by removing unnecessary cursors Developed SSIS Packages to pull data from Access and Excel sheets and performed ETL operations using SSIS to validate, extract, transform and load data to data warehouses.
Environment: Agile, MS Office Suite, MS Visio, Snagit v 9.1.3, Smart Draw, SQL Server, JIRA/Confluence, RESTful, JSON APIs
EDUCATION:
· Master’s in Information Technology specialization in Project Management at Southern New Hampshire University, Manchester, NH – December -2020
· BTech in Electronics and communication, Vignan University– June 2015
