Sql Server Business Intelligence

Alemnesh Dadi

ad5j0k@r.postjobfree.com

Bethesda, MD

PROFESSIONAL SUMMARY:

* ***** ** ** ********** specializing in Database Design, Development, Implementation, and Administration in SQL Server 2014/2016/2019.

Proficient in providing ETL/Business Intelligence solutions using Microsoft components.

Skilled in highly complex T-SQL queries and SQL Scripts for efficient data loading based on complex business rules.

Experience in Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expertise in Objects creation such as Tables and Views, Table Normalization, User-created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes, and appropriate Triggers for efficient data manipulation.

Strong understanding of RDBMS concepts and Data Modeling Concepts.

Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data management, data dictionaries, and data integrity.

Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).

Experienced in report generation using SQL Server Reporting Services (SSRS) and Excel spreadsheet lately using SQL Server 2012/2014/2016/2019.

Experience in implementing different types of Replication models like Snapshot, Merge, and Transactional.

Excellent communication and interpersonal skills, self-motivated, quick learner, strong troubleshooting skill, and good Team player with excellent interpersonal and teamwork skills.

TECHNICAL SKILLS:

Microsoft Packages: MS-PowerPoint, MS-Excel, MS-Word

ETL and OLAP Tool: SQL Server Integration Services, SQL Server Analysis Services

Reporting Tools: SQL Server Reporting Services (SSRS)

RDBMS: SQL Server 2012/2014/2016/2019

EDUCATION QUALIFICATION:

Bachelor of Science, 2006

Adama University, Ethiopia

WORK EXPERIENCE:

Infojini

Rockville, MD

BI/SSIS/SQL Developer

Jul/2021 – Present

Leveraging SSIS to design, develop, and deploy packages for extracting, transforming, and loading data from diverse sources such as SQL Server 2008, MS Excel, and MS Access into Dimension and Fact tables within the Data Warehouse environment.

Utilizing various SSIS data flow transformations for data scrubbing and validation checks during staging before loading data into the Data Warehouse.

Developing SSIS packages with for each loop functionality in Control Flow to process Excel files within specified folders, utilizing File System Tasks for file archival, and Execute SQL tasks for inserting transaction log data into SQL tables.

Implementing SSIS Event Handlers for Exception Handling to ensure the robustness and reliability of data processing.

Receiving and processing customer data from multiple sources, with a specific emphasis on IRS Form 1095-A for reconciliation purposes.

Conducting thorough data cleanup and transformation activities using SSIS to ensure the accuracy and consistency of information.

Utilizing SSRS packages to generate reports for tracking and managing data discrepancies and reconciliation progress.

Managing the storage and maintenance of consumer information, including but not limited to full names, social security numbers (SSNs), dates of birth, contact details, healthcare insurance details, and dependent information.

Creating and maintaining case IDs and ticket numbers for effective tracking of reconciliation cases.

Assigning staff analysts to specific cases and closely monitoring their progress throughout the resolution process.

Communicating effectively with Qualified Health Plans (QHPs) as necessary to obtain supplemental information for case resolution.

Leveraging CERRS as a comprehensive case management and tracking system to reconcile enrollment discrepancies between CMS FFM and QHPs or FF-SHOPs.

Analyzing discrepancies and data inconsistencies by harnessing data shared from various CMS systems integrated with CERRS.

Ensuring strict compliance with data retention policies by meticulously storing information for the duration required to resolve each case effectively.

NetVision Resources, Inc.

Owings Mill, MD

SQL/SSIS/SSRS Developer

Oct/2018 – Jun/2021

Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.

Optimized query performance by modifying SQL queries, removing unnecessary columns, and eliminating redundant and inconsistent data.

Created efficient Stored Procedures for data cleansing and loading tasks.

Developed SSIS packages to integrate data from Text files and Excel files.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations.

Implemented Event Handlers and Error Handling in SSIS packages.

Deployed SSIS Package into Production and used Package configuration to export various package properties.

Tested, Cleaned and Standardized Data meeting business standards using Fuzzy/exact lookups using SSIS tasks.

ManTech

Columbia, MD

ETL/SQL Developer/SSIS/SSRS Developer

Jun/2016 to Nov/2018

Involved in Requirement gathering, Technical Design, Development, Testing, and Implementation of reports in SQL Server Reporting Services (SSRS).

Worked on developing Tables, Indexes, Views, Complex Stored Procedures, Triggers, Functions, SQL joins, and other T-SQL code to implement business rules in SQL Server 2016.

Wrote T-SQL, designed, and modified database objects such as Tables, Stored Procedures, and UDF for SSRS report requirement.

Extensively utilized Teradata utilities for loading the data into CPM DWH system.

Used SQL to query the databases and performed extensive data processing in Teradata, using complex SQL.

Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions, and more using T-SQL to provide structure to store data and maintain database efficiently.

Created SSIS Packages to perform filtering operations and to import data on a daily basis from the OLTP system, DSR to SQL server.

Developed Tabular, Chart, Matrix, Drill-down, and Drill-through reports using SSRS as well as managed the Subscriptions of the reports.

Generated Multi-Parameterized reports in SSRS allowing users the ability to make selections before executing reports, thus making them user-friendly.

Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).

Environment:

SQL Server 2016/2014/2012

SQL Server Reporting Services (SSRS)

Microsoft Visio

SQL Profiler

Database Engine Tuning Advisor

Visual Source Safe

Contact this candidate