0ver 9+ years of IT experience in Database Design, Development and Business Intelligence (Power BI desktop, Power BI desktop Pro, Power BI Service, Power BI report server, Tableau), and other related IT development technologies like MS BI Stack (MS SQL Server, SSIS, SSAS, SSRS), MS Excel PowerPivot, Informatica power center & connect.4 years of experience in Power BI desktop, power BI service and power BI Admin.Experienced in Data Modelling, designing and developing Power BI reports with data sources such as ETL Loads, SSAS Cubes, Impala and various heterogeneous data sources using both Import and Direct Query/Live Connection Modes.Experience in Analysis, Design, Development and Implementation of Client/Server and Data warehousing using SSIS, Informatica Power Center.Data Modeling knowledge using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.Hands on expertise on snowflake cloud warehouse. Experience in migrating other databases to Snowflake.Experience including analysis, design, development of reports and dashboards for analytics.Develop Power BI reports, Custom Visuals, Groups Creation and effective dashboards after gathering and translating end user requirements.Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX Query.Expertise in writing DAX, Power Query formulas and creating KPI's based on client requirements.Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter Plots, Tree Maps, Heat Maps using Tableau. Experience writing Complex SQL code. Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using PL/SQL.Hands on experience on ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS, Informatica by creating mappings/workflowsWorked in creating complex stored procedures, SSIS packages, triggers, cursors, tables, views and other SQL joins and statements for applications.Building the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose and created SSRS reports.Developed, scheduled and generated variety of reports like List, Matrix, Drill-Down, Chart and Sub Report and standardize company report by implementing SQL Server Reporting Services SSRS.Used Power Automate to automate repetitive tasks and processes.Certified PL(300) & Snow pro.
Hd Supply
View- Website:
- hdsupply.com
- Employees:
- 10679
-
Power Bi Developer And AnalystHd SupplyCalgary, Ab, Ca
-
Power Bi Developer/AnalystHd Supply Sep 2020 - Present• Interact with business stakeholders to gather detailed business requirements and Convert business needs into technical specifications. Designed appropriate BI solutions to measure trends and performances. • Involved in data migration of on prem server to snowflake cloud.• Worked on Snowflake modeling and highly proficient in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment . Define roles, privileges required to access different database objects.• Worked on external stages to ingest the data from Azure Blob storage to Snowflake through copy command and snow pipe and also used SnowSQL ,scheduled the jobs in ADF pipelines.• Developed, published, and managed reports & dashboards using Power BI.• Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.• Involved in Performance Tuning of the Dashboard and Storyboard by making the required changes effectively.• Created/Managed groups, Users, Workbooks, Data sources and data connections in power BI services.• Created the KPI to show the difference between actual and forecast data.• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging• Created several user roles and groups to the end - user and provided row level security to them.• Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters.• Worked on scheduling refresh of Power BI reports, hourly and on-demand.• Created Tableau dashboards using Side by side Bar graphs with a combination of Line charts on top of Bar graphs, Donut charts, Tree maps and Tabular charts.
-
Power Bi Developer/AnalystBison Transport Inc. Oct 2017 - Aug 2020Brampton, Ontario, CanadaInvolved in gathering the requirements with business users Connect to different Data sources from Power BI.Responsible for providing the securities for reports/dashboards by assigning roles.Involved in Designing, building and deploying data reports/dashboards for large volumes of data in Power BI.Extensive use of DAX (Data Analysis Expressions) functions for the reports and for the tabular models. Created calculated measures and columns with DAX in MS Power BI Desktop.Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI desktop.Worked on data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.Combined data from different sources by using power query.Generated periodic reports based on the statistical analysis of the data from various time frame and division using power pivot, power query, power view.Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.Applied the business rules on the data coming from multiple operating companies and maintained the rules in a table for visibility to all required processes to develop Power BI reports & effective dashboards.Loaded the processed data into final view point centralized DWH for further Power BI reporting.Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.Wrote Calculated Columns, Measures, and Queries in Power BI desktop to show good data analysis techniques.Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.Created Interactive reporting dashboards by combining multiple views using Tableau Desktop.Worked to Set up a trigger using Power Automate that activates the flow when a new expense report is submitted.
Frequently Asked Questions about Hari R
What company does Hari R work for?
Hari R works for Hd Supply
What is Hari R's role at the current company?
Hari R's current role is Power BI Developer and Analyst.
Who are Hari R's colleagues?
Hari R's colleagues are Brian Parke, Karen Carrasco, Robert Willis, Frank Danker, Ryan Reid, Kassandra Gunther, John Meagher.
Not the Hari R you were looking for?
-
Hari R Pillai
Internationally Trained Anaesthesia Assistant | Counsellor | Developmental Support Professional | Healthcare Administration & Service ManagementCambridge, On -
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