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 features of UIF (Unified Interface Framework) of SCM.

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 meetings and facilitated communication with clients and determined business problems or drawbacks; developed functional business requirements- Proposed architecture and design approach to technical stakeholders; received signoff- Derived the estimation in adherence to the user requirements with Dev, QA, UAT, Prod deployment timelines along with assumptions and risks- Involved in creation of database objects, code and reports with code review and migration activities. - Involved in data extraction, integration, transformation and data storage in target DataWarehouse. - Collaborated with the internal teams and developed database objects - SQL and extracted business data from DRM with Informatica ETL mappings, SQL queries and workflows, cleansed, transformed source data and ingested to DWH to maintain historical records of wireless dimensions.- Developed stored procedures to purge the archived audit records; Views to mimic dimensions.- Identified the root cause of the defects in the QA and UAT phase and resolved the same.- Ensured on-time delivery with quality by following coding standards and technical unit testing.- Involved in the preparation of Knowledge transfer and Process documents for Rogers.- Involved in deployment of code to QA and PROD environment followed by warranty support.

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 claims• 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 increasing efficiency• 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, Sybase, Cognos 8, MKS Integrity, Control-M- Involved in requirement conception; gathered requirements from stakeholders and healthcare experts; - Analyzed the data requirements and proposed Datawarehouse architecture and technical design approach; developed functional business requirements and technical detailed design document presented the same to business and technical stakeholders within MVP and received signoff.- Derived the estimation in adherence to the user requirements.- Validated the healthcare claims with complex SQL queries, views, stored procedures and triggers.- Identified slowly changing dimensions and maintained historical data by creating necessary Oracle tables adhering to client’s DataWarehouse standards and state’s HIPAA standards.- Created BI reports with subscriber claims and accumulator values that enabled stakeholders to manage insurance coverage. Migrated reports from vendor’s environment to MVP’s BI environment.- Involved in code and design reviews of the Informatica jobs/database objects/BI reports and themigration activities to higher-level environments with data protection standards.

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 loading into Capacity Data Store• 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 :- Analysed the high level design document and prepared detailed technical design document source to target mapping based on requirements and enhanced existing Datastage jobs.- Prepared high-level ETL flows and estimated the effort to complete the user requirements- Created efficient Datastage Jobs as per mapping document, Sequencers as per the business requirements, and UNIX Scripts to download page files from URL within the specified time interval - Created efficient Datastage Jobs and sequencers within the team as per mapping document- Reviewed code design and technical unit testing documents to ensure quality- Conducted Work-Product audit for deliverable and shared the documents with the client

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 IMacros) from being static and formula driven to dynamic reports that enabled better, faster senior management decision-making around resource allocation• 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 processes by 60%, increasing both migration efficiency and code quality; further marketing of this tool won substantial new business for the company• 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 system which uses Oracle database to support its retail and wholesale business at various levels • 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 supported client end-user reporting