Paul Maddy

***** * ******* ****** **, New River, Az. 85087

480-***-****

ad4ifb@r.postjobfree.com

www.linkedin.com/in/paul-maddy

Professional Summary

Results-oriented SAS Developer and Data Analyst with over 15 years of experience in the IT industry. Proven expertise in financial, risk, marketing, and healthcare domains. Organized and dependable team player, skilled in managing multiple priorities with a positive attitude. Adept at taking on additional responsibilities to meet team goals.

Skills & Abilities

Programming Languages & Tools:

SAS, SQL, Unix Shell Scripting

Oracle, Teradata, Mainframe DB2

SAS EG (Enterprise Guide), PC SAS, SAS DI Studio, SAS Management Console, SAS Admin

SAS Grid, LSF Process Manager, Cron Tab

Linux & Solaris, Jira, Indigo, FileZilla, Putty

Microsoft Office (Excel, Word, PowerPoint), Tableau

DMS (Document Management Services), Customer Remediations, IRMT, WordPress

Professional Experience

Professional Development and Education Pursuit

July 2023 - January 2024

In response to a layoff in June 2023, I proactively utilized the subsequent period for professional development and education. During this time, I dedicated myself to advancing my skills in data management and analytics through intensive coursework.

Key Areas of Focus:

Azure Data Studio Essentials: Acquired essential skills for data management and analysis using Azure Data Studio.

Microsoft Azure Synapse for Developers: Gained expertise in developing solutions using Microsoft Azure Synapse Analytics.

Skill-Up in Tableau: Strengthened proficiency in creating impactful visualizations for data-driven decision-making.

SQL: Strengthened proficiency in SQL.

This deliberate investment in learning not only addressed the challenges posed by the layoff but also reflects my commitment to staying current with industry trends and technologies. I am excited to leverage these updated and newly acquired skills in contributing to innovative and impactful projects, showcasing resilience and adaptability in the face of career transitions.

Analytics Consultant

Wells Fargo Dec 2022 – Jun 2023

Developed SAS proc SQL programs for field logic checks, collaborating with business-unit leaders.

Utilized Jira, IRMT, Indigo, DMS, Excel and SAS for Customer Remediation.

Conducted data analytics quality control reviews, ensuring code alignment with business requirements.

Provided analytics expertise and troubleshooting, maintaining security and confidentiality.

Sr Consultant

CVS Nov 2017 – Aug 2022

Implemented SAS code to streamline department processes, enhancing efficiency.

Automated performance guarantee satisfaction surveys using SAS, SAS Proc SQL, SAS Macros, Excel, and Unix shell scripting.

Developed a new sample survey driver program for all performance guarantee surveys.

Top Two Projects:

Project 1: Automated Performance Guarantee Surveys

Leveraged SAS, SAS Proc SQL, and SAS Macros to design and implement an automated system for performance guarantee satisfaction surveys for Customer Care.

Successfully transitioned survey frequency from weekly to daily, streamlining the process and enhancing data timeliness.

Automated survey deployment to Qualtrics, ensuring seamless and timely data collection.

Demonstrated expertise in SAS tools to optimize workflow and improve survey efficiency.

Project 2: Development of Sample Survey Driver Program

Engineered a robust sample survey driver program using SAS and macros to manage performance guarantee surveys.

Implemented comprehensive data quality control checks within the survey process, enhancing data accuracy and reliability.

Introduced a new level of efficiency in handling performance guarantee surveys, reducing errors and improving reporting accuracy.

Showcased proficiency in SAS programming and macro development to drive process improvements and ensure data integrity.

Ensured security and confidentiality of PHI, PII, and sensitive data in accordance with HIPAA regulations and company policies.

Web Developer

Wayne’s Web Design Apr 2017 – Sept 2017

Provided front-end website development using WordPress.

Optimized websites for speed, scalability, and security.

Demonstrated expertise in SEO processes.

Senior Services Delivery Analyst

American Express Jun 2016 – Mar 2017

Investigated and resolved application issues on Big Data Platform.

Developed onboarding engagement model for Big Data applications transition to DevOps.

Automated manual support work, monitored infrastructure health, and provided metric reporting to Leadership.

Played a key role in investigating and resolving application issues on the Big Data Platform, contributing to effective Root Cause Analysis (RCA) practices.

Developed a standardized onboarding engagement model for Big Data applications, facilitating a smooth transition to the DevOps support team and ensuring operational efficiency.

Collaborated with development and infrastructure teams to implement alerts, dashboards, and monitoring tools, enhancing infrastructure and application health reporting for improved availability.

Ensured high availability of all applications through comprehensive end-to-end monitoring, proactively identifying and addressing potential issues.

Collaborated on the automation of manual support tasks, streamlining workflows and reducing manual intervention for improved efficiency.

Worked collaboratively with cross-functional teams to provide support in troubleshooting, minimizing service interruptions and ensuring smooth operations.

Conducted weekly team meetings to boost the support team's knowledge around Big Data applications, fostering a continuous learning environment.

Implemented metric reporting mechanisms, delivering insightful reports to management for informed decision-making and continuous improvement.

Lead Developer

American Express Aug 2006 – Jun 2016

Engineered task automation by developing intricate shell scripts on Solaris and Linux platforms, optimizing operational efficiency.

Executed complex SQL queries, extracting data from Oracle, Teradata, and DB2 databases on the mainframe, showcasing versatility in database management.

Upheld security standards and ensured data integrity within the SAS DataMart, contributing to a reliable and secure data infrastructure.

Identified and addressed data issues promptly, directing concerns to business unit leadership when necessary, showcasing a proactive approach to problem-solving.

Designed, developed, tested, and implemented SAS programs for extracting card member data, showcasing proficiency in end-to-end program life cycles.

Enhanced efficiency by updating, modifying, and expanding existing SAS programs, utilizing SAS macros to streamline coding processes and reduce repetitive routines.

Spearheaded data cleaning initiatives, analyzing and eliminating duplicates and inaccurate card member data, ensuring data accuracy and quality.

Leveraged various SAS procedures for Extracting, Transforming, and Loading (ETL) data into a SAS DataMart, ensuring data consistency and reliability.

Scheduled programs and shell scripts in crontab and LSF Process Manager for the Linux SAS Grid production system, optimizing workflow and task execution.

Managed and provided training for a team of 4 offshore production support personnel, serving as a Subject Matter Expert (SME) for 95% of production processes and data sources.

Top three projects:

Project 1: Database Migration for Enhanced Efficiency

Spearheaded the initiative to migrate SQL data extractions from Oracle to Teradata, successfully eliminating a redundant database source.

Implemented seamless data transition, optimizing extraction processes and enhancing overall system efficiency.

Demonstrated expertise in database management, contributing to streamlined operations and improved data access.

Project 2: Automation of Risk Data Extractions

Redesigned, tested, and automated the weekly risk data extraction process from a web application to a daily mainframe data feed.

Utilized SAS and Unix Scripting to create an efficient, error-free system, eliminating the need for manual extractions.

Significantly increased data accuracy and reduced processing time, enhancing decision-making capabilities for risk analysis.

Project 3: Migration from Solaris to Linux Platform

Played a pivotal role in the migration of SAS code using SAS DI Studio, data, shell scripts, and production schedules from Solaris to the Linux platform.

Collaborated effectively with team members to complete the migration within a remarkable 3-month period.

Instrumental in the decommissioning of the Solaris system, showcasing adaptability and efficiency in managing large-scale platform transitions.

Ensured a smooth transition with minimal disruptions, contributing to overall system modernization and improved performance.

Initiated and meticulously documented all production processes and data sources in a comprehensive spreadsheet, providing a valuable reference for future system maintenance and troubleshooting.

Education

LinkedIn Certificate Courses:

Azure Data Studio essentials

Microsoft Azure Synapse for developers

Skill-Up in Tableau

Glendale Community College, Glendale, AZ

Computer Science

ITT Technical Institute, Phoenix, AZ

Associate of Applied Science, Computer Science

Contact this candidate