Steven Herrera Email & Phone Number

• Analyzed over a millions rows of data relating to Oracle's customer engagement• Created a mock-up interactive tool that provided personalized experience for customers visiting Oracle website• Heavy use of R and Tableau for exploratory analysis

Paso Robles, Ca

• Structured and analyzed data with 150 variables to find cost saving strategies for the firm, using analytical tools like R, SAS and Tableau• Assisted with Survival Analysis to better predict the lifespan of parts that led to a decrease in replacement costs• Delivered a management presentation and a written report with tactics to increase profitability and sustain existing customers

10960 Wilshire Blvd. Los Angeles, Ca

• Supervise staff on contract compliance audits of major film studio accounting systems on behalf of clientele including entertainment unions, actors, producers, directors, investors & co-financing studios.• Act as primary contact with film studios to facilitate transmission of accounting data and contend potential misreporting issues in accordance with studio/client contracts.• Review staff methodologies for data cleansing and transformation.• Utilize data visualization in Microsoft Excel to effectively identify major revenue and expense sources.• Review staff methodologies of sample selections based on high risk reporting assessments. • Utilize data summarization in Microsoft Excel to effectively communicate internal performance metrics, propose audit fee budgets and provide insights to individuals at all levels of management.• Propose and review valuation methodologies for unauthorized activity. • Maintain internal staff task log and external studio correspondence logs. • Review draft and final audit reports for clients and studios.

Los Angeles, Ca

• Monitor, investigate and audit major motion picture and television studio accounting systems on behalf of clientele of which include actors, producers, directors, investors & co-financing studios participating in film production.• Review clientele/studio agreements for potential revenue & expense deviations from stipulated agreements.• Reconcile and conduct analytical testing of all revenue and expense general ledgers provided by studios including making sample selections, determining sample size according to trends and potential risk and reviewing studio transactions for any fraudulent or unauthorized activity.• Work closely in adversarial relationship with studio executives.

Sony Pictures Entertainment

• Create financial statements and perform detailed analysis of participant (actor, producer, director, and investor) income statements. • Review, implement and research initiating agreements between studio and participants. • Critically analyze performance projections of major motion pictures and television programs then cross-reference projections with actual income statements in order to resolve interpretive issues with Legal and Business Affairs. • Prepare ad hoc reports and special calculations at the request of Directors. • Work closely with multiple departments to provide and receive financial products, creating a greater understanding of the interconnection of business functions.

Master Of Science - Business Analytics, Business Analytics

• Database creation and management • Data modeling and visualization methods • Real world collaborative industry projects with Oracle.

Bachelor Of Science (B.S.), Business Administration

Triple major with concentrations in: • Finance, Real Estate and Law • Management • Operations Management

Cpa Education Fulfillment, Accounting