Aman Rastogi

   Greater Cincinnati, KY
   +1 (513) 888 3271
   amanrastogi2604@gmail.com

Software Developer, Data

I'm a Java back-end engineer who grew interested in data and now combining the knowledge that I've gained over five years with the newly acquired skills from Masters program in data mining- classification, regression with the production-ready code.
Technology solving business problems intrigues me, hence in my free time either I read engineering blogs of Netflix, Google, Databricks, Facebook or you can find me hiking on the nearby trail.
Currently, I'm learning AWS services and this portfolio is an attempt at that.

Experience

Software

Robert Bosch LLC

Robert Bosch Automotive Steering LLC is the subsidiary of Robert Bosch LLC which manufactures dual pinions, engine control units, rackbars for clients - Honda, Toyota, Subaru, Daimler, Waymo, etc to name a few. I worked with the digitalization team and worked with the following projects-

IdeaM Portal- Designed and developed the micro-service architecture for IdeaM portal using Spring boot, Spring WebClient and deployed it into Spring cloud. The end-points are consumed in the Power BI, facilitating efficient decision-making

Automation- Conceptualized and implemented the digital transformation strategy for USA and Mexico. Trained more than 30 business partners from CXO, Manufacturing, Logistics, Controlling, and HR verticals.
Improved the exisiting business processes by automting them using, RPA, and workflow automation tools- Automation Anywhere and Catalytic Push bot. Gave demonstration to the President and delpoyed it into AWS cloud. Saved cost-to-company, approximately $280K yearly

Database- Formulated database schema for SAP reports to be ingested by Power BI to minimize data manipulation in Power BI Query Editor. Saved ~60 man-hours monthly

Power BI Dashboards- Transformed raw data from SAP and SQL employing DAX & M language to design dashboards for various business units, deployed bi-weekly and monthly, especially tailored for decision making by the CXOs

May 2020 - Present

Technology Analyst

Infosys Limited

Infosys Limited is a global leader in IT services, consulting & business solutions with a large network of innovation & delivery centers. My responsibilties includes but not limited to-

System Design- Designed and implemented batch processing system for an Asset Management Project called Horizon. Incorporated observer design in Spring Boot and Apache Kafka to periodically get quotes of stocks from Bloomberg and Thomson Reuters

Legacy Modernization- Migrated more than 1500 stored procedures for the Horizon project, from Sybase to Spring Data, making system database agnostic. Orchestrated redesigning of Horizon's Windows Desktop Application to WebApp using Spring Boot and React

Mutual Funds Transaction System- Coded robust batch application in Java with multithreaded environment. Handled more than 15 files containing millions of Funds Transactions. Saved approximately $56K annually

October 2016 - July 2019

Systems Engineer

Infosys Limited

Onboarding/Offboarding Web-App- Built a web-app in Spring Boot and Angular to automate manual tasks of onboarding/offboarding of resources. Increased productivity by ~37.5% from 16 days to 10 days

July 2014 - October 2016

Education

University of Cincinnati

Master of Science

Information Systems

GPA: 3.846/4.000

Jaypee University of Information Technology

Bachelor of Technology

Information Technology

GPA: 7.6/10.0

Skills

Programming Languages

Java, Python, C#, R

Databases

Oracle 12c, MS SQL Server

Frameworks

Spring Boot, Spring Batch, Spring Data, Spring WebClient, Hibernate
Micro-services, RESTful API, SOA, Apache Kafka, Maven
Agile, Waterfall

Testing

JUnit, Mockito

AWS

S3, DynamoDB, API Gateway, Lambda, Cloudfront
Elasticsearchservice (EC2), IAM, Kinesis, Comprehend, Kibana
VPC, VPN, Route53,

Tools

IntelliJ Idea, SQL Server Management Studio (SSMS), PL/SQL Developer, Putty, Power BI, R Studio, Jupyter Notebook, Anaconda
Shell scripting, GIT, GitHub, MS Visio, MS Excel

Projects

Cloud Portfolio/Resume

AWS Lambda, Amazon DynamoDB, Amazon Route 53, Amazon API Gateway, Amazon Cloudfront, AWS Certificate Manager, Amazon S3

Used S3 to deploy a static website and Cloudfront to securely deliver the data globally with low latency

Registered a domain with GoDaddy and create a public hosted zone in Route 53 to route the requests to Cloudfront

Managed DynamoDB, Lambda and API Gateway to store, update and retrieve visitor counter

Addressed infrastructure as code using AWS SAM and set up CI/CD pipeline using GitHub actions

October 2020

Twitter Sentiment Analysis for Presidential Elections

Amazon Kinesis, AWS Lambda, Amazon Comprehend, Amazon EC2, AWS Kibana

Extracted real-time data from Twitter using a python script running on EC2 with the help of libraries Tweepy and Boto3

Used Kinesis Firehose delivery stream to capture the streaming data and AWS Lambda to call the Comprehend service for generating the sentiment information

Loaded the transformed data into Elastic Search Cluster and visualized it using Kibana

September 2020

Neighborhood Affluence

Spring Boot, Spring Data, Spring WebClient, JSON, Azure

Created RESTful web services to determine affluent neighborhoods of Chicago, consuming different JSON Schemas. Implemented dynamic website by consuming JSON Schema from web service created, and hosted it on Microsoft Azure

Mar 2020

Predicting Dengue Spread

Python, numpy, pandas, scikit-learn

Predicted local epidemics of dengue fever in San Juan, Puerto Rico, and Iquitos, Peru.

KNN, Random Forest, Regression Trees, XGB to test the performance on the test dataset.

XGB performs best with Mean Absolute Error as 16%