HEMA MALINI

• Designed and developed reports and dashboards using the Power BI platform. Gathered data from various sources including SAP, SharePoint, and Excel.
• Developed a VM Server dashboard and set up a scheduled refresh in Power-BI.
• Collaborated with the finance team to develop a financial reporting dashboard resulting in a 50% reduction in report development time.
• Developed ITIM Ticket dashboard to track the ticket management status based on number of tickets by priority, tracking response time, ticket volume and resolution rates.
• Used several DAX functions to improve the report and meet targets.
• To implement, manage and monitor our company’s cloud environment using Microsoft Azure.
• Experience interpreting Software license types and models.
• Strong analytical and problem-solving competency.
• Worked on the effective management, control, and protection of the software assets within an organization throughout all stages of their lifecycle.
• Enhanced skills in Cyber Security based on application and cloud.
• Collaborating with Microsoft workshops and enhanced advanced features in MS office including Copilot.
• Worked under Compliance to help professionals manage an organization risks and reputation.
• Hands on experience on Advanced MS Excel and outlook to manage various tasks in compliance.
• Worked on all transformations in Power query editor.
• Created custom visuals based on client requirements to enhance the dashboard on a best way.
• Co-ordinate with each department of IT team to manage all tasks effectively.

● Understand the Business requirements and translate it into the technical requirements for the end users.

● Using Power-BI, create dashboards and interactive visual reports.

● Define Key performance Indicators (KPIs) with specific objectives and track them regularly.

● Converted business needs into technical specifications and established timetable for job completion.

● Good knowledge in Excel using Vlookup, Hlookup, Xlookup, charts,Pivot, etc..

● Worked on all types of transformations in Power Query Editor.

● Created calculated columns and measures using DAX functions like SUM, SUMX, SAMEPERIODLASTYEAR, PARALLEL PERIOD, YTD, MTD, QTD, COUNT, etc…

● Developed visual reports, KPI Scorecards using Power BI Desktop.

● Worked on filters in Page level, Report level & Drill through.

● Enabled Row-level-security in a static way for different users to access the Reports.

● Imported custom visuals as per the client requirements.

● Created bookmarks and buttons to deploy the reports in Power BI workspace.

● Developed Dashboards in Power BI Service.

● Participated in requirement gathering, design and develop report and analysis projects.

● Managed relationships between the tables and created a data model star schema.

● Prepared dashboards using calculations measures in Power BI.

● Created analysis reports using various charts like bar chart, pie chart, waterfall chart, Gauge chart, matrix & tables, etc…

● Imported Custom visuals as per the client requirements.

● Implemented Row-level-security on data.

● Created Bookmarks by using Selection Pane.

● Designing, Developing, Implementing business Intelligence solutions.

● Creating data models and building reports and multiple dashboards for various stakeholders.

● Keeping data updated and accurate.

● Troubleshooting and resolving any issues in Power-BI platform.

● Collaborating with stakeholders to understand business requirements and translating them into data visualization solutions.

● Used Power-BI to run DAX Queries and functions.

● Used SQL queries and excel for testing reports.

● Worked on all transformations and implemented best practices using Power Query and M-Query.

● Perform basic data analysis and calculations using DAX functions under the guidance of senior team members.

● Assist in integrating data from multiple sources into Power BI, ensuring data consistency and accuracy.

● Maintain documentation for reports, data sources, and data transformation processes.

● Develop and maintain data models, including establishing relationships, hierarchies, and calculated columns. Manage data integration tasks, including data source connections and data transformation processes.

● Implement advanced features like bookmarks, drill-through actions, custom themes, and custom visuals.

● Understand source systems and customer requirements.

● Imported existing applications from Qlik sense Management Console (QMC) and reloaded each application in Qlik Sense HUB.

● Implemented Binary load in presentation layer for fast data loading using 4-Tier Architecture.

● Analyzed data and business requirements and created data model Star Schema.

● Prepared dashboards and analyzing reports using various Qlik Sense objects as per

● the user’s requirements.

● Responded to the queries raised by users and promptly updated with feedback and resolutions.

● Implemented multiple Ad-Hoc reports by using Qlik Sense Hub.

● Hands on Experience in report testing, data validation and functional testing in each stage of Qlik Sense applications.

● Created Customized Reports using Set Analysis.

● Used Incremental loads for better data loading on reload time consumption.

● Applied Section Access to restrict data for different users.

● Created new tasks and modified existing reports with Qlik Sense N-Printing.

● Resolved the Problems/ Tickets raised by the Business Owners and Users.

● Communicated with clients on ticket status and clarifications on applications.

● Worked on enhancement activities.

● Weekly updates to the team lead regarding the SLA and Tickets issues.