WardWarrior adlı kullanıcının profil görüntüsü
@WardWarrior
9 Mart 2016 den beri üye
0 Tavsiyeler

WardWarrior

Çevrimiçi Çevrimdışı
Hi, I have 10+ years specialising in analysing company data and presenting business insights using visualisation tools. Creating dashboard reports showcasing how your business's KPI is currently performing or producing historical/investigative analysis to find trends and improve business processes. As a senior consultant, I understand the key performance areas across various industries including marketing, finance, retail, healthcare, government, insurance and hospitality industries. Data Analysis & Visualizations - Ten years working with various software solutions to analyse databases, create reporting queries and developing dashboards (including MSSQL, Azure, SSRS, SSAS, SSIS, Tableau and Power BI).
$25 USD/hr
4 değerlendirme
2.9
  • 100%Tamamlanmış İşler
  • 100%Bütçe Dahilinde
  • 100%Zamanında
  • N/ATekrar İşe Alım Oranı

Portföy

Son Değerlendirmeler

Tecrübe

BI Developer

Jun 2017

• Leading workshops to create project requirements and refinement with stakeholders based worldwide • Design of ETL scripts to facilitate data quality control for various client’s data sources and KPI • Creation of ETL process across Python, Redshift, Lambda, S3, QlikSense, Power BI and custom API scheduler • Writing of complex stored procedures to calculate conditional and hierarchical KPI • Analysing trends of customer product usage to determine client specific KPI

BI Consultant

Aug 2016 - Jan 2017 (5 months)

• Design and built cube to support end user requirements • Create cube structure and data hierarchies using MDX (SSAS) • Designing Report Content in SSRS • Validating and disseminating reports in the correct format to strict deadlines • Managing Report User Acceptance testing and reporting cycles • Additional dashboard/report refinement and development

Lead BI Developer

Sep 2014 - Jul 2015 (10 months)

•Developed BI solution within an Agile Scrum Environment using SQL Server (2008R2), SSIS, SSRS, QlikView and Power BI • Extensive profiling to determine data integrity • Developed complex packages and workflows to facilitate ETL • Staging database developed for data cleansing and data standardisation • SSIS package developed to deal with all data cleansing, isolating duplicates and invalid records, standardisation of data-types and formats

Lead BI Developer

Oct 2013 - Jan 2014 (3 months)

Consultant to provide standards and knowledge transfer for advanced SSRS reporting • Design and implementation of source database mirroring to improve report and application performance • Workshops to facilitate knowledge transfer on advanced SSRS techniques to facilitate future reporting requirements • Mentoring and 1 to 1 training sessions for individual developers in advanced techniques • Documented standards and procedures for the department and development team

Lead BI Developer

Dec 2012 - Oct 2013 (10 months)

• Full life-cycle data-warehouse project • Workshops to gather data-feed and reporting requirements • Scrum master responsible for five BI developers • Updated and migrated current report structure of 200+ reports to new server (SSRS) • Produced reports in SSRS from Cubes to demonstrate development capabilities • Workshops to demonstrate new processes and functionality • Knowledge transfer and standards on ETL and cube design

BI Developer

Nov 2011 - Nov 2012 (1 year)

Developed BI solutions using SQL Server (2008R2), SSIS, SSRS • Facilitated workshops to build requirements and engage stakeholders • Interviewed heads of Divisions to produce analysis based on each divisions unique services and contracts • Extensive profiling to determine data integrity • Developed complex packages and workflows to facilitate ETL • Dynamic extraction from a number of data sources including flat file, SQL and

Eğitim

Computer Science

1997 - 2000 (3 years)

Nitelikler

Securities & Investment Institute Securities Certificate (2006)

Siti

Securities Paper: Financial Regulation/ Principles of Financial Regulation

Sertifikalar

  • SQL Level 1
    85%
  • US English Level 1
    85%

Doğrulamalar

  • Facebook Bağlantılı
  • Tercih Edilen Freelancer
  • Ödeme Onaylı
  • Telefon Onaylandı
  • Kimliği Doğrulanmış
  • E-posta Onaylı

Başlıca Becerilerim

Benzer Freelancerlara Göz At