SamrawitDemisse 571-***-**** adysmc@r.postjobfree.com

Professional Summary:

●Over 8+ Years of IT professional in database Design and Development on Microsoft SQL Server 2005/2008/2012/2016, T-SQL, Performance Tuning, Troubleshooting, SSIS, SSRS, SSAS and Data-warehousing.

●Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications

●Experience with Amazon Web Services including EC2, VPC, S3, EBS, Cloud Watch, AWS Redshift

●Expert in working with various data sources such as AWS, AWS Redshift, Postgres, SQL Server, Amazon Athena, Excel, Flat Files, etc.

●Expert in working with large data sets from sources such as AWS Redshift, Postgres, SQL Server, etc.

●Strong SQL Server proficiency (Database access, SQL Agent and Integration Services Catalog Management)

●Strong SQL proficiency (T-SQL, MySQL, and PostgreSQL).

●Experience working with an Enterprise Data Warehouse and Dimensional Database.

●Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.

●Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF's) for business logic.

●Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.

●Migrated old data from MS Access into SQL Server 2012 using SSIS Packages.

●Worked on all activities related to the development, implementation and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.

●Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

●Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.

●Having SSAS - Working knowledge of SSAS using tabular.

●SSRS - Reporting using parameters, Sub reports, Drill down Reports, expressions, and report development using Tabular modeling SSIS - Development and deployment of SSIS using various sources like Oracle/SQL Server/Flat Files/SAP systems.

●Used Script task for Data Flow and Error Handling in SSIS.

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

●Created SSIS packages using Conditional Split, Aggregate, Merge, Multicast, Term extraction Data Conversion, Fuzzy Lookup, Pivot, Lookup.

●Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.

●Experience with Git, Jira DevOps

TECHNICAL SKILLS:

Cloud Technologies

Microsoft Azure, AWS

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 2003, 2007, 2010, 2013, Windows 8/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

SHIFT4 Payments, Remote

Sr.ETL(Business Intelligence engineer lll)

Dec 2021– Present

●Maintain and expand ETL architecture and content.

●Creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.

●Develop automated ETL processes to ensure flow of data is gathered for appropriate Business Intelligence efforts.

●Developing ETL packages to create dimensional data warehouses using SSIS.

●Designed and developed ETL packages to validate, extract, transform and load data from OLTP, ODBC systems to the Data warehouse.

●Created T- SQL objects to load the data from the staging tables to the transaction tables.

●Support of ETL architecture and content up to and including off hours support when necessary.

●Contribute to and enforce the use of the organization's Business Intelligence solution.

●ETL testing & data validation.

●Interact with client on regular basis

●Assist in requirements gathering and data analysis as needed

●Estimate work effort and assist the Project Manager with task planning and LOE (level of effort) estimatesProvide technical leadership and oversight of a project development team

●Review work product of others for compliance with development standards

●Provide guidance and mentoring in database marketing development best practices

●Write technical documentation

KPMG, Remote

SR.ETL/ SQL /SSIS Developer

April 2019 – Dec 2021

Responsibilities:

●Responsible for creating a Data warehouse for the organization as part of the migration project from IBM to Microsoft SQL Server.

●Created SSIS packages to load data from flat files, csv and excel files in to the staging tables.

●Created T- SQL objects to load the data from the staging tables to the transaction tables.

●Responsible for creating the Datamart for various domains.

●Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.

●Creating SSIS packages to send the data in flat files to various vendors.

●Working with the Business Analysts to gather the requirements and working with them on the mapping document.

●Monitoring the production Jobs and working on postproduction tickets (defects) and enhancements.

●Working with the business to create SSRS reports by extracting data from the data mart.

●Implementing OLAP cubes (Star Schema) for the business users.

●Solely Responsible for deployment of objects (T-SQL, SSIS, SSRS) to all the regions (DEV, TEST, PROD).

●Creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.

●Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.

●Estimate work effort and assist the Project Manager with task planning and LOE (level of effort) estimatesProvide technical leadership and oversight of a project development team.

DMI, Bethesda, MD

MSBI Developer

March 2017 – March 2019

Responsibilities:

●Creating SSIS packages to extract data from various sources to load them to data warehouse using various transformations.

●Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.

●Responsible for monitoring the jobs deployed on to the server and also trouble shooting the same.

●Responsible for migration from SQL Server 2012 to SQL Server 2014.

●Working on service tickets (service –now) created by the users/business and resolving them based on the priority level.

●Conduct design review meeting with developers and architects before the actual development is done.

●Responsible for configuring report service in SSRS and creating various reports based on the requirements from the business.

●Responsible for Training interns in ETL(SSIS).

●Created Azure Data Storage accounts within the ADF (Azure Data Factory) for storing the bigdata inside the cloud.

Sapient, Arlington, VA

Database Developer

February 2014 – January 2017

Responsibilities:

●Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.

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

●Responsible for Conducting bug triage meeting for successful and fast closure of bugs.

●Transferred data from various data sources systems including MS Excel, MS Access, and Flat Files to SQL Server using SSIS/DTS using various features like data conversion.

●Performed Bulk data migration using SSIS from flat files.

●Transferred data from various data sources systems including MS Excel, and Flat Files to SQL Server using SSIS/DTS using various features like data conversion.

●Created SSRS report model projects and created, modified, and managed various report models with multiple model objects, source fields and expressions.

EDUCATION

Bachelor’s Degree Computer Since

Certificate Data Analysis

Certificate project manager

Contact this candidate