Data Analyst Business
Resume:
Vaishnavi M
*********.*******@*****.***
SUMMARY:
Over all 7+ years of experience with 4 years of experience as Business/Data Analyst in Financial client and Software Development Life Cycle (SDLC) such as Agile (scrum) and Waterfall and 2 years in SQL.
Experienced in writing user stories, story boarding, and story mapping.
Use-case documentation: defining use case list, schedule, review session, signoff within Agile framework
Joint Application Development (JAD) sessions and White Board Sessions with subject matter experts (SMEs).
Interact with the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.
Business Requirements Documents (BRD), Functional Requirement Documents (FRD), Non-Functional Requirement Documents (NFRD) and System Requirement Specifications (SRS).
GAP analysis (as-is and to-be process models) cost benefit analysis, SWOT analysis and ROI.
Expert understanding of data systems, data integrity, and data validation.
Worked on SQL Profiler to view indexes performance to mostly eliminate table scan.
Reviewed, analyzed and created detailed documentation of business systems and user needs, including workflow, program functions and steps required to develop or modify application programs.
Assisted in developing and maintaining business & financial reports and IT work/databases which was required to support the various lines of business and specific projects.
Consulted with IT Personnel to determine business, functional and technical requirements for specified applications.
Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, SQL Server, Excel and Access to SQL Data Tools.
Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
Developed effective reporting tools for the business unit and completed existing projects from original concept through final implementation.
Organized chart-holding facilities and assisted in training staff. Assisted various projects from start to finish through the SDLC process.
Participated in Code Reviews, System Testing and UAT followed by production verification, post production testing and support.
Process Mapping, Change Management, Continuous Process Improvement and expertise in dealing with financial data and complicated and detailed tasks.
Led of business process techniques such as: Data Flow Diagrams, Process Models, ER diagrams, Sequence Diagramming.
Experience in creating wireframes, storyboards, user flows, process flows and site maps for web and responsive layouts.
Electronic Data Interchange (EDI) transactions used in healthcare industry and good knowledge of HIPAA X12.
Involved in Writing Backend Sql queries for source And Target Table Validation.
Involved in ETL Data validation, count and source to target table mapping using SQL queries and back-end testing.
Experience in Project management tools including MS Project, Power Point, Excel, Visio and MS Word.
Knowledgeable with conducting process mapping and data mapping process documentation.
Effective communication w/ cross-functional teams across org; ability to facilitate business & technical discussions.
Project management experience able to initiate, develop and execute projects from start to finish& being quick learner. Able to meet deadlines, including in urgent situations through task prioritization and time management.
Effective communication with an ability to understand and interpret the operational needs of businesses at all levels.
Excellent oral, written and presentation skills; clear communicator with all cross-functional teams
TECHNICAL SKILLS:
Business Process Modeling Tools: MS Visio
Operating Systems: Windows, Linux
Desktop Software: MS Word, Excel, Access, PowerPoint, Project, QuickBooks Enterprise, JIRA, MS Dynamics
Programming Languages: Visual Basic, Visual C++, SQL, HTML
Project Methodologies: Waterfall, Agile, RUP
STRENGTH’s:
Strong Excel, PowerPoint, Tableau, SQL, SDLC And Access With Focus On Financial Modeling And Report Writing Via The Use Of Pivot Tables, VLookups, Queries And Table Configuration. Trend Analysis And Data Interpretation
PROFESSIONAL EXPERIENCE
MUFG Union Bank .N.A, Monterey Park, CA Nov 2018 - Present
Business Analyst/ Data Analyst
Project 1: Pillar 2c Data Transformation : As part of the data transformation, MUFG Bank is initiated the bigger transformation of the data automation, scope is to automate the 800 + Risk data reports required by higher management to understand to the key risk to the bank, The key risk area’s include Operational risk and Losses, Model risk, Credit risk, Third Party risk, Consumer risk,Wholesale risk, Information risk .As most of the risk data preparing through manual process, Data Transformation project is tracking all the manual business process and documenting the current state and design the future state requirements for data and report automation form the multiple source systems .Also identify the key data elements to build the central DWH. central DWH to help the bank to avoid all the manual effort through technology to receive accurate numbers to understand the risk factors of the bank. The Data Management Integrated Control Framework(“DMICF”) represents heightened standards related to the BCBS 239 RDAR Framework. The full implementation of the DMICF heightened standards across the 3 layers of the EDMA for the BCBS 239 Scope(28key Reports, i.e., Tier 1 Reports) which includes CCAR, FR-Y 14M, 2052A is progressing in phases and targeted to be completed in line with our BCBS 239 alignment target in dates. As we progress on the journey to full implementation for the BCBS 239 scope, we will implement controls incrementally and policies will also evolve incrementally in line with a maturing current state. As these policies evolve, they will refer to component of DMICF.
Responsibilities:
Managed tasks associated with stakeholder communication, data analysis and documentation.
Performed analysis for documenting detail data lineage (source to target)
Documented data flows and Process of Risk Reports..
proficient in use of the standard tools determined by the Data Program
Worked on Risk Reports and provide data domain expertise within report content
Worked within the “POD” allocating necessary time attending daily meetings, status report development, issue escalations, etc.
Proficient in describing details on Risk Reporting schedule process flows, data flows, aggregation routines (etc.) related to assignments for the current state analysis process
Work with Analysts and ISA/CDO to identify gaps in business process, controls and data flows
Specify business requirements for future state “how to” work
Identified data control (new) requirements. IE. Reconciliations and validations. Identify data thresholds, as an example. This is part of new business requirements and may need to work with CDO and ISA representatives
Bridge communication to entities that we currently do not work with Acted as an escalation point for any data analysis related issues.
Project 2: Transformation Pillar #2 -Implement Foundational Tools: Metadata Content Enhancement : Capture key business and technical metadata in Collibra and MetaCenter for over 70 systems of record and systems of reference (i.e., potential golden sources) which are critical to Finance, Risk and Regulatory reporting. This will include all lineage which can be automatically scanned (or manually stated) between in-scope systems of record and downstream aggregation points.
Responsibilities:
Performed analysis and design by translating business requirements and developing reporting solutions that yield relevant business information in a user-friendly format by collecting, analyzing and leveraging data to solve business problems.
Contribute to the business requirements, the coordination and the tests on the IT projects for GTB (Global Transaction Banking). which are upgrade of the payment system for US dollars, online banking platform or investigation tool
Work closely with the front office, the client service/middle office team and the risk officer in order to improve existing processes and tools (IT applications or spreadsheets)
Perform some data analysis to answer some regulatory/business/ internal audit inquiries
Work closely with the relationship managers on customers’ complaints to provide solutions / answers
Working with developers
Deep understanding of Core Banking and Cash Management products including deposits, cards, and account features (checking, ACH, payments, P2P).
Applied technical skills using SQL in data collection, data analysis and reporting to procure data from database structures.
Project 3: Requirements Elicitation, Gathering, Clarification, and Analysis. Participate in the creation of Business Requirements Document. Use Case Analysis and Documentation. Data Analysis and Documentation and proficiency in SQL. Create Functional Design Document. Create Detailed Design Document. Ensure business requirements are organized and coherent for application architects and developers to understand. Test Planning and Coordination. Ensure application meets business requirements. Create and Track Test Plans, Cases, and Scripts. Migration Planning and Coordination. Provide Project Support (Issues Tracking, User Training). Create Application Documentation (User Guide, Operations Guide, Training Manual, etc.). Familiarity with modern web application designs and concepts. Strong knowledge of Software Development Life Cycle (SDLC). Work with business for requirements. Work with technical team to write the detailed and functional design documents.
Responsibilities:
Analyze Risk Reporting data flows/process flows and Update data/process flows.
Collaborate with Business Data Owners, Data Stewards, and Stakeholders to examine and understand their data points
Collaborate with Data Consumers to understand their requirements and make sure they are expressed in ING’s global data language
Be responsible for content analysis of local sources, local data definitions, mappings into global Esperanto business terms, defining testing scenarios and be part of the CoE Data Delivery teams
Be part of the CoE chapter to develop your capabilities and competencies as well as improving your CDMO Esperanto knowledge
Support defining requirements for Data Quality, Data Lineage, Reference Data, and Data Governance
Support, coach and train colleagues on adopting and implementing our models
Report on the progress and communicate the dependencies and impediments to stakeholders
Contribute to existing principles, standards, guidelines and way of working to continuously improve them
Make sure Sources of Record are mapped into Esperanto in a harmonized way
Participate in strategic meta data & modelling initiatives
Build a culture of meta data & modelling craftmanship and improvement
Drive synergies across the global Data management community and stimulate collaboration to ensure delivery on commitments, without relying on hierarchical structure or formal committees to do so.
Project 4:
On-Cycle Activities(Production Run)
Designed and developed Tableau dashboards that enabled stakeholders to focus on performance.
Defined and documented client requirements in structed formats and created data mapping.
Monitoring DQ Dashboards to validate expected DQ rules per report.
Identifying DQ rule failures and communicating to Info Aggregation Domain / Report Production / Project Teams.
Collaborate with Info Aggregation Domain team member to understand report impact & materiality for DQ rule failures, and leverage Tableau AD-Hoc Reporting to gather details on failed records.
Off-Cycle Activities
Creating JIRA tickets for any DQ fails seen in Production.
Troubleshoot DQ rule failures and work with respective business and tech SME’s to understand root cause / next steps in remediating DQ incidents.
On-going Activities
Validation of DQ Rules for Daily Reports via Daily Dashboards(FR2052a & Liquidity Risk).
EDP Control 6 validation, DMICF Monthly Metric reporting, EDP Incident Sampling.
Enhancements to DQ processes.
Cardinal Health Care - Columbus, OH Aug 2017 – Sept 2018
Business Analyst/ Data Analyst
Supported internal project managers in defining the data requirement, implementing and reviewing the functional specification to determine best data design approach and translate business requirements into data models.
Lead a group of 6 BI team members with internal and external client requests to develop reports to help our operations team and clients ensure robust data and excellent quality in reporting.
Ensured that Business, Data Governance and Integration team leads are deeply involved in critical design issues and decisions.
Participated in projects to implement new or extended functionality.
Provided support and maintenance of Dexcom’s MES solution. Identifying areas of improvement for the operations team.
Provided on-going support and training for users of existing systems as well as new functionality.
Set priorities and categories of user requests and assigned development projects.
Gathering requirements from business partners and translate into technical requirements for Camstar team.
Providing subject matter expertise on the Camstar manufacturing system.
Ensuring system changes and enhancements are completed in compliance with regulations.
Provided superior customer service to the user community.
Offer support and guidance for the Camstar team.
Coordinate with the Business Analyst to document the release matrix.
Work with the development team to correct bugs and errors.
Bank of America - San Francisco, CA May 2017 - Aug 2017
Data Analyst
Liaison between Walmart data management team and internal data molding team.
Identified minor and major requirements changes and developed change management proposals.
Produce reports, dashboards, pivot tables and other metrics for accounting and budgetary information within excel.
Design, create and implement IT solutions for inventory, data extraction, database management, metric reporting, and business process efficiencies for accounting and all related business units.
Design management strategies with Microsoft access SQL for data manipulation and extraction.
Reviews and validates new loan bookings and new account establishment and conducts transaction monitoring to insure accuracy
Experience in Banking Operations
Conducts loan payment reviews to establish validity of sources of funds and creates periodic reports for management review
Regular and effective communication
Strong interest in the financial services industry with an ability to achieve results in the context of complexity, ambiguity and constant change
A Team player with strong collaborative qualities and a positive demeanor
Designed and developed user interface for mesh design using Visual Basic 5.0.
Implementation of Metadata Repository, Maintaining Data Quality, Data Cleanup procedures, Transformations, Data Standards, Data Governance program, Scripts, Stored Procedures, triggers and execution of test plans
Analyzed and designed the business rules for data cleansing that are required by the staging and OLAP & OLTP database.
Updated or worked with test team members to help them understand data changes and write test cases
Identified and documented data sources and transformation rules required to populate and maintain data warehouse content
Implemented the Data Cleansing using various transformations
Designed and implemented basic SQL queries for testing and report/data validation.
Ensured the compliance of the extracts to the Data Quality Center initiatives.
Accenture Info Technologies Pvt Ltd - Hyderabad, Telangana July 2015 – Jan 2016
Data Analyst
Developed the billing dashboards for Microsoft delivery management team and developed the billing reports.
Secured a revenue generating project from Microsoft; Recognized by the client for developing interactive dashboards to retrieve critical business data.
Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
Developed reports for supporting consultants in process improvements by performing analytical analysis for developing insights and identifying future areas
of improvement.
Created dashboards used by Microsoft information technology team for billing analysis; assisted the delivery managers in understanding the cluster performance reports.
Responsible for generating the quarterly and monthly business review reports and analysis.
Performed analyses on requirements and maintained traceability matrix.
Contact this candidate