Database Specialist Ssis

Fante Dawet

(***) *** - ****

*******@*****.***

Professional Summary:

Highly motivated Microsoft BI Tools (SSIS, SSRS & SSAS) using SQL Server 2005/ 2008/ 2012/ 2014/ 2016, Power BI the last 4 years.

Wide-ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc.

Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).

Experience in integration of various data sources like SQL Server, Salesforce, Access DB, DB2 and Flat File, Excel File.

Import Data into Power BI using different ETL methods, SQL Azure, Direct Query, Restful API Generator, build relational model with in Power BI.

Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.

Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc., to convert raw data into required data meeting the business requirements

Extensively worked on Control Flow Tasks such as for each Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, and Send Mail Task.

Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).

Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.

Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2012/2014/2016.

Experience in debugging the SSIS packages using breakpoints and checkpoints.

Hands-on star schemas, snowflake schemas, dimensional modelling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.

Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.

Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.)

Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.

Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships, highly complex joins and SQL Scripts for Views and Materialized Views.

Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.

Education:

Georgia Piedmont Technical College – Atlanta, GA

Associate’s Degree - Database Specialist

Unity University College – Addis Ababa

Bachelor Degree – Accounting

Certifications:

Certificate in SQL Server Database

Certificate in Business Analyst with Proficiency in DWH and BI

Certificate in Power BI and Azure

Technical Skills:

Operating System

Windows 2003, 2008, 2010

Languages

Pl/SQL, T-SQL

Microsoft Technologies

ASP.NET, VB.NET, ADO.NET

Web Technologies

HTML, XML, SharePoint 2010.

Databases

MS SQL Server 2005/2008/2012/2014/2016

BI Tools

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI Desktop.

Development Tools

Visual Studio.NET 2008/2012/2013/2015/2017 Community Edition

Database Query Tools

SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2015, SQL Profiler, DQS, Toad for SQL server

PROFESSIONAL EXPERIENCE:

Client: First commercial Bank, Alhambra, CA May 2021 – Till Date

Role: MS SQL BI Developer

Responsibilities:

Worked on SQL Server Integration Services SSIS to integrate and analyze data from multiple heterogeneous information sources

Created SSIS packages to extract data from OLTP sources like MS SQL Server 2016/2014, Text Files, Excel and Access to OLAP systems (SQL Server 2012/2014/2016).

Created SSIS packages to automate different FTP's files and emailing to different clients.

Created SSIS packages included a variety of transformations, for example, Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.

Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).

Created several visualizations and featured dashboards using Power BI for Underwriting Team for Fully funded group reports.

Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

Created, Maintained & scheduled various reports in Power BI.

Published Power BI reports from Power BI desktop to Power BI service.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases

Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2012/2014 and then created reports using this data using SSRS 2014/2016.

Extensively worked on OLAP cubes using SSAS. Responsible for documentation of system related activities. Used Dataset, Data Table, Data Adapter, Data Reader and other ADO.NET connectivity controls.

Created stored procedures and functions to perform business operations on the back-end using MS SQL Server 2012/2014/2016 database

Created and Managed OLAP Cubes using SSAS.

Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder 2.0.

Based on the business requirement written complex T-SQL queries to perform data and graph validation to make sure that the test results are matched.

Designed Data flows, Workflows and jobs to load data from source to target.

Created trace in SQL Profiler and used Data base engine tuning advisor for performance tuning on scripts and stores procedures.

In-Depth knowledge of SDLC, understanding of various phases like Requirements, Analysis, Design, Development. And Testing. Reviewed many T-SQL issues using management studio for better performance

Environment: MS SQL Server 2016/2014/2012 R 2/2012/2008/2005, SSIS, SSRS, SSAS, SQL Profiler, T-SQL, ASP.Net, DHTML, XML, C#, CSS, ADO.Net, AJAX, VB Script, Power BI, MS Access, Excel, MS Visio, MS Office 2010/2007/2003,Windows 2010/2008/2003/2000.

Client: Health Integrated, Tampa, FL Aug 2019 – Apr 2021

Role: MS SQL BI Developer (TSQL, SSIS, SSRS)

Responsibilities:

Active participation with customers in understanding their business process and suggesting optimal database structure, practices and tools on specific projects, ensuring high customer satisfaction rates.

Supported efficient Data Insertion, Manipulation, and Retrieval using various Joins, Indexed Views, Stored Procedures, and Functions.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

Transferred data from various OLTP data sources such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server.

Involved in SQL Server Stored Procedure Development and T-SQL.

Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report services (SSRS).

Migrated reports from MS SQL Server Reporting Services and created complex reports using SSRS from the OLAP cubes for end user analysis.

Optimized and implemented stored Procedures and triggers for automating tasks and also managed indexing, debugging, optimization and performance tuning using T-SQL.

Involved in Migration of databases from Business Objects to SQL server.

Imported data from various sources like MS Excel, MS Access, oracle, DB2, transformed to data warehouse using SSIS and then created reports using this data by SSRS.

Creating database objects like tables, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Migrated Parameterized reports from Business Objects to Reporting services (SSRS).

Created Parameterized Reports using RDL. Promoted RDLs to Reporting Service Server (SSRS).

Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated users and to administrative Clients.

Environment: MS SQL Server Management Studio 2012/14, OLPT, OLAP, SQL Profiler, MS SQL Server Integration Services (SSIS), ETL, MS SQL Server Reporting Services (SSRS), Microsoft Visual Studio, Agile, Business Objects (BO), Windows.

Client: AWI, Lancaster, PA April 2018 - July 2019

Role: SQL / MSBI Developer (SSIS/SSRS)

Responsibilities:

Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.

Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.

Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2008 R2 Analysis Services (SSAS) and Reporting service (SSRS).

Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.

Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.

Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.

Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages.

Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.

Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.

Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.

Recreate Tableau reports using Google Big Query data sources.

Performed business data analysis and report creation in support of both ad hoc requests from the customer and to support new development and system maintenance.

Research and investigate key business problems through quantitative analyses of utilization, healthcare and cost data.

Provided and defend conclusions and recommendations to customer based on results of analysis.

Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.

Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, TFS.

References will be provided upon request.

Contact this candidate