Patrick Pepper Email & Phone Number

Wheat Ridge, CO, US

Denver, Colorado, United States

Monitoring daily jobs for completion and removing errors generated by the error logs through the use of SalesConnect, Salesforce, Workbench and MS SQL. Python script development for SQL, data cleansing, Excel editing automation along with webscaping Salesconnect and Mutual Fund data.Ad-hoc reports and data pulls utilizing Salesforce reporting and Tableau.

Denver, Colorado, United States

Experience with Agile SCRUM sprints used to track user contributions and pinpoint workflow bottlenecks during the documentation, data collection, conversion and upload processes used to plan the modernization of current legacy data. My team is working on gathering data so it can be loaded to T-SQL databases, which will be further optimized for querying.

Centennial, Colorado, United States

• Data validation and escalation of corrupt/incorrect data utilizing direct partnership with data engineering team – most recently involving missing customer contact name information
• SQL (Teradata / Presto) Query development and upkeep structured to stay current with monthly and adhoc market strategies
• Telemarketing list management used for outbound sales teams created with a combination of SQL queries and data cleansing using Python 3.7 scripts with Spyder 4.0.1 IDE
• Translation of marketing strategies into viable SQL queries to extract usable data to fulfill sales team requests for lists used in high-level outbound targeting methods including outbound calling, direct mail, ad.
• Contributor to market strategy meetings to cover any potential gaps or questions that arise regarding counts of potential prospects or availability of data
• Automation constructed with Python language to process and compile multiple Excel files into a single source for reporting to remove duplicate values to ensure data quality. Secondary data bins created and used for.

Centennial, CO

• Facilitated projects to provide analytics on tickets produced by Tier I repair team and how they are resolved. I have found trends that I have brought to my supervisors' attention and have built a few decks for them to.
• Spearheaded a revenue recovery project related to overuse of LTE networks for our backup internet service which led to over $1,000,000 recovered in annual lost revenue due to overage payments to business partners.
• Normal job duties included: repairing internet, voice, and security based issues through a ticketing system using advanced techniques, systems and knowledge beyond the normal scope of troubleshooting that Tier I is.
• Awarded in Q4 2019 for implementation of Tableau Dashboards, Excel Pivot Report Automation, Training Creation and Meeting Organization to provide data analysis and tools to the Tier II team outside of normal job scope.

Centennial, Colorado, United States

Inbound help desk to support co-workers with on-call training and assistance

Centennial, Colorado, United States

• Inbound call center for businesses
• ISP troubleshooting | telecom troubleshooting
• Awarded for excellence in Customer Service and being in the top 10% for metrics

Denver, Colorado, United States

Installation and repair of consumer car electronics | Extremely knowledgeable in understanding automotive assembly blueprints, 12 volt blueprints, and basic electrical theory - not limited to Ohm's Law, electrical interference troubleshooting, and noise isolation. MECP Certified between Aug 2013 - Aug 2017