• 5+ years of IT experience working with Power BI / SQL. Worked in different domains like Insurance, Petroleum and Banking Organizations developing IT applications.• Certified Microsoft certified Data Analyst Associate with PowerBI• Responsible for building reports in Power BI from scratch.• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries. Used Performance monitoring tool of Power BI desktop to analyze the performance of heavy data dashboards and implemented the best practices to improve the end-user experience.• Expert in creating Partitions, Measures and calculated columns using DAX for quick issue resolution in large-scale production environments located globally.• Highly skilled in developing OLAP cubes using SSAS measures, measure groups and dimension members in SQL Server Analysis Services using Dynamic Analysis expression (DAX), mathematical formulae, and user-defined functions.• Expert Creating Tabular and Multidimensional cubes using SSAS Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.• Developed the SSAS Created reports such as Parameterized, Cascading, drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.• Developed and maintained tables, indexes, stored procedures, views, triggers and other objects utilizing the latest DML and DDL syntax.• Created solution driven dashboards using different chart types like Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Power BI and Tableau Desktop.• Experienced in technical support, troubleshooting, report design and monitoring of system usage.• End to End experience in designing and deploying data visualizations using Power BI.• Solid knowledge of Power BI and Tableau Desktop report performance optimization.• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map and Heat Map.• Expert on Microsoft Power BI and Tableau reports, dashboards and publishing to the end users for executive level Business Decision.• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Exceland Oracle.
-
Data Analyst And Data EngineerRbcToronto, On, Ca -
Data Analyst / Data EngineerRbc Feb 2022 - Present• Participating in team business requirements gathering, analyzing, understanding and converting them into database solutions with solid exposure to architecture, analysis, design, testing, development, documentation & implementation.• Worked on building reports for tracking Incidents & Change management on top of Service Now Data Using Service Now REST APIs to pull the data in Power BI.• Modelling the Data in Power BI to perform combined analytics and published to Power BI Service by implementing incremental refresh.• Worked on data integration & automation using PowerShell to pull data from email and load it to MySQL Database.• Performed Power BI Administration tasks such as managing Gateways, managing workspaces and publishing Apps for broader content consumption.• Worked on Power BI Embedded to make the report accessible through the company’s intranet portal. Automated Power BI Refresh using Power BI REST APIs in combination with PowerShell.• Conducted workshops and training for Business Users & Power Users on Power BI.• Created KPI's, Partitions, Perspectives, and Calculated Measures, DAX queries, Roles.• Involved in building tabular cubes with star schema and snowflake schema using SSAS.• Created calculated columns and measures using DAX.• Employed various version controlling by utilizing GIT tools.• Created change tickets for production migration.• Understanding of change management procedure,provided end users training.• Using Smart sheet for workflow management – Managed projects, setting up automated workflows to prioritize the importance of different iterations throughout projects.• Used SharePoint to manage documents, collaboration, and meet deadlines.SQL Development & Support - SQL Development, Reporting, Develop Implement & Maintain Databases, and Fixed Data load issues by creating, testing and debugging SQL (MS SQL, MySQL, and Oracle) codes.Environment: PowerBI, Python, Business Objects, Oracle SQL Server, SQL Scripting MS Excel
-
Data Analyst / Data EngineerCenovus Energy Canada Apr 2020 - Jan 2022• Designed, developed and tested various Power BI visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.• Experienced in Microsoft Power BI (Desktop, Pro, Mobile, Power Bi Report Server).• Built and published customized interactive dashboards utilizing Power BI.• Created the data model by pulling the data from multiple sources and transformed the raw data into business information by applying the transform rules.• Developed and rendered monthly, weekly, and daily reports as per the requirement and given roles, user access with respect to security in report manager.• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.• Designed and created OLAP cubes for data warehouse. Designed a partitioning strategy to refresh cubes effectively. Test and validate OLAP cube in different environments.• Created both star schema and snowflake schemas using SQL Server Analysis services.• Created scripts in XMLA to deploy in different environments.• Created and transformed data such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time column, etc.• Created linked servers using ODBC drivers.• Created dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.• Created calculated columns and measures using DAX.• Import data from different data sources to create Power BI reports and dashboards.• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.SQL Development & Support - SQL Development, Reporting, Develop Implement & Maintain Databases, and Fixed Data load issues by creating, testing and debugging SQL (MS SQL, MySQL, and Oracle) codes.Environment: PowerBI, Python, Business Objects, Oracle SQL Server, SQL Scripting MS Excel
-
Data Analyst / Data EngineerSharp Insurance Canada Aug 2019 - Mar 2020• Develop enterprise Business Intelligence (BI) solutions using PowerBI.• Import data from different data sources to create Power BI reports and dashboards.• Involved in creating dynamic well-organized, accurate, and insightful Power BI reports/dashboards to support strategic decisions.• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.• Server and storing the data in Azure SQL Server using Blob Storage and creating reports using Power BI Desktop.• Expertise in data transformations such as adding calculated columns, managing relationships, creating different measures, remove rows, replace values, split column, Date & Time Column, etc.• Created different reports in Power BI Desktop and published to Power BI Service.• Strong knowledge of SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database. Used MDX to create custom groupings, parameters, named sets, main reports and sub-reports(including reports with line and pie charts).• Expert in developing Power BI Reports and dashboards from multiple data sources using data blending and composite models.• Worked on Power BI desktop and power BI service to publish the reports. Able to implement row level security on data and understand application security layer models in Power BI. Defined the report layout in SSRS. Created complex stored procedures for reporting services, Analyzed Reports, and Fixed Bugs in stored procedures.• Develop tabular and multidimensional models that are compatible with warehouse standards.• Implemented SSIS packages to load the Data into Staging, ODS, and dimensional models.• Developed Lookup Transformation package for data matching, compare source and destination data based on id, and get the new and updated records, and then used conditional split to select those new records before inserting into the database
-
Data AnalystShaw Communication, Toronto, Ontario, Canada May 2018 - Jul 2019• Understanding business requirements documents and developing design documents. • Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.• Installed and configured Power BI Desktop.• Created Power BI Visualizations and Dashboards as per the requirements.• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server, and Flat files.• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.• Created SSIS packages to integrate the data coming from flat files.• Migrated SSIS Packages from during data migration.• Optimized queries by looking at Execution Plan for better tuning of the database.• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.• Performed database backup and deployment to the production server.• Involved in modifying existing Data Stage Jobs for better performance.• Created detail technical documentation of various staging area operations for future reference and guidance.• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2008/2012).• Installation and configuration of SQL Server Reporting Services (SSRS).• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
-
Junior Account ManagerFma Summits Aug 2016 - Apr 2018Montreal, Canada Area• Providing Business Consulting to companies that provide turnkey solutions if different technologies that can benefit National Corporations.• Achieve and surpass their strategic goals of energy efficiency, cost, usage & environmental footprint reduction within their facilities. -
Customer Experience RepresentativeGreenwich Associates Jan 2015 - Jun 2016Montreal, Canada Area• Reporting directly to the Contact centre manager.• Conduct telephonic customer experience interviews within Canada and USA for our clients• Develop and maintain productive and harmonious relations with respondents of assigned surveys -
Radio JockeyRadio Humsafar Jun 2014 - Dec 2015Montreal, Canada Area• Conduct live programme with the audience and interact with them• Collaborated with a team of Radio Humsafar to better improve the services
-
Punjab Communication LimitedEngineering Internship Jul 2012 - Dec 2012Mohali, Punjab• Assembling ad testing of PLCC (power line carrier communication) components and modems.• Maintenance of quality documentation such as product specification and technical specification.• Collaborated with one member; Programming applied : Assemble language, C++ , Lab VIEW
-
Cmc Limited(A Tata Enterprise)Engineering Internship Jun 2011 - Jul 2011New Delhi Area, India• Project on “DTMF LAND-ROVER” based on Embedded System Technology..• Collaborated with one member; Programming applied : Assemble language, C++ , Lab VIEW
Vivek Kumar Education Details
-
Electical And Computer -
Electronics And Communication Engineering
Frequently Asked Questions about Vivek Kumar
What company does Vivek Kumar work for?
Vivek Kumar works for Rbc
What is Vivek Kumar's role at the current company?
Vivek Kumar's current role is Data Analyst and Data Engineer.
What schools did Vivek Kumar attend?
Vivek Kumar attended Concordia University, Punjab Technical University.
Who are Vivek Kumar's colleagues?
Vivek Kumar's colleagues are Alexandre Charron, Md Zihad Hassan Robin, Sushila Narayan, Prithvi L., Gary Cross, Helen Gatama, Skye Wang.
Not the Vivek Kumar you were looking for?
-
3bluecatnetworks.com, cira.ca, bluecatnetworks.com1 (416) 6XXXXXXX
-
Vivek Kumar
Infrastructure Management | Linux Admin | Cloud Admin | Devops | Infrastructure AutomationBrampton, On -
Vivek Kumar
Canada -
Vivek Kumar
Greater Toronto Area, Canada
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial