Aashreya Agasthya Kundurthy
Santa Clara, CA ***** *********.********@*****.*** +1-928-***-****
https://github.com/agasthya-kundurthy https://www.linkedin.com/in/agasthya-ak/ EDUCATION
Santa Clara University, Leavey School of Business, Santa Clara, CA 3.52/4.0 Master of Science in Information Systems (MSIS) December 2018 Big Data Modeling & Analytics, Business Intelligence & Data warehousing, Cloud Computing, Dashboards & Visualization, Data Science with Python, Database Management Systems, Information Systems Analysis & Design, Object-Oriented Programming (JAVA) Sastra University, Thanjavur,India
Bachelor of Technology in Information Technology May 2014 TECHNICAL SKILLS
Programming Languages: Python, Objective-C, Swift, Java, SQL Databases: Microsoft SQL Server, MySQL, Postgre SQL, Couchbase Lite, ETL - Pentaho Data Visualization: Python – Matplotlib, Seaborn, Plotty and Cufflinks, Tableau Platform: AWS – EC2, ELB, RDS, Kinesis, Firehose, Kibana, Elasticsearch Frameworks & Tools: Map Reduce in Apache Spark, RESTful web services, SVN, GitHub EXPERIENCE
Prosper Marketplace, Inc. San Francisco, CA
Analyst Associate, Business Operations (Internship) Sep – Dec, 2018 Tools : Microsoft SQL Server, Microsoft Excel and Tableau
• Automated a Work Force Management(WFM) process to forecast the number of contact center Agents required.
• Understood the WFM process of the Organization and converted the process of forecasting from Excel to SQL and reduced the time-taken to perform daily tasks from more than 3 hours a day to under 2 minutes by the use of Stored Procedures
• Created dashboards and scorecards in Tableau, to show monthly forecasts and other key metrics to the upper level management
• Performed Data source identification, Data Validation and developed in-depth documentation to train users on the new process Tata Consultancy Services Chennai, India
iOS Mobile Application Developer 2014-2016
• Designed and implemented an iPad Application for a leading Asian Airline to deliver more personalized customer service and to automate and streamline in-flight processes for cabin crew
• Analyzed the client’s requirements for critical modules in the application and provided optimal solutions using the cocoa touch framework in Objective-C and Swift and used couch base lite database to store data
• Implemented Customer Experience Management (CEM) module in the application to record and keep track of in-flight Customer preferences to increase customer retention and improve customer satisfaction
• Implemented an Audit-Trail feature that captures information on cabin crew’s in-flight operation of application and sends data to the on-ground Data-Grid team to process it for Analytics. Achieved Continuous Delivery of the application build using Jenkins. Integrated and managed 3rd party libraries using Cocoa-pods in the application ACADEMIC PROJECTS
• Data Science–‘Will your Permanent work visa be approved Python–Pandas, ScikitLearn, imblearn, Matplotlib) Analyzed a dataset on permanent visa approvals in the U.S. Cleaned the dataset and performed Exploratory Data Analysis with Python using Pandas and visualized the Analysis using Matplotlib and Seaborn packages. Used Scikitlearn and imblearn for the classification and training of data to build a model that predicts the outcome of a visa application.
• Data Product – ‘Home Market Analysis’: (Python – Pandas, Tableau) Created a Data Product in Tableau, based on Analysis in comparison of home prices across three cities a Tech Hub, A Financial Capital and a fast-growing City. Used metrics such as price to rent ratio to understand if it is better to rent or buy a home in the city, compared the average salaries and prices of homes to help in a detailed analysis of the market.
• ‘Real-time Log Analytics in AWS’: (AWS – EC2, Kinesis, Firehose, S3, Elasticsearch, Kibana) Performed real-time analytics by ingesting streaming of temperature logs from sensors into AWS through Kinesis, aggregating the data, and persisting the data into AWS S3 through Firehose, consolidated the aggregated data into an Elastic Search domain and visualized the data using Kibana.
• Business Intelligence – ‘Airport Insights': (ETL – Pentaho, MySQL, Tableau) Implemented a Business Intelligence solution for an Airport manager use-case to reduce passenger wait times in airports due to machine issues. Created ETL jobs to extract data from various data sources of the airport and store in a Data Warehouse to perform analytics. Visualized the data using Tableau and performed forecasting to predict future issues. Developed Swimlane diagrams to assist in the process flow identification AWARD & CERTIFICATION
Certification: Tableau Certified Desktop Specialist (January 2019) Award: Earned Award for ‘Best Digital Project – Asia Pacific region’ at Tata Consultancy Services (2016)