Anthony Will Email & Phone Number

New York, Ny, Us

FALCON Project Overview• Hired on to assist with the bank's goal of having a centralized platform to standardize the acquisition and enrichment of data needed across Finance.• Work on data acquisition and architecture for AmEx's "Fast Forward" goals involved with the increased regulatory scrutiny - via AUM category thresholds being met.Role Specifics• Role is a combination of Product Owner, Architect, SQL Developer, and Analyst.• My focus has been on US cardmember data of ensuring all the data is landed correctly and all transformations go as intended from our provisioning tables to downstream database management systems.• Work with Engineers to understand existing logic + processes which involves reviewing existing SQL logic and any applicable lookup table(s) leveraged.• Focus on landing, transformation, and provisioning designs to ensure SOR data meets downstream requirements.• Analyze downstream use cases to ensure all necessary elements needed are acquired and all applicable transformations are performed.• Work within an Agile framework of creating & accepting user stories for our Engineers to implement each sprint.• Source to Target (S2T) lineage• Perform data validation between FALCON data versus legacy data warehouses to ensure logic is working. • Work with Engineers to arrive at solutions for enhancements, defects, and change requests.• Write, challenge, and understand business requirements and partner with tech teams to drive an expected outcome.Software Utilized: Oracle SQL Developer, MySQL, Rally, Cornerstone, Hive Terminal

Santa Clara, Ca, Us

• Initially hired in 2021 to help ramp up the bank’s increasing Regulatory requirements due to certain assets under management (AUM) thresholds being reached• Focus was on 14Q Schedule H.1 and H.2 via regular meetings with SMEs/LOBs to help in the facilitation of data collection/production needed for Reg Reporting teams. Involved utilizing data from various sources with Oracle SQL Developer and other loan & client financial systems.• Once data was ingested into Axiom, the focus shifted to remediating Federal Reserve failed edit checks that arose via leveraging SQL and working with various LOBs/SMEs. • From 2022 to the present, I shifted into a Business Intelligence role using Microsoft SSMS, Oracle SQL Developer, and Tableau to automate datasets and satisfy any dashboards needed and any ad-hoc data requests for Leadership.• Example SQL scripts + Tableau reports I created helped the bank automate UAT/SIT testing, identify characteristics associated with our loans + deposits population, and provided Leadership with aggregations from our global population to help identify our cross-jurisdiction exposure (as we were approaching another regulatory threshold).

Phoenix, Az, Us

• Liaison between SME’s, Data Modelers, and BI via gathering and documenting business/technical needs into a Functional Design Document• Aid in ensuring all legacy Agency, State, and Federal reports are mapped to the Data Warehouse• Identify core data elements needed for BI to ensure their schema/table/fields are correctly mapped to aid in converting Tableau reports to Power BI.• Regularly meet with Data Modelers to help identify missing data elements and identify business processes needed in the Data Warehouse• Write SQL queries, create views, create & publish Power BI visualizations• Requires knowledge of Child Welfare, CHILDS legacy system, and the Cloud-based Azure CRM Guardian system currently in Development• Utilize Microsoft Azure DevOps, SQL, SSMS, Microsoft Dynamics 365, Power BI, Microsoft Teams, SharePoint, Tableau, and ER Studios/IDERA data model• Arizona DPS Level One Fingerprint Clearance Card: Expiration Date 4/6/2026

San Francisco, California, Us

• Verify documentation of data elements and controls are current within applications to ensure enterprise data governance policy and regulatory body compliance • Interviewing application SME’s, document current needs• Data mapping, research, analysis, development of solutions and data process improvements• Verify and review any upstream/downstream applications, that each system feeds, to ensure data quality controls are in place• Utilized Collibra and AppOne repositories• Data Dictionary focus was in satisfying California Consumer Privacy Act (CCPA) requirements• Identifying core data elements and ensuring data quality controls are in place via documentation of a Data Dictionary and Data Quality Control Assessment• Given Lead designation, after just five months, to provide mentorship to new hire Analysts• Presented a Deep Dive on (CCPA) Data Privacy to 200 + Wells Fargo attendees

Gilbert, Arizona, Us

• Manipulated and analyzed large data sets in order to locate discrepancies• Located discrepancies and reconciled any errors between our clients and their vendors• Data collection and research • Utilized SQL queries to analyze data• Utilized MySQL Workbench & Excel

Torrance, Ca, Us

• Liaison between business and technical stakeholders, internal teams and external clients• Efficiently aided in the delivery of monitoring systems from install to activation• Utilized strong communication skills and a technical background• Ownership of all system monitoring related items• Diagnosed production/communication issues remote• Worked with Business Intelligence to help Operations become more efficient • Automation in Excel/SSMS database linked reports/dashboard• Utilized Microsoft SQL Server Management Studio (SSMS), MS Access, and MS Excel ODBC• Analyzed production data via system output data (string/micro inverters)• Utilized Enlighten, SolarOS, and Itron solar monitoring software• Trained Customer Service Department in solar monitoring software