Sr.specialist Resume
Irving, TexaS
Education
Master of Business Administration in Finance and Accounting .
EXPERIENCE
Confidential,Irving Texas
Sr. Specialist - Financial Planning & Analysis August 2005 to Sep 2012
- Finance & Reporting Administrator for CT T360, primary responsibilities include making sure all the financial codes are correctly populated by users for example, Cost/Budget Center, Account Code, Business units and Project code. Financial /Accounting codes are updated accordingly due to employee movements within legal department; new hires, retirement, mergers, spin offs.
- Ad hoc reporting/data analysis using, MS SQL and several other reporting tools like Info Maker, in order to complete complex analysis and reporting.
- Expert in writing complex SQL queries to fetch the data from large Datawarehouse.
- Generated Financial, Sales, Marketing and Custom reports using Excel, InfoMaker and other Business Intelligence tools.
- Validated Reports by running the SQL against Relational and Multidimensional Database.
- System Administrator for Advanced Invoice Management System & Matter Management system used by over 400 Legal employees, including Attorneys, Paralegals, Budget & Finance Employees.
- Interface Administrator for People Soft 8.4, responsibilities includes sending daily payment files via secured protocol, correction of errors in People Soft/SAP/GTEAMS, generating daily report, reconciling, and sending the packet to VSO Interface team, Employment Benefit group, Discontinued Operation, Real estate groups, etc.
- Monthly report generation from various applications and re-conciliation with SAP, Hyperion Essbase, People Soft and other Verizon application for different workgroup Leaders including SVPs, VPs, Directors, Managers, Practice Area Leaders, & Corporate Finance team.
- Lead in Legal Invoicing Application Vendor selection.
- Trouble shoot, data synch errors between applications, and continuous analysis of base queries based upon the department needs.
- Responsible for authorizing/updating approval authority limits according to hierarchy changes, or changes in CPS 103(Corporate Policy Statement).
- Complex pre-submission daily analysis of interface and payments files.
- Train new Attorneys, Paralegal, Assistants, and Legal Secretaries In person & via e-web.
- Update of workflow according to the various moves in Legal Department, mergers, spin offs, retirements, and new hires.
- Prepare financial documents/summaries of yearly time surveys (Common Cost Allocation) required for yearly allocation to business units.
- Completed four years reconciliation of A/P data with vendors A/R, cleaned up activity and implemented procedures for duplicate invoice refunds, and payment of unpaid invoices.
- Written and implemented procedural manual for Verizon Legal Department – Budget & Finance group.
- Process Return to cash/refund checks, Re class of Outside Counsel Fee, Travel, and A/P expenses to correct Budget Center/Dept id, project codes etc.
Confidential,Tampa FL
Contractor -Verizon COMMUNICATIONS – Sprint PCS – Yash ENTERPRISES.
Financial Planning Analyst – Business Analyst
April 2003 to August 2005
- Interviewed managers and users of the system to get a full understanding of requirements
- Documented process flows of as-is and to-be system
- Uncovered a business process improvement opportunity and presented it to managers for a solution
- Created test cases for system testing and UAT testing
- Interfaced with various groups that include Business requirements team, System testers, UAT testers, and Integration testers
- Created user procedures and training manuals
computer skills
Solid working experience in Law Pack (Legal Matter Management System), AIMS (Legal Invoice Management System), CT T360 (Invoicing System), PeopleSoft 8.4, SAP, LAWSON, ESSBASE, G-TEAMS. MS SQL Server, Info Maker, Crystal Report, MS Office particularly MS Excel, Outlook, Access, HSS, DM (Document Manager), MS Office, Lotus Notes. Etc.
Member of OSCPA and AICPA – Planning to appear for CPA in 2013. Currently taking refresher courses at Univ. of Dallas