Data Developer

ADDISIE GEREMEW

Phone: 301-***-**** * Email: ************@*****.***

Washington DC, Zip 20011

CAREER GOAL

Over seven years of experience in applying Microsoft SQL Server Management Studio (SSMS), Implementing SQL Server Integration Services (SSIS) and Reporting Services (SSRS) using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT) and Power BI as a backend developer in financial and healthcare sectors. With this experience, I am looking to work as SQL and BI Developer in a technology-oriented company where I can demonstrate my caliber and technical abilities to design, test, and deploy SQL and BI solutions as well as provide solutions to data analytic issues.

PROFESSIONAL SUMMARY

Experience in Database and Business Intelligence Technologies with expertise in SQL Server Database, ETL and Report development using SQL Server 2008/2012/204/2016, SSRS, SSIS, Power BI and Tableau.

Strong Experience in client requirement analysis, logical and physical design), development, Testing, Deployment, Performance Monitoring Tuning and troubleshooting business applications.

Hands on experience in Application and Database Development using SQL Server, Skilled in writing T-SQL scripts and designing databases.

Proficient in creating database objects such as stored procedures, views, Triggers, user defined functions, cursors, derived tables, and common table expressions (CTEs) and Complex and dynamic queries using DDL, DCL, DML and TCL query languages.).

Involve in data migration using import/export, BULK INSERT and BCB between heterogeneous systems and MS SQL Server and creating alerts and scheduling SSIS Packages.

Expert in creating SSIS packages involving ETL process, extracting data from various sources (Flat files, Excel files, XML, SAP, and SQL Server) and loading for data warehousing.

Perform Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column; optimizing queries with indexes

Proficient in applying error handling, troubleshooting through Checkpoints and Breakpoints in packages for better reusability.

Skilled in developing parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports, Custom Reports and different types of Tabular reports, Matrix reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).

Good knowledge of Defining, Developing and Deploying Star Schema, Snow flake Schema and Dimensional Data modelling using MS SSAS.

In depth experience in using SQL Server Data Tool (SSDT) and business intelligence development studio (BIDs)

Sound knowledge of Data marts, Data warehousing, Operational Data Store (ODS), Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.

Hands on experience creating Tableau dashboards and visualizations.

Excellent knowledge of all the phases of Software Development Life Cycle (SDLC). SKILLS & TECHNOLOGIES

Programming and Scripting Languages: C#, VB.Net, T-SQL, Java Script,Linux, C++, Visual Basic

DBMS: SQL Server 2005/2008/2012/2014/2016, MySQL, Oracle

Data Modeling Tools: LucidChart, Draw.io, Visio

Business Intelligence Tools: SSRS, SSIS, SSAS, Informatica

Data Visualization Tools: Tableau, Power BI, Grapher

Statistical Tools: STATA, EPI Info, SPSS, R, Python, JMP, CANOCO, GeneMapper

Operating Systems: Windows Server 2003, 2008, 2012, 2016

Cloud Environments: AWS, Azure

Version/Source control: Team foundation server, Git (distribution)

Issue tracking software: JJIRA

Project management and requirement analysis

EXPERIENCE

Senior SQL/ SSIS/SSRS/ Developer (January 2018 to Present) Targeted Technology Institute, Silver Spring, MD

Partner with data and business analysts to refine the business requirements that must be met for building and maintaining data warehouses/marts built on Microsoft SQL Server 2017.

Analyzed business requirements and built conceptual, logical, and physical data models that describe all the data and relationships between the data

Installed and Configured SQL Server 2012/2014 on physical Server and Virtual environments

Evaluated the data structures in the source and enhanced the existing logical and physical database design to fit new business requirement, and implemented new design into SQL Server

Developed complex T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, cursors Constraints, Stored Procedures Queries and join statements to support normalized and dimensional models.

Optimized the existing queries to improve performance by using Profiler and Execution Plans.

Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like SSIS, BULK INSERT etc.

Built SSIS packages, and scheduled ETL jobs to populate data from disparate sources/ business systems including MS Excel, MS Access, Flat Files, Oracle, etc. into SQL server and vice versa using SSIS.

Designed and deployed SSIS packages using various data Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Aggregate, Conditional Split, and Derived Column.

Managed and monitored the system utilization by using query optimizer and checking execution plan as well as Handling errors and, Log particular events.

Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.

Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using SSRS and Tableau.

Built SSRS project to generate reports with desired formats (Word, PDF, Excel, etc.) to present statistics information according to business requirements.

Deployed analysis projects using SSAS based on data volume, as well as developed of KPI's which helped the Business users for easy understanding.

Worked on transitioning database and report packages from Development and Test Environments to Production

Developed relational databases and multidimensional OLAP data warehouses. BI/ETL Developer (November 2014 to December 2017)

Apside, Bruxells, Belgium

Designed and Developed complex SSIS packages for performing ETL process using SQL Server Integration Services.

Built numerous complex SSIS packages to pull data from different sources (SQL server, CSV, Flat Files, XML) and loaded into data destination by using SSIS.

Used ETL to implement the SCD (slowly changing Dimension) transformation to maintain historical data in data warehouse.

Worked on SSIS logging, Error Handling and Package configurations.

Deployed SSIS packages to stage and production environments and created SQL server agent jobs for scheduling daily.

Created reports that contained Parameters, Sub-Reports, charts, gauges with Drilldown and Drill-through features in MS SSRS 2016.

Developed various visualizations by creating reports and dashboards with Power BI and deploying them to Power BI Services.

Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and performed calculation with MDX.

Designed and created high efficiency Dashboard management reports with implementing KPI.

Involved in performing Audits and recovery operations of SSAS objects.

Built Azure assets and services and required in the architecture

Worked with the customer to integrate the Azure environment into their existing environments and ensured that the architecture meets all SRG standards SQL Developer/DBA (September 2012-September 2014)

Q-Dignostic PLC, Addis Ababa, Ethiopia

Installed, configured and upgraded installations of SQL server 2012.

Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults

Creation of New NT Logins and granting privileges to users/Groups and objects

Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes

Backup and recovery of Master, MSDB and Application databases

Monitored NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk as current

Responsible for Query optimization and Performance tuning

Monitor Server Level Blocks/deadlocks and Maintain all the OLTP Servers with Maximum Database Availability, & Reliability

Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.

Setup Transactional Replication and maintain the servers.

Performance tuning, optimization of procedures and queries and also support, maintain, monitor and tune high available and clustered database systems.

Developed a security schema for user access and maintained the databases by setting up logins and privileges.

Developed strategy for database backup and recovery based on user requirements

Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor. EDUCATION & TRAININGS

M.Sc in Biology (Major) and Statistics (Minor), Vrije Universteit Brussel, Belgium

B.Sc. in Applied Biology, Mekelle University, Mekelle, Ethiopia

Diploma in Advanced SQL Server/ BI Developer, CPU Technology College, Addis Ababa, Ethiopia

Certificate Advanced T-SQL for MS SQL Server 2016, Sholla Corporate, Siver Spring, MD, USA

Certificate in Tableau Developer, Duke University, USA

Contact this candidate