Likhitha Madasu

Proficient in SQL, SAP, PowerBI, Tableau, and various data management and visualization tools. Demonstrated ability in troubleshooting, project management, and delivering customer-centric solutions. Experience using Python for data wrangling to improve procedures. Proficient in implementing and managing cloud computing platforms like ADLS and Snowflake. Strong communicator, adept at working with cross-functional teams to achieve business objectives. Good business knowledge in understanding the end-to-end processes. Organized professional with excellent verbal and written communication skills. Worked on deliverables with short notice and provided reliable and effective solutions ensuring customer satisfaction.

SQL Developer with 5 years of experience in IT, specializing in data analysis, transformation, and technical support.

Fitio – Business Application Database Management System (Course Project), Northern Illinois University, Dekalb, IL, December 2019

• Designed and developed a database for a fitness application using SQL Server and created UML diagrams for functionality prediction.
• Identified the Entity relationships and tested for different use case scenarios.

Northwind Traders – Business Intelligence and Business Analytics Application (Course Project), Northern Illinois University, Dekalb, IL, April 2020

• Analyzed the data warehouse for business cases and provided business insights using Visual Studio.
• Performed data wrangling, data analysis and created visualizations using DAX, PowerBI, and Tableau.

DressMania – Business System Analysis Design (Course Project), Northern Illinois University, Dekalb, IL, April 2020

• Developed an e-commerce web interface and business system with use case and test cases, improving functionality and designing UML diagrams to depict the functionality.

Illinois School District – Statistics Project (Course Project), Northern Illinois University, Dekalb, IL, December 2020

• Performed hypothesis testing using SAS and provided business insights.

Huskie Marching Band IT Transformation – Project Management Plan (Course Project), Northern Illinois University, Dekalb, IL, December 2020

• Defined a project management plan with a work breakdown structure considering the scope and major deliverables of the project.
• Analyzed the Risk register and its effects on the deliverables.

Customer Support Analysis on Twitter Data – Social Media Analytics for Business (Course Project), Northern Illinois University, Dekalb, IL, April 2021

• Conducted social network analysis by performing Topic Modelling, Feature extraction, Word Cloud and Sentiment Analysis using Python and Gephi, providing business recommendations.

· Created Results-driven reports which helped the stakeholders in Decision making and improved business processes

· Reduced server costs by migrating to Azure cloud and Snowflake

· Optimized and tuned SQL queries and stored procedures for performance and scalability and reduced the run time by 50%

· Migrated on-premises databases to Azure SQL Database, resulting in 33% faster query Performance

· Created Data Models that reduced data redundancy by 30 % and improved Query Performance by 25%

· Created and managed Power Apps for data mapping and cloud flows, reduced wait time by 25%

· Managed data migration using ETLs to Microsoft Dynamics CRM with KingswaySoft increasing productivity by 20%