websites portfolios profiles jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary certified ibm cognos report designer metadata models consultant total 8 years work experience including 5 years experience analysis design development testing production support proficiency data warehousing environment business intelligence systems cognos tableau power bi worked multiple domains like banking healthcare insurance manufacturing retailing automotive fleet pharma gas oil industries skills cognos 10x8x report studio query studio analysis studio event studio workspace advanced business insight cognos connection bi tools tableau 8 desktop power bi data modeling framework manager power play transformer starsnowflake schema teradata ms sql server oracle db2 ms access greenplum sql plsql xml html javascript teradata sql assistant plsql developer toad ms visio work history 112014 current senior bi application developer microstrategy dallas tx agility hp alm itsm passport legal infor m3 ms office suite jpmorgan chase one oldest financial institutions united states history 2 centuries jpmc leader investment banking financial services consumers small businesses commercial banking financial transaction processing asset management ive involved multiple projects multiple line businesses delivered many reports users using cognos tableau bi tools integrated consumer data warehouse extensively interacted business users understand reporting needs created business requirements documentscap mats conducted reviews requirements business users worked team members analyze data coming multiple source systems build reporting solutions per requirements analyzed business needs created complex cognos reports created visualizations dashboards using tableau multiple lobs business banking consumer banking cwm interacted business user group provided technical assistance business driven sustainable reports using cognos tableau reporting tools participated data modeling business process analysis developed cognos framework manager packages published use report development created many financial reports delinquency trends credit loss trends cc npl scored strategies portfolio reports scored graded credit kri national regional trends weekly monthly reports etc integrated consumer data warehouse developed complex reports multiple graphs crosstabs list reports customized reports output multiple prompt pages applied multiple cognos report functionalities master detail relationships report bursting drill updown reports cascading prompts conditional formatting etc modified existing report template used layout component reference objects use across multiple lob report development documented developed tableau dashboards worksheets using calculated fields parameters quick filters groups sets bins custom hierarchies developed tableau data visualization using bar charts line charts heat maps scatter plots geo maps crosstabs bubble charts area charts donut charts etc mastered different formatting techniques tableau using annotation mark labels tool tips etc applied different actions filter highlight url tableau dashboard user customizations connected tableau server publish dashboards central location portal integration involved scheduling distributing reports schedule management cognos connection helped setting jobs controlm helped admin team migrating reports multiple environments created report wireframesprototypes using data generator tool unit test documents report design fm model design documents run books report auditing purpose assisted qa team creating report test cases extensively wrote sql queries report validation monitored assigned reports delivery design phase delivery phase using hp alm tool extensively involved report performance tuning fixes deployment issues environment cognos 1021 framework manager report studio query studio workspace advanced tableau 827 teradata teradata sql assistant informatica hp alm itsm controlm data generator tool 022014 102014 senior cognos consultant two95 international inc sacramento ca wellcare provides health plans families children exclusively providing managed care services governmentsponsored programs medicaid medicare company approximate 39 million members wellcare understand special needs challenges know communities live well ive involved multiple projects includes building framework manager model building complex reports modifying existing reports based intake requests performance tuning analyzing specifications provided business users developing specification documents reports per client requirements created technical specification documentation reports worked remediation icd9 reports ive modified reports include future diagnosis version icd10 along icd9 conditional formatting per new business requirement modified existing relational model memberships claims framework manager part report remediation developed reports memberships claims includes lists complex crosstabs charts drill reports conditional blocks masterdetail conditional formatting reports using report studio worked agile environment project called hix developed framework manager model build reports created standalone filters embedded filters creating model using cognos framework manager extensively used prompts filters cascading prompts calculations conditional variables multiple queries reports created dashboards cognos portal everyday access easy identify history projections standardized prompt pages consistent user experience let users choose different filters used plsql developer writing sqls oracle agility tool connect greenplum database data validation testing tested validated report output database measure performance reports created unit test plan documents tested result documents used service manager close tickets opened users teams involved scheduling bursting reports actively involved report testing production support environment 102013 022014 senior bi consultant circle k stores inc ambridge pa weatherford one largest international oil natural gas service companies weatherford provides products services drilling evaluation completion production intervention oil natural gas well worked passport report development project developed complex reports modified existing reports legal department worked directly users business requirements created functional technical documents report development primarily worked cognos integration project client legal department report development also worked finance department developed sample reports using cognos 101 report studio created modified list crosstab reports client matter management system developed prompt pages cascaded prompts also worked customization prompt parameters developed multi query multi prompt reports using conditional blocks various filters implemented advanced features master detail relationship conditional formatting page set report bursting using cognos report studio created drillupdown drill reports detail reporting modified existing framework manager model report development performed cognos administration security tasks environment 072012 092013 senior cognos developer acushnet company city state acushnet company comprised titleist foot joy golf brands leading manufacturer marketer golf balls golf clubs golf shoes golf gloves involved ags project developed many reports multiple divisions client developed reports different functional areas finance sales marketing distribution etc worked closely different business teams gather requirements prepared functional technical documents uat process created list crosstab chart reports using report studio support finance sales marketing functional areas developed complex reports using different features like slice dice drill capabilities queries master detail multilingual reports created query prompts calculations conditions filters implemented report bursting distribute reports effectively involved scheduling report studio sending reports via email several business users created adhoc reports like grouped list reports crosstab reports using query studio also created documentation processes involved like applying security reports deployment portal customization etc created multiple layout component objects incorporated reports migrated cubes reports c8 version c10 created jobs schedule reports cognos connection consolidated multiple dashboards one making use conditional blocks selfdrill experience writing htmljava script cognos report studio reports per requirements added data security object row level security according requirements created database layer physical layer presentation layer defining appropriate relationships tables environment 2012 072012 senior cognos report developer mike albert fleet solutions city state mike albert fleet solutions one largest fleet management providers nation offering superior customer service implementing innovative business solutions clients 50 states involved mostly troubleshooting existing issues related different types reports fleet expenses orders contracts inventory involved creating new reports customers analyze business increase profits analyzed reviewed business requirements technical specification documents report development extensively involved troubleshooting complex reports modified existing report designing according new business requirements created list crosstab various graphical presentation reports incorporated different reporting functionalities master detail cascading prompts drill drill multiple reports created multiple prompt pages using java scripts validate data report narrowing report output extensively implemented complex reporting functionalities using conditional formatting conditional blocks using multiple variables parameters created multiple report templates help developers create new reports according company standards created read documents created multiple utp documents report testing involved performance tuning complex reports analyzed cognos sql native sql participated building customer portal site web development team worked third party tool motio control different versions cognos reports used migrate reports different environments involved automated testing cognos reports using motio environment 072011 2012 cognos developer corning inc city state corning incorporated world leader specialty glass ceramics proven track record first market breakthrough innovations involved multiple projects largely dealing creating modifying reports inventory shipment sales client products business units customers order details project also involved migration cognos applications c7 c 8 version analyzed business requirements analysts created modified various list reports grouped reports crosstab reports drillthrough reports developed reports using various functionalities like master detail conditional formatting conditional blocks multiple prompts working closely etl developers building data marts per requirements created global graphical reports view analyze companys corporate performance implemented various prompts parameters filters calculated measures aggregations conditions created reports using subqueries multiple queries testing improving report performance performance tuning complex reports report level customized cognos connection appropriate reports security measures developed relational dimensional models framework manager defining relationships query subjects maintaining data integrity manually modified sql report studio tune andor write complicated reports involved migration cognos bi applications version 7x 84 migrated cubes cognos 74 version cognos 84 resolved issues occurred migration reports previous versions cognos 84 used framework manager build models packages publish packages cognos server scheduled reports power play cubes run daily weekly monthly basis handled security administration cognos connection portal environment 092010 072011 chemistasst manager canalis medical pharmacy city state identifies resolves drug related issues suppliers providers assisting registered pharmacist organizing control substances inventory gathered entered data billing invoicing department maintained organized database using software ms access sql server provide correct patient records developed inventory tracking reports monthly basis performed annual inventory including preparation first barcode reporting environment recorded test results using variety chemistryspecific software programs 102008 082009 asst manager reliance pharmacy services city state worked assistant pharmacy store manager long term care pharmacy implemented pharmacy policies procedures assisting pharmacy staff needed provided frontline leadership achieving ongoing quality productivity efficiency long term care implemented pharmacy software applications billing data entry maintained databases generate organization growth reports conducted meetings company business contractors like hospitals nursing homes group homes future business development designed report layout data sorting defining subtotals reports using sql server environment assisted pharmacy staff drug inventory purchasing receiving correctly completed pharmacy paperwork including daily weekly reports worked closely pharmacy care representatives pcrs providing excellent patient care directly supervised number pharmacy technicians interns support staff duty education 2008 2005 mba health care administration university findlay findlay oh bachelor science pharmacy kakatiya university india pharmacy certified ibm cognos 10 bi report designer certified ibm cognos 10 metadata modelscertified base sas programmer certification certifications ibm cognos 10 bi report author