professional summary jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom 3 years strong professional experience data base design data ware house application development using oracle 12c11g sql plsql oracle data integration experience phases software development life cycle sdlc including analysis specification software database administration development maintenance testing documentation excellent proficiency data extraction transformation loading database modeling data ware housing tools technologies profound knowledge star schema modeling snowflake dimensional modeling data marts facts dimensions strong technical expertise creating maintaining database objects tables views materialized views indexes sequences synonyms database links database directories extensive experience developing plsql stored procedures functions packages cursors collections nested tables records object types database triggers proficient oracle utilities tools sqlloader exportimport sqlplus sql developer sql navigator expertise performance tuning query optimization using various types hints partitioning bulking techniques indexes profound experience tuning sql queries using utilities like explain plan sql trace tkprof improve performance strong experience oracle etl data loading techniques like utl file sql loader copy command external tables various business source environments exposure oracle applications 11i oracle financials ar ap gl modules oracle applications 11i multi org multicurrency environment handson experience oracle apex 503 oracle application express core qualifications databases oracle 10g11g12c mssql server 72000 ms access languages basic c c basic java htmldhtml xml tsql scripting sql plsql unix shell scripting query tool toad sql developer sql navigator sqlplus operating systems windows 2000ntxp798 unix packages micro soft office suite msword msexcel ms power point experience plsql developer 122015 012017 cognizant technology solutions lombard il gdit general dynamics information technology provides professional services simulation training customers defense federal civilian government health homeland security intelligence state local government commercial sectorsheadquartered fairfax major offices worldwide company delivers enterprise solutions manages largescale missioncritical programs provides mission support services responsibilities developed several packages procedures functions triggers use multiple series backend programs using pl sql involved logical physical database design star schema design identified fact tables transaction tables small business consumer markets sbcm customers written sql scripts create database objects like tables views sequences constant monitoring performance tuning oracle12c database checking queries coded plsql subprograms modified existing plsql program units customer contact employees cces relationships customer data load flat files oracle tables using plsql procedures created etl design specifications solid understanding business technical aspects bi solutions created table partitioning based systems date range implemented snapshot process moving data warehouse implementing jobs using apex job monitoring tool assigning email notification data loading validation done performed review analysis deadlocks database performance tuning conducted code walkthrough internalpeer reviews application code deliverables documented whole process flow plsql packages log files locations descriptions log tables possible error messages process codes descriptions involved continuous enhancements fixing production problems worked closely application development teams identify implement continuous improvements effective problem resolution strategies environment oracle 12c sql plsql apex 503 html unix windows 20072010 database developer 062012 122013 corvel indianapolis project deals buying selling exchange crude oil various tasks project user given navigation bar choose specific task work withsome modules include operational accounting coverage actualization credit general ledger accounts invoicing payments pricing reconciliationprovision exists reports analyze print information responsibilities gained experience c c programming unix raminfo applications also developed plsql code updating payment terms interacting business users gathering analyzing requirements involved understanding requirements end usersbusiness analysts developed strategies etl processes provided technical solutions form mdd minor development document process change requests business involved design database schemas data mapping clients databases dcxs transactions databases involved designing star schemas using dimensional modeling created fact dimensional tables writing complex sql queries plsql procedures extract data various source tables data warehouse involved performance tuning optimization sql queries data warehouse consisting many tables large amount data created plsql packages procedures functions extensively used plsql cursors user defined object types exception handling active involvement optimization process database capacity planning creation materialized views partitions tables views indexes etc designed etl extract external data oracle excel file load data using sql loader developed etl data extraction data mapping data conversion various application processes developed unix shell scripts automating execution process involved preparing test plans unit testing system integration testing implementation maintenance automating data loading extraction report generation using unix shell scripting created induction manual etl process production support document involved preparing documentation user support documents environment plsql oracle 11g unix sql navigator windows 2000xp education master science electrical engineering university new west hyderabad ct electrical engineering electronics communication engineering jntuh hyderabad andhra pradrsh electronics communication engineering