Resume

Sign in

Manager Microsoft Office

Location:
Herndon, Virginia, United States
Posted:
November 09, 2018

Contact this candidate

Resume:

Bella Mehta

***** ********* **** ****

Herndon, VA 20171

Cell 703-***-****

ac7nfk@r.postjobfree.com

RELEVANT EXPERIENCE:

Fifteen years experience in structured analysis, requirements gathering and user acceptance validation on multi-tiered applications developed for customer analytics, data warehouse and decision support solutions. Ms. Mehta is a US Citizen with experience on a wide range of structured methodologies.

SKILLS SUMMARY:

Software & Programming Languages: Business Objects, Cobol, Java, Lotus Notes, Microsoft Office tools, Peachtree Accounting, Quicken 2008, Rational Quality Manager, Rational ClearCase, ClearQuest, Requisite Pro, Vertex software, Microsoft Access, Visual Basic.

Database Systems: Microsoft Access, ORACLE, SQL Server

Methodology & Processes: SDLC, CMMI, SOX, Agile and 6-Sigma.

PROFESSIONAL QUALIFICATION

Chartered Accountant (CA), India.

EDUCATION:

The Institute of Chartered Accountants of India - Final examination - July 1990 (British/Indian equivalent of a CPA)

The Institute of Company Secretaries of India -Intermediate examination - June 1995(Notarized Public Accountant)

Bachelor of Science, Accounting & Taxation, University of Bombay, Bombay, India - July 1986

PROFESSIONAL EXPERIENCE

Business Development and Proposal Manager – Jun. 2013 – Present.

Analyzed potential business opportunities and prepared a road map to help an organization evaluate its mission statement, key performance indicators, evaluate its business programs against return on investments. Prepared monthly and quarterly profit / loss projections on proposed projects and helped articulate trending and identifying potential loss making projects. Coordinated with resource pool to engage in new technologies and learn new processes to help gain an edge on new proposal and market trends.

Convergenz, Fannie Mae, Herndon, VA.

Senior Business Analyst - Nov 2012 – May 2013

Member of the loan processing team at Fannie Mae, where was tasked with lender communications for fee reconciliation system. As part of the project had to leverage Fannie Mae’s SIR product suite to process different loan products from lenders and apply the one-time servicing fee. For open loans that had not closed within 30 days or aged loans, created a process to automatically generate a summary and detail report for management by each lender using SQL queries against three database systems, namely MS Access, Sybase and Oracle. Additionally, created a process to validate the insurance certificates needed from lender’s to reconcile all mortgage loan portfolios. Created business requirements in Requisite Pro and followed the process of entering defects in Rational products.

Multitech Services Inc.,Herndon,VA

Business Development and Proposal Manager – Sept. 2009 – Nov.2012.

Prepared different technical solutions and business processes for government proposal and coordinated teaming opportunities on different request for proposals. Analyzed potential business opportunities and prepared a road map to help an organization evaluate its mission statement, key performance indicators, evaluate its business program’s against return on investments. Prepared monthly and quarterly profit / loss projections on proposed projects and helped articulate trending and identifying potential loss making projects. Coordinated with resource pool to engage in new technologies and learn new processes to help gain an edge on new proposal and market trends.

Xerox (Affiliated Computer Services) (MN-DHS) / HealthMatch

System and Lead Quality Assurance Tester – Sept. 2004 – Aug. 2009.

Health Match was a Web based automated information system for the State of Minnesota to streamline Minnesota Healthcare Program(MHCP) delivery and eligibility process. MHCP provides automated health care eligibility determination functions, rules engine, standardizing MHCP eligibility processes and outcomes across Minnesota. Health Match allows potential MHCP clients apply for coverage online. Health Match, E-Commerce Applications and MMIS Mainframe Applications constitute MHCP Health Care Systems. Interacted with Project Manager and Business Analysts to define functional and system requirements. Created and maintained test artifacts including test plan, test cases, test scripts, defect reports, and test execution summaries. Matched all test cases to business requirements and reported test case creation progress on requirements traceability matrix (RTM). Executed regression tests using automated test scripts for intermittent software releases, using Perl, SQL and QTP 9.x. Created new automated scripts and edited pre-developed scripts based on changes using library of re-usable components. Developed automated scripts to satisfy business scenarios and submitted defect / pass/fail reports to management. Performed database testing using SQL/Toad and used IBM Rational ClearQuest for defects management. The E-Commerce project was managed using scrum principles and the project phase was split into 14 different sprints with each sprint spanning 60 days. The project team members had a standup meeting every morning with each team explaining the status in terms of the tasks completed yesterday, the tasks planned to be completed today, and any issues or road block for completing the day’s tasks.

Freddie Mac, McLean, VA.

Senior Accountant: - Mar 2004 – Aug. 2004

Helped create a reconciliation process to audit check all restatements processed by PriceWaterhouse Coopers accountants for mortgage backed securities. Used Microsoft Office tools to generate and store monthly statements and create status reports for Vice-President of Finance.

Winstar Wireless Inc., Vienna, VA.

Senior Tax Accountant - Nov 2000-Apr 2002

Designed and developed a methodology for filing of regulatory papers, sales & use tax returns, telecommunication taxes, property tax returns using Vertex software and Microsoft office tools. As part of my duties I had to research and respond to audit queries and other legal issues raised by internal and external auditors. Additionally, had to research and responded to tax notices raised by various state and local tax authorities. Due to regulatory rules laid down by Federal Communications Commission our company had to file regulatory papers in different states and also for subsidiary companies incorporated in the State of Delaware. Developed a sampling of call detail records for a given customer and reconciled the customer bill with the payment received from the customer. This process helped our business users to guarantee our internal audit software and process controls. Analyzed excessive tax charges on our customer invoices and helped ascertain whether there was any excessive charge made due to tax software glitches. Maintained tax deduction certificates and validated tax credits due to our customers. Created detailed business requirements with specific examples for software developers to build missing features to help our chief financial officer analyze our business viability.

Manpower, Fairfax, VA.

Senior Business Analyst at Exxon Mobil -April 2000-November 2000

Prepared federal and state taxation returns for over 200 subsidiary companies worldwide using CorpTax System. Created requirements for standard business reports on other income, bad debts and legal fees for the above companies in accordance with generally accepted accounting principles (GAAP). The software developers generated our reports and my group was assigned to perform user acceptance and validate the data values.

K-Force, Vienna, VA.

Senior Assistant Account’s Dept.-March 2000-April 2000

Reconciliation of accounts with general ledger.

Apple One, Los Angeles, CA.

Account Assistant Account’s Dept. Feb. 2000 - March 2000.

Reconciliation of accounts with general ledger. Prepared reconciliation statement of accounts payable for the external auditors. Bank Reconciliation statements.

Balsekar & Desai, Chartered Accountants, Mumbai,India

Accounting Partner, 1995-1999

Handled statutory and tax audits of government, private sectors, insurance and banking companies. Filed income tax returns of the above and also prepared and filed the report to the comptroller and auditor general of India. Prepared and filed individual income tax returns. Audited and filed income tax returns for professionals. Reviewed the purchase function of private sector companies. Monitored the collection of accounts receivables. Controlled and cut down revenue expenses. Analyzed the increase in sales returns and recommended measures for additional reductions

Roussel India Ltd., Mumbai, India

Accounts Officer, 1992-1994

Handled bills payments, payments of wages to pharmaceutical sales representatives and staff. Approved expense statements of pharmaceutical sales representatives. Prepared and filed central and state sales tax returns. Consolidated information for sending MIS reports to the managing director and the parent company, Roussel Uclaf, Paris, France. Prepared and filed tax deducted at source returns with the Income Tax Office of India

G. P. Kapadia & Co., Chartered Accountants, Mumbai, India

Manager, 1990 - 1992

Handled statutory, revenue and concurrent audits of banks. Handled statutory and tax audits of insurance companies (fire & marine claims depts.) including the checking of provisions for outstanding claims, claim payments, premium collections, reinsurance premiums. Conducted the physical verification of stock and cash. Conducted the concurrent audit of banks and prepared the audit report based on the analysis of bank advances, identified and analyzed problematic loans that were considered risky Prepared and filed the income tax returns of companies, individuals and partnership firms. Formed limited companies.

Balsekar & Desai, Chartered Accountants, Mumbai, India

Articleship, 1986-1990

Handled statutory, revenue and concurrent audits of banks. Filed income tax and wealth tax returns of individuals and companies. Wrote minutes of private limited companies and also drafted annual reports for such companies.



Contact this candidate