Viresh Patel Email & Phone Number

New York, Ny, Us

New York, Ny, Us

London, England, Gb

• 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

New York, New York, Us

• 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

Atlanta, Ga, Us

• 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.

Seattle, Washington, Us

• 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.

London, London, Gb

• 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.

Master'S Degree, Electrical, Electronics And Communications Engineering

Bachelor’S Degree, Electrical, Electronic And Communications Engineering Technology/Technician

Gsheb, Science