Senior Financial Analyst, Fp&a - Network Security Resume
Columbia, MD
SUMMARY
Project Leader with over 10 years’ experience in financial, accounting, sales, and marketing data analysis and reporting in midsize and large companies across multiple industries. Possess strong quantitative and analytical skills. Experienced in improving efficiency and accuracy of the financial planning and analysis by simplifying and standardizing processes and automating reports. Acquired managerial and communication skills through leading projects, working on cross - functional teams, and interacting with all levels of management.
AREAS OF EXPERTISE
- Financial planning and analysis
- Trending and dissecting P&L
- Budget / forecast management
- Cost accounting
- Bookings, revenue and margin forecast
- Capital budgeting
- Reporting processes improvement
- Financial modeling
- Monthly close process support
- Project management
TECHNICAL SKILLS
- Fluent in English, Russian, and Ukrainian
- Proficient in Microsoft Office (Word, Excel, Access, PowerPoint), Minitab, SPSS, QlikView, Oracle, and SAP BusinessObjects
- Familiar with using Microsoft Project, JDE, Khalix, and Hyperion Essbase
- Familiar with market data reports (NPD, GfK, IDC)
PROFESSIONAL EXPERIENCE
Confidential, Columbia, MD
Senior Financial Analyst, FP&A - Network Security
Responsibilities:
- Managed projects on bookings, revenue, and gross margin forecasting.
- Worked with cross-functional teams driving the requirements to assure data accuracy and consistency in the organization.
- Created and implemented a roadmap to streamline the bookings forecast in Oracle’s Demantra demand planning tool.
- As a result, the process time was decreased from 8 to 4 hours.
- Established controls in the process resulting in better forecast accuracy.
- Analyzed P&L trends and identified the drivers of gross margin change.
- Managed royalty reporting.
- Worked with business partners on royalty contracts and payments.
- Audited internal reports to identify missed payments.
- Conducted financial modeling and reporting related to acquisitions.
Confidential, Columbia, MD
Senior Financial Analyst, FP&A
Responsibilities:
- Worked with 10 business unit heads to develop a detailed $200 mill+ annual operating budget for 12 departments to help the company set and achieve financial goals.
- Implemented a standard Excel model to plan and track project and headcount costs, which resulted in increased expense forecast accountability, accuracy, and visibility.
- Designed a process to compare actual expenses to projections, analyze the variance, and communicate risks and cost reduction opportunities to the executives.
- Reconciled accounting data and determined use of appropriate methods to correct discrepancies to assure accurate representation of costs and revenue recognition.
- Built financial models and dashboards to present the KPI trends and new product launch sensitivity analysis to the V- and C-level executives.
- Developed a lean process to track and trend domestic and international product sales for multiple years.
- Streamlined sales data analysis and performance metrics reporting by creating and managing Access database, Excel PivotTables and Dashboards.
Confidential, Austin, TX
Cost Benefit Consultant, PMO - Sales Process Re-engineering Program (SPReE)
Responsibilities:
- Analyzed the process maps for the 5-year $260 mill SPReE Program and identified the major steps in standardizing business processes and IT infrastructure.
- Developed a business case to analyze and summarize NPV of IT and business costs and benefits of the SPReE Program.
- Presented the information to the executives and led discussions about the program’s risks, costs, quantitative and qualitative benefits.
Confidential, Lexington, KY
Senior Business Analyst, Global Sales & Marketing
Responsibilities:
- Managed projects to report the key performance indicators and ISD’s financial position to the executive management team, Global Sales Operations, Business Development and Marketing departments.
- Developed reports tracking sales and distribution trends of over 40 models of printers with $200mill global annual revenue by retail channel and by account in 5 geographic regions of the world (GEOs).
- Used by executive management to adjust the global manufacturing, inventory, selling and pricing strategy.
- Created and implemented standardized performance reporting processes in North and South America, Europe, and Asia Pacific, which centralized and improved global reporting accuracy, consistency and efficiency by 50%.
- Established relationships and served as a key communication person with sales and marketing management in 5 GEOs.
- Conducted price competitive research and P&L analysis, and worked with Product Managers to build price roadmaps and adjust pricing strategy in 5 GEOs.
- Developed a regression model that identified the top 10 features driving the price of inkjets based on the voice of customer.
- Product managers used the model for 2011 multifunction printer portfolio development.
- Developed business cases to plan partnership strategy.
Confidential, Lexington, KY
Financial Analyst, Toyota Business Unit
Responsibilities:
- Improved the accuracy of sales forecasts, resulting in better inventory planning.
- Simplified inventory count process by creating an Access database which replaced an Excel-based tracking tool.
- Analyzed costs to identify potential savings.
- Worked on streamlining bOm analysis to increase efficiency.
Confidential, Boston, MA
Research Analyst, Assessing Department
Responsibilities:
- Developed multiple regression models for the valuation of 50,000 condominium stock in Boston, which brought money in the form of property tax dollars to the city budget.
- Developed methods for forecasting property tax revenue.
- Created and ran reports to identify errors in property characteristics and sales data to provide accurate property assessment and, as a result, save city’s spending on court hearings.
- Designed an original report to reduce time for property sales data verification by 30%, thus, improving assessors’ productivity.
- Managed interns to enhance their contribution to the work of the department.
- Assisted property owners in their understanding of property valuation issues.