Daniel Hailu Gardew

202-***-**** )

adkiin@r.postjobfree.com

PROFESSIONAL SUMMARY:

Around 6 years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development, and Support of MS SQL Server […] in Production, Testing and Development

Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.

Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.

Experience in coordinating with users in gathering source data files, defining data elements, business rules, data, and process flow documentation, prepare High level and Low-level design documents.

Experience in installation, configuration of MS SQL Server 2008, 2008R2, 2012, 2014.

Hands on experience in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

Knowledge of Relational Database Management systems.

Experience in Database Backup, Recovery, and Disaster Recovery procedures.

Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and exception handlers.

Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.

Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.

Install and Configure SQL Server 2008, 2008R2, 2012 and 2014 on Virtual Machines.

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.

Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SSMS on SQL Server […] environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.

Extensively worked on Creating, Populating, and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star, and Snow Flake Schemas of Data Marts.

Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.

Good experience in creating SQL Server Analysis Projects (SSAS) using SQL Server

Good Knowledge working with Facts, Dimensions, Multi-Dimensional Cubes.

Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.

Experience in Data Modeling using Erwin Design Tool

Knowledge of Networking Concepts and Object Modeling Technology.

Good interpersonal, Analytical and Communication skills

Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.

Experience in Object Oriented Analysis concept implementation, design, and programming technical skills.

TECHNICAL SKILLS:

Cloud Technologies: Microsoft Azure

Databases: SQL Server 2008/2012/2014/2017, Azure (Cloud Server), Access, MySQL, Oracle 10g, 11g, 12c.

Programming Languages: T-SQL, HTML, XML, PowerShell, VB.NET, ASAP.NET

BI Tools: SSIS, SSAS, SSRS, Power BI

Operating Systems: Windows Server 2007, 2010, 2013, Windows 8/10/NT/XP/Professional, MS-DOS, Red Hat Linux

Version Control: TFS/GIT/SVN

Languages: T-SQL,PL/SQL, C/C++, HTML, XML, VBScript, C#.Net, VB.Net, ASP.Net, ADO.Net, ActiveX, XML, MS Access, HTML, DHTML, Shell Scripting

Tools: SQL Server Enterprise Manager, Management Studio.

PROFESSIONAL EXPERIENCE:

EMIT Technologies, Washington, DC

Sr. SQL/SSIS/SSRS Developer

Jan 2019 - Present

Responsibilities:

Developed various T-SQL stored procedures, triggers, views, and adding/changing tables and Table valued Functions for data extraction, data load and transformations.

Created Reports with different Output formats such as Excel file, fixed width text file, PDF, tab-delimited and pipe-delimited.

Worked on several State Reports and used SSIS to create multiple destination files from single/multiple sources.

Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc. and scheduled SSIS packages.

Created SSRS (SQL Server Reporting Services) reports having multiple Parameters and cascading parameters, Navigation to a sub reports and created book marks when report is exported to PDF or EXCEL File.

Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.

Responsible to build Reports for different Markets and AD HOC reports as per request.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS (SQL Server Integration Services)

Documented Back out Implementation Plan for all the work done and also created the CMD files.

Worked with Team foundation server version Control to maintain the different versions of Code, RDL Files, Back out Scripts, CMD files & SSIS Packages.

Created Subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.

Provided 24/7 Production Support for the maintenance & scheduling of reports.

Environment: SQL Server 2017/2014, Report Builder 3.0, Business Intelligence Studio (SSIS, SSRS), C#.NET, T SQL, MS Excel.

Hillview Group Inc, Richmond, VA

SQL/ SSIS/ SSRS Developer

Sep 2016 – Dec 2018

Responsibilities:

Developed store procedures, triggers, views and user defined functions for better performance in SSIS and SSRS

Analyzed queries performance with SQL query analyzer, optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.

Installed and configured SQL Server 2008, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) which were highly efficient to monitor the central console and SQL Server instances and detecting problems before affecting transaction of online users.

Implemented the online indexing making the transaction in SQL 2008 faster nearly three times as compared to the SQL Server 2005.

Merged data from heterogeneous data sources including MS SQL server, flat file and MS Excel to SQL Server 2008 using SSIS packages.

Participated in to design ETL architecture and processes records from different locations, and successfully met challenges of very high volume of data.

Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers in SSIS.

Imported XML data file as data source and put into the desired database in SSRS and SSIS.

Generated different type of customized reports including drill-down, drill-through in SSRS.

Created and executed the stored procedures and complex queries for reports.

Deployed, scheduled the reports and send the output via email in report manager.

Responsible for generating different types of daily and weekly Reports based on specifications and user's requirements using SSRS

Documented all the work and all the process of integration and reporting services for further references.

Interacted with development teams and managers to analyze business needs and developed technical specifications.

Environment: SQL Server 2014/2016, SSIS, SSRS, Microsoft Operation Manager, SQL Query Analyzer, ODBC, VBScript, Windows 2000/XP/7, MDX.

Assurant Inc, Lewisville, TX

SQL Developer

Jan 2015 – Aug 2016

Responsibilities:

Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.

Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum efficiency and scalability.

Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.

Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2008.

Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts.

Used ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.

Maintained error logs for the Stored Procedures.

Used Team Foundation Server and Visual Source Safe as a version control tool.

Developed logical queries to not triggering email limit error for ETL batch jobs.

Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.

Environment: MS SQL Server 2012, Microsoft Visual Studio 2010, Team Foundation Server (TFS), MS VISIO, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Excel, Microsoft Office SharePoint Server

EDUCATION:

Bachelor’s Degree: Addis Ababa University, Addis Ababa, Ethiopia

Contact this candidate