Sql Server Power Bi

YARED AYNALEM REDA

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

Phone: 202- 855-3754

Professional Summary:

●MS SQL Server Developer with 9+ years of strong experience in various domains like Financial, Retail and insurance with expertise in MS SQL Server 2019/2017/2012/2008R2/2008/2005/2000 and SSIS, SSRS, SSAS.

●Comprehensive knowledge & in all phases of the Software Development Life Cycle (SDLC)

●Proficient in Conceptual, Logical, & Physical Modeling

●Experience in designing, modeling, developing, managing &administrating database systems

●Excellent in enterprise database architecture, security, high availability & performance

●Well versed in designing, constructing and implementing operational data stores and data marts

●Proficient in relational & dimensional database modeling also normalization & demoralization

●Skilled in creating & managing database objects, stored procedures, triggers, views & UDFs

●Fluent in T-SQL programming language, including store procedures & user defined functions.

●Expert in creating materialized views using Sub-Queries, CTEs, & Joins

●Expertise in designing and implementing both Start & Snowflake Schemas

●Hand on experience in utilizing DDLs, DMLs, functions, variables, temp tables & transaction blocks

●Experience in Developing & delivering data integration workflow using Agile delivery methodology

●Well versed in developing Data Transformation workflows using SSIS packages.

●Experienced in designing & implementing data flow processes to integrate data from various heterogeneous data sources like Access, Excel, & flat files

●Well versed in designing dynamic SSIS packages using variables, parameters & expressions

●Proficient in creating dynamic SSIS Packages to refresh slowly changing dimension tables

●Skilled in creating and maintaining a slowly changing data flow process for enterprise data warehouse

●Excellent in developing SSRS reports with functionality such as Drill Down, Drill through, &Parameters Well versed in creating ad hoc reporting Data Model using Power BI

●Expert in building visualizations in Power BI Desktop and Power BI Service

●Hands on experience in deploying Power BI reports to app workspace

●Excellent in managing Power BI workspace users and configuring getaways for data refresh

●Effective in problem solving skills, and ability to analyze existing systems and ascertain users’ needs, and translate into clear proposals and plans

●Ability to work multiple projects with multiple deliverables

●Work with Agile team to develop BI platform dataflow, visualizations & interactive dashboards

●Excellent communication with multifunctional teams, programmers, and technical staff at all levels

PROJECT METHODOLOGY

●Agile methodology with Multiple Sprint Cycles

Customer focused & Rapid delivery

Adaptive to changes in technology & requirements

Highly collaborative with Daily Scrum meetings

Client: Charter Communication, Charlotte, NC September 2022– Present

Role: MSSQL Developer

Responsibilities:

●Develop high-quality database solutions.

●Design, develop, and maintain efficient, reusable, and reliable SQL code. Use T-SQL to develop and implement procedures, functions, triggers and views.

●Analyze existing SQL queries for performance improvements. Identify and resolve performance issues in SQL queries and database processes. Optimize SQL queries and database structures for better performance and scalability.

●Plan and execute data migration tasks, including data cleansing, validation, and transformation from various sources into SQL Server databases.

●Research required data.

●Implement and maintain database backup and recovery strategies. Perform regular backups and ensure data can be restored in case of failures.

●Work closely with software developers, business analysts, and other stakeholders to understand application requirements and ensure seamless integration with databases.

●Build appropriate and useful reporting deliverables.

●Use version control systems to manage database scripts and schema changes, ensuring version history and collaboration among team members.

●Investigate and resolve database-related issues reported by users or automated monitoring systems. Provide timely and effective solutions to problems.

●Investigate exceptions with regard to asset movements.

Tools & Technologies: MS SQL server 2017/2019, SQL Profiler and T-SQL, Windows 2008 server and Visual Studio 2019, Microsoft Office, Source Tree, Bit Bucket, Index Tuning Wizard, Query Analyzer, SQL profiler.

Client: Newport group, Charlotte, NC June 2019– August 2022

Role: SQL/SSIS Developer

Responsibilities:

●Worked closely with SME’s end users/internal customers to understand project/requirement scope and involved in providing solution to implement or support production issues.

●Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to

●Validate the solution met requirements. And prepared documentation for same.

●Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.

●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 2008/2012/2017/2019.

●Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

●Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.

●Involved in enhancing and deploying the SSIS Packages from development server to production server.

●Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Advisor

●Highly skilled with Agile/Scrum/Waterfall working methodologies along with phases of Software Development Lifecycle (SDLC)

●Designed and developed ETL solutions for transformation of data from source transactional systems or other data feeds, into a dimensional database, or other destinations

●Created, Scheduled, Generated and optimized ETL jobs

●Created and maintained technical documentation using defined technical documentation templates.

●Proficient in programming languages such as Python, as well as popular python libraries and frameworks including TensorFlow, PyTorch, Scikit-learn, SciPy, NumPy, Seaborn, Matplotlib and pandas.

●Contributed to the creation of solid coding techniques and recommended and reviewed coding standards. Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data.

● Wrote documentation, data warehouse artifacts and data lineage for ETL tools.

Tools & Technologies: MS SQL server 2017/2019, SSRS, SQL Profiler and T-SQL, Windows 2008 server and Visual Studio 2019, Microsoft Office, SSIS, Index Tuning Wizard, Query Analyzer, SQL profiler.

Client: Rolex, New York, NY

Dec 2016 –May 2019

Role: ETL/DataBase Developer

Responsibilities:

Developed & maintained complex SQL stored procedures and functions

Worked with Type 1 and 3 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts

Developed Complex SSIS Packages to load data into Staging, ODS, & Data Warehouse systems

Developed SSIS packages using Lookup Transformations, Merge Joins, Union all Fuzzy Look Ups, & Derived Columns with Multiple Data Flow tasks

Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On-Task Failed Event Types

Automated SSIS Packages using SQL Server Agent Jobs

Configured various event driven e-mail notification process in SSIS packages

Created audit database to handle SSIS error output and validate data

Designed visual report solutions, including dashboards using SSRS and/or other data visualization/dashboard tools

Deployed SSRS report to Report Server Web Service

Configured report server & report manager for SSRS report deployment and management

Designed reports with single /multi valued, dependent & Cascading Parameters

Created Report Email Subscription using Data Driven & Time Triggered Report Subscriptions

Wrote efficient stored procedures for optimal performance

Optimized SQL queries for improved Reports rendering

Developed, executed, documented, & maintained appropriate BI documents

Worked with end users & developers to determine requirements

Scheduled Jobs and Alerts using SQL Server Agent

Designed full Normalized relational database model for application support

Configured Database Components to support online transactions

Developed Error Handling scripts to adhere Transactional properties (ACID)

Created test scripts to evaluate database and application reliability

Developed and maintained complex SQL stored procedures and functions

Developed a complete SSIS life cycle creating SSIS packages including building, deploying, executing, and scheduling the packages

Created SSIS package that refreshes type one and type three-dimension tables using slowly changing dimensions transformation

Created maintenance plan packages for backup and restore operations

Designed Parameterized Reports for generating Ad-Hoc reports as per client’s requirement

Configured subscriptions, snapshots, cache refresh and reports history on report manager

Involved in Normalization and De-Normalization of existing tables for faster query retrieval

Created groups, roles, users and assigned access privileges

Deployed database objects from development/testing environment to production environment

Developed and published reports using MS SQL Server Reporting Services

Tools & Technology: Windows Server 2000, 2003, 2008, 2008R2, 2014, 2016, 2017; MS SQL Server; Water fall, Triggers; DDL; DML; 1stNF – 3rdNF; Visio; DTS

Client: Wadi El-Sundus Petroleum Co.LTD, Addis Ababa, Ethiopia

May 2014 – Nov 2016

Role: SQL developer/ SSRS, SSIS Developer

Responsibilities:

Understanding the business requirements.

Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS.

Transformed Complex business requirements into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.

Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2012.

Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2012.

Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.

Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.

Experienced in implementation of strong referential integrity and auditing with the use of triggers.

Deployed the SSIS Packages to File System based on the requirements

Develop of complex SQL queries, stored procedures, functions and triggers.

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

Developed Cross-Tabbed and Sub-Reports in 2012.

Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2012.

Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.

Created complex SSIS packages using various transformations.

Prepare documentation for ETL process future references.

Tools & Technologies: Environment: Microsoft SQL Server 20012/2008R2, SQL Server Reporting Services (SSRS), XML, SQL Server Integration Services (SSIS), Windows Server 2008.

Education:

Bachelor Degree of Computer Science from Addis Ababa University in 2007.

IBM CERTIFICATE On Databases and SQL for Data Science

Business Skills / Technical Skills:

MS SQL Server 2019/2017/2012/2008R2/2008, Visual studio 2019/2013/2010/2008 (SSAS/SSIS/SSRS), Microsoft Access 2007/2003, Microsoft Excel (Pivot Table), OLAP and OLTP, Outlook, MS SQL Profiler, SQL Server Azure, SQL server Query Analyzer, Index Tuning Wizard, C#. Net, VB.Net. / Share point, Crystal Reports 10, ADO.NET, Erwin8/3.5, Windows 2007/2005 Advanced Server/Professional, Window XP, MS Access, C#, My SQL

Contact this candidate