SUMMARY:

• MS SQL Server (2008 - 2014) programming including store procedure, trigger, SSIS, SSAS and SSRS.
• Practical knowledge of healthcare integration platforms, frameworks, and standards (HL7, X12, HIPAA 5010).
• Microsoft .Net programming experience with C# and ASP.NET (Web Form and MVC) Visual Studio 2008-2015.
• Working Experience with Microsoft Dynamics CRM 2011-2016.
• E-commerce (EDI), supply chain and B2B experience.

SKILLS:

Systems: Windows 2008, 2003 Server, Windows (2000/NT/XP), VMware.

Databases: Microsoft SQL Server 2000, 2005, 2008, 2008 R2, 2012, DB2, Oracle DB.

Languages: Visual C#, C++, C and Java.

Technologies & Tools: Visual Studio 2010 to 2015, Web Service, Silverlight, WCF and WPF. Windows Team Foundation Servers.

Workflow: K2 Work Flow.

PROFESSIONAL EXPERIENCE:

.Net Developer

 Confidential, Houston TX 

• Participated in Medical Billing Portal project using Microsoft Dynamics CRM 2011-2016, SQL Server 2008 - 2012 and BizTalk 2010.
• Processed HIPPA 837, 835, 270/271, 277CA.
• Developed (SSIS) package which move claim information and message flow information into a Data Mart for reporting. Used SQL Server Analysis Services Cube which provides the ability for reporting and trending on claim data.
• Developed BizTalk Pipelines, Maps, Orchestrations, Business Roles and other components.
• Created and update solutions, plugins, workflows, entities, forms, views in the CRM system. Worked on data migrations and integration projects.

Database Programmer

Confidential, Houston TX 

• Developed integration projects for company ecommerce web using BizTalk 2010, DB2 and SQL 2008 R2.
• Created reports for different company departments such as accounting, purchase, asset protection and DTC (Direct TO Customer) using SQL Reporting Service and Integration Service.
• Support JDA allocation program with MMS, DB2 and Oracle database.

Senior Programmer

  Confidential, Houston TX 

• Developed a web application for biological/medical research using and Visual Studio 2010, Entity Framework and SQL 2008 R2.
• Provided analysis and supported to internal and external customers relative to HIPPA electronic exchange of data including enrollment, claims, payments, and clearinghouse activities.
• Monitors, activates, and operates claims processes, including data processing, technical support, systems operation, and documentation.
• Retrieved and analyzed vendor claims to ensure proper processing and payment (underpayment and over payment).
• Facilitated, implemented, and supported EDI transaction and code sets to meet HIPAA compliance, and supported other EDI relationships using BizTalk 2009 and C# with Visual Studio 2008. Upgraded it to BizTalk 2010 with SFTP adapter.
• Provided coordination with regulatory agencies and outside customer for proper claim retrieval, processing, and reporting.
• Executed, maintained, and monitored the process for reporting purposes and claim reports. Monitored and maintained EDI system logs to correct any operational errors.
• Trained users on help functions of internally created programs and with commercially bought programs.

EDI Business Analyst

Confidential, Houston TX

• Designed and implemented a .Net web application that provided the ability to view EDI and X12 810 in a formatted, user-friendly UI. The application is used for company main office to approve invoices. Skills and tools used included SQL server 2005, .Net 2.0 (C#, ADO.Net and ASP.Net), SQL 2005 Integration Service & Reporting Service, MS IIS, EDI X12, Account Payable Processing.
• Designed and created Database Schema, Stored Procedures, Views, and Triggers. Created SQL agent job to automate tasks and jobs.
• Designed and created SSIS/ETL package to migration EDI data from Access 2003 Database to SQL Server 2005 using SQL Server integration service.
• Designed and created reports for company accounting/AP and Store Management using SQL server reporting service.
• Integrated EDI Invoices 810 with PO 850 using BizTalk 2009

SQL Server DBA

Confidential, Houston, TX

• Performed daily DBA jobs (backup, morning check up).
• Troubleshoot concurrency issues and performance tuning. Maintained and optimized indexes.
• Monitored and troubleshoots SQL Server Performance.
• Performed data migration/conversion to move data from MS Access database and SQL 2005 to SQL 2008 using SQL integration service. Performed other development tasks with T-SQL, stored procedure and trigger.
• Participated in E-Commerce DW/BI development using MS SQL tools.
• Created reports for accounting and management with SQL Analysis and Reporting Service.

Senior Business Analyst/Developer

Confidential, Angleton, TX

• Participated in EDI integration project using BizTalk 2004 and BizTalk 2006 from Java based tool to Microsoft .Net BizTalk technology.
• Designed and developed data integration between EDI transactions (810, 850, 855, 856,824 etc.) and Baan ERP system with Communication Protocols (File, FTP, MS SQL, Oracle, HTTP and AS2).
• Developed asp.net/web application and workflow application using C#, ASP.NET, K2 work flow and SQL Reporting Service.
• Designed and developed a BizTalk file mover customer pipeline/adapter component using C# and WCF/Web Service.
• Provided project production support.
• Performed project migration from BizTalk 2004 to 2006.
• Integrated PO order process using BizTalk 2006 R2 EDI native support/functions.

Business Analyst/Developer

Confidential, Miami, FL

• Participated data conversion project, from Unix Pick system to Microsoft Great Plains using SQL Server DTS/SSIS.
• Mapped business process, data and application file layout between Unix ERP and Great Plains.
• Architected, designed EAI Projects using Window Server 2003, BizTalk 2004, C#, SharePoint and .Net technology.
• Responsible for EDI trading partner setup, maintenance and new system EDI (EDI 875, 880 etc.) implementation.
• Designed and developed Warehouse management integration with Great Plains using BizTalk 2004 and Great Plains Econnect.

EDI Systems Analyst

Ellwood City, PA

• Participated Ecommerce conversion project, from Inovis and TrustedLink to BizTalk
• Designed, and planed EDI / EAI environments using BizTalk 2002.
• Performed data mapping according to standards, business process analysis and development.
• Developed EDI transaction sets in accordance with company business requirements, trading partner guidelines and best practices.
• Implemented and document change control procedures related to EDI and coordinated with members of all departments to meet customer guidelines.
• Designed and implemented testing procedures.

EDI Admin/Specialist

Confidential, Houston, TX

• Designed, implemented, and set up EDI system and relationships with partners using Sterling - Gentran tools.
• Performed system maintenance and administration job. Monitored daily EDI transmissions with 850, 810, 820, 856, and 210.
• Designed and created import and export maps and translation objects using application integrator.
• Developed and designed Bar Code and Label (UCC 128 Carton Labels) using Bartender tool.
• Programming and system integration
• Designed, developed, and integrated Freight Bill (EDI 210) program with a UNIX based order entry system.
• Converted Freight Bill program to Microsoft Great Plains with Microsoft SQL 2000 Enterprise Server.
• Designed, developed and integrated AR (EDI 820, 810) accounting program with Microsoft Great Plains.