PROFESSIONAL SUMMARY:

• Around 8 years of IT experience in C, C++, scripting, SQL and PERL on UNIX & Windows platforms and MSBI & PL/SQL.
• Involved in all the phases of software development life cycle SDLC process (Design, Development and Unit Testing, System Integration Testing and Functional Testing).
• Experienced in Oracle (SQL, PL/SQL, SQL Loader), Sybase (SQL advantage, DB Libraries), Informix, IBM DB2
• Exceptional hands on working knowledge and recent experience working with Pro* C and BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Exposure to scripting tools like Python and Shell Scripts.
• ANSI C, C++ (Network, Sockets, Standard template Libraries, POSIX Threads), GDB
• DBX, Sun workshop tools (Performance analyzer, workshop, etc.), DDE (HP - UX), VAC/C++
• Expertise in C/C++, Pro*C using Pointer, Structures, Macros, Functions.
• Knowledge on Medicare, Medicaid, MMIS, HIPAA EDI 4010/5010, 270/271, 276/277, 278, 820, 834, 835, 837, ICD-9, ICD-10, HL7, HMO, PPO, ANSI X 12 4010/5010.
• Experienced in creating Views, Stored Procedures, Indexes, functions and Triggers using T-SQL and PL/SQL.
• Experienced in migrating DTS Packages to SQL Server 2005/2008 and 2012 packages by using Migration Tools.
• Experienced in ETL - Extract Transform and Load experience using DTS & SSIS (SQL Server Integration Services) in SQL Server 2008R2/2012/2014 and 2016.
• Experience of metadata library development, management and upkeep.
• In-depth knowledge of metadata formats, standards and schema, descriptive bibliography and cataloging procedures.
• Operational knowledge of using Integrated Library System and metadata management software.
• Excellent analytical, design and problem solving skills using HP-UX, AIX, Solaris and Windows NT.
• Extensive knowledge of Medical Management Information Systems (MMIS), and National Provider Identification (NPI).
• Experienced in HIPAA compliance, Electronic Data Interchange (EDI) and implementation of HIPAA code sets, ICD-9, ICD 10
• Knowledge of Medicaid, Medicare, Procedural and Diagnostic codes and Claims Process.
• Working knowledge on Institutional and Professional claims for EDI and HIPAA Transactions 837/835, 834, 276/277, 270/271
• Knowledge of software application development, deployment and entire spectrum of necessary platforms for the smooth execution of projects. Strong communication, collaboration and team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2008/2012R2/2016(NT 6.0 - NT 10.0) Windows NT/XP/Vista/7/8/10 Linux, HP-UX, Sun Solaris, GNU/Linux and MacOSX

Languages: T-SQL, PL/SQL, .Net(C#,ASP,VB), HTML, UNIX, C/C++, Java and CSS

Tools: /Utilities: SQL Server Management Studio (SSMS), Query Analyzer, BIDS, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2008/2012/2014/2016, SQL * Plus.

Databases: Oracle 10g/11g/12c, MS SQL Server, MS Access, IBM DB2

Data Modeling Tools: Microsoft Visio, Ervin, Visual Studio

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, MS Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Business Objects.

PROFESSIONAL EXPERIENCE:

Confidential, Conway, AR

C/UNIX Developer (Pro *C)

Responsibilities:

• Responsibilities included designing, Coding, unit testing and documentation.
• Translating the business requirements into coding (C) and meet the project deadlines on time.
• Assisted in software design, creation of ER diagrams, phasing from development to QA and to production environment.
• Created PL/SQL programs to generate reports.
• Used Embedded SQL and Oracle SQL Developer to write programs on HP UNIX platforms.
• Involved in unit testing, integration testing, system testing and user acceptance testing.
• Written UNIX Ksh scripts to run jobs and utilities.
• Participated in design reviews and walkthroughs with project manager and development team.
• Worked on running quarterly, annual NCPDP/NDC updates from CMS as the Reference developer.
• Worked on MMIS and EDI transactions codes.
• Developed PL/SQL stored procedures to automate processes like Email Sending (UTL SMTP). This was used for both on-demand basis and pre-defined schedules
• Developed PL/SQL scripts, packages, procedures and functions used for migrating data from interchange to present DSS (Design Sub system).
• Created technical design documents for new custom Batch programs according to business needs for development team.
• Involved in production support for resolving end-users issues
• Extensive experience in writing SQL Queries, PL/SQL Stored Procedures, Packages, Functions, and Database Triggers
• Extensive experience in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TOAD from COBOL to Pro*C.

Environment: C, Pro*C, SQL, PL/SQL, Oracle 11g/12c, UNIX, Shell scripting, ksh, TOAD, SQL*Plus, and SQL*Loader.

Confidential, Denver, CO

C/UNIX Developer (Pro *C)

Responsibilities:

• Actively participated in gathering Business requirements to implement functional and technical specifications.
• Have good knowledge and understanding rules of HIPAA.
• Involved in creating new programs and jobs to generate reports as per the client request using Pro*C and shell scripts.
• Enhanced and created new metadata XML.
• Developed, implemented and evaluated metadata and cataloging workflows and standards.
• Created Pro*C program using Pointer, Structures, Macros, Functions.
• Involved in Production support for resolving end-users issues.
• Extensive experience in writing SQL Queries, PL/SQL Stored Procedures, Packages, Functions, and Database Triggers.
• Extensive experience in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TOAD from COBOL to Pro*C.
• Created technical design documents for new custom Batch programs according to business needs for development team.
• Involved in unit testing, integration testing, system testing and user acceptance testing.
• Receive claim data files from the business users and retrieve info for different fields from it.
• Implement business rules on all the fields fetched from the incoming claim data files using C & C++.
• Participated in design reviews and walkthroughs with team leader and development team.

Confidential, Conway, AR

C/UNIX Developer (Pro *C)

Responsibilities:

• Design & development on Claims & Reference - Adjudication, Edits-Audits and Pricing & Rules Engine modules.
• Developer for Rules engine (config changes, metadata changes, BPA load, rules conflict reports) and Reference (reports, rules, configuration, BPA).
• Ability to translate business requirements into technical specifications.
• Responsibilities included designing, Coding, unit testing and documentation.
• Developed C, C++ coding and tested the code to administer and support Medicaid claims.
• Worked with a team of developers to analyze project requirements and add functionality to existing C applications such as reading in claims in different formats from different sources, checking for errors, and converting them into a standard format.
• Conducted Unit testing for the C programming projects to support Medicaid Claims.
• Reading existing source code in C to determine current programming to match the business logic.
• Implemented HIPAA 5010 enhancement in the new MMIS system
• Wrote SQL queries for Oracle and SQL server databases.
• Used Embedded SQL and Oracle SQL Developer to write programs on HP UNIX platforms.
• Performed code reviews, unit testing and debugging the bugs and errors while testing and debugging with GDB debugger.

Environment: C, Pro*C, SQL, PL/SQL, Oracle 11g/12c, UNIX, Shell scripting, ksh, TOAD, SQL*Plus, and SQL*Loader.

Confidential, Rancho Cordova, CA

C/C++ UNIX Developer

Responsibilities:

• Worked on application development of Financial Billing Systems
• Developed applications using LavaStorm Business Rule Editor(BRE)
• Used BrainScript Language for coding
• Wrote SQL queries for Oracle and SQL server databases.
• Used Agile methodology for Software development
• Used GitHub for code repository
• Responsibilities included design, coding, testing and documentation

Environment: MS SQL Server 2012/ 2008 R2/ 2008, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2012/ 2010, Visual Source Safe, MS Office, VB Script, C#.NET, SQL Profiler, Red Gate Tools, Excel and Access.

Confidential

C/UNIX Developer

Responsibilities:

• Developed and tested software applications to administer and support Medicaid claims.
• Worked with a team of developers to analyze project requirements and add functionality to existing C applications and SQL databases, such as reading in claims in different formats from different sources, checking for errors, and converting them into a standard format.
• Used Embedded SQL and Oracle SQL Developer to write programs on Windows and UNIX platforms that interact with Oracle databases.
• Planned and implemented features in a team setting using C and troubleshooted reported issues with the compiler and interpreter for the company's homebrewed scripting language.
• Planned and implemented functionality in the interpreter for step-by-step execution, breakpoints, and reporting of traceback information for runtime errors.
• Implemented interaction with MySQL databases via the C API and handling of container objects such as arrays, hash tables, and user-defined data structures.

Environment: Microsoft SQL Server 2008/ 2008R2, Windows Server 2008R2/2012R2, Idera, VMware vSphere client, remedy ticketing tool.