Swarnim Jambhule

M.S in Management Information System with nearly 4 years of industry experience, expertise in Data Engineering, Analysis.

Contact: +1-669-***-**** Email: adzklj@r.postjobfree.com Location: San Bernardino, California

: https://www.linkedin.com/in/swarnim-jambhule-b501ab214

WORK HISTORY:

Pacific Gas and Electric (PG&E), SF, California. (Contract basis) Job Title: Data Engineer Feb 2021 -Present

Job roles and responsibility:

•Built a pipeline monitoring system that alerts user via phone call and email when the error occurs withing a pipeline which is build outside the company’s infrastructure using AWS, Elastic Search with the help of Rest API call scripted in Python.

•Worked on Various query on daily basis using query language like SQL, DSL and Pyspark for building pipelines.

•Troubleshooted Foundry issues of the data and analytics team, we are first team to be contacted if anything needs to be requested or needs to be troubleshoot an error and/or there is any product bug.

•AWS-optimization brought the cost of AWS bills by 22% in first quarter and followed by 15% in second quarter.

•Performed cleaning data (data wrangling) from a variety of different sources; assembling disparate datasets into a tidy format that can be easily used for analytics and visualizations.

•Involved in converting Hive/SQL queries into Spark transformations using Spark RDDs, Scala.

•Supported Wildfire (EOC) team which helps with wildfire emergencies in California making sure data availability and data accuracy at the most critical time.

Company: TCTS, MH, India. (Fulltime) Job Title: Service Executive Dec 2015 - July 2018

Job roles and responsibility:

•Worked with client to understand business needs and translate those business needs into actionable reports in Tableau, saving 18 hours of manual work each week.

•Prepared and presented reports, analysis and presentation to various stakeholder including Executives.

•Identified low hanging fruits (clients) and focused on them to achieve level-3 targets which profited company by around $80000.

•Well versed with the Database and Data Warehouse concepts like OLTP, OLAP, Star Schema, SQL.

•Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information through dashboard.

•Responsible for migrating Teradata tables (Millions of records) into Cloud using AWS Platform.

EDUCATION:

Engineering in Electronics & Telecommunication, MESCOE, PUNE. Aug 2011 – May 2015

MS in Management Information Systems, California State University, Los Angeles. Aug 2018 – May 2020

SKILLS:

•Language: SQL, DSL, PL/SQL, Python, Query.

•Cloud services – AWS (Lambda, Redshift, EC2, EMR, S3).

•HDFS, MapReduce, Hive, Pig, Yarn, Apache Spark

•Visualization tools: Tableau, Power BI.

•Linux/UNIX Commands, Bash commands.

•Others: Palantri Foundry, Elastic search.

CERTIFICATION AND TRANING:

• Hadoop Data Access (IBM), Big Data Analytics with Hadoop and Apache Spark Dec-2018

•Advanced SQL for Query Tuning and Performance Feb-2019

•Python essential training Sept-2018

•Spark Optimization (LinkedIn learning). June-2019

•Spark for Machine learning and AI. Oct- 2019

Contact this candidate