SUMMARY:

• IT Professional with 20+ years of experience.
• Hands - on proficiency in business requirements analysis, design, coding, testing, implementation, enhancement, users and maintenance of web-based, client-server and mainframe systems and applications.
• Extensive experience in Oracle & SQL Server database analysis, design, development, performance tuning, platform migration and data conversion. Broad expertise in T-SQL & PL/SQL (Stored Procedures, Functions, Triggers), loading & transforming large data sets, using analytical functions.
• Exceptional analytical, leadership and communication skills.

TECHNICAL SKILLS:

Languages & Scripts: SQL, PL/SQL, T-SQL, VB.NET, C#, COBOL, JavaScript, JQuery, VBScript, HTML/HTML5/CSS/XML/XSLT, JSON

Databases: Oracle, MS SQL Server, MS Access, DB2, VSAM

Operating Systems: Windows 8/7/XP & previous, Windows Server 2012/2008 R2, UNIX, MS-DOS, OS/MVS/zOS

Tools: & Technologies: ASP.NET, MVC, MS Visual Studio, AJAXControlToolkit, TOAD, Oracle SQL Developer, Oracle SQL Navigator, SQL Server Management Studio, SSIS, SSRS, SQL*Loader, SQL*Plus, Crystal Reports, HostBridge, COMTI, TSO/ISPF, CICS, JCL, FileAid, Xpediter, Intertest, MS Office, MS Visio, MS Project, Tableau, TFS, VSS, ALM

EXPERIENCE:

Confidential, NY

Lead Programmer Analyst

Responsibilities:

• Perform all phases of System Development Life Cycle (SDLC), collaborating with business partners and guiding other IT team members.
• Conduct the analysis, design, development, testing and implementation of major corporate projects, including Affordable Care Act, ICD10 Conversion, New York State OON Bill, Medicare Renewal, etc.
• Directly interact with Claims, Finance, Underwriting, Benefits, Enrollment, and Provider Relations.
• Act as a liaison with vendors, maintain and support various third-party software.
• In charge of complete design, development and support of Over-The-Threshold system that captures claims exceeding a set dollar amount for Audit and Clinical Review. The application is web-based; the latest version is developed using MS Visual Studio 2013 & Oracle SQL Developer 4.1.2.
• As a Subject Matter Expert, prepared technical design documentation and user manuals for Capitation System; trained a team of programmers to support and improve it.
• Technical owner of Benefits Administration system - a web-based application that serves as a single repository for Benefits information and interacts with various internal applications and vendors. Responsible for application development and upgrades, ETL processes (SSIS, SQL*Loader), built-in and ad-hoc reports (Crystal reports, SSRS).
• Maintain and support QCARE WE system - a web-based presentation enhancement to mainframe platform that encompasses Claims, Member & Provider Relations and other key systems.
• Responsible for development and support of Claims Audit Tracking System that enables claim system auditors to randomly select and inspect claims adjudicated by examiners.
• Developed back-end (Oracle PL/SQL) enhancements to Consolidated Provider system.
• Technology: ASP.NET/VB.NET, JavaScript, Ajax, Oracle, PL/SQL, SQL*Loader, MS SQL Server, SSIS, SSRS, HostBridge, MFT.

System Analyst

Responsibilities:

• Designed, developed and supported Benefits Administration system - ASP.NET application that serves as a repository of Benefits information, provides an interface to create various Benefit products and feed internal and external automated systems. The application communicates with CICS via HostBridge.
• Participated in design, development and implementation of Web services in CICS Transaction Server.
• Served as Technical owner of Capitation System that calculates monthly payments to physicians and ancillary providers. In charge of enhancements and production support of multiple batch and online modules.
• Was in charge of development and support of PCP Auto-Assignment process that ties unassigned members to physicians based on networks, service areas, family links and other criteria.
• Contributed to integration of various web and mainframe based applications during consolidation of HIP and GHI as parts of EmblemHealth.
• Created technical design documents based on business requirements.

Confidential, NY

System Analyst

Responsibilities:

• Conducted full Project Life Cycle for Enrollment, Capitation and Benefits projects.
• Contributed to integration of various applications during acquisition of Vytra and Connecticare.
• Designed, developed and implemented ancillary Capitation and premium-based Medicare Capitation module.
• Was major contributor to development of Benefits Automation process that connects Windows-based application with CICS via COMTI.
• Was in charge of development and enhancement of Claims Archive/Restore process.
• Engaged in development of Provider Profiling system.
• Designed and developed Dun & Bradstreet COB member surveys.

Programmer Analyst

Responsibilities:

• Participated in development and support of Claims, Member and Provider subsystems.
• Analyzed, developed and implemented PCP Capitation Reengineering, including batch and online modules.
• Participated in development and implementation of Capitation system.
• Participated in maintenance of Multi-Currency Account Relationship system.
• Participated in development of Customer Checking Account maintenance system.
• Participated in development of Steel Melting Process Management application.