SWETA SONULKAR – Business Analyst

PROFESSIONAL SUMMARY:

Business Analyst with over 7 Years of experience in business process analysis modeling, business requirements gathering, analysis, design, and development of web-based and client/server applications.

Possessing Salesforce Administrator, Scrum Fundamentals, Six Sigma Yellow Belt and Google Analytics certifications.

Expertise in understanding and supporting the client with requirements definition, analysis, design, testing, system documentation, and user training.

Strong knowledge of Software Development Life Cycle (SDLC) including UML, Waterfall, and Scrum/Agile.

Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling tools like Smart Draw, Draw.io & MS Visio.

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 diagrams), also Class Diagrams based on UML Methodology using MS Visio.

Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.

Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost-benefit analysis, risk analysis, testing, development of functional specifications.

Strong understanding of the business process, Definition of the Scope of the Project, User and system requirements, and implementation to functional and technical specifications.

Experience in Test Planning, Test Preparation, Test Execution, and Issue Resolution and Report in TestRail

Preparing analytical reports/documents to improve the business based on the historical data existing in the warehouse system using SQL.

Ensure data governance by adhering to standard data policies and practices.

Utilize Tableau and PowerBI for reporting and visualization purposes using Power Query's data modeling capabilities to establish relationships between different data tables, define measures, and create calculated fields as needed and Visual Basic for Applications (VBA) to automate repetitive tasks, add interactivity, and enhance the functionality of the reports. This may include automating data refreshing, report generation, data validation, and other custom functionalities as required.

Review and audit the code for quality assurance purposes.

Write TSQL queries to extract, manipulate, and analyze data.

Exceptional problem-solving and sound decision-making capabilities, recognized by alternative solutions, and confident, accurate, decision-making coupled with excellent communication and interpersonal skills.

Liaised with customers, development, and operations.

Followed established release management guidelines and oversaw acceptance and functional testing.

Strong verbal and written communication skills

Prior experience with Atlassian tools such as JIRA and Confluence

TECHNICAL SUMMARY:

Business Skills

SWOT Analysis, AS-IS TO-BE Gap Analysis, Risk Analysis and Management, RTM, Stakeholder analysis, Root cause analysis

Databases

SQL Server 2008/2012, MySQL

Programming Languages

Java, EJB, J2EE, JavaScript, Servlets & OOPS

Application/Web Servers

Weblogic 6.0 to 12c, JBoss & Glassfish, Apache Web Server & iPlanet Web Server

Configuration Management

Git, Git-Hub

Reporting/BI

Testing Tools

Microsoft Power BI, Tableau, Google Analytics, TestRail, Jira, UiPath(Automation)

Documentation

MS Excel, MS PowerPoint, MS Word, Confluence

GUI Prototyping Tools

Pencil, Justin Mind, Draw.io, LucidCharts, SmartDraw, Concept Draw, Visual Paradigm, MS Excel, MS Visio, Balsamiq, Miro, Moqups, Figma, Webflow, form.io

Domain Knowledge

Healthcare, Hospitality, Property and Travel

EDUCATION:

Bachelor of Engineering: Gogte Institute of Technology, Belgaum India – 2006

WORK EXPERIENCE:

Worked as a Freelancer for Freelancer.com as a Business Analyst from Oct-2012 to Jan 2023.

Worked with Wissen Infotech Ltd, India as a Software Engineer from Mar-2008 to Oct-2008.

Worked with Tejas Tech, India as a Junior Software Engineer from Jan 2007 to Feb 2008.

PROJECTS:

Project 1: Gloucester County Habitat for Humanity

Duration: Mar 2023 – May 2023

Role: Sr Business Analyst

Project Description: The project aims to provide affordable housing for low-income families. It recognizes the challenges faced by these families in securing safe and decent housing and seeks to address this issue by creating affordable housing options tailored to their needs. The project involves various activities such as Project Development, fundraising, community engagement, and partnership building.

Responsibilities:

Conducting thorough analysis of project requirements, including gathering and documenting business needs and objectives.

Collaborating with stakeholders to define project scope, goals, and deliverables.

Facilitating workshops and meetings to elicit requirements and ensure a comprehensive understanding of project objectives.

Analyzing and documenting current business processes, identifying areas for improvement, and proposing solutions.

Developing and maintaining project documentation, including business requirements, functional specifications, and use cases.

Conducting feasibility studies and impact assessments to evaluate the viability of proposed solutions.

Collaborating with cross-functional teams, including IT, finance, and operations, to ensure alignment and successful implementation of project initiatives.

Managing and prioritizing requirements, ensuring they are clearly defined, measurable, and traceable.

Performing gap analysis to identify discrepancies between current and desired states and recommending appropriate solutions.

Collaborating with technical teams to translate business requirements into system specifications.

Participating in the testing and quality assurance process to ensure that delivered solutions meet business needs.

Providing ongoing support and assistance to project stakeholders, addressing any issues or concerns that may arise.

Monitoring project progress, identifying risks and issues, and implementing mitigation strategies as needed.

Providing guidance and mentoring to junior business analysts, fostering their professional growth and development.

Keeping abreast of industry trends, best practices, and emerging technologies relevant to the project.

Environment:

1.Fundraising Platforms:

Donorbox

GoFundMe

2.Customer Relationship Management (CRM) Systems:

Salesforce Sales Cloud

3.Project Management and Collaboration Tools:

Trello

Asana

Jira

Microsoft Teams

Slack

4.Data Analysis and Reporting Tools:

Microsoft Excel

Microsoft Power BI

Google Analytics

5.Communication and Marketing Tools:

Mailchimp

Hootsuite

Canva (for graphic design)

6.Database Management Systems:

MySQL

7.Document and Content Management Systems:

Microsoft SharePoint

Google Drive

Dropbox

8.Social Media Platforms:

Facebook

Twitter

Instagram

LinkedIn

9.Web Development Technologies:

HTML/CSS

JavaScript

PHP

Content Management Systems (e.g., WordPress)

10.Email and Communication Platforms:

Microsoft Outlook

Gmail

Google Workspace (formerly G Suite)

Project 2: Insurance Investments.

Duration: Oct 2022 – Feb 2023

Role: IT Business Analyst

Project Description: The project is a software system that combines credit card application, credit score evaluation, underwriting, approval/denial processes, and credit card processing and management. The system will provide a user-friendly interface for users to apply for credit cards, receive credit score evaluations, undergo underwriting processes, and receive approval or denial decisions. The system will also include features for managing credit card transactions and processing payments. The aim of the project is to provide a comprehensive solution for the credit card application and management process, reducing manual effort and improving the overall efficiency and user experience.

Responsibilities:

Responsible for gathering and analyzing requirements for new projects, prioritizing and planning work, participating in sprint planning and reviews, and contributing to release planning in an Agile/Scrum Environment, involve working with cross-functional teams to ensure that projects meet the needs and wants of customers and stakeholders and are delivered on time, within budget, and to a high quality.

Work with stakeholders to understand their business requirements and translate them into functional and non-functional requirements for the software system.

Document the requirements in a clear and concise business requirement document that outlines the project scope, objectives, and functional requirements.

Create wireframes and prototypes of the user interface to help stakeholders visualize the product using Web flow and form.io form builder.

Analyze the existing credit card application and management process to identify areas for improvement and recommend changes to streamline the process.

Develop a detailed design for the system, including architecture, data models, user interfaces, and system interfaces.

Test the system to ensure that it meets requirements and works as intended, including unit testing, integration testing, and system testing.

Deploy the system to the production environment and ensure that it is properly configured and secured.

Identify and manage risks associated with the project, including technical, operational, and business risks using FMEA and root cause analysis.

Establishing data governance policies and procedures, ensuring data quality standards, defining data ownership and stewardship, and implementing data security controls.

Collaborating with Tableau and Power BI experts to create reports and visualizations that provide real-time insights into the credit card application process.

Creating a data model in Power BI using Power Query's data modeling capabilities to establish relationships between different data tables, define measures, and create calculated fields as needed.

Used Visual Basic for Applications (VBA) to automate repetitive tasks, add interactivity, and enhance the functionality of the reports. This may include automating data refreshing, report generation, data validation, and other custom functionalities as required.

Creating reports and dashboards to provide insights into the credit card application process. These reports should be user-friendly and easy to understand, providing actionable insights that can be used to improve efficiency and user experience.

Working with the software development team to ensure that the software is developed, tested, and deployed in a consistent and predictable manner, adhering to industry standards and best practices.

Collaborating with the development team to regularly review and audit the code to ensure that the software is secure, reliable, and scalable. This will involve performing code reviews, testing, and implementing security controls to protect against cyber threats.

Writing T-SQL queries to retrieve, manipulate and analyze data from the database. Collaborating with the database team to retrieve and manipulate data from the databases. Ensuring that queries are optimized for performance and adhere to industry best practices.

Working with the IAM (Identity Access Management) team to create and manage user accounts, establish access controls, monitor user activity, and enforce security policies and procedures.

Manage changes to the project, ensuring that they are documented, approved, and implemented in a controlled manner.

Train users and support staff on how to use the system, including how to perform credit score evaluations, underwriting, approval/denial, and credit card processing.

Perform ongoing maintenance and support for the system, including bug fixes, upgrades, and performance optimization.

Ensure that the system is in compliance with relevant laws, regulations, and industry standards, such as the Payment Card Industry Data Security Standard (PCI DSS).

Developing documentation, including user manuals and process flows, to support the use of ISO 20022, ISO 8583, Base24, FedNow, ACH, and SWIFT systems and Card Management.

Monitor the system regularly to ensure that it is functioning as intended and to identify potential issues early on.

Worked closely with the QA and testing team and assisted them with creating various test scenarios and test cases for User Acceptance Testing to ensure that the system provides business value and caters end user needs and tested API using POST, PUT, GET, DELETE on API testing tool Postman, and documented the same.

Project 2: Virtual Jobs Fair Portal.

Duration: Jul 2018 – Dec 2021

Role: Sr Business Analyst

Project Description: An online platform that allows job seekers and employers to connect, network, and interact in a virtual environment. It provides a platform for employers to showcase their job openings and for job seekers to search and apply for job opportunities. The virtual job fair portal can include features such as virtual booths, live chat, and video conferencing capabilities to facilitate virtual interactions between job seekers and employers. This type of platform is becoming increasingly popular as a way for employers to reach a wider pool of job candidates, and for job seekers to access job opportunities from the comfort of their own homes.

Responsibilities:

Work with stakeholders to gather requirements and understand the business needs for the job fair portal.

Document the requirements in a clear and concise business requirement document that outlines the project scope, objectives, and functional requirements.

Create wireframes and prototypes of the job fair portal user interface to help stakeholders visualize the product using Webflow and form.io form builder tools.

Translate the business requirements into user stories that define the functionalities required for the job fair portal.

Use Unified Modeling Language (UML) to create diagrams that help to clarify and visualize the system architecture and workflows for the job fair portal.

Work with the development team to ensure that the UML diagrams accurately reflect the system design.

Analyze the data stored in the legacy HRIS system and determine the best approach for migrating it to the new job fair portal.

Write TSQL queries to extract, manipulate, and analyze data.

Work with the data team to extract, transform, and load the data into the new system using Microsoft Power BI.

Work with the Scrum Master and development team to plan and execute sprints, participate in daily stand-ups, use Srumban for task management and provide status updates to stakeholders.

Attend sprint retrospectives and provide feedback on how to improve the process and work more effectively in the Agile Scrum methodology.

Work closely with the development team, stakeholders, and other team members to ensure that the job fair portal is developed and delivered on time and within budget.

Facilitate communication and collaboration between all stakeholders to ensure that everyone is on the same page and that the project is moving forward as planned.

Conducted SWOT, and gap analysis (AS-IS, TO-BE), and stakeholder analysis (RACI matrix).

Translate stakeholder requirements into different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, and data flow/data model (RUP methodology) diagrams followed by design documents and present them to the SME for validation and getting the signoffs.

Created Business Requirement document (BRD) and Functional Requirement document and maintained the Requirement Traceability Matrix (RTM) related document.

Assisted in Testing Strategy for the portal and validated the test case, test plan document, test scenarios with testing team.

Ensure data governance by adhering to standard data policies and practices.

Review and audit the code for quality assurance purposes.

Participated in UAT, SIT and Release cycles and drafted the User manuals for Users.

Project 3: Ridesharing app

Duration: Oct 2016 - Jul 2018

Role: Business Analyst

Project Description: With ridesharing, passengers can find a ride via a mobile app and finds the closest available car and matches it with a passenger and know instantly when a vehicle will arrive based on this information, can accept, or decline the ride with a driver. The app allows passengers to choose what type of car with a driver they want – a budget or a luxury one. Secondly, passengers are always informed about the ride price before getting into the car. The mobile apps let users pay with a credit card and not worry about having enough cash for a driver. Most ride-sharing mobile apps allow users to leave tips and rate ratings for a driver to be paid with their credit card.

Responsibilities as a Business Analyst:

Responsible for communication and collaboration with stakeholders to gather and analyze business requirements,

Creating project scopes and use case documents.

Identifying process gaps to implement process improvements resulting in a 10% increase in project efficiency (Organizational Change Management Plan Strategy).

Proposed business strategies conducted gap and stakeholder analysis.

Collaborated with UX teams to design mockups and prototypes and translated stakeholder requirements into functional specifications and user stories.

Managed risks related to project implementation and testing.

Increased customer satisfaction by 17%, and mitigated defects by 15% by conducting gap analysis and root-cause analysis.

Consulted with clients to assess the quality of data and metadata, created user guides and manuals, and improved operational performance through various financial forecasting and planning methods.

Collaborated and negotiated with stakeholders in defining project scope boundaries, SWOT and gap analysis (AS-IS, TO-BE), and stakeholder analysis (RACI matrix).

Translate stakeholder requirements into different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, and data flow/data model (RUP methodology) diagrams followed by design documents and present them to the SME for validation and getting the signoffs.

Created Business Requirement document (BRD) and Functional Requirement document and maintained the Requirement Traceability Matrix (RTM) related document.

Working with the team to identify personas and define use cases, epics, user workflows, detailed requirements, and user stories with well-defined acceptance criteria.

Building and maintaining relationships with cross-functional internal teams and external customers to understand user needs, translating findings to actionable feature planning artifacts, and prioritizing the feature/defect backlog.

Actively participated in several iterations of the domain-related customer tasks in a Scrum team environment and participated in backlog review and Sprint planning sessions and other Scrum ceremonies, following Agile methodology

Planned, facilitated, and reported on quality assurance testing efforts, using Agile Testing (Test Cases), and Participated in UAT, SIT and Release cycles resulting in annual savings of $2,500.

Facilitate monthly meetings with clients to connect project planning and analytics, budgeting, commission calculation, demand planning, financial forecasting, profitability modeling, project planning, quota planning, and workforce planning to improve operational performance.

Create User guides (or user manuals) to help users know exactly how to use a software application or product.

Project 4: Rental Residential®

Duration: Oct 2014 – Sept 2016

Role: Business Analyst

Project Description: The Rental Residential project involves creating a website and mobile app to manage and facilitate the rental of residential properties. This includes allowing property owners to list their properties, and tenants to search for and book properties. Effective asset management was crucial to ensure the accurate listing, verification, and maintenance of residential properties on the Rental Residential website and mobile app, and to provide a seamless experience for property owners and tenants using the platform.

Responsibilities:

Understanding and identifying the business requirements of the residential property management system.

Responsible for overseeing the asset management aspect of the project. This included ensuring accurate property listing and verification using Yardi, managing the data model and database, conducting quality assurance and user acceptance testing, implementing change requests, and generating reports and documentation.

Developing scope and use case documents, as well as identifying gaps in different processes.

Implementing process improvement initiatives across the business improvement model to increase project efficiency by 10%.

Collaborating with stakeholders in defining project scope boundaries, conducting SWOT analysis, and stakeholder analysis.

Analyzing clients' business requirements and processes through document analysis, interviews, workshops, and workflow analysis.

Analyzing the data flow, processes, and requirements to develop a data model for the project, including creating an ER diagram and defining the database structure and schema.

Translating stakeholder requirements into functional specifications, user cases, and other tangible deliverables.

Maintaining the Requirement Traceability Matrix (RTM) related document and working with the team to identify personas, define use cases, and prioritize the feature/defect backlog.

Building and maintaining relationships with cross-functional internal teams and external customers to understand user needs.

Participating in Scrum team environment, including backlog review and Sprint planning sessions, and following Agile methodology.

Planning and conducting quality assurance testing efforts, participating in UAT, SIT and Release cycles.

Identifying impacts and implementing change requests through change management that follows the predetermined approval process.

Identifying potential risks and issues and working with the project team to develop mitigation strategies and contingency plans.

Using Power BI for data analysis, creating reports and dashboards.

Creating user guides to help users know exactly how to use the software application.

Maintaining organization of complex projects and tasks by tracking notes, tasks, and appointments in Microsoft Office Suite.

Project 5: Eat Centrally – Food Delivery and Ordering Website Application

Duration: Oct 2012 – Sept 2014

Role: Business Analyst

Project Description: The online food delivery platform aimed to provide a seamless ordering and delivery experience for customers, with features such as restaurant search, menu selection, and ordering. The platform also had a membership system with different levels (Gold, Silver, Platinum) based on order history, offering discounts and coupons for customers. The platform consisted of three subversions - one for end-users, one for delivery persons, and one for vendors. The development process utilized a connected planning tool to ensure optimal organization and responsiveness. Additionally, the platform offered a special discount on birthdays.

Responsibilities:

Gathering and analyzing business requirements from stakeholders.

Translating business requirements into technical specifications and communicating them to the development team.

Conducting market research and competitor analysis to identify opportunities and trends in the food delivery industry.

Assisting in the development of a detailed project scope, including timelines, resources, and budget estimates.

Understanding the KPIs and Requirements Documents.

Working with Data Warehouse teams and understanding Data Mart.

Designing and Developing reports using Tableau.

Testing and validating the generated reports in collaboration with Business Users.

Facilitating communication between stakeholders, the development team, and project managers to ensure project progress is aligned with the business objectives.

Identify potential risks and challenges associated with the change and develop a strategy to manage them(Organizational Change Management Plan strategy).

Participating in user acceptance testing to ensure the delivered solution meets business requirements.

Developing and maintaining project documentation, including business requirements documents, functional specifications, test plans, and user manuals.

Identifying and mitigating project risks, including resource constraints, technical challenges, and changes in business requirements.

Providing ongoing support to the end-users, delivery persons, and vendors to ensure the platform is functioning optimally.

Continuously evaluating and improving the platform's performance and user experience based on customer feedback and usage data.

Organization: Wissen InfoTech Pvt. Ltd, India

Client: GE Healthcare, USA

Duration: Mar 2008- Oct 2008

Role: Software Engineer(Middleware Admin)

EPIC (Electronic Health Record), a widely used electronic health record system that provides a comprehensive and integrated approach to managing patient information. It helps healthcare providers to manage patient data, track appointments, manage billing, and maintain patient history, among other things.

Worked as Software Engineer and helped my team to set up a development environment for initial work and later turned the same into a test, staging, and production environment. Deployed Java and J2EE applications and provide on-call support for the incident resolution in production for both internet and intranet applications.

Responsibilities as Weblogic, JBoss, IIS, and Glassfish Administrator:

Improving system uptime by 5% through the installation and configuration of application and web server instances

Improving application performance by 10% through the creation and configuration of server domains, data sources, machines, and node managers

Reducing defects by 15% through the deployment and testing of applications in dev/stage environments

Identifying and addressing potential issues through load testing, improving system stability and performance

Maintaining system uptime through timely resolution of issues and monitoring of server and application health status

Reducing downtime by 20% through troubleshooting and resolving issues in production

Improving system stability and performance through the upgrading of Weblogic domains

Providing day-to-day production support, including bug-fixing and problem-solving

Collaborating with the customer, reporting, and IT teams to develop initiatives that improved internal and external reporting and business processes.

Supporting the deployment of a healthcare risk management platform

Increasing credentialing efficiency by 15% through the management of the Credential Stream for Provider Credentialing system.

Environment: EHR, HL7, Linux, MySQL, Windows 2000 Server, Weblogic 8.1, J2EE, Apache 2.0, and Oracle 8, EDI, Unix, VMware, CA Service Desk, eHealth, Apache JMeter, Health Insurance Portability and Accountability Act (HIPAA) and International Classification of Diseases (ICD)-10 compliance, Git, Jenkins

Organization: Tejas Tech, India

Duration: Jan 2007 to Feb 2008

Role: Jr. Software Engineer

Worked as Software Engineer and helped my team to set up a development environment for initial work and later turned the same into a test, staging, and production environment. Deployed Java and J2EE applications and provided on-call support for incident resolution in production for both internet and intranet applications.

Responsibilities:

Installing & configuring application & Webserver instances.

Creating and configuring server Domains, Data sources, Machines & Node Managers.

Deploying and testing applications in dev/stage environments.

Performing Load Tests to monitor resource utilization by the application.

Starting and stopping servers and monitoring servers and applications’ health status.

Sharing logs to users from the server.

Working closely with System Administrators.

Production Troubleshooting.

Upgrading the WebLogic domains

Day to Day production support including bug fixing, problem-solving, and coordination with the DBA team, end users, and interfacing system teams as required.

Documentation of regular issues

Collaborating with customer, reporting and IT teams to develop initiatives that improve internal and external reporting and business processes using proprietary project and portfolio management software suite.

Environment: Linux, Windows 2000 Server, WebLogic 8.1, J2EE, Apache 2.0, and Oracle 8, Git. Jenkins, Visual studio, Eclipse IDE,VMWare.

HARD SKILLS

Software Development

Software Development Life Cycle (SDLC)

Supply Chain/Logistics Management

Order and Inventory Management

Information Technology

Agile Methodology

Waterfall Methodology

Scrum

ROI and Cost – Benefit Analysis

SWOT analysis

AS-IS TO-BE Gap Analysis

Risk analysis and management

Root cause Analysis

Contact this candidate