Self Venture Resume Charlotte, NC - Hire IT People

TECHNICAL SKILLS

Advanced MS Access, Excel, SQL Server and VBA; SQLite; Oracle MySQL; Python 2.7; Tableau; SSRS;
SSIS; Power BI; Matplotlib; Salesforce; Google Analytics, SAP Tables. Rudimentary ML techniques. Love working wif data to solve problems.

PROFESSIONAL EXPERIENCE

Confidential - Charlotte, NC

Self Venture

Responsibilities:

Developed novel metrics to gain insights into putting performance and sold reports to stakeholders wifin the PGA world.
Gained sales of >$10,000 including a client who is a PGA player
Utilized Python and MySQL to collect/analyze/develop the product
Applied geometry, machine learning, and domain-specific noledge to turn raw data into performance reports.
Currently collaborating wif PGA to incorporate findings into their product

Confidential

Product Analyst

Responsibilities:

Disseminated analytics across various departments on the product via Tableau, SSRS, Power BI
Provided product design input pre-launch to ensure data reporting needs would be met.
Developed custom event and sales funnel tracking via Google analytics to improve conversion rates
Wrote SQL stored procedures to develop a churn model as well as other KPI’s for PMs.
Created a data warehouse and automated dashboards through SSRS and Tableau

Confidential - Charlotte, NC

Data Quality Specialist

Responsibilities:

Developed a cost management system via SQL, Access, and Visual Basic whereby costs for the company’s +20,000 US/CA products could automatically be updated to reflect changes in supply chain cost; cost change of ~20mm quarterly; increased accuracy/efficiency/flexibility of cost system.
Consulted wif managers in Los Angeles and subsequently developed several automated front-end programs via MS Access/SQL for use by union employees in their office; saving an estimated +$95,000 annually.
Utilized internal SQL Server data and implemented algorithms (Dijkstra’s algorithm) via VBA to proactively update the company’s computer system routing information; increasing data quality and saving manual work.

Confidential - Atlanta, GA

Portfolio Analyst

Responsibilities:

Designed and managed the company’s SQL database and MS Access front-end which stored the majority of the company’s information and was used by all of the employees of the company; emphasized database normalization and ease-of-use for users.
Created an automated accounting system using SQL and SQL Stored Procedures to keep track of all accounts receivable and accounts payable relating to equipment sales.