Data Analyst Sql Server

ZENIFER CHOWDHURY

SQL/BI/ ETL Developer Data Analyst

Contact: 929-***-****

Email: ***********@*****.***

Professional Summary

Around 8+ years of extensive expertise as an MSBI developer, spearhead database management, data warehousing, T-SQL scripting, and business intelligence initiatives across diverse industry sectors, including Health Care, Banking, and various industry.

Assume ownership of critical tasks such as database design, security implementation, ETL development, report generation, and application deployment, showcasing proficiency across various SQL Server iterations from 2005 to 2019, as well as Oracle platforms.

Demonstrate skill in crafting intricate T-SQL scripts, encompassing Views, joins, DDL/DML Triggers, and User-Defined Functions, to maintain peak database performance and ensure steadfast data integrity.

Implement advanced data modeling techniques to seamlessly align database structures with evolving business requirements, optimizing data warehouse efficiency.

Lead ETL development efforts, harnessing SSIS packages to streamline data extraction, transformation, and loading processes from diverse sources, including flat files, Excel, SQL Server, Oracle, and more.

Execute complex data transformations using a comprehensive suite of SSIS components like Data Flow Task, Control Flow Task, Script Task, and Data Conversion, enhancing the efficiency of data processing workflows.

Cultivate a culture of data integrity and expedited troubleshooting by integrating robust error handling and logging mechanisms within SSIS, proficiently managing and automating SSIS package execution through SQL Server Agent and complementary tools.

Architect data solutions grounded in a deep understanding of data warehousing principles, with a focus on dimensional modeling and star schema design.

Lead the design and development of insightful reports using versatile reporting tools such as SSRS, Power BI, and Tableau, empowering stakeholders with dynamic dashboard creation and ad-hoc reporting solutions across diverse data sources.

Drive application performance optimization, testing, and bug remediation efforts leveraging Microsoft .NET Core (C#, VB.net) and SQL Server databases, developing custom PowerShell and Python scripts to streamline file management workflows across platforms such as sFTP, AWS S3, and Azure Blob storage.

Proficient in Azure Data Factory to perform Incremental Loads from Azure SQL DB to Azure Synapse.

Experience in moving data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.

Experienced in Microsoft Power BI to extract data from external sources and modify data to certain format as required in Excel.

Strong skills in visualization tools Power BI, Confidential Excel - formulas, Pivot Tables, Charts and DAX Commands

Play a key role in cloud infrastructure planning and design, leveraging AWS capabilities and Azure Data Factory features to orchestrate data workflows, schedule processing tasks, and meet evolving business needs.

Enable seamless data visualization and analysis by connecting Power BI or Tableau to Azure data repositories, empowering stakeholders with actionable insights.

Engage in Agile development methodology using Jira and Azure Devops, including daily standups, sprint planning sessions, code reviews, and change management review sessions.

Key Area of Expertise

•Data Visualization (Power BI, Tableau, SSRS)

•Dashboard Development

•DAX

•Error Handling

•Database Querying

•Source Control

•SQL

•Performance Tuning

•Export & Import (DTS)

•Azure SQL Database

•Azure Data Factory

•Azure DevOps

•Agile & Scrum

•KPI’s

•JIRA

CERTIFICATIONS & AWARDS

Microsoft Certified: Power BI Data Analyst Associate

Foundations: Data, Data, Everywhere, Coursera, Google, USA

DevOps Engineering with Cloud Computing, People N Tech Institute of Information Technology (PIIT), USA

Oracle Database SQL Certified Associate.

Microsoft Certified: Azure Data Engineer Associate (DP-203)

Microsoft Certified: Azure Database Administrator Associate (DP-300)

Microsoft SQL Certification: Azure Data Fundamentals

Education: - Bachelor of Computer Science

Masters of Science in Information Technology (MSIT)

Professional Experience

TD Bank, NY (07/2022 – Present)

Sr. SQL/BI Developer

As a Senior SQL BI Developer, my role involves leading the design, development, and implementation of ETL processes and Business Intelligence solutions and develops complex SQL queries and work closely with stakeholders to gather and analyze business requirements, translating them into technical specifications for ETL and BI solutions. Develop and maintain data pipelines and workflows using ETL tools such as SSIS and develop reports, dashboards, and visualizations using BI tools such as Power BI, Tableau, or SSRS.

Responsibilities:

Offer specialized support and troubleshooting for existing SQL procedures embedded within our Banking Management System's critical business processes, ensuring uninterrupted operation.

Develop, fine-tune, and manage complex T-SQL components, including stored procedures, views, and functions, to enable seamless data management and processing.

Engineer resilient and adaptable ETL systems utilizing SSIS, architecting SQL Integration Services packages and SQL Reporting Services (SSIS and SSRS) to meet the dynamic needs of banking operations.

Created Dax Queries to generated computed columns in Power BI.

Created reports in Power BI by importing data, shaped and transformed data for business intelligence (BI), Visualize data, author reports, scheduled automated refresh of reports and created and share dashboards based on reports in Power BI desktop.

Develop BI Dashboards, Reports and maintain existing Reports to Visualize data in a business environment with large-scale, complex data sets.

Design SSIS packages to extract data from diverse sources prevalent in the banking sector, such as relational databases, flat files, Excel spreadsheets, XML files, and APIs, transforming it as per regulatory guidelines for loading into target databases or data warehouses.

Implement robust data cleansing, validation, and enrichment processes within SSIS, leveraging transformations like Derived Column, Conditional Split, Lookup, and Aggregate to handle intricate data scenarios.

Utilize Power BI for data preparation, applying DAX for advanced calculations and measures, collaborating closely with stakeholders to deliver bespoke reporting and analytics solutions tailored to banking requirements.

Fine-tune report performance and scalability within Power BI to ensure efficient data visualization and analysis, facilitating strategic decision-making for operations.

Establish seamless connections between Tableau and diverse banking data sources, encompassing databases, spreadsheets, and cloud platforms, to provide comprehensive data visualization tailored to financial analytics.

Maintain and enhance SSRS dashboards to accommodate evolving banking requirements, ensuring the accuracy and relevance of data presented.

Integrate Azure Data Factory (ADF) with other Azure services such as Azure SQL Database and Azure Blob Storage within the banking ecosystem, constructing robust data workflows to enforce governance and security standards within ADF pipelines.

Connect Azure SQL Database with Azure Analysis Services to develop OLAP cubes tailored to banking analytics, enabling interactive data analysis and reporting capabilities for deeper insights into banking operations.

Environment: SQL Server 2019/2016, Visual Studio 2019/2016, ADF, Azure Databricks, Azure DevOps, SSIS 2019/2016, Tableau, Alteryx, Power BI, GIT, Jenkins, SharePoint, JIRA, API, C-Sharp, Shared Risk Platform, EDW, EDL, Hive, ServiceNow, JIRA, Confluence, PowerShell, PY-Spark, Python.

Cigna, CT (08/2020 – 06/2022)

Power BI/ ETL Developer

My role involves ensuring the stability and optimal performance of production systems by both proactively identifying and promptly responding to system vulnerabilities and defects. Additionally, I am responsible for designing and constructing an ETL framework for automation purposes. This includes utilizing T-SQL for production support tasks, developing SSIS packages and ADF Pipelines, and generating reports using Tableau, SSRS and performance tuning.

Designing, developing, and maintaining ETL processes using SQL Server Integration Services (SSIS) to extract data from various sources such as electronic health records (EHR) systems, claims databases, and operational systems.

Implementing data transformations and cleansing operations within SSIS packages to ensure data quality and consistency before loading it into the data warehouse or data lake.

Designing and maintaining the data warehouse infrastructure using Azure SQL Database or SQL Server on-premises for storing integrated and transformed data.

Optimizing database performance through indexing, partitioning, and query optimization techniques to support efficient data retrieval for reporting and analytics purposes.

Implementing data security measures such as role-based access control (RBAC), encryption, and auditing to protect sensitive healthcare data and comply with regulatory requirements like HIPAA.

Developing interactive and insightful dashboards, reports, and visualizations using Tableau and Power BI to provide stakeholders with actionable insights into key performance indicators (KPIs), healthcare metrics, and patient outcomes.

Collaborating with business users and analysts to understand reporting requirements, design effective data visualizations, and iterate on dashboard designs based on feedback and evolving business needs.

Leveraging Azure services such as Azure Data Lake Storage, Azure Synapse Analytics (formerly SQL Data Warehouse), and Azure Analysis Services to build scalable and high-performance analytics solutions.

Integrating on-premises data sources with Azure cloud services using Azure Hybrid Connections, Azure Data Factory, or SQL Server Stretch Database to enable seamless data access and integration across hybrid environments.

Environment: MS SQL Server 2012, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, Visual Studio 2012, Microsoft Office, Team Foundation Server (TFS), SharePoint, Cloud Berry, AZ Copy, MS Azure.

BeneSys Inc, MI (09/2018 – 06/2020)

Data Analyst/ BI Developer

Conducted thorough data analysis using statistical methods, machine learning techniques, and exploratory data analysis (EDA) to extract actionable insights. Employed advanced analytical tools and techniques to identify trends, patterns, and correlations within datasets, contributing to informed decision-making processes.

Collected, cleaned, and preprocessed data from diverse sources, including databases, spreadsheets, and APIs, ensuring accuracy and integrity for analysis.

Loaded transformed data into target databases, data warehouses, or data lakes using ETL processes, adhering to data loading best practices and performance optimization techniques.

Conducted in-depth data analysis using SQL queries and statistical methods to identify Trends, patterns, and insights, facilitating data-driven decision-making.

Created visually compelling reports, dashboards, and visualizations using tools such as Power BI and Tableau, effectively communicating key findings to stakeholders.

Develop and maintain executive dashboards, operational dashboards, and self-service BI solutions, providing users with real-time access to key performance indicators (KPIs) and actionable insights.

Managed multiple data analysis projects simultaneously, prioritizing tasks, setting timelines, and meeting project deadlines.

environment: MS SQL Server 2019/2017, SSIS, T-SQL, Azure Data Factory, SSRS, BIDS, SQL Profiler, Power BI, Tableau, JIRRA Azure DevOps, Azure Data Warehouse, FTP, T-SQL, SSMS, Windows Server.

Leidos, VA (08/2017 – 06/2018)

SQL/SSRS/SSIS Developer

As an SQL Developer, I was responsible for designing, optimizing, and maintaining databases, ensuring efficient data retrieval and integration. I collaborated with stakeholders to create data models, implement security measures, and monitor database performance. Additionally, I provided support, documentation, and expertise to ensure smooth data operations and alignment with business needs.

Implementing data transformations and cleansing operations within SSIS packages to ensure data quality and consistency before loading it into the data warehouse or data lake.

Designing and maintaining the data warehouse infrastructure using Azure SQL Database or SQL Server on-premises for storing integrated and transformed data.

Leveraging Azure services such as Azure Data Lake Storage, Azure Synapse Analytics (formerly SQL Data Warehouse), and Azure Analysis Services to build scalable and high-performance analytics solutions.

Developing interactive and insightful dashboards, reports, and visualizations using Tableau and Power BI to provide stakeholders with actionable insights into key performance indicators (KPIs), healthcare metrics, and patient outcomes.

Optimize SSIS package performance by identifying and resolving performance bottlenecks, fine-tuning SQL queries, optimizing data flows, and implementing parallel processing techniques to meet performance SLAs.

Create, optimize, and maintain complex T-SQL as part of stored procedures, views, functions.

Environment: SQL Server (2017/2016/2014), SSIS, SSRS, SSAS, Visual Studio, T-SQL, XML, HTML, MS Excel, Power BI, Tableau Server, Data warehouse, Report Builder, Query Analyzer, Agile, Git.

Apex Health, NC (08/2016 – 07/2017)

SQL/ Tableau Developer

Innovatively fine-tuned BI solutions for optimal performance, orchestrating intricate measures such as query refinement, data caching strategies, and meticulous index enhancements, culminating in expedited response times and seamlessly efficient data retrieval mechanisms.

Proficiently designed and deployed T-SQL queries to facilitate comprehensive reporting and address intricate business needs.

Demonstrated expertise in developing, implementing, and optimizing stored procedures and functions using T-SQL, ensuring streamlined database operations.

Successfully executed bulk loading and incremental loading strategies leveraging SSIS, tailored to accommodate varying data volumes and latency requirements.

Configured server settings to automate email notifications for DTS processes, facilitating prompt response to process success or failure.

Applied advanced tuning techniques to optimize database queries, indexes, and data access patterns, resulting in notable enhancements in ETL performance.

Environment: SQL Server (2017/2016/2014), SSIS, SSRS, SSAS, Visual Studio, T-SQL, XML, HTML, MS Excel, Power BI, Tableau Server, Data warehouse, Report Builder, Query Analyzer, Agile, Git.

Contact this candidate