Sql Server Power Bi
Resume:
Nurul Amin ****.******@*****.***
Summary:
• Over 12+ years of strong experience as Data Engineer in various domains like telecommunication, health insurance, banking, insurance, and pharmacy with expertise in T-SQL, Traditional/Modern data warehousing.
• Proven ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Designed conceptual, logical, and physical model of database
• Expert in data conversion, data modeling, normalization, and SQL server enterprise manager
• Wrote complex stored procedures, user defined functions, views, and creating other database objects
• Expert in migration of data from Oracle, Sybase and DB2 to SQL Server
• Involved creating ETL process, data warehousing, operations data store concepts, data marts and OLAP technologies
• Expert in creating, maintaining, and configuring DTS and SSIS packages
• Involved working with heterogeneous data source like Excel, flat file, Oracle, DB2, and SQL Server
• Expert in logging, error handling by using event handler, and custom logging for SSIS packages
• Involved creating operational reports in SSRS 2008/2008r2/2012/2017/2019 i.e., drill-down, drill- through, dashboard, sub-report, and matrix reports for various domains.
• Work with tabular and multidimensional data model writing DAX using SSAS MDX query visualize various kinds of Power BI report
• Expert in performance tuning, query optimization, client/server connectivity, database consistency checks using DBCC utilities
• Involved in data scrubbing, data staging and data validation in preparation of pushing data to production environment
• Expert in database backup, recovery and applied necessary SQL server database service packs, hot fixes and security patches
• Defined and administered database standards, controls, procedures and documented the same
• Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support
• Working knowledge of ADF, Azure SQL, Dataflow in cloud with Power BI visualization Skills:
• MS SQL Server 2017/2016/2019/2012/2008r2, Visual studio 2010/2008,2012,2017,2019 (SSIS/SSRS), Power BI, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, MySQL, Windows Server, Erwin, SSMA, C++, MS Office, big data clouding (Hive), and Python.
• Cloud Stack: Azure (Azure Blob, Azure Data Lake, Azure Data Factory, Azure Synapse Analytics [Dedicated SQL Pool, Spark Pool], Azure Key Vault & basic of Data bricks) Microsoft Fabric, one lake, lake house, file storage, shortcut, external storage, semantic model in Power BI.. Education: Bachelor of Science-Economics, 1998
Professional Experience:
Wells Fargo Bank
Jan 2023 – Current
New York
• Develop and maintain data pipeline and ware housing solutions for banking stakeholder
• Worked with multiple source and destination such as Oracle, Salesforce, SQL Server, Data Lake, Flat files
• and others • Architecting ETL solutions in SSIS, Microsoft Fabric, one lake, lake house, file storage, shortcut, external storage, semantic model in Power BI.
• Coordinated development of reports and visualization in Power BI
• Working with business to collect requirements, convert them into technical specification and getting it implemented by developers.
• Worked extensively with SQL, DAX and M Query
GalaxE Solutions
Jan 2022 – Nov 2022
New York
Tech Lead (MS SQL, MSBI, ADF, and Power BI Developer)
• Managing offshore team and production support
• Develop and maintain ware housing and transactional system for a retail giant
• Working with SQL server databases, power BI, SSIS, and SSRS
• Working with business to collect requirement, convert them into technical specification and getting it implemented by developers.
• Created Power BI reports using joins in multiple tables from multiple databases using complex SQL Queries
• Extensive use of DAX functions
• Implemented DAX functions for various calculations for efficient data visualization in Power BI. Jade Global
July 2021 – Dec 2021
San Jose CA
Senior MS SQL and MSBI Developer
• Managing offshore team, And production support.
• Revolution food distribution for school across the United States.
• Working with SQL server,2019 to write SQL script store procedures complex query.
• Work on Data factory tool in order to load the data from on premise to Azure Data Lake
• Working with ETL tool SSIS 2019 create design and deploy package also production support.
• Working with Power BI generating reports collaborating with customer B2 in Azure cloud platform.
• Developed 85% custom Power BI dashboards, visualizations, and interfaces with SSRS to deliver meaningful and actionable insights.
• Hands on Experience working with Azure Data Lake Analytics to analyze the structured, nonstructured data from various sources.
• Perform DAX queries using Power BI.
• Developed custom reports and deployed them on server using Power BI. Northwell Health- New York, NY
May 2020 – April 2021
Senior MS SQL and MSBI Developer
Working with health insurance projects comprising data from renown health providers across the United States.
• Worked with SQL server 2016,2019 to write SQL script store procedures function complex scripting
• Design, develop & test the ETL 2019processesaccordingtoindustriesbestpracticesusingSSIS to create and design various packages for parent’s child packages
• Generated SSRS report as well as Power BI visualization with DAX function
• Create and maintain existing dynamic SSIS packages to load data from and to MS SQL Server and Oracle, Excel files, and flat files.
• Used SQL profiler, and indexes for performance tuning & debugging issue whenever necessary. • Data quality (DQ) checking transformations and deploying
• Script task for Data Flow and Error Handling in SSIS.
• Developed custom reports and deployed them on server using Power BI.
• Complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers& import/export wizard while developing packages.
• Create reports such as Matrix Report, Drill-Down and Drill- Through Reports, Parameterize Reports, Dash- BoardReport, and Link report using SSRS 2008r2 Reporting tool.
• Designed Power BI Data Visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Understanding and knowledge of ADF, Azure SQL Data flows, Copy data and transformation Tools
&Technologies: MS SQL Server 2016/2014/2012/2008r2, writing SQL script store procedures function complex scripting, SSIS 2008r2/2008, SSRS 2008r2/2008 (remedy ticketing dashboard, ETL), T- SQL, Power BI visualization, From ADF, Azure SQL Data flows
Infosys- Atlanta, GA
Aug 2019 –May2020
Senior MS SQL and MSBI Developer
Working with health insurance projects comprising data from renown health providers across the United States.
• Worked with SQL server 2017 to write SQL script store procedures function complex scripting
• Design, develop& test the ETL processes according to industries best practices using SSIS for parent’s child packages
• Data quality (DQ) checking transformations and deploying
• Script task for Data Flow and Error Handling in SSIS.
• Used SQL profiler, and indexes for performance tuning & debugging issue whenever necessary.
• Generated SSRS report as well as power BI visualization
• Developed Power BI reports and dashboards from the multiple data sources using data blending.
• Complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services
• Created Power BI Reports using the tabular SSAS models as source of data in Power BI Desktop and publish reports to service.
• Developed and published reports using Power BI and written DAX formulas and expressions.
• Create and maintain existing dynamic SSIS packages to load data from and to MS SQL Server and Oracle, Excel files, and flat files.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/ export wizard while developing packages.
• Designed Power BI Data Visualization.
• Create reports such as Matrix Report, Drill-Down and Drill-Through Reports, Parameterize Reports, Dash- BoardReport, and Link report using SSRS 2008r2 tool. Tools &Technologies: MS SQL Server 2017/2014/2012/2008r2, writing SQL script store procedures function complex scripting, SSIS 2008r2/2008, SSRS 2008r2/2008 (remedy ticketing dashboard, ETL), T- SQL, Power BI visualization.
ConnectiveRx- New Jersey
Jan 2019 – Jun 2019
MS SQL/SSRS Developer
The goal of the project was to analyze patient accounts, increase the prescribed patients, implementing coupons to the physicians, and selling medication with affordable price.
• Increasing more prescribed patients and implementing coupons and working with physician data information
• Work on SSMS writing stored procedure in order to generate ad hoc report.
• Work with Sybase process data to dump in DWH
• Interaction with clients while business requirements, design & implementation phases.
• Create and maintain existing dynamic SSIS packages to load data from and to MS SQL Server and Oracle, Excel files, and flat files.
• Design, develop & test the ETL processes according to industries best practices using SSIS.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
• Script task for Data Flow and Error Handling in SSIS.
• Utilizing T-SQL to create data base objects such as Tables, Views, Functions, Triggers and Stored Procedures.
• Complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Used SQL profiler, and indexes for performance tuning & debugging issue whenever necessary.
• Report for all kinds of reports and SSIS packages.
• Create reports such as Matrix Report, Drill-Down and Drill-Through Reports, Parameterize Reports, Dashboard Report, and Link report using SSRS 2008r2 and Power BI Reporting tool. Tools & Technologies: MS SQL Server 2017/2014/2012/2008r2, SSIS 2008r2/2008, SSRS 2008r2/2008
(remedy Ticketing dashboard, ETL), T-SQL, Power BI, and Hive. Comcast- Atlanta, GA
Jan 2018– Dec 2018
MS SQL/SSRS Developer
The main project goal was to increase more consumers in the market, upgrade the network connection and to compete other cable providers.
• Interaction with clients while business requirements, design & implementation phases.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services.
• CreatedandmaintainedexistingdynamicSSISpackagestoloaddatafromandtoMSSQL Server and Oracle, Excel files, and flat files.
• knowledge and understanding data warehouse on cloud concept in snowflake.
• Worked on SSMA for transferring data from Oracle to MS SQL Server.
• Design, develop &testtheETLprocessesaccordingtoindustriesbestpracticesusingSSIS.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
• Used Script task for Data Flow and Error Handling in SSIS.
• Worked with T-SQL to create database objects such as Tables, Views, Functions, Triggers and Stored Procedures.
• Worked with big data in Linux platform extracting data from various sources and processing and deployed to the repository using Hive tool
• Work with Hadoop Ecosystem technologies including Hive, HDFS, Storm, and Spark.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Used SQL profiler, and indexes for performance tuning & debugging issue whenever necessary.
• Documented for all kinds of reports and SSIS packages.
• Created reports such as Matrix Report, Drill-Down and Drill-Through Reports, Parameterize Reports, Dashboard Report, and Link report using SSRS 2008r2 and Cognos Reporting tool. Tools & Technologies: Windows XP, MS SQL Server2014/2012/2008r2, SSIS2008r2/2008, Hive, SSRS2008r2/2008(remedy ticketing dashboard), T-SQL, Excel, and Acrobat Reader. And Hive Tool Sanofi Pharmaceuticals- Bridgewater, NJ
May 2016 – Dec 2017
MS SQL Server / SSIS/SSRS Developer
The goal was to support the data warehouse management globally to help the scientist with the updated database to compete with the current pharma market to increase the profit margin.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
• Successfully implemented indexes on tables for optimum performance.
• ExtensivelyusedJoinsandSub-queriesforcomplexqueriesinvolvingmultipletablesfrom different databases.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS2008r2.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Performed Documentation for all kind of SSIS packages.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Involved in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS). Tools &Technologies: MS SQL Server 2012/2008r2, SSIS 2008r2/, T-SQL Visual Studio, Windows XP, MS Office 2007/2010, MS Access.
Rite Aid- New York, NY
Mar 2015 – Mar 2016
MS SQL Server/SSIS and SSRS Developer
Pharmaceuticals and retail industry. Increasing more consumers in the market with top notch service. The main project goal was to use integration services to extract data from sources and push that data through staging and create package, data analysis and generating various report such as drilldown, drill through, sub-report, linked report and dashboard report using SSAS/SSRS.
• Involved in creating various Tables, Views and Functions based on the requirement specified by EDW team and wrote complex Join statements for combining data from various Databases and tables.
• Involved creating complex stored procedure based on business requirements.
• Proficient in tuning SQL queries using execution plan, index, and DMV.
• Created SSIS packages with different data sources (SQL Server, Flat files, Excel files, CSV files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Use Packages by testing and cleaning the Standardized Data by using tools in Data Flow.
• Involved in scheduling SSIS packages in multiple servers using SQL Server Agent.
• Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.
• Schedule and maintain Full, Differential, Transactional Log backup and restore the data using restore with recovery and restore with no recovery option.
• Worked on locking, blocking and dead lock issues.
• Involved in performance tuning of slow running queries using execution plan and index tuning wizard.
• Scheduling jobs and alerts using SQL Server Agent and configured database mail for any job failure. Tools
&Technologies: MS SQL Server 2008r2 T-SQL, SQL server Integration service 2008r2/ Microsoft visual studio, Windows server 2008.
Popular Bank- New York, NY
Feb 2013 – Jan 2015
MS SQL Server/SSIS and SSRS Developer
The project was to analyze bank accounts, to market additional products more effectively to the customers who have one or more accounts with the bank i.e., business, and personal account.
• Involved in planning, defining, and designing data and provided documentation
• Developed and Implemented UNIX shell scripts through command task to handle requirements like dropping and building indexes, flat file archiving/dropping process etc.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs
• Used various SSIS tasks such as conditional split, derived column, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse
• Created error and performance reports on SSIS packages, Jobs, stored procedures, and triggers.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS
• PerformedT-SQLtuningandoptimizationofqueriesforreportsthattakelongerexecution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server2005
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers
• Involved in documentation for all kinds of reports, DTS and SSIS packages
• Designed and implemented stored procedures and triggers for automating tasks
• Maintained the table performance by following the tuning tips like normalization, creating Index, and ensured best practices are applied and integrity of data is maintained through security and documentation.
Tools & Technologies: MS SQL Server 2008r2/2005 T-SQL, SQL server Integration service 2008r2/2005 Microsoft visual studio, Windows server 2008
Well Care New York
Jun 2011 – Jan 2013
MS SQL Server/SSIS SSAS and SSRS Developer
Health Care industry: serving
• Complex simple SQL queries stored procedure function views triggers using joins, sub queries and correlated sub queries to retrieve data from the database.
• ETL: Extracting data from different sources using SSIS tool like flat file excel CSV RDBMS like SQL oracle bring staging area do the DQ apply transformation and load to EDW.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services and deploy them.
• Involved in documentation for all kinds of reports, DTS and SSIS packages
• Designed and implemented stored procedures and triggers for automating tasks using SQL server Agent.
Contact this candidate