Sr Business Analyst

Around * years of Business and Data Analysis experience focused in industries like - Banking & Financials, Auto Finance with proven experience in designing, developing, supporting critical business data models within the domains. Strong knowledge on auditing and tax return activities of all types of business domains.

Excellent skills in facilitating the JAD (Joint Application Development) sessions for gathering Functional and Non-Functional requirements.

Thorough understanding in analyzing and creating Use-cases, various UML diagrams like Use case diagram, Process Diagram, Activity diagram, E-R diagrams, Sequence Diagram, Data Flow diagram (DFD’s) using MS-Visio, Balsamic, mock-ups.

Expert in translating user requirements into System Specifications and mapping the process design workflows for SDLC with documenting and managing business requirements.

Excellent documentation skills, especially in designing, preparing and reviewing various documents including the Business requirements document (BRD), Requirement Traceability Matrix (RTM) and testing documents, Systems Proposal Reports, Business Plans, scope and vision of the project, data warehouse process flow (SQL queries & crystal reports) using MS Office and Dashboards, FSD, SRS and SDS.

Strong knowledge of the Software Development Life Cycle (SDLC) models such as Waterfall, Scrum, Agile, RUP, Extreme Programming and Scrum-Waterfall Hybrid, Spiral, SAFe, Kanban.

Demonstrated Leadership personality with strong analytical and problem-solving skills, unmatched persistence and determination with the ability to adapt to a new environment and meeting stringent deadlines.

Experienced in performing Gap Analysis, Impact Analysis, Risk Analysis, Traceability Matrices, SWOT Analysis, Document analysis, AS-IS & TO-BE analysis and Cost Benefit Analysis

Worked in Marketing Analytics department, prepared prospective customer areas reports based on the clients needs

Excellent communication and interpretation skills. Especially, very good at maintaining cordial relationships with business partners, customers, technology teams and Data Management.

Experienced in Project Planning, Project Design, creating functional specifications and data flow diagrams.

Used SSIS as an ETL tool to load data from flat files and databases into SQL Server and Teradata environments.

Worked closely with the QA team to conduct functional, compliance, performance testing and develop the test plan, test conditions, test cases and ensured adequate testing of software both before and after completion, and conducted UAT. Also involved in maintaining Test Matrix and Traceability Matrix identifying various test scenarios.

Sound knowledge of all banking Practices, Financial and Management Reporting, Business Process Reengineering, Forecasting and Capital Budgeting reporting, Ad Hoc reports, Dashboards creation and maintenance using Tableau, Micro Strategy and Power BI for the business.

Proficiency in Windows, Mac OS X, MS Office Suite, MS Project, POS, QuickBooks, SQL

Strong concepts knowledge of all Accounting Laws and Practices, Financing Structures, Financial Markets, Portfolio Management, Project Financing, and venture Capital Funding, Securities and their valuation, risks and returns, and the derivatives i.e., Forwards, Futures, Call and Put options, Swaps and Fixed Income Securities with Very good understanding of Present values, Future Values, Annuities, Simple and Compound Interest Rates.

Professional understanding of System development life cycle (SDLC) as well as various phases such as Analysis Design, Development and Testing.

Expertise in using source code control systems such as GIT, SVN

Worked in JIRA and used to regular scrum meetings in Agile methodology.

Experience in working with Agile methodology, SAFe, and SDLC. Involved in daily scrum meetings, used to KANBAN boards.

EDUCATION:

Masters in Information Technology- Southern New Hampshire University GPA- 3.6

Technical Skills

SDLC Methodologies

Agile, Agile-Scrum, Waterfall-Scrum Hybrid, Extreme Programming (XP), Spiral, SAFe, Kanban, Scrum-ban, Rational Unified Process (RUP).

Requirement

Management Tools

JIRA, HP ALM, Rational Requisite Pro, Confluence, MS Project, MS Office 365 (MS Word, MS Excel, MS-PowerPoint, MS Access) MS SharePoint, MS Outlook

Reporting Tools

Tableau, Power BI, MS office suite, JIRA, SQL Server Reporting Service.

Graphical &

Modeling Tools

MS Visio, Balsamic, Rational Rose, UML, Mockup Screens.

Databases

MS Access, MYSQL, Microsoft SQL (T-SQL), Oracle9i&10g (PL/SQL).

ETL Tools

SQL Server Integration Services, Oracle Warehouse Builder, IBM Cognos Data Manager

Data Warehousing

ER Modeling, Dimension Modeling, Data Marts, OLTP, OLAP, Data Profiling, Data Mapping, Data Mining, Data Validation, Star schema, Snowflake Schema

MS Tools

MSOffice Tools (Word, Power Point, Excel)MSAccess,MSSharePoint,Outlook365

Professional Experience

General Motors Jan 2018 – Till Date

Austin,Tx - Remote

Sr Business Analyst

Project Summary: Worked on analyzing payroll business processes, making the required changes and training the users on the changes made. Performed UAT test and validate the integrity of payroll data and all the steps of the year-end process.

Responsibilities:

•Conducted workflow, process flow and GAP Analysis to derive requirements for existing systems enhancements

•Studied and analyzed transactions of all kinds to improve existing and create new predictive financial models

•Document lineage, including data hops and transformations of all the data elements in the Banking system from Source to target views.

•Responsible for interacting with the business users, and enabling their reports on the Power BI, coordinating with the technical teams, and interacting with vendor specialists for product related issues.

•Involved in data management for Credit Risk, Liquidity risk and Market Risk data warehouse and creating business rules for risk management systems.

•Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements and technical specifications of the product, and followed-up defects using TFS. Tested various sprints using Agile methodology.

•Work with the business users to understand & document the functionality requirements.

•Utilize TFS as an agile tool to manage product backlog items and sprint tasking.

•Wrote business requirements specification (BRS) and functional requirements specification (FRS) documents as per the business requirements and process flow.

•Responsible for technical issues related to reports and dashboards, such as issues related to performance of the reports, failure to render, and other technical causes of failure.

•Setup and managed entitlements, also managed and promoted reports, trouble-shot issues with data sources for data exploration read-only issues.

•Collaborate with business and technology teams to provide comprehensive technological solutions for various business problems like cost analysis.

•Expertise with Administration and Configuration of Salesforce CRM to populate and maintain data.

•Participated in the Logical and Physical Design sessions and developed Design Documents.

•Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds.

•Participated in bug thrashing sessions to discuss and resolve bugs with developers.

Q2 Banking Jun 2016 – Jan 2018

Austin, TX

Responsibilities:

•Identified third party services, performed Feature Analysis and developed RFP document.

•Liaised between the financial reporting team, business users, mortgage servicers and the development team.

•Facilitated brainstorming sessions, conducted one-on one interviews and JAD sessions with servicers and business users for eliciting new reporting and data requirements

•Documented the requirements In BRD and created the FSD.

•Performed GAP analysis by creating the As-Is and To-Be business models.

•Assisted the team and Product Owner by fluently translating the gathered requirements into User Stories as per the INVEST criteria and enforced Acceptance Criteria for the same.

•Created and presented UI prototypes of the enhanced web portal and applications to the business users and concerned stakeholders, using Mock up screens and Wireframe.

•Verified priorities and feasibility of the User Stories with the team and Product Owner during the Sprint Planning meeting and Backlog Grooming sessions.

•Helped the team to properly decompose the User Stories into Tasks.

•Coordinated with the team, business users and created the Data Mapping Document as per the requirements of the stakeholders, business users and financial analysts.

•Updated the existing Data Dictionary.

•Provided ad-hoc query assistance to Data Warehouse users when required.

•Worked with SQL queries using MS Access for data manipulations.

•Scheduled and monitored completion dates, budgets, and variance reporting.

•Collaborated in building a business analysis process using Rational Rose, RequisitePro, and Visio.

•Used Context API for medium size state management instead of Redux for quick prototyping.

Mass Mutual Jan 2014- Dec 2015

Hartford, Connecticut

Responsibilities:

Manage multiple projects of medium-to-large size simultaneously, and their respective project teams of varying sizes, complexity and backgrounds through the entire Project Development Life Cycle.

Establish and maintain project plans and project budgets, report progress as required, generate risk assessments, escalate issues, and facilitate project review presentations.

Develop presentation deliverables related to projects.

Work with a cross functional team on assigning tasks, establishing project deliverables and scheduling of those tasks and deliverables.

Obtain approvals from primary stakeholder(s) and control project scope, priorities, and schedule.

Contribute to thoughtful and creative discussions with project sponsor(s), stakeholders, department and division management on strategic goals, resources, scheduling, plans and challenges.

Assist leadership with allocating resources and outlining budgets to complete various strategic initiatives.

Manage the day-to-day projects/logistics and the corresponding communication for each project.

Involved in define the entrance/exit criteria for all testing phases (i.e. Unit, System, UAT, & Performance testing).

Involved in facilitating defect review meetings.

Supervise the Test execution process and supported test case and test script creation for test team using Quality Center.

Create and maintain the Detailed Test Execution Plan.

Establish and organize Onsite/Offshore Test Teams and define standard SQA methodology and standards.

Extensively involved in requirements traceability matrix to ensure all requirements have been met and thoroughly tested.

Extensively used SQL scripts/queries for Data Verification and Data Validation at the backend.

Participated in User Acceptance Testing coordinated with clients for maintaining Quality Standards.

Participated in the status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution

Contact this candidate