D M Email & Phone Number

Tampa, Florida, United States

• 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.
• 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.
• 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.
• 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.

St Petersburg, Florida, United States

• 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.
• 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.
• 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.
• Configured SQL Server Agent jobs and SSRS report manager objects to run ETL packages and deliver reports on a schedule.

Tampa, Florida, United States

• 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.
• 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

Tampa, Florida, United States

• 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.
• 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.

Pinellas County, Florida, United States

• 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.
• 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.

Tampa, Florida, United States

• 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.

St Petersburg, Florida, United States

• 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.
• 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.
• Provided technical and production support for 250 applications.
• Created ad-hoc reports for internal clients in the Compliance Department.

Bachelor, Computer Science

Associate, Computer Science