professional summary jessica claire montgomery street san francisco ca 94105555 4321000 resumesampleexamplecom certified python programmer tibco spotfire architectengineer extensive years rdbms programming covering aspects backend processes relational data model dimensional data model oltp olap cubes sqletl testing strong understanding spotfire api ironpythonpython scripting terrr programming cnet sdk extensions great professional attitude communication skills efficiency sdlc methodologies agile rup applied teamplayer mentality strong ability use tibco spotfire architectural components web player server spotfire server information designer library administration administration manager spotfire database inmemoryindb storage work history skills note ironpythonpython scripting spotfire api dynamic visuals d3js visuals user interactions web services restful services file io dynamic images text area dynamism rdbms operations custom python modules tagging analysis color customization dynamic data tables algorithms guidedanalysis data security parameterizedscript analysis log monitoring data manipulation dxp state manipulation ability innovate improvise new designs techniques spotfire terrplatformr programming terr data functions expression functions rstudio ability use rscripts analytics datawarehouse conceptual logical physical data models entityattribute relationships cardinality optionality dependencies oltp olap staging ods maintenance relational model normalization analytical sql programming sql ability work design data quality maintenance aspects datawarehouse tibco spotfire core techniques ondemand load custom expressions calculated columns dynamic visualizations information links usergroup administration application profiler documentdatatablecolumn properties data functions ironpython scripting sdk customization geoanalysis geocoding coordinate matrix systems html css javascript d3js visuals ability create appealing visualizations dxps programming objectorientation javac scripting python r rdbms sql programming sql ability work various programming concepts statistical tools r python tibco spotfire database oracle sql server teradata ms access hadoophdfs nosql hbase operating systems unix windows xp199820007 html css javascript j2ee java rest api programs microsoft office suite word excel powerpoint access outlook ms visio tibco spotfire developer vmlyr hoboken nj 052015 current project clinical data trials data captured via edc electronic data capture batch processing via oracle clinical engine analysis via tibco spotfire platform tableau reporting key features project database locks interims last data generated patient visits key data attributes python java sql r key environment also including oracle informatica db2 db visualizer ms excel xml agile macros vba business objects ms office suite ms sharepoint mainframe technology autosys sas files created bi specifications clinical trials database lock metrics ldg last data generated fplv first patient last visits interim database locks interim data cut offs created job file xml module automate reporting tasks reviewed edc electronic data capture process gathering clinical trials data created information links prompts ondemand loads transformations joins parameterizations connecting data sources files designed folders spotfire library administered usersgroups analyzed backend spotfire database tracked memorycpu usages spotfire server webplayer server incorporated custom python modules spotfire server utilize python library full custom functionalities used d3js datadriven documents interactive appealing visuals utilizing html text area features javascript html css ironpython designed specifications custom functionalities dynamic visualizations within dxps manipulated data tables columns rows cell values document properties document metadata filters markings using ironpython achieve interactions created specifications data transformation information links custom expressions calculated columns data wrangling python r scripts terr advanced custom expressions worked statisticians utilize r scripts incorporate spotfires terr engine writing data functions expression functions tilcco spotfire developer deutsche bank city state analytics project involved financial data relevant auditing accounting 082013 042015 backend framework involved hortonworks based platform comprising hadoop batch processing big data major languages involved pig latin apache hive analytics platform involved tibco spotfire python customization information links import key metrics involved financial data entities sources included sql server relational data plus various file formats incoming external clients tracked data quality issues reporting requirements jira tool quality center modified existing database models relational dimensional databases created conceptual logical physical data models depict level granularity measures distribution dimensions analyzed feasibility hadooplike architecture analyze high volume data per big data analytics concepts used standalone hadoop mode run initial mapreduce job created specifications data transfer hdfs sftp ftp http smtp web servers created technical specification running hadoopmapreduce jobs via pig latin apache hive fully distributed mode assessed feasibility nosql storage via hbase created specifications realtime streaming processing using apache kafka apache storm created specifications hdfs architecture filefolder architecture reviewed open source apache hadoop projects information knowledge transfer used linux command line interface run hadoop commands grunt shell scripts run pigsql scripts grep commands query plain text data linux shell commands untar files database ecosystem created information links load data demand controlled document properties expressions limiting parameterization used javascript d3 library create visualizations sourcing json file formats created map charts comprising map layers feature layers based geocoding tables co ordinate matrix systems wrote ironpython scripts customize dashboards implementation tagging analysis document properties manipulation visualization properties manipulation table manipulation filedata manipulation used html css along javascript features design text areas used web player configuration control initial state dashboards used marking filtering selection via ironpython scripts automate functionalities dashboards tested usage analysis comprising memory usage cpu usage network usage usergroup activities library activities created calculated columns custom expressions manipulate data loaded spotfire wrote hive ql load data demand hortonworks hive metastore sfotfire developer loreal corporate city state 2011 072013 projects primary goal convert ssas cube reports spotfire dashboards visualizations total number cubes around 30 dashboards covered metrics related production inventory customer segmentation inbuilt spotfire features used along customization via ironpython scripts created nonspatial geographical distribution charts mapcharts display metrics via geocoding coordinates mapping used ironpython scripts loop filters markings visuals data columns build customized functionalities within spotfire documents used spotfire library administrator manage folders dxp files information links connectors installed configured sql server connector sap hana connector ssas connector others create indb connections used spotfire automation services create automated jobs via xml builds scheduled daily weekly basis managed users groups privileges security spotfire environment using ldapspotfire fusion developed custom data source via sdk module google analytics connection wrote custom expressions visualization axes calculated columns property controls limit expressions created custom text areas via html scripts javascripts used advanced data services ads cisco composite servers create data virtualization layers designed information links mimic inmemory connections daca analyst trowe price city state 102009 112010 compliance data quality project assess define gaps quality equities securitiestrades data created sprint logs agile mode work monitored weekly autosys jobs dev qual prod regions created job file xml module automate reporting tasks created technical specifications modification informatica mappings created technical specification list data profile including constraints indexes views sequences synonyms cardinalityoptionality measures metrics dimensions referential integrity aggregations calculations transformations statistical modeling order predesign data load source target monitored informatica session logs order assess rectify data cycle errors address data quality issues assessed existing data marts designed bridge tables connect different data tables modified source qualifier queries informatica mappings used analytic functions statistical functions via sql analyze process data aggregate level including rollups cubes grouping sets used dml ddl statements via sql manipulate define data sets used joins subqueries set operators via sql cross analyze data across multiple tables used substitute functions character functions numeric functions conversion functions date time functions pivots hierarchies aggregation via sql modify data column values used data security languages data transaction control languages via sql written test strategies test cases asses informatica code changes including initial code debug converted business objects adhoc reports dashboards visualizations pie chart bar chart pivots line charts crosstables heatmap maintained source data flow using excel macros flat files relational tables accessed files mainframe system used informatica etl created technical specification insert else update process part slowly changing dimensions used data profiling services sql server 2008 document column null ratio profile column statistics profile column value distribution profile column length distribution profile column pattern profile reviewed informatica powercenter designer mappings informatica workflow manager workflows sessions autosys job scheduling informatica workflow monitor session logs jaca developerpython programmer jp morgan chase city state 072008 102009 project involved creating ui application used mortgage line business java python sql three key frameworks used java fundamentals core java techniques design maintain application codes used java hibernate jsp principles create frontend user interface communication layer rdbms used python data processing logics derive analytical data transactional sources regulatory submission used sql validate data quality accuracy backend education master science informtation technology goldey beacom college wilmington de bachelor science technology kathmandu university dhulikhel nepal aug 2015 sep 2007