Christopher Schmalz Email & Phone Number

Redwood City, California, United States

Redwood City, California, United States

Redwood City, CA

• Write and manage reporting related ETL processes for paid media across all channels, obtaining data from dozens of external platforms in addition to an internal data warehouse based in Hadoop
• Implemented automated checks to ensure 99.999% accuracy between platforms and internal reporting, allowing our data to be used internally by finance to estimate spend in real time
• Working on an exciting project to unify messaging across all channels, leveraging petabytes of data collected about our players to ensure we are communicating with them in a personal way
• Act as an evangelist of the rich data at our fingertips; educating and training different groups in the organization about its depth, usefulness, and potential
• Engineered an automated tool to globally plan budgets for all titles in our portfolio across console, PC, and mobile devices – allowing teams to accurately pace media spend on a daily basis
• Created more than 25 personalized dashboards for users across activation, strategy, brand, creative, and finance – allowing for increased visibility, self-service insight, and one source of truth

Santa Clara, CA

• Create and manage a robust offering of 32 business intelligence research and monitoring reports to track and illuminate the propagation of piracy on peer-to peer networks and the web
• Provide regression analysis for film and television by leveraging the trends of existing titles with a similar genre, budget, and distribution method – predicting piracy before it happens
• Automated manual procedures for the operations team, often cutting task time by 95% or more
• Member of the Global Innovation Team, guiding several projects including 3D printing protection
• Oversee the launch of a new peer-to-peer tracking system on Hadoop; assisting the engineering team in the design, deployment, testing, and troubleshooting of all reporting related systems
• Created eight customized heat maps for international and domestic territories, providing valuable metrics used for targeting new markets and identifying emerging threats

Santa Clara, CA

• Prepared for and facilitated the switch of databases from MySQL to MongoDB, often worked with the Director of Engineering to improve query speeds by 40-60%
• Quickly learned the MongoDB query language and became well versed in all types of queries
• Worked with Engineering to create a robust Excel-based mongo query engine that became the backbone of the new reporting infrastructure – used by all automated reports
• Worked on nine large ad-hoc analysis projects for HBO, comparing their television programs to other high-profile competitors at the time
• Often present on client calls or visits to educate them about our offerings and capabilities
• Provided data and analysis to customers on the data we collect for research or litigation

Los Gatos, CA

• Led independent program to redesign all 25 client reports from concept to final draft; the updated and revised layout, design, and automated execution led to greatly increased readability
• Developed a suite of VBA macros which fully automate the generation of Excel based reports, improve scalability, and reduced report generation time by 85%
• Monitored and analyzed all client data to troubleshoot problems and perform trend analysis
• Kept and updated portfolios of the habits, routines, and activity of pirate groups all over the world
• Point person for creating specialized ad-hoc reports, especially when the task was urgent
• Developed extensive training materials and tutorials for internal departments on six services

Los Gatos, CA

• Established standards and procedures for the submission of downloaded files to various intellectual property holders– strict requirements were needed due to its usage in litigation
• Searched for and downloaded pirated content from any available sources for evidence gathering and tracking purposes, maintaining full documentation on activities for later reference
• Created and sent hundreds of reports and evidence packages each week

Campbell, CA

• Managed 25-50 cashiers directly on a daily basis
• Managed the collection process for all bounced checks
• Redesigned the organization and structure of the Customer Rebate Center, resulting in increased customer satisfaction and readability
• Responsible for counting and tracking over $10,000 in petty cash daily.