Applications Consultant Resume

SUMMARY

Technology professional with experience managing enterprise health insurance information Expert in gathering, analyzing and defining business and functional requirements Perform data - modeling and process-mapping initiatives Design/re-engineer processes, workflows and technology solutions for health insurance systems Proven ability to multi-task and work independently as well as with a team to implement seamless technical solutions.

TECHNICAL SKILLS

Applications: Microsoft SQL 2000 (Data Transformation Services, Query Analyzer, Enterprise Manager, VB Script), Microsoft SQL 2005(Integration Services, Management Studio, BIDS, Visual Studio), MS Project, MS Word, MS Excel, MS Visio, Unicenter Service Desk, Sharepoint, Eroom, File Transfer Protocol, Lotus Notes, Discoverer Reports, Platinum, FileAid, MQ Series, Panvalet, MVS Utilities

Languages: SQL, HTML, VBScript, COBOL, DB2, CICS, VSAM, JCL, IDMS, ADSO, TSO, ISPF

PROFESSIONAL EXPERIENCE

Confidential

Applications Consultant

Responsibilities:

Developed enterprise wide Provider Information Management System (PIMS) that supports both provider demographic and credentialing activities. Data was collected from various platforms throughout all markets nationwide and converted to a SQL database. Primary responsibilities included: SQL database modeling and build, Designed an audit tracking system using triggers to track changes to tables; Developed process to collect contract information from various platforms(CAS, Metavance and Badger); Worked with business partners to establish testing environments and cases.
Performed numerous data conversions due to company acquisitions. Worked with business and IT staff to develop conversion mapping specifications and strategies. Created standard load routines to more efficiently load data to SQL database.
Worked with business to develop data collapse rules for PIMS system; Developed process using a series of stored procedures for collapsing duplicate data for immediate merge/purge capabilities triggered by the online systems as well as batch processing that would further remove duplication.
Created data-cleaning solutions and reporting processes for use by Provider Affairs in order to produce provider directories for all markets during enrollment periods resulting in more accurate claims payment.
Led project team comprised of 10 individuals by organizing daily work for an IDMS to DB2 database conversion while supporting current production needs; Arranged and facilitated meetings with business users throughout the country to address data issues relating to provider directories and contracting as well as addressing IT access needs for other applications within Confidential ; Provided weekly status reports to upper management; Made market office visits to better understand how to consolidate all of Confidential ’s provider data.

Confidential

Applications Database Administrator

Responsibilities:

Developed Sybase stored procedures and triggers to facilitate the outward interfaces and reporting features for the Smartstream financial systems implementation.
Provided support for 120 application programmers and 20 end users as part of an enterprise data management team which creates and maintains DB2, Sybase and SQL Server databases.
Coordinated and completed database update and enhancement requests for all DB2 relational data; Delivered performance and tuning guidelines for more efficient use of SQL.
Conducted DB2 bind and package training to streamline current bind process.
Enhanced customer database merge functionality by reducing run times and improving data quality.
Created and distributed customer surveys to measure team effectiveness and productivity.
Served as project leader for Smartstream client server general ledger project for all batch processing and 53 interfaces involving both Unix/Sybase and mainframe environments; Coordinated efforts for around 60 individuals from both the financial and technical areas.
Facilitated status meetings for project team members and interviewed and directed work for team members; Completed performance reviews and feedback sessions for team members.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship