Resume

Sign in

Data Web Services

Location:
Palo Alto, California, United States
Posted:
January 27, 2018

Contact this candidate

ALPANA SENGUPTA

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

CA 94303

ac37uz@r.postjobfree.com

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

Summary:

Software Consultant with several years of experience in Systems/Business Analyst in Client/Server, middleware and Web based applications. Excellent professional interpersonal skills to independently gather/analyze requirements and Data.

Professional Experience:

Wells Fargo

Sr. Business Analyst August 2017– Present

Location: San Francisco, CA

Presently working 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 Bank’s 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 details 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 uses cases.

Worked very closely with both Development and QA team all through the SDLC process.

Supported integration and acceptance testing and provided post implementation support to end users

Developed comprehensive user manuals, training documents and work flow Visio diagrams.

Served as a liaison between business stakeholders and service providers (to manage requests for additional scope or process changes)

Ability to work successfully in both Agile and waterfall methodology.

Environment: Java, Soap Xml, REST API, JSON, ALM, Jira, SQL Server 2008, ASP.net, Oracle, NT, waterfall Methodology, Oracle11.0, Jira, windows services.

United Health Group

Sr. Business Analyst November 2012– April 2017

Location: San Jose, CA

Experienced with requirements analysis involving health care claim pricing, health care claim 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.

Partners with Business Engagement Team to facilitate process that builds partnership between business and delivery team.

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

Ability to gather requirements, analyze and evaluate XML data through Soap UI.

Worked on several projects involving ETL Technology, dealing with transforming valuable information into meaningful data for complex business needs.

Good understanding of RabbitMQ and windows services calls and analyzing logs.

Responsible for addressing data and reporting needs through Data analyses and validations.

Designed complex SQL queries using Oracle SQL dev tool and SQL Mgt. studio 2008 to conduct background research and analyze/ vast amount of data.

Extensive use of Excel/Pivot tables/VLOOKUP’s to analyze big data

Designed Functional features user stories/used 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 with involving off shore 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, Oracle11.0, Java, Rally, MQ, Data Warehouse, BI Reports, Cogos reporting.

Bank of America

Sr. Business Analyst November 2010 – November 2012

Location: Dallas, TX

Worked as a Senior Lead in the department of Mortgage testing all complex applications dealing with foreclosure, bankruptcy, Short Sale, Equator DIL and other Vendor related Complex application. 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 as an SME gathering requirements understanding process and improvements.

Worked on several projects that dealt with Bank’s Legacy system IBM AS400 iSeries database.

Created Capability features and analyzed functional areas.

Worked on ETL Processes to extract /load and test data on 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.

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

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

Environment: .net, xml, SQL, Java, ASP.net, Oracle SQL developer, HP ALM, SharePoint application Microsoft outlook NT, UNIX, Tomcat, Agile Methodology, As400

MetLife

Business Analyst May 2009 – October 2010

Location: Dallas, TX

Worked as a Senior Business for Met life ‘s (First Person) Loan /Banking Application. (a division of MetLife Bank). It is designed as an Integrated Marketing software to help the Mortgage and the brokerage company with their loans and refinance marketing 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

JCPenney

Business Analyst: July 2008 September 2009

Location: Dallas, TX

Worked as a Senior Engineer in gathering requirements and testing 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:

Gathered requirements and created Functional specifications documents through JAD sessions and creation of porotypes.

Reviewed test plans to accomplish required testing.

Validated the results along with the QE team 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.

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 as needed

Environment: .NET, SQL, Quality Center, Windows NT, UNIX, CMM Web Services

AT@T

Technical Business Analyst: December 2006 June 2008

Location: Dallas, TX

CSI is the Common Services Interface of Cingular Atlas System - a platform for enabling B2B Partners, CSI is a SOAP Compliant Web services Implementation that provides a robust set of services intended to support the management of Cingular wireless customers by Cingular Business Partners.

Responsibilities:

Lead Role in monitoring and troubleshooting all the transactions moving through Atlas middleware.

Analyzed the BRDs and FRS and involved in gathering system requirements

Supports the delivery of high-quality information systems by leading the effort to plan, execute, and document results of tests of new or revised system capabilities

Reported defects of the team to upper management using quality metrics in QC

Help the team execute testing in a Fully integrated production Like environment

Help validate the XML file Using XML SPY.

Executed Back End testing by validating the Transactions in the UNIX server

Actively participating in Daily Defect Calls to resolve the defects in efficient and timely manner.

Used SQL queries to retrieve data from tables and to perform back-end testing.

Worked along with Development team and Production team

Ensure entire end user experience (i.e. Provision, Activation, usage, Billing, Care processes) meets expectations.

Environment: Quality Center, Oracle Sql developer Jack Track, WINCVS, WINSCP, WebLogic, Windows NT, UNIX, CMM, JAVA, HTML, Web Services, XML SPY, SOAP, XML, WSDL, TOAD, Oracle, Agile Methodology.

Education

BS Engineering Texas A&M University

Minor in Computer Science Texas A&M University

REFERENCES:

Available on request



Contact this candidate