Pavan Kumar Email & Phone Number

Canada

Toronto, Ontario, Canada

• Designing and developing the POC’S according to business users.• Developing the best practices and driving the code to across development, test and Pre-Prod and Production environments.• Creating the Daily jobs for data dumps for various teams.• Responsible for Data analytics migration from Tableau to Power BI.• Designed and developed the migration of Data Analytics to Power BI.• Designed and developed the dashboards, Scorecards and KPI’s in the Power BI.• Experience in developing the Calculated columns and Measure in the Data Analysis Expressions (DAX).• Design and develop the RLS (Row -Level-Security).• Implemented the best practices to speed up the data refreshed or load the data model.• Design and Developed the Data marts as per the Business requirement.• Migrated the existing Microsoft excel and Tableau reports to Power BI.• Experience in using the M language for Data transformation in the Power Query.• Have experience in using the Bookmarks and Sync Slicers and Buttons extensively to Develop the Best User Experience.• Design and developed the MySQL Scripts for Data Dumps.• Extensively involved in deploying SSIS Packages, SSRS Reports and SSAS Cubes using command line utilities.• Extensively involved in Data Warehouse Star Schema Modeling, Snow-Flake Modeling, FACT& Dimension Tables, Physical and Logical Data Modeling.Environment: MS SQL Server 2016/2014/2008, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2014/2013/2012, C#, SQL Server Profiler, Azure Cloud, Azure SQL Database, Azure Data Lake, Azure Blob, Power BI Desktop, Power BI Service, Power Query, Power Pivot, Power Designer, Tabular Models, SQL Server Management Studio, Team Foundation Server (TFS), Business Intelligence Development Studio (BIDS), Business Objects, Jasper Soft Studio.

Toronto, Ontario, Canada

• Collaborating with application developers to optimize database interactions, working closely with developers to ensure efficient and effective data access and manipulation.• Promoting and supporting Power BI platform and user group community.• Developing custom SSAS components and tasks to meet specific business requirements, extending SSAS functionality as needed.• Creating custom components using SSAS object model, .NET, or other programming languages.• Developing and implementing data models in Power BI to support analytical requirements while ensuring data accuracy and consistency through ETL processes• Troubleshooting issues related to SSAS performance, data quality, and cube processing.• Collaborated with team to establish Git workflow that includes documentation tags for marking versions of project documentation in database code.• Performing meticulous capacity planning for OLAP and OLTP databases to accommodate future data growth and ensure scalability.• Implementing Power BI's direct query mode to analyze data directly from data sources without importing.• Implemented SQL server change tracking to monitor and capture changes made to specific database tables.• Creating interactive reports and dashboards with drill-through and drill-down functionality in Power BI, allowing users to explore data at different levels of detail.• Conducted BI data governance reviews to identify data ownership and data stewardship.• Proficiently configuring and managing package data profiling and data quality checks in SSIS, ensuring unparalleled data quality and accuracy during data integration.• Collaborating with database administrators to fine-tune report performance in SSRS, optimizing SQL queries and indexing to enhance report execution speed.• Configuring and managing ETL job dependencies and scheduling for efficient workflow orchestration.• Developed and maintained SQL scripts for database data validation and data profiling.

Hyderabad, Telangana, India

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiplehomogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).• Built cubes using Microsoft Analysis Services for faster reporting capabilities.• Collaborated with other stakeholders involved in the development process like project managers and analysts.• Designed dimensional models in Kimball methodology for data warehousing solutions.• Utilized advanced functions such as pivot tables, VBA Macros, and custom formulas in Excel spreadsheets to analyze data sets.• Optimized existing T-SQL code for better performance and maintainability.• Created reports using SSRS, Power BI, Tableau and Excel.• Provided technical support to users related to Business Intelligence applications and databases.• Worked on Creating Calculations using MDX and Supported DAX expressions which were using Pivottable reports.• Maintained up-to-date documentation of database objects including table structure, column attributes, relationships between tables.