Patrick A. Email & Phone Number

Phoenix, Arizona, United States

Solon, Ohio, United States

Document requirements for provisioning and migrating data sets to Azure Data Lake. Data assets were provisioned for projects involving SRM, Trade Promotion Optimization and Strategic Pricing. Responsible for creating a process that harmonized third party data sets to integrate them with internal data hierarchies at a 97% level which serves as the foundation to integrate many data sets for SRM program. Write articles and document data descriptions in Data Catalog prior to technical and business launch. Present several topics to Data Stewardship Council to build consensus for data processes.

Solon, Ohio, United States

Cleveland/Akron, Ohio Area

Responsible for gathering data from Nielsen and IRI every 4 weeks and maintain a SQL repository for syndicated data. Create and publish data source in Tableau that shows multi year trends of Nestle and competitor products including price elasticies. Run advanced process in SQL combining trade promotions cost data and Nielsen/IRI syndicated data to produce ROI for individual trade promotion events. Supply critical data sources to external vendor for development of Trade Promotion Optimization solution.

Akron, Oh

Gather the tagging requirements necessary for Omniture implentation. Build large data sets of raw log data collected from Coremetrics and Omniture to be used for routine reporting and ad hoc analysis. Develop a report that shows how gross sales fallout (cancellations, fraud rejections, discounts,returns) that shows both the delta between gross and net sales and as well as how much in sales remains open compared to last year.. Create the process for generating email lists for the Credit Marketing Initiative.. Conduct many ad hoc analyses to identify areas of opportunity or trouble shoot problems in data collection.

Akron Ohio

Responsible for documenting the attributes of leading ecommerce websites and identifying areas of opportunity for Signet's ecommerce websites. Create Exectutive Ecommerce Dashboard to identify the performance of KPIs related to the ecommerce business. Created hybrid direct mail and email campaigns to test the effectiveness of sending direct mail alone vs. sending direct mail and email.

Akron, Oh

Conduct demographic analysis related to potential new store locations using GIS and generate sales forecasts. Present findings to Real Estate Committee.

Cuyahoga Falls, Oh

Conduct Geographic analysis and produce maps for various clients to help improve sales territory alignments, select store and shopping center locations, and improve targeted marketing based on areas with the most potential clients. I also conducted MapInfo and Map Point training sessions.

Wooster, Oh

Digitize geographic features such as roads, water bodies,and cities from satellite imagery. Became responsible for the QA/QC for other employees to ensure accuracy prior to the submission of the data to the client. Develop SQL queries to enhance the QA/QC process.

Master Of Arts (M.A.), Geography, 3.7 Gpa

Bachelor Of Arts (B.A.), Geography, 3.8 Gpa

Activities and Societies: Gamma Theta Upsilon, Golden Key International Honor Society, Geography ClubGraduated Summa Cum Laude