Resume

Sign in

Developer Sql

Location:
Jersey City, NJ
Salary:
110000
Posted:
March 20, 2019

Contact this candidate

Resume:

Rajesh Kumar Soundarrajan

Mobile: +1-209-***-****

Email:ac8umn@r.postjobfree.com

CAREER SUMMARY

To obtain a Challenging position in Software this offers opportunity for my professional growth with the growth of the Organization, in a corporate environment that will utilize my technical expertise and personal skills.

TECHNICAL SUMMARY

8+ Years of experience in Trizetto Facets, Oracle sql, pl/sql.

Having Good Knowledge and Experience in US Health care Domain.

Extensively worked on US Health insurance life cycle like Membership, Plan/Product, Provider, Billing, Claims and have good knowledge on the Facets Data Models.

Business Process Reengineering in Health Care Sector with prime focus on membership, provider, eligibility on various healthcare programs.

Rich exposure on different phases of software development life cycle (SDLC) including analysis, design, development, testing and maintenance and end to end Implementation.

Excellent ability to gather and understand business requirements and translate into IT solutions.

Ability to meet deadlines and handle multiple tasks and flexible in work schedules by taking complete ownership of the job.

Proven ability to interact with end-Users, managers and technical personnel and Responsible for task delegation, code delivery, defect management and issue and risk resolution.

Conducted Technical & Domain related training for the members inducted to the team.

Deputed to client location @ Bangkok for providing development and support for UAT.

WORKING SUMMARY

Currently associated with Cognizant Technology Solutions from April 2013 to till date.

Associated with iSOFT Health Management private limited, A CSC Company, Chennai from November 2010 to April 2013.

EDUCATIONAL QUALIFICATION

Bachelor of Engineering - Electronics and Communication Engineering - 70% – 2010

TECHNICAL SKILLS

Development Tools : iSQL*Plus, Oracle Developer Suite 10g R1, R2

Productivity Tools : SQL Developer, TOAD and PL/SQL Developer

Relational Database : Oracle 11g

Environment : SQL*Plus, Windows XP.

PROFESSIONAL PROJECTS PROFILE:

PROJECT 4

Client

Emblem Health, United States

Project

EH SS IT Trans Facets BPAAS

Role

Facets Designer, PL-SQL Developer

Environment

Oracle, Facets, SQL Developer

Duration

06/27/2016 – Till date

Project Description:

Emblem Health is New York's leading neighborhood health insurance and Wellness Company. We are committed in making quality health care accessible to all New Yorkers. As part of Legacy to Facets migration project, we migrated HMO, EPO and Large group end to end functionality. Managed the membership tower interfaces like ID Card, Welcome Kit, Auto PCP and Facets to Entops, Medicare and Membership Reconciliation report to state.

Role:

Facets Designer & PL-SQL Developer

Responsibilities:

Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.

Involved in Mainframe to FACETS migration which includes understanding the legacy system and transforming the business rules to Facets.

Involved in resolving complex queries and optimized long running SQL and PL/SQL scripts for better performance.

Mentored team members in arriving at the technical solution for SI Custom components.

Provided technical assistance to the team and calls with on the Architecture discussions regarding any open issues.

Responsible for working with the State to review and modify process flows to increase and effectively utilize FACETS features not provided by the legacy systems.

PROJECT 3

Client

Presbyterian Health Plan Core Contract

Project

PHP core contract

Role

PL-SQL Developer

Environment

Oracle, Facets, SQL Developer

Duration

09/05/2015 - 06/26/2016

Project Description:

Centennial Care is a major revision to the Managed Care system and all the subsystems that touch it. Centennial Requirements have driven a demand for Client to provide more robust Integrated Care Management services, particularly in the areas of Care Management and Utilization Management. Client wants to develop more extracts to send and receive member, provider, claim and utility information to different MCO's.

Role:

Facets Designer & PL-SQL Developer

Description:

Responsibilities as a core developer in team encompasses the key technical activities including analyzing, designing, developing and testing various components based on various task provided by client.

This activity involves providing new approaches for client configuration, flexibility to work in all major modules and in-depth Facets knowledge.

Have setup Test data in Facets for Unit testing and Integration testing.

PROJECT 2

Client

Blue Shield of California

Projects

BSC SA Accelerate T&M, BSC SAA Delivery Management,

BSC Portal HCR, BSC SA Interfaces SGHCR

Role

Facets Designer and PL-SQL Developer

Environment

Oracle 11g, Facets, JIRA, SQL Developer

Duration

05/01/2013 to 09/04/2015

Project Description:

Blue Shield of California (BSC) has relied on its mainframe benefit administration systems for nearly 30 years and has reached the point where the cost and time taken to update these systems for meeting market demands became unacceptable and unsustainable. BSC selected Facets as the platform of choice. Facets would be the single system of truth for administering and processing Eligibility, Claims and Provider services. 4 major Lines of Business (LOB) – Preferred Provider Organization (PPO), Individual Family Plans (IFP), HMO (Health Maintenance Organization) and Small Group (SG) were migrated to Facets till 2014. Shield Advance Accelerate is to migrate the remaining LOBs.

Role:

Facets Designer & PL-SQL Developer

Responsibilities:

Has worked as Facets Designer and PL-SQL Developer in Shield Advance program for HCR and SAA Projects (SMU tower)

Involved in development of new stored procedures for EDI 834 Inbound Interfaces and SAA requirements.

Involved in design, development and unit testing for various Interfaces.

Coordinated with ESB technical to perform Integration Testing.

Interacted with the Onsite to understand requirements and performed impact analysis.

Have prepared Explain Plan as part of deliverables for performance improvement.

Involved in Triaging and provided test support for the deliverables in SAA.

Coordinated across teams for daily defects tracking for SMU tower.

PROJECT 1

Client

Siriraj Hospital

Projects

Enterprise Health Information System (eHIS)

Role

PL-SQL Developer

Environment

Oracle sql, pl/sql, Oracle reports

Duration

09/15/2010 - 04/26/2013

Project Description:

eHIS is a healthcare software product. Used in hospital management. The product is widely used in Middle East, Thailand, Malaysia and India. Patient Administration System (PAS) is one of the 17 functional areas in eHIS. PAS comprises of around 12 modules. All Patient information, Configuration settings of facility, different entities of facility like Clinic, Nursing Unit, Practitioners, Specialty for each practitioner, different functionalities of IPW and OPD are some of the areas handled by PAS.

Role:

PL-SQL Developer

Responsibilities:

Analysis & Development on Support Call Forms (SCF), Change Request Forms (CRF) from customers.

Peer understanding with clients and involved in technical discussion.

Designing, Testing and validation of reports.

Understanding and documenting the development to be done.

Involved in code review and test case review.

Creation of Database objects per business logic specifications.

Adopting change management for customizing and new development

PERSONAL PROFILE

Father's Name : Soundarrajan C

Date of Birth : 18-05-1989

Gender : Male

Nationality : Indian

Communication Address : 216 Congress St,

Jersey City, New Jersey-07307

PASSPORT DETAILS:

Passport No : H7387709

Date of Expiry : 29/09/2020



Contact this candidate