ÿþ<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40" xmlns:ns1="urn:schemas-microsoft-com:xslt"> <head> <meta http-equiv=Content-Type content="text/html; charset=unicode"> <meta name=ProgId content=Word.Document> <meta name=Generator content="Microsoft Word 14"> <meta name=Originator content="Microsoft Word 14"> <link rel=File-List href="Big%20Data27_files/filelist.xml"> <link rel=Edit-Time-Data href="Big%20Data27_files/editdata.mso"> <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--> <title>S K Sinha</title> <!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Template>NormalEmail.dotm</o:Template> <o:Revision>1</o:Revision> <o:TotalTime>0</o:TotalTime> <o:Created>2013-06-04T21:24:00Z</o:Created> <o:Pages>1</o:Pages> <o:Words>4693</o:Words> <o:Characters>26755</o:Characters> <o:Company>Microsoft</o:Company> <o:Lines>222</o:Lines> <o:Paragraphs>62</o:Paragraphs> <o:CharactersWithSpaces>31386</o:CharactersWithSpaces> <o:Version>14.00</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> <link rel=themeData href="Big%20Data27_files/themedata.thmx"> <link rel=colorSchemeMapping href="Big%20Data27_files/colorschememapping.xml"> <!--[if gte mso 9]><xml> <w:WordDocument> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:DoNotExpandShiftReturn/> <w:BreakWrappedTables/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="&#45;-"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-536870145 1073786111 1 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} a:link, span.MsoHyperlink {mso-style-noshow:yes; mso-style-priority:99; color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-noshow:yes; mso-style-priority:99; color:purple; text-decoration:underline; text-underline:single;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} p.boldtext, li.boldtext, div.boldtext {mso-style-name:boldtext; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; font-weight:bold;} p.boxbackground, li.boxbackground, div.boxbackground {mso-style-name:boxbackground; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; background:#E2EFFC; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} p.fatlink, li.fatlink, div.fatlink {mso-style-name:fatlink; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:7.5pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; color:#0066CC; font-weight:bold;} p.orange, li.orange, div.orange {mso-style-name:orange; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; color:#F09261;} p.sectionheading, li.sectionheading, div.sectionheading {mso-style-name:sectionheading; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; background:#FF6600; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} p.smallboldtext, li.smallboldtext, div.smallboldtext {mso-style-name:smallboldtext; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:7.5pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; font-weight:bold;} p.smalltext, li.smalltext, div.smalltext {mso-style-name:smalltext; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:8.5pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} p.whitebold, li.whitebold, div.whitebold {mso-style-name:whitebold; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; color:white; font-weight:bold;} p.xslnormboldtext, li.xslnormboldtext, div.xslnormboldtext {mso-style-name:xslnormboldtext; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; font-weight:bold;} p.xslnormitalictext, li.xslnormitalictext, div.xslnormitalictext {mso-style-name:xslnormitalictext; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; font-style:italic;} p.xslnormtext, li.xslnormtext, div.xslnormtext {mso-style-name:xslnormtext; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} p.xslreditalictext, li.xslreditalictext, div.xslreditalictext {mso-style-name:xslreditalictext; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; color:red; font-style:italic;} p.xslresponsetext, li.xslresponsetext, div.xslresponsetext {mso-style-name:xslresponsetext; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} p.xslscreeningkb, li.xslscreeningkb, div.xslscreeningkb {mso-style-name:xslscreeningkb; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:15.0pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} p.xslsummarytable, li.xslsummarytable, div.xslsummarytable {mso-style-name:xslsummarytable; mso-style-unhide:no; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} span.boldtext1 {mso-style-name:boldtext1; mso-style-unhide:no; font-weight:bold;} span.Heading1Char {mso-style-name:"Heading 1 Char"; mso-style-priority:9; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Heading 1"; mso-ansi-font-size:14.0pt; mso-bidi-font-size:14.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#365F91; mso-themecolor:accent1; mso-themeshade:191; font-weight:bold;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} </style> <![endif]--> </head> <body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'> <div class=WordSection1> <p class=MsoNormal style='margin-left:120.0pt;text-indent:-120.0pt;tab-stops: 120.0pt;mso-layout-grid-align:none;text-autospace:none'><b><span style='font-family:"Calibri","sans-serif";mso-bidi-font-family:Calibri; color:black'>From:<span style='mso-tab-count:1'>                              </span></span></b><span style='font-family:"Calibri","sans-serif";mso-bidi-font-family:Calibri; color:black'>route@monster.com<o:p></o:p></span></p> <p class=MsoNormal style='margin-left:120.0pt;text-indent:-120.0pt;tab-stops: 120.0pt;mso-layout-grid-align:none;text-autospace:none'><b><span style='font-family:"Calibri","sans-serif";mso-bidi-font-family:Calibri; color:black'>Sent:<span style='mso-tab-count:1'>                               </span></span></b><span style='font-family:"Calibri","sans-serif";mso-bidi-font-family:Calibri; color:black'>Tuesday, June 04, 2013 3:54 PM<o:p></o:p></span></p> <p class=MsoNormal style='margin-left:120.0pt;text-indent:-120.0pt;tab-stops: 120.0pt;mso-layout-grid-align:none;text-autospace:none'><b><span style='font-family:"Calibri","sans-serif";mso-bidi-font-family:Calibri; color:black'>To:<span style='mso-tab-count:1'>                                   </span></span></b><span style='font-family:"Calibri","sans-serif";mso-bidi-font-family:Calibri; color:black'>hg@apeironinc.com<o:p></o:p></span></p> <p class=MsoNormal style='margin-left:120.0pt;text-indent:-120.0pt;tab-stops: 120.0pt;mso-layout-grid-align:none;text-autospace:none'><b><span style='font-family:"Calibri","sans-serif";mso-bidi-font-family:Calibri; color:black'>Subject:<span style='mso-tab-count:1'>                          </span></span></b><span style='font-family:"Calibri","sans-serif";mso-bidi-font-family:Calibri; color:black'>Please review this candidate for: Big Data<o:p></o:p></span></p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal><a name=top><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>This resume has been forwarded to you at the request of Monster User xapeix01 <o:p></o:p></span><!--OptionalMessage--><!--JobSeekerSummary--><!--HTMLRenderer--><!--ResumeInstructionalText--><!--Referral--><!--ContactInfo--></a></p> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=650 style='width:487.5pt;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in' xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:m="http://schemas.monster.com/Monster"> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'> <td style='padding:0in 0in 0in 0in'> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td style='padding:0in 0in 0in 0in'> <div> <p class=MsoNormal><span style='mso-bookmark:top'><strong><FirstName><span style='font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman"; color:black'>Santosh</FirstName> <LastName>Kumar</LastName>&nbsp;</span></strong></span><span style='mso-bookmark:top'><b><span style='font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black'><o:p></o:p></span></b></span></p> </div> <div> <p class=MsoNormal><span style='mso-bookmark:top'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman";color:black'>Last updated:</span></b></span><span style='mso-bookmark:top'><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>&nbsp; </span></span><span style='mso-bookmark:top'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";color:black'>05/02/13</span></span><span style='mso-bookmark:top'><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><o:p></o:p></span></span></p> </div> <span style='mso-bookmark:top'></span></td> <span style='mso-bookmark:top'></span> <td style='padding:0in 0in 0in 0in'><span style='mso-bookmark:top'></span></td> <span style='mso-bookmark:top'></span> </tr> </table> <span style='mso-bookmark:top'></span></td> <span style='mso-bookmark:top'></span> </tr> <tr style='mso-yfti-irow:1'> <td style='border:none;border-top:solid #D4D4D4 1.0pt;mso-border-top-alt: solid #D4D4D4 .75pt;background:#FFFFCC;padding:0in 0in 0in 0in'> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 11.25pt 11.25pt 11.25pt 11.25pt'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td valign=top style='padding:11.25pt 11.25pt 11.25pt 11.25pt'> <div> <p class=MsoNormal style='line-height:12.75pt'><span style='mso-bookmark: top'><strong><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Job Title:</span></strong></span><span style='mso-bookmark:top'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>&nbsp; no specified <o:p></o:p></span></span></p> </div> <div> <p class=MsoNormal style='line-height:12.75pt'><span style='mso-bookmark: top'><strong><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Company:</span></strong></span><span style='mso-bookmark:top'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>&nbsp; no specified <o:p></o:p></span></span></p> </div> <div> <p class=MsoNormal style='line-height:12.75pt'><span style='mso-bookmark: top'><strong><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Rating:</span></strong></span><span style='mso-bookmark:top'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>&nbsp; Not Rated<o:p></o:p></span></span></p> </div> <div> <p class=MsoNormal style='line-height:12.75pt'><span style='mso-bookmark: top'><strong><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Screening score:</span></strong></span><span style='mso-bookmark:top'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>&nbsp; no specified <o:p></o:p></span></span></p> </div> <div> <p class=MsoNormal style='line-height:12.75pt'><span style='mso-bookmark: top'><strong><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Status:</span></strong></span><span style='mso-bookmark:top'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>&nbsp; Resume Received<o:p></o:p></span></span></p> </div> </td> <span style='mso-bookmark:top'></span> <td valign=top style='padding:11.25pt 11.25pt 11.25pt 11.25pt'> <div><Address1 /> <p class=MsoNormal><span style='mso-bookmark:top'><span style='font-size: 9.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman"'><br> <City>Fremont</City>, <StateAbbrevMsg MessageID="294554">CA</StateAbbrevMsg>&nbsp;&nbsp;<PostalCode>94539<br> </PostalCode><CountryAbbrevMsg MessageID="294458">US<o:p></o:p></span></span></p> </CountryAbbrevMsg> <div> <p class=MsoNormal><span style='mso-bookmark:top'><strong><PhoneType MessageID="133625"><span style='font-size:9.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'>Mobile</PhoneType>: </span></strong></span><span style='mso-bookmark:top'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><Number>4152649262</Number> &nbsp;&nbsp;<br> </span></span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><a href="mailto:skumar.bigdata@hotmail.com"><EmailAddress>skumar.bigdata@hotmail.com</EmailAddress></a><o:p></o:p></span></p> </div> </div> </td> <td valign=top style='padding:11.25pt 11.25pt 11.25pt 11.25pt'><!--ResumeEmailNavigationLinks--> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook: 1184;mso-padding-alt:0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td style='padding:0in 0in 0in 0in'> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook: 1184;mso-padding-alt:0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td style='padding:0in 0in 0in 0in'> <p class=MsoNormal><strong><span style='font-size:8.5pt;font-family: "Arial","sans-serif";mso-fareast-font-family:"Times New Roman"'>Quick View Links:</span></strong><span style='font-size:8.5pt;font-family: "Arial","sans-serif";mso-fareast-font-family:"Times New Roman"'><o:p></o:p></span></p> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 align=left width="100%" style='width:100.0%;mso-cellspacing:0in; mso-yfti-tbllook:1184;mso-table-lspace:2.25pt;mso-table-rspace:2.25pt; mso-table-anchor-vertical:paragraph;mso-table-anchor-horizontal:column; mso-table-left:left;mso-padding-alt:2.25pt 2.25pt 2.25pt 2.25pt'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'> <td width=130 style='width:97.5pt;padding:2.25pt 2.25pt 2.25pt 2.25pt'> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><a href="#resume">Resume Section</a><o:p></o:p></span></p> </td> </tr> <tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'> <td width=130 style='width:97.5pt;padding:2.25pt 2.25pt 2.25pt 2.25pt'> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><a href="#summary">Summary Section</a><o:p></o:p></span></p> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> <tr style='mso-yfti-irow:2;mso-yfti-lastrow:yes'> <td style='padding:0in 0in 15.0pt 0in'> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>&nbsp;<o:p></o:p></span></p> </td> </tr> </table> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all'><o:p>&nbsp;</o:p></span></p> <!--Title--> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=650 style='width:487.5pt;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in' xmlns:fo="http://www.w3.org/1999/XSL/Format"> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'> <td style='padding:0in 0in 0in 0in'> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:.75pt'> <td width=180 style='width:135.0pt;padding:0in 0in 0in 0in;height:.75pt'><a name=resume></a></td> <span style='mso-bookmark:resume'></span> <td width=470 colspan=2 style='width:352.5pt;padding:0in 0in 0in 0in; height:.75pt'><span style='mso-bookmark:resume'></span></td> <span style='mso-bookmark:resume'></span> </tr> <tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes;height:13.5pt'> <td width=180 style='width:135.0pt;background:#E5ECF3;padding:0in 0in 0in 0in; height:13.5pt'> <p class=MsoNormal><span style='mso-bookmark:resume'><span class=boldtext1><span style='font-size:8.5pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'>RESUME</span></span></span><span style='mso-bookmark: resume'><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><o:p></o:p></span></span></p> </td> <span style='mso-bookmark:resume'></span> <td style='background:#E5ECF3;padding:0in 0in 0in 0in;height:13.5pt'> <p class=MsoNormal><span style='mso-bookmark:resume'><span style='font-size:8.5pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'>&nbsp;&nbsp;<o:p></o:p></span></span></p> </td> <span style='mso-bookmark:resume'></span> <td style='background:#E5ECF3;padding:0in 0in 0in 0in;height:13.5pt'><span style='mso-bookmark:resume'></span></td> <span style='mso-bookmark:resume'></span> </tr> </table> </td> </tr> <tr style='mso-yfti-irow:1;height:11.25pt'> <td style='padding:0in 0in 0in 0in;height:11.25pt'></td> </tr> <tr style='mso-yfti-irow:2'> <td colspan=2 style='padding:0in 0in 0in 5.25pt'> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td style='padding:0in 0in 0in 0in'> <p class=MsoNormal><span class=boldtext1><span style='font-size:8.5pt; font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman"'>Resume Headline: </span></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><ResumeTitle>Santosh Kumar<o:p></o:p></span></p> </ResumeTitle></td> <td style='padding:0in 0in 0in 0in'> <p class=MsoNormal align=right style='text-align:right'><span class=boldtext1><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Resume Value: </span></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'><ResumeValue>kfghb3xgkfjj2tms</ResumeValue>&nbsp;&nbsp;&nbsp;<o:p></o:p></span></p> </td> </tr> </table> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>&nbsp;&nbsp;<o:p></o:p></span></p> </td> </tr> <tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes;height:11.25pt'> <td style='border:none;border-top:solid #E5ECF3 1.0pt;mso-border-top-alt: solid #E5ECF3 .75pt;padding:0in 0in 0in 0in;height:11.25pt'></td> <td style='padding:0in 0in 0in 0in;height:11.25pt'></td> </tr> </table> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all'><o:p>&nbsp;</o:p></span></p> <!--Body--> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=650 style='width:487.5pt;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in' xmlns:fo="http://www.w3.org/1999/XSL/Format"> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td style='padding:0in 0in 0in 5.25pt'> <div> <div> <p align=center style='margin:0in;margin-bottom:.0001pt;text-align:center'> <meta http-equiv=Content-Style-Type content="text/css"> &nbsp;<span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse;mso-yfti-tbllook:1184;mso-padding-alt:0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:23.85pt'> <td width=667 valign=top style='width:6.95in;border:solid black 1.0pt; mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height:23.85pt'> <p align=center style='margin:0in;margin-bottom:.0001pt;text-align:center; orphans:0;widows:0'><a name="OLE_LINK2"></a><a name="OLE_LINK1"></a><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Santosh Kumar</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p align=center style='margin:0in;margin-bottom:.0001pt;text-align:center; orphans:0;widows:0'><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><a href="mailto:skumar.bigdata@hotmail.com"><span style='font-size:9.0pt; background:white'>skumar.bigdata@hotmail.com</span></a><o:p></o:p></span></p> <p align=center style='margin:0in;margin-bottom:.0001pt;text-align:center; orphans:0;widows:0'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>(415) 264 9262</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> </td> </tr> </table> <p style='margin:0in;margin-bottom:.0001pt;orphans:0;widows:0'><b><u><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></u></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;orphans:0;widows:0'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;orphans:0;widows:0'><b><u><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>SUMMARY: </span></u></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>14 years of total IT experience</span></b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'> in software analysis, design and development for various software applications in client-server environment with expertise in providing Business Intelligence solutions in <b>Data Warehousing</b> for Decision Support Systems and <b>SDLC</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Possessing over 11 years of practical hands on experience in DW and BI Reporting implementation<span style='color:black'>.</span></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Architect, Build and Sustain <b>Hadoop echo system environment, Map Reduce Jobs, Hive, Hbase, Pig and NoSQLs and MongoDB.</b></span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked on Multi clustered environment and setting up Big Data and Hadoop echo-system. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Set up and <b>configure Hadoop</b></span><b><span style='font-family:"Arial","sans-serif"'>&nbsp;</span></b><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>system </span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>on Amazon AWS for processing massive volumes of data.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; color:black'>Involved in Designing extraction process, Data Analysis,</span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'> Requirement study,<span style='color:black'> Data modeling, Performance tuning</span>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Expert in performance tuning methods, partitioning and pushdown optimization with large volumes of data load.</span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Provide leadership and best practices for installation, administration, backup &amp; recovery, <b>Unit test, release</b>, management, design features and functionality on BI Project. </span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Designed and developed <b>complex mapping logic</b> from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union and more.&nbsp; </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Experience in integration of various data sources with Multiple Relational Databases like Oracle, <b>SFDC, Teradata</b>, SQL Server, MS Access, DB2, and<b> XML System</b>. Used Teradata Utilities like <b>Fast Load, Multi Load and Fast Export</b>. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Maintaining Informatica Codes, Mappings, workflows, Parameters, creating and managing users, set up LDAP environment, troubleshooting and resolving issues. </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tuning.</span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Analyze business requirements and translate them into <b>functional and technical design specifications</b> and implementation plans. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Self-starter, result-oriented team player with an ability to manage multiple tasks simultaneously.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Proven strong analytical and logical skills with ability to follow project standards and procedures as per client specifications.</span><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:9.0pt; margin-bottom:.0001pt;text-align:justify'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <h1 style='margin:0in;margin-bottom:.0001pt;page-break-after:avoid'><u><span style='font-size:9.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'>Achievements: </span></u><span style='font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><o:p></o:p></span></h1> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Implemented Cloud Base echo-system HDFS, Pig, Hive, and Map Reduce on AWS.</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Excellent performance in the Data Extraction, Transformation and Load Processes using various tools including Informatica PowerCenter and achieved high level of customer satisfaction</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Implemented excellent DW/DM projects for Financial and Utilities sectors.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Parsed Unstructured and semi structured documents like multi tab excel sheets, XMLs documents by implementing Complex Data Transform using Informatica PowerCenter.</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Provided good documentation for the entire business processes to make better streamline process.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;orphans:0; widows:0'><b><u><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Core Skills </span></u></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Hadoop Distributions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Apache Hadoop, <b>Cloudera/CDH3, CDH4</b>, MapR and HortonWorks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Sub Projects &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <b>Hive, Hbase, Pig, Flume, Zookeeper, Avro, Sqoop, Hui</b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Linux Flavors &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ubuntu 12.04.02 LTS, CentOS-6.3, RedHat Linux 6 </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Monitoring tool&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <b>Ganglia</b>, Cloudera Manager, Apache Hadoop Web UI</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Automation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <b>Puppet</b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Reporting and Other&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OBIEE 10.1.x, Qlikview, Tableau, SAP Business Object</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Databases&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <b>Oracle </b>10g, <b>Teradata, DB2</b>, Vertica, Cassandra<b>, MongoDB, MySQL</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>ETL Tools&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Informatica Power Center 9.0.1, Data Quality </span><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Database Tools&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Oracle SQL*Plus, SQL<b>, </b>PL/SQL, Navigator, Toad 7.4, Teradata SQL<b> </b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Languages&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <b>SQL, UNIX Shell Script</b> (Bash, ksh), <b>Python</b> </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:1.5in; margin-bottom:.0001pt;text-indent:-1.5in'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <h1 style='margin:0in;margin-bottom:.0001pt;page-break-after:avoid'><u><span style='font-size:9.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'>Technical Certification and Education</span></u><span style='font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman"'><o:p></o:p></span></h1> <p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>B.S. (Mathematics):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pandit Ravi Shankar Shukla University, India</span><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>PGDCA (A Level):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; National Institute of Electronics and Information Technology (Formerly Known as DOEACC Society), New Delhi, India </span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>DCS (Computers):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; APTECH Computer Education, India.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>Certification-</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Oracle Certification in Oracle 9i SQL.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Informatica Certified Designer in Informatica Power Center 6.2.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Informatica Power Center 8.1 Trained Professional from Informatica Corporation.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><u><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>Project Experiences</span></u></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Client: Gilead Sciences &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Oct 11  Till Date&nbsp; </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Sr Software Consultant  ETL and BigData</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; color:black;letter-spacing:-.25pt'>Implementation Partner Systems wanted to get analytic information on Products, services and contracts. Typical reports need to generate from database like contract terms, service Contracts and forecast analysis. Work with massive amount of data to create next generation reporting and Analytics System and <b>implemented sustainable big data/ Hadoop environment.</b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>I am Responsible for  </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Architect, Build and <b>maintain sustainable Hadoop echo System</b> and sub projects such as HDFS, MapReduce, Hbase and pig for data store and reporting for the business requirements. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>As System Admin, worked on various sctivity along with analysis, design and enhancement of existing system. </span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Evaluate different ways to visualization data and store in best possible way to sustain HDFS environment.</span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Build Platform for <b>inmemory reporting system</b> to report hdfs and respective sub projects, </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked on Monitoring cluster, plan for backup-recovery and desaster Planing and other Administration activity. </span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Create, update and maintain project documents including&nbsp; business requirements, functional and non-functional requirements, functional design, Big Data etc.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Eliminated bottleneck in MapReduce Jobs&nbsp; <b>Processed Enterprise wide High Volume data</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Develope best practice methodology and documentation to support in different aspect of project.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Install, Configure and maintain Hadoop on Multi clustered environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'> and worked with MapReduce, Hbase, Hive, Pig and PigLatin, Flume, Zookeeper etc.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Install and maintain monitoring tools like Gangila Guide, mentor and develop others working on MapReduce and Hbase roles.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Creating different Applicate and Metrics to analyze data for business users like Service Attach metric, Multi year etc.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked as Point of contact for all BigData Implementations. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: <b>HDFS</b>, <b>Cloudera</b> <b>Hadoop Admin/CDH4,</b> Shell Script, Map Reduce, Hbase, Pig, Flume, Oozie, Puppet, Qlikview, and Tableau.</span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Client: Risk Management Solutions, Inc. Newark, CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; June 11  Oct 11 </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Lead Consultant  ETL and Hadoop Implementation</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; color:black;letter-spacing:-.25pt'>RMS is working to implement new system and interface for their product Risk Link. By being data efficient, fast as real life, open to the best, and in the cloud, customers will realize significant improvements in data management, automation and operating efficiencies so more time and resources can be engaged in creating risk intelligence and disseminating insight. This data is used by insurance and reinsurance industries do assess the damage and act accordingly.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>I was Responsible for -</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Started Cloud base service with AWS and HDFS, worked on Installation of Hadoop and different components(HDFS, Map Reduce, Pig, Hive, NoSQL DBs like MongoDB etc).</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Perform <b>Data analysis</b> and understand Business requirements. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Wrote Map Reduce Jobs and processed billions of records for analysis.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; color:#222222;letter-spacing:-.25pt;background:white'>Worked with large scale Hadoop environments build and support including design, performance tuning and monitoring.&nbsp;</span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'> </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Implemented <b>File validation and File management system</b> for Informatica to process. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Manage and Monitor Hadoop Distribution using Ganglia and Puppet ED.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Create, update and maintain project documents including business requirements, functional and non-functional requirements, functional design, data mapping, etc.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Identify opportunities for process optimization, process redesign and development of new&nbsp; process.</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: <b>Hadoop, Map Reduce, Pig, Hive, </b>HP Vertica Database<b>, Squirrel SQL</b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Client: PG&amp;E, San Ramon, CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Oct 10  June 11 </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Sr Informatica Consultant</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>With the onset of the new Market Redesign Technology Upgrade, the Front Office has determined a need to gather and analyze market data from various sources within CAISO and other PG&amp;E internal applications in support of least cost dispatch. In order to accomplish this task, we are working towards an aggregation of data from various resources to provide daily, weekly and quarterly analysis on the new Markets and PG&amp;E s Portfolio Optimization &amp; Trading strategies.&nbsp; The Project will be known as ETO (Energy Trading and Optimization).</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>I was Responsible for -</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Design and Development of ETL routines using Informatica Power Center and data flow management into multiple targets.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked on Information gathering from different sources within PGE for implementing ETO Project.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Participate in</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>BI</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>and Database product evaluations, <b>POC</b>'s and business decisions.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Analysed different source like <b>XML, Database, EXCEL</b> based existing system to extract and <b>aggregate</b> to new system and experience with</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Agile Methodology</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked as Informatica Administrator and performed Admin Activity e.g Install, Patch, creating environment.</span></b><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked in Initial implementation of <b>Informatica Power Center 9</b>, Shell Scripts and other tools.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Implemented file management systems for XMLs and Unstructured EXCEL Files.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Extracted data from XML system for <b>Master and Details record set</b> and extablished one to many relationship in database using Informatica while populating in database.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Contributed on doing the <b>technical documents</b> for dimenstions and Fact tables.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Wrote <b>Test Plan</b> and Script at high level, tested the build of Informatica, Scripts. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked on <b>Performance Improvement</b> and <b>tunned mapping, Session and Workflow</b> for better performances. </span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: Oracle 10g,<b> PL/SQL, Informatica Power Center 9.0.1</b>, Business Object reports, XML Source, Toad, Linux </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Client: HCL- Axon, Miami&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 10  Oct 10 </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Hadoop Consultant</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; color:black;letter-spacing:-.25pt'>HCL Axon was implementing project for all Caribbean island Telecommunication LIME legacy data to SAP System and do the Data warehouse implementation for reporting purpose. The Data is related to sales and marketing which needed to bring back in Data Warehouse thru ETL Process. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>I was Responsible for -</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Done an implementation of <b>ECTL process</b> for existing legacy system to move data.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial; letter-spacing:-.25pt'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Identify<span style='letter-spacing:-.25pt'> opportunities for </span><b>process optimization</b><span style='letter-spacing:-.25pt'>, process redesign and development of new&nbsp; process.</span></span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Leading BI Team and Design the Data model for Sales, and implemented shell Scripts.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; color:black;letter-spacing:-.25pt;background:white'>Evaluated tools and worked on POC for Big Data implementation on Hadoop environment setup</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:black; letter-spacing:-.25pt;background:white'>.&nbsp;</span><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; color:black;letter-spacing:-.25pt;background:white'>Worked on Map Reduce Jobs, Hive, Hbase, Pig and NoSQL- MongoDB.</span></b><a name="_GoBack"></a><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Designed the Star Schema, Physical and Logical Model. Also the Parameter tables and control tables.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Responsible for the design, development, testing and documentation of the Informatica mappings, Transformation and Workflows based on LIME standards.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Finally populating the data to datawarehouse in Oracle thru <b>Informatica PC 8.6</b>. Participated on End to end development and involved in decision making process, different meetings and conf calls.</span><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; letter-spacing:-.25pt'>Designed Mappings for Stage area and responsible to develop and analyze the requirement work out with the solution.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: Oracle 10g,<b> PL/SQL, Informatica Power Center 8.6.0</b>, <b>Hadoop, Hbase, Hive and Pig, NoSQL DBs</b> </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Client: Commercial BI Project, Genentech, Inc.&nbsp; SSF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Aug 09  Dec 09 </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Lead ETL Consultant</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; color:black;letter-spacing:-.25pt'>Genentech engages in research, development, manufacture, and marketing of biotechnology products for serious or life-threatening diseases. BI is responsible to manage the BI System database for Genentech customers, clients and Products. When fully Implemented the BI System (part of CIT Commercial Group) the business will be able to generate the reports based on ETL code and helps high level management on decision making.&nbsp; </span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>I was Responsible for -</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Design, develop and implemented <b>ECTL process</b> for existing tables in Oracle to move to DW. Performed data-orientred tasks on Master Data especially Patient, customers like standardizing, <b>cleansing, merging,</b> de-duping<b> </b>rules along with UAT in each state.</span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Responsible for the design, development, testing and documentation of the <b>Informatica mappings,</b> <b>Transformation</b> and Workflows based on Gene standards.&nbsp; </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial; letter-spacing:-.25pt'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Identify<span style='letter-spacing:-.25pt'> opportunities for </span><b>process optimization</b><span style='letter-spacing:-.25pt'>, process redesign and development of new&nbsp; process.</span></span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Initiate, define, manage implementation and enforce <b>data QA processes</b> across, Interact with other Team. Interacted with data quality team.&nbsp; Finally populating the data to datawarehouse in Oracle thru <b>Informatica PC 8.1</b>. Performance tunning in Informatica, Oracle SQL. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Used Informatica to <b>populate Oracle Table</b> from <b>Flat File</b> System BI System.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; letter-spacing:-.25pt'>Designed Mappings for Landing, CADS, CDM area and responsible to develop and analyze the requirement work out with the solution.&nbsp; <b>Tuning the SQL Queries</b>, Mapping and PL/SQL Blocks.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Done Incremental Load in Dimention tables and worked in highly normalised schema. Used Stage work and Dw table concept to load data, applied <b>Start Schema</b> concept. Used Informatica to do<b> </b>scheduling the workflow thru workflow manager.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: Oracle 9i<b>, PL/SQL, Informatica Power Center 8.1.6</b>, UNIX Shell Script, BO.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Client: Oracle Consulting Services, Costa Mesa, CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; Jan 09  Jul 09 </span></b><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Team Lead</span></b><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; color:black;letter-spacing:-.25pt'>Oracle Consulting Services is working to implement new system and interface for Auto Club. Automobile Club Enterprises wanted to migrate their Insurance payment system from Mainframe system to Oracle R12. This migration requires extracting payment details information GDG COBOL file and using Informatica to populate Oracle R12 Tables and distribute the file to internal system and corresponding bank. ETL Process will also record the errors and send the successful transmission back to the System for confirmation. A Complete implementation will enable the system to operate on Oracle R12 on go live and retire the mainframe system for Payments; feed the data warehouse system in Teradata.</span><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:blue; letter-spacing:-.25pt'> </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>I was Responsible for -</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Responsible for preparing the BRD, <b>technical specifications</b> from the business requirements and participated to <span style='letter-spacing:-.25pt'>develop ETL environment, processes, programs, and scripts to acquire data from source systems to populating to target system followed by feeding to data warehouse.</span></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Analysis of the Business and documenting it for development. Creating Tables and used Informatica to <b>populate Oracle Table</b> from Cobol GDG file System EBS System.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Mentored the team</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'> of 3 Informatica Developer and prepared them for development.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked in different tool in <b>OBIEE</b> like Admin Tool, Answers,Dashboards, <b>Pivot Tables</b> etc.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created <b>Physical and Logical Layer</b> extensively worked in different layers in OBIEE along with reports. Designing Start Schema Model. Extract and load DB2 tables for a customer.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Wrote Teradata BTEQ Scripts, Fast Load, Mload etc in order to support the project. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Performed Administrative talk as <b>Informatica Administrator</b> and participated on data-oriented tasks on Master Data projects especially members/Payment, like standardizing, <b>cleansing, merging, de-duping </b>rules along with UAT in each state.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Responsible for the design, development, testing and documentation of the <b>Informatica mappings,</b> <b>Reports</b> and Workflows based on AAA standards. Implemented DAC in this Project to schedule.</span><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: Oracle R12<b>, PL/SQL, Informatica Power Center 8.6</b>, Oracle EBS, <b>OBIEE</b>, Answers, Dashboard, DAC, DB2 Source and target, Cobol Copy Book.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>Client:&nbsp; Wells Fargo Bank, San Francisco, CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Apr  08  Dec 08 </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Sr ETL Consultant</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>The Problem of Obtaining customer and account information directly from mainframe operational systems, affects mainframe utilization, operational system performance, size of the mainframe environment and availability of mainframe.&nbsp; The objective of this project is to improve availability of key business data and processes by replicating the static or near static data from those SORs into a non-mainframe database. A successful implementation will reduce mainframe load and in the long run will save money by not having to constantly invest in increasing mainframe capacity including <b>best available quality of data</b> and controlling it and populate it to Data Warehouse database going forward.&nbsp; </span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>I was Responsible for - </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Provide technical guidance to programming team on overall methodology, practices, and procedures for support and development to ensure <b>understanding of standards, profiling and cleaning process</b> and methodology. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Interact with the team to facilitate development, provide data quality reports, and perform software migration activities and accumulated the data for B2B solution.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked in <b>Informatica 8.x </b>to create and deploy the business rules to polulate data into tables.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created Snapshots, Summary tables and views in Database to reduce the system overhead and provide best quality of data for report, worked on cash management and configuration of DAC.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Creation of presentation layer tables by dragging appropriate BMM layer logical columns in <b>OBIEE</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Developed Global prompts, Filters, Customized Reports and Dashboards</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Implemented Pivot Tables and manipulated Init Blocks for report analysis.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Perform data quality analysis, standardization</span></b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'> and validation, and develop data quality metrics.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Insuraing the data quality in Source and Target levels ot generate proper data report and profiling.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Provide <b>overall direction and guidance to ETL development</b> and support for the Prescription Solutions Data Mart. Applying <b>Velocity Best Practice</b> for the Project work.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created and used <b>reusable Mapplets </b>and transformations using <b>Informatica Power Center</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Responsible for the design, development, testing and documentation of the Informatica mapping,</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: Windows, UNIX, Informatica 8.x, Oracle 10g, SQL, UNIX Shell Script, <b>OBIEE, Answers, Admin tool</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:9.0pt; font-family:"Arial","sans-serif"'>Client: PayPal, San Jose, CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; July 07  Mar 08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Senior Data Warehouse ETL Developer</span></b><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial; letter-spacing:-.25pt'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>ECTL of Oracle tables to Teradata using Informatica and <b>Bteq Scripts</b>. Migrated SAS code to Teradata Bteq Scripts.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Predict current high value sellers who are likely to churn based on their similarities to past high value sellers. Identify dollar opportunity by reducing churn of high value sellers.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>I was Responsible for - </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Responsible for preparing the <b>technical specifications</b> from the business requirements.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"; letter-spacing:-.25pt'>Analyze the requirement work out with the solution. Develop and maintain the detailed project documentation.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Used Informatica and generated Flat file to load the data from Oracle to Teradata and <b>BTEQ/Fast Load Scripts</b> to do incremental load. Used Stage work and Dw table concept to load data, applied <b>Start Schema</b> concept. Created UDFs in <b>JAVA </b>Transformation to complete some tasks.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Design, develop and implemented <b>ECTL process</b> for Marketing Team for existing tables in Oracle. Wrote <b>BTEQ Scripts</b> in order to support the project. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Used version control system to manage code in different code streams like Clear case.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Performed data-oriented tasks on Master Data projects especially Customer/Party, like standardizing, <b>cleansing, merging, de-duping, determining </b>rules. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Responsible for the design, development, testing and documentation of the <b>Informatica mappings,</b> <b>PL/SQL, Transformation</b>, jobs based on Paypal standards.&nbsp; </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Initiate, define, manage implementation and enforce <b>DW data QA processes</b> across, Interact with other QA Team. Interacted with data quality team.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial; letter-spacing:-.25pt'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Identify<span style='letter-spacing:-.25pt'> opportunities for </span><b>process optimization</b><span style='letter-spacing:-.25pt'>, process redesign and development of new&nbsp; process.</span></span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Anticipate &amp; resolve data integration issues across applications and analyze data sources to <b>highlight data quality issues</b>. Did performance and analysis for Teradata Scripts.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Migrate SAS Code</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'> to Teradata <b>BTEQ Scripts</b> to do the scoreing for score taking in account various parameters like login details, transaction $ amount etc. Playing with <b>Marketing Data</b> for various reports.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: Oracle 9i<b>, Informatica PC 8.1</b>, PL/SQL, <b>Teradata V2R6</b>, Teradata SQL Assistant<b>, Fast load</b>, <b>BTEQ Script</b>, SAS Code, Clear case<b>, JAVA Language, Pearl Scripts, XML Source.</b></span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>Client:&nbsp; Charles Schwab, SLDM, Phoenix, CA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Oct 06  June 07</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Informatica and ETL Lead</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>The SchwabLink file delivery process is one of the cornerstone technology offerings of Schwab Institutional (SI). Effective portfolio management can not be performed without data. Financial advisors doing business with SI rely upon the SchwabLink file delivery process to obtain daily updates to customer, account, balance, position, and other important data required for portfolio management.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>The file delivery process harvests Schwab broker/dealer data for use in creating download files. In addition, data is received from external sources including U.S. Trust, The Charles Schwab Trust Company, The Charles Schwab Bank, and Great Western.&nbsp; In total, nearly 4G of data is received daily for processing and delivery of more the 68,000 individual files  with 79 different file formats  to advisors using the SchwabLink file download mechanism.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>I was Responsible for - </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Design Road map for ETL implementation and worked with ETL Team.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Developed reusable mappings and mapplets to acomplish similar business rules using various transformations. Configuring VSAM Files as source.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Designed the process of Parameter file generation from Informatica.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Used the <b>Shell Scripts</b> for running the Workflows and Normalised the process.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Checkin-Check-out of the mapping and locks checking. </span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created and used <b>reusable Mapplets </b>and transformations using <b>Informatica Power Center</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial; letter-spacing:-.25pt'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Responsible for the design, development, testing and documentation of the Informatica mapping, sessions and workflows based on Schwab standards and specifications.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created Scripts to populate <b>Teradata tables</b> and used BTEQ Scripts along with Teradata utilities.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Executed several sessions and created batches to automate the loading process.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Loaded the data from <b>VSAM</b> file to Oracle and also created flat files.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Generated the <b>XML Source/Target</b> for specific metadata requirements. </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: Oracle 10g, <b>Informatica PC 8.1.1</b>, Clear Case 7.0, Toad, COBOL Files, Teradata Source, Target.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>DBS Bank, Singapore&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Aug  05  Sep  06 </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Senior Data Warehouse Consultant </span></b><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>The Data Warehouse programme will enable the identification and realization of improvements in the areas of cross-selling &amp; market share growth, risk management, operational excellence and finance &amp; regulatory reporting by defining and building the Enterprise Data Warehouse providing accurate, consistent, timely and shared customer centric information for Singapore and Hong Kong.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>This project is about the business s requirement for consolidated, timely, standardized and cleansed data, globally available on a timely basis to ultimately answer business questions for identifying and realizing improvements across the business lines and geographies. It is an  enterprise-wide initiative that addresses the lack of quality and timely customer information, the need to merge more and more data from currently separate sources and to establish standards for wide range of information used within the bank.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>I was Responsible for - </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Working as <b>Team lead</b> Involved in the development Team for setting the standards for Informatica developers in project.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Communicate with immediate supervisor on the status of the work in-progress, both verbal and written communications. </span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>To Support whole systems, TWS daily run and Daily Backup for whole systems.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Responsible for designing the ETL source map and transformation logic.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Developed Teradata script for<b> FastLoad, MultiLoad, FastExport scripts</b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created DSNs and Database connections to support <b>Informatica Architecture.</b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Involved in working with various<b> active and passive transformations</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created workflows and sessions</span></b><span style='font-size:9.0pt;font-family: "Arial","sans-serif"'> to perform data loading.</span><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Designed Test-Cases and validation scripts to test the loaded data.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Tuned the mapping, data flow and session property sheet to <b>optimize the performance. </b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked in <b>Star schema </b>and<b> Snowflake schema</b> design.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Written Shell Scripts to run Informatica Workflows and Backup.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: Windows, IBM AIX, <b>Teradata V2R5, Informatica PC 7.1.2</b> (Designer, Repository Manager, Workflow Manager, Monitor), Tivoli Workload Scheduler, <b>Teradata Utilities like Fast Load, Multi Load</b>, Fast Export, SQL.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Hewlett-Packard, Malaysia, Singapore&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; May 04  Jul 05</span></b><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Team Lead /SME </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Description: </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>To create a tiered Data Warehouse Architecture based on the requirements.&nbsp; Data from various data sources will be consolidated into different business subject areas within the Data Warehouse layer. This will ensure semantic integrity for common attributes across different data marts and eliminate redundancy in data extraction, transformation and consolidation.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>I was Responsible for - </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Designed the tables and created the mappings to populate data.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Used control table and Parameter files to run the mappings </span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Written<b> shell scripts</b> in order to take <b>repository backup and run workflows</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Implemented complex mappings</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'> using expressions, aggregators, filters, joiner, rank, union, sequence generator and procedures. Populated <b>Teradata Tables</b> for DW Implementations.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Developed and tested <b>ETL procedures</b> to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures. </span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created<b> Parameter Files</b> and also done the <b>version control thru Clear Case.</b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Improved performance by identifying the <b>bottlenecks in Source, Target, Mapping and Session levels</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Used Bteq Scripts</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>. Implemented the Change requests, Involved in testing the mappings/Documents.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment:</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'> <b>Informatica PC 6.2</b>, Oracle 8i/9i, Cognos Report Studio, Toad, SQL&nbsp;&nbsp; Informatica Repository Manager, Designer, Unix Shell Script, Windows 2000/NT,<span style='letter-spacing:-.25pt'> <b>Teradata V2R1</b> , Rational Rose Clear Case.</span></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif";letter-spacing:-.25pt'>GE Medical Systems,Bangalore, India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; May  03 - Apr  04</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>ETL Consultant</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Description:</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>The Customer wanted to integrate their Data from all origin, which is Legacy and Oracle. After the Integration, we apply business logics and use the Informatica sessions to pull the data to Target system and this data can be used to generate Cognos Cubes and Reports.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>I was Responsible for - </span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Done Various Loads like<b> Daily, Weekly and Monthly Load </b>based upon the request.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Automated the Process of Extraction for some Origin.</span><span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Developed various Mappings to implement business logic.</span><span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Used the <b>Shell Scripts</b> for running the session.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Used Update strategy and Target load plans to load data into Type-2 Dimensions.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created and used <b>reusable Mapplets a</b>nd transformations using Informatica Power Center.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Created Snapshots, Summary tables and materialized views in Database to reduce the system overhead.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Design and Development of ETL routines, using Informatica Power Center Within the <b>Informatica Mappings, usage of Lookups, Aggregator, Ranking, Stored procedures / functions, SQL overrides usage in Lookups and source filter </b>usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.</span><span style='font-size:8.5pt;font-family: "Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Executed several sessions and created batches to automate the loading process.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Involved in testing the developed mappings and created the test cases.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:27.0pt; margin-bottom:.0001pt;text-align:justify;text-indent:-.25in;line-height:11.0pt'><span style='font-size:9.0pt;font-family:Symbol;mso-bidi-font-family:Arial'>·</span><span style='font-size:7.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Loaded the data from .CSV file to <b>Oracle and Teradata</b>.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;text-align:justify;line-height: 11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Environment</span></b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>: <b>Informatica Power Center 6.2,</b> Oracle 8i, Shell Scripts, <b>Teradata, Teradata Utilities</b> like Fast Load, Multi Load, Fast Export, SQL.</span><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>&nbsp;</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt;line-height:11.0pt'><b><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Worked with different companies as Developer and Consultant  Jan 99 thru Apr 03.</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'>3<span style='font-size:8.5pt; font-family:"Arial","sans-serif"'><o:p></o:p></span></p> <p style='margin:0in;margin-bottom:.0001pt'>&nbsp;<span style='font-size: 8.5pt;font-family:"Arial","sans-serif"'><o:p></o:p></span></p> </div> </div> </td> </tr> </table> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><br style='mso-special-character: line-break' xmlns:fo="http://www.w3.org/1999/XSL/Format"> <![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'> <![endif]><o:p></o:p></span></p> <!--ExperienceTableView--><!--EducationTableView--><!--SkillsTableView--><!--Summary Section--> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=650 style='width:487.5pt;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in' xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:m="http://schemas.monster.com/Monster"> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:15.0pt'> <td width="100%" style='width:100.0%;padding:0in 0in 0in 0in;height:15.0pt'></td> </tr> <tr style='mso-yfti-irow:1'> <td style='background:#E5ECF3;padding:0in 0in 0in 0in'> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:13.5pt'> <td width=180 style='width:135.0pt;padding:0in 0in 0in 0in;height:13.5pt'> <p class=MsoNormal><a name=summary><span class=boldtext1><span style='font-size:8.5pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'>Additional Info</span></span></a><span style='mso-bookmark: summary'><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><o:p></o:p></span></span></p> </td> <span style='mso-bookmark:summary'></span> <td style='padding:0in 0in 0in 0in;height:13.5pt'> <p class=MsoNormal align=right style='text-align:right'><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'><a href="#top" alt="BACK TO TOP"><span style='color: #0066CC'>BACK TO TOP</span></a><o:p></o:p></span></b></p> </td> </tr> </table> </td> </tr> <tr style='mso-yfti-irow:2;height:11.25pt'> <td style='padding:0in 0in 0in 0in;height:11.25pt'></td> </tr> <tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes'> <td style='padding:0in 0in 0in 0in'> <div align=center> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:337.5pt'> <td style='padding:0in 0in 0in 0in'></td> <td style='mso-cell-special:placeholder;border:none;padding:0in 0in 0in 0in' width=450><p class='MsoNormal'>&nbsp;</td> </tr> <tr style='mso-yfti-irow:1'> <td width=160 valign=top style='width:120.0pt;padding:0in 0in 0in 5.25pt'> <p class=MsoNormal><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Current Career Level:<o:p></o:p></span></b></p> </td> <td width=450 valign=top style='width:337.5pt;padding:0in 0in 0in 0in'> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Experienced (Non-Manager)<o:p></o:p></span></p> </td> </tr> <tr style='mso-yfti-irow:2;height:3.75pt'> <td style='padding:0in 0in 0in 0in;height:3.75pt'></td> <td style='padding:0in 0in 0in 0in;height:3.75pt'></td> </tr> <tr style='mso-yfti-irow:3'> <td style='padding:0in 0in 0in 0in'><!--WorkStatus--></td> <td style='padding:0in 0in 0in 0in'></td> </tr> <tr style='mso-yfti-irow:4'> <td width=160 valign=top style='width:120.0pt;padding:0in 0in 0in 5.25pt'> <p class=MsoNormal><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Work Status:<o:p></o:p></span></b></p> </td> <td width=450 valign=top style='width:337.5pt;padding:0in 0in 0in 0in'><Country MessageID="42174"> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>US</Country> - <Status MessageID="70382">I require sponsorship to work in this country.<o:p></o:p></span></p> </Status></td> </tr> <tr style='mso-yfti-irow:5;height:7.5pt'> <td style='padding:0in 0in 0in 0in;height:7.5pt'></td> <td style='padding:0in 0in 0in 0in;height:7.5pt'></td> </tr> <tr style='mso-yfti-irow:6'> <td style='padding:0in 0in 0in 0in'></td> <td style='padding:0in 0in 0in 0in'></td> </tr> <tr style='mso-yfti-irow:7'> <td width=160 valign=top style='width:120.0pt;padding:0in 0in 0in 5.25pt'></td> <td width=450 valign=top style='width:337.5pt;padding:0in 0in 0in 0in'></td> </tr> <tr style='mso-yfti-irow:8;mso-yfti-lastrow:yes;height:7.5pt'> <td style='padding:0in 0in 0in 0in;height:7.5pt'></td> <td style='padding:0in 0in 0in 0in;height:7.5pt'></td> </tr> </table> </div> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:8.5pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman";display:none;mso-hide:all'><o:p>&nbsp;</o:p></span></p> <div align=center> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in'> <!--Placeholder to prevent single table tag for both closing and opening, which does not render correctly in browser--> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'> <td style='padding:0in 0in 0in 0in'><!--TargetJob--> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook: 1184;mso-padding-alt:1.5pt 1.5pt 1.5pt 1.5pt'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'> <td style='padding:1.5pt 1.5pt 1.5pt 1.5pt'></td> </tr> </table> </td> </tr> <tr style='mso-yfti-irow:1;height:7.5pt'> <td style='padding:0in 0in 0in 0in;height:7.5pt'></td> </tr> <tr style='mso-yfti-irow:2'> <td style='padding:0in 0in 0in 0in'><!--TargetCompany--> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook: 1184;mso-padding-alt:1.5pt 1.5pt 1.5pt 1.5pt'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right: 337.5pt'> <td style='padding:1.5pt 1.5pt 1.5pt 1.5pt'></td> <td style='mso-cell-special:placeholder;border:none;padding:0in 0in 0in 0in' width=450 colspan=2><p class='MsoNormal'>&nbsp;</td> </tr> <tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'> <td width=160 valign=top style='width:120.0pt;padding:1.5pt 1.5pt 1.5pt 5.25pt'> <p class=MsoNormal><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Target Company:<o:p></o:p></span></b></p> </td> <td width=270 valign=top style='width:202.5pt;padding:1.5pt 1.5pt 1.5pt 1.5pt'> <p class=MsoNormal><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Company Size:</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'><o:p></o:p></span></p> </td> <td width=180 valign=top style='width:135.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt'><CompanySize MessageID="-1" /></td> </tr> </table> </td> </tr> <tr style='mso-yfti-irow:3;height:7.5pt'> <td style='padding:0in 0in 0in 0in;height:7.5pt'></td> </tr> <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'> <td style='padding:0in 0in 0in 0in'><!--Locations--> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%" style='width:100.0%;mso-cellspacing:0in;mso-yfti-tbllook: 1184;mso-padding-alt:1.5pt 1.5pt 1.5pt 1.5pt'> <!--Placeholder to prevent single table tag for both closing and opening, which does not render correctly in browser--> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right: 337.5pt'> <td style='padding:1.5pt 1.5pt 1.5pt 1.5pt'></td> <td style='mso-cell-special:placeholder;border:none;padding:0in 0in 0in 0in' width=450 colspan=2><p class='MsoNormal'>&nbsp;</td> </tr> <tr style='mso-yfti-irow:1'> <td width=160 valign=top style='width:120.0pt;padding:1.5pt 1.5pt 1.5pt 5.25pt'> <p class=MsoNormal><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Target Locations:<o:p></o:p></span></b></p> </td> <td width=270 valign=top style='width:202.5pt;padding:1.5pt 1.5pt 1.5pt 1.5pt'> <p class=MsoNormal><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>Selected Locations:</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'><o:p></o:p></span></p> </td> <td width=180 valign=top style='width:135.0pt;padding:1.5pt 1.5pt 1.5pt 1.5pt'> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'>US-CA-Oakland/East Bay<o:p></o:p></span></p> </td> </tr> <tr style='mso-yfti-irow:2;mso-yfti-lastrow:yes;height:11.25pt'> <td style='padding:1.5pt 1.5pt 1.5pt 1.5pt;height:11.25pt'></td> <td style='padding:1.5pt 1.5pt 1.5pt 1.5pt;height:11.25pt'></td> <td style='padding:1.5pt 1.5pt 1.5pt 1.5pt;height:11.25pt'></td> </tr> </table> </td> </tr> </table> </div> </td> </tr> </table> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all'><o:p>&nbsp;</o:p></span></p> <!--Language--><!--Reference--><!--CustomFields--><!--ResumeNotes--><!--UploadedDocComment--> <table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=650 style='width:487.5pt;mso-cellspacing:0in;mso-yfti-tbllook:1184;mso-padding-alt: 0in 0in 0in 0in' xmlns:fo="http://www.w3.org/1999/XSL/Format"> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'> <td style='padding:0in 0in 0in 0in'> <div class=MsoNormal align=center style='text-align:center'><span style='font-size:8.5pt;font-family:"Arial","sans-serif";mso-fareast-font-family: "Times New Roman"'> <hr size=1 width="100%" align=center> </span></div> </td> </tr> <tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'> <td style='padding:0in 0in 0in 0in'></td> </tr> </table> <p class=MsoNormal><span style='font-size:8.5pt;font-family:"Arial","sans-serif"; mso-fareast-font-family:"Times New Roman"'><o:p>&nbsp;</o:p></span></p> </div> </body> </html>