jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 6 years experience sql server databases data loading reporting tools ssis ssas ssrs power bi sql server integration services ssis strong experience analysis design development testing implementation business intelligence solutions using data warehousedata mart design etl olap bi clientserver applications excellent knowledge rdbms concepts constructs along database objects creation tables user defined data types indexes clustered non clustered stored procedures views user defined functions cursors triggers proficient designing deployment ssis packages using various transformations slowly changing dimension multicast merge join lookup conditional split aggregate derived column sort multicast union data conversion transformations experience dealing different source target like oracle 11g sql server 20082012 hive tera data cassandra sales force csv flat file text format data using different type connection like ole db odbc adonet experience dts migration metadata management migrating dts packages ssis package migration wizard storage management maintaining log audit information sql tables experienced providing logging error handling using event handler ssis packages hands experience tuning mappings identifying resolving performance bottlenecks various levels like sources targets mappings sessions hands generating ssis packages using business intelligence markup language biml terminology experienced developing window batch script execute ssis package configured jobs using bmc product control 81 experience report writing using sql server reporting services ssrs creating various types reports like drill parameterized cascading conditional table matrix chart sub reports developing reports ssrs sql server understanding ssas olap cube architecture knowledge storage modes molap rolap holap processing cubes using ssis ssms experience writing expressions ssrs expert fine tuning reports created many drill drill reports using ssrs developed tableau data visualization using cross tabs heat maps box whisker charts scatter plots geographic map pie charts bar charts density chart worked power bi prepared dashboards using tableau make attractive create reports power bi preview portal utilizing ssas tabular via analysis connector involved analyzing designing building testing olap cubes ssas 2008 adding calculations using mdx extensively worked developing ssas cubes aggregation kpis measures partitioning cube data mining models deploying processing ssas objects designed implemented data mart facts dimensions olap cubes using dimensional modeling standards sql server 2008 maintained data involved complete data warehouse development life cycle actively supported business users change requests extensively worked teradata utilities like bteq fast export fast load multi load export load data tofrom different source systems including flat files knowledge sfdc standard data structures familiarity designing custom objects forcecom platform forcecom sites experienced working sql query analyzer sql server management studio business intelligence development studio scheduling jobs sql server agent sql server storage structures index clustered nonclustered sql profiler part team extensively involved software development life cycle sdlc initial planning implementation projects capable handling responsibilities independently well proactive team member skills data ware housing tool sql server integration services ssis informatica power center 91 reporting tool sql server reporting services tableau 70 power bi power map report builder data base sql server 20082012 oracle 11g hive tera data cassandra cloud services microsoft azure sales force programming language tsql sql soap app servers iis ides tools microsoft visual studio shell bids sql server management studio tera data studio sql developer revision controlling systems borland starteam ibm rtc scheduling tool control methodologies agile scrum work history msbisql developer 072015 current cognizant technology solutions bannockburn il childrens place childrens place largest pureplay childrens specialty apparel retailer north america childrens place designs contracts manufacture sells fashionable highquality merchandise value prices 1 brand recommended moms headquarters childrens place secaucus nj responsibilities managing design coding source dependent extracts source independent loads post load processes source target systems managing design implementation user defined dashboards reports optimized performance queries tsql queries normalized tables established joins created clusterednonclustered indexes wherever necessary designed different kinds reports like linked cascaded parameterized reports worked drill drillthrough reports etc expert working activities related development implementation administration support etl processes using bulk copy process bcp data transformation services dts change data capture cdc worked type 1 type 2 packages incremental load data source datamart wrote complex sql queries data analysis build reports business users created reports power bi preview portal utilizing ssas tabular via analysis connector created different visualization power bi according requirements responsible deploying ssis packages scheduling package jobs tiers including dev test production created different facts dimension tables increase performance complex sql queries used ssrs reporting created packages different control flow options data flow transformations conditional split derived column look data conversion merge merge join used ssis sql server stored procedures transfer data oltp databases staging area finally transfer data marts extensively worked production support includes deployment ssis packages development production servers creating scheduling managing sql jobs extensively worked design development ssis etl packages extract transform load data different sources like excel files flat files data warehouse using different tasks transformations like file system task data flow task derived columns execute sql task worked execution paths depending success failure completion tasks precedence constraints expressions determine workflow environment sql server 201420122008 r22008 tsql plsql excel power bi toad visual studio 201020122013 msbi developer 102013 072015 cognizant technology solutions barnegat nj black hawk networks united states building toward future innovations spanning growing spectrum technologies project data storage media data center services project used ssis packages etl purpose configure source target mapping transformation finally loaded data sql server tables ssrs reports run top tables created better visibility data managers responsibilities msbi developer 052012 092013 vision comptech india data digitalization migration services egovernment project initiated interface government end user solve billing related complexity customer management secure payment failed transaction management customer messaging error handling company designed csi solution interact interface effort ddms portfolio responsible handling data captured csi channel external government web services raw data received third party vendor responsibilities education bachelor technology computer science engineering 2012 rajasthan technical university kota rajasthan