ELILTA MELESE

MS SQL /BI/SSIS/SSRS developer

Phone: 202-***-****

Email:adaelr@r.postjobfree.com

Silver spring, MD

Summary

Over 6+ years of professional experience in the Information Technology field as a BI developer in MS SQL server2012/2008R2/2008/2005 environment covering various domains.

Excellent in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS and Tera data, Data Cleansing, Data Migration and using them to alter and build objects.

Excellent problem solving and analytical skills proficient in system-based decisions.

Hands on experience in database normalization, de-normalization, optimization, Tuning, Back-up, migration, conversion and document processing using data modeling tools like MS VISIO 2010/2013.

Proficient in creating dynamic packages for Incremental loads and data cleansing in data warehouse using SSIS.

Experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.

Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.

Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.

Ability to build data marts and cube by analysis tool SSAS. Easy to build and deploy analytic solutions for decision support systems.

Ability to measure, edit and compare business data with different queries. Good experience on KPI (Key Performance Indicators) areas.

Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures

Experience in Application systems and understanding how the data resides in the source system to effectively create OLAP Structures to support reporting.

Excellent experience in developing drill down, cascading, parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.

Experienced with visualization tools like Power BI, Tableau and SAP LUMIRA.

Experienced in creating Ad hoc reports with complex design to query the database for Business Intelligence.

Ability to assign different types of keys with their preferred data types.

Experienced in installing, upgrading and configuring Microsoft SQL Server and Databases.

Vast experience with SQL in understanding DDL, DML, DCL, TCL, DRL statements.

Experienced in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.

Confident with operators, variables, wildcards, views, triggers in T-SQL.

Clear cut idea about data warehouse, dimensional modelling, OLAP, OTAP, RDBMS and schemas.

Good Understanding with AGILE methodologies like Scrum, Extreme Programming (XP) and Unified Process (USDP).

A well-organized, goal-oriented, highly motivated effective team member.

Technical skills and tools

●Databases: SQL Server 2017/2014/2012/2008/2005/2000, Access 97-2007

●Languages: T-SQL, HTML, CSS, C#, Visual Studio 2017/2013/2012, SharePoint, Data Analyst

(RDBMS, SQL)

●O/S: Windows Server 2012/2003/XP/2000/NT/98/95, MS DOS 6.2

●Reporting: SQL Server Reporting Services (SSRS), Tableau

●Integration: SQL Server Integration Services (SSIS)

●Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP,

●DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor (DTA)

●Internet Tools: Internet Information Server (IIS 5.0/6.0), FTP, TCP/IP

●Other Tools: Microsoft Office 2003/2007/2010

Work Experience

SunTrust bank, Richmond VA 09/2017 – Present

BI Developer

Responsibilities:

Requirements gathering, Analysis and Design of all the client requirements.

Performed Data Modeling and Developed logical and physical model using Erwin and implementing them to sql server.

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information and other important data.

Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.

Designed, coded and implemented ad hoc reports using existing report models in SSRS.

Identified the Data Source and defined them to build the Data Source Views.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports

Managed Alerts for successful or unsuccessful completion of scheduled Jobs.

Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-through and demographical comparisons with SQL database of customer information.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Involved in testing, bug fixing and documentation for the project.

Worked on updating and maintaining customer information using Slowly Changing Dimension for address and last name changes using SSIS.

Performed detailed data analysis to analyze the duration of claim processes and created the cubes with Star Schemas using facts and dimensions through SSAS.

Designed and developed KPIs to measure sales and Growth using SSAS.

Assisted with best practices during implementation and integration of Tableau Platform.reere

Created SSIS/DTS packages to copy tables, schemas, views to extract data from Excel.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Create complex DTS Packages in SSIS for Data load from CSV/Excel Sheets with more than 200 columns and with different file layouts to SQL Server database.

Developing Stored Procedures and Functions used for inserting, updating, or transforming data.

Developing complex T- SQL queries used for data investigation.

Creating table indexes and constraints to ensure data integrity and enhance query processing.

Sourced data from various types of relational databases, flat files, excel files.

Created story points for different dashboards involving lot of category divisions.

Involved in creating and visualizing dashboards using Tableau Desktop.

Generated Dashboards by joining multiple complex tables.

Exported reports from Tableau desktop to Tableau server.

Environment: SQL Server Data Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Management Studio 2012, Visual Studio 2010, MS Report Builder 3.0, Microsoft Excel 2013, Tableau.

Social & Scientific Systems, Silver Spring, MD 08/2015 – 08/2017

BI Developer

Responsibilities:

Responsible in maintaining databases.

Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).

Performed intermediate queries using SQL, including Inner/Outer/Left Joins and Union/Intersect.

Pulled data from existing customer databases using views built in SQL Server, Excel and csv flat files.

Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load using Visual Studio.

Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.

Ensured processes and project plans implemented and used by the end user customers.

Troubleshoot to resolve issues and meet company standards.

Optimized the queries for efficient data retrieval by implementing indexes on the tables.

Provided regular reports for both internal and external stakeholders.

Created cubes and data marts using SSAS

Designed snowflake and star schemas for customer summaries.

Used complex expressions to group data, filter and parameterize reports.

Designed reports and visualizations using MS BI solutions utilizing MS SQL Server, SSAS, SSRS, Power Pivot, Power View, and integration with Excel

Created linked reports and managed snapshots using SSRS.

Performed various calculations using complex expressions in the reports and created report models.

Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS 2008.

Created many complex ad hoc reports like Tabular report, parameter report, drill through, and drill down reports in SSRS.

Deployed and managed the reports in the Report Manager using SSRS 2008.

Designed reports subscription schedule for managers.

Standardized reporting formats and statistical analysis methodologies.

Visualized nationwide growth with Power Map.

Used Power query and Power view extensively for mobile data improvements.

Created predictive models and verified predictive analytics for the business solutions using Rapid Miner.

Environment: SQL Server Data Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Management Studio 2012, Power BI, Rapid Miner.

AT&T, Irving, TX 04/2013 – 07/2015

MS SQL BI/SSIS Developer

AT&T, Inc. provides telecommunication services and products, including wireless communications, local exchange services, telecommunications equipment, managed networking and wholesale services. My project mainly involved in Creating and monitoring database to track project management to help with managing contractor's projects, hours and billing.

Responsibilities:

Designed and implemented complex SSIS package to migrate data from multiple data sources.

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

Created SSIS package to extract, validate and load data into Data warehouse. +

Created and modified existing stored procedures, triggers, views, indexes.

Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

Successfully migrated data between different heterogeneous sources such as flat file, Excel etc.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Extensively used SSRS to design and subscribe Drill Down, Drill Through, Matrix, Cascading parameterized reports to present the billing detail and sale performance of departments and shared them in SharePoint.

Environment: Microsoft Visual Studio: SSIS, SSRS, SQL Server Management Studio 2008R2, Microsoft Excel 2010 and Microsoft SharePoint.

Education

●Bachelor

References

●Will be provided upon request.

Contact this candidate