Business Analyst Software Development

Aayush Shetty

Business Analyst

Contact: 781-***-****

Email: **********@*****.***

PROFESSIONAL SUMMARY:

Around 9 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Modelling, Translating Requirements into Specifications, Application Design.

Practical knowledge of the Software Development Life Cycle (SDLC), as well as Rational Unified Process (RUP), Waterfall, and Agile Software Development Methodologies.

Worked in various domains such as Healthcare, Insurance, Annuity, Telecommunications, and Internet Technology.

Actively participated in Joint Application Development (JAD) and Rapid Application Development (RAD) sessions with business users, SMEs, and stake holders to collect requirements, analyze them to pinpoint the true business need, and facilitate the creation of a tailored solution that offers the client and business the greatest possible cost and usability benefit.

Business process management expertise that includes requirements analysis, financial management, SIPOC process, cross-track effort estimation, and SIPOC process.

Wide-ranging understanding and practical experience in organizing and monitoring business requirements as they are transformed into UML diagrams using MS Visio and Rational Rose.

Experience in process modeling using Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams.

Knowledge in IAM related standards such as SAML, SOAP, LDAP, and OAuth.

Extensive experience in producing documents like Business Requirements Documents (BRD), Functional Requirement Specifications (FRS), Software Requirement Specifications (SRS), Creating Request for Proposals (RFP), creating Requirements Traceability Matrix (RTM).

Expertise in creating and delivering pre- and post-implementation training, doing SWOT and ROI analyses, GAP analyses, and user acceptance testing (UAT).

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, transformations, Filters, Calculated fields, Sets, Groups, Parameters etc. in Tableau.

Knowledge of testing lifecycle and the various testing types such as Manual Testing, Black Box Testing, System Testing, and User Acceptance testing.

Motivated by innovative ideas and supported by solid analytical and methodical problem-solving abilities, able to identify causes, take corrective action, and offer creative solutions, develop strategic alliances with senior business leaders, and secure commitments to action from people at all levels.

Experience in creating Key performance indicators (KPI), Enterprise Risk Management, Risk Mitigation and Business Continuity Planning (BCP).

Proficient in end-to-end ETL testing processes, including data extraction, transformation, and loading, ensuring data integrity and accuracy throughout the data lifecycle.

Excellent Knowledge of Health Insurance Portability and Accountability Act HIPAA Standards, code set rules as EDI 837, 835, 834, 270,271, 276,277 and ICD9-ICD10.

Experience in developing maps for various inbound and outbound EDI X12, EDIFACT, CSV, XML, Commerce XML and IDoc.

Good working knowledge on Gentran 4.0

Defined Test Scripts, created Test cases, analyzed defects, by interacting with QA /developer teams in fixing errors and writing simple SQL queries.

Experience in monitoring and administrating IBM infosphere DataStage server performance and usage.

Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio, Rational Suite, and SQL.

Proficient in Advanced Excel analysis, emphasis on creating pivot tables, data tables and analysis tools, statistical functions, file formats.

Extensive experience in Developing and building Webparts using SharePoint object model and SharePoint Designer.

Highly motivated individual with great interpersonal, communication, and presentation skills who excels both individually and in teams and is always eager to work in demanding cross-platform environments.

CORE COMPETENCIES:

Strategic Planning

Organizational Communication

Project Management

Creative Thinking

Risk Assessment

Leadership skills

Attention to Detail

Problem Solving

Logical Reasoning

Critical Analysis

TECHNOLOGY STACK:

Methodologies

Agile, Scrum, RUP, SDLC (Waterfall, JAD).

Rational Tools

Rational Requisite, UML, Rational Rose, Rational Clear Quest

Tracking Tools

QualityCenter

Modeling Tools

UML, rational Rose, and MS Visio

Analytical Tools

MS Excel (Advanced: pivot tables, data tables, lookup functions, statistical tools, solver, data validation)

Languages

PL/SQL, SQL, C, C#

Databases

ERP, Oracle 11i, MS SQL Server

Reporting Tools

Crystal Reports, Micro Strategy, Tableau

Others

MS Office Suite, SharePoint, MS Project, HTML, XML, PHP

Optum, MN July 2022 – April 2024

Sr. Business Analyst

Summary:

Optum, a subsidiary of UnitedHealth Group, is a leading health services and innovation company. The Project is related to building and maintaining health information exchange platforms. These platforms facilitate the sharing of patient information across different healthcare providers to enhance care coordination.

Responsibilities:

Designed the business requirement collection approach based on the project scope, Created Business Analysis using agile methodology.

Organized and facilitated Agile and Scrum meetings, which included Sprint planning, Daily Scrum, Sprint check in, Sprint review and retrospective.

Conducted interviews with key business users to collect requirement and business process information.

Created project plans, style sheets and templates to analyze and estimate feasibility, cost, time, and general guidelines for project team.

Facilitated JAD (Joint application development) sessions with business users and development teams to drive out detailed business requirements.

Analyzed IAM system data extract to align work efforts with mergers, acquisitions, and divestiture of new and existing businesses.

Performed extensive data analysis using MS Excel and gap analysis.

Managed SharePoint Designer workflow creation.

Designed and implemented SharePoint solutions for document management, collaboration, and workflow automation.

Used SQL query to produce data for 270 EDI X12file and create 270 files and submit to MEVSNET to check dual snip member for Medicaid benefits.

Involved in Requirement Elicitation and maintaining requirements from Inception through phase.

Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software. Conducted Business Analysis and Data Analysis.

Refined and input business requirements in HP Quality Center for traceability to test requirements.

Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities.

Helped to develop wireframes and graphical data visualization for client.

Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Dataflow Diagrams in MS Visio.

Involved in developing the intranet UI/UX of audit web application, watchlist application to alert underwriters and other internet applications.

Prepared a traceability matrix for tracking the requirement to software requirement specifications and test cases. Also maintained change management throughout inception phase to transition phase.

Developed strategic partnerships with the business units to develop a solid knowledge base of the business line, including the business plan, products, and process and revenue streams.

Worked with the Business Objects developers to provide input for generating automated and ad hoc Business Objects reports.

Conducted thorough analysis of existing data structures and formats to facilitate seamless migration to new workflow systems.

Used SQL for querying and analysis purposes on various source tables and conditions applied.

Led and managed end-to-end workflow migration projects within the organization, ensuring successful delivery within scope, budget, and timeline constraints.

Designed and optimized new workflows to meet specific needs and regulations by utilizing process mapping, flowcharting, and data analysis techniques to streamline the processes.

Thorough knowledge of the revenue cycle management and documented and outlined the claims and denial processing of the system.

Create retro enrollment case as needed to correct members enrollment data with Medicare.

Research and analyze issues for center for Medicare and Medicaid studies processing system.

Helped the testing team in creating the test plans and test scripts. Assisted the users in UAT testing by providing test scenarios and test data.

Identified potential risks associated with the workflow migration project and developed mitigation strategies to minimize impact on project timelines and deliverables.

Developed and executed detailed ETL test plans, test cases, and scenarios to validate data completeness, correctness, and consistency across various sources and targets.

Conducted regression testing on ETL processes to identify any potential impacts on existing data structures and functionalities, ensuring backward compatibility and system stability.

Create a well-informed cloud strategy and manage the adaptation process.

Working on designing AWS cloud migration strategy from on-prem servers.

Extensive data cleansing and analysis, using pivot tables. Formulas, data validation, conditional formatting, and graph and chart manipulation using Excel.

Conducted benchmarking activities to identify best practices.

Customized rally dashboards for agile teams i.e. Kanban, Scrum boards, Agile portfolio dashboards, defect tracking analysis dashboards, product owner dashboard and metrics dashboards.

Trained business users and sales teams on new promotion and operational procedures.

Environment: Oracle 11g, Oracle SQL Developer, MS Office, MS Project, MS Visio, Crystal Reports, Rational Requisite Pro, Rational Rose, MS SharePoint

National Grid PLC, MA Oct 2021 – June 2022

Business System Analyst

Summary:

National Grid is a multinational electricity and gas utility company that operates in the United Kingdom and the northeastern United States. The project was related to identifying the issues related to power outages and maintenance activities and difficulty in predicting equipment failures.

Responsibilities:

Gathered high level requirements from stake holders located and developed scope along with the PM of the project for the implementation.

Conducted weekly meetings for deciding and reporting on the Policies and Procedures to be followed.

Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.

Performed the Risk Assessment, requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.

Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies.

Developed a database on MS Access for the company to keep track of the expenses for various phases of the project.

Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.

Conducted JAD sessions with management, SME, vendors, users, and other stakeholders for open and pending issues.

Create detailed wireframes for all pages.

Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.

Perform Slicing and dicing of data using SQL and Excel for data cleaning and data preparation.

Assisted in writing SQL Queries as a part of Backend Testing.

Utilized advanced features of tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Involved in testing SQL scripts for report development, Tableau reports, Dashboards, Scorecards, and handled the performance issues effectively.

Identified and clearly functional issues and supported IT development staff throughout the design, development, testing, and implementation phases of the software development life cycle.

Created and managed project templates, use-case project templates, requirement types and trace-ability relationships in Requisite Pro.

Authored progress and completion reports, which were then submitted to project management on a weekly basis.

Collaborated with development teams to optimize ETL processes for improved performance, identifying bottlenecks and proposing solutions to enhance data processing efficiency.

Support the review, clean-up (moving/copying sites), management and configuration of SharePoint accounts and sites.

Leveraged Google Workspace tools such as Gmail, Google Drive, Google Docs, Google Sheets, and Google Meet to facilitate collaboration and communication among team members, improving productivity and teamwork.

Configured and customized Google Workspace to align with the organization's specific needs and requirements, including setting up email aliases, group permissions, and shared calendars.

Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director.

Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing using Mercury's Win Runner.

Performed User Acceptance testing (UAT) and documented results.

Facilitate all Scrum ceremonies to promote scrum values and principles within the framework.

Trained user team on new processes and operational procedures.

Environment: Web sphere, Visual Basic, Tableau, MS Excel, Microsoft Visio, PL SQL, SQL, Oracle9i, Unix, WinNT, Win Runner & Test

Verizon, MA Aug 2020 – Sep 2021

BI Analyst

Summary:

Verizon is a telecommunications company that provides a variety of services including wireless communication, internet, and television. The project focused on enhancing cybersecurity measures to protect the network and customer data. This involved developing advanced threat detection systems and implementing security protocols.

Responsibilities:

Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation, and test plans.

Conducted JAD (Joint application development) sessions with business users and development teams to gather the quality requirements.

Worked extensively with SMEs in understanding and documenting their requirements pertaining to the Credit Card processes. Worked with all levels of client staff in the process of solution definition.

Work with key stakeholders, Business leaders, and project teams to integrate their application into IAM solutions.

Assisted with product evaluation, product customization and system integration. Conducted GAP analysis around the identification of business rules, Risks involved, business and system process flows, user administration, requirements, and assumptions.

Analyzed user problems, including automated and manual business processes, and identified, researched, investigated, defined, and documented business processes.

Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML.

Created wireframes based on requirements and refined them with the development team.

Co-authored business requirements document with the business users.

Defined best practices for tableau report development.

Converted metric insight reports to tableau reports.

Applied use cases diagram to validate and test web application design against the UI architecture.

Designed visual concepts and UI layout.

Migration of infrastructure, data, and application out of legacy data centers into cloud and hybrid environment.

Collaborated with external vendors and third-party service providers to procure necessary software solutions, services, or expertise required for the successful execution of workflow migration projects.

Maintained comprehensive documentation of ETL test cases, results, and defects, providing regular reports to project stakeholders on testing progress and quality metrics.

Discussed and refined business requirements from business users and team members.

Assisted the project managers with the development of project schedules.

Created and updated implementation client plans and step playbooks for the different modules of the RCM product.

Development of custom Microsoft InfoPath based web form applications backed by SharePoint workflow processes.

Utilized data profiling tools and techniques to gain insights into the characteristics and patterns of data, identifying outliers and trends that may impact workflow migration efforts.

Proficient in using ETL testing tools such as Informatica, Talend, or SSIS, as well as familiar with database querying tools like SQL for data validation and analysis.

Led the implementation of SharePoint as a central document repository, resulting in a reduction in document retrieval time.

Perform data collection, data cleaning, data wrangling, data analysis and building machine learning models on data sets in both R and Python.

Involved in documentation during various phases of development life cycle.

Performed UAT on business requirements, technical specifications, and product knowledge.

Environment: Rational Rose, Clear Quest, Microsoft Project, Python, Tableau, Java, Oracle, UNIX, HTML, MS Excel, MS Access, MS Visio, SharePoint.

Cigna Healthcare, MA June 2019 - March 2020

Junior Business Analyst

Summary:

Cigna is a global health services organization that provides a range of insurance and healthcare services. The project aimed at improving the overall customer experience, including the development of user-friendly mobile apps, online portals, and customer service enhancements.

Responsibility:

Analyzed business in creating a program which evaluates and identifies leading network physicians and hospitals using quality and efficiency criteria based on evidence-based medicine across a broad spectrum of care.

Created Business Requirement Documents and Functional Requirement Document

Performed Gap Analysis by identifying existing features and documenting the enhancements to meet the end state requirements.

Co-authored Business Requirements Specification (BRS), Use Case Specifications, Systems Requirement Specification (SRS) and Change Request in collaboration with the Business Group and the IT project group members.

Worked with the business community to define business requirements and analyze the technical solutions.

Conducted sessions for Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis.

Designed and developed project document templates based on SDLC methodology.

Facilitated Joint Application Development (JAD) sessions with user and IT group members.

Collaborated with the QA team to develop the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.

Worked with several HIPAA teams addressing the specific requirements of each part of the HIPAA regulation.

Seamlessly collaborated with team members to achieve daily objectives.

Used Quality center for writing test plan and managing and track requirements.

Involved in comprehensive testing of the system (UAT) to check if it satisfies functional specifications.

Environment: UML, RUP, MS Visio, DOORS, IBM Clear Quest, IBM Clear Case, Oracle, UDB, SQL, HTML, XML, Lotus Notes 7, Windows 2000, Web server, Web Logic, Web Methods, UNIX, J2EE.

Praveen Engineering Industries Pvt Ltd, Hyderabad Jan 2016 - July 2018

Business Analyst

Responsibilities:

Involved in gathering Business Requirements for new models through E-mails and Surveys.

Facilitated JAD (Joint application development) sessions with business users and development teams to drive out detailed business requirements.

Performed extensive Use Case analysis.

Created wireframe and presented various user interface design options to stakeholders.

Part of Automation COE to assess the RPA/IPA use case for existing client.

Used IBM infosphere DataStage Designer, Director, and Administrator for creating and implementing jobs.

Involved in identifying opportunities to automate manual tasks using Robotics Process Automation (RPS) technology.

Performed extensive Business Process Modeling using Swim-Lane diagrams, Sequence diagrams, Workflow diagrams and Activity diagrams using MS Visio.

Conducted Feasibility Analysis to study the benefits of using the application through Data Flow Diagrams and used Trace-ability Matrix.

Coordinated with all Allstate agents to gather requirements for the application and managed them using Rational Requisite Pro.

Involved in Gap Analysis and ROI Analysis of existing policy management system with the Enterprise system.

Integrated Requisite Pro with Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.

Analyzed the final requirements of data and authored the Source to Target Mapping (STTM) Documents to help ETL team in extracting and processing data before loading to the target database.

Studied and Analyzed the Reporting requirements of agents to include them while building the application. O Coordinated with Quality Analyst to develop test plans and performed UAT.

Environment: MS Word, Excel, Access, Visio, Load Runner, Rational Requisite Pro, Rational Rose, Rational Clear Case, ERWin 4.5, UNIX, SQL server, Crystal reports, VB, Windows XP.

Nimap Infotech, Mumbai, India. June 2014 – Dec 2015

Junior Business Analyst

Responsibilities

Estimated time required to deliver project artifacts and reports progress toward delivery goals throughout the project. Interacted with project stakeholders to elicit, analyze and document project requirements.

Analyzed and prepared the users 'AS-IS' workflow scenarios and the 'TO-BE' business processes.

Used Microsoft Visio to model business processes using UML to create use case diagrams, activity diagrams, sequence diagrams and collaboration diagrams.

Produced professional quality project artifacts including but not limited to business requirement documents, requirement plans, models (e.g., data, event, context, and process), traceability matrices, use cases, issue logs and other documents as needed.

Developed database, created tables and ran queries for testing functionality.

Maintained the requirements traceability matrix to manage business requirements.

Assisted the business in determining if and how new systems or system enhancements may improve process flow and business function.

Served as a critical resource and liaison between subject matter experts and technologists throughout the project lifecycle.

Documented User Training Materials (Manual and Guides).

Environment: MS Visio, Windows, UML, MS Office Suite, Oracle 10g

EDUCATION:

Northeastern University, Boston, MA Sept 2018 -June 2020

Master of Science in Project Management

Mumbai University, Mumbai, India July 2010 – May 2014 Bachelor of Technology in Engineering

Contact this candidate