Ashim Singh Chadha

Email: adg20w@r.postjobfree.com Phone: +1-412-***-**** LinkedIn

EDUCATION

Carnegie Mellon University, Heinz College of Information Systems and Public Policy, Pittsburgh, PA Dec 2019 Master of Information Systems Management, Business Intelligence and Data Analytics, GPA- 3.64 Relevant Coursework

• Machine Learning, Unstructured Data Analytics, Advanced Business Analytics, Practical Data Science, Decision Making Under Uncertainty, Digital Transformation, Database Management, Deep Learning for Information Systems, Distributed Systems Dwarkadas J. Sanghvi College of Engineering, University of Mumbai, India May 2018 Bachelor of Engineering in Information Technology (Distinction), GPA- 3.65 WORK EXPERIENCE

Data Engineer City of Pittsburgh June 2020 – Present

• Working with several APIs related to the city of Pittsburgh to produce robust ETL pipelines and translating legacy code to python for better compatibility and simplicity.

• Analyzing and visualizing results related to several domains to optimize resource allocation. Senior Consultant Headstorm March 2020 – June 2020

• Partnered with a leading fitness company, based in 1000+ locations, to develop an ETL pipeline of their consumer data, thereby enabling analysis to prevent customer churn.

• Extensively used Amazon Athena, Glue and S3 for uploading source files, querying them and running periodic jobs, per client requirements.

• Followed flexible agile methodology with a focus on extensive documentation. Worked closely with data scientists to build tables pertaining to specific business requirements. Data Science Intern Federated Investors June 2019 – August 2019

• Created several models to derive actionable insights for maximizing client acquisition and retention. Identified high value customer segments of $1M+ for the organization.

• End to end project included consolidating billions of raw records, feature engineering, model generation and data visualization.

• Used and mastered Microsoft Azure, Databricks, Apache Pyspark and Tableau. Data Analyst Intern Radiowalla Network Pvt. Ltd. June 2017 - August 2017

• Hands-on experience working with the Data Analytics team as part of a project on improving efficiencies in mall retail based on understanding customer demographics.

• Developed an age & income relation model for optimizing predictability analysis in purchase decision making by using statistical concepts like linear regression and maximum likelihood estimation. Data Analyst Intern Juneja Global June 2015 - August 2016

• Worked as part of an overall project on devising strategies for more effective positioning of one of the largest Indian sportswear brand, “Black Panther”, to compete more effectively with the best global sports brands.

• Analyzed data relating to customer preferences with special emphasis on psychological compulsions influencing choices in favor of international sports brands over homegrown ones.

• Built SQL scripts to access, insert and update records. Optimized queries and data structures to maximize speed.

• Generated views, functions and tables to meet business needs. SKILLS

Programming: Python, Apache Pyspark, Java, C, SQL, HTML5, CSS3, JavaScript, Solidity, Hadoop MapReduce, Spark Tools and Libraries: Pytorch, Keras, Numpy, Pandas, Tableau, Oracle, MySQL, Azure, Databricks, Redis, MongoDB, Neo4j, AWS Glue, Amazon S3, Amazon Athena, Confluence, Jira, Docker, Django, Airflow, Google Cloud Storage Processes: Exploratory Data Analysis & Wrangling, Time Series Analysis, Modeling, Visualization ACADEMIC PROJECTS

Data Steelers

• Created a desktop-based application using Python to provide analysis on NFL related data.

• Scraped data from various NFL related websites and subsequently processed it to carry out three kinds of analysis - historical performance analysis, betting strategy analysis, and sentiment analysis on tweets.

• Used concepts from the Modern Portfolio Theory to develop the betting strategy analysis. LoyaltyOne- Air Miles Student Consultant

• Used the dataset provided by LoyaltyOne to assist in guiding strategic partners by identifying high-value customers to target with Air Miles (one of Canada’s largest loyalty programs).

• Created a model to identify the top subset of customers to target with promotions to maximize true lift.

• Carried out exploratory data analysis, feature engineering and modelling using Databricks and pyspark. Decentralized data storage using Blockchain

• Developed method to store a user’s data on the machine of another user willing to rent out excess storage space on a contract basis, earning a nominal amount for storage space rented out.

• Data stored is encrypted to prevent unauthorized access; multiple redundant copies stored for 24/7 data availability.