Lydia Peter

Lydia Peter

Application Lead

Followers of Lydia Peter410 followers
location of Lydia PeterMission, British Columbia, Canada

Connect with Lydia Peter to Send Message

Connect

Connect with Lydia Peter to Send Message

Connect
  • Timeline

  • About me

    Information Technology Specialist at UST

  • Education

    • Mahatma Gandhi University, Kottayam

      2001 - 2005
      Bachelor of Technology - BTech Computer Science
  • Experience

    • Wipro Technologies

      Nov 2006 - Aug 2014
      Application Lead

      • Built program for a financial institution to publish their quarterly report to Monitory Authorities of government. This report collects information for the total credit card and loans users, implement the business rules to calculate the total & rollover balances for credit card and loans funded by the bank.• Implemented the application to regularly monitor the branches with lesser transactions. This application helped the business team to review and enforce the business strategies either to increase the performance or to close the low performing branches.• Developed Business Intelligence Platform (BIP) to streamline Data Management process in a consolidated and consistent platform to make it accessible across CBG (Consumer Banking Group) markets.• Fabricated Financial reports/statements for the business team for the reconciliation needs. Show less

    • UST

      Aug 2014 - Sept 2021

      • Designed and developed a new application for analytical reporting for the needs for Department Specialists. This report provides an accurate visibility into all recently estimated and collected vendor funds by type, timeframe, and structure to align with the business KPIs. Integration with Datastage 11.5 and snowflake (Snow sql, Snow pipe) and Power BI for visualization.• Built a standardized process in to reveal the discrepancies in billing. This process helped to address/reduce the payback invoices worth ~2M CAD.• Improved the performance of a straight-through ELT process by redefining the data process flow. Redefined program reduced the runtime from 36 hours to less than 10 hours.• Built automated process by encapsulating complex Sql in Linux framework for frequently requested ad-hoc queries by business.• Involved in Business Analyst activities for gathering business requirements by conducting detailed interviews with business users, stakeholders, and SMEs, to gather the requirements and convert business requirements into technical design.• Built trusting relationship with business stakeholders to ensure the deliverables meet the stipulated SLA.• Actively participate and contribute to the internal data analytics projects and proposals.• Conducting regular retrospective meeting and ensuring the project activities are accomplished within approved time frames, scope, and adhere to defined standards and guidelines.• Contributed for defining best practices. Created and maintained documentation at all phases of the projects using web-based corporate wiki like Confluence and SharePoint. Show less

      • Technology Specialist

        Apr 2016 - Sept 2021
      • Senior Systems Analyst

        Aug 2014 - Apr 2016
    • The University of British Columbia

      Sept 2021 - Jun 2024
      • Senior Programmer Analyst

        Sept 2023 - Jun 2024
      • Data Conversion Analyst

        Sept 2021 - Sept 2023
    • UST

      Jun 2024 - now
      Information Technology Specialist
  • Licenses & Certifications

    • Datastage 11.5

      IBM
    • Informatica PowerCenter

      Informatica
    • Teradata BTEQ

      Teradata
    • Oracle Advanced PL/SQL Developer Certified Professional

      Oracle
    • Datastage 8.x

      IBM
    • Teradata FLOAD

      Teradata
    • Teradata MLOAD

      Teradata
    • Programming Foundations: Secure Coding

      LinkedIn
      Mar 2021
      View certificate certificate
    • Learning Secure Payments and PCI

      LinkedIn
      Mar 2021
      View certificate certificate
    • Version control tools

      Micro Focus
    • SQL Essential Training

      LinkedIn
      Mar 2021
      View certificate certificate
    • Learning Security Frameworks

      LinkedIn
      Mar 2021
      View certificate certificate
    • Power BI Data Modeling with DAX

      LinkedIn
      Jul 2021
      View certificate certificate
    • International certification in Teradata V2R12 (Teradata certified SQL specialist)

      Teradata
      Jul 2011
    • Microsoft Certified: Azure Data Fundamentals

      Microsoft
      Apr 2023
      View certificate certificate
    • Learning the OWASP Top 10

      LinkedIn
      Mar 2021
      View certificate certificate
    • Certified ScrumMaster® (CSM®)

      Scrum Alliance
      May 2022
      View certificate certificate