Penn Whipple Email & Phone Number

Marietta, Ga, Us

Atlanta Metropolitan Area

Atlanta Metropolitan Area

Executed maintenance of existing data pipelines, including ETL procedures and functions related to loading, transforming, auditing, reporting, and programming of multiple relational databases. Worked with existing and new customers to gather requirements and information for new data needs. Handled intake of datasets from disparate sources including flat files, CSV RDMS, FTP, XML, and applied data mapping, hygiene, and normalization to customer records. Automated ETL processes using PERL, Shell Scripting, and Python. Participated in stand-up meetings twice a week.Key Contributions:◼Migrated national consumer database with 280M+ records and 150 data elements/columns to existing data platform◼Developed Python ETL tool that collects data from 24+ different data sources totaling 30TB/day ◼Developed weekly and nightly batch jobs and sent real-time email with audit/data quality log, reducing time by 50%◼Cleansed and standardized 500+ million records of data monthly, increasing data reliability and performance

Atlanta Metropolitan Area

Provided analysis, quantitative insight, and data management using Base SAS, SAS Macros, and PROC SQL. Test, document, and implement predictive models including applications to predict response, conversion, loss, and retention. Worked closely with modelers to determine model requirements and gathered data necessary for model build analysis. Executed updates to data sources, while adapting to changing business requirements and providing guidance, monitoring, and performing ad hoc requests.Key Contributions:◼Developed and maintained national “Invitation to Apply” marketing database for 170M+ households ◼Utilized SAS and Bash scripting to successfully integrate disparate data from multiple sources including flat files, FTP, relational databases, and delimited files from consumer household, real estate, and modeled data sources ◼Documented issues and resolutions for data projects, ensuring 100% alignment to project requirements ◼Played a lead role in developing and implementing a Credit Predictor model that was released 2 months ahead of schedule and was based on household assets certain zip 4 level credit data to predict a household’s creditworthiness ◼Audited source files from 8 clients and 5 vendors to check for and communicate data inconsistencies using SAS ◼Developed a Promotion History database in SAS to track 1M monthly direct mail promotions for a high-profile client◼Created a SAS macro to automate the update process and write out the data set to a flat file and create a file layout, saving 50% of the time to update and create the file

Atlanta Metropolitan Area

Provided data analytical services in support of audits as well as a variety of consultative services such as healthcare compliance, telecommunications, and energy. Utilized technical and analytical skills with business process knowledge to enhance the quality, usability, and availability of information. Responsible for gathering and condensing datasets for analysis. Continuously identified inconsistencies with reporting and dataset analysis. Key Contributions:◼Developed a SAS program using Base SAS, Proc SQL, and SAS Macros to simulate business rules which resulted in identifying $100K monthly in revenue from payphone calls◼Developed SAS code to parse, scrub, strip and standardize data to identify anomalies in employee data and reduce bottlenecks in reporting◼Reconciled general ledger balances to journal entry line items under the Statement on Auditing Standards No. 99◼Conducted analyses in SAS to identify trends, unusual activity, and possible fraudulent activity within journal entry data

Atlanta Metropolitan Area

Developed, maintained, and utilized analytic and marketing information databases and data warehouses to provide customer-centric analysis and leverage database services to achieve business objectives. Translated data language into actionable insights, utilizing a combination of marketing analytics, strategic vision, and advanced statistical modeling techniques, enabling the quick creation and analyzing capabilities within marketed segments. Key Contributions:◼Designed and developed SAS programs to produce customer-oriented reporting and analysis which provided up to date insights to predict customer churn ◼Managed data migration across 6 multiple systems while ensuring data quality and accuracy using SAS◼Designed and developed Brio front end reporting applications using SAS/DB2 back end for 200+ users◼Provided leadership in the development, delivery, and utilization of analytic learnings and standardization of performance metrics that allowed for increased reliability of customer insights ◼Earned IBM team player and performance award (July 2002)

Master'S Degree, Information Systems Management

Bachelor Of Arts - Ba, Psychology