SQL Server BI Developer

Ecolab

1. Responsibilities:
2.  Actively participated in gathering business requirements to implement functional and technical specifications.
3.  Migrating databases\instances from SQL Server 2017 to SQL Server 2019 version.
4.  Installed, managed and administrated SQL Server 2019/2017/2016/2014/2012 Databases.
5.  Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bulk
6. Insert task, Script task in SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Data Flow.
7.  Designing, developing, and testing the ETL (Extract, Transformation, and Load) strategy to populate the data from various
8. source systems feeds using SSIS.
9.  Worked with both the version in Azure Data Factory such as V1 & V2.
10.  Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run
11. all other packages.
12.  Wrote a python-based SQL generator that helped speed up a weekly reporting from several days.
13.  Developing interactive reports and dashboards using tools like Power BI, Tableau, or QlikView to enable data
14. visualization and insights.
15.  Created packages using the various control flow tasks such as data flow task, execute SQL task.
16.  Proficient in designing and maintaining relational databases using platforms like Microsoft SQL Server, Oracle, or
17. MySQL.
18.  Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc queries.
19.  Generated monthly reports and budget analysis to drive forecast production plans with SQL Server Reporting Services
20. (SSRS).
21.  Integrated data from varied sources using SSIS – SQL Server, Azure Data Lake, Spreadsheets and Flat Files
22.  Created parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart,
23. and matrix report).
24.  Experience in publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards,
25. collaborate using workspaces, apps, and to get quick insights about datasets
26.  Working with various business groups while developing their applications, assisting in Database Design, Creating E-R
27. Diagrams using Visio, and designing Local and Physical Data Models with Erwin r4.
28.  Used various transformation tasks to create ETL packages for data conversion.
29.  Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions, measures, MDX
30. queries.
31.  Based on business requirements, developed complex SQL queries with Joins and T-SQL, Stored Procedure, Views,
32. Triggers to implement the business rules and transformations.
33.  Created ETL packages with different data sources (SQL Server, Oracle, Teradata, Access, Flat Files, Excel source files,
34. XML file) and then loaded the data into destination tables by performing different kinds of transform
35.  Involved in extracting the data using SSIS from OLTP and OLAP.
36.  Extracted data from various sources like DB2, Oracle, Flat Files, and XML Files and loaded them into Fact and Dimension
37. tables of the Datawarehouse.
38. Environment: MS SQL Server 2019/2017/2016/2014/2012, Microsoft Visual Studio, SQL Server Business Intelligence
39. Development Studio (SSAS, SSIS, SSRS), Microsoft Office SharePoint Server, XML, Oracle, ASP.Net, and C#.

Sher-e-Agricultural University

Computer Science