Avishek Kumar

Avishek Kumar Email and Phone Number

VP @ ANZ @ ANZ
melbourne, victoria, australia
Avishek Kumar's Location
Bengaluru, Karnataka, India, India
About Avishek Kumar

Highly motivated,self-starter & a quick learner with 16 years of extensive experience in Business Intelliegence and DataWarehouse.Having full understanding and appreciation of the data (It's new currency,if used properly ), I have successfully supported and partnered in implementing complex Enterprise Data warehouse(EDW) using MPP architecture.I have hands on experience on database design that supports mixed workload i.e. Transactional, tactical and OLAP queries. I have hands-on experience on various clouds platforms like GCP and AZURE, its various security features and how to ensure that data governance in cloud is built in design phase and should not be implemented as an after-thought process.Comprehending complex business requirements and translating them in to Conceptual, Logical and Physical data model is my forte. I have worked on Inmon, Kimball as well as data vault database logical models.With proficient in writing SQL(Indeed a data science tool), i have created complex logic running through 1000 lines of SQL for Banking, Retail and logistic industries. My extensive experience on EDW, gives me a unique perspective to look at the data analytics as a next logical step, i.e. how to solve a specific business problem or look for new business opportunities with the actionable insight using structured data. In this regard, I'm hands-on various machine learning techniques like Logistic regression, Random Forrest, Neural network etcCustomer experience which is causing paradigm shift in business, my own inclination is to keep data at the most raw format and creating data products as per the application data model.I have extensive consulting experience on Data warehouse optimization, data management, data lineage, restructuring and validating data lake. I have also contributed in creating Data Quality Framework for regulatory driven reports like IFRS9 and Stress Testing. I have also conducted workshops for the business users on explaining complex data structures and how to run efficient queries.I have worked on international assignments in countries like India, United Kingdom and Netherlands.I understand and practice the virtue of humility, empathy and trust. With unremitting efforts to improve myself, I'm always open to learn new tools and technologies.

Avishek Kumar's Current Company Details
ANZ

Anz

View
VP @ ANZ
melbourne, victoria, australia
Website:
anz.com
Employees:
44544
Avishek Kumar Work Experience Details
  • Anz
    Vice President
    Anz Feb 2022 - Present
    Bangalore
  • Infosys
    Principal Consultant
    Infosys Jul 2021 - Feb 2022
    India
  • Infosys
    Data Engineer(Abn Amro)
    Infosys Jul 2020 - Sep 2021
    India
  • Infosys
    Data Analyst(Rabobank)
    Infosys Feb 2019 - Jun 2020
    Utrecht, Utrecht, Netherlands
    Responsibilities included- Complex Data analysis by running advanced SQL queries and engaging the relevant business stakeholders for the actionable insight. - Formulating logical data model using power designer.- Developing new features and integrating into IFRS9 regulatory reporting.- Hands on understanding on various assets class like Retail SME, Corporate, Mortgage and it's associated model for RWA calculations.- Creating data lineage and data evidencing for external and internal auditor..- Agile development based on feature road map of the product.
  • Infosys
    Data Architect(Tnt)
    Infosys Mar 2018 - Feb 2019
    Amsterdam Area, Netherlands
    Responsibilities included-Understanding of the client's issue, it's architectural landscape, identifying improvement areas in terms of database design, data management policies.-Analyzing and optimizing long running SQL queries by addressing both structural and tactical changes, like, adding required indexes, partition, changing physical data model.-Conducted 2 workshops for business users(Data analyst and Scientist) for best practices and guidelines for writing efficient queries. -Auditing the database design and architecture to have single version of truth for the data.-Integrating various data sources of customers interactions to better help understand in customer journey
  • Infosys
    Lead Consultant(Rituals Cosmetics)
    Infosys Oct 2017 - Mar 2018
    Amsterdam Area, Netherlands
    Highly enriching experience working with a talented and motivated folks of a startup organization based at Amsterdam.Responsibilities-Validating and restructuring Google Big data platform.-Creating an Enterprise semantic layer (Views/tables) by using Google Big query to provide insight on the retail KPI to the business users.-Engaging Data Scientist team about the usage of data wrangling tool(Trifecta)for data cleansing/data preparation activities.
  • Infosys
    Senior Consultant(Tnt)
    Infosys Oct 2016 - Sep 2017
    Pune Area, India
    The client has world wide logistics operations and they wanted to integrate all the data at one place so as to avoid multiple version of truth. It also gives leeway to the sales and commercial team-to have integrated view of the data and thus understand and respond to customer's need in a more effective manner.As a BI consultant my responsibilities included -Creating High level architectural design for the data flow.-Delineating the infrastructure requirement in order to have single assimilation of data at one place.-Performing capacity planning in terms database space growth.-Mentoring the team to have optimized SQL code for data extraction and transformation.-Worked closely with the business users to construct OLAP queries for data mining.
  • Infosys
    Data Architect(Tnt)
    Infosys Mar 2016 - Oct 2016
    United Kingdom
    Its amazing to see and appreciate as how IT sits in the heart of logistics Industry. The synchronization of Operational data which hops on various desperate system with the EDW is seamless. As a data architect, the task involves -Source System analysis and integrating data from disparate systems.-Delineating the full life cycle of data from its origination till its consumption. -Consulting on Teradata EDW performance and capacity planning
  • Infosys
    Business Intelligence Consultant(Sainsburys)
    Infosys Dec 2014 - Mar 2016
    London, United Kingdom
    With ever evolving business insight analysis, OLAP and DSS usage, the Teradata EDW fits the bill quite accurately for the enterprise. The database has been implemented as 3 NF, integrating various enterprise subjects’ areas. The various pre-populated reports coupled with heavy data mining and analytics on detailed data makes Sainsbury’s PLC to remain ahead of the curve and respond in advance for any business scenario and opportunities. As a Teradata consulant, the responsibilities include :1. A complete ownership of the database.2. Created Campaign data mart using hub-and-spoke architecture for effective and targeted campaign. 3. The activities also span from creating various environments, roles, profiles, user id to implementing enterprise data model architectures and securities.3. Successfully led the Teradata upgrade from 13.10 to 14.10 with zero impact on the service.4. Working with business users in constructing Complex Adhoc and DSS SQL that are used for data mining and analytics.5. Mentoring junior BI analyst and building capability within the team.
  • Infosys
    Business Intelligence Consultant
    Infosys Dec 2012 - Dec 2014
    Chandigarh Area, India
  • Steria (India) Limited
    Teradata Consultant
    Steria (India) Limited Dec 2010 - Nov 2012
    Noida Area, India
    Responsibilities included- Formulating Technical design based High Level requirements.- Developing high level codes using Teradata tools and utilities like BTEQ, MLOAD, FLOAD.- E2E testing and supporting deployment.
  • Cgi
    Senior Software Engineer
    Cgi Feb 2010 - Jun 2010
    Bangalore, India
  • Ibm
    System Engineer
    Ibm Sep 2009 - Feb 2010
    Bangalore, India
  • Tesco Bengaluru
    Software Engineer
    Tesco Bengaluru Mar 2006 - Aug 2009
    Bangalore, India

Avishek Kumar Skills

Teradata Consulting R Data Warehousing Teradata Data Warehouse Public Speaking Physical Data Modeling Google Big Data Logical Data Modeling Data Governance Data Model Load Data Analytics Business Analysis Web Analytics Knime English Alteryx Tabeleu Performance Tuning Programming Data Modeling Big Data Google Analytics Extract Databases Google Big Query Analytical Skills Text Analytics Machine Learning Unix Software Project Management Statistics Transform Solution Architecture Teradata Sql Big Data Analytics Microsoft Power Bi Storytelling

Avishek Kumar Education Details

Frequently Asked Questions about Avishek Kumar

What company does Avishek Kumar work for?

Avishek Kumar works for Anz

What is Avishek Kumar's role at the current company?

Avishek Kumar's current role is VP @ ANZ.

What schools did Avishek Kumar attend?

Avishek Kumar attended Dayananda Sagar College Of Engineering, Bangalore, Great Lake Institute Of Management, Vikas Vidayalaya.

What skills is Avishek Kumar known for?

Avishek Kumar has skills like Teradata, Consulting, R, Data Warehousing, Teradata Data Warehouse, Public Speaking, Physical Data Modeling, Google Big Data, Logical Data Modeling, Data Governance, Data Model, Load.

Who are Avishek Kumar's colleagues?

Avishek Kumar's colleagues are Jonathan Bloch, Murali Krishna Sanku, Kamal Panesar, Raksha K N, Jon Warren, Ilaisa Tulele Senimila, David Hawking.

Not the Avishek Kumar you were looking for?

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.