Mezanur Rahman
Dallas,Texas
Summary
Versatile and results-driven MS SQL/BI Developer with over 5+ years of experience in designing and implementing database solutions, ETL pipelines, and business intelligence systems across Finance, Healthcare, Insurance, Retail, and IT domains. Proven expertise in Microsoft BI Stack (SSIS, SSRS, SSAS), Power BI, and Azure Data Services, with a strong background in SQL/T-SQL development, data modeling, and performance tuning. Adept at delivering high-impact dashboards, managing large-scale data integrations, and driving data-driven decision-making through innovative reporting solutions. Committed to continuous improvement, technical excellence, and leveraging cutting-edge tools to meet evolving business needs.
Overview
6
6
years of professional experience
1
1
Certification
Work History
MS SQL/BI Developer
FNB Bank
11.2024 - Current
- The main objective of this project is to handle data in a few databases that include data retrieval manipulation through implementation of views, cursors, stored procedures and triggers. Furthermore, I work on various roles for loading data from multiple sources into the application databases using SSIS packages, developed SSRS Reports and built Power BI and Tableau dashboards.
- Responsibilities:
- Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
- Worked with DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
- Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
- Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular intervals for better performance.
- Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
- Designed SSIS Packages to transfer data from flat files to SQL Server using Visual Studio.
- Created DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
- Identified issues and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
- Managed Power BI Service components including Workspaces, Apps, and deployment pipelines, ensuring proper access control and versioning for dashboards used by multiple business units.
- Designed and optimized complex data transformations using Power Query (M language) to prepare and clean data for multiple Power BI reports, reducing data refresh time by 25%.
- Strong scripting skills in Python and PowerShell for workflow automation and cross-platform data management.
- Working knowledge of big data and data science tools including Python, R, Hadoop, and PySpark.
- Configured scheduled data refreshes via Power BI Gateway and monitored refresh failures, implementing automated alerts to ensure timely and accurate reporting.
- Automated data ingestion and pipeline orchestration using Python and Airflow, enhancing consistency and security.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).
- Experience in creating configuration files to deploy the SSIS packages across all environments.
- Created horizontal partitioning of data for different file groups.
- Created reports on Power BI Desktop and published on Power BI Report Server.
- Expertise in DAX Queries to build Power BI calculated measures and calculated columns. Developed Multiple Power BI dashboards on top of different sources.
- Published Power BI reports to Power BI web service and Implemented Security for users and developed Tabular model and generates Power BI dashboards on top of that.
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
- Performed Tableau query extension functions when connected to relational data sources.
- Develop reports using complex formulas and query the database to generate different types of ad-hoc reports using SSRS Configured and trained users to use Reporting Services.
- Experience in working on different kinds of reports Parameterized Reports, Linked Reports, and Drill-through reports.
- Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
- Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
- Production support, troubleshooting and debugging in a high-volume transaction processing environment utilizing a lot of XML.
- Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
- Actively working on Azure, Azure SQL Database, Azure SQL Data Warehouse, ADF v2, Blob Storage, and using SSIS in ADF environment on purpose of scripting calling APIs and so on.
- Implemented Azure DevOps solutions for various development teams, including source control, work item tracking, build and release management.
- Worked on GIT (Git Hub) repositories as Distributed Version Control System.
- Expertise in Agile Scrum methodology, worked on Agile Environment. Experience in creating stories and tasks for Agile Iteration.
- Environment: MS SQL Server 2019, MS SQL Server Integration Services (SSIS), TFS, MS SQL Server Analysis Services (SSAS), Power BI Desktop, Python, Powershell, Power BI Service, Tableau Server v7/v8/v9, Tableau Desktop v7/v8/v9, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Azure, Git.
MS SQL/ETL/BI Developer
CARGILL INC
06.2022 - 10.2024
- Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on the requirements and converting them into technical specifications.
- Participated in the requirement gathering sessions to understand the expectations and worked with system analysts to understand the format and patterns of the upstream source data.
- Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
- Implemented Event Handlers and Error Handling in SSIS packages.
- Built KPIs in tabular based on the end user required.
- Build end to end automation of social media sources.
- Automated data quality validation and transformation logic using Python and PySpark in Azure environments, reducing manual QA effort by 50%.
- Administered Power BI workspaces and datasets, managing user roles, access permissions, and publishing apps for enterprise-level consumption.
- Developed robust Power Query transformations to integrate data from Excel, Flat Files, and SQL Server, enabling seamless and automated report generation.
- Optimized Power BI dataset performance by implementing incremental refreshes, DAX measures, and calculated columns tailored to business KPIs.
- Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
- Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
- Created SSIS packages to Export data from text file to SQL Server Database.
- Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
- Developed data model in Power BI and implemented Many to Many relationships. Utilized Power BI gateway to keep dashboards and reports up-to-date with on premise data sources.
- Created calculated Columns and measures in Power BI and Excel depend on the requirement using DAX queries.
- Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.
- Create user interface reports using Tableau sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.).
- Maintained and Installed Tableau Server in all the environments.
- Established referential integrity, data consistency, indexing, and data cleanup procedures to maintain high-quality data for reporting.
- Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
- Pumping data between Excel and Servers using Flows and Scheduled Jobs in Flows and ADF Pipelines.
- Building the pipelines to copy the data from source to destination in Azure Data Factory (ADF V1). Scheduled Jobs in Flows and ADF Pipelines.
- Worked on source controls like TFS, GIT, Azure DevOps for development and maintaining code.
- Directly interact with end users to get the ad hoc requirements and report modifications.
- Environment: MS SQL Server 2017/2019, SSIS/SSAS/, ETL, T-SQL, Visual Studio 2017, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, Tableau Server v7/v8/v9, Tableau Desktop v7/v8/v9, SQL Server Management Studio, PL/SQL & SQL Server Data Tools (SSDT).
MS SQL Server/ ETL Developer (SSIS) / Power BI Report
Anthem
10.2021 - 04.2022
- Increasing more prescribed patients and implementation coupons and working with physician data.
- Utilizing T-SQL to Create Database Objects such as Tables, Indexes, Views, Function, Temp Table, Table variable, Triggers, Store Procedures and Dynamic SQL.
- Proficient in writing T-SQL Insert, Update, Delete Statement (DDL, DML) and New Features like CTE, Rank & Dense Rank Function, Pivot Function and SQL Server Window Function.
- Responsible for Query Execution plans and making sure each query is using appropriate and useful indexes.
- Wrote complex SQL Queries using joins and Sub Queries to Retrieve Data from the Database
- Proficient in Creating ETL Package for data Conversion using various Transformations tasks.
- Create and Maintain existing Dynamic SSIS Packages to Load Data from SQL Server, Excel files, flat files and CSV Files.
- Extensively used various SSIS Object such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & Import/ Export Wizard While developing packages.
- Strong Experience in Creating, Configuring, Error Handling and Testing in SSIS Packages.
- Used SSIS to create ETL packages (dtsx files) to validate, Extract Transform and Load data (ETL) To data warehouse databases, data mart databases.
- Proficiency in Developing, Deploying and Monitoring SSIS Packages.
- Excellent in Developing Dashboards Reports connecting to various sources like SQL Server, Excel, Flat File, SharePoint.
- Used Various Visual including bar, line, area, map, pie chart, tree map, matrix, tables, Funnel etc.
- Creating Power BI Reports, Dashboards, Workspace, Apps, Publishing & Sharing with Team And scheduling the report refresh using data Gateway.
- Providing ad-hoc reports on demand, performing data validations.
- Created calculated Measure and column using DAX (Data Analysis Expression) functions.
- Implementing Row level security to make reports more secure.
- Environment: MS SQL Server 2017 MS Access, |Data Warehousing| Data Integration (ETL) SSIS, Reporting (Power BI) Windows server2010, Oracle.
SQL/ BI Developer
Riverstone Resources
01.2020 - 08.2021
- Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2017 and migrated data from 2016 to 2017
- Used SSIS to create ETL packages (dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases
- Used advanced features of SQL Server Integration Service for newest versions.
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
- Developed, deployed and monitored SSIS Packages including upgrading to (SSIS)
- Strong Experience in Creating, Configuring, Error Handling and Testing in SSIS Packages.
- Extensively used joins and sub queries to simplify complex queries involving multiples tables.
- Wrote complex Stored Procedure, Queries, Triggers, Functions, joins, sub queries, Indexes, User-defined functions and Cursors for application for ETL Packages.
- Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes
- Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder
- Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
- Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services.
- Good knowledge in creating Drill-down, Parameterized and Sub-Reports using RDL.
- Environment: MS SQL Server 2016/2017, SSRS, MS Access, SSIS, Windows server 2008.
- The Riverstone Group is the preeminent insurance run-off manager in the world and is owned by Fairfax Financial Holdings Limited, a financial service holding company. Riverstone is a global insurance industry leader specializing in the acquisition and management of insurance portfolios. The project goal was to create a new client portal for the new claim acquisition and create user friendly report for client portal.
Education
Bachelor of Science - Computer Science
Cleveland State University
Cleveland, Ohio, OH12.2019
Skills
- BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Tools (SSRS), SQL Server Analytical Services (SSAS), Tableau, (Power BI) Power Point Services
- Relational Databases: SQL Server 2017/2016/2017/ 2014/2012/2008r2/2008, MS Access, DB2, MS Excel
- Tools and Packages: SQL Server Management Studio (SSMS), BIDS, Azure Data Studio, SQL Profiler, Query Analyzer, MS Visual Studio, TFS
- Reporting & Analysis Tools: Visual Studio, Report Builder, SSRS, Tableau, Power BI Desktop, Power View, Power Map, Power Pivot
- ETL Tools: SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Azure SQL Data Warehouse, Data Bricks, Data Transformation Services (DTS), BCP
- Languages: T-SQL, XML, MDX
- Operating Systems: Windows 2010/2008/2007/2003/2000/NT 40/9x, MS-DOS, UNIX, Linux
- Cloud Technologies: Azure SQL, Azure data Lake, Azure Data Factory, SQL Data Warehouse
- Application Packages: MS Office, MS Outlook (Microsoft Office Suite)
Certification
- Microsoft Certified: Azure Fundamentals (AZ-900)
- Microsoft Certified: Azure Data Engineer Associate (DP-203)
- Microsoft Certified: Azure Database Administrator Associate (DP-300)
Timeline
MS SQL/BI Developer
FNB Bank
11.2024 - Current
MS SQL/ETL/BI Developer
CARGILL INC
06.2022 - 10.2024
MS SQL Server/ ETL Developer (SSIS) / Power BI Report
Anthem
10.2021 - 04.2022
SQL/ BI Developer
Riverstone Resources
01.2020 - 08.2021
Bachelor of Science - Computer Science
Cleveland State University