summary jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom information data management professional 6 years experience within business data analysis data migration system integration capability analysis experience spanned across projects clientele healthcare banking clients investment management companies skills ibm infosphere datastage 87 designer director oracle 11g9i unix putty ms access ms word ms power point experience data stage developer cognizant technology solutions honolulu hi 112016 current use sql profile data provide data sheets based work requests executed datastage jobs made sure proper files generated cognos also made sure verify database loaded correctly new data used datastage designer create table definitions csv sequential files import table definitions repository import export projects release package jobs created etl processes extract data landing oracle database transformed data based business requirement load proper database table executed sequence jobs restart ability check points implemented proper failure designed developed parallel jobs using datastage designer per mapping specifications using appropriate stages used datastage director runtime engine schedule running solution testing debugging components monitoring resulting executable versions worked troubleshooting performance tuning performance monitoring enhancement datastage jobs performed unit testing system integration testing development uat environments used cognos tool verify files generated accurately daca stage developer cognizant technology solutions horicon wi 092015 112016 recognized business needs evaluated business technical alternatives suggested solutions took part implementation imported metadata repository created new job categories used datastage designer create table definitions csv sequential files import table definitions repository import export projects release package jobs created etl processes extract source data db2 enterprise database developed job sequences execute set jobs restart ability check points implemented proper failure actions used datastage director runtime engine schedule running solution testing debugging components monitoring resulting executable versions worked troubleshooting performance tuning performance monitoring enhancement datastage jobs wrote several complex sql queries test etl process worked control setting production job cycles daily weekly monthly loads proper dependencies designed developed parallel jobs using datastage designer per mapping specifications using appropriate stages daca integration developer investcloud warren twp nj 052012 092015 recognized business needs evaluated business technical alternatives suggested solutions took part implementation perform data cleansing activities based writing sql patches investigating etl jobs address data gaps imported metadata repository created new job categories routines data elements using datastage manager used datastage designer create table definitions csv sequential files import table definitions repository import export projects release package jobs created etl processes extract source data healthcare company database load enterprisewide data warehouse cleansing transforming integrating used quality stage coordinate delivery consistency removing data anomalies spelling errors source information designed developed parallel jobs using datastage designer per mapping specifications using appropriate stages developed job sequences execute set jobs restart ability check points implemented proper failure actions used datastage director runtime engine schedule running solution testing debugging components monitoring resulting executable versions worked troubleshooting performance tuning performance monitoring enhancement datastage jobs worked autosys setting production job cycles daily weekly monthly loads proper dependencies performed unit testing system integration testing development uat environments wrote several complex sql queries test etl process eto developer cognizant technology solutions hunt valley md 092011 042012 worked etl datastage consultant project design production support reviewed validated existing job code designed developed new jobs future releases worked offshore developers coordinate etl work requirements reviewed code developed offshore worked parallel project datastage upgrade version 75 version 81 developed unix scripts run datastage job file validations performance tuning datastage jobs sql used inside job education training activities honors bachelors computer science university karachi sindh computer science 37 jan 2011