Sales Sql Server

James Mwangi

**** ******** **, ******* ** *****

Tel/Fax: 845-***-****. ablv60@r.postjobfree.com

[pic]

QUALIFICATIONS SUMMARY

. Progressive Analyst with more than 15 years of increasingly

responsible employment with a large corporation. Diversified,

progressive experience in the analysis of financial / economic data

supporting corporate decision making including marketing, financial

planning, and forecasting. Progressive technical strengths including

database application development, technology system analysis,

programming processes and technical support skills. Can easily

explain technical concepts and communicate with users and system

administrators at all levels. Works as well independently as within

a team environment. Very productive, staying on task and getting the

work done in an effective manner. Excellent written, communication

and problem solving skills.

TECHNICAL SKILLS

SOFTWARE: Microsoft Windows Microsoft Windows Microsoft Windows

2000 XP Vista

Microsoft Excel Microsoft Microsoft Word

PowerPoint

Lotus 1,2,3 Microsoft Visio, FAS-Best Software

Crystal Reports

DATABASE: Microsoft SQL Microsoft SQL Microsoft Access

Server 2000 Server 2005/2008

WORK EXPERIENCE

1990-2009 DialAmerica Mahwah NJ

DATABASE ANALYST (2007-2009)

. Responsibilities included designing and developing, relational

databases using Microsoft Access 2000 and Microsoft SQL Server 2000

for corporate and individual department's sales and cost analysis.

. Designed all input and reports for Microsoft Access 2000 for

accounting and accounts payable departments using Microsoft Access

2000, Microsoft SQL Server 2000 queries, stored procedures and

scheduling.

. Responsibilities included also converting the accounting department

from manual recording to computerized system of record management.

. Designing various databases for accounting, accounts payable and

unclaimed wages / property state filing system.

. Managed and administered various databases and trained accounting

staff with basic computer operations and proper data entries.

. Fixed Assets analysis, testing new systems, maintaining data

standards, controlling access permissions and privileges.

. Responsible for program and end user documentation as well as for

troubleshooting processing problems.

FINANCIAL ANALYST (1990-2007)

Recorded transactions on network database, maintained General Ledger

and balance sheets, handled month-end-closings, and fixed assets

analysis.

. Maintained confidential personnel files including salary histories,

time sheets, attendance records, and payroll related information.

. Analyzed corporate weekly and monthly projections and communicated the

reports to the controller, the CFO and other senior executives.

. Streamlined the corporate unclaimed property / wages filing process

with the states, creating a centralized system that reduced state

filing preparation time from two weeks to two hours for each team

member of the accountants.

. Assisted in analysis that saved the company $5 million from telephone

overcharges.

. Analyzed Fixed Asset and interpreted monthly variances and trends

between budgets, actual and prior results in developing projections

and forecast.

. Track and review gross and net sales including gross margins in

producing forecasts and trend analysis on an on-going basis.

. Provided financial support and analysis to operations and marketing

areas for strategic business decisions and cost savings initiatives.

EDUCATION

. Masters of Science in Management Information Systems: New Jersey

Institute of Technology, NJ.

. Bachelor of Science in Business Administration: Ramapo College, Mahwah

NJ.

Contact this candidate