SUMMARY

• Highly competitive IT Professional wif 9+ years of experience in teh development and support of mission critical applications for major companies.
• Strong noledge in healthcare Care Management systems called TriZettoClinical CareAdvance, Anthem Care Management Systems, Landacorp’ smaxMC Confidential Solution, IBM Watson &Availity.
• Strong noledge in Confidential ( Travel Transportation and Logistics domain) and airline passenger reservations system called iFly Res by IBS - Airline Software.
• Achieved Award for “Process Excellence”.

TECHNICAL 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 Intro scope

Analytics: Informatica 8.6&9.1, Splunk

Webservices: SOAP UI3.5

FTP Tools: FileZilla, Ipswitch,WinSCP

PROFESSIONAL EXPERIENCE

Confidential

System designer, Senior Oracle & ETL Developer and Analyst

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

Responsibilities:

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
• Created backend data base and worked in teh development team for teh system Anthem Care Management Solution (ACMP) using Oracle &Informatica.
• Migration of scripts from oracle10g to oracle 11g for Anthem Legacy Confidential legacy systems.
• Perform projects via Software Development Life Cycle (SDLC) projects. Ensure teh 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 wif DBA group closely in teh 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 teh requirements.
• Developed various complex squries, stored procedures, packages, interfaces and triggers in PL/SQL. Created various SQL and PL/SQL scripts for verification of teh required functionalities.
• Provide production support for teh 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 teh requirements.
• Team player and self-starter wif 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 wif business analysts, testers, developers and other team members in teh 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.
• Worked wif 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 wif project team and other departments to define acceptance criteria, resolve issues, implemented test strategies. Tracked, planned, and coordinated teh 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 teh TriZetto Content Edit tool for various client environments. Importing and exporting files, forms and assessment via teh 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.

Confidential

Senior Oracle Developer, ETL Developer, System Designer

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

Responsibilities:

• A nalysis of teh requirements. Providing solutions after understanding teh requirements.
• Designing and Building teh structure of teh maps and workflows. Delivering Quality service wif thorough testing.
• Creating teh Change Request. Providing support through teh client business timings for teh User Acceptance Tests. Coordinating teh project activities wif onsite. Transferring Business and process noledge to new comers in team. Technically lead a team of 3 at offshore
• Conduct technology trainings
• Involved in uploading of teh data from flat files into Databases and validated teh data wif PL/SQL procedures.

Confidential

System designer, Developer, Technical Lead

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

Responsibilities:

• Preparation of project Requirement Specification Document by analyzing teh code flow. 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 Informatica. Implement expression transformation using Informatica tool, power center.
• Coding in PL/SQL (Subject to clients requirements).
• Testing - Unit Testing & Integration Testing (By analyzing relevant airline business scenarios coming under passenger reservation Domain).Meeting teh deadlines.
• Data retrieval from Teradata and Oracle database and its manipulation for generating teh different claims files to all states of America.

Confidential

Senior Software Engineer

Responsibilities:

• My experience wif Confidential has fetched me sound business noledge in teh Airline Reservation Domain.
• In my job role, I contributed to teh patch level consolidation of teh product Design development, product packaging, deploying and testing in Web logic server, Business to Product Mapping Job.

Confidential

Developer, Team Member

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

Responsibilities:

• Preparation of Product Requirement Specification Document by analyzing teh code flow. Design and development activities of change request from different clients using airline reservation system( Confidential )
• Administration of database (installation, maintenance, performance tuning)
• Design and Development in Data base. Coding in PL/SQL (Subject to clients requirements).
• Testing - Unit Testing & Integration Testing (By analyzing relevant airline business scenarios coming under passenger reservation Domain).
• Design and development activities of change requests from client using Informatica, Oracle 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.

Confidential

System Designer and Team Member

Responsibilities:

• Identification of major performance bottle necks in teh application.
• Optimize teh performance both in business-wise and code-wise.
• Regressive load testing of teh application in P550 (IBM database server), HPLOAD
• Analysis of AWR report and ADDM reports
• Analysis of quires in Informatica mappings
• Creating SQL scripts for various analysis. And
• Business level optimization in teh key business flows which includes PNR creation, PNR modification, Airline reports

Confidential

System Designer

Responsibilities:

• Finalize teh complete data migration strategy meeting teh airline domain complete business. Automation data migration scripts using Perl scripting.
• Development of data migration scripts to cater teh business changes in teh two versions of product.
• Meeting teh dead line of completing teh data migration of production data base of size approximately I TB in two hours of down time.
• Making scripts for sanity checking.

Confidential

Business reports design/developer

Responsibilities:

• Oracle Sql and Pl/Sql Query development for scheduling and planning departments.
• Integration wif 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 teh production data containing 3 million PNRs on zero production down time approach.
• Developed Pl sql procedure wif 30000 lines of code for migration in 2months times period.