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 TriZettoClinical Care Advance, Anthem Care Management Systems, Landacorp's max MC Medical Management Solution and IBM Watson Availity.
• Strong knowledge in TTL Travel Transportation and Logistics domain and airline passenger reservations system called iFly Res by IBS - Airline Software.
• A dynamic professional with experience of 64 months spanning across requirements gathering,analysis,design, development, implementation, and testing of applications using various Data base technologies and ETL methodologies
• Excellent knowledge of Software Lifecycle SDLC Agile Waterfall models and Software Engineering Processes - adept in end-to-end development of software products from requirement analysis, solution design, and project execution methodologies.
• Excellent in Business Analysis and System Study. Proficient in documenting requirements, design and test cases.
• Extensively worked on developing Informatica Mappings, Mapplets, Session, workflows and worklets for data loads. Worked with Informatica PowerCenter to move data from multiple sources into common target area using Source qualifier, Normalizer, Expressions, Routers, and Connected/Unconnected Lookups.
• Strong experience in Oracle and Informatica performance tuning for mission critical applications like Airline Reservation system and Performance Critical data base migration Projects.
• Very strong programming experience in PL/SQL, SQL and UNIX environments.
• Good programming experience in Microsoft sql server 2005 and Teradata database environments.
• Excellent Team player, Quick learner and ability to meet deadlines.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.
• Excellent Knowledge in Tools like SQL developer, Toad, Putty, Eclipse, Intelij IDEA and Informatica PowerCenter.
• Good team player and an effective communicator with excellent interpersonal and communication skills has the ability to lead and work effectively in a team.
• Contributes efficiently through technical and value mentoring.
• Achieved Award for Process Excellence .

Technical Skills:

• Database design development skills
• Excellent communication skills
• Extreme 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

• Web/Application Server: IBM Web Sphere 7.0.0.31, Bea Weblogic
• Database: Oracle 8i, 9i, 10g, 11g, Microsoft SQL Server 2005, 2008, DB2 UDB
• Version Control: IBM Rational ClearCase8.0, SVN
• Defect Tracking Tool: IBM Rational ClearQuest
• Java IDE: Eclipse, Intellij IDEA
• Database Tool: Toad TDA, TFO , SQL Developer, IBM Data Studio
• Scheduling Tool: Control M, WLM
• Operating System: WindowsXP, 7, 8, Linux/Unix/AIX
• Performance monitoring Tool: CA Introscope
• Analytics: Informatica 8.6 9.1, Splunk
• Webservices: SOAP UI3.5
• Scripting Languages :Batch,Shell
• FTP Tools: FileZilla, Ipswitch,WinSCP
• Generic Tools: Microsoft Power Point,Vizio,Textpad,NotePad ,Citrix,IBM Lotus Notes,HP Service center
• 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.

Confidential

• System designer, Developer, Technical Lead and Team Lead
• 1 Care Management Roles and Responsibilities:
• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design and production support.
• 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 of production issues. Monitor systems health and provide instant solutions to production 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 queries, 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.
• Perform data modeling, data troubleshooting and in development. Monitor systems health and provide instant solutions to system performance issues.
• Create and manage Splunk Search Processing Language SPL queries, Reports and Dashboards Also maintain splunk client and forwarders,work with splunk admins to size the splunk implementation projects and deploy Splunk Deployment Serves.
• 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.

Confidential

Mid-level Developer Offshore, Technical Lead Offshore

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

Confidential

System designer, Developer, Technical Lead and Team Lead

Roles Responsibilities:

• Preparation of project Requirement Specification Document by analyzing the 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 the deadlines.
• Data retrieval from Teradata and Oracle database and its manipulation for generating the different claims files to all states of America.

Confidential

Designation: Senior Software Engineer

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 PCMMLevel 5, CMMi Company.

Confidential

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:

Confidential

Developer, Team Member, Change requests intake

Contribution as a Developer and Technical Lead:-

• Preparation of Product Requirement Specification Document by analyzing the code flow. Design and development activities of change request from different clients using airline reservation system iFly RES
• 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 .

Confidential

Team Member

Contribution as a Technical Lead:-

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

Confidential

Team Leader

Contribution as a Designer Technical Lead:-

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

Confidential

Business reports design/development

Contribution as a Designer/Developer:-

• 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.