ALPANA SENGUPTA

**** ******* ***** **** ****

CA 94303

ad4b83@r.postjobfree.com

PH# 214-***-****

Summary:

Senior Product/Business Analyst with years of experience in digital marketing, business analysis requirement gathering data analysis and testing. Experienced with middleware, cloud and Web based applications. Passionate to deliver viable business solutions to the stakeholders, partners and various internal teams based on qualitative and quantitative analysis.

Professional Experience:

Sr. Business System Analyst (Salesforce Marketing) April 2018 – January 2024

Location: San Francisco, CA

Worked as Senior Product Owner /Business Analyst in Salesforce Marketing automation to help with development, implementation and execution of effective marketing campaigns through webinar using ON24 platforms. This involved application enhancements, merger, acquisition and integration projects

Responsibilities:

● Product owner ON24 webinar platform ( SME)

● Developed and maintained Salesforce integration with other systems. Worked with detailed data analysis and data sync between the two systems

● Liaison between business and Engineering team, gathering function requirements to enhance data sync

● Worked with the cross functional team impacted with the merger. Worked closely with developed as thy solutioned the requirements

● Created complex data flow diagrams using visio and did detail analysis on data scheme

● Worked closely with the business team to draw out detail merger plan

● Created test plan and test scripts for UAT testing. Supported business during UAT phase and test results

● Worked with cross functional team executing the test case and reporting bugs

● Collaborate with Marketing Managers to help run marketing campaigns using ON24 platforms

● Trained and supported users on Salesforce functionality and its integration with other down hill application

● Managed and analyze website traffic closely monitoring lead flow issues

● Tested data accuracy between the two platforms using Vlookups/Pivot tables both using excel and google sheets.

● Worked closely with third party vendors ( ON24 /Scribe/) troubleshooting their technologies for successful execution of the webinars

● Regularly audited Campaign and share lead generation reports with detail analysis to stakeholders within the organization

● Created dashboard and maintain reports to track performance metrics and analyze data to optimize campaign creations

● Manage mid size projects with 8 to 10 member team Sr. Product Analyst (Salesforce Enterprise Integration Engineering dept) April 2018– April 2021

Worked in the department of IT enterprise Integration. Responsibilities included helping integrate various lines of salesforce Internal business system and applications to the data that runs salesforce Business. Worked on projects which involved data integration between workday, org62, serraview, DreamForce based off latest Mule Soft Technologies. Responsibilities:

● Worked very closely with the business to identify, evaluate and analyze the issues within the existing business processes to create more efficient solutions.

● Involved in Defining and executing structured project plans from development to deployment. Proactively ensuring all the committed deliverables are on track for timely delivery.

● 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. Creation of training materials

● Developed Process flow diagrams/Activity Diagrams, Test cases and use cases

● Help Coordinate Functional, Regression, Load (Performance) and UAT testing.

● Performed Data analysis on Performance Metrics using advanced Excel Formula, Pivot table and VLookup .

● Recommended changes based on the data analysis..

● Managed Software development using Agile methodology.

● Worked with the team closely to implement several changes in SDLC methodology as needed for successful project delivery.

● Successful in leading project deliverables with globally located teams.

● Provided regular status updates and recommendations to Management using metrics. Environment: Java, xml,JSON, ALM,, SQL Server 2008, ASP.net, Oracle, NT, Agile/waterfall Methodology, Oracle 11.0, Gus, Rally, 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’s downhill custom applications. Responsibilities:

● Responsible includes 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

Sr. Product Owner/ Business Analyst

November 2014– April 2017

Location: San Jose, CA

Extensive experience with managing Waterfall and Agile projects. Led teams on Kanban and Scrum methodologies using Project Management tools- MSP,VSTS,Jira and Confluence. Project involved requirements analysis involving health care claim pricing, benefits, Chargeback 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 meeting with stakeholders and business partners to gather, analyze and discuss the product requirements.

● Planned and created a road map outlining key deliverables.

● Carried out day to day stand up meetings for status check using Rally and Confluence.

● Attended regular grooming sessions with Architects /QE/Dev/ team to discuss in detail requirements, challenges and solutions.

● Prepared weekly status reports suited to the client stating the project color code and resource allocation using MS Project.

● Designed Functional features user stories/use cases for each requirement

● Created Visio charts, wireframes and Mockups to detail data flow and application layout.

● Knowledge of Agile principles and values. Helped in streamlining processes and keep focus on successful delivery.

● Assisted in Integration testing efforts involving offshore and onshore team members.

● Facilitated user acceptance testing and handled defect Management Process.

● Conducted successful Demo to Business owners, to validate the end product is as per the given project requirements.

● Trained UAT tested as needed to successfully validate the test Environment: .net, Soap Xml, REST API, JSON, ALM, SQL Server 2008, Java, ASP.net, Oracle, NT, UNIX, Agile/waterfall Methodology, Oracle 11.0, Java, Rally, BI Reports. Bank OF America

Sr. Business Analyst

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.

Responsibilities:

● Worked on several projects that dealt with Bank’s Legacy system IBM AS400 iSeries database. Worked in ETL processes to extract and load/test data to various downhill applications.

● Worked with my team to Analyze various business requirements and functional requirements and clearly laid out the complex business processes that need to be tested in detail for various modules within a project.

● Created test plan, reviewed test scripts, worked with the team members to create complex SQL joins to test the applications.

● Wrote detailed test scripts for system integration testing.

● Successfully executed and monitored team activities testing reports generated in Cognos.

● Managed the entire quality process like creating test scripts and defect management processes.

● Closely worked with dev to resolve any environmental issues.

● Maintained close communication with DBA and development team and system analyst team throughout the software development life cycle.

● Received recognition from various teams for hand work and dedication. Environment: .net, xml, SQL, Java, ASP.net, Oracle, SharePoint application Microsoft outlook NT, UNIX, Tomcat, Agile Methodology, As400

Metlife

Sr. BA/QA Analyst May 2009 – October 2010

Worked as a Senior Business/QA Analyst for Met life‘s (First Person) Loan /Banking Application. (a division of MetLife Bank) .It is designed to help the Mortgage and the brokerage company with their loans and refinance needs

Responsibilities:

● Attending Planning sessions with Business liaisons. Understanding in detail complex business processes. Designing the processes with flow diagrams using Visio.

● Gathering, clarifying, and validating business requirements through regular meeting, discussions and maintaining active relationships with the business (subject matter experts) all through the requirement phase.

● Making recommendation to improve and support some of the business processes

● Understanding techniques for dealing with requirements changes and their impact on testing and product quality

● Documenting all the discussions in a detailed manner and using the information in creating comprehensive Functional specifications.

● Working in close coordination with the developers to clarify the business process Environment: Java, SQL, Quality Center, Windows NT, UNIX, Tomcat, Agile Methodology Jcpenney

QA Engineer : June 2008 March 2009

Working as a senior QA Engineer testing a highly complex .NET application, MPM (Media Placement Management) in the department of Marketing. The application involved distribution of preprint copies nationwide on all the JCP stores. Responsibilities:

● Tested complex modules which involved setting up special sale events in the JCP stores

● Analyzed the Functional specifications documents and was involved in gathering system requirements . Coordinated with the Business as needed

● Created test plans to accomplish required testing. Execute test plans, Report accurate testing status.

● Validated the results by running complex queries in sql server and compared the results

● Worked closely with development to resolve issues

● Tracked Defects and reported the bugs and Email notifications to the developers using the Quality Center.

● Performed smoke Testing, System Testing, Integrated System Testing,Regression Testing and Functional Testing.

● Performed Positive and Negative testing

● Involved in writing detail test cases for UAT testing efforts

● Involved in setting up data for the UAT test cases in the pre UAT environment

● Tested all the UAT ( end to end) scenarios in the test environment Environment: .NET, SQL, Quality Center, Windows NT, UNIX, CMM Web Services Education

BS Engineering Texas A&M University

Minor in Computer Science Texas A&M University

REFERENCES:

Available on request

Contact this candidate