Designed and built initial data warehouse and ETL system for gathering data from thousands of sources, bringing operational data into a centralized location for analysis and reporting.Worked closely with stakeholders from across the business (Sales, Development, Finance) on numerous projects to refine requirements and translate those into technical solutions that met the business needs.Worked with many different data sources — databases, external/third-party APIs (OpenAir, SalesForce, Rally, BrightIdea) and AWS APIs (Glue tables, S3 buckets, CloudWatch metrics).Developed a queuing system that increased extraction capacity to tens of thousands of data sources while also increasing visibility of data issues. Developed a service for running investigative queries across thousands of customer databases that enabled leadership to quickly assess scope of problems impacting production environments.Made extensive use of SQL Server Integration Services (SSIS) with a shift to cloud-based service architecture, primarily AWS Lambda functions and Glue jobs.Regularly sought opportunities to improve performance, increase reliability, and minimize resource consumption/costs all with the end goal of delighting end users with timely and accurate insights.

A point of triage between development teams and the rest of the company and its various service organizations. Responded to application deployment, configuration, and product defect escalations raised by members of the Delivery Services and Customer Support organizations. Peer-reviewed customizations and add-ons to core products for security and scalability concerns. Communicated concerns from service organizations to development leaders and coordinated the preparation of emergency issue fixes and monthly product maintenance releases to deliver timely resolution to product defects and continuously improve product quality. Received training with SQL Server Reporting Services and Integration Services and applied those skills by developing data mining processes and reports to analyze product performance and quality metrics.

Performed investigations to identify and correct application configuration and deployment issues. Shared problem solving strategies, issue summaries, and steps necessary to achieve resolution with team members. Examined software defects, security concerns, and performance/scalability issues in close collaboration with Product Development teams and Service organizations. Managed escalated incidents and resolved hundreds of unique problems monthly, increasing breadth of product knowledge and honing problem solving skills under tight deadlines. Contributed to the development of an incident management application that improved prioritization, resulting in better response times and more attention to critical issues.

Deployed and configured products to client systems. Worked closely with SaaS/Hosting organization to coordinate deployments to live Production environments without impact to end users. Developed knowledge of underlying systems (Windows Server, Internet Information Services, SQL Server, .NET Frameworks). Received Desire2Learn Superstar award for "extreme dedication" to completing projects as the entire client-base was upgraded to the latest product version. Regularly contributed to internal process improvements by revising documentation and streamlining procedures.