Viresh Patel

Experience

• 

  MEC

  Mar 2014 - Jun 2014

  SQL Developer

  • Installed SQL Server PDW, VS 2012 Ultimate, PDW drivers into a local desktop to integrate the PDW with VS SSIS. • Created template packages for incoming sample ad files from different vendors. • Created client based solutions using the base and reference package strategy. • Created the ETL process to load the daily incoming ad files from network directory to the parallel data warehouse. • Work on data acquisition process to automate data from cloud and FTP.• Created audit and logging table structure into SQL server to populate log entries for files into tables.• Work on DataMart to keep track of all files loaded into PDW.• Created SQL Agent jobs to run the process on schedule base using SQL Agent proxy account.• Work on deployment to Deploy solution on SSISDB in SQL 2012. • Created dev and prod environments in integration catalog service to map the SSIS packages. Show less

• 

  Avanade

  Jul 2014 - Feb 2016

  Solution Developer

  • Design, develop, revise, and maintain custom SSRS reports for the desktop migration project.• Gather and translate business requirements into report designs for application life cycle and user migration to new machines.• Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports• Generate ad-hoc reports as needed which helped the project manager to track the user migration to new windows machine • Provide reporting to customers and management to support business decisions and become more proficient in the use of the application• Communicate with team members to assess the progress of deliverables.• Examine, evaluate, and develop reporting requirements for various business units develop reports and reporting structures as required• Communicate reporting changes, enhancements, and modifications verbally or through written documentation to management and other team members• Work with other reporting team members to generate new reports and deliver them, get recommendations, or alternatives for improving processes in reporting systems across the organization• Work on the subscription to deliver the reports on Daily, weekly with different formats. • Created the logging and auditing report that help the internal team to monitor how the users using the reports. Show less

• 

  Cox Automotive Inc.

  Feb 2016 - Feb 2018

  Senior Data Engineer

  • Analyzed, understand, and documented user needs to ensure accurate fulfillment of user story requests from internal business customers.• Contributed, and lead, project scrum team that were developing or modifying highly complex information solutions.• Designed and architect the EDW model for Credit Application. • Administers & maintains the BI Portal, data warehouse, and existing BI solutions.• Created logging and auditing reports for visualization of the daily jobs and created subscription to email so that team member visually check the daily job execution flow. • Created Python scripts to pull the data from JIRA APIs and load them into Data Warehouse. • Arranged and delivered training sessions for BI processes and Hadoop.• Mentoring teammates on BI tools and methods.• Continuously developing expertise in the data and data models within the data warehouse, as well as an understanding of supported business domains.• Continuously developing an understanding of Business Intelligence technology and architecture, including data warehousing, dimensional modeling, OLAP functionality, reporting tools, and other methods of information delivery. Show less

• 

  ExecOnline

  Feb 2018 - Nov 2019

  Data Engineer

  • Build and developed ingestion and ETL pipelines to bring the business critical survey data into data warehouse using Talend ETL• Designed Tables and created ETL procedures to process data from various sources • Created Cron jobs to schedule the Talend ETL bash scripts• Worked on multiple projects to cleanse the data using Python UDF• Created Python Ingestion pipelines to invoke APIs and import the data from Marketo, FullStory, Google Analytics• Initiated project on building the real time analytics using Snowflake Snowpipe in Production environment• Support and Maintained Data warehouse Infrastructure • Build Ad hoc reports to monitor and notify the ETL jobs• Build Tableau Reports for product team to get insight on platform and participant performance• Worked closely with Data Analysts and Data Scientists to build the reports to get insight on participant engagement activity Show less

• 

  William Hill

  Nov 2019 - Apr 2021

  Senior Data Engineer

  • Worked with Offshore Team to build the Ingestion pipeline to process data from API and Apache Kafka• Created Airflow Dags to scheduled the Ingestions and ETL jobs• Supported Production Environment and debug issues using splunk logs• On call support for production job failures and lead the effort on working with variaous teams to resolve the issues• Build CI/CD pipelines to automate the deployment and task• Build Docker Images to run airflow on local environment to test the Ingestion as well as ETL pipelines• Worked on Architecture Design for Multistate • Generated CSV reports for regulatory and finance team to get insight on betting transactions and various different KPIs Show less

• 

  Blackstone

  Apr 2021 - now

  VP, Data Platform Engineering