Manager Project

Summary:

. ** + years of experience in Finance and IT departments

. Proficient in prioritizing and completing tasks in a timely manner

. Reliable, hardworking and dedicated team player who works well under

pressure and with minimum supervision

. Highly motivated, self-starter and quick learner

. Consistent record of exceeding expectations

. Excellent communication and documentation skills

Education:

. MBA in Accounting / Finance (Osmania University, INDIA) - GPA: 3.53

Credentials Evaluated by World Educational Services,

http://www.wes.org

. One Year Diploma in Computer studies, Oracle 8.0 Course and Java

Programming Course

Technical Skills:

. MS Word, Excel, Access and PowerPoint

. MS Performance Point Server, SharePoint, Lotus notes

. Cognos 10 (CAF, Query Studio, Report Studio and Enterprise Planning)

. SQL, Dynamic GP (Great Plains), FRX, Quick Books, J.D. Edwards

. Hyperion Essbase and Analyzer

. Knowledge of HFM, Smart view, Oracle Financials and SAP

. Strong Knowledge of SDLC (Software Development Life Cycle), BI

(Business Intelligence), Data warehousing and ETL process

Work Experience:

Northern Trust - Business Analyst / QA Analyst (Consulting)

Oct 2013 to Present

. Work with business on facilitating requirements, analyzing and

documenting them

. Coordinate with project manager, developers and QA manager on

requirement feasibility analysis

. Schedule and facilitate requirement analysis meetings

. Participate in detailed technical design review meetings

. Serve as liaison between developers and business

. Perform unit testing prior to integration / system testing

. Develop test cases and test scripts based on Business Requirements

. Execute test cases, document test results and log defects into defect

tracking system

. Front end GUI testing to test the usability of the reporting

application

. Write SQL Queries in TOAD to retrieve data from tables for back end &

report data testing

. Extensive use of excel to compare data using vlookups and for manual

calculation based on business rules to validate reports

. Perform regression testing, smoke testing during dry run and post

migration testing

. Coordinate with the users about UAT testing, analyze user questions

and log defects as needed

. Work with offshore QA by assigning tasks and provide training as

needed

. Conduct defect review meetings and work with developers on fixing the

defects

Arthur J Gallagher - Sr. Financial Analyst (Consulting)

Nov 2012 to May 2013

. Support monthly and quarterly management reporting by providing

reports throughout the ledger close process.

. Maintain large inventory of Cognos-based financial reports on a

monthly basis. Oversee nightly data refresh activities performed by

offshore team. Troubleshoot and update reports as needed for changing

business/reporting requirements. Work closely with IT team on data and

report changes.

. Support annual budget. Assist with budget application (Cognos

Enterprise Planning) and monitor corporate cost centers. Responsible

for creating reports for budget review meetings and presentations

Responsible for validating data loads performed by IT.

. Work on special projects. Prepare ad hoc analysis and reports to

senior management.

. Converted several reports from old COA (Chart OF Accounts) to new COA.

Medical Staffing Network - Financial Analyst Oct

2007 to Oct 2012

. Responsible for annual budgeting for 90+ branches across the country

with $300M in revenue.

. Support regional VP's and branch managers with budget inquiries and

operational reports

. Manage budget application (MS Performance Point Server) as a System

Administrator

. Calculate Branch manager and Staffer/Scheduler bonuses

. Assist in monthly accounting close process

. Prepare monthly and quarterly Financial reports such as P&L statements

. Prepare weekly Flash reports and Minidash reports for senior

management and field

. Analyze financial information and provide recommendations to

management for decision making purposes

. Perform actual vs. budget analysis and provide explanations to

variances

. Research and respond to inquiries regarding financial issues

. Prepare ad hoc financial reports for senior management

. Participated in implementation of new budget tracking system (MS

Performance Point Server) by providing business requirements, writing

test cases and performing UAT

AC Nielsen - Financial Analyst (Consulting) Oct

2006 to Sep 2007

. Prepare and distribute monthly / weekly Financial reports

. Research and respond to inquiries regarding financial issues

. Perform financial analysis and provide explanations to variances

. Assist in developing budgeting and forecasting

. Participate in month end close process by reviewing financial results

AC Nielsen - Bonus accrual project (Consulting)

Apr 2006 to Jun 2006

. Prepared Excel spreadsheets to summarize bonus structures

. Designed databases in MS Access

. Developed several queries and macros to calculate employee bonuses

. Prepared documentation

Collins Consulting - Accountant Jan

2005 to Mar 2006

. Billing

. Full cycle Accounts Payable

. Collections when needed, helping payroll when needed

. Consultants termination audits, maintaining active consultants

worksheet

. Completing additional projects as assigned by controller

Boise Office Solutions - Accounts Payable Analyst (Consulting)

Sep 2004 to Dec 2004

. Handling vendor calls about payment status and schedules

. Researching vendor statements / charge backs and resolving past due

invoices

. Preparing internal adjustments

. Calling Vendors for missing invoices from the open receipts reports

Bruce Offset, an RR Donnelley Company - Accountant (Consulting)

Aug 2004 to Sep 2004

Matching, coding, entering invoices, filing, Sales order entry, preparing

spreadsheets and helping the staff accountant as needed.

Summit Marketing - Cleaning open orders project (Consulting) Jun

2004 to Jul 2004

Researching open orders and finding out the reason for an order not being

billed. Calling vendors for the missing invoices, processing them and

making sure the order gets billed. Working with sales persons and vendors

with any pricing issues and getting them resolved.

Summit Marketing - A/P coordinator (Consulting) Sep

2003 to May 2004

Handling vendor calls about payment status and schedules, researching

vendor statements and resolving incorrect invoices, resolving pricing

discrepancies by contacting vendors and internal sales persons, vouching

high volume Invoices (300-400 per day), 2 way and 3 way matching and

completing additional duties as assigned by controller.

H&R Block - Tax Associate (2003 Tax Season, part time) Jan

2004 to Apr 2004

Prepared income tax returns for individuals and performed technical review

of moderate to complex returns. Identified and promoted opportunities for

tax planning and other special services by preparing practical solutions to

clients' tax situation. Provided broad-based financial information on

issues such as retirement planning and investing.

Contact this candidate