Business Analytics Finance Consultant In Los Angeles Ca Resume Nelinia Varenas

Transcript

Nelinia Varenas MBA Business Analytics Finance Consultant with Expertise in Financial Applications Development ______________________________________________ Long Beach | CA | 90804 Telephone 310.650.0725 [email protected] __________________________________________________________________________________________ SUMMARY Over 13 years experience in finance and accounting, including:        Financial software application design, development, user acceptance testing, implementation, and administration Financial software installation and configuration Financial reporting, modeling, planning, and forecasting Project and process management and leadership User interface development End-user training Application documentation/technical writing Experience in a variety of industries, including:         Aerospace and defense Automotive financial services Commercial real estate Computer peripherals Electronics Gaming Software development Sports apparel and equipment Certifications:    IBM® Certified Developer - Cognos® Financial Statement Reporting (FSR) IBM® Certified Developer - Cognos® TM1® IBM® Certified Specialist - Cognos® TM1® Data Analysis TECHNICAL SKILLS         IBM® Cognos® Financial Statement Reporting® 6.6 development and implementation IBM® Cognos® TM1® 9.5 and 10.1 development and implementation IBM® Cognos® Express 9.5 development and implementation Perform ETL via ODBC connection, SQL script or data dump (data extraction, transformation and load) MS Excel 2003, 2007 and 2010 MS PowerPoint MS Word MS Access Nelinia Varenas MBA   Visual Basic for Applications (Excel) Various ERP systems (Hyperion Financial Management, Hyperion Essbase, SAP, Oracle, Business Objects) FUNCTIONAL SKILLS       Manage monthly reporting and forecasting cycles, communicating closely with the Accounting, Information Technology, Project Management, Cost and Profit Centers, and Executive departments. Manage annual planning/budgeting cycle, communicating closely with the Accounting, Information Technology, Project Management, Cost and Profit Centers, and Executive departments. Perform financial and key performance metric analyses Manage, prepare and present executive review packages Create business valuation and pricing models Prepare IT statements of work PROFESSIONAL EXPERIENCE AVIANA GLOBAL TECHNOLOGIES, Brea, CA -- Senior CPM Consultant (2010-2013) Provide business analytics consulting and leadership services for the following external and internal clients: VIZIO, Irvine, CA The purpose of the TM1® project was to develop a dynamic TM1® price modeling application that is tightly integrated with VIZIO’s price forecasting system using SQL scripts. The TM1® solution provides a powerful vehicle to methodically maintain product baseline data and assumptions that feed the price modeling process. Users interact with the TM1® application primarily through smart Excel interfaces with Action Buttons and VBA logic that trigger TurboIntegrator processes that, in turn, perform ETL processes, guide workflow and navigate between workbooks. Simulation and what-if scenario building are core features. WESTFIELD AMERICA, Los Angeles, CA The objective of the TM1® project was to develop and automate the detailed multiyear budget upload and generate Excel reports for the regions and national tenants by shopping center and leased space. Visual Basic, TM1® and Excel coding provided the required functionalities and radically shortened the template and report delivery timeframes. GOLDEN STATE WATER COMPANY, Ontario, CA The objective of the Cognos® Express project was to design and develop a collaborative workflow planning solution for the annual budget process. The solution was designed to be reliable, accurate, stable, flexible, and scalable. The solution can be integrated with future systems and can be adapted to support future financial and performance initiatives. NIKE EMERGING MARKETS, Beaverton, OR Aviana partnered with IBM® TM1® developers on this project designed to speed data flow in a predictable and controllable manner, leveraging efficient cube design and IBM Cognos® TM1® TurboIntegrator. End-users interact with the solution via Long Beach | CA 90804 | Tel 310.650.0725 Page 2 Nelinia Varenas MBA compelling and intuitive Excel interfaces designed to reliably collect and aid in the effective analysis of periodic forecast and planning data. THE COSMOPOLITAN OF LAS VEGAS, Las Vegas, NV While Excel workbooks captured the business logic and enabled a degree of flexibility, as the business grew in complexity and as management demands for timely and reliable information increased, the Cosmopolitan’s need for a costeffective solution became paramount. Cognos® Express was built to provide the desired process-driven budgeting and forecasting system that enables greater collaboration, along with enhanced reporting and analysis capabilities. DIRECTV, El Segundo, CA With the implementation of TM1®, increasing efficiencies in collecting, analyzing and sharing selected P&L and G&A forecasting and planning information, including variance comments, throughout the enterprise was a primary objective. The TM1® system drove data integrity and reliability, promoted consistency across the enterprise, and shortened the time needed to query and analyze financial information. CB RICHARD ELLIS, El Segundo, CA The design of the IBM Cognos® TM1® 10.1 planning solution drives reliability and standardization throughout the budgeting process with an eye to reasonable performance, positive user experience, appropriate controls, and tight security accesses. The TM1® planning solution ultimately provided capabilities that were previously performed by many legacy applications. AVIANA GLOBAL TECHNOLOGIES, Brea, CA  Developed the TM1®-based Quick Close product The Quick Close product was developed to provide a set of rapid deployment tools to allow finance departments to comfortably meet period-end reporting deadlines. Quick Close enables automated currency conversions, allocations, eliminations, and consolidations. It also provides detailed logs and audit trails to satisfy audit requests.  Developed TM1® Resource Planning Model to Improve Company Profitability The Resource Planning Model was designed to improve company profitability by providing management visibility into the fully burdened cost of resources compared to billable rates. The Resource Planning Model’s ultimate objective was to optimize project profitability by creating the optimal mix of resources.  Developed TM1® Project Staff Planning Model to Optimize Staff Capacity The Project Staff Planning Model was designed to increase the efficiency of the project staff planning process for existing projects as well as future projects. Gaps in staffing may be identified early in the staff allocation process so that additional resources may be on-boarded to avoid staff shortages or misallocation of staff. Long Beach | CA 90804 | Tel 310.650.0725 Page 3 Nelinia Varenas MBA BELKIN INTERNATIONAL, Compton, CA -- Senior Financial Analyst (2008-2010) Lead forecasting, financial reporting, budgeting, and analysis functions for global corporate headquarters. Design and consolidate executive review packages. Provide advice related to key business drivers to the Global Shared Services and Executive Management teams. NORTHROP GRUMMAN, Redondo Beach, CA -- Reporting Analyst (2004-2008) Administrator and lead internal consultant of Cognos® Finance application for Space Technology Sector, serving 100+ users. Process monthly data loads via ODBC connections and SQL queries. Coordinate with Accounting and Information Technology departments. Assure Cognos® Finance compliance with the Sarbanes-Oxley Act. Serve as subject matter expert for migration from Cognos® Planning to SAP R3 ERP. VOLT TECHNICAL, Torrance and Orange, CA -- Financial Specialist (2002-2004) Provide financial expertise, leadership, oversight, and support related to budgets, forecasts, business models, pricing, sales incentives, capital investments, cash flow, and cost allocation for client companies, such as Toyota Financial Services, Epson and Northrop Grumman. Analyze and communicate financial impacts of capital investments, price movements, incentives, and price protection. LUMOS TECHNOLOGIES, Santa Monica, CA -- Senior Financial Analyst (2000-2002) Prepare and lead the presentation of GAAP compliant and pro forma financial statements and variance analysis reports. Develop financial planning policies and procedures and implement their continuous improvement. Develop sales and client databases to manage revenue collection. Create financial models for business, valuation and product planning purposes. Submit corporate sales and use tax repots, foreign corporate registrations and other mandatory business filings. CB RICHARD ELLIS, Torrance, CA -- North America Financial Analyst (1999-2000) Lead and manage bottom-up and top-down operating and capital planning processes involving all branch offices in North America. Develop user guides and resolve issues. Create budget reporting packages for the Vice President of Financial Planning. Manage monthly forecast cycle. Prepare key performance and ad hoc analyses to guide the executive team. Present financial results. EDUCATION     Bachelor of Science, Child Development, University of California, Davis Master of Science, Child Development, University of California, Davis Master of Business Administration, Finance & Accounting, University of California, Davis Certificate of Financial Planning Course Completion, College of Financial Planning Long Beach | CA 90804 | Tel 310.650.0725 Page 4