Sql Server Power Bi

Zemen Mekonnen

Email: ***********@*****.***

Phone: 424-***-****

EXPERIENCE SUMMARY

8+ years of progressive work experience in analysis, design, development, and management of databases for applications backend databases using SQL Server 2012, 2014,2016, 2017 & 2019.

Extensive knowledge and experience with ER Diagram and design of logical and physical data modeling using Erwin, Visio, Toad and draw.io.

Experienced in creating and using Stored Procedure, Views, Triggers, schemas, Complex queries, Common Table Expressions, Cursors, Functions, User-Defined Types and Dynamic SQL.

Expert on installing and configuring MS SQL Server 2012\2016\2017\2019.

Hands on experience in configuring Power BI Desktop and Power BI Services.

Expert on Configuring MS SQL Integration Service Catalogs.

In depth experience in using SQL Server Data Tool (SSDT) and business intelligence development studio (BIDs).

Sound knowledge of Data marts, Data warehousing, Operational Data Store (ODS), Dimensional Data Modeling, Star and Snow-Flake schema Modeling, Fact and Dimensions Tables using MS Analysis Services.

Hands on experience in configuring Data Flow source and destination connection strings.

Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables, XML configuration and check points.

Hands on Experience on SSIS package development, deployment, and scheduling.

Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using Power BI.

Used power BI to create different visualizations from different data sources.

Experienced Creating and Managing Indexes.

Experienced working on Agile Projects with Multiple Sprints cycles.

Experienced using Agile Project management tools like JIRA.

Have hands full of experience in C# and Visual Basic (VB).

Experienced in translating reporting and analytical needs into technical solutions.

Experienced in Data Masking Techniques

Have Hand full experience in data migration from one Environment to another environment by using dynamic ETL Package technique.

Have Knowledge in Azure Data Services, Azure Data Factory, Azure Data Lakes and Azure Analysis Services.

Strong interpersonal & communication skills, competitive analytical, logical, and problem-solving skills, Strong management, administrative and leadership skills to work in team.

Highly motivated, dedicated, well organized, goal oriented and flexible to learn advancements in the IT industry.

TECHNICAL SKILLS AND TECHNOLOGIES

Database and BI Tools: SQL Servers 2012/2014/2016/2017/2019 and associated tools such as SQL server Configuration manager, SQL Server Reporting Services Configuration Manager, SQL Server Tuning Advisor, MySQL, Oracle, Power BI.

BI Design Tools SQL Server BI Stack (Power BI, SSIS, SSAS), MS Excel Report builder 3.0, Visual Studio 2010 to 2017, Windows Server 2012/2014/2017, MS-Access.

Programming Languages and Environment: C#, Python

Desktop Tools: Microsoft office 365/2013/2010/2007 (Word, Excel, Power Pivot, Outlook, and PowerPoint) to communicate solutions among team and to clients of BI solutions.

PROFESSIONAL EXPERIENCE

SQL/ETL Developer Aug 2021 – Present

Comcast, CO

Responsibilities:

Worked on different databases, writing complex queries to Trace results on Object use to identify what is being used, who is using it, and how it is being used. And used the traced results as an input to determine on what must be decommissioned or not.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Created SSIS packages for File Transfer from one location to the other using FTP task.

Used Stored Procedures, joins, functions, views and so on to manipulate data and get the desired result set which leads to identifying the referencing and referenced database objects.

Worked on the integration of TFS with Visual Studio to access, update and share SQL codes and ETL packages for collaboration within the team by using push, pull, merge, commit, and sync techniques.

Worked on Data Migration from one server (decommissioned) to the other server (new) by using ETL packages (Parameterizing the packages dynamically). Updated ETL packages and then deployed the ETL packages for the check-in in the TFS.

Wrote complex queries like stored Procedures and Create DataMart Tables for reporting purpose by using Teradata for Big Data Analytics.

Used Teradata Database for writing different queries for validation purpose to make sure the counts are matching.

Took business requirements in the BI context and designed data models to convert raw data to meaningful insights.

Created dashboards and visual interactive reports using Power BI.

Identified KPIs with clear objectives and monitored them consistently.

Analyzed data and presented it through reports that can help in decision-making.

SQL/ETL Developer Aug 2020 – July 2021

Wells Fargo Bank, Short Hills, NJ

Responsibilities:

Worked on the integration of GitHub with Visual Studio to access, update and share SQL codes and ETL packages for collaboration within the team by using push, pull, merge, commit, and sync techniques.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.

Worked on Data Migration from one server environment to the other server environment by using ETL packages (Parameterizing the packages dynamically).

Used SQL dynamic query to check the records in one table and update the other table based on the first one.

Worked with Elastic Database Platform to update the newly added attributes from the excel format to different applications dynamically (end to end pipeline update).

Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins, and creating indexes wherever necessary.

Created different database Design Documents for different platforms.

Used Data Masking techniques to cover the sensitive data from being exposed to data security issues. Masked data by using data masking software of the lower environments (SIT, UAT)

Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins, and creating indexes wherever necessary.

Write complex queries to support different applications within the platform.

Converted business requirements into technical specifications and decided the timeline to accomplish tasks.

Developed operational reports.

Built automated reports and dashboards with the help of Power BI.

Used filters and graphs for a better understanding of the data.

Designed, developed, and deployed Power BI scripts and performed efficient detailed analysis.

Wrote DAX queries and functions in Power BI.

Created charts and document data with algorithms, parameters, models, and relations explanations.

SQL/ETL Developer Jan 2018 – July 2020

PNC Financial Services, Pittsburgh, PA

Responsibilities:

Worked closely with SME’s end users/internal customers to understand project/requirement scope.

Strong experience working in an Agile development environment.

Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes.

Involved in the logical and physical data models of databases and prepared test cases for existing solutions and new solutions to validate the solution met requirements. And prepared documentation for the same.

Experience in implementing Normalization rules in database development and maintaining Referential Integrity by using Primary Keys and Foreign Keys.

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 2012/2014/2016.

Expert in Query Optimization and tuning the query, creating Indexes to improve the query performance, used SQL Profiler, and Query Analyzer to debug, troubleshoot, monitor, and measure SQL statements and stored procedures.

Extracted data from heterogeneous sources and transformed, processed the data using SSIS.

Involved in Designing the Data Warehouse and creating Fact and Dimension tables with Star Schema and Snowflake Schema.

Scheduled SSIS packages for running monthly/weekly/daily feeds from and to various vendors using SQL server Agent.

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 and various transformations.

Integrated SSIS packages with the windows batch to trigger the SSIS package.

Develop several detailed and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using Power BI.

Worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS sources.

Use Bulk Insert to load large data into staging table.

Develop various types of reports like Drill down, Drill through, tabular, matrix and parameterized reports using Power BI.

SQL/MSBI Developer March 2016 – Dec 2017

Johns Hopkins Hospital, Baltimore, MD

Responsibilities:

Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.

Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins, and creating indexes wherever necessary.

Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like SSIS, BULK INSERT etc.

Developed, monitored, and deployed SSIS packages for ETL flow to validate, extract, transform and load data into database.

Managed and monitored the system utilization by using the query optimizer and checking the execution plan.

Documented and delivered Functional Specification Document to the project team by using SQL Server.

Used TFS/GitHub for source code management of developed codes/version control.

Migrated SSIS 2008, 2012,2014 version to SSIS 2017 and used custom created DLL for transfer of files using SFTP connection.

Created Alerts/log entries for successfully completed and failed jobs.

Collaborated with network operators, application developers, engineers, and DBAs to address production issues and enhance end user experience.

.

EDUCATION and CERTIFICATIONS

Bachelor’s Degree

MCSA SQL Server 2012/2014

Microsoft Azure Data Fundamentals

TRAINING

Querying Microsoft SQL Server 2012/2014

Administering Microsoft SQL Server 2012/2014

Advanced Training in SQL Development, MSBI, Data Visualization

Microsoft Azure Data Fundamentals

Contact this candidate