Robert Gaunt

Robert Gaunt Email and Phone Number

Senior Data Engineer at Lloyds Banking Group @ Lloyds Banking Group
london, greater london, united kingdom
Robert Gaunt's Location
Greater Cheshire West and Chester Area, United Kingdom
Robert Gaunt's Contact Details

Robert Gaunt personal email

n/a
About Robert Gaunt

SAS* Export reports to HTML to create a “Drill Down” reporting effect.• Experience in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS.• Experience in developing SAS procedures, macros, and applications for data cleaning, programming, reporting and documentation.• Extensive experience in Report formatting, Batch processing, Data Loading and Exporting (Using Libname, ODS and DDE).• Extensive experience with concatenating, interleaving, and merging SAS datasets.• Knowledge of Data warehousing and modelling concepts.• Experience in using Relational DBMS like Access, DB2, Oracle, SQL-Server and Netezza.• Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on UNIX, Windows and Mainframes environments.• Excellent problem solving skills for delivering useful and compact solutions. Always keen and eager to face up to challenges by means of innovative ideas.OBIEE* Bespoke VB Script for external emailing/exporting reports to network/ftp.* Bespoke VB Script for monitoring and re-starting services.* Upgrade from OBIEE10g to 11g (Including patches and “MAD”)• Experience modelling / building the OBIEE repository layers.• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.• Ability to discuss and utilize the architectural components of the tool (Security, aggregation, Logical columns, etc). • Experience with the migrating legacy and / or other BI tool reports to OBIEE.• Experience developing reports & dashboards in OBIEE using Answers.Cognos* Bespoke CSS, Javascript, HTML to increase user interaction within reports.* Integrated 3rd party software into report studio to add additional chart and widget types.• Experience developing reports & dashboards in Cognos Report Studio• Drill Through to create dynamic reports with different flavours/cuts.

Robert Gaunt's Current Company Details
Lloyds Banking Group

Lloyds Banking Group

View
Senior Data Engineer at Lloyds Banking Group
london, greater london, united kingdom
Website:
lloydsbankinggroup.com
Employees:
53179
Robert Gaunt Work Experience Details
  • Lloyds Banking Group
    Senior Data Engineer
    Lloyds Banking Group Jan 2023 - Present
    Chester, England, United Kingdom
    View
  • Lloyds Banking Group
    Senior Sql Database Administrator
    Lloyds Banking Group Mar 2021 - Jan 2023
    Chester, England, United Kingdom
    View
  • Lloyds Banking Group
    Sql Developer
    Lloyds Banking Group Nov 2015 - Mar 2021
    Chester, United Kingdom
    View
  • Mag (Airports Group)
    Business Intelligence Analyst
    Mag (Airports Group) Apr 2013 - Oct 2015
    Manchester, United Kingdom
    • Created operational, financial and retail reports/dashboards/iBots.• Created exception reports to highlight incorrect/missing data.• Maintained the user/group security model.• Created bespoke VB Script to email external customers.• Created bespoke VB Script to Export reports/dashboards to network/ftp locations.• Created bespoke VB Script to monitor OBIEE windows services, and re-start them if needed.• OBIEE 11g POC (proof of concept) installed/patched/configured, including MAD (Mobile App Designer) and Maps.• Currently upgrading Production 10g environment to 11g environment.• Modifications to config files to increase application performance.• Created automated Excel Reports to pull data from OBIEE using the GO URL Method (allowing filters to be passed).• Created High Usage reports to show reports/dashboards that might need improvements.• Created a Microstrategy POC.• Created a SSIS/SSAS/SSRS POC.
    View
  • Target Group
    Business Intelligence Analyst
    Target Group Sep 2012 - Feb 2013
    Chester
    *Created operational dashboard for each department with specific departmental reports.*Used Drill Through to display different cuts of reports from summary to agent level detail for ops performance improvement increasing payment percentages by 10%.*Bespoke CSS to change the look and style of reports to aid design and usability.*Bespoke Javascript to show/hide sections of reports (Using buttons).*Bespoke HTML to create a scrolling marquee Newsflash on reports dynamically highlighting agent with best performance.*Integrated www.fusioncharts.com into report studio for additional charts and widgets using HTML, Flash and Javascrip.*Scheduled reports to run via Cognos Scheduler.
    View
  • Vertex Financial Services
    Mi Analyst
    Vertex Financial Services Dec 2011 - Sep 2012
    *Re-developed the arrangements datamart and produced a suite of Arrangements Scorecards giving more accurate and detailed performance increasing performance within departments which included the Collector Incentives Scorecard.*Developed the Complaints Database with a full suite of Complaints Reports in accordance with FSA compliance.*Enhanced existing programs to increase performance from 6 hours to 30 minutes.*Created Data Integrity reports identifying where procedures are not being followed.*Created control file batch reporting (Daily, Weekly and Monthly).
  • Virgin Media
    Mi Analyst
    Virgin Media 2001 - 2010
    SAS*Created data validation and control file batch reporting.*Performed SAS programming required for data analysis and reporting in UNIX environment.*Created routine customer mailing list for Direct Mailing.*Developed macros and views to integrate complex business rules. *Maintained and enhanced existing SAS reporting programs. *Presented the results and statistical reports in “Drill Down” HTML pages. *Migrated and made changes in SAS programs, to make them work in Unix without losing their functionality*Created, updated and maintained tables views and indexes*Modified the existing SAS programs to save time and resources*Used different SAS procedures like proc tabulate, proc report, proc sort and proc transpose for different utilities.*Used SAS procedures and preparing daily, monthly, yearly reports. OBIEE*Involved in the design of the data warehouse.*Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.*Designed, Created and Tested Report in the Dashboard and created the adhoc report according to the client needs*Designed, Developed and Tested Data security and Dashboard security in OBIEE*Migrated code from Dev to Test and Test to Production of Repository, Dashboard Reports and workflows.*Involved in meeting with business representatives for requirement analysis and to define business and functional specifications.*Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.*Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.
    View

Robert Gaunt Skills

Obiee Sas Sql Cognos Business Intelligence Javascript Sas Programming Business Intelligence Tools Data Analysis Database Design Microsoft Sql Server Requirements Analysis Oracle Sparx Enterprise Architect Vba Php Joomla Css Xml Sas Base Kimball Data Warehousing Databases

Robert Gaunt Education Details

  • Plessington High School
    Plessington High School

Frequently Asked Questions about Robert Gaunt

What company does Robert Gaunt work for?

Robert Gaunt works for Lloyds Banking Group

What is Robert Gaunt's role at the current company?

Robert Gaunt's current role is Senior Data Engineer at Lloyds Banking Group.

What is Robert Gaunt's email address?

Robert Gaunt's email address is ro****@****iko.com

What is Robert Gaunt's direct phone number?

Robert Gaunt's direct phone number is +4416148*****

What schools did Robert Gaunt attend?

Robert Gaunt attended Plessington High School.

What skills is Robert Gaunt known for?

Robert Gaunt has skills like Obiee, Sas, Sql, Cognos, Business Intelligence, Javascript, Sas Programming, Business Intelligence Tools, Data Analysis, Database Design, Microsoft Sql Server, Requirements Analysis.

Who are Robert Gaunt's colleagues?

Robert Gaunt's colleagues are Simone Mcdonald, Olufemi Dosunmu Cii Dip, Marty Caldwell, Harriet Katy Benn, Kate Parsons, Marianne Mcintosh, Laura King.

Not the Robert Gaunt you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.