Summary
Overview
Work History
Education
Skills
Project Highlights
Timeline
background-images

Md. Haque

Spring Hill,TN

Summary

Experienced in designing and maintaining SQL databases and BI solutions, utilizing advanced data modeling techniques and ETL processes to optimize data integration and reporting. Proficient in creating impactful data visualizations that effectively support business objectives. Skilled in creating Power BI Dashboards and working with SSIS and SSRS, ensuring seamless data flow and generating insightful reports. Committed to delivering high-quality solutions that drive informed decision-making and enhance overall business performance.

Overview

9
9
years of professional experience

Work History

Sr. SQL BI Developer

MyNexus Health
01.2023 - Current
  • Manage various ETL projects by using SSIS and stored proc
  • Worked on data analysis, data validation using T-SQL
  • Worked with business users to gather requirements to create data pipelines
  • Written various complex stored procedures to complete ETL jobs
  • Designing and building ETL process from scratch using SSIS and stored proc
  • Working with large volume of data and performance issues for SSIS packages and SSRS reports
  • Working on data profiling to analyze source data
  • Worked on Data cleansing and data transformation to support ETL projects
  • Providing end to end implementation and support for Power BI reporting system
  • Working on various SSRS & Power BI reports
  • Handling performance issues for reports
  • Worked on converting tableau into Power BI
  • Environment: MS SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI

Sr. SQL BI Developer

Harmony Healthcare
01.2019 - 11.2022
  • Manage various ETL projects by using SSIS and stored proc
  • Worked with business users to gather requirements to create data pipeline & report
  • Written various complex stored procedures to complete ETL jobs
  • Designing and building ETL process from scratch using SSIS and stored proc
  • Working with large volume of data and performance issues for SSIS packages and SSRS reports
  • Working on data profiling to analyze source data
  • Providing end to end implementation and support for Power BI reporting system
  • Working on various SSRS & Power BI reports
  • Handling performance issues for reports
  • Works on Azure database development
  • Create ETL packages IN and Out of Azur
  • Working on Snowflakes data warehouse implementation
  • Practicing best practice for data engineering SDLC
  • Playing a key role for ETL, reports & data warehouse projects
  • Environment: MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, MicroStrategy, Snowflakes, TFS, Visual Studio 2012, ASP.Net 2.0

SQL BI Developer

Caterpillar Financial
02.2016 - 12.2018
  • Responsible for Analyze and cleansing legacy data for data migration
  • Create and manage complex stored procedures
  • Involved in development phase meetings for Business Analysis and Requirements Gathering
  • Designing and building ETL process from scratch using SSIS and Data stage
  • Working with large volume of data and performance issues for SSIS packages and SSRS reports
  • Working on data profiling to analyze source data
  • Creating ad-hoc reports out of CRM system
  • Worked on full reporting solution for operational and analysis reports
  • Create and map data pipeline to provide data for reporting service
  • Worked on production data support
  • Studied the data requirements and the impact analysis on the existing schema
  • Trouble shooting and performance tuning on existing ETL packages
  • Create and deliver daily ad-hoc reports
  • Closely work with the business users to gather business requirements for various reports, KPI, dashboard
  • Design, coding, testing, debugging and documentation of applications
  • Working with QA team for testing SQL codes
  • Scheduled jobs, alerts and designed and implemented user log in and security
  • Actively participated in the meetings to meet the goals
  • Environment: MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, MicroStrategy, TFS, Visual Studio 2012, ASP.Net 2.0

Education

Masters -

Management

Bachelors -

Commerce

Apprentice Education -

Chartered Accountancy

Skills

  • Experienced with MS SQL Server
  • SQL Server Integration Services
  • SQL Server Reporting Services
  • SQL Server Analysis Services
  • T-SQL Query Optimization
  • Power BI Proficiency
  • DAX Reporting Skills
  • Database Management
  • Data Warehouse Management
  • Data Normalization Techniques
  • Data extraction
  • Data loading
  • Data profiling
  • Data mapping
  • Data cleansing
  • Data aggregation
  • Data presentation
  • Dashboard creation
  • Data visualization
  • Database management
  • Data integration
  • ETL processes
  • Requirements Assessment
  • Problem solving
  • Technical documentation
  • Report design
  • Java Development
  • Gherkin
  • XPath
  • JSON
  • Crystal Reports Development
  • Azure Data Factory
  • JIRA Workflow Optimization
  • GITHUB
  • Agile Methodologies
  • Behavior-Driven Development
  • SCRUM Framework Implementation
  • Software Development Lifecycle
  • Software Testing Lifecycle
  • Snowflake
  • Selenium WebDriver
  • TestNG
  • Test-Driven Development

Project Highlights

  • Automated ETL Processes: Reduced manual workload by 40% by implementing optimized SSIS workflows.
  • Data Warehouse Optimization: Improved reporting efficiency by 60% by redesigning data warehouse models.
  • Power BI Implementation: Led the transition from Power BI, enhancing real-time analytics and visualization.

Timeline

Sr. SQL BI Developer

MyNexus Health
01.2023 - Current

Sr. SQL BI Developer

Harmony Healthcare
01.2019 - 11.2022

SQL BI Developer

Caterpillar Financial
02.2016 - 12.2018

Bachelors -

Commerce

Apprentice Education -

Chartered Accountancy

Masters -

Management

Similar Profiles

CREATE PROFILE
Md. Haque