AAGNA KATRODIA

Making Analysis Insightful

About Me

Hello! I am Aagna N Katrodia.
I am a Master of Science in Information Systems student at the University of Maryland, College Park. I have a Bachelor of Engineering degree in Computer Science. I am an analytical problem solver, highly organized, performance-driven and motivated.
I am passionate about the role of technology in improving businesses and find providing comprehensive solutions to technology-driven issues really interesting.
I have expertise in Advanced data analytics, Database Management, Business Analytics, Web Development and Advanced Google Analytics

Education

Projects

Data Mining and Predictive Analytics

In this project, I have analyzed the criminal incidents/ behaviors in the city of Los Angeles and predicted whether there is any impact on the real estate prices in crime-affected neighborhoods. I performed Data engineering using Python and R to clean the data with 1.9 million observations and used it to extract Zip Code/Census Tracts by implementing Reverse Geocoding and by calling API from api.census.gov/data respectively. The project then moved forward by merging the crime and rent datasets using a R code. I further trained predictive models such as Naive Bayes, Multinomial Logistic Regression, XGBoost and Neural Networks to predict the real estate rent prices in these crime-affected neighborhoods for the city of Los Angeles and generated data visualization reports in R Plotly. These finding were presented to a group of 40+, completed in 6-week development window [Click on the icon to see the report]

Big Data and Artificial Intelligence for Business

The goal of this project was to manage data from Yelp Datasets to perform predictive and descriptive analysis on it using major Big Data technologies such as Spark, Python and AWS. I led a team of five to analyze and predict user ratings using a semi-structured Yelp dataset (2 million records) using Spark and Python on AWS. I also created and managed AWS clusters to run spark scripts using Jupyter Notebooks.In addition to that, I cleaned data and performed dimension reduction, one hot encoding and feature engineering operations to feed data to Machine Learning models like Linear Regression, Gradient Boosting and Random Forest. We were able to achieve an accuracy of 75% with Random Forest Algorithm.

Web-based System to Search Alumni Information

The goal of this project was to create a web-based system to acquire the Alumni information stored in a Microsoft Azure database. The initial stage of this project was to create user stories and ER diagrams. I then, developed the SQL query structure and table structure for 100 record Microsoft SQL Server database of Alumni contact information. The SQL queries were created for a variety of search criteria such as look up Alumni information based on University, Major, Company, Location, Degree type and also on a number of combinations of these criteria. I further used R on Shiny Dashboard to develop live front-end and back-end web framework and hosted the database on Microsoft Azure SQL Server. The final stage of this project was to perform data visualization using R Plotly. This project was completed in a 6-week development window and presented live with a fully-functional system to group of 50+ people [Click on the icon to see the report]

Business Process Intelligence Augmentation

This project focused on Business process analysis of the operational framework of our client. I led analysis for improvement of business intelligence processes for the client. based on collected data and documented System Analysis Report and Design Phase Report (DFDs, ERDs and CRUD Matrix). I further, Implemented the physical system design by performing a feasibility analysis on the candidate solutions available and performed data collection, filtering and connecting the data in Amazon AWS Redshift to Power BI. I have utilized Agile Development Methodology to generate and publish Analysis reports on Power BI after 8 weekly sprints. I also performed Acceptance testing and demonstrated live to a group of 70+

Proposal and Recommendation for IT business expansion between different countries

This was a consultation project to analyze the functional and non-functional IT requirements, historical data sets, business strategy and operation for the networking capabilities of the specified country. It involved gathering and scrutinizing financial and written policy/procedure information and developing cost and resource assessment documentation, infrastructure planning map and business process workflow. Based on this information, I had prepared the recommendations for possible locations for supplier outsourcing and proposed service providers. This project also involved performing complete SWOT analysis of the Internet and Telecom service providers in the specified country to reach the proposed recommendation. [Click on the icon to see the report]

Google Analytics Project

The goal of this project was to design, develop and implement digital strategies for our client GiftsLe. Our team had multiple interactions with the client to understand their business domain, their customer demographics and their mission. In this project, we analyzed the google analytics data obtained from their E-commerce website to understand the traffic flow and customer engagement. Based on the data and as a part of the 'Google Challenge', we developed ad-search campaigns for the client. It involved following a trial and error method to constantly monitor which ad-groups and keywords resulted in more traffic to the site and which of them resulted in improved customer engagement. My campaign was monitored for a period of 3-weeks and it resulted in an increased CTR of 10.3%. As a part of this project, we also set up the Google Tag Manager settings for the client. In addition to that, I was able to acquire the Google Analytics for Beginners and Advanced Google Analytics certifications.

A Customizable Food Ordering System for the College Canteen

In this project, I designed an application and two websites to allow flexible management of canteens on campus and to allow the students and faculty members to order food online from any of these canteens. The canteen menu, their prices and also the canteens themselves can be modified by the canteen manager or the college admin at any point of time. It had an additional facility for wallet recharge for the students and faculty members and I had also implemented Notification-Messaging chain through SMS once the recharge is successful. This project involved programming the models for three canteens using Java SE 6 programming language and Android 4.2 Jellybean as working platform. I engineered the software using Eclipse Indigo as an Integrated Development Environment (IDE) and used JSP/SERVLET and SQLyog for remote database access from the main system of the restaurant. [Click on the icon to see the report]

Experience

American Institutes for Research

Data Analyst Intern/ Project Coordinator
Jun 2019– Aug 2019
• Developed SQL scripts and stored procedures to identify data discrepancies between the obsolete and new systems and perform migration testing to make sure that the data in these two systems are accurate and in accordance to the business rules
• Prepared reports for senior management based on data analysis using Excel, R and SQL. Performed predictive analysis using Python and R to predict the amount of capabilities needed at a particular date and time for next year based on the data from past years.
• Built automated data pipelines for Data Extraction, Transformation and Loading (ETL) using Python and SQL scripting to migrate data from one subsystem to another.
• Coordinated development, testing and implementation of bug fixes, development projects and internal research using the cloud-based requirements management software (Accompa) across all stages of SDLC.
• Prepared and reviewed system change documentations such as Project Control Board (PCB) outlining issue description, risk analysis, deployment process and shakeout testing procedures for approval by management
• Managed various system changes, including User Acceptance Testing (UAT) and production environment setups, patch updates, data archival, data center migrations and bug fixes.

Accenture

Application Development Associate (Java, ADF, SQL, Agile)
Dec 2017 – Jul 2018
• Conducted defect analysis using XSLT scripts to correct errors in XML data for a project under the Accenture Life Sciences (ALSC) stream. Examined and surveyed the xml documents to understand the health care terminologies and meta data used in Health Care IT systems for the project.
• Developed Java program to parse XML ODM file and generate element-attribute tables to write data to MySQL database
• Prepared System Design Document (SDD), Interface Design Document (IDD), Interface Control Document (ICD), and Database Design Description (DBDD)
• Designed, created and queried the backend databases using relational database management systems to acquire the data as per client requirements and the meta data rules
• Participated in daily scrum call and examined division of larger epics into user stories and making estimates through story points.
• Simulated a thoroughly functioning website for Events Registrations and Scheduling under the Accenture GFT training using Eclipse IDE for Java programming and MySQL for database access

IMicron Web Services

Analytics Intern
Jun 2017 – Dec 2017
• Analyzed and documented business implications of introducing updated functional requirements such as comparison feature and filter-based cloud service providers selection in IMicron cloud project by working closely with users, developers, leadership and stakeholders.
• Performed a complete feasibility analysis for the implementation of the above-mentioned features and updated the system documents to incorporate the changes.
• Defined and executed hypothesis and test methodologies to inform and support the strategic roadmap for implementation of functional requirements.
• Gathered and communicated important information from meeting to cross functional team members