Dinesh Patil
15+ Data Product expertise/BI/Analytics/SQL Server/SSIS/Azure Data Factory/DBT/SQL Server/Snowflake/synapse/Redshift/P&C ins/Finance/Azure/AWS/Python/Spark/Scala/pyspark/Hive/PowerBI/DBA/Azure ML/Github/Devops/DataBricks
- Role
- Sr Bi Developer Data Product Engineer Snowflake Developer at Duck Creek Technologies
- Location
- Edison, NJ, US
- LinkedIn followers
- 500 followers
About Dinesh Patil
Expertise in building cloud platform BI products/ Solutions.Expertise in building MS Business Intelligence/Analytics solutions for insurance, financial, educational, and administrative data. • Expertise in building and administering relational database systems and it’s ETL, SQL Codes for large transactional and non-transactional data.• Advanced expertise in data analysis, data engineering, data query, data integration and data migration.• Expertise in designing and developing Database/Datawarehouse/Datamart/SSAS Cubes.• Expertise in data conversion, such as from SQL Server/Oracle/DB2/XML/CSV/duck creek to SQL Server.• Expertise in data/ Business Intelligence and Analytics solutions migration, such as from SQL Server 2008R2 to SQL Server 2012/2014/2016• Expertise in physical/logical data modeling using Erwin• Expertise in implementing, configuring, installing and maintaining Servers/SQL Server instances such as SQL Server 2008 R2 on Windows Server 2008 R2, SQL Server 2014 on Windows Server 2012• Extensive experience in Analytics report creation with thorough knowledge of report server architecture using SSRS, Yellow-fin, Power-BI. • Extensive experience with AWA and Azure: Configuring and maintaining SQL Server Databases and its stand alone and named Instances over cloud.• Expertise in programming languages T-SQL, PL-SQL, My-SQL, Batch Programming, C#.Net, Python.• Expertise in SQL Server administration: Security, Installation, Maintenance• Expertise in using tools : Visual studio 2008/2012/2013, SSIS 2005/2008/2012/2014(DTS),SSMS, SQL Server Profiler, SQL Server Tuning advisor, SSRS, SSAS, Erwin, SQL Developer, TOAD, Winnows event logs, windows performance monitor, Yellow-fin, Power-BI, Jupyter notebook,TFS, SVN, JIRA, Visio, Hyper-V• Highly professional to implement latest and best practices to build high performance MS Business Intelligence/Analytics solutions,relational /Datawarehouse/Datamart databases.
Experience
Sr Bi Developer Data Product Engineer Snowflake Developer
May 2020 — Present · Basking Ridge, NJ, US
new Implementation of data analytics product.Fully led technical development of the product.• Successfully design and develop data product analytics solution for P&C line of insurance using Azure SQL database, Azure data factory, Azure blob storage, Snowflake, azure devops.• Done POC’s on different cloud platforms like Azure Data warehouse, Azure synapse, Azure Data factory, Snowflake, DBT.• Successfully done some POC’s on azure data bricks and Delta Lake for some of the functionalities.• Expert in Azure synapse self-hosted and on demand functionalities.• Expert on snowflake data warehousing design and development using JavaScript, snowsql, snowflake task, snow pipe.• Dept understanding of snowflake platform.• Expert in azure SQL server, key vault, azure blob storage, and more azure services.• Coordinated and supported cross team functionality developments like clarity.• Supported all data functionality development for powerBI.• Worked enhancement of previous SQL server/SSIS based data analytics product called Insights.• Supported client environments for any enhancements or bugs.• Responsible for developing POC using AzureSQL database instance, Azure Data factory, Azure Synapse Pool, Azure server less Pool, Azure data lake storage v2,Azure Events grid,• Azure log analytics workspace. This approach was bulit using complete ADF for versioning and CTAS to improve data load performance.mple to parse XML and dump data into SQL Server Databases• Responsible for migrating on premise BI solutions over cloud (Azure)• Responsible for creating pipelines azure data lake.• Responsible for developing POC on DBT code and Snowflake, Existing Snowflake solution converted to DBT + Snowflake style.• Responsible for design, develop, deploy, maintain power bi reports.• Perfoemd enhancment and bug fixing for SQL Server/SSIS/Power BI anytics solution.
Education
GF'S GODAVARI COLLEGE OF ENGINEERING, JALGAON
Bachelor's degree, Computer Engineering
1999 — 2004
New York Institute of Technology
M.S., Computer Science
2007 — 2008
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.