JIYAJI J P
E-Mail : abkv5o@r.postjobfree.com
Mob : 974-***-****
OBJECTIVE:-
Want to involve myself in a challenging environment offering scope for Growth & Development
and an opportunity to apply my functional experience of Informatica to effectively contribute towards the
achievement of the organizational objective.
TRAINING EXPERIENCE:-
Successfully completed Oracle-Informatica course from Quest IT solutions, Bangalore.
Complete knowledge on Informatica powercentre 8.x and Oracle 10g Database.
Learnt different phases of Data Warehouse development lifecycle from designing,
development, testing and implementation.
Designed various Mappings for extracting data from various sources involving relational tables
and flat files. Created Re-Usable objects like Mapplets & Re-usable transformations for business
logic.
Knowledge about transformations for loading the data into Oracle database.
• E.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank
transformations, Expressions, Aggregator and Sequence Generator transformations.
Good knowledge in Data Warehousing concepts.
PROJECTS EXPERIENCE:-
Project 1, Title : Hybrid Subscription Warehouse.
Environment : Informatica 8.6, Oracle 10g, Flat Files
Description : Hybrid Subscription Warehouse is value-added service (VAS) company which
offered content management, mobile advertising, ring tones, phone backup, voice portals and voice SMS.
We receives log files for each Telecom Operator based on new subscribers list, new subscriptions for
various VAS services on Daily Basis which needs to be reformatted as per business logic and later will be
loaded to Dimension and fact tables. These data warehouse is mainly for purpose of data analysis, report
generation based on various operators, various subscriptions during a span of time and helpful in decision
making. Source will be flat files which are logs generated on daily basis based on calls routed to server.
Project 2, Title : - Secure Dynamic Data Transfer for WiCoM using RSA
Environment : - C#, Dot Net, Android, SQL SERVER 2008, Web service
Description : - Secure Dynamic Data Transfer using WiCoM & RSA propose a secure
wireless content management system using RSA cryptographic encryption method. This application
provides interface for the user to securely add in various useful data, which can be interactively displayed
on the web. To acquire more security here I used stegnographic method to hide RSA encryption Keys.
TECHNICAL SKILLS:-
• ETL/Data Modeling Tools : Informatica Power Center 8.6.1/8.1/x (Repository Manager,
Designer, Work Flow Monitor, Work Flow Manager).
• RDBMS : Oracle11g/10g, SQL SERVER 2008
• Languages : C, C#, CORE JAVA.
ACADEMIC QUALIFICATION:-
• MCA from NIELIT, Calicut, under University of Calicut, Kerala in 2013 Dec with CGPA
7.31/10.
• BSc (Electronics) from CAS, Vazhakkad, under University of Calicut, Kerala with 68.02%.
• 12th from GHSS, Kolathur, Kerala in 2007with 65.5%.
• 10th from GVHSS, Atholi, Kerala in 2005 with 72.37%.
INTERESTS:-
• Playing and watching Cricket and Listening music
ACHIEVEMENT:-
• College union General Captain in College of Applied Science, Vazhakkad.
PERSONAL DETAILS:-
Date of Birth : 21/05/1990.
Gender : Male
I hereby declare the above information is true as per my knowledge
Thanks