Senior consultant Informatica
Resume:
Vikalp Khare
Experience
Skillset Data warehousing / BI
Email ******.*****@*****.***
Legal Work H1B
Status
Objective
To pursue a career with a company having a global vision that encourages
creativity and offers an opportunity to grow professionally as well as
personally.
Work Experience
Presently, I am working as a Senior Consultant with Deloitte Consulting.
Have around 9 years of experience in multiple End to End Data Warehouse
implementations and development of Data Migration solutions through ETL
tools like Informatica, SSIS etc. I have worked in domains like Banking -
Merchant Operations, Healthcare - Drug Safety & Insurance.
Experience Summary:-
Deloitte Consulting (Current) : - 2 Years and 4 Months
Fidelity Investment Ltd : - 10 months
Infosys Technologies Ltd : - 5 Years and 9 Months
Technical Exposure
. Worked on Informatica PowerCenter Ver. 8X & 9X with Oracle, SQL
server 2012 & DB2
. Worked extensively on building PL/SQL packages on Oracle 10g for Data
Migration solutions
. Done data modeling using ER studio for bank merchant operations
. Worked on Informatica Data quality ver 8.5
. Worked on Informatica Power Exchange for reading various VSAM files.
. Conducted various trainings for
1. Informatica power Center
2. Informatica Data Quality
3. SQL server Integration services
. Worked on Teradata V2R5 & Netezza 4.6.
. Worked on Ab Initio & SSIS too.
. Developed Custom Data warehousing solution and a Functional Data
Profiling solution that can be used across the board for
Pharmacovigilance domain clients. Presented the same in Oracle
Heath Sciences conference, 2014 held in St Louis.
. Informatica 8x certified consultant
. Teradata V2R5 certified consultant
DETAILS OF THE PROJECTS WORKED ON
01. Project Otsuka Data Profiling
Name
April 2014 to Till Date
Duration :-
Deloitte Consulting LLP
Organization:
-
Description of the project
To perform a business/functional data profiling for a leading
Pharmaceutical company to highlight the current functional data
deficiencies which can be acted upon by the stakeholders and rectified
during their ongoing re-plat forming activity.
Role : Custom Solution Designer
Responsibility : Generate profiled data output reports
Analyze the profiled outputs and come up with the
suggested remediation approach
Conduct business interviews to understand key concerns
Conduct data discovery interviews and initial data audit
Prioritize profile requirements in facilitated sessions
with information management and business personnel
Generate a customized data profile solution which can be
used across the board for all Pharmacovigilance(PV)
clients to improve the overall PV data quality
Hardware : Intel Based Platform
Software : PL\SQL on Oracle 2011g
02. Project Daiichi Data Migration
Name
July 2013 to April 2014
Duration :-
Deloitte Consulting LLP
Organization:
-
Description of the project
To develop and implement an End to end Data migration solution for a
global pharmaceutical company with objective to integrate three regional
databases into a consolidated global database which in-turn enables them
to use an industry standard Adverse Event Management tool by Oracle (ARISg
to Argus migration)
Role : PL/SQL developer / Solution designer
Responsibility Understood and implemented the Data conversion logic
for Migrating the Patient Information from ARISg to
ARGUS.
. Developed and executed Unit test cases for the code.
. Supporting Functional specific testing and Technical
acceptance testing.
. Understood the existing ARGUS Backend Database schema
.
. Provided accurate status reporting to the management
. Perform peer review on the deliverables that were
provided to client.
. Ensuring zero percent defect leakage to the client.
. Built a complex Hierarchy system logic for customized
reporting requirements and advised on the data aspects
to the reporting team.
Hardware : Intel Based Platform
Software : PL\SQL on Oracle 2011g
03. Project Alcon Spal Plus
Name
April 2013 to July 2014
Duration :-
Deloitte Consulting
Organization:
-
Description of the project
To implement an improved management reporting solution for Actuals. To
design a solution which provides the improved capabilities and benefits
as listed below:
1. Actuals P&L detail with a new more detailed Chart of Accounts (COA)
not offered in existing system.
2. An expanded company hierarchy for visibility into entity and market
Actuals activity.
3. Actuals data integration with multiple heterogeneous Data sources for
full visibility into Eye Care division expenses.
Role : ETL Lead / Solution Architect
Responsibility Understood and implemented the business requirements
in SSIS.
. Developed and executed Unit test cases for the code.
. Supported Functional specific testing and Technical
acceptance testing.
. Understood end-to-end technical architecture of the
client's environment and proposed performance
improvement options in the project.
. Provided accurate status reporting to the management
. Perform peer review on the deliverables that were
provided to client.
. Assigned daily tasks to the team with long term and
short term deliverables.
. Ensured zero percent defect leakage to the client.
. Built a complex Hierarchy system logic for customized
reporting requirements and advised on the data aspects
to the reporting team.
Hardware : Intel Based Platform
Software : SSIS & SQL Server 2005.
04. Project Aflac
Name
May 2012 to April 2013
Duration :-
Deloitte Consulting
Organization:
-
Description of the project
Implementation of Group Insurance ODS by utilizing knowledge and
expertise in Analytics Accelerator for Insurance model. Party, Policy,
Product and Billing were the subject areas which were built as part of
this implementation.
Role : ETL Lead / Solution Architect
Responsibility Understood and implemented the business requirements
in SSIS.
. Developed and executed Unit test cases for the code.
. Supported Functional specific testing and Technical
acceptance testing.
. Understood end-to-end technical architecture of the
client's environment and proposed performance
improvement options in the project.
. Provided accurate status reporting to the management
. Perform peer review on the deliverables that were
provided to client.
. Assigned daily tasks to the team with long term and
short term deliverables.
. Ensured zero percent defect leakage to the client.
. Built a fact layer for customized reporting
requirements and advised on the data aspects to the
reporting team.
Hardware : Intel Based Platform
Software : SSIS & SQL Server 2012.
05. Project Fil-RAS Informatica
Name
Oct 2011 to May 2012
Duration :-
Fidelity International
Organization:
-
Description of the project
Fidelity International is one of the investment banking service providers
in the world. Business wanted to streamline the process of Fund data
distribution across various buy - sell applications within Organization.
Informatica Near real time jobs were created as a part of this solution,
to ensure a single change at one point gets reflected in all the
downstreams with in a stipulated time frame.
Role : Technology Lead
Responsibility : Analyze functional design documents for technical
feasibility.
Understand business process and draft technical design
documents based on functional documents.
Develop, test and support ETL Near Real Time Cyclic jobs
using Informatica and Control-M scheduler.
Review code & documentation for the deliverables
designed and developed by the team.
Handling a team of 4 Developers.
Hardware : Intel Based Platform
Software : Informatica Power Center 8.6.1, Informatica 8.1.1.
Oracle 10g.
06. Project Fil-RAS Informatica
Name
July 2011 to Oct 2011
Duration :-
Fidelity International
Organization:
-
Description of the project
Fidelity International is one of the investment banking service providers
in the world. The Informatica support group within the firm wanted to
streamline their data integration approach with different existing
applications henceforth improving the efficiency of their current
processes. This project involved support and development of enhancements
in existing applications. The project included multiple applications
support running on various versions of Informatica also giving an
exposure to various databases. It mainly focused on application support
with small code enhancements.
Role : Technology Lead
Responsibility : Defining the processes & streamlining the existing
support system.
Understanding the existing systems, and proposing better
solution to existing application using Informatica.
Handling a team of 6 developers.
Hardware : Intel Based Platform
Software : Informatica Power Center 8.6.1, Informatica 8.1.1.
Oracle 10g.
07. Project Merchant Data Warehouse (MDW)
Name
Feb 2009 to June 2011
Duration :-
Bank Of America
Customer :-
Description of the project
Bank of America is one of the largest commercial banking service
providers in the world which provide credit card services to large retail
institutions like Target, Best Buy etc within North America. The merchant
reporting group within the firm wanted to enhance their data reporting
strategy henceforth improving the efficiency of their current
processes. This project involved development from scratch i.e. high/low
level design, code development, testing and implementation of the
Merchant data warehouse (MDW). The project included designing and
developing one of the bank's biggest data warehouses of approximately
19TB. It mainly focused on developing ETL mapping from source to target
database.
Role : Onsite Technology Lead
Responsibility : Defining the architecture, design approach and
integration strategies.
Understanding source systems and Requirement Analysis.
Data Modeling for Merchant Data Warehouse.
Design, development & testing of Data-warehouse
Handling a team of 2 developers at onsite & offshore
team of 8 developers.
Hardware : Intel Based Platform
Software : Informatica Power Center 8.6.1, Informatica Power
Exchange, Netezza, Unix, Maestro.
08. Project Marketing Nach Merge- Lite (MnM - Lite)
Name
Nov-2008 to Feb-2009
Duration :-
America Express
Customer :-
Description of the project
MnM was created to consolidate data from five A/R platforms (CRP, Optima,
Triumph, CARS and Canada Globestar) into standardized data feeds to be
used for marketing purposes.
MnM had primarily 10 types of data feeds, used by 20+ interfaces, about
150+ daily, monthly and ad-hoc jobs have a dependency on MnM
processing. It was one of the biggest Mainframe data warehouse
application migration/Re-engineering in American Express using
Informatica power centre & Power exchange. This was a 100% offshore
driven delivery.
Role : Offshore Programmer Analyst
Responsibility : Analyzing the existing Mainframe programs.
Designing and Development of ETL solution.
Design, development & testing of Informatica jobs.
Handling a team of 4 offshore developers.
Hardware : Intel Based Platform
Software : Informatica Power Center 8.6.1, Informatica Power
Exchange, Unix, Control-M.
09. Project Institutional Customers Linking and Identification
Name Capability (iCLIC)
Duration Jun 2007 to Nov
:- 2008
Customer American Express
:-
Description of the project:
The Institutional Customer Linking and Identification Capability will
identify and link an
Institutional customer's relationship with the company. It will also
provide different relationship
Views of company's institutional customer base. The purpose of iCLIC
is to help the enterprise
more accurately and efficiently "know" their institutional customer
base and which opportunities
exist in the market place for marketing, penetration, share of
wallet, risk, and return on investment for every institutional US
based customer. The immediate impact will be for Marketing and
Underwriting in terms of targeting potential customers and estimating
total exposure across all lines of business.
Role : Software Engineer
Responsibilit : Coding, Testing, Analysis, Design
y
Hardware : Intel Based Platform
Software : UNIX, Shell Scripting, Perl, DB2,PL/SQL, Ab Initio.
10. Project Name Deals Management
Duration :- Feb 2007 to June 2007
Customer :- Bank Of America
Description of the project:
Bank of America is amongst the world's leading financial services
companies with operations in Consumer Banking, Commercial Banking,
Global Corporate and Investment Banking (GCIB), Asset Management and
Capital Markets Pipeline Reporting (CRM).
Clients needs for the GIB Sales Pipeline Reporting project, process
of implementing new data warehouse technology within CRM Services.
This technology will accumulate all necessary data from CIBR deals,
CED, DAC, CDB and other sources into a single data store, and then
parse out the necessary data into a Sales Data Mart for reporting and
analytics consumption.
Role : Software Engineer
Responsibilit : Analysis of Specification Documents provided for
y mappings and mapplets.
Developing ETL mappings and ETL Mapplets.
Analyze the test data given for the mappings and
mapplets
Testing the mapping and the mapplets using the Unit
test data provided by the client.
Hardware : Intel Based Platform
Software : Informatica Power Center 7.1.3, Oracle 9i,
TeradataV2R5
11. Project Name Portfolio Immigration Management System
Duration :- June 2006 To Feb 2007.
Customer :- Bank Of America
Description of the project
Bank of America is a leading financial institution of USA. The
primary objective of this project was to relocate the existing
3CPplatform to the Teradata environment along with some data model
enhancements. This project involved Requirement analysis, Business
Process design, high level design, testing and implementation of the
project as specified in the client letter. The project also included
designing and developing a robust Data-warehouse for the client. It
mainly focused on developing ETL mapping from source to target
database.
Role : Software Engineer
Responsibilit : Requirement gathering
y Design and development of Data-warehouse
Offshore/Onsite Coordination
Hardware : Intel Based Platform
Software : Informatica Power Center 7.1.3, Teradata V2r5,
Oracle 8i, Unix. Shell Scripts
12. Project Name Phoenix
Duration :- Sep 2005 To Jun 2006
Customer :- Bank Of America
Description of the project
Bank of America is a leading financial institution of USA. The
primary objective of this project was to help risk analysts to gauge
the market risks and accordingly predict and formulate the market
strategies. This project involved high level design, code
development, testing and implementation of the Risk Engine. The
project included designing and developing a robust Data-warehouse for
the client. It mainly focused on developing ETL mapping from source
to target database.
Role : Software Engineer
Responsibilit : Requirement gathering
y Design and development of Data-warehouse
Offshore/Onsite Coordination
Hardware : Intel Based Platform
Software : Informatica, Sybase, SQL Server, Unix
Academics
Examination Board/University Year CGPA
Graduation RGTU, INDIA 2005 7.4
(Bachelor of
Engineering)
High School C.B.S.E, INDIA 2000 6.7
Achievements:-
. Received a couple of "Spot Awards" (in 2013) for Client Service with in
Deloitte consulting.
. Received "Applause award" in my previous project within Deloitte for
Outstanding service to client.
. Awarded Manager's appreciation Award at Fidelity Internations for the
month of November, 2011.
. Won couple of Spot awards for Team leading capabilities during my stint
both at onsite
& offsite within Infosys Technologies.
. Won MVP (Most Valuable Player) award continuously for three quarters
(2008-2009) in
Infosys Technologies.
. Won Excellence award for iCLIC in Infosys Technologies (2008).
. Informatica certified Consultant on Informatica 8X platform.
. Teradata V2R5 certified developer.
Personal Details:-
Citizenship
:-
Indian
Father's Name
:-
Mr. V.K. Khare
Date of Birth:
:-
29th Sept 1983
Hobbies
:-
Traveling, Watching Movies and Listening to Music.
Marital Status:
:-
Married
Languages Known
:-
Hindi, English
Passport & VISA Details:-
Passport No F3127476
Passport Expiry May 5th, 2015
Date
VISA Status H1B valid till March,2016
Contact this candidate