Senior Systems Analyst Resume Profile

Summary:

Proven ability to design systems for quick access to vital information.
Excellent analysis and multi-platform programming skills.
Dependable and conscientious accurate at detail work.
Goal oriented, creative and resourceful.
Communicate equally well with technical and business staff.

Technical Skills:

Hardware: IBM 30XX, Terradata, PC, HP-UX
RDBMS: SQL Server, MS Access, Oracle, DB2, MySQL
Software: SAS, VBA, EXCEL, MS Outlook, Word, SSMS, SSBIDS, SQL Server Agent Job, Windows Batch, Visual Basic .NET, C .NET, WAMP, HTML, CSS, JavaScript, Java, NetBeans IDE, ASP, PL/SQL, UNIX Korn Shell, TOAD, COBOL, JCL, Syncsort, MVS/TSO/CLIST, Crystal Reports, Visio, Doc-To-Help, Focus, PC/Focus, VM/CMS/REXX, Teleforms, EPIC, IKA

Confidential

Business Analyst III

Developed multi-user databases with an MS Access forms front end and SQL Server 2008 back end. Used SQL Server Management Studio for development and assignment of user rights. Wrote all VBA forms code and creation of database tables.
Using SQL Server Agent created jobs to load database tables on a daily basis. Wrote SSIS packages, which utilize T-SQL, for loading of Medicare Advantage MA membership information into SQL Server tables.
Automated the generation of a Master Grid in MS Excel using VBA that is used to determine a member's annual co-pay amounts, LIS levels and premium amounts for MA. The grid can now be created in seconds, saving the MA Department a month of manual work.
Wrote an Excel add-in that determines the last date a member can cancel their MA policy. The add-in ensures that the department is compliant with Centers for Medicare Medicaid Services CMS guidelines.

Confidential

Digital List Analyst Contractor

For the Department of Analytics, performed MS Excel automation using VBA to create add-ins for the generation of statistical functions and pivot tables.

Confidential

Senior Programmer/Analyst

Performed analysis, design and development of MS Access databases, in clinical studies, for the recording and analysis of patient related data.
Using VBA, developed validation routines in data collection forms to ensure data accuracy.
Transferred data between Access and Excel using object model and VBA code.
Maintained a multi-site research database written in C .NET, Perl and MySQL. Wrote a module in C and NHibernate used for collecting patient data.
Using SAS, analyzed statistical data for several research study groups in order to determine relationships and trends in data collection instruments which resulted in the publication of two research papers.
Performed research of patient comorbidities using EPIC software. Collaborated with the EPIC team to create data extracts for the analysis of patient lab data.
Maintained a patient scheduling system written in VB6.
Performed data mining based on specific ICD-9 codes and patient drug utilization for the director of the ICU.

Confidential

Senior Systems Analyst

Performed analysis and research of existing healthcare claims system functionality.
Produced High Level and Detail Systems Specification Documents for enhancements to healthcare insurance policy master and peripheral systems.
Conducted walk throughs of specification documents with business and technical staff.
Created detailed System QA Test Plans and performed extensive QA system testing for policy master upgrades.
Coordinated system assembly test activities for assembly test region.

Confidential

Database Developer/Analyst

Developed a Real Estate Title Management System written in VB .Net and SQL Server 2000. Performed all analysis, created ERD diagrams for database relationships and constraints.
Wrote VBA routines in MS Access to reformat data and perform edits prior to moving to new data model in SQL Server.
Utilized DTS for data transfer from MS Access to SQL Server 2000.

Confidential

Software Database Developer/Analyst

Converted a Customer Satisfaction Survey system written in Lotus Approach macros to MS Access/MS Outlook/VBA.
Performed all system analysis, wrote new system specification document, performed development of all tables, forms and VBA code modules.

Confidential

Senior Developer

Performed disease management consulting DMC for managed-care clients.
Processed medical and pharmacy claims from insurance-provider groups using DB2/MVS/JCL with the objective of maintaining costs and improving patient outcomes.
Analyzed trends in patient's drug utilization and cost of care in order to identify outliers.
Developed several reports written in MVS/FOCUS for the Finance, Marketing and Operations departments.
Supported Finance Department with ad-hoc reports using FOCUS on a daily basis.
Performed extensive QA analysis on medical and pharmacy data, utilizing SAS for the generation of QA reports.
Maintained Oracle PL/SQL code, using TOAD, which evaluated inventory for an order fulfillment system.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship