aarohi agarwal
Software Engineer at Metromile
software engineer
aspire full-stack software designer/developer effectively contribute appropriately applying skill acquired continuous research , education , self-learning , application latest technological advance field information technology .
Metromile
https://www.linkedin.com/company/metromile
●	Implemented the backend service using Spring Boot technology and Java Spring MVC Framework to provide support to integrate EzLynx with Metromile, thereby supporting comparative rater model to allow external agents/vendors to use the platform to get insurance rates/quotes from Metromile.
●	Designed the API to generate and store the authentication-tokens for the external agents in DynamoDB table, to grant them access to the partner-service agent-rates POST API for getting the insurance rates/quotes based on the information sent by the agents as a JSON request while starting/updating their quotes.
●	Handled the agent-id attribution for comparative raters, by integrating the partner-service codebase with the Salesforce API, by querying the Metromile Salesforce database to fetch the JSON object for Salesforce user pertaining to that agent-id and allowing only valid and active agents to proceed with the Quote and Enrollment (Q&E) flow to get the insurance rates.
●	Developed the Quote and Enrollment (Q&E) service to calculate the monthly insurance rates based on information entered by agents on EzLynx platform such as different coverage limits (such as Bodily Injury, Physical Damage, Comprehensive, Collision, Medical, Personal Injury Protections, etc.), primary driver/vehicle, additional drivers/vehicles, total miles travelled, number of accidents/violations per vehicle, and then bridging the valid agents to the Metromile hub containing the information.
●	Managed the database to store the policy information containing the agent-rates using the PostrgeSQL database hosted on the Amazon Web Services cloud using a Relational Database Service (RDS) instance.
United States
https://media-exp1.licdn.com/dms/image/C560BAQHZ-oBjDjgv3g/company-logo_100_100/0/1625190275751?e=1655942400&v=beta&t=MClNgVS3Ji7abMlH7X-CuRfDxYpMEVvQnsz5qxACd6o
Software Engineer
The George Washington University - School of Engineering & Applied Science
https://www.linkedin.com/company/the-george-washington-university---school-of-engineering-&-applied-science
Provided support to the university faculty and students by grading their course work and guiding them in the following technologies: -

 ● Created PL/SQL stored procedures and triggers in Oracle SQL Data Developer to generate a report containing the name, address, date of sale, order type, cost, the total cost for individual customer orders, and used database views containing results set of the queries to show the report to clients.
● Deployed two Elastic Stack servers and Apache servers on multiple EC2 instances in different subnets across two Availability Zones in an Amazon Virtual Private Cloud (VPC) for collecting, parsing logs using ElasticSearch and Filebeat and displaying the system and apache logs using Kibana dashboards.
● Deployed the Red Hat Linux Server on the virtual machine using VMware Workstation Pro and connected to multiple Linux servers using remote SSH protocol from the command line. to executed Linux commands such as chmod, chown, cat, etc. for file access and manipulation on servers.
● Deployed a containerized NodeJS application forked from Github on the Red Hat OpenShift Container platform using Dockerfile container images containing libraries and dependencies required for the application to run.
Washington, District of Columbia, United States
https://media-exp1.licdn.com/dms/image/C560BAQGOCWWg6plU5g/company-logo_100_100/0/1633639451506?e=1655942400&v=beta&t=gHbBXcXsaU585F7XRBa-CzhDebFD81PT93AOWXotHqM
Student Administrative Assistant
AIVHUB LTD formerly known as Active BI Ltd
https://www.linkedin.com/company/aivhub
● Developed Business Intelligence software product modules to provide data analytics and business intelligence support to the clients.
● Generated business reports using open-source reporting tools such as BIRT, Pentaho, and Jaspersoft. 
● Developed several web application modules using Angular, Bootstrap, and Spring Boot. Supported automation testing of various application modules by developing automated scripts in Selenium.
● Managed AIVHUB application database using database management systems like Oracle, MySQL, PostgreSQL, and MongoDB. 
● Provided major design ideas for the new look of the AIVHUB website www.aivhub.com
Vadodara Area, India
https://media-exp1.licdn.com/dms/image/C4E0BAQE70aJQKy92sQ/company-logo_100_100/0/1594143358180?e=1655942400&v=beta&t=VVwt6Nzh1OAAc152bwmWKJUVg2jvTx7AXSiN_KN4ILQ
Software Associate
Solvative (Previously Quark Studios)
https://www.linkedin.com/company/solvative
• Provided design and development support for the corporate website using PHP and Angular JS. 
• Involved in the development of front-end as well as back-end code for the website.
Ahmedabad Area, India
https://media-exp1.licdn.com/dms/image/C560BAQEJ7bLKVMRGhg/company-logo_100_100/0/1592242736476?e=1655942400&v=beta&t=loyGx-d6Uvt8NahW2-gbcP2WP5zpLl3fNVeIIopzpcE
Full Stack Intern
Bachelor of Engineering - BE
Computer Engineering
SARDAR VALLABHBHAI PATEL INSTITUTE OF TECH.,VASAD 041
https://www.linkedin.com/school/sardar-vallabhbhai-patel-institute-of-tech.-vasad-041/
Master's degree
Computer Science
https://media-exp1.licdn.com/dms/image/C560BAQGOCWWg6plU5g/company-logo_100_100/0/1633639451506?e=1655942400&v=beta&t=gHbBXcXsaU585F7XRBa-CzhDebFD81PT93AOWXotHqM
The George Washington University - School of Engineering & Applied Science
https://www.linkedin.com/school/the-george-washington-university---school-of-engineering-&-applied-science/
● Hadoop: Processed a large text file of around 200MB across Hadoop cluster leveraging HDFS and MapReduce for distributed storage and processing by successfully replicating the file across multiple data nodes in the cluster using Hadoop commands such as copyFromLocal, fsck, and setup to name a few to handle scalability and fault-tolerance of data stored in file. Performed batch processing of the file by counting words appearing four times or more using MapReduce by dividing the words into buckets with key value pairs containing word as the key and frequency count as the value in a bucket.

● Text Analytics: Performed Text Analytics/Text Mining to extract meaningful information from unstructured data using the following methods:
• Semantic Analytics on the State of Union Address speeches given by Presidents of the United States from 1989-2017 by finding the frequency of words with strong positive/negative sentiments to predict whether given speech has a positive/negative polarity.
• Preparing a Corpus – a collection of documents for text analysis - for the speech data by removing the punctuations, special characters and stop words using the tm package in R. Converted the Corpus into a set of individual tokens for each word occurring in the corpus using the Term Document Matrix in the tm package of R, to find the difference between frequency of words with positive and negative sentiments. Modelled the difference as a sentiment and used it to plot the value against different Presidents as labels in a boxplot using the ggplot library of R.
Big Data and Analytics
● Developed a publish-subscribe communication model similar to Apache Kafka for distributed systems for collecting and distributing real-time data generated from multiple sources using data structures such as message queues in Google’s golang.
● Distributed the incoming message requests to the producers among different partitions by using round-robin load balancing algorithm to schedule request for processing to a particular partition inside the producer servers.
● Handled fault-tolerance issues occurring due to failure of master-node managing the distributed cluster by implementing Raft Consensus algorithm in golang that appoints one of the available nodes as leader node to manages and directs commands to execute to other follower nodes.
● Implemented a local file storage mechanism using the Reader, Writer and Scanner classes of the bufio package in golang, by creating intermediate files to store the log messages exchanged between publishers and subscribers across the network. 
● Enabled communication between leader and data nodes for distribution of log messages across the cluster by sending heartbeat messages via RPC client library in golang to ensure the availability of nodes for processing.
● Ensured the synchronized access to intermediate log files generated during processing as well as preserved the state of application at a particular instance of time by implementing locking protocols and state machine replication using sync.mutex library in golang.
Kafkaesque
https://github.com/gwDistSys20/project-kafkaesque/tree/main/milestone-4
Applied content-based filtering approach in the Neo4j recommendation browser using the graph data structure to generate course recommendations for university students using following methods:
• Generated a script containing Cypher Query Language (CQL) commands such as CREATE and MATCH to create graph nodes such as Courses, Instructors and Skills and establish relationships between them respectively by iterating over the rows in a CSV file containing course data using the R programming language.
• Performed content-based filtering on the graph generated by executing the cypher commands from the script generated using R code to recommend a list of courses that match the skill set, previous student ratings and the instructor of the course provided as input, and assigned weights to the resulting list obtained for each attribute to generate a weighted algorithm that displays the suggestions in form of a Neo4j graph.
Neo4j Course Recommendation System
Obtained actionable insights using Tableau desktop which provides numerous data visualization menus in form of dashboards and stories to enable better data analysis by applying visual data exploration using the following methods: -
• Generate the visualization dashboards containing area charts and maps to perform visual analysis on the sales of products across different regions for a sample Superstore across different regions for a span of years ranging from 2017 to 2020 across four-quarter periods.
• Implemented a script using R and python programming language using shinyUI library and matplotlib package respectively, to replicate Tableau dashboards to identify the regions and quarters which had maximum sales for a particular product from 2017-2020 by analyzing annual sales for each product during this period.
Tableau Data Visualization
● Performed the training-test split on different sample datasets downloaded from Kaggle by creating two python lists, one containing training data and the other containing test data, and normalized these datasets using one-hot-integer-encoding to convert string values to corresponding integers.
● Developed a classifier in python by emulating the K-nearest neighbor classifier algorithm that predicted the prevalence of diabetes in a Native American tribe “Pima Indians” by using majority vote using the labels of the K-nearest neighbors of the current data point in Euclidean Distance Metric.
●	Implemented Perceptron algorithm on the Iris-flower dataset, for two classes Iris-setosa and Iris-virginica; which is a linear classifier that finds a linear hyperplane separating data points of two classes by matrix multiplication of weight vector and the input feature vector of the input dataset.
● Performed Linear regression for predicting current grades of students of a Portuguese high school in the Portuguese language based on previous student data; by calculating the values of weight vectors and bias for the testing data points.
Predictive Modeling and Algorithm Development
● Developed a simple website using Bootstrap 4 and hosted it on the cloud using Amazon S3 buckets. Restricted the access to the bucket only for the certified users using the Identity and Access Management user and bucket policies for resources hosted on Amazon S3.
● Deployed the virtual Linux servers on cloud using Amazon EC2 Linux instances inside an Amazon Virtual Private Cloud and protected the servers from the malicious attacks by restricting the inbound traffic only to a predefined list of IP-addresses using the Security Groups in AWS.
● Distributed the incoming requests to the EC2 instances by balancing it to different servers using Amazon Elastic Load Balancer and handled the sudden spike in the requests by scaling up the number of servers to match the incoming requests using Amazon EC2 Autoscaling groups.
● Deployed Oracle database for a chain of restaurants generated using a PL/SQL script on AWS cloud using Amazon Relational Database System (Amazon RDS) service and connected to this database using Oracle SQL Data Developer.
● Created PL/SQL stored procedures and triggers to generate a report containing the name, address, date of sale, order type, cost, total cost for individual customer orders and used database views containing results set of the queries to show the report to clients.
Oracle and Amazon Web Services (AWS)
● Deployed two Elastic Stack servers and Apache servers on multiple EC2 instances in different subnets across two Availability Zones in an Amazon Virtual Private Cloud (VPC) environment and balanced incoming log requests using Amazon Elastic Load Balancer.
● Ingested Linux system logs, Apache access logs and error logs into Lucene-based No-SQL database search engine Elasticsearch which parses, normalizes and enriches the log data using data ingestion.
● Ingested normalized system logs generated by the Elasticsearch server to Filebeat server for processing log files by running complex queries against data and aggregating query results which are then fed into Kibana visualization tool to create dashboards, reports and monitor health of ElasticSearch server.
Elastic Stack on AWS
● Performed the role of a “White-Hat” hacker to hack login credentials of Metasploitable 2 from Kali-OS using Metasploit Framework in Kali that comes with different payloads and vulnerabilities for different types of operating systems, primarily used for performing penetration testing.
● Gained remote access to Metasploitable 2 by running arbitrary commands via compilation jobs to exploit distcc service running on TCP 3632; identified from Nmap scan using SPARTA in Kali; a python-GUI that identifies vulnerable services running on machines. 
● Exploited vsFTPd vulnerability in FTP protocol; which allows root access by entering smiley as the username for the FTP login; and gained root access to Metasploitable 2 and cracked the passwords of users using John-the-Ripper password cracking tool in Kali.
● Removed the traces of the attack by accessing the vsFTPd log files, using the credentials of users of Metasploitable OS, and deleting the vsFTPd log files from the system.
Penetration Testing using Kali Linux
● Awarded A+ grade on the project. 
● Developed a web application to provide online sales and purchase of products, services such as AMC contract, online repairing, online query solving, and auctioning of products for an existing shop.
● Used Bootstrap and AngularJS to manage the front-end visualization of the application by the users.
● Handled multiple user requests and CRUD database queries using Java and Spring Boot Technology and MySQL database management system respectively.
● Generated inventory and consolidated billing reports using the JasperSoft reporting tool.
● Encouraged innovative ideas from team members as their leader and delivered outstanding results.
OnlineTronics
Codility
app.codility.com
certDEV4A8-JFM3TDZYE7FBC6SN
Golden Award The Matrix 2021
https://app.codility.com/cert/view/certDEV4A8-JFM3TDZYE7FBC6SN/
Red Hat
Introduction to OpenShift Platform
Internshala
Programming with Python Training
Amazon Web Services (AWS)
www.youracclaim.com
AWS Certified Developer – Associate
https://www.youracclaim.com/badges/caf5762e-59d7-4c74-9adf-75930287b45a?source=linked_in_profile
https://www.linkedin.com/in/dishit-kotecha-488a6499
Fairfax, VA
Dishit Kotecha
Mobile App Developer | Web Developer | AWS Certified
https://www.linkedin.com/in/siva-teja-koppineedi
Burlington, MA
Siva Teja Koppineedi
Software Engineer at iRobot
https://www.linkedin.com/in/charitha-devabhaktuni-24ba4b187
Washington, DC
Charitha Devabhaktuni
Software Engineer
https://www.linkedin.com/in/pranay-patodi
Chicago, IL
Pranay Patodi
Data Engineering at The Climate Corporation | Data Science | Data Engineer | Machine Learning
https://www.linkedin.com/in/alvaro-albero-416554128
Washington, DC
Alvaro Albero
Software Engineer, M.S. Computer Science at The George Washington University
https://www.linkedin.com/in/ayush-dwivedi-5557b05a
Washington, DC
Ayush Dwivedi
Machine Learning & Deep Learning Adjunct Professor | Researcher  | Software Developer
https://nl.linkedin.com/in/naveed-rahman-0700b833
Netherlands
Naveed Rahman
Senior Finance Manager @ Nike
https://www.linkedin.com/in/talbot-de-st-aubin-274a63225
Washington, DC
Talbot de st aubin
Student at The George Washington University
https://www.linkedin.com/in/daniella-brancato-485ab11ab
Great Neck, NY
Daniella Brancato
Student at Carnegie Mellon University
https://in.linkedin.com/in/tableau-trainer-028823156
Chennai
Tableau Trainer
Tableau Corporate Trainer (Online & Offline)
https://www.linkedin.com/in/capri-cibelli-5b6103201
New Hyde Park, NY
Capri Cibelli
Student at State University of New York at Fredonia
https://www.linkedin.com/in/devyani-raghuwanshi
Arlington, VA
Devyani Raghuwanshi
Software Engineer II at Alarm.com | MS in Computer Science
https://www.linkedin.com/in/ali-fazal-32671b18b
Berkeley, CA
Ali Fazal
Astrophysics and Economics Student at UC Berkeley; Sports Reporter at The Daily Californian
https://www.linkedin.com/in/nadiadev
Great Neck, NY
Nadia Devereaux
Consultant for KadAfrica | B.S. Candidate in Business Analytics at the George Washington University School of Business
https://in.linkedin.com/in/harshitha-damineni-152205145
Hyderabad
Harshitha Damineni
Associate Software Engineer at Accenture
https://www.linkedin.com/in/kylechoi9
West Lafayette, IN
Kyle Choi
Resident Assistant at Purdue University
https://in.linkedin.com/in/poonam-jaswani-06b43136
Greater Delhi Area
Poonam Jaswani
Freelancer | Business Intelligence | Tableau Consultant | Tableau Trainer| Transition  Management
https://in.linkedin.com/in/vikul-agrohi-530a5a163
Pune
VIKUL AGROHI
Data Visualization and Analytics | Business Data Analyst | Tableau | Tableau Prep | Alteryx | Data Studio | SQL
https://www.linkedin.com/in/jeremy57021
Dallas-Fort Worth Metroplex
Jeremy Bayangos
Software Engineer at JPMorgan Chase & Co.
Shared by Aarohi Agarwal
https://www.linkedin.com/signup/cold-join
Photo
Shared by Aarohi Agarwal
https://www.linkedin.com/signup/cold-join
View my verified achievement from Amazon Web Services (AWS).
https://in.linkedin.com/in/aarohi-001
Pune
Aarohi Agarwal
System Engineer
https://in.linkedin.com/in/aarohi-agarwal-8557b7209
Delhi, India
Aarohi Agarwal
Project Specialist at Freelance, Self employed
https://in.linkedin.com/in/aarohi-agarwal-9a1192224
Noida
Aarohi Agarwal
Product Specialist at EDZ
https://in.linkedin.com/in/aarohi-agarwal-3ab7851b0
Uttar Pradesh, India
Aarohi Agarwal
Bachelor of Technology (Biotechnology) - Jaypee Institute of Information Technology, Noida