Evaluated complicated and disjointed business processes to surface trends and evaluate business performance. Supported rapid product growth and market expansion by providing near real time reporting and rapid turnaround time for ad hoc questions and exploratory analysis. Reconciled overlapping accounts of business process definitions from cross-functional, technical, and non-technical perspectives to document frequently changing processes, identify gaps, educate peers and leadership, and advocate for improvements. Piloted new tools and methods and made recommendations for adoption.Streamlined data preparation pipelines to efficiently combine data from Indeed’s proprietary data storage system and other non-standard sources with data in relational databases. Directed data engineering to make improvements to support those pipelines and created tickets with technical specifications. Specified improvements enhanced reporting capabilities and created a manifold increase in data processing and report loading times.Recognized the need for a robust QA process to ensure data engineering efforts met requirements, discussed options with peers, data engineers, and management to align on a mutually agreeable solution. Partnered with the marketing team to develop a new campaign tracking process which enabled highly specific attribution at all funnel levels and produced the first direct marketing spend to revenue report and analysis at Indeed. Collaborated with the user experience team to produce an atheistically pleasing and easy to navigate reporting template, compliant with brand guidelines, and drove its adoption among report authors. Provided training to new team members exposing them to processes, data sources, best practices, along with diagrams and documentation which I had authored. Gleefully worked with team members to swap knowledge and expand each other’s technical capabilities.

Developed and implemented large-scale solutions to institutional data issues. Modeled business processes to document the current state and communicate the desired future state. Assessed requirements at the team and university-wide levels. Devised innovative solutions that addressed requirements from all levels while anticipating future needs. Ensured transparent and diplomatic communication between end-users, technical developers, and management.• Proactively evaluated legacy business processes, took the initiative to craft improvement strategies, secured buy-in from management, and oversaw implementation, resulting in continuous increases in timeliness and accuracy of reporting as well as enabling advanced analytics.• Liaised extensively with coworkers and executives of diverse technical backgrounds to build and lead successful cross-functional teams, negotiate requirements, establish methodology, deploy solutions, validate results, and achieve common goals.• Cultivated and maintained an awareness of all ongoing projects and deadlines in the office, what work overlapped and intersected, where dependencies created bottlenecks, and anticipated downstream effects of process improvements.• Collected and cataloged user requirements, promoted requirements to inform solutions and justify action.• Responsible for cross-training office staff, ensuring they had a deep understanding of data sources and business processes. Served as the primary resource for problem solving related to data migrations and provided expert guidance on which data to use for different purposes.• Performed root cause analyses to diagnose and treat systematic issues with source data, data loads, access, and use. • Established documentation standards for all systems, models, requirements, and data elements. Collaborated with a technical writer and application developer to build a user-facing documentation portal and a back-end interface for publishing documentation that met the new standards.

Accelerated the University’s effort to build its first OLAP data warehouse. Synthesized nuanced requirements to produce technical specifications. Assessed and approved data models and ETL instructions. Worked closely with the project manager and development team to ensure goals were clear, and deadlines were met each sprint. • Conducted interviews and facilitated meetings with users, data stewards, subject matter experts, and stakeholders to gather user requirements and map business processes.• Analyzed, organized, and tracked requirements. Produced formal functional and technical specifications based on requirements. Maintained a feedback loop with users to verify understating, scope, and deliverables met business needs.• Represented user needs and advocated for user-centric solutions during the entire development lifecycle.• Managed the testing phase gate, including documenting user acceptance criteria, developing test cases, auditing test results, and prioritizing bug fixes.• Authored programs to perform comprehensive source to target testing of data from the transactional warehouse to the new reporting warehouse evaluating every value in every cell of the target against the source to ensure records were not lost and all transformations were properly applied.• Consulted with the project manager regularly to assess progress and determine goals. Facilitated communication between the technical development team, the users, and the project manager. Helped formulate staffing stagey. Represented the project manager in meetings.• Championed documentation by elevating department standards and consistently producing thorough, accurate, and clear documentation for the spectrum of technical and non-technical consumers.

Organized, prepared, and cleaned multi-dimensional datasets with disparate sources. Performed statistical analysis to support data-driven decision making at the executive level of the University. Reported results using data visualizations in Tableau. Modernized and standardized compliance reporting practices.• Effectively collaborated with technical staff to provide expanded training and access to reporting analysts, empowering analysts to navigate data repositories without requiring constant support and improving working relationships between the groups. • Streamlined processes for producing recurring reports by automating routine processes, centralizing data sources, and updating access protocols.• Prioritized compliance with FERPA laws, protecting student’s privacy, and maintaining the integrity of the reporting system. • Developed logistical regression models to evaluate the effect of financial aid on matriculation rates, which were used to strategically distribute financial aid to incoming first-year students.• Developed Markov chain models to predict the size and makeup of undergraduate classes ten years into the future, which were used by the Provost’s office for resource planning and allocation.