professional summary jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom astute technical data architectanalyst datadriven technologyfocused approach specializing healthcare domain expert sql programmer endtoend knowledge facets data architecture extensively develop hive sql logic transform data projects write shell scripts automate schedule sql batches load data hive warehouse extensively code sqoop scripts data transfer across hadoop relational databases sas programming sas data integration sas data formats storing managing data sas excellent excel reports using external data sources extensively use formulas pivot tables data slicers develop publish tableauqlikview reports access administration expert complex relational database design combining data different sources querying working large tables analyze design new database objects tables indexes triggers etc coordinate database development designing data architecture create logical physical data models using powerdesigner etl datawarehouse development using tools datastage informatica ssis talend data studio model datawarehouses around schemas star snowflake executed projects involving database migration db2 netezza large scale data migration projects sas based analytics platforms datastage version upgrade lead big offshore team around 15 resources numerous projects kept track performance every associate excellent understanding data management principles joining aggregation data concatenating sortingmerging critical thinking multitasking abilities analytical skills planning coordination excellent written communication skills skills data analysis using data cleansing tools create data pivots run sqls using database clients toad oracledb2 dbeaver hive netezza teradata studio data mapping etl development data migration projects sas programming analytics enterprise guide experience base sas macros loading data external files like csv hadoop hive oracle sql server sas metadata environment automate sas projects using sas data studio bigdatahadoop extensively use hadoop utilities hive sqoop spark etldata warehousing etl development using tools datastage designer informatica talend data studio sql development sql scripting automating long running hiveoracle sqls work history technical data analystarchitectural engineer deposco alpharetta ga client united healthcare minnetonka mn data architecture design using sap powerdesigner databases netezza db2 oracle teradata ms sqlserver programming language unix shell python scripting use extensively automation bi reporting tableaubusiness intelligence program developer excellent ms excel report developer using data slicers complex formulas 012019 current sas programming sas data integration sas data formats storing managing data sas develop hive sql logic write sqoop scripts data transfer across hadoop relational databases create publish tableauqlikview reports administer user level access develop complex ms excel reports using external data sources extensively use formulas pivot tables data slicers create document validate process maintain programs macros generate analysis datasets tables graphics reusability improvised data reports availability across team automating weeklymonthly sas projects resulting 247 execution without manual intervention established head data operations team maintain database file system health check perform data cleanup revised modularized updated old code bases modern development standards reducing operating costs improving functionality monitor batch runs followed qa communicate team upon data availability leod etl developerdata warehouse architect 062016 122018 avispa denver co client us bank corp richfield mn datawarehouse development data migration database migration bi reporting platform development executed projects involving database migration db2 netezza large scale data migration projects sas based analytics platforms datastage version upgrade extensively used datastage designer develop etl jobs extracting transforming integrating loading data various sources data warehouse automate jobs using tools controlm autosys executed project responsibilities qa developed etl projects coordinate business uat project deployment production environment lead big offshore team around 15 resources numerous projects kept track performance every associate collaborated stages systems development lifecycle requirement gathering production releases project lead syntel inc city state client american express phoenix az 102010 052016 developed established high level data flow diagram data standards naming conventions evaluated consistency integrity model repository analyze design new database objects tables indexes triggers etc worked database administrator designing data architecture create logical physical data models using powerdesigner trained mentored team developers discussed issues order provide resolution apply best practices collaborated stages systems development lifecycle requirement gathering production releases scotware engineer capgemini city state 102007 102010 consulted us insurance firm analyze different components policy management system document writing low level design specifications followed designdevelop transformed modules mvs vse followed unit testing sit education bachelor engineering madhya pradesh india certified talend big data programmer certifications ibm infosphere datastage developer data engineering microsoft azure 062007