Bonny Varghese

Senior Consultant - Cloud datawarehouse for ADT at MSH
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Bengaluru, Karnataka, India, IN
Languages
  • English Full professional proficiency
  • Hindi Full professional proficiency
  • Malayalam Full professional proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Ricardo Martín Planelles

I had the opportunity to work with Bony during a challenging project. He was looking always for the excellence, being proactive and collaborative with the team. He was a key person for the project succes, being a reference not only internally but also with the customer. On top of that, he is a very positive person with I enjoyed to work with.

Subhas Modi

Bonny, It was a real pleasure working with you as my team lead on the Global HR Data Hub project for the Japanese pharmaceutical company. I could always rely on you to manage the tasks and the timeline in the project plan and ensure the work was being well coordinated by you among the 4 developers under your supervision. You mentored the team, reviewed their work, ensured best practices were being followed, overlooked System and End-to-End testing and ensured the status was always accurately reflected. Your risk management of the tasks was excellent - you were forward looking and making sure any obstacles were addressed will in advance so as to not impact the project. Your technical skills were always evident as you carefully reviewed all designs of all Informatica Mappings and Oracle stored procedures and DDL scripts. Go-Live was uneventful because of the attention you paid to all the small details and ensuring they were carefully addressed and tested. Best of luck in your career !!

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Hands On Essentials - Data Warehouse
    Snowflake
    Aug, 2021
    - Nov, 2024
  • Flowgear Technical Certification
    Flowgear
    Jul, 2021
    - Nov, 2024
  • Microsoft Certified: Azure Fundamentals
    Microsoft
    Nov, 2020
    - Nov, 2024
  • Redis Labs | RU101: Introduction to Redis Data Structures
    Redis Labs
    May, 2020
    - Nov, 2024
  • PowerCenter Data Integration 10: Developer, Specialist
    Informatica
  • edX Honor Code Certificate for Introduction to Python for Data Science
    edX

Experience

    • United States
    • Business Consulting and Services
    • 1 - 100 Employee
    • Senior Consultant - Cloud datawarehouse for ADT
      • Jan 2022 - Present

      • Develop and implement ETL solutions for cloud data warehousing and DW modernization projects. • Utilize Informatica IICS and Google BigQuery for ETL development and data management. • Design and execute API integration projects using Informatica IICS. • Implement mass ingestion jobs to synchronize data between Salesforce and Google BigQuery. • Leverage expertise in Call to Lead generation subject area for data analysis and reporting. • Schedule, monitor, and manage ETL jobs to ensure timely data processing. Show less

    • United States
    • Financial Services
    • 700 & Above Employee
    • Associate Specialist
      • Dec 2019 - Dec 2021

      • Act as ETL consultant to manage field analyst compensation data for a US-based banking client. • Collaborate closely with client architects in a client-facing role. • Manage end-to-end ETL pipeline for the project, incorporating changes and updates as needed. • Develop ETL mappings, Oracle PL/SQL scripts, and Unix scripts for project requirements. • Utilize GIT versioning tool to manage source code and project artifacts. • Act as ETL consultant to manage field analyst compensation data for a US-based banking client. • Collaborate closely with client architects in a client-facing role. • Manage end-to-end ETL pipeline for the project, incorporating changes and updates as needed. • Develop ETL mappings, Oracle PL/SQL scripts, and Unix scripts for project requirements. • Utilize GIT versioning tool to manage source code and project artifacts.

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Lead Consultant
      • Dec 2017 - Nov 2019

      • Consult on ETL processes for managing credit card data for a US-based banking client. • Conduct proof-of-concept for handling mainframe data using Spark packages. • Manage the integration of new source systems into the data warehouse. • Develop and optimize Informatica PowerCenter mappings, data flows, and performance tuning. • Write Oracle SQL/PLSQL queries for data analysis and mapping development. • Create Unix shell scripts for handshake processes and quality control checks. • Consult on ETL processes for managing credit card data for a US-based banking client. • Conduct proof-of-concept for handling mainframe data using Spark packages. • Manage the integration of new source systems into the data warehouse. • Develop and optimize Informatica PowerCenter mappings, data flows, and performance tuning. • Write Oracle SQL/PLSQL queries for data analysis and mapping development. • Create Unix shell scripts for handshake processes and quality control checks.

    • Ireland
    • Business Consulting and Services
    • 700 & Above Employee
    • Senior Analyst
      • Jan 2014 - Dec 2017

      • Act as ETL consultant for IFRS implementation for a Sweden-based telecom company. • Develop HR data hub for a US-based pharmaceutical company. • Lead a team of 4 ETL developers, coordinating activities and ensuring effective client communication. • Assess existing environment and identify new requirements and opportunities for improvement. • Collaborate with reporting teams to deliver high-quality solutions. • Act as ETL consultant for IFRS implementation for a Sweden-based telecom company. • Develop HR data hub for a US-based pharmaceutical company. • Lead a team of 4 ETL developers, coordinating activities and ensuring effective client communication. • Assess existing environment and identify new requirements and opportunities for improvement. • Collaborate with reporting teams to deliver high-quality solutions.

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Programmer Analyst
      • Jan 2011 - Jan 2014

      • Serve as Informatica Developer and Team Lead, implementing ETL solutions based on business requirements. • Develop expertise in Oracle Database and SQL Server. • Conduct ETL and Informatica training sessions for trainees. • Demonstrate excellent problem-solving skills and the ability to meet deadlines and work under pressure. • Apply knowledge of data warehousing concepts, analysis, and data modelling processes and methodologies. • Serve as Informatica Developer and Team Lead, implementing ETL solutions based on business requirements. • Develop expertise in Oracle Database and SQL Server. • Conduct ETL and Informatica training sessions for trainees. • Demonstrate excellent problem-solving skills and the ability to meet deadlines and work under pressure. • Apply knowledge of data warehousing concepts, analysis, and data modelling processes and methodologies.

Education

  • University of Calicut
    Bachelor of Technology (BTech), Computer Engineering
    2006 - 2010

Community

You need to have a working account to view this content. Click here to join now