Salesforce Certified Heroku Architecture Designer

Data Scientist with Python

Data Analyst with Python Track

Quantitative Analyst with R

Salesforce Certified Administrator

SnowPro Core Certification

Microsoft Certified: Data Analyst Associate

Astronomer Certification for Apache Airflow Fundamentals

Astronomer Certification DAG Authoring for Apache Airflow

Primary responsibilities were directly supporting 12 "High-touch" Equity sales-traders in NYC and 4 in London in the middle office capacity. I personally handled all post-execution issues for 100+ US institutional clients and communication of any risk to the desk. Operational flow ranged from $10M-$1B per day in equity volume.

Trade Support Analyst

-Settlements of failing trades and client service for a high volume of equity trades both domestic and international.
-Collaborative issue resolution on a systemic scale
-Analytics on the above including: daily summary, monthly summaries, and data management/cleaning for other analytics teams.
-Introduction of vba macros and shortcuts to expedite manual processes and reduce unnecessary expenditure on man hours.

Client Service Analyst

▪	Development and launch of 50-100+ user customer facing reporting and analytics portal. 
	▪	Financial Modeling and Forecasting as due diligence for over $500M in Business Prospects
	▪	Management and Administration of Azure Active Directory, Salesforce, PowerBI Embedded, Heroku, PostgreSQL, Airflow, EC2 and more. 
	▪	Development of first ever Postgres ODBC DirectQuery connector for PowerBI. 
	▪	Engineering through agile methodology, actively involved in sprint grooming, planning, and scoring.
	▪	Development of ETL / Integration with Quickbooks Online ERP. 
	▪	Scope, Dev, Production Launch, and Production Support of Analytics Platform for Series A Startup valued at $5M (https://www.crunchbase.com/organization/finexio)

Data Analyst

Under supervision of CTO, design and implement scaling strategy for management of B2B payments data during 10X growth period following $5M A round. 
▪ Lead migration onto Salesforce CRM and architect primary integration to Heroku Postgres based databases. 
▪ Architect and implement data engineering from various operational systems to cloud based data warehouse orchestrated and modeled with dbt. 
▪ Manage team of internal and external resource to meet business and executive directed analytics deliverables.

Data Architect

Business and Data Analyst

	▪	BI / KPI Dashboards for 100 user, $300K/day call center
	▪	Salesforce Custom reporting through SOQL / Wave Analytics custom JSON reporting structures and dashboard with fully interactive elements
	▪	Salesforce Embedded PowerBI reports using Azure Active Directory services and PowerBI Desktop
	▪	Engineer Chatfuel Chat AI integration for location based service responses with REST callouts through Integromat. 
	▪	Integration with multiple relational and non-relational databases (SQL, Postgres, MongoDB, Cache)
	▪	Adhoc Analysis reports in Excel and R to isolate process improvements, provide timeline analysis, customer segmentation, call center efficiency, and more. 

Salesforce Admin
 
▪ Serve as system administrator for Salesforce.com environment with 150+ users
▪ Working Experience writing Force.com Apex classes, triggers, components, VisualForce pages, Salesforce Object Query Language (SOQL) and Salesforce Object Search Language (SOSL) queries.
 ▪ Hands on 

Business, Process, and Data Analyst + Salesforce Admin

Data analytics, data stack infrastructure, and data integration. 

Current stack:
* File, REST, GraphQL, JSON data source pipelines
* Fivetran, Airbyte, and other ETL / ELT tools
* S3 Data Lake, Microsoft SQL Server, and Snowflake Data Warehouse
* Snowflake Document AI
* dbt (data build tool) & dbtCloud
* Github Actions, Airflow / Astronomer, and other orchestration / DataOps tools
* Monte Carlo Data (https://www.montecarlodata.com/)
* Atlan Data Catalog (https://atlan.com/)
* Tableau, Sigma Computing, Hex Tech Notebooks)

Data Sources: 
* Financial Sources (Bloomberg BLPAPI, Moody's Analytics, FRED, Netsuite, etc.)
* Real Estate Sources (MLS systems, HouseCanary, Cherre, Zillow, & more)
* Operations (Low Code tools like Retool / Unqork, & other internal systems)
* Databases (Amazon RDS, MSSQL, MySQL, & more)

Scott Goley

Data & Analytics Professional. Financial & Fintech background.