jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 6 years experience full software development life cycle sdlc 5 years experience developing implementing sql server databases including creating database tables views store procedures functions index triggers cursors constrains transactions relationships using tsql queries well user interface management studio 5 years experience administering sql server databases including preparing maintenance plan implementing security database also experienced sql performance optimization setting different high availability options 5 years experiences designing testing deploying administrating different kinds reports tabular matrix sub report linked reports graph based adhoc report using different kinds reporting tools ssrs birt crystal reports report builder 30 5 years experience extracting transforming loading importingexporting data different sources different destinations using sql server package integration ssis experience using configuration variables package deployments qa production servers 3 years experience agile methodology using jira excellent academic record better analytical problem solving ability core qualifications databases ms sql server 20141208r20500 oracle 10g ibm db2 v95 mysql ms access platform windows ntxp2000200320082012vista windows 7 unix report ssrs crystal report report builder30 birt language c c aspnet java vb wcf wpf html css xml javascript tools rational rose visio tfs vs2012 vs2010 tortoises svn soap ui jira experience database etl developer 042013 current maleda tech city state worked business analysts understand requirements analyze different business requirements provide time estimate sdlc phases analysis design coding implementation uat production move developed exported custom documents using business intelligence reporting tools birt sql server reporting service ssrs various formats pdf doc ppt perform etl processes using ssis tool sql server designdevelop complex queries efficiently per given business requirements created database factdimension tables views stored procedures functions triggers required develop views subqueries joins complex queries involving multiple tables used various transformation tasks create etl packages data conversion loaded flat files excel data database using sql server integration services ssis applying various transformations like lookup merge join aggregation derived column data conversion script task created transactsqlstored procedures views triggers subqueries joins used advanced features tsql order design tune tsql interface database applications efficient manner created stored procedures business logic using tsql involved daily batch loads full incremental staging staging areas troubleshooting process issues errors using sql server integration services ssis scheduled jobs alerting using sql server agent worked table partitioning load current historical data greatly improved performance daily transforms identifying reorganizing indexes major tables performed space estimation calculation application installation performance tuning database monitoring configuration troubleshooting technologies microsoft sql server 2005200820122014 microsoft visual studio 2012 microsoft sql server reporting service ssis red gate database report developer 022012 042013 data group llc city state analyzed interpreted business requirements transferred applicable system generated reports using sql server reporting services ssrs research design develop software enhancements integrate existing products designed relational database using ms sql server 2012 wrote stored procedure triggers view functions migrated mainframe sql server 2008 database microsoft sql server 2014 databases created databases maintenance plan databases based application requirements prepared system design document operational manual disaster recovery plan reviewed operational issues senior management suggested possible solution current technologies technologies microsoft sql server 2005200820122014 microsoft visual studio 2012 microsoft sql server reporting service project mcc advertisement system system integrated software system designed specifically business needs cutting edge newspapers magazines media providers keep track customer data credit history payment information ads classified ads sales reps schedule across organization system also send emails pdfs invoices statements customers send bulk email campaigns customers prospects schedule ads check past activity enter payments change ad sizes add run dates fly use realtime reports show revenue space usage future issues responsibilities designed relational database using ms sql server 2012 wrote stored procedure triggers view functions designed implemented business logics bll data access dal components c aspnet developed reports using sql server reporting service ssrs used record set sql commands retrieve update data database sql server 2005 created etl process move data different sources different destinations technologies vb60 aspnet c ssrs crystal report ms sql server 20052008 uml rational rose visio javascript html jquery ajax css database report developer internship 082011 022012 data group llc city state involved full development cycle data warehouse including requirements gathering design implementation maintenance collaborated network operators application developers dbas enhance end user experience involved installation configuration development deployment troubleshooting reporting services using ssrs across various environments worked client requirement wrote complex sql queries generate reports created different reports tabular chart dashboard etc based requirements retrieved data using stored procedures accept parameters using ssrs technologies microsoft sql server 2005200820122014 microsoft visual studio 2012 microsoft sql server reporting service help desk assistance 102009 072011 sound hospitality city state assisted developing efficient way track user calls extract user information responsible tracking calls log system submit daily log management responsible creating support ticket making sure close ticket issue resolved worked customer service representative complex volatile customer issues technologies ms office word excel outlook access instant messaging software vmware applications bachelor science accounting 2012 strayer university alexandria va associate applied science business administrations 2010 northern virginia community college alexandria va education