Business Analyst Project Management
Resume:
Arun Kumar Karanam
Sr. Business System Analyst
************@*****.***
Professional Summary
● Having 9+ years’ experience as an accomplished Business Analyst with extensive experience in information technology industry and its applications in the Banking, Insurance, Health and Retail sector.
● Experience in Cost reduction, End to End Inventory Monitoring, Order Management System, Creating Replenishment strategies, Forecasting, Inventory Management System, Material Handling
● In depth knowledge of System Development Life Cycle (SDLC) methodologies like Waterfall, Scrum, Waterfall-Scrum hybrid, Scale Agile Framework (SAFe) and Kanban.
● In depth knowledge of Requirement Management, Change Management, Defect Management, Release Management, Project Management and Risk Management using JIRA and MS Project.
● Expert in understanding of the AS-IS and TO-BE, business processes by conducting GAP analysis and experience in converting the requirement into technical specification for better execution of the business decision.
● Experienced in gathering Eliciting from end-clients and stakeholders by using various elicitation techniques like Joint Application Development (JAD), Brainstorming, Interview, Questionnaire/Surveys, Prototyping, Document Analysis, Focus Group, Interface Analysis.
● Assisted in drafting artifacts like Project Vision and Scope, Project Management Plan, Project Charter, Business Requirement Document (BRD), Functional Specification Document (FSD) and System Requirement Specification (SRS) by communicating with business owners and subject matter experts
(SME)
● Assisted Product Owner in defining Minimum viable product (MVP) features of the application under development.
● Experienced in writing the user stories and acceptance criteria. Participated in Scrum Ceremonies like Backlog Grooming, Sprint Planning, Daily Stand-Up, Sprint Review and Retrospective and efficient in using prioritizing techniques like Moscow, KANO, 100 Point method and Business Value Based.
● Experienced in analyzing workflow and developing and reviewing business solution model using Use Case Diagram, Sequence Diagram and Activity Diagram with Lucid Charts and MS Visio.
● Assisted in creating low-fidelity and high-fidelity mockups and wireframes with UI designer using Balsamiq.
● Developed Entity-Relationship (E-R) diagram using Conceptual Data Model and Logical Data Model with Lucid Charts.
● Assisted in developing Data marts (DM), Data mapping, Data migration, Data integration and Data warehouse (DW) implementing Extract, Transformation and Load (ETL) with Informatica PowerCenter.
● Knowledge of HIPAA and various transaction codes like 270/271 (inquiry/health care benefits), 276/277
(Claim Status), 834 (Benefit Enrollment), 837 (Health Care Claim), 835 (Payment/Explanation of benefits) PPACA (Health Care Reform and patient Protection and Affordable Care act).
● Strong knowledge of MMIS, HIX, EMR, EHR, and healthcare reforms like EMTALA
● Extensive knowledge of the various types of health insurance programs such as Medicaid, Medicare (Part A, B, C, and D), PPO, Accountable care organizations, HMO, Dental claims, and POS.
● Knowledge in identifying ETL jobs, designing reports, ensure data meets Business requirements and managing work quality and quantity through frequent releases and coordinating with ETL developers, modelers, PM's.
● Collaborated with cross-functional teams to integrate Data Mining solutions into existing inventory management systems, ERP platforms, and business intelligence tools.
● Ensured accuracy and consistency of BOM (Bill of materials) data across various departments, improving collaboration and communication.
● Expertise in usage of Tableau and power BI, to create interactive and analytical dashboards, Ad-hoc Reports to aid in Business Intelligence (BI) initiatives, decision making, determine Seasonality and trends in the data.
● Used data analytics tools to monitor (Just-In-Time) JIT-related KPIs, offering actionable insights for process refinement.
● Proficient in Agile testing practices including Test-Driven Development (TDD), Acceptance Test-Driven Development (ATDD), Behavior-Driven Development (BDD), and Continuous Integration.
● Skilled in implementing SQL QUERIES and using Joins, unions, Select commands and Aggregate functions in extracting data from different data sources and programmed SQL Queries, Functions, business logic.
● Significant experience in Service Oriented Architecture with strong and in-depth understanding of EDI, JSON, XML, Web Services (WSDL, SOAP, REST) across heterogeneous IT environments.
● Reviewed the Test plan, Test cases, Test scenarios and maintained the test data with Confluence and HP ALM QC.
● Strong experience in writing Test cases, Test plans, Test scenarios for UAT using Cucumber and Jenkins for Testing and Validating business requirements and worked closely with clients to demonstrate the new functionality and changes to ensure all business needs are addressed. Technical Skills
Business Skills Change Management, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, ROI Analysis, JAD Sessions, SWOT analysis
Cloud Platform Salesforce Service Cloud, Oracle Inventory Cloud, Oracle Transportation Cloud, Microsoft Azure, Google Cloud.
SDLC Methodologies Agile-Scrum, Waterfall, Waterfall-Scrum hybrid, SaFe. Requirement Management MS Office, Jira, HP ALM, HP-QC Modeling Tools MS Visio, Lucid Chart, Balsamiq, Draw.io ETL Tools Informatica Power Center, Talend.
Data Warehousing Data Marts, OLTP, OLAP, Multidimensional Analysis, OLAP Operations, Data Mapping, Star schema, Snowflake Schema
Databases MYSQL, Microsoft SQL T-SQL, Oracle database. Defect Tracking/ Testing
Tools
HP ALM QC, Selenium, Jira, Azure DevOps.
Work Experience
TD Bank, Auburn Hills, MI
Sr. Business System Analyst Oct 23 to Till date
Project Description
The project involved creating and maintaining a centralized transaction monitoring system for a network of bank branches, providing up-to-the-minute information regarding transactions and account statuses across all branches within the region. The project required implementing an advanced Transaction Management System by integrating Oracle Fusion Cloud Financials with core banking systems and CRM using MuleSoft's Anypoint Platform. This integration enabled seamless, real-time data synchronization, improved fraud detection, and provided end-to-end visibility across all financial operations.
Roles and Responsibilities:
• Performed document analysis and interviews to understand current business processes and the desired business processes (As-Is and To-Be states). Conducted GAP Analysis to understand discrepancies and conducted risk assessments.
• Facilitated Agile ceremonies including Daily Standups, Sprint Planning, Sprint Reviews, and Retrospectives, utilizing Scrum and Kanban frameworks to enhance project delivery and team collaboration.
• Created detailed workflows using Business Process Modeling Notation (BPMN) to visualize and analyze current and future state processes, ensuring clarity and alignment among stakeholders.
• Utilized and Azure DevOps to track project progress, manage backlogs, and ensure timely delivery of project milestones.
• Assisted in creating Work Breakdown Structure using MS Project to visualize workflow and created RACI matrix and Value Stream Mapping to manage all relevant stakeholders and help understand the delivery flow of project value.
• Created and maintained a Requirements Traceability Matrix (RTM) to document the requirements from inception through testing and deployment, ensuring all requirements are met and validated.
• Engaged with Project Managers, Developers, and Business Users to ensure processes are defined, documented, and translated into technical requirements for the development team to build and deliver the solution.
• Facilitated workshops for requirements analysis with cross-functional teams, utilizing techniques such as brainstorming, storyboarding, and user journey mapping to elicit comprehensive and accurate business requirements.
• Developed Project Initiation Documents (PIDs) outlining project objectives, scope, deliverables, and timelines, providing a clear roadmap for project execution and stakeholder alignment.
• Worked with the PO and development team in deciding and negotiating the DOD (definition of done), definition of ready, and acceptance criteria for user stories.
• Conducted JAD sessions, document analysis, and Interview sessions with SMEs and various stakeholders to identify and analyze requirements for various functionalities and prepared Business Requirement Document (BRD), Functional Specification Document (FSD), and System Requirement Specification
(SRS).
• Defined and documented Quality-of-Service (QoS) requirements, including performance, scalability, security, and usability metrics, to support functional requirements and ensure comprehensive system quality.
• Designed user-friendly dashboards and performance Analytics Reports using Power BI to provide stakeholders with real-time visibility into inventory levels, demand trends, and key performance indicators
(KPIs).
• Served as a liaison between company business areas and the data management team to develop the data and business requirements for the Data warehouse, Data modeling, ER diagrams, Dataflow diagram, and workflow analysis.
• Analyzed the impact of Change Requests in business requirements and updated them in the requirements document.
• Mapped data from On-premise systems to Inventory cloud. Identified initial Data sources to migrate to Oracle Inventory Cloud after analyzing, Data Mapping, and designing target data fields as part of the Extract, transform, and load (ETL) process.
• Analyzed data contained in the Data warehouse using SQL-CRUD Operations and used Tableau to confirm data accuracy and integrity of various reports also to find seasonality and trends in the data and present the findings to the management.
• Worked with API team and Architecture team to understand Microservices architecture and documentation along with SQL queries for Data Analysis, retrieval, validation, and modification.
• Managed communication and change management activities, ensuring effective stakeholder engagement and user adoption during IT integration and migration.
• Aided in the development of UAT test plans and worked with the testing team to clarify ambiguity related to Test Cases.
• Assisted the development support team with Defects script testing, Defect tracking, and Validation of scripts.
• Developed and executed UAT test plans, ensuring that deliverables met quality standards and user expectations through comprehensive testing.
• Performed API Testing using Postman to check if the information returned is in JSON/XML format (RESTful API) and Swagger for API Documentation.
Environment: Agile Scrum, MS Visio, Azure DevOps, Oracle DB, MySQL, Power BI, Postman, MuleSoft AnyPoint, Informatica power center, SharePoint, Python, Confluence, MS PowerPoint, MS Excel. State of Wisconsin DOE, Madison, WI
Business Systems Analyst Aug 2021 to Sep 23
Project Description-
Implemented a Healthcare Management (HM) solution to enable seamless collaboration across the healthcare network, reducing operational costs and improving patient care delivery. Integrated Oracle's Healthcare Management cloud platform via API-based integration with existing Electronic Health Records (EHR) systems to provide real-time visibility of patient data, offering dynamic care timelines and optimized resource allocation. This resulted in improved patient outcomes, streamlined care coordination, and efficient execution of multimodal treatment plans for the client.
Roles and Responsibilities:
● Identified key stakeholders and gathered functional and non-functional requirements associated with, Transportation Management, Potential Stores, etc. through Interviews, Document analysis, and JAD sessions.
● Understood the AS-IS and TO-BE system with proposed features while performing GAP Analysis on every aspect of TMS.
● Performed a High-level analysis of the requirements from a business perspective to determine the feasibility of constructing the new application.
● Worked extensively with developing a business rules engine enabling the business rules such as referral, prior authorization, eligibility, claims processing, and billing essential.
● Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
● Worked on FHIR, and EDI transactions: X12, 835, and 837 P.I identify key data set elements for designated record sets. Interacted with Claims, Payments, and Enrollment hence analyzing and documenting related business processes
● Guided the development team to develop a single application to process data from multiple integration points, convert the data for reporting purposes, and feed data into the mainframe system to be compliant with reporting requirements.
● Gathered requirements for setting quality metrics and standards for enhancing managed health care and performance while processing newborn baby data.
● Performed GAP analysis by performing the system analysis between the scheduling systems and documented the gap items.
● Conducted JAD sessions, Medicaid meetings, and workshops to gather requirements from various stakeholders and SMEs.
● Expertise in implementation of Standard operating procedures (SOP), CMS documentation related to MMIS Certification
● Utilized Agile Software Methodology using Scrum framework. Actively participated in creating the user stories and prioritizing user stories along with tracking of burn up, and burn-down charts to estimate sprint delivery.
● Facilitated all Aspects of the scrum framework, including product backlog, release backlog, sprint planning session, daily scrum meeting, sprint reviews, and sprint retrospectives.
● Initiated with a comparison report of 270 Eligibility, Coverage or Benefit Inquiry (VX092A1) vs.270 Eligibility, Coverage or Benefit Inquiry (VX279)
● Conducted project-related Presentations periodically to the management and end users during various phases of Software Development Life Cycle SDLC.
● Extensive use of Facets back-end tables and front-end application system for data validation purposes.
● Developed Test Cases for unit testing, and prepared spreadsheets for testing criteria, including regression, positive and negative testing, process flow testing, and screenshots for test results to complete expected and actual results.
● Prepared various diagrams by using MS Visio.
● Wrote SQL scripts for creating performance evaluation reports.
● Prepared documents for the SOP, Manuals, Proposals, User Guides, RFPs, and CMS Documentation wireframe and prepared a data dictionary for the same.
● Used different ad-hoc analyses, the Reports assist in defining strategy for each customer category. Informatics was used for the ETL process and Business Objects.
● Perform research on Member, Provider, Clinical Data, Claims, Authorization, Appeals, and Grievances data from Facets back end and front-end application system for reporting purposes.
● Followed the UML-based methods using Rational Rose to create Use Cases, Activity diagrams, that include Functional and Non-Functional specifications to hand off to development teams.
● Recorded requirements in the Requirement Traceability Matrix RTM defining each technical requirement in detail.
● Assisted in Conducting UAT User Acceptance Testing to make sure that all the user requirements are catered by the application.
● Acted as User Acceptance Testing coordinator monitored business testing and interfaced with the development team regarding defect status and fixes daily.
● Worked closely with QA and Developers to clarify/understand functionality, resolve issues, and provide feedback to nail down the bugs.
Environment: Agile Scrum, Balsamiq, Microsoft Office Power BI, Azure DevOps, Jira 7.1.9, MY SQL, REST APIs, Confluence, HTML, CSS, HP-ALM, Microsoft Teams, Figma, Talend. Toyota, Plano TX
Business Systems Analyst Nov 2019 to Jul 2021
Project Description-
Developed a centralized service request management system to automate the service request processing and resource allocation resulting reduced response time by 50%, improving customer satisfaction. Integrated Salesforce CRM Service cloud platform to transform outdated legacy roadside assistance systems, facing operational inefficiency from inefficient processes - causing slow responses, high costs, and poor service quality. The CRM solution automates service request assignment to technicians, uses algorithms to optimize routing and resources, provides a consolidated customer history for personalization, and centralizes work tracking and billing for better coordination.
Roles and Responsibilities:
● Identified key stakeholders and gathered functional and non-functional requirements related application enhancement, customers trends, market insights through interviews, document analysis and JAD sessions.
● Analyzed, modified, and validated Business Requirements (BRD) and Systems Requirements (SRS).
● Created Use Cases and Designed UML diagrams like Use Case, Activity and Sequence using MS Visio.
● Monitored, Managed and Tracked requirements using MS Project throughout Project Lifecycle.
● Collaborated with the QA team to design and develop Test Plan and Test Scenarios and Cases, involved in ETL testing process in validating the data, reviewing data dictionaries and in test data preparation.
● Defined Process Flows and user interface use cases, ensuring clarity and alignment with business objectives and enhancing user experience.
● Performed source analysis to identify, analyze the required data from on-premises databases and used SQL queries to retrieve the required data and identify the data formats.
● Led collaborative efforts between on-site and offshore teams to develop and implement the centralized service request management system.
● Developed analytical lens, reports and dashboards using Einstein Analytics which helped in analyzing the customer performance and in improving customer experience and customer satisfaction.
● Generated periodic reports using Tableau and Excel for the management to make effective business decisions.
● Assisted data analyst in data cleaning, performed data profiling to assess the data quality and ensuring data integrity.
● Assisted the team in preparation of the training modules, provided steps/tutorials to generate reports.
● Performed API testing using Postman and created API documentation of request and response body using swagger.
● Performed UAT, tracked the entire issue life cycle and generated the defect reports.
● Involved in dealing with Change Requests by performing Impact Analysis. Environment: Scrum, MS Office, Tableau, Informatica, MS Visio, MS Project, Figma, SQL Server, SharePoint, UAT testing.
Wakefern Food Corp., Edison, NJ
Business Analyst Feb 2017 to Oct 2019
Project Description
The project was focused on building a robust Order Management System (OMS) integrating a comprehensive set of fulfillment options (BOPIS, curbside pickup, same-day delivery, easy returns) into the retail omnichannel infrastructure, providing customers with flexibility, convenience, and a superior shopping experience. Responsibilities:
● Assisted Project Manager in creating and assigning tasks through Work Breakdown Structure.
● Interviewed stakeholders and SMEs to elicit detailed business requirements and functional requirements. Translated needs into comprehensive Functional Specifications Documents (FSD).
● Converted the Business Requirements Document (BRD) into Functional Requirements Document (FRD).
● Created process flows and data maps to facilitate understanding and alignment between business, development, and testing.
● Performed GAP analysis for AS-IS and TO-BE of the process to identify and validate requirements.
● Created UML diagrams, assisting both functional and technical teams in creating mockups, wireframes, and prototypes using Balsamiq tool.
● Developed test plans outlining scenarios, test cases, and data requirements. Collaborated with QA on defect tracking using TFS to maintain resolution history.
● Worked with QA team to develop test plans, scenarios, and cases to execute System Integration and User Acceptance Testing (UAT).
● Collaborated with cross-functional teams to design and implement the Order Management System (OMS) for a seamless omnichannel retail experience, enhancing customer satisfaction.
● Developed and maintained comprehensive documentation for the OMS, ensuring clear communication and alignment among stakeholders, developers, and QA teams.
● Conducted user training sessions and workshops to ensure smooth adoption of new fulfillment options, including BOPIS, curbside pickup, same-day delivery, and easy returns.
● Analyzed customer feedback and sales data to identify areas for improvement in the OMS, providing actionable insights to optimize system performance and user experience.
● Coordinated with third-party vendors to integrate additional services into the OMS, expanding fulfillment capabilities and supporting the retail omnichannel strategy.
● Wrote complex SQL queries to extract and analyze data from various databases, supporting data-driven decision-making and troubleshooting.
● Designed and implemented ETL processes to facilitate the seamless integration of data from multiple sources into the Order Management System.
● Utilized ETL tools to transform and load data into data warehouses, ensuring data integrity and consistency for reporting and analytics.
● Developed and executed detailed test plans, including test cases and scenarios, to validate system functionality and performance.
● Conducted data validation and reconciliation processes to ensure accuracy and completeness of data migration efforts.
Environment: Agile-Scrum, MySQL, TFS, SharePoint, Oracle, MS Project, MS Visio (v15.0), Balsamiq. Wipro, Gurgaon, India.
Business Analyst May 2015 to Jan 2017
Project Description
The objective of this project was to develop an automated claim adjudication system catering to policyholders, general users, and healthcare professionals. The project is structured into three distinct releases. As a Business Analyst, my primary role was in the initial release, focusing on the implementation of the claim intake process. Roles and Responsibilities:
• Gathered High Level Business Requirements (HILBERs) from client and stakeholders through interview process.
• Created and developed Business Requirement Document (BRD) and Functional Requirements Document
(FRD).
• Analyzed and managed cross-functional existing/planned business processes impacts.
• Developed feasibility and Project risk analysis to ensure requirements can be met.
• Analyzed and segregated business requirements into high level and low-level Use Cases, using Microsoft Visio.
• Wrote Use Cases descriptions including pre-conditions, assumptions, normal flows, alternative flows, post- conditions, notes and issues.
• Coordinated Virtual Meetings with business clients, stakeholders, end users and various development teams including testers to discuss project progression reports and to gather new requirements.
• Identified and created Use Case diagrams with business process workflow diagrams including Activity, Sequence and from the requirements.
• Used detailed knowledge of application features, architectures and functions to assess scope and impact of business needs throughout analysis and through the completion of all enhancement specifications.
• Conducted Joint Application Design (JAD) sessions for communicating with all project sponsors and stakeholders.
• Documented Requirements, Test Plan, Test Cases, Defects and Change Controls in Quality Center.
• Prepared weekly Review and Status Reports, which included Test Case Standings, Metrics, QA Issues and Defects.
• Communicated the project status to clients bi-weekly, highlighted changes made in requirements and gathered new requirements.
• Conducted User Acceptance Testing (UAT) with users and project team members. Environment: Waterfall- Scrum, MS visio, MS Project, MS Office Suite, MS Power Point, Unified Modeling Language
(UML)
EDUCATION:
North Maharashtra University India
B.S Mechanical Engineering
Contact this candidate