Anusha Koyilakonda Email & Phone Number

Irving, Texas, United States

Irving, Texas, United States

Oklahoma City, Oklahoma

• Created Azure Data Share resources for clients to send course data into their blob Storage which helped the clients track metrics and update dashboards on a daily basis resulting in increased course completions by 15%.
• Reconfigured database by automating configuration changes from Business Critical Gen5, 10 vCores to 4 vCores during off hours which resulted in saving 25% i.e.$5,000per annum.
• Responsible for backed-up data migration from MS SQL to Cosmos DB using Azure Data Factory Pipelines that help the customer care team to resolve queries in a much more efficient way saving 2 hours of time per day per.
• Designed Azure logic apps to update data in Salesforce from Azure SQL Database which reduced 80% of the man hours.
• Automated monthly account health reports in Tableau and Power BI for the CEO and CFO, using complex SQL queries and stored procedures to help change marketing techniques increasing the customer retention by 10%.

Irving, Texas

• Analyzed clinical data and census data to provide socio economic factors that cause heart attacks. Developed reports using this data in tableau which helped the Christus set up required awareness camps across Texas.
• Standardized and operationalized SQL, SAS and MicroStrategy based data management infrastructure to support Health Equity & population health initiatives.
• Worked as an acting manager for 2 months and led the project when the program manager moved to a different company.
• Redesigned data mart by extracting, transforming & loading (ETL) data from various platforms for deeper insights enabling effective decision-making and documented the process for future reference.
• Automated the data import using SSIS packages from various external environments, which decreased the time taken from 1.5 days to 1.5 hours.
• Analyzed patient data and developed reports using excel and MicroStrategy to make business decisions.

Stillwater, Oklahoma

Mysore

• Designed, developed and implemented stored procedures in SQL server to get the attendance data of the organization with 3 lakh employees.
• Created widgets in MVC using C# used in the Timesheet Application which shows the number of timesheets submitted by employees in a team used by the managers across Infosys Ltd.
• Worked on SSIS packages to move data of working hours from excel to SQL server
• Developed User screen for Timesheet application using HTML, Javascript and JQuery.
• Designed UI screens for Daily Monitoring application which monitors the shares of customers for Bank of America using angular.

Master'S Degree, Management Information Systems, General, 3.75/4

Bachelor'S Degree, Electrical And Electronics Engineering, 72%

10 + 2, Maths Physics & Chemistry, 93%

High School, 91.6%