Madhumitha Koosuru Email & Phone Number

United States

Cincinnati, Ohio, United States

• Collected the School Districts data (Employee Benefits) for Production Team.• Screened and Prepared Templates For all Self Insured and Fully Insured Clients By using MS EXCEL • Prepared and loaded the client files in Employee Navigator. By using MS EXCEL.• Prepared Employee Navigator Audit Reports and Audit Forms.• Scheduled and implemented, monitored and executed production jobs.• Performed analytical problem solving for production operations.• Generated and processed Various quality ad hoc reports.• Communicated effectively to the team about the files and updated the tracker.• Represented AP Benefit Advisors in a positive and professional fashion with both internal and external team.• Performed Other Duties Based and special projects as assigned.

• Extracted the application data using Qualtrics forms, Created Many Qualtrics Projects as a part of Collecting the Survey data, gathered and analyzed the business metrics for reporting.• Established Appropriate Communication Workflows in salesforce by performing continuous testing, revised them and monitored the results to improve the targeted campaign performance.• Extract data for statistical reports using SQL and built interactive dashboards using Tableau, thereby influencing the business performance, decision making.• Performed data analysis in detail, built regression models to predict the incoming rate, calculated the conversion rated of the services like Internet, TV, Mobile using Pivot Tables.• Developed prescriptive analytic solutions by Visualizations using Tableau, to make decisions for business operations and observe the effect in number of customers choosing the spectrum services.• Communicated the statistical modelling results to supervisors and to the team for increasing the rate of new potential customers.• As an Account Executive ensured data quality and integrity by implementing data validation techniques and maintained data privacy and security.

• Worked with Donor Relations to strengthen relationship and support for Wright State using a multi channeled approach to donor retention. Used Exploratory, Statistical analysis on donors’ data. • Conducted Supervised and Unsupervised analysis using Principal component analysis, random forest for archiving data reduction.• Data visualization and data blending is performed using Tableau to describe the differences in funding.• Created Tableau Dashboard for the top key Performance Indicators by connecting various data sources like Excel, Flat files• and SQL Database.• Analyzed donors’ data to understand the donor behavior patterns overtime which helped to optimize fundraising efforts and to engage donors more effectively.• By Analyzing Donors data overtime, we Identified the trends such as seasonal giving patterns, Preferred Donation Channels or specific triggers that influence Donors Giving• Calculated the Life Time Value of donors which aid to assesses the long-term financial Impact of Donors, Including the total Amount Donated over their Lifetime, Retention Rate and the potential for future Giving. It also helped organization to prioritize donor acquisition, Retention and cultivation Strategies.• By analyzing the data helped to measure the campaign performance metrics such as response rates, conversion rates, average gift amounts and return on Investment (ROI).• Scorecards are created. stack bars, bar graphs, scattered plots, geographical maps, Gantt charts are also built as part of data analysis.• Experienced in handling multiple tasks using JIRA by collaborating with various teams.

• Understood the basics of Internet of Things like Big data, Cloud Technologies telecommunications. • Developed the User Interface (UI) by understanding the complex business problem to indicate the cause, types of traps and frequency of the network alarms in a Network Management system (NMS) using Java, MySQL. • Stored the necessary information for the display in appropriate data tables. • Queried databases to access millions of rows of data, extract as needed, transform and load (ETL) by understanding the various data schemas and its concepts.

Graduate, Marketing Analytics And Insights, 3.0 And Above

Activities and Societies: Board Member -MS Marketing Analytics Student Advisory Board, Digital Marketing project at Wright State.

Bachelor'S Degree, Mechanical Engineering