ETL Specialist/SQL Developer

Esete Maruta

Phone 240-***-****

***********@*****.***

Database /BI Solution Architect

Flexible and adaptable in a variety of roles contributing keen technical and analytical skills in high performance data integration for business intelligence solution.

With over 5 years of experience in database design, development, and database systems using MS SQL 2019/2016/2014/2012. Highly diligent and technically capable in manipulating databases and improving performance; Intensely focused and often complete tasks ahead of schedule. Pay close attention to detail and results.

Software Development Life Cycle (SDLC) /

Troubleshooting and Issue Resolution / Documentation / Extraction, Transformation, and Load (ETL) packages / Reporting / Optimize Performance / Logical and Physical Data Model Designs / Business Requirements /

RDBMS

SQL Server 2019/2016/2014/2012

Languages\Tools

Visual Basic, PowerShell, C#, T-SQL.

Modeling Tools

MS Visio and Oracle SQL Server Data Modeler.

Visualization

Power BI Desktop, Report Builder, Visual Studio

Analysis Tools

SQL Server Analysis Server (Tabular and Multi Dimensional)

PROFESSIONAL EXPERIENCE

Database / ETL Solution Architect (03/2015-04/2017)

MAPBOX

Technical Scope: T-SQL, ETL, SSRS, Power BI, Alteryx, SSIS, Tableau.

Developed databases, tables, cluster/non-cluster index, unique/check constraints, views, stored procedures, and triggers; Authored stored procedures promoting optimal system performance. Tracked data manipulations using audit functions; Developed SSIS packages and scheduled to keep extracting data from On-line Transaction Processing (OLTP) at specific time intervals. Performed query optimization and performance tuning.

Key Achievements:

Proactively Involved in Technical discussions with Business Analysts, developers, product owners and all stake holders to gather and review business requirements

Documented the technical architecture of the data warehouse, including the physical components, their functionality, source data and ability to integrate with existing system architecture.

Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.

Extensive experience in MS SQL Server 2014/2012R2/2008 R2 Business Intelligence in MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS).

Experienced in providing Logging, Error handling by using Event Handlers, and Custom Logging for SSIS Packages.

Created SSIS packages which involved a variety of transformations such as look up,, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join,Slowly Changing Dimension,, and Data Conversion before loading the data into Data Warehouse from various sources Namely Oracle 12c, DB2 10.5, SQL Server 2014/2012R2/2008 R2, .CSV, Microsoft Excel and Text file from Client servers.

Created and modified T-SQL stored procedures/triggers for validating data integrity.

Developed custom and parameterized reports using SSRS. Configured and deployed all the reports (RDL, RDS) across a number of SDLC environments. Contributed to complex SSRS reports, including sub reports, matrix/tabular reports, charts, and graphs.

Created data sets using T-SQL and stored procedures.

In query optimization and performance tuning, rebuilt indexes and tables.

Built data visualizations in Power BI Desktop and Power BI Service.

Configured report Subscription and report sharing rules in Power BI workspace.

Utilized Custom Visuals from Power BI market place.

Embedded Power BI reports in SharePoint.

Migrated SSRS reports to Power BI.

Configured Power BI Premium Capacity Workspaces.

Developed Self-Service Analytical Data model using Power BI.

Closely worked with Business Analysts and stake holders to gather and review business requirements.

Create document maps to help the end users easily navigate between multiple pages or between reports

Review BRDs and the ETL strategy, analyze the existing source dataflow diagram and make modifications when necessary, gathered requirements, analyzed data, developed and built multiple SSIS packages, populate SSRS source tables, create SSRS reports and dashboard, supported more than 20 client companies' general business reports and benefit plan administration processes.

Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS

ETL Specialist/SQL Developer (06/2017 – 03/2020)

DASDAK

Technical Scope: SSIS, MS Excel, SQL Server 2012, SQL Server 2008 Reporting Services (SSRS), SSRS 2008, DTS, T-SQL/PLSQL

Build tables in SQL Server and T-SQL, applying normalizing techniques on database tables. Demonstrate deep skills in: creating and using stored procedures, views, and user defined functions; creating sub-queries and joins for complex queries; and, creating indexes, indexed views, observing business rules and creating effective functions and appropriate triggers to assist efficient data manipulation and consistency.

Key Achievements:

Imported and exported data from MS Excel, SQL Server 2012 and flat files by designing and constructing import and export SSIS packages.

Using the Software Development Life Cycle (SDLC), analyzed business requirements and developed functional work flow for information from source systems to destination systems.

Extensive experience in SSIS Package Configurations and deployments between Development and QA and Production servers so that various properties like variables, connection managers could be changed when moving the Package from one environment to another.

Involved in Code Revie, Unit testing and closely worked with the QA team.

Design and develop store procedures to mask sensitive information while uploading data from production to the QA environment by utilizing random and custom strings.

Conducted system tests, troubleshoot customer issues and correct database defects.

Excellent experience in Exception Handling with @@error a, with Try/catch.

In the design and execution of development and production SSIS packages, utilized SSIS lifecycle and implemented event handlers and error handling. In constructing loop containers and fuzzy lookups, utilized a variety of transformations in SSIS dataflow and control flow. In addition, demonstrated talent in creating dynamic packages for data warehousing using SSIS.

Increased performance optimizer using query optimizer, and contributed to Extract, Transform, Load (ETL) architecture enhancements.

Configured incremental load, changing dimensions employing slowly changing dimension transformation.

Designed and created report templates consisting of bar graphs and pie charts for financial data; built extensible reports using SQL Server 2008 Reporting Services (SSRS). Constructed complex reports (Drill Down, Drill Through, and Cross Tab Reports). Additionally, contributed to scheduling, creating snapshots and subscriptions for the reports utilizing SSRS 2208.

Collaborated on front-end for implementing logic in stored procedures and functions.

Conducted complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML, and User Defined Functions to implement business logic. Created the clustered and non-clustered indexes. Contributed to normalization and de-normalization of existing tables, resulting in faster query retrieval.

Reviewed plan execution for optimized queries to improve database tuning.

Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing report and other insurance/payroll/COBRA file transfer reports by using SSRS and SQL Server 2008/2012.

Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.

Troubleshoot customer issues and correct data related defects.

Created Cross-Tab, Drill-down and Sub-Reports using and promoted the RDLs to Reporting Service Server.

EDUCATION AND TRAINING

Bachelor Degree IN Computer Science

Contact this candidate