Renuka Kwatra

Auburn Hills,

MI – *****

Ph: 248-***-****

Email: ac1iv9@r.postjobfree.com

https://www.linkedin.com/in/renuka-kwatra/

EXPERIENCE SUMMARY

7+ years of professional experience in all stages of SDLC (Software Development Life Cycle) involving studying of the user requirements, analyzing, designing, coding, implementation, debugging, testing, deployment and documentation across diverse industries / work environments.

Expert in developing web applications using .NET Framework (2.0- 4.0), ASP.NET, C#, VB.NET, ADO.NET, Web Services, LINQ, Entity Framework, MVC 4 and SQL Server with T-SQL and stored procedures

Extensive experience in HTML, ASP, XML, SOAP, XSLT, VBScript, JavaScript, jQuery, JSON, Angular JS2, SSRS and SSIS.

Currently involved in web development on .Net 4.5 platform using C#.NET, ASP.NET, MVC, LINQ, jQuery, JSON, Angular JS and Bootstrap 3 and knowledge of test driven approach using nUnit.

Good hands on knowledge of OOPS (Object Oriented Programming Structure) and Agile methodology.

Sound knowledge of 3-tier and N-tier layered architecture.

Developed projects in Waterfall, Iterative, Agile and Scrum Development Methodologies.

Extensive experience in creating rich content Web-Forms, Win-Forms (Windows Forms), Web User Controls, Custom Control, Server Controls, Windows Service and Web Service.

Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.NET and LINQ (Language Integrated Query) Providers for data manipulation.

Expert knowledge of versioning tools like TFS (Team Foundation Server), VSS (Visual Source Safe) and SVN.

Hands on experience with SQL Server 2005, 2008 & 2012.

Extensively worked on writing Stored Procedures, Triggers, Functions, Views and Database Design.

Created and maintained SSIS packages to Import/Export data from flat files, XML, Excel and Oracle.

Expert in designing UML diagrams like use cases and cross-functional diagrams and having good knowledge in database designs.

Extensive experience in the Healthcare, Insurance and Retail domain.

Excellent experience in performing duties pertinent to Healthcare ICD-9, CPT-4, HCPCS and designing SSIS packages to load the codes to system.

Experience in focusing mainly on the core-business of healthcare IT-HL7 Interface analysis and integration of applications from clinical and public health perspective to help providers in their

quest to achieve meaningful-use.

Work directly with the business to envision appropriate solutions, estimate effort, assess risks, and complete the overall development process.

Extensive experience in implementing and integrating the Payment APIs with third parties.

Have worked closely with business teams to understand the requirements and convert them to technical design documents.

Strong Coordination & Analytical skills for issue resolution involving various stakeholders, business owners, Support, Technical, Infrastructure and Application Teams for ensuring quality and timely Project Delivery.

TECHNICAL SKILLS

Software Tools and Technologies: Visual Studio (2005 – 2013), .NET Framework 3.0 – 4.0, ASP.NET, C#, VB.NET, ADO.NET, MVC, MVC 3.0, WCF, JavaScript, jQuery, Angular2, VBScript, VB6.0, XML, HTML, CSS, LINQ, Entity Framework, Web Services, WCF, Twitter Bootstrap, Team Foundation Server, SVN, Active Directory using LDAP, Lotus Notes, IIS 7.0.

Distributed Environment: BizTalk Server 2009, Managing SharePoint 2010.

Directory management: Active Directory using LDAP, Lotus Notes.

Databases: SQL Server 2005/2008/2012, Oracle.

EDUCATION

Bachelor’s Degree from Delhi University, India.

Post Graduate Diploma in Information Technology and Management from IMT, India.

PROFESSIONAL EXPERIENCE

Beaumont Health System, Nov 2014 - Present

Environment:

Visual Studio 2013, 2017, MVC 4.0, Razor, ASP.NET, Entity Framework, LINQ, C#, jQuery, JavaScript, SQL Server 2012, TFS, Twitter Bootstrap, CSS, Web Services, Angular JS, Angular2.

Project Details:

Developed multiple online applications for patients and physicians to help with patient care. Designed complex solutions to support the patient care for Surgical Services Department. Also developed applications to facilitate gift shop purchases and online bill payments in compliance to PCI Data Security Standard.

Accomplishments:

Design, develop, configure, deploy, create documents and maintains large and/or complex programs using a variety of software development toolkits, programming languages.

Testing/verification of applications and other tools, while adhering to specific development best practices and quality standards.

Coordinates deep troubleshooting and issue analysis, as well as coding, testing and implementing software enhancements and/or applying patches.

Drives process leadership for work groups, and product/service delivery strategy and work plans.

Providing technical direction for the development, design, and systems integration from definition

phase through implementation.

Designed various software solutions driving continuous improvement to processes, systems,

work-flow and client responsiveness.

Designed an application using AngularJS, Angular2 to record real time EC Wait time data.

Designed web services using C# to fetch the credentialing data for various physicians from visiting facilities.

Leading the effort to migrate legacy systems to the .NET framework with MVC & Razor.

Delivered cutting-edge developments such as Web-based customer online case boarding,

surgical paging, payments system along with dashboards and online patient portal using C#, ASP.NET MVC and Entity Framework.

Drove all phases of enterprise integration and process improvement projects to successful

completion, including application availability initiatives (Data Replication).

Responsible for ensuring successful implementation of projects or phases of projects.

Devises or modifies procedures to solve complex problems.

Gathers business requirements, translating that information into detailed technical specifications from which programs will be written or configured.

Has full technical knowledge of all phases of applications systems analysis and programming.

Migrated Oracle databases to SQL Server with new structures, created stored procedures, udfs, SSIS packages for various data ware house applications.

Assisted with planning and implementation TFS code repository standards. From branching to merging and work flow.

Providing 24X7 production supports on a mission critical basis.

Lochbridge Inc, Detroit, Nov 2013 – Nov 2014

Environment:

Visual Studio 2012, MVC, Razor View Engine, Entity Framework, C#.NET, JavaScript, jQuery, PHP, Scheme, SQL Server 2012, XML, SVN.

Project Details:

The project aims to develop an online Loan Origination System and provide desktop underwriter master checklist on website for all the USFS brokers.

Accomplishments:

Worked for one of the leading mortgage providers in Michigan USA.

Designed and developed an online Loan Origination System using C#, ASP.NET, MVC with Razor View Engine and bootstraps which enables the brokers to manage a loan online.

Handled validations and setup formulas using jQuery.

Design and integrated USFS legacy system with modern web based applications.

Supported existing system originally developed in PHP.

Enhanced the online pricing system for brokers which helps them to view the daily prices based on their mortgage insurance plans.

Designed a permission-group based architecture for Insurance brokers.

Drove all phases of enterprise integration and process improvement projects to successful

completion, including application availability initiatives (Data Replication).

Responsible for ensuring successful implementation of projects or phases of projects.

Devises or modifies procedures to solve complex problems.

Gathers business requirements, translating that information into detailed technical specifications from which programs will be written or configured.

Computer Sciences Corporation (CSC), July 2011 – Oct 2013

Environment:

Visual Studio 2008, ASP.NET, Classic ASP, VB.NET, C#.NET, JavaScript, SQL Server 2005, SQL Business Intelligence tools, Team Foundation Server 2008.

Project Details:

HFHS is committed to providing patient friendly communications that are useful and informative to patient and account guarantor. This project is intended to design, develop, enhance, support Patient Administration-Claims Administration CA/PCA project for this leading healthcare provider.

Accomplishments:

Worked for one of the leading healthcare providers in Michigan USA.

Designed, developed, enhanced, supported Patient Administration-Claims Administration CA/PCA project for this leading healthcare provider.

Developed utilities, SSIS packages to integrate the data between various clinical systems and load ICD-9, CPT-4, HCPCS codes to system.

Developed various tools for operations team using C#, SQL to setup the alarms in case of any system failures.

Developed utilities to generate the claim files for Insurance payers and setup automatic processes to transfer files using ftp.

Enhance system to increase the through put and decrease the turnaround time in claim processing for the healthcare provider.

Designed web solution using VB.NET, ASP.NET and SQL which enabled the provider to generate faster and accurate revenues.

Implemented processes to improve the clarity regarding the patient’s claims.

Supported inhouse applications written on classic asp and lead the effort to migrate them in .NET.

Devises or modifies procedures to solve complex problems.

Gathers business requirements, translating that information into detailed technical specifications from which programs will be written or configured.

Provided 24X7 production supports on a mission critical basis.

HCL Technologies Ltd, Oct 2005 – Apr 2011

Environment:

Lotus Notes Servers, Active Directory Servers, MS Outlook, Visual Studio 2005, ASP.NET, VB.NET, C#.NET, VB, JavaScript, SQL Server 2005, XML, Team Foundation Server, C#, VS.NET 2008, VB Script, SQL Server 2008 R2, XML, Microsoft Source depot.

Worked for various customers of HCL Technologies.

Project Details:

a.Microsoft Outlook Integration: This project aims to integrate MS Outlook services with RDA T & I (Task & Incidents) application. The purpose of the application was to generate business reports and pass it on to the business Users.

b.Lotus Notes Synchronization: This project aims to sync the users information between different directory management servers. It used to pick data from Lotus server and sync the same to AD server on daily basis.

c.Group Contract is a software product meant to enable group annuity with the states. There will be a group certificate contract issued to the Broker/Dealer and certificates issued to individuals who purchase this product. The product will be filed with the SEC as a registered fixed annuity. This also will be offered to a group of clients with positions in account at the brokerage.

d.This project takes care for the Clearing Operations that happen after the Trading hours of Stock Market. There are two modules in this project: Clearing Office (or COPC, used by Stock Exchange Clearing Personnel's) and BackOffice (or BOPC, used by Members/Brokers of the Exchange). COPC / BOPC applications send different queries/transactions to the specific server subsystems running on different machines.

e.The Compass-Canada processes several thousand invoices per year from its suppliers. These invoices are submitted to the Accounts Payable department in London, Canada in paper format, where the A/P executives manually verify for quantity, items & their prices, extended amounts, taxes and invoice totals before they are entered into the JDE system for final payments to the supplier.

Accomplishments:

a.Integrated MS Outlook services with RDA T & I (Task & Incidents) application using C#. Generated business reports and pass it on to the business Users.

b.Developed a tool to sync the user’s information between different directory management servers. It used to pick data from Lotus server and sync the same to AD server on daily basis using C#.

c.Designed the interfaces to provide a robust framework for integration between all Hudson systems. All the interfaces are designed in Microsoft BizTalk Server 2009 and the backend components developed on SQL server 2005. The common libraries were developed in C#.

d.Integrated ePro, PeopleSoft and Oracle systems across ANZ through Interfaces that will continue to support Hudson Business Processes.

e.Generated Stubs for COPC/BOPC to validate the calculated stock prices using XMl/XSLT.

f.Designed and developed Group Contract software product meant to enable group annuity with the states. This application was designed and developed using C#.NET, java/VB script, ASP.NET and SQL.

Contact this candidate