D

Samuel Debela

619-***-****

advrtn@r.postjobfree.com

Silver Spring, MD 20901

SUMMARY

6+ years of IT experience in Analysis, Design, Modeling, Development, Testing and Maintenance of Business Intelligence Applications. I have worked in different domains such as Finance and Mortgages. Using different versions of Microsoft SQL Services (SSMS, SSRS, SSIS, and SSAS) related tools. Meticulous SQL Developer with expertise in processing data and knowledge of various flowcharting techniques. An excellent understanding of database structures, theories, principles and practices. Superb problem-solving and analytical skills.

SKILLS

Professional Skill:

MS SQL Server 2019/2017/2016/2014/2012/2008, MS SQL Server Integration Service (SSIS), MS SQL Analysis Services (SSAS), MS SQL Reporting Services (SSRS), MS Access, MS Excel, MS Outlook, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor, Power Designer, Erwin Data Modeler, MS Visio, T-SQL, Unix/Linux.

Code Analysis and Development

Regression Testing

Agile/Scrum Methodology

Database Management Software

Source and Version Control: Git, Github

Linux and UNIX

EXPERIENCE

SQL Server SSIS/SSRS Developer

Miami, FL

Integraconnect/ Feb 2019 to Current

Converted the legacy sequential SQL job to parallel processing using SSIS and reduced the execution time to 50%

Converted existing legacy reports to Microstrategy Reports

Tuning the SQL Agent job and SSIS packages

Performance Tuning (Index Design and Maintenance, Ability to read/interpret SQL Execution Plans)

Production Support

Bug fixing raised by QA and Clients

Creating the SSIS packages for a smooth data flow across different servers

Create reports in BI preview portal utilizing the SSAS Tabular via Analysis connector

T-SQL coding for creating procedures and other database objects

At the staging server, data was loaded from different sources like flat delimited text files, Extensively used store procedures and UDF functions such as scalar and inline functions for complex queries, Triggers, indexes involving multiple tables from different databases

Worked on Evaluation of SSIS packages and did error handling

Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging

Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments

Created complex SSIS packages for data cleansing, involving various tasks such as for each loop, file system task, and multicasting

Interacted with the existing database developers and DBA to understand the existing schema

Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server

SQL Jobs monitoring and troubleshooting

Designed and implemented UX for clients based on their needs and requirements

Proficient in designing, implementing and managing data structures and queries using Snowflake data warehouse technology

Experienced in utilizing Snowflake's cloud based architecture for data storage, analysis and storage.

Developed database dictionaries and schemas.

Designed and created database systems after reviewing end user's requirements.

Tested databases and performed bug fixes.

Designed, developed and implemented firmware to support embedded system product concepts.

Grew program capabilities seamlessly weaving more complex elements into product foundations.

Prepared charts and diagrams to illustrate system operation results to staff in other departments.

Prepared documentation for database applications

Conducted software trial runs to achieve desired results and confirm accurate information.

Used software and computer programs to compile and categorize data for daily use.

Developed technical specifications and plans, documenting details into user manuals for future reference.

SQL Developer

san jose, CA

Home Depot/ May 2016 to Dec 2018

Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implement the business rules and transformations

Data Analysis and Designed the logical and physical model architecture for database

Interacted directly with the various SME for gathering the business requirements

Involved in Design DW of Star Schema (Dimensional model and Fact tables) based on business

Convert data from Legacy system to SQL Database

Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor

Involved in the maintenance of the existing cubes of the data warehouse by adding additional dimensions, user-defined hierarchies, and calculated members using SSAS 2008 and also wrote many scripts while developing the reports from the cubes using SSRS 2008

Implemented Auditing using triggers

Involved in scheduling backups of databases and logs and restoring them when necessary

Created schema objects, rules and granted roles to the users

Involved in Query optimization, Performance Tuning and Index Creation

Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)

Used SSRS to create reports, customized Reports, on-demand reports

Database Backup and restoring the database

Worked in Database Security, Replication, and Log shipping activities.

EDUCATION AND TRAINING

management Information systems

Unity University Aug 2011

Contact this candidate