Vimarsha Chandrahasa Shetty Email: ac8q40@r.postjobfree.com

Mobile: +1-972-***-****

Professional Summary

Around 5 years of IT experience in Analysis, Design, Development, Testing and Implementation of business application systems for Health care sector.

Strong hands on experience of using ETL tools like Informatica PowerCenter 8.6/9.5, PowerExchange 8.6/9.5 and databases like Teradata, Oracle and DB2.

Proficient in data modeling for OLTP relational databases and Dimensional modeling – star and snow flake schema.

Implemented several complex mappings using different transformations and features provided by Informatica PowerCenter.

Good working knowledge on advanced concepts of PowerCenter like Partitions, Workflow recovery, concurrent workflows.

Experience in creating Reusable tasks (Sessions, Commands and Email) and Non-reusable tasks (Decision, Timer, Assignment, Worklets, and Control).

Has experience with implementation of Data synchronization, Data replication and creating mappings in Informatica cloud Services

Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

Hands on coding experience with DB2 PLSQL and performance tuning of SQL queries

Involved in preparation of unit test cases, test case review and code reviews for several newly developed modules.

Conducted CMMI software quality internal audits; in the role as configuration librarian maintained the integrity and accuracy of the configuration data.

Excellent interpersonal and communication skills and is experienced in working with onsite & offshore managers, business people and developers.

Skill Set

ETL Tools : Informatica Power center 9.5/8.6/8.1, Data Explorer 9.5.1, Power Exchange 9.5.1, Data Quality 9.5.1

Relational Databases : DB2 9.7[Primary], Oracle. Teradata SQL, Hive

Hadoop : Hive

Scripting : Shell, Python

Languages : SQL, DB2 SQL/PL

Operating Systems : Linux, Windows, Mac

Other Tools :CA Harvest SCM, Humming Bird for Mainframe, TOAD, SQL Developer, WinZip

Organizational Experience

August 1st, 2011 to March 30th, 2016 with Evry INDIA (formerly SPAN InfoTech India Pvt Ltd), Bangalore

Courses

MongoDB for Developers

Python

Educational Qualifications

Bachelor of Engineering in Information Science & Technology from VTU, Belgaum with 71% in the year 2011

Awards

SPOT Award for the appreciation by Customer in Nov 2013, Aug 2015 and Feb 2016

Project: Billing–Health Care Systems November 2011 to March 2016

Client: HMS Holdings Corp, USA

Designation: Senior Software Engineer

Technologies: Informatica PowerCenter 9.5.1, IBM DB2, TWS scheduler, SharePoint, Harvest

Project Details:

HMS client provides analytics and engagement solutions to help reduce costs for healthcare payers, improve health outcomes and enhance their member experience.

This project comes under Coordination of Benefits solution provided by HMS, wherein the application identifies the primary responsible commercial Insurance payer for the claims submitted to CMS

Architecture Details:

This is an n-tier application with server-side implementation using core Java, DB2 & Informatica. Client-side application is developed using J2EE with spring framework.

Roles:

Development of mappings, workflows and shell scripts as per requirements provided by business users.

Involved in customer meetings for requirement gathering and analysis.

Implemented Workflow recovery by having sessions level and record level restartability

Performance tuning and performance testing of the Informatica processes

Solid experience in Troubleshooting Sessions using the Debugger tool, by Log tracing and through running Test loads

Involved in Production movement of mappings, workflows from Development, Test to Production repository using Deployment Groups on weekly basis.

Created Workflows with various tasks like Session, Command, Email, Control Task and Worklets.

Extensively used Connected/unconnected Lookups, Filter, Router, Aggregator, Expression, Update strategy, Joiner for mapping Development. Used Mapping parameters and parameter files on different mappings and sessions, based on various business requirements.

Involved in POC’s for customers for requests such as invocation of web services from PowerCenter, hosting web services using Web service hub, generation of COBOL file in PowerExchange.

Created Workflows with various tasks like Session, Command, Email, Control Task and Worklets.

Onsite co-ordination and communication regarding clarification, design, development and project related processes

Created shell scripts which will be called by TWS application for automating the ETL process developed

Configured sessions to run on Grid, to increase performance and scalability.

Performed POC’s for application matching operation using Hadoop tools like Hive.

Design, create, and implement database systems based on the end user's requirements by ensuring the data quality and integrity in databases

Created Functions, scripts, stored procedures and triggers to support application development

Created shell scripts which will be called by TWS application for automating the ETL process developed.

Providing technical guidance to the trainees in the team during implementation activities.

Preparation of Unit test cases, Low level design documents and Code reviews of informatica Processes

Preparing MOM's, Estimation guidelines and Coding standard documents as a part of quality process.

Instilled development standards in team by developing mapping templates, documents for Naming conventions, Error handling strategies, Code review and Production release checklists

Prepared the process and technical documentation of the project flow

Extensively involved in Production support and also in resolving issues related to UAT and Production.

Project: Rebill - Health Care System July 2012 to January 2014

Client: HMS Holdings Corp, USA

Designation: Senior Software Engineer

Technologies: Informatica PowerCenter 9.5.1, IBM DB2, TWS scheduler, SharePoint, Harvest

Project Details:

The rebilling product enables Yield Management Project Managers (YMPMs) or Carrier Relation Ship Managers (CRMS) to identify populations of claims that require follow-up and can be resubmitted for payment to carriers

Roles:

Involved in requirements gathering for the application.

Involved in building the ETL source to Target specification documents by understanding the business requirements

Developed mappings that perform Extraction, Transformation and load of source data into target application schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings

Involved in SQL development activities such as create, read, update, and delete a table as per the application requirement.

Participated in Testing and performance tuning by identifying bottlenecks in mapping logic and resolving them, setting cache values and creating partitions for parallel processing of data

Conducted knowledge transfer sessions with client resources and documented Data Mappings/ Transformations as per the business requirements

Performed automation of ETL process, performance optimization, release verification and configuration management

Project: Matching – Medicaid COB Dec 2012 to Jan 2014

Client: HMS Holdings Corp, USA

Designation: Senior Software Engineer

Technologies: IBM DB2, Informatica PowerCenter 9.5/8.6.1, TWS scheduler, SharePoint, Harvest

Project Details:

Application deals with processing Pharmacy claims for billing, it finds the commercial insurance party which is eligible for the claim and intimates the commercial insurance party about the claim. Once the Claims are paid by the commercial insurance parties, client gains profit. Application process claims electronically.

Roles:

Developing and testing shell scripts to automate the Informatica processes by following complete SDLC.

Monitoring the Informatica process and analyze the possibilities of tuning the process and provide solution for tuning the process.

Developed Unit Test Cases to ensure successful execution of the data loading processes.

Automation scripts, code review and test case review

Knowledge transfer to Onsite team with the process details

Performance Optimization, Release Verification and Configuration Management

Contact this candidate