Post Job Free

Resume

Sign in

Sql Server Business Intelligence

Location:
United States
Posted:
January 29, 2024

Contact this candidate

Resume:

Name Betelhem Tsegaye

Email ad2634@r.postjobfree.com

Phone 678-***-****

Professional Summary

● Over 8 years of experience in diverse business and technical environments with main areas of focus in design, development, implementation and support of relational databases, data analysis, business intelligence solutions and enterprise data warehouses development, ETL, and data visualization using RDBMS databases and various reporting and visualization tools.

● Expert knowledge in building and managing relational databases and tables normalization/denormalization using SQL Server Management Studio (SSMS)

● Strongly experienced on SQL Server 2022/2019/2017/2016/2014/2012 as a Developer, experience includes Database Design and Development, Confidential BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SSAS, SSIS, SSRS and T_SQL.

● Proficient in all Software Development Life Cycle (SDLC) phases of specifically Waterfall and Agile Scrum methodology.

● 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.

● Goal-Oriented usage of features such as Dynamic SQLs, Cursors, Stored Procedures, Views, Indexes, User Profiles, User Defined Functions (UDFs), Triggers, Temp Table, Relational Database Models and Data Integrity in observing Business Rules.

● Strong experience in T-SQL programming proven, scalable code using stored procedures, various types of joins, sub-queries, analytical functions, aggregate function, group by, over partition by, cursors, merge, try/catch, dynamically generated scripts, common table expressions, scalar/table valued functions, create/alter tables/columns, views, primary/foreign key constraints, and indexes.

● Implemented dynamic SQL constructs to avoid code redundancy and filter data as per given input parameters to the reporting model stored procedures.

● Hands-on experience in administrative tasks like installing, configuring, upgrading, log shipping, troubleshooting, scheduling, partitioning, backup & recovery, and transaction logs.

● Hands on experience in installation, configuration, performance tuning, optimization, backup, and recovery in SQL server.

● Experienced in troubleshooting SQL issues by using SQL Tools Execution plan, Trace and 3rd party tools.

● Have experience in Performance Tuning using Execution Plan, SQL Profiler, and Database Engine Tuning Advisor, T-SQL Query Optimization and Solving Blocking issues.

● Highly experienced in Dimensional modeling (using Star and Snowflake schemas), Designing different types of Fact tables and building relationships between Fact and Dimension tables.

● Identified business keys and utilized them to link Source tables data to respective Dimension and Fact tables, also defined Surrogate keys to relate Dimension members to Fact records.

● Implemented Slowly changing dimensions up to Type 3 and developed Late Arriving dimension and fact scenarios during data load from Staging to Data Warehouse.

● Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

● Well experienced in designing ETL data flows by creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SSIS.

● Implemented Full load and Incremental load using merge statements and strong skills in using SSIS Control Flow ( Execute SQL task, Foreach Loop Containers, Script Task, File Task, Expression Task, etc.) and SSIS Data Flow (Derived Column, Count, Multicast, Conditional Split, Lookup, Data Conversion, etc.)

● Profound understanding of Enterprise Data Warehouses and Data Marts including OLTP/OLAP, Dimension/Fact Tables, Top-down/Bottom-up models, Star/Snowflake Schemas using Landing and Staging stages

Name Betelhem Tsegaye

Email ad2634@r.postjobfree.com

Phone 678-***-****

● Skillful in Creating, Managing, and Delivering Reports using SSRS and integrating with share points.

● Experienced in generating on-demand (ad-hoc) reports for business analysis or management decisions using SQL Server Reporting Services and Report Builder.

● Profoundly experience in feature design and flexible usage of tabular charts, donut charts, histograms, and maps to express business solutions comprehensively using visualization tools including Tableau, Power BI, MS SQL Server Reporting Services (SSRS) and Excel

● Utilized Power BI (Power View) to create various analytical dashboards that depict critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-users to make filters.

● Implemented several DAX functions for various fact calculations for efficient data visualization in PowerBI.

● A multitasking analytical thinker with the capacity to function both alone and as a team member in a fast-paced setting.

● Effective problem solver with thorough analytics added to credible and concise presentations TECHNICAL SKILLS

RDBMS SQL Server, Azure SQL database, Oracle

Languages\Tools T-SQL, C#, PowerShell, XML

Modeling Tools MS Visio, Star Schema/Snowflake Schema modeling, Fact & Dimension tables, SQL Server Data Modeler

ETL Tools SSIS, DTS, SSDT, Data Quality Services, Azure Data Factory Reporting Tool Power BI, SSRS, Excel 2016/2013/2007, Report Builder 3.0 Analysis Tools SQL Server Analysis Services (Tabular and Multidimensional) Operating Systems Microsoft Windows, UNIX, LINUX

Other Skills/tools Microsoft Word, BIDS, Red Gate, Jams, Powerpoint, Agile Methodology, GitHub, Jira, MS Excel

Version Control

Tools

VSS

EDUCATION:

Bachelor’s Degree

PROFESSIONAL EXPERIENCE

Bank of America

03/2021 to present

SQL/ETL Developer

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 developing Cubes and reports for analysis.

Name Betelhem Tsegaye

Email ad2634@r.postjobfree.com

Phone 678-***-****

● 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 automating regular SQL processes, tracking issues, and documenting changes.

● Developed and automated SSIS packages to perform Extraction, Transformation, and Loading (ETL) of data from various sources like Flat files, MS Excel, CSV, and 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 and 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

ETL Developer / SQL Developer

04/ 2017 to 02/2021

Costco

Responsibilities:

● Gathered, analyzed, classified, and documented project requirements from BI analysts and directors and completed a data mapping process, related to claim history, property value, three financial sheets, etc.

● Used T-SQL to create database objects based on business specifications such as stored procedures, user-defined functions, and views in SSMS.

● Involved in building Data Warehouse based on Star Schema and Data Marts

● Developed ETL packages in SSIS to import data on a weekly basis from the OLTP system to the landing zone in the staging area and migrate it to Data Warehouse and data marts.

● Performed incremental loading tasks to migrate the data from heterogeneous sources to Data Warehouses and Data Marts as well as implementing the slowly changing dimension to protect or discard historical data based on requirements.

● Cleaned and validated the data in the staging area, corrected and unified the format, handled the missing values, transformed the data, and split or combined columns based on specifications.

● Created multiple control flows based on specifications including data flow tasks for data migration or conversion, Script Tasks for dealing with variables, Foreach Loop Containers for realizing loop functions, and File tasks for creating weekly records.

Name Betelhem Tsegaye

Email ad2634@r.postjobfree.com

Phone 678-***-****

● Applied different types of transformations like Data Conversion, Lookup, Conditional Split, Derived Columns, and Merge in SSIS

● Debugged the packages and identified error information and stored it by using breakpoints, analyzing processes, and error output in SSIS as well as sending an error email message while a task fails.

● Worked with the test team to operate unit testing on completed packages and Production Control Team to schedule the operation of the entire package.

● Used pages, cascading parameters, expressions, and other features to create drill-down reports, drill-through reports, and nested reports as operational reports in SSRS.

● Interacted with the Data Science team and developed risk management reports using Tableau for advanced visualizations.

Environment: SQL Server 2010/2012, Oracle 10g, SQL Server Management Studio (SSMS), MS BI Suite

(SSIS/SSRS), Business Intelligence Development Studio, Visual Studio 2008/2010, Tableau 8/9, MS Office Suite 2013 (Excel/Access/Word/PowerPoint), TFS

SQL (SSIS/SSRS/SSAS) Developer

01/2015 to 01/2017

Addis Hiwot Hospital

Responsibilities:

● Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data, Normalized tables.

● Created Tables, Views, and Triggers, Stored Procedures, Functions and other T-SQL scripts.

● Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.

● Worked on Filtered Views, views and Base table integration between different source systems.

● Worked with different methods of logging in SSIS and created packages in SSIS with error handling.

● Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for on-going ETL Processes.

● Modified existing ETL packages to support additional/new features based on the customer requirements.

● Provide technical support, troubleshoot and monitor packages released for staging.

● Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-valued Parameters, Debugging Parameter Issues Matrix Reports and Charts.

● Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.

● Working with the QA team on the Defects assigned and Test Case review.

● Repaired/recreated PPS reports damaged in the conversion process.

● Worked in Agile based environment involved to work closely with web, Mid-tier, BSA and QA to understand business requirements.

Name Betelhem Tsegaye

Email ad2634@r.postjobfree.com

Phone 678-***-****

● Responsibilities involve Requirement analysis, Design and prototyping, developing unit tests, bug fixes, maintenance and production support.

● Responsible for adhering to our Programming, documentation and process standards

● Created and Managed OLAP Cubes using SSAS.

● Reviewed Cube with End user and changing the cube and documentation according to their requirements.

● Provide fields mapping document, refreshed table/packages data load to UAT after delivery up on the completed data mart.

● Implemented Stored Procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects.

● Worked on the enhancement of SSAS, Processing multi-dimensional cube (In MOLAP storage mode), querying multidimensional cube using knowledge of MDX.

● Developed and maintained daily\weekly status report and sent to Senior Executives.

● Implemented the calculations to aggregate physical measures.

● Defined relationships between Measure groups and Dimensions.

● Good experience in On-site/Offshore development model. Environment: MS SQL Server 2014/2012, SQL Server Reporting Services 2014/2012, SSIS, SSAS, Unix, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL. EDUCATION/CERTIFICATIONS



Contact this candidate