ARCHANA E Mail:
[email protected] [email protected] om Mobile: +91 8008!!!9" 8008!!!9"
#b$ec%i&e: Looking for a challenging and Responsible position in the field of Information Technology and have the flexibility to adapt to any new environment and work on any project wish to utilize this experience in an organization as part of them.
'R#(E))*#NA ),MMAR-:
aving .! /ear of !xperience on "ata #arehousing in analysis$ design$ and development of software applications using *nforma%ica eigner 8.! 2 9.0.1
a%a 3arehoing experience 3arehoing experience implementation using *nforma%ica 'o3er Cen%er 8.!$ 8.!$9.0.% 9.0.% & E5 'oncepts. E5 'oncepts.
!xtens !xtensiv ively ely worke worked d on *nforma%ica eigner Componen% ( )ource *nalyzer$ #arehouse #arehouse "esigner "esigner$$ +apping +apping "esigner "esigner$$ +applet +applet "esigner "esigner$$ Trans Transforma formation tion "eveloper "eveloper$$ and #orkflo #orkflow w +anager.
'reating 'reating the mapping mapping using using transfor transformatio mations ns (il%er6 (il%er6 )orce )orce 7alifier6 7alifier6 oiner6 oiner6 Aggrega%or Aggrega%or66 Epreion6 oop6 ,p;a%e )%ra%eg/6 )e<ence =enera%or.
!xpert in "# concepts.
,nowledge of data warehousing techni-ues )tar )nowflake schema.
Experience of implementing implementing slowly slowly Changing Dimensions Dimensions..
/ood ,nowledge on "ata #arehousing #arehousing concepts like )%ar )chema$ )chema$ "imensions and 0act tables.
1sed !TL process to !xtract$ Transform and Load the data into %age area and area and data warehouse
"eveloped full and Incremental load mapping2s to populate fact and dimension tables by creating dynamic mapping &ariable with &ariable with parame%er file parame%er file process.
3ptimizing Informatica +apping2s and )essions to impro&e %he performance
!rror handling and performance tuning.
#orked #orked with different data sources like (la% (ile an; Rela%ional a%abae
#orking #orking experience in 3racle 4i&%5g$ )6L$ )6L 7lus$ T3*"$ #indows 8795554:4;$ 8795554:4;$ #in
/ood communic communication ation skills$ interpers interpersonal onal skills$ skills$ team coordina coordination tion and versed versed with )oftware )oftware "evelopment processes.
5ECHN*CA )>*)E5: E5 5ool a%abae #pera%ing )/%em 'rogramming
= Informatica 7ower 'enter :.>$4.5.% = 3racle 4i&%5g = #indows$ 1
P a g e | 2 Applica%ion 5ool
= Toad
E;ca%ional 7alifica%ion:
+aster of 'omputer *pplications in 955: from ,akatiya 1niversity. 1niversity.
?or Eperience:
#orking with )) with )) 5ech )/%em '&% %; $?anglor %; $?anglore e $ from
'ro$ec% in ;e%ail: 'ro$ec% 1: 'ro$ec% Name Clien% En&ironmen% ra%ion
: :
=lobal Re&ene 5/co )afe%/ 'ro;c% Boca Ra%on6 (lori;a. : *nforma%ica 9.0.16 #racle10g. : an 011 %o %ill ;a%e.
ecrip%ion: Tyco Tyco )afety 7roducts is part of the Tyco Tyco 0ire and )ecurity division of Tyco Tyco International Ltd. Tyco Tyco )afety 7roducts2 businesses design$ manufacture$ and distribute electronic security systems$ fire protection$ detection and suppression systems$ sprinklers and fire extinguishers including more than >5 brands distributed in markets across the globe. Informatica is used to !xtract data from disparate !R7 systems$ transform the "ata by implementing complexsimple business logic and loading the data in data warehouse. . Role 2 Reponibili%/:
1nderstanding the )ource )ystem$ *nalyzing users@ re-uirements.
Involved in !xtraction$ Transformation Transformation and Loading of the data from different data
sources like 0lat files and 3racle to the "ata warehouse.
Importing )ource Tables Tables from the respective databases and created Reusable
Transformations and +apping2s using "esigner Tool set of Informatica.
'hecking logs in case of #orkflowTask failure.
'reated batches to run several sessions se-uentially and concurrently. concurrently.
"eveloped mapping2s using Informatica 'o3er Informatica 'o3er Cen%er eigner to eigner to load data from
various source systems to target database.
Involving performance tuning.
'ro$ec% : 'ro$ec%
:
C)M a%a Mar%
P a g e | 3 Clien% Manfac%ring En&ironmen% ra%ion
: :
Char%ere;
)e ) emi
Co C on;c%or
*nforma%ica 8.!6 #racle10g. : ne 010 %o ec 010.
ecrip%ion: 'hartered )emi conductor +anufacturing 'ompany is 3ne of the worlds top dedicated semi conductor manufacturing company which provides innovative solutions for manufacturing I's that power today@s consumer communications and computing products. This project is aimed to reduce the manufacturing cost and improve the sales by identifying the key factors like the total sales revenue on a monthly and -uarterly basis on the region and sales amount. The decision support system is focused on analyzing the entire business proces process s in order order to provid provide e criti critica call inform informati ation on like like daily daily revenu revenue$ e$ total total sales sales$$ goals goals information on employees and new plans to company for developing business intelligences system based on ?.3s and information products. Role 2 Reponibili%/:
1nderstanding various business re-uirements.
"eveloped the informa%ica mapping to mapping to load the data into %aging table %aging table from multiple
data sources such as #racle and #racle and %e% file. transformations depend upon re-uirements to "eveloped mappings using various transformations implements bine logic and logic and also tuned them better performance. cae for assigned tasks to self review the test cases. 7repared the re-uired ,ni% %e% cae for
'ro$ec% : 'ro$ec% Clien% En&ironmen% ra%ion
: : :
*C*C* Ban. *C*C**n;ia. *nforma%ica 8.16 #racle10g. : No& 009 %o Ma/ 010.
ecrip%ion: I'I'I 7rudential$ one of the biggest Life Insurance 'ompanies in India. This project is to maintain the "atabase which has lots of historical data. )o data warehouse plays a major role in enabling various stores to view the data at a lowest level and help them to make decisions to bring more revenue to company with new policies. "ifferent entities of this project were to identify user data from all data sources on diversified systems. . Role an; Reponibili%/:
"eveloped !TL mappings$ transformations transformations using *nforma%ica 'o3er Cen%er. Cen%er. "evelo "eveloped ped mappi mappings ngs using using vario various us trans transfor forma matio tions ns like like update update %ra%eg/6 %ra%eg/6 loop6 loop6 %ore; %ore; proce; proce;re re66 Ro%er Ro%er$$ (il% (il%er er66 e< e<en ence ce gene genera ra%o %or6 r6 $oin $oiner er66 aggr aggreg ega%e a%e transformation transformation and expression. Involved into orce co;e re&ie3$ re&ie3 $ the mappings created by my team members. 7repared ;eplo/men% ;ocmen% and ;ocmen% and assisted to deployment team while migration.
P a g e | 4
Invo Involv lved ed in performance %ning by optimizing optimizing the sources$ sources$ targets$ targets$ mappings mappings and sessions. +appings were designed to cater the lo3l/ changing ;imenion. ;imenion. "eveloped "eveloped several several reable %ranforma%ion %ranforma%ion and mapple% mapple% that were used in other mappings.
