Nikhil J Shetty

Description:

Game Telemetry DAT project involves the Data collection, Analysis, Performance Optimization, Testing and Validation of telemetry data generated during the gameplay experience, Reporting and Visualization of the data

This project will help developers identify areas for improvement based on data-driven insights to provide a smooth, responsive and engaging experience for players

Responsibilities:

• Analyzed raw data and planned necessary views and table creation based on the Design Document requirements.
• Identified data issues, wrote queries to investigate, and created JIRA tickets for data ingestion actions.
• After issue resolution by the Game team, performed regression testing to confirm data population.
• Documented table structures and provided information for stakeholders' reference.
• Suggested additional columns and new data requirements based on game interactions.
• Implemented business rules using stored procedures.
• Developed SQL queries with subqueries, CTEs, joins, string functions, ranking functions, and set operators.
• Defined check constraints, primary, and foreign key relationships.
• Created DAX queries for computed columns in Power BI.
• Connected to and transformed data from various sources for Business Intelligence.
• Developed Power BI reports using Power BI Desktop and Power Query, integrating data from SQL, Excel, and Power BI datasets
• Designed and executed SQL queries to validate data transformations, aggregations, and loading processes across Staging, Fact, and Dimension tables, ensuring accurate source-to-target mapping (STM)

Description:

The centralized database management system is the system used to perform feasibility studies, tolerance allocation, and manage the data of production, rejection, sales, purchase, supplier issues data, supplier and customer information, and supply chain. It will give an end-to-end solution to maintain the overall project data.

Responsibilities:

• Wrote simple and complex queries using joins and subqueries to fetch required data.
• Reviewed the standard tables to for the feasibility study and tolerance requirements
• Created SQL queries and views to perform the necessary calculations to ensure achievability of product specifications
• Tracked production, rejection, sales, and supplier issue data to identify areas for process improvement.
• Developed SQL queries with subqueries, CTEs, joins, string functions, ranking functions and set operators.
• Defined check constraints and primary and foreign key relationships.
• Worked with temporary tables and table variables.
• Created indexes on selected columns to optimize query performance in SQL Server Management Studio.
• Used stored procedures and UDFs to implement business rules.
• Worked on schemas and entity relationship diagrams.