development, production support engineer, project coordination, planning and
development, estimations, customer relationship with good management/technical/analytical
skills, worked as a programmer analysis consultant/specialist, Module/Technical
Lead for six to eight support engineers, acts as an Onshore coordinator for
Onshore-Offshore model team.
Highly professional, good learner, dynamic with excellent communication
Oracle Certified Associate (OCA)
Professional, Academy in Healthcare Management
Optimizing and performance tuning
Excellent problem solving skills
Strong analytical skills Structured query language (SQL) expert
Programming and design skills
Oracle SQL and PL/SQL
Year Title Presented to Location Organised by 2014 2013 UNIX Scripting Coordination of Benefits (American Healthcare Standards) TCS Consultants TCS Consultants Lake Oswego Chennai TATA Consultancy Services TATA Consultancy Services 2009 Oracle PL/SQL TCS Consultants Chennai TATA Consultancy Services Training Attended Year Title Location Organized by 2009.
Assistant Consultant05/2016 to 07/2016TATA CONSULTANCY SERVICES LIMITED TCS, Ltd
Information Technology Analyst01/2013 to 04/2016TCS, Ltd
Claims processing systems for Colorado(CO).
01/2012 to 01/2016
Colorado Region - Monthly/Quarterly Production release activities coordination.
2014 - Colorado Region - Converted ETL extracts to Oracle extracts for performance improvement.
2013 - Colorado Region - Xcelys Claims Colorado Production Support Engineer.
Performing critical data loads in a timely manner.
College Graduate Academic Projects Title: Heterogeneity Projection Hard-Decision color interpolation Using Spectral Spatial correlation (Image Processing).
Systems Engineer01/2011 to 01/2012TCS, Ltd
Programming Analysis Consultant/Specialist06/2009 to 05/2012KAISER PERMANENTELake Oswego, Oregon
Xcelys Claims Responsibilities Lead team of 6 Level 2 and Level 3 Production Support engineers (Onshore and Offshore model).
Understanding business requirements through conference calls and emails, Analysing business requirements and estimating the timeline to incorporate the changes in the system in order to meet the objective.
Converting the project specifications and statement of problems and procedures of detailed logical flowcharts for coding into computer language.
Developing and Writing computer programs to store, locate and retrieve specific documents.
Wrote extensive, high performing PL/SQL functions, packages, procedures, tables, triggers, indexes and so on.
Writing ad hoc Oracle PL/SQL scripts, Unix shell and Perl and SQL reporting scripts for business partner request using the coding standards and follows SDLC process.
Reviewing the code, preparingthe test plan to describe the scenario for testing requirements and preparing the Test results document for verification of the code changes.
Performing Process related activities to conform to standards and ensure the quality of deliverables.
Implementing the code changes in System and Testing whether the incorporated changes attain the objective without affecting the existing code functionality.
Developed automate scripts for daily Production health check-up.
Aiding productivity within team and saving several hours of effort.
3+ years of experience with ETL (Informatica) extract processes in an Oracle environment.
3+ years of experience with Java development skills and an understanding of object-oriented analysis, design and programming.
2+ years of experience with architecture and development of web services and WebSphere applications.
Proactively developed automation scripts for daily Production activities to increase the efficiency of the system and saved human efforts.
Monitoring the System jobs performance and troubleshooting the root cause if any job failures.
Performing root cause analysis of production bugs and Fixing all the errors to enhance the performance of the application Code review and checking the coding standards Converted ETL extracts to Oracle extracts for performance improvement.
Maintenance activities like impact analysis, coding, unit and peer testing.
Supporting System testing.
Performing release coordination and Business and IT validation activities during the Production deployments.
Update the status of tickets that assigned to do the tasks in Remedy.
Code review, walk through and checking the coding standards for other modules and peer testing.
Part of Technical evaluation team within the Project as well as account level.
Use Remedy tool to track the change requests / incidents assigned by users / business.
Projects Xcelys claims is the system of medical claim records (CO region) for Kaiser Permanente which adjudicates and finalizes the medical claims and maintains the benefit accumulations of every member enrolled with Kaiser Permanente for Colorado region.
The application is designed with Service-oriented 3-tier architecture built with Power builder as a front-end and Oracle database as a back-end.
With Xcelys, there are many interfaced systems such as Common Membership, Tapestry (Authorizations), Bets (Benefit and Group source systems), and KPEG sending members, authorizations, groups and benefits and claims data to the Xcelys systems in order to process or finalize the claims and pay to the members.
Xcelys application was implemented in Kaiser Permanente only for Colorado region.
06/2009 to 05/2012Chennai, India, TN
Title Claims processing systems for MAS, OH, NW and CA.
Period06/2009 to 05/2012
Client Name KAISER PERMANENTE Positions Programmer Application Diamond 950 Responsibilities Development for Production code defects or enhancements.
To provide fix for all errors arising out of Production problems that assigned by service management team, the fixes are delivered every Thursday.
Maintenance activities like Impact analysis, Coding, Unit and Peer testing.
Performance tuning of SQL, PL/SQL code block for database jobs performance improvement.
Create PL/SQL packages, procedures and functions.
UNIX Shell and Perl scripts and commands Technical Deployment support.
Unit test plan and Unit test logs preparation.
Provide support for System and Application testing during releases.
Part of Technical evaluation team within the Project as well as account level.
Conducted trainings about the American healthcare standards and brainstorming sessions to overcome the pain areas with the system design and improve the ongoing processes Full ownership for all data loads requests received from Business Partners.
Check-in and Check-out the code using Starteam tool Projects Diamond application is for Claims processing, adjudication and benefit accumulation.
It has been developed with PowerBuilder as front end with Oracle 10g as the database.
Diamond uses Application Programming Interfaces (API's) to load and update the Claims, Members and authorizations to process and finalize the claims.
Diamond interact with many interfaces like Common Membership (CM) to get the members, BETS to get Benefit and group coverage details, Health connect, MACESS, Metavente (Printing vendor), Citibank, KPEG, Material Management system (MMS) and National general ledger systems etc to provide the Diamond updates to downstream systems and get the updates from upstream systems in order to sync up the data.
Diamond application was implemented for the regions North West (NW), Ohio (OH), and Mid Atlantics (MAS) and California (CA).
Activities Performed 2015 - Colorado Region - Xcelys Claims Disaster Recovery Environment Build - Design, co-ordination, Testing and implementation.
2015 - Colorado Region - Xcelys Claims CO Oracle database 10g to 11g migration.
2015 - Colorado Region - Claims Xcelys Administration Console Tool (XACT) SQL server migration.
Assistant Systems Engineer01/2009 to 12/2012TCS, Ltd
Development, Maintenance and enhancement support of Claims application.
This includes Diamond, Xcelys and Claims Connect application for Claims processing, adjudication and benefit accumulation.
The databases are Oracle 10g and 11g.
J2EE and Webservices (SOAP calls) for providing claim status.
Informatica Extracts to downstream systems (Health-connect, Claims data warehouse, Benefit systems, General Ledger, Printing vendor) and gets the updates from upstream systems (Benefit Systems, Membership, Health-connect) in order to synchronize the data.
Claims Applications are currently used for the regions North West (NW), Mid Atlantic States (MAS), California (CA) and Colorado(CO).
Module Lead/Team Lead for development team of six people (Onshore and Offshore model) responsible for quarterly releases and weekly defect Production fixes.
Business Areas/Applications Knowledge Health Care Claims processing Extracts (835, 837, 277) and more.
Reports - Statement of Accumulations, Member Out of Pocket (Part C) and more.
Benefits, Accumulation configuration.
01/2009TATA CONSULTANCY SERVICES
01/2008 to 05/2008A. C. College of Engineering and TechnologyTN
The objective of the project is to make the image size lesser than the original image with high performance, low computational complexity and produce high quality visual results not only in textured regions, but also in re-constructing sharp edges of the image by means of developing efficient proposed color interpolation.
Education and Training
Bachelor of Engineering: computer science2008A.C.College of engineering and technology, Karaikudi, Anna UniversityINDIAcomputer science