Daniel Antonio Demaria
Concord,NC
Summary
Experienced IT professional with over 10 years in the industry, specializing in data analysis, data visualization, data modeling, and modern data warehouse concepts. Proven expertise in extracting, manipulating, and reporting data from various sources and formats. Demonstrated ability to provide analytical insights, improve processes, and solve complex problems across multiple business sectors, including financial services and non-profit organizations. Key strengths include: Proficient in analytical thinking, problem-solving, and decision-making, with a focus on developing communication strategies that align with company objectives. Strong leadership and collaboration skills, emphasizing best practices and innovative solutions. Extensive experience in data analysis, validation, and cleaning, with a solid foundation in relational database management concepts, including database design and reporting. Skilled in complex SQL, data profiling, and ETL processes, including source-to-target mapping and data lineage. Knowledgeable in software development life cycle (SDLC) and testing methodologies, with expertise in SQL Server administration and performance optimization. Basic knowledge of SAS and R, with experience in business analytics platforms like MicroStrategy. Adaptable, self-motivated, and an effective team player with a rapid learning curve.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Data Analytics Lead
Bank of America
05.2023 - Current
- Led remediation projects to enhance data retrieval and operational efficiency, while developing error detection methods for better communication and planning
- Provided technical guidance to data analysts, monitored data quality and performance, and retrieved raw data from various Systems of Record (SOR) using MicroStrategy
- Optimized the database and improved data retrieval processes, creating comprehensive reports and dashboards for senior management using Excel, SQL, and Tableau
- Conducted risk assessments, data mapping, and quality assurance testing to ensure accuracy in key risk indicator metrics, while providing regular project updates on changes and improvements
Analytics and Report Lead
Wells Fargo
06.2021 - 12.2022
- Collaborated with senior management and business partners to analyze problems and recommend communication solutions for informed decision-making
- Managed the Production Data in Lower-level Environments (PDiLL) Remediation project, ensuring data consistency across multiple sources and analyzing incoming data for discrepancies
- Created executive dashboards and reports using Excel, SQL, Tableau, and Power BI, integrating data from various sources including the PDiLL Oversight team and Enterprise Data Masking
- Developed dashboards for Application Dependency Mapping and provided JIRA dashboard management for Confluence domains, while supporting routine operations and addressing ad-hoc data requests
Sr. Data Analyst
Bank of America
03.2019 - 03.2021
- Assessed data quality and supported the Data Quality team with detailed reports
- Enhanced reconciliation processes between Remedy and Runbook by collaborating with application managers and developers to resolve issues
- Utilized SQL for data manipulation across multiple RDBMS platforms, including Oracle, MS SQL Server, IBM Netezza, and DB2
- Identified data discrepancies and assisted the BMC Discovery team with stale data issues
- Conducted ad-hoc scans for BMC Discovery assessments and provided guidance on AIT for mapping certifications
- Supported the MicroStrategy team in troubleshooting errors and performance issues in Sailfish environments
Sr. Data Analyst
Charter Communications
06.2018 - 02.2019
- Developed detailed reports from legacy systems (LCHTR, LTWC, LBHN) and tailored SQL scripts for credit services to enhance data utilization
- Analyzed and validated customer account and billing data for accuracy and integrity
- Demonstrated expertise in ICOMS and CSG billing systems for effective data management
- Utilized Teradata and SAS for data management and statistical analysis to support improved decision-making
Sr. Data Analyst / Business System Consultant
Wells Fargo
10.2017 - 03.2018
- Created comprehensive reports and interactive dashboards from multiple data sources to support decision-making and project visibility, utilizing advanced Excel techniques for data analysis
- Developed bulk update reports and a tracking list with established metrics, enhancing the approval process and accountability within data center management
- Analyzed time-based trends and diverse data sources, generating meaningful insights and presenting findings through visually appealing graphical formats
Database Specialist
TeleworX
01.2017 - 09.2017
- Designed and developed databases and daily batch feeds for the marketing department, improving data storage and real-time insights for the Marketing Dashboard
- Conducted ETL processes to clean and integrate analytics data, creating Tableau reports for actionable insights in Marketing and Finance
- Analyzed invoice data against carrier contracts to identify discrepancies, managing contract data tasks as the sole analyst on major projects to ensure alignment with project plans and client SLAs
SQL Database Developer and Administrator
Tech Guru USA
12.2014 - 12.2016
- Managed SQL Server environments (2008 R2, 2012) with high-availability solutions, resolved client issues, and performed upgrades from MS Access and older versions
- Developed ad-hoc reports using SSRS, designed data models with E-R diagrams, and monitored performance while scheduling tasks with DTS and SSIS
Information Technology Expert
Yared- Siboni Construction
03.2013 - 12.2014
- Maintained status reports for management and ensured documentation accuracy while supporting database design for performance
- Collaborated with the General Manager on daily operations and provided IT support for enterprise project management
Database Administrator and Magazine Distribution Associate
Premo Advertising
11.2011 - 11.2012
- Provided backup administrative support, tested stored procedures, and conducted technical analysis and code reviews, with expertise in security, backup procedures, and disaster recovery planning
- Skilled in report writing, evaluation plan preparation, and proficient in MS SQL Server installation, configuration, and performance tuning
- Conducted database consistency checks and applied data modeling using ER Studio and Visio
Data Encoder and Project Assistant
Unity University
05.2008 - 04.2010
- Coordinated and organized programs, events, and training sessions while managing accurate data entry and analysis
- Developed a robust database system for the registrar's office and updated records
- Engaged with customers and students to address technical questions and led project deployment as a peer leader when necessary
Education
Master of Science (MSc) - Information System - Specialization in Business Development
Linnaeus University
Bachelor of Science - Management Information System
Unity University
Skills
- Analytical thinking
- Problem-solving
- Decision-making
- Communication strategies
- Leadership
- Collaboration
- Data analysis
- Data validation
- Data cleaning
- Relational database management
- Database design
- Reporting
- Complex SQL
- Data profiling
- ETL processes
- Source-to-target mapping
- Data lineage
- Software development life cycle (SDLC)
- Testing methodologies
- SQL Server administration
- Performance optimization
- SAS
- R
- Business analytics
- MicroStrategy
- Project management
- MS Project
- MS Office Suite
- Reporting tools
- SSRS
- Tableau
- Power BI
- Database management
- MySQL
- MS Access
- IBM Netezza
- Oracle
- Statistical tools
- Toad Data Point
- Toad for SQL Server
- Windows operating systems
- SolarWinds
- Adera
- ServiceNow
- Skype for Business
- WebEx
- MS Teams
- Quality management
- JIRA
- Confluence
- Telecommunication billing systems
- Integrated Communications Operations Management System (ICOMS)
- Business/Customer Support System (CSG)
Certification
Microsoft Certified in Administering Microsoft SQL Server 2012/2014 Databases
Publications
Risk and risk management practices within information system outsourcing.
Technicalacumen
Proficient in MS Project and MS Office Suite for effective project planning and execution., SSRS, Tableau, Power BI, MicroStrategy, SQL Server, MySQL, MS Access, IBM Netezza, Oracle, SAS, Knowledgeable in Statistical Analysis System (SAS), Proficient in Toad Data Point, Toad for SQL Server, Experience with various Windows operating systems, including Windows XP-10, Server 2000-2008 R2, SolarWinds, Adera, ServiceNow, Skype for Business, WebEx, MS Teams, Proficient in quality management tools including JIRA, Confluence, Integrated Communications Operations Management System (ICOMS), Business/Customer Support System (CSG)
Languages
English
Full Professional
Timeline
Data Analytics Lead
Bank of America
05.2023 - Current
Analytics and Report Lead
Wells Fargo
06.2021 - 12.2022
Sr. Data Analyst
Bank of America
03.2019 - 03.2021
Sr. Data Analyst
Charter Communications
06.2018 - 02.2019
Sr. Data Analyst / Business System Consultant
Wells Fargo
10.2017 - 03.2018
Database Specialist
TeleworX
01.2017 - 09.2017
SQL Database Developer and Administrator
Tech Guru USA
12.2014 - 12.2016
Information Technology Expert
Yared- Siboni Construction
03.2013 - 12.2014
Database Administrator and Magazine Distribution Associate
Premo Advertising
11.2011 - 11.2012
Data Encoder and Project Assistant
Unity University
05.2008 - 04.2010
Bachelor of Science - Management Information System
Unity University
Master of Science (MSc) - Information System - Specialization in Business Development
Linnaeus University