MOUNICA MIRIYALA
San Antonio,Texas
Summary
A data enthusiast with 5 years of experience in the intersection of technology, consulting, Banking, Marketing, Electrical, and Logistics industries, including decision analytics and modeling. Skilled in statistical data modeling, machine learning, data mining, analysis, BI visualizations, R and Python programming
Overview
8
8
years of professional experience
Work History
IT Manager
Vericast
03.2022 - Current
- Transformed/processed customer data and built reports and Tableau visualizations for presentations to stakeholders
- Collaborating with client managers to evaluate, refine, and improve underwriting guidelines for Credit Unions and Banks, to mitigate the risk of extending pre-approved offers to high-risk customers/prospects
- Worked on online banking,emailresponse,and other responses to generate segments using K-Means clustering
- Collaborated with analytics team to automate and build tableau dashboard for report purposes thus reducing 80% of manual work on processing data for a Bank
- Developed 100+ campaigns for increased product sales of more than 25 Banks and Credit Unions.
Data Analyst
Alterman Inc
05.2021 - 03.2022
- Created 15+ Power BI reports, and 5 Dashboards and maintained rich interactive visualizations through data mining, analysis, and interpretation thus reducing 75% of effort to examine trends for better decisions
- Proactively mined, enriched, transformed, and analyzed large data consisting of millions of customer transaction records to answer key questions from stakeholders
- Identified areas for improvement in efficiency and productivity
- Trained and supervised team of 7 on SmartData website by Chase Bank to efficiently track expenses for 300 employee credit cards
- Created power app that pulls entire employee's personal information from DB when provided last 4 digits of their SSN
- Avid member of Microsoft Power BI community providing solutions to problems for almost a year
- Automated process of creating vendor invoices and keyed in all information to database for thousands of transactions every month for 300 employees without human intervention thus optimizing current process and reducing 98% of manual work for accounting managers every month end.
Teaching/Research Assistant
The University of Texas
08.2019 - 05.2021
- Prepared large and dirty data consisting of millions of records in R and Excel for complex machine-learning algorithms
- Worked as coach for business management students
- Performed ETL processes for data preparation and used them in real-life projects
- Created 10+ power point presentations for professors and Graded students answer 140+ sheets.
Software Engineer – Front End Developer
Accenture
12.2016 - 06.2019
- Implemented interactive websites for Canadian transportation system
- Trained, coached, and supervised team of junior developers in understanding project structure to help meet acceptance criteria and so lowered spending on subject matter experts by 50%
- Automated 208 manual test cases using C# language and selenium test suite in short period demonstrating excellence under pressure, improving efficiency to 85%
- Analyzed customer behavior using monthly reports and helped business in decision-making for customer acquisition hence improving subscriptions by 5%
- Awarded Accenture Best Employee of the Month 2017.
Education
Master of Science - Data Analytics
The University of Texas
San Antonio, TXBachelor of Science - Electrical Engineering
Jawaharlal Nehru Technological University
Kakinada05.2016
Skills
- Proficient in analytical programming languages such as R(Tidyverse,ggplot,xaringan)
- Python(Numpy, Pandas), SAS, DAX, HTML 5
- Net, and Angular JS
- Experienced in querying using SQL Server writing stored procedures
- Practiced in statistical programming and predictive modeling using machine learning, deep learning, and visualization
- Experienced in usage of tools such as Tableau, Power BI, Alteryx, Jupyter Notebooks, GRETL, MS Office(Excel, PowerPoint), Google Collab, Microsoft Power Apps, Microsoft Power Automate, Spectrum, Redpoint, cplXpress, Datalab, and SAS Enterprise Guide
- Able to translate operational requests from stakeholders into data criteria in order to model expected results
Key Projects
- Customer Contract Analysis: To assist company with decision-making in accepting new contracts from old Customers
- Health insurance cross-sells Predictive Model: Proposed solution for insurance company that wants to predict how many customers would be receptive to cross-selling. Explored data relationships using packages such as Pandas, Numpy, and Scikit-learn. Compared machine learning classification models in Python, such as random forest, gradient boosting machine, and logistic regression, and then fine-tuned final predictive model with most accurate method
- Customer acquisition and retention: A finance company wanted to predict number of customers it would acquire in given period and duration of customer retention. Created predictive model to determine who would be acquired and keyed in predictions as input to random forest model to predict retention duration of those customers
- Facebook Advertisement Predictive Model: Used RandomForestRegressor to predict click-through rate (CTR) and Conversion Rate to analyze the performance of Facebook advertisements
- NADAC Comparison of Medicaid Drugs: Designed set of visualizations to tell story on weekly increases in Medicaid drug prices for life-saving medications using Plotly, ggplot2, and Xaringan packages in R
Additionalinformation
Bachelor of Technology, Electrical And Electronics Engineering, 04/2016, Jawaharlal Nehru Technological University, Kakinada, India, 3.27
Coursework
- Algorithms in R, including supervised and unsupervised learning
- Python programming, machine learning, and neural networks such as CNN and RNN using Keras and TensorFlow
- Modeling with real-time case studies in R, including logistic regression, decision trees, random forest, SVM, ensemble models, and linear regression
- Visualization and communication in R, SAS EG, and Tableau
- Exploratory Analysis, Data Engineering, and data Preprocessing using R and Python
- Time series modeling in R, including ARCH, GARCH, and ARIMA models
- Data Modeling and Preprocessing in Alteryx for Data science tool, Power Query, SQL SERVER
- Shiny App development in R
Timeline
IT Manager
Vericast
03.2022 - Current
Data Analyst
Alterman Inc
05.2021 - 03.2022
Teaching/Research Assistant
The University of Texas
08.2019 - 05.2021
Software Engineer – Front End Developer
Accenture
12.2016 - 06.2019
Master of Science - Data Analytics
The University of Texas
Bachelor of Science - Electrical Engineering
Jawaharlal Nehru Technological University