Joseph Saunders Email & Phone Number

Seattle, Washington, Us

Lead a department of Data, Software and Business Intelligence Engineers to develop and maintain data infrastructures that provide business and production teams across the globe with time-critical technical solutions in support of the creation and distribution of Amazon MGM Studios' original content.Launched and continually expand an AWS-based, enterprise data ecosystem leveraging micro-service architecture, infrastructure-as-code as well as continuous integration and continuous delivery. This platform consumes and distributes data with 20+ systems via change data capture, near real-time streaming services, third party APIs, analytic dashboards, and file transfer.Own strategic initiative definition and execution. Organize and host monthly reviews with customers, leadership and tech partners reviewing achievements and challenges supported by standardized operational metrics.Develop technical and managerial resources to enhance engineering excellence, leadership instincts and customer relationships in support of their long-term career goals.Provide technical and professional mentorship to resources and teams across Amazon.

Seattle, Washington, Us

==Amazon Studios, Data Engineering==Support the various teams across Amazon Studios, with projects focusing on content performance, primary research, predictive analytics and financial analyses related to Amazon Studios' original contentIdentify, ingest and interpret new data sources, devising analytic strategies and building data pipelines to support themDesign and manage a data infrastructure that includes Redshift clusters, S3 repositories, EC2 instances, hundreds of daily ETL processes, billions of rows at the terabyte scaleKey operational projects include automating Redshift maintenance operations as well as creating automated data quality and process performance monitors===Languages Used===SQL, Python, Shell Scripting===Technologies Used===Redshift, S3, EC2, AWS Lambda

Seattle, Wa, Us

==Amazon Retail Analytics Premium==Providing Amazon's top tier retail vendors a premium analytics platform that uncovers hidden insights to help accelerate their business on Amazon.com. I design and support data processes, environments and frameworks utilizing Oracle, Redshift, Hive on Elastic MapReduce and other proprietary technologies.===Languages Used===SQL, Shell Scripting===Technologies Used===Oracle, Redshift, S3, EC2, Elastic MapReduce (EMR)

Chapel Hill, North Carolina, Us

Design and develop ETL jobs, sequences and scripts to extract data from a variety of organizational sources and store the transformed data in a central repository and subject-specific data martsDesign new data structures, relationships and ETL processes to expand scope of healthcare data warehouse and add new data marts to support research and analysisImprove quality and performance for existing ETL processes through query tuning, job efficiency, batch optimization and scheduling; using Agile software development modelProcesses are created using IBM DataStage Designer and include IBM DB2 and Microsoft SQL Server data sourcesParticipated in Six Sigma DMAIC project to reduce ETL process time and resource use; currently in training to lead future DMAIC projects===Languages Used===DB2 SQL, Microsoft SQL Server, Netezza (PostgreSQL), Shell scripting===Technologies Used===IBM InfoSphere DataStage (v8.1, v8.7, v9.1)IBM FastTrackMinitab===Technical Courses Completed===IBM InfoSphere DataStage 8.5IBM InfoSphere DataStage 8.7Netezza 7.0 Appliance and Database===Six Sigma + Lean===UNCH Yellow Belt - seminar introducing process improvement methodologies Six Sigma and LeanUNCH Six Sigma Green Belt Certified - participated in improvement project following DMAIC process focused on reducing ETL processing timeUNCH Lean Purple Belt Certified - coached a Kaizen improvement project following Lean improvement methodologies to standardize the development of Healthcare Quality measurements and analyticsUNCH Six Sigma Black Belt (training complete) - training in leadership, facilitation and statistical analysis guided towards coaching DMAIC and Lean projects

Bellevue, Wa, Us

SQL-Server environment experience includes developing SSRS reports, writing MDX queries and designing OLAP cubes for Analysis Services. Led planning and development on a migration effort involving the re-envisioning of over 20 existing reports, which included designing and implementing new OLAP cubes to improve report processing time.Oracle environment experience includes developing on-demand reports and automated feeds using SQL queries, PL/SQL procedures, Business Objects WebIntelligence, ColdFusion web pages and Bash shell scripts.Languages Used: MDX, T-SQLTechnologies Used: Microsoft SSRS, SSIS; OLAP cubes

Bellevue, Wa, Us

Supported processes, applications and data feeds that provided financial analysis to the top wireless carriers and entertainment providers.As a member of the back office team, my responsibilities included managing and improving ETL processes, as well as developing feeds and reports using Business Objects WebIntelligence, ColdFusion pages and SQL stored procedures (Oracle).Additionally, I developed documentation which involved detailing legacy processes, creating diagrams of existing data models and data flow.Languages Used:ColdFusion, PHP, PL/SQL, SQL, SQL*Plus, Shell ScriptingTechnologies Used:Apache Webserver, Data Integrator, FTP, SSH

Durham, Nc, Us

Improved and maintained ColdFusion-based reporting application that allowed mobile content developers to view sales performance of their products on Appia's PocketGear marketplaceImproved and managed billing processes that relied on 3rd party ColdFusion/XML gatewayPerformed troubleshooting on storefront application, which uses the Fusebox framework (ColdFusion)

Armonk, New York, Ny, Us

2007 - Test EngineerTested diagnostic software for Blade servers.Organized and conducted training of offshore resources.2004 - Test Lead Intern (6 months)Planned and supervised functional testing of IBM eServers and diagnostic software.

Blue Bell, Pennsylvania, Us

Provided technical support to User Experience Design team across Windows and Mac OSX environments.Constructed a 30-system render farm to process 3D animations, reducing render time by 90%.Supported executive presentation theatre. Integrated wireless access control (RFID), audio/video synchronization and web-based control/monitoring. Monitoring was Apache, PHP based and also utilized shell scripting. System composed of 3 web servers, 9 PCs, 20 plasma television screens, video projector and 10 speakers supporting 5.1 digital surround sound.