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.

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.

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.

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.

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.

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.

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.

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.

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.

Washington, DC, US

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