BP
Bhavesh P.
Location Map Pin United States
Main Clock UTC-08:00 (America/Los_Angeles)
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.