SUMMARY

• Over 8+ years of Business Analysis experience in the banking/financial services industry.
• Perceive excellent business domain knowledge for financial services, banking, investment management, asset management, wealth management, regulatory reporting business intelligence with data visualization needs.
• Performed project management activities in the PMO such as progress reports, project status update in Clarity PPM and SharePoint, project planning using Microsoft project
• Created Narrative Use Cases, Use Case diagrams, Sequence Diagrams, Activity Diagrams, State Diagram, Flow Diagrams and other related UML diagrams.
• Produce Statement of Work (SOW) to include scope of work, task breakdown, level of effort, duration and costs
• Team player, comfortable working in fast paced, changing environment and ambiguity.
• Exceptional written and verbal communication skills.
• Experience dealing with senior business leaders.
• A solid understanding of Mergers, Acquisitions
• Excellent understanding of Data services, Data ETL using SQL query tools and applications.
• Hands on experience on funds transfer application including the messaging system like SWIFT and FedWire.
• Well - developed leadership, management and strategic-thinking skills, with the ability to excite and guide team members in a highly collaborative.
• Advance knowledge of the Loan IQ vendor loan agency and trading platform 4.
• Strong analytical skills and expertise with various Project management methodologies and tools, (Waterfall, Agile, and Iterative).
• Proven track record of managing complex, highly technical projects across functions and business lines.
• Ability to balance structure and flexibility, with a drive toward results and accountability.
• Experience including on-site and offshore project management, technology strategic planning and implementation.
• Knowledge of project management tools, methods and best practices such as those defined by the Project
• Experience in developing detailed project management plan and work breakdown structure, executing project work plans and updating them as appropriate to meet changing needs and requirements.
• Strategic and motivated professional with hands-on experience in Service Operations and Wealth Management PMO with knowledge in Waterfall and Agile Software Development Life Cycle.
• Experience on working XML and testing Restful API
• Hands on experience in creating variety documents like Business requirement documents, Functional specification, Use cases, User stories, Test Cases, Test Plan, and Change Control documents etc.
• Expert in using Clarity for project management, MS Office 2003/2007 applications (MS Word, MS Excel, MS Access, MS Power Point, MS Project).

PROFESSIONAL EXPERIENCE

Confidential - Peoria, IL

Business Analyst/Scrum master

Responsibilities:

• Used Rational Quality Manager to develop test plans, develop test cases, run tests and report status.
• Providing overall project management to multiple projects successfully completing them on-schedule and on-budget.
• Has JAD sessions with cross functional teams to understand business process flows and functional interdependencies
• Part of the requirements team and have written User Stories and Product Backlog lists.
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Administered and coordinated the monthly release cycles
• I performed extensive testing on API for ensuring accuracy of backend services.
• Worked on workflows, scalability and capacity panning requirements for Adobe AEM authors and publishers as Confidential is the largest retail website in Canada.
• Manage testing and create comprehensive testing scripts for a project involving the addition of new enhancements in Loan IQ.
• Document and stakeholder analysis. Requirements gathering to define scope of projects focused on integrating assets
• Involved in MDM Process including data modeling, ETL process, and prepared data mapping documents based on graph requirements.
• Oracle ERP Install Base and Contracts integration with Support Portal
• Worked on requirement for AEM integration with Adobe Test and Target for Confidential ’s first online store joefresh.com.
• Defined and worked on setting Targets, Campaigns, segments, MVT and Ad Testing using Adobe Test and Target.
• Collaborate with API and System teams to support development initiatives Knowledge of JSON involved.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Tools are uses to support the application of the Scrum and SAFE Agile Methodologies in developing and managing the application development process.
• Prepared functional requirement documentation for ACH account analysis
• Participated in understanding existing Sovereign's ACH processing system
• Application of SDLC, Scrum and SAFE Agile Methodology.
• Worked with Oracle Support to resolve bugs and defect management.
• Knowledge of Explanation of Benefits EOB for a member or Explanation of Payments EOP for a provider.
• Created Power BI visualization of Dashboards & Scorecards (KPI) for Finance Department
• Designed and implemented multiple dashboards using Power BI
• Used Microsoft Access and VBA script to write tools to automate customer support reports.
• Conducting interviews with various business users to collect requirement and business process information using MS Visio, Requisite pro.
• Using Agile Development methodology throughout Project Life Cycle.
• Working in an Agile/Scrum environment which posed initiating several JAD sessions and active interaction with business and technical teams
• Identify, prioritize, research, and track key legislation and regulation for the Commercial Banking industry, particularly for issues relating to commercial banks
• Assist in developing proposals to clients and potential clients for mergers, asset or company divestitures or acquisitions and related advisory services
• Perform the API Testing for the end points systems
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Financial analyses including valuation, pro forma merger scenarios, cash flow and liquidity analyses, returns analyses, etc. through development of detailed financial and operating models
• Performed Restful API testing using and created from framework from the scratch
• Build Platform features, user stories, and maintain backlog with priorities, using Rally and JIRA platforms
• Build Platform features, user stories, and maintain backlog with priorities, using Rally and JIRA platforms
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Extensive knowledge with Fixed Income, Equities, Foreign exchange. This includes the associated systems; Swift, FedWire,
• Reviewed System and Integration Testing SIT, Regression Test Cases by using ALM for the Core MMIS's functional areas e.g. Provider, Member, Web Portal, Finance, and Reference.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Creating and upgrading payment processing procedures time to time for bank operations.
• Comprehensive knowledge of Treasury processes, including liquidity risk management/monitoring and; knowledge of regulatory reporting standards and practices
• Review compliance to internal controls, including adherence to policies, standards, rules and regulations
• Helped in enhancement of the internal audit functions that further aligned company SOX compliance strategies
• Identify and assess new and existing risk and elevate any concerns to Capital Markets Senior Management to mitigate bank exposure or potential loss.
• Creating and upgrading payment processing procedures time to time for bank operations.
• Responsible for end to end support for state farm enterprise credit cards product: Visa, MasterCard, Amex and Discover.
• Working on Lifecycle, Create and follow up on JIRA tickets for the change requests received from various business partners.
• Work with Business Intelligence tools such as Business Objects to develop reports and provide data to stakeholders
• Lead various process improvement projects within Capital Markets and ensure timely and accurate results of all project deliverables.
• Created interactive dashboard using advanced excel to provide complete end to end visibility of supply chain process.
• Performed additional tasks as assigned, improving the effective administration of the AML and KYC Policies.
• Using RUP approach to fabricate UML diagrams and use case storyboards.
• Providing value added suggestions for process improvement to business partners and end users.
• Interfacing with end users and business owners to examine current work processes and communicating the results to the stakeholders.
• Conducting JAD sessions with management, SME's, vendors, users and other stakeholders for open and pending issues
• Perform GAP analysis to define gaps between AS-IS and TO-BE processes.
• Providing recommendations and helping in resolving errors and reconciling daily bank control of State Farm payment centers and treasury services.
• Interacted with Credit Card Processor First Data Inc and acquirer for processing refunds, voids, chargebacks and reversal transactions.
• Monitoring credit card application and reporting to high level management about possible risk and ensured compliance.
• Serving as a liaise between Supply Chain, Finance and IT teams and providing analysis
• Proficient in writing advanced SQL queries with ability to analyze large volumes of data.
• Demonstrating excellent technical writing skills by developing Business Requirements Document (BRD) and Functional Specifications Document (FSD).
• Responsible for modeling requirements using UML diagrams such as Use cases, Activity diagrams in MS Visio tool.
• Experience in translating client requirements into different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams.
• Following and Appling Rational Unified Process (RUP) Methodology in defining the problem, gathering requirements, business modeling and communicating with the technical team for the development of the system.
• Participating in the development and preparation of the Test Plan with the testing team.
• Experience working on projects with blended Waterfall and Agile environments.
• Extensive experience in producing documents like Business Requirements Documents (BRD), Functional Requirement Specifications (FRS), Software Requirement Specifications (SRS).

Confidential, Lake Mary, FL

Business System Analyst/Business data analyst

Responsibilities:

• Integrated data from disparate systems to give holistic reporting across Global information solution center.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Enhanced the existing online banking application by improving its GUI, making it more users friendly.
• Managed user stories and conducted Scrum Ceremonies throughout the product development life cycle.
• Played active role in file transferring and file processing from mortgage to banking Division.
• Ensured that the modifications suggested by the users were incorporated into the Application.
• Facilitated Joint Application Development (JAD) requirements gathering sessions.
• Performed GAP analysis and SWOT Analysis.
• Used lifecycle management and API management.
• Participated in functional design sessions, creates and executes SQL test scripts, and aids in the solution of data issues.
• Validated the test data in DB2 database on Mainframes using SQL queries.
• Working on Lifecycle, Create and follow up on JIRA tickets for the change requests received from various business partners. Test them in prestage and test env to validate and bring them to closure.
• Designed from the scratch. Imported data from the Excel spreadsheets into MS Access database.
• Created a number of reports essential for the project operation, provided the reports both in Access and Excel formats, developed Operational, Logistic, Finance, Production and Management modules.
• Involved in documenting detailed Functional Requirement Specification based on Basel regulatory requirements
• Design, Integrate and implement controls to prevent operating exposures and increase business improvements in Capital Markets area.
• Utilized sharp presentation skills and background in software engineering to present a demo of the tool to the executive director of Supply Chain department and other stakeholders in the chain.
• Extensive use of JIRA to create user stories.
• Gathered and documented MDM application, conversion and integration requirements.
• Provided advice on AML and sanctions risks related to all Wholesale Banking clients in the America’s region
• Interacted with the stakeholders to gather user requirements and their expectations from the system
• Reviewed and documented the requirements in Business Requirements Document (BRD), Functional Requirements Documents (FRD), and Frequently Asked Questions (FAQ) and conducted JAD Session.
• Defined Project Scope and worked with the development team to create User Stories as per requirements.
• Participated in User Acceptance Testing (UAT) and Quality Assurance.
• Conducted User Acceptance Testing (UAT) to ensure all the business requirements have been fulfilled by the application.
• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Great effort in regression testing the information or data using SQL skills, data governance and carrying data stewardship skills creating data dictionaries.
• Assisted the execution of CCAR stress testing framework including gathering requirements of multiple stress scenarios and defining data elements required by stress tests.
• Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems.
• Creating data flow diagrams and data mapping for various processes in the project life cycle.
• Implemented functional and technical designs of reporting systems by working in conjunction with the ETL, Support, BI Reporting and Business teams to ensure alignment with current and future business and IT strategies and opportunities.

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Advise product owners, scrum masters and teams to improve their ability to create good product backlogs.
• Observed and implemented mortgage originations, servicing, loss mitigations and loan modifications
• Obtained and verified financial information, such as applicant’s credit rating and income level.
• Analyzed and evaluated applicant’s finances to decide if applicant qualifies for a loan.
• Communicated directly with mortgage banker, customers, agents and attorneys to achieve an ideal customer experience
• Prepared and reviewed of closing documents for purchases, refinances and construction loans.
• Implemented of recommendations from Basel Committee on banking supervision on IT projects for Credit Risk, Operational Risk and Market Risk in line with Basel II.
• Worked heavily on SQL Server database to extract data and build Business reports.
• Experienced working with Data warehousing.
• Extensive use of JIRA to create user stories.
• Extensive use of JIRA to create user stories.
• Worked with the ERP tool and creates the test cases, test scripts and perform user acceptance testing.
• Created MS-Visio diagrams to depict the “AS-IS” workflow of the system in place.
• Worked with enterprise architects to create the “to-be” workflow.
• Experience in developing Test Plan and Test Cases as per the business process requirements to match the functionality
• Understood and interpreting requirement specifications and Mapping Business Process using BPM.
• Gathered data and prepared forecasts and budgets for different regional locations using Excel.
• Experienced in working extensively as an analyst in a Business Intelligence and Data Warehouse environment.
• Analyzed user stories and separate them into high level and low level and prepared product backlog working with product owner and other SME as well as prioritized user stories and assigned to different sprints.
• Translate stakeholder requirements into deliverables such as functional specifications, use cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Responsible for creating the User stories with acceptance criteria for the entire feature list.

Confidential, San Francisco, CA

Business Analyst/Product owner

Responsibilities:

• Created and maintained Meeting Minutes/Issues Log and ensured timely resolution of all items.
• Created UAT Test cases and assisted senior business analysts in conducting UAT tests.
• Created class diagram, sequence diagram, and collaboration diagram using MS Visio.
• Supported development team in unit testing by providing testing data during User Acceptance Testing (UAT) phase.
• Worked with Release Management, PMO, Executive Management, along with managers/staff in Development, ETT, UAT, Core Business and other areas, to plan, delivers, and track testing progress.
• Worked closely with the creation and generation of reports.
• Identified different risks such as credit risk (default risk), prepayment risk, inflation risk, and market risk. Project requirements for cash management practices adhered to accounting principles or GAAP and IFRS.
• Worked with risk management tools for mortgage loan servicing, commercial & residential mortgage, and risk analytics for MBS.
• Determined functional requirements through conducting user interviews and created business requirement document (BRD) and traceability matrix, and thus develop standardization of processes.
• Maintaining the Documentation of Business process.
• Closely work with multiple projects.
• Identified the areas for improvement by reviewing and analyzing the existing online portal systems.
• Gather requirements by conducting meetings and brainstorming sessions with end users and SME.
• Assisted senior business analysts in performing GAP analysis and documenting the Business Requirements. Functional Requirements and Non-Functional Requirements into Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs).
• Designed and developed Use Cases, Sequence and Activity Diagrams using UML.
• Created wireframes and prototypes of the new web interfaces to communicate development ideas to the business users and the management teams.
• Worked closely with UI design and development team to ensure viability of new features and ensure proper functionalities of the complete system.