jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary diverse experience industry emphasis etl development data modeling data analysis sql development worked multiple domains like data integration data mining database security industries across various clients currently working informatica power center tools designer repository manager workflow manager workflow monitor enhanced transforming ssis packages different sources destination servers 4 years total experience data analysis system application analysis data architecture development testing deployment business intelligence using data warehousing database business systems areas banking insurance industries strong experience data analysis data cleansing data validation data verification identification data mismatch excellent software development life cycle sdlc good working knowledge testing methodologies disciplines tasks resources scheduling experience designing data marts star schema snowflake schema data warehouse concepts like ods mdm architecture skills data extraction transformation loading data using informatica proficient writing complex sql queries stored procedures normalization database design creating indexes functions triggers subqueries created reports users using tableau connecting multiple data sources like flat files ms excel csv files sql server oracle extensively used vlookups pivot tables excel functions also created pivot graphs reports dashboards configured power bi dashboards reports experience working teams agilescrum development environment good command business intelligence bi tool cognos excellent knowledge creating databases tables stored procedures ddldml triggers views functions indexes using tsql experience data extraction transforming loading etl using various tools data transformation service dts ssis good knowledge business intelligence olap dimensional modeling star snowflake schema extraction transformation loading etl process strong working knowledge oracle sql plsql teradata db2 flat files ms access sybase good analysis requirements gathering design development implementation management full lifecycle data warehouse projects databases sql server 20142012 teradata v2r5 oracle 11g10g db2 sybase ms access unix windows xpnt tools msbi plsql informatica power center 8x7x ssis tsql sharepoint visio tableau system aspects data modeling er dimensional database design requirement analysis object oriented design development testing data mapping metadata management master data management data profiling documentation project management languages plsql java c c microsoft word spss windows welldeveloped skills data populating communication excellent written verbal communication skills confident articulate professional speaking abilities experience empathic listener persuasive speaker writing creative factual speaking public groups via electronic media excellent presentation negotiation skills work history informatica etlsql developer 022017 current gep chicago il working informatica power center tools designer repository manager workflow manager workflow monitor business glossary informatica lineage dvo analyzing customized package plsql code provided informatica provide solution lineage automation converting store procedure etl using informatica created incremental aggregated transaction fact used type 1 type 2 scd mappings update slowly changing dimension tables involved performance tuning source target mappings sessions system levels prepared migration document move mappings development testing production repositories using various transformations like filter expression sequence generator update strategy joiner stored procedure union sql transformation develop robust mappings informatica designer process data load using etl tool informatica grouped 4 batches initial load staging area initial load facts dimensions incremental data source systems staging area incremental load staging fact dimensions independent sessions creating ssis packages using pivot transformation fuzzy lookup derived columns condition split term extraction aggregate execute sql task data flow task execute package task etc generate underlying data reports export cleaned data excel spreadsheets text file ms access csv files data warehouse created sessions configured workflows extract data various sources transformed data loading data warehouse creating shared dimension tables measures hierarchies levels cubes aggregations ms olap analysis server ssas generating periodic reports based statistical analysis data various time frame division using sql server reporting services ssrs creating ssas olap cubes partitioning cubes monitored full incremental load using cube wizard gathering functional nonfunctional client requirements order optimize design bi deliverables reports dashboards alerts visualizations designing developing ssis packages loading data text files csv files sql server databases using ssis environment informatica power center 86 repository manager designer workflow manager workflow monitor obiee 10134 sql query analyzer 80 oracle 10g11g ms sql server sql developer windows unixlinux putty sql msbi developer 112017 022018 amazoncom inc maple grove mn designing conceptual logical physical data models data dictionaries metadata repositories working project management team prioritize business information reporting needs working enterprise data architects drive acceptance enterprise view data use coordinating dbas creating managing tables indexes table spaces sequences views materialized views generating ddl scripts using forward engineering technique create objects deploy databases partnering data governance data committees ensure implement common vocabulary understanding business entities relationships entities providing thought leadership areas advanced data techniques including data modeling data access data integration data visualization text mining data discovery statistical methods database design implementation developing documented data requirements design specifications form data models data mappings data quality metrics mapped structure organization relevant data aflac working internal customers business units understand business requirements business processes design data warehouse schemas define extracttranslate load etl processes data teams assisting analysis design development implementation logical data models physical database objects data conversion integration loading processes query reporting functions data management governance data quality assurance processes working collaboration data analysts etl developers provide source target etl requirements ensured efficient transformation loading assisting maintaining enhancing metadata infrastructure data dictionary business metadata facilitate publishing information business technical communities partnered business create appropriate business rules data usage environment informatica powercenter 951 oracle windows 7 idq sql developer 2005 unix plsql autosys business objects aix svn tidal wave analytics sql bi developer 062013 112014 web drills city determine appropriate research projects data collection methodologies identify retrieve manipulate relate andor exploit multiple structured unstructured data sets various sources including building generating new data sets appropriate demonstrated leadership adaptability willingness readily voluntarily take ownership challenging task problem even beyond initial scope responsibility thorough analytical skills capability apply data mining text analytics optimization skills solve business problems improve bidding strategy technology eg accurate efficient price volume auctionrate estimation design building tools scaling campaign management including automation design methodology extracting user insights location data develop maintains expertise msbi tools including excelpowerpivot ssis performancepoint ssas ssrs analysis large volumes transactional data speed collection cycles identify operational opportunities use advanced programming skills java python major languages build software solutionsservices including robust data pipelines dynamic systems environment oracle 10g918i7x ms sql server udb db2 9x teradata quality center sql queries siebel analytics oracle bi uml olap teradata sql assistant dbms jr software developer 122010 032013 web drills pvt ltd city expertise javaj2ee development use related technologiesframeworks develop optimize applications perform relation database development employing oracle plsql provide strong big data design development coding expertise large complex projects design code unittest application code using software development life cycle sdcl best practices design develop debug support complex data integration interfaces processes including stored procedure queries using various tools technologies including ssis ssas ssrs tsql msbi sql server technology complete estimates work plans collaboratively design development implementation rollout tasks create technical system documentation ensure documentation remains current throughout phases sdlc able work business users understand requirement convert technical design responsible coordinating design code reviews environment c net wpf windows forms ms sql server ms access xml entity framework masters computer information systems computer information systems bachelors degree computer science engineering computer science engineering education skills net agile aix analytical skills articulate automation big data bi business intelligence business objects business processes c c cognos client customer service data collection data conversion data dictionary data integration data management data mining data modeling dts data transformation service data visualization data warehouse dba databases database database design database development dbms designing dimensions dml documentation etl xml forms frame functional graphs db2 db2 9x informatica j2ee java leadership teambuilding linux managing access ms access c excel spreadsheets ms excel excel sharepoint windows 7 windows nt windows xp microsoft word migration modeling negotiation enterprise object oriented design olap optimization oracle developer plsql persuasive pivot tables processes coding programming project management speaker speaking python quality quality assurance reporting requirement requirements gathering research scaling scrum sdlc scripts siebel software development spss ms sql server sql sql server staff development statistical analysis strategy structured sybase system documentation tableau tables teradata tsql type 1 type 2 udb uml unix verbal communication skills view visio workflow excellent written additional information ability handle interact business users collect analyze businessfunctional requirements willing relocate anywhere authorized work us employer