Patricia Huie Email & Phone Number

San Mateo, Ca, Us

Foster City, California

Foster City, California

Manage loyalty programs at Visa

BI Consulting and Support on MicroStrategy Projects

Work closely with marketing managers to translate business requirements into technical specifications and turn data into valuable insights • Design and build self-served MicroStrategy reporting dashboard for the marketing analytical team and provide end user documentation and training.• Develop extract/transform/load (ETL) processes to integrate Oracle data warehouse with MicroStrategy. • Setup and configure MicroStrategy Intelligence Server and MicroStrategy Narrowcast server. • Manage MicroStrategy user accounts, licenses, project security and database connection setting.• Monitor and gather statistics on report usage using MicroStrategy Enterprise Manager.

Generate marketing performance reports and provide data-driven business insights to optimize online marketing campaigns • Provide technical expertise on tracking and capturing marketing campaign data for analysis.• Collaborate with US marketing campaign and metrics managers to design and execute acquisition, retention and customer engagement campaigns across all marketing channels (Yahoo! Network, Email, Off-Network and SEM channels).• Partner with international marketing campaign managers across the globe to define standard metrics and analytical models for Y! Messenger and Y! Personals.• Utilize MicroStrategy, SQL, Perl, Shell scripts and Excel to extract Yahoo! customer behavioral data for analysis follows with actionable recommendations and valuable findings.• Automate recurring analytical reports using Perl and Shell scripts to perform data extraction and utilize Excel VBA to produce complex graphical presentation.

Software Engineer III Develop Server-side Java and Perl application.• Implement a scheduler with load balancing capability using TIBCO Hawk and RV to manage multiple Linux clusters with 100+ machines. • Develop and maintain an in-house data loading java application to insert and update records to a terabyte Oracle database with very well-toned SQL queries.• Follow software development cycle to create functional documents based on customer needs (MRD/PRD) and generated technical design documents.Software Engineer II - Team Lead Manage a team of five in a 24x7 Production group to provide services on direct email marketing campaign.• Administrate complex project scheduling, capacity/resource planning and implementation.• Act as a mentor to the team and evaluate their performances.• Provide business technical consultation to clients and be the escalation point.• Generate Oracle SQL scripts and Stored Procedures to increase the performance on data access.• Write PERL scripts to optimize the data manipulation process for a terabyte Oracle database. • Became a Power UNIX user in vi and shell scripting.