jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary flexible sql developer adapts fulfill diverse customer requests within strict budgetary time constraints proficient data architecture design emerging data warehouse concepts new sql development techniques takes responsibility data integrity acquisition processing final validation complex problemsolver analytical driven mindset dedicated achieving demanding development objectives according tight schedules producing impeccable code data quality assurance processes use cases activity diagrams data formatting data validation skills software testing life cycle stlc data analysis technical analysis project management teradata bteq unix platform work history sr data analyst report developer 012019 current cognizant technology solutions framingham project media sales integration dish fortune 250 company 13 billion annual revenue continues redefine communications industry dish disrupted paytv industry mid90s launch dish satellite tv service taking largest us corporations process grew fourthlargest paytv provider dish also involved first live internetdelivered tv service sling tv bucks traditional paytv norms gives consumers truly new way access watch television aim current project create migrate data existing netezza testprod databases tera data structure aws addition migration data team responsible migrating maintain approximately 120 reports business marketing team current projects also involve extensive work gathering requirements reports understanding thirdparty teams billing micro services involving e2e testing deployments responsibilities involved creating detailed functional report level documentation includes business requirements technical specifications worked data conversions application screens worked designing logical physical data models master data transactional data knowledge experience structured systems analysis design techniques prepared mapping document details mapping source target data model application business rules importing exporting data multiple environments working database connections sql joins cardinalities loops aliases views aggregate conditions parsing objects hierarchies developed tableau reports display monthly analysis lob requirements designed implemented etl report flow created dynamic data types implemented data aggregation tableau involved performance considerations tableau via calculation dashboard design involved creating obiee dashboards migrating obiee dashboard reports tableau graphana supporting local retailer sales team external partners retailers distributors vendors timely marketing support learning retailer business understanding nuances local marketing strategy serving marketing support premier advertiser teams supporting creative reviews approvals driving creative development internal dish creative agency provide effective materials across various tactics support marketing campaigns offers local retailers creating reports analyzing key marketing data sales trends consumer insights etc present conclusions meaningful way inform creation development execution marketing projects collaborating various sales groups identify opportunities define marketing strategies support local retailer initiatives within growth segments created grant charts box charts data display writing adhoc sqls unix scripts support incidents soon addressing requests csv files tableau reporting part emergency production support also responsible maintaing reports frequency access high level involvement tableau admin tasks environment unix bteq sql server reports 10g netezza aws hadoop sql tableau oracle rdbms sql developer obiee 1112c soap postman jenkins con jobs sr oracle plsql report developer 092015 012019 comcast city state project xfinity entertainment pass interactive tvvodip electronic sell comcast leading provider information entertainment communication products services provides services high definition video highspeed internet digital voice wireless highspeed internet communication solutions aim project create data warehouse existing database addition comcast decided build obiee tableau top data warehouse create reports provide business decisions users also involved building day day transactional flow purchases coupon assignment fraud enhancements rental assignments individual customers current projects also involve extensive work external teams billing micro services oracle involving e2e testing deployments responsibilities involved creating detailed functional documentation includes business requirements technical specifications worked data conversions application screens worked designing logical physical data models master data transactional data knowledge experience structured systems analysis design techniques developed database objects including tables clusters indexes views sequences packages triggers procedures troubleshoot database problems prepared mapping document details mapping source target data model application business rules importing exporting data multiple environments support maintenance monthly metric reports lob analysis active part 4dx projects apart assigned projects part 4dx worked multiple projects created tasks learn implement core java concepts tableau use grafana analysis reports monitoring implemented nagios alarming multiple operations automating recycle process designed developed audit control process plsql jobs keep track job execution along balance reconciliation reports working database connections sql joins cardinalities loops aliases views aggregate conditions parsing objects hierarchies worked postman soap urls part implementing code involved etl design development informatica mappings sessions developed plsql programs load validate data staging environment tuning legacy operations automated analysis reports experienced creating ad queue single user consumption multiuser consumption developed tableau reports display monthly analysis lob requirements designed implemented etl report flow created dynamic types implemented data aggregation tableau involved creating obiee dashboards migrating obiee dashboard reports tableau graphana automated daily outlook email reports tableau display created grant charts box charts data display involved creating word cloud bubble charts tableau part 4dx project track game team used sql loader external tables loading bulk files dailymonthly frequency involved writing external table scripts complex shell scripting data scrubbing based business requirements environment oracle 1112g sql server reports 10g automation deployment using go cd pipelines git implementations plsql toad tableau oracle rdbms sql developer obiee 1112c soap postman jenkins uc4 job scheduling nagios oracle plsql developer 012015092015 great west financial co city state project conversionsreportingmigration conversion project mainly based file load validations run customer data set files varied 5 gb 32 gb received servers using ftp sftp tools used files load unix sqlplus external tables worked finance insurance data validations involved writing plsql procedures load database tables connecting multiple sources challenge used sqlcopy copy one db another encrypted passwords legacy system corrections process connection reports involved main frames unix environment also part implementation team named itsm designed scheduling tools like oracle scheduler control unix jobs batch jobsreports apex manually created lot implementation changes business team widely involves plsql coding procedurepackages triggersreports loading process production completely based pearl c programming plsql programming responsibilities involved uploading data flat files databases validated data plsql procedures created repository building physical layer business model mapping layer presentation layer using oracle admin tool involved getting perl c coding making changes production necessary new implementation logics involved creating implementing sqlcopy db links supported scripts necessary p1 level access across servers tuned complex stored procedures faster execution developed database structures according requirements used look router filter joiner stored procedure source qualifier aggregator update strategy transformations extensively created data mapping files data coming different web services developed various complex stored procedures packages interfaces triggers plsql created various sql plsql scripts verification required functionalities developed database triggers enforce data integrity additional referential integrity developed complex sql queries data retrieval various database objects including tables views worked dba extensively create external tables loading schedules redo undo logging worked various backend procedures functions using plsql developed forms reports per requirements involved requirement gathering creating dataflow diagrams er diagrams database diagrams using oracle designer environment oracle 11g apex svn sql plsql toad tableau oracle rdbms sql developer sql loader external tables oracle plsql developer system analyst 092012 122014 jpmorgan chase city state project information one remediation project mainly migration one database different database basic involvement unix part control jobs existing database ability production changed present environment involved writing unix shell scripts procedures added migration process dbms scheduler replaced control jobs new environment involved tract every change made production involved tickets getting access etc used concept external tables instead sql loader migrated environment responsibilities involved writing new procedures enhancing existing procedures knowledge experience structured systems analysis design techniques developed database objects including tables clusters indexes views sequences packages triggers procedures troubleshoot database problems worked etl team architect build data model staging area prepare mapping document details mapping source target data model application business rules worked sftp process involved creating detailed functional documentation includes business part production support involved data analysis debugging legacy code documentation involved working offshore qa development team involved actively pm role understand assign tasks offshore team get daily updates solely responsible representing offshore team performed sql tuning using explain plan hints indexes responsible performing code reviews created sqlloader scripts load data temporary staging tables utilized sqlloader load flat files database tables used reports display formatted data reports viewed database created printed saved reports snapshot files viewed outside access application created repository building physical layer business model mapping layer understanding qa cycle writing test cases presenting demo test scenarios interacted clients understand requirements managed workload independently collaborated colleagues complete larger scale tasks distributed team environment prepared memory management database systems analyzed complex sql installations help plan data extraction processing tasks aiding eventual deployments drafted data mapping documentation relational databases establish standardized formats maintained complex tsql queries views stored procedures multidatabase environment little supervision environment oracle 10g sql server reports 10g sql plsql toad oracle rdbms sql developer master science electrical engineering state university new york new paltz bachelor electronics communications jntu aws certified cloud practitioner aws certified solutions architect associate education certifications