Data Developer

Hanna Aberham

Email: ************@*****.***

Contact: 240-***-****

Professional Summary:

BI Developer with 5 years’ experience in multiple industries, with experience as Database Developer and Business Intelligence developer using various tools like SSMS, SSIS, SSRS, SSAS, Databases MS SQL Server and MS Access. Proficient in designing and data modelling, Data Mapping, Table Normalization, Optimization, Tuning. Good knowledge in all phases of Software Development Life Cycle (SDLC). Upgrading and Configuring Microsoft SQL Server. Proficient in SQL Server and T-SQL (DDL and DML). Generated ETL Packages, Reports/Dashboards applications. Worked in agile and waterfall project methodologies from initial development. Development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer

Technical Proficiencies:

Operating Systems: Windows XP, Vista,7, Windows Server 2003/2008/R2/2012

Database Packages: SQL Server 2005/2008/R2/2012,2016,2017 MS Access

BI Tools: BIDS/SSDT, SSMS, SSIS/SSAS/SSRS, SharePoint, TFS, Power Pivot, Power View, Power BI

Data Modeling: Erwin, MS Visio

SDLC Methodologies: Waterfall Model, Agile, SCRUM

Professional Experience:

Viavi Solutions- Germantown, MD January 2019- Present

BI Developer

Responsibilities

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

Responsible for documenting Data Dictionaries and versioning them

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.

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 stored procedures, views, triggers and constrains to implement the database consistency and integrity.

Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.

Created data mapping between source and target using different tools like data profiler, ERWIN and Excel sheet.

Designed ETL packages to migrate data from different data sources such as Oracle, flat files, and XML files into SQL server.

Used various SSIS tasks such as Condition Split, Derived Column, etc. to scrub, clean and validate data during staging before loading data into the data warehouse.

Tools and Technologies: MS SQL Server 2014/2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Enterprise

Manager, Windows Server 2003/2008/2012/2104, DTS, Share Point Portal Server, HTML, XML, C#, .Net,

Inovalon - Bowie, MD February 2017- December 2018

MS SQL/ BI Developer

Responsibilities

Created database tables with various constraints including primary key, foreign key, etc.

Loaded data from flat data files into SQL Server 2008 database tables using bcp, bulk insert, and table export/import, SSIS package

Power user of SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL.

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

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Assist with documentation of tasks and processes for business and technical teams use of data quality, metadata, ETL tools.

Created views to display required information on user interface, and triggers to validate consistent data entry into the database.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.

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

Tools and Technologies: MS SQL Server 2014/2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Enterprise

Manager, Windows Server 2003/2008/2012/2104, DTS, Share Point Portal Server, HTML, XML, C#, .Net,

ASP.NET, Visual Studio 2010/2013/2015, MS Access, Crystal Reports, MS Excel 2007.

Asmara Palace – Asmara, Eritrea October 2015 - December 2016

SQL /BI Developer

Responsibilities:

Developed Energy Conservation System including design, data model, ETL creation, Star Schema design, Cube Creation, Dimensional Hierarchies design, writing MDX calculations, writing SSRS and Performance Points reports and dashboards.

Solved T-SQL query performance issues by checking the execution plan and then rewriting the query or adding missing indexes

Created T-SQL functions, cursors, views, indexes, stored procedures and triggers.

Worked with application developers and production teams across functional units to identify business needs and discuss solution options.

Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages

Planned, Defined and Designed data based on business requirement and provided documentation.

Scheduled and maintained packages by daily, weekly, and monthly using SQL Server Agent in SSMS.

Designed and implemented Stored Procedures and Triggers for automating tasks.

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

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

Tools and Technologies: 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

Eritrea Institute of Technology Computer Science

Contact this candidate