SQL CERTIFICATIONS• Data Camp : Introduction to SQL: Completed June 18, 2022• Data Camp :SQL Joins: Completed June 19, 2022• Data Camp: Intermediate SQL: Completed June 20,2022• Data Camp: Time Series Analysis in SQL Server: Completed June 23, 2022• Data Camp: SQL Server Fundamentals Track: Completed June 29, 2022DATA CONVERSIONS – 20 YEARS• Interpret field types for import from numerous file formats such as:o Flat Files with fixed length fieldso FoxPro Databaseo Microsoft Access database o Excel Spreadsheets• Provide data cleansing with custom SQL scripts.• Create queries in MS Access to extract and upload the dataSQL SERVER – 20 YEARS• ETL SQL Scripts for Querying data, finding specific data, and updating data when needed• Created Relational Databases with custom views to aid in reporting• Stored Procedures to aid in repetitive queries• Functions for updating fields to eliminate duplicate entry, such as calculating Age from todays date and birth date.• Triggers for creating entries in external tables after insert and update• Generate UI screens for end users• Create Reports and Dashboards for end user query of the dataSQL SERVER INTEGRATION SERVICES (SSIS) 2 YEARS• Set up SSIS Packets to extract, transform and upload (ETL) the data into the SQL Database tables from various file formats.• Create the Control Flow, Data Flows, Conditional Splits, data transformations and data destination. Some columns were derived, added and SQL tasks were implemented.POWER BI 2 YEARSo Created Slicer tables for year, week of year, month, and departmento Exported data in Quickbooks Mapped the tables so the Slicers would give the expected resulto Created Dashboards for Data Analyticso Dax Programming to give year over year and month over month comparisons