Senior SQL/BI Developer with Power BI Expertise

Professional Summary

Vaishnavi M

903-***-**** *********.*****@*****.***

Over 4 years of extensive experience in database design, development, and administration using Microsoft SQL Server

(2022/2019/2017/2016), with deep expertise in T-SQL for writing complex queries, stored procedures, functions, triggers, and optimizing database performance. Skilled in developing, deploying, and monitoring ETL workflows using SSIS and integrating data across systems using Informatica PowerCenter. Proficient in building and tuning SSAS cubes, creating MDX queries, and delivering enterprise reports via SSRS, Power BI, Tableau, and QlikView. Experienced in performance tuning with tools like SQL Profiler and Windows Performance Monitor, as well as creating dynamic dashboards and KPIs using Power BI, including real-time integration with Azure and Logic Apps. Adept in data migration, cloud automation with PowerShell, and managing data pipelines for both on-premise and cloud-based environments including Azure.

Technical Skills

• Data Warehousing & BI SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), Azure SQL.

• Reporting Tools SSRS 2022/2019/2017/2016/2014, Excel, Tableau, Power BI.

• Database MS SQL Server 2022/2019, Oracle, MS-ACCESS.

• Programming C, Python, C++, TSQL, DAX, MDX, SQL

• Cloud Technologies AWS (S3, Lambda, Glue, Redshift), Azure (Data Lake, Synapse Analytics, SQL Database)

• IT Processes Software Development Life Cycle (SDLC), Project Management

• Productivity Applications MSWord, MS Excel, MS Access, MS Project, Visio

• Operating System Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

• Aws Application Servers Microsoft IIS 6.0/5.0/4.0, Apache. Professional Experience

UT Southwestern Medical Center, Dallas, Tx Jul2023 - Present SQL/BI developer

• Expert in building rich, interactive dashboards using Power BI by integrating data from SQL Server, Azure SQL, SAP BW, and Oracle. Proficient in writing advanced DAX expressions for calculated columns, measures, KPIs, and time intelligence.

• Extensive experience in developing high-performance ETL processes using SSIS and IBM DataStage, including architecture design, error handling, event logging, checkpointing, and performance tuning.

• Skilled in designing and implementing tabular, matrix, drill-down, and chart-based reports using SSRS

(2022/2019/2017/2016/2014) and Crystal Reports; strong command of stored procedure-driven report generation.

• Deep understanding of Azure Data Factory, Azure Synapse Analytics, and Azure Databricks for building cloud-based ETL pipelines and performing large-scale data processing using SQL and Py Spark.

• Expert in designing Kafka-based streaming pipelines for processing real-time events, enabling responsive dashboards and near- instant decision-making in analytics environments.

• Hands-on experience using Power Query in Power BI to cleanse, transform, and merge data across heterogeneous sources.

• Skilled in developing and optimizing complex PL/SQL and T-SQL queries, stored procedures, functions, and triggers for data transformation and automation.

• Experience using Python and libraries such as Pandas, NumPy, Matplotlib, and Seaborn for exploratory data analysis and visualization, especially in ad hoc analytical projects.

• Worked with TIBCO Spotfire for data pivoting, security control, and visualizations, including implementation of write-back functionalities.

• Managed and maintained Azure DevOps pipelines for deploying BI solutions, ensuring consistent delivery and automated deployment across environments.

• Actively used JIRA for sprint planning, task tracking, and collaboration across cross-functional Agile teams in end-to-end data projects.

• Migrated reporting environments from Excel, SSRS, and Power BI to Tableau, enhancing data storytelling and self-service capabilities.

• Configured and maintained Power BI gateways and refresh schedules to keep reports in sync with on-premise and hybrid data sources.

• Deployed and scheduled complex SSIS packages for daily, weekly, and monthly data loads, enabling automated ETL processes across OLTP and OLAP systems.

• Contributed across the SDLC including requirements analysis, testing, documentation, and production support, occasionally taking on Business Analyst responsibilities for gathering data needs and defining KPIs Environment: SQL Server 2022, ETL, SSIS, T-SQL, Power BI Gateway, Power BI Service, DAX, Python, Excel, Microsoft Power BI, SQL, No-SQL, Server Data Tools (SSDT), OLTP and OLAP Lockton, Plano, Tx Jul2022 - Jun2023

ETL/BI developer

• Expert in designing and maintaining robust ETL workflows using Informatica PowerCenter, including creation of complex mappings with transformations like Lookup, Aggregator, Joiner, Update Strategy, and Expression to support business rules in data warehouse environments.

• Extensive experience in data modelling for data warehouses, designing star and snowflake schemas, and integrating real-time and batch data sources into SQL Server and Amazon Redshift for enterprise analytics.

• Proficient in developing and configuring Informatica Workflows, Worklets, and Sessions, incorporating components like Event Wait, Decision Tasks, and Email Notifications to control data flow across target environments including Netezza.

• Expert in writing complex T-SQL queries, stored procedures, functions, and scripts for data transformation, validation, and business logic enforcement, especially in SQL Server 2022/2019 environments.

• Skilled in developing ad-hoc, drill-through, and paginated reports using SSRS, with experience in designing mortgage and financial reports, integrating datasets from stored procedures and T-SQL scripts.

• Hands-on experience in designing and deploying data pipelines using AWS Glue, managing Amazon Redshift clusters, and implementing ETL logic for scalable cloud-based analytics solutions.

• Integrated Informatica pipelines with Tableau dashboards, enabling automated data refreshes and maintaining high data accuracy in business visualizations.

• Developed and optimized SSIS packages involving control flow and data flow elements, including complex data movements from flat files, Excel, and SQL sources into OLAP/OLTP systems.

• Experience using SQL*Loader to ingest flat file data into Oracle databases, ensuring proper indexing and data validation.

• Proficient in creating BTEQ scripts, and using Fast Load and Multi Load utilities to transfer large datasets into Teradata systems, including key generation and transformation.

• Utilized SQL Profiler and Execution Plans for identifying bottlenecks, optimizing slow-performing queries, and improving overall database performance in development and staging environments.

• Designed and implemented OLAP cubes for multidimensional analysis, integrating data from various OLTP sources like Oracle, Access, CSV, and flat files into SQL Server Analysis Services (SSAS).

• Configured Role-Based Access Control (RBAC) in Azure to enforce secure access to cloud-based data pipelines and reporting assets.

• Performed comprehensive data cleansing and transformation using Informatica mappings, ensuring data consistency and alignment with business KPIs.

• Developed Windows Batch Scripts to automate data load processes and job scheduling, supporting seamless integration of legacy data systems with modern platforms.

Environment: MS SQL Server 2022, SSRS, T-SQL, SSIS, C#, MS Access 2021, Power BI, DAX, SQL Server Management Studio

(SSMS), SharePoint, ASG-Zena, IBM Cognos, SQL, Python, OLTP and OLAP. Health Edge Aug2020 - Dec2021

SQL Server/BI developer

• Expert in creating complex stored procedures, CTEs, Tally tables, and queries with inner/outer joins and subqueries using Microsoft SQL Server 2019/2017 for advanced data manipulation and reporting logic.

• Deep experience in building and optimizing SSIS packages with components like Execute SQL Task, Bulk Insert, File System Task, and Data Flow for high-volume ETL workflows, supporting both SQL Server 2019 and 2017 environments.

• Expertise in dimensional modelling using star and snowflake schemas, with hands-on experience in designing conformed and role- playing dimensions using tools like Erwin Data Modeler to support scalable data warehouse solutions.

• Designed and deployed Azure SQL Database solutions for BI platforms, and implemented CI/CD pipelines in Azure DevOps for controlled and automated deployments of database and ETL codebases.

• Expert in developing parameterized, ad hoc, and drill-down reports using SSRS (2019/2017) by writing optimized stored procedures, managing subscriptions, snapshots, and exporting in multiple formats (Excel, PDF, XML, HTML).

• Built and extended OLAP cubes and dimensions using SQL Server Analysis Services (SSAS), and created reports from Analysis Services cubes by integrating with SSRS for multidimensional insights.

• Built multi-layered staging architectures using SSIS, extracting data from varied sources (CSV, SQL Server 2018), performing data cleansing and transformation in Data Flow Tasks, and loading into data warehouses.

• Optimized Tableau extracts (TDE, Hyper) for better performance, created visualizations using live connections and extracts from SQL Server, Azure Synapse, and Redshift, and maintained data refresh schedules.

• Integrated Amazon Quick Sight with AWS-based sources to build real-time visual dashboards, ensuring data freshness and KPI visibility across distributed environments.

• Configured SSRS report snapshots, email subscriptions, and export formats to meet daily/weekly/monthly reporting needs across multiple teams, enhancing reporting automation and accessibility.

• Packaged and deployed SSIS projects across environments using SSIS Deployment Wizard and Azure DevOps, enabling smooth migration, rollback, and version tracking of ETL solutions

• Experienced in working with Tableau TDE and Hyper extracts, optimizing data models for performance tuning, and configuring scheduled refreshes for high-volume reporting environments.

• Connected Tableau and Power BI to Azure Synapse Analytics, leveraging Synapse’s high-performance capabilities to enable real- time business dashboards and reporting pipelines.

• Developed dynamic stored procedures and views to support ad-hoc SSRS reports, enabling users to generate flexible reports based on business-driven parameters and filters.

• Developed reports for business needs in multi-format delivery (Excel, PDF, XML, HTML) using SSRS and other tools, supporting both interactive and print-friendly formats for executive reporting. Environment: SQL Server, Business Intelligence Studio (SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ERWIN, MS Excel

Education

Masters in Computer Science from University of North Texas, Denton, TX Jan2022 - Dec2023

Contact this candidate