Keith Ramnanan

Data Engineer | SQL Expert | Professional Data Wrangler

Trinidad and Tobago

About

A well-rounded IT professional with almost 10 years industry experience in collecting, organizing, interpreting and disseminating various types of data. Most recently, helping the Caribbean's leading airline to enter a new era of data-driven decision making by pioneering a modern data warehouse infrastructure and facilitating access to never-before seen insights from their large scale data.

Experience

  • Information Services Analyst at Caribbean Airlines Ltd
    Jul 2018 - Present · 8 yrs

    • Developed and implemented major transformational data-related projects to ensure information is available and accessible to all internal and external stakeholders. • Responsible for creating, deploying, monitoring SSIS catalogs and Python ETL data pipelines for extracting, transforming and loading large scale data from multiple structured and unstructured data sources into a central data warehouse. • Write and tune code on large datasets for long term reusability and performance. • Advanced T-SQL querying, data wrangling/ data modeling. • Designing and deploying automated business intelligence reports and dashboards using SSRS and Power BI. • Architected and pioneered the Airline’s modern data warehouse (DWH) and business intelligence platforms to ensure the successful execution and continued alignment with the company’s architecture and data management direction.

  • Database and Report Analyst | ACE IT Technician at Sunny Group of Companies
    Sep 2013 - Jun 2018 · 4 yrs 10 mos

    Database and Reporting Responsibilities • Manage multiple SQL Servers with highly transactional Casino databases across the Caribbean. • Interpret Casino betting data, analyze results using statistical techniques and provide ongoing reports • Write custom SQL queries and use SSRS to create custom reports • Develop and implement data collection systems and other strategies that optimize statistical • Acquire data from primary or secondary data sources and maintain databases/data systems • Filter and clean data, and review computer reports, printouts, and key performance indicators to locate and correct code problems. • Work closely with management and player development departments to prioritize business and information needs • Locate and define new process improvement opportunities • Liaise with systems vendors to ensure reporting systems are properly implemented and resolve any issues with current reporting systems • Train staff on reporting systems on current or new reporting\database systems Business Applications/Related Hardware • Continuously monitors all business applications and related hardware in order to ensure that the network is up and running with minimum down time. • Troubleshoot issues and either independently resolve or work with service providers to ensure timely resolution of issues. • Monitor and analyze system logs, identify and resolve potential issues • Apply operating system updates, patches and configuration changes. • Monitor all software licenses, process renewals in a timely manner and maintain an updated summary list • Perform hardware and software upgrades as required Maintains Active Directory/E-mail • Add, remove and/or update user account information, including resetting passwords. • Assign folder permissions and maintains updated list of permissions granted Back Up of System • Ensure all the Corporation’s data is backed up and stored as per established policy and procedures.

  • Graphic Designer at New Edition Printers
    2004 - 2014 · 10 yrs

    Freelance work - Designs of Business Cards, Fliers, Wedding Cards, Invitations, Programs, Tickets, Magazine and Newspaper ads, brochures, banners, logos, Receipt Books etc., for mass print PC Repair and Maintenance

  • Graphic Designer/ Desktop Publisher at Belgrove's Group of Companies
    Apr 2013 - Sep 2013 · 6 mos

    • Designs for All Funeral Material, Marketing and promotional items, Funeral Programmes, Video Memorial Tributes, bookmarks, cards, banners, etc. • Web-streaming, Camera Production, Video Editing, Media-shout

  • Office Assistant /Clerk at Princes Town Regional Corporation
    Oct 2009 - Oct 2011 · 2 yrs 1 mo

    OJT