We provide IT Staff Augmentation Services!

Sr. Consultant Resume

Arlington, VA

IT SKILLS:

Data Mining/OLAP Softwares: MicroStrategy Suite (Desktop/Web; NarowCaster); COGNOS Cubes; SAS/EBI; MicroSoft SQL Server Report Builder

Mathematical and Statistical Applications: Mapl, MatLab; SAS, StatGraphics, SPSS

Programming: FORTRAN, Visual Basic (VBA) 5, Pascal, C/C++, SQL

Platforms/Operating systems: Mainframes/CMS; VAX/VMS; Workstations/UNIX; PCs/DOS, Windows

Miscellaneous: TOAD; MS Office Suite

RELEVANT WORK EXPERIENCE:

SR. CONSULTANT

Confidential, Arlington, VA

Responsibilities:

  • Assisted creating PARRiS and SMART tools (for 7A and 504 Programs respectively) to evaluate 4000+ banks’ and CDC’s $80B+ of SBA - backed loans, using SAS and MS Excel. Maintained, enhanced and updated the tools.
  • Created and maintained corresponding Data Packs (for 7A and 504) to further assist Financial Analysts and auditors
  • Supported OCRM (Office of Credit Risk Mgmt) with various ad-hoc analyses and reviews, and FOIA data requests.
  • Allocated tasks, such as QC, ad-hoc requests, running Data Packs, etc. between a junior analyst and myself.
  • Trained junior analyst with SAS use and on the process of quarterly updating the main tools

DATA SPECIALIST

Confidential, Alexandria, VA

Responsibilities:

  • Created SAS/SQL data manipulations routines to generate reports off the Client’s database.
  • Extracted Work Force Analytics information using SQL Server Report Builder
  • Assisted with other presentations requiring presentation tools (graphs, charts, tables, etc.);

STATISTICAL CONTRACTOR

Confidential, Falls Church, VA

Responsibilities:

  • Extracted large data sets off client’s Data Warehouse and performed various QC checks against other extracts;
  • Maintained SDR (Survey Data Repository): performed ETL of surveys into the database and performed QC of data extraction routines using SAS/SQL; extracted information off the databases using SQL queries upon request;
  • Assisted with other data extractions and presentations using SAS/EBI and Business Object tools;

STATISTIAN CONTRACTOR

Confidential, Alexandria, VA

Responsibilities:

  • Extracted large data sets off client’s Data Warehouse and integrated them to other data sets;
  • Ran Multivariate statistical analyses of client’s data using SPSS and presented findings, including recommendations; Suggested subsequent, continual data monitoring techniques.
  • Assisted with other presentations requiring presentation tools (graphs, charts, tables, etc.);

MICROSTRATEGY REPORTS DEVELOPER

Confidential, McLean, VA

Responsibilities:

  • Gathered requirements from both Account Managers and Clients and created their reports according to their specs;
  • Documented the specifications of report sets, after clarification from requesting parties;
  • Distributed tasks between a junior Reports Developer and myself;
  • Trained junior Reports Developer with MicroStrategy use and reports development protocols;
  • Built MicroStrategy objects as needed, e.g. metrics, filters, set qualifications, prompts, custom groups, consolidations;
  • Designed, ran, and optimized ad-hoc reports to best use MicroStrategy, taking into consideration resource limitations
  • Further customized, formatted and tailored the reports to the clients’ exact preferences;
  • Designed reports and style sheet layouts to be used by Narrowcaster services in all phases of report dissemination;
  • Managed services and their respective lists of recipients and schedules for all clients;
  • Ran services directly to clients with html-compliant e-mail servers;
  • Used TOAD (Tool for Oracle Applications Developers) or Access via ODBC on staging tables to run scripts and SQL queries to pull Personal Health Information outside MicroStrategy’s underlying data due to HIPAA constraints;

STATISTICAL CONTRACTOR

Confidential, Falls Church, VA

Responsibilities:

  • Maintained web-accessed Crystal Reports monitoring HEDIS measures for the client (USAF) on its TriCare database;
  • Modified and maintained COGNOS Cube underlying reports used in the HEDIS measures;
  • Designed an early warning health model, using Statistical Process Control tools;
  • Assisted in the design and review of multivariate analyses of early warning health model;

ACTUARIAL PROGRAMMER

Confidential, Bethesda, MD

Responsibilities:

  • Communicated spec changes among Underwriting, Actuarial and Programming teams;
  • Maintained and updated underwriting rating engines using Visual Basic (VBA 5);
  • Assisted in the development of Large Group Rating Engine for the underwriters and actuaries;

STATISTICAL SOFTWARE ANALYST

Confidential, Bethesda, MD

Responsibilities:

  • Taught the StatGraphics statistical software and trained manufacturers with SPC (Statistical Process Control) and QC (Quality Control) techniques;
  • Provided technical support by answering telephone and e-mail questions about statistics and StatGraphics;
  • Assisted with the Version 5 release of StatGraphics by authoring help screens using ROBOHELP and stress testing;

PROGRAMMING CONTRACTOR

Confidential, Fairfax, VA

Responsibilities:

  • Maintained a legacy warehousing software in pro-C based front-end and C Middleware, on UNIX machines;
  • Addressed correction or bug requests from users;

ACTUARIAL PROGRAMMER

Confidential, Washington, DC

Responsibilities:

  • Configured C/C++ middleware calculations per pension actuaries’ specifications;
  • Set up Crystal reports (letters, forms) per specs for the client to use;
  • Ran test SQL queries against the client database, modified DLL’s;

ACTUARIAL ANALYST

Confidential, Washington, DC

Responsibilities:

  • Reported and Forecasted for Ancillary Lines of Business (Drug, Dental and Vision);
  • Did pricing and Rate Filings for these lines of business; this saved the company several millions of dollars annually;
  • Maintained and ran medical pricing C programs;

Hire Now