Stuart Segan

Business Data Analyst

Long Beach, CA 90813

acxxz8@r.postjobfree.com - 562-***-****

Authorized to work in the US for any employer

WORK EXPERIENCE

Business Data Analyst

Oracle Medical Collections - Los Angeles, CA - 2013-07 - 2015-02

• Provided detailed structured and ad-hoc analysis and reporting using VBA, MS Excel, SQL Server, MS Access, SSRS, and other business related analysis and reporting tools.

• Audited Accounts Receivable portfolios leading to profitable acquisition of over $100 Million in collectible Medical Services

• Developed and supported T-SQL stored procedures, functions, views, and triggers with SQL Server 2008.

• Created Integration Service Packages (SSIS) to extract, load and transform data.

• Developed and supported the SSRS reports for daily business activities. Data Analyst (Consultant)

FindItParts.com - Los Angeles, CA - 2013-03 - 2013-06 Provided detailed ad-hoc analysis using MS Excel, MySQL, VBA,, SQL Server, MS Access and Nextag analytics leading directly to a significantly improved advertising campaign. Marketing Data Analyst

Coin Dealer Newsletter - Torrance, CA - 2009 - 2011

• Provided detailed ad-hoc analysis using MS Excel, MySQL, VBA,, SQL Server, MS Access leading directly to a significantly improved advertising marketing campaign.

• Research, collect, analyze and determination of pricing data points.

• Provide expertise in the overall design, architecture, table structure, SQL programming and UI of a 50 gigabyte database of rare coin prices.

• Wrote editorial and market analysis articles on the rare coin market. Business Development

SkinWest - San Dimas, CA - 2006 - 2008

Companywide System Administration; ensured 99.99% uptime for SkinWest LAMP Server; Implemented Automated Processes, optimized shipping, handling and return items, Logistics.

• Slashed $60,000/month Google adWords advertising campaign to $20,000/month; preserved at least 70% of new customer acquisition measured by gross sales, number of new customers and ROAS. IT Manager

Printer Ribbons Plus - Los Angeles, CA - 2006 - 2007 Maintained Windows 2003 Server domain, M-Daemon email server, and 10 workstations over an Ethernet LAN/ WAN.

• Provided desktop support and troubleshooting for software products like MS Office, QuickBooks, Goldmine ERP and a variety of printers/fax machine/copiers. Consultant

First Financial Merchant Group, LLC - Los Angeles, CA - 2006 - 2006 to 2006

• Implemented SunDialer Predictive software w/ automated dialogic board hardware on 12 workstations.

• Operated and maintained SunDialer Server engine: performed SQL queries, created dialer segments, and ad-hoc Visual Basic for Applications programming when required. EDUCATION

Bachelors in Physics

University of California - Berkeley, CA

ADDITIONAL INFORMATION

Skills

• C, MySQL, SQL Server, Data Analysis, SAS, BI, UNIX, MAC, Modeling, MS Office, VB, Python, Fortran Published author including articles in the Lawrence Berkeley Laboratory Journals Archive for work in Fortran, C Programming and the simulation of fluid flow in geologic fractal networks.