Sheldon Pinto Email & Phone Number

Seattle, Wa, Us

Redmond, Washington, Us

- Architected and drove the implementation of a unified cloud-based data platform to support all the reporting needs of an entire division of our customer’s organization. The solution leveraged Azure services such Azure Data Factory, Azure Functions, Azure Databricks, Azure Analysis Services, Power Apps, Power Automate and Power BI.- Authored Big Data pipelines, using Apache Spark, to process upwards of 100M records every 4 hours.- Designed and implemented the snapshotting framework which was leveraged by 17 teams to perform trend reporting of various data points. The framework was built using Azure Data Lake Store, Delta Lake and Azure Databricks.- Optimized reporting workloads by leveraging database partitioning and indexing strategies to meet benchmarks of 200ms query duration.- Authored a data extraction framework leveraging the fan out/fan in pattern in Azure Durable Functions to source data from Azure DevOps, Azure SQL databases and Azure Blob Storage. The highly configurable design enabled developers to leverage this framework to reduce development cycles by up to 80%.- Mentored and managed a team of 8+ junior developers.- End to end ownership of project delivery including requirements gathering, estimation, development, testing and demoing daily/weekly incremental builds.

Redmond, Washington, Us

- Developed the in-house recruitment platform which is used for all recruitment activities from screening, conducting programming tests and interviewing candidates. This solution mitigated the need of multiple vendor products for each of the recruitment areas and saved the company ~3-5M per year. - Designed the distributed evaluation engine using a microservices based architecture and backend OLTP system thereby enabling 1000+ candidates to take the online programming test via the recruitment portal.- Designed and developed a reporting ecosystem spanning the entire supply chain including employee productivity metrics, carrier assignment, warehouse inventory and shipment tracking.- Designed Excel reports powered by MySQL and Redshift data marts for Warehouse floor managers showcasing employee productivity metrics and inventory bottlenecks thereby reducing time to problem solve by up to 5 min per issue.- Developed a Power BI dashboard powered by a Tabular SSAS cube with 150+ measures and hybrid row level security based on user personas.- Authored complex measures in DAX and MDX to support business requirements.- Configured CI/CD for various project artifacts including database, and tabular solutions and Power BI using Azure Pipelines in Azure DevOps.- Lead the team implementing the GDPR compliance standard across 15 projects within the organization.

Redmond, Washington, Us

Developed a reporting platform to surface key metrics and actionable insights to 4000+ Marketing field users thereby enabling them to beat their targets by 1.5x. The platform was a web hosted solution with a C# Web API service and SQL Server backend.- Authored stored procedures involving complex logic while leveraging transactions, isolation levels and error handling mechanisms to ensure data quality and system stability.- Authored reporting views, functions and queries using T-SQL on top of staged data which could be easily consumed while visualizing the insights derived.- Developed an end to end reporting solution using Microsoft SQL Server, SSIS, SSAS, and Excel for a Fortune 500 client which enabled them to double retail sales of tablet devices across the North American continent within a semester.- Developed an automated data validation framework which has been adopted by 50+ projects company-wide.

Bachelor Of Engineering (Be), Computer Science

Higher Secondary Certificate, Information Technology

Seconday School Certificate