Resume

Sign in

Data Analyst

Location:
Grafton, MA
Posted:
February 20, 2020

Contact this candidate

Resume:

Executive Summary

Scrum-master Business Analyst with MBA Degree and 6+ experience in Business/Data analysis and improvement, data reporting, client engagement, and project management leveraging Agile methodologies.

Experience working in Agile and Waterfall environments of the Project Life Cycle. Adept at Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Testing (DFAST) with banks and financial services.

Skill-Set

Skills: Business Analysis including quantitative and functional analysis, creating user stories, BRDs and FRDs, data reporting, data mapping, data lineage, data quality, Data Warehousing experience with Software Development Life Cycle a(SDLC) and Agile/Waterfall methodologies, Scrum master

Tool : Igrafx, MS Visio, Oracle, Jira, SQL, SAS, Tableau,SharePoint, Jira MS Office Suite, DFAST

Professional Experience

ISO, Holyoke, MA Sept 2019 – Dec 2019

Data Governance Analyst

Data governance and documentation:

Analyzed data and assisted with planning and applying data governance standards to the current documentation

Worked with IT to ensure audit issues are addressed (PL/SQL, MS Access)

Generated Data Governance metadata and ensured Data Dictionary is accurate

Linked data lineage to data quality and business glossary work within the overall data governance program

Experience in implementing metadata, Business Glossary, Data Lineage and data quality

Created business data dictionary, data lineage and required metrics for various reports

USAA, San Antonio, TX Mar 2019 – Sep 2019

Data/Business Solutions Analyst

Data/Business Analysis: Analyzed current data for W-9 Remediation project, produced audience files and reports, performing analysis, documentation, performing data validation, troubleshooting and researching issues

Data Reporting: Scrubbed the data and provided recommendations to improve data reporting process (SAS/SQL)

Capital One, TX Feb 2016 – Jan 2019

Business/Data Analyst- Regulatory and Reporting

Client Engagement: Interacted closely with the business users and key stakeholders to gather business requirements and analyze the functionalities to be incorporated into the system

Business Analysis: Prepared detailed business and functional requirement documents. Responsible for defining, analyzing and communicating key metrics and business trends to the management teams. Generated data in order to create reporting infrastructure/dashboards for business process management and data mining. Coordinated and led meetings across business lines to verify completed assessments.

Traced Data Lineage of data elements to be used

Analyzed data lineage processes to identify data points, control gaps, data quality issues, and overall lack of data governance

Documentation of Business Lineage and Technical Lineage

Extensive experience in implementing metadata, Business Glossary, Data Lineage and data quality

Process Analysis: Improved process efficiencies by 20% by identifying redundancies and other inefficiencies. Experience on Change Management

Project Management: Defined project requirements by identifying project milestones, phases, and elements; forming project team; established project budget; provided recurring status reports, thereby creating smooth project lifecycle

Data Reporting: Provided visual representation for financial data to stake holders for intuitive decision making (Tools: Access, Tableau)

USAA, San Antonio, TX June 2015 – Dec 2015

Business System Analyst

USAA is a fully integrated financial services company in United States of America serving more than 6 million military members. Governance Risk and Compliance (GRC) is an important area in any bank, which handles the risks and how to mitigate them (risk management). This program uses the existing enterprise repository to track and report privacy related controls and to capture the results of assessments of those controls that demonstrate effectiveness in mitigating the risk of non-compliance with applicable laws and regulations.

Business Analysis: Understood and utilized the existing infrastructure created to house LOB level privacy risks and controls. Coordinated identification of P&C privacy risks. Supported P&C in development of their privacy controls against the identified risks. Eventually loaded completed privacy controls and repository.

Used Waterfall methodology and Agile SDLC methodologies like SCRUM in building users' required systems.

Performed requirement gathering, prepared Business Requirement Document and Functional Requirement Document and took active part in analysis and design.

Created business process workflow diagrams (Activity diagrams) in MS Visio

Participated in project review meetings and gathering Business Requirement Documents (BRD/FRD)

Data Reporting: Verified reporting functionality by LOB, across the enterprise and by law/regulation

Project Management: As a scrum master, I conducted scrum meetings to ensure quality and timely deliverables(Agile-scrum)

USAA, San Antonio, TX July 2013 – June 2015

Business Analyst/Data Analyst

(Dodd-Frank Act Regulatory Reporting)

USAA is a fully integrated financial services company in United States of America serving more than 6 million military members. The Dodd-Frank Wall Street Reform and Consumer Protection Act (Dodd-Frank Act Regulatory Reporting) requires national banks and federal saving associations with total consolidated assets of more than $10 billion to conduct annual stress tests. The Office of the comptroller of the currency (OCC) guidance indicates that developing high-quality internal data is crucial for improving a company’s stress testing estimation practice.

To comply with OCC guidance, the USAA Federal Savings Bank (FSB) has established a program to identify and document full data lineage and all transformations for all input variables to stress testing models. This will allow institution to provide full traceability and transparency of the input data sources.

Client Engagement: Interviewed clients to gather project goals and requirements thereby building relations and becoming single point of contact between involved teams. These relations included but not limited to diverse business units like technology and business partners like data modelers, data governance and business managers.

Business Analysis: Developed and analyzed credit and fraud risk models. Worked with various work streams and SMEs to break down the project goals into business and functional requirements thereby providing clear concise documentation for data and process analysis.

Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.

Managed the approved changes when and as they occur by regulating the flow of requested changes and prepared Data flow diagrams

Involved in all phases of the Software Development Life Cycle(SDLC) including requirements gathering, analysis, design, developing, testing and deployment

Can work on SQL Server database by development of views, tables and load data into tables using Stored Procedures

Created business process workflow diagrams (Activity diagrams) using Rational Rose.

Linked business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvements.

Linked data lineage to data quality and business glossary work within the overall data governance program.

Experience in Data Lineage using Excel

Extensive experience in implementing metadata, Business Glossary, Data Lineage and data quality

(Data Governance and Strategic Planning)

Data Analysis: Performed data analysis of all the DFAST models including breaking down of scenarios - baseline, adverse, and severe scenarios along with creating data lineage and pseudo SQL codes for QA and development teams. Created controls in order to ensure data was reconciled and properly mapped according to CCAR requirements.(Tools: MYSQL, Access, SAS/ETS, SAS/Macros, SAS/SQL, and Excel)

Data Reporting: Worked on a Regulatory audit requirement involving data quality &analysis. Provided graphical visualization of the business and data level analysis/data mapping for easy understanding and recommendations to the stakeholders. Assessed data granularity, mappings and rules related to FR Y-14 reports.(Tools: Igrafx)

Project Management: Managed projects with third party vendors and consultants along with internal resources to ensure effective support of DFAST initiative. As a scrum master, I conducted scrum meetings to ensure efficient and effective project lifecycle. Manage project meetings, deliverables, timelines, and ad hoc tasks in conjunction with stakeholders (Agile-scrum)

Automation: Created automated processes during entire DFAST project execution thereby improving process efficiency by 15%. The project was initially planned for 26,000 man-hours, but it was reduced to 12,000 man-hours allowing early completion and receiving highly accolades from the OCC(Tools: Excel Macros)

Testing: Created test scenarios and reports for business and development teams to perform comprehensive test and ensure user acceptance. Produce Stress Testing scenario results, review & challenge, and documentation of procedures and methodology

Rajyog Engineering Pvt. Ltd., Vadodara July 2010 – May 2011

Accounting Assistant

Accounting: Responsible for Budgeting, Budget Tracking, AP and AR, and processing monthly payroll for employees

Creating and presenting weekly and monthly sales and expense report

Sales/Marketing: Partook in exhibitions across the country to develop prospective client base and generate leads

Project Management: Assisted in project planning process and created recurring tracking reports

Kemrock Industries and Export Limited, Vadodara Apr 2009 – June 2009

Internship

Project Planning: Managed interdepartmental task scheduling between Human Resources, Marketing, Finance, and Production departments

Education

University of New Haven, West Haven, CT, USA

Master of Business Administration, May 2013 – Major in Accounting – GPA 3.67

Specialized Coursework and Projects: Business Analysis, Project Management, Finance Strategy and Valuation, Reporting and Analysis, Financial management, SQL

Maharaja Sayajirao University, Gujarat

Post-Graduation Degree, May 2011 – Major in Accounting and Finance

Maharaja Sayajirao University, Gujarat

Bachelor of Business Administration, May 2010

Certificate

1.Scrum master Accredited Certificate from International Scrum Institute



Contact this candidate