Power Bi Sql Server

Active Secret Clearance

Professional Summary:

I'm a Business Intelligence professional with over 4 years of experience in IT, specializing in Power BI, MSBI (SSIS, SSRS, SSAS), Tableau, and Snowflake. I love turning raw data into meaningful insights through interactive dashboards, visualizations, and reports that help businesses make smarter decisions.

My expertise includes data analysis, ETL processes, data migration, and integration, working with tools like SQL Server, Azure Data Factory, and SSIS. I'm also well-versed in DAX, Power Query, and SQL, ensuring data is optimized and easy to interpret.

I've worked in Agile and Waterfall environments, collaborating with teams, participating in PI planning, sprint planning, and backlog grooming, and always looking for ways to improve processes. Whether it's designing KPI scorecards, optimizing queries, or building reports that make data come alive, I thrive on helping businesses unlock the full potential of their data.

Tools and Technologies

Database: MS SQL Server, MS Access, Oracle, DB2, PostgreSQL, SQL Server Management, Snowflake

Programming Languages: T-SQL, DAX, PL/SQL, Snow SQL, C#.Net, Python

ETL Tools: SQL Server Integration Services (SSIS), IBM DataStage, Informatica Cloud

Reporting Tools: Power BI, Tableau, SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder

Operating Systems: Windows 7/10, Windows 2016, 2017,2019, Windows Server 2012/2014/2016, Windows XP

PROFESSIONAL EXPERIENCE:

Role: SQL Snowflake Power BI developer Feb 2023- Present

Client: Queens LLC, Washington DC

●Experienced in Analyzing and understanding the business requirements, definition and design of the data sourcing and data flows Involved in creating functional and technical specification documents after gathering requirements from business.

●Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.

●Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.

●Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.

●Worked on Snow SQL and Created Snow pipe for continuous data load.

●Develop stored procedures/views in Snowflake and use in Talend for loading Dimensions and Facts.

●Worked with DAX/MDX queries in building expressions for various business calculations.

●Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.

●Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.

●By using Power BI desktop connected to various data sources, working with different visualizations.

●Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.

●Design, develop, and deploy custom applications using Power Apps, Power Automate, and Power Virtual Agents.

●Provide support and maintenance for Power Platform solutions.

●Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

●Created several user roles and groups to the end - user and provided row level security to them.

●Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.

●Worked with table and matrix visuals, worked with different levels of filters like report level, visual level, and page level filters.

●Used various data visualizations including imported or custom visuals.

●Configured incremental refresh and deployment pipelines in Power BI.

●Designed, developed, and deployed different reports like Matrix and Tabular reports with Top N, Cascaded, Parameterized, and pie chart reports using SSRS with Report Builder.

●Used parameters to configure URL report filters and capture last data refresh date and time in Power BI.

Environment: MS SQL Server 2019/2017/2016/2014, Microsoft Visual Studio 2017,2019, MS Access, MS Excel, MS Visio, SQL Server Profiler, Windows Server 2014/2016

Role: SQL/Power BI developer/Analyst Aug 2021- Feb 2023

Client: Kaiser Permanente, Silver Spring, MD

●Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the reporting needs.

●Discussed with stakeholder teams to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.

●Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types in codes developed)

●Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2017/2019.

●Wrote complex SQL queries to read data from source databases to analyses source system after joining multiple tables.

●Worked with data modelers to understand data models from different source system, also involved in creating dashboards by extracting data from different sources Prepared STTM (source to target mapping) for ETL and Report development.

●Created data visualizations, applied various actions (URL, Filter, Parameters) in Power BI desktop Develop, Organize, manage, and maintain graphs, tables, and document templates for the reports.

●Used SQL, PowerPoint, Info View, and Excel daily to generate various performance reports for analysis.

●Developed different types of visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Visual hierarchies and drill-down in the tableau reports.

●Used different functions like number, string, date, Type conversions and Aggregate functions.

●Developed custom SQL queries to minimize the data to improve the performance in power BI.

●Utilized advanced features of Tableau software like linking data from different data sources together on one dashboard to filter data in multiple views.

●Developed Power BI dashboards and published them on to Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

●Scheduled data refresh on for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.

●Used Excel sheet for multiple purposes such as data analysis, data comparison, reporting, data mapping etc.

Environment: Power BI 2.7, MS Office Suite, Oracle 12c, MySQL 7.1, SQL Server 2017/2019, PowerPoint

Role: Database/BI Developer March 2020 - Aug 2021

Client: Prisha LLC Virginia

Developed and maintained Power BI dashboards and reports to monitor business performance, focusing on key metrics such as sales trends, customer behavior, and operational efficiency.

Transformed raw data from multiple sources (e.g., sales, inventory, customer data) into meaningful insights by creating data models and visualizations in Power BI.

Conducted data analysis on sales performance, identifying trends, seasonal patterns, and customer preferences to drive decision-making and strategy.

Performed regular data cleaning, transformation, and validation using Power Query and SQL to ensure high-quality, reliable datasets.

Collaborated with cross-functional teams to define key performance indicators (KPIs) and provided actionable insights to improve operational efficiency, customer experience, and financial performance.

Provided data-driven recommendations to optimize inventory management, reduce waste, and improve cost-efficiency across business operations.

Created and automated monthly and weekly reports to track business trends and operational performance, ensuring timely distribution to senior management.

Designed and delivered interactive dashboards and reports that allowed stakeholders to explore data and derive insights independently, increasing organizational data literacy.

Developed sales forecasting models and helped refine pricing strategies by analyzing historical trends and customer demand.

Developed and optimized complex SQL queries, stored procedures, and triggers to improve database efficiency and performance.

Conducted data migration and integration between PostgreSQL and Oracle databases, ensuring data consistency.

Implemented performance tuning techniques such as indexing, query optimization, and partitioning to enhance database operations.

Designed and optimized PL/pgSQL and PL/SQL stored procedures to streamline data processing and improve application performance.

Refactored and debugged existing stored procedures, reducing execution time and enhancing maintainability.

Utilized execution plans, indexing, and caching techniques to improve SQL query performance.

Managed and deployed cloud-based databases on Azure SQL, AWS RDS, and Oracle Cloud, ensuring high availability and security.

Automated database provisioning and maintenance using Terraform, Ansible, and Azure DevOps pipelines.

Optimized cloud database costs and performance by implementing scalability strategies and monitoring resource utilization.

Key Achievements:

Implemented a Power BI dashboard that provided real-time tracking of sales, inventory, and customer satisfaction, which led to a 50% improvement in decision-making speed.

Identified inefficiencies in the supply chain through data analysis, leading to a reduction in stockouts and a 10% - 25% improvement in inventory turnover.

Played a key role in a data-driven pricing strategy, which increased average order value (AOV) by 25% by tailoring offers and pricing to customer behavior trends.

Streamlined reporting processes by automating key reports, reducing report generation by 40 hours per week and enabling quicker access to insights for leadership.

Certifications and Education

High School Diploma

Professional Scrum Master (PSM)

CompTIA Security+

Contact this candidate