Business Analyst Process

Akhila Sandiri

Sr. Business Analyst

Email: ******.******@*****.*** 480-***-****

Professional Summary:

Over 7+ years of IT experience including 5 years of experience in Business Analysis, Intelligence, and Data analysis.

Experienced in business process analysis, gathering requirements from stakeholders, and preparing Business and Functional requirements documents.

Extensive experience in Agile methodologies, facilitating Sprint planning sessions that align team efforts with project goals and timelines.

Proficient in crafting detailed User Stories that reflect business needs, ensuring clarity and alignment among stakeholders and development teams.

Experienced in maintaining product backlog (user stories) and aligning them with functional and technical requirements.

Experienced in generating and analyzing custom reports for management and various business unit personnel to provide detailed information on key performance indicators using Tableau, Qlik Sense, Power BI, and Excel.

Proficient in writing SQL Queries for backend testing to check and analyze data integrity and validation.

Experienced in performing hands-on workflow analysis and process engineering to identify inefficiencies and optimize business process, for enhancing operations and support objectives.

Worked extensively with Data Migration from multiple sources to a Data warehouse by providing Data Mapping.

Executed various levels of testing including functional, user acceptance, integration, and performance to verify the client's needs are met.

Effectively provided production support for key business applications and strong experience in troubleshooting, prioritization of production issues, assessing the impact, and providing alternative solutions.

Strong knowledge & experience working with cross-functional teams.

Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

Act as a critical liaison for development teams, providing clear and actionable requirements, addressing ambiguities, and ensuring a shared understanding of project deliverables.

Committed to enhancing Agile processes by identifying areas for improvement, promoting best practices, and fostering a culture of innovation within teams.

Technical Skills:

Azure DevOps, Rally, Jira, Confluence, Visio, Lucid chart, Microsoft Office Excel, Power Point, SQL, SOQL, Reports & Dashboards

Work Experience:

Medica Group, Minnetonka, MN May 2022 – July 2024

Sr Analyst

Reviewed, collected, and documented business requirements, application infrastructure, and modules/ interfaces.

Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.

Translate high-level requirements into functional and technical user stories in Azure DevOps.

Document requirements using the Agile User Story format and create User Stories and Acceptance Criteria in Azure.

Analyze defects that have been reported in Azure and send them over to the developers for a fix.

Collaborate meetings with Program Managers and various other counterparts to guide them through the process and Confluence Methodologies.

Work with Exchanges for changes in methods, procedures, policies, and workflows affecting Medical Partner program files in compliance with compliant processes like HIPAA formats and accredited standards ANSI.

Assist in the creation of the Functional Design Document from the Business Requirements Document which was used as the reference by the development team while preparing the design and held the responsibility of the required data setup for testing.

Conduct business validations covering the following deliverables: Facets Providers, Claims, and Membership.

Perform felid-by-field mapping of the interface between the parent EMR system and the downstream system.

Responsible for UI mock-ups and documentation attachments for User Stories.

Review and accept completed User Stories with Business and update User Story status in Azure.

Responsible for all contractual requirements related to provider enrollment and credentialing, provider file maintenance, provider inquiry, provider publications, and provider training.

Manage planning for data cleaning, and clinical data listing review, and coordinate the process for reviewing data listing by the clinical team.

Create and execute queries to verify data results during QA back-end testing.

UnitedHealth Group, Chicago, IL Sep 2020 to Apr 2022

Sr. Analyst

Responsibilities:

Worked in Agile methodologies using Scrum in moving the Business functionality from existing legacy applications to Salesforce CRM for better efficiency and enhancements.

Involvement in SDLC which includes gathering business requirements, architecture, design documents, planning, development, deployment, and maintenance.

Performed Risk Analysis and Impact Analysis to be prepared for potential business and technical risks.

Analyzed documented business needs, and detailed data requirements by conducting JAD, One-on-One sessions with multiple stakeholders.

Provided in-depth analysis of the business processes and customer feedback on the recommendations to improve the processes.

Developed and managed the execution of the Change Management strategy, plan, and approach for a major Salesforce.com release as well as a release focused on the integration of Siebel and Salesforce.com.

Planned and conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to the client's Salesforce technology enhancement and initiatives.

Prepared business requirement documents (BRD), Use cases, UML, Process Flows (BPM), and Data Mapping

Customized dashboards to provide daily forecasts and track opportunities and customer engagement.

Customized Reports to track usage for productivity and performance of business centers and their sales teams.

Collaborated with all project teams including Project Management, Development, and Business Partners regarding setting up visibility securities like roles, profiles, and field-level securities.

Created numerous dashboards in Tableau Desktop based on the data collected from Insurance Apps by importing and blending data from MS Excel and CSV files along with Oracle Database tables.

Citibank, Irving, TX May 2019 to Aug 2020

Business Analyst

Responsibilities:

Gathered and analyzed business processes and requirements to identify the best implementation options in Salesforce.

Assigned tasks to the System Administrator as required to perform administrative tasks such as setting up users, creating or updating fields, custom objects, page layout, approval processes, dashboard, and code implementation.

Performed some basic administrative functions as needed as assigning users to permission sets, the addition of fields to list views, and more.

Coordinated Salesforce training programs, including working with the Director, and Lead CRM Manager to identify new features, functionality, and training needs.

Created journeys and implemented marketing campaigns using marketing cloud tools like Journey Builder, Email Studio, and Automation Studio.

Maintained and communicated system metrics to track trends in usage and data integrity as well as regularly auditing data to uncover data integrity issues and/or opportunities for process improvement.

Involved and interacted with various business user groups to gather the requirements for CRM implementation.

Created various dashboards per the requirement of the user and business needs.

Developed and configured various Reports for different user profiles based on the needs of the organization.

Participated in the training sessions provided by the Salesforce team and supported end users.

Performed GAP analysis by identifying existing processes and technologies and documented the enhancements needed to meet the end-state requirements.

Assisted testing teams in Regression testing and Performance testing.

Participated in Navigation testing, Smoke testing, and UAT of each build during the various phases of the application.

Involved in preparing a simple and detailed user manual for the CRM Salesforce application.

Client: GE, Schenectady, NY.

Sr Administrator Mar 2018 to Apr 2019

Responsibilities:

Developed various Custom Objects, Tabs, Entity-Relationship data models, validation rules, workflow rules & approval processes.

Customized user Roles, Role hierarchies, Profiles, and Sharing settings to ensure that the protected data is available only to the authorized users.

Create and maintain lists, data extensions, segmentation groups, e-mail tracking, reports, and dashboards.

Created journeys and implemented marketing campaigns using marketing cloud tools like Journey Builder, Email Studio, and Automation Studio. Developed and deployed A/B testing strategies to roll out the control version to be used in the final email campaign.

Involved in the integration of Salesforce with Pardot and responsible for implementing Marketing flows through the Pardot platform creating automation and segmentation rules.

Used Data loader to bulk load data into Salesforce from other databases.

Implemented data security by configuring OWD and by creating criteria & owner-based sharing rules on different objects.

Worked in an Agile environment and was involved in daily Scrum meetings to keep track of the ongoing project status and issues.

Build & monitor standard analysis and reporting for marketing campaigns.

Manage page layouts, fields, and system interface/capabilities.

Maintenance of data entry standards & data integrity process.

Manage data migrations/conversions from other data sources into Salesforce.

Developed and configured various Reports and Report Folders for different user profiles based on the needs of the organization.

Client: GE Capital, Norwalk, CT Jan 2017 – Feb 2018

Administrator

Responsibilities:

Involved in Case Management and Automated using queues, Assignment rules, Auto Response, and Escalation rules.

Maintains multiple user profiles, role hierarchy, security, sharing rules, and other Salesforce.com out-of-the-box access features.

Customized standard objects like Accounts, Opportunities, Contacts, Leads, Campaigns, Reports and Cases.

Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com subjects.

Implemented pick lists, dependent pick lists, lookups, master-detail relationships, validation, and formula fields to the custom objects.

Created new custom objects, assigned fields, and designed page layouts, custom tabs, components, custom reports.

Involved in data mapping and migration of data from legacy systems to SalesForce.com Objects and fields.

Involved in deploying changes across various environments using change sets.

Created Workflow Rules and approval Processes, Developed and supported customer support portal.

Managed multiple sandbox environments.

Customized the Dashboards to track usage for productivity and performance of business centers and their sales teams.

Education:

Bachelors from Dr. B.R. Ambedkar Open University-India- 2011

Contact this candidate