Senior Data Integration & BI Architect

Saila

973-***-****

*****.********@*****.***

Professional Summary

Seasoned Data Integration and BI professional with extensive experience in designing, developing, and optimizing ETL pipelines, data warehouses, and reporting solutions. Adept at leading teams of developers, delivering scalable data models, and ensuring high-performance SQL and ETL processes. Expertise in MS SQL Server, SSIS, Azure Data Factory, Power BI, Tableau, and iWay Data Migrator, with a strong focus on data quality, performance tuning, and actionable business intelligence. Skilled in analyzing complex data systems and translating stakeholder requirements into optimal technical solutions.

Core Competencies

ETL & Data Integration: SSIS (2008–2022), Azure Data Factory, iWay Data Migrator

Database Management: MS SQL Server 2008–2019, Azure SQL Database, PostgreSQL, Oracle

SQL & Performance Tuning: T-SQL, stored procedures, views, functions, indexing, query optimization

Data Modeling & Warehousing: Star & snowflake schemas, Fact & Dimension tables, OLAP cubes, SCD Type 1/2

Reporting & BI Tools: SSRS, Power BI, Tableau, WebFOCUS, Excel (PivotTables, Macros, VBA)

Programming & Scripting: C#, ASP.NET, ADO.NET, Python, R, PowerShell, Batch scripting

DevOps & Version Control: Azure DevOps, CI/CD pipelines, Git, TFS

Data Formats & Structures: JSON, XML, CSV, Parquet

Professional Experience

Associated Grocers of New England BI Developer (Remote)

Jan 2025 – Present

Designed and optimized SQL queries, views, stored procedures, and dimensional models.

Worked on Star schema and snow flake schema data modeling.

Orchestrate the data for data reporting.

Developed ETL workflows using Azure Data Factory for structured and semi-structured (Parquet) data ingestion.

Built and loaded data into Azure SQL Database and Synapse Analytics; ensured performance optimization.

Developed Power BI dashboards and reports for real-time business insights.

United Way of Greater Rochester Data Analyst (Remote)

May 2023 – Dec 2024

Designed, developed, and optimized SSIS packages for ETL processes into SQL Server data warehouse.

Developed and maintained T-SQL objects, automated workflows, and ensured data quality via profiling and error handling.

Built Tableau dashboards, interactive reports, and Excel VBA automation to streamline reporting.

Carson Tahoe Health Data Integration Engineer

Aug 2021 – May 2023

Extracted, transformed, and loaded data from multiple sources using iWay Data Migrator into PostgreSQL EDW.

Implemented dimensional modeling (star & snowflake schemas) for reporting optimization.

Automated ETL jobs, performed performance tuning, and delivered WebFOCUS dashboards.

CVS Well Partner, Inc. MS SQL Server / Report Developer

Jun 2018 – Jul 2021

Developed and optimized ETL packages, SQL procedures, and SSRS/Power BI reports.

Handled complex healthcare datasets (ICD-10, CPT, HL7) and ensured compliance with reporting requirements.

Automated SSIS job by sql agent.

Worked in dev and production support.

Fixing the bug by approved by test team

Education

Master of Science (Field/University Name)

SAS Certification

Microsoft SQL Server Certification

Contact this candidate