Sql Server Power Bi

SQL Server Business Intelligence Developer

Summary:

Over 12 years of strong experience as a SQL Server BI Developer, specializing in database design, development, and implementation of business applications across industries such as Finance, Entertainment, and Energy.

Expertise across all phases of the Software Development Life Cycle (SDLC) with a focus on performance tuning, ETL pipelines, and end-to-end reporting solutions.

Advanced proficiency in writing complex T-SQL queries, stored procedures, triggers, views, joins, user-defined functions, indexes, and DDL/DML scripting.

Deep experience with SQL Server BI stack: SSIS (ETL), SSRS (reporting), and SSAS (tabular modeling).

Skilled in developing cascading and parameterized SSRS reports, sub-reports, and ad-hoc reports using expressions, global variables, and custom formatting.

Hands-on experience creating ETL workflows from heterogeneous data sources such as Excel, Flat Files, SQL Server, SharePoint Lists, and SAP HANA.

Strong understanding of logging, event handling, and performance tuning within SSIS packages using advanced transformations.

Solid knowledge in defining and deploying cubes using SSAS and the deployment wizard.

Expertise in creating the reports using Power BI Desktop and Looker Studio.

Working knowledge of Python, with additional experience in JavaScript, VBScript, ASP.Net, and C#.Net.

Experienced in backup/restore operations, database maintenance plans, and general database administration tasks.

Recent experience as a Gen AI / Data Scientist, working on RAG architecture, prompt engineering, and deploying AI agents (Voice, Chat, Email, SMS) integrated with LLMs and vector databases (Pinecone, FAISS).

Known for strong analytical thinking, solution-oriented mindset, and excellent team collaboration and communication skills.

Education:

Masters in computer science in Southern University and A and M college, Baton Rouge, Louisiana, USA (2008-2010)

Certifications:

Microsoft Power BI: 70-778 - Analyzing and Visualizing Data with Microsoft Power BI (Certification ID 17637958)

Technical Skills:

Languages

Python, C#.Net, ASP.Net, Java Script, VB Script, PowerShell

Database

MS SQL Server 2000/2005/2008/2012/2016, PostgresSQL

Data Warehouse Tools

MS SQL Server Integration Services 2005/2008/2012, MS SQL Server Reporting Services 2005/2008/R2, MS SQL Server Analysis Services 2005/2008/2012/2016, Power BI Desktop/Power BI Service, Azure Data Factory, Azure Analysis Services.

Tools/Utility

MS Office Suite, SQL Server Management Studio (SSMS) 2005/2008/2012,MS Visual Studio 2012/2017/2019, Team Foundation Server, OSI soft PI System, Visual Studio Code, Cursor, MDS (Master Data Services)

Work Experience:

Client: ContactSwing.AI Jan 2024 – Present

ContactSwing helps businesses talk to their customers using AI through voice, chat, email, and text messages. They use smart technology to make communication easier and faster.

Role: Sr BI/Gen AI Developer

Designed and developed interactive Power BI dashboards to visualize key business metrics including customer engagement, AI agent performance, and operational KPIs.

Automated data ingestion and transformation pipelines using Power Query and DAX, pulling data from PostgreSQL, APIs, and vector databases.

Created custom visuals, slicers, and drill-through pages to allow business users to explore AI usage trends across Voice, Chat, Email, and SMS channels.

Developed Power BI alerts and subscriptions for proactive monitoring and reporting.

Collaborated with cross-functional teams to translate business needs into analytical dashboards that informed product and AI strategy.

Optimized Power BI reports using data modeling best practices (star schema, calculated columns, measures) for improved performance.

Ensured data accuracy, governance, and compliance across Power BI environments using Row-Level Security (RLS) and workspace permissions.

Gen AI Integration & Support

Built Gen AI solutions to enhance customer support across Voice, Chat, Email, and SMS.

Implemented RAG architecture to connect AI with internal company data for more accurate, context-rich responses.

Developed and maintained AI agents for multiple channels and optimized prompts for accuracy and natural interaction.

Used Pinecone vector database for semantic search and improved retrieval using document chunking and metadata tagging.

Integrated feedback loops and analytics tracking to iteratively enhance AI responses.

Client: Noble Drilling Corporation, Sugar Land, TX Sep 2019 – Dec 2023

Noble Drilling Corporation operates as an offshore drilling contractor. The Company offers drilling services for oil and natural gas markets.

Role: Business Intelligence Developer/BI Partner

Projects Involved:

HSE – Health Safety and Environment

NDOR – Performance/Operations

SkillsVX – Training and Development

Involved in end-to-end process of gathering requirements, providing data, creating reports for the Business Users.

Involved in extracting the data from various sources like SharePoint Lists (On Prem), SharePoint Online and Microsoft SQL Server database, SAP HANA and Flat files using SSIS.

Designed and developed Tabular model for analytics purpose.

Designed and developed various Power BI dashboards, reports to support HSE, Operations/Performance, Maintenance, SkillsVX, Subsea – Well Control teams.

Created Datasets in T-SQL, stored procedures for SSRS.

Designed and developed various SSRS reports to support business needs.

Extensively wrote complex T-SQL queries, Store Procedures, user defined functions, and views.

Expertise in writing complex DAX functions in Power BI.

Involved in managing the enterprise gateway in Power BI service.

Created Workspaces, Apps, Dashboards in Power BI for business users to view the developed reports.

Involved in developing the PowerShell scripts to extract the data from third party vendors using Rest API.

Designed and developed SSIS packages to perform ETL operations from upstream systems.

Created and monitored the jobs in SQL server agent.

Involved in optimizing and performance tuning of the T-SQL scripts, store procedures by creating the indexes on the tables.

Involved in deploying the SSIS packages, Tabular models to production.

Involved in daily production support activities.

Involved in creating the reports using OSI soft PI system for MPD (Managed Pressure Drilling).

Maintained the master data for rigs, crew required list, training certificates and licenses using Master Data Services tool (MDS).

Client: Bank of America Home Loans, Thousand Oaks, CA Oct 2013 – June 2019

Bank of America Home Loans is the mortgage unit of Bank of America. Bank of America Home Loans is composed of Mortgage Banking, which originates purchases, securitizes, and services mortgages.

Role: SQL server BI Developer/Consumer Product Strategic Analyst

Projects Involved:

GRA – Consumer Mortgage Loss Forecasting Information Management

Involved in end-to-end process of providing data, creating the reports for the Business users (Loss Forecasting Modeling team).

Designed and developed various kinds of SSRS reports including sub reports, charts, drill down reports, cascading parameterized reports using Visual studio 2010 for the loss forecasting modeling team for their presentation.

Developed the SSRS reports connected to analysis services cubes by writing complex MDX queries.

Closely worked with business users on requirements gathering.

Designed and created data extracts, supporting SSRS, POWER BI or other visualization tools reporting applications.

Involved in processing the month end data to provide it for loss forecasting modeling team.

Automated and scheduled the various T-SQL scripts, SSIS packages on SQL server agent.

Extensively worked on SSIS packages and ETL transformations for extracting the data from upstream system databases and flat files to the local database.

Used Control Flow Tasks and Data Flow Tasks, Execute SQL task for creating SSIS Packages.

Extensively wrote the complex Store Procedures for the data transformation from source to destination.

Extensively wrote the complex T-SQL scripts, store procedures, scalar value functions and table value functions.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Involved in optimizing and performance tuning of the T-SQL scripts, store procedures by creating the indexes on the tables and inserting the necessary data into temp tables.

Configured the email setup on the Report server and set up the automated email subscriptions reports to users in various formats like Excel, PDF etc.

Worked on creating the SSAS cubes, adding new dimensions to the cube, processing and deploying it to production.

Maintained and administrated the Team foundation server projects of Mortgage loss forecasting group.

Using Team foundation server (TFS) for managing source code changes.

Involving in developing test cases for Unit Testing.

Client: The Walt Disney Company, Burbank, CA Sep 2011 – Sep 2013

The Walt Disney Company is an entertainment company worldwide. Its Media Networks segment engages in broadcast television network, television production and distribution, television stations, broadcast radio networks and stations, and publishing and digital operations.

Role: SQL Server BI Developer

Projects Involved:

IPPM (Integration Planning and Process Management)

Involved in designing and developing the simple and complex reports using Report Builder 2.0, Visual Studio 2010.

Actively worked with business unit on requirements gathering.

Developed various kinds of reports like Sub Reports, Drill Down reports, Tabular Reports, Matrix Reports, Parameterized reports, Charts using Report Builder 2.0.

Worked on troubleshooting the issues related to Project Server and SSRS Reports.

Extensively wrote the store procedures, scalar valued functions and table valued functions, T-SQL scripts and views that are used in reports.

Worked on the Reportable objects’ models used in reports where users can build their own reports.

Set up the File Share and Email subscription reports to users in various formats like Excel, PDF, and MHTML etc.

Worked on modifying the reports like filters, parameters, adding new columns or fields to the reports whenever requested by user.

Extensively wrote the VBA scripts and expressions for fields, color-coding, and fonts in the SSRS reports.

Involved in setting the jobs on timely run basis in SQL server agent.

Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

Documented the issues & uploaded in the Disney Wiki for internal training and usage.

Involved in end-to-end testing and moving the code from development to pre-production and to production.

Client: Bank of America Home Loans, CA Aug 2010-Aug 2011

Bank of America Home Loans is the mortgage unit of Bank of America. Bank of America Home Loans is composed of Mortgage Banking, which originates purchases, securitizes, and services mortgages.

Role: Application Developer

Projects Involved:

CLEAR (Corporate Loan Economics Accounting and Reporting)

1.CLEAR Reporting

2.CLEAR Tax

3.CLEAR Segmentation Reporting

4.CLEAR DCI (Data Center Integration)

Responsibilities:

Involved in all phases of System Development Life Cycle (SDLC).

Developed, executed and maintained SQL queries/scripts and to validate completeness, integrity and accuracy of data.

Involved in gathering data and documenting it for further reference.

Extensively wrote and edited existing Stored Procedures, Views, and User Defined Functions using T-SQL.

Developed Sub Reports, Tabular Reports, Matrix Reports, Drill down Reports and Charts (2D and 3D) using SQL Server Reporting Services 2008/R2.

Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions, and functions.

Responsible for deploying reports to SharePoint and Troubleshooting for any error occurs in execution.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Developed the scripts using T-SQL to populate the Fact tables and Dimension tables for SSAS cubes.

Optimized scripts by getting insight from Execution Plan for better performance of the database.

Created the Monthly and Daily partitions and Indexes on the tables for better performance.

Developed the SSIS packages for creating, merging, and dropping of partitions for the SSAS cubes.

Extensively wrote VB script for creating and dropping of partitions for SSAS cubes using Script task.

Contact this candidate