jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary 78 years programming experience plsqletl developer analysis design implementation business logics data warehouse olap applications transactional database oltp development experience teradata utilities like fastload multiload fastexport bteq expertise oracle sql plsql including database objects stored procedures stored functions packages type objects triggers cursors ref cursors parameterized cursors views materialized views plsql collections good knowledge logical physical data modeling using normalizing techniques performance related features query optimizer execution plans indexes strong experience data warehouse concepts etl tools like ssis dmexpress experience working microsoft sql server environment experience data analysis reporting using oracle bi publisher microsoft ssrs power bi good exposure microsoft sharepoint designing configuring various reporting platform strong problem solving technical skills coupled confident decision making enabling effective solutions leading high customer satisfaction low operation costs good expertise stages full software development life cycle implementation sdlc expertise agile process software development excellent communication interpersonal analytical skills strong ability perform part team onsiteoffshore model oracle plsql teradata sql server dm express ssis unix bi publisher skills ssrs power bi microsoft sharepoint agile bi data modeling etl plsqletl developer 122019 current wipro ltd melville ny work history analyze business requirements maintenancedevelopment requests etl using dm express tool various source systems like billing hr payroll general ledger purchase order budget enterprise data warehouse work closely business analysts requirement gathering designing database creating workflow evaluate business requests preparing low levelhigh level design new system compatibility current systems coding developmentenhancementmodification newexisting dmexpress spark bteq mload fast export fast load jobs following syntel hca coding standards plan define development testing strategy performing unit testing code changes done creatingmodifying powerbi reports validating functionality customer upload dashboards servers mapped processes holistically examine business flow identify improvement opportunities researched redesigned etl workflow improve performance 50 applied knowledge data modeling statistical analysis note trends draw conclusions validated results performed quality assurance assess data accuracy documented procedures business processes shared information appropriate stakeholders daily troubleshooting etl production support lawson data requirements plsql etl developer 042019 122019 atos syntel city state understanding requirements translating technical form creating design documents legacy data conversion migration using sql ssis dmexpress coding developmentenhancement newexisting processes sql server oracle database etl tools like ssis dmexpress following coding standard client architecture performing unit testing code changes root cause analysis frequent issues applying permanent fix ensure sla compliance etl jobs participate review meetings various deliverables like code review design review ongoing changesimplementations daily critical cycle support production environment ensure data getting delivered downstream system within sla timeline documented communicated database schemas using accepted notations plsqletl developer 032017 032019 atos syntel city state involved requirement gathering business partnersend users translating technical functional requirements organized business requirements conceptual logical physical olap models createdreviewed highlevel design specification etl coding mapping documents involved sprint planning sessions effort estimation meetings agile environment leading guiding team understand implement solution business requirements effective manner involved etl development using native oracle tools sql loader oracle plsql participated system analysis data modeling included creating tables views indexes synonyms triggers functions procedures cursors packages wrote complex sql queries fact dimensional tables pull data analysis purpose created reports using bi publisher microsoft ssrs optimized broken inefficient assets effectively troubleshooting technical processes workflows interpreted data models conversion etl diagrams code collaborated business intelligence staff customer facilities produce customized etl solutions specific goals communicated regularly customers concerning data exchange technology integration wrote optimized inapplication sql statements plsql developer 122013 022017 atos syntel city state involved etl development using native oracle tools sql loader oracle plsql participated system analysis data modeling included creating tables views indexes synonyms triggers functions procedures cursors packages used advanced bulk techniques bulk collect improve performance involved performance tuning sql using auto trace explain plan tkprof utilities worked analytical functions like rank dense rank lag lead partition wrote complex sql queries fact dimensional tables pull data analysis purpose created reports using bi publisher microsoft ssrs generated debugged enhanced existing reports introduction new system features managed workload independently collaborated colleagues complete larger scale tasks distributed team environment education bachelor engineering computer science 062013 pune university pune india additional information received individual imaginative team adaptive value awards organization received multiple spot awards project manager engagement manager defect free production deployments oracle database 11g sql fundamentals 1z0051 oracle database 11g administration 1z0052 certifications