Solution Data Engineer Resume
3.00/5 (Submit Your Rating)
SUMMARY
- 8+ years as solution architect engineer and data analyst.
- Experienced with building data pipelines to automate: data mapping, reconciling, validating, transforming and monitoring.
- Write complex queries and experience with database performance and tuning.
- Have in depth knowledge of BI tools: Yellowfin and Tableau.
- Developed very intricate dashboards with in - depth visualizations to help levels of company leaders to identify and analyze patterns in data.
TECHNICAL SKILLS
BI: Tableau server, Yellowfin
Analytical tool: Rapid miner, KNIME, R Studio
SOFTWARE: Tableau desktop, Data Match
Tools: T-SQL, SQL server 2016, Visual Studio, Redgate data suite
Access Controls: Amag, Ccure, Lenel, Winpak
API’s: Tableau server. Payment gateways Authorize.net, Stripe CLOUDs AWS, AZURE
Databases: Microsoft SQL - developer Certification, Azure, Oracle Industry Microsoft SQL
PROFESSIONAL EXPERIENCE
SOLUTION Data Engineer
Confidential
Responsibilities:
- Engineer a data pipeline in .Net and MSSQL to automate data migration process: map and validate. Improve time in bringing new data sets within 15 minutes
- Migrated, reconciliated, cleansed, validated and transformed data from multiple data sources.
- Integrate all Tableau server’s permissions to existing application
- Build rich and dynamic Tableau dashboards of office utilization, people attendance, HR and finance information
- Engineer in .net to integrate REST APIs of Tableau server, payment gateways (Authorize.net), data upload service to internal application
SOLUTION ARCHITECT ENGINEER / tableau
Confidential
Responsibilities:
- Migrated, reconciliated, cleansed, validated and transformed data from multiple data sources: access control, HR, workplace management, police ticket system, TSA training.
- Engineered an automated validation process to validate data pre-and-post-migration across multiple data sources
- Architected and built data warehouse for analytics platform used by SP500 companies.
- Built visualizations, reports and dashboards, on both Tableau desktop and server.
Senior Database Administrator
Confidential
Responsibilities:
- Administer 50+ database MSSQL servers with db size 3 + terabytes
- Designed and implemented automated backup processes of large databases
- Improved db maintenance tasks with success rate +98%
- Enhanced or troubleshoot performance large tables or views
