***.********@*****.*** +1-312-***-**** https://www.linkedin.com/in/anuhya-koduri/
Summary
Business Analyst with 2 years of experience in IT and retail industry. Proficient in data analysis and visualization using Power BI and SQL. Certified subject matter expert in Business Intelligence, MCSA.
Certifications
MCSA – Developing solutions for Microsoft Azure June 2020 MCSA – BI and Reporting May 2020
Introduction to Data Analytics using MS Excel from Microsoft Edx May 2018 Work Experiences
Microsoft - Allyis, Redmond, WA Sept 2018 – March 2020 BI Analyst - BI and Reporting /Retail IT Opex July 2019 – March 2020 Development: Developed interactive Power BI Dashboards for company-wide sales transactions to improve ‘Holiday Readiness’ and increased user flow, Analyzed and debugged ~60 existing dashboards, handled change requests and updated them to reflect latest data, Worked with various data sources like Azure Storage, SQL Server and Live clusters to plug into differed systems, Reporting: Created the analysis report for the dashboards showcasing the performance and health for each of the reports built, Automated the scheduled daily refreshes and published reports for dashboards Power BI Service, Maintenance: Monitored Azure Logic Apps and ensured sustainable data flow to the SQL DB, Maintained and updated store procedures in SQL Server using SSMS, Software Test Engineer/ Retail IT Opex Sept 2018 – March 2020
Created, Updated and Reviewed test cases and test scenarios and identified, tracked and reported the bugs using VSTS dashboard
Verified backend validation for test scenarios using MICROSOFT AXDB
Created and Validated Business order quotes using Microsoft Dynamics 365
Contributed towards controlled testing in the Pre-production environment for a Microsoft store
Wrote SQL queries and validated data population in application tables to perform Backend Testing against SQL Database.
Worked cross-functionally with developers on provided daily updates/blocker bugs, issues and follow-ups and generating a bug report on daily basis. Illinois Tech University, Chicago, IL Jan 2018 – May 2018 Student Assistant / Information Technology and Services
Diagnosed UNIX and Windows processing issues using troubleshooting methods
Designed marketing plans to verify alignment with senior management objectives
Assisted customers with hardware and software related support, bug fixes and configuration issue Sunridges Solutions, Hyd, India Jan 2016 - June 2016 Associate Program manager
Co-designed and managed the implementation of the TEA application.
Managed business pitches, and helped maintain transparency with the customer about the product
Analyzed and scrutinized by creating reports and interactive dashboards with Power BI
Documented business processes and analyzed procedures to boost efficiency
Collaborated with cross- functional teams to bolster system-wide improvements Academic Projects
Opinion Mining, Program Manager
Tech Stack: Python, MS EXCEL, MySQL
Determine the polarity of the review and analyzed amazon digital music reviews for over 8000 reviews
Implemented text classification techniques like Tf-idf, bag-of-words and used classifiers to determine the class of the review Tour of Chicago, Project Manager
Tech Stack: MS PROJECT
Worked in a group of 15 as the team lead. Implemented a team Charter, worked on updating the issue log and WBS charts
Updated the MS project file on weekly basis. Derived EVM charts as per the specified budget of the project. In addition, published a video based on the topic Technical Skills
Tools: Microsoft Dynamics CRM, Microsoft Dynamics, Fiddler, MS SQL Server Management Server Databases: AXDB, Cosmos, SQL, Azure DB suite
BI: Power BI, Tableau
Business Management: Workflow Analysis, Team Building and Strategic Planning, Project development/management Leadership Activities
Led a skill share employee resource group – Women in tech, Sunridge at Sunridge Solutions.
Head of Marketing and Logistics, Revolutionizing India through Social Empowerment, (R.I.S.E) Hyderabad
Head of Publicity of Chaitanya Smruthi, alumni organization of CBIT. the biannual cultural festival of CBIT; largest in South India Education
Master of Information Technology and Management Aug 2016 - May 2018 Data Management and Analytics GPA - 3.5/4.0
Illinois Institute of Technology, Chicago, IL
Bachelor of Engineering in Information Technology, Aug 2012 - May 2016 Osmania University, Hyd, India GPA – 3.7/4.0
LAKSHMI ANUHYA KODURI