BALAMURUGAN PANNEERSELVAM

Long Beach, CA

aceboq@r.postjobfree.com

562-***-****

EXPERIENCE SUMMARY

Has 4.8 years of industry experience in Design, Development and Maintenance of Enterprise applications on

the .NET Platform and MSSQL database.

Has versatile exposure to MS SQL Server (2008, 2005) Server Programming ASP.NET, C#, in Unit testing

using Visual Studio 2010, Exposure of end to end product development life cycle.

Certifications

America’s Health Insurance Plans PARTA

Querying Microsoft SQL Server 2012

TECHNICAL SUMMARY

Languages and tools : C#, ASP.NET, Crystal Report,SSIS, SSRS

Databases : SQL Server 2005 and SQL Server 2008

Scripts : HTML, CSS, Java Script

OS : Windows XP, 2003, Windows 7

ENGAGEMENT OVERVIEW

Employer: Infosys Ltd. Bangalore, India Jan 11 – Date

Role: Senior Systems Engineer

Employer: Pathfinder Business Analysis Pvt Ltd

Role: Software Programmer

Responsibilities:

Requirement gathering, Design, Development and Code reviews, Unit and integration testing

DETAILS OF THE PROJECTS WORKED ON

Project Name :

01 Application Development and Maintenance

Client : Molina Healthcare

Description of the Project : This project under ADM involves modification of Eligibility

inbound and outbound interfaces. It also includes automation of

interfaces using SSIS. These projects involves transfer data from

one database to another database to output files, input files to

database. This involves implementing necessary logic to load

input files to database, generating reports from dataset.

Generating report from various formats.

Page 1 of 4

Role : Senior System Engineer

Responsibility : Estimation, requirement gathering, Development and Code

reviews, Unit and integration testing

Duration : Dec-2013 to Till Date

Software : .Net Framework 3.5, SQL Server 2008.

Hardware : Windows XP, Linux

Project Name :

02 QBLUE ITS Automation

Client : Horizon BCBSNJ

Description of the Project : ITS Automation project which involves Automating ITS claims

load and processing post ITS 13.5 upgrade. Client has decided to

discontinue the support from the QBlue vendor and selected a

solution to process the claims using the existing 13.0 processes.

Local ITS will receive SF's from host plans and send to MPL for

837 conversions. The step down 837 files are loaded and

Adjudicated by QBlue and QBlue will send DF extract to MPL.

The Step down RF for the claims will be sent to QBlue to

finalize the Claims. QBlue will then send the finalize claims data

to downstream Systems (UPS, EDW, MPD).

Senior System Engineer

Role :

Estimation, requirement gathering, Development and Code

Responsibility :

reviews, Unit and integration testing

Apr-2013 to Nov-2013

Duration :

.Net Framework 3.5, SQL Server 2008.

Software :

Windows XP, Linux

Hardware :

03 Project Name CPL Benefits Migration

:

:

Client Horizon BCBSNJ

Description of the Project This is a re-engineering project wherein the existing Horizon

:

Benefit information from multiple sources onto its Central

Product Library (CPL) system. The project helps an automation

solution to address the manual migration challenges, thereby

reducing the turnaround time (TAT) and resulting in cost savings

to the client.

:

Role Senior Systems Engineer

Responsibility Responsibilities include requirement analysis, preparation of

:

detailed design, code walkthrough, resolving technical and

design issues, onsite-offshore coordination and independent unit

testing.

Duration Jul-2011 to Mar-2012

:

Software : Microsoft Business Intelligence SSIS package, SQL Server, MS

Excel and Lotus Notes.

04 Project Name Data Integrity Production support

:

:

Client HORIZON

Page 2 of 4

:

Description of the Project This project involved analyzing the Membership and Enrollment

details for the member‘s from QBlue system with NASCO NMS

(New Membership System). This requires analysis of existing

production data in QNXT Systems.

Role Business System Analyst

:

:

Responsibility Production Support Analysis, Finding the root causes.

Duration Mar-2011 to May-2011

:

:

Software Microsoft SQL Server 2005,QNXT Application, Nasco Formats

database

0 Project Name : Intranet Portal

5

Client : O’Connor & Associates

Description of the Project : Intranet Portal is an Application which fastens the

communication between the employee and the

management. It Connects the Timecard Device and collects

the punches for Payroll Process, According to the

Companies policy, Leave, Permission, Vacation is

calculated though this Application. It gives the reports to

the Admin Department & users. The LOP process available

in this module calculates the actual LOP Days using the

Punch of the Employees, Which helps the Payroll Process.

Also after Payroll is processed, processed pay slip is

encrypted and uploaded for the individual to view the pay

slip for the required month. The pay slip is decrypted only

at the time of report. This application has the following

features like,

ESS - Employee Self Service, Payroll process

Role : Developer

Responsibility : Understanding the business requirement, Development and

maintenance support, Unit testing, bug fixing and Support

to client.

Duration : Mar-2011 to Dec-2011

Technology : SQL Server 2005, Microsoft .NET framework 3.5

0 Project Name : O’Connor Data

6

Client : O’Connor & Associates

Description of the Project : It is a web based application. This oconnordata website is

designed for managing real estate process. It provides

information about retail, office and industries properties

also it provides historical information of that properties.

Page 3 of 4

Role : Developer

Responsibility : Understanding the business requirement, Development,

Unit testing, bug fixing and Support to client.

Duration : Jan-2010 to Feb-2011

Technology : SQL Server 2005, Microsoft .NET framework 2.0

Page 4 of 4

Contact this candidate