jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 7 years experience business intelligence profession wellversed mining data developing databases database design administration generating reports ms sql server 2008201220142016 using ssis ssrs ssas bi tools financial banking industries supply chain management skills business intelligence analysis sql server management studio ssms etl sql server integration services ssis tsqlstored procedures sql server reporting services ssrs sql server analysis services ssas data modeling microsoft visual studio work history 082018 current business intelligence developer sequoia benefits san francisco ca data visualization html xml office tool ms word ms excel ms powerpoint one note visio requirements gathering data warehousing solution development processed generated reports end business users daily weekly monthly basis developed managed dashboards using visual studio collected data wideranging sources including ms sql server ms excel flat files experienced working many sql queries using joins date functions generate various reports designed customized data collection models specific visualization tasks developed drilldown drill parameterized ad hoc reports charts using ssrs advanced extensible reporting skills using sql server 2016 reporting services ssrs created many stored proceduresfunctions used ssrs directly generate adhoc reports created modified needed stored procedures user defined functions scripts ssis packages extract transform load etl data several data sources mssql server data warehouse formulated documented physical etl process design based business requirements system specifications including source target mappings transformations lookups aggregations expressions designed ssis packages bring data existing oltp databases new data warehouse performing different kinds transformations like lookup transformations merge joins fuzzy look ups derived columns merge join conditional split data conversion multiple data flow tasks created implemented complex ssis package migrate data multiple data sources data analyzing deploying dynamic configuring ssis packages created complex ssis packages using various transformations tasks like sequence containers script loop loop container execute sqlpackage send mail file system conditional split data conversion derived column lookup merge join union flat file source destination ole db source destination excel source destination etc worked xml configuration files variables deploying ssis packages various environment transferred data various oltp data sources oracle ms access ms excel flat files csv files sql server organized error event handling using precedence constraints break points logging involved creating c scripts using script task ssis performed efficient tuning sql source queries data load usage stored procedures performance participated agile iterative development methodology participated quality processes design reviews peer code reviews version control documentation 102017 022018 sql bi developer ssrs reporting rushmore loan management services llc city state prepared monthly ad hoc reporting alignment client needs improved existing reporting researching data sources compiling data designing output gathered requirements creationreview business functional requirement documents business systems experience database design process data modeling process interacted users extensively gathering requirements analyzing needs end users defined report layout identified datasets report generation developed reports using complex tsql queries user defined functions stored procedures views conducted process interviews stakeholders obtain requirements analysis problem solving designed business requirements documents functional specifications conducting process interviews converted various sql statements stored procedures thereby reducing number database accesses created ssrs report projects bi visual studio created modified managed various report models multiple objects source fields expressions developed various types complex reports like drill drill gauges pie chart bar chart sub reports developed drilldown drill parameterized ad hoc reports charts using ssrs designed develop dashboards reports using ssrs wrote sql queries stored procedures generate data reports deployed scheduled reports using ssrs generate daily weekly monthly quarterly reports including current status participated agile iterative development methodology participated quality processes design reviews peer code reviews version control documentation 022016 052017 sql bi developer etl ssis capital one financial corp city state gathered business requirements definition design data source data flows develop technical design specifications code specifications meet business requirementsspecifications involved technical decisions functional requirements data mapping data directory interaction business analysts client team development team interpreted business needs developed code used ssis create etl packages validate extract transform load data data warehouse databases performed data extraction transformation loading etl systems using sql tools ssis extracted data multiple sources including excel sql etc created ssis packages load customer information flat file database development experience microsoft sql server oltpolap environments using integration services ssis etl extraction transformation loading database administrative skills including backups recovery database maintenance analyzed source system data determine data model etl solution meet business requirements formulated documented physical etl process design based business requirements system specifications including source target mappings transformations lookups aggregations expressions designed ssis packages bring data existing oltp databases new data warehouse performing different kinds transformations like lookup transformations merge joins fuzzy look ups derived columns merge join conditional split data conversion multiple data flow tasks created implemented complex ssis package migrate data multiple data sources data analyzing deploying dynamic configuring ssis packages created complex ssis packages using various transformations tasks like sequence containers script loop loop container execute sqlpackage send mail file system conditional split data conversion derived column lookup merge join union flat file source destination ole db source destination excel source destination etc worked xml configuration files variables deploying ssis packages various environment transferred data various oltp data sources oracle ms access ms excel flat files csv files sql server organized error event handling using precedence constraints break points logging involved creating c scripts using script task ssis performed efficient tuning sql source queries data load usage stored procedures performance participated agile iterative development methodology participated quality processes design reviews peer code reviews version control documentation 022011 012016 data reporting analyst sql serverssrsssis etl education 122014 certifications bank america city state gathered business requirements definition design data source data flows develop technical design specifications code specifications meet business requirementsspecifications involved technical decisions functional requirements data mapping data directory interaction business analysts client team development team interpreted business needs developed code created ssrs report projects bi visual studio created modified managed various report models multiple objects source fields expressions developed various types complex reports like drill drill gauges pie chart bar chart sub reports developed drilldown drill parameterized ad hoc reports charts using ssrs designed develop dashboards reports using ssrs wrote sql queries stored procedures generate data reports deployed scheduled reports using ssrs generate daily weekly monthly quarterly reports including current status used ssis create etl packages validate extract transform load data data warehouse databases performed data extraction transformation loading etl systems using sql tools ssis extracted data multiple sources including excel sql etc created ssis packages load customer information flat file database development experience microsoft sql server oltpolap environments using integration services ssis etl extraction transformation loading database administrative skills including backups recovery database maintenance analyzed source system data determine data model etl solution meet business requirements formulated documented physical etl process design based business requirements system specifications including source target mappings transformations lookups aggregations expressions designed ssis packages bring data existing oltp databases new data warehouse performing different kinds transformations like lookup transformations merge joins fuzzy look ups derived columns merge join conditional split data conversion multiple data flow tasks created implemented complex ssis package migrate data multiple data sources data analyzing deploying dynamic configuring ssis packages created complex ssis packages using various transformations tasks like sequence containers script loop loop container execute sqlpackage send mail file system conditional split data conversion derived column lookup merge join union flat file source destination ole db source destination excel source destination etc worked xml configuration files variables deploying ssis packages various environment transferred data various oltp data sources oracle ms access ms excel flat files csv files sql server organized error event handling using precedence constraints break points logging involved creating c scripts using script task ssis performed efficient tuning sql source queries data load usage stored procedures performance participated agile iterative development methodology participated quality processes design reviews peer code reviews version control documentation associate arts collin college plano tx microsoft sql server data analytics business intelligence applications colaberry school data science analytics credential id 1008020193234746538277 nov 2019