Sandhya Kumar Email & Phone Number

Munich, Bavaria, Germany

- Enhancing and maintaining RUTA (Resource Utilization and Trend Analysis) monitoring system for database applications on a large scale. - Reviewing and Resolving Data modeling and Database objects tickets with Oracle SQL scripts. - Automated process improvements to speed up Database operations with Oracle Stored Procedures. - Maintaining and enhancing.

Toronto, Canada Area

Employed by Capgemini at Rogers Communications on DRM Wireless Project: Built a strategic tool for Rogers to manage wireless reference data in a consolidated and structured manner. Migrated existing wireless dimension tables that contain referential data on customer wireless plans onto a new DRM application. - Participated in requirement elicitation.

Albany, New York Area

• Employed by Virtusa USA at MVP HeathcareProjects:
• IBM Castlight - Healthcare Member Data: Automated the creation and transmission of IBM Member data feed to Castlight
• CIGNA - Healthcare Provider Claims Adjudication: Reduced the manual intervention to identify providers for claims adjudication; improved data accuracy and turnaround time for processing and paying Cigna and non-par.
• IBM Telemedicine - Healthcare Member Data Feeds: Created Informatica mappings that enabled client to automate the process of securely delivering member information to a third-party vendor, reducing errors and.
• User Requests: Led a project team to successfully deliver a solution that enabled better prioritization and faster resolution of client’s technical incidentsEnvironment: Informatica 9.5.1, UNIX, Oracle, SQL Server.

Chennai Area, India

• Senior Software Engineer - Tech Lead, India
• AIG Insurance Project - Common Financial Platform (CFP): Analysed and enhanced CFP to include general ledger information of Japan; won additional projects with this client based on quality of work
• Cardinal Health Project – Health Metrics Data Monitoring System: Collected metrics information of Cardinal Health applications and loaded into MySQL database. Extracted metric information by downloading page files and.
• Cardinal Health Project – Health Data Marts Transfer: Created ETL jobs to read data to DB2 Staging tables; performed necessary transformations to populate data into Teradata database and data martResponsibilities.

Chennai Area, India

• Software Engineer - Developer, India
• Project for Solution Accelerators – Resource Management Utilization Report: - Environment: Cognos 8.0, Informatica 9.1, Oracle 9i- Created a real-time automated solution (Cognos Dashboard with backend Informatica and.
• Project for Solution Accelerators – INF to DS Migration Tool: - Environment: IBM Websphere Datastage 8.1 (Server and PX), Oracle, Informatica 9.1- Developed an automated ‘INF_DS Migration Tool’ which eliminated manual.
• Project for Clearwire – Switch Sybase to Oracle Migration:- Environment: IBM Websphere Datastage 8.1 (Server), UNIX, Sybase, Oracle- Supported migration of Clearwire’s BOSS system which uses Sybase database to AMDOCS.
• Project for JHFS - Long Term Care (LTC): - Environment: SSIS, SSRS, SQL Server Management 2005- Used MSBI-SSIS and MSBI-SSRS to develop and deliver, on time and with high-quality, an end-to-end analytical system that.