Name : SUBHA BALASUBRAMANIAN
E-Mail id    : [Send email using form at bottom]
Contact Number : 201-993-2114
INTRODUCTION
I have 4 years of experience in the Information Technology industry as an
Analyst Programmer. I have been involved with reviewing the functional
specifications, writing the high and low level design, coding, and Quality
assurance and in production Support.  I have worked on projects for Telecom based
clients such as Motorola and in the Health insurance industry.
EDUCATION
Title of the Degree with Branch	College/University	Marks (%)	Year of Passing
Bachelor of Technology 
Electronics and Communication Engineering	Thiagarajar College of Engineering,
India	83	2003
Higher Secondary  School	St.Josephύs Anglo Indian School,
India	94	1999
  High School                  	St.Josephύs Anglo Indian School,
India	92	1997                                                                   
 

TRAINING PROGRAMMES UNDERTAKEN:
No	Course Name	Duration	ORGANIZATION
1.		Health and Life Insurance-Business Training	4 weeks	TIERMED SYSTEMS
2.		HEDIS TOOLS (TierMed specific Tools) ύ
•	Road Map Builder
•	Compass Navigator
•	Compass Viewer
•	TierMed Engine
•	Data Audit Tool	4 weeks	TIERMED SYSTEMS
3.		Initial Learning Programme for Freshers :
•	Software Development Process,
•	Systems Engineering,
•	Requirements Engineering, System Design Overview,
•	Database Management Systems,
•	Object Oriented Methodology,
•	Problem Solving in C,
•	Testing and Debugging,
•	Review, Walkthrough and Inspection,
•	Software Maintenance,
•	Unix,Linux,C	3 months	TCS
4.		Oracle-PL/SQL scripting	2 months	TCS
5.		Clarify	4 weeks	TCS
6.		CRM-Business Training	4 weeks	TCS

TECHNICAL SKILLS
Hardware	IBM and HP compatible PCs
Operating System 	DOS, Win 9x, Win NT, Win 2K, Win XP , UNIX
Programming Languages	Clear Basic, Visual Basic 6
Databases & Tools	•	Oracle 9i, 
•	PL/SQL Developer,
•	TOAD,
•	SQL Server,
•	CLARIFY
Other Utilities 	Visual SourceSafe, HEDIS
EMPLOYMENT HISTORY
Name of the Company	Designation	From	To	Duration (Years)
TIERMED SYSTEMS 
Minneapolis, USA	Data Analyst	December 2006	August 2007	9 Months
Tata Consultancy Services
Chennai, India	Technical Lead	January 2006	August 2006	8 Months
Tata Consultancy Services
Chennai, India	Analyst programmer	July 2003	December 2005	2 Years 5 Months

PROJECT PROFILE: 
PROJECT I  
TIERMED SYSTEMS-HEDIS REPORTING
Project Title 	HEDIS Reporting
Duration	Dec 2006 ύ Aug 2007
Location	TIERMED SYSTEMS, Minneapolis ύ USA
Hardware	IBM compatible PCs
Operating Systems	Win 9x, Win NT, Win 2K, Win XP
Programming Languages	PL/SQL, SQL Server, MS SQL
Other Utilities	ROAD MAP BUILDER, COMPASS NAVIGATOR, COMPASS VIEWER, DATA AUDIT
TOOL, TIERMED ENGINE, CLARIFY, VSS 
PROJECT DESCRIPTION:
This project involves the processing of HEDIS(Health care information and data
set) data through the TierMed HEDIS certified engine. The creation of HEDIS
measure results is a progressive process: One that begins with initial HEDIS runs
to analyze the translation process, progresses to additional runs to create
hybrid samples and ends with a final administrative HEDIS run to submit to NCQA.
This also involves consultation with the insurance companies involved so that
maximum quality assurance in the data is attained.
CLIENT DESCRIPTION: 
I was involved with the following Health insurance Clients:-
•	Touchstone, New York
•	Atrio Health Plans, Oregon
•	Clear Choice Health Plans, Oregon
•	Elder Health Plans, Pennsylvania
•	Citrus Health Plans, Florida
ROLES AND RESPONSIBILITIES IN THE PROJECT:
•	To interact with the client and understanding/base lining the
requirements
•	To translate client data into TierMed standard format and to create a ύ.eprύ
project file for each client
•	Perform test run of client data using TierMed HEDIS engine 
•	Weekly interactions with the clients to analyze the data run results.
•	Perform QA before each product release (Compass Navigator , Compass Viewer,
Pocket PC, Data Audit Tool)
•	To provide the clients processed data results in the form of SQL Server
Datamarts
•	Perform QA after each run and the final HEDIS results for each client
•	To backup/support senior analyst for translational/datarun activities 
•	To Migrate the data of the TierMed website from MS SQL to Oracle 9i
•	To perform QA on the NCQA(National Center for Quality Assurance) tool for
HEDIS reporting, IDSS(Interactive Data Submission System)

EXPERIENCE IN THE TECHNOLOGIES USED: 
I have been associated with the project for around 9 months. I had been involved
in the entire HEDIS cycle for 5 major insurance clients.
My major role in this project is analyzing the client data and creating
translation using PL/SQL so that it meets the TierMed format. I was involved in
understanding health care data, HEDIS specifications, and various TierMed tools
and performed QA for each product.
ABOUT TIERMED SYSTEMS:
Highly experienced in the development of commercial health care software,
TierMed has spent their entire careers acquiring the knowledge necessary to bring
high quality products and services. They work for some of the largest health care
software companies in the nation, and also some of the smallest. They have worked
inside of health care delivery organizations and understand the pressures and
needs that are up against. 
TIERMED SYSTEMS strives to set the standard of excellence in developing HEDISύ
software and quality metric software for the managed health care industry. We
work hard to ensure that our clients have the best, most innovative and cost
effective HEDIS solutions available.
PROJECT II  
MOTOROLA- GEMS-PACKAGE  SOLUTIONS SUPPORT
Project Title 	Motorola-GEMS-Package Solutions Support
Duration	Janύ06-Augύ06
Hardware	IBM compatible PCs
Operating Systems	Windows 2000, Windows NT, Windows 98
Programming Languages	Clear Basic,PL/SQL
Tools Used	Clarify,Genesys,Primus,TOAD,PL/SQL Developer
Location	TCS, Chennai - India
PROJECT DESCRIPTION:
This project involves the primary support of Clarify, Genesys and Etalk
applications. Tickets will be raised by the users in the ticket logging tool
called ύMONETύ and based on the SLA of acceptance of tickets, the tickets should
be accepted. Depending on the criticality of the tickets the SLA varies for
resolution time of each ticket and the ticket should be resolved within the
timeframe. It also involved running some scheduled jobs in servers and monitoring
servers on a periodical basis and investigate and take actions if problems
arise.
CLIENT DESCRIPTION: 
Motorola is known around the world for innovation and leadership in wireless and
broadband communications. 
 A leading provider of integrated radio communications and information
solutions, with more than 65 years of experience in meeting the mission-critical
requirements of public safety, government and enterprise customers worldwide, it
also designs, manufactures and sells automotive and industrial electronics
systems and telemetric systems that enable automated roadside assistance,
navigation and advanced safety features for automobiles.
ROLES AND RESPONSIBILITIES IN THE PROJECT: 
•	To monitor the tickets and accept them without crossing the SLA
•	Analyzing the tickets and resolving them in the required timeframe depending
on the criticality of the ticket
•	To run scheduled jobs in the servers
•	To monitor the jobs scheduled and investigate if any issues arise.
•	To maintain and update documents like Maintenance Manuals and Frequent
Occurring Issues Document for each application.
•	To lead a team of 5, helping out in technical and functional aspects.
EXPERIENCE IN THE TECHNOLOGIES USED: 
I had been associated with the project for more than 5 month. My major role is
to monitor the tickets and accept them without crossing the SLA, analyzing the
tickets and resolving them in the required timeframe depending on the criticality
of the ticket.
I was also the technical lead leading a team of 5 helping out in technical and
functional aspects
PROJECT III  
MOTOROLA-NETWORKS-CLARIFY MIGRATION
Project Title 	Motorola-Clarify Migration
Duration	Jul 03  - Dec 05
Location	TCS, Chennai ύ India
Hardware	IBM compatible PCs
Operating Systems	Win 9x, Win NT, Win 2K, Win XP
Programming Languages	Clear Basic, PL/SQL
Other Utilities	CLARIFY, VSS, PL/SQL Developer
PROJECT DESCRIPTION:
Clarify Migration project involved the migration of two Clarify versions to a
single upgraded version of Clarify. Motorola had two Clarify instances to meet
the Customer solutions, one operating in North America and one in GSD
(Global).The NA instance was a Clarify 9 version and the GSD version was a
Clarify 10.1 version. The project involves the migration of Clarify 9 and 10.1 to
Clarify 12.5 which was the latest upgraded version then. This involved the
customization of Clarify screens in large and maintaining all customer
information in a Central database which involved data migration.
CLIENT DESCRIPTION: 
Motorola is known around the world for innovation and leadership in wireless and
broadband communications.  Inspired by the vision of Seamless Mobility, the
people of Motorola are committed to helping the world get and stay connected
simply and seamlessly to the people, information, and entertainment that is
wanted and needed.  This is by designing and delivering the "must have" products,
"must do" experiences and powerful networks - along with a full complement of
support services.  A Fortune 100 company with global presence and impact,
Motorola had sales of $36.8 billion in 2005. Delivers proven capabilities in
cellular, wireless broadband and wire line access technologies, with recognized
leadership in integrating core networks through wireless IP, wireless softswitch
and IP multimedia subsystems.  The Networks group is advancing seamless mobility
with innovative technology solutions, as well as a billion dollar services
business with an expanded portfolio delivering support, integration, applications
and management.
ROLES AND RESPONSIBILITIES IN THE PROJECT:
•	Mapping Business Processes to Web enabled Application
•	Analyzing Requirements and doing Impact analysis and design
•	Application tuning, code restructuring, and other efforts typically undertaken
to improve the efficiency and reliability of programs
•	Working on Clarify screens, customizing them and coding using Clear
Basic
•	Preparing test Plans for testing, Issue log and Impact analysis
documents
•	Database Handling including migrating data between databases to a common
database and manipulating data
•	Working closely to adhere to both TCS and Motorola processes by preparing all
process level documents
•	Working closely with Motorola personnel to study their business process and
suggest improvements.
EXPERIENCE IN THE TECHNOLOGIES USED: 
I have been associated with the project for around 2 years (22 Months). I had
been involved in the entire software development cycle in the migration of two
Clarify instances. 
My major role in this project is analyzing the requirements and reviewing the
functional specifications, preparing the high level and low level design
documents, implementing the design, doing an impact analysis for all the
releases, preparing test cases and carrying out unit and system testing. Have
worked on almost all the modules of Clarify including Clear Support, Clear
Quality, Clear Call Center, Policies and Customers, Clear Contracts and Product
Manager.
I have been involved in Data Migration too where my role is to maintain the data
integrity in a common database, manipulating tables and synchronizing the data. I
have used Clear Basic scripting for all customizations done in Clarify and PL/SQL
scripting for data handling.
ABOUT TATA CONSULTANCY SERVICES:
Tata Consultancy Services Limited (TCS) is the world leading information
technology consulting, services, business process outsourcing and engineering
services organization that envisioned and pioneered the adoption of the flexible
global business practices that today enable companies to operate more efficiently
and produce more value. TCS achieved this by creating and perfecting a unique
method of global deployment and delivery of high quality, high value services and
products in IT consulting and business process outsourcing. Known as the "Global
Delivery Model," this strategic services delivery concept has reshaped the IT
services industry. 
More than 95% of TCS customers reward the company's reliability, passion,
creativity, and unique ability to handle the broadest range of their IT needs by
continually extending and deepening their partnerships with TCS. With over 50,000
of the world's best trained IT consultants located in 34 countries, TCS is
uniquely positioned to deliver its flexible world class services seamlessly to
any location. TCS reported consolidated revenues of $2.24 billion (U.S.) in the
fiscal year 2004-2005. The company is listed on the National Stock Exchange and
Bombay Stock Exchange in India.