Vimal Kishore Email & Phone Number

Plano, Tx, Us

Plano, Tx

Working for North America major automobile client for their sales and marketing arm. It coordinate vehicle sales, parts and service for dealers in US states. This project includes Four different Data Warehouses which are inter-related to each other and help business users get information about profit they have made in different locations, parts, labors. Data marts are built for various attributes in an existing data warehouse such as billing, shipping, inventory, receiving, dealership, reconciliation, journal details, logistics etc.

Bengaluru Area, India

Working for North America large captive auto finance, mortgage and leasing products organization. The objective is to build a single retail and lease repository from their complex federated structure of loan processing from various banking and non-banking channels.Responsibilities:• Requirement analysis, Module estimation and High level design.• Building CLE framework; which is shared among multiple vendors and ETL codes as per standards .• Handling multiple source system writing complex SQL queries to meet the business requirements.• End to End business solution and helping in client ARB’s.• Review LLD’s , Code design, UTC/UTR’s and Release notes.• Handling ETL team for work allocation and closure.

Bengaluru Area, India

Worked for multiple Financials Services and Telecom clients including leading wealth management corporations. In the most recent engagements, got the chance to work on emerging DW trends in analytics space including handling of unstructured data sources. The basic approach was to use Informatica to improve an existing process for reconciliation for invoice and advices. In the new process payment channels receive files from different data source. Data and pattern matching is handled by external vendor which generates reports in easy to understand by business users. This project requires handling of large set of unstructured data format and their integration with INFA power center. Responsibilities:• Understanding of existing subject areas which includes EDIFACT source data and target systems. • Matching and reconciliation after processing through Data Transformer.• Involved in understanding the client requirement and planning for execution related to assigned modules.• Developing the ETL codes (Mapping and Workflows) and peer reviews. • Responsible for High level design, Data Mapping docs and Technical Design docs for the individual modules.• Client facing roles which includes interaction with BA's.

Noida Area, India

Responsibilities:- Test case execution.- Capturing the test results and validation.- Preparing test data.