Bilatina Yifru

Result driven MS SQL, Business Intelligence Developer with working track of 7+ years in Database Designing, Developing and Technical management using Microsoft SQL Server 2008/10/12/14, Oracle Client, ETL tools, SSRS and Business Intelligence Suits (SSIS, SSAS). Excellent written and verbal communication skills with the ability to effectively communicate with Clients to analysis identify and implement client needs along with functional requirement implementation throughout the entire Software Development Lifecycle (SDLC) along with the on time and within budget delivery of high quality client solution and Decision Support services.

SUMMARY OF QUALIFICATION

7+ Years of working experience in Microsoft Business Intelligence Suits (BIDS) SQL Server Integration services (SSIS), SQL Server Analysis services (SSAS) and Reporting using SQL Server Reporting services (SSRS)

7+ Years of High experience in Designing, Developing, Maintaining and Testing SSRS Reports using SSRS BI tools

7+ Years of Experience in Writing/Developing T-SQL queries, Store procedures, Function, Triggers, user defined Functions, views and indexes, Exception handling using RDBMS, T-SQL, ORACLE Client, SQL developer, SQL Plus

6+ Years of Excellent knowledge in Collecting data and developing ETL packages using SQL Server Integration Services (SSIS)

6+ Years of Experience in design and implementation of On-Line Transactional Processing (OLTP), Data warehouse and On-Line Analytical Processing (OLAP)

4+ Years of Experience in developing Dashboards and Scorecards using Microsoft Share Point 2010

7+ Years of Experience in creating Pivot Tables and Excel Charts from different data sources like MS SQL Server, MS Access, cubes using MS SQL Server Analysis Services

7+ year of reports development experience using MS SQL Server Reporting Services (SSRS)

7+ years of experience in LDM, PDM data modeling using Erwin and Enterprise Architecture

Optimization of Queries, Stored Procedure and tested application for better performance, data integrity using SQL profiler along SQL Query Analyzer

5+ Years of Installation Configuration and update of SQL Server experience

4+ Years of experience in XML, HTML, CSS

2+ Years of ASP.net

Excellent in handling responsibilities independently as well as a team member in a timely manner

Excellent written and verbal communication skills with the ability to effectively communicate with Clients, stakeholders including senior leadership.

COMPUTER SKILLS

Database - MS SQL Server 2008/08R2/10/12/14, SQL Reporting services(SSRS), SQL Analysis services (SSAS), SQL Integration Services(SSIS), Microsoft Visual studio 2008/10/12/13/15

Oracle 11g, SQL Developer, SQL Plus, T-SQL, PL-SQL, Team Foundation Server TFS/VSS, Enterprise Architecture V9.3, MS SQL profiler, SQL Query Analyzer, MS SQL Server Index Tuning, Erwin Data Modeler 7.1/5/4,VB6, MS SharePoint, Microsoft products MS Access, MS Excel, HTML, XML, C++, C#, ASP.Net, Gallio unit test, Notepad++

PROFFESSIONAL HISTORY

Department of Public Welfare, Camp hill, PA(Deloitte)

Sr, ETL/SSRS Developer

October 2014 - Current

eCIS is a Client Information system that provides Citizens of Pennsylvanians and staff to perform application processing and case management activities for benefits such as (Food stamp, LIHEAP,MA, LTC). eCIS Reporting functionality drives operational efficiencies by providing reporting at the Federal, state, County area and office level to provide users with key performance metrics, By using Business Intelligence solution to answer strategic business questions so that management can take proactive measures to manage the office and programs effectively and provides historical information to analyze trends.

Responsibilities

Design and Develop Requirement Analysis for business Change requests by interaction with clients, stake holders, and preparing technical documentation

Created technical documentation using use-case diagrams, Class diagrams, sequence diagram, Activity diagram in Enterprise Architecture

Developed T-SQL Queries, Packages, Stored Procedures, Functions, Trigger using Oracle, T-SQL, SQL Developer

Developed On demand and automated Tabular and Matrix SSRS Reports for Federal, State County Office using SQL Server 2008/14, .NET with complex Calculated fields and expressions using SSRS

Developed automation of SSRS Reports to provide Annual, monthly, weekly and on demand reports to clients.

Uploading new Reports and maintaining existing on Report servers and shared locations using Visual studio

Developed ETL data from different Data sources with target destination of SQL Server 2014 using SSIS

Generated Reports that run on OLTP and OLAP databases used by eCIS

Involved in all Software Development Lifecycle (SDLC) activities in requirement gathering, designing, writing Scripts, Unit Testing, Deployment and Maintenance

Involved in developing, documentation and validation of batch jobs using .Net

Worked on the Migration of SQL Server 2008 to SQL Server 2014

Maintained Deployment utility in Report Config file

Review requirement and conduct impact analysis, test cases and unit test for user acceptancy test

Agile methodology using version control of TFS/VS

Worked with business user, Business analysts and application team to understand the business and application requirements

Environment: SQL Server 2008/10/2014, Oracle 11g, SQL Plus, SQL Server Reporting Services,, SSAS, SSIS, Enterprise Architecture, Visual Studio 2010/12/14, TFS, .Net, MS Excel, Xml, CMD, SQL BI Suits, Notepad++

WMATA – Washington, DC May 2013 – Oct 2014

MS SQL Server/SSRS/SSAS/SSIS Developer

WMATA is a tri-jurisdictional government agency that operates transit service in the Washington Metropolitan Area. WMATA was created by the United States Congress as an interstate compact between the District of Columbia, the State of Maryland, and the Commonwealth of Virginia.

The clients Legacy web application SQL server 2008 is being converted to the new web application SQL server 2012 Database. The current system interface, reports and files transfers handled by the host application needs to be Merged and developed for the new SQL server 2012 application. This required analysis of the existing system, interaction with business user to determine the needs, modifications and new methods of sending, receiving and viewing the files.

Responsibilities:

Migrated the existing application/Databases to MS SQL Server 2012 and SSIS.

Going through the clients’ requirement coming up with Database solutions design and application architecture. Plan capacity specification requirement for new Database server using (SSAS).

Created variety of reports using SSRS including matrix report, parameter report, dashboard, charts, drill-down, drill- through, cascade parameterized report, configured report server and deployed reports on the web server with SharePoint.

Generated daily, weekly, monthly and Dashboard reports for analysis purposes and also created report models for ad hoc reports when the end user wants to see the reports on fly using Report Builder.

Designed and implemented indexing to optimize transactional and reporting performance

Developed Logical and physical data model using ERWIN and mapped the data into Database objects.

Wrote T-SQL scripts, store procedures, User defined functions, views to extract data.

Designed and Created different .DTSX packages to SQL Server 2008 source to SQL Server 2012 as destination to import and export data from Flat files, Text files, Excel spreadsheets. Using transformations such as data conversion, fuzzy look-up, conditional split, derived column transformation...

Implemented data Integration processes to handle XML files generation or processing.

Involved in developing Cubes in Business Intelligence Development Studio using SSAS.

Environment: Windows 7, MS SQL server 2008/2012, MS SQL SERVER Reporting services 2012, Report Builder 3.0, MS SQL Integration Services 2012, SQL Server Analysis services (SSAS), Visual studio, T-SQL, and ERWIN, Share Point.

Lincoln Financial Group - Richmond, VA Feb 2012- Apr 2013

ETL/SSIS/SSAS Developer

Lincoln Financial group is a financial industry that provides financial service and solution for its clients. The project was completed in two phases in the first phase it involved developing and testing the SSIS packages to deal with high volume processing output loading data from different system into Data warehouse. The second phase was to create the Analytical report for business users to understand the growth of business and better understand the service Provided

Responsibility

Created and used complex store procedure in SSRS to generate reports using SSRS.

Developed and designed various forms of Reports such as Drill down, Drill through, parameterized, cascade parameterized reports using SSRS.

Designed and developed snowflakes and star schema data models with facts, dimensions, measure and cubes, also established data granularity using SSAS.

Developed a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.

Scheduled Jobs, Alert, and Subscriptions using SQL Job Agent in SQL Server management studios.

Design KPIs, Filters, Reports, Scorecard and Dashboards reports Using PerformancePoint on Share Point.

Developed mapping databases for (ETL) team with source to target data mapping with physical naming standards, data types, domain definitions, and corporate meta-data definitions.

Developed SSIS packages to Extract, Transform and load data to Data warehouse with different control flow options and data flow transformations such as conditional split, multicast, Union all, for each loop, send mail and derived column.

Created SSIS packages for file transformation from one location to other using FTP task, with master SSIS package to run all other packages.

Used dynamic package configuration to move the package from development server to the testing server.

Used Bulk Copy Program (BCP) to import and export large amount of data in and out of SQL Server Databases.

Performed SQL performance tuning using SQL Profiler and query optimization to improve the performance of slow running queries.

Worked on Agile methodology and Microsoft Team Foundation Server (TFS) as a central server product where software team members connect and collaborate efficiently for a successful software project

Environment: SQL Server 2008R2, T-SQL, MS Access, MS- Excel, and windows server 2003 server, business intelligence tools Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, visual studio, SSIS, SSRS, SSAS, SharePoint.

Health first NYC, NY Aug 2010 – Jan 2012

ETL/BI Suit Developer

Health first, is a nonprofit managed care organization that provides healthcare coverage to individuals and families in New York service areas through low-cost or free government-sponsored health insurance programs, including Child Health Plus, Family Health Plus, Medicaid, and Medicare. The project was to build an objective to help top level management in decision making. The data from different department is collected and integrated into Data Mart that are built based on subject areas.

Responsibilities

Worked on designing the SSIS packages to transform data various sources such as Text files, XML files, Excel, Flat files to SQL server 2008R2.

Designed and developed various reports such as cascading reports, sub-reports, and charts, parameterized reports as per client requirements.

Used Execute SQL task, Execute Process task, Execute SSIS package task and Script task, File System task.

Used Event Handlers to run the Send mail task in the background upon failure of SSIS package.

Created and used stored procedures, triggers, views for Audit and Maintenance tasks.

Monitored performance and optimized SQL queries for maximum efficiency using SQL profiler and Database Engine Tuning Advisor.

Created cluster and non-cluster indexes based on Database Engine Tuning Advisor

Worked on client/server tools like SQL Server Enterprise manager and Query Analyzer to administer SQL Server and used SQL Server system tables to retrieve metadata.

Developed bug/data fixes scripts and maintained data integrity.

Worked with OLTP, OLAP, Data warehouse application on star schema and snowflakes schema dimensions.

Created SSRS data models projects using Microsoft Visual Studio 2008 and using Reports Builder for report server to facilitate Ad-hoc reporting by the business user.

Environment: MS SQL Server 2008R2, Business Intelligence Studio Integration Services, SQL Server Report services, Windows 7, Microsoft Access, Microsoft Visio

Bloomberg Financial LP, NY Feb 2010 – Jul 2010

MS SQL Server /SSRS developer

Bloomberg L.P. is a privately held financial software Provider, Connecting decision makers to the dynamic network of information people and ideas, It quickly and accurately provides Data analysis services and delivers business and financial information news to financial companies and organizations through the Bloomberg station. The project was to build Customer-Center Database to analyze transaction across financial marketing, risk analysis, data collections and customer relations.

Responsibilities

Created new Database objects Stored Procedures, Functions, Packages, Triggers Indexes and Constraints Views using T-SQL in SQL Server 2008

Created ER diagrams for easy understanding and functionality of information using MS Visio

Managed logins, roles, assigning rights and permissions. Created views to implement security.

Developed reports using SSRS using various features as per client requirements.

Have written complex stored procedures and trigger to fetch data and exception handling

Environment: MS SQL Server 2005/08, T-SQL, SSRS, MS Excel(X32 and X62 ), windows XP, SQL Server BI Suit, C++, Microsoft Visio

EDUCATION

Bachelors of Science in Computer Science

Unity University College - Addis Ababa, Ethiopia

Contact this candidate