Nagasravika Bodapati

Python/BI Developer

Guntur,Andhra Pradesh

961-***-****

ac96ze@r.postjobfree.com

EDUCATION

University of Massachusetts, Amherst - Masters in Computer Science

Jan 2016 - Jan 2018

Focused on Database systems, Machine Learning, Data Analysis and Visual Analytics.

BITS Pilani, Hyderabad – B.E in Electronics and Communications

2008-2012

SKILLS

●Programming Languages: C, C++, Javascript, Python, R, PySpark, DAX, T-SQL, HTML5, CSS, Machine Learning, Visual Analytics,D3.js,Express.js, Node.js,Flask python.

●ETL Tools: SQL server integration services (SSIS);

●Databases: SQL Server, MySQL, SQLite, Oracle, Documentum, MongoDB.

●BI Tools: SSRS, Power BI, MS EXCEL.

●Big Data Tools: PySpark, AWS, MapReduce.

●Project Management Tools: JIRA, Jenkins, TFS.

●Python Libraries: Pandas, UrlLib, Numpy, Regex, Beautiful Soup, Sci-kit Learn, Tensorflow, Django, Multiprocessing, Seaborn.

EXPERIENCE

CareSource, OH – Python/BI developer

Sept 2018 – May 2019

●Responsible for writing complex sql queries performance tuning complex stored procedures to provide results to business requests in an Agile work flow.

●Building and formatting multiple complex SSRS reports and SSIS packages to perform ETL operations on healthcare data.

●Building powerfully interactive dashboards in Power BI to gain insights into the trends of hospitalizations and claims by different categories.

●Used Python to do some question-answering on patient-nurse interactions to obtain diagnosis and other information from phone call data stored in text format.

Tools Used: MSBI suite, SQL Server, SSMS, Python, DAX, Power BI

Valiance Partners, NJ -Python Developer /Migration Specialist

March 2018 – Sept 2018

●Responsible for writing complex sql queries and building configurations to migrate content and metadata from sources like documentum, SQL server to destinations like SQL server, Azure SQL server, Azure SQL database.

●Writing complex python scripts to parse logs, troubleshoot migration issues and validate the results of migration.

●Design, implement and test a python-based solution to generate PDFs for audit trail data residing in sql server.

●Improved the performance of ETL packages by 90% through usage of parallelization and other advanced techniques in optimization.

●Improved the performance of an internal migration tool by 60% through making parallelization possible with a python script using Multiprocessing, Queue and Pandas libraries.

Tools Used: MSBI suite, SQL Server, SSMS, Python, Django, Power BI.

UMASS Amherst Project, Amherst

March 2017 - Feb 2018

●Used PySpark, R and Power BI to clean, summarize massive amounts of data gathered from on-campus dining halls to analyze data and build powerful visualizations.

●Analyzed and build statistical visualizations to capture outliers after hosting the data on sql server and connecting to it through R packages.

●Worked on a web based application to get information on dining visits by students.

●Feature selection, k- fold cross validation and best model selection to build a regression model using SVM and Random Forest regressors to predict the number of enrollments given the combinations of menu items and different variables.

Tools used: SQL Server, PySpark, Python, Power BI, R, Sklearn.

Time Series Analysis for Estimation of Amount of Hand Usage

– Machine Learning UMass Amherst, 2017 - Independent Study

Build models using to estimate the amount of hand usage in heart stroke survivor patients based on finger based, wrist based and global sensors.

Involved in data collection, data cleaning, feature generation, feature selection, model fitting and regression model selection through leave one out cross validation.

Tools used: Sklearn, Pandas, Numpy, Matlab, Python.

Altiostar Networks, Bangalore

July 2013 – 2015

● Worked on layer 2 of LTE base station RLC-MAC layer – writing and debugging code in C++.

●Parsing base station logs using python and c++ templates to identify number of packets transferred, number dropped and number of times a base station crashed due to overload of packet transfer;

Powerwave technologies, Hyderabad

July 2012 – 2013

● Worked on OAM layer 3 of LTE base station RLC-MAC layer – writing and debugging code in C++ and C.

●Designed and developed a socket based application that can transfer periodic base station statistics to a remote server that can assess health and crash status of a working base station;

Juniper Networks, Bangalore

Internship 2012

● Used Html, CSS and Javascript to create an interactive web application that helped keep track of perforce(an svn solution) check-ins, who has done them and what the changes were. To obtain list of users who has checked-in on a given date at and given date etc.

Fun Personal Project, 2019

To develop a web application powered by Flask python, Expressjs, nodejs and d3.js to keep track of democratic elections in the US. To use machine learning to study correlation between certain features and polling numbers of front runners.

Contact this candidate