** ***** ***** ** ******: 940-***-****

Yonkers, NY, 10701 RAVALI REDDY TUMMA addl3v@r.postjobfree.com

www.linkedin.com/in/ravali-reddy-tumma

Professional Summary:

Software Developer with experience in various phases of Software Development Life Cycle (SDLC) i.e. Analysis, Design, Development, implementation and testing of windows and web-based software applications using C# .NET, Web Services, T-SQL, XML, .NET Framework.

Expertise in writing complex database queries, stored procedures, views, functions, indexes and triggers using MS SQL.

Hands on experience in LINQ (Language Integrated Query) and Entity Framework by retrieving data from various data sources.

Experience in Database design, Modeling and Database maintenance in MS SQL Server environment.

Hands on experience with OOPS concepts, JavaScript and HTML.

Knowledge of the healthcare integration standards (HL7, CDA, CCDA, FHIR).

Developed FHIR API endpoints.

Ensured that the code was HIPPA compliant, and that HIPPA best practices were followed.

Performed unit testing using NUnit and also performed several integration testing.

Managed work items in Microsoft Team Foundation Server.

Trouble-shot and fixed problems through customer requests, and QA.

Used agile methodology for Application development.

Strong analytical and dynamic troubleshooting skills coupled with excellent communication skills and able to work individually and as team.

In-depth understanding of data structures and algorithms.

Exceptional ability to learn new technologies and deliver outputs in short deadlines.

Education:

Master’s in Engineering Technology

University of North Texas (Aug 2015 – May 2017)

Bachelor of Technology in Electrical and Electronics Engineering

Jawaharlal Nehru Technological University, Hyderabad, India. (Jul 2011–May 2015)

Technical Skills:

Languages

C, C++, C#, Java

.Net Framework

.Net Framework 4.0,4.5,4.7

Databases

SQL

Web Technologies

HTML5, CSS3, JavaScript, JSON, XML

Web Servers

Internet Information Server (IIS)

IDE and Tools

Microsoft Visual Studio, MS Office, SQL Profiler, SQL Server Agent, SQL Server Management Studio, NUnit

Software Engineering

Agile, SDLC

Version Control Tools

GIT, TFS

PROFESSIONAL EXPERIENCE

Aprima Medical Software - Texas, USA Jan 2019 – Present

Software Developer

Company Description: Aprima’s electronic health record (EHR), practice management (PM) and revenue cycle (RCM) solutions are designed to complement and simplify physicians/practice workflow, while improving productivity and profitability.

Responsibilities:

•Gather and evaluate user requirements in collaboration with product owners and other stakeholders

•Build component to send Billing information from different eMDs EMRs to single application (EKOS). EKOS enables to view and modify RCM Billing information of eMDs RCM clients.

•Build Web API to consume RCM Billing payloads.

•Participate in all phases of design and development; to defining the REST APIs using C# & SQL; to writing the codes and tests.

•Experience in HL7 interface deployment for clinical laboratory, anatomic pathology and EMR’s, including obtaining customer use cases and requirements, creating implementation project plans, and maintaining implementations and testing.

•Creating modules and components and coupling them together into a functional app

•Work in an agile environment following agile practices

•Define, create, and validate HL7 data mapping

•Modify database objects (i.e. Clustered and Non-clustered index) to improve performance

•Write, debug, and tune stored procedures, triggers and user-defined functions

•Maintaining the source codes in Team Foundation Server (TFS) server for each change made in application code

•Involving in fixing application bugs, providing Production Support and maintenance

•Write complex SQL queries with joins on multiple tables, stored procedures, triggers

•Create custom Press Ganey SQL reports for clients

•Develop FHIR API endpoints

Environment: SQL, HL7, FHIR, .NET, CQM, XSLT, XML, JSON, TFS, GIT, Angular,Visual Studio, C#

Aprima Medical Software - Texas, USA Jan 2018 – Dec 2018

PRM Technical Analyst

Responsibilities:

•Research and resolve SQL Server software and database issues

•Install and maintain SQL Servers

•Establish and maintain backup and recovery processes

•Provide critical problem resolution in virtual servers

•Handle database corruption issues

•Deploy and upgrade application databases

•Work with SQL Server Replication

•Track and resolve database related incidents related to performance, capacity limitations, and replication

•Troubleshoot SQL code and design (stored procedures, indexes, triggers, constraints, etc.)

•Closely working with development team and writing T-SQL scripts to resolve application bugs

•Modify database objects (i.e. clustered and non-clustered index), process and rebuild indexes to improve performance

•Export/import database via SFTP

•Monitor blocking process/deadlocks to improve performance

•Exercise judgment within general defined practices and policies in selecting methods and techniques for obtaining solutions

•Perform data refresh from production to test environments

Environment: SQL Server, SQL Server Management Studio, Salesforce, TFS, Visual Studio, C#

MI Softech Inc - Collierville, TN, 38017 Aug 2017 -Jan 2018

Programmer Analyst

Company Description: Delivering the best-suited technology services and solutions to empower the customers to realize their business goals

Responsibilities:

•Develop page layouts, navigation and presented designs and concepts to the clients and the management to review

•Create the triggers, views, user defined functions and indexes required for the project to perform data transactions

•Optimizing, debugging and creating T-SQL stored procedures in MS SQL Server

•Write complex SQL queries with Joins on multiple tables, define roles, create database users

•Decide all the Security Concern (IIS Security, Web application security and Database Security) needs to be taken during application development

Environment: SQL Server, SQL Server Management Studio, TFS, Visual Studio, C#

Contact this candidate