Shyam Patel Email & Phone Number

Jodhpur, Rj, In

Gurugram, Haryana, India

• Collaborate with business stakeholders to gather requirements for automating reports.• Write logic using PySpark and SQL to perform join operations on CSV files in Azure Databricks, derive additional columns, and save data in Parquet format.• Create Synapse external tables for Power BI developers to support reporting needs.• Monitor and troubleshoot pipelines to ensure smooth operations and support Team Lead in project management.

Bengaluru, Karnataka, India

• I worked as a Azure Data Engineer at Lipman Family Farms. In this role, my responsibilities include analyzing source data, bringing it to Azure Synapse in ADLS Gen 2 in delta form, Create external tables using Serverless SQL and run pipelines to refresh the data.• Developed a high-performance ELT pipeline for data ingestion using Python and Cassandra as the source database, and MySQL as the destination. Multithreading was utilized to ensure rapid data processing and load… Show more • I worked as a Azure Data Engineer at Lipman Family Farms. In this role, my responsibilities include analyzing source data, bringing it to Azure Synapse in ADLS Gen 2 in delta form, Create external tables using Serverless SQL and run pipelines to refresh the data.• Developed a high-performance ELT pipeline for data ingestion using Python and Cassandra as the source database, and MySQL as the destination. Multithreading was utilized to ensure rapid data processing and load times.• Leveraged the power of TensorFlow.js to create an innovative web application for object detection, deployed on AWS with the help of a Sagemaker endpoint, Lambda function, and API Gateway. The application provided fast, accurate, and reliable object detection capabilities for users.• Utilized cutting-edge technologies to build a comprehensive email classification project that included multi-class classification and seamless integration with Gmail. The project intelligently classified incoming emails into 5 different departments and automatically routed them to the correct email addresses. To simplify project management, a custom web application was developed that enabled easy.• Developed an innovative Model Validation Engine python package that offers a comprehensive suite of validation techniques and easy integration with popular libraries such as sklearn, matplotlib, seaborn, and Flask. The package includes an extensive range of functions such as holdout train/test split, k_fold, stratified k fold, and repeated random train-test split, all aimed at simplifying the model validation process in the form of functions and UI.• Developed a highly efficient ELT pipeline that enables Salesforce developers to transfer critical files from on-premise disks to an AWS S3 bucket with ease. By extracting file names and paths from a SQL Server database, this pipeline ensures that all files are accurately and efficiently transferred, saving developers valuable time and resources. Show less

Mumbai, Maharashtra, India

• Conducted thorough research on expired domains to identify their concept and potential value for online advertising.• Conducted extensive keyword research to identify relevant high cpc keywords for each domain, and mapped them to the domains' content to optimize ad placement and increase ad revenue for clients.• Continuously monitored ad performance and analyzed expired domains that were already mapped to determine if visitors were clicking on keywords. Adjusted keyword… Show more • Conducted thorough research on expired domains to identify their concept and potential value for online advertising.• Conducted extensive keyword research to identify relevant high cpc keywords for each domain, and mapped them to the domains' content to optimize ad placement and increase ad revenue for clients.• Continuously monitored ad performance and analyzed expired domains that were already mapped to determine if visitors were clicking on keywords. Adjusted keyword strategies accordingly to increase click-through rates.• Generated daily reports for team lead, including total mapped expired domains and investigations into the previous day's work to ensure all expired domains were properly reflected with their mapped keywords.• Conducted analysis on various accounts to track revenue and ensure that no account was going in loss. Developed strategies to optimize ad placement for these accounts and increase their revenue.• Utilized keyword trends analysis to select keywords with high possibility of getting clicks to attract visitors to mapped domains. Show less

Bachelor Of Science - Bs, Information Technology, 2.88/4

Activities and Societies: Malhar Fest, Technomad, Social activities, Tech events

Postgraduate Degree, Full Stack Data Science

Activities and Societies: Python and Data Science Challenges, Classroom Training, Workshops • Utilized advanced concepts in Python.

Postgraduate Degree, Data Science Masters Program

Activities and Societies: Tech Talks, Hackathons, Webinars • Develop an in-depth understanding of data science methods in predictive.