jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary 8 years programming experience oracle plsql developer analysis design data modeling logical physical development clientserver multitiered applications using oracle relational database management system rdbms sql pl sql different platforms like windows nt2000xp unix linux well experienced working waterfall agile methodologies experienced tuning queries better performance large volume data created technical design back end plsql based business requirement documents functional system design creation database objects like tables views synonyms materialized views stored procedures packages using oracle tools like plsql developer coordinated front end design team provide necessary stored procedures packages necessary insight data involved updating procedures functions triggers packages based change request built complex queries using sql wrote stored procedures using plsql used ref cursors collections accessing complex data resulted joining large number tables involved moving data flat files staging area tables using sql loader extensively used bulk collect fetch large volumes data table performed sql plsql tuning application tuning using various tools like tkprof autotrace dbms sqltune languages sql plsql unix shell basic c c html skills operating systems databases oracle 11g10g9i8i8x7x ms access db2 teradata windows 2000ntxp msdos sql asst 12060 ms sql server work history plsql developer 012022 current cognizant technology solutions morris plains nj developed system using plsql packages procedures triggers functions indexes collections implement business logic using oracle developer toad designed developed maintained data extraction transformation processes ensured data properly loaded extracted systems investigated data quality issues implemented appropriate solutions helped improve performance scalability stability database systems identified implemented programming enhancements developed technical system documentation understanding collecting requirements business user side business analyst convert requirement sql queries plsql convert business need technical complex queries use different strategies database development meet client functional requirement work sql plsql programming developing complex code creating plsql packages procedures functions triggers views exception handling retrieving manipulation checking migration complex data sets oracle creating indexes tables partitioning table sql tuning purpose writing procedures functions views materialized views required writing complex sql queries reporting purpose support users application using multiple sql plsql techniques support day day activities related database like data consolidation data migration scripting creating complex views materialized views multiple table per customer requirement used plsql tables cursors process huge volumes data used bulk collect mass update performance improvement process migrated data flat files tables using sqlloader work data migration using import export user excepting manage unit testing uat plsql developer 082018 122019 cognizant technology solutions mossville il involved creating detailed documentation includes business requirements technical specifications created data mapping files data coming different web services worked designing logical physical data models staging knowledge experience structured systems analysis design techniques developed database objects including tables clusters indexes views sequences packages triggers procedures troubleshoot database problems extensively used stored procedures apply validation logic data staging area load catalog database used explain plan hints performance tuning sql plsql queries worked etl team architect build data model staging area worked business experts understand source data web service systems prepare mapping document details mapping source target data model application business rules worked financial tools maintain manage backup recovery storage user administration using sybase execute handle database objects views procedures indexes file system structure supported code integration system integration testing application involving creating test plan using unit testing fix bugs test code designed developed multiple ctm jobs automate process execute handle database objects views procedures indexes file system structure using sybase expertise production support worked operations closely provided required support involved multiple reports creation operations usage prepared mitigation scripts production resolve issue temporarily analyze production issues send tickets dev tracks code fix involving creating python scripts move data one database another database plsql developer 052017 072018 allied global services shawnee ks analyzed overviewed database design better understanding relations associations dependencies within database data modeling client specific requirements developed database objects including tables clusters indexes views sequences packages triggers procedures troubleshoot database problems developed complex queries data warehousing developed plsql procedures give nice strategic plans higher level management tuned complex stored procedures faster execution developed database structures according requirements oracle data warehousing used dynamic sql programming technique build process sql statements fly run time developed plsql scripts data cleansing sql developer 032010 022015 bankers healthcare group charlotte nc create maintain database server inventory performance inventory working sql tsql vba involved creating tables stored procedures indexes creating maintain users creatingrunning jobs packages design develop deploy packages wmi queries importing data various sources like excel sql server frontbase collecting server inventory data users using infopath 20032007 sql server 2005 creating linked servers databases like frontbase import data using linked servers ensuring data consistency analyzing data generate dash board reports internal users using sql server 2005 reporting services backing database rackstack proliant servers installing base operating system deploy various reports sql server 2005 reporting server design reports user requirements involved migrating servers ie physical virtual virtual virtual installing configuring sql server 2005 virtual machines migrated hundreds physical machines virtual machines conduct system testing functionality virtualization monitor migrated system next 48 hrs bachelor technology csit jntu hyderabad india education