jessica claire professional summary 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom experienced data architect wellversed defining requirements planning solutions implementing data structures enterprise level data warehouse enrinment analytical problemsolver detailoriented methodical approach background includes designmaintenance conceptual logical physical dimensional start schema data models prepared offer 10 years related experience dynamic new position room advancement skills erwin r73 modeling tool ibm rational system architect rsa microsoft office excel word power point outlook data governance tool collibra service alerting tool itsa confluence jira rochade metjessicata repository cobol programming report generation structure designs work history database consultant 012010 092020 amazoncom inc west jefferson oh staging tables verbal written communication analytical skills transitioned dual role metjessicata analystlogical data modeler perform enterprise relational data modeling banking industry using ca erwin tool following ibm banking data warehouse bdw standards responsibilities included creationmaintenance conceptuallogicalphysicalstar schema data models different databases housed data warehouses based united states worked closely business stakeholders business analysts data analysts systems analysts translate data requirements data model design using 3rd form normalization interview process worked end users business analysts technical architects developers identify understand project requirements data different source systems performed data profilinganalysis activities help establish modify maintain data models different business lines using excel spreadsheets assisted teams hong kong uk mexico ensure logical modeling standards followed single handed project 2000 data elements needed research risk team single handed logical modeling effort standardized 3000 data elements comply uk team requirements new credit card vendor spearheaded delivery 1000 data elements 10 weeks opposed normal delivery time 6 months using iterative process split work across multiple metjessicata analysts logical data modelers created maintained data mart dimensional star schema models mortgage business line created conceptual data models identify key business entities visualize relationships created maintained detailed logical data models identifying entities attributes relationships comply business requirements worked closely etl dba teams create best fit physical data model derived logical data model facilitate ddl scripts database implementation worked closely etldba teams testing ddl scripts ensure models deployed test environments issues provided updated data dictionaries reports data models business users performed data validation querying data sql server ensure accuracy data model design documented data lineage source target mapping developing data warehouse models implemented tracking changes time attribute levels purpose traceability responsible trainingdevelopment team members dual role logical modelermetjessicata analyst assisted peer reviewing changes logical data models used visual paradigm tool upload xml files erwin models effort convert data models new modeling tool used juniper rx tool prepare load data gcp storage bucket collaborated system architects design analysts others understand business industry requirements documented communicated database schemas using accepted notations actively listened customers requests confirming full understanding addressing concerns created plans communicated deadlines ensure projects completed time gathered defined refined requirements led project design oversaw implementation developed database architectural strategies modeling design implementation stages address business industry requirements actively listened customers handled concerns quickly escalated major issues supervisor metjessicata analyst 012005 092020 john wiley sons inc saint louis park mn hired metjessicata analyst main objective ensure application data standards responsibilities included gathering business technical requirements documentation data lineage source target mapping maintained data dictionaries essential data management functions prepared loaded business glossaries technical metjessicata metjessicata repository tool asgrochade metjessicata management collaborated stakeholders support implementation metjessicata collibra data management tool worked closely data stewards identification documentation critical data elements cde preparation load collibra used ibm rational system architect rsa tool query business data model collibra different systems createdmaintained jira story boards track issuesrequirements facilitate engagement different teams agile projects createdmaintained confluence pages itsa jira events applications discovered deployed production without proper development operations workflows complies service level agreements assisted research development implementation special projects needed maintained data glossary business definitions calculations business rules column names data lineage impact analysis business metjessicata technical metjessicata led global metjessicata efforts multiple projects 1000 data elements purpose identifying redundancies data definitions deficiencies naming convention discrepancies identified resolved problems root cause analysis research generated reports detailing findings recommendations validated results performed quality assurance assess accuracy data business system analyst 012000 012005 american dental partners inc menomonee falls wi hired cobol db2 programmer work projects different business lines responsible writingmodifying batchonline cobol programs populate db2ims database segments would interact power builder screens assisted conversion cii ims system cobol programs point new db2 tables retirement ims segments assisted analysis design implementation batch interface process data conversion as400 05390 environment wrote technical specifications translated rpg programs current process wrote new db2 programs replicate current as400 process performed data mapping ensure impact new process wrote new db2 programs replaced current manual processes wrote data conversion programs files receivedsent vendors assisted analysisdesignimplementation online ezpay application assisted data conversion sql server db2imscics environment wrote nightly batch process retrieveupdateinsertdelete transactional data db2 tables responsible supporting system implementation audited loaded data ensure data quality wrote program part monitoring process online transactions ensured federal compliance helped deploy system enhancements improve field operations coordinated data migration consolidation efforts gathered reviewed reported findings collected defined analyzed business requirements education ba economics north park university chicago il online cloud related courses creating new big query datasets visualizing insights applying machine learning data gcp achieving advanced insights big query exploring preparing data big query big data nosql program mongo cassandra db computer career program ccp certification cobol jcl cics db2 depaul university continuously working updating skills online courses progress data warehouse developer sql serveretlssisssas ssrstsql microsoft power bi desktop business intelligence microsoft excel data analysis dashboard reporting dqs training microsoft sql server data quality services data cleansing data deduplication data quality client ssis tools mar 2021 mysql database administration beginner sql database design feb 2021 sql mysql data analytics business intelligence google cloud platform gcp data engineering specialization