Hari Deepak Email: addflt@r.postjobfree.com

Data Analyst Mobile: 418-***-****

Professional Summary:

Over 5 years of experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse, SSIS, SSRS, Power BI, Tableau, OLAP, Client/Server applications.

Strong working experience in Data Analysis, Data Validation, Data Verification and identifying data mismatch.

Strong knowledge of System Development Life Cycle including analysis, design and review of business and software requirement specifications, development and Testing Methodologies and Techniques.

Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validations.

Extensive hands on experience in reports Design, Development maintenance business applications using Tableau

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Skilled in Tableau Desktop versions for Data Visualization, Reporting and Analysis.

Developed reports, dashboards using Tableau for quick reviews to be presented to Business and IT users.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Proficiency in using SQL to manipulate data, query expressions, join statements, subquery, stored procedures, functions, triggers and packages etc.

Developed reports, dashboards using Tableau for quick reviews to be presented to Business and IT users.

Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards etc.) using Tableau and Power BI.

Expertise in Relational Data Modeling with very good focus on creating physical models and Dimensional Data Modeling in designing Data Marts and Data warehouse

Strong experience in using Excel & MS Access to dump the data & analyze based on business needs.

Created Teradata SQL scripts using OLAP functions like rank and rank Over to improve the query performance while pulling the data from large tables.

Analyzing the data from low level in conversion projects, provided mapping documents between Legacy, Production and User Interface systems.

Extensively performed Data Profiling and has a good knowledge on best practices.

Experience in developing monthly, weekly, quarterly reports by using MS Office suite, Macros, SQL and Unix

Hands on Experience on Pivot tables, Graphs in MS Excel

Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations. Work Experience

Data Analyst

Telus, Quebec City, QC January 2019 to Present

Responsibilities:

As a Data Analyst, my responsibilities include to Extract, Transform, Integrate, Analyze and export the data to cloud while making any necessary modifications.

Performance of the system was documented by understanding the existing data model. Hari Deepak Email: addflt@r.postjobfree.com

Data Analyst Mobile: 418-***-****

Business requirements were mapped to the new databases to develop logical data model which defines the project delivery needs.

Generated DDL scripts from Physical Data Model to create objects like table, views, and indexes.

Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.

Implemented star-schema, snowflake schema/dimensional for data warehouse in AWS.

Implement naming standards for the data warehouse to maintain the consistency

Created logical and conceptual data model to show the entities, relationships and data mapping document to show the flow of data from multiple data sources.

Written SQL queries performed calculations and checked the efficiency of certain processes.

Designed the database, creating Tables, Stored Procedures, Views and Function.

Successfully load data into SQL Server and analyze and explain the result using Server and Access as an important tool.

Developed reports using the Teradata OLAP advanced techniques like rank, rank and row number etc.

Designing the database, creating Tables, Stored Procedures, Views, Function, and Triggers & Automated test cases to safeguard against regression.

Created complex data views manually using multiple measures, used sort, Filter, group, Create Set functionality.

Experience in Preparing detailed reports and presenting trends using tableau dashboards on an ongoing basis. Created audit reports involving charts and graphs using Excel, Tableau dashboards

Created the data story in Tableau by implementing interactive dashboards using drill down filters and parameters. Environment: MS Excel, SQL, Tableau, MS Visio, AWS, Snowflake, Teradata, JIRA and Windows 7. Data Analyst

Walmart, Toronto, ON June 2017 to December 2018

Responsibilities:

Created Stored Procedures to migrate data from flat file structure to a normalized Data structure

Created Test Report Dashboards that helps in visualizing several thousands of app status using Tableau

Created Tableau dashboards to know the app status of machine for user/organization

Created Adhoc reports in Tableau to visualize top 10 incompatible apps based on user count

Developed stacked bar chart in Tableau for management to view the test status of apps across the organization.

Developed various Dashboards using objects such as Chart Box List, crosstab etc. using Tableau.

Created complex formulas and calculations within Tableau to meet the needs of complex business logic

Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web

Created complex formulas and calculations within Tableau to meet the needs of complex business logic

Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.

Developed various data connections from data source to Tableau Desktop for report and dashboard development

Created Technical Documentation for reports and maintenance/enhancements of existing reports

Involved in project planning, scheduling for database module with project managers

Discussed with businesspeople to understand the rules for defining the test status of apps at the report level Hari Deepak Email: addflt@r.postjobfree.com

Data Analyst Mobile: 418-***-****

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau

Effectively used data blending feature in tableau. Defined best practices for Tableau report development

Developed Tabular, drill down, parameterized, cascaded and sub-reports using Tableau. Environment: Tableau, MS SQL Server, SSIS, SSRS, MS Excel and Informatica Data Analyst

Ubisoft, Montreal, QC December 2014 to May 2017

Responsibilities:

Experience working with physical and logical data modelling.

Involved in Retrieve data from Database and developing reports based on the business requirements.

Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks

Experience in working in creating data sources, data source views, named queries, calculated columns, cubes, dimensions, roles and deploying of SSAS cubes.

SSAS Cube Analysis using client tools like MS-Excel and PowerPivot.

Defining Regular, Referenced, many-to-Many relationships and creating Hierarchies key.

Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like MS Access, Excel and SQL Server.

Implemented conditional formatting in Excel and created validation.

Worked with end users to gain an understanding of information and core data concepts behind their business.

Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.

Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.

Performed Verification, Validation and Transformations on the Input data before loading into target database.

Designed and developed weekly, monthly reports by using MS Excel Techniques and Power point presentations.

Designed stunning visualization dashboards using tableau desktop and publishing dashboards on tableau server and desktop reader.

Environment: SQL, SSAS, SQL server, PL/SQL, MS Excel, MS Visio, Tableau, Windows 7, Microsoft Office. Educational Background

Bachelor of Commerce & Master’s in Business Administration Additional Information

Analytics & Visualization tools - Tableau, MS Power BI, R Studio, Google Analytics, SAP Lumira Predictive Analysis, MS Visio, Jira, Agile, AWS Quick Sights, AWS Glue, Salesforce Data Tools - Rapid Miner, MS Excel, Hadoop, HIVE, MS Azure, Oracle DB, My SQL, Data Analytics, AWS Athena BI Tools: SSIS, SSRS and SSAS

Programming Languages - R, Python, SQL, PL/SQL, SQLMAP

Contact this candidate