Imagem de perfil de WardWarrior
@WardWarrior
Membro desde 9 de março de 2016
0 Recomendações

WardWarrior

On-line Offline
Hi, I have 8 years of experience completing Business Intelligence solutions for clients ranging from small to large companies across emergency services, marketing, healthcare, government, insurance, mobile, retail, hospitality and finance industries. Tools I am proficient with: SQL Server 2005-2016, SSIS, SSAS, SSRS, Power BI, Power Query, Tableau, Azure, Qlikview, Qliksense, Power Pivot, Redshift, Lambda, S3, Python, R, T-SQL, MDX, DAX Skills I have developed throughout my career: - Full life cycle of BI project - Requirement gathering - Data profiling - Data modelling - Packages and workflows to facilitate ETL - Create cube structure and data hierarchies - Design and implementation of insightful dashboards using various tools - Managing report user acceptance testing and reporting cycles - Troubleshooting development and production problems - Mentoring, 1to1 training sessions and group workshops to facilitate knowledge transfer
$25 Dólares/hora
1 comentário
0.6
  • 100%Trabalhos concluídos
  • 100%No Orçamento
  • 100%Pontualmente
  • N/ATaxa de Recontratação

Portfólio

Comentários recentes

  • imagem de basraasahb Power BI microsoft $20.00 USD

    “Andrew went above and beyond my expectations for the project. He made sure he understood the specifications and the deadline, produced results as promised on time. He was keen to make sure I understood how the dashboards worked, and how the data had been processed. One of the best freelancers! I will work with him again.”

Experiência

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

Educação

Computer Science

1997 - 2000 (3 years)

Qualificações

Securities & Investment Institute Securities Certificate (2006)

Siti

Securities Paper: Financial Regulation/ Principles of Financial Regulation

Certificações

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

Verificações

  • Conectado com o Facebook
  • Freelancer Preferencial
  • Pagamento Verificado
  • Telefone Verificado
  • Identidade Verificada
  • E-mail Verificado

Minhas habilidades principais

Pesquisar Freelancers similares