About

Viresh Patel is a highly experienced VP of Data Engineering at Blackstone with over 9 years of relevant experience. He has extensive knowledge in database design, development, and maintenance of database applications on SQL Server, Oracle, MySQL, Amazon Redshift, and Snowflake in OLAP/BI environment. Viresh has developed ingestion pipelines and data analysis systems and provided technical expertise while creating software design proposals for upcoming components. He is an expert in developing SSIS Packages to extract, transform and load (ETL)/DTS data into the data warehouse database from heterogeneous databases and in developing Talend ETL Jobs and deploy jobs on Linux ETL servers. Viresh has high proficiency in using ETL tools such as SSIS, Talend, and experience in creating jobs, SQL Mail Agent, Alerts, and schedule SSIS Packages, Schedule Talend Jobs using crontab. He has created Scalar Python and SQL Functions in Amazon Redshift to clean the data and Python scripts to pull the data from different APIs and created CSV, JSON format data, and loaded into the warehouse. Viresh has also created Python, Pyspark scripts to process the data from CSVs and automated ETL jobs. In addition, Viresh has experience in building and publishing customized interactive reports and dashboards, report scheduling using Tableau server and Tableau Online. He has created Tableau workbooks for Data Alerts, Job Execution Logs, and developed Tableau workbooks from multiple data sources using Data Blending. Viresh has strong experience as a lead Developer and in guiding team efforts to meet objectives. He is proficient in working closely with system/network administrators, developers, and end-users. Viresh has strong interpersonal skills and is equally adept at documentation. He is highly motivated and passionate about working in a challenging environment. Viresh is an expert in adapting to various environments and situations and has strong organizational and management skills. Before joining Blackstone, Viresh worked as a Senior Data Engineer at William Hill and as a Data Engineer at Execonline, Inc. where he built and developed ingestion and ETL pipelines to bring the business-critical survey data into the data warehouse using Talend ETL. He also designed tables and created ETL procedures to process data from various sources and created cron jobs to schedule the Talend ETL bash scripts. Viresh has a Master's degree in Electrical, Electronics, and Communications Engineering from New Jersey Institute of Technology and a Bachelor's Degree in Electrical, Electronic and