Andrew Affolter Email & Phone Number

Bothell, Wa, Us

Seattle, Washington, United States

Seattle, Washington, United States

●Owned the Data Lifecycle organization at Snap with the mission to instrument, collect, deliver and catalog data at scale for timely data-driven decision-making.● Led an organization of 20+ engineers, TLs, and Managers who build and own Tier-0 & Tier-1 Big Data systems for Snapchat users including Snap’s Big Query infrastructure and data pipelines for Tier 0 metrics.● Owned Big Data Infrastructure Costs for Snap, including building continuous cost savings tools, which delivered $2M in annualized savings over the first month.● Responsible for setting the strategic vision for all Data & Insights through annual company-wide strategic planning, including staffing, finance, & incremental HC planning.● Worked in partnership with leaders across the company, developing cross-Snap OKRs within the Data & Infrastructure organization, translating strategic priorities into measurable milestones.

Seattle, Washington, United States

● Owned the Analytics Engineering Infrastructure organization at Snap, enabling Product Analytics via a robust set of visualization tools, Data Engineering, and orchestration platforms.● Worked in close partnership with Product Management and Data Science & Analytics, supporting users of BigQuery, Looker, Tableau, and in-house built visualization and analytics tools.● Lead an organization of 30+ engineers, TLs, and Sr. Managers who build and own Tier-0 & Tier-1 Big Data systems for Snapchat users, including the canonical data model and the central repository of all Snap KPIs, including the canonical data on DAU, DNU, Revenue, etc

Seattle, Washington, United States

• Own the Storage, Caching, and Core Services Infrastructure organization at Snap supporting all Snapchat users across AWS and Google Cloud. • Leading an organization of 30+ engineers, hands-on managers, and Sr. Managers who build and own all Tier-0 & Tier-1 multi-cloud storage platforms for Snapchat services around the globe supporting an engineering organization of 2,000+ HC.• Kickstarted and led Snap's acquisition & integration of KeyDB, a high-performance fork of Redis, including technical due diligence, interviewing, deal terms, comms plans, etc.• Responsible for setting the strategic vision for Storage, Caching, and Core Services through annual company-wide strategic planning including staffing & incremental HC planning.• Work in partnership with leaders across the company developing cross-Snap OKRs within the Infrastructure organization translating strategic priorities into measurable milestones.

Greater Seattle Area

• Establish and build a 15-person engineering organization, including recruiting, hiring, and bootstrapping SDMs and multiple vertically aligned product teams to optimize full-stack customer facing experience (CX) technology for Advertising Content Experience (ACE).• Create an innovative shopping experience in the Amazon Shopping App that disrupts the current engagement paradigm while enabling customers to discover company products; $1B business goal.• Partner with the General Manager on coordinating product ideation, vision, and execution, as well as with cross-functional teams on delivering optimal customer experiences across platforms.• Draft business and technical writings to VPs and SVPs to drive cross-organizational product alignment.

Greater Seattle Area

• Recruited and trained top talent for two software engineering teams (15 people), managing them through confidential and public phases to launch products under extreme deadlines.• Promoted four Software Engineers to Senior Software Engineers and two entry-level Software Engineers to Software Development Engineer II.• Piloted the launch of the fully native iOS and Android Amazon Go apps used to shop the Amazon Go Store, as well as the Event Graph Database which acts as the central broker for events and sessions.• Collaborated with the Product Manager and Visual Designer on streamlining the UX experience and regularly reported project status and milestones to SVP (S-Team) level management.

Greater Seattle Area

• Founded and directed two teams in developing DevOps and Security services, including creating tools and services used by core browser engineering teams and owning Big Data services and tools built on top of Amazon EMR and Redshift.• Fortified relationship with customers by escalating their security and privacy matters, defining their needs, answering questions, and maintaining project transparency.• Optimized incident response for large scale security issues, including Heartbleed vulnerability in OpenSSL.

Columbus, Ohio Area

• Directed operations for the first major Agile project in Retail Consumer Banking, a new CRM front-end application, including developing the project team, organizational structure, and delivery strategies while adhering to established Scrum practices and methodologies.• Organized daily stand-ups, planning meetings, product backlog grooming, use-case development, planning board and task board creation, and staff responsibility delegation.• Created application architecture and development methodologies (e.g. Spring MVC, JQuery, Apache OpenJPA, CXF), as well as standardized team development tools, source control management, and documentation according to FE&A standards (e.g. FAST DD, SVN, Confluence) and Agile best practices.• Instituted the use of JIRA + GreenHopper for user story development and tracking, planning board and task board management, and release management.• Managed a suite of applications (e.g. Account Origination, Branch Scanning, Marketing Campaign Management) while providing solutions architecture, project direction, and execution within the Consumer Banking IT department.• Earned top-tier “Exceeds Expectations” rating in 2009, 2010 and 2011.• Charted successful development of architecture vision and migration to Firmwide Engineering & Architecture (FE&A) development tools and cloud hosting system.• Designed a new Branch P&L system, a security framework, a mobile Contact Manager prototype, and a report generation system, building use cases, requirements, and specifications, performing usability testing, and implementing updates.

Columbus, Ohio Area

• Oversaw a 10-person team in developing a Customer Assist application: implementing enhancements within the Enterprise Release schedule, managing onshore and offshore architecture and infrastructure resources, tracking and reporting status and defects, and establishing services for client applications.• Focused on J2EE programming utilizing Java, JSP’s, JSTL, and JavaScript.• Liaised with business analysts to refine requirements, create designs, and implement solutions while also providing estimates, participating in JAD sessions, monitoring critical paths, and interviewing and evaluating employees.• Conducted defect tracking and code review and coordinated with testers.