Anand Arya

Anand Arya

Sr. Technical Associate

Followers of Anand Arya420 followers
location of Anand AryaMumbai, Maharashtra, India

Connect with Anand Arya to Send Message

Connect

Connect with Anand Arya to Send Message

Connect
  • Timeline

  • Skills

    Obiee
    Pl/sql
    Oracle warehouse builder
    Testing
    Oracle
    Data warehousing
    Unix
    Etl
    Oracle pl/sql development
    Sdlc
    Odi
    Oracle fusion middleware
    Weblogic
    Unix shell scripting
    Data migration
    Solution architecture
    Requirements analysis
    Sql
    Agile methodologies
    Business intelligence
    Hp quality center
    Requirements gathering
    Databases
    Oracle data integrator
    Software development life cycle
    Shell scripting
    Obia
  • About me

    Over 10 years of total experience as an IT Professional which includes Functional experience in Data Warehouse, ETL, Manufacturing, Insurance, and Telecom Domain. Proficient in End to End Data warehouse designing, developing, and implementing ELT/ETL solutions using Oracle Data Integrator (ODI) and Oracle Warehouse Builder (OWB) Expertise in Software Development Life Cycle and Agile Methodology. Experience in implementing ETL solution using Oracle Data Integrator ODI 12c and 11g Upgrading ODI 11g to ODI 12c Migrating OWB 11g to ODI 12c Experience in implementing End To End Data Warehouse solution using OWB, ODI, OBIEE, OBIA Installation, setting up, and configuration of ODI, OBIEE, OBIA, OWB Strong knowledge on PL-SQL development, and performance tuning of SQL queries.

  • Education

    • Swami Vivekanand College of Arts, Science, & Commerce

      2004 - 2007
      B.Sc Information Technology
    • Birla Institute of Technology and Science, Pilani

      2008 - 2012
      Master of Science (M.S.) Computer Software Engineering
  • Experience

    • Tech Mahindra Ltd

      Jun 2007 - Sept 2012
      Sr. Technical Associate

      OBIEE Analytics reports and RPD developmentDesigning ETL mappings using OWB toolOWB Code review automation using OMB+OWB migrations automations using OMB+Data Warehouse designsSQL / PLSQL development

    • Tata Consultancy Services

      Oct 2012 - Jun 2013
      IT Analyst

      Sr. Obiee developer and Administrator- RPD and webcat development- Interactive reports and dashboards- OBIEE 10g to OBIEE 11g upgrade

    • L&T Infotech

      Jul 2013 - Mar 2017
      Project Lead

      Oracle Data Integrator and Oracle Business Intelligence- Design and Develop ELT processes using ODI 11g- ODI Admin activities- ODI 11g to ODI 12c Upgrade- OBIA 11g installation, configuration, and set-up- OWB 11g to ODI 12c Migration

    • Capgemini

      Mar 2017 - Apr 2022

      ETL / ODI ArchitectOBIA upgrade specialist from 11.1.1.8.1 - 11.1.1.9.2 - 11.1.1.10.2 - 11.1.1.10.3 Automations, Solution and Accelerators Vendor Management, RFP OBIA Consultant / ODI Architect • Customizing ETL and BI report solution in OBIA using ODI and OBIEEPerformance Improvements • ETL & BI code deployment • Bug fixing and applying patch in coordination with Oracle support• Load monitoring, troubleshooting, and fixing ETL issues

      • Manager / Architect

        Oct 2020 - Apr 2022
      • Senior Consultant

        Mar 2017 - Oct 2020
    • LTIMindtree

      Apr 2022 - now
      Senior Manager - Data Engineering

      Upgrade OBIA 10.1 to 10.3Planning and executionCustomization in ODI 12cLoad Plan and TroubleshootingData Validation

  • Licenses & Certifications

    • Oracle Cloud Infrastructure Foundations 2021 Certified Associate

      Oracle
      Feb 2022
    • L1 Certified Architect

      Capgemini
  • Honors & Awards

    • Awarded to Anand Arya
      Squad Award - Best Team LTIMINDTREE LTD Mar 2025 Best Team Award
    • Awarded to Anand Arya
      Hi-Five : Spot Award LTIMINDTREE LTD Jun 2024 Improving Performance of Business-Critical Reports in Oracle BI
    • Awarded to Anand Arya
      GoMx - Certificate of Appreciation LTI Oct 2022
    • Awarded to Anand Arya
      Certificate of Appreciation Capgemini Mar 2022 For Completing 5 years
    • Awarded to Anand Arya
      Solution Architect Program Capgemini Jun 2021 You are recognized for the practical understanding of Solution Architect concepts
    • Awarded to Anand Arya
      Xtra Mile Capgemini Jun 2021 In recognition of Outstanding Performance and Contribution
    • Awarded to Anand Arya
      Xtra Mile Capgemini Feb 2020 In recognition of Outstanding Performance and Contribution
    • Awarded to Anand Arya
      Project Star Capgemini Dec 2019 In recognition of Outstanding Performance and Contribution
    • Awarded to Anand Arya
      Certificate Of Appreciation Capgemini for the invaluable contribution in building a Learning Culture within Capgemini
    • Awarded to Anand Arya
      World Class Delivery Capgemini For your committed efforts and contribution towards the organization, which have enabled us to stay relevant and strong in these unprecedented times