Management Analyst

JASON B MCCRAY

**** ****** ***** ***** *****, FL 33584 cell: 904-***-****

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

SUMMARY OF QUALIFICATIONS

Proficient in the use of advanced Microsoft Excel functions including pivot

tables, macros and vlookups

Able to compile and analyze complex data and output into a simplistic form

for analysis

Able to extract data from multiple database systems including Omni,

Business Objects and Cognos

Able to work on multiple operating systems including Windows, Mac OS X and

UNIX

Able to test, code and implement systems upgrades for users and clients

Excellent interaction with cross-functional teams

TECHNICAL SKILLS

Software Microsoft Excel, Minitab, Scientific Workplace, Mathematica,

Maple, Codewright, MathCAD, Matlab

Languages SQL/SQL*Plus, PL/SQL, COBOL, C/C++, HTML, Visual Basic, JPL,

Omniscript, Korn Shell Script

Databases Oracle 8i, Microsoft Access

Applications Business Objects, OmniStation, PowerImage

Operating Systems UNIX, Windows 7, Mac OS X

PROFESSIONAL EXPERIENCE

CSX - Jacksonville, FL

MS Excel Analyst (May 2010 to present)

Creates all analytical reports sent to upper level management for review

Performs vlookups and pivot tables for statistical presentations and

training sessions

Responsible for data mining and management

Performs all office related duties as required

ING - Jacksonville, FL

Omni Plus Systems Analyst (July 2006 to February 2010)

Constructed all monthly reports sent to client including distribution,

suspense to forfeiture, and prior period activity

Reconciled all contributions, elections, and distributions for defined

contribution with assets exceeding $5 billion

Researched and resolved individual participant cases and events

Created T933's for querying client databases to produce ad hoc reports

Uses OmniStation and PowerImage as tools for participant management and

administration

Responsible for testing and coding of various client-directed technical

projects

Used Business Objects for monthly external client report creation and ad

hoc internal reporting

Performed advanced excel functions such as vlookups, macros and pivot

tables for data analysis

Tallahassee Community College - Tallahassee, FL

Mathematics Instructor (January 2004 to April 2006)

Instructed students in College Preparatory Mathematics courses

Responsible for teaching technology-based courses and use of mathematics

software

Served as mentor and peer counselor for beginning college students

Aided CLAST students in preparation for examination

Florida A&M University - Tallahassee, FL

Assistant Mathematics Lab Director (October 2002 to April 2004)

Responsible for overseeing student workers and performing payroll processes

Tutored various students in Calculus, Abstract Algebra, Complex Analysis,

etc

Responsible for aiding Lab Director in grant management

Served as TA and sub for professors in different math courses

State of Florida Department of Revenue - Tallahassee, FL

Programmer Analyst (July 2001 to January 2002)

Developed, maintained, and enhanced COBOL batch programs for Motor Fuel

Taxes

Used embedded SQL (cursors, views) to extract data from the database

(Oracle 8i)

Created Panther Client screens for GUI access and coded JPL script in

Codewright

Maintained UNIX test environment and Shell Scripts to ensure optimum

performance

Exported COBOL programs from UNIX to Unisys for mainframe use with ECL

EDUCATION

BS Mathematical Sciences - Florida A&M University, Tallahassee, FL

2003

BS Computer Information Systems - Florida A&M University, Tallahassee, FL

2000

Contact this candidate