Sign in

Data Engineer

Oak Ridge, TN
February 24, 2020

Contact this candidate


Hitendra Parmar

*** ****** ***** **, *** Ridge, TN 37830 ● Phone: 865-***-**** ● email: QUALIFICATIONS SUMMARY

Multi-Cultural Experience Data Analytics Process/Performance Improvement Team Leadership & Development Database Management Relationship Management Cross Functional Experience Technology Integration Adaptability EDUCATION

University of Tennessee, Haslam College of Business, Knoxville, TN December 2018 Master of Science, Business Analytics

Vellore Institute of Technology, TN, India May 2015 Bachelor of Technology, Computer Science and Engineering PROFESSIONAL EXPERIENCE

Pilot Flying J, Knoxville, TN March 2019 – October 2019 Data Engineer

• Developed and maintained database architectures for fuel delivery system that included dispatch of fuel from terminals to B2B and B2C lines of businesses

• Constructed SQL tables in Netezza to transform data from source systems to ETL tables, easily accessible by Business Intelligence teams including Data Scientists and Data Analysts

• Created scheduling processes in ActiveBatch for Dimension and Fact tables to sync with production data based on business requirements

• Worked closely with DBA team and developers to resolve performance and operational issues as well as on-call support to handle failures in transforms or sync processes

• Collaborated closely with Data Analysts to incorporate business requirements in a bi-weekly sprint planning

• Refined and improved data transforms regularly to enhance speed and performance of tables with large amounts of data

Team Health, Knoxville, TN May 2018 – August 2018

Data Analytics Intern

• Designed forecasting models using R to assess the cost of recruiting doctors by performing in-depth analysis of internal variables including patient volume and physician work schedules, along with external census variables

• Spearheaded study of accounting units that reduced costs by about 15% by incorporating new methods like time series factor, changing forecasting techniques and finding good performing units from 140 to observe their patterns that transformed the way other units preformed

• Delivered weekly presentations to leadership sharing key findings and analyses of different accounting units

• Monitored data feeding into the dashboards Data Analysts use to make informed business decisions Infosys, Pune, India July 2015 – June 2017

Data Warehouse Tester, Software Testing

• Extensive experience in performing end-to-end testing activities for a large Australian telecom service provider with project experience using Comptel Fulfillment 8 suite

• Conducted simulations using SQL and IBM RQM to plan and execute test cases for product delivery

• Proficient in all phases of Software Testing Life Cycle (STLC) including composing test scenarios and test cases in Excel based on design documents, test data setup, test case execution, and bug reporting

• Mentored a team of 4 by overseeing their business requirement analysis training and performance on STLC

• Diagnosed defects restricting each project release using IBM RTC, by working closely with other teams and mediating potential disputes with them for better communication and coordination OTHER EXPERIENCE

The University of Tennessee, Knoxville, TN August 2017 – January 2018 Graduate Research Assistant, Haslam College of Business

• Researched online job postings to conduct comprehensive research of industry requirements

• Consolidated research by finding 100-120 relevant jobs per week to help tailor academic course content Tech Mahindra, Noida, UP, India May 2013 – July 2013 Industrial Intern

• Managed database records, monitored database performance, and resolved discrepancies using C++ on the project

‘Faculty Selection Register’ to maintain faculty records at the training institute branch of Tech Mahindra

• Demonstrated interpersonal skills by regularly collaborating with a group of 25 interns Capstone project for Georgia-Pacific that provided data analysis and consulting services to assist the company with optimizing forecasting models August 2018 – December 2018 SKILLS

Technical: SQL, Python, R, NoSQL, Tableau, AWS, Informatica, ActiveBatch, JMP, AMPL, PuTTY, VBA, Excel Solver, SAS Languages: English, Hindi

Contact this candidate