Sql Server Power Bi

PROFESSIONAL SUMMARY:

Data & BI Engineer with *+ years of experience in Microsoft Business Intelligence (MSBI) tools including SQL Server (2012/2014/2016), SSIS, SSAS, SSRS, and Power BI, delivering enterprise-scale data solutions and reporting systems.

Certified in Microsoft Fabric Data Engineering, with hands-on experience designing and building scalable data pipelines using Fabric Lakehouse, Data Factory, Notebooks, and Pipelines.

Strong command of T-SQL development, writing optimized and complex queries involving joins, indexing, stored procedures, views, and functions; adept in performance tuning using SQL Profiler, Execution Plans, and DBCC Commands.

Extensive expertise in ETL development using SQL Server Integration Services (SSIS), including error handling, transformations, and data flow optimizations.

Experienced in data warehousing, data modeling (physical/logical), data mapping, migration, and unit testing, leveraging tools like Erwin, TFS, GIT, SonarQube, BlackDuck, Checkmarx, ThreadFix, and SCA, ensuring versioning, code quality, security, and compliance.

Provided application support for i-Search and GLUE, key components of the enterprise CRM system, ensuring seamless access to customer and business data for front-line and back-office users.

Investigated and resolved data access, synchronization, and application performance issues, coordinating with infrastructure and data teams to maintain SLAs.

Facilitated user access management, issue triaging, and change control for CRM-related tools, contributing to enhanced user productivity and system reliability.

Strong knowledge of Power BI, with the ability to design and publish dynamic dashboards, create DAX measures, and manage datasets in the Power BI Service, including gateway configuration.

Proficient in SSAS cube design, dimension modeling, MDX queries, and building KPIs and drill-through actions to support OLAP-based analytics.

Skilled in developing and maintaining SSRS reports—matrix, parameterized, sub-reports, and OLAP reports—to meet various business intelligence needs.

Experience in data migration from legacy systems and between SQL Server versions, as well as integration with Oracle ERP systems.

Adept in working within Agile and Scrum environments—participated in sprint planning, daily stand-ups, backlog grooming, retrospectives, and iterative delivery of data products.

Collaborated with cross-functional teams including developers, QA, and business analysts to deliver high-quality solutions aligned with SDLC best practices using both Agile and Waterfall methodologies.

Strong documentation, communication, and stakeholder management skills with a focus on quality, timelines, and scalable design.

TECHNICAL SKILLS

RDBMS

MS SQL Server 2019/2016/2014/2012 MS Access, Sybase Server

Tools & Packages

SQL Server Management studio, Enterprise Manager, Profiler, Business

Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET, TOAD

BI Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS),

Data Transformation Services (DTS), SQL Server Analysis Services (SSAS),

MS Visio, Power BI,SAS

Application Packages

Microsoft Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS)

Operating Systems

Windows 10/8.1/8/7/XP, Windows Server 10/8.1/8/7/XP

Web Technologies

HTML, JavaScript, XML, XPath

EDUCATION

Bachelor’s Degree: Bachelor in Technology, JNTUH

Certifications:

Fabric Data Engineer Associate

EXPERIENCE SUMMARY:

Client: WellsFargo, Charlotte,NC

Duration: July2023 - Present

Role: ETL/SQL Server Developer

Responsibilities:

Designed and developed robust ETL pipelines using SQL Server Integration Services (SSIS) to extract, transform, and load data from multiple heterogeneous sources, ensuring data quality, consistency, and integrity.

Developed and optimized complex T-SQL queries, stored procedures, user-defined functions, views, and triggers to support business rules and reporting requirements.

Maintained, enhanced, and refactored legacy SSIS packages and SQL scripts to improve performance, scalability, and maintainability.

Performed data migration between systems using advanced SSIS logic and transformation strategies with proper mapping and validation.

Built and tuned SQL Server databases with optimal indexing strategies, normalization, and query performance optimization for high-volume transactional systems.

Conducted performance tuning and root-cause analysis using SQL Server Profiler, execution plans, and system DMVs to resolve slow-running queries and ETL bottlenecks.

Implemented and monitored CI/CD pipelines for Power Platform and MSBI components using tools such as TFS, GIT, SonarQube, BlackDuck, Checkmarx, ThreadFix, and SCA, ensuring code quality, security, and compliance.

Proactively debugged and resolved production issues in SSIS packages and SQL jobs, minimizing downtime and maintaining SLAs.

Collaborated with business stakeholders and analysts to gather requirements, define data workflows, and design scalable and maintainable data solutions.

Managed SQL Server environments, including database configuration, upgrades, patching, and maintenance tasks.

Delivered work within Agile/Scrum frameworks, participated in sprint planning, stand-ups, retrospectives, and ensured iterative delivery of high-quality solutions.

Documented technical specifications, ETL processes, and operational procedures using Confluence and supported incident tracking via ServiceNow and Jira.

Environment: MS SQL Server, T-SQL, SSMS, SSIS, Visual Studio, Autosys, Azure DevOps, ServiceNow, Confluence, Jira, Windows Server, SQL Server Profiler, SSRS, DTS, OLTP, XML.

Client: TD Ameritrade-Omaha, NE

Duration: August 2021- July2023

Role: SQL/ Power BI Developer

Responsibilities:

●Prepare source to target mapping data, like claims, insurance and provider related data.

●Expertise in writing complex DAX functions in Power BI and Power Pivot.

●Automated Power Query refresh using power shell script and windows task scheduler.

●Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL etc.

●Installed and configured Enterprise gateway and Personal gateway in Power bi service.

●Created Workspace and content packs for business users to view the developed reports.

●Weekly presentation to the business users about the reports and their changes as required.

●Created stored procedures and SQL queries to pull data into power pivot model.

●Participated in project planning sessions with project managers, business analysts and team members to analyse business requirements and outline the proposed solution.

●Owned up ETL process and responsible for the major architectural changes including the design of master packages and load strategies

●Utilized Power Query in Power BI to Pivot and Unpivot the data model for cleaning and massing.

●Extract Transform Load (ETL) development using SQL Server, SQL Integration Services (SSIS).

●Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

●Developed complex DAX Queries to generate computed columns.

●Storage development and design utilizing Blobs, Tables, Queues, Files

●Weekly presentation to the business users about the reports and their changes as required.

●Defines and captures metadata and rules associated with ETL processes

Environment: T-SQL, MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), Power BI Desktop, Data Factory (ADF), SQL Server Analysis Services (SSAS) 2016, Tableau, Visual Studio 2016, Business Intelligence Development Studio (BIDS), Team Foundation Server (TFS), SharePoint, MS Excel, Microsoft Windows Server.

Client: S&S Health, NJ

Duration: October 2019 – July 2021

Role: SQL BI Developer

Responsibilities:

●Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical reporting and scorecard/ dashboards on SQL Server using SSAS, SSIS/DTS, SSRS

●Participated in gathering User Requirements and System Specifications.

●Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.

●Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.

●Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.

●Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.

●Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.

●Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

●Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.

●Designed and implemented Parameterized and cascading parameterized reports using SSRS.

●Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code and T-SQL code from developers and QA.

●Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

●Actively participated in gathering Business Requirements that are focused on providing a user-friendly System usage or ambience

●Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).

●Involved in complete SSIS life cycle in creating SSIS package, building, deploying and executing the package in both the environments (Development and Production).

●Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.

●Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

●Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

●Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.

Environment: MS SQL Server, SQL Integration Services (SSIS), SSRS, Data Transformation Services, Business Intelligence Development Studio (BIDS), T-SQL, SAS, Visual Studio, Windows 2012 Enterprise, MSOffice.

Client: Vine Brook Homes- OH

Duration: June 2018 to September 2019

Role: ETL/SQL Server Developer

Responsibilities:

●Created T- SQL queries for data retrieval.

●Optimized queries tuned and monitored server performance.

●Monitored performance and optimized SQL queries for maximum efficiency.

●Created and modified Stored Procedures as per the business logic.

●Created other database objects like tables and indexes.

●Created views as per design needs for security reasons.

●Successful migration of the data from SQL database by converting and re-writing DTS packages and updating them to SSIS packages.

●Enhanced the logical and physical database design to fit new business requirements, and implemented new design into SQL Server

●Involved designing and developing packages for Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources.

●Created Triggers (Instead of and after) for Auditing Purpose.

●Created tables for Data WareHousing applications and populated the tables from the OLTP database using (SSIS) packages.

●Involved in Creating (SSIS) jobs to automate the reports generation, cube refresh packages.

●Installing, configuring, administering and securing production and non-production servers.

●Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.

●Managed up gradation of DTS packages to SSIS packages.

●Created SSIS packages to extract data from Excel File, Flat Files, and Text Files and Comma Separated Values (CSV) files using various transformations.

●Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server, T-SQL, Windows Server, Erwin, SQL Server Profiler, Microsoft Business Intelligence Development Studio (BIDS), SSIS, SSRS, DTS, OLTP, XML.

Contact this candidate