Analytic Process Automation: Subject Matter Expert. Assessed the completeness of a KYC population across multiple lines of business by building Alteryx workflows with unique logic interpreted from instructions within LOB procedure documents. Built and maintained a PII scan tool with Alteryx workflows. The tool was able to read multiple file types for key PII search words/phrases. Translated laborious, manual Excel reporting into automated Alteryx workflows. Data Visualization: Advanced aptitude with Tableau. Built dashboards for large financial services group which tracked data quality metrics on their Salesforce site. Built change management audit trail dashboard highlighting movement of financial remediation issues. Designed and created multiple dashboards to monitor and analyze data for campaigns which were responsible for producing millions of dollars of revenue for a Software as a Service (SaaS) technology company.

•Manage, build, schedule, deploy, test, optimize, QA, and analyze Carbonite’s promotional & operational campaigns from testing to production.•Build filters to target and segments lists by making use of Carbonite’s marketing database structure.•Optimized database queries and communication cadence to increase customer retention by 10% over 2015.•Developed a strategy to increase trial conversion and subscription renewal of our small business client accounts.•Generated promotional campaigns (among a team of 3 analysts) that garnered $15 million of revenue in 2015.•Constructed all automated and operational communications from product launch through client retention for a new cloud/on-site backup business solution.

•Reduced manual effort of Operations Team by 94% by developing a process to consolidate the processing audits of over 100 distinct files into one Excel document.•Identified and archived four terabytes of obsolete data across 100 client-facing tables. •Built documentation and managed multiple test cases for a data mart redesign affecting over 13,000 tables and 70 terabytes of data.•Collaborated with cross functional teams to build new automated and improved processes on the overall solution to decrease future manual efforts.•Evaluated data requirements for existing and new analytical projects and addressed areas for improvement.•Supported client as well as internal teams with emergency requests and workarounds where appropriate to meet business needs.•Functioned as sole Systems Analyst for all enhancements related to the analytic data mart for over 12 months. •Validated, documented, and tested a statistical report which calculates the variation and standard deviation of 150 dynamic, incremental tables. •Lead internal status meeting which oversaw all development projects related to the analytic data mart. •Trained new Business Systems Analysts on the technical applications of the UNIX Operating System.