Sql Server Power Bi

SB

SUMMARY

Microsoft Certified Business Intelligence Developer with 5+ years of experience

Strong experience in using the Microsoft BI Stack (SQL, SSIS, SSAS, SSRS and Power BI). Worked with SQL Server 2022, SQL Server 2019, and SQL Server 2017/16

Worked with different domains like Insurance, Banking, Telecommunications, Shipping and HealthCare.

Experienced in Microsoft Power BI, Power Query, Power BI server, Power BI Service, Power BI Desktop

Developed rich visualized reports and dashboards using Microsoft Power BI

Experience on Complex SSRS Report Creation and deployment with Stored Procedures, Functions, T-SQL using SQL Server

Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server.

Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads.

SSAS experience in OLAP Cube and tabular creation, facts, dimensions, and perspectives.

Having experience in implementing the security by using RLS, Power BI reports scheduling, subscriptions, PBI Report Builder and Optimizations.

Experience in solving Real Time issues with Index fragmentation, Query Tuning, Error Handling, SQL Performance Optimizations.

Developed SSIS packages that can extract data from Excel/flat files into SQL server using different SSIS components.

Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.

Excellent back-end skills in creating SQL objects such as Tables, Complex Stored Procedures, User-defined Functions, Views, Indexes, Triggers, and SQL Performance Tuning to facilitate efficient data manipulation and consistency.

A well-organized, goal-oriented, highly motivated effective team member with strong analytical, troubleshooting, and problem-solving skills.

Proficiency in the use of T-SQL for developing stored procedures, triggers, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing.

Experienced in configuring SSIS packages using package logging, Breakpoints, Checkpoints, and Event Handling to fix the errors. Expert in troubleshooting SSIS packages using a variety of techniques/tools.

Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

Flexible, enthusiastic, and project-oriented team player with excellent communication and leadership skills to develop creative solutions for challenging client needs.

EDUCATION

Bachelor’s Degree

SKILLS

RDBMS/DBMS: SQL Server 2022, SQL Server 2019, and SQL Server 2017/16 Oracle 11g/10g

Database Tools: SQL Server Entreprise Manager, SQL Server Intégration Services (SSIS), SSAS, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), DTSX, Data Stage PX 8.5/8.1,7.5.3, Team Foundation Server (TFS)

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Power BI, Business Objects, Qlik View, Tableau

Programming Languages: SQL, TSQL, PL/SQL, XML, HTML, Visual Basic, VBScript, C#, .NET

Design Tools: Erwin 7/4, MS Visio

BI Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS)

Analysis Methodologies: Scrum, UML, Agile methodology, Waterfall methodology, SWOT, Cost-Benefit Analysis, Gap Analysis.

EXPERIENCE

SQL/SSIS/SSRS Developers Priority Health

1231 E Beltline Ave NE, Grand Rapids, MI 49525 June 2023 to Current

Utilized SSIS to enhance data quality and improve metadata capabilities.

Designed, developed, and deployed OLAP cubes and SSIS packages for cube processing, utilizing XMLA files for deployment.

Developed MDX queries for cubes in BIDS, deploying them through SSIS packages for cube processing.

Leveraged Power BI and DAX to create reports and KPIs for organizational and departmental needs.

Proficient in Teradata Express Studio for query writing and result comparison with SQL audit tables.

Conducted analysis and designed data models for enterprise systems.

Created and maintained comprehensive documentation detailing data management systems and structures.

Worked with Azure SQL Database Import and Export Service, deploying SQL Databases in Azure cloud.

Managed Servers, Log Shipping, and utilized MySQL Analysis Services for Data Warehousing.

Automated processes using Control M and custom SQL metadata-driven solutions for job automation and error logging.

Implemented Report Email Subscriptions based on data and time-driven triggers.

Collaborated with offshore teams for issue resolution, development processes, and quality support.

Demonstrated strong expertise in SQL for ETL processes.

Proficient in data profiling, cleansing, and quality assurance techniques.

Skilled in scripting languages like Python for automation and data manipulation.

Strong problem-solving and analytical skills with attention to detail.

Utilized tools like SQL Profiler, index tuning wizard, and windows performance monitor for MS SQL Server performance tuning.

Coordinated with offshore teams to ensure timely product delivery and resolve queries.

Transformed existing reports and dashboards into interactive/automated formats using Power BI.

Monitored Power BI system for data quality, job errors, and performance issues.

Environment: SQL Server 2019, Visual Studio, MS Access, MSExcel, SSIS, SSRS

SQL DEVELOPERS Crowe

Chicago, IL Sept 2021 to May 2023

Created complex ETL packages to extract data from staging tables to portioned tables with incremental load.

Created SSIS reusable packages to extract data from multi formatted Flat Files, Excel, XML files into UL Databases and DB2 Billing system.

Developed deployed and monitored SSIS packages.

Wrote complex SQL queries using joins, sub queries, and correlated sub queries to retrieve data from the database.

Created Data Mapping Document (DMD) by analyzing various OLTP data sources.

Developed Reports, Views and Stored Procedures and deployed them on server using SQL Server Reporting Services (SSRS).

Implemented Business Logic utilizing CTEs, Temporary Tables, Table Variables, Dynamic SQL and System /Aggregate /Ranking Functions.

Scheduled reports for daily, weekly, and monthly reports; created reports for executives, business analysts, and customer representatives based on business needs.

Tuned SQL Queries by analyzing Execution plans, Reorganizing/Rebuilding Indexes.

Setting up ODBC connections with Teradata, SAS, and SQL servers on machine to extract data.

Imported and exported data from other data sources such as Excel and Access.

Worked on POWER BI to collect the data and created PBI desktop and reports.

Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database.

Worked closely with the Business Analysts to gain a good understanding of the specifications and timelines.

Strong experience using Micro Strategy Suite (Intelligence Server, Desktop, MDX Adapter/ OLAP Provider, Web, Narrowcast Server, Visual Insight, Report Services).

Extended full support for the team regarding issues, feature discussions, and/or enhancements.

Environment: SQL Server 2017/2016, SQL BI Suite (SSIS, SSRS, SSAS), Enterprise manager, TFS, Agile, Power Bi

SQL Developers Laxmi Sunrise Bank

Hattisar, Kathmandu, Nepal Jan 2020 to Aug 2021

Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.

Written different T-SQL scripts for automated execution of the tasks.

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.

Extensively used SSIS to move data from heterogeneous data sources to SQL Server.

Created jobs, alerts to run SSIS packages periodically.

Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.

Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.

Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)

Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.

Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files.

Scheduled and executed different automated and manual jobs once the package is executed.

Managed the Clustered environment databases and was fixing the errors when they arose.

Rebuilding the indexes at regular intervals for better performance.

Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.

Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.

Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.

Written complex stored procedures and functions and integrated it with the front-end application.

Created multi-dimensional cubes with different dimensions and measures in it using SSAS.

Diagnosing and tuning the server optimal performance using SQL Server SQL Profiler and Database Engine Tuning Wizards.

Prepaid user manual and technical support manual.

Environment: MS SQL Server 2016 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLTP, Tortoise SVN, MS Office, MS Excel.

JR SQL Developers F1 soft International

Lalitpur, Nepal Feb 2019 to Dec 2019

Communicated with clients to understand business needs and devised technical solutions for software products.

Developed complex SQL queries, stored procedures, triggers, views, and indexes using DML and DDL commands to implement business logic.

Created database schema objects such as tables, views, and indexes.

Collaborated with front-end developers to program stored procedures for report development.

Utilized Transact-SQL (TSQL) for triggers, stored procedures, functions, and maintained physical database structures.

Employed Dynamic Management Views and System Views for indexing and performance enhancements.

Collaborated with ETL team to optimize database solutions for improved performance.

Automated control flow, data flow, events, and logging in SSIS packages using Microsoft .NET framework.

Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging areas and then into data warehouses.

Implemented various SSIS tasks for data scrubbing, validation checks, and data loading processes.

Developed and maintained ETL packages, debugging and upgrading structures as needed.

Utilized SSIS tasks like Execute SQL Task, Bulk Insert Task, Data Flow Task, etc., for various data operations.

Worked in a team to create cubes in SSAS and developed MDX queries for efficient historical data retrieval.

Created reports using SSRS, designing layouts, and defining datasets for report generation.

Designed financial report templates, graphs, and charts based on financial data, scheduling reports for automatic generation.

Developed different types of reports including financial, cross-tab, conditional, drill-down, and parameterized reports.

Collaborated with DBAs, QA, and support teams to deploy and automate code to production.

Used TFS for version control and created necessary documentation for operational support.

Environment: MS SQL Server, SSRS, VSS visual source safe, .NET Framework, ASP, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN, Windows Server.

Sunil Bhattarai

704-***-**** - ******************@*****.*** - Concord, NC 28027

Contact this candidate