Senior Financial System Analyst Resume
New York, NY
SUMMARY:
- Seeking a challenging Business oriented position in NYC area to utilize my qualifications.
- Proficient in creating business processes templates and supplying required deliverables .
- Excellent interpersonal communication skills with both business and technical individuals to apply proper information technology tools.
TECHNICAL SKILLS:
Web Design Software: Adobe Photoshop, Microsoft Front Page, and Dreamweaver, and HTML
Database: SAS, Word Perfect, MS SQL Server, Excel, Access, Lotus, Paradox,Visible Analyst
Software: Deltek Costpoint, JAMIS, People Soft, DELPHI, PRISM, Tableau, Hyperion, Cognos, APXConnect,SCMS, Proact, ZipOffice, Microsoft Project, Rational Rose, Microsoft Visio Studio, ShipSmart, JD Edward, Primavera and QuickBooks
Language: HTML, UML, .NET (ASP, VB)
Operating System: Windows and MS DOS
PROFESSIONAL EXPERIENCE:
Senior Financial System Analyst
Confidential, New York, NY
Responsibilities:
- Perform financial and expense comparisons to Confidential ( Confidential ) contracts
- Review budgets using actual performance, previous budget figures, estimated revenue, expense reports, and other data sources to control funds and provide proper financial administration
- Perform multiple financial cost analyses functions, including cost allocation, setting up cost control systems, collecting data, controlling costs and preparing reports that maintain the customer's cost accounting system
- Ensure that costs are allocated according to established procedures.
- Apply principles of accounting to analyze financial information and prepare financial reports
- Formulate and execute the Operations (OPS) and Facility and Equipment (F&E) budgets
- Review vendor invoices and create spend plans for task orders to support Confidential Contracts
- Monitor project costs and budget cost and ensure all project related costs are processed and recorded accurately in the Spend Plan
- Analyze financial data, develop budget tools and forecasts and provide over - burn and under burn analysis to the Program Manger
- Provide budget tool to client to keep track of excess fund and return to the program at the end of final invoice
- Support month-end close process and assist in revenue recognition and revenue adjustment
- Work with Finance Manager and Program Manager to produce monthly financial reports
- Process invoices for subcontractors and work with AP to ensure payments to the subs
- Respond to vendor inquiry, and process RFQ, PA and PR as needed
- Build various databases for clients to provide excess funds, price information, and etc
Senior Financial System Analyst
Confidential, Rockville, MD
Responsibilities:
- Prepare Budget Tool and Dashboard.
- Lead finance communication to the client
- Deliver spend plans for contracts that include actuals, estimates to complete, estimates at complete
- Monitor travel expenses ensuring that GSA requirements have been met
- Responsible for monthly, quarterly, and annual forecasting along with variance analysis and real time risk and opportunity assessments
- Responsible for department overhead budgeting, management, analysis and reporting
- Communicate regularly and effectively with program manager, functional peers (contracts, subcontracts, FP&A, etc) and functional management
- Responsible for leading proposal efforts on program and other competitive and noncompetitive efforts as needed
- Provide support to Confidential ( Confidential ) Budget Analysis
- Deliver accounting best practices recommendations for budget tracking to client
- Construct Budget Tool with actual, planned and pipeline structure
- Build Entity Relationship Diagram (ERD) Data Model and submit to developers to build Budget Tool for Confidential and develop SQL queries
- Develop Use Cases for each of the front ends of the solution
- Assemble user Guide for the development team and list known user names
- Construct front-end data entry interface in Microsoft Visio to manage spend annotation, labor invoice annotation, travel spend annotation for developers
- Implements and enforces security for all of the Oracle Databases
- Troubleshoots with problems regarding the databases, applications and development tools
- Build excel dashboard into Tableau to create initial main accounting dashboard
- Briefed new staff to contract as needed and provide Risk Management to identify risk and ways to mitigate
- Facilitated weekly meetings with PM and GO Team colleagues to provide status of the contracts
- Maintain knowledge of corporate accounting policies & standards; ensure proper authorization and transactional support, adhering to all published schedules
- Provide status of contracts to the clients, workspace leads, and upper management on a daily basis/as needed
- Oversee the full cycle of the contracts until they are briefed and fully executed
- Served as Admin for PBS share drive to give access to other staff
- Researched excess charges and prepare and manage MWAs to alleviate risk
- Prepared assigned financial reports, including variance analysis and explanations
- Reviewed financial implications of initiatives, ensuring availability of budget; prepares financial analysis reports in support of new initiatives and projects
- Identified ways to automate processes, minimizing manual intervention and increasing efficiency
- Served as a liaison between the PM/Client Staff and the GO Team to resolve suspense items, missing time sheets, TIAs, and etc.
- Provided resource and financial management solutions, including budget formulation and execution, accounts payable and receivable, general ledger, and financial reporting and reconciliation
Project Controller/Financial Analyst
Confidential, Arlington, VA
Responsibilities:
- Performed a wide variety of analysis.
- Worked with Confidential and/or Navy financial management and accounting practices
- Performed reconciliation of daily and monthly transactions and reconciliation
- Involved with reconciliation/validation of monthly payments and obligations in STARS-FL
- Prepared accruals, revenue adjustments, risk funding authorization requests, and monthly financial reports including funding and unbillable data
- Prepared monthly and ad-hoc program analysis of billings, financial forecast changes, and adjustments for Army contracts
- Reviewed and edited requirements, specifications, business processes and recommendations related to proposed solution
- Responsible for various financial functions such as budgeting, auditing, forecasting and analysis.
- Briefs program/project budget estimates/projections, shortfalls, over-runs, funding types, etc.
- Maintained documented records supporting financial forecasts used in the rate and budget area
Financial/Business Analyst
Confidential, Rockville, MD
Responsibilities:
- Provided financial decision-making information by accumulating material, material overhead, applying standard costs to proposed products and actions; and identifying and analyzing variances as needed.
- Performed construction product line analysis recommended by the side engineers.
- Prepared Business Process Models from conceptual to procedural level.
- Gather analyze, document, validate and maintain business, functional and approach requirements.
- Utilized requirements gathering techniques to evaluate ingredient problems (i.e. interviews, requirements analysis etc.) and generate traceability matrices
- Worked collaboratively with production manager to evaluate technology solutions.
- Exposure to full production life cycle from inception to delivery of products.
- Developed appropriate strategies for project implementation
Accounting Analyst
Confidential, Bethesda, MD
Responsibilities:
- Processed accounts payable, accounts receivable, and maintained reconciliation of all advances.
- Recorded and balanced actual cash received against the sales report from the retail management systems and point of sale system on a daily basis. Reconciled invoices through PeopleSoft.
- Monitored A/R, billing, payment and regulation; analyzed data; and wrote reports of findings.
- Consolidated monthly financial results and prepared summary presentations to management.
- Enhanced and develop financial reports using JDEdwards Report Writer and Microsoft access.
- Responsible for account reconciliation, A/R reconciliation, journal entries, month end, and monitoring compliance with accounting policies and internal control procedures for these financial entities.
- Manage reconciliation of bank accounts for assigned division(s) and necessary entries to properly reflect this activity, utilizing the software programs currently in use.
Student Aid Analyst
Confidential, College Park, MD
Responsibilities:
- Assisted in coordination of calculating, awarding, and packaging aid for all students of the campus.
- Responsible for management’s tracking funds, monitoring allocations, verifications of files, exit and entrance counseling.
- Coordinated events with admissions office for presentation of financial aid information to prospective and new students.
- Organized teacher evaluation process and provided assistance in special event preparations.