Wake Technical Community College - Accounting
Financial Analyst at Cisco
Computer Networking
Ericka
Tapia, MACC
Knightdale, North Carolina
Highly motivated and result driven professional with experience in country enablement, project management, business financial analysis, as well as accounting. People oriented manager with the ability to train, empower and lead a team and build long lasting business relationships across all levels of an organization. Currently pursuing PMP certification wtih expected date of July 2015
Sr. Accountant / Sr Financial Analyst
Worked on different projects for clients such as INC Research and Tribune Media.
• Assist in preparation and analysis of monthly and quarterly financial statements including variance explanations.
• Prepare monthly journal entries including accruals, adjustments, and reversing JE’s
• Prepare monthly account recons, identify and resolve issues.
• Track, review and reconcile P-card and T-card activity
• Assist with internal, external and SOX audits.
• Adhoc analysis and special projects.
• Intercompany accounts reconciliation (consolidations). Doing research to find out reason for variances and find the necessary support to make entries to fix variances between accounts. (Multi-currencies)
• Make the necessary JE’s to adjust for FX gain/loss,
• Drive meetings with upper management to explain entries and find a solution for other inexplicable variances.
• Project reconciliation. Reconcile the finance aspect of the project teaming with PM's and other business controllers. Make process improvements to have a seamless close of project to ensure timely payment or billing to sponsor.
• Track project during close process, and make the necessary month end entries to reflect current position on the P&L
(Key accomplishments: made process improvements by automating spreadsheets with macros and complex functions)
Data Analyst
- Data Analyst for Employee Business Ops Team.
- Liaison, strategist and business intelligence developer delivering insight into business trends.
- Assess, measure, streamlining and improving each service by GSA.
- Consultant for the business area assigned.
- Create reports for different services of the business and offer expertise based on data analysis.
- Process improvement coordinator.
- Prepare and present data trends to upper management.
- Partner with finance for analysis and recommendations for upper management.
- Monthly accruals.
- Budget forecast.
- Enter and track headcount allocations in Apptio in order to prepare costing reports for leaders.
-Work on financial projects such as Vendor costing management, adhoc projects and reports.
Accounting Lead Cisco Capital Mexico
• Part of the team leading the country enablement team for Mexico. Country enablement function such as research of business requirements, process improvements, BRD, partnerships with cross-functional teams such as Tax, Operations, Project management, Legal, Business managers, and outside vendors, systems testing.
• Onboarding new vendors through our internal channels.
• Project manager for the accounting phase of the project, including BAT/UAT testing in system conversion.
• Participated in management consulting engagements with Senior Project manager, defining and refining strategy; in particular focused on processes, procedures and IT testing and results.
• Co-wrote the CSC Mexico playbooks with processes and procedures.
• Responsible for creating the FAS157 leasing report and gathering the information to renew CA lender’s license.
• Month end close activities. (Create journal entries, top sided entries, account reconciliation, Income statement, P&L, Balance sheet & Trial balance) ad-hoc reporting.
• Analysis between US GAAP and International GAAP (Mexico)
• Mitigated risk factors through analysis of financial and statistical data. Anticipated and managed change effectively in rapidly growing global business environments.
Participated in revenue model project for the Cloud.
(Key accomplishments: Recipient of award for completing the CSC Mexico project by deadline and under budget)
Partner Relations Manager
• Work in partnership with the sales team to ensure they meet the commit goals.
• Reporting and forecasting funding for sales team.
• Review potential deals from sales to ensure accuracy and proper documentation.
• Prepare all required standard and approve non-standard documents (Red line contracts).
• Responsible for providing timely and accurate metrics
• Train sales in leasing procedures as needed.
• Reduced days sales outstanding (DSO) by 20% both by process improvements and increased communication.
• Provide internal/external customer support as appropriate.
• Contribute to special projects (documentation and process improvements)
• Audit lease schedules to ensure accuracy & ensure data integrity.
• Reconcile schedules according to the pricing scenario to ensure proper funding of partners.
(Key accomplishments: Created forecast reports and status reports for management and sales in order to track deals and ensure quickly turn around. Increased lease and loan activations by 25%)
Financial Analyst
Ericka worked at Cisco as a Financial Analyst
Adjunct Professor of Accounting
- Teach Managerial accounting
- Prepare lessons and exams
- Grading
- Prepare projects for students to complete for grade
Senior Accountant
•Responsible for reconciling liability accounts.
•Month end procedures such as journal entries, accruals, pre paid expenses.
•Account Receivables (full cycle) and collections.
•Keep track of fixed assets and depreciation.
•ADP payroll for 63 employees.
•Send all appropriate reports to benefits such as 401k, FSA.
•Setting up new employees and their benefits/deductions in the payroll system.
•Classify and reconcile operating and capital leases.
•Organize and implement new procedures to improve workflow for accounts payables department. (around 600 payables a month)
•Trained staff in accounts payable procedures such as coding invoices in the right accounts, and organization.
•Calculate monthly sales commissions for 12 sales personnel.
•Bank reconciliation for 14 bank accounts.
•Reconciliation of deferred revenue account.
•Reconcile books for UK office that closed down.
•Ad-hoc reporting (commission analysis, sales trend analysis, project cost analysis)
Teach children of middle school age from low income families my experiences as a professional, skills and inspire them to stay in school. The program allows professionals to inspire children and teach them that education is a great tool in order to better their future.
MACC
Accounting
Masters in Accounting
Doctor of Education (Ed.D.)
Organizational Leadership
Currently working on this degree.
BBA
Finance
Business Administration with a concentration in Finance