How and why I built A reporting tool
Using Excel VBA and SQL to make a multi-user application by leveraging an Outlook mailbox to provide security and a way of sharing and reporting information
Troy Samuels-Dowden
ABOUT ME
15+ Years experienced Excel Spreadsheets and VBA
15+ Years experienced Excel Spreadsheets and VBA
Hi, my hobbies and my profession as a data analyst keeps me well intuned with Excel. Ranging from worksheet formulas & VBA functions to integrating with other applications, online servers, and scrapping websites for data. I've even used Excel to mock up web/mobile apps. So whether your issue is big or small. I'm more than happy to lend a quick helping hand.
Eastern Time (US & Canada) (-04:00)
Joined July 2021
EXPERTISE
2 years experience
1 year experience
SOCIAL PRESENCE
EMPLOYMENTS
Senior Data Analyst
DHS
2018-01-01-Present
Data analytics with Excel, SQL, Python
Data analytics with Excel, SQL, Python
Python
SQL
Excel
View more
Python
SQL
Excel
Excel VBA
View more
IT Specialist
GCS Fibers
2015-12-01-Present
Leading technical initiative for GCS Fibers. A start-up based out of Northern Virginia and close to D.C. . Duties range from setting up A...
Leading technical initiative for GCS Fibers. A start-up based out of Northern Virginia and close to D.C. . Duties range from setting up AWS cloud services to building blockchain-based solutions.
Excel
Excel VBA
AWS (Amazon Web Services)
View more
Excel
Excel VBA
AWS (Amazon Web Services)
View more
Excel VBA Developer
Various
2007-05-01-2015-12-01
As a consultant/employee worked at locations like Capital One Bank, Kepha, Triple Tech, USMC building Excel VBA-based solutions.
As a consultant/employee worked at locations like Capital One Bank, Kepha, Triple Tech, USMC building Excel VBA-based solutions.
Excel
Excel VBA
Excel
Excel VBA
PROJECTS
Capital One Bank Underwriter Standardization Tool
Capital One Bank
2014
Built a dynamic flow, Excel-based tool that links to an internal database and helps 100+ users to work simultaneously on 10,000+ outlier ...
Built a dynamic flow, Excel-based tool that links to an internal database and helps 100+ users to work simultaneously on 10,000+ outlier credit card/credit line increase applications each month. The project was finished ahead of time and allowed for the addition of nice-to-have features.
Excel
Excel VBA
View more
Excel
Excel VBA
View more
Mapping Tool
DHS
2020
Build an Excel-based application that allows users to do in 5 seconds what once took 15 mins. Using a mobile app-styled intuitive interfa...
Build an Excel-based application that allows users to do in 5 seconds what once took 15 mins. Using a mobile app-styled intuitive interface users can drill through 5, 500+ page documents and end up at the answer they need in seconds. The project required gaining a thorough understanding of ISO/NIST standards and was accomplished on time.
Excel
Excel VBA
View more
Excel
Excel VBA
View more