Business Intelligence
Resume:
Mejanul Kabir
Sr. SQL BI Developer
Email: *************@*****.***
SUMMARY:
Over 14 years of IT experience with Database Development, Business Intelligence, ETL Developments and Reporting.
Experience in all MSBI stack (SSIS,SSMS, SSRS, SSAS)
Experience in creating database objects such as Indexes, Views, complex Triggers, CTE, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.
Experience in writing complex T-SQL for data analysis.
Experience in gathering requirements from business users.
Experience in MS Visio, Erwin. Experience in creating ER diagrams for data warehouses.
Experience in Azure DevOps, TFS, Jira.
Experience in data profiling and data analysis.
Experience in designing, writing, performance tuning and troubleshooting SSIS packages.
Experience in end-to-end Power BI analytics solution.
Experience in Tableau data visualization.
Experience in designing, building, and maintaining data warehouses using multi-dimensional models.
Experienced in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool.
Experience in creating data pipelines for various reporting purposes.
Experience with Snowflakes.
Experience in Azure Data Factory, databricks.
Experience in gathering business requirements and writing technical specifications. TECHNICAL SKILLS:
MS SQL Server, SSIS, SSAS, SSRS, Oracle 10g, MS Access, SQL, Transact-SQL(T-SQL), PL/SQL, XML, Power BI, Tableau C#. SFTP, Sales Force, VBScripts, QlikView, QlikSense, Crystal reports, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Azure Data Factory, Azure Databricks, AWS, TFS, Jira, Github.
PROFESSIONAL EXPERIENCE:
Harmony Cares, Remote Jan’2023 – Current
Sr. SQL BI Developer
Responsibilities
Worked with business users to gather requirements to create data pipeline & report.
Managed various ETL projects by using SSIS.
Led the development of Tableau dashboards to analyze healthcare claims data.
Worked on converting tableau into Power BI.
Designed and optimized Tableau visualizations, ensuring seamless data interaction and usability.
Working on various SSRS, Power BI report and Tableau reports. Handling performance issues for reports.
Written various complex stored procedures to complete ETL jobs.
Defined and executed measurement strategies for marketing campaigns, aligning with organizational KPIs.
Working with large volume of data and performance issue for SSIS packages and SSRS reports.
Designed and managed ETL processes and data pipelines using SQL and Azure Data Flow, ensuring efficient data extraction, transformation, and loading for analytics.
Working on data profiling to analyze source data.
Providing end to end implement and support for Power BI reporting system. Environment: MS SQL Server 2019, SQL Server Integration Services (SSIS), Tableau, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, MicroStrategy, Snowflakes, TFS, Visual Studio 2012, ASP.Net 2.0, Azure Data Flow. Franklin American Mortgage Company, Franklin, TN June’2017 – November’ 2022 Sr. SQL BI Developer
Responsibilities
Worked on providing end to end support for operational and analytical reporting system using SSRS and Power BI.
Designed ETL process from scratch using SSIS.
Worked with large volume of data and performance issues for SSIS packages and SSRS reports.
Worked on data profiling to analyze source data.
Provided end to end implementation and support for Power BI reporting system.
Worked on various SSRS & Power BI reports. Handling performance issues for reports.
Worked on converting tableau into Power BI.
Worked on Azure database development. Create ETL packages IN and Out of Azure.
Worked on Snowflakes data warehouse implementation.
Practiced best practices for data engineering SDLC.
Played 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, Tableau, MicroStrategy, Snowflakes, TFS, Visual Studio 2012, ASP.Net 2.0
Caterpillar Financial, Nashville, TN March’2016- May’2017 Sr. SQL BI Developer
Responsibilities
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
Chamberlin Edmonds Healthcare, Atlanta, GA Sep’2011- December’2015 Sr. BI/ETL Developer
Responsibilities
Developed, created, and managed complex stored procedures and SSIS package to maintain client’s file process.
Created and maintained database objects like tables, views, triggers, indexes.
Troubleshoot and performance developed on Stored Procedures and SSIS packages.
Created and developed the EDI process (835,837).
Managed Claim audit process.
Developed member eligibility process.
Created opportunity analysis and value reports.
Created and maintained Sales Force reporting.
Developed and maintained SSRS reports (drill-through, drill-down, linked and cache reports).
Performed administration roles for report server.
Developed and managed Tableau reports.
Provided data support for Tableau reports using SSAS tabular model.
Created and managed ODS data warehouse.
Worked on total BI solution (SSIS, SSRS, SSAS)
Performed as a Lead developer to manage enterprise data solutions.
Used SQL Profiler along with Data Tuning Advisor for optimizing complex T-SQL code
Created, developed and managed data for reporting services.
Worked on all phases of a development application development process. Gathering requirements, analyzing data, creating data flow, implementing application development, testing and deployment.
Environment: MS SQL Server 2008 R2, 2012, SQL Server Integration Service (SSIS), SQL Server Reporting Services 2008(SSRS), Tableau, MicroStrategy, JIRA, TFS 2012, Wells Fargo, San Francisco, CA Jan’10-Sep’11
SQL BI Developer
Responsibilities
Analyzed the business requirement and functional specifications provided by the data analyst.
Create various reports (ad-hoc, Tableau, drill-through, crystal).
Used MS SSIS as the main ETL tool along with stored procedures.
Used data profiler to analyze source data.
Developed created and managed complex stored procedures and UDF in SQL Server 2008
to support the functionality various front-end applications and performing different data
Created various database objects like Indexes, Views, Triggers and User-defined functions depending upon business rules and optimized them.
Used SQL Profiler along with Data Tuning Advisor for optimizing complex T-SQL code
Ensured the integrity on the database by creating triggers and constraints to make sure that the data is always stored in consistent way at any given point of time.
Played a major role in optimizing large tables by creating indexes (clustered and non- clustered indexes) and partitioning the table depending upon the no of records coming in from the front-end application.
Designed Staging Database using ER-win.
Created dimensions and fact tables based on the business requirement.
Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, flat files and load it to the destination database after using multiple transformations.
Implemented the Master Child Package Model for easier maintenance and better performance.
Defined Data sources, Data Source views and Created MOLAP cube using SSAS 2008. Environment: SQL Server2008 R2, SSRS, SSAS, SSIS, Windows 2003 Server / Vista Enterprise, MS Visual Studio 2005, Erwin, Crystal reports.
Contact this candidate