Management Analyst

KAVITA SINGH

***** ****** **. #* . **********, CA 91324 . Phone: 818-***-**** . Email:

*************@*****.***

OBJECTIVE

Eager Professional with formal education in Business Administration and

hands-on experience working with people and technology seeks a challenging

position as an Analyst.

COMPUTER SKILLS

ACCESS .SQL . VISUAL BASIC . EXCEL . POWERPOINT . MICROSOFT WORD

SUMMARY OF QUALIFICATIONS

. Seven years of experience developing Access databases and

applications for data transformation and validation projects

for mortgages, IT Contracts, and Health insurance industries.

. Solid background in table/query design, report design, and automation

utilizing Excel macros.

. Strong track record collaborating with stakeholders to define

functional requirements.

. Superior communications, interpersonal, and project management skills.

. Well organized, self motivated and persistent in achieving objectives

. Excellent problem-solving and decision-making abilities.

EDUCATION

Bachelors of Business Administration-Management of Information Systems

School of Business Administration and Economics . California State

University of Northridge . Dec. 2000

Information Technology Projects:

. Worked in a team situation to convert the existing homegrown

database to the corporate standard database Contract Management

Solutions, Inc. (CMSI).

. Assisted with GAP analysis to determine discrepancies between

existing processes and proposed technology solutions.

. Data mapping of the homegrown database to the existing CMSI system.

. Developed a department Procedural Handbook and Training Manual for

IT Senior Management

. Trained IT Senior Management to new system usage and features

. Modified reports based on user changing needs

. Saved the company over $200,000 by implementing the new CMSI

database.

. Implemented the new contract department policies and procedures

presently used in the parent Company, AIG.

. Annual savings of $200,000 from overseeing the entire contract

process.

WORK EXPERIENCE

Controller/General Manager

R&J Subway Corporation, Van Nuys, CA 1/08-Present

. Reconcile bank statements with sales reports.

. Prepared monthly accounting reports, profit/loss statements.

. Prepared payroll reports.

. Scheduled and managed a staff of twelve employees.

. Provided operations training to new hires.

. Conducted monthly employee meetings.

Financial Analyst

Countrywide Financial, West Hills, CA 06/06-09/07

. Creating and maintaining databases (such as Access) for use in Price

Analysis, Competitive Analysis and tracking Allocations.

. Designed and developed an Allocation Database using MS Access to

streamline loan allocation process. The database increase the number

of loans processed from 40 to 80 loans per day.

. Developed a loan comparison database to sample 2500 loans with

competitor's rates and present the data to management for pricing

decision.

. Sampled 120,000 records to analyze price and loan characteristics.

. Performing automation, process improvement and document imaging.

. Conducting ad hoc analysis at management's request using SQL, Excel

Charts, Pivot Tables, h-lookups, and v-lookups.

. Collaborating with IT to enhance current programs and applications.

Database Administrator/MIS Contract Administrator

AIG SunAmerica Retirement Services, Woodland Hills, CA 1/01-06/06

. Performed in depth systems analysis to identify user requirements.

. Redesign and maintained Access DBMS to track MIS contracts and

costs.

. Designed user interface to access various reports.

. Developed vendor phone list using macros.

. Normalized and updated data to reflect accurate information.

. Ensure company contract standards were implemented in the contract

terms and conditions.

. Held initial vendor meetings to collect information about the products

or services vendor is offering.

. Maintain and manage all details of contract database and contract

process.

. Maintain and manage all templates for contract administration.

. Ensure data Integrity and accuracy for annual IT budgets

. Assist with financial analysis and business cases.

. Resolve/improve process issues across all platforms for consistency

throughout AIG Retirement Services, Inc.

Senior Financial Analyst

Wellpoint, West Hills, CA 10/07-12/07

. Designed queries to sort and filter prescription drug formularies.

. Ad hoc reporting on contract renewals and pricing.

. Analyzed various rebate programs and presented information to upper

management.

. Gathered information from various sources and presented to

management.

Database Administrator/ Data Analyst

Regenetrol Labs, Los Angeles, CA 8/00-1/01

. Designed, developed and maintained Access DBMS to handle telephone

and Internet orders.

. Designed reports for media investments, monthly income, and order

status.

. Provided investment analysis by reconsolidating reports.

. Performed in-depth analysis of web traffic reports for the product

site.

. Reconfigured and customized filters based on analysis and

findings.

. Analyzed data and created reports.

Keywords: Access Developer, Financial Analyst, Business Analyst, SQL,

Process Improvement, Excel, Vlookup, Hlookup, Quires, Tables, Forms, Ad

Hoc reporting, Design and Development of database.

Contact this candidate