Business Intelligence Data Analytics Qlik Power BI Tableau

HEMALATHA KANDERI

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

IT professional with 7+ years of expertise in Business Intelligence, Data/Business analyst and cloud technologies. Experienced in using QlikView, QlikSense, and Power BI to design and manage dashboards that simplify complex data analysis. Proficient in Qlik admin, Qlik Replicate and Power BI admin, including user role management and system configuration, with hands-on experience in Azure cloud services. Committed to delivering efficient, data-driven solutions that empower better business decisions. EDUCATION

Master of Science in Information Technology (GPA – 3.7/4.0) Jan 2024 – Present 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 WORK EXPERIENCE

University of Wisconsin Milwaukee – Business Analyst Project Intern Jan 2024 – Present

• Analyzed, Designed and developed predicted traffic accident trends in Milwaukee using Python and Power BI.

• Conducted data preprocessing, visualization, and predictive modeling to provide actionable insights for road safety improvements.

• Executed data scraping from a shopping website using power automate and fetching the data into a structure form and working on data analysis and mining to find trend insights. Accomplished regression analysis using excel analysis pack, performed EDA by comparing input and output variables, calculated correlation matrix, single, multiple linear regressions and determined which input factors such as reviews and ratings impacted the movie sales.

• Developed an Oracle database using SQL as part of BUS ADM Data and Info management course where employee’s database was created for a packaging company, where CRUD, normalization, de-normalize, database schemas, attributes, data mapping, entity relations, PLSQL concepts were implemented for database management.

• Reviewed, analyzed, and evaluated business workflows, documenting key inputs, outputs, and data dependencies.

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

• Created test cases and executed test plans to validate data integrity and business process workflows.

• Defined and documented workflows, developed process documents, and identified key business inputs and outputs.

• Designed integrations of internal operational systems and created test plans and scenarios.

• Developed flowcharts using Visio and worked with REST services, Docker, Jenkins, AWS, and Microservices frameworks. Cognizant Technology Services – Sr. Associate Projects Jun 2023 – Jan 2024

• Managed Merck hospital data using QlikSense and Azure admin platforms like Active directory, including setting up licenses, data connections, and extensions. Collaborate with stakeholders to gather business requirements and translate them into technical solutions.

• Migrated applications from development to production and maintained the load balancers, monitoring and refreshing the applications, troubleshooting issues around the same and sending reports with triggers on daily/weekly/monthly basis.

• Monitoring VMs, servers, tracking CPU utilization, Memory, Network Utilization and performed patch upgrades.

• Automated report distribution via Mail and Deploy tool, enhancing communication efficiency.

• I participated in client and end-user meetings, handling incidents, requests, and modifying tickets according to priority, and resolving issues in line with root cause analysis (RCA) and service level agreements (SLAs).

• Implement Agile Scrum methodologies to ensure effective project management. Capgemini Technology Services – Consultant May 2017 – Jun 2023

• Designed and built interactive dashboards using Qliksense and Power BI, Nprinting, QMC Handling, installation, and Upgrades for various clients such as Syngenta and Grupo Bimbo.

• Utilized Python and SQL for extracting and analyzing software development datasets, leading to actionable insights and a 15% increase in development team satisfaction.

• Led scrum meetings to gather requirements, manage change requests, and deploy solutions.

• Created and maintained Business requirement documents for software projects, effectively communicated any inconsistencies.

• Assessed data quality, design data quality management procedures, clean and correct data quality defects, establish data governance.

• Partnered with peer groups of development, testing, deployment and stakeholders, business partners, ensure projects adhered to compliance guidelines and regulatory requirements.

• Business Analyst experience includes requirement gathering, stakeholder engagement, and process optimization.

• Data Analysis experience includes data visualization, report generation, and performance tracking using Power BI and QlikSense.

• Hands-on experience in Agile project management, ensuring timely deliverables and effective communication with stakeholders.

• Implemented risk mitigation activities by leveraging cyber security principles and regression testing for every application software upgrades.

• Leveraged training and collaborative skills with SME and LMS systems by coordinating in development, training, skill planning in guidance of scrum leaders.

• Installed, configured, and administered Qlik Replicate, QlikView, and Qlik Sense platforms, including QMC tasks such as managing streams, apps, user roles, and permissions.

• Configured and maintained source and target endpoints like VSAM, SQL, DB2, MySQL, ADLS, and Databricks for seamless data replication and synchronization.

• Migrated apps from QlikView to Qlik Sense and optimized dashboards, reducing load times and improving performance by 20%.

• Monitored and managed Qlik Sense and Power BI platform health, troubleshooting issues, analyzing logs, and recommending system improvements to ensure 99.9% uptime.

• Designed and developed interactive dashboards and automated reports using Qlik Sense, Power BI, and NPrinting, saving over 10 hours per week in manual effort.

• Led a team of 10+ members, resolving high-priority issues, conducting root cause analyses, and ensuring timely project deliverables. Trained teammates and new hires on Qlik administration best practices, enhancing their proficiency and reducing resolution times by 30%.

• Automated data refresh cycles, report distribution, and cleanup processes to optimize storage usage and improve operational efficiency by 30%.

• Implemented role-based access controls and SSO configurations (SAML authentication), ensuring enhanced data security and compliance.

• Collaborated with clients and stakeholders to gather requirements, deliver tailored solutions, and improve decision-making processes. Improved QlikView/Sense deployments by defining best practices, creating reusable templates, and setting up governance metrics to monitor system usage.

• Created custom administrative views and dashboards to monitor server performance, background tasks, license allocations, and job queues, enabling proactive issue resolution.

• Maintained system reliability through server migrations, backups, and periodic patch updates while ensuring minimal downtime during upgrades. Configured alerts and thresholds to monitor system performance, hardware utilization, and storage capacity, addressing potential bottlenecks proactively.

• Optimized report performance and reduced data processing times by leveraging advanced Qlik features like set analysis, dimensional modeling, and fact/dimension tables.

• Provided 24x7 production support, resolved tickets via ServiceNow, and managed incidents and service outages effectively.

• Supported endpoint database-to-database connections through Qlik Replicate, ensuring data consistency and accuracy across systems. Led efforts in Qlik Replicate operations, configuring endpoints and troubleshooting connectivity issues to maintain uninterrupted data flow.

• On the Azure admin side, I maintained Active Directory by adding users, managing roles, and permissions, monitoring VMs and storage, and performed system patch upgrades to ensure security and efficiency. PROFESSIONAL SKILLS

Business Intelligence Tools: QlikSense, Qlikview, Nprinting, Mail and deploy, Qlik SAAS, Qlik Replicate, Power BI,Cognos and Tableau 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: Waterfall, SDLC, STLC (Unit Testing, Integration Testing), Object-Oriented Programming, Business Requirement Analysis, Function requirement analysis, Business Process Modeling, Process optimization, Agile Project Management, Customer Relation Management (CRM). Software Tools: Jira, Jupyter, PyCharm, Eclipse, Microsoft Office Suite 365, service now. PROFESSIONAL CERTIFICATIONS

• QlikView Business Analyst

• QlikView Data Architect

EVIDENCE OF EXCELLENCE

• 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.

Contact this candidate