jessica claire resumesampleexamplecom 555 4321000 100 montgomery st 10th floor summary offering proven track record supporting influencing positive outcomes business units companies throughout financial services industry application cuttingedge tools creation detailed productionlevel technical specifications well intuitive conceptual logical relational physical data models enthusiastic learner excellent problem solver collaborate data architects data model management version control conduct data model reviews project team members capture technical metadata data modeling tools create data objects ddl enforce standards best practices around data modeling efforts ensure data warehouse data mart designs efficiently support bi end user collaborate bi teams create reporting data structures skills conceptual logical physical dimensional data modeling oltpolap data warehousing data architecture design development business requirements development web application development mainframe application development development clientserver application development data analysis profiling agilescrumsdlcwaterfall microsoft azure cloud services microsoft sql server transact sol oracleplsql sql oract db2 microsoft access microsoft visual studio microsoft net j c web based technologies aspnet html css bootstrap jquery javascript google maps javascript api google search console microsoft azure sql server education training wayne state university detroit michigan bachelor computer science certifications microsoft certified professional mcp experience apex systems data architect providence ri 122017 current assigned various origin clients reverse engineered sql server oracle operational databases developed conformed dimensional data models reverse engineered operational data sources developed several fact tables using conformed dimensions forward engineered data model ddl sql server data warehouses hadoop hive developed selfservice data marts develop conceptual logical physical data models using best practices ensure high data quality reduced redundancy develop best practices standard naming conventions coding practices ensure consistency data models recommend opportunities reuse data models new environments evaluate data models physical databases variances discrepancies analyze datarelated system integration challenges propose appropriate solutions develop data models according company standards generate sourcetotarget stm mappings erwin generated excel spreadsheets using erwin forwardengineer model ddl azure sql serverazure data factory work etl developers visual studioc stm develop workflows source ods 3nf atomic data target dimensional data perform response time processing window tuning maintain sla apex systems data architect renton wa 082016 122017 assigned external data department reverse engineered eight sql server oracle external data operational databases developed conformed dimensional data models reverse engineered external data operational data sources developed several fact tables using conformed dimensions forward engineered data model ddl sql server data warehouse developed selfservice net loss data marts analyzes cost purchasing processing external data accenture data modeler charleston sc 022015 022016 gm sales marketing data warehouse integrate tier 1 tier 2 sales marketing data develop ods operational data store conceptual logical physical data models source data web logs tags impressions clicks conversion t1t2 sales marketing data develop conformed snowflaked dimensions maintain lineage generate sourcetotarget stm mappings erwin generated excel spreadsheets cognizant technology solutions data modeler salt lake city ut 042011122014 state north carolinas medicaid data warehouse data sourced states claim provider prescription member systems project estimated lower operational reporting costs develop ods operational data store conceptual logical physical data models source data providers claims procedures diagnosis pharmacy data develop conformed snowflaked dimensions maintain lineage generate sourcetotarget stm mappings erwin generated excel spreadsheets forwardengineer model ddl oracle exadata work etl developers datastage stm develop workflows source ods 3nf atomic data target dimensional data maintain type ii history lineage metadata cdc work sas developers develop selfserve olap reporting omni hotels application developerdata modeler rancho mirage ca 112005 052011 enterprise data warehouse data sourced claims provider member pharmacy dental systemsproject estimated lower operational reporting costs develop ods operational data store conceptual logical physical data models source data providers claims procedures diagnosis pharmacy data develop conformed snowflaked dimensions maintain lineage generate sourcetotarget stm mappings erwin generated excel spreadsheets forwardengineer model ddl oracle exadata work etl developers datastage stm develop workflows source ods 3nf atomic data target dimensional data maintain type ii history lineage metadata cdc work cognos developers develop selfservice olap platforms perform response time processing window tuning maintain sla medicare advantage ibm mainframe membership provider claims nasco systems using coboldb2ims provided mainframe application maintenance services applied coding changes developed new online imsdb2 batch programs performed coding reviews testing production release provider systems migration develop current future state conceptual logical data models models used reveal gaps current future state applications microsoft msdn net software sales licensing specialist city state 092001 112003 responsible developing strategies attach msdn enterprise accounts great lakes region increased msdn ea attach 10 yoy managed closed deals multimillion sales pipelines prepared presented msdn technical roi tco knowledge decision making customers orchestrated presentations product owners crossselling coordinated customer licensing training negotiated msdn enterprise licensing pricing customers managed msdn telesales efforts provided microsoft resources partners help close business worked marketing msdn campaigns organized conducted proofofconcepts lunchandlearns acquired msdn subscription expert knowledge learned kept abreast competing products wayne county michigan contractor project manager city state 031996 092001 project prosecutor warrant log oltp application htmljavascriptsql server reduced processing time 50 reduced errors 75 ms project project human relations vendor certification application htmljavascriptsql server reduced processing time 40 reduced errors 80 project treasurer accounts payables application access reduced processing time 30 reduced errors 75 project county mainframe cobol treasury accounts payables application applied upgrades enhancements application required managed year 2000 assessment remediation marlage managed 25 25 technicians managed 5 test replaced upgraded 1500 windows apple desktops laptops servers replaced upgraded 40 applications project online geographical information system esri gis data warehouse arcgis arcsde oracle 81 integrated implemented aerial photography layer county roads management system assisted aerial photography data sourcing implementation estimated 30 improvement road management logistics installed managed administrated oracle 8i implementation installed managed administrated esri arcsde implementation participated jad sessions sheriff police roads sewerage project development participated development data quality strategies