• Data architect data modelling and designing ETL and warehouse database for roadmap delivery projects (Marketing initiatives) • Built ETL in SSIS, SQL Server, stored procs and Microsoft Data Services, automated testing - Redgate • Lead BI developer leading offshore resource to build and deliver ETL and warehouse solution
Specialised in providing business intelligence and data analytic solutions for the global pharma industry ( Novartis ). • Taken on as lead BI Developer and data architect when previous lead left after the specification stage on Novartis Russia ( a Global Pharmaceutical) project • Acting as Data Architect designing the Data Warehouse (SQL 2012) and Data mart cube’s (SSAS 2012) dimensions ( 50+) and facts (300+) • Lead and developed ETL solution (SSIS 2012, SQL 2012) to populate Data warehouse • Designed and built SSAS solution and coding facts using complex MDX (2012) • Working with remote teams to deliver SFTP and Azure cloud based solution (SaaS) and reports (SSRS 2012, XLcubed) • Stakeholder management and mentoring of Russian clients both on site (Moscow) and remotely • Designing stored procedures and views to populate the data sources for the data mart.
Pharmaceutical Marketing with online doctors’ community. Senior BI developer and data analyst • Analysed, designed, developed, improved and stabilised BI platform (ETL SSIS 2008, data warehouse SQL 2008) , Data marts (SSAS 2008) Store Procs) • Took over Senior BI developer role allowing offshored activity to return in house to protect the business • Stakeholder management whilst delivering solutions developed on SSIS, SSAS, Excel linked Cubes & SSRS reports. • Architect, project manager and developer of SSRS data driven automated reporting of effectiveness of website campaigns • Data Analytics of doctors’ interaction with online messaging campaign ( SQL, Statistics) • Built REST APIs to read MongoDB data and then transform the data into SQL Server tables. • Analysed BI platform and delivered architectural roadmap to senior management. • Lead selection of new BI framework by reviewing Tableau, Qliksense, Pentaho BI, Wherescape’s RED, Informatica and SQL 2014.
Nissan Europe Marketing Web Application : Workshops with Nissan, designed SSAS cube and website structural changes, developed and led delivery of multi-million pound cloud based application in SSIS 2012, SSAS 2012, MDX and C# MVC and JQuery, JavaScript, HTML, CSS, Less, Angular JS. Chevrolet Europe: developed BI Marketing application in MVC, SQL and SSAS and technical lead for on /off shore team. Using SSAS, SSIS, MDX, MVC4 in C#, JQuery, JavaScript, HTML, CSS and Less.
Moss Plastics Ltd part of Essentra • Developed SSRS 2008 reports, designed SSAS cubes using Kimball's modelling. • Developed Sales , Orders and Logistics data warehouses using Wherescape's RED application to produce SSAS cubes (2008) accessed on Cognos connection web platform. • SQL 2008 database administrator, performance tuning indices, updates in stored procedures, creation and maintenance, backup plans and security.
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
A Pentalog account allows convenient access to our global price catalog featuring competitive prices for top software engineering and digital profiles.
Our catalog contains everything you need to build and scale a high-performing agile development team.
Why create a Pentalog account?
View transparent pricing for world-class developers
Build and price your development “dream team”
Compare pieces across 3 continents & 8 countries
Receive updates on available devs and special offers
Pro tip: Talk to a Pentalog Solution Specialist for help with technical profiles not listed in the catalog.