| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
EMAIL AVAILABLE,
Phoenix, AZ
PHONE NUMBER AVAILABLEProfessional Summary: I am an Azure Data Engineer/ Developer with experience in building enterprise-level data pipelines using industry-standard tools and processes. I have years of experience architecting and developing data storage objects (structured and semi-structured data); This includes data dimensional modeling, implementing high availability and disaster recovery functionalities, and performance tuning. had hands-on experience building cloud data solutions using Azure, implementing database and data integration solutions using tools like Azure Synapse Analytics, Azure Data Factory, DevOps, Logic App flow, Azure Data Studio, Azure SQL databases, dedicated pool, serverless, Cosmos DB, Azure Data Lake storage, and Blob storage, PowerApps, Apache PySpark, in Databrick. I have years of experience building data analytic solutions using Power BI and Excel at an advanced level, building numerous enterprise-level Power BI reports and dashboards to provide analytical insights. Advanced experience in developing SQL queries for data retrieval, transformation, reporting , .Net Core and Web API for semi structure data transferring and migration.Technology:
Data Engineering: Azure Data Factory, Azure Synapse Analytics, Databrick for SQL
visualization, Cdata x12 Connector xml parse.
Data Analytics: Microsoft Excel, Power BI
Programming: SQL Server, Azure SQL, Snowflake, dedicated pool, Serverless, Cosmos DB, Azure
Blob, ADLS and Salesforce.
Database Design: Data Modeling, Dimensional Modeling
PowerApps: Dataverse Microsoft 365, GitHub, Azure Logic App, Azure Data Studio, NET Core and Web API
Professional Experiences:
Consumer Cellular, Inc, Scottsdale, AZ (Remote) Jul 2023 PresentAzure Data Engineer (Contract through CBTS Service Management Company). Experienced in data cloud migration efforts from on premise SQL server databases, Azure Data Lake storage to Synapse enterprise Data Warehouse using Azure Data Factory.
Ability to solve complex SQL based logic including debugging stored procedures, create views, joins, temp table, queries, cursors, and windows functions to implement new functionalities and support data load transformation. Ability to create Rollback/Backup on Store procedure, and table for data backup using GitHub release code. Experience in .NET Core and Web API to model, providers and filter use to developing backend technology and semi structure data driven. Participated in data warehouse weekly, data warehouse strategies analytics, daily scrum standup and weekly task sprint team. Experienced in modernization discussions and efforts to increase productivity and efficiency across the organization.
Experienced in creating feature branches to leverage GitHub for pull request merging, in code review, and processing validation in both dev and prod environment for prod. Used Azure Data Factory to build automated architectures pipeline design for ETL process and to move data from source to sink. Ability to use Azure Synapse Analytics to limitless analytics service that brings together data integration for enterprise data warehousing, by stage data in dedicated pool, Serverless and directly use SQL script to query ADLS for external table creation and to materialize table in different schemas. Experience in GitHub repository, CICD action to perform deployment in both Dev, QA, and Prod environment.Monogram Health., Brentwood, Tennessee (Remote) Oct 2022-March 2023
Azure Data Engineer (contract through IDR, Inc)
Led data cloud migration efforts from on premise SQL server databases to Azure SQL databases using backpacks.
Developed complex SQL based logic including stored procedures, views, joins, temp table, Cross/Outer apply, Pivot, correlated sub-queries, cursors, and windows functions to implement new functionalities and support data load and transformation into data repositories.
Participated in data modernization discussions and efforts to increase productivity and efficiency across the organization.
Data processing to data validation, data movement, Azure Data Factory ETL, and writing business logic as necessary.
Design and develop ETL pipelines using Azure Data Factory. These pipelines extracted the company s data.
Experience in creating feature branch in DevOps GIT Azure Data Factory, create a pull request for merging, CI/CD collaboration.
Experienced in using PySpark in Databrick, use SQL script and Scala to optimize big data orchestration and transformation. Experience in extracting data from external and internal sources, Azure Blob Storage, Azure Data Lake Storages and sftp using ADF automate pipeline architectural design. Experience in Azure Synapse Analytics for limitless analytics service that brings together data integration, enterprise data warehousing, stage data in dedicated pool and Serverless and query ADLS.
Experience in creating an external, external source format, and external table to load data to warehouse staging entities.
Experience in using C-data connector tool to parse x12 files- xml and migrate to M-drive directories. Experience in migrating record to Salesforce database using Azure Data Factory and dbsync for auto insert and update purpose.
Info Works, Inc., Nashville, Tennessee (remote) April 2022 - August 2022
Azure Data Engineer (contract through Orbis Consulting)
Work from a backlog to complete tasks.
Data processing to data validation, data movement, Azure Data Factory ETL, and writing business logic as necessary.
Design and develop ETL pipelines using Azure Data Factory. These pipelines extracted the company s data.
Experience in creating feature branch in DevOps GIT Azure Data Factory, create a pull request for merging to main, CI/CD collaboration.
Extracting data from external and internal sources, Azure Blob Storage, and Azure Data Lake Storages using ADF pipeline orchestration.
Experience in Azure Synapse Analytics for limitless analytics service that brings together data integration, enterprise data warehousing stage data on dedicated pool and Serverless and query ADLS.
Creating an external and external source format, external table to load data to synapse dedicated pool staging entities.
Perform package and workflow development.
QA data is based on data counts.
Set up databases.
Load data from different sources using ADF orchestration into Salesforce.
Test performance of packages.
Offer guidance on best practices.
Ability to complete tasks independently / also participated in daily standups / sprints.
Hoyos Integrity Cooperation, Fort Lauderdale, FL (remote) July 2021 - January 2022
Azure Data Developer (Company Shutdown)
Experience in PowerApps Dataverse development environment. Create customs, standard, and virtual entity, views, and forms in Dataverse.
Experience in creating dataflow architecture design to migrate data using OData and Power Query Editor that scales across the various Dataverse environment.
Experience in product development as well as importing and exporting data across Dataverse managed and unmanaged solutions in Power apps environment. Create record level, field level, entity-level security role resources to different users, grant access to different types of records, business units, team, and user.
Developed GitHub action designed for CI/CD. Experience in creating power Automate flow for bulk data delete and data migration within tables. Built various SQL queries, SQL script to retrieve data from database system. Experience in working DevOps environment to help data development process.
Hope Behavioral Health, Goodyear, AZ December 2016 March 2021
Data Engineer
Built PowerBI reports that extracted data from disparate sources (Cosmos DB, SQL Server, Azure Data Lake storage and Rest APIs) and transformed accordingly to provide insights into operational activities for the organization.
Built complex Excel based reports that displayed operational metrics across multiple business processes.
Designed and developed ETL pipelines using Azure Data Factory and SSIS. These pipelines extracted company s data from various sources / structures, transforming and loading it into various formats at different destinations.
Implemented Azure Cosmos DB solution to consume and store semi structured (JSON) structure extracted from third party APIS; configured partition keys, request units, and consistency levels to optimize performance.
Designed, developed, and maintained complex ETL solutions (SSIS) that updated data warehouses and data marts on a regular cadence. Packages were built with complex transformations to support the required business process.
Led data cloud migration efforts from on premise SQL server databases to Azure SQL databases using backpacks.
Developed complex SQL based logic including stored procedures, functions, views, joins, CTE, Cross/Outer apply, Pivot, correlated sub-queries, cursors, and windows functions to implement new functionalities and support data load and transformation into data repositories.
Participated in data modernization discussions and efforts to increase productivity and efficiency across the organization.
Destiny Behavioral Health, Tolleson, AZ December 2015 November 2016
Snr. Data Analyst (onsite contract)
Developed interactive dashboards and reports using PowerBI to display member daily activities and incidents report. This includes analysis and reporting on activity types, appointment, rating, and participation.
Built PowerBI reports that provides comparative analysis of treatment plans; These reports are used to improve our members responsiveness to treatment plans and to evaluate the most effective plan, KPI to measure goals and progress of treatment plan. Built PowerBI executive dashboards that analyzed and reported member ratings; these dashboards provide trend analysis based on aggregated data.
Built Power BI audit report and dashboard for row count monitoring purposes.
Built Excel based Pivot tables and charts to display member appointments, implement complex metrics and transformed using Excel formulas to allow better slicing and dicing of data.
Built data models in Excel for self-service reporting purposes; extracted data from CSV files and SQL Server, created relationships, transformed data, and built standard measures for reporting purposes.
Created multiple SQL queries (Standard and Ad Hoc) to support reporting and analytics.
As part of the team, designed and implemented a reporting data model for member activities and incident reporting.
Worked closely with business users to design and implement pertinent metrics and KPI s for reporting purposes.
Created business requirements documents and technical documentation for educational and knowledge transfer purposes.
EDUCATION AND TRAININGB.Sc. Computer Science LAGOS STATE UNIVERSITY (LASU) LAGOS, NGTRAINING: SQL, Power-Bi., Dax functions, Excel, Basic Python. Azure, Data Modeling, Dimensional Modeling
|
