Anthony Manderichio Email & Phone Number

Portland, Oregon, United States

• Gather requirements, conduct research, analyze data, and collaborate with customers to create and deploy reporting solutions within SRSS Reports and Tableau Dashboards utilizing agile development processes• Develop and optimize code in both SQL Server and Snowflake• Research and document Tableau Server and Desktop system requirements and create PowerShell and Batch scripts to test Tableau feature upgrades for the Analytics Applications team• Conduct User Acceptance Testing (UAT) for the Analytics Applications team, document results, and partner with the team to address any enhancement or upgrade issues• Use tools such as SSMS, Snowflake, Visual Studio, SSRS, Tableau, TFS w/ Azure DevOps, and the data catalog to analyze, transform, import, export, synthesize, and visualize data acquired from various databases utilizing either SQL Server or Snowflake• Collaborate interdepartmentally to request escalations and deployments on behalf of the BIA and Analytics Applications team• Update data catalog entries for various tables to support data governance initiatives• Collaborated with the dental department analyst to support the external dashboard registration process which utilized row level security conditional access policies to provide data maskingAccomplishments:• Developed an automated solution for managing Tableau licenses, installing software, and activating the LBLM feature and then collaborated interdepartmentally to deploy this solution via SCCM• Created an automated solution using PowerShell to import standard Tableau workbook templates and update registry paths using recursive lookup• Implemented and tested row level security use cases for external facing Tableau dashboards within the FIDO Web UI utilizing Gatekeeper security conditional access policies for data masking, and built and presented a row level security PowerPoint presentation for the BIA team

Portland, Oregon, United States

• Consult with customers to understand business challenges, gather requirements, and recommend improvements to business systems to enhance their workflow• Collect data exports, analyze them to identify ways to improve procedures, and reduce costs by eliminating unnecessary licensing and fee-based services• Create Excel workbooks, charts, graphs, tables, and pivot tables to analyze data outliers using exports from Active Directory, ShoreTel Director, and various vendor portals • Manage client relationships by addressing escalated issues, resolving problems, and sharing feedback with team members and leadership to improve customer experience• Document, update, and enhance Service Desk procedures and processes in the internal Knowledge Base• Use PowerShell to export data from Active Directory and generate comparative analysis spreadsheets to determine why customers were experiencing software challenges and identify solutions• Mentor junior staff members on how to resolve incidents, problems, and requests escalated for Service Desk Tier III resolution• Configure SQL ODBC connections to enable MS Access, Cactus, Quality Reporter, and other business systems to interact with SQL databasesAccomplishments:• Coordinated the execution of a co-term agreement with a preferred vendor to improve the predictability of our IT department budget• Established a method to validate ShoreTel data against Active Directory data, reducing wasteful spending on inactive accounts and saving $18.8k in unnecessary licensing costs• Developed a method to validate cellular data against Active Directory data, reducing unnecessary service fees and saving approximately $13.2k annually

Portland, Oregon, United States

• Entered data into ServiceNow and vendor portals, used data exports to perform comparative analyses and locate missing IT Assets• Collaborated with a distributor to manage the assignment and recovery of IT AssetsAccomplishments:• Devised an offboarding asset management procedure that clearly defined how to reclaim IT assets from offboarding employees• Established a method to calculate IT asset burn rates, safety stock needs, and highlight inventory gaps utilizing Excel spreadsheet formulas in conjunction with distributor data exports

Portland, Oregon, United States

• Windows 10 migration project

Portland, Oregon Metropolitan Area

• Designed procedures and flow charts to support processes and optimize workflows• Managed group projects using Teams planner boards to track deliverables, timelines, and resources• Presented status updates to IS Leadership and C-Suite members utilizing metrics captured from Jira exports and visualizations captured from Tableau dashboards• Produced incident response procedures, e-mail templates, and supporting documentation for the Service Desk to bolster uniformity and training• Generated critical incident reports to identify opportunities for preventing downtime• Investigated, analyzed, and recommended resolutions for customer issues and established project requirements through partnerships with customers, team members, and management• Forecasted Service Desk project budgets based upon anticipated workload• Led biweekly problem reviews and weekly incident and request reviews to identify and resolve roadblocksAccomplishments:• Pioneered the Service Desk Knowledge Base to reduce team ticket count and enhance employee onboarding• Spearheaded weekly Jira ticket review process which led to a 40% reduction in tickets older than 7 days

Portland, Oregon Area

• Configure SQL ODBC connections to enable MS Access, Cactus, Quality Reporter, and other business systems to interact with SQL databases • Developed and maintained procedures, RACIs, swim lane diagrams, standards, and knowledge base articles to support workflow design in ServiceNow• Provided insights into ITIL best practices surrounding Incident, Problem, and Change Management• Orchestrated major incident response efforts by owning escalations, engaging resources, and communicating outage notices along with hourly status updates until issue resolution• Identified root-causes of major incidents by collaborating interdepartmentally, audited change logs, and presented opportunities for improvement during the major incident post mortems• Conducted Change Advisory Board and Major Incident meetings• Provided license assignments and custody changes for Tableau, Articulate, and Smartsheets• Presented status updates to IS Leadership to illustrate KPIs and performance observations utilizing metrics, measurements, graphs, and pivot tables based upon phone and ticket queue data exports• Collaborated with customers regarding issue escalation requests and investigated, analyzed, and engaged resources• Partnered with Information Security to identify and produce the procedures & workflows necessary to mitigate riskAccomplishments:• Negotiated with vendors for a $12K rebate to upgrade 110 cellular devices, and reduced plan costs by nearly $7K• Redesigned IT asset tags resulting in $3500+ worth of recovered assets

Portland, Oregon, United States

• Configured, deployed, maintained, diagnosed, and performed custody changes on computer workstations, VDIs, laptops, tablets, printers, cellular devices, VOIP phones and supplemental computer and telecommunications equipment• Resolved incidents, problems, and requests submitted to the Service Desk• Acted as Subject Matter Expert (SME) for building security system, cellular devices, and PaloAlto Traps• Generated Shoretel Agent accounts, assigned queues, enabled workgroup integration, and installed software• Performed workstation and phone adds, moves, and changes in concert with facilities staff and vendors• Resolved device assignments and custody changes for laptops, tablets, desktops, and cellular devices• Coordinated interdepartmentally for DB backups and snapshots, submitted change requests, and performed updates on our PaloAlto Traps server and 750 Traps endpoints• Collaborated with Systems Engineers on selection of and changes to Citrix VDI backend systems• Fielded onboarding and offboarding of employees• Completed workstation and phone adds, moves, and changes in concert with facilities staff and vendors • Mentored junior staff members on how to resolve incidents, requests, assign IT assets, and manage projects• Generated Nice Contact Center Agent & Supervisor Accounts, assigned queues, and installed agent software• Provided IBM SPSS, Adobe, and various other software license custody assignments and changesAccomplishments:• Helped coordinate and execute 750 workstation moves during building remodel• Migrated 350 workstations from CO remote access to Citrix VDA• Redesigned our asset tags resulting in $3500+ worth of recovered assets• Devised and executed a plan for consolidating cellular accounts to reduce the number of invoices Accounts Payable needed to process• Produced and published SharePoint forms and workflows to assist with employee onboarding and offboarding

Hackensack, Nj

• Consulted with customers to identify business challenges, gather requirements, and design workflows for physical forms. Used this information to develop digital forms and workflows in SharePoint, then conducted coordinated UAT efforts with customers• Diagnosed and resolved issues with Failover Clusters and SQL Databases to restore server functionality• Configured SQL ODBC database connections to enable Crystal Reports, B2W Explorer, and other business systems to connect with SQL databases• Develop batch files, xml files, and executable files for use in SCCM Deployment packages• Created and distributed SCCM deployment packages, deployed software updates, and scheduled patchesAccomplishments:• Created, managed, and deployed Windows images for over 350 endpoints• Developed SharePoint solutions for managing Leave of Absence requests, check requests, subcontractor contract statuses and reviews, and material purchase orders

Piscataway, Nj

• Researched and developed new methods, programs, and procedures for equipment testing• Mentored junior team members on diagnosing and repairing IT equipment• Created and managed diagnostic computer images• Updated daily, weekly, and monthly Excel reports to track team progressAccomplishments:• Led a QA process that reduced laptop failures by about 40%• Developed laptop diagnostic images and bootable CDs using batch scripting, which streamlined testing for over 2,000 laptops and tripled our team's output

Bachelor Of Science, Business Administration, 4.0 Gpa

Associate'S Degree, Networking - Telecommunications Systems Technology, 3.58 Gpa

Activities and Societies: Member of Phi Theta Kappa Honor Society Writer / Features Editor for the School Newspaper

High School Diploma