Name Mickyas Mekonen

Phone 971-***-****

Email Address ady1if@r.postjobfree.com

Summary

Over 7 years of experience in reporting solution development, ETL development, business intelligence solutions and enterprise data warehouses development involving multiple industries

Expert Knowledge in building and managing relational databases and tables normalization/denormalization using SQL Server Management Studio (SSMS)

Expert with producing highly efficient and project-oriented T-SQL query statements

Goal-oriented usage of features such as Dynamic SQLs, Cursors, Views, Stored Procedures, User-Defined Functions (UDFs), Triggers, Indexes, Temp Table in SSMS to provide convenience for front-end applications or reporting purposes

Proficient in tuning performance of query statements using Execution Plan, SQL Profiler, and Database Engine Tuning Advisor

Profoundly experience in feature design and flexible usage of tabular charts, donut charts, histograms, and maps to express business solutions comprehensively using visualization tools including Tableau, PowerBI, MS SQL Server Reporting Service (SSRS) and Excel

Excellent knowledge of MS SQL Server Integration Service (SSIS) to perform ETL solutions for Data Migration, Data Conversion, Data Validation, Data Management, Reporting and supporting other analysis

Profound understanding of Enterprise Data Warehouses and Data Marts including OLTP/OLAP, Dimension/Fact Tables, Top-down/Bottom-up models, Star/Snowflake Schemas using Landing and Staging stages

Strong Skills in using SSIS Control Flow (Execute SQL task, Foreach Loop Containers, Script Task, File Task, Expression Task, etc.) and SSIS Data Flow (Derived Column, Count, Multicast, Conditional Split, Lookup, Data Conversion, etc.)

Substantial experience in usage of Event Handlers, Loggings, Checkpoints, Breakpoints and Debugging in SSIS

Proficient in using skills like Slow Changing (Type 0/1/2/3) and Change Data Capture to load and transform data dynamically

Highly skilled with Agile/Scrum/Waterfall working methodologies along with phases of Software Development Lifecycle (SDLC)

Effective problem solver with thorough analytics added to credible and concise presentations

Technical Skillset

RDBMS: MS SQL Server 2016/2012/2008R2/2008/2005, MySQL, Oracle

Reporting Tools: SQL Server Reporting Services (SSRS), Excel 2016/2013/2007, Tableau 10/9/8, Power BI

Languages: T-SQL, PL/SQL, C++, C#

ETL: Server Integration Service (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Data Quality Services, Talend

Data Warehouse/OLAP: SQL Server Analysis Services (SSAS)

Development Platforms: Visual Studio 2015/2010/2008, SharePoint 2013/2010, Atom, Jupyter, PhyCharm

Project Management: JIRA, Slack, TFS, Microsoft Project, Microsoft Visio

Project Experience

Bank of the West

Jan 2020 – Present

MS SQL Server /ETL Developer

Responsibilities

●Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

●Developed, monitored and deployed SSIS packages

●Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.

●Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.

●Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.

●Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

●Using DTSX Change tool converted DTS packages to SQL Server 2005 SSIS packages.

●Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

●Created SSIS packages to retrieve data from Legacy sources and retrieve user data from the Flat files on monthly and weekly basis.

●Responsible for data analysis, loading data from Data feed to Data Warehouse tables.

●Involved in conversion interfaces on QNXT Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits.

●Used techniques like backups, restore, replication, and standby databases to ensure higher availability Production Environment.

●Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.

●Created Tabular Matrix reports, Charts and graphs as per customer requirements using SSRS.

●Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS 2005/2008.

●Involved in designing the physical database models on SQL Server 2005 RDBMS using DML/DDL implementing constraints and triggers for data integrity.

●Extensively used T-SQL to manipulate and architect to produce results for users.

●Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency

●Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.

●Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization

●Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

●Used SQL profiler to view indexes performance to mostly eliminate table scan.

●Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

●Worked with development teams in the design of physical databases and in modification.

●Involved in migration from SQL Server 2005 to SQL Server 2008

●Created incremental data load task using SQL Server Integration Services

Environment: MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g, Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007.

Citizens Property Insurance Corporation

Apr 2016 – Dec 2019

MS SQL Serv0er / SSIS Developer

Responsibilities:

●Actively participated in gathering of User Requirement and System Specification

●Developed database objects like tables, views, stored procedures in SQL Server 2008

●Created Partition Tables based upon Partition Functions and Partition Schemas

●Involved in Performance Tuning of the Stored Procedures, User Defined Functions and long running queries.

●Created reports based on the format specified in the design document

●Documentation of all the processes involved in maintaining the database for future reference

●Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer

●Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.

●Involved in development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.

●Created DTS Packages for extracting data from Flat Files, Excel, MS Access, Oracle and MS SQL Server 2000

●Responsible for data analysis, loading data from Data feed to Data Warehouse tables.

●Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS.

●Data access layer implemented using ADO.NET with Database.

●Implemented ADO.NET concepts to connect to the database. SQL .NET Data provider, Data Adapter and Data Set were used to retrieve and access data.

●Developed SQL stored procedures and daily as well as monthly batches using ADO.NET and SQL Server 2005

●Created reports using SQL Server reporting services SSRS, which is then exported as PDF. Reports variables are passed from ASP.NET web pages.

●Designed and built the ETL for mass uploading of product attribute changes into a custom-built analytical MDM solution.

●Developed Subject Areas for MDM using SQL Business Intelligence

●Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS

●Created reports using SQL Server reporting services (SSRS), which is then exported as PDF. Reports variables are passed from ASP.NET web pages.

●Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.

●Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks

●Involved in Unit Testing, Integration and deployment in Production and Staging Servers.

●Used .Net Framework for creating Reports and customization of reports.

ENVINORMENT: MS SQL Server 2005/2008, Visual Studio 2005, COM/COM+, VC++, C#, MySQL, Windows 2000, Windows XP, T-SQL, VB.NET, ADO.NET, ASP.NET, Visual SourceSafe, XML, MDM, MDX, Crystal Reports, SSAS, SSRS, ERWIN, Brio.

Education

Bachelor’s Degree.

Contact this candidate