ALPANA SENGUPTA
CA 94303
**********@*****.***
PH# 214-***-****
Summary:
Software Consultant with several years of experience in Systems/Business and Quality Analyst/Project Management in Client/Server, middleware and Web based and cloud applications. Excellent professional interpersonal skills to independently gather/analyze requirements. Passionate to deliver viable business solutions to the stakeholders, partners and various internal teams based on qualitative and quantitative analysis.
Professional Experience:
Workday
Sr. Business Analyst June 2024 – October 2024
Location: Pleasanton, CA
Worked at Workday subscription based WSP ( Workday Success Plan) application. This application is a critical customer service application ( B2C) that provides support to workday’s entire customer base. As a Sr. BSA I am involved in gathering enhancements to WSP applications built on the Salesforce CRM System.
I have been working closely with business in gathering critical enhancements and converting them into user stories with detailed acceptance criteria. I am involved in projects related to customizing features on Salesforce instance with emphasis on Sales and Service cloud .
Responsibilities:
●Working very closely with business in gathering both functional and technical requirements for all new enhancements and existing bugs. (this involved small and mid- sized projects)
●Responsibilities included managing/driving mid size projects from requirements gathering to production deployment
●Defining clear use cases and converting them to functional user stories using Jira as project management tool and following Agile methodology
●Working closely with development ( both onsite and offshore) to implement Workday solutions for business who are part of the engagement tools that help resolve customer facing challenges
●Gather requirements around UI/UX interface and help solution some requirements to enhance user centric business needs
●Worked on understanding business flows related to different personas and understand their detail journey
●Understanding complex business flows and data flow with the various integrations supporting the application
●Develop Process Flow diagrams and activity diagrams to help understand overall data flow within the systems
●Working with QA and driving UAT phase of SDLC life cycle ( setting data and designing test scripts)
●Understanding and documenting critical data flow through data collection, data analysis and data interpretation
Salesforce
Sr. BSA (Product owner) April 2018– January 2024
Location: San Francisco, CA
Marketing Dept: Worked as Product Analyst in Marketing Technology department dealing with Campaigns and ON24 Webinar platform ( digital marketing) . Responsibilities included managing projects related to product enhancements. Working closely with stakeholders from gathering requirements and finally deploying the features to production .
Worked closely with the Product Data science team involved in data lineage validation, metadata management, Data governance and data quality and integrity.. Working with third party vendors was a major part of my responsibilities. I was responsible for validating dashboards, running reports related to campaign success and KPI numbers using salesforce propriety Einstein data analytics tool.
IT Enterprise Integration: Responsibilities included help integrate various Salesforce Internal business systems and applications that run critical Business. Worked on projects which involved data integration between workday, org62, serraview, DreamForce.
Worked on H@T Integration Reliability which aims to gain customer confidence by improving performance, reliability by improving the data sync between source (Org62) and Target systems (DreamForce) using latest Mule Soft Technologies.
Responsibilities:
●Worked very closely with the business to Identify, evaluate and analyze the issues within existing business processes and help create efficient solutions
●Understand the complex business flows between the source and Target Systems.
●Analyze Data within the systems using Excel and SQL Management Studio.
●Generate BRD, FSD with and FRD. Create training materials
●Developed Process flow diagrams/Activity Diagrams, Test cases and use cases
●Performed Functional, Regression and Load (Performance) and UAT testing.
●Performed Data analysis on Performance Metrics using advanced Excel Formula, Pivot table and VLookup.
●Successful in leading project deliverables with globally located teams.
Environment: Java, JSON, ALM, Jira, SQL Server 2008, ASP.net, Oracle, NT, Agile/waterfall Methodology, Oracle 11.0, Gus, Rally,Jira, Confluence, SharePoint.
Wells Fargo
Sr. Business Analyst August 2017– March 2018
Location: San Francisco, CA
Worked on SVP Store Vision Platform application which is (Banker Sales Platform). The application is browser-based sales and service application built on a complex architecture Interfacing with several Banks downhill custom applications.
Responsibilities:
●Responsibilities included ability to comprehend, investigate, analyze complex business requirements. Understanding data flows between interconnected systems.
●Develops complex Functional specifications off BRD for processes and systems which span across multiple business domains.
●Developed and documented comprehensive business cases for detailed analyses impacting both upstream and downstream solution components.
●Participated with stakeholders and appropriate IT teams (e.g., Solutions Delivery, Infrastructure, Enterprise Architecture) to come up with a workable business solution.
●Analyzed data through extraction and manipulation using excel, SQL Queries and MicroStrategy tools, to design data driven use cases .
●Worked very closely with Development and QA all through the SDLC cycle.
●Supported UAT test efforts and provided post implementation.
●Developed Comprehensive training materials using visio.
Environment: Java, Soap Xml, REST API, JSON, ALM, Jira, SQL Server 2008, ASP.net, Oracle, NT, Agile/waterfall Methodology, Oracle 11.0, Rally, Data Warehouse.
UnitedHealth Group
Quality Analyst/Business Analyst November 2014– April 2017
Location: Dallas, TX
Experienced with requirements analysis involving health care claim pricing, health care claim benefits, Charge back and end to end claim processing. This included submission, processing, pricing, benefits, finalization, remittance, adjustments. Worked on WCF and Client Server applications in the areas involved with Payment integrity solutions. Worked on transaction and payment details between patient/pharmacy/physician/Medicare and workers compensation Modules.
Responsibilities:
• Participated in Team planning sessions to review product requirements and design.
• Involved in estimating hours required to successfully complete the project.
• Knowledge of Agile Methodology, and breaking and sizing each user story .
• Creation and presentation of Test Strategy/Plan Document with business partners
• Execution of user story ( Functional Testing ), starting from creating of test scripts to
execution and demo/acceptance from business partners. This involved documenting every
result in detail in ALM.
• Extracting and testing data using SQL Server.
• Involved in In-sprint automation for every user story using Coded UI.
• Involved in testing transactions to Legacy applications ( CDB, COSMOS, Facets).
• Understanding defect Management process and Company’s MBO Guidelines.
• Ability to analyze and evaluate XML data through Soap UI and windows service calls
• Tested RESTful Web APIs.
• Tested WPF user interfaces applications.
• Tested RabbitMQ Messaging Framework.
• Involved in integration testing involving cross multiple teams
• Facilitate user acceptance testing.
• Maintained both automation and Manual Regression folder.
• Used Rally for story sizing and defect tracking tools.
Environment: .net, Soap Xml, REST API, JSON,SQL Server 2008, Java, ASP.net, Oracle, NT,
UNIX, Agile Methodology, Oracle 11.0, Java, Rally
Sr. IT Quality Analyst
Bank Of America
November 2010 – November 2014
Worked as a Lead in the department of Mortgage testing all complex applications dealing with foreclosure, bankruptcy, Short Sale, Equator DIL and other Vendor related Complex applications. Worked as a lead on various applications with onshore-offshore models and successfully executed the projects to completion. Worked in production support as per project needs.
Education
BS Engineering Texas A&M University
Minor in Computer Science Texas A&M University
REFERENCES:
Available on request