Power Bi Business Intelligence

Samvida T

Dayton, OH,USA Mail: *******.*@*****.*** Ph: 937-***-**** LinkedIn

Professional Summary: -

Results-driven SQL and BI Developer with over 5 years of experience in database development, data modeling, ETL design, and business intelligence solutions. Expertise in Microsoft SQL Server, SSIS, SSRS, and Power BI for building scalable data pipelines and insightful dashboards. Proficient in T-SQL, DAX, and Python for data analysis, transformation, and reporting across both OLTP and OLAP environments. Strong understanding of data warehousing concepts, including Star and Snowflake schemas, with proven ability to optimize queries and tune performance. Adept at delivering business insights through interactive dashboards and advanced analytics, integrating data from various sources.

Professional Experience: -

Integris Health, OK, USA Jan 2023 – Present

BI Developer

Designed and developed complex T-SQL stored procedures, views, triggers, and table-valued functions to facilitate efficient data extraction, transformation, and loading (ETL) processes across various systems.

Generated and distributed reports in diverse output formats including Excel, PDF, fixed-width, tab-delimited, and pipe-delimited files to meet different business and compliance needs.

Built and maintained SSIS packages to load data from multiple sources such as SQL Server, Excel, flat files, and XML into structured destination tables with necessary transformations applied.

Created dynamic, interactive, and parameterized reports using SSRS, incorporating features like cascading prompts, sub-reports, conditional formatting, and visual elements such as charts.

Designed and published visually compelling Power BI dashboards, enabling stakeholders to gain real-time insights into business performance and operational metrics.

Authored detailed ETL mapping specifications, documenting data source systems, change data capture (CDC) logic, transformation algorithms, lookup logic, and target systems for each DataMart.

Connected SSRS to Analysis Services (SSAS) to generate multidimensional reports and supported OLAP-based data exploration.

Scheduled and monitored SSIS packages and report delivery jobs, ensuring consistent data refresh and automated distribution on a daily, weekly, and monthly basis.

Built advanced Power BI reports by writing complex DAX measures and calculated columns to support detailed data analysis and decision-making capabilities.

Utilized Power Query in Power BI to clean, transform, pivot, and unpivot data, ensuring it was in the correct format for reporting.

Connected Power BI to various data sources including SQL Server databases, Excel files, and live SSAS models while implementing data modeling best practices.

Installed, configured, and managed both Enterprise and Personal Power BI Gateways to maintain live data connectivity and enable scheduled report refresh.

Implemented Row-Level Security (RLS) and other dynamic filtering techniques in Power BI to restrict data access based on user roles.

Created logical and physical data models using ERWIN and generated DDL scripts to build and modify database schemas and objects in development environments.

Collaborated with cross-functional teams to pull claims, provider, and member data from Oracle Applications databases, supporting the development of healthcare-related reports and extracts.

Actively participated in sprint planning, requirement gathering, and project meetings with business analysts and project managers to define solutions aligned with business goals.

Delivered weekly presentations to stakeholders, showcasing report enhancements and incorporating business feedback to continuously improve report relevance and accuracy.

Provided ongoing production support for BI reports and ETL processes, ensuring availability, performance, and timely issue resolution in 24/7 environments.

Designed and implemented Azure storage solutions using blobs, tables, queues, and files to support scalable and secure data storage for reporting and analytics workflows.

Environment: Microsoft SQL Server 2012/2014/2016, T-SQL, SSIS, SSRS, Report Builder 3.0, Power BI, Tableau, Microsoft Excel, C# .NET, ETL Processes, SQL Server Data Tools (Business Intelligence Development Studio).

Accenture, India May 2020 - Jun 2022

SQL Developer

Played a key role in data modeling activities based on client requirements, as well as in the daily maintenance and performance optimization of the database environment.

Designed and developed various types of SSRS reports including tabular, matrix, parameterized, sub-reports, snapshots, and ad-hoc reports to fulfill dynamic reporting needs.

Created physical data models using ERwin and ER/Studio, and generated DDL scripts for schema and object creation in the SQL Server database.

Worked closely with system administrators for the installation, configuration, and maintenance of SQL Server 2012 and 2014 environments across development, test, and production servers.

Developed complex business logic using T-SQL, including stored procedures, user-defined functions, views, and triggers to support application requirements.

Designed and implemented SSIS-based ETL processes to facilitate data movement and transformation from multiple sources into the SQL Server environment.

Managed data migration and transformation activities, including conversions from mainframe systems and Oracle databases into SQL Server.

Created reusable SSIS templates for consistent package development and streamlined deployment across development, testing, and production environments.

Reviewed and validated change requests, made architectural recommendations, and standardized the implementation of data integration and reporting processes.

Configured and deployed SSRS reports to Microsoft Office SharePoint Server to enable collaborative access and secure report management.

Developed web pages using C#.NET and ASP.NET to show the deployed SSRS reports as required by the user.

Created and optimized various database objects including tables, indexes, stored procedures, triggers, views, and roles, and significantly enhanced performance using clustered and non-clustered indexing strategies.

Automated SSIS package execution by scheduling SQL Server Agent jobs for daily data refresh and processing.

Built and maintained advanced SSRS reports including drill-down, dashboard, conditional, and chart-based reports, delivering meaningful business insights.

Created and published dashboards and key performance indicators (KPIs) using both SSRS and Power BI to support executive-level decision-making.

Deployed reports to the SSRS server and configured report subscriptions, including standard and data-driven options, for automated report delivery.

Utilized Power Pivot and Redgate tools for advanced data modeling, management, and performance tuning tasks.

Employed source control tools such as Team Foundation Server (TFS) for version control and team collaboration.

Modified existing stored procedures to accommodate evolving business logic and reporting requirements.

Maintained database security by managing logins, assigning permissions, and resolving access-related issues, including integration with Active Directory for enterprise-wide user authentication.

Environment: Microsoft SQL Server 2012/2014, Microsoft Dynamics CRM 2013/2015, SSRS, SSIS (2012), T-SQL, Redgate Tools, Power Pivot, Visual Studio 2013, Team Foundation Server (TFS) 2013, SharePoint 2013, Microsoft Visio, Agile/SCRUM Methodologies.

Merizon Technologies LLC, India Nov 2019 - Mar2020

SSIS Developer:

Actively participated in gathering and analyzing end-user requirements, serving in dual roles as both a system analyst and application developer to design custom audit functionalities and applications tailored to business needs.

Authored comprehensive user requirement documents and created detailed technical specifications and design documentation to guide development throughout the project lifecycle.

Wrote advanced T-SQL queries including sub-queries, correlated sub-queries, and dynamic SQL to extract, manipulate, and analyze large datasets for reporting and processing needs.

Developed stored procedures, triggers, user-defined functions, and views within SQL Server to support application logic and business processes.

Contributed to data modeling efforts by designing and normalizing/de-normalizing database structures to support data warehousing and reporting solutions.

Improved database performance by analyzing and tuning queries, creating clustered and non-clustered indexes, and using tools like the Index Tuning Wizard.

Designed and implemented SSIS packages using various control flow and data flow components, including transformations like Lookup, Merge Join, Conditional Split, Derived Column, and Slowly Changing Dimension (SCD).

Utilized event handlers to manage pre-execution, post-execution, and error handling within SSIS packages for better operational control.

Environment: Microsoft SQL Server 2005/2008, SQL Query Analyzer, SQL Profiler, Enterprise Manager, ERWIN Data Modeler, SSIS, SSRS, SSAS, Visual Studio 2008, Windows Server 2003/2008, DTS, OLTP, OLAP, ETL Processes, Microsoft Access.

Technical Skills: -

Methodologies: SDLC, Agile (Scrum), Waterfall

Programming Languages: SQL, Python

BI & ETL Tools: SSIS, SSRS, Power BI, Tableau, SQL Server Reporting Tools

Data Modeling & Design: Star Schema, Snowflake Schema, ER Diagrams, Normalization/Denormalization, ERwin, Power Designer

Web Technologies (for report integration): HTML, CSS, JavaScript, JSON, XML

Frameworks & Libraries: Pandas, NumPy, Matplotlib (for EDA), Flask (for lightweight APIs)

Databases: SQL Server, MySQL, Oracle, PostgreSQL, MongoDB, SQLite

Cloud & Deployment Tools: AWS (EC2, S3, RDS), Power BI Service, Databricks, Jenkins (CI/CD)

Development Tools & IDEs: Visual Studio, Visual Studio Code, Jupyter Notebook, PyCharm, SQL Server Management Studio (SSMS)

Version Control: Git, GitHub

Other Skills: DAX, T-SQL, RESTful API Integration, Data Warehousing, Data Cleaning & Transformation, Performance Tuning, Report Automation, Postman, UML, Kafka (for data ingestion), JUnit (for testing data logic), SAP

Operating Systems: Windows, Linux, macOS, Excel.

Education: -

Masters in computer science - University of Dayton, Dayton, OH Aug 2022 – May 2024

Bachelor of Engineering, Computer Science - JNTUH, India Aug 2015 – Mar 2019

Contact this candidate