SANDEEP JACOB

Email: acn2w1@r.postjobfree.com

Richmond,VA,23294 cell: +1-949-***-****

PROFESSIONAL SUMMARY

Highly competitive IT Professional with 9+ years of experience in the development and support of

mission critical applications for major companies.

Strong knowledge in healthcare Care Management systems called TriZetto Clinical CareAdvance,

Anthem Care Management Systems, Landacorp’s maxMC Medical Management Solution, IBM

Watson & Availity.

Strong knowledge in TTL( Travel Transportation and Logistics domain) and airline passenger

reservations system called iFly Res by IBS - Airline Software.

Achieved Award for “Process Excellence”.

SKILLS

Database design & development skills Excellent communication skills

Production support skills Expert in SQL and PLSQL programming

Strong in Informatica development Expert in SQL Performance tuning

Data warehouse knowledge Splunk/Introscope Knowledge

Unix shell script/Control M,WLM scheduling Waterfall & Agile model Knowledge

Good team lead, contributor and mentor with excellent interpersonal and technical skills

Experience in Oracle advanced features like AWR, Oracle collections

Expert in managing projects from requirements to release.

Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.

Excellent knowledge on Normalization and de-Normalization concepts.

SOFTWARE SKILLS

• Languages : JAVA, J2EE,.net

• Web/Application Server : IBM Web Sphere 7.0.0.31,Bea Weblogic

• Database : Oracle 8i,9i,10g,11g, Microsoft SQL Server 2008,DB2

• Languages : Linux/Unix/Shell/Windows 2003

• Version Control : IBM Rational ClearCase8.0,SVN

• Defect Tracking Tool : IBM Rational ClearQuest, IBM TSRM,HP Service Center

• Java IDE : Eclipse,Intellij IDEA

• Database Tool : Toad( TDA,TFO),SQL Developer,IBM Data Studio,SQL

Navigator

• Scheduling Tool : Control M,Work Load Manager

• Operating System : WindowsXP,7,8

• Performance monitoring Tool : CA Introscope

• Analytics : Informatica 8.6&9.1,Splunk

• Webservices : SOAP UI3.5

• FTP Tools : FileZilla, Ipswitch,WinSCP

CERTIFICATIONS

Awarded the following certifications,

• Oracle certified PL/SQL developer (OCA 9i)

• Oracle certified Database Administrator (OCP)

• Oracle 10 g: SQL Tuning.

• Informatica Certified Developer

• Team Leadership Training

ACCOMPLISHMENTS

• Active member of Database Center of Excellence (DBCOE)

• Conducted various technology trainings for fresher and experienced hands in the team.

• Worked along with the business development team on project proposals & estimates

• Actively involved in Software Process implementation and CM audit panel member for National

Business Project Management Office.

WORK HISTORY SUMMARY

1.UST Global Inc : Contracted to Anthem Inc

Duration: Sep 07, 2009 –till date

o

Current Designation: Senior Systems Analyst

o

Current Project Role : Developer Sr.

o

Current Account: Anthem Care Management Systems

o

2. IBS Software Services Private Limited

o Duration : July 21, 2005 –Sep 04,2009.

o Designation: Senior Software Engineer

o Project Role : Oracle Developer & Designer.

o Account: TTL (Travel,transportation and logistics)

EXPERINCE SUMMARY

A. Medical Management Systems

Domain

Healthcare domain –Medical Management

Role

System designer, Senior Oracle & ETL Developer and Analyst

Organization UST Global

Duration Oct 2010 to current

Team Size 5

Technology Oracle PL/SQL,Informatica,Websphere,DB2,Linux

Client Anthem Inc

1.Care Management Roles and Responsibilities:

My role in this project in Anthem Ince is to provide leadership, vision, and management to the IT

department and also maintain various production/development/testing databases and develop both front end

and back end functionalities. Currently I am ensuring the development and performance tuning. I am also

ensuring the front end compatibility with the various schema of the backend database. I am using PL/SQL

for backend developments and reporting.

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing

Design.

• Created backend data base and worked in the development team for the system Anthem Care

Management Solution (ACMP) using Oracle & Informatica.

• Migration of scripts from oracle10g to oracle 11g for Anthem Legacy medical management

legacy systems.

• Perform projects via Software Development Life Cycle ( SDLC) projects. Ensure the phases like Requirements

Gathering, Analysis/Design, Development and Testing are followed before production implementation. Create

Technical design documents and developing unit test documents

• Perform data troubleshooting and development. Monitor systems health and provide instant solutions to system

performance issues.

• Developed database objects including tables, clusters, Indexes, views, sequences, packages,

triggers and procedures for troubleshoot any database problems for Anthem Care Management

Solution.

• Worked with DBA group closely in the design of Materialized View refresh jobs for Anthem Care

Management Analytics Reporting Solution. Provide production support to daily MV refresh jobs

and address user and performance

• Tuned complex Stored Procedures for faster execution and Developed database structures, according

to the requirements.

• Developed various complex squries, stored procedures, packages, interfaces and triggers in PL/SQL.

Created various SQL and PL/SQL scripts for verification of the required functionalities.

• Provide production support for the application build on Java J2EE and .NET

• Wrote shell scripts for various requirements like report automations and batch jobs.

• Performance tuning using explain plan, AWR report and Query analysis.

• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in

ETL processes.

• Preparation of project Requirement Specification Document by analyzing the requirements.

• Team player and self-starter with excellent communication, coordination, documentation, project planning and

interpersonal skills.

• Proven ability to work under pressure, prioritize and meet deadlines. Open to dynamic work environment and

ability to work collaboratively with business analysts, testers, developers and other team members in the overall

enhancement of software product quality.

• Perform query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan,

Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.

• Analyze AWR to troubleshoot performance issues in production.

2.Clinical Care Advance Roles and Responsibilities:

Configured and tested CCA across various plans, lines of businesses, and platforms to deliver high quality

implementations to leading health plans and payer organizations

• Worked with TRIZETTO consultants to define profiles for campaigns while validating those

profiles against campaign requirements. Create and validate concepts, assessments and

questionnaires.

• Defined and edited String Customizations and User Defined Fields based on given

requirements.Configured and tested CCA across various plans, lines of businesses, and platforms to

deliver high quality implementations to leading health plans and payer organizations.

• Worked collaboratively with project team and other departments to define acceptance criteria,

resolve issues, implemented test strategies. Tracked, planned, and coordinated the resolution of

defects to ensure defect assignments in a timely fashion. Communicated test results, project status,

and complex issues effectively to project team and stakeholders.

• Performed CCA configuration via the TriZetto Content Edit tool for various client environments.

Importing and exporting files, forms and assessment via the CMT (Configuration Management

Tool).

• Provide support to CCA batch jobs to load memebership,provider and production information to

CCA database. Implemented new business rules in CCA using FICO® Blaze Advisor® Business

Rules Management System.

B.EPDS Migration: Health care -Provider platform migration

Domain

Healthcare domain –Provider migration

Role

Senior Oracle Developer,ETL Developer, System Designer

Organization UST Global

Duration Aug 2010 To Oct 2010

Team Size 5

Technology Oracle PL/SQL,Informatica,TeraData,SQL Server 2005,WLM,Shell Scripting

Client WellPoint Inc

Project EPDS- Enterprise Development System which is the key unit one of the leading

healthcare networks in United States of America. The scope of the project is to

migrate the details of Provider data to the Core Administration Redesign

Solution program from D950

Roles & Responsibilities:

• Analysis of the requirements.Providing solutions after understanding the requirements.

• Designing and Building the structure of the maps and workflows.Delivering Quality service with

thorough testing.

• Creating the Change Request.Providing support through the client business timings for the User

Acceptance Tests.Coordinating the project activities with onsite.Transferring Business and process

knowledge to new comers in team.Technically lead a team of 3 at offshore

• Conduct technology trainings

• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL

procedures.

C. Health Care Networks State Sponsored Business-IT – SSCRs

Domain

Healthcare domain

Role

System designer, Developer, Technical Lead

Organization UST Global

Duration Sep 2009 To Aug 2010

Team Size 19

Technology Oracle PL/SQL,Informatica,TeraData,SQL Server 2005

Client WellPoint Inc

Roles & Responsibilities:

Mid-level Developer Offshore, Technical Lead Offshore

Preparation of project Requirement Specification Document by analyzing the code flow.

o

Design and development activities of change request from client using Informatica, Oracle

and Teradata.

ETL processing of different files, and Oracle, MS Sql database tables, COBOL files using

o

Informatica.Implement expression transformation using Informatica tool, power center.

Coding in PL/SQL (Subject to clients requirements).

o

Testing - Unit Testing & Integration Testing (By analyzing relevant airline business

o

scenarios coming under passenger reservation Domain).Meeting the deadlines.

Data retrieval from Teradata and Oracle database and its manipulation for generating the

o

different claims files to all states of America.

2. Company : : IBS Software Services Pvt. Ltd,Trivandrum,Kerala,India

Duration : July 21, 2005 –Sep 04,2009.

o

Designation: Senior Software Engineer

o

Account: TTL (Travel Traffic,transportation and logistics)

o

The IBS Group is a leading software solutions provider to the global Travel, Transportation and Logistics

industry. IBS offers a range of software products that manage mission-critical operations of major

airlines, airports, oil and gas companies, seaports, cruise lines and tour operators world-wide. In addition,

IBS offers services that include software development, business & technology consulting, application

maintenance, and onsite software development services.IBS is a PCMM Level 5, CMMi Company.

Current Project: iFly Res; http://www.ibsplc.com/air-travel-solutions-system.html

Role: Senior Software Engineer

Job Responsibilities: My experience with iFly RES has fetched me sound business knowledge in the

Airline Reservation Domain. In my job role, I contributed to the patch level consolidation of the product

Design development, product packaging, deploying and testing in Web logic server, Business to Product

Mapping Job. My responsibilities are:

a. As part of iFly RES Design/Development Team

Domain

TTL (Airline Reservation system)

Role

Developer, Team Member

Organization IBS software services, Private Ltd

Duration Jul 2005 To Sep 2009

Team Size 30

Environment Oracle PL/SQL Programming,Informatica,Java J2EE, Handling

database

Clients VIRGIN AMERICA,MALDIVEAN AIRLINES,ENERJET

CANADA,VISION LAS VEGAS,FDA JAPAN

Contribution as a Team Member:-

Preparation of Product Requirement Specification Document by analyzing the code

o

flow.Design and development activities of change request from different clients using airline

reservation system(iFly RES)

Administration of database (installation, maintenance, performance tuning)

o

Design and Development in Data base.Coding in PL/SQL (Subject to clients requirements).

o

Testing - Unit Testing & Integration Testing (By analyzing relevant airline business

o

scenarios coming under passenger reservation Domain).

Design and development activities of change requests from client using Informatica, Oracle

o

and Teradata. ETL processing of different files, and Oracle, MS Sql database tables, COBOL

files using Informatica. Prepare analytical, Balance and Reports for various systems.

As part of iFly RES Performance Optimization Team

b.

Domain

TTL (Airline Reservation)

Role

System Designer and Team Member

Organization IBS software services, Private Ltd

Duration Jul 2006 to Dec 2006

Team Size 10

Contribution as a Team Member:-

Identification of major performance bottle necks in the application.

o

Optimize the performance both in business-wise and code-wise.

o

Regressive load testing of the application in P550 (IBM database server),HPLOAD

o

Analysis of AWR report and ADDM reports

o

Analysis of quires in informatica mapppings

o

Creating SQL scripts for various analysis. And

o

Business level optimization in the key business flows which includes PNR creation,PNR

o

modification, Airline reports

c. As part of iFly RES Data migration Team for Virgin America Airlines -USA

Domain

TTL (Airline Reservation)

Role

System Designer

Organization IBS software services, Private Ltd

Duration Mar 2008 to till Nov 2008

Team Size 5

Contribution as a Team Leader:-

Finalize the complete data migration strategy meeting the airline domain complete

o

business.Automation data migration scripts using Perl scripting.

Development of data migration scripts to cater the business changes in

o

the two versions of product.

o

Meeting the dead line of completing the data migration of production data base of size

o

approximately I TB in two hours of down time.

Making scripts for sanity checking.

o

d. As part of Virgin America Airlines Onsite reports Team - USA

Domain

TTL (Airline Business Reports)

Role

Business reports design/developer

Organization Virgin America Airlines,USA

Duration Nov 2008 to Jan 2009

Team Size 11

Contribution as a Team Leader:-

• Oracle Sql and Pl/Sql Query development for scheduling and planning departments.

• Integration with Perl and CRONTAB.

• Front end development in BERT. Contribution as a database Designer/Reviewer/Data:-

• Oracle Pl/Sql Query development.

• Data migration for generating HOT (hand off tape) for the production data containing 3

million PNRs on zero production down time approach.

• Developed Pl sql procedure with 30000 lines of code for migration in 2 months times

period.

EDUCATION QUALIFICATION

Qualification Score College/University

Bachelors in Electronics and

MA College of Engineering,

Communication Engineering (2005) 78%

Kothamangalam, MG University,Kerala

Contact this candidate