Ankur · Senior MS SQL / Power BI Data Analyst · 5+ yrs
Mid-LevelProof of scale
About Ankur
Ankur is a Data Analyst with 5+ years of experience specializing in data migration, system consolidation, and ETL processes. He has a proven track record of improving data workflows and ensuring data quality through automation and effective reporting.
5+ years of commercial experience in
Skills(11)
Why hire Ankur?
Led financial data migration to a new ERP platform, ensuring data consistency and minimizing downtime.
Automated data quality checks using SQL and SSIS, significantly reducing manual effort.
Developed Power BI dashboards for senior management to track key metrics and support decision-making.
Improved data loading speed by 25% and reduced manual intervention by 40%.
Reduced manual intervention by 40% in data quality checks using SQL and SSIS.
Improved data loading speed by 25% and enhanced reporting performance by streamlining ETL processes.
Led the migration of financial data to a new ERP platform, ensuring data consistency and minimizing downtime.
Project highlights(7)
Data Migration & System Consolidation Project – Data Analyst
Overview: This project involves the comprehensive migration of financial data from an outdated legacy system to a modern ERP platform. Responsibilities: Led the migration of financial data from a legacy system to a new ERP platform, ensuring data consistency and minimizing downtime. Performed extensive data mapping and transformation, using SSIS to integrate data from multiple sources. Developed and automated Power BI dashboards for senior management to track migration progress and system performance.
Key outcomes:
Led the migration of financial data, ensuring data consistency and minimizing downtime.
Developed and automated Power BI dashboards for senior management to track migration progress and system performance.
Data Profiling & Quality Assurance for Client Database – Data Analyst
Overview: This project focused on enhancing the integrity and accuracy of a large customer database prior to its migration. Responsibilities: Conducted detailed data profiling to identify inconsistencies and errors in a large customer database prior to migration. Automated data quality checks using SQL queries and SSIS, reducing manual intervention by 40%. Created and maintained a comprehensive reporting dashboard in Power BI to monitor data quality and profiling metrics.
Key outcomes:
Automated data quality checks, reducing manual intervention by 40%.
Identified inconsistencies and errors through detailed data profiling.
Cloud Data Migration & Reporting Automation – Data Analyst
Overview: This project focused on migrating key business data from on-premise systems to a cloud-based platform. Responsibilities: Migrated key business data from on-premise systems to a cloud-based platform to improve accessibility and scalability. Designed and implemented automated data pipelines using SSIS to handle ETL operations and improve data processing efficiency. Created Power BI dashboards to track cloud migration progress and data availability, enhancing real-time decision-making.
Key outcomes:
Improved accessibility and scalability of business data through cloud migration.
Improved data processing efficiency by implementing automated data pipelines.
Cloud Data Migration & Reporting Automation – Data Analyst
- This project focused on migrating key business data from on-premise systems to a cloud-based platform.
- The goal was to improve accessibility, scalability, and enable real-time decision-making through migration tracking.
- Migrated key business data from on-premise systems to a cloud-based platform to improve accessibility and scalability.
- Designed and implemented automated data pipelines using SSIS to handle ETL operations and improve data processing efficiency.
- Created Power BI dashboards to track cloud migration progress and data availability, enhancing real-time decision-making.
Key outcomes:
Improved accessibility and scalability of business data through cloud migration.
Improved data processing efficiency by implementing automated data pipelines.
Data Cleansing & Consolidation for Business Analytics – Data Analyst
- This project aimed to improve data quality and create a unified database by cleaning and consolidating data from multiple business units.
- The objective was to ensure better reporting accuracy and facilitate business performance monitoring.
- Led a data cleaning initiative to remove duplicate and incorrect entries across several client databases.
- Consolidated data from multiple business units to create a unified database, ensuring better reporting accuracy.
- Provided support in creating detailed Power BI reports to monitor business performance and identify trends.
Key outcomes:
Led a data cleaning initiative, removing duplicate and incorrect entries.
Consolidated data from multiple business units, ensuring better reporting accuracy.
Industry experience
SaaS / B2B
4 projects- •Data Migration & System Consolidation Project— Data AnalystSQL Server · SSIS · Power BI
- •Cloud Data Migration & Reporting Automation— Data AnalystSSIS · Power BI
- •Cloud Data Migration & Reporting Automation— Data AnalystSSIS · Power BI · Data migration · ETL
- •Legacy System Data Migration for CRM Integration— Junior Data AnalystPower BI · Data migration · Data mapping · Data quality assurance
FinTech
Reported in resumeAt a Glance
Single contract. No agency markup confusion.
Typically responds within 4 business hours.
Vetted by WitaristNot sure if this is the right fit?
Tell us your requirements and we'll match you with the best candidates.
Ankur
Data Analyst - Migration & System Consolidation