Shivani Bhale

As the Business Intelligence Analyst for the OTIS Elevators project, I played a pivotal role in enhancing data-driven decision-making processes through the implementation of QlikSense. The project aimed to improve the overall understanding of business data, streamline reporting, and optimize data storage.

• Collaborated closely with business users to understand data needs, developing solutions for quality decision-making.
• Identified and managed budget, timescale, and scope changes, recommending actions for project goals.
• Performed data visualizations in QlikSense (Cloud/On Prem), receiving consistently positive client feedback (e.g., OTIS Elevators).
• Gathered and defined technical requirements for database designs and updates.
• Worked on optimization and storage of data via QVD creation.
• Planned and implemented data governance and security measures in QlikSense to safeguard vital business data.
• Built, reviewed, and maintained data models to meet business requirements.
• Demonstrated expertise in QlikSense architecture, data connections to ODBC/Excel/Folder, and Data Load Editor usage.
• Hands-on experience in QlikSense back-end (data part) and front-end (data visualizations), including Master Dimensions, Master Measures, and Set analysis expressions.
• Analyzed requirements, highlighted gaps/inconsistencies to clients, and provided end-to-end solutions for product development.
• Managed requirements throughout project lifecycle to ensure delivery as specified, conducting change impact assessments.
• Analyzed large datasets, drew meaningful conclusions, and provided actionable recommendations.
• Coordinated cross-functional teams in delivering data input, extraction, and analyses.
• Successfully managed/handled and completed four projects simultaneously within six-month period.

This project not only enhanced the organization's data-driven decision-making capabilities but also showcased my ability to manage complex BI projects effectively.

As the Subject Matter Expert for HR Analytics projects at TCS, I played role in leading and enhancing the analytics capabilities within the HR domain. This project aimed to optimize HR processes, provide insights through visualizations, and implement robust data security measures.

• Serve as the Subject Matter Expert for HR Analytics projects, leading meetings with clients and internal teams to facilitate project completion and providing status updates.
• Successfully led teams of 10, achieving productivity KPIs and ensuring seamless project execution.
• Developed visually appealing Dashboards, Analytics, and Reports for HR Analytics using QlikSense script editor.
• Worked on QlikSense Mashups for TCS SBWS Policies, utilizing scripting functions like Lookup, Applymap, Where clause, Where exist, Match, Wildmatch, Qualify, Unqualify, and implementing Data Level Security/Section Access.
• Applied hands-on experience in creating calculation views in SAP HANA based on business requirements.
• Proficient in SQL scripting, including DDL, DML, Joins, With-clause, Where, Case statements, Date formatting syntax, and Group by clause.
• Coordinated with business stakeholders, being accountable for end-to-end project delivery and workstream management in the project process.

This project has enhanced the HR analytics capabilities at TCS and also showcased my leadership, technical expertise, and ability to implement secure and efficient data processes.

I played a key role in analyzing, processing, and enhancing data to address customer inquiries and improve the functionality of QlikView Dashboards. This project focused on optimizing data handling processes, ensuring prompt responses to customer queries, and maintaining the efficiency of QlikView applications.

• Analyzed data and information to identify issues, employing critical thinking to create tailored solutions.
• Handled high-volume data to address customer inquiries and concerns, ensuring prompt and accurate responses.
• Used critical thinking to break down problems, evaluate solutions and make decisions.
• Deployed and Handled Qlikview Hygiene Activity to make all folder to nfs4 upgraded structure.
• Worked on creation of databases and Autosys jobs for Qlikview Dashboards, ensuring seamless functionality.
• Understanding of existing code flow to provide resolutions to production issues
• Interacting with Users to ensure timely delivery of Qlikview Dashboards/Applications.

This project has addressed data quality issues and enhanced QlikView Dashboards and showcased my ability to handle high-volume data, collaborate with users, and ensure the seamless functionality of critical business applications.

The project aimed to optimize data transformation processes, ensure regulatory compliance, and improve decision-making through advanced data visualization.

• Developed and executed Perl scripts for precise data mapping from Universe, ensuring accurate data transformation.
• Demonstrated an in-depth understanding of Data Warehouse concepts, including OLAP, Star schema, and data modeling using normalization techniques , Business process analysis, Physical and Logical Data Modeling, Fact & Dimension Tables.
• Conducted regulatory reporting via Business Intelligence tools, ensuring compliance with industry standards and regulations.
• Implemented data visualization tools to effectively communicate research findings, enhancing understanding and decision-making processes.
• Applied advanced data visualization techniques using SAP Boxi to demonstrate project progress through charts and graphics.

This project has improved decision-making through advanced data visualization techniques, showcasing my expertise in both technical and business aspects of data analysis.