Clearsum

• Main Tools Used: Microsoft Azure (Storage, Data Factory), GCP (Cloud Functions, Dataflow, BigQuery, Dataform), Python, Javascript , Microsoft SQL Server (SSMS), R, Neo4J

Data Engineer

Iris Pricing Solutions 

• Main Tools Used: R, Python, Snowflake (SQL), Tableau, RShiny, Excel (VBA)

Analytics Consultant

Eccomelt LLC

• Main Tools Used- Excel, R, Python and Tableau
• Data wrangling, transformation and extraction preformed with R, Python and Selenium
• Data visualizations with R, Excel and Tableau
• Construction of a Business side Application with Shiny
• Communicate results to stakeholders and adjusting project goals accordingly
• Involved with proposal and report writing
• Created and managed agile-styled task board (Trello) and workflow

Data Scientist

Eurofase Lighting

•  Main Tools Used. R, Python, SQL and Google Data Studio (Looker Studio)

EML Capital Group

• Main Tools Used: Excel, VBA, SQL (via ADODB)
• Involved in constructing end user tools for evaluating risk as part of underwriting

VBA Data Engineer

Blynk Consulting

• Main Tools Used- Excel, SQL (Microsoft Server & SQLite), Python and Google Data Studio (Looker Studio)
•Created a Data pipeline connecting Microsoft Server to Google Sheets with automated SQL and Python Blocks (ran via cloud)
• Created a dashboard with Google Data Studio to visualize updated data on an ongoing basis.

Data Engineering Consultant

• Main Tools Used- Excel, R, SQL
• Serve as the "go to" for data related tasks.
• Query CRM database (Admire) to create necessary reports
• Create financial reports, forecasts and dashboards with Excel.
• Wrangle,Audit and Validate existing/incoming data

Highlights Include:

• Assisting in Spearheading a $1 Million Fundraising Campaign by handling all incoming high volume data, financial reporting and back end support
• Managing a team of 6 and coordinating/executing logistics during the COVID-19 Pandemic

Operations Analyst

Futuric Planning Inc.

• Main Tools Used: Excel, R, Microsoft Access.
•Query and update Client Database (SQL/Microsoft Access/ACT!)
•Created a Custom Excel Spreadsheets for company Sales Pipeline Analysis
•Lead prospecting process for business.
•Created an Excel/Access based CRM system for prospecting (Conditional Formatting, Dropdown Lists, Pivot Tables, Data Mapping [VLOOKUPs], SQL Queries, Access Forms etc.)
•Create Dashboards for tracking/summarizing various areas in the company (Microsoft Office, Excel/VBA)
•Conduct intake analysis to ensure client applications are up to date
•Audit Data to assure consistency across company records

Business Analyst

Jewish Russian Community Centre of Ontario

• Main Tools Used: Excel, R, SPSS
•Collect and Analyze Survey data for monthly/annual evaluations
•Audit, wrangle and analyze data from company CRM Software (Salesforce) using Excel, R and SPSS

Data and Operations Analyst

I work with everything related to data and build end-to-end solutions. Check out my Github and website!

Taplio

Benjamin Smith's Linkedin Analytics

Benjamin Smith

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Benjamin Smith's Linkedin Analytics

Benjamin Smith

Want to drive more opportunities from LinkedIn?

Benjamin Smith's Linkedin Analytics