Technical Consultant, Data Integration
Finance - San Francisco, CA (2015)- Web Analytics: To help drive improvements in the online customer experience and engagement, our team delivered enhanced web data and analytic capabilities via Teradata Aster and AppCenter. Utilizing the Aster nPath function, we performed pattern matching of web traffic data to find common paths to revenue-generating actions on the customers website.-Data Quality: Provided data integration support to a data science team tasked with modeling the customer's website event counts. Using the past 365 days of web-event data, the team used statistical modeling to predict the expected web-event counts for any given day and allowed client to react to changes in customer online behavior more efficiently and find ETL and website errors before data is moved downstream. -Email Surveillance: Worked with an Aster data science team to build a process that followed a basic flow of preparing, classifying and cleaning a collection of email messages to permit the execution of a simulation of business rules against each email(find emails that have illegal content according to business/federal rules). Emails were brought into Aster from Hadoop, cleansed(removal of "noise"; spam, images, signatures, etc) processed against the list of rules, and then saved into permanent tables for subsequent reporting. Retail - San Francisco (2015-2017)-Data integration into Teradata to support and provide foundation for finance reporting related to customer order management.-Migrate Ab Initio ETL process from Oracle to Teradata. Worked with business and 3rd party vendor to understand customer transaction data, business requirements, SLA's and automated job scheduling.