Michael Marcello Email & Phone Number

Washington, District Of Columbia, United States

Data AnalysisDashboardsSQL

Watsontown, Pennsylvania, United States

Diagnosed and performed troubleshooting with complex data issues to support rapidly changing e-Commerce needs Created and configured REST API endpointsDesigned and updated ETL operations via NPM, C#, Java, and BoomiStrong knowledge of A/B testing analysis and tools, test design best practices, and advanced understanding of concepts in probability and statisticResident expert on AWS API accessAutomated GA4 aggregation and displaySuperior communication skills, ability write and speak clearly and kindly

Montoursville, Pennsylvania Area

Developed ETL solutions for multiple data silosMade data import processes future-proof, saving days of downtime and lost man-hoursOffered troubleshooting and designed complex SQL reports for large-scale healthcare records, including SQL queries across multiple tables, data analysis, and profiling skills for the creation of mapping documents and further discussion Assisted end-users with training, requirements gathering, and data fixesAutomated onboarding and security configuration setupsTrained colleagues on advanced Excel, Tableau, and SQL usage, including advanced methodologies like AgileExperience working with enterprise data visualization tools, such as Power BI, Tableau, Lookr with large and complicated datasets.Adopted data ownership, data stewardship, and data governance processes across the organizationCollaborate with other team members to identify additional documentation needs

Lake Oswego, Oregon

Used Biztalk and T-SQL for ETL and monitoring toolsProvided immediate support to high-risk customersUpdated company-wide training materials and toolsDeployed patches, hotfixes, and updatesInstructed colleagues in advanced Excel techniques

Portland, Oregon Area

Reduced department annual budget by $125,000 via process automationCreated multiple ETL systems to facilitate rapid and cost-effective data warehousing for Raiser's Edge CRMTrained data entry and programming staffDesigned and implemented automated procedures to enhance data tracking and report optionsHeaded CRM migration - providing requirements, roadmap, and implementation

Portland, Or

• Invented process to rapidly deduplicate and import hundreds of records from outside sources• Improved algorithms and data-entry standards to further reduce duplication• Researched then created views and dashboards for instant data distribution• Automated complex reporting• Eliminated unnecessary complexity in database with a focus on change management• Enforced and updated business rules to ensure high data health• Enhanced and created stored procedures to facilitate higher-quality data access and security• Created multiple ETL systems to facilitate rapid and cost-effective data warehousing• Trained data entry staff• Provided back-up IT support to administrative office• Improved backup of SQL database• Designed and implemented automated procedures to enhance data tracking and report options• Continually adapted to shifting data and resource needs• Foresaw and addressed multiple security and data-health concerns

Portland, Oregon Area

• Reduced staff budget from $150,000 to $70,000 a year• Facilitated rapid response to various departments• Reduced receipt lag from 6 weeks to 48 hours• Acted as liaison between multiple departments• Outsourced many processes to volunteers• Added OCR scanlines to all in-house documents, increasing efficiency and accuracy of gift processing• Removed dependency on costly 3rd party software• Wrote SQL queries, exports, and imports for organization• Designed adaptive Luhn algorithm for Access and Excel• Applied array formulas to facilitate massive data manipulation• Coded Excel and Access procedures to mass-format hundreds of thousands of names and addresses• Created adaptive unique key construction methods with built-in false-positive and false-negative detection• Researched and developed cost-saving bulk-mail technologies• Provided on-site support for multiple events incorporating gift processing, receipting, fulfillment, and tracking• Managed multiple projects with varying timelines and departments• Anticipated and eliminated hurdles to team achievement

Portland, Oregon Area

Learned Raiser's Edge database software while improving learning center systems.

Pennsylvania, Washington, And Oregon

Tutored and taught Mathematics at various schools and programs.Created and operated Millersville University's private math tutoring program.Trained to teach SAT prep.