Data Analyst

Sreeja Adavalli

415-***-**** **** University Terrace Dr, Charlotte, NC-28262 **************@*****.*** www.linkedin.com/in/sreeja-adavalli-6b9b06109/

SUMMARY

Over three years of experience in Analytics and Reporting across various domains (Finance, Telecom, Retail) combined with Data Migration and Project Management, creating solutions for business problems through data driven decisions and Agile Project Management.

Experience with data cleaning, data manipulation, database(Oracle) testing and developing controls using R Programming.

Computer Science Graduate Student with specialization in Data Analysis, Data Warehousing, ETL development, Quantitative Analysis, Data Mining, Reporting and BI application development.

Academic Knowledge in data modeling techniques like Predictive Modeling, Hypothesis Testing, ANOVA, Regression Analysis, Clustering techniques using R Programming.

Experienced and passionate for data visualization, presentation, and communication with specialization in Tableau, Analysis using Python and SQL query writing.

EXPERIENCE

Finance Analyst at Bank of America (R, Oracle, Toad, Tableau) August'17 - Present

GR Group - Global Risk Initiatives Team - Develop economic scenarios for stress testing and capital planning.

Responsible for providing data solutions, delivery for Risk to support portfolio management and develop data quality checks for Regulatory stress tests like CCAR.

Involved in every phase of Economic Scenario Generation from Input data quality checks, generating model outputs, model output loading, generating deliverable files and run delivery controls.

Designed and created the Data Quality rules on every level of data hierarchy to establish data quality

Develop controls to validate the history data, model output data and distribute data to downstream.

Worked on data migration, assisted with various phases of UAT, PROD database and performed database(oracle) testing using R programming.

Coordinate with different business units to address all data gaps with help of data lineage.

Develop ad-hoc reports using latex coding and Tableau to facilitate reconciliation and validation. Data Analyst Intern at Sprint (Excel, Alteryx, Tableau, R) May'17 - August'17

Analyzed Cellular (Mesh and log) data to implement project AGOOP to improve the network signal strength.

Performed Spatial Analysis using Alteryx and Tableau to understand the real-time data.

Improved overall sprint network coverage and usage using SOGA and CHURN modeling.

Created ad-hoc reports and provided data for monthly & weekly business review meetings. Graduate Teaching Assistant at UNC Charlotte (Design and Implementation of Object Oriented Systems) July '16-December '16

Assisted under-grad students individually or in small groups to help them master assignments and to reinforce implementation of projects in Python and JAVA programming.

Generated reports using Tableau on student’s level of comfort in Python and Java. Data Analyst at NTT Software Solutions at Hyderabad, India (R, Tableau BI, SQL, Microsoft Office &Excel) Aug'14 - May'15

Analyzed a Transactional, customer, product data of size 32GB to improve and predict the sales.

Interpreted data, analyzed results using statistical techniques and automating executive level reports; identifying trends and patterns to understand and resolve business obstacles.

Prepared data sets using the complex SQL scripts, used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.

Used various predictive modeling Algorithms like Decision Trees, LOGIT in R Studio to predict the response.

Used Random Forest for better predictability and achieved model accuracy of 75% and sensitivity of 54%

Developed interactive and insightful Tableau Dashboards/reports to present consumer spend behavior and patterns and identified metrics/KPIs based on data/visual analytics performed on the current/historic transactions and improved the sales by 40%.

TECHNICAL SKILLS

Programming Languages : R, Python, SQL, PL/SQL, T-SQL, JAVA, C++, C Analytics : SAS, SPSS, Tableau, Alteryx, SSIS, SSRS, Excel (Pivot Tables, Macros). Database : MySQL, Microsoft SQL Server, Oracle, Teradata Web Technologies : HTML5, CSS, JavaScript, XML

Operating Systems : Windows, LINUX

Machine Learning Algorithms : Exploratory Data Analysis (EDA), Classification & Regression Technique (CART), Dimensionality Reduction (PCA, Factor Analysis), Support Vector Machines, Decision Trees & Random Forests, Linear & Logistic Regression, Time series, Market Basket Analysis, Apriori Algorithm, Bayesian Thinking & Naive Bayes, Clustering. Tools & Platforms : Toad, R studio, JIRA, SAS E-Miner, SAS Enterprise guide, Eclipse IDE, Open Shift, Putty, Net Beans

CERTIFICATIONS

SAS certified Base Programmer for SAS 9

R Programming -- Coursera Course Certificate from John Hopkins University

Data Science and Machine Learning Boot camp with R - Udemy Certificate.

Intermediate Python for Data Science -- Data Camp Certificate

Pandas in Python--Data Camp Certificate

ACADEMIC PROJECTS

Visualization of US Economy since recession (Tableau, Excel)

Imported data into tableau using web data connector and developed dashboards with multiple visualizations considering various factors effecting the US economy using Tableau 10.2. Visualization of factors influencing Global Warming (Tableau, D3.js, R Programming)

Developed a dashboard with various visualizations of multiple attributes causing global warming using Tableau, R and D3.js

Dealt with various R packages dplyr, tidyr to develop a tidy dataset and ggplot2 for plots. High Precision Attribute Descritizer (SAS, WEKA, Python, Excel)

Performed web crawling using Python on Saatchi art website, and extracted 1 GB of information using Python scripts.

Performed data cleaning and discretized a variable of data using equal frequency binning and classified other columns based on it, using J-48 algorithm to have a high precision and implemented the same in SAS to compare the best method. Exploratory and Predictive Analysis of Super Market Data (SAS E-Miner, SAS Enterprise guide)

Performed Exploratory Data Analysis on the Organic product data and predicted the best innovative strategy for the super market by performing RFM Analysis, Predictive Analysis in SAS E-Miner using Logistic Regression and plotted the ROC curves to determine the best model.

Online Ticket Reservation System (MySql, HTML, CSS, JavaScript)

Developed a web based application that enables users to check, reserve, cancel tickets and track his booking history using SQL code and query analysis.

EDUCATION

MS. Computer Sciences, University of North Carolina, Charlotte, USA --GPA: 3.7/4.0 August2015–December2016 BE. Computer Engineering, Osmania University, India --GPA : 3.7/4.0 August 2011 – May 2015

Contact this candidate