PROFESSIONAL SUMMARY

SQL/MS BI consultant with over 8 years of IT experience that includes Analysis and Design, Development & Support of MS-SQL 2014/2012/2008R2/2008 and Business Intelligence including SSRS/SSIS.

Highly qualified in implementing end-to-end BI solutions using the Microsoft BI Stack (SSIS, SSRS and SSAS) within several industries.

Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, Indexes, User Defined Functions, Relational Database models, Data integrity and SQL joins.

Expert in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports and Dashboard Reports using SSRS based on client requirement.

Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS

Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.

Experienced in Creating dimension tables in Teradata to fit our reporting needs.

Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension Tables.

Proficient in Job Scheduling, Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.

Excellent understanding of full Software Development Life Cycle (SDLC)

Ability to work independently Designed and coded application components in an Agile environment utilizing a test-driven development approach, also created and maintained project tasks and schedules.

highly, demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment.

Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, and Parameters etc

Involved in complete software development life cycle (SDLC) of project with experience in domains like transportation, Banking, Insurance and Appliances.

Experience in installation, Configuration and Managed SQL Server in development, test and production environment

Strong working experience in SQL native database Backup and restore.

Disaster Recovery planning and implementation.

Configured and maintain Database High Availability group always on.

Configured and maintain database replication between multiple SQL Servers.

Expertise in the ETL Tool SSIS and have expertise in Power Center Client tools including Repository Manager, Workflow Manager/ Workflow Monitor.

Worked with mappings using various transformations like Filter, Joiner, Router, Expression, Union, Normalize, Sequence Generator, Update Strategy, Reusable Transformations, User Defined Functions, etc.

EDUCATION:

Bachelor’s degree in Computer science\

TECHNICAL SKILLS:

Databases

MS SQL server 2014/2012/2008R2/2008,MS Access

Database Design Tool and Data Modeling

Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

BI Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)/including data staging, SQL Server Business Intelligence Development Studio (BIDS), SQL Server DTS, Visual Studio, Crystal Reports and Knowledge in SQL Server Analysis Services (SSAS)

Tools and Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console

Microsoft tools

MS Office, Management studio, Visual studio and Unix and PowerShell

PROFESSIONAL EXPERIENCE

Court Services and Offender Supervision Agency for the District of Columbia (CSOSA)

Washington, DC JAN 2019-PRESENT

ETL DEVELOPER

Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them

Extracted data from heterogeneous sources and transferred to OLAP using SSIS 2012

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations

Involved in automating SSIS Packages using SQL Server Agent Jobs and configured various event driven e-mail notification process in SSIS packages.

Eminent technology

Washington, dc January 2018 – JAN 2019

SQL/SSIS/BI Developer

Responsibilities:-

Gathered business requirements related to data and business intelligence needs, HLD design for the ETL and Reporting requirements.

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

Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.

Involved in performance tuning for new databases and existing databases by using SQL profiler.

Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.

Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destination using various complicated transformations like conditional split, derived column, and data conversion for fee schedules from the existing database.

Modified the existing packages by making changes in the stored procedures according to the requirement.

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

Used various data flow transformations like conditional split, look up, derived column etc.

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

Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS.

Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.

Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.

Environment: SQL Server 2014/2012, MSBI(SSIS,SSAS,SSRS), Visual Studio 2012/2008, Windows server 2012

Data consulting

Washington, DC February 2015 – December 2018

MS SQL Server Developer/BI Developer

Responsibilities:

Liaise with business subject matter experts in analyzing Business Requirement Document (BRD) and translating them into conceptual data models and schema development to be implemented with T-SQL, ETL and Reporting to develop a solution.

Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.

Optimized the database by creating new tables, various clustered, non-clustered indexes.

Developed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.

Responsible to created views with multiple Facts and dimension tables in Teradata for building cubes.

Diagnosing and tuning the server optimal performance using SQL Server 2012 SQL Profiler and Database Engine Tuning Wizards.

Map source system data elements to target system and develop, test, and support extraction, transformation, load processes, data profiling, data quality and clean ups for SSIS packages.

Used various SSIS tasks such as Data flow task, Fuzzy lookup, Conditional Split, Derived Column and Union All which were used for Data Scrubbing, data validation checks during Staging.

Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data base.

Created SSIS packages to load data into Data base using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task.

Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Created Summary Reports, Sub Reports, and Drill-down Reports using SSRS.

Planned to schedule reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs using SQL Server Reporting services (SSRS).

Designed for Alerts for successful or unsuccessful completion of Scheduled Jobs.

Environment:-SQL Server 2014/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Teradata, Database Tuning wizard and Visual Source Safer, Workflow Manager, Workflow Monitor), Oracle, Flat files, ODBC

Dangote group

Addis Ababa April 2012 -January 2015

SQL Developer/ SSIS/SSRS Developer

Responsibilities:-

As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of reports in SQL Server Reporting Services (SSRS).

Designed and developed a full-scale reporting solution for an environment using SQL Server 2008 and SSRS 2008.

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

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 in to CPM DWH system.

Used SQL to query the databases and do as much crunching as possible in Teradata, using very complicated SQL.

Defined Check constraints, Business Rule, Indexes and Views.

Worked with data modeling product support team on tool features, functionality and maintenance.

Installed and configured MS SQL Server 2008R2 along with Visual Studio on a network domain system.

Designed develop SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to AMS database.

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

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

Proficient in using Table variable, Temp table, Dynamic SQL, Loop, CTE, and various built-in functions in SQL server.

Developed Tabular, Chart, Matrix, Drill down and Drill through reports using SSRSas 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.

Experience in deployment of the generated SSRS reports through report manager.

Designed and developed corporate performance management solutions including Dashboards, Score cards and analysis of SSRS reports using the data from SQL Server 2008.

Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Extensively used SSRS for creating reports like Sub-reports, Linked reports, Cascaded Parameterized reports, Matrix reports and different types of Graph reports.

Created official Templates, Mailing Subscriptions and created shared data sources that can be used across different processes.

Subscribed many of reports useful for the clients through scheduled Email subscriptions.

Environment: SQL Server 2008, SQL Server Reporting Services (SSRS), Microsoft Visio, SQL Profiler, Database Engine Tuning Advisor and Visual Source Safe.

Bahir Dar University, Ethiopia February 2011 - March 2012

SQL Server/SSIS Analyst

Responsibilities:-

Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them

Extracted data from heterogeneous sources and transferred to OLAP using SSIS 2012

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations

Involved in automating SSIS Packages using SQL Server Agent Jobs and configured various event driven e-mail notification process in SSIS packages.

Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Deployed SSRS report to SharePoint and Report Server Web Service.

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

Rebuilding/Reorganize indexes and running Database Consistency Check Commands (DBCC).

Problem identification, troubleshooting, resolution, and index tuning databases.

Taking full Backup, Transaction log backup & differential backup in daily Routine.

Collaborated with network operators, application developers, and DBAs to enhance end user experience.

Environment: SQL Server 2005/2008/ R2/2012, BIDS, Visual Studio 2005/2008/2010, T-SQL, MS Access, MS- Excel, SSIS, SSRS,SSAS, Report Builder 2.0/3.0

Contact this candidate