EDUCATION

University of California at Berkeley
B.A., Architecture May 2007

PROFESSIONAL EXPERIENCE

Waterfront Media, Brooklyn, NY
Revenue Analyst | August 2008 – Present

• Created a Visualforce page, tracking in real time the sale status of unique-per-year custom packages, allowing Sales Development to see which packages were sold, outstanding, open, and conflicting with an already sold package
• Formulated a more nuanced strategy minimizing the discrepancy between third party delivery and DFP/DSM buffering, recognizing the default buffer method was wasting inventory
• Using Salesforce Apex, developed triggers and business logic to parse meaningful information; read DSM line item data to separated revenue types (media, custom solution, roadblock, email, sponsorship, etc) into different months that rolled up into the total revenue, making the pipeline a real-time one-click exportable excel file
• Incorporated a split revenue pipeline taking into account shared sales campaigns
• Developed classes and triggers in a controlled testing environment before deploying to production, assuring they functioned within Apex governors and limits
• Set field-level validation rules to mitigate human error and field-level security to control access to specific fields
• Reconciled monthly billing reports using various data sources; caught and fixed errors in line item placement, delivery, and human error, to save, prevent future loss, and recover large sums of money; reduced the discrepancy from about 10% to less than 5%, saving the company on average $300,000 each month
• Recreated the existing Opportunity structure for a separate, newly acquired company pipeline with similar but unique business logics, triggers, and workflows
• Reconfigured the Insertion Order (IO) process within the overall sales process to better track, document, and locate important contract information, allowing multiple parties from different physical locations to easily access information; integrated Salesforce approval process to digitize the IO process, direct the flow of information and attention to the necessary end parties, and make accountable parties involved, complying with Sarbanes-Oxley rules; documented and created work flow map of process
• Set up multiple system workflows that updated end users with relevant information; notification informing sales people, their planner, and vice president that an opportunity at a certain probability was set to begin and informing them to move it back it wasn’t going to start soon, ensuring an accurate pipeline; notification informing client services and traffickers when a double signed IO was uploaded into Salesforce
• Integrated the sales and finance process of the credit check into the overall workflow; used DFP’s credit controls to regulate line item reservations and Salesforce’s notification workflow to inform the finance team of upcoming opportunities with clients of unknown credit status
• Served as business analyst and system administrator for the integration, configuration, customization, migration, testing, and training of Salesforce, DART for Sales Mangers (DSM), and DART for Publishers (DFP)
• Collected detailed requirements from stakeholders, including sales people, sales planners, client services, ad operations, finance, and business intelligence, and reconfigured overall workflow to meet their needs
• Configured Salesforce, DSM, and DFP; improved business metrics by setting up custom fields, workflows, and triggers; compiled relevant data into one system (Salesforce) for easy information access
• Created line-item-based pipeline report based on DSM line item data, resulting in a more accurate monthly revenue distribution; used straight-lining method for alternate cases
• Assisted with data restructuring and cleanup effort; maintained data integrity across all three systems
• Trained users, fielded requests, led troubleshooting efforts, and optimized systems based on user feedback
• Worked with third-party developers (DoubleClick, Echo Lane) to test systems, discovering deficiencies, reporting defects, and requesting enhancements often affecting all third-party clients
• Wrote detailed user and system administrator guide

Satellite Housing, Berkeley, CA
Administrative Assistant |  February 2008 – March 2008, May 2008 – July 2008

• Systematized records for new affordable housing developments
• Standardized archives for the Development, Finance, and HR departments
• Provided support for a ground breaking ceremony, including seating arrangement, area preparation, and photographic documentation

Mal Warwick, Berkeley, CA
Development Assistant | March 2008 – May 2008

• Administrated direct mail fundraising for national foundations, political organizations, and nonprofits
• Processed and recorded donation data for multiple fundraising campaigns

Oakland Unified School District, Oakland, CA
Administrative Assistant | January 2008 – February 2008

• Screened public school enrollment records for implementation of school choice program; placed students in appropriate Oakland elementary, middle, and high schools.
• Verified and compiled documentation (birth certificates, transcripts, residential status, immunization records, custody etc.)
• Processed student application data into school enrollment records

Asian Art Museum, San Francisco, CA
Customer Service Representative – Museum Store | September 2007 – February 2008

• Explained significance of various museum store pieces (ceramics, paintings, prints, etc.) to patrons as it related to current and past exhibitions
• Arranged displays of store merchandise

Lisa Solomon Studio
Art Studio Assistant | September 2007 – December 2007

• Organized schedule for upcoming events and deadlines for grants, submissions, residencies, and fellowships
• Mounted and installed exhibitions
• Scanned, photographed, and framed artwork to be displayed for web-based, print publications, and exhibitions

Public Safety & Transportation, University of California
Special Events Assistant | April 2004 – February 2005, May 2007 – December 2007

• Ensured safe and efficient environment for patrons and pedestrians by directing the flow of traffic during major sporting events and concerts
• Mediated patron complaints regarding delays and limited capacity
• Provided friendly customer service, directing hundreds of daily visitors to the U.C. Berkeley campus
• Facilitated financial transactions and processed parking ticket

University of California Office of the President – California Policy Research Center
Assistant | June 2005 – August 2006

• Reconciled financial ledgers to attain a balanced budget
• Organize records for internal database

ADDITIONAL

• Cal Habitat for Humanity Member (2004 – 2005)
• Lee F. Fallman Memorial Scholarship (2006)

SOFTWARE

• Microsoft Office
• Microsoft Excel
• Adobe Photoshop
• Adobe Illustrator
• Salesforce
• Working knowledge of Salesforce Apex Code
• Working knowledge of Visualforce