Rohit Chavan Email & Phone Number

I am a Data Engineer at JPMorgan Chase & Co. and a Master of Science in Data Science candidate at Pace University. I have over five years of experience in building data pipelines, web-scraping, data cleaning, data analysis, and data visualization for various industries and domains. My core competencies include Data Science, PySpark, and Data Architects.In my current role, I create process maps and decision trees to optimize and find inconsistencies in financial metrics, such as cost, profit, demand, etc. I also implement automation algorithms using SAS and SQL to process large volumes of data from different sources. I work with a team of data engineers and analysts to identify and address root causes for negative profitability in the supply chain, leading to a 15% increase in overall profitability. I am motivated by the challenge of solving complex problems with data and delivering value to the business. I bring diverse perspectives and experiences to the team, as I have previously worked as a Data Engineer at BrainByte Infotech, where I built real-time data pipelines using Kafka and Spark, extracted data from HTML and XML files by web-scraping, performed exploratory data analysis and advanced analytics with Python and Tableau, and reduced data pre-processing time by 25%.

• 

  Data Engineer

  Jpmorgan Chase & Co.

  Aug 2022 - Present

  - Created process maps and decision trees to map logic for optimizing and finding inconsistencies in financial metrics, such as cost, profit, demand, etc.- Identified and addressed root causes for negative profitability in the supply chain, leading to a 15% increase in overall profitability.- Implemented automation algorithms using SAS from process map logic utilizing historical big data, paving way for processing of almost million parts per day rather than the usual 2-3 parts manual inspection per day.- Implemented text file database on shared drives, importing data from DB2 mainframe tables and Teradata tables, for a subdivision in Caterpillar using SQL via SAS, IBM QMF, Teradata, and Microsoft Access.- Used custom SQL and calculated fields in Tableau to create financial dashboards and other visualizations from connections to remote DB2, Teradata tables.- Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart, and refresh strategies.- Design and development of different data models according to user specifications in the development of databases for small applications.- Used Kafka producer to ingest the raw data into Kafka topics run the Spark Streaming app to process clickstream events.- Implemented a text file database on shared drives, accommodating a diverse set of data types and sources, resulting in a 30% improvement in data retrieval efficiency.- Designed and implemented time series forecasting models for estimating server provisioning on the cloud environment which resulted in accurate demand forecasting for cost optimization and budgeting.- Implemented Agile Scrum methodology, leading to a 15% reduction in software development life cycle durations and faster delivery of quantitative value-driven features.

• 

  Pace University