Khushali Soni
Cliffwood,NJ
Summary
Business Analyst with 6+ years of experience in requirements gathering, business process analysis, and delivering scalable solutions across web-based and enterprise applications. Proven ability to translate business needs into technical specifications, supporting full project lifecycles from planning and design through testing, implementation, and user training.
Strong expertise in AS-IS/TO-BE analysis, gap analysis, and UAT, with a track record of facilitating JAD sessions and collaborating with cross-functional teams to drive alignment and successful delivery. Skilled in data analysis, process optimization, and identifying opportunities to improve efficiency and performance.
Recognized for strong problem-solving, critical thinking, and communication skills, with the ability to manage stakeholders effectively and deliver high-quality outcomes in fast-paced environments.
Overview
8
8
years of professional experience
Work History
Revenue Account Systems Business Analyst
Carnival Cruise
Miami, FL
06.2023 - Current
- Ensured reconciliation of sales data between the Point of Sales system and the Sail & Sign payment systems.
- Experience in using Azure DevOps services for managing test cases, test plans, and test executions as part of software development lifecycle (SDLC) processes.
- Perform data validation and reconciliation to ensure accuracy and completeness of revenue records, addressing any discrepancies through thorough investigation and resolution.
- Proficient in creating and maintaining dashboards in Azure DevOps to monitor project progress, track testing activities, and communicate key metrics to stakeholders.
- Compiled comprehensive reports and presentations for senior management that emphasized key revenue drivers on a quarterly basis.
- Supported with data collection and analysis from a variety of sources, including financial systems and SQL databases, for revenue analysis and reporting.
- Conducted validation and reconciliations for Onboard Revenue JEA voyages using Excel and SQL.
- Mastery of Microsoft Excel for data analysis, financial modeling, and visualization, including advanced functions (e.g., VLOOKUP, PivotTables, macros) to streamline revenue reporting processes.
- Contributed to the preparation of monthly, quarterly, and annual financial statements and disclosures related to revenue recognition.
- Collaborated with the IT department on small to medium-scale mainframe and Data Warehouse projects throughout various stages of the project lifecycle.
- Drafted queries and conducted user acceptance testing (UAT) as necessary for each enhancement in the new system.
- Worked across multiple business areas to streamline and automate daily tasks, enhancing overall business effectiveness and efficiency.
- Environment: MS Visio, MS Access, Excel, Word and PowerPoint, Gap Analysis, RUP, Rational requisite pro, Rational Rose, Agile, UML, SQL and Windows, MS Visio, Amdocs, ASPECT, MS Office, SQL, HP Quality Center, MS Project.
Business Analyst
Home Street Bank
Seattle, WA
10.2021 - 06.2023
- Documented Requirements for Activity Managery:
- Strong knowledge of Software Development Life Cycle (SDLC) including UML, Rational Unified Process (RUP), Waterfall, and Agile Methodology.
- Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.
- Expertise in Fixed Income, Derivatives, Equities, Bond Pricing, and Mortgage-Backed Securities (MBS).
- Organized Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthroughs, Interviews, Workshops, and Rapid Application Development (RAD) sessions with end-user/clients/stakeholders and the IT group.
- Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM), and testing documents.
- Excellent Business scripting skills and proficiency in developing Use Case Models, Analysis Models, Design Models, Implementation Models, Use Case Diagrams, Context Diagrams, Dataflow Diagrams, State Transition Diagrams, Functional Storyboards, Behavior Diagrams (sequence diagrams, collaboration diagrams, and activity ment, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution, and reporting requirements for the user interface.
- Followed a structured approach to organize requirements into logical groupings and developed Business Requirement Documents (BRD) from essential Business Processes, Business Rules, and information needs and ensured that critical requirements are not missed.
- Translated the business support systems (BSS) to Operational Support System tasks (OSS).
- Responsible for forecasting, financial reporting, and review of the company’s accounting function and managed the annual budget for Global Equity and Derivatives.
- Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stakeholders and document analysis, representing them in the Requirements Traceability Matrix (RTM).
- Gathered stakeholder requirements from various ends through surveys, interviews, and JAD sessions and translated them into system requirements.
- Designed and developed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams using MS Visio to define the Business Process and Data Process model.
- Environment: MS Visio, MS Access, Excel, Word and PowerPoint, Gap Analysis, RUP, Rational requisite pro, Rational Rose, Agile, UML, SQL and Windows, MS Visio, Amdocs, ASPECT, MS Office, SQL, HP Quality Center, MS Project.
Business Analyst
Prudential Bank
Philadelphia, PA
07.2020 - 09.2021
- Elicited customer requirements by organizing interviews with internal/external stakeholders and subject matter experts (SMEs).
- Prepared Business Requirement Documents (BRD) coordinating with other Business Analysts in the team.
- Responsible for coordinating JAD sessions with business users to analyze the present shared resource, analyze the needs of the new application, and application lifecycle, gather and define the key performance indicators, and document and present the requirements specifications.
- Acted as a communicative bridge between the upper management and the technical team and also assisted Project Manager in scheduling tasks.
- Performed Gap analysis by identifying existing technologies and documenting the enhancements to the end-state requirements.
- Used RUP methodology and coordinated with other members to implement the process and create the following various RUP artifacts scope statement: high-level requirements, detail requirements (use cases), and functional specification.
- Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes and participated in Stakeholder Management to communicate effectively with them.
- Carried Out Gap analysis and was engaged in an analysis of the technical specifications of the current system and the infrastructure requirements.
- Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
- Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component-Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
- Analyzed Use Case specifications and Use Case models for technical criteria.
- Created weekly Claim reports for management and administration purposes.
- Wrote SQL queries to validate data after testing the changes.
- Involved in maintaining the Requirements Traceability Matrix (RTM) across deliverables.
- Documented User Specifications with MS Word as the editing tool and Rational Rose to develop the Use Cases.
- Conducted ad-hoc analysis to support business initiatives and address specific financial queries from various departments.
- Environment: RUP, Gap Analysis, MS Office, MS Visio, MS Project, SQL, Quality Center, and Windows.
Business Analyst
Magellan Health
Phoenix, AZ
04.2018 - 06.2020
- Involved in gathering requirements, identifying and preparing Use Case specification documents, creating a Trace-ability matrix, and tagging it in the Rational Requisite Pro.
- Developed Use Case diagrams, business flow diagrams, Activity/State diagrams, and Sequence diagrams using Rational Rose so that developers and other stakeholders can understand the business process.
- Lead requirements gathering sessions, create process flows and produce documentation.
- Manage all business stakeholders and the project teams to desired expectations.
- Analyze requirements and specifications and identify alternatives to problems or opportunities, and then recommend a solution to allow stakeholders to select the best option.
- Identify gaps between existing and desired environments. Make multiple suggestions then justify the best solution.
- Designed and developed project document templates based on SDLC methodology.
- Involved in Managing Data modeling projects from Logical design and implementation of Sybase Database.
- Designed and developed all Use Cases and UML models using Rational and Visio.
- Managed meeting sessions with the committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring, and Asset Management.
- Prepared detailed design documents to translate business processes effectively for developers and product managers using MS Visio.
- Conducted interviews with various business users to collect requirements and business process information using MS Visio.
- Coordinate internal resources and third parties/vendors for the flawless execution of projects.
- Effective management of stakeholder relationships at all levels of the business (Both internally and third-party suppliers).
- Responsible for conducting As-Is To-Be Gap analysis to find out the current state of the system and the required state of the system.
- Environment: MS Office Suite (MS-Word, MS Excel, MS- PowerPoint, MS Project), RUP, Requisite Pro, Windows.
Education
Master’s - project management
University of the Cumberland’s
Williamsburg, KY08.2023
Master’s - business administration
New L J Institute of Engineering and Technology
India01.2015
Bachelor of Commerce - undefined
New L.J commerce college
India01.2013
Skills
- Project Methodologies: Waterfall, Rational Unified Process (RUP), UML, Agile
- Business Modeling Tools: MS Visio, Rational Rose, ERWIN
- Requirement Management Tools: Enterprise Architect, Notes 7, Rational Requisite Pro
- Defect Tracking Tools: Rational ClearQuest, Bugzilla, Quality Center, Team track
- Business Applications: Microsoft Office Suite- MS Word, Excel, Outlook, PowerPoint, Software Application Testing Life Cycle
- Quality Assurance: Configuration management Tools: Visual Source Safe (VSS), Subversion
- Databases: SQL Server, Oracle, MS Access
- Operating Systems: Windows XP, UNIX
- Data analysis
- Requirements gathering
- Team collaboration
Timeline
Revenue Account Systems Business Analyst
Carnival Cruise
06.2023 - Current
Business Analyst
Home Street Bank
10.2021 - 06.2023
Business Analyst
Prudential Bank
07.2020 - 09.2021
Business Analyst
Magellan Health
04.2018 - 06.2020
Master’s - business administration
New L J Institute of Engineering and Technology
Bachelor of Commerce - undefined
New L.J commerce college
Master’s - project management
University of the Cumberland’s