| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Phone: PHONE NUMBER AVAILABLEEmail ID: EMAIL AVAILABLEOBJECTIVE:Azure BI Developer where I can apply my education and analytical skills in database and reporting development as well as my customer focus to provide business insights and reporting solutions.SUMMARY PROFESSIONAL:5+ years of IT experience in developing complex distributed applications, system design, system analysis using MSBI and extensive database programming using Data Programming.Hands on working experience in Azure data technologies: Azure Data Lake, Azure SQL server, Azure Synapse Analytics, Data bricks, Azure Data Factory, Spark SQL.Designed and developed ETL system which covered vast data input sources: SQL, Azure blobs, flat files, parquets.Experience in Migrating the On-Prem SSIS Packages to Azure Synapse Pipelines and Load the data into different destinations Azure SQL Server and ADLS Gen2.Hands-on experience in building DataMart based on business requirements and processing data using data pipelines.Knowledge of Azure Analysis Service and different schemas like Star Schema and Snowflake Schema.Reporting design and data modelling end to end in the current project which is developed using Microsoft Power BI and Tabular cubes.Experience with SSMS, SQL Server Profiler and SSIS Wizards.Expertise in system analysis, design, development, testing, and implementation of projects (SDLC).Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2012/2014.Scheduled reports for daily, weekly, monthly reports for executives, Business analysts and customer representatives for various categories and regions based on business needs using PowerBI Reporting.Strong experience working with Azure dev ops, Visual Source Safe (VSS) and Team Foundation Server (TFS).Ability to handle projects independently and to work proactively within a cross team environment.Used Agile Methodology on a support and maintenance project.Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.TECHNICAL SKILLS:SQL Server ProgrammingAzure Data FactoryRelational and OLAP database designAzure Portal ManagementAzure DatabricksSoftware Development LifecycleAzure Analysis ServiceExcel Power pivot and Power QueryAzure Dev opsSSISProfessional Experience:Client: Milgard Windows & Doors (MITER) Jan 2022 to Till DateLocation: Tacoma, WA Role: Azure BI DeveloperResponsibilities:Worked as part of a team to design and develop end to end solutions using Azure tech stack for ELT and reporting solution: Azure Data Lake Gen2, Azure SQL server, Azure Synapse Analytics, Spark SQL, Scala, Azure DevOps.Migrating the On Prem code (Stored procedure code) into Synapse Notebooks code using SparkSQL syntax.Experience in Migrating the On-Prem SSIS Packages to Azure Synapse Pipelines and Load the data into different destinations Azure SQL Server and ADLS Gen2.Hands on experience in building the Datamart based on the business requirements and process the data using data pipelines.Build data pipelines using Synapse pipelines for different sources (Oracle, Salesforce, SharePoint, SQL, Excel, csv) and destinations (parquet, delta, csv) to move the data from source location to Azure Data Lake Gen2.Creating Scheduled trigger for processing the Data pipelines using Synapse Pipelines.Worked with both live and import data into Power BI for creating reports.Creating Facts and Dimensions for processing the data using Synapse Notebooks into Tabular models for business reports.Designed and developed ETL system which covered vast data input sources: SQL, Azure blobs, flat files, parquets.Created Power BI reports from different data sources like Azure Analysis Services, SQL Server, Excel, SQL Azure etc.Experienced in Agile Methodology Scrum approaches and SDLC life cycle for Design, Development and Staging phases of the projects.Experience in analyzing the requirements and mapping them as per business use.Experience in analyzing the root cause of data issues and fixing them.Environment: Azure Data Lake, Azure SQL server, Azure Synapse Analytics, Synapse Notebooks, Spark SQL, Scala, Azure DevOpsClient: Fractal (Neal Analytics) Jul 2021 to Jan 2022Location: Bellevue, WA Role: Azure BI Developer/AnalystResponsibilities:Worked as part of a team to design and develop analytics/reporting solutions using Azure tech stack: Azure Data Lake, Azure SQL server, Azure Data bricks, Azure Data Factory, Spark SQL, Scala, PowerBI, Azure DevOps, Azure Analysis service.Migrating the Onprem code (Stored procedure code) into Azure Databricks code using SparkSQL syntax.Experience in Migrating the On-Prem SSIS Packages to Azure Data Factories and Load the data into different destinations Azure SQL Server and ADLS Gen2.Hands on experience in building the datamart based on the business requirements and process the data using data pipelines.Build data pipelines using ADF to move the data from source location to Azure Datawarehouse.Creating Scheduled trigger for processing the Data pipelines using ADF.Worked with both live and import data into Power BI for creating reports.Created Power BI reports using visualizations like Bar chart, Line chart, etc.Creating Facts and Dimensions for processing the data into Tabular models for business reports.Experience in creating the power bi reports and validating (or) analyzing the data in the ports.Designed and developed ETL system which covered vast data input sources: SQL, Azure blobs, flat files, parquetsCreated Power BI reports from different data sources like Azure Analysis Services, SQL Server, Excel, SQL Azure etc.Strong experience in star and snowflake schemas in Azure Analysis service.Experienced in Agile Methodology Scrum approaches and SDLC life cycle for Design, Development and Staging phases of the projects.Experience in analyzing the requirements and mapping them as per business use.Experience in analyzing the root cause of data issues and fixing them.Environment: Azure Data Lake, Azure SQL server, Azure Data bricks, Azure Data Factory, Spark SQL, Scala, Power, Azure DevOps, SSIS, SSAS.Client: 247 Labs Jul 2018 to Jul 2021Location: Almeda, CA Role: MSBI DeveloperResponsibilities:Experience in database development, process as per the SQL standards.Worked on building several new SSIS packages and updating existing packages.Created tables, views, indexes based on the requirements.Wrote complex SQL queries to retrieve information from the databases depending on the requirement.Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T- SQL in development and production environment for SQL Server.Experience in developing the applications using T-SQL Programming (DDL, DML and DCL).Experience in Upgrading from SQL Server 2000 to SQL Server 2005 to 2008 R2.Expert at creating reports using SSRS (SQL Server Reporting Services), SSAS and OLAP (creating cubes) including infrastructure with BIDS.Code deployment, tuning RDBMS, and Multidimensional queries as part of support for developers.Experience in Agile work Methodology.Experience in optimization of queries, improving performance and maintaining the database consistency with DBCC, DMVs at regular intervals.On call support for Applications over the weekend.Environment: MS SQL Server 2000, T-SQL, SQL Server Enterprise Manager, SQL Profiler, Excel, Data Import, DBMS, C, MS Visio |
