Naga Shruthi Boggarapu

405-***-**** Colorado Springs, CO linkedin.com/in/shruthi-boggarapu/ adksif@r.postjobfree.com SUMMARY

• Strong experience in querying relational databases using complex SQL queries and maintaining databases

• Experienced in generating Business Intelligence reports and building dashboards using Tableau software

• Expertise in data preprocessing, data analysis, business analytics, descriptive and predictive analytics EDUCATION

M.S. in Management Information Systems D.S. specialization, Oklahoma State University GPA: 3.86/4.0 May 2020 Bachelor’s in Electrical and Electronics Engineering JNTU, Hyderabad, India GPA: 3.8/4.0 May 2011 SKILLS

Data Visualization: Tableau, Power BI, STATA, Alteryx, MS Excel Languages: Python, R, SQL, HTML, CSS, JavaScript

Databases: Oracle 11g, Microsoft SQL Server, Data Warehouse Machine Learning: NLP, Regression, Decision Trees, Naïve Bayes, K means, Clustering, Random Forest, PCA, Factor Analysis, Time Series Analysis, Keras, TensorFlow, Neural Network, NumPy, Pandas, scikit-learn, matplotlib Software Tools: SSRS, SSIS, SAS Visual Analytics, KNIME, TOAD, OEM, ETL WORK EXPERIENCE

Graduate Teaching Assistant, Oklahoma State University, Stillwater, OK Jan 2019 – Dec 2019

• Generated word cloud for each department to share with the administration on what key concepts they should work on

• Managed advanced database management systems for 100 students, communicating and assisting them with the complex queries

• Assisted students with the concepts of normalization, Structured Query Language, ER diagrams, and query troubleshooting Data Analyst Intern, GableGotwals, Tulsa, OK Jun 2019 – Aug 2019

• Extracted data from Oracle databases by writing complex SQL queries as per the tickets and management requests

• Developed legal transaction reports, billing reports, case study reports, and ad hoc requests using Tableau Senior Business Analyst, Cars24, Hyderabad, India Dec 2017 – Jun 2018

• Analyzed data on established and prospective customers, competitors and marketing channels

• Designed dashboards, interactive graphs with parameters, trend and reference lines in Tableau for measures requiring forecast

• Identified KPI’s and communicated compelling data-driven insights to marketing executives to make decision towards increasing the customer footfall conversion rate and for increasing the profit margins Business Analyst, Sujala Pipes Private Limited, Hyderabad, India Apr 2015 – Sep 2017

• Coordinated with stakeholders to translate business requirements into Business Intelligence reports

• Developed Tableau visualizations and dashboards from multiple sources using Data Blending

• Created action filters, parameters and calculated sets for preparing dashboards, stories, and worksheets in Tableau

• Prepared weekly, monthly reports and involved in reporting statistical findings for recommendations to leadership at firm SQL Developer, Infosys Limited, Hyderabad, India Jun 2011 – Feb 2015

• Performed database, schema, table refreshes using oracle data pump export/import utility from production to non-production

• Involved in creation, installation, upgradation, migration and patching of Oracle databases

• Created database objects like tables, views, procedures, and triggers in Oracle 11g to provide data integrity

• Scheduled full, incremental database backups and performed recovery and restoration during disaster recovery management

• Involved in the configuration and maintenance of Oracle Data Guard, which involves Physical standby databases ACADEMIC PROJECTS

Predictive Analytics for Credit Card Fraud Detection using Python

• Predicted fraudulent transactions by modeling 248k credit card transactions using Random Forest and Logistic Regression

• Increased prediction accuracy 10%, by balancing the bias of minority credit card fraud transactions in the target variable Descriptive Analytics and Data Visualization on World University Rankings using Tableau

• Blended data from various files and performed exploratory data analysis to develop a storyboard

• Designed analytical dashboards using interactive graphs to identify trends, ranking patterns and regional statistics

• Derived inferences help students interested in abroad education, academia and scope for lower-ranking universities to improve Link : https://public.tableau.com/profile/naga.shruthi#!/vizhome/World_University_Rankings/WorldUniversityRankings Database creation and analysis for Car Rental Database System using Oracle SQL

• Defined Business rules to design a car rental database system and implemented the ER model in 3NF

• Designed database in Oracle for car inventory, to maintain customer records, enabling customers to book appointments for car rentals, cancel appointments and see the billing history online