Data Engineer/Analyst

Sarvesh Gohil

1-551-***-**** • Jersey City, NJ, *7307 • ******@*******.*** • github • linkedin

Experienced data analyst professional with strong analytical skills and expertise in business intelligence, data engineering, automation, and application design and deployment. Proficient in Python, R, SQL, Tableau, and Predictive Analytics. EDUCATION

Stevens Institute of Technology, Hoboken, NJ May 2020 Master of Science in Business Intelligence and Analytics (GPA: 3.84) Coursework: Data Analytics & Machine Learning, Big Data Technologies, Practicum in Analytics, Data Warehousing and Business Intelligence, Web Mining, Optimization and Proc. Analysis, Knowledge Discovery & Data Mining Dwarkadas J. Sanghvi College of Engineering, University of Mumbai, India May 2017 Bachelor of Engineering in Computer Engineering

SKILLS

Professional competencies: Problem Solving, Data Analytics, Project Management, Leadership, Automation Tools and Technologies: Python (sklearn, numpy, pandas, matplotlib, seaborn, flask, django, pickle, joblib), R, SQL, PL/SQL, SAS, MS-Excel (VBA, VLookup, HLookup, Pivot Tables, Macros), IBM DataStage, DataBricks, Tableau, Power BI Databases: MySQL, Oracle SQL, Microsoft SQL Server, HiveQL, PostgreSQL Cloud Technologies: AWS (EC2, S3, Redshift, Glue, Athena, Kinesis, EMR, RDS, Lambda), Snowflake Big Data Technologies: Hadoop (HDFS, Spark, Hive, MapReduce, Impala, Hbase) Analytical Skills: Data Cleaning, Data Wrangling, Data Mining, Data Visualization, Exploratory Data Analysis, Linear and Logistic Regression, Naïve Bayes, ANOVA, Clustering, Neural Networks, Decision Trees, Random Forests, SVM, Recommender Systems, A/B testing, Dimension Reduction, Forecasting, Time Series, Marketing Analytics PROFESSIONAL EXPERIENCE

Stevens Institute of Technology, Hoboken, US

Designation: Data Engineer/Analyst Feb 2020 - Present

• Devised a reconciliation system for School of Business using Python to help in reporting missing entries and automated the Database Update Process using complex SQL queries, decreasing manual labour by 10 hours a week

• Developed student roster in MS-Access by building common repository for School of Business, assisting the management to help students get jobs during corporate engagements

• Designed dashboards in Power BI for generating and analyzing insights (related to employment reports, admission scores etc) thus aiding Program Director and management in making decisions for incoming students and future graduates Dotminds, Mumbai, India

Designation: Data Engineer/Analyst May 2019 - Jan 2020

• Extracted data from various sources(APIs, OracleDB, CSV, JSON) and conducted data cleaning, manipulation, and analysis of large datasets(in distributed system) to assist in producing insights and drive key business decisions for stakeholders

• Formulated solutions to help clients migrate from traditional on-premises data warehouse and reporting platforms to cloud based solutions on AWS and further developed serverless ETL pipeline, reducing costs by 70 percent

• Performed customer segmentation and drove integration of these segments into product marketing strategy and thus redistributed marketing campaigns on various platforms, cutting down the marketing cost by 15 percent

• Automated data pipelines for ETL from multiple sources, transformed using AWS Lambda, loaded to AWS Redshift, analyzed on AWS EMR with Spark and Hive, and created sales predictive model and built dashboards/reports for a client Aristron Weighing Machine and Systems, Mumbai, India Designation: Business/Data Analyst June 2015 - Aug 2016

• Provided various stats and actionable insights by leveraging data from disparate data sources using ETL/BI tools for discovering opportunities in customer acquisition and retention, customer value management & product development.

• Prepared interactive dashboard on Tableau to display key metrics every month reducing manual labour by 12 hours a month Raj Computers Academy, Mumbai, India

Designation: Assistant Professor June 2017 - July 2018

• Taught courses such as SQL, Python and Advanced Excel, and helped in updating exercise problems which aided students to get better grasp over the programming language

• Mentored the students on one-on-one basis which resulted in improvement of grades by 25% PROJECTS

• Customer churn prediction: Deployed various machine learning algorithms on large amount of data collected from various sources and developed a model to predict customer churn rate. Employed customer segmentation to identify unsatisfied customers and generated visualizations to identify customer pain points and investigate into potential issues

• Loan Default prediction: Deployed machine learning model on AWS utilizing flask framework to accept the details of the person applying for loan from a webpage, process it using pickle object in the backend created for best performing model and return the prediction back to display it on the webpage stating if the particular person is eligible for the loan

Contact this candidate