career overview qualifications profile summary technical skills jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom bi sql server developer adept application development testing optimization excels microsoft sql server application development including coordinating groundup planning programming implementation core modules programming design skills strong analytical skills experienced structured query language sql developer excellent problem solving skills optimizing performance tuning agile development methodologies requirements analysis design phases 8 years experience analyzing designing tuning developing clientserver business intelligence bi database applications various segments software development life cycle sdlc using ms sql server skilled business intelligence tools like sql server 2008 integration services ssis reporting services ssrs analysis services ssas expertise extracting transformation loading etl data using various tools including bulk insert bcp importexport data dts packages sql server integration hands experience dimensional modeling er modeling star schema snowflake schema fact dimensional tables created configured data source data source views dimensions cubes measures partitions mdx queries using sql server 2008 analysis services extensive experience delivering olap solutions developing corporate dashboard reports using sql reporting services strategy companion analyzer experience creating ad hoc reports reports complex formulas query database business intelligence extensive sql development experience retail industry strong understanding data analytics experienced creating tables stored procedures views indexes cursors triggers user profiles user defined functions relational database models data integrity observing business rules broad experience query optimization performance tuning stored procedures functions etc experience creating jobs sql mail alerts schedule ssis packages using sql server agent experience scheduling deployment reports uploading files report server catalog report manger wellorganized goaloriented highly motivated effective team leadermember excellent analytical troubleshooting problem solving skill rdbmsdbms microsoft sql server 20082005 bi data model tools microsoft sql server reporting services 20082005 microsoft sql analysis services 2008 microsoft sql integration services 2008 strategy companion analyzer programming languages tsql vbnet aspnet rpg database tools sql server management studio sql server business intelligence development studio visual studio 2010 visual studio 2005 sql server profiler work experience ms sql server bi developer sbarro llc city state 062005 current involved complete software development life cycle sdlc process analyzing business requirements understanding functional work flow information source systems destination systems designed developed ssis packages import export data db2 sql server flat files involved daily batch loads full incremental staging data warehouse areas troubleshooting process issues errors using sql server integration services ssis 2008 involved dimensional modeling identifying fact dimension tables based user reporting requirements designed implemented dashboards scorecards business kpis using strategy companion analyzer involved designing generating adhoc reports per client requirements responsible creating datasets using tsql stored procedures rfc programmeranalyst sbarro llc city state 072000 062005 support lawson financial hr ap ar systems job control ocl procedures cl programming clp language rpg ii rpg iv rpg ile structured modular design db2400 ddsphysical files logical files join files data dictionaries screen design aid sda menus display files subfile programming query400 open query file opnqryf rfc programmer analyst sentry technology corporation city state bpcs 405 cd software modifications additions using rpg cl provide technical support users year 2000 program file conversions rfc programmeranalyst bruckner supply company inc city state 1999 072000 111995 1999 performing full project life cycle development including analysis design coding testing debugging rpg cl programs responsible extensive interfacing users developing enhancing systems applications include sales analysis tracking accounts receivable order processing inventory management education training diploma computer programming computer programming briarcliffe data system institute woodbury ny bachelor science electrical engineering technology new york institute technology central islip ny 1994 1992