jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary around 7 years experience data warehousing emphasis business requirements analysis application design development coding testing implementation maintenance clientserver data warehouse data mart systems extensive experience gathering defining business requirements brd translating functional requirements frs using various elicitation methods techniques experience business process management business process flows software development life cycle process design change management enterprise analysis requirements analysis extensively worked teradata developer involved mainly building teradata warehouse strong hands experience teradata utilities bteq fload mload tpump analyst using sql server teradata v13 v14 v1510 v1620 experience query optimization performance tuning stored procedures functions proficient data warehousing techniques data cleansing slowly changing dimension phenomenons scds change data capture cdc experience integration various data sources databases like teradata oracle sql server text files developed complex teradata sql code bteq script using olap aggregate functions excellent knowledge experience documents like bsd tsd mapping documents extensively involved identifying performance bottlenecks targets sources transformations successfully tuned maximum performance using best practices experience documenting design specs unit test plan deployment plan extensive knowledge teradata sql assistant developed bteq scripts load data teradata staging area data warehouse data warehouse data marts specific reporting requirements tuned existing bteq script enhance performance expert teradata rdbms initial teradata dbms environment setup development production dba support use fastload multiload tpump teradata sql bteq teradata utilities created shell script run datastage jobs unix schedule script run datastage jobs scheduling tool experience writing unix korn shell scripts support automate etl process work planning grooming user requirement provide solution design using olap architecture create estimates end end development experience data warehouse concepts methodologies well strong knowledge star schema snowflake schema data models knowledge query performance tuning using explain collect statistics compression nusi join indexes including join sparse indexes well versed teradata analyst pack including statistics wizard index wizard visual explain extensively worked pmonviewpoint teradata look performance monitoring performance tuning strong work experience zena scheduler sourced data disparate data sources ibm db2 oracle sql server loaded oracle teradata dw experience testing unit testing integration testing system testing knowledge oracle teradata rdbms architecture good communication skills interpersonal relations hardworking result oriented individual team competent handling levels data warehouse life cycle including requirements gathering analysis preparing business specifications designing technical specifications system requirement specifications skills operating systems unix windows 7xp2000 windows nt 40 zos mvs os390 databases teradatav1620v1510v14v13v12 oracle8i 9isqlserver200020052008 db2 teradata tools utilities query facilities sql assistant bteq load export fastload multiload tpump tpt fast export datamover data modeling erwin visio physical modelling logical modelling relational modelling dimensional modelling etl tools datastage 81858791113 teradata bteq fast load mload ascential datastage 752 designer director administrator manager ms visio 2007 work history 082017 current teradata etl developer infosys san antonio tx programming languages shell scripting kshell cshell sql scheduling tools zena autosys uc4 operating systems winxp78and10 unix linux methodologies agile scrum waterfall analyzed existing etl process came etl design document listed jobs load logic load frequency load tables consolidated data multiple sources central data warehouse environment using datastage etl database worked etl migration talend datastage 115 projects handled various issues code migration used teradata utilities fastload multiload tpump load data designing etl jobs using datastage tool load data multiple source system teradata database parallel jobs load data target schema created datastage jobs load data various mysql postgresql tables teradata tables testing jobs preparing unit test cases helped business user acceptance test converted complex job designs different job segments executed job sequencer better performance easy maintenance wrote tested implemented teradata fastload multiload bteq scripts dml ddl wrote teradata macros used various teradata analytic functions involved migration projects migrate data data warehouses oracledb2 migrated teradata good knowledge teradata manager tdwm pmon dbql sql assistant bteq fixed issues implemented requested changed warranty support period worked application development team implement data strategies build data flows develop conceptual data models created logical physical data models using best practices ensure high data quality reduced redundancy performed reverse engineering physical data models databases sql scripts data dictionary documentation entire tables present swy unica campaign database environment ibm datastage 81858791115 designer director teradata v1620v1510 teradata loading utilities bteq fastload fast export multiload teradata sql assistant info sphere information server datastage postgresql mysql teradata oracle unix shell scripting windows xp 042017 082017 teradatadatastage developer pacific life insurance city state gathered business requirements conducting detailed interviews business users stakeholders subject matter experts smes involved gathering business requirements logical modelling physical database design data sourcing data transformation data loading sql performance tuning developing well modifying existing mappings enhancements new business requirements mappings load staging tables target tables edw also created mapplets use different mappings defining schema staging tables landing zone tables configuring base objects foreignkey relationships complex joins building efficient views expertise writing scripts data extraction transformation loading data legacy systems target data warehouse using bteq fastload multiload tpump involved datastage migration backup version 85 115 modified unixscheduling scripts per datastage 115 developed bteq scripts load data teradata staging area teradata data mart responsible building teradata temporary tables indexes macros bteq scripts loadingtransforming data created load scripts using teradata fast load mload utilities procedures sql assistant performed query optimization help explain plans collect statistics primary secondary indexes used volatile table derived queries breaking complex queries simpler queries streamlined teradata scripts shell scripts migration process unix box error handling performance tuning teradata queries utilities working different tasks workflows like sessions events raise event wait email command worklets scheduling workflow scheduling jobs zena scheduler involved heavily writing complex sql queries based given requirements complex teradata joins stored procedures macros etc used zena scheduling tool schedule jobs per requirement imported data msaccess database xml sql server database wrote complex stored procedures meet business requirements sourced data teradata oracle using fast export oracle sql loader creating sessions configuring workflows extract data various sources transforming data loading enterprise data warehouse running monitoring daily scheduled jobs using work load manager supporting edw enterprise data warehouse loads history well incremental data automating manual monthend processes job creation using zena scheduler investigating failed jobs writing sql debug data load issues production writing sql scripts extract data database testing purposes supported code postproduction deployment involved transferring processed files mainframe target system used serena dimensions build troubleshoot automated testing continuous integration deployment datastage jobs worked agile software methodologies environment teradata v16201510 unix ibm datastage 81858791113 designer director teradata loading utilities bteq fast load fast export multiload teradata sql assistant asgzena scheduler agile 072016 032017 teradata business object developer american express city state gathered documented business requirements along detailed functional design specifications system documentation documented elicited business requirements smes writing user stories resulting clearer detailed complete understanding project deliverables using jira involved documenting business process identifying requirements involved writing system requirements extensively used erwin logical physical data modeling designed star schemas design develop complex business objects universes using designer development using sap business objects toolset developed complex etl mappings extract data flat files hana database load edw teradata database hands experience business intelligence experience using business objects provide ongoing teradata system performance management using teradata manager pmon responsible performance tuning teradata scripts using explain plans indexing statistics extensively used environment sql commands workflows prior extracting data etl tool created databases tables triggers macros views stored procedures functions packages joins hash indexes teradata database involved fixing invalid mappings testing stored procedures functions unit integration testing batches target data creating sql bteq scripts teradata load data edw per business logic performance tuning targets sources mappings sessions improve system performance loaded data teradata tables using teradata utilities bteq fast load multi load fast export tpt develop test support applications running various environments like teradata unix windows coding using bteq sql teradata write unix scripts validate format execute sqls unix environment used erwin tool physical logical data modeling created used volatile tables testing purposes involved code reviews unit testing etl code developed created custom views teradata meet requirements integrated tableau dashboards internal web portal using java script api consistently attended meetings client subject matter experts understand functional business requirements involved administration business objects building data repository performance tuning using aggregates indexes optimizing start routines etc developed reports using teradata advanced techniques like rank row number created new business objects users user groups using business objects cmc module maintained user security bo reports folders universes created complex universe level objects measures using business rules provided created web intelligence reports deployed bi launch pad customized webi front end various business object reporting functionalities used slice dice masterdetail user response function different formulas created derived tables universe performing sql queries custom columnar requirement tables work planning grooming user requirement provide solution design using olap architecture create estimates end end development environment teradata v14v13 erwin etl tool bteq fast export fast load multi load sap bibo enterprise 41 sp2 bi launch pad web intelligence design studio 13 sap design dashboard 41 bw 74 udtidt sap business objects 41403130xi r1r265161 web intelligence launch pad info view information design tool universe designer explorer sap lumira crystal xcelsius 452008 032013 122014 teradata developer tata consultancy services city state massaged data using bteq applying business rules source data validation transformation developed bteq script pre population worktables prior main load process performed transformation later stages performance tuning done functional level map level used relational sql wherever possible minimize data transfer network developed unix script sftp archive cleanse process many flat files created ran preexisting debug sessions debugger monitor test sessions prior normal run workflow manager extensively worked migrating mappings worklets workflows within repository one folder another folder well among different repositories created mapping parameters variables written parameter files designed implemented tables functions stored procedures triggers sql server 2008 wrote sql queries stored procedures views performed application level activities creating tables indexes monitored tuned teradata betq scripts written several teradata bteq scripts reporting purpose developed bteq scripts load data teradata staging area teradata data mart developed teradata utilities populate data edw like fastload bteq fast export multi load analyze translate functional specifications change requests technical specifications generated implemented micro strategy schema objects application objects creating facts attributes reports dashboards filters metrics templates using micro strategy desktop developed tested unix shell scripts running teradata scripts used various teradata index techniques improve query performance created unit test plans unit test code prior handover process qa helped users extracting mainframe flat files fixed csv onto unix server converting teradata tables using base sas programs environment teradata v1314 teradata sql assistant teradata utilities bteq mload fastload fast export tpt db2 sql server 20052008 controlm unix education 052016 032012 master science information technology valparaiso university valparaiso bachelor science ece electronics communication engineering jawaharlal nehru technological university hyderabad