Scrum Master Business Analyst

AVANTHI CHINTALAPATI

*** * ********* ** *****: 904-***-****

Mooresville NC 28117 email: *******.***@*****.***

PROFESSIONAL SUMMARY:

Certified Scrum Master - CSM, Project Manager and Sr. Business Analyst with 13+ years of professional experience having strong knowledge in Retail & Banking industries.

Certified Salesforce Admin with hands on experience on configuring Salesforce CRM platform.

MBA candidate complemented by expertise in the field of Information Technology.

Expertise in managing teams and working in partnership with clients and being interface between technology and business. Strategic planner in using technology with business.

8 years of leadership and team management experience in various projects.

Experience in B2B, B2C and Ecommerce portals web application developments, expert in developing and evaluating business process Models.

Have worked on planning project proposals and have extensive knowledge on project estimates and timelines.

Strong experience in project life cycle and SDLC methodologies including Waterfall, SCRUM and Agile.

Worked closely with multiple Quality Assurance teams and ensuring requirements traceability.

Working knowledge of Business Process Modeling (BPM) and notations (BPMN 2).

Created use-cases, process flows, proto types, mock-ups and wireframes to make customers understand and get an idea of the system and make sound decisions.

Experience in implementing all phases of the software development life cycle (SDLC), including business requirement gathering, preparing the high level and low level design, construction, testing and implementation of various IT projects.

Worked as an integral part in application support and maintenance. Worked with L3 and L2 support teams.

Expert in design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.

Experience in managing the changes in requirements by Unified Change Management Tools like Rational Clear Quest.

Experience working with Content Management tools like Oracle UCM (Universal Content Management)

Knowledge in the OLAP tools and Business Intelligence (BI) tools.

Have worked closely with client engagement teams to ensure that there are no gaps in the entire SDLC of the project.

Successfully coordinated with multiple teams including DBAs, vendors to ensure smooth flow of the design and development stages.

Excellent communication skills and a good team player with analytical and problem solving skills.

EDUCATION:

Webster University, St. Louis, MO GPA 3.9/4.0

Bentley University, Waltham MA

Master of Business Administration

V.R. Siddhartha Engineering College, Vijayawada, India

Bachelor of Technology in Electronics and Communication Engineering.

CERTIFICATION: CSM – Certified Scrum Master, Certified Salesforce Admin

SKILL SET

Primary Skills : Certified Salesforce Admin, Oracle UCM, Filenet, Accounting Recon Tool –IntelliMatch, HP Quality Center v10.00, Clarity PPM v12, MS Project, MS Visio, SWIFT Files, Pseudo 950 and OGL formats, MS Office (word, excel, PowerPoint), Sharepoint 2010, Rational Rose, Rational Clear Case, Rational Enterprise Suite, 2003-2007 Outlook, Rational Requisite Pro, Test Director, Win Runner, Load Runner, Quick Test Pro, ATG E-Commerce, Web Sphere Commerce.

Technical Skills : Salesforce Admin, .Net, Mainframes, COBOL, JCL, PL/SQL, Java, ATG, Data Warehouse, ETL, Oracle Hyperion Essbase, HTML, Java, JavaScript.

Databases : DB2, IMS DB, Oracle.

Platform : MS Windows, UNIX.

Reporting Tools : Hyperion

Working Knowledge of Salesforce, ATG, Oracle UCM, BPMN 2, ERP, Oracle e-Business Suite – General Ledger, Accounts Payable, Accounts Receivables & Financials

PROFESSIONAL EXPERIENCE:

Lowes Companies Inc Jul’18- Current

DACI Loyalty

Sr. Scrum Master/Program Manager

Launch MLR (My Lowes Rewards) for all DIY loyalty customers. This project encompasses rolling out Bonus points, extra points rewards and My Lowes money to all DIY loyalty customers basing on a tier structure. The project is to roll out the Loyalty program in phases to incorporate various offers and campagins and build a superset dashboard to capture the program’s KPIs.

Salesforce CRM Implementation

Sr. Scrum Master/Program Manager

Provide the Contact Center with an integrated and innovative CRM platform that supports associates and management with the ability to manage all inbound and outbound interactions for accurate, first call resolution. The CRM will proactively provide information for the associate to empathize with the customer throughout their journey while creating a way for management to monitor workload and create proactive coaching. The team is focused to accomplish the following as part of this project:

1.Replace Siebel with Salesforce Service Cloud for the Contact Center users

2.Reduce Level of Effort (LOE) for Associates by unifying ALL CC Associates with a single CRM application by the end of 2021

Roles & Responsibilities:

Manages two teams with more than 20 member team across different geographies and time zones (India and Charlotte) to ensure on time delivery of the project.

Lead BRP (Big room Planning- Quarterly planning) meetings.

Plan the timeline for the entire MVP release coordinating with multiple teams.

Work with multiple sprint teams to get status updates and report the statuses to leadership.

Work on risk mitigation methods and involved with communicating with Business and technical stakeholders.

Plan sprints in alignment to the overall delivery timelines.

Conduct sprint ceremonies with teams and resolved blockers.

PBI and OKR review with product management.

WellsFargo, Charlotte Jan’18- July’18

Intellimatch to DART Conversion

Scrum Master

The purpose of the Wholesale New Reconciliation Application Project is to move from an outdated 1998 legacy FIS/SunGard reconciliation system to a cloud-enabled in-house reconciliation system. The current reconciliation system, IntelliMatch is considered a CAM (Critical Applications Model) high application and ranked in the top 100 Technology applications in the scoring of security vulnerabilities. These vulnerabilities were assessed based on an algorithm that was executed upon all Wholesale technology applications. The score included factors such as system age, programming language that the system is coded SOX application, number of users, and whether it is a critical books and records system. IntelliMatch has had a vulnerability exception open since February 2016 for the inability to upgrade to MSXML 6.0 and the application utilizes functionality not supported in MSXML 6.0. The vendor has been reluctant to resolve vulnerabilities and while they are now attempting to address MSXML 6.0 (targeting Q4 2017); any future vulnerabilities will require significant rewrites of the application. Develop and implement more accurate and proactive liquidity forecasting models and match rules to predict cash inflows and outflows.

Roles & Responsibilities:

•Involved in working standardizing field names for DART recons

•Worked on Match rule Analysis and enhancements of match rules.

•Gathered requirements and conducted FSD reviews.

U.S. Bank Jun’17- Jan’18

Loan IQ v7.1.4 Upgrade Project

Scrum Master/Project Manager

The LoanIQ, commercial Loan system module with in the U.S.Bank is upgraded from version 6 to version 7.1.4. The upgraded is segregated out to three phases: Database upgrade, app server upgrade and client installation and enhancements to the output reports. The project also includes integrating FATCA module to the Loan IQ interfaces. The two modules with in the project are handled in two different forms: FATCA integration is a waterfall approach and the LoanIQ upgrade in a Agile scrum approach.

Worked as both Project manager and Scrum master with onsite and offshore team.

Daily stand up scrum meetings

Sprint planning, backlog review.

Conducting retrospective sessions after each sprint and sprint demo sessions with whole team.

Project planning and defining the scope with regular meetings with the team

Developing project plan, cost estimates

Working with the team to identify any roadblocks

Conducts daily status call and weekly status meetings to report the team progress.

WellsFargo, Charlotte Jan’17- May’17

GE Capital MCT- OPICS new Branches

Scrum Master (Kanban methodology), Business Systems Consultant

The GE Capital Acquisition will result in a substantial increase of non-USD balance sheet positions. Of particular note are the Wells Fargo Capital Finance and Wells Fargo Equipment Finance entities in the Americas (specifically Canada), Wells Fargo International Finance LLC, Cardinal International Leasing (“WFIF”) and new entities formed as subsidiaries of WFIF in the Asia Pacific region. Corporate Treasury Group and International Finance do not currently have robust tools and infrastructure to effectively manage and hedge this increase in FX position and funding/liquidity risk in Canada and APAC. Hedging of the FX position must be conducted in compliance with the Volcker Rule and a manual non-automated process is not sustainable. Two new OPICS Branches (Branch 09 – Asia and Br 10- North America) are created to manage non-USD positions in multiple entities.

Roles & Responsibilities:

•Conduct weekly meetings with London team and Hong Kong team to gather the requirements.

•Responsible to gather the status of different teams involved in the project.

•Created new Balance Pools/ categories in the recon tools – SRPL, Intellimatch and DART

•Team lead for escalating issues to Technology providing and Senior Executive Management noticed in testing.

WellsFargo, Charlotte Feb’16- Dec’16

DCOE- Derivatives Center of Excellence

Scrum Master, Business Systems Consultant

Internal non-Derivative transactions between Wells Fargo affiliates captured on International SORs like Midas+ London & Cayman branches), OPICS, Calypso, Flexcube, Loan IQ etc. are not being interfaced into Oracle GL to facilitate correct elimination on consolidation for external reporting purposes.

The two main issues are: One side of an internal non-derivative transaction going unrecorded or not being recorded on equal and opposite terms to the corresponding other side. Internal non-derivative transaction breaks occurring and not being identified and resolved on a timely basis. This project is to effectively manage funding strategies and optimizing liquidity management.

This is a major project with high visibility due to the CICAT issue and Affiliate accounting. All SORs with in International are engage and tested as part of this project.

Roles & Responsibilities:

•Met with the Controllers team and the chief controller every week to chalk up the strategy in creating the requirements for affiliate accounting.

•Pivotal in creating the matrix of account elimination.

• Worked and validated all SORs with in International like Globus T24, Calypso, IBIS Asia, IBIS London, IIS, Legacy Midas, OPICS all branches, and Flexcube.

•Worked with technology partners closely to develop requirements for recon with in DART tool

•Major team player for creating customer relationship matrix in DCOE Trade recon.

•Team lead for escalating production issues to Technology providing clear and concise written and verbal communication to Senior Executive Management.

WellsFargo, Charlotte Jan’15- Sep’15

FATCA - Foreign Account Tax Compliance Act

Project Manager/Business Systems Consultant

Wells Fargo need to comply with FATCA reporting regulation, which includes systems of record being able to pass identified pieces of data to centralized tax reporting solution and directly to local tax authorities for branches located in countries with Model 1 IGA agreement. To meet that goal, WF created a repository that will include all data required for any “foreseeable” tax reporting. The tax reports 1042-S and 8966 are created and sent to GAMS (Global Application Middleware Service) and IRS. To enhance the financial stability and operational efficiency of the organization by improving the management of liquidity, optimizing funding strategies, and ensuring adequate cash flow for day-to-day operations.

This is a high visibility project as the tax reports are directly sent to IRS after the team validates them

Roles & Responsibilities:

•Played crucial role in developing the procedures to understand the tax reports (1042s and 8966) and validate them

• Worked with many SORs like Globus T24, Calypso, IBIS Asia, IBIS London, IIS, Legacy Midas, OPICS all branches, and Flexcube.

•Partnered with Technology and Business partners to develop and test solution prototypes for reporting requirements.

•Team lead for escalating production issues to Technology providing clear and concise written and verbal communication to Senior Executive Management.

•Documented all tax reporting procedures and manual processes for training and audit.

•Written business requirements for projects.

•Responsible for customer onboarding static data reconciliation against multiple systems to ensure a high level customer experience for Wells Fargo’s international products.

•Accountable for meeting and maintain documented reconciliation of income expense back to Oracle GL.

WellsFargo, Charlotte Jan’14 – Jan’ 15

GL Remediation - IBIS

Scrum Master

Standardize the GL entries made into companies General Ledger. Ensure all the GL entries from London IBIS files are posted in respective foreign currencies instead of an USD to General Ledger. Create and validate the recon files for chart of account, IntelliMatch, detail trail balance, summary trail balance, manual general ledger entry, GL interface to ensure validity of the data.

Roles & Responsibilities:

•Create work breakdown structure and prepare a project plan

•Monitor project progress and responsible for ensuring alignment between user requirements, funding requirements, technical requirements, and system capabilities.

•Gather business requirements and create Business Requirements Document (BRD)

•Worked on SRPL, Intellimatch recons extensively

Bank of America, Charlotte Jul’13 – Dec’13

ROCC – Deposit & Debit Services

Sr. Business Analyst / Scrum Master

Reduce, Optimize and Control Cost project deals with migration of XAD daily extract processes to Data stage processing platform without any compromise to customer deliverables. It extracts the required information from the XAD tables and send to the downstream application like W, FFD and Viewdirect and also create the Internal XAD account incentive and affinity related reports.

Roles & Responsibilities:

•Use Agile and Scrum methodology for a sequential development process

•Take daily status during SCRUM meetings & identify progress and road blocks.

•Estimate time lines and work on creating a deployment plan & implementation.

•Analyze the current process and draft the requirements / user stories for future state.

•Provide a project status to leadership and management teams during SCRUM of SCRUM meetings.

•Act as a single point of contact for all the needs and queries of the project

•Create Detail Task Plan (DTS).

•Prepare the use cases and prototypes for the project.

•Prepare the As-Is and To-Be diagrams for the modules in the project.

•Review all the test cases and ensure that all the requirements are thoroughly tested to the satisfaction of business users

•Host weekly defect triage meetings to gather status from QA & development teams

Wells Fargo, Charlotte Sep’12 – Jul’13

IntelliMatch Upgrade - Wholesale Banking

Sr. Business Analyst

IntelliMatch is a multi-currency detail account reconciliation application that simplifies the process of account reconciliation used by the Wholesale banking group of Wells Fargo. This project upgrades IntelliMatch from version 8.1 to a new version 9.1

Roles & Responsibilities:

•Monitor project progress and is responsible for ensuring alignment between user requirements, funding requirements, technical requirements, and system capabilities.

•Gather business requirements and create Business Requirements Document (BRD) for all the three phases from different lines of business (LOB’s).

•Lead User Trainings & create User Training manuals for the new application.

•Liaise with the technical team, QA and business team to determine the requirements and project scope.

•Initiated meetings with the upstream and downstream teams.

•Responsible in creating Master test plan and test scripts for all the three phases.

•Reviewed QA and UAT test strategies, including regression and integration testing,

•Responsible for end-to-end testing scenarios and test plans, managed testing, defect reporting and change requests

CSX Corporation, Jacksonville, FL Jan’11 – Sept’12

Enterprise Content Management (ECM)

Sr. Business Analyst

The goal of the project is to capture the documents from all the departments and organize them in a way that they can be easily searched and retrieved when required. This not only deals with the electronic files that reside on the network drives but also the paper files that are in file cabinets and Iron Mountain. Extensively used Filenet and Oracle UCM for image and document capturing.

Roles & Responsibilities:

•Determine how the content can be organized in all the departments after closely working with directors

•Gather business requirements and create Functional Specifications Document (FSD)

•Analyze the file and folder structure on network shared drives for all the departments

•Building the taxonomy for the new folder structure in ECM

•Determine the security and user access on each folder and content

•Identify the retention information on each piece on content

•Create disposition and screening reports

•Involved in User group trainings

•Provide a project status to the leadership and management teams.

Sams Club, Bentonville, AR. Feb’10 – Dec’10

eCommerce – International Expansion

Sr. Business Analyst

International expansion project will enable customers across multiple countries to be able to access all the products and be able to pay in any currency of their choice. Calculate the forex rate on a daily basis to enable international customers pay at the current exchange rate. Used Filenet for order form image repository.

Roles & Responsibilities:

•Analyze the business needs and draft the requirements as requested by the business users

•Responsible to define a process and plan to execute the project

•Ensure that the project is tracked and all the teams involved are clear about what is expected of them

•Define a roadmap depicting key milestones of the project including the code drop and go live dates

•Act as a single point of contact for all the needs and queries on the project

•Prepare process flow diagrams using MS Visio

•Maintain the requirements traceability matrix for all the requirements through the project life cycle

•Review all the test cases and ensure that all the requirements are thoroughly tested to the satisfaction of business users

•Maintain all the requirements and respective test cases in HP Quality Center

•Maintain project financials within clarity, extract reports for project managers & resource managers

mCommerce- Samsclub.com Sep’09 – Jan’10

Sr. Business Analyst

Sams Club has identified process to enhance the member experience to its samsclub.com. This is mobile application project where we developed samsclub.com mobile app for iPhone, Android and Blackberry mobiles. Automated reports are to be generated so that business users will have information handy in a timely fashion. This project also has data warehousing, ETL to help generate reports.

Roles & Responsibilities:

•Used Agile and Scrum methodology for a sequential development process

•Developed Process flow modeling and simulation using BPM

•Created requirements for user interface using Oracle UCM and integrate with ATG

•Worked closely with user interface (GUI) web designers to create screen layouts with emphasis on user friendliness, clarity and consistency with applications and standards; assist with developing new standards and help review Heuristic evaluations

•Gather Requirements, Create User Stories and Acceptance test criteria

•Collaborating requirements with geographically distributed, cross functional teams (Development, QA, UI Design, Documentation, Professional Service Team)

•Extensively used QC (Quality Center) for requirements gathering purposes. Created Test Scripts and defects using HP Quality Center

•Created Requirements Traceability Matrices (RTM) to trace back the test cases to the use cases and requirements

•Facilitated user acceptance testing (UAT) and usability test strategies with Information Technology Group

•Prepare the AS-IS and TO-BE process flows for all the modules in the system

•Generate mock-ups for the reports intended to be developed

•Prepare the use cases for all the modules

•Prepare the proto types to demonstrate what can be expected after the changes are implemented

Bank of America, Charlotte Jul’07 – Aug’09

Finance Data Warehouse (FDW):

Sr. Business Analyst

FDW is a data mart repository of monthly and daily data serving financial clients including Regulatory reporting, Funds Transfer Pricing, Cost Allocations, Tax. It represents an array of systems like commercial loans, payments, deposit systems, loan systems, investment systems, letters of credit, corp. investments, brokering functions, domestic trading, foreign investments, equity investments, securities.

Roles & Responsibilities:

•Prepare the Business Requirements Document (BRD) and estimations, timelines for the project.

•Prepare the As-Is and To-Be diagrams for the modules in the project.

•Expertise with working on complex SQL queries on Oracle & Mainframe DB2 database

•Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM).

•Created and reviewed User Requirements Document, Use Cases, and Functional Requirements Document.

•Worked on Mainframes COBOL, JCL and DB2 in data warehousing.

•In depth knowledge on data analysis, data mapping, data warehousing, ETL, OLTP and OLAP concepts.

•In depth knowledge on BI tools. Used Business Intelligence (BI) tool Hyperion for reporting.

•Designed and developed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams (DFD’s) to define the Business Process.

•Experience working with onsite and offshore model.

•Assist the technical team in preparing and reviewing the Technical Design Document (TDD) and the Technical Specifications for all the components.

•Worked on designing and testing of data marts.

•Worked as an integral part in application support and maintenance.

•Worked with L3 and L2 support teams while generating reports

•Project & timeline planning and ensuring that the time lines are met without any issues.

•Prepare the use cases and prototypes for the project.

Bank of America, Charlotte Sep’05 – Jul’07

Financial Control Systems (FCS):

Software Engineer

FCS is Financial Control System which caters to General Ledger and reporting requirements of Bank of America. It includes various Front-End and Back-End processing functions to provide Budgeting Techniques, Cost Allocation Methods and User Customized Reporting facilities. It is a management information system combining both General Ledger and reporting capabilities to support the accounting functions.

Roles & Responsibilities:

•Prepare the Technical Design Documents and the technical specifications for all the impacted components.

•Code and test the programs to ensure the functionality is as per the requirements.

•Provide the day time support for the application.

Contact this candidate