Summary

Expertise

Project Highlights

Education

Agency

BP

English:

Upper Intermediate

Bhavesh P.

vetted by Youteam

Vetted by YouTeam

United States

UTC -08:00

America/Los_Angeles

English:

Upper Intermediate

Data Engineer/Scrum/AZURE/AWS/Data Analyst/Power BI/SnowFlake/SSIS/SSRS

Over 16+ years of experience in architecture, design, development, Big data analytics, Azure/AWS Cloud support, data architect/scientist/engineering, machine learning, testing, performance optimization and documentation. • Hands on experience in Azure Development, worked on App services, Azure storage, Azure SQL Database, Azure Synapse( Azure Data warehouse), Azure Data Factory, Azure DataBricks, Azure DevOps, Virtual machines, Azure AD, Azure CI/CD pipeline and notification hub. • Solid experience of AWS services such as CloudFormation, S3, Glue, EMR/Spark, RDS, Redshift, DynamoDB, Lambda. • Experience in implementing performance data movement pipeline using real-time event data streams (Apache Kafka, Azure Event Hub, AWS Kinesis, etc.) Experience in MS SQL Server suite of products like SSIS, SSAS and SSRS of MS SQL Server 2012/2014/2016/2017, Power BI, JavaScript, and Tableau for Data Analytics, Talend. • Worked with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance. • Experience as ETL Team lead and lead of the code review team for ETL. • • Hands on experience with Snowflake utilities, SnowSQL, SnowPipe, Big data model techniques using Python. • Strong understanding of the principles of Data Warehousing concepts using Fact tables, Dimension tables, and Star/ Snowflake schema modeling. Extensive experience in data warehousing tools including Tableau, SSIS, SSRS, SSAS using different databases. • Effectively manage the business cycle process from client consultation to closing including identifying requirements, developing focus, presenting demos and providing tactical IT solutions. • Experience in full BI implementation cycle in Client’s organization from installation and configuration of BI Tools, freezing client’s requirement, designing ETL, cubes & data models, developing reports/dashboards as per client requirement. • Expertise in Business Intelligence Tools – Talend, Tableau ,Cognos , Microstrategy, MSBI (SSIS, SSAS, SSRS), BIRST Cloud BI, Qlikview , Tableau • Expertise in ETL Tool like SSIS and developed OLAP cubes using SSAS & Cognos Transformer. • Designed data structures, procedures and functions in SQL Server for ETL and reporting layer. • Good knowledge and experiences of in Tableau visualizations and dashboards using Tableau Desktop. • Experienced with Power BI to visualize and analyze data with greater speed, efficiency, and understanding. • Experienced with Python for data analysis. • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Developed Tableau visualizations and dashboards using Tableau Desktop. • Developed Tableau workbooks from multiple data sources using Data Blending. • Provided 24/7-production support for Tableau users. • Extensive experiences in developing Stored Procedures, Views, Triggers and Complex Queries, generating cubes on SQL Server. • Expert in creating cubes and dimensions, handling multi dimensional reports. • Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008/2012/2014/2016. • Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger. • Excellent experience and understanding of database design, relational integrity, Constraints, OLAP, OLTP, Cubes and Normalizations. • Hands on experience in designing and developing SSAS (SQL Server Analysis Service) cubes and dimensions and writing MDX queries. • Extensive experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access. Education Qualifications: M.S in Engineering (Computer Science) ,New York Institute Of technology,NY,2008 B.E.(Computer) Birla VishvaKarma Mahavidyalay,V.V Nagar India,2005 MS SQL SERVER: SQL Server Management Studio SSMS, SSIS, SSRS, SSAS, DTS Programming Languages: SQL, C#, Python, VB.NET, JavaScript, J-Query, Angular JS , NODE JS Reporting Tools: SQL Server Reporting Services (SSRS), Tableau, Power BI, QlikView Big Data Technologies: HDFS, Hive, Map Reduce, Cassandra, Pig, H catalo, Sqoop, Flume, Zookeeper, Mahout, Kafka, Oozie, Avro, H Base, HDFS, Storm, Impala, Storm, YARN ETL Tool: ADF , SSIS (SQL Server Integration Service) Azure Technology: Azure SQL, Azure Synapse, Azure Key vault, Azure Storage, Azure data lake, Azure Data factory, Azure Data Bricks, Azure DevOps, Azure CI/CD pipeline, Azure Logic flow, Azure Power Apps, Azure Event Hub AWS Technology: Redshift, DynamoDB, AWS Kinesis, AWS Lambda, S3, EMR, Glue, Athena.

Want to hire this engineer?

Check if Bhavesh is available

Expertise

Years of commercial development experience

16 years of experience

Core technologies

SQL 16 years
Python 5 years
Azure 6 years
AWS 5 years
ETL 15 years
Data Warehousing 15 years

Other technologies

Agile
ASP.NET MVC
Big Data Architects
Database Developer
Data Scientists
JavaScript
Tableau
Data Modeling
Data Visualization
Azure Storage
Scrum Master
Hadoop
AWS Lambda
Data Analyst
Power Platform
Power Apps

Project Highlights

icon
Data Engineer

Analyze Data Platform

Feb `22 - Dec `22

10 months

Worked as lead Data Engineer.

Responsibilities & achievements

AWS
ETL
MySQL
Python
SQL
Snowflake

Education

Higher education in Computer Science

Agency

agency #4075

10-50

GMT-8

Portland, Oregon

Core Expertise

AWS
Azure
C#
C++
Database Developer
Data Scientists
ETL
Java
JavaScript
.NET
Python
React Native
Ruby
SQL Server
Data Ingestion
Data Modeling
Data Structures
Data Visualization
Database design
QA Management
Software Debugging
Web Crawling
Web Hosting
Web Services
Mobile UI Design
Angular 2x
Data Analyst
Web Analytics

Industries

Advertising & Marketing, Big Data

Want to hire this engineer?

Check if Bhavesh is available