Sql Server Data

Abinet Boke

**** ***** *** *** ***, Takoma Park, MD 20912 **********@*****.*** 240-***-****

PROFESSIONAL PROFILE:

About 4 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of Crystal Reports 8.5/9/10, Oracle 9i/11g/12c, SAP BO, Tableau Desktop 9/10,SQL server 2008/2012/2014/2016.

Good Experience in working with RDBMS including Oracle, SQL Server, MS Access and Excel.

Expert in creating various type of reports such as Complex drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).

Hands on experience in installing, configuring, managing, upgrading & migrating, monitoring & troubleshooting SQL Server 2005/2008 /2012/2014 & Databases.

Experienced in developing Oracle PL/SQL packages and object types

In-depth knowledge of XML and XSLT data and processing tools

Solid understanding of inheriting PL/SQL object types, casting PL/SQL object types into descendant types, converting PL/SQL object collections into a result set, bulk operations and pipelined functions

Proficient writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML & User Defined Functions to implement business logic & also created clustered & non-clustered indexes.

Data Extraction/Transform/Load (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP

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

Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Experience with Tableau, Power BI or equivalent BI Toolset

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Major responsibilities include getting requirements from the user, developing Tableau and SSRS Reports maintaining proper documentation of the reports for future reference

EDUCATION:

M.S. in Energy Management, University of Twente, Enschede, Netherlands - 2012

Database Design & Computer Programming (9-month training), Northern India Research Institute, India - 2008

B.S. in Engineering Technology, Bahir Dar University, Bahir Dar, Ethiopia - 2003

TECHNICAL SKILLS:

Scripting: PowerShell Scripting, Biml Scripting, DOS Scripting.

Tools and Technology: SQL Server Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS), Oracle 11g, SQL*Plus, TOAD, Erwin Data Modeler.

Databases: SQL Server 2012/2008R2,2005, Oracle 11g/10g/9i, Amazon RDS, Teradata, DB2

ETL Tools: Informatica PowerCenter 9.5/ Oracle Warehouse Builder/ SQL Server Integration Services (SSIS).

Methodologies: ER/Multidimensional Modeling (Star/Snowflake), Data Warehouse Lifecycle.

Reporting: SQL Server Reporting Services (SSRS), Report Builder 3.0, Tableau, Crystal. Reports

Languages: Visual Basic.NET, C#, C++, Java, JS, T-SQL, PL\SQL, XML, JSON.

Operating Systems: Windows Server 2000, 2003, 2007, 2010 & 2012, UNIX.

Monitoring Tools: Quest Spotlight/Foglight, SQL Trace/Profiles.

PROFESSIONAL EXPERIENCE:

Client: American Health Lawyers Association, Washington, DC. 08/2017 - Present

BI Developer (short-term contract)

Designed & developed a full-scale reporting solution for a multi-client environment using MS SSRS 2012 & MS SQL Server 2016.

Optimize various SQL queries to make the reports run faster

Provided MS SSRS 2012 training to clients in order for them to develop their own ad-hoc reports.

Converted MS SSRS 2012 based reports to CRM 2016 UX based reports.

Created drill down, drill through, sub & linked reports using SSRS 2012 & managed subscription of the reports.

Create test data by creating views/procedures for reporting purpose

Create and edit alerts on Reports, as per User request

Migrate reports from Dev to Production

Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.

Created, implemented and maintained a reporting suite of over 180 standard reports while also customizing many reports to meet individual client needs.

Involved in CRM upgrade project and migration from Business Objects to Tableau.

Configuring, customizing and providing technical support to corporate CRM systems.

Environment: MS SQL Server 2016/2012/2008, MS Access, MS Excel, MS Office Access 2013, DB2, Oracle 12c, SAS. CRM 2011, UX8, Tableau Desktop10.

Client: Department of Labor 08/2016 - 08/2017

SQL Developer/ Data Analyst (contract)

Created the SSIS package to load, change and clean the data various data sources to database.

Designed ER diagrams and mapped the data into database objects and involved in normalization of the database in OLTP.

Used SSIS package to populate data from excel to database, used lookup, derived column and conditional split to achieve the required data.

Add package configuration and package parameters to ensure the package execution in another server.

Developed cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes, dimension members, calculation, actions, partitions and perspective using SQL Server Analysis Services 2008R2 to analyze data based on sales information.

Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.

Environment: SSRS, SSIS, MS SQL Server 2014/2012/2008, C#, MS Access, MS Excel, MS Office Access 2013, DB2, Oracle 12c, SAS, Tableau.

Client: Frontier Communication, Rochester, NY. 08/2015 - 07/2016

SQL Developer / Data Analyst (contract)

Migrated all data and objects of Oracle 9i to MS SQL Server 2012 server.

Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.

Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.

Extensively using joints and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.

Store procedures, User defined functions, Views, T-sql scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.

Experienced in creating, designing, processing of cubes using SSAS.

Responsible for creating and maintaining Analysis services objects such as cubes, dimensions, measures. Created report model on SSAS cubes as well as changing default configuration on existing cubes.

Assisted with documentation and code deployments from Development, QA and Production environments.

Environment: SQL Server 2012/2014,.Net framework, Microsoft Office Share Point Server 2012, XML, Oracle 9i and11g, Visual Studio Team Foundation Server 2012, Visio, Agile Development and PowerCenter ETL 9.5.1 ASP.NET, C# .Net 3.5 framework, ColdFusion.

Allied Aviation, Houston, TX. 07/2013 - 07/2015

BI Developer / SQL Developer

Created and maintained T-SQL stored procedures, functions, created database objects like tables, views, triggers. Updated and maintained database data.

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard, supported more than 20 client companies' general business reports and benefit plan administration processes.

Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing report and other insurance/payroll/COBRA file transfer reports by using SSRS and SQL Server 2008/2012.

Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.

Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.

Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional Tables and Operational Data Store (ODS).

Normalized data fields to meet the business requirements and specifications to build a data marts for various departments into a metadata.

Designed and implemented cubes across multiple data marts using OLAP methods in Business Object for users to access reporting as its needed.

Maintained ETL jobs for OLAP cubes. Executed and supported ETL using MS-SQL Server and Informatica.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Environment: SSRS, SSIS, SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, FTP, Microsoft Reporting Services, MicroStrategy.

Contact this candidate