Project Data

Soniya Bhari

Summary:

Resourceful and dynamic Business Analyst with over 7 years of experience with strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP), Waterfall, V-Model and Agile methodology.

Broad experience in various domains including Finance, Mortgage, Auto/Home Insurance, Property and Causality Insurance, Utilities, Marketing & Advertisement, and Education.

Expertise in broad range of technologies including business process tools such as MS Project, MS Excel, PowerPoint, MS Visio, technical assessment tools, Data Warehousing concepts, Infrastructure, and web design.

Proficient in developing Use Cases, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, and Activity diagrams), Swim-lane diagrams and Class Diagrams based on UML using MS Visio and Rational Rose.

Strong experience in client interaction and understanding business applications, business data flow and logical/ physical data modeling using Dimensional/ER Modeling and Star and Snowflake schemas.

Extensive experience in using the change management tools like Rational Clear Case, Rational Clear Quest, and Perforce & requirement management tools like Rational Requisite Pro.

Extensive success in translating business requirements, reporting requirements, and user expectations into detailed system specifications employing Unified Modeling Language (UML).

Expertise using Business Objects tools such as Supervisor, Designer, BCA, Web Intelligence and Info view.

Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mappings for Operational Data Stores, Enterprise Data Warehouse, Data Marts,

Data mining, Data Migration other databases.

Proficient in Data, UML Modeling, Data Warehouse and OLAP reporting tools.

Expert in facilitating and defining the entire Testing Life Cycle including test strategy, test planning, test case preparation, test execution and defect management.

Experience in conducting Automation and Performance testing using various tools including Rational Suite Tools, HP Quality Center

Experience in Manual Testing using Mercury and Rational tools and in writing Test Scripts using Test Scripting Languages.

Strong customer/user advocate, apt negotiator with excellent analytical, communication, decision-making and organization skills.

Creative and maintaining positive and productive team environments and with integrative thinking skills.

Education: Master of Business Administration in Project management

Skillset:

MS SQL Server 7.0/2000/2005/2008, MS Access, iRise, Oracle 9i, SQL, C/C++, TFS, HP Quality Center, Serena Open Project, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, Rational Rose, Dream weaver CS5.5, HTML, XML, Enterprise Architect, MS Office, MS Outlook, MS Share Point 10/11/12, MS Visio, MS Project, MS OneNote, Photoshop, MS-DOS, Windows Vista/XP/9x to 2k.

Projects Summary:

Optionsxpress (subsidiary of Charles Schwab), Chicago 03/2014 – Present

Lead Business Analyst

Organizational Account Project (OAP): The objective of this project is to strengthen and position the Organizational Account portfolio for future growth opportunities by improving risk controls and developing an appropriate service model and account platform. This includes development of a risk scoring policies and procedures, new client on-boarding process, existing client re-papering, and internal training and communications.

Foreign Account Tax Compliance Act (FATCA): The objectives of the project will address for foreign entity accounts for which each of Schwab’s business units (Broker/dealer, RPS, RBS, SPC, CBS and OptionsXpress) will commence using new W-8 BEN-E forms; modify the new account open processes, check and continually monitor accounts for US indicia, and make tax withholding changes related to FDAP and gross proceeds. New W-8s and new due diligence process must be in place by 1/1/14 for new foreign entity accounts, and existing foreign entity accounts should be remediated by 1/1/16.

Desktop Application Resilience Project (DARP): The objective of this project is to support Broker dealer functions and regulatory requirements, over the years, various OptionsXpress team members developed a number of key business applications on their desktop. As a result of a number of initiatives related to the Data Center move as well as full integration with Schwab, several critical systems have been identified as a recovery gap. Currently, many of the systems are located on desktops, with the work performed by designed individuals. As a part of this project we shall be developing different artifacts in form of repository for Operation team.

Data Migration Center (DCM): The object of the Data Center Migration project is defined as moving the System of Record (SOR) and all related client-facing, production applications, migrate and build support for the optionsXpress platform in PDC1 and PDC3 to accommodate 300,000 customers who will temporarily remain under separate broker dealers. Provide for long term support of the optionsXpress Futures Trading platform and subsequently, decommission existing optionsXpress data centers and compliant.

Responsibilities:

Coordinated with the business constituents and technology teams to refine requirements and translate them into technical specifications/ functional requirements so that they leverage existing technology.

Developed and maintained a thorough understanding of the needs of the business user and design perspective.

Responsible for providing business requirements, develop user stories and analyze existing functionality within an AGILE software development in scrum environment.

Performed the role of the Scrum Master, facilitating daily scrum meetings and scrum of scrums knowing the status of the development and testing of the product on a daily basis.

Performed Gap Analysis to check the compatibility of the existing system and perform product evaluation to determine compatibility, survivability, and supportability in the various critical environments including production, UA, Demo, Dev and virtual trade.

Defined Business processes, business rules and evaluated change requests for the application.

Worked with multiple merchandising and inventory control and tracking systems.

Implemented Cost Benefit Analysis for deciding whether adding new modules would benefit the project.

Created basic wireframes prototypes for graphical user interfaces to visually demonstrate the proposed application.

Provided overall project management to multiple projects successfully completing them on-schedule and on budget.

Possessed strong interpersonal, analytical, problem-solving, influencing, prioritization, decision- making and conflict resolution skills.

Environment: MS Office suite (2010), including Word, Excel, Visio, Power Point, Outlook, Project, Scrum, HP Quality Center, TFS.

Bank of America, CA 02/2013 – 02/2014

Business System Analyst

Mortgage

Mosaic – TPC Close code Enhancement: The purpose of this project is to implement modifications to existing processes that will not allow changes to the Closed Code on a service released loan within 5 days of its release date. This will allow PSG to readily identify service released accounts and provide all required documentation to the servicer.

Property Inspection Limit Project: This objective of the project is to reduce unnecessary fee write-offs due to unnecessary and off-cycle inspection orders that cannot be charged to borrowers or investors, mitigate risk of manual processes causing errors and inefficiencies, bring into compliance with investor guidelines regarding inspection orders, and result in FTE savings due to reduction of manual processes.

CFPB Periodic Statement Project: The objective of this project is to ensure that, the interest rate are applied and referred on payment calculations appropriately when the loan is in SCRA program or SCRA protector. We originally identified the following areas in Bankruptcy LOB.

IO to P&I Project: The objective of the project is to address the inaccuracy in P&I payment calculation that occurs when an delinquent IO Loan transitions into the P&I Stage. Identify and understand upstream and downstream impacts of this calculation across the enterprise. Ensure accurate calculations reach all end consumers of the calculation as well as ensure accurate reporting to customers.

Biggert Water Escrow of Flood Insurance Payment: The Biggert-Waters Flood Insurance Reform and Modernization Act of 2012 impose new rules on lenders governing the escrowing of Flood Insurance premiums. The objective of this project is to addresses the mandatory escrowing of flood insurance premiums. This is a mandatory compliance regulation. We should have the ability to escrow First Mortgage and all Home Equity products carried on iSeries and ALS for mandatory flood insurance as of July 6, 2014.

Responsibilities:

Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications. Developing functional specifications for business process refinement and automation, data modeling, system Architecture, conducting feasibility studies, scope

Expertise in analyzing Business and Development Specifications, Use Cases, and Detail Design to develop requirement gathering, analyzing the business process, conducting Feasibility studies, Document generation and conducting sessions.

Comprehensive knowledge of the testing lifecycle within web, client server & Mainframe environment.

Excellent analytical skills for understanding the business requirements, business rules/processes and detailed design of the application.

Excellent knowledge of Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP) and Rational Tools used during various phases of RUP.

Proficient in customizing already existing business practices, workflows, activities and deliverables.

Use Case development and UML modeling using modeling tools like MS Visio.

Develop User interfaces and requirements sessions. Requirements gathering, data modeling, Feasibility studies, Scope Documents.

Conducted JAD sessions for communicating with the all Project directors and stakeholders.

Conducting sessions with end users/clients to gather business requirements and translating the same to the development teams.

Providing traceability across the project by analysis and review of project elements involved in traceability including requirements, testing artifacts, end-user support documentation and training materials.

Extensive Documentation Skills for use in Standardization of Testing and Programming Procedures and Guidelines.

Formulating Test Plan, Test Scripts and Test Cases for Functional, System, Integration, UAT, and Regression Testing based on the Design Document and User Requirement Document for the Functional, Security, and Performance Testing.

Environment: MS Office suite (2010), including Word, Excel, Visio, Power Point, Outlook, Communicator and Access, UML diagrams, HP application Lifecycle Management 11.0, IBM iSeries AS400 Version6.0, SharePoint 2012.

Wells Fargo Bank, San Francisco, CA 11/2011 – 12/2013

Business Analyst

Mobile, Tablet and Text Banking platform

Wells Fargo is a diversified financial services company which provides retail banking, commercial banking, investment banking, mortgage and insurance. Involved in following five projects for Mobile, Tablet and Text Banking platform.

Mobile Platform Outage Messaging: This project will address the customer messaging presented during the various outages seen – Network Outages, Application down (Mobile Platform), and Backend Failures during Authentication and Backend after authentication. The messaging has to be identified for various mobile offerings – Browser, Downloadable Apps, and Text Banking.

Retirement Plan Data Integration: This project will be implemented in two distinct phases. Phase 1 and involves the integration of Institutional Retirement and Trust data to the Enterprise Customer Repository (Hogan CIS). Phase 2 is about a controlled release of the IRT data out into the Enterprise systems; including Wells Fargo Internet Banking (WIB), store tools such as SVP and SVT, support systems including CIV and IVR and Wealth and Brokerage tools including Smart Station and Client Link Provide basic mobile site integration for Institutional Retirement plans.

HSA WIB Integration: The purpose of this project is to extend Wells Fargo Mobile access to Health Benefits Services. Health Benefits Services has a growing Health Savings business that currently maintains over 314K account holders and $615MM+ in assets. As the health care paradigm changes, Health Savings Accounts (HSA) are predicted to become a crucial element to individuals’ overall retirement planning as customers accumulate balances and migrate to longer-term vehicles for health care. Provide the ability to view HSA accounts (Cash and Investment Balances) on Mobile Banking devices, including the Mobile App, Tablet App, wf.com, and Text Banking.

EDE: OLB Enrollment Email Validation & Bounce back Enhancement: The OLB enrollment email validation and bounce back enhancements is a component of the overall Electronic Delivery Evolution (EDE) program of work. There are two main objectives of the EDE: OLB Enrollment Email Validation & Bounce back Enhancement project: Validate a new customer’s email address during the enrollment process and verify an existing customer’s email address through an enhanced bounce back process. Present a mobile notification to customers following a bounce back event, the next time they log in through a mobile device.

WFF Loan Conversion: The scope of this project is to provide full online and mobile banking access to WFF loans. Technology application will minimize customization and development efforts by leveraging the existing mortgage product’s behavior in WIB, Mobile Banking, OPS and APS. This project aims to provide WFF Real Estate loan customers with core online and mobile banking functionality for accessing account information and making payments.

Responsibilities:

Conducted and directed the analysis of highly complex business problems to be solved through strategic e-commerce-based solutions.

Responsible to elicit, analyze, and produce detailed business requirements/specification documents, including conducting walkthrough meetings of the produced documents with impacted technical/system groups, testing groups, servicing groups, and business groups.

Evaluated current processes and recommending new e-commerce solutions that reduce costs or extend current capabilities.

Ensures existing compliance practices are effective and support the overall business strategies.

With direction, helps to ensure compliance process are well established, documented and repeatable so that matters can be resolved timely and consistently.

Analyzed requirements and formulated logical designs and documented them in Detailed Design Specification (DDS) artifacts. Reviewed designs and gained sign-off from TIG management, key SME's, application and data architects, and data modelers.

Ensured that logical and physical designs fit it with the overall application and data architecture.

Worked with developers to ensure their understanding of the requirements and logical designs. Reviewed developers Data Technical Design (DTD) artifacts and ensured full converge of assigned requirements.

Jointly reviewed developers' code to ensure module designs will deliver the requirements, are complete in handling positive and negative logic paths, and adhere to standards.

Communicated with the Business Users and prepared the Project sizing reports for Enterprise Projects (Product Development) and Enhancement projects to determine the level of effort required by the Technology Information Group (TIG)

Prepared the User Acceptance testing Window Calendar for the Enterprise and Enhancement releases.

Prepared the Service Level Agreements for Business Units.

Reviewed and updated the test plans for the Functional and Regression testing of Enterprise and Enhancement projects.

Involved in identifying the high level test scenarios.

Involved in preparing and reviewing the test cases for the User Acceptance Testing.

Environment: MS Office suite, including Word, Excel, Visio, Power Point, Project, Outlook and Access, Enterprise Architect (EA) UML diagrams.

Information Intellect, Fort Worth, TX 01/2010 – 10/2011

Business Analyst/Business Intelligence

Information Intellect delivers enterprise asset management solutions to its clients. They help their clients to most effectively manage their asset portfolios to meet their strategic objectives. Information Intellect developed a radio-based automated meter reading system (AMR) which reads information from electric, water, and gas meters. The information was then collected to a central database and made available through a web-based interface. The Meter Mesh project was involved in developing an Enterprise level software solution containing various modules like Administration, Operations, Customer Service and Management, which cater to the needs of the AMR system in any utility company.

Responsibilities:

Conducted a thorough analysis and understood the requirements gathered through the previous phase in the project.

Gathered the business requirements for the new phase through Interviews and JAD sessions.

Analyzed the requirements and prepared the Vision documents for the different modules to get the approval sign-off from the client.

Created the mock-ups and screen shots using Adobe Dreamweaver to help the development team better understand the requirements.

Prepared the Use Cases for various functionalities in the enterprise system and performed Business Process Modeling using Sequence diagrams, and Activity diagrams using MS Visio.

Communicated with the Stakeholders and SME’s through JAD sessions and E-mails to gather the reporting requirements used in the software solution.

Performed data mapping from Operational data store to the Enterprise Data Warehouse.

Prepared the Reports Standard documents and the Reports Design Documents to help the reporting team effectively understand the requirements.

Led and coordinated with the off-shore reporting team of four on a daily basis in completing the reporting requirements using Crystal Reports.

Involved in creating OLAP cubes by using SOL Server Analysis Service.

Environment: MS Word, Excel, PowerPoint, Visio, Agile, MS SQL Server 2005, SQL, Crystal Reports XI R2, ASP .Net 2.0/1.1, C#, VB. Net, HTML/DHTML, XML, Windows XP, Flash Player, Adobe Flex.

Allstate Insurance, Irving, TX 05/2008 – 12/2009

Business Analyst/Data Analyst

All State Insurance Company is the nation’s oldest mutual insurer of automobiles. The company is a national writer of automobile, homeowners; and personal excess liability insurance. It has 42 offices across the country. Project involved developing an Integrated Policy management System where the company wanted to extend its five existing policy management systems for access by the company’s countrywide network of independent producers and make it accessible over the Internet.

Responsibilities:

Involved in gathering Business Requirements for new models through JAD sessions, E-mails and Surveys.

Performed extensive Use Case analysis for insurance claims.

Performed extensive Business Process Modeling using Swim-Lane diagrams, Sequence diagrams, Workflow diagrams and Activity diagrams using MS Visio.

Conducted Feasibility Analysis to study the benefits of using the application thro’ Data Flow Diagrams and used Trace-ability Matrix to find out the best possible technologies to be used.

Coordinated with all Allstate agents to gather requirements under property and casualty insurance for the application and managed them using Rational Requisite Pro.

Involved in Gap Analysis and ROI analysis of existing policy management system with the Enterprise system.

Integrated Requisite Pro with Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.

Provides timely and efficient project implementation related to compliance projects designed to manage or reduce risk.

Analyzed the final requirements of data and authored the Source To Target Mapping (STTM) Documents to help ETL team in extracting and processing data before loading to the target database.

Created Data Dictionary as descriptions for the mock-ups screens and wire frames for the development teams.

Studied and Analyzed the Reporting requirements of agents so as to include them while building the application.

Developed Test Plan and Test Cases in co-ordination with Quality Analyst to perform manual and performance testing.

Environment: MS Word, Excel, Access, Visio, Load Runner, Rational Requisite Pro, Rational Rose, Rational Clear Case, Rational Clear Quest, ERWin 4.5, UNIX, SQL, Informatica, Business Objects XI R2, ASP .NET, Crystal reports 7.0, Windows XP.

United Health Group, Minnetonka, Minnesota 04/2007 – 04/2008

Business Analyst

UnitedHealth Group Incorporated (UHG) is a diversified managed health care company headquartered in Minnetonka, Minnesota, USA. Through its family of subsidiaries and divisions, UnitedHealth Group serves approximately 70 million individuals nationwide. UHG, as part of their expansion in Medicare and Medicaid business has acquired about 25 health plans throughout United States. To better serve its members and providers while reducing the total operational cost, UHG decided to migrate the claims processing system of all the health plans into a single platform: CSP (Community & State Strategic Platform). TriZetto Facets was chosen as the core administration and claims processing system for CSF’ Platform.

Responsibilities:

Gathered user and business requirements through interviews, surveys and prototyping. Stored and modified requirements in MS Word.

Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.

Conducted Change Analysis for the improvement of the existing system and recommended the required changes using Rational Clear Case.

Created SRI (System Requirement Inventory) and BRTM (Business Requirement Traceability Matrix) to keep track of the requirements

Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using Rational Rose.

Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.

Involved in the entire project life cycle (SDLC) from evaluation, installation, configuration and development of end user reports.

Gathered and analyzed the business reporting requirements with the existing Data source and suggested the changes in the data source.

Created the universes based on the user classes and their hierarchy in the organization at different aggregations.

Specified the standards for universes, Classes, Aliases, Help text, Simple and complex objects.

In Info View, implemented customized logins at application level and provided password reset options to the users.

Created user groups and managed access privileges using Business Objects Supervisor.

Involved in improvement of claim adjudication process of CSP Facets application..

Created the Test cases and SQL scripts to verify the results and performed bug tracking using Clear Quest.

Environment: Rational Rose, Rational Clear Case, Rational Clear Quest, MS Office Suite, MS Project, Business Objects 6.5(Supervisor, Designer, Reporter), Java, Broadcast agent server, ERWin 3.5.2, IIS Web server, SQL, Oracle 9i, Mercury Test Director.

Contact this candidate