add photo
Daniel
etdani1@gmail.com
571-241-9885
Arlington, VA 22246
Database / ETL Developer
14 years experience W2
0
Recommendations
Average rating
111
Profile views
Summary

  • Highly qualified MS BI consultant with over 8 years of experience in implementing end-to-end BI solutions using the Microsoft BI Stack (SSIS, SSAS and SSRS) within several industries Real estate, Banking, Automotive industry.
  • Involved in gathering business requirements from clients through Joint Requirement Development sessions for functional and nonfunctional requirements.
  • Implement ELT to load data warehouse using Azure Data Factory.
  • Used Azure Data Lake as a destination and source of ELT.
  • Experience in implementing a CI/CD of Azure Data Factory.
  • Experience in managing projects and creating automated deployments using Azure DevOps.
  • Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
  • Experience in creating efficient ETL Strategy for initial load into the databases as well as incremental load.
  • Well versed with Software Development Life Cycle (SDLC) process and familiar with Spiral, Agile and Scrum Models.
  • Experience using many of the SSIS transformations like Slowly Changing Dimension, Audit, Aggregate, Lookup, Fuzzy Lookup, Conditional Split, Derived Column, and Multicast.
  • Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.
  • Experience in Importing/Exporting Data from various data sources like Excel, XML, Oracle and Flat file using BCP, Bulk Insert & SSIS package.
  • Well versed in creating Parameterized Reports, Drill down, linked, sub cascading Reports and Reports using SQL server Reporting Services.
  • Proficient in using Report Manager for setting up roles, security on the reports and creating Standard and Data Driven Subscriptions in Delivery of Reports.
  • Ability and willingness to learn new technology and deliver results in a timely manner.
  • Well-organized, goal-oriented, highly motivated and effective. Overall Technical Skills Azure SQL DB, Azure Data Factory, Azure Data Lake, MS SQL Server 2000/05/08/20008R2/12/14/16, SQL Server Integration Services (SSIS), SQL Server DTS, SQL Server Reporting Services (SSRS), SSAS, Power BI, MongoDB, Microsoft Products Office, VSS, T-SQL, ODBC, MS Visio 2008, Erwin, Python, .Net Framework, C#, JavaScript, CSS/3, HTML, XML.

Experience
Education
Bachelor's in
University of Virginia
Skills
SQL
2020
8
ETL
2022
7
SSIS
2022
7
Data Warehousing
2022
5
SQL Server
2020
5
Stored Procedure
2022
5
Data Cleansing
2017
4
MS Azure
2022
4
MS Power BI
2018
4
Microsoft Excel
2015
3
Oracle
2015
3
BI Developer
2018
2
C#
2015
2
Data Conversion
2015
2
Data Profiling
2015
2
ETL Developer
2022
2
FTP
2015
2
SSRS
2017
2
Triggers
2015
2
XML
2015
2
Business Intelligence
2017
1
Data Marts
2013
1
Data Modeling
2017
1
Data Validation
2017
1
Data Visualization
2018
1
Database Backups
2013
1
DB2
2013
1
Disaster Recovery
2017
1
EDI Developer
2020
1
MongoDB
2013
1
MS SharePoint
2016
1
OLTP
2017
1
Production Support
2013
1
Python
2013
1
REST
2016
1
SSAS
2020
1
SSAS CUbe
2020
1
T-SQL
2013
1
Warehouse
2017
1
.NET
0
1
Agile Methodology
0
1
CSS
0
1
Data Lakes
0
1
Erwin Data Modler
0
1
HTML
0
1
JavaScript
0
1
Scrum
0
1
Snowflake
0
1