Jay Mendes Email & Phone Number

San Diego, Ca, Us

Credited Games: Lost Ark, New World Architected database hosting and service platform for MMORPG Lost Ark for five game regions in Europe, North America, and South America Designed and implemented data privacy service in Lost Ark to document and comply with global internet data privacy laws Designed solution to z-axis shard worldwide mega server architecture Refined data architecture across the organization for cost and capacity optimization Automated deployment of database updates and maintenance activities Automated creation of database resources from instance creation to availability group listeners

Boulder, Co, Us

Implemented customer facing PowerBI reporting to track customer usage statistics. Implemented internal PowerBI reporting to track Azure cloud costs. Implemented data collection for an enterprise data lake using Azure SQL Databases. Developed and automated ETL pulling data from Azure cloud API and in-house application database servers to track user activity and cloud cost budgeting. Migrated legacy MySQL environments to Azure MSSQL production and staging environments. Created new production and staging environments for new customers and application functionality.

Implemented a Snowflake data lake containing over 1TB of monetization data. Implemented data collection for an enterprise data lake using AWS Kinesis Streams. Developed and automated Upsolver ETL for data enrichment and aggregation between AWS Kinesis and AWS S3 storage. Developed AWS Lambda applications to control and import data to a Snowflake data lake with c#.net and python. Managed, migrated and improved the performance of multiple Elasticsearch production and staging environments. Supported teams around the world utilizing Looker, Anodot, MySQL, Kibana, Tableau, Hadoop, Hive, Jenkins and AWS Neptune graph database. Managed production and staging environments for legacy applications on MSSQL 2008R2. Automated disaster recovery process to upload database backups to AWS S3 and test backups by restoring to AWS RDS.

San Diego, Ca, Us

Managed production and staging environments at 99.99% uptime availability utilizing MSSQL high availability groups, transactional replication and proper backup strategies. Managed and developed in Azure SQL environment across three global regions for new products using C# and PowerShell to create applications for data manipulation. Developed and executed a major Azure migration between regions in Azure SQL, Azure table storage, blob storage and file storage by creating .NET applications to perform ETL on over 100GB of data including programmatic testing of the migrated data to ensure the migration was completed successfully. Implemented two major MSSQL migrations from legacy systems to modern scalable z-axis split environment utilizing SSIS and TSQL scripting. Supported BI teams utilizing Tableau, Greenplum, Hadoop, Hive and SSRS. Architected and implement AWS solution to support EU data compliance for our EU customers.

Us

Work with Development and BI to determine database requirements and required featuresPerform database maintenance, performance tuning and patching, including on call rotationCreated MS SQL Database and ETL process for large incoming Business Intelligence data system that services 1.5TB (2 billion rows) per day of incoming data on heavily partitioned databases.Created process for maintaining BI data warehouse.Created ETL process for aggregating large datasets (multi TB in size) in 80 node Hadoop cluster and pushing to BI data warehouse for consumption.Upgraded several key SQL Server instances from MSSQ 2008 R2 to MSSQL 2012 and implemented High Availability Groups. Started testing for move to MSSQL 2014 with memory optimized objects.

Design and execute test plans to verify and validate the correct functionality, usability, performance, and reliability of web-based systems and applications. Create, run and analyze comprehensive automated tests for dynamically changing Web applications. Assigned Military Healthcare projects include: TRIAP, TRICARE and Wounded Warrior Assigned Gaming projects include: Army Family Support sites in Linden Lab’s Second Life, Forterra Inc’s OLIVE online game world, and the Army Financial Literacy game (An extensive flash based game world designed to help teach soldiers valuable lessons on the principles of sound financial judgment.) Experience with Agile SCRUM development methods

San Diego, Ca, Us

Worked with Development and Business Analysis to analyze requirement specifications Developed and implemented test plans with QA teams of up to 5 members supporting enterprise level projects (thousands of personnel work hours) Provided detailed estimates of resource and time needs to QA and Project Management Created comprehensive test strategies to properly plan and outline activities required for both manual and automated testing teams while conforming to defined SDLC and QA standards and processes Reviewed and instructed QA Engineer written test scripts to ensure best practices and maximum efficiency in testing efforts Supervised and mentored QA Engineers in black box and grey box testing efforts Created detailed test data outlines supporting hundreds of possible data scenarios and specific data related test points Managed and reviewed code/builds submitted by development for deployment to QA and production environments in accordance with established SDLC processes Assisted in creation of and using testing status reports for VP level management using MS Word, Excel and PowerPoint Coordinated and supported user acceptance testing teams of up to 20 members Preformed product risk analysis and analyzed testing results to support QA approval of projects to be deployed to production Gathered and stored legal audit materials to support QA approval of projects to be deployed to production in accordance with established SDLC and QA standards and processes Preformed and supervised critical security breach testing Preformed review, guidance and troubleshooting with Dev and QA resources on defects found by QA Engineers Coordinated and led project, defect and team meetings as needed to support testing efforts and training for team members

Las Vegas, Nv, Us

o Utilize automated testing tools such as Mercury Quick Test Proo Create, maintain and implement test scriptso Assisted the Production Support team by troubleshooting and re-testing critical production issues.o Assisted in coordinating user acceptance testing.o Develop and implement test plans (via Mercury Quality Center)

Las Vegas, Nv, Us

o Supported the Operations department by gathering, documenting and publishing of business requirements.o Troubleshooting and tracking of issues via ClearQuest.o Coordinated end user validation and acceptance testing.o Served as Operations department liaison with IT Development and Software Testers.o Provided training on processes, tools, and data to users and business departments.

Las Vegas, Nv, Us

o Developed documentation standards, issue resolution, and escalation processes related to record management and file retention.o Developed reporting applications and reports as requested by management, via Access, Cognos and SQL.o Provided Operations processing support and training as needed.o Resolved escalated application issues as required by the Legal department.o Managed and upgraded record storage and tracking software.

Washington, Dc, Us

Description pending...but general military stuff with an emphasis on troubleshooting and repairing heavy equipment and generators.