jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary senior developer expertlevel acumen application development delivery new technology capabilities around data analytics space transforming data insights turning insights strategy innovative creative problem solver proven track record improving operational excellence enabling business capabilities organizational strategy competitive positioning excellent interpersonal dexterity proven ability converse liaise negotiate relate relate key stakeholders clients global projects area expertise 15 years experience architecting designing implementing complex high performance scalable solutions specific interest creating data systems operational data stores information data warehouses business intelligence applications data modelling 8 years experience er modeling oltp anchor modeling enterprise data warehouse edw dimensional modelling olap data marts using starsnowflake schemas extensively worked reverseforward engineering generate conceptual logical physical models using erwin oracle designer tools extensively worked establishing enterprise data standards policies guideline data management practices data security developing managing data models metadata management master data management database data warehouse development 12 years strong experience data warehouse full software development lifecycle sdlc extensively worked phases data warehouse development including business requirement gathering converting business requirements functional technical specifications data analysis data architecture design development testing implementation etl bi applications extract land extracttransactload etlelt 10 years extensive experience etl bi architecture design development testing implementation using oracle plsql extensively developed implemented etl process following ralph kimballs dimensional modeling concepts impleme business intelligence data visualization 6 years experience building rich dynamic dashboards reports using tableau birst business objects crystal reports deliver actionable insights extensive experience using python libraries data processing data visualization excellent knowledge agile fundamentals extensive experience working managing agile project task planning workflow scheduling customerinloop development communicates effectively executives management peers subordinates customers enabling fostering professional relationships skills development toolslanguages sql plsql birst bql shell script c aspnet web services javascript xml c c python tableau spark middlewaredatabasesetl oracle 9i10g11g12c ms sql server 20082012 informatica power center software productplatforms oracle sqlplus sqlloader oracle data modeler oracle enterprise manager toad erwin oracle sql data modeler tableau tableau desktop tableau server birst business intelligence platform microsoft visual studio business objects crystal reports aws quicksight change management team foundation server pvcs git processes agile waterfall operating systems windows linux education university pune india 062005 bachelor engineering electronics work history ip secure inc senior datawarehouse etl bi developer albuquerque nm 062011 current lead design development enterprise data warehouse edw operational data store ods agile environment working program staff across organization build automated data solutions analytics reporting provided consultation complex projects considered top level contributor phases systems analysis considering business implications application technology current future business environment devised modified procedures solve complex problems considering computing capacity limitations operation time suggested processing improvements saved 3 hours automated daily night cycle created data models relational schemas oltp dimensional schemas olap proper normalization denormalization techniques using erwin oracle designer created er entity relationship diagrams maintained corresponding documentation corporate data dictionary attributes table names constraints designed data models following ralph kimballs dimensional modeling concepts star snowflake schema slowly changing dimensions type1 type2 type3 implemented etlelt processes extracting data oracle oltp sql server csv xml json using apis shell scripts oracle sql loader developed complex database objects like stored procedures functions packages triggers using sql plsql transforming loading data dimensional data marts olap cubes data mensional dat worked sqlloader load data flat files obtained various facilities every day used lloader standard packages like utl file dmbs sql plsql collections used bulk binding involved writing database procedures functions packages developed scripts python parse json documents load data relational database implemented advanced concepts like collections bulk collect dynamic plsql exception handling global temp table nested tables external tables advanced queuing analytical functions ref cursors perform etl functions effectively use made table functions indexes table partitioning collections analytical functions materialized views query rewrite performed root cause analysis failures resolved performance tuning related issues queries hints explain plan tkprof sql trace indexing partitioning using performed data migration data warehouse using shell script oracle external tables sql loader importexport bulk batch processing automated different workflows using uc4 automation responsible analyzing quality source data designing implementation data quality controls designed developed efficient error handling methods implemented throughout mappings built rich dynamic dashboards reports using tableau birst deliver actionable insights generated 300 canned reports subreports drilldown reports drillthrough reports parameterized reports provide visible data data analysts business using business objects crystal reports migrated 300 reports crystal reports birst tableau developed managed 60 dashboards consisting 400 kpischarts birst tableau bi platform used management employees across multiple departments trained 80 end users across multiple departments use dashboards interact birst birst tableau server worked tableau online tableau server pocs migrated change management system pvcs microsoft tfs worked business analysts qa team implement agile development practices including project scoping analysis design development testing implementation etl bi applications served backup oracle database administrator analysis oracle sessions tablespace usage indexes provide support root cause identification production issue warranty period post implementation conducted walkthrough meeting guiding support successfully completed poc using informatica etl maintained defect tracks bug fix ad hoc reports projects assigned works using jira tools blackwell consulting llp senior datawarehouse etl bi developer city state 052010 052011 lead projects various stages requirements gathering business rules analysis creating physical database model etl development bo universe architecture reporting lead improvised existing enterprise data warehouse instrumental creating process procedures policies standards data warehouse implementation designed conceptual data model based requirement interacted nontechnical end users understand business logics modeled logical physical diagram future state delivered brd low level design document desigi successfully led analytics team implemented various reporting analytics projects using excel dashboards birst crystal reports supported thousands users hundreds reports across organizational units business functions maintaining active trusted business intelligence environment created plsql stored procedures functions packages moving data staging area data mart conducted improved database performance tuning sql statements index tuning creating materialized views data warehousing extensively involved using hints direct optimizer choose optimum query execution plan plan used bulk collections better performance easy retrieval data reducing context switching sql plsql engines generated server side plsql scripts data manipulation validation materialized views remote instances created shell scripts invoking sql scripts scheduled using cron tab wrote unix shell scripts process files daily basis like renaming file extracting date file unzipping file remove junk characters file loading base tables involved continuous enhancements fixing production problems deloitte consulting llp senior web database developer city state 012007 042010 provided consultation complex projects considered top level contributor phases systems analysis considering business implications application technology current future business environment lead meetings business users capture collate document business requirements project implementation responsible development technical programs components system using microsoft aspnet c writing procedures oracle database creating reports using crystal reports proficiently worked logical conceptual physical data models also created various dimensions warehousing data process involved data profiling cleanup process requirement analysis data mart generating scripts schemas using reverse engineering erwin data modeler responsible developing support maintenance etl extract transform load processes using oracle plsql extensively used etl transfer extract data source files flat files json xml load load data target database responsible tune etl procedures star schemas optimize load query performance created complex sql plsql functions procedures packages cursors triggers analyzed technical design documents development various data flow diagrams data models plsql packages database objects provide support developers developed plsql procedurespackages kick sql loader control filesprocedures load data oracle worked list hash table partitioning stats gathering table analysis various oracle indexes wrote plsql procedures reconciliation financial data source target automate testing phases help business preliminary validation finetuned proceduressql queries maximum efficiency various databases using oracle hints rule based optimization created global temporary tables handing multilevel data staging operation extensively worked oracle query optimization performances tuning using explain plan dbms profiler reengineering existing process highly efficient robust monitored maintained health assigned modules overall application develop documented data mappingstransformations per business requirement participating user acceptance testing hand holding business users necessary agile infosystems private limited software developer city state 092005 122006 designed developed multitier data driven web applications support internal external organizational needs understand data business intelligence requirements ensure system compatibility transform complex customer business requirements effective efficient maintainable enterpriselevel solutions developed physical data models created ddl scripts create database schema database objects designed data models using erwin wrote user requirement documents based functional specification created new tables written stored procedures triggers application developers user defined functions created sql scripts tuning scheduling involved performing data conversions flat files normalized database structure developed functions views triggers automation extensively used joins subqueries simplify complex queries involving multiple tables also optimized procedures triggers used production provided disaster recovery procedures policies backup recovery databases performance tuning sql server using sql profiler data loading supported testing team integration user acceptance testing