•Collaborated closely with the Policy, Regulatory, and Legal units to review GDPR and CCPA documents concerning the company's overall operations.•Collaborated with Data Stewards for policy updates and managed configuration of the data governance structure in Collibra, overseeing documentation creation and policy development.•Conducted extensive quality control assessments on the data warehouse utilizing SQL Server Integration Services (SSIS) on SQL Server for ETL processing… Show more •Collaborated closely with the Policy, Regulatory, and Legal units to review GDPR and CCPA documents concerning the company's overall operations.•Collaborated with Data Stewards for policy updates and managed configuration of the data governance structure in Collibra, overseeing documentation creation and policy development.•Conducted extensive quality control assessments on the data warehouse utilizing SQL Server Integration Services (SSIS) on SQL Server for ETL processing, facilitating data migration from different databases on the same server and across different servers.•Contributed to the establishment of a database for water scheduling and conservation efforts utilizing Collibra, SQL and Azure Data Factory.•Documented workflow requirements in data governance solutions such as Collibra, ADF, and PowerBI.•Engaged in data dictionary management, extraction, transformation, and loading (ETL) of data from diverse sources such as flat files, Excel, and Oracle.•Facilitated all sprint cadences including Daily Standups, Sprint Planning, Backlog Refinement, Sprint Reviews, and Sprint Retrospectives.•Gathered and documented Master Data Management (MDM) governance requirements through interviews with business and technical stakeholders.•Held accountability for system integration and user acceptance testing of National Automated Clearing House Interface, Monetary Workflows, and Index Rates for Automated Financial Services (AFS) Vision Servicing, a novel web-based commercial lending loan origination and servicing system.•Provided guidance to stakeholders on the configuration and implementation of Data Governance technology solutions such as Collibra and SQL.•Recommended policies for data security, retention, and disposal utilizing documentation, Azure Data Factory, and SQL.•Utilized software tools like Jira, Miro, and Slack to document requirements into a visual representation of value creation steps. Show less

Crafted User Stories in Azure DevOps following the SDLC Agile SAFe model.Developed a roadmap for clients to plan, develop, and implement MDM solutions, facilitating the consolidation of MDM data post Mergers and Acquisitions.Developed Workflows for Collibra and utilized it as an enterprise-wide data governance tool.Engaged in project management, systems analysis, and design of a web-based application for tracking and managing various case and customer data.Executed MDM processes… Show more Crafted User Stories in Azure DevOps following the SDLC Agile SAFe model.Developed a roadmap for clients to plan, develop, and implement MDM solutions, facilitating the consolidation of MDM data post Mergers and Acquisitions.Developed Workflows for Collibra and utilized it as an enterprise-wide data governance tool.Engaged in project management, systems analysis, and design of a web-based application for tracking and managing various case and customer data.Executed MDM processes to translate strategy into a roadmap and design development activities, resulting in the delivery of MDM roadmap & architecture.Experienced with Jira planning, tracking, and managing agile software grooming backlogs, and working on sprints.Formulated a strategic roadmap for data and analytics transformation and innovations, owning the enterprise BI platform modernization strategy covering data governance, EDW, BI, MDM cloud migration, user education, and developer skill enhancement.Functioned as a Business Analyst in a project aimed at migrating the Commercial Lending Process from the existing AFS Level 3 Application to the new application platform AFS Vision, encompassing all workstreams of the Commercial Lending process.Implemented data governance controls and processes to mitigate identified risks, including data classification, access controls, data loss prevention, and data breach response plans.Led diverse projects totaling approximately $40M, focusing on data governance, lineage, quality, and risk reporting to drive enhanced outcomes.Performed UAT defect analysis and documented the steps to reproduce defects, assigning them to the appropriate Dev resource for resolution. Led defect triage calls for the agile teams for status updates and resolution of issues.Provided guidance to business stakeholders/internal customers on business process monitoring and measurement using key metrics (KPIs) and BI dashboards such as Tableau, Power BI, and SAS. Show less

Collected test metrics weekly from the Quality Centre defects database that reflected the status of the test execution and the state of the defects and presented a weekly status report to the Project Manager.Created business process models using BPMN on Current State and Future State for functional and technological process improvements.Created test plans, test cases, and test data for integration and system testing all the components and applications involved and executed… Show more Collected test metrics weekly from the Quality Centre defects database that reflected the status of the test execution and the state of the defects and presented a weekly status report to the Project Manager.Created business process models using BPMN on Current State and Future State for functional and technological process improvements.Created test plans, test cases, and test data for integration and system testing all the components and applications involved and executed them.Designed and developed Use Cases using UML and Business Process Modelling. Applied Unified Modelling Language (UML) to design Use Case Diagrams, Activity Diagrams, and Sequence Diagrams in MS Visio.Executed SQL queries, to retrieve data from different databases, for data validation & analysis, researching underlying data errors, and generating reports.Extensively involved in Business Requirements Document (BRD), Functional Requirement Documents (FRD), systems requirements specification (SRS), high-level design documents (HLDD), and traceability mapping/matrix with the assistance from the business group and the IT team members.Facilitated User Acceptance Testing (UAT) with end users by providing necessary training and setting up testing data, test scenarios, and testing environment.Involved in Business Intelligence (BI) and Data Visualization, analyzed the Transaction Processing Data (TPS) using advanced MS Excel/Macros.Involved profoundly in the GAP Analysis of Employer Rosters and analyzed "AS IS" and "TO BE" scenarios, designed and documented new process flows, business processes.Participated in UAT and worked with HP Quality Centre for bug/defect tracking.Utilized Waterfall software development life cycle methodology throughout the project and acted as a liaison between the project manager, business users, & IT team.Worked with SQL queries, responsible for data mapping and data cleansing.Wrote SQL queries to create database views and reports to track customer data. Show less