Business Intelligence Analyst with 7+ Years Experience

HEMALATHA KANDERI

MILWAUKEE, WI • 414-***-**** • *********.********@*****.*** • www.linkedin.com/in/hemalatha-157a1712b SUMMARY

Results-driven Business Intelligence Analyst with 7+ years of experience in BI, data analytics, and cloud platforms. Expert in QlikSense, Power BI, Tableau, SQL, Python, Azure, and AWS, delivering data-driven insights and optimized business processes. SKILLS

Business Intelligence Tools: QlikSense, Qlikview, Nprinting, Mail and deploy, Qlik SAAS, Power BI and Tableau CRM/ERP: Microsoft Dynamics 365 Sales, SAP Suit.

Programming languages: Python, HTML, CSS.

Cloud Platforms: Microsoft Azure (VMs, Storage, Active Directory), Azure Data Factory, AWS. Database Technologies: PostgreSQL, MySQL, SQL, Oracle, PL/SQL. Methodologies: Agile, Waterfall, SDLC, STLC (Unit Testing, Integration Testing), Microsoft 365, Object-Oriented Programming. WORK EXPERIENCE

• Leading a team of 4 from Project Initiation, requirement gathering to deployment and supporting hyper care etc.,

• Developed automated Power BI reports and dashboards with scheduled refreshes, incremental refresh, and row-level security

(RLS) to support secure, role-based access across finance, sales, procurement, and operations teams.

• Created Qlik Reporting solutions to a manufacturing client by automation of 15+reports which impacts to bottom Line of the Business.

• Designed Star& Snowflake data models based on business use case by maintaining the performance of the report which impacts in UI to update 4 min to 10 sec which is a game changer in the dashboards.

• Created financial and operational dashboards covering revenue analysis, cost optimization, inventory movement, demand forecasting, margin analysis, and performance tracking across regions and products.

• Guided health care/Pharma client to integrate into multiple systems (SAPBW, Snowflake, Databricks) by extracting raw data and performing ETL activities on 100’s of GBs.

• Deigning of nprinting reports to users in HTML, PDF & excel versions.

• Handling Administration requests and server maintenance activities and RBAC access etc.

• Designed and developed predictive traffic accident analysis using Python and Power BI, providing insights for road safety improvements.

• Led a large-scale Power BI implementation, combining complex data sources to significantly improve decision-making speed

(40% increase).

• Championed a collaborative BI strategy across departments, resulting in much faster report creation by 50%.

• Initiated data extraction from website using python API’s, which saved by 1day of resource.

• Conducted Implemented Microsoft Dynamics 365 Sales to streamline campus processes.

• Extracted and analyzed data from shopping websites using Power Automate and conducted trend analysis.

• Created business requirement documents (BRDs), functional requirement documents (FRDs), and process documents.

• Managed hospital data analytics using QlikSense, Power BI, and Azure Admin platforms.

• Automation of excel dashboards to Qlik reports which saved 2 days of time of an employee on every week.

• Conducted essential training on Qlik dashboards, empowering stakeholders to translate data into actionable business intelligence.

• Understanding of APLD datasets, Patient behavior, and Engagement/Customer Adoption pulse on drugs, which Streamlined business to take key decisions for further investments.

• A deep dive into key metrics like drug claim volume, treatment cost, insurance coverage percentages, claim rejection reasons, and approval rates provided valuable insights benefited 30 to 40 Stakeholders in saving their time.

• Based on the recommendation engine, integrated with a Qlik dashboard, empowered a business to select the right marketing platform, driving a 1.2% lift in global drug sales.

• Data Analysis on APLD and EMR Data to know metrics of patients attended clinical trials, Rx, NRx, TRx analysis by each physician on various brands by raising 0.2% Rx, NRx. Business Analyst Project Intern - University of Wisconsin Milwaukee Jan 2024 – May2024 Sr. Associate Projects-BI& Cloud Administration - Cognizant Technology Services Jun 2023 – Jan 2024 Lead Business Intelligence Developer/Data Analyst - Sharp IT Inc Aug 2024 – Present

• Collaborate with stakeholders to gather business requirements and translate them into technical solutions.

• Configured Active Directory, security roles, and data connections for analytics platforms.

• Designed and developed interactive dashboards using QlikSense, Power BI, and Tableau.

• Built Power BI data models using star and snowflake schemas, optimized relationships, and applied advanced DAX measures

(YTD, MTD, YoY growth, rolling averages, contribution %, variance analysis) to support accurate and fast reporting.

• Worked closely with business stakeholders to gather requirements, translate business questions into analytical solutions, and deliver insights that influenced pricing, procurement planning, production optimization, and sales strategies.

• Designed interactive and user-friendly visualizations using slicers, drill-throughs, bookmarks, and tooltips, enabling non- technical users to quickly identify trends and anomalies.

• Supported daily, weekly, and monthly executive reporting, providing leadership with actionable insights on business performance, digital initiatives, and operational health.

• Improved dashboard performance by optimizing DAX calculations, reducing data load size, and applying best practices, resulting in faster refresh times and better user experience.

• Led QMC Handling, installation, upgrades, and security configurations for BI platforms.

• Conducted ETL processes using SQL, Python, and optimized data processing workflows.

• Migrated QlikView to Qlik Sense, improving dashboard performance by 20%.

• Managed Qlik Replicate pipelines and SAP to CRM data flows.

• Configured and maintained Azure Active Directory, Virtual Machines, and Storage Accounts.

• Created custom administrative dashboards to monitor server health, job queues, and license allocations.

• Provided 24x7 production support, resolving tickets via ServiceNow and managing system outages.

• Developed data governance frameworks, improving data quality and security compliance.

• Assisted in evaluating and implementing new BI and data analytics technologies to improve reporting capabilities. EDUCATION

Master of Science in Information Technology (GPA – 3.7/4.0) Jan 2024 – May 2025 University of Wisconsin, Milwaukee, WI, United States Bachelor of Technology (GPA – 3.6/4.0) May 2013-May 2017 Siddarth Institute of Engineering and Technology, Andhra Pradesh, India PROFESSIONAL CERTIFICATIONS

• QlikView Business Analyst

• QlikView Data Architect

AWARDS

• Awarded “Rising Star” at Capgemini for outstanding project performance.

• Recognized with “Top of the People” award for contributions to Grupo BIMBO project.

• Honored with "Top Performer of the College" award in Bachelor of Technology for exceptional academic achievements. Consultant-Business Intelligence & Data Analytics -Capgemini Technology Services May 2017 – Jun 2023

Contact this candidate