Aayush Bhardwaj Email & Phone Number

Seattle, Wa, Us

Technologies Used: AWS, Python, SQL, ETL, Data Modeling, PySpark, GIT, Data Architecture, Data Warehouse, Database Management, Apache Airflow, S3, Glue, Redshift, Athena, Firehose, Kinesis Streams, Batch and Real Time data processing systems, SQS, SNS, Lambda, Data Analytics, Business Intelligence, NetworkX, Graph, CDK, CI/CD, Data Pipelines, Data Lineage, Leadership, Data Security, Testing, Debugging, Requirement Gathering, Requirement Analysis, Scoping, Design, HLD, LLD, AGILE, Data Visualization, Reporting

New York, Ny, Us

Applied AI/ML EngineerTechnologies Used: Python, SQL, AWS, Flask API, Machine Learning, NLP, Apache Spark, ETL, Greenplum, AGILE, Natural Language Processing, Neural Networks, Elastic Search, Kibana, Hadoop, Hive- Designed scalable ETL data pipelines, supported Data Scientists for training/testing of ML models in production.- Extracted and Transformed (~Millions) records from Hive/Greenplum database using Apache Spark. Used advanced analytic SQL functions and queries and extracted/aggregated data from multiple tables.- Developed a FastText/BERT word embeddings-based NLP model for efficient retrieval on source code; Deployed Flask APIs on Amazon EC2, automated the CI/CD pipeline using Auto Scaling Groups, S3, CodeDeploy bash scripts. Used NLP techniques, NLTK, word embeddings and FAISS (Facebook AI Similarity Search) library.- Worked in a team of 10, Analyzed Unstructured Text data (feedback given by Chase bank customers:calls/emails/surveys) for various chase products [entity] and its theme (good/bad features about that product) [issues]. -- Developed a scalable multi-class classification model for Digital Payments team. Classified customer text feedback/call notes into 21 products and 148 sub-themes using Neural Networks, NLP techniques: accuracy of 82.38%.- Utilized ML and Active Learning techniques, developed a reusable API and a smart data labeling tool. Reduced time taken to gather a large labelled data set necessary for Supervised machine learning problems.- Extracted and Transformed JPMC Employee data, loaded this data in Elastic Search to develop an AI-powered people search directory. Automated this data pipeline.- Analyzed FDIC (Federal Deposit Insurance Corporation) data set, using Python, Elastic Search and Kibana. Plotted city/zip code where annual deposits have increased/decreased over years.- Developed a time-forecasting model, using ARIMA and identified servers likely to fail 90 days in advance.

Bentonville, Arkansas, Us

Software Engineer - IITechnologies Used: Microsoft Azure, Apache Spark, Databricks, PySpark, SQL, Java, SparkSQL, Azure SQL Data Warehouse, Azure SQL Database, Azure Data Factory, Apache Airflow, BTEQ, Azure Data lake, DB2, Teradata, AGILE, Hadoop, Scala, Tableau- Data Engineer (Software Engineer - II) with Sams Club (Walmart). - Helped Pricing team make real time pricing decisions, analyzing the competitor pricing data thereby helped the business team stay a step ahead of the competitor.- Developed/maintained ETL data pipelines; helped cross-functional teams, provided essential insights from the data.- Transformed competitor data with Databricks, PySpark, Scala, Spark SQL, Microsoft Azure and Azure Data Lake.- Automated the ETL process, used Azure Data factory to orchestrate between Azure Data Lake, DB2/Teradata/Blob storage.- Migrated large database tables (~2 Billion rows) from Teradata to Azure SQL Data warehouse: executed BTEQ scripts on Hadoop edge-node-->Azure Blob Storage-->Azure SQL Data warehouse (using Azure Data factory).- Wrote optimum SQL queries and aggregated tables (of the order of billion rows), from daily to weekly/monthly level, joined several tables, created Indexes to improve query performance. - helped in migrating a single Hadoop edge-node (shell script/cron tabs) based infrastructure to a more scalable and reliable Apache Spark based solution using Apache Airflow.

Us

• Worked with the Marketing and Engagement team of the Pittsburgh Penguins (the Pens, from NHL).• Performed Sentiment Analysis and Topic Modelling on over 2M tweets in Python, developed a predictive model.• Analyzed their social media presence and audience engagement using Kairos, Brandwatch, and Audience.ai.• Suggested recommendations after assessment of different content types that lead to higher engagement.Technologies used: Python, R, MS Excel

Graduate Research Assistant at the PeeX (Privacy Economics and Experiments) LabTechnologies used: Python, R, SQL• Processed and parsed Facebook user profiles (JSON) data set using Python, pandas and pushed the data in a MySQL database.• Analyzed user preferences, based on information disclosed overtime with Facebook’s changing privacy policy

Pittsburgh, Pa, Us

• Graduate Teaching Assistant of "Programming R for Analytics" (with Professor Constantine Cois).• Assisted Professor in reinforcing the lessons by holding weekly office hours to review the material with students. • Graded Labs and Assignments and aided Professor in keeping records, such as calculating grades.

Chicago, Illinois, Us

Technologies used: Python, R, NLP, ML, Neural Networks, LSTM, MS Excel• Won “Top-6 Project Team 2017” award for excellent work.• Collaborated in a team of seven, along with the Portfolio Risk Forum group of a Fortune 50 pharmaceutical firm.• Analyzed and predicted risks associated with Timeline shifts and Cycle Times variation in drug industry.• Performed Text Mining, Sentiment Analysis, trained a Deep Neural network and developed a predictive algorithm.• Predicted the duration of projects and hence delays.• Recommended which projects to pursue and which to suspend to improve the financial standings of our client.• Our work is projected to save over US$ 10 million annually for our client who have an annual revenue of US$ 5 billion for pharmaceutical research.

Pittsburgh, Pa, Us

Aim: To enhance CMU in Australia’s Marketing teams CRM system (Radius) by allowing 3rd party information systems to push data into CMU-A's Radius “cloud based service” using web services. - Developed a CMU-Australia “Radius” bridge-web-services that exposes web services for 3rd party information systems to push JSON format data in. Then posts data to existing Radius web services. - This bridge-web-services application involved use of a verity of programming languages and frameworks such as mysql, RESTful API, JSON Data and object oriented programming skills hosted on CMU’s internal servers in Australia. - Git Work Flows for the project team’s sources code management system.Outcome:This developed application and web-services eased up the interaction between 3rd party CRM systems and Prospective-Student-Management-Systems with our Radius CRM system. These services automated the information capture and retention by CMU-A's student-recruitment-agents into CMU-A's systems without human errors and enabled CMU Australia to timely respond to prospective students.

Boston, Ma, Us

> Worked on multiple web development projects for a Peru based client, became adept to technologies such as ASP.NET MVC, C#, jQuery, Ajax, MSSQL etc.> Worked on Microsoft Web API based projects, worked on ASP.NET Web API 2.0. I worked from client location. This project involved daily client interaction, requirement gathering and analysis. I developed many critical APIs which handled huge database transactions involving complex operations.

Boston, Ma, Us

> Got introduced to web development working in Microsoft .NET technologies such as C#, ASP.NET, MSSQL database.> I worked on a ASP.NET winforms and XML based windows desktop application. > I also worked on a web based project involving ASP.NET, jQuery, Ajax and MSSQL database.

New Delhi, In

Master'S Degree, Master Of Information Systems Management

Bachelor Of Engineering - Be, Instrumentation And Control Engineering

Bachelor Of Engineering - Be, Instrumentation And Control Engineering

Aissce, Physics, Chemistry, Mathematics, Informatics Practices, English

Aisse, Mathematics, Science, Social Studies, English, Hindi