jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary astute technical data architectanalyst datadriven technologyfocused approach specializing healthcare domain come 12 years successful experience data warehousing analytics organized dependable candidate successful managing multiple priorities positive attitude expert sql programmer endtoend knowledge facets data architecture excellent reputation resolving problems improving customer satisfaction motivated learn grow excel data analysis data warehousing sql programming tableaubusiness intelligence program developer skills excellent ms excel report developer using data slicers complex formulas unix shell python scripting extensively use hadoop utilities hive sqoop databases netezza db2 oracle teradata ms sqlserver sas analytics enterprise guide experience base sas macros loading data external files like csv hadoophive oracle sql server oracle db2 sas metadata environment data architecture sap powerdesigner data mapping etl programming infosphere datastage talend studio work history technical data analystarchitectural engineer 012019 current fugro gainesville fl consulting leading us healthcare client thorough knowledge sas programming sas data integration sas data formats storing managing data sas improvised data reports availability across team automating weeklymonthly sas projects resulting 247 execution without manual intervention extensively develop hive sql logic transform data projects write shell scripts automate schedule sql batches load data hive warehouse code 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 excellent understanding data management principles joining aggregation data concatenating sortingmerging expert complex relational database design combining data different sources querying working large tables established quality control processes data verification data integrity data file report results streamline results reports account level create document validate process maintain programs macros generate analysis datasets tables graphics reusability established head data operations team maintain database file system health check perform data cleanup monitor batch runs followed qa communicate team upon data availability revised modularized updated old code bases modern development standards reducing operating costs improving functionality monitor batch runs followed qa communicate team upon data availability lead etl developerdata warehouse architect 062016 122018 hulu san antonio tx consulting leading us banking corporation 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 coordinated project management staff database development timelines project scope strong analytical problemsolving skills willingness troubleshoot issues work detailed level collaborated stages systems development lifecycle requirement gathering production releases trained mentored team developers discussed issues order provide resolution apply best practices project lead 102010 052016 syntel inc city state consulted leading us financial services firm 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 modeled datawarehouse around schemas star snowflake design database changes review database changes data architecture team coordinate deployment development production environments 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 revised modularized updated old code bases modern development standards reducing operating costs improving functionality collaborated stages systems development lifecycle requirement gathering production releases software engineer 102007102010 capgemini city state 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 bachelor engineering 062007 madhya pradesh india certified talend big data programmer ibm infosphere datastage developer data engineering microsoft azure education certifications