jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom profile highly motivated sales associate extensive customer service sales experience outgoing sales professional track record driving increased sales improving buying experience elevating company profile target market core qualifications expertise full project life cycle development implementation integration motivational coordination skills ability deliver systems schedule analyze drill data marts information mining change management process data quality experienced requirement analysis test design test preparation test execution defect management management reporting experienced developing data mapping performance tuning identifying bottlenecks sources mappings targets sessions experienced development etl mapping scripts understand debug etl jobs transforming data remove duplicates experienced batch systems scheduling processing jad sessions determine requirements purchase order requisition conceptual model experience large enterprise data warehouse olap architecture design including logical physical model development data models enterprise data models expertise extracting transforming large datasets experience etl tools like ibm infosphere data stage ssis experienced working offshore vendors establishing offshore teams processes demonstrated experience database technologies eg oracle ms sql server sybase mysql move data oracle sybase using sybase gateway experience hybrid cloud platforms oracle vm server handson experience production reporting bi platforms setup oracle rac clusters production nonproduction environment technical skills oracle 10g 11g 12c oracle rac mssql server 2012 sybase ase 125 ibm infosphere professional experience 121993 121994 lead datadatabase architect worked collaboratively team members using microsoft lync webex ledcoordinated meetings multiple time zones onoffshore team members provided findings questions business analysts verification provided metadata allowed values defaults constraints domain inconsistencies data layouts flat files etc reference data modeling etl team worked txbase erp software inventory systems factory worked shop floor understanding movement items bins factory floor understand identify data relationship inventory items automating issuesreceipts using scanner software design creation models maintaining product receivables issues generation reports stock ledger use purchase department ordering new items schedule quotations bill materials items building large database sybase system 10 inventory materials generation purchase orders quotations design creation tables process change management impact analysis data 111988 121993 sr programmersystems analyst jad sessions determine requirements purchase order requisition conceptual model designed logical physical data models analyzed source data determine metadata included logical data model performed data mapping determine identified source data belonged data base created forward engineered sql case tool loaded build maintain data base used transact sql load data sybasemssql server load source data data base designed tables bank reconciliation system purchase order requisition system identified attributes entities converted physical tables different account heads related company purchase order requisition system towards identifying customers supplier rates deviation scheduled delivery dates designed tables related generation maxmin levels inventory hand production reports cost total stock hand installation audit trail system changes made report management datetime change enforce data integrity using primary key foreign key composite key identifying indexes tables optimum data retrieval residency status united sates citizen senior data technical solutions architect responsibilities aig provide production support various oraclesybasemicrosoft database environments across enterprise developed dumprestore scripts sybase rman backup scripts hotcold backup datapump scripts oracle setup automated alerts disk space monitoring database server uptime monitoring thru ca pronet oraclesybase security patch updates database home available scheduled change tickets autosys job scheduler scheduling jobs viz backupdumpdatapump database upgrade newer versions order maintain support software vendor work application teams upgrade schedule setup test serversdatabase upgrade testing written security stored procedures required compliance password security server query application performance tuning deterioration query performance reverse engineer physical database logical models needed using powerdesignerembarcaderoerwin needed identifying tabledata relationship schedule time unix engineers san migrate datafilesdatabases storage database needs migrated new host education training ibm datastageparallel extender infosphere datastage training ldom rac inmemory database oracle university project management training towards certification masters administrative management mumbai university accomplishments coordinated ibms warehouse migration solaris aix enterprise datawarehouse dba edw reinsurance databases datawarehouse administration 7tb 10tb experience building scalable data warehouse olap database database data migration different technologies proof concept oracle ldom architecture towards migration services compliance tools testing poc imperva database compliance sqlserver database migration sqlserver 2014 logical physical data modeling erwin performance appraisal design project include logical physical database design covering database objects schema tables stored procedures views triggers defaults setting metric numbers performance parameters reverse engineer databases sybaseoracle e r diagrams interaction data architects estimation table size database size reduce spacecpu utilization creation maintenance databases test model uat production environments maintenance fact tables reorg large tables identifying additional partitions identifying tables used parallelism faster retrieval data multicore host environment materialized views setup consolidation viewing data identifying setting range partitions large reinsurance oracle tables database size 3tb korn shell scripts monitor databaseservers disk io file system space process monitoring usage awksed parsing data perl numericalphanumeric scripting database migration expertise oracle sybase sqlserver data transfers using twotier three tier application using odbc data classification analysis hands etl jobs move data db2 oraclemssql databases data consolidation using data stage etl mainframeoracle mssql enforce change management process data changes production mssql sql server integration services move snapshot data mainframe data provisioning updates outstanding issues affected application business migrate sybase system10 database sybase ase12 skills administrative backup bank reconciliation bi case tool change management ca data modeling data warehouse databases data base database datastage delivery engineer erp erwin etl gateway ibm inventory ledger management reporting materials max meetings memory mysql enterprise olap oracle processes project management quality reporting requirement san scanner scheduling servers scripts ms sql server mssql sql sybase tables transact sql unix upgrade vm written