Alok Sabherwal

ac88wu@r.postjobfree.com

Cell – 571-***-****

Summary

Over ten years of diversified experience as Business Systems Analyst and two plus years as a Product Owner.

Experience includes Requirement Gathering, Data Analysis, Project Planning, System Testing, and quality assurance of Client/Server and Web based applications.

Extensive experience in working Agile as well as Waterfall/SDLC based software development environments.

Identify and prioritise work from Story Backlog for development in an sprint.

Organize and conduct System Demo sessions with business groups at completion of every sprint.

Prepare Features that breakdown the functionalities of the product being developed during a sprint.

Experience includes leading the functional teams in all interactions with the stakeholders and documentation of the requirement and design documents.

Experience in documenting screen updates and enhancement requirements via prototypes and screenshots prepared in discussion and coordination with user interface development groups.

Strong domain experience in Mortgage, Retail Banking, Brokerage and Financial Asset Management.

Strong domain experience in Mortgage (MBS) and Asset Backed securities (ABS).

Experience in Online originated asset movement for cash and securities via ACH, Wires and Checks.

Experience in auditing and validating project documentation confirming to the delivery methodology standards.

Experienced in creating process flow diagrams.

Experienced in working and delivering projects in multiple software delivery methodologies.

Experienced in using the Thomson Smart Station broker trading application for analysis and testing.

Experience in Planning, scheduling and setting up the environment for testing applications.

A self-starter, motivated team player with Leadership abilities and excellent communication and interpersonal skills.

Technical Skills

Databases Oracle, DB2, SQL Server and MS-Access

SQL Tools Toad SQL, Win SQL

Mail Servers Lotus, Microsoft Outlook

Tools Clear Case, Clear Quest, DOORS, MS Project Server, MS Visio, HP ALM, Rational Rose. Thomson Smart Station

Operating Systems UNIX (Sun Solaris), Windows 2000/NT, DOS, RUMBA Mainframe (Thomson Reuters Beta Systems).

Software Methodologies Waterfall, Agile, Kanban

Requirements Definition Borland Caliber, DOORS, Topteam, JIRA, Rally

Tools

Experience

(09/17 – Present) Merrill Lynch / Bank of America (Hopewell, NJ)

Product Owner / Business Systems Analyst

UST Online Money Movement

Provide the ability for US Trust clients to self-serve money movement transactions between their trust and banking accounts real-time through US Trust Online. Today, the requests of these high net worth clients are serviced by their client team and is an overnight process. The objective of this phased initiative is to introduce eligible account owners who are enrolled on UST Online, the ability to initiate certain types of cash-related money movement transactions. Such transactions should process either straight-through or will be routed to the client team for review and approval.

Responsibilities:

Analyze and prioritize feaures and stories from backlog for work in a sprint iteration.

Conduct and organized bi-weekly product demo sessions with stakeholders at the end of every sprint for signoffs and communicate feedback to teams for any changes as needed.

Conducted daily Scrum calls and sprint retrospective meetings as and when needed.

Analyzed system requirements for scheduled cash transfers between trust and banking accounts and vice versa.

Analyzed system requirements for immediate check transfers from trust accounts to payee/s.

Defined, estimate sizing and prioritized stories in rally tool for scheduling transfers and maintenance of cash and check transfers after submission (Editing/Cancel etc.).

Analysed and prepare data mappings of the middle tier Web Services/API’s called by the Online application, for the Request and Response xml’s of the web services.

Analysed and prepare data mappings of the main frame Web Services/API’s called by the Middle tier web services as part of integrating the Online application with the end systems.

Worked together and coordinated with multiple teams (UI and Mainframe) integrating the flow of functionalities from Front end to Back end.

Performed functional testing of new money movement functionalities and guided testing team in end to end testing.

Work together with multiple Dev and testing teams to ensure that the stories/acceptance cretieria are clearly/completely defined and the end to end functionalities are delivered on schedule.

Logged and tracked defects for every release and enhancements in HP ALM.

Other responsibilities:

Defect resolution and analysis on regular basis for issues/monthly release items as requested by branch and high net worth clients.

Prepare current and future state flows as necessary to review and propose solutions to business on production issues.

Defined/Updated roles and other parameters in order to control accesses to money movement application and specific functionalities within it.

Define, estimate sizing and prioritize stories for quaterly releases addressing these issues.

Assist in gathering estimates for proposed enhancements being aligned in future releases.

Work together with Dev and testing to ensure that the stories/acceptance cretieria are clearly/completely defined and delievered as scheduled.

Logged and tracked defects for every release and enhancements in HP ALM.

(04/17 – 8/17) Chubb Insurance (Whitehouse Station, NJ)

Senior Business Systems Analyst

As part of the merger between ACE and CHUBB Insurance, all policy and downstream systems are being planned to be gradually transferred to the ACE platform. To accomplish this goals bridges are being built to transfer Financial as well as Policy related data to move as well as start originating at ACE.

Responsibilities:

Perform system analysis activities for third party vendors who presently work with CHUBB and are being affected with this merger.

Data analysis of feeds that send policy and financial data to vendors which currently provide after-hours claim service for CHUBB.

Updating existing data mapping of feeds from CHUBB to its new source at ACE.

Defined requirements addressing changes and updates to the existing process of data transfer between claim applications and vendors.

Data analysis and mapping of file feeds that are being sent to external vendors for after-hours claims processing.

Prepared Requirement Definition documents for multiple modules of the Claim processing application being affected by the merger project.

Prepared current state process flows of the after-hours claims processing system and its interaction with Chubb internal systems.

(07/16 – 1/17) Vanguard (Malvern, PA)

Product Owner / Business Systems Analyst

The Vanguard Group is an American investment management company based in Malvern, Pennsylvania, that manages approximately $3.6 trillion in assets. It is the largest provider of mutual funds and now the second-largest provider of exchange-traded funds (ETFs) in the world after BlackRock, with about $451 billion in ETF assets under management, as of March 2015. It offers mutual funds and other financial products and services to retail and institutional investors in the United States and abroad.

Responsibilities:

Perform system analysis activities for enhancements and upgrades to existing pricing and quotation application.

Identify features and applicable stories which were the picked during any sprint.

Conduct requirements gathering sessions with the stakeholders and technical units of the project and prepare applicable Stories and estimate sizing.

Conduct and organized bi-weekly product demo sessions with stakeholders at the end of every sprint for signoffs and communicate feedback to teams for any changes as needed.

Conducted daily Scrum calls and sprint retrospective meetings as and when needed.

Prepare data mapping of the Pricing and Quotation application, for the Request and Response xml’s of the web services for Billing Summary.

Document pricing screen update/enhancements requirements via prototype in discussion with the sales team and user interface development group.

Conduct and participate in daily stand up Scrum meetings with the team.

Conduct daily decomposition sessions with Business and Developers to document stories and discuss any impediments affecting the assigned tasks for the ongoing sprint.

Create and maintain any change requests in discussion with stakeholders.

Working closely with QA team to prepare system test plans, test cases and managing status of day to day testing activities and logging/tracking defects in HP ALM.

Conduct system testing along with QA team.

(03/16 – 07/16) Merrill Lynch / Bank of America (Hopewell, NJ)

Identity and Access Management

Senior Business Systems Analyst

As part of centralizing the information security of the entire organization, Bank of America is rolling out streamlining of the entitlement setup and management process. This would allow over 6000 in house applications to be able to onboard resources, devices, databases and networks following a regulated, monitored, auditable and streamlined process. The process is also meant to identify and build more security for accesses allowed to third party and vendor applications that interact with the systems of the bank.

Responsibilities:

Key member of the IAM Acceleration project

Generate reporting for Sr. Management and Stakeholders using SharePoint and other BI modeling.

Escalation point to GIS in meeting deliverables

Data analysis using Excel formulas and writing Excel Macros, data formatting and file format layouts

On-boarding applications onto the Centralized Security Database

Process on-boarding requests that come in via several application teams. Assist Business technology teams with the process of getting their data into the centralized security database by helping them set up file feeds in the correct format and assist them with access request forms needed to transmit data files

Ensure that the data quality of the feed that the application teams provide meets the required standard Check file feed formats on test files to ensure they meet the load requirements

Troubleshoot data quality and load issues with existing applications

(07/12 – 01/16) IBM – Worked on multiple projects for the following mortgage clients of IBM – Englewood, NJ)

Senior Business Systems Analyst

Seterus Inc

Seterus as IBM’s client accesses the Fannie Mae loss mitigation decision engine via IBM’s mortgage servicing application called Impact (I3). This application provides servicer the ability to enter loans for servicing, as well as get them decisioned from SMDU for loss mitigation solutions.

Servicing Management Default Underwriter (SMDU) is a Fannie Mae system that evaluates loss mitigation workouts for conventional loans where the borrower may be experiencing a hardship that causes (or may in the future cause) a payment delinquency. SMDU is a callable service (through web services, Application Programming Interfaces (APIs), and bulk transactions) that servicers can use to obtain automated loss mitigation recommendations (HAMP, Mod24, Fannie Mae Standard, Streamlined modifications) and report status of active loss mitigation workouts.

Responsibilities:

Coordinate gap analysis and mapping review for client and Impact required changes as per requirement updates.

Defined, estimate sizing and prioritized related stories in JIRA tool.

Analyze and prioritize feaures and stories from backlog for work in a sprint iteration.

Conducted daily Scrum calls and sprint retrospective meetings as and when needed.

Analyze impact of Fannie Mae policy changes both from a configuration standpoint and potential gap / change required from application and client to support updated credit policy.

Analysed and prepared data mappings of the Web Services/API’s called by the User from the Impact3 application, for the Request and Response xml’s of the web services.

Perform analysis activities for functional updates required to the servicing and loss mitigation application.

Documented requirements for web application screen enhancements/updates via prototypes and screenshots in discussion with Business and Interface development team.

Prepared test plans and functional test cases and conducted system testing in coordination with business and QA group.

Facilitate and coordinate Weekly client meetings between SMDU and the business group at Seterus.

Raise issues with regard to SMDU to SMDU team and track resolution.

Log open questions / issues.

Create and maintain any change requests as per client needs and Impact release schedule

Manage specification tasks internally to document changes required to individual specs for release

Upon approval of specifications, work with development to create actionable work tasks to implement the specifications

PNC & Bank of America

TILA-RESPA Integrated Disclosure

In November 2013, the Consumer Financial Protection Bureau (CFPB) integrated the Real Estate Settlement Procedures Act (RESPA) and Truth in Lending Act (TILA) disclosures and regulations. Any transaction involving a mortgage will use new CFPB disclosure forms. The new TRID rules and forms took effect on October 3, 2015. These changes resulted all banks to update their loan origination/processing systems to use the new Loan Estimate and Closing Disclosure forms.

As IBM Impact (I3) application is used at both of these institutions lot of work post development was spent in exhaustive testing to which IBM resources were dedicated to.

Responsibilities:

Documented requirements for web application screen enhancements/updates via prototypes and screenshots in discussion with Business and Interface development team.

Create and run a loan through from origination all the way to funding and closed. This was to ensure that the data mapped for the fields on the new forms is calculated and filled accurately.

System Testing and verification of all Loan Estimate and Closing Disclosure form fields. This included the behavior change for loan of all different types (Fixed Rate, ARM etc.)

Create and maintain any change requests as per client needs and Impact release schedule

Addressing any calculation and mapping errors that cause the forms to be populated incorrectly.

Facilitate communication with third party vendor (Docutech), who was responsible in printing and publishing these forms for the clients.

Create and maintain data mappings of fields for both forms as main artifacts for development and testing groups.

(09/11-07/12) PHH Mortgage Corporation (Mount Laurel, NJ)

Business Systems Analyst

Correspondent Lending Technology

As Wholesale Correspondent Lending presently lacks a technology platform necessary to retain its competitive advantage in the current marketplace. A technology is required that a) supports the unique needs of the B2B broker and correspondent lending businesses and b) allows PHH Mortgage to maintain and grow market share with its existing clients as well as acquire new clients.

A new application is required as a solution to fulfill the correspondent needs of PHH. It would allow PHH to effectively price, register, process and fund loans. New functionalities would also need to be developed that allow for more audit controls, edits and workflow management in the loan pipeline.

Responsibilities:

Prepared Current and Future State Process Flows using MS Visio to identify PHH requirements for Correspondents.

Conducted requirements gathering sessions with the stakeholders and the technical units of the project and prepared requirements for multiple systems currently used by Correspondents.

Prepared Use Case diagrams (UML) for depicting project functionalities.

Prepared Functional Design Document for the new functionalities and other supporting enhancements.

Prepared Data mapping to match the current data fields with the fields in Channel Master, the new application for Correspondents.

Documented process flows and requirements using the Borland Caliber RDM requirement definition tool.

Worked closely with the developers to ensure that all requirements were well understood and correctly implemented.

Prepared test plans and cases for system testing.

Logged and tracked defects in ALM testing tool.

Created and maintain SharePoint sites for all project documentation and change control items.

(03/11-08/11) Merrill Lynch / Bank of America (Hopewell, NJ)

Business Systems Analyst

Bank Wires Project

Responsibilities:

Prepared High-Level (Functional) Design Document for the Wires Web services and other supporting enhancements.

Prepared Low-Level Design Document for the Wires Web Services, detailing the operation of the web services including all inputs and outputs.

Conducted walkthrough sessions with Business and Development teams explaining the functioning of the services.

Prepared Data mapping to match the data fields submitted from the Smarts User Interface with the web services/API’s used to service the wire requests.

Assisted the testing team in understanding the testing scenarios of various functionalities.

Worked closely with the developers to ensure that all requirements were well understood and correctly implemented.

Researched and defined xml tags to perform inquiry and maintenance of data variables on mainframe.

Created and maintain SharePoint sites for all project documentation and change control items.

(10/09-02/11) Wells Fargo Advisors (Richmond, VA)

Business Systems Analyst

Instruction Maintenance Project

Responsibilities:

Conducted requirements gathering sessions with the stakeholders and the technical units of the project and prepared requirements documents.

Prepared Functional Design Document for the Instruction Maintenance Service request application.

Conducted walkthrough sessions with Business groups to explain the prototype of the module.

Prepared mock wire frame prototypes for the Instruction Maintenance user interface.

Set-up system rules and variables for movement from Cash and Margin account via ACH, Check and Wire.

The application was designed for two interfaces IRA and Non-IRA (Retail) Accounts as account setup rules are different for them.

Defined roles and other parameters in order to control accesses to the application module within service request application.

Researched and defined xml tags to perform inquiry and maintenance of data variables on mainframe (Thomson Reuters Beta Systems).

Prepared data mapping for the Web services/API’s that will be called by the end clients with the existing ACH modules to match the data fields being displayed on the user interface and their source from the mainframe applications.

Worked closely with the developers to ensure that all requirements were well understood and correctly implemented.

Conducted unit testing of the Service Request applications and the related Interfaces.

Wrote detailed queries to verify the quality of the brokerage data in the legacy systems using Access and SQL.

Staged test data for testing the functionalities in the System Integration and Comprehensive test environments.

Researched and resolved issues during the course of development and testing.

Created and maintain SharePoint sites for all project documentation and change control items.

ACH Web Services Project

Responsibilities:

Prepared Functional Design Document for the ACH Web services and other supporting enhancements.

Conducted walkthrough sessions with Business to explain the functioning of the services.

Prepared mock wire frame prototypes for the ACH Web services user interface.

Developed system for movement of asset from Cash and Margin accounts.

Automated the complex, inefficient and labor-intensive aspect of, workflow, compliance, and interface and customer portfolio management.

Researched and defined xml tags to perform inquiry and maintenance of data variables on mainframe (Thomson Reuters Beta Systems).

Define account setup and usage rule for IRA and Non-IRA (Retail) Accounts for ACH transfers.

Prepared data mapping for the Web services/API’s that will be called by the end clients with the existing ACH modules to perform the service request.

Defined roles and other parameters in order to control accesses to the application module.

Prepared UML diagrams to capture system specifications for WIB and IVR.

Coordinated the testing effort with WIB, IVR and BIL (Brokerage Integration Layer) for money movement requests to be prepared and tracked their processing and passage all through to mainframe.

Prepared and executed test scripts of various functionalities using Quality Center.

Prepared data mapping to match the data fields submitted by the end clients with the existing ACH modules within service request application.

Worked closely with the developers to ensure that all requirements were well understood and correctly implemented.

Prepared process flow diagrams for calls posting values entered on the user interface to mainframe.

Created and maintain SharePoint sites for all project documentation and change control items.

(05/09 - 10/09) Freddie Mac (Mclean, VA)

(02/08 - 04/09) Wachovia Securities / Wells Fargo Advisors (Richmomd, VA)

(08/06 – 01/08) Freddie Mac (Mclean, VA)

(02/06 – 07/06) Fannie Mae (Herndon, VA)

(07/05 – 01/06) Freddie Mac (Mclean, VA)

Education

Michigan Technological University, Masters in Science, Michigan US 2003 - 2005

The Technological Institute of Textile and Sciences, Bachelors in Engineering, India 1999 - 2003

Contact this candidate