Sql Bi Mail Agent

SHAZIYA AFROZ CHOWDHURY

Phone: 929-***-****, Email: ***********@*****.***

Microsoft Business Intelligence/SQL Developer

Highly motivated SQL server/BI Developer with 7+ years of IT experience having multiple skill set and extensive working experience in Data Warehousing and Business Intelligence Technologies with expertise in SQL Server development, MSBI (T-SQL, SSIS, SSAS, SSRS, Power BI), Azure, Tableau for building, deploying and managing applications and services through a global network of Microsoft - managed data centers.

CORE STRENGTHS:

•Azure SQL Database

•Azure Data Factory

•Azure DevOps

•Azure SQL Data Warehousing

•MSBI (SSIS&SSRS)

•Data Visualization

•SQL Server programming

•Power BI

•Tableau Development

•Tableau Desktop

•Power BI Desktop

•Power Pivot

•Dashboard Development Tools

•Chart Visualizations

•Visual Design

•DAX, MDX

•BIDS

•Data Migration

•Error Handling

•Performance Tuning

•Bulk Copy Program (BCP)

•Export & Import (DTS)

•Reporting Package Creation

•Data Claim Sets

•SQL Coding

•Database Querying

•Database Storage & Procedures

•Source Control

•Snowflake Schema

•Agile & Scrum

•KPI’s

•JIRA

•Complex Problem-Solver

•Technical/Client Support.

professional summary

Expert in writing T-SQL queries, complex Stored Procedures, User Defined Functions (UDF), designing and implementing Database triggers, Views, and Indexes.

Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent.

Excellent in High Level Design of ETL DTS Packages &SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.

Strong Experience in Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and U-SQL Azure Data Lake Analytics.

Having good experience in ETL Concepts like Lookup Caches, Package Configurations and Variables.

Experience in creating complex SSIS packages using proper control and data flow elements with error handling.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Experience in report writing using SQL Server Reporting Services (SSRS), Tableau, and Power BI creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Experience in integrating the SSRS reports into web applications using report viewer control and URL methods and creating data driven subscriptions to different users using Report Manager.

Strong skills in visualization tools Power BI, Confidential Excel - formulas, Pivot Tables, Charts.

Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table Calculation, Calculated fields, Groups, Parameters, Forecasting, Blending and Trend lines.

Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.

Expertise in creation of CI/CD pipelines using Azure DevOps.

Experience with centralized version control system such as Subversion (SVN) and distributed version control system such as Git.

Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills.

Education

Bachelor of Computer Science and Engineering.

TECHNICAL SKILLS:

Databases & database Tools

MS SQL Server 2019/2016/2017/2014/2012/2008R2/2008/2005, MS Access, SQL Server Management Studio (SSMS), Azure Data Studio, SQL Profiler Query Analyzer, MS Visual Studio

Cloud Technologies

Azure SQL, Azure data Lake, Azure Data Factory, Azure DevOps.

Reporting & Analysis Tools

Visual Studio, Report Builder, SSRS, Tableau, Power BI Desktop, Power BI Services

ETL Tools

SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Data Bricks, SQL Data Warehouse, Data Transformation Services (DTS), BCP.

BI Platform

Business Intelligence development Studio (BIDS), Visual Studio, SSIS, SSRS, SSAS, Power BI, Tableau

Data Visualization

Power BI, Tableau, SSRS, KPI’S, Excel, Dashboards

Languages

T-SQL, XML, Dynamic SQL, MDX, DAX.

Data Modeling Tools

MS Visio, Erwin

Miscellaneous

Agile, Azure DevOps, CI/CD, JIRA, MS Office, GIT, GITHUB, Visio, Power Point, TFS.

Operating Systems

Windows 7/ Vista /XP professional. Windows Server 2008/2003/2000, UNIX.

Application Packages

MS Office 2013/2007/2003/2000(Word, Excel, Power Point, Access).

professional experience

Cigna Bloomfield, CT

Duration: 04/2021- Present

SQL BI Developer

Role and Responsibilities:

Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

Creating views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Created, tested and implemented SQL backup strategy based on the business needs, utilize the combination of full, differential and transactional log backup to ensure all necessary business data is properly backed up.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Extensively used Joins and Common table expressions to simplify complex queries involving multiple tables.

Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.

Monitoring and maintenance of all components that make up the Data Warehouse and Business Intelligence infrastructure.

Design and Develop Data Warehouses using Star Schema, Snowflake Schema depending upon business needs.

Involve in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments. Maintain existing ETL processes and trouble shoot issues as they arise.

Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.

Use the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.

Use different transformation controls like Look up, Conditional split, data conversion, unpivot Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.

Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.

Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and U-SQL Azure Data Lake Analytics.

Developing Multiple Power BI dashboards on top of different sources and developing data model in Power BI and implemented Many to Many relationships.

Expertise in DAX Queries to build Power BI calculated measures and columns. Publishing Power BI reports to Power BI web service and Implemented Security for users

Creating effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.

Experience in refreshing dataset using Power BI gateway.

Creating high quality reports, dashboards and analytics to meet the needs of various business clients such as Operations, Sales, Customer Service, Finance, and Executives.

Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

Generate score cards with executive summary dashboards to display performance monitoring measures with Tableau.

Implement Tableau BI Dashboard reporting solution for different groups in the organization.

Performing T-SQL tuning and optimizing queries for reports that take longer execution time.

Working with other team members for implementing data pipelines and solutions in production using DevOps for deployment or automation.

Manage all CM tools (JIRA, GitHub) and their usage / process ensuring traceability, repeatability, quality, and support.

Environment: SQL Server 2019/2017, SQL BI Suite (SSIS, SSRS, SSAS), T-SQL, DAX, Power Query, DTS, OLAP, Power BI Desktop, Power BI Service, Tableau Server, Data Gateway, Azure SQL, SQL Data Warehouse, SQL Profiler, XMLA, MS Excel, JIRA, GitHub, Azure DevOps, Azure Data factory.

Citi NY, NY

Duration: 04/2019- 03/2021

ETL/BI Developer

Role and Responsibilities:

Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.

Used SQL Profiler T-SQL Duration template for tracking execution time of T-SQL Statements.

Designed and Built ETL packages to migrate data from different source systems using Data vault modeling concept.

Worked on ETL Load SSIS Packages, report / cube creation and data visualization including dashboards and reports leveraging charts (Pivot tables), gauges and drill-through.

Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

Involved in usage of various SSIS components like Slowly Changing Dimension, Conditional Split, Merge, Merge Join, Multicast, Union All, Sort, Derived column, SQL execution task, Variables, and Error Handling before loading data into the Data warehouse.

Optimizing Azure Data Factory (ADF) Pipelines with Various Partitioning Techniques and implement Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.

Transferred data from various data sources/business systems including DB2, MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat file source, transformation etc. Created derived columns from the present columns for the given requirements.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

Recommending Dashboards per Tableau visualization features and delivering reports to Business team on timely manner.

Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.

Creating Data warehouse analytical Reporting Visualizations using Power BI dashboards, trendlines, donut chart, bubble Filters, Hierarchies, Data Blending, Parameters, PKIs.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI’s.

Implemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.

Created AD-Hoc Report models and drill down and drill through and complex reports using SSRS.

Involved in Full Life Cycle Development of Reporting Projects includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.

Utilized Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Involved in clean-up old data in Azure DevOps Server.

Worked in Implementation life cycles of both Agile and Waterfall Methodologies.

Worked on GIT to maintain source code in Git and GitHub repositories.

Environment: SQL Server 2019/2017, SQL BI Suite (SSIS, SSRS, SSAS), T-SQL, DAX, Visual Studio, BIDS, DTS, OLAP, Blob, Power BI Desktop, Power BI Service, Tableau Server, Data Gateway, Azure SQL, SQL Data Warehouse, SQL Profiler, XMLA, MS Excel, JIRA, TFS, Azure DevOps, Azure Data factory.

Digital Realty Dallas, TX

Duration: 04/2017 - 03/2019

SQL Server SSRS/SSIS Developer

Role and Responsibilities:

Created Queries in T-SQL, Stored Procedures and Views to store the data of clients, advisors using SQL Server Management Studio. Create User Defined Functions, Views to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.

Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring. Create database design documentation at architectural and functional level.

Create complex SSIS packages using multiple tasks and transformations in Control flow and Data flow.

Migrating SQL Server 2012 SSIS packages to SQL Server 2017.

Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.

Implement different Error handling and Event Handling Techniques to ensure efficient package execution.

Worked with SSIS packages involved FTP tasks, Merge, and Merge joining, Sort, Pivot and Unpivot Control Flow Transformations.

Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).

Created different KPI using calculated key figures and parameters and designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.

Environment: SQL Server 2017, Business Intelligence Development Studio, ETL, Data Warehouse, SSRS 2008 R2, SSIS 2008 R2, MS Visual Studio 2008, T-SQL, Window 7, Team Foundation Server.

Morgan Stanley NY, NY

Duration: 09/2015 - 03/2017

SQL Developer/MSBI Developer

Role and Responsibilities:

Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.

Defined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.

Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.

Designed SQL Server Database and Table Design with Schemas, Constraints and Views.

Extracted data from various sources like DB2, VSAM, SQL Server 2014/2012/2008 R2, .CSV, Microsoft Excel, and Text file from Client servers.

Identified issue 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.

Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2016/2008 R2 Business Intelligence Development Studio.

Created datasets, data source and involved in deploying the reports into the report server.

Created reports using SQL Server 2016 (SSRS) and integrated into the web front end.

Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance.

Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).

Worked on Performance tuning, and optimization of procedures and queries.

Environment: SQL Server 2016/2014, T-SQL, SSIS, SSRS, Microsoft Excel, Microsoft PowerPoint.

Contact this candidate