SUMMARY:

• IT Analyst with a sound understanding of application development, application software deployment, and management of relational and non - relational data. Affinity for process improvement and above average attention to detail, organization skills, and critical thinking.
• Waterfall and Agile development Methodologies
• Windows 2012 & SQL Server(s) 00/05/08(R2)/12
• VISUAL COBOL 2013, Multiple SQL dialects
• VISUAL STUDIOS 2013 & Other DEV ENV.
• Data/Code Migrations, Transformation, Imp
• PC, Midrange(AS/400), & Mainframe Files-DBs
• HP Service Center, Quality Center, TFS
• PVCS Tracker, IBM Rational (RTC), SharePoint
• EDW/CDW, DB2, SSDB, MS Office
• PMHS, HBMS, POINT, HEALTHQUEST
• Reporting & BI Tools, MICROSTRATEGY WEB.
• .CMD/.BAT/DLL Use, POWERSHELL Exposure

PROFESSIONAL EXPERIENCE:

SYSTEM MODERNIZATION ANALYST

Confidential, Philadelphia, PA

Responsibilities:

• Migrated various Canadian Employment Insurance (UI) applications from legacy systems to Windowsintegrated environments overcoming incompatible data hurdles between legacy and target environments.
• Leveraged various tools including Confidential Compare, Compare-It, Notepad++, TextPad, Micro-Focus DataTools, XGEN, Etc. to aide in migration issue identification and resolution.
• Navigated many regional Windows Networked Servers using Citrix gateway to acquire files and scripts asneeded while remediating migrated code defects locally using Visual Studios IDE.
• Combination of both US Based and Onsite Canadian worksites requiring DoD Secret Clearance.

PROGRAMMER ANALYST

Confidential, Charlotte, NC

Responsibilities:

• Utilized various industry application development tools and proprietary in-house T-Rowe Price applicationTools to detail baseline and custom application code and data current state.

DEVELOPER

Confidential, Durham, NC

Responsibilities:

• Continuous development of complex i-Series application processes within 2 week Agile Sprint intervals mining Provider, Vendor, and Network details contained within BCBSNC legacy databases.
• Various Cobol-SQL applications written to bridge data gaps between new application solutions being integrated into the new BCBSNC enterprise model. The aforementioned applications required detailed backend knowledge and use of PMHS database tables and data elements. The core PMHS tables utilized during development tasks primarily resided in the Provider Practitioner-Vendor and PPO, TIER, LOW COST provider network PMHS DB2 sources.
• Additionally, Stored Procedures written to facilitate PEGA frontend data requests, providing key provider historical data sourced from the BCBSNC PMHS DB2 sources.

DATA ANALYST/DEVELOPER

Confidential, Jacksonville, FL

Responsibilities:

• During externalization of Gift Card Processing contributions included field level mapping necessary for integration of 3rd party vendor inbound reconciliation/settlement data into the corporate EDW, facilitating reporting of e-gift card activity across approximately 265 retail locations.
• Primary development resource for mining, mapping, and formatting outbound extract data from multiple in-house gift card DB2 databases into 3rd party vendor specified formats using DB2 SQL Stored Procedures. Researched and Analyzed legacy gift card variances between internal DB2 databases and EDW using SQL and Micro-Strategy Reports. Successful identification of approximately 90k in variances working collaboratively with accounting, finance, and internal data/BI team.

SQL REPORTS DEVELOPER

Confidential, Columbia, SC

Responsibilities:

• Developed and maintained applications written against a 3rd party DB2 database associated with a real-time and batch I-Series IBM (GENELCO) OLTP insurance software package utilizing COBOL, CL, and SQL scripting. Areas of focus included New Business (Medical, Dental, Life, RX) Plan Enrollments, Policy Issue, and Financial Reporting.
• Successfully developed a process automating insurance policy enrollment for jet issued and diverted pended applications for manual review improving the accuracy and speed of enrollment loads. Incorporated the use of triggers and FTP scripts to automate the hand shake and consumption of client files from a network server process, re-format and map into intermediate files, load via an IBM (GENELCO) OLTP program interface, and perform error handling/notification.
• Applied as-needed SQL Server 2000 job, stored procedure, DTS package, tables/index updates utilizing Enterprise Manager.

DEPLOYMENT ANALYST

Confidential, Columbia, SC

Responsibilities:

• Engaged in proactive data cleansing, standardization, and post conversion validation activities at 6 counties varying in size across the State of South Carolina utilizing both I-Series (AS400), SQL Server, and Windows (DOS) tools/utilities.
• Contributions included financial validation, credit card interface configuration, and implementation working directly with 3rd Party clearinghouse SCGOV.
• Performed Client and Server software release installations, upgrades, and ODBC data source configurations.
• Deployed Case Management System (CMS) at county locations operating I-Series & Microsoft SQL Server systems.
• Provided post implementation on-site support including issue logging and Case Management System (CMS) procedural ‘how to’ user assistance.
• Gathered requirements needed to produce system output (forms & correspondence) design document deliverables stated within the RFP of a $90 million web based Family Court replacement system contract.
• Produced over 100 Family Court forms and correspondence GSD/DSD documents utilizing Microsoft Office and proprietary Letter Genie software.

Programmer Analyst

Confidential

Responsibilities:

• Developed applications against a 3rd party DB2 database associated with a real-time IBM (GENELCO) OLTP insurance software package utilizing COBOL, CL, and SQL Scripting. Areas of focus included new business, plan enrollments, policy issue, medical management, year-end W2 & 1099, compliance, agent commissions, and miscellaneous reporting.
• Achieved corporate goals of expanded functionality and operational cost reductions thru significant modifications to existing plan enrollment, ID card generation, and agent commission processes.
• Routinely fulfilled information requests from various departments including legal to ensure compliance with state regulatory agencies.