Vivek Kumar Email & Phone Number

Toronto, ON, CA

• Participating in team business requirements gathering, analyzing, understanding and converting them into database solutions with solid exposure to architecture, analysis, design, testing, development, documentation &.
• 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.

• 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.

• 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.

• 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.

Montreal, 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.

Montreal, 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

Montreal, Canada Area

• Conduct live programme with the audience and interact with them
• Collaborated with a team of Radio Humsafar to better improve the services

Mohali, 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

New Delhi Area, India

• Project on “DTMF LAND-ROVER” based on Embedded System Technology..
• Collaborated with one member; Programming applied: Assemble language, C++, Lab VIEW

Master Of Engineering (M.Eng.), Electical And Computer

Bachelor Of Technology (B.Tech.), Electronics And Communication Engineering