Summary: Assisted with municipal client database implementation and post-implementation to track labor, equipment, and material costs of engineering projects. Provided on-going production support and handled requests via a ticketing system. • Created SSIS ETL packages and scripts to migrate data from legacy database systems into the new CityWorks application with a SQL Server backend. Transformed data using data conversion and other cleansing. Performed data validation to reconcile data between the source and destination databases.• Developed reports, dashboards, scripts, stored procedures and triggers using advanced SQL scripts, SSRS, Crystal Reports, Power BI, Power Query, DAX, and Python. • Configured SQL Server Agent jobs and SSRS report manager objects to run ETL packages and deliver reports on a schedule.

Summary: Created and maintained project management applications to track the progress, cost, and timelines for State of California departmental telecom system installations.• Developed Microsoft Access and Excel applications to automate project management personnel jobs using graphical user interfaces and VBA code to perform various tasks. o Examples are converting, renaming, and shuffling files between network directories. Combining data from multiple sources into template form for importing or presenting. Generating a series of Excel workbooks with a maximum of 999 grouped and sorted rows from a Master worksheet. Adding history tables and modules to Master data with tracking algorithms. Extracting phone numbers with conversion statuses using Regex patterns.• Analyzed data and designed various reports by request. Evaluated raw data for anomalies, discrepancies, and trends using SQL procedures with complex calculations, aggregations, and comparison logic.• Assisted project managers with spreadsheet preparation, pivot tables, macros, and advanced formulas to present to upper management.

Data Engineer August 2020 to February 2021Kobie Marketing - Saint Petersburg, FL Industry: MarketingSummary: Created and maintained marketing cloud data warehouses and data flow pipelines for the administration and analysis of client loyalty and reward programs.• Created Snowflake data warehouses in Azure and imported data from source database systems.o Created SSIS packages to load legacy data and dataflow pipelines to continuously load new data from Oracle, MySQL, SQL Server, PostgreSQL, Excel, and text files. Transformed data using data conversion and other cleansing techniques. Developed data analysis and validation reports to reconcile data between the source and destination databases.• Prepared reporting environment to consume data from the cloud data warehouses.o Converted source system stored procedures and embedded SSRS scripts into Snowflake code. Tuned and/or reconstructed existing procedures for efficiency. Created new SSRS reports and assisted the data scientists to create Snowflake scripts and SSRS reports. Created Power BI dashboards and reports using PowerQuery, DAX, Python, and Snowflake connections. Developed and maintained SSAS dimensional database cubes for executive summary reports. • Configured SQL Server Agent jobs and SSRS report manager objects to run ETL packages and deliver reports on a schedule.

Summary: Implemented credit union client remote reporting environments on a cross-functional Scrum team. • Deployed and/or maintained remote data warehouses for 17 client companieso Created SSIS ETL packages for one-time loading of large amounts of archived data some with tables of 100 million rows or more. Created SSIS ETL packages and SQL stored procedures to continuously transform source data and load it into dimension and fact tables incrementally. Developed SQL data analysis and validation scripts to reconcile source and destination data and scripts for unit testing• Provided supplementary support based on the client’s contracto Created Power BI dashboards and reports, SSRS and Excel financial reports, and Python scripts.• Cleared two-year production support backlog of problematic implementations for other clients

Summary: Maintained insurance provider client remote reporting environments on a cross-functional Scrum team.• Loaded source data into the multi-client data warehouseo Created SSIS ETL packages with XML scripts for easy replication and deployment to remote client servers. Included dataflow pipelines to load and transform data from the source database systems. Developed SSRS reports and SQL scripts requested by clients. Resolved production database issues and made database modifications by request.• Created a data warehouse for the data scientists with dataflow pipelines from the production database.• Updated source databases daily with ICD and CPT codes from the Centers for Medicare and Medicaid website.

Summary: Maintained insurance provider client remote reporting environments on a cross-functional Scrum team.• Loaded source data for all clients into the segmented data warehouse and configured SQL Server Agent jobs to run ETL packages on a schedule.o Maintained the initial load package and developed the SSIS incremental load package for daily inserts, deletes and updates using SQL Change Data Capture (CDC) to detect changes in the source data. Developed SQL data analysis and validation scripts to reconcile source and destination data and scripts for unit testing• Created and maintained SSAS dimensional analytics cubes. • Created SSRS ad hoc reports with MDX scripts. Analyzed data with Excel PowerPivot and developed dashboards with Microsoft Power BI.

Summary: Provided data analysis of healthcare insurance clients’ member enrollment, subsidy eligibility, and claims activity and presented the results in periodic reports. • Loaded data into SQL Server from the clients’ source systems for reporting and analysis.o Imported data from text, Excel, EDI, DB2, and MySQL sources into SQL Server for data analysis using SSIS, VB.Net and C#.Net. • Converted Excel tasks into advanced SQL scripts for detecting updates and discrepancies between our databases and the clients’ databases. Embedded these scripts into SSRS reports and exported the formatted pivot tables, grids, and charts to Excel. Created some SSRS reports with the standard 835 and 837 EDI file formats and exported them into EDI text files for the updating of client databases.

Solution Developer II August 2014 to December 2015Raymond James - Saint Petersburg, FL Industry: Wealth Management, FinanceSummary: Created and maintained applications for the Compliance Team to ensure wealth management personnel complied with government statutes and regulations and corporate policy.• Developed Microsoft Access and Excel applications to automate compliance team jobs using graphical user interfaces and VBA code to perform various tasks.o Functionality included CTE education credentialing, audit tracking, client services, trade analysis, money laundering detection, direct mail campaigning, report generation, and switchboard form navigation. o Developed pass-thru queries to perform retrieve and/or manipulate data in linked SQL Server and Oracle backend databases.• Provided technical and production support for 250 applications.• Created ad-hoc reports for internal clients in the Compliance Department.