Freelancers using Google App Script in SuwaneeFreelancers using Google App Script in Suwanee
ProjectsPeople
Michael Plowden's avatar
Michael Plowden
Suwanee, USA
SQL Data Engineer | ETL, Power BI & Automation
New to Contra
SQL Data Engineer | ETL, Power BI & Automation
Cover image for I designed and supported automated
I designed and supported automated reporting workflows that moved data from source systems through validation and transformation into databases, spreadsheets, APIs, and reporting tools. The goal was to replace repetitive manual steps with dependable, maintainable automation. My work included API integrations, field mapping, data validation, error handling, and delivery or refresh steps using tools such as Zapier, Google Apps Script, SQL, and Python. The workflow and code shown are sanitized portfolio examples with no client data, credentials, or proprietary automation logic.
0
16
Cover image for I built data-quality and reconciliation
I built data-quality and reconciliation checks to catch issues before they affected reporting, downstream processes, or business decisions. The work included validating required fields, standardizing formats, identifying invalid or duplicate values, reconciling source and reporting totals, and creating clear exception outputs for follow-up. The validation query shown is a sanitized portfolio example and does not contain client data or proprietary quality rules.
0
13
Cover image for I built Power BI dashboards
I built Power BI dashboards for financial and operational reporting, with row-level security to ensure each user could see only the data permitted by their assigned role and region. The work included designing the data model, creating Power Query and DAX logic, configuring security access, and supporting dependable report refreshes. The dashboard and RLS rule shown are sanitized portfolio examples using sample data, with no client data or proprietary report elements included.
0
23
Cover image for I consolidated 13 legacy SQL
I consolidated 13 legacy SQL queries and data pipelines into 2 streamlined workflows, reducing runtime by 60% while making the reporting process easier to maintain and support. The work involved reviewing existing logic, standardizing source data, simplifying transformations, and rebuilding the process around clearer, reusable SQL. The code shown is a sanitized example created for this portfolio and does not contain client data or proprietary code.
0
24
Google App Script(1)