jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 professional summary 8 years experience developing bi applications utilizing sql server bi stack power bi tableau involved business analysis oltp olap data decision support extensive database programming experienced building ssas cubes dimensions different architectures data sources business intelligence writing mdx scripts experience writing tsql stored procedures triggers constraints indexes using various ddl dml commands developed tsql scripts performing automation tasks performed finetuned stored procedures sql queries user defined functions strong k knowledge data warehousing methodologies including star schemas snowflakes concepts used ntier architecture presentation layer business data access layers coded using c worked agile methodology application development generated adhoc reports excel power pivot sheared using power bi decision makers strategic planning proficient creating configuring workflows designed ms sql server integration services ssis experience reporting services power bi dash board reports crystal reports ssrs using ms sql server supporting services mdx technology analysis services proficient designing scheduling complex ssis packages transferring data multiple data sources integrates data based business logic load data warehouse designed etl using ssis packages reprocess date data time using reprocess logic developing c scripts ssis automating tasks using c maintaining log audit information sql tables experienced providing logging error handling bui handling using event handler ssis packages knowledge dimensional data modelling cube development manipulations sql server analysis services ervices ssas involved designing ssas 2012 cubes building attribute relationships optimal mdx query performance performance hierarchies fact dimensions utilized power bi power view create various analytical dashboards depicts critical kpis legal case matter billing hours case proceedings along slicers dicers enabling enduser enduser make filters miters implemented power bi gateway different source matching analysis criteria modeling power pivot power view experienced designing developing ssrs reports using data etl loads ssas cubes various heterogeneous data sources knowledge big data technologies like hadoop cosmos etc excellent analytical communication interpersonal skills proficient technical writing presentations good team player strong investigative troubleshooting skills education purdue university indiana usa 2017 master science computer information technology jawaharlal nehru technological university kakinada india 2014 bachelor science electrical engineering technology skills programming languages python java c c python libraries numpy matplotlib pandas algorithms linear regression logistic regression decision tree svm naive bayes knn k meansdatabases oracle mysql hbase mongo db operating systems windows centos debian ubuntu tools software pycharm eclipse jira hlm git svn cosmos microsoft sql server data tools sql server bid studio 2008 sqlserver management studio 20122008 sharepoint server 2010 performance point server 2010 power bi hadoop ecosystems hdfs mapreduce pig ambari hbase zookeeper hive sqoop oozie flume accomplishments received highest customer satisfaction index csi 100 customers received client appreciation successful completion data integration project received client appreciation successful completion global supplier 32 release work history neogenomics laboratories sql bipower bi developer aliso viejo ca 082016 072017 project sales orders bi description sales orders project combine subsets data systems containing sales orders information stage format easily interrogated business users bi solution provide consolidated view captured sales orders information answering questions users ability report sales inventory quantity value country available responsibilities developed high level test matrix based business requirements functional technical specifications development standards assigned projectsapplications assisted production olap cubes wrote queries produce reports using sql server 2012 analysis services ssas reporting service ssrs created deployed cubes star snowflake schema performed worked dimensions measures mdx mdx queries designing current database adding tables relationships creating stored procedures views performance tuning sql queries stored procedures designed developed maintained application using vbnet c implemented business logic form custom classes written c developed test cases based test matrix including test data preparation data completeness data transformations data quality performance scalability developed power bi reports dashboards multiple data sources using data blending developed sql queries scripts validate data checking duplicates null values truncated values ensuring correct data aggregations performed data quality analysis using advanced sql skills performed count validation dimensional analysis statistical analysis data quality validation data migration extensive sql querying staging data warehouse data mart explored data variety ways across multiple visualizations using power bi strategic expertise design experiments data collection analysis visualization involved troubleshooting resolving escalating data related issues validating data improve data quality contributed development knowledge transfer documentation designed power bi data visualization utilizing cross tabs maps scatter plots pie bar density charts tata consultancy services sqlbi developer city state 20132015 global supply chain gsc organization global supplier bi xerox manages invoice amount amount distributed payment amount individual teams group gscb xeomaf otc ocf ncth acs need reports analysis decision making gsc bi application mitigate complexity providing single source instead multiple sources cleansed one stop integrated warehouse flexible enough accommodate new changes scalable enough efficiently cater growing user community gsc bi application provides flexibility xerox business users take key management decisions improvement business responsibilities requirement analysis customer interaction requirement clarifications planning estimates hence assigning user stories team development unit testing implementation delivery msbi platform solutions develop deploy etl analytical reporting sql server 2008 using ssas ssis ssrs developed custom reports deployed server using power bi developed business logic layer implementing object oriented programming languages oops concepts abstraction encapsulation inheritance polymorphism c designed designed developed various abstract classes interfaces classes construct business logic using c entity framework sql experience providing logging error handling using event handler custom logging ssis packages experienced sdlc life cycle design development staging phases projects dataflow process models er diagrams support maintained log information text file tracking errors recording package execution status created configurations checkpoints breakpoints created designed adhoc reports excel power pivot shared using power bi decision makers strategic planning understanding olap process changing maintaining warehouse optimizing dimensions hierarchies adding aggregations cube created data warehouse schema deploy fact dimension table defined referenced relationships measure groups fact tables understood existing etl relational database framework scheduled packages using sql server agent jobs perform preventive maintenance activities like causal analysis restructuring program codes data problems resolution performance tuning come different test scenarios automating unit test cases build verification test cases environment test cases unit testing fixing bugs giving application demos customer teams every sprint end generated adhoc reports excel power pivot sheared using power bi decision makers strategic planning utilized power query power bi pivot unpivot data model data cleansing data massaging store source code team foundation server tfs update development status tfs timely