*. Proven experience as a Data Architect - Data analysis to modeling of complex system/applications,

Evaluation & Selection of BI Tools, establish and enforce Data Governance and standards 2. Exhaustive experience designing Data Integration processes for traditional Datawarehouse's, Azure EDW and Data Lake, Microsoft BI

3. Data Modeling and Design of Enterprise DW, Datamart, Master Data Management Systems both for Analytical and Operational Usage

4. Working with the Business in laying out the Enterprise Governance Organization, designing the data stewardship process by integrating the Data Governance tool with MDM, Metadata management tool, Data Quality and Data Profiling tools

5. Exhaustive Experience in various Data Modeling methodologies including E-R, Dimensional and Data Vault

6. Strong Reporting and Analytics Knowledge/experience. 7. Implementation and strong knowledge on Data Center Migration and Technology upgrades in BI space

8. Studying and experimenting Various ML and DS Algorithms as part Master Degree in Data Science. 9. Expertise in T-SQL, MDX, DAX, Python, R for Data Engineering 10.Expertise in Insurance and Financial domain knowledge. Conducted Various Training in Azure, Power BI and Domain related trainings

Skills

Enterprise Data Warehouse & Data Analysis - Large Dataset, Decision Making Skill SQL Server Architecture - MS SQL SERVER, SQL, Performance Tuning, DB Admin Azure Data Lake Gen2, ADF (V2), Azure Databricks, Azure SQL DW/DB, Azure ML T-SQL, DAX, MDX, TFS, Azure DevOps, Python, R,C#

Hadoop - Azure HD Insight, Apache Hadoop MapReduce Reporting - MS SSRS, Tableau, Excel, Business Objects SAP Self BI and Analytics - Power BI, Azure SSAS, Cubes, R Markdown RAGUNATH GUNASEKARAN

Data Analytics Lead

Address 723 SUNFISH POINT, Schaumburg, IL, 60194

Phone 802-***-****

E-mail adgo6d@r.postjobfree.com

LinkedIn ragunath-gunasekaran-30130663/

Data Modeling - Power Designer, Start Schema, Datawarehousing and Datamart Design Work History

Apr 2009 -

Aug 2016

Team Lead (Business Dev App)

NTT Data Inc, Montpelier, VT

Subject Matter Expert in MSBI SSIS/SSRS/SSAS & MS SQL Server, T-SQL, MDX, DAX, Scripts (C#). Strong Exposure in Master Data Management, designing Data models, Datawarehouse and Data migration, Predictive Analytics Worked with Business User and empowered as Power User (Self-Service BI) Created Complex Tabular and Multidimensional Cube through Azure SQL Analysis Services, Salesforce and Power BI Integration

Single point of contact and Lead the overall Reporting, Analytics and BI environment - failure, Root Cause analysis on ETL Jobs, Analytics and Reports Strong Exposure in Master Data Management, Designing Data models, Datawarehouse and Data migration, Predictive Analytics Aug 2016 -

Sep 2019

BI Architect (Senior Associate)

Cognizant Technology Solutions, West Des Moines, IA Worked on the Salesforce CRM, Metrics, Reports in SFDC Expert on MS SSIS 2008/2012/2016, Provided the solution for end to end desing of ETL Architecture with Event handlers, log, configuration. Expert on MS SSRS 2008/2012/2016, Provided the solution for end to end desing of Reporting Architecture.

Designed and Built several Cubes through MS SSAS both Tabular and Multidimensional model.

Performed Data modelling and DB design by considering all aspect, Performace Tunning for better performance and Data governance SQL Server Maintaince, Scheduling, Stored Procedure, Function, CTE and other functions

Power BI - Implemented various Data model through Azure Analysis Cubes and Empowered the clients as Power Users

Azure DevOps - Source Control Implementation for Azure Data Factory, Power BI. Functional Testing of Azure Data Factory and Worked on POC of Azure Machine Learning

• Worked on Performance Tuning, Monitoring on Azure SQL DW by using DMV, Clustered Column store index, Materialized View

Built Various Dashboards, Data set, Reports by using Power BI, Azure Analysis Services. Strong experience in Data Modeling - Star Schema (Power Designer), Documentation of Business Rules and mapping (3D)

Conducted Various Training in Azure, Power BI and Domain related trainings Sep 2019 -

Current

Senior BI SQL/Data Analytics Developer

ADP, Elk Grove Village, IL

Data Modeling of Azure SQL DW - Fact and Dimension Integrate CRM with Reporting and Analytics

Microsoft Dynamics CRM - Data Analysis and Improve the process to Data Management

Dashboard Creation and KPI modelling

Designing DB, Fact and Dim Tables, Cubes, Party model design MS SQL Server DB Design, Cloud Data migration, Data Analysis Design and implementation of Azure, Data Lake Gen2 Apache Hadoop in Azure HDInsight implementation

Implemented Predictive analytics modelling and various Data Science algorithm for study and decision making by using R and Python Worked on various visualization and story telling by using R Markdown Education

Aug 2019 -

Current

Master of Science: Data Science

Bellevue University - Bellevue, NE

Jul 2004 -

Apr 2008

Bachelor of Science: Electrical, Electronics And Communications Engineering

Anna University - India

Contact this candidate