Sasha Pate

Ph: 214-***-****

Email: ad2zyd@r.postjobfree.com

PROFESSIONAL SUMMARY

USAFA Veteran A result driven professional with over 16 years in the Financial Telecom industry and Automotive Sector i.e. Sr. Financial Analyst an Airline industry with key emphasis in Financial\Business Data responding Amicably and properly to changing circumstances.

TECHNICAL EXPERIENCE

Programming Languages: Python, SaaS, Java, QuickSight, C++, SQL, SAS, Azure, Snowflake, Rocket, ERWIN, SALESFORCE, AWS CLOUD, Java Eng., BITBUCKET,

Software/Databases: Jira, AWS, HIVE, Redshift, Kubernetes, Confluence, SQL, Jenkins, FHA, Tableau, SOX, Snowflake, CIA, PowerBi, MSSQL, Salesforce, Collibra, Fatca, KYC, Claims, Azure, Agreements, Aml, SME, SCRUMMASTER, Data, Implentation, Healthcare, ETL, VLOOKUP, Automotive, Telecom, Airline industry, Ssrs, Mapping, Military reserve, PMP, ALTERYX, ERP, ETL, Oracle, GOOGLEDOCS, GOOGLESHEETS, Supervisory Control and Data Acquisition (SCADA)

Others: Responsible for defining and implementing enterprise data management strategies, vision, and management processes to effectively govern enterprise data including the management of enterprise data governance, operating model, data policies and standards as well as the implementation of clearly defined data management definitions for use across the organization

PROFESSIONAL EXPERIENCE

WEBSTER BANK NY – Remote Jan 2023 – Dec 2023

Sr. Business Analyst (Compliance)

Developed a Process for capturing end to end Data Governance lineage using Snowflake Queries, and SQL Queries to fetch the data from the Warehouse

Assist with leading the Risk, Control and Self-Assessment (RCSA) including coordinating and executing requirements per Bankwide standards

Act as SCRUM Master focusing on providing guidance on agile mindset and practices, self-organization, collaboration and continuous improvement

Ensure cross-team coordination with the other SCRUM Masters and manage dependencies between teams and external contributors.

Lead business governance forum(s), ensuring a regular review of the business’s risks and controls

Monitor significant identified weaknesses and gaps in processes (as evidenced by metrics, events, issues, findings, etc.) and assist with remediation

Produce risk reporting and metrics to provide timely management information to business management on issues, control deterioration and remediation status; monitor metrics across the business

Provide oversight for new activities and significant new business initiatives impacting the business and ensure connectivity with firmwide stakeholders

Establish trusted partnerships with peers, functional leads, and executive level stakeholders

Update and maintain documentation for team processes and best practices

Design and develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)

Will write complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx.

Develop and continuously improve Supplier Quality for existing, line extension and new products.

Act as the Supplier Quality representative to New Product Development Teams.

Facilitate supplier selection for project teams or when a supplier change is needed. Participates in Design for Manufacturing and Assembly (DFMA).

Perform Supplier Quality Audits

Triggered BIGID sensitive levels as High for PI Data and PII Data for PDO metrics

Used Workday as system of choice for Cloud based reporting and engineering

Oracles ERP to manage resources, people, machine learning, Transactions, Automation, reporting and E-Business Suite

Created Internal URL websites while using KUBERNETES

Proxies, VPN, DNS, web and mail servers edited and maintained Licensing

TD BANK (Toronto Dominion) Apr 2022 – Jan 2023

Business/ Financial Analyst

Run Alteryx Workflow to execute data TRANSFORM LOAD, Run SQL Query to validate the Alteryx workflow, Verify the Data on the Tableau Dashboard verifying Accuracy from SQL Query.

Conduct analysis right SQL queries data reconciliation data mapping in data definition

Design and develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)

Finance Risk identifies, monitors, evaluates and oversees the firm’s liquidity risk to ensure that the firm is appropriately positioned to meet its liquidity and funding needs

Will write complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx

Create a Dallas analysis report identifying issues within the commercial department

Coordinate with stakeholders to improve and understand data requirements giving feedback for clarification

Paid Claims, and curtailed AGREEMENTS per invoice Insurance Claims, Variances

Commercial lending department managed portfolio through complete and current knowledge of clients financial condition

Responsible for ensuring all advances and loans comply with loan policy and approved structure in commercial lending sector

Reviews model results and assists in the identification of unexpected results.

Frequent Azure to Manage and develop applications through global data centers on the cloud.

Develops and maintains strong business relationships with business line management.

T-MOBILE April 2022 – Jan 2023

Sr. Data Analyst Procurement (Night Role)

Research and develop compelling counter-offers to obtain strategic value for T-Mobile.

Work with Business Planning to identify costs, plan, and schedule performance of procurement activities in SAP in accordance with business processes of the organization

Hands-on experiences with migrating changes from development to test to production environment(s) using CI technologies like Salesforce DX, Jenkins, GIT, Bitbucket, JIRA and ANT

Partner with internal distribution partners to coordinate shipments and escalations

Utitlized Google Sheets and Google Docs for link new data to the Google Drive board.

Communicated in SLACK when needed new additions added to the google docs.

Responsible for Procurement of Displays for T-Mobile launches and resets logistics, forecasting and pricing, aging

Helps to Drive T-Mobile direction strategically within certain categories of spend cost Prohibitive and BIDs for sites eligible and Available.

Moved Data Source from Power Bi to V-lookup the data also with Downloading data from Tableau Site for T-Mobile

Perform control testing through observation or collection and analysis of evidence of control performance against defined policies, guidelines, or laws

Assess control language and business line procedures to ensure alignment

Lead process inquiries, walkthroughs and procedure reviews to support the development of QA test work papers

Collaborate with Control Owners, Risk Analysts and subject matter experts to define evidence, populations, and discuss results of testing

Validate populations of desired activity for accuracy and completeness

Select test samples based on internal program methodology and document rationale for adequate coverage

NMAC NISSAN AUTOMOTIVE - Frisco, TX Oct 2019 – Nov 2021

Business Analyst SR

(Pandemic Layoff)

Analyzed large and complex data sets using SAS Enterprise to prepare monthly sales and forecasting and reporting.

BEV experience with mathematics, schemes and vehicle related business Battery Electric Vehicles (LEAF)

Ensure cross-team coordination with the other SCRUM Masters and manage dependencies between teams and external contributors.

Collaborate with internal software and powertrain engineering teams to optimize battery design to meet overall electric vehicle performance targets

Used Redshift and AWS to analyze structured and semi-structured data across data warehouses, operational database and data Lakes.

Moved Data Source Mapping from SAS to SQL to SNOWFLAKE data in Tableau.

Learns and utilizes all company and manufacture provided software including but not limited to the Client Relationship Management (CRM) system, vehicle appraisal system, and service drive opportunities.

Extracting Data from Tableau with Attributes to maintain Dash and rebate trend Dashboards.

Automated SAS codes for daily SAS Runs.

Provides support for production execution and delivery of Business Intelligence Solutions Maintain technical dev documents in Jira.

Detected and presented Tableau Dashboards to monitor income verification and Credit Volume Mix.

Trained employees in SAS and Tableau Prep implementing traits regulatory daily standards.

Ability to forecast trends dealing with Tiers 1-9.

Recommends operational and process improvements based on efficiencies and available technologies Produces documentation, including project plans, analytical reports, decision backup, information research reports, budget analysis, training plans, business justifications, and graphics Prepares standard and ad hoc financial reports and analysis for senior management.

Mapped data from Data warehouse columns to Snowflake ensuring accuracy with Tableau data source switch.

FISERV/ ASSURANT - Frisco, TX Jan 2019 – Aug 2019

Accounting SR. MGR

Used PeopleSoft for Chargeback requirements for Visa, Mastercard, and Discovery Credit and Debit Cards.

For Claims and Agreements ensured there was no Variance withing that said Record.

Used Redshift and AWS to analyze structured and semi-structured data across data warehouses, operational database and data Lakes.

Hands-on experiences with migrating changes from development to test to production environment(s) using CI technologies like Salesforce DX, Jenkins, GIT, Bitbucket, JIRA and ANT

USED AIM System to run jobs for File Extracts, Run to Stage, Run Database Reports.

Understand conceptual, logical, and physical data models Develop ETL for the BI solution using SSIS Develop reports using SSRS Develop DB applications using Microsoft Azure platform.

Perform all functions of a Finance and Insurance (F&I) manager within automobile dealerships.

Followed the Chargeback matrix withing the process of executing a proper chargeback.

Manually charged back Customers on Visa network when matrix adhered to the fulfillment.

REG Z and REG E within CB regulations and Rules.

Used CyberSource and FINCEN and SharePoint to communicated with Fraud team Globally.

Executed and Supported Management procedures including the use of key tools DMS/Service Point Visa/ Mastercard Connect.

LOUIS VUITTON - Colleyville, TX Jun 2017 – Dec 2018

Fraud RISK Management

Risk Management, Account Takeover, and Identity Theft.

Develop and continuously improve Supplier Quality for existing, line extension and new products

Facilitate operational risk event management framework and data collection, including the detailed reviews of significant events to ensure appropriate remediation plans are implemented, and identification of trends to identify significant or emerging risks.

Conduct quarterly trigger assessments for divisions to ensure the risk and control self -assessment (RCSA) and tail scenarios remain accurately assessed and current.

Facilitate challenge of 1st line RCSA and Control Assessment ratings to ensure appropriate measurement approach and rationale has been employed.

Conduct scenario analysis by working with stakeholders to develop and quantify scenarios measuring tail risks used for stress testing and capital calculations.

Contribute to the advancement of operational risk methods and practices and the operational risk management framework.

Create Management reporting using Alteryx, Tableau, or other cutting-edge visual interface-based tools.

Develop analytical reports and presentations for senior management, executive committees, and regulatory exams

FANNIE MAE - Addison, TX May 2016 – May 2017

Multifamily Senior Credit Risk Analyst

Assist team in aggregating data and building reporting to monitor Multifamily credit quality, risk exposures and key trends.

Assess the credit and financial strength of counterparts by performing fundamental credit analysis of both quantitative and qualitative credit factors

Collaborate with the business teams, including Global Banking & Markets, to meet client credit requests while ensuring the firm’s risk return needs are balanced

Proactively monitor and assess counterparts and industry subsectors in your portfolio and report relevant information and its impact to senior management in a timely manner

Complete annual reviews to determine Internal Credit Ratings, Regulatory Risk Ratings and Watch List Status for your industry portfolio

Document and present findings and/or conclusions of analysis to key stakeholders and senior management in a thoughtful and persuasive manner.

Curtail the amount if the invoice was not to Fannie Mae guideline Matrix.

Perform data analysis and risk reviews on various areas of the Multifamily business.

Partner with Multifamily and other stakeholders to carry out business strategies that will drive success and ensure safety and soundness in the face of shifting market conditions and regulations.

In this role, you will collect, process, and allocate monies for accounts payable, accounts receivable, and reinvestment.

Contribute production data and intelligence from clients to higher level staff and management preparing daily projections for cash needs.

Assist in testing and implementing systems and/or process changes to support increased efficiencies or conformance with regulations.

MR. COOPER (NATIONSTAR) Mar 2015 – Jan 2016

SR. Financial Consultant Compliance

Accountable for partnering on the design, value quantification, and implementation of these projects.

Operational oversight for multiple ongoing development projects related to mortgage servicing priorities working in close partnership with our IT.

A direct report to a SVP and responsible for providing concise executive-level updates and proposals.

Assisting with vetting external vendors on new products or services that help improve our web presence.

Investors, spanning traditional and alternative markets offering products and services

Advisors, understanding our clients’ priorities and poised to help provide investment advice and strategies that make sense for their portfolios

Thought Leaders, providing timely insights across macro and secular themes to help inform our clients’ investment decisions

Innovators, using our suite of digital solutions to help our clients address complex challenges and meet their financial goals

J. P MORGAN CHASE - Evans, GA May 2007 – Dec 2014

Internal Auditor

*MILITARY BASE

Plan, execute and participate in audit activities, including risk assessments, audit planning, audit testing, control evaluation, report drafting and follow-up and verification of issue closure (Toastmaster).

Expertise in Healthcare To identify the scope of the testing required for a particular release based on the requirements document, medical billing codes

Proficiency in SQL or other querying language

Experience using data management / data modeling tools (Alteryx, Tableau)

Working knowledge of more than one programming language (E.g. R, VBA, Python)

Hands-on experience with data modelling and BI tools (Tableau, Alteryx, MS-BI Stack, Qlikview, Elastic Search, PURE modelling etc)

Advanced expertise with Business Intelligence Database Infrastructure (SQL Server, MongoDB, DB2, Data Lake)

Hands-on with advanced Microsoft Excel functionalities

Exhibit ability to multi-task and prioritize to deliver accurate and timely work in a time pressured environment

EDUCATION

Bachelor of Science in Criminal Justice

University of North Texas - Denton, TX Aug 2011

AFB Shepards - Wichita Falls, TX

General Studies

United States Air Force Academy - Colorado Springs, CO Jun 2004

Contact this candidate