jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary microsoft certified professional 11 years experience development implementation support microsoft business intelligence msbi tools ssis ssrs microsoft sql server various banking finance domains extensive knowledge experience dealing relational database management systems used etl methodology performing data migration extraction transformation loading using ssis designed data conversions wide variety source systems able work minimal supervision collaborative environment experienced informatica etl tool well versed various phases software development life cycle process sdlc highly motivated ability learn new systems business processes excellent verbal written communication skills combined interpersonal conflict resolution skills possess strong analytical skills accomplishments received employee month award 2013 customer centric reliable received star employee award 2017 always fixing severity 1 production issues well sla conducted introductory advanced workshops db concepts entry level programmers tutored school dropouts voluntarily graduation skills sql server integration services sql server reporting services microsoft sql server informatica source version control git github svn tableau scripting vb shell aws cloud aws quicksightaws redshift aws s3 work history 032019 032021 senior etl developer epam systems inc jacksonville fl interacting business owners gather functional technical requirements identifying bottlenecksissues fine tuning optimal performance documenting business requirements framing business logic etl process managed team 25 onsite offshore employees overseeing training professional growth employees load historical intraday data data warehouse enable business analysts better understand monitor analyze data increased customer satisfaction resolving severity 1 issues making sure system bau performed data analysis data validation writing complex sql queries 032015 032019 lead etl developer allegis group jacksonville fl translate business needs sql server reporting servicestableauwebfocus reports make data analysis easy end users design develop test ssis packages involving complex etl processes managed 40 ccp issues single day smooth functioning dialer systems provide support central data warehouse dialer systems diagnose quickly resolve production issues working experience informatica power center experienced creating data visualization dashboards using tableau provide adhoc reports support business needs end users perform rca issues defined sla made sure applications bau performed replication backup compression individual tables indexes reducing disk usage improved database performance 20 filtered cleansed data legacy system using complex transactsql statements staging area implemented various constraints data consistency performed data cleansing creating tables eliminate dirty data implemented error logging using ssis 022013 022015 etl developer abt associates cambridge created etl packages using different data sources sql server flat files excel source files xml files loaded data warehouse using sql server integration services prepared complete data mapping migrated jobs using ssis migrated data sql server hdfs used sql server reporting services develop different kinds reports like canned adhoc reports clients based requirement worked different file formats like csv orc json parquet files different compression techniques include bzip2 snappy knowledge hadoop ecosystem including scoop hive experience full development cycle data warehouse including requirements gathering design implementation maintenance 032010 012013 junior sql developer education 032009 certifications servicetitan columbus oh worked tsql creating tables views stored procedures functions views migrated dts objects sql server integrated services ssis environment proficient writing optimized sql queries expertise performance tuning troubleshooting query optimization skills run queries export data desired format worked phases sdlc scrumagile involved migration databases sql server 2005 sql server 2008 used vb scripting script tasks achieve desired function bachelor technology biotechnology jawaharlal nehru technological university anantapur microsoft certified systems administrator itil v3 foundation