Sql Server Business Intelligence

Name Tsi Gegzabher

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

Phone 702-***-****

Professional Summary

Over 7+ years of experience working as a SQL Server BI Consultant with good knowledge in various areas such as MS SQL BI, ETL SSIS, SSRS and SSAS

Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server with expertise on data normalization.

Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing, and post implementation support.

Experience in analyzing and troubleshooting issues with SSIS, SSAS, SSRS, Power BI and SQL server and providing resolutions.

Experience with full project life cycle, including gathering requirements, system design, implementation, testing, deployment and support of applications.

Created SSIS packages and orchestrated ADF pipelines to schedule and automate incremental and complex data loads.

Experience in BI Solutions using SQL Server, T-SQL, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and Programming using DDL, DML, DCL commands.

Experience in creating multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports and navigation reports.

Experience in reviewing the code as SME, approving the change and releasing it into PROD environment.

Experience in SSIS ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, etc.) and then loaded the data into destination tables by performing different kinds of transformations, deployment, Job scheduling.

Experienced in creating Technical and Functional requirement documentation and discussions with Business Users and Project owners in gathering requirements.

Experienced in handling the teams and delivering the projects on time to the business.

Experienced in creating configuration files to deploy SSIS packages across all environments.

Experienced in Business Process Analysis, Improvement, Optimization and Application Integration

Experienced in merging data from various Heterogeneous data sources, populating dimensions and fax tables in data warehouse, cleaning and standardizing data loaded into OLTP and OLAP databases using SSIS.

Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools etc.

Experience in providing experience system menus and defined variables, logging, error handling by using event handlers, and performance monitoring in SSIS packages by using Row transformation, block and unblock transformations.

Experienced in executing activities related to end-to-end project management, including project plans and estimates, scoping, and requirements through implementation, Requirement Gathering, Requirement analysis, Application environment Setup, Preparing Test Scripts, Project Status reporting, bug fixing and deployment.

Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

Worked on different project delivery framework like Waterfall model and agile framework model.

Very good track record of communication, analytical, interpersonal, presentation skills and Team skills combined with self-motivation, initiative, and the ability to think outside the box and worked as lead to carry out deliverables.

Technical Skills

DBMS/RDBMS: MS-SQL Server (2017/2016/2014/2012/2008

ETL Tools: SQL Server Data Tools (SSDT), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and T-SQL

Reporting Tools: SQL Server Reporting Services (SSRS)

Programming Languages: T-SQL, PL/SQL

Tools: Microsoft SQL Server Management Studio, Visual Studio.

Operating Systems: Windows Server 201/2008/2012R2.

Office Tools: MS word, MS Excel, PowerPoint, Outlook and Visio.

Professional Experience:

Sandy Springs Bank

June 2022 - Present

ETL/SQL/BI Developer

Responsibilities:

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

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

Worked in T-SQL to create Tables, Function and stored procedures, view, sub-query, correlated-sub query and ad-hock TSQL Statements.

Designed and developed Data models using Erwin and responsible for Forward and Reverse Engineering of data models.

Modified the existing SSIS packages to meet the changes as specified by the users.

Defined report layouts including report parameters and wrote queries for drill down report using SSRS.

Developed conceptual, logical, and physical data models for creating schema using MS Visio. Created star/snowflake schema for Data Marts.

Designed and created and managed primary objects such as tables, triggers, indexes based on logic design model. Developed all the required stored procedures and user defined functions.

Formulated and documented the ETL (SSIS) process design based on business requirements and system specifications with strong ETL(SSIS) design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.

Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLEDB Source, Excel Spreadsheet to SQL Server.

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

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

Analyze different business requirements and provide time estimate for Analysis, Design, Coding, and Implementation Developed all the required stored procedures, user defined functions, triggers using T-SQL.

Environment: SQL Server, SSMS, SSIS, SSRS, SSDT, SSAS, Visual Studio, TFS, Oracle, T-SQL, PL/SQL, SQL Server Agent, JIRA, MS Access, Windows Server.

AutoZone

December 2018 – May 2022

SQL Server/SSIS Developer

Responsibilities:

Involved in designing, developing and deploying reports in MS SQL Server environment using SSIS and SSRS

Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.

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

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Designed SSIS Packages to transfer data from flat files to SQL Server using SSDT

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

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

Extensively designed the packages and data mapping using Control flow task, Sequence container task, Data-flow 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.

Established ETL design practices for optimization and performance of packages and Parameterized SSIS.

Environment: SQL Server 2022/2019/2016/2014, SQL Integration Services(SSIS),SSDT

Visual Studio 2022/2019/2017/2016/2014, JIRA, Confluence, MS Teams, ServiceNow

Junior Database Developer

Zions Bank

February 2017 – November 2018

Responsibilities:

Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL workflows to populate fact and dimension tables, and developed Cubes and reports for analysis.

Developed complex SQL queries and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.

Troubleshooting and correcting production ETL issues.

Optimizing stored procedures, T-SQL, views, and functions for the best performance.

Refining and automates regular SQL processes, track issues, and document changes.

Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server.

Developed complex database objects like complex stored procedures and complex UDFs.

Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models.

Developed script for data manipulation and ensuring data integrity.

Designed, developed and maintained a data warehouse.

Creating Tabular reports with SQL Server Reporting Services (SSRS).

Generating parameterized reports, drill down drill through reports

Deployed reports created report schedules and subscriptions. Managing and securing reports using SSRS.

Environment: SQL Server 2012, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Excel VBA/ Macros, MS Office Suite 2010 (Excel, PowerPoint, Word), Tableau 10, JIRA, WebEx, Agile/Scrum

Academic Background

Bachelor’s Degree in Computer Science

Contact this candidate