Business Intelligence Support Engineer
Resume:
Brian Cooke
Burbank CA *****
*****.*.*****@*****.***
A seasoned technical leader with 16 years’ experience in data engineering, database development, and business intelligence, and 9 years of DevOps, Linux software integration, and release engineering EXPERIENCE
Irdeto USA, North Hollywood, California and Remote DECEMBER 2015 – PRESENT DevOps, Integration, and Support Engineer
● Served as subject-matter expert for the company’s Distributor Watermarking anti-piracy solution, supporting movie studios with on-site deployment, support, upgrades, and troubleshooting
● Extensive support of large-scale, multiple-server Linux deployments, both RPM- and Docker-based, at customer sites
● Later transitioned Distributor Watermarking customer integration to cloud-based delivery using AWS or GCP, depending on which cloud platform the customer used for its content delivery
● Worked extensively with customers to configure their S3 buckets for cross-account video access by Irdeto services. Transitioned log file analysis to CloudWatch and GCP logging
● Release engineer for the company’s TraceMark Cloud Service anti-piracy product, using AWS for
● Docker (ECS, ECR, EKS), GitLab for CI/CD, Ansible, CloudFormation, and Terraform for automating cloud infrastructure deployment and configuration
● Planned and performed release-to-customer activities, chiefly planning and executing user acceptance tests of new software releases
● Primary liaison between the Studio Services group and the Netherlands-based engineering team
● Provided engineering support for pre-sales activities, planning and deploying proofs of concept at customer sites, and architecting new post-sales deployments
● Supported online piracy detection and business intelligence analysts using Python/Perl, and SQL and NoSQL querying (MySQL/MariaDB, PostgreSQL, MongoDB)
Verizon Enterprise Solutions, Business & Government Customer Operations, Irvine, California Systems Consultant, Business Intelligence JUNE 2013 - DECEMBER 2015
● Lead ETL development for an organization-wide data mart using SQL Server 2008 and 2012
● SSIS packages, with script tasks and components using C# (.NET framework)
● Custom ETL using Perl, with advanced regular expressions
● Oversee a conversion of database instances, SSIS packages, and other supporting workflow from
● SQL Server 2008 to 2012
● Full-stack application development using Java (Spring framework), HTML5, jQuery, JSP/Thymeleaf, REST services, and MongoDB, deployed on Tomcat application servers
● Convert the BI team’s source code management to a distributed, Git-based workflow
● Identify trends, correlations, predictive behaviors, and customer behavior patterns using data cleaning and presentation toolset: Perl, Python, R, SPSS
Verizon Enterprise Solutions, Finance, Irvine, California Supervisor, Budgets & Reporting JUNE 2012 - JUNE 2013 Senior Analyst, Reporting & Analysis MARCH 2009 - JUNE 2012 Manage all server-side and database back-end functions for the reporting group:
● Server maintenance, software patches, server configuration and deployment
● SQL Server database design and administration
● SSIS load packages that pull detail records from the data warehouse and other sources into the group’s own reporting databases
● Stored procedure and query development for use by front-end reporting and dashboarding applications
● Automated testing and validation tools, including extensive use of open-source programming tools such as Unix shell and Perl
Serve as technical lead for the reporting group:
● Develop, communicate, and ensure compliance with group coding standards, with emphasis on maintainability and readability
● Maintain wiki-based documentation of the group’s query logic, detailed SQL, and other technical documentation
● Maintain version-control systems on the group’s servers (Git and Subversion), and educate team members on best practices for using these technologies to maintain work products under accessible version control
● Oversee the back-end database aspects of the reporting requirements through two complete reorganizations of the group, first from Government Sales & Operations to E&G Finance (early 2010), then to Verizon Enterprise Solutions
(early 2012)
Verizon Wireless, Irvine, California
Consultant, Headquarters Customer Service JANUARY 2001 - MARCH 2009 Successfully design and build sophisticated database and reporting infrastructures, transforming cumbersome, non-usable data into actionable information utilized by senior leadership and third-party providers:
Web application Development and Maintenance
● Enterprise-wide website to house and report metrics for the ongoing customer survey. Build using Ruby on Rails framework, with Apache on Unix proxying to a Mongrel cluster
● Architect and build web applications used by contact center management for monitoring interactions with customers while capturing and reporting scores based on defined performance criteria
● Technical lead and lead developer, interfacing with Verizon Wireless leadership and outsourcer managers to gather requirements, architect solutions and construct and deploy applications
● Deploy multiple applications, using the Rails and Catalyst frameworks, mod_perl running on Apache, Perl/CGI and PHP. Used the Prototype and jQuery AJAX libraries for client-side user interfaces Database Design and Administration
● Design and administer databases to house IVR call statistics, call drivers, net promoter score (NPS) surveys and a variety of ad hoc reporting needs
● Relational database (RDBMS) systems include MySQL, SQL Server and Oracle Programming
● Utilize high-level programming languages to extract, mine, summarize and analyze data from disparate sources
● Perform advanced automation techniques including mechanizing file transfers traversing the company firewall, automating downloads from external vendor websites
● Advanced skills in languages including advanced Perl (including using and authoring CPAN modules), Ruby, PHP and Java
Partnering with Stakeholders
● Technical reporting lead, interfacing with senior management and IT to implement enterprise reporting applications
● Highly respected subject-matter expert regularly sought out by technical staff for mentoring
● Regarded as “voice of the business”, liaising between management and IT. Translate both business and technical requirements into language understood by all stakeholders
● Successfully implement customer self-service modules, providing considerable cost and time savings TECHNICAL EXPERTISE
Server Administration and DevOps
● Unix setup and administration: Linux, Solaris, BSD
● Cloud platforms: Amazon Web Services (AWS), Google Cloud Platform (GCP)
● Containerization: Docker and Kubernetes
● CI/CD tools: GitLab CI/CD, Jenkins
● Designing and deploying AWS environments using EC2, S3, EBS, ELB, and auto-scaling groups
● Web servers: Apache, lighttpd, nginx
● Application Servers: Mongrel, mod_perl, jBoss, Tomcat, Jetty, Weblogic Software and Database Development
● Python
● Perl, including CPAN modules
● Shell scripting: bash, ksh, zsh, Powershell
● Visual Basic, C#, .NET framework
● Java and Spring framework
● Databases: Teradata, SQL Server, Oracle, MySQL, PostgreSQL, SQLite, MongoDB, Amazon Aurora, DynamoDB
● Data warehousing: Building and maintaining BI data marts using SQL Server, SSIS, and custom ETL
● Reporting, analysis, data mining, data transformation, and presentation: SQL Server Reporting Services (SSRS) report development, SQL Server Analysis Services (SSAS), Oracle, Teradata, MongoDB, Perl, Ruby, Python, R
● Scripting Teradata power tools on Unix: FastLoad, MultiLoad, FastExport, BTEQ
● HTML5 and CSS, focus on W3C standards compliance
● Search Engine Optimization (SEO)
● JavaScript and jQuery
Database Administration
● MySQL/MariaDB
● PostgreSQL
● SQL Server including server installation and deployment, DBA, SSIS package development and deployment SKILLS
Excellent track record bridging technical and business stakeholders Experience with software project management, SDLC, and agile methodologies Extensive experience collaborating with different functional areas in complicated organizational environments EDUCATION
Azusa Pacific University, Azusa, California — Bachelor of Science, Accounting
Contact this candidate