Helped marketing operations understand and manage resource utilization by creating dashboards, conducting investigations, and creating predictive models

Consult to nonprofits on data modeling and analysis

Analyzed the universe of legacy marketing and lead data, the processes and workflows that generated the data, and their data containers.Collaborated with the CIO, marketing leadership, and sales leadership to redesign the databases, tools, and processes in support of a more efficient and nimble, data-driven decision environment.Configured and maintained Microsoft Dynamics CRM online dashboards (RDL files, SSRS Expressions) with KPIs for multiple user roles.Queried Microsoft SQL Server databases using T-SQL on a daily basis for ad hocreports, using complex joins as needed.Analyzed website visitor origin and activities using data from Google Analytics.Created Excel workbooks with Pivot Tables, Dynamic Tables, VBA Macros, and formulas.

Web application developer intern using C#.Net, SQL Server 2008, ASP.Net MVC framework, LINQ to SQL

Analyzed the information technology (IT) reseller/indirect sales channel market. Collaboratively designed surveys with sales, editorial, and executive staff. Programmed surveys for skip logic and data integrity checks. Developed relational databases and linked Web forms for other data collection. Analyzed data using SPSS to produce descriptive statistics. Provided reports and consultation to Everything Channel's editorial, sales and marketing teams. Delivered PowerPoint decks, Excel books with advanced functions and pivot tables, data visualizations, news articles, and feature articles for consumption of executives, sales staff, journalists, and readers. Used proprietary scripting language (Insight Express) for survey programming, as well as HTML, XML, and PowerPoint.

Conducted independent survey research, monitored third-party research for editorial relevance, coordinated data presentation across the book and wrote research-driven features.

Managed the edit cycle for 4-5 articles per issue in a magazine that printed 18 times per year with 40-plus pages per issue. Served a community of 90,000 print subscribers (plus additional Web readers) interested in information technology used for strategic advantage at Global 2000 companies. Subscriber titles included CIO, CFO, CEO, VP or Director of Marketing, and VP or Director of IT. Covered topics such as business intelligence (BI), analytic applications, data mining, text mining, online analytic processing (OLAP), performance management, knowledge management (KM), supply chain management, customer relationship management, and enterprise information integration. Wrote news, interviews, and columns. Conducted reader surveys. Represented the magazine at industry events.

Coordinated creation of internal and customer Internet nodes: Worked with vendors, technicians, engineers, sales staff, accounting staff, landlords, and customers to plan and implement installation of communications equipment and delivery of services nationwide. Helped grow the network from 5 nodes on a T1 to 25 nodes on an OC3 backbone. Helped grow the customer base from 8,000 to 60,000.