jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary around 6 years information technology experience phases software development life cycle including database administration data analysis business intelligence proficiency microsoft business intelligence technologies like ms sql server integration services ssis ms sql server analysis services ms sql server reporting services ssrs experience creating databases tables stored procedures ddldml triggers views user defined data types functions cursors indexes using tsql extensively worked clients understand business requirements recommended technical solutions documented functional requirements involved data warehousing concepts data modeling techniques like dimensional data modeling star schema modeling data vault modeling snowflake modeling fact dimensions experience sdlc software development life cycle involving system analysis design development implementation using waterfall methodology agile methodology strong experience design developing etl using sql server integration services ssis experience creating ssis package load data flat files sql server using various types transformations like lookup fuzzy lookup multicast derived columns condition split term extraction aggregate transferred data modifications dataflow tasks script tasks loop container loop sequence container slowly changing dimension experience installing managing monitoring troubleshooting sql server excellent knowledge dimensional data modeling analyze data warehouse building multidimensional cubes using sql server analysis services skills technical skills operating systems windows2010 2008 2007 2003r2 2003 2000advanced server windows nt unix rdbms mssql server 2016201420122008r22008 bi tools sql server integration services ssis sql server reporting services ssrs sql server analysis services ssas etl self bi excel tableau languages c c tsqlsas xml dynamic sql database query tools sql server management studio ssms business intelligence development studio bids visual studio 201320152017 sql profiler dqs work history aug2020 current sql developer android industries hazel park mi worked senior management team operationlevel managers gather requirements strong experience analysis design development implementation endtoend business intelligence analyzed existing sql queries identify opportunities improvements developed etl framework processing monitoring import flat files ssis key client interface technology teams extract transform load data wide variety data sources using microsoft ssis andor azure cloud technology developed implemented optimized stored procedures functions using tsql involved designing developing testing etl extract transformation load strategy populate insurance data various source systems feeds using ssis developed complex stored procedures views generate various drillthrough reports linked reports ad hoc reports using ssrs responsible scheduling reports run daily weekly monthly basis using ssrs report manager developed custom database objects stored procedures delivered application support designed implemented tsql queries reporting complex solution development maintained complex tsql queries views stored procedures multidatabase environment little supervision managed workload independently collaborated colleagues complete larger scale tasks distributed team environment designed developed customized extract transform load etl applications per client specifications reviewed interpreted business report requirements address user needs followed standard practices migrating changes test production environments provided technology support meet business requirements built useful reporting deliverables properly document analysis results provide performance improvement feedback generated debugged enhanced existing reports introduction new system features proved successful working within tight deadlines fastpaced atmosphere developed maintained courteous effective working relationships participated continuous improvement generating suggestions engaging problemsolving activities support teamwork sep2017 jul2020 sql developer android industries arlington tx worked senior management team operationlevel managers gather requirements wrote optimized sql statements assist business intelligence practices responsible creating managing various database objects tables stored procedures views triggers database constraints meet business requirements involved interacting user gathering business requirements resolving claims client accounts responsible making analysis transactions client determining solution settlement client account proficient coding optimized teradata batch processing scripts data transformation aggregation teradata database analyzing business needs clients developing effective efficient solutions ensuring client deliverables committed timelines responsible extracting loading client historical data source sql environment performing various business operations using ssis responsible scheduling ssis jobs automate processes using sql server agent experience building ssis packages dtsx involving etl process extracting data various flat files excel files legacy systems loading sql server hands experience working ssis etl process ensuring proper implementation event handlers checkpoints transactions package configurations created ssisdts packages copy tables schemas views extract data excel oracle designed etl packages dealing different data sources sql server flat files xmls etc loaded data target data sources performing different kinds transformations using sql server integration services ssis experience deployment ssis packages different environment using configurations deployments different environments implementing high availability techniques like clustering log shipping replication experience working cmd utility tool run command files created different power pivot reports per client requirement designed developed power bi graphical visualization solutions business requirement documents plans creating interactive dashboards experience creating multidimensional cubes using ssas designing dw schemas experience creating ssrs reports using pie charts bars etc business analysis purpose experience creating ssrs reports using pie charts bars etc business analysis purpose experience writing excel macros using vb script format excel report responsible designing development deployment ssrs reports using ssrs report designer responsible designing developing tabular report parameterized linked reports sub reports drilldown reports drill reports adhoc reports crystal reports thorough knowledge ssrs responsible scheduling reports run daily weekly monthly basis using ssrs report manager defined security models row level data security rolebased security etc business objects universes central management console cmc responsible creating complex cross tab olap cube report using crystal reports integrated ssms designed report templates bar graphs pie charts crystal reports data analysis worked extensively obiee answers create financial statement reports intelligence dashboards financials per detailed design requirements involved monitoring trouble shooting performance tuning databases support production environment 247 oncall rotation responsible creating maintaining highlevel design documentation considering future changes demonstrated respect friendliness willingness help wherever needed aug2014 aug2017msbi developer cognizant technology solutions dayton oh gathered requirements determine necessary hardware configurations planned software involved team member requirement analysis design phase project project involved maintenance existing oltp databases well designing ssis packages custom warehousing needs experience handling extraction transformation loading etl process pulling large volume data various data sources using ssis experience working different control flow elements like data flow task bulk insert task active x scripts execute sql task script task send mail task xml task experience working different data flow elements like flat file oledb excel sources destinations data conversion term extraction conditional split derived column pivot etc deployed different ssis packages development test environments created scheduled ssis jobs using sql scheduler sql server agent daily weekly monthly loads experience migration parts visual source safe vss 2005 team foundation server tfs 2010 involved development deployment cube developed complex stored procedures views generate various drillthrough reports linked reports ad hoc reports using ssrs scheduled reports run daily weekly monthly based requirement report manager defined report layouts formatting report design per need generated test data tested new database consistency existing databases maintained existing applications designed delivered new applications created jobs alerts activity logs error logs capture possible errors using sql server agent enhanced performance using optimization techniques normalization indexing transaction isolation levels education 072003 bachelor science management information systems unity university college