Project Manager Data Analyst

PROFESSIONAL SUMMARY:

Excellent organization skills

Strong problem solving and analytical skills

Self-starter, applies individual initiative to get the job done

Proficient in Microsoft Access, Word, Outlook and Excel including pivot tables, v-lookups, macros, formulas, etc.

PROFESSIONAL EXPERIENCE:

APEX Systems – Hines, IL – Contractor

ASM Research: Data Analyst 8/2015-11/2015

National Security Operations Center (NSOC) at Veterans Affairs – CRISP contract

Coordinate system access and security clearance with VA for new staff (3 locations)

Coordinate computer issuance and equipment for staff

Maintain SharePoint site with on-boarding statuses, system access statuses, staff information, etc

Assemble statistical reports of scanning requests, statuses, and completion rates

Document procedures and contact lists for on-boarding processes

Freelance Web Design 12/2012 to Present

Website design/maintenance Train and assist with navigation of website template programs & Google analytics

K-force – Chicago, IL – Contractor

JP Morgan Chase & Co: Project/Program Manager II 1/27/2014 to 3/31/2015

Develop Access database to match data from Product Managers and systems

Obtain extracts from Business Objects for data in system

Organize meetings and Introduce project scope to Product Managers

Meet with Product Managers globally (via email and conference calls) to confirm documentation requirements for products/sub-products/services

Gather product documentation changes, business rules for document requirements, and client lists from Product Managers globally – EMEA, APAC, LATAM, NA

Verify client lists from Product Managers match the applicable product/sub-product/service or other documentation and contain the required data (entity or account information)

Track responses & follow-up with Product Managers to ensure clarify all information received

Contact: Beth Wolde, VP, Project Manager 44-207-******* (London)

Ragan Autry, VP, Project Manager 940-***-****

Sears Holdings Corporation – Hoffman Estates, IL 07/2007-11/2012

Senior Risk/Financial Analyst

Promoted November 2011 from Risk /Financial Analyst

Analyze collateral posted for self-insured liabilities and follow state by state procedures to reduce surety (reduced by approx $240M)

Report financial, claims data, and assessment payments, premium payments, actuarial data, 10-Q and 10-K financial statements, etc for workers compensation claims in 43 states and Virgin Islands (self-insured and monopolistic states)

communications with state Departments of Insurance regarding workers compensation filings/audits

Co-manage implementation of new RMIS (Risk Management Info System) -Salesforce.com/Cognos platform

Create reports and provide training on new RMIS system

Sears Holdings Corporation; Sr Risk/Financial Analyst (Cont’)

Ad-hoc claim reports for claims analysis

Coordinate claim code corrections/changes with Sedgwick CMS

Answer unit (store/business) inquiries and resolve discrepancies regarding internal claim charges

Maintain 11 tier business structure for all open and previously closed units for all entities (approx 40,000)

Calculate property/casualty, workers compensation, and product liability insurance plan at all levels (from corporate to line of business to unit level)

Create Excel macros to expedite reporting

Risk Management department website

*Sears Holdings Corporation’s corporate policy prohibits personal references

Sedgwick CMS – Hoffman Estates, IL 04/2006–06/2007

Juris Specialist II - Sears Holdings Account

Prepay payment balancing /check committal Maintain client business structure

Maintain provider/vendor records Process claim code changes

Provide Juris update training to colleagues Maintain database for user security levels

Maintain team website on intranet

Resolve EDI issues for documents being transmitted to Department of Insurance

Maintain Data Analyst duties after promotion

Data Analyst I – Sears Holdings Account Promoted January 2007

Create periodical and adhoc reports (Workers Compensation, General Liability, Product Liability)

Provide reports for Workers Compensation state reporting

Develop Excel macros to automate reporting

Contact: William Etheridge, VP, Program Executive 847-***-****

Anne Scully, Assistant VP, Program Manager 248-***-****

Madsen, Kneppers & Associates, Inc. – Chicago, IL 08/2005-03/2006

Administrative Assistant

Organize inspection site notes and photos Track project correspondence

Prepare final inspection reports Maintain project database (MS Access)

Reconcile credit cards/prepare expense reports

Addison Financial Services – Chicago, IL - Contractor 01/2005–08/2005

Whitehall Jewelers: Inventory Specialist

Reconcile inventory counts and enter information in dedicated computer system

Request audits of items with significant discrepancies

Computershare Investor Services: Reconciliation Specialist

Reconcile client accounts for share purchases, refunds, sales, proceeds, bank statements,

Reconcile data from 3 computer systems used for tracking transactions

EDUCATION:

Fox Valley Technical College – Appleton, WI Graduation: 12/2004

Associate of Applied Science - Computer Programming/Systems Analyst

Graduated with honors 3.86 GPA, Phi Theta Kappa Honor Society, National Dean’s List

Insurance Institute of America – Associate in Risk Management (ARM) certification 04/2012

Contact this candidate