Business Intelligence Power Bi

LAKSHMI PRANEETHA ACHANTA

New Jersey, ***** 917-***-**** ******************@*****.***

SUMMARY

Experienced IT Business Analyst with a strong background in data analysis, business intelligence and automation Skilled in custom applications using Power Apps, developing interactive dashboards using Power BI and Tableau, and proficient in SQL for data extraction and transformation. Successfully reduced ad-hoc report requests by over 60% through effective data visualization and automation. Eager to leverage analytical skills and technical expertise to drive data-driven decision-making as a Data Analyst.

EDUCATION

Stevens Institute of Technology May 2024

Master of Information Systems

•Coursework: Strategic perspective of project management, Integrating Information Systems and Technologies, IT Strategies, Leader Development, Business Analytics with Data models and Decisions, Financial Decision Making, Managing Emerging Information technology, Fundamentals of Data Visualization and Application

KL University Vijayawada, India

Bachelor of Business Administration (BBA)

TECHNICAL SKILLS

•Cloud & Infrastructure: Azure services (App Services, Load Balancers, NSGs, Azure SQL Database), Azure DevOps, CI/CD pipelines, cloud infrastructure management

•Data Analysis & Management: Large dataset analysis, data cleaning, ER diagrams, data modeling

•Business Intelligence & Reporting: Power BI, Tableau, Excel, real-time dashboards, statistical analysis, reporting, data storytelling

•Project Management: Agile methodologies (Scrum/Kanban), Jira, strategic project planning, team collaboration

•Database Management: MySQL, PostgreSQL, SQL Server, Data transformation.

•Programming & Scripting: Python, R, SQL, PowerShell

•Automation & Workflow Tools: Power Automate, SharePoint, Power Apps, custom workflows

•System Integration & Security: REST APIs, OAuth, Azure Security Center, compliance protocols, disaster recovery planning, API intergrations

EXPERIENCE

Youth Vine Nov 2024 - Present

Data Strategy Specialist Remote-San Diego, CA

•Administered SharePoint Online sites in our lean startup environment, configuring permissions and security groups to support rapid project delivery.

•Engineered real-time Power BI dashboards connected to Azure SQL Database, incorporating advanced DAX and Power Query

techniques to deliver instant, actionable insights for leadership.

•Partnered with cross-functional stakeholders to gather and document requirements for both workflow automation and executive reporting.

•Developed interactive Power BI and Tableau dashboards connected to Azure SQL Database, cutting ad-hoc report requests by over

60%.

•Built Power Apps forms and Power Automate workflows on SharePoint lists to streamline approvals and data collection-reducing manual steps by 40%.

•Automated sensitivity label application and retention-policy enforcement using Power Automate and Microsoft Purview APIs, resulting in zero compliance findings during quarterly audits.

•Designed and maintained backup and recovery routines leveraging SharePoint retention settings, documented restore procedures, and ran quarterly drills to ensure business continuity.

•Extracted, cleaned, and transformed large datasets from Azure SQL and on-premises SQL Server; conducted trend and competitor analyses using predictive modeling to inform strategic planning.

• Conducted trend and competitor analysis using predictive modeling to identify business growth opportunities and support strategic planning.

•Integrated disparate data sources via Azure Data Factory and Power Platform connectors, centralizing reporting and improving data consistency across BI dashboards.

•Supported data-governance frameworks with Microsoft Purview and Azure Data Lake, enforcing data quality rules and supporting audit-ready documentation.

•Crafted scalable data models and custom reports in Excel, Power BI, and Tableau to support budgeting, forecasting, and performance tracking.

P-Koncepts Pixel Studio Dec 2023 - Aug 2024

Business Intelligence Analyst- Information Systems Remote- Hyderabad, India

•Extracted, cleaned, and analyzed large datasets from SQL databases, ensuring high-quality, reliable data to drive business insights and decision-making.

•Performed data wrangling and transformation using SQL, creating complex queries to manipulate raw data into actionable insights for business stakeholders.

•Designed and developed interactive dashboards and reports with Power BI, delivering real-time analytics on key business metrics, including sales performance, resource allocation, and financial forecasting.

•Conducted in-depth data analysis and trend forecasting using Tableau and Excel, offering insights into customer behavior, market trends, and operational efficiencies.

•Facilitated requirement-gathering sessions with business stakeholders to define data needs, KPIs, and reporting objectives.

•Translated business requirements into technical specifications, designing interactive Power BI dashboards.

•Built integrations between Power Automate and backend SQL systems, automating workflows and improving data availability.

•Leveraged Azure Data Factory to manage ETL processes, integrating data from multiple platforms to create a centralized data repository, improving consistency and accuracy in reporting.

•Collaborated with cross-functional teams to define KPIs, translated them into data requirements, and built custom reports and dashboards to align with strategic objectives.

•Produced actionable business insights by analyzing performance data and identifying bottlenecks using SQL and Power BI, supporting executives in making data-driven decisions.

•Delivered regular reports and presentations to stakeholders, using Power BI for data visualization and Excel for financial modeling, making complex data accessible and easy to interpret.

•Mentored junior analysts and helped integrate best practices in SQL, Power BI, and Power Automate to enhance team efficiency and data literacy.

School of Business, Stevens Institute of Technology. Sep 2022 - May 2023

Graduate Assistant Hoboken, New Jersey

•Updated alumni database by scraping data from multiple portals, facilitating the formation of new alumni panels.

•Enhanced network building by conducting surveys for prospective students and organizing informational sessions for international students via Zoom.

•Volunteered in the accounts department, serving as a grader, and played a key role in establishing a board for the MSIS department in the School of Business by conducting various research and selecting alumni members.

Siddhartha Institute of Medical Sciences Apr 2021 - Jun 2022

Business Analyst Krishna, India

•Spent a lot of time talking to both academic and administrative staff to understand their challenges and needs and then worked on translating those into practical solutions.

•Acted as liaison between academic departments and technical teams to gather feedback and iterate on system improvements.

•Created dashboards in Power BI to give leadership a clear picture of student enrolment, performance, and trends, which made their decision-making much quicker and easier.

•Used SQL to organize student data into proper models and set up automated reports in Excel to save everyone from manual work.

•Mapped out existing workflows using tools like Lucid chart and Visio, so we could figure out where things were slowing down and plan improvements.

•Defined and documented business requirements and translated them into process improvement initiatives, collaborating with IT and administrative stakeholders.

•Regularly cleaned and validated data from different sources to ensure everything was accurate and aligned across systems.

•Centralized student records using Azure SQL Database, making it easier for teams to access and work with the data they needed.

•Automated repetitive tasks like data entry and report generation using Power Automate, which helped save a lot of time for the admin teams.

•Held weekly review meetings with key stakeholders to share updates and gather their input, which kept everyone on the same page and ensured smooth progress.

•Made sure all data handling followed institutional guidelines, keeping everything secure and compliant with policies.

Siddhartha Institute of Medical Sciences Sep 2020 - Mar 2021

Junior Business Analyst Krishna, India

•Helped the team roll out a Learning Management System (LMS), where I mainly worked on making sure the data moved over correctly, and the system worked as expected during testing.

•Used SQL and Power BI to analyse student enrolment trends and academic performance, which were then used by leadership to plan course offerings.

•Created easy-to-use dashboards and reports for the faculty to track student performance without digging through raw data.

•Sat with staff to get their feedback on the new system and worked on incorporating their suggestions to make it more user-friendly.

•Assisted senior analysts in documenting requirements and creating process diagrams to ensure we were all clear on what needed to be built.

•Responded to ad hoc requests for data using Excel and SQL, whether it was for last-minute presentations or specific operational needs.

•Helped prepare training materials and guided staff on how to use the LMS, making the transition smoother for everyone.

•Looked at how similar institutions were using their systems to suggest ideas we could adopt or improve on.

•Shared weekly updates on key metrics like student retention and performance with leadership, ensuring they had the right information to make decisions.

•Worked closely with senior analysts on improving how we managed and secured student data, making sure it was accurate and handled properly.

PROJECTS

University Admissions & Enrolment Reporting

•Integrated multiple data sources to create automated reporting systems, utilizing Power Automate and Power BI for real-time data analysis and visualizations.

•Streamlined data collection and reporting, improving efficiency and providing actionable insights for student retention and course offerings

E-Commerce Product CatLog Optimization

•Analysed and optimized a dataset of 33,000 products using SQL and Python for insights on sales trends, product performance, and pricing strategies.

•Developed Power BI dashboards for tracking sales and customer behaviour, leading to targeted marketing and strategic decision-mak-

ing.

Healthcare Analytics for Patient Data

•Utilized SQL and Power BI to analyse patient outcomes and treatment effectiveness, driving data-driven decisions in healthcare management.

•Automated daily reporting and developed a predictive model for patient recovery, optimizing treatment plans and resource allocation.

Cybersecurity Problem and Solution Development in Health and Finance

•Identified and mitigated cybersecurity risks using structure diagrams and cost-benefit analysis, emphasizing solutions like multi-layered security, email filtering, and two-factor authentication.

•Developed strategic recommendations for the health and finance sectors, ensuring compliance with security protocols and reducing data breaches.

Research Project - State Bank of India

• Conducted market research on SBI's loan products, analyzing demographic trends using SPSS and Excel.

• Designed customer feedback surveys using stratified samples to gather representative data.

• Identified customer pain points and product gaps through statistical analysis.

• Recommended process improvements and product strategies to enhance customer satisfaction.

• Presented actionable insights to SBI's senior management to inform strategic planning.

IT Strategy of Amazon Whole Foods

•Analysed Amazon's IT strategy and its role in the expansion of Whole Foods, focusing on cloud technology, automation, and supply chain optimization.

•Used Tableau for visual analytics to assess operational efficiencies and provide actionable insights for business growth.

VOLUNTEER & INTERESTS

•Participated actively in Red Cross Blood Campaigns, promoting blood donation awareness in college and neighboring villages. Volunteered during campaigns, assisting doctors.

•Demonstrated leadership as the School Throw Ball team Captain and engaged in various extracurricular activities, including Youth festivals, Essay writing, and Elocution competitions.

•Involved in fundraising for non-profit organizations and earned recognition for musical talents, winning awards in school-level music competitions organized by local entities.

•Fundraisers at Cherish Foundation conducted various fund-raising campaigns for a Non- Profit Organization.

•English club team member and leader conducted debated and seminars on different topics in English on various occasions to improve the knowledge in English.

Contact this candidate