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.
-
Vice PresidentAnz Feb 2022 - PresentBangalore -
Principal ConsultantInfosys Jul 2021 - Feb 2022India -
Data Engineer(Abn Amro)Infosys Jul 2020 - Sep 2021India -
Data Analyst(Rabobank)Infosys Feb 2019 - Jun 2020Utrecht, Utrecht, NetherlandsResponsibilities 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. -
Data Architect(Tnt)Infosys Mar 2018 - Feb 2019Amsterdam Area, NetherlandsResponsibilities 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 -
Lead Consultant(Rituals Cosmetics)Infosys Oct 2017 - Mar 2018Amsterdam Area, NetherlandsHighly 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. -
Senior Consultant(Tnt)Infosys Oct 2016 - Sep 2017Pune Area, IndiaThe 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. -
Data Architect(Tnt)Infosys Mar 2016 - Oct 2016United KingdomIts 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 -
Business Intelligence Consultant(Sainsburys)Infosys Dec 2014 - Mar 2016London, United KingdomWith 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. -
Business Intelligence ConsultantInfosys Dec 2012 - Dec 2014Chandigarh Area, India -
Teradata ConsultantSteria (India) Limited Dec 2010 - Nov 2012Noida Area, IndiaResponsibilities 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.
-
Senior Software EngineerCgi Feb 2010 - Jun 2010Bangalore, India -
System EngineerIbm Sep 2009 - Feb 2010Bangalore, India -
Software EngineerTesco Bengaluru Mar 2006 - Aug 2009Bangalore, India
Avishek Kumar Skills
Avishek Kumar Education Details
-
First Class With Distinction -
Great Lake Institute Of ManagementBusiness Analytics And Business Intelliegence -
Vikas VidayalayaSchooling
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?
-
Avishek Kumar
Bengaluru3gmail.com, infosys.com, gmail.com -
Avishek Kumar
Noida -
1gmail.com
-
Avishek Kumar
Pune -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial