KANIKA KANSAL

• Developed and implemented project plans for a wide range of consulting projects.
• Trained, coached, and mentored junior consultants on best practices in the industry.
• Conducted research to identify potential solutions to client issues.
• Provided strategic advice to clients on how to maximize the impact of their initiatives.
• Created detailed reports and presentations outlining results from consulting engagements.
• Analyzed data sets and identified trends in order to make informed decisions.
• Established relationships with key stakeholders across multiple organizations.
• Managed budgets, resources, and timelines related to assigned projects.
• Led meetings with internal teams and external partners as needed.
• Managing Users and Workspaces: Adding or removing users, assigning roles, and managing permissions
• Experience in Power BI Service Administration and Gateway configuration for multiple source systems.
• Deploy the Power BI models, Reports and Paginated reports to premium capacity
• Performance analysis and suggest best approaches to team to improve the performance.
• Developing Power BI data Models, Data Preparation with Data Flows and designing Power BI reports
• Good experience in consuming data from different sources and designing the Power BI Data Models
• Ability to work in team in diverse/ multiple stakeholder environment
• Conducted training sessions and workshops to educate users on Power BI features and best practices.
• Provided technical support and troubleshooting assistance to Power BI users, addressing issues related to report creation, data refresh, and visualization.
• Optimized report performance by identifying and resolving bottlenecks in data processing and visualization.
• Managed Power BI Premium capacities, including planning and allocating resources to meet organizational needs.
• Analyzed usage patterns and performance metrics to optimize capacity utilization and ensure efficient resource allocation
• Utilized Power BI performance analyzer and query optimization techniques to improve report loading times and responsiveness.
• Monitored system performance and resource utilization within Power BI capacities, identifying bottlenecks and optimizing capacity configurations.
• Evaluated capacity requirements based on business growth and data volume projections, recommending scaling options such as adding nodes or upgrading capacities.
• Coordinated capacity expansion projects, working with vendors and IT teams to procure and deploy additional resources as needed.
• Implemented performance tuning strategies to improve report rendering times and overall system responsiveness.
• Resolved capacity-related issues and incidents by troubleshooting performance issues, identifying root causes, and implementing corrective actions.
• Generated capacity usage reports and performance metrics to track usage trends, forecast future requirements, and support decision-making processes.
• Conducted capacity analysis and forecasting to anticipate growth and plan for capacity upgrades or migrations proactively.
• Provided timely support and escalation for capacity-related issues to minimize downtime and ensure continuity of service.
• Worked With team to move reports from Snowflakes to SYNAPSE SQL.

• As a part of Power BI Administration, configured Usage metrics, Users, Audit logs, Tenant settings, Dashboard settings, Power BI Apps settings, Power BI premium and Premium Capacity settings
• Performed subscriptions and refresh extracts in Power BI as well as set up data alerts on business-critical data utilizing Power BI service (SaaS)
• Work with multiple teams through all phases (Design, Development, Testing and Deployment) of project life cycle
• Adept in Power BI Desktop, Power BI service (SaaS), Power BI Gateway & performance optimization
• Created Workspace and Apps in Power BI and giving access to end users to Apps
• Implemented Data security (Row level security (RLS)) on Dataset and Reports in Power BI
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports
• Design and model datasets with Power BI desktop based on measure and dimension requested by customer and dashboard needs
• Develop interactive visuals using Power BI Desktop application
• Install and configure Power BI Gateways to keep the dashboards and reports refresh automatically
• Configure Power BI Report Server for SSRS, deployed and scheduled reports in Report Manager
• Create paginated reports using Power BI Report Builder for on-premises and cloud data sources
• Adroit in accessing and using PowerApps, Power Automate (MS Flow), and Power BI
• Experience building Power Automate (Flows), supporting multiple users on Power BI & Power Apps
• Maintained different levels of Data Security in Power BI while granting access to data and assigning Row Level Security (RLS) when needed
• Configures and maintains Premium capacity planning, updating, troubleshooting, access management and performance management
• Configured Capacity settings to assign users as Capacity Admins per capacity during initial setup of the capacity and later via User Permissions within the Premium settings
• Skilful in using Power BI features such as bookmarks, selection pane, drill down drill-throughs
• Created Power BI Apps using REST API and integrated with Power BI reports & dashboards
• Configured Tenant settings to give control over the PBI features such as (workspace settings, Export and sharing settings, Publish to web, Developer settings)
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Deployment of ETL solution, OLAP cubes and report promotions from one environment to another
• Expert in creating OLAP cubes, dimensions, business critical KPIs, and MDX queries using SSAS
• Experience as Analysis Services Cube Developer (OLAP) and Report Developer (SSRS)
• Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing
• Deploy SSIS Packages and Cube
• Experience with Azure data platform including Azure active directories, application creation
• Along with Power Bi Administration Worked as a functional Business analyst and handled a team of 10 People.

• MSBI (SSIS, SSRS) solutions Deployment, Data warehousing
• Involved in Planning, Defining and Resolving BI infrastructure problems
• Reports development for Business user using Power BI, and data source gateway creations
• Backup and Restore operation of OLAP Cubes
• Monitoring and troubleshooting incremental load to Data warehouse
• Involved in Root Cause Analysis related of Data warehouse problems
• Extensively involved in server level Incident, Problem and Change management
• Hands-on experience on Tabular Visualization, Matrix Visualization, Funnel chart, Pie chart, Scatter plot, and Sand dance plot
• Managing power Bi Gateway requests, PPDL creation, Port openings
• SQL Server Administration activities - Database Backup and Restore activities
• Managing logins, users, roles, permissions, and creation based on the level of database access
• Installing and configuration SQL Server
• Installing Service packs and Cumulative updates on SQL Servers
• Creating, scheduling, and monitoring Maintenance (Backup, Renidex, Reorg, Stats and Check DB) and other SSIS jobs
• Monitor database and windows log files for errors
• Handling creation of databases as per user request
• Monitoring the overall health of the SQL Server (CPU
• Memory, disk size, DB log size, blocking etc.

Project: IBASIS

IBASIS is a KPN company which deals with voice calls VOIP, LSX, GRX and IOT

Responsibilities:

· Providing Support on performance of SAP BI4.

· Troubleshooting of ETL processes using Oracle Data Integrator (ODI 11g) tool.

· Balancing load on IBM Netezza for better performance of BI servers

· Troubleshooting reporting issues.

· Working with database issues.

· Tool used are TOAD for ODI and Agility Workbench for Netezza and SSMS for database issues.

Troubleshooting and Monitoring on SQL and UNIX platform.