As member of the Operational Health Reporting Team (OHT) assisted in defining reporting activities, defining new data sources and analysis activities as it pertains to all middleware assets for patching, configuration and end-of-life products. • Subject matter expert on source data loaded into the Operational Health Team reporting data-mart. • Consulting with business partners to clarify and define requirements and/or trouble-shoot reporting issues.• Lead the effort of identifying impacts to reporting while transitioning to the ServiceNow platform.As member of the Analytics Platform Reporting Services (APRS)• Support reporting related to the product lifecycle, patch ,configuration management, and vulnerability management of 3rd party software products within Wells Fargo Technology Center.• Key projects o Retirement of current reporting database and transitioning report to new APRS databases.o Transitioning current Alteryx reporting into automated SQL based reporting.

• Supported Wells Fargo as a Database Analyst within the Operational Health Reporting Team (OHT) within the Middleware and Platform-As-A-Service organization. This team is responsible for producing aggregated analytical reporting of Middleware configuration inventory, version patching and end-of-life activities.o Instrumental in the design and development in standing up a SQLServer Reporting Database for use in compliance reporting of Wells Fargo Assets.o New report development utilizing Alteryx, SQL and SSIS o Analysis activities in researching new data sources, trouble-shooting reporting and inquiry requests.o Supporting SSIS/SSRS developers in managing data loads, processes, understanding data sources and managing roadblocks.o Agile/Kanban development

Supported the Marketing Analyst at the DEG Crown Center office assigned to the Hallmark Cards account in addition to supporting Data Scientists and Managers within the Insights & Analytics Department at Hallmark Cardso Maintain and Support the Retail Estimate and Purchase Diary System.  Alteryx processes for loading and cleaning Purchase Diary Data and loading to Teradata. Heavy Interaction with 3rd Party data provider to ensure accuracy of data provided for the Purchase Dairy. Maintaining SAS based processes, Teradata tables and views and responsible for all table management Processing Purchase Diary Survey data using Alteryx workflows and creating Tableau files to load into Tableau Server.o Pulling data out of the Hallmark System and executing Analytical Modelso Developing, maintaining Teradata tables & views, SAS, and Alteryx processes and creating simple Data-marts.o Support the Marketing Analyst at DEG assigned to the Beauty Brands Account in loading and report development of Beauty Brand Data from SqlServer tables residing on a Cloud Server using SSMS/SSIS. This also involved development of store procedures.o Developing and processing reporting requests against the Consumer Marketing Database for Analysis and creating Pivot tables and Data Marts when necessary.o Teradata, SQL, SAS, SSMS, Alteryx

Supported the Marketing Analyst at HSB Marketing that was assigned to the Hallmark Cards Account.o Pulling data out of the Hallmark System Consumer Marketing Database and creating ad-hoc reports, pivot tables using Microsoft Excel, data marts and reusable data stored processes to aid in Marketing Analysis. o Managing large and working with large data sets and database tableso Developed standardize reusable processes for pulling and gathering various consumer level, demographic, purchase transaction history and other key consumer data and creating data files to be sent off for statistical modeling. In charge of running the developed model analytic SAS code and loading the results to a consumer modeling score table for Analysis.o Re-engineered Hallmark’s Consumer Purchase Diary and Industry Estimate system to utilize Teradata. The current system was all SAS programs and files. The new process is now much more manageable,the data is more visible and available for analysis.o Creating various Alteryx processes and workflows to read, cleanse and load various data files in varying formats to Teradata for Analysis.o Lead initiatives with high-levels of risk and complexity to deliver what the client needed on-time and within budget.

Worked with a team of Teradata developers working on sustainment releases for the IGC system. The sustainment releases addressed fixing production issues, adding more functionality and process improvements. • Assisted in the effort to redesign all the ETL code templates and processes to reclaim database space in addition to giving them the ability to restart based where the failures occurred, thus shortening the process down-time.• Provided support in trouble-shooting common database issues.• Required obtaining DOD Full Secrete Clearance and Passing of CompTia Security Exam.

Projects Contributions Assignment Hallmark Cardso Teradata Relationship Manager Upgrade to release 6. Due to my extensive Hallmark experience in the DatabaseMarketing Group, I assisted in the upfront Analysis on processes affected, and did a majority of the design, coding and testing to convert key processes and necessary table conversions.o Retailer Customized Marketing initiative. This project provided Hallmark Retailers a web based tool to market to their consumers. I performed all the backend Teradata database work such as writing all the necessary database queries for the online interfaces.o Gold Crown Card Loyalty program. A redesign effort tasked with making the Gold Crown program a tier based program. I was responsible for table design and ETL processes to populate new the Teradata Data marts.

I worked on the Teradata warehouse for the Integrated Data Environment (IDE)/Global Transportation Network (GTN) Convergence, or IGC system. The IGC system replaced DLA/USTRANSCOM’s – Global Transportation Network (GTN) in Aug 2011. I played a key role in the development, design and prototyping of the ETL SQL templates for processing and loading data to the data warehouse. • Developed various Teradata stored procedures to: execute ETL procedure code, automatic build out of database views and a process for backing up/restoring military exercise/simulation data and databases. • Required obtaining DOD Full Secrete Clearance