jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary seven years experience analysis design implementation administration bi using microsoft sql server 2012200820052000 development testing production expert writing tsql working dts ssis ssrs data cleansing data scrubbing data migration developed custom reports different types tabular reports matrix reports adhoc reports distributed reports multiple formats using sql server reporting services ssrs business intelligence development studio bids proficient building end end data integration workflow solutions input source extraction apply various transformations data load database development experience microsoft sql server oltpolap environments using integration services ssis etl extraction transformation loading database administrative skills including backups recovery database maintenance involved optimization data models using ralph kimballs dimensional bill innmon er models experience dts packages migration creating complex ssis etl purposes including data migration data extraction transformationloading etl data flows using ssis creating mappingsworkflows extract data oracle sql server ms access excel flat file sources legacy systems load various business entities involved writing complex queries stored procedures batch scripts triggers functions joins views using tsql performance tuning stored procedures cascading operations large sql queries using indexes efficient coding standards developed cubes scd hierarchies analysts executive dashboards using charts graphs developed business applications vb 6 objectoriented software languages vbnet creating managing users roles assigning necessary permissions sql server security handling dead locks scheduling maintaining jobs automatic email notifications complete understanding software development life cycle sdlc including requirement analysis requirement gathering design development implementation testing deployment experience sound knowledge sql server administrative skills including backups disaster recovery database maintenance user authorizations database creation operating system windows xp7810 windows server 200520082012 red hat centos languages tsql plsql visual basic 6 net rdbms ms sql server 200820122014 ms access 20132016 oracle 9i10g11g mysql etl tools ssdt bids dts importexport wizard reporting tools sql server reporting tools ssrs crystal reports ms excel skills source control tools visual source safe 2005 team foundation server 20082010 data modeling tools microsoft visio 50 erwin v 40 testing tools qtp 10 quality center 10 tfs bug tracking others agile scrum iislinq data migrationetl developer 042016 102016 grmcity state work history grm leading provider information management solutions provides data protection imaging certified destruction film storage hard copy convert migrate customer legacy databases using sql server 2014 tools ssis work various source data formats oracle sql server ms access ms excel ascii text files extract relevant data migrate grms ecm enterprise content management application migrate clients image data vendorneutral archive vna enterpriseclass data management system consolidates primarily medical image data multiple imaging departments master directory corresponding consolidated storage solution provide technical documentation data migration project different clients design implement table partitioning large databases vld order maximize scale performance vldbs tuned much granularly smaller databases develop ssis packages vb logic ssis script task customize data formatting purpose tools technologies sql server 2014 enterprise edition ssis tsql windows server 200822012 grm ecm application sqlssisssrs developer 092015032016 novedea systems city state novedea systems business intelligence consulting firm helping organizations achieve superior performance realizing business potential bi technology extract data various locations excel flat files sql server 2008 ssis perform data extraction transformation loading etl systems using sql tools ssis create database objects like views stored procedures sqlclr hosting microsoft net common language runtime engine within sql server create parameterized reports users clients drilldown drillthrough features develop sql queries stored procedures fetch data different tables remote databases using joins expertise sql server reporting services ssrs created tabular matrix drill bar chart pie chart reports analyze critical data ssrs database development experience microsoft sql server oltpolap environments using integration services ssis etl extraction transformation loading database administrative skills including backups recovery database maintenance define report layout identified datasets report generation develop reports using complex tsql queries user defined functions stored procedures views involved creating sub reports dashboard linked reports charts snapshot reports drill report models drill reports using cube design reports using table filters single value parameters multi value parameters dynamic dependent parameters cascading parameters work different control flow tasks creating ssis packages tools technologies sql server ssmsssisssrs developer 072012 052015 lion international bank lion international bank commercial bank 200 branches within ethiopia 11year history giving different services retail banking services gathering requirements creationreview business functional requirement documents business systems experience database design process data modeling process involved designing databases data marts er model oltp multidimensional model olap work various upstream downstream systems customers interfacing various systems data extractions etl analytics reporting needs involved source data analysis design creation data mappings extraction bulk data heterogeneous sources like oracle oledb data sources design developed ssis packages using various control flow data flow items transform load data various databases servers using sql server integration services ssis extract data various sources like sql server 20052008 oracle csv excel text file client servers create packages included variety transformations slowly changing dimensions look aggregate derived column conditional split multicast data conversion configure packages checkpoints package logging error logging event handling redirect error rows fix errors ssis scheduling maintaining ssis packages batch jobs thru sql server agent day day basis work developing tables indexes views creating complex stored procedures triggers functions handle performance tuning optimization strong analytical troubleshooting skills quick issue resolution largescale production environments located globally create complex adhoc reports sub reports linked reports charts drill throughdrilldown reports created large number report models users create reports design enterprise reports using sql server reporting services ssrs excel pivot tables based olap cubes make use multiple value section parameters pick list cascading dynamics reports deploy solutions web server involved creating user security roles reporting services parent level report level tools technologies database ssrs developer 072008 062012 commercial bank ethiopia city commercial bank ethiopia cbe leading bank ethiopia bilateral arrangement 700 international banks around world design architecture datacenter logical physical data modeling data dictionary mappings warehouse development starting inception implementation ongoing support write various db objects like user defined functions views instead triggers usage indexes accomplishing various tasks work analyzing performance tuning queries looking indexes appropriate joins statistics execution plans using sql profiler query analyzer design packages error handling package logging stores logging results sql table log files create package configurations event handlers error warning task failed event types involved monitoring troubleshooting complex packages using data viewers grids debugging maintenance etl packages optimization using sql server best practices configure install administer reporting services 2005 create report email subscription using data driven time driven report subscriptions work dimensional data modeling using star snowflake schemas fact dimension tables define data sources data source views dimensions measures hierarchies attributes calculations kpis perspectives roles use team foundation server store run view edit revert back different versions design development phases create complex conceptual database designs sql server 20002005 using various constraints triggers implement complex business requirement backend using efficient stored procedures flexible functions facilitate easy implementation front end compliance education bachelor science mathematics 1980 addis ababa univeristy addis ababa mathematics bachelor science mathematics 1980 addis ababa university addis ababa certification database management system implementing oracles financial services software ofss microsoft certified systems engineer mcse certificate business process reengineering bprquerying microsoft sql server 20122014 mcp relational database 1990 ethiopian science technology commission asdis ababa