Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic
Mounica Miriyala

Mounica Miriyala

San Antonio,Texas

Summary

A data enthusiast and data analyst with 5 years of experience in the intersection of technology, consulting, 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 Able to translate operational requests from stakeholders into data criteria to model expected results Exceptional interactive, written, and verbal communication skills to enable a layman to understand complex analytical concepts for business decisions

Overview

7
7
years of professional experience

Work History

IT Manager

Vericast
03.2022 - Current
  • Working on Analytics, Marketing Operations, UI, mid-campaign, and end-of-the-campaign reports generation using Python and Big Data
  • Built visualizations and presented them by telling stories on organization's performance on campaign performance
  • Development areas include Python Programming Language, Redpoint, DataLab, cplXpress, and Tableau
  • Working together with client managers to discuss, analyze, and thus enhance quality of campaigns which generate revenue on average of 1 Million USD per campaign
  • Developed 75+ campaigns for increased product sales of more than 25 Banks and Credit Unions
  • Customized and repaired technology based on staff requests
  • Conferred with executives to advise and plan for short-term and long-term IT system upgrade needs

Data Analyst

Alterman Inc
05.2021 - 03.2022
  • Created 15+ 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 using R programming language and SQL to answer key questions from stakeholders out of self-initiated curiosity with eye for what drives business performance
  • Identified areas for improvement in efficiency and productivity
  • Trained and supervised team of 7 members to use 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 back end when provided last 4 digits of their SSN to request company credit card
  • An avid member of Microsoft Power BI community providing solutions to problems
  • 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
  • Transformed, maintained, and preprocessed credit card finance data for analysis then presented spending trends in each merchant and clustered employee titles based on their spending limits to determine credit card spending limits when new employees applied for credit card
  • Worked as subject matter expert for BI tools, data modeling, mining, relevant data extraction, data integration, and Chase Bank SmartData product for expense tracking and analysis
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources

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 for data analytics major
  • Proctored students while giving exams and prepared coursework materials for professors
  • KEY PROJECTS
  • Customer Contract Analysis: To assist company with decision-making in accepting new contracts from old Customers, used previous contract data to identify customers who pay late for contract. Therefore, allowing company to make key decisions in accepting new contracts/projects
  • Credit Card Expense Analysis: Analyzed company's credit card expense data and helped organization to understand what merchants company is mostly spending for raw materials. Thus, helping them to grab concessions while purchasing raw materials in bulk amounts
  • Health insurance cross-sells prediction: 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
  • Stock price prediction and risk analysis: To help investors balance their portfolio risk, model was formulated in R using CAPM to calculate risk of adding individual stocks to portfolio
  • Risk level was compared with historical returns to analyze which stocks would be good investment according to investor’s risk tolerance profile
  • 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

Software Engineer – Front End Developer

Accenture
12.2016 - 06.2019
  • Implemented interactive websites for Canadian transportation system using Angular, HTML 5, Bootstrap, and SQL that would interact with end users, streamline transaction processes, and increase customer satisfaction
  • 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 thus improving efficiency to 85%
  • Analyzed customer behavior using monthly reports and helped business in decision-making for customer acquisition hence improving subscriptions by 5%

Education

Master of Science - Data Analytics

The University of Texas
San Antonio, TX
08.2021

Bachelor of Technology - Electrical and Electronics EngineeringGPA

Jawaharlal Nehru Technological University
Kakinada, India
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 for 3 years and 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
  • Fluent in professional communication with internal and external stakeholders and customers

Additional Information

  • AWARDS AND HONORS , Recipient, UTSA Graduate Scholarship August 2019-August 2021
  • Nominee for Best Employee of the Month June 2019

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 Technology - Electrical and Electronics EngineeringGPA

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Mounica Miriyala