jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary seeking position bietl developer organization wherein technical efficiency commitment contribute towards organizational well personal growth skills oracle biee 11g analytics conducted maverick solutions miami fl 3days 2013 oracle bi publisher conducted oracle web based 2 days 2016 participations active member oracle technology network otn providing solutions discussing obieebi publisher otn skills rdbms oracle 10g11g sql server 2000db2 etl tools informatica power center 90 86 oracle data integrator operating systems windowslinuxunix languagesutilities sql plsql xml html tools sql plus sql developer toad work history bietl developer 022016 current fdny city state effectively interacted end users requirement gathering defined requirement specifications document access retrieval financial personnel data one single source worked different fdny applications like cid cpattraining trackingbhs applied optimization techniques better performance reports generated tableau dashboard quickcontextglobal filters parameters calculated fields tableau reports created functions packages oracle support data loading environment obiee 11117 tableau90 oracle bi publisher smart view oracle11g unixsql developer toad obieetableau developer bi analyst 102015 122015 dunkin brands city state understanding client requirements source data business objectives key performance indicators configuring analytics repository rpd implementing security authenticate authorize oracle users built physical layer logical layerbusiness model mapping layer presentation layer repository using star schemas identified facts dimensions grain dimensional mode referential joins built repository 3 layers ie physical layer connecting data sources import schema business model data mapping create logical tables data source mapping presentation layer level create presentation catalogs created business facts dimensions defined logical relation bmm layer created action filters parameters calculated sets preparing dashboards worksheets tableau developed tableau visualizations dashboards using tableau desktop environment obieeetl developer 122014 102015 audible city state involved gathering requirements prepare functional technical code document development worked extensively physical layer business layer presentation layer customize existing business models also developed new models maintenance developed new dashboards reports users obiee answers involved performance tuning obiee reports bi publisher reports involved writing complex sql queries part report development bi publisher involved performance tuning complex sql queries using different types hints worked different databases like oracle redshift environment obieeetl developer 102014 112014 upmc city state involved translating functional requirements technical requirements assisted building detailed project schedule gathering requirement completed proof concept designed developed making technical designs unit test scripts creating kpis key performance indicators interactive dashboards administering oracle obiee applications responsible offshore onsite coordination build test cases tested reportsdashboards comparing sql output data warehouse values reportsdashboards documented test results enviroment obieeetl developer 072014 082014 adt security services city state interacted business management representatives gathering reports dashboards requirements define business functional specifications created new repository customized existing metadata repository rpd designed developed physical data layer business model mapping presentation layer using bi administration tool designed physical relationship diagrams using fact dimensional tables developed dimensions time series objects business model mapping layer configured measures logical layer mapped multiple physical source tables configured ibots deliver analytics content based schedule automated ibot queries obtain weekly reports delivery reports email handheld devices mobile phones extensive performance tuning bi implementing aggregate navigation cache management environment obieeetl developer 032013 062014 bankunited city state built business model established relationships foreign keys physical logical tables involved migration repository test environment production environment compared data hyperion essbase obi data validation applied optimization techniques better performance reports extensively used sql tuning improve performance created financial reports using sql plsql bi publisher created highly formatted prebuilt reports bi publisher environment obieeetl developer 122012 022013 pnc bank tcs city state involved rpd development oracle bi administration oracle bi answers scheduling ibots bi publisher upgraded 10g 11g created views alias complex queries physical layer obiee order improve performance reports implement complex reports developed physical layer business model mapping presentation layer using oracle bi administration tool specified dimensional hierarchy aggregate levels dimensions developed different brand level reports filters prompts using oracle bi answers administered nqsconfigini instanceconfigxml configuration files creating kpis key performance indicators interactive dashboards administering oracle obiee applications environment oracle bi consultant 082012 122012 aramark uniform services city state involved building detailed project schedule gathering requirements completed proof concept translating functional requirements technical requirements designed developed made technical designs unit test scripts designed developed obiee metadata repository rpd using obieesiebel analytics server admin tool importing required objects dimensions facts aggregates integrity constraints physical layer using connection pool developing multiple dimensions drilldown hierarchies logical facts measures objects business model layer creating presentation catalogs presentation layer upgrading obiee 10g 11g fixing errors coming way well versed datamodellingdata qualityetl performed data validation data reports fixed errors warnings repository web catalog performed unit integration regression testing various dashboards reports repository environment education masters degree electrical electronics mobile may2012 university south alabama al bachelors degree electrical electronics guntur rvr jc college engineering ap electrical electronics guntur rvrjc