Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Vivek Gorley

Vivek Gorley

Lincoln,Nebraska

Summary

A self motivated Senior Data Engineer with data-driven and technology-focused approach. Demonstrated success in identifying relationships and building solutions to business problems. Love to solve complex problems and use data to make decisions and add value to lives of people.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

Rocket Mortgage
06.2022 - Current
  • Built a one stop application for all metrics needed to track the performance of the company and help the teams evaluate their performance using a customizable dashboard application
  • Built a data warehouse solution to house the silo source systems to create a relationship among the sources and build metrics on top of them to identify the opportunities for improvements
  • Mentored junior developers on data warehousing best practices
  • Redesigned and Optimized the ETL process for a more efficient and standardized system using AWS Glue and Redshift resulting in 20% time savings, more efficient design
  • Collaborated with other internal teams to understand the source systems, other best practices to gather data and to understand the data for opportunities to build insights for end users.

Senior ETL Engineer

Nebraska Department of Education(Contract)
11.2018 - 06.2022
  • Collaborated and engineered the NEP data warehouse solution to overhaul the legacy reporting process to a more optimal solution using MS Azure technologies
  • This is to enable faster query results by 20% and enforcing data compliance regulation as per the State regulations
  • Acted as a technical expert for data modeling and data architecture solutions
  • Redesigned the ETL process for a more efficient and standardized system using DataStage resulting in 30%-time savings of the overall process
  • Collaborated with other internal and external teams to drive continuous improvements in quality and processes, including documentation of the processes to conform to State regulations.

Business Intelligence Consultant

Deloitte Consulting LLP
12.2015 - 11.2018
  • Lead a team for delivering 5 critical reports for clients from requirement gathering to post deployment support on strict deadlines ensuring completion of the complete project in time
  • Collaborated and engineered with 5 other teams for the re-designing of the database for building the new reports leading to performance gains of 20% user query retrieval time
  • Resolved conflicts with the clients on the requirements and implementation of the critical reports and provided support to the client for the smooth testing and approvals of the changes
  • This ensured the deadlines of the project were met
  • Guided and gave inputs to the team for database design and ETL design for implementing the auditing changes for the compliance feature of the requirement.

Business Intelligence Consultant

Tata Consultancy Services Ltd
07.2008 - 12.2015
  • Lead a team of 4, including a team at offshore, for development and support of Business Intelligence reports to facilitate the end clients to analyze the various metrics for the performance of their products
  • Developed and implemented a data governance process for providing access to the power users as per the audit and compliance regulations
  • Supported the clients to help them understand the data and gain additional insight from the data.

Education

Bachelor of Technology Information Technology - Information Technology

Odisha University of Technology And Research
Bhubaneswar
2008

Skills

  • Data Warehousing
  • API Development
  • ETL Development: Glue, Airflow, IBM DataStage, MS SSIS
  • Programming: Python, Typescript, Unix shell scripting
  • Framework: Angular, Nodejs, Nestjs
  • Data Modeling
  • Data Integration
  • Database Management: AWS Redshift, AWS RDS, PostgreSQL, MS SQL Server, MySQL, Oracle
  • Data Visualization: Power BI, D3
  • Methodology: DevOps, Agile, ServiceNow
  • Team Leadership
  • Continuous Integration
  • Data Pipeline Design

Certification

  • Azure Data Engineer Associate
  • AWS Certified Developer Associate
  • AWS Certified Data Analytics Specialty
  • IBM Infosphere DataStage V9.1, V8.5 certified

Timeline

Senior Data Engineer

Rocket Mortgage
06.2022 - Current

Senior ETL Engineer

Nebraska Department of Education(Contract)
11.2018 - 06.2022

Business Intelligence Consultant

Deloitte Consulting LLP
12.2015 - 11.2018

Business Intelligence Consultant

Tata Consultancy Services Ltd
07.2008 - 12.2015

Bachelor of Technology Information Technology - Information Technology

Odisha University of Technology And Research

Similar Profiles

CREATE PROFILE
Vivek Gorley