Sr. Business Systems Analyst Resume

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Systems Analyst

Responsibilities:

Consultant for client company SE2 for development and installation of new Universal Life Product.
Produced Ad hoc reports using Sales Force, MS Access, Excel, and VBA.
Extracted and scrubbed data from Sales Force system.
ETL data from an Oracle database into the “Dun and Bradstreet” system to obtain company information for customer sales database.

Confidential

Systems Analyst

Responsibilities:

Consultant for Pharma company Novo Nordisk. Converted the compliance Oracle database tables using MS Access and VBA, for the Oracle Business Intelligence Enterprise Edition (OBIEE).
Converted data extracts from old system to support conversion to new IQVIA system.
Analyzed, scrubbed, verified, and loaded data for over 400,000 records for the Federal CMS website to comply with “Sunshine” law. It involved re - formatting data elements to meet government specifications.
Produced Ad-hoc reports using MS Access, Excel, and VBA.

Confidential

Programmer/Analyst

Responsibilities:

IT support and VBA/Microsoft Access Specialist for Biotechnology firm. Using MS Access, VBA, and Excel for both new, and enhancement of applications and reports.
Modeled and created a relationship database and developed VBA code to replace an Excel based manufacturing/assembly system.
Interfaced MS Outlook, MS Word, and external serial devices, with MS Access and Excel.

Confidential

Programmer/Analyst

Responsibilities:

Consultant for Medical supply company B. Braun Corp. as a Microsoft Access Specialist. Using MS Access, VBA code and Excel for both new, and enhancement of applications and reports.
Extracted files from SAP into MS Access.
Converted Excel applications into MS Access/VBA.
Consulted with end users on application related problems regarding maintenance and design.
Consultant for PPL Corp. for the remediation of multiple MS Access applications to a new Oracle database schema. Involving intense VBA, forms/ reports, ODBC links, query maintenance and development.
Remediated over 70 Access databases during a 3-month period.

Confidential

Project Analyst

Responsibilities:

Consultant for MetLife. Produced and converted data from SQL, Excel, MS Access, and text sources for the Mid-Range Unix group reporting system.
Change manager for my team using BMC Remedy Service Management. Responsible for over 4,000 tickets as the change manager. Represented my group at the weekly MetLife IT CAB meetings
Project Lead for MetLife’s PC Asset Inventory Management Group.
Designed and produced critical data PC Asset inventory extracts using SQL, Oracle, MS Excel, and MS Access used by all departments across the enterprise.
Reconciled MS Office, and other software licenses (owned vs. deployed) for MetLife PC's.
Partnered with Expense Control team to find over one million dollars in cost savings.
Designed/Created MS SQL databases, SSIS processes and SQL queries to load/update database.
Team leader for the reprogramming of the legacy COBOL/CICS and JCL code on our IBM mainframe to accommodate Y2K Business requirements.
Y2K Renovation initiative - personally renovated over 400,000 lines of COBOL/CICS/JCL/DB2 code for Y2K on the MVS/TSO mainframe.
Installed software and trained users for our Group Life Customer Service Operation Unit in Aurora, IL.
Successfully developed a PC based Life Insurance/Re-proposal Online System which interfaced with the mainframe database to provide a “what if” illustration of personalized insurance using Realia COBOL.
Developed Paid-up Life Insurance System using Microsoft Access and Visual Basic.
Maintained an Accounts Reserve System utilizing MVS/TSO JCL, REXX and COBOL.
Found and reconciled customers account discrepancies between billed premiums and payments.
Cross System Product (CSP) Administrator and SQL/DS Database Administrator.
Created and maintained programming libraries using VSAM datasets.
Documented and maintained programming standards.
Created SQL tables, views, and granted access to Development, QA, and Production SQL databases.

Confidential

Programmer/Analyst

Responsibilities:

PC admin for the company. Set up and configured PC’s, trained users on software.
Programmer/Analyst for mainframe COBOL applications.
Backup System Administrator for the IBM 4361 mainframe.

Confidential

Programmer

Responsibilities:

Work for a Wall Street Mutual fund company.
Programmed a new Mutual Fund Sales Illustration System for use on a personal computer.
Supported, maintained, and developed COBOL batch applications.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship