ELDA YEFRU

aczy86@r.postjobfree.com

240-***-****

Summary:

Detail oriented Microsoft Business Intelligence developer with experience in developing, designing and maintenance of Microsoft SQL Server Services along with planning, applying business requirements in diverse industries.

Strong skills with all parts of the MSBI stack with a special focus on T-SQL, Data warehousing ETL, SSIS & SSRS.

5+ years MSBI of database designing and development,Data Modeling(CDM,LDM,PDM)

Strong RDBMS concepts and experience in creating, maintaining and tuning views, stored procedures user defined functions and system functions using TSQL, SQL server.

Writing T-SQL Queries, Implementing relational database design techniques using SQL Server 2008/2008R2/2010/2012/2014

Writing PL\SQL Stored procedure, function in Oracle Database 11G, 12

Having good knowledge on creation and scheduling of TSQL jobs to run daily.

Implementing data integrity, specifying rules throughout database tables by creating and applying constraints, (primary key, foreign key, unique, check and default constraints)

Expertise in writing complex stored procedures queries, functions, triggers for event handling for the application team or/and end users based on the business requirement.

Defined best practices and standards for the data modeling process.

Creating Conceptual, Physical and logical Data models

Applying SQL Queries using SQL analyzer, performance tuning, and database Engine tuning advisor

Expert in crating ETL Processes for data cleansing, assuring data quality, and standardization techniques.

Creating ETL process packages using diverse Data flow and control flow tools along with tracking package events by event handler in SSIS

Advanced in developing costumed SSRS reports (matrix, tabular, charts, etc.) using SQL server 2008R2/2010 and 2012

SSRS Reports server Deployment, maintenance, support and enhance existing or new SSRS reports.

Deploying SSRS reports along with setting up email data driven subscriptions and parameter filtering including Linked reports and assuring security access.

Detail oriented with emphasis on quality of work using solid organizational skills with ability to manage multiple priorities.

Communicate status and technical considerations to both technical and non-technical audiences.

Ability to work at a fast pace and adapt to a rapidly changing environment.

Education:

BS Computer Science Unity University, Ethiopia.

Professional Experience:

Hogan MAY 2015- present

MSBI, SQL SSIS, SSRS Developer

Hogan is a multinational law firm co-headquartered in London and Washington, DC. It has around 2,500 lawyers working out of more than 40 offices in the United States, Europe, Latin America, the Middle East, and Asia. The Information Technology team's mission is providing cost effective and secure information and technology services and solutions to enhance the firm.

Responsibilities:

Developed Data warehouse and reporting solutions using the Microsoft Business Intelligence based tools (SSIS & SSRS) with MSBI

Implementing business rules by using different PL\SQL constraints

Created presentation and metric process reports for legal team and finance team purposes.

Created matter and client reported report

Created sub reports and linked reports based on clients for their business needs.

Created programs with the highest level of integrity for our clients.

Designed multiple filters and categories for different cases.

Performed SQL query optimizations.

Implemented package configurations, logging, scheduling, error handling, variables etc. while creating the packages.

Wrote complex SQL queries, triggers and stored procedures, used for testing, that validate the ETL process.

Developed test queries that validate stored procedures PL\SQL statement that pull data from the data warehouse into the report products.

Worked with Data Analysts and Developers to clarify data requirements and QA Analysts to ensure that data presented in reports is accurate.

Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.

Completed change request work to load data with extra columns to understand details data and started new import source to process the data Worked for Data Truncation and reload as per the requirement to change in import for data quality.

Executed dashboard and automation for repetitive processing tasks, as well as offers support to upgrade and modify automation.

Meridian Senior Living

1330 Massachusetts Avenue, NW Washington, DC July 2013-April 2015

MSBI, SQL, TSQL, SSIS, SSRS Developer

The Residences at Thomas Circle is a care retirement community in Washington, DC that offers housing options for currently healthy people who want to secure their healthcare plan throughout the aging process and it now operates over 10 different states.

Responsibilities:

Maintained records based on service being provided, Independent Living, Assisted Living, and Memory Care etc.

Created System log reports.

Designed reports based on changing Healthcare plans.

Created and updating tables with daily Healthcare records.

Created daily, weekly, monthly and quarterly reports on patients with MSBI.

Performed Data Validation and cleansing to ensure the integrity of data is maintained.

Created maintaining SSIS packages, and supporting enhancing existing SSIS packages.

Implemented Constraints for HIPAA rules and regulations.

Monitored performance and propose enhancements to T-SQL queries.

Source data, build and maintain reporting and provide expertise on the best approach to implement it.

Designed SSIS package for data transfer, managing and maintenance.

Provided technical guideline and focuses on data management, performance measurement, and reporting.

Implemented Business Logic for POA and other Legal activities Group by creating Stored Procedures.

Created dashboard and scorecard for performance measures and management reporting needs.

Liaised with technology partners, gathers and understands requirements, collaborates with management to develop reporting approach and delivers reporting.

Knowledge of SQL Server Transact SQL (development and performance tuning).

Design daily, monthly and annual Health and community Reports.

Performed SQL query optimizations, maintenance, backup, creating users and groups and other database administration roles.

Documented ETL Design (high level and low level design) and perform ETL design and development and carry out ETL functions or responsibilities using SSIS tools.

JMA Solutions, Washington DC July 2012-June 2013

TSQL, SSIS Developer

JMA Solutions is a consulting firm with over 10 year of experience delivering outstanding customer support. JMA have provided customer support for Program Management, Engineering Services, Air Traffic Management and more. JMA Solutions is a dynamic and thriving management services firm consisting of knowledgeable and seasoned professionals.

Responsibilities:

Providing different domains to multiple consultants, dividing how many consultants have access to a domain.

Creating consultant data payroll reports

Creating and maintain budget reports.

Resource Management Reports, number of clients, pay, etc.

Maintaining project renewal data in SQL server.

Designed and developed data construction using SQL Server Integration Services (SSIS), TSQL and stored procedures.

Developing queries and stored procedures along with performance tuning of existing code.

Designing payroll data reports as well as payroll growth reports.

Documents ETL Design (High level and Low level Design) and Perform ETL design and development and carry out ETL functions or responsibilities using Informatics and SSIS as tools.

Executed code reviews, evaluated execution plans, and corrected inefficient code.

Followed data standards, resolved data issues, completed unit testing and system documentation for ETL processes.

Worked with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.

Maintain multiple SQL Server environments.

Actively involved in improving system performance by tuning SQL queries and stored procedures by using SQL Profiler, and Index Tuning Wizard.

Led the design, development and implementation of BI and Reporting solutions within Knowledge business.

Creating reports for based on client requirements Using SSIS in Extracting, Loading and Transforming of Data from different source systems like SAP and other ERP systems.

Designing different data reports on top of the client data based on client requirement.

Actively participated in the on-going development, maintenance and improvement of a comprehensive knowledge base/FAQ repository.

Build - Design and develop all areas of a business intelligence solution, including databases, ETL, reports, and dashboards, primarily using the Microsoft BI stack.

Contact this candidate