Baljeet Kumar

Technical Lead Phone: +1-502-***-****

Tata Consultancy services limited [TCS] Email: acs10f@r.postjobfree.com

Experience Summary:

An Associate of Tata Consultancy services having 10+ years of IT experience. 3+ years with Technology Lead experience and 5 years in Healthcare domain with Medicare, Medicaid and Humana 1 plans.

Currently located in Miami FL & working with H-1B work permit in USA.

I have been in Melbourne AUS for 1 year to make LIVE on PROD server for TEMPO Holidays.

My Technological forte:

ASP.NET 4.0,3.5, 2.0 C#, SSRS, Dependency Injection, WCF, MVC, Web Services, Web API, Qlikview, Design Patterns, XSLT, XML, AngularJs, Dependency Injection

SQL Server 2005/2008, PL/SQL, Toad

Ajax, XML, XSLT, HTML, JavaScript, Agile Methodology, Scrum

Good problem solving abilities, communication skills, Quick learner and also a good team facilitator.

Career Profile

Dates

Organization

Role & Designation

July-2011 to Till Date

TATA Consultancy Services Ltd.

Team Lead/Project Lead

Oct-2006 to July-2011

InterGlobe Technologies Pvt Ltd.

Sr. Software Engineer / Module Lead

Dec-2005 to Oct 2006

Cantata Solutions Noida

Software Engineer

Technology

Languages

:

C# and T-SQL, JavaScript, CSS, XML, XSL, AngularJs

Framework

:

ASP.NET 1.1, NET 2.0 / 3.5 and .NET 4.0

.NET Skills

:

WCF, MVC, Web Services, ADO.Net, WEB API, LINQ

SQL Server Report Service( SSRS ), Dependency Injection

Tools

:

Visual Studio 2012,2010/2008/2005

Toad

Visual SourceSafe, SVN,TFS

Databases

:

SQL Server 2005 / 2008, Oracle

Web Servers

:

IIS 5.0 onwards

Others

:

XML, XSLT,JavaScript,HTML

Training Attended:-

WCF, MVC trainings attended in InterGlobe Technologies.

Assignments

The details of the various assignments that I have handled are listed here, in chronological order.

Assignment#1:

Project

Chameleon Application

Customer

HUMANA

Period

April 2015 – Till Date

Description

Chameleon is a practice management system (PMS) which supports the day to day operations of the providers of CAC Miami Florida, Concentra, MPM and CNU. These four groups of providers use Chameleon for storing patient information, storing provider information, scheduling appointments, patient engagement and other activities. These four groups of providers are segregated as companies in Chameleon and the user is prompted to select a company during the logon. Users will have access only to the company they belong to and the databases are also split by company. This is to make sure that user from one company will only be able to see information of that company. From version 3.2, a feature called subnet will be added to Chameleon which will default a user to a particular company based on the subnet value. At a high level the modules in Chameleon are split into:

Scheduling

Patient

Other Applications

Cash Collection

Utilities

Gatekeeper

Maintenance

A comprehensive list of all the modules that are available in Chameleon is covered in the below sections. Chameleon is integrated with e Clinical Works, another practice management system Chameleon is integrated with Crystal for its reporting requirements. The reports that can be generated by a user are dependent on the role of the user

Role

Technical Lead

Solution Environment

Technology: ASP.NET 2012,MVC,Dependency Injection, SQL server 2008

Tools: SQL Server 2008, SVN

AngularJs – Creating web portal for above said chameleon using AngularJs.

Responsibilities

Requirements Gathering and analyzing the functional specifications of multiple Modules of Chameleon by discussing with Business & Architect.

Code review and offshore coordination.

Performed Unit Testing after enhancement of the functionalities.

SQL server Stored Procedure optimization.

Assignment#2:

Project

Senior Product Actuarial & SSRS Reports with Oracle

Customer

HUMANA

Period

Sep 2013 – March 2015

Description

The model is used to price a plan and produce a Bid Pricing Tool by combining input from different excel document templates. These documents include the SAM, MaRS, MACTAPT, etc. and can modify which counties are in a plan all the way up to what trends are being used to price a plan forward. Once a template from every desired excel document has been entered into the model, you can begin to customize the plan you are pricing. Anything from desired profit to which plans are to be blended into the current plan can be selected. Once everything has been entered in correctly, the user can then create a Bid Pricing Tool.

Original & Current Purpose of Tool

The bid model has many functions and can complete dozens of tasks that align to just a few main goals.

1.To semi-automate the pricing and production of BPTs.

2.Emulate BPT calculation mechanics.

3.To calculate member cost share.

Over the years, the goals have been expanded to include:

4. Feed financial information to be used by the SCT.

5. Reconcile and Validate Benefit and Plan data against Senior Product Design's PBP process.

a.The PBP or Plan Benefit Package is a structured database report that is submitted to CMS at the same time as a BPT.

Goal #1

This became the primary goal of the model due to the high volume of data that needs to be processed to produce the hundreds of MA plans serviced by Humana.

Goal #2

It is information in the BPT that sets the baseline revenue assumptions that are used by CMS when determining the amount of payment to Humana. In addition, the member premium for the plan is determined in the BPT. Thus, it is important to have a quick way to gather these revenue assumptions as calculated by the BPT.

In essence, the MA Bid Model is a recreation of the math performed in the bid form.

Goal #3

Back in the day when Humana only had 23 Medicare Advantage plans, we could only price for a handful of benefits. As our data processing capabilities grew we were able to expand our cost and utilization data to price for 50+ different benefits. This increases accuracy of cost sharing estimation.

At the moment, the Bid Model is the only major tool in MA-Actuarial that can calculate cost sharing with this level of detail. Most other tools are just using an approximation that uses prior years claims data or information that comes from the Bid Model.

Goal #4

This goal was added after the creation of the SCT as an official communication tool of actuarial projections. The Bid model provides financial summaries from bid data to be used as reference in the SCT.

Goal #5

This goal was added to improve the partnership with the Senior Products Design team and to ensure what gets submitted in the PBP matches what is being priced for in the BPT.

Role

Technical Lead

Solution Environment

Technology: ASP.NET 2010,MVC, SSRS, with C#, Qlikview, SQL server 2008

Database: SQL server.

Responsibilities

Understanding and analyzing the functional specifications of Bid Model and its coordinating data applications

Turning Developed code to different environments (i.e TEST, QA & PROD).

Liasion with client & Code review and offshore coordination.

Performed Unit Testing after enhancement of the functionalities.

SQL server Stored Procedure optimization.

Oracle PL/SQL queries for SSRS reports.

Assignment#3:

Project

ePharmacy Production Support Team

Customer

HUMANA

Period

Jan 2013 – Aug 2013

Description

PCMS ( Pharmacy Campaign Management System ) & DrFirst Application

Pharmacy Campaign Management System is one of major revenue earning systems for Humana where Campaigns are executed to encourage members towards cost saving. Some examples of such kind of drive can include making aware members to switch their claims from Retail to Right Source or from Brand drug to less expensive generic drug. Humana is in contract with some vendors to accomplish this.

From technical perspective, this system manages drug claims of a member. It calculates savings for a member if he /she switch to Right source Pharmacy; takes Alternative drugs instead of Brand drugs or takes alternative drugs from a Right source Pharmacy. Every such execution for a set of members is called a Data Run

Role

Technical Lead

Solution Environment

Technology: ASP.NET,MVC SSIS with C#

Tools: SQL Server 2008, SVN

Responsibilities

Understanding and analyzing the functional specifications of multiple SSIS packages.

SQL Servers.

Performed Unit Testing after enhancement of the functionalities.

SQL server Stored Procedure optimization.

Assignment#4:

Project

ACE (Analytical Consumer Ecosystem)

Customer

HUMANA

Period

Aug 2011 – Dec 2012

Description

. The ACE program cares for the delivery of a system comprised of applications supporting all consumer touch points. ACE ensures that the data is collected and stored in an aggregated location that is accessible by all areas of the business for consumer analytics. These consumer analytics inform campaign and communication management, message/interaction personalization, and an enhanced consumer experience.

The key components of ACE are…

Aggregate Consumer Data by creating an Operational Consumer Hub.

Inform Business Processes with Consumer Analytics by providing an environment and tools for analysis, reporting, predictive modeling and enhanced visualization

Enable strategic, personalized messaging (including prioritization and governance) for sales campaigns and member communications including:

- Right message - Right time

- Right frequency - Right channel

Enable an enhanced consumer experience both real-time and scheduled interactions

Role

Module Lead

Solution Environment

Technology: WCF, MVC, ASP.NET with C#, SQL server 2005, XSLT, XML

Tools: SQL Server 2005 management studio, Visual studio 2008, IIS6.0, Microsoft VSS

O.S : Windows XP

Responsibilities

WCF service Person Service, Person Policy Service, Authorization service

Implemented XSLT to include version 2.0 request & Response.

Understanding and analyzing the functional specifications

Performed Unit Testing after development of the functionalities.

Coordinating the team and helping the in getting the tasks done.

Assignment#5:

Project

Sky Team

Customer

Sky Team Amsterdam

Period

Dec 2010 – JuL 2011

Description

The main objective of this project is to build an interactive and feature-rich online. Travel Planner to offer SkyTeam’s agents, corporate and end-B2C customers a way to build complex Round the World (RTW) itineraries in full compliance with SkyTeam’s product rules and sales conditions. The Travel Planner tool will allow users to select a complete set of destinations, to select the associated scheduled flights and display a fare estimate through an unfailing and easy to use interface.

The solution being built would stress the importance of the end-user interface and will consider this aspect as a crucial differentiating point. The ultimate goal of the Travel Planner tool is to generate leads and strongly engage potential customers to purchase a ticket. At the end of the RTW process, customers will hold all necessary information: valid itinerary, required volume of miles, flight schedules, fare estimate to purchase a SkyTeam RTW or a regional pass trip at any given airlines’ point of sales and/or travel agent’s desk.

Role

Module Lead

Solution Environment

Technology: WCF, MVC, ASP.NET with C#, SQL server 2005

Tools: SQL Server 2005 management studio, Visual studio 2008, IIS6.0, Microsoft VSS

O.S : Windows XP

Responsibilities

By using WCF service KLM Web services consumed to calculate the fare corresponding to a particular route.

Understanding and analyzing the functional specifications

Involved in code review and coding for one module of the project

Performed Unit Testing after development of the functionalities.

Coordinating the team and helping the in getting the tasks done.

Assignment#6:

Project

Travel Holidays Online Reservation system 2(THOR 2)

Customer

TEMPO Holidays Australia

Period

Oct 2006 – Nov 2010 (1 year Client location in Melbourne AUS)

Description

THOR is a comprehensive Front, Mid Office and Back-Office online Reservations management system which can be used by wholesalers, travel agencies, customers, suppliers and company staff to manage the lifecycle of a booking right from the time a quote is created to the time of dispatch of travel Documents to the client.

The system meets the growing business needs of Tempo Holidays Pty Ltd. It allows greater partnership of Tempo Holidays with its Customers and suppliers by bringing them together on a common platform. The System allows complete management of travel products and bookings.

Extensive management and reporting capabilities provides transparencies And allow staff to focus on most complex aspects of business processes.

Role

Sr. Software Engg.

Solution Environment

Technology: WCF, Asp.net 2.0, SQL Server 2005, XML, CSS

Tool: Visual studio 2005,sql server management studio, VSTS (for source control), MS Visio

Responsibilities

WCF is used to communicate between FACADE layer and DATA Access layer.

Prepared the unit test cases

System deployment on production server in AUS. POC,

Liaison with client,

Requirement Analysis documents and impact analysis documents.

Time estimations

Assignment#7:

Project

Accounting Module (THOR)

Customer

TEMPO Holidays Australia

Period

Mar 2007 – Oct 2007

Description

Accounting module for THOR provides multi-currency transaction facility. This module is for B2B, B2C users. There are many stages & accounting templates in system corresponding to which accounting of the system works.In this module user can make payment, refund and journal for the client. For supplier it provides the facility to create batch and clear that batch and refund, journal. Invoice raise and credit note can be done from this module.

Role

Sr. Software Engg.

Solution Environment

Asp.Net 2.0,

SSRS ( Sql Server Reporting Services ),

Application blocks and SQL SERVER 2005

Tools Used

MS Visio

Responsibilities

Coding and Unit Testing

Multiple Payment Gateway

Conversation with Onshore client.

Uploading the SSRS report on PROD server.

Assignment#8:

Project

Travel Wire

Customer

Leading Company in America

Period

Dec 2005 – Oct 2006

Description

This is a web solution which is used to provide information about Air and Accommodation corresponding to the search criteria. User must be a registered user to search and book using this portal.

Role

Software Engineer

Solution Environment

.Net 2.0, Application blocks and My Sql

Responsibilities

Coding and unit testing.

Assignment#9:

Project

Restaurantplace.com

Customer

Leading Company in America

Period

May 2005 – Dec 2005

Description

This is a site which provides information of restaurant of USA. In this site there is detail information of uploaded restaurant and there images and menu are also given. There are four type of user entry in this site. One is Portal Admin that manages all restaurants. Second section is for RO in which the restaurant owners who have paid for the service can change their restaurant image or can edit their menu.

RO can publish the coupon and able to get feedback from guest. RO can publish feedback.3rd is the guest user who can upload image and feedback can get coupon.4th is the general user can search restaurant using different search conditions.

Role

Software Engineer

Solution Environment

.Net 1.0, SQL SERVER 2000.

Responsibilities

Coding and Unit Testing.

Contact this candidate