Lulla Amit - Resume updated
Download as docx, pdf1 like289 views
- Amit Lulla has over 7 years of experience working with data warehousing, ETL tools like Abinitio, UNIX/SQL, data analysis, defect analysis, and extraction. He has worked on projects in banking, insurance, and other industries. - He is experienced in working as an Abinitio lead and expert, data analyst, and business requirements analyst. He is proficient in Abinitio, Oracle, DB2, UNIX, and other technologies. - His experience includes development of data warehouses and data marts, ETL development, performance tuning, testing, release management, and ensuring timely deliverables. He has worked with various organizations like SunTrust Bank, Citi Bank, AIG
Lulla Amit - Resume updated
- 1. AMIT LULLA lullaamit9@gmail.com 201-218-5543 SUMMARY ? 7 yearsof IT experience workingin DataWarehousing,ETL tool Abinitio,UNIX/SQL, Data Analysis/documentation,DefectAnalysis, Extraction. ? Trained on Abinitio(basicand advancedconcepts including Conduct>IT) by AbinitioCorp. ? Trained on AbinitioACE template (Express>IT) by AbinitioSoftware Lab, MA. ? Experiencedworkingas Abinitiolead. ? Experiencedworkingas Data analyst. ? Experiencedworkingas businessrequirementanalyst. ? Workedon variousAbinitiocomponents; reformat,sort,rollup,dedupsort, normalize,lookups, input table,output table,input file,outputfile,partitioncomponents,subscribe,publish,batch subscribe,etc. ? Well versedwithvarious Abinitioparallelismtechniques andworkedonAbInitioGraphsusing Data parallelismandMulti File System(MFS) techniques. Experience workingwithAbinitio ContinuousGraphs. ? Extensive knowledgeinEME, checkins,checkouts,commandline interface,aircommands. ? Hands onexperienceindevelopmentof DataWarehouses/DataMartsusingAb InitioCo>OP, GDE, ComponentLibrary,Oracle andUNIX formainlyBanking/Financial/CreditCardindustries. ? Experience in DataWarehousingconcepts;Dimensional Modeling/Kimball Methodology,Star Schema, Snowflake Schema.Workedon EBX DataBase tool. ? ExperiencedininteractingwithEMEData store withseveral aircommands. ? Integrationof variousdatasourcessuchas flatfiles,ASCII,EBCDIC files,XMLfiles,DB tables etc. ? Experiencedinworkingwith Mainframe DataFiles,COBOL Copybook,UNIX shell wrapper scripts. ? Experiencedon Service Now/ChangeRequestenvironmentsforrelease managementandstream liningprocesses. ? Experiencedon HPQC. ? Experience in all stagesof Software DevelopmentLife Cycle(SDLC) processes andespecially workedonrequirementanalysis,designing,development,testing,co-ordination,release management,supportingapplication,systemconfigurationsandend-to-enddeliverables. ? Experience of workingwith tier1 financial institutionsandmost critical applications,withteam of 25-30 members. TECHNICAL SKILLS Skills : ETL Ab InitioGDE 1.15, Co>p 2.15, GDE 3.0.4.1, Co>p 3.0.3.9, ACE template,EBX Tool,HP QC, Service Now. Languages : Unix-shell scripting,Mainframe(JCLversion),C,C++. Databases : Oracle SQL, DB2, Microsoftsql server. OperatingSystem : Windows(2007 and XP) Domain : Banking,Insurance
- 2. PROFESSIONAL EXPERIENCE SunTrust Bank, Atlanta GA Mar 2016 to Current Role: ETL/AbinitioExpert / Lead Projects:1. CCAR-Risk-Management 2. MDM refresh ? Workingsas Abinitiolead andhandsondeveloper. ? Workingas Data analystexpertandBusinessrequirementanalyst. ? Workingon onsite andoffshore teammodel. ? Coordinatingwithdifferentteamstoensure timelydeliverables. ? Clientinteraction. ? Preformedall code Check-inandCheck- outoperationswithEME. ? Involvedindecreasingapplicationruntimessignificantlybyusingperformance tuning. ? DefectAnalysis. ? Insuringsuccessful andtimelydeliverables. Environment: Ab InitioGDEversion3.2.5.2 , UNIX LINUX,Oracle 11G, AutosysScheduler. CITI Bank, NJ July 2014 to Feb 2016 Role: ETL/AbinitioExpert Project: CitiKYC(Stage1) and Genesis CitiKYC(KnowYourCustomer) systemisone of the majorAML applicationsinCiti. Itisthe processof a businessverifyingthe identityof itsclients,theirprobityandintegrity. ? Work as Abinitio leadonStage1,Purge processdevelopment,Deletetool development, BOAI report Migration processfrom SQL to Abinitio. ? Investigatingissueswiththe dataandworkingwithsource teams. ? Coordinatingwithdifferentteamstoensure timelydeliverables. ? Clientinteraction. ? Involvedinmajorpartof testingthe code anddebuggingthe issues. ? Preformedall code Check-inandCheck- outoperationswithEME. ? Developedgenericgraphsusingpsetstominimizedevelopmentandmaintenance costs. ? Involvedindecreasingapplicationruntimessignificantlybyusingperformance tuning. ? Release Management. ? DefectAnalysis. ? Supportingapplicationand workingcloselywithQA teams. ? Insuringsuccessful andtimelydeliverables. ? Workedon AbinitioACE CDA (CommonData Acquisition) frame work in Genesis - mainly includingcreationof configurationpsetsforACECDA frameworktemplates. Environment: Ab InitioGDE3.1.5.5, Co>p 2.15, ACE Framework,UNIX AIX,Oracle 11G, HP QC, Service Now, AutosysScheduler. AIG,NJ DEC 2012 to JUNE 2014 Role: ETL/AbinitioExpert
- 3. Project: Chartis FusionOperations To handle claimssubmittedbythe claimants,the Companiesenlistthe servicesof thirdparty administrators(¡°TPA(s)¡±).The TPA validates,processes,andpaysthe claimantsonbehalf of the Companies.The TPA thensendsthe claimstothe Companiesforbilling,booking,reimbursementand reporting.The claimdatafrom all TPAsare validatedfordataqualityandpopulatedinthe ThirdParty AdministratorInformationRepository(¡°TPAIR¡±) database bythe coverage validationprocess.The TPAIR applicationandassociatedbusinessprocessesapportionthe lossestolayersandassignthe responsible party,for each layer,whichcouldbe eitherthe insuredorAIGVendorServices(¡°AIGVS¡±) orthe Fusion group,whichisthe unitthat runsthisline of business.The TPAIRapplicationthenbillsthe insuredand AIGVSfortheirrespective lossesandbooksthe lossestothe Corporate ReportingSystem(¡°CRS¡±). ? Workedas Abinitio leadanddeveloper. ? Involvedindocumentation. ? Workedmostlyonverycritical adhoc requirements. ? Experiencedworkinginhighlycompetitive environment. ? Workedon performance improvementof variousprocesses. ? Involvedinmajorpartof testingthe code anddebuggingthe issues. ? Involvedindecreasingapplicationruntimessignificantly byusingperformance tuning. ? Assignedphasesandsetupcheckpointstocomplex graphshavinglarge numberof components to protectagainstfailure,avoiddeadlockandeasyrecoveryof failedgraphs. ? InteractedwithDB2 and MicrosoftSQL serverdatabases. ? DevelopedUNIXshell scripts. ? Release Management. ? DefectAnalysis. ? SupportingapplicationandworkingcloselywithQA teams. ? Insuringsuccessful andtimelydeliverables. ? Responsible forthe overall qualityandtimelinessof the deliverables. Environment: Ab InitioGDE3.0.4.1, Co>p 3.0.3.9, UNIXAIX,DB2, MicrosoftSQL server.,HPQC, Service Now,Autosys. BARCLAYS Bank APR 2011 to NOV 2012 Role: ETL/AbinitioDeveloper Project: PSD (Paymentservice directives) Phase 3 The Financial ServicesAuthority(FSA) mandatedthatBarclaycardconformtothe PaymentServices Directive regulationsforAvailabilityof Funds ? WorkedextensivelyonAbinitiodevelopment andleadingateamof juniordevelopers. ? Createddesigndocuments. ? Involvedinthe developmentof tier1 and mostcritical applicationof Barclaysbank. ? Workedwithteamsize of around15 Abinitiodevelopersanddevelopedmore than80 graphs. ? Involvedinmajorpartof testingthe code anddebuggingthe issues. ? Preformedall code Check-inandCheck- outoperationswithEME. ? Developedgenericgraphsusingpsetstominimizedevelopmentandmaintenance costs. ? Involvedindecreasingapplicationruntimessignificantlybyusingperformance tuning. ? Assignedphasesandsetupcheckpointstocomplex graphshavinglarge numberof components to protectagainstfailure,avoiddeadlockandeasyrecoveryof failedgraphs. ? InteractedwithMainframe filesystemandORACLEdatabase. ? Good exposure withMainframeEBCDIC formatfilestohandle withAbinitio.
- 4. ? Createdtestcasesfor variousscenariosforunittesting. ? Developedaprocessto execute graphs/scriptsinserial orparallelmode withfullrestart. ? Thisprocesswas usedto execute productionjobsonhourly/daily/Weeklyschedules. ? Release Management. ? DefectAnalysis. ? SupportingapplicationandworkingcloselywithQA teams. ? Insuringsuccessful andtimelydeliverables. Environment:Ab InitioGDE 3.0.4.1, Co>p 3.0.3.9, UNIX AIX,Mainframe, Oracle 11G, HP QC, Service Now, Control M, Autosys. Citi Bank, India OCT 2009 to MAR 2011 Role: ETL/AbinitioDeveloper Projects:Workedon various applicationsinGIW(Global InformationWarehouse) AUC Reporting SFS AssetUnderCustody(AUC) phase 1 isone of mainlyiterativeprojectstobuildacoordinatedand highlyintuitive solutionthataddressesdataintegrationthroughsourcingfromadata warehouse and anticipatesfuture growthbothindataand depthof analyticcapability. Mapping ExceptionsReporting Effortto detectand notifythe productteamof the changeswithinthe accountlevel reference attributes withinthe productprocessorsystems.The productprocessorwouldaddanew value tothe reference information.Since,the newreferenceinformationwill notbe presentinthe inthe currentset of valid values,the changeswouldnotbe reflectedinthe reports.These Exceptionsneedtobe detectedand reportedsothat corrective actioncouldbe takento rectifythe reportinginformation. NP Accounts AdjustmentsUK Notional Poolsare cashmanagementstructuresthatcontaina HeaderAccountwithone or more sub- accounts associatedwithit.HeaderAccountrepresentsa¡®notional¡¯or¡®adjusted¡¯balance positionthat equalsthe balance netof itsownphysical balance andall sub-accountbalances,whilethe sub-accounts representnotionalzero-balance positions.Notionalpoolingproductprocessorsimulatesthe movement of fundsforinterestcalculationpurposesbutthere are noactual debit/creditentriesmade tothe accounts themselves. Industry SegmentsUpdate Intendedtoalignthe ¡®datasegregation¡¯and¡®reportcuts¡¯toCiti¡¯smanagementorganization. The benefitof thisexerciseisthatthe sectorsheadsandmanagerswill be able toproduce deposit reportswiththe cuts and aggregationtheyrequire managingtheirbusiness. ? Workedas Abinitiodeveloperandinvolvedindocumentation. ? DevelopedvariousAbinitiographs ? Involvedinmajorpartof testingthe code anddebuggingthe issues. ? Preformedall code Check-inandCheck- outoperationswithEME. ? Involvedindecreasingapplicationruntimessignificantlybyusingperformance tuning. ? Assignedphasesandsetupcheckpointstocomplex graphshavinglarge numberof components to protectagainstfailure,avoiddeadlockandeasyrecoveryof failedgraphs. ? Interacted withORACLEdatabase. ? DevelopedUNIXshell scripts. ? Responsible forthe overall qualityandtimelinessof the deliverables. ? Createdtestcasesfor variousscenariosforunittesting.
- 5. ? Release Management. ? DefectAnalysis. ? SupportingapplicationandworkingcloselywithQA teams. ? Insuringsuccessful andtimelydeliverables. Environment:AbinitioGDE1.15, Co>p 2.15, Unix AIX,Oracle 11G, Autosys,HPQC, Service Now EDUCATION Electronicsand Telecommunication Engineering,2009 Mumbai University,India INTERESTS: Art, Philosophy,Painting, Reading, Writing,Meditation, Yoga, philanthropy (supportingChild education),Cooking