SUMMARY:

• Result Oriented Consultant Senior Software Engineer with 12 years of experience in design and development of Multithreaded desktop, server Applications, Workflow Automation, ETL, database and data warehouse applications.
• More than 12 years of Experience in C#.NET, VB.NET, .NET 3.5 - 4.6, MS SQL Server 2008-201 4, T-SQL, WinForms, Win Services, ADO.NET, ORM, DevExpress Controls
• Developed and maintained numerous WinForms Applications containing complex grid controls, charting, collaboration, data entry and analysis tools with real-time data sync.
• More than 6 year Experience of SQL Server Database Administration, programming complex T-SQL applications, ETL of Healthcare/HIPPA data including; Meditech, Epic, Eclipsys, Eagle, SMS, SDK, PATCOMM, HBO data extracts
• 2 year Experience in WPF, UWP, XAML, WPF DevExpress Controls and MVVM
• Over 6 years of experience in Healthcare Revenue Cycle/Recovery Industry. Developed and maintained numerous data exchange applications for Healthcare eligibility, claims and payment information, including New York Medicaid(eMedNY) batch and real-time, Medicare(HETS), Empire Blue Cross, ENS Health and Ability Access System. Consumed SOAP/MIME/REST based APIs.
• Excellent knowledge of EDI/X12 ; 270/271, 276/277 documents interchange.

TECHNICAL SKILLS:

• C#, VB.NET, .NET 3.5-4.6, WinForms, Win Services, Web Services, SOAP, WSE, WCF, REST, XML, X12, EDI, ORM, LINQ, ADO.NET, ETL, Multithreading, TPL, DevExpress Controls
• MS SQL Server 2008-201 4, T-SQL, Stored Proc, UDF, CLR-UDF, Views, Indexes, Indexed Views, Triggers, Dynamic SQL
• Experience in Entity Framework, WPF, UWP, XAML, PowerShell, P-Invoke, C++/CLI
• Visual Studio 2008-201 7, LINQPad, SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Principal Software Engineer/Architect

Confidential

Responsibilities:

• Designed and implemented Universal Windows App (UWP) Video and Audio Cutter Application for Microsoft Store using Microsoft Player Framework and FFmpegInterop.
• Designed and architect Ability Access Services application. A bespoke information exchange gateway that exchange HIPPA data with Ability Networks through its REST based API. Application automated the manual lookup of Medicare payments for our clients.
• Managed the development of eMedNY CSI gateway application. Implemented client library for eMedNY SOAP based API for exchanging Claim Status Inquiry & Response (276/277) files. Application completely automated the manual lookup of NY Medicaid payments for our clients.
• Managed and architect eMedNY high performance batch eligibility gateway to exchange Eligibility & Benefit Inquiry & Response (270/271) data with NY Medicaid for high volume needs. Application uses eMedNY SOAP API for batch submission of files.
• Designed and developed eMedNY real-time eligibility gateway to exchange Eligibility & Benefit Inquiry & Response (270/271) data with NY Medicaid. It uses eMedNY Meds History Service real-time SOAP API. MHS real-time uses NIST Level 3 authentication protocol and uses two factor authentication and message layer security (MLS)
• Worked on numerous other healthcare data exchange applications for exchanging data with Medicare, ENS Health, Empire (Blue Cross). Diverse experience of data exchange API/Standards across Healthcare industry including EDI X12, XML, propriety, CA HQ Core SOAP/MIME

Senior Software Engineer

Confidential

Responsibilities:

• Worked closely with Data Centre Architect in designing the Next-Generation High Compute Data Centre. Coordinated in designing, testing and deploying application policies for application layer firewalls. Provided software specification regarding hardware requirements for Enterprise applications. Helped in designing hardware systems tailored for enterprise applications. Data centre was built using highly scalable dense DELL blade servers, high performance SSD based SAN and 40Gbps fibre optic network backbone.
• Lead the migration to the new Infrastructure and completed with 0 working day downtime. Architect, design, install, and configure large, complex Microsoft SQL Server 2014 deployments utilizing TDE encryption, Resource Governor and other advanced features. Migrated databases, SQL agent jobs from the old servers. Implemented Maintenance Plans for automated backups, database maintenance. Migrated All enterprise applications to the new active directory domain with group policy based authentication and security.
• Provided Application support in day to day operations for all Enterprise Applications.
• Developed a new line of product for FQHC (Federally Qualified Health Centre) clients to discover secondary payments. Application discovered more than $50K worth of billable accounts in a trial run for a small client.
• Upgraded Medicare Eligibility lookup to add option of Dates of Service Span. Upgraded all lines of Revenue discovery products to make use of Dates of Service Span. Solution involved very complex Post Back logic. It reduced costly Medicare eligibility lookup up to 30% and allowed RTech to be complaint with Medicare eligibility lookup regulations.
• Took ownership of All Payers line of products and provided analysis to Business users for troubleshooting and process enhancements. Added application logic in ETL and discovery process to capture recurring outpatient visits resulting in a 20% increased revenue.
• Extensively used LINQPAD for C# LINQ queries, ad hoc programming, data analysis, Excel report generation, ad hoc ETL, SQL scripting, SQL deployments, Meta Programming
• Improved the functionality of Test Environments and Introduced DevOps culture for rapid testing and release cycles.
• Managed the upgradation of all applications and Infrastructure to handle the ICD10 procedure and diagnosis codes.
• Designed and developed Medicare CSI (Claim Status Inquiry) workflow for IME and All Payers line of products. It automated the process of posting IME payments to potential account hits and thus reduced manual lookup of accounts. Process was implemented with a complete audit trail, logging and performance measurements. Technology used: Visual Studio, .NET 4.0, LINQ, ADO.NET, TPL, T-SQL, DevExpress controls
• Managed Digital Certificate Store and acquired/maintained certificates from business partner/CA for client authentication/encryption/code signing
• Developed a WPF based Expense and Resource Tracking Desktop Application Technology used: Visual Studio, C#.NET 4.0, LINQ, PetaPoco, TPL, T-SQL, DevExpress WPF controls, DevExpress MVVM framework

Software Engineer

Confidential

Responsibilities:

• Provided Application support in day to day operations. Maintained and troubleshoot ETL operations and Medicare IME (Indirect Medical Education) and Medicaid GME (Graduate Medical Education) line of products.
• Re-Architected GME line of product with multi pass data analysis. It reduced the eMedNY (New York Medicaid) healthcare eligibility lookup volume by 30%. Enhanced the existing name search process to find additional accounts. Introduced table driven logic that enabled quick changes in business logic on the fly. Implemented auditing for GME process at accounts and policy level that enabled Business Analysts to analyse complex business logic and reacts to changes quickly.
• Designed and developed RTech Dashboard; a WinForms based desktop application which is a collaboration and workflow hub with real-time data and screen sync. State of the art UI controls from DevExpress used for data visualization, selection, navigation. Technology: Visual Studio, C#, VB.NET, WinForms, LINQ, ADO.NET, TPL, SQL Server, DevExpress controls,
• Administered MS SQL Server 2008 Enterprise servers; Expert in database creation, backup, creation and maintenance of Stored Procedure, UDF, CLR UDF, Indexes, views, indexed views, triggers, linked server, synonyms, database mail etc. Monitoring Event Viewer, SQL Error logs for Software and hardware related errors. Experience in Database Backups and Restores. Expert in query optimization, index tuning using SQL Server Management Studio, Query Analyser, SQL server profiler. Experienced in optimisation using query/table hints.
• Developed and maintained complex T-SQL based ETL applications for Healthcare data warehouse for more than 30 clients. Data extracts includes Meditech, Epic, Eclipsys, Eagle, SMS, SDK, PATCOMM, HBO. Analysed Healthcare/HIPPA data for discrepancies and missing information.
• Maintained complex .NET based Bespoke ETL application. Application consists of Desktop Application and a Win-Service counterpart. Desktop application used for configuration, scheduling, pre-load validation and monitoring. Data-load is automated using the multithreaded Win-Service. Fixed several bugs in pre-load validation and file decompressing and decryption. Technology used: Visual Studio, C#, VB.NET, WinForms, LINQ, ADO.NET, TPL, Multi-Threading, T-SQL, DevExpress controls
• Developed a complex algorithm to find insurance policies based on fuzzy match on Patient’s demographic information. It uses state of the art Error correction/Error prediction algorithms. It enhanced all lines of Revenue Discovery products and provided additional billable Revenue.
• Designed and implemented Medicaid CSI (Claim Status Inquiry) workflow for GME line of products. It automated the process of posting GME payments to potential account hits and thus reduced manual lookup of accounts up to 50% by business analyst. Process was implemented with a complete audit trail, logging and performance measurements. Technology used: Visual Studio, C#, .NET, WinForms, LINQ, ADO.NET, TPL, T-SQL, DevExpress controls
• Maintained bespoke Process/Job Scheduling engine. It consists of a WinForms based desktop application for configuration, monitoring and scheduling jobs and a high performance, multi-threaded win-service counterpart for job execution. Technology used: Visual Studio, C#, VB.NET, LINQ, WinForms,ADO.NET, TPL, Multi-Threading, T-SQL, DevExpress controls
• Maintained more than 5 eligibility Inquiry (EDI 270/271) data exchange gateways including New York Medicaid, Medicare, ENS Health (Commercial Payer), Empire (BlueCross BlueShield of New York). Maintained and enhanced X12 EDI parsing engine and fixed several bugs. Technology used: Visual Studio, C#, VB.NET, LINQ, ADO.NET, TPL, Multi-Threading, T-SQL, X12, EDI, OopFactory X12 Parser
• Completed certification and prototype for Pennsylvania Medicaid eligibility Inquiry system (EDI 270/271) based on CAQH Core 2.2.0 specifications.