Technical Resume080717.docx

Andrew Resume Technical

Andrew Schell Twitter [#datatalking](https://twitter.com/hashtag/datatalking) - Email [info@yourdatatalking.com](mailto:info@yourdatatalking.com)

**Salesforce Admin – Google Analytics – Data Marketing Analyst**

Seeking an analyst or technical big data position at a growing company. I work best with action based teams to accomplish goals vs doing theoretical research. In finance I developed a process that tells me with 84% confidence which customers are likely to churn and I am well versed in business development as well as the Analytics supporting Sales. Current pro bono projects are administration of a Salesforce Org for a nonprofit and my artificial intelligence prototype that helps disabled children

**Subject Matter Expert:**

**Business Intelligence**** Analysis**

**Dashboard Prototypes**

**Predictive Analytics**

**Area of proficiency**

Python Data Analysis

Spark Analysis & Data Cleansing        Hacking and Extracting Data

Salesforce Administration

Google Web Analytics

Data Hacking and Analysis

Database Migration & Planning

**Data Visualizer – Tech Integrator – Dog Whisperer**

**Data Analyst & Developer –** Your Data Talking – October 2014 – Present.

• Consultatively trained Salesforce and Zoho CRM users on best practices to drive growth.

• Merged existing or create new databases API's, customized sales process software.

• Organization and documentation of python analytics backend system

**Client List:**

**Salesforce Admin & Developer** – Presbyterian Senior Services - De 2015 to March 2017

• in charge of full Salesforce Org design, used biweekly software releases to roll out software.

• Full cycle developer in charge of process research and 24/7 on-call security admin.

**Data Analyst** - SPROXIL - September 2015 to June 2016 – Contract.

• Google Analytics subject matter expert, visualize customer traffic, monetize opportunities.

• Analysis of 160 gigabyte AWS data lake, startup pharma market, produce ad hoc reports.

**Sabbatical** ,June 2014 – September 2014

• Analyzed business intelligence software and CRM for predictive analytics platform.

**Financial Planner** ,Country Financial

October 2007 – May 2014

• Provided hoc data regression and CRM pipeline analysis for Monte Carlo Risk assessments

• Grew sales from $340k to $840k, annual analysis of $2MM in 482 clients' accounts.

• Analyzed B2B and B2C portfolios for risk management and market exposure.

• Used Salesforce to improve user experience, resulted in +312% increase in sales.

Education – Certifications

-


  1. Bachelor of Science, Data Analytics, Bellevue College – in progress.

[SQL Database Certificate, Stanford Mooc – In Progress](https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/about#https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/about)

Finance - Series 6 and 63 FINRA License _(Financial Services Analysis)_

-
  1. American Design Association, Certified Computer Designer
  2. Associates in Computer Aided Design, Itt Technical. Dean's List - 3.64 GPA
- Menu Of Available Applications
-
- Salesforce: Admin & Development, Service Cloud, Sales Cloud, Visual Force
-
- Google Analytics: Setup or Weekly Monitoring (requires discovery)
-
- Excel:  PowerBI, PowerQuery, PowerView, Low level analysis, dashboards, cleaning
-
- Data: Python, Jupyter Notebooks, IBM Watson, SQL, PostgreSQL, PySpark, DataBricks, Docker,   Github, Atlassian, Mercurial
-
- Python: Flask, Django, Anaconda, Pandas, Matlab, Scikit, Nlkt, NLP
-
- GUI: Bowtie, DS3, Pygui, xMind, nserves
-
- HR: TopGrading, FiringFreeze, Annual Picknic, DailyStat3, Weekly Update
-
- Dashboards Specialty: Finance, Sales, Operations, and Management
-
- CRM: Msft Dynamics, Salesforce, Insightly, ZohoCRM, Hubspot, Goldmine, Ms Access
-
- Client Review: Gives good answers but maybe not the best spoken person, hired for persistence and ability to translate technical specs, not for personality, so he can be hot to handle at times. His best fit will be people or companies in growth mode and looking to scale process, or he can create a process.
  1.