Pull together data from disparate sources, including accounting, email platform, CRM, ERM, Google Analytics and other api based providers to produce unique and timely business intelligence to partners, practice managers and business development team via scripted and ad-hoc reports, data visualizations and dashboards.Applications and tasks:R for wrangling, cleaning, modeling, evaluating, interpreting:-Accounting data for practice and client analysis-Foundation data for uncovering trends in matters-ETL via SQL and APIs-Data cleaning on large, poorly-formatted data sets-Web scraping-Exploratory analysis and regressions as well as beautiful static visualizations-RMarkdown to produce static reports-API extraction of Google Analytics and Twitter data for integration with other data sets/analysis-GIS and mapping for litigation practiceTableau and PowerBI for visualizing, interpreting, sharing:-Dashboard creation and interactive visualizations for business development, strategist teams, partners and management.Excel with VBA for:-Reporting granular, user-manipulable data via pivot tables and dashboards-Custom ribbon development for litigation document review process (regarded as the firm's Excel guru so am often tapped for advice and projects outside of marketing)

Consult and train cross-departmentally on special projects requiring advanced Excel functions: advanced formulae, formatting, macros, and pivot tables.Update R scripts for greater efficiency, create RMarkdown documents to analyze and report on effectiveness of thought leadership for the Marketing Department.Provide VBA programming in Access, Excel, Word, PowerPoint.Design, create and maintain several relational databases (Access, SQL, MS Query) for trafficking jobs through the department and managing temporary staff.Provide ad-hoc queries and reports from several databases (QBE and SQL).Produce business intelligence and data analysis for document production management.Analyze software and hardware usage to create metrics for the duplicating department.Train new hires in Microsoft Office Suite, Best Authority, PDF Converter Pro, ChangePro, Microsystems DocXpert customization, Nero, Bravo CD Burning and printing, PhotoShop, Snag-it, FrontPage, Dreamweaver, and InDesign.Provide ad-hoc training, troubleshooting and special project support to domestic and overseas staff via VNC Remote Control access.Accomplishments:Scripted VBA and created Excel ribbon for the Litigation Department to speed up review of spreadsheets. This ribbon was ultimately deployed to the entire firm.Produced streamlined billing application for document production staff and accounting. Reduced accounting's commitment to document production billing from 10 hrs./wk to 30 mins.

Contract trainer for law firms transitioning to the Microsoft 2000/XP operating system and Microsoft Office Software suite. Instructed attorneys and support staff at several top tier law firms.

Mapped processes and provided business analysis for in-house applications.Performed needs analysis for departments' intranet.Collaborated with Graphic Design team to produce user interface for several in-house custom applications.Tested software for in-house developed applications.Wrote technical specifications for in-house developed applications.Trained staff in Microsoft Office Suite and firm's proprietary applications.Created Flash training modules.