Homepage
Give Private Classes
₹500/hr
Unfortunately, this teacher is not available
Tutor profile verified
Response Time 24hr
Classes offered by Ayan
  • Individual
The classes will be held
Taught subjects
  • Programming languages
Levels
  • Primary School
  • Middle School
  • Class 10
  • Higher Secondary School
  • Class 12
  • Adult education
  • Undergraduate
  • Masters
  • Postgraduate Diploma
  • Doctorate
  • Beginner
  • Intermediate
  • Advanced
  • Professional
  • For children

Want to train students on Database, programming tuition from. I am IT Professional.

Methodology

Brain research has actually shown that certain methods and approaches can truly enhance the learning process, and done right, applying innovative learning and attention-management techniques to classes is a win-win for both students and teachers.

Background

I am engineer with B.Tech in Computer science. Started career as IT trainer with Ramakrishna Mission. Currently working as IT professional with 13 years of experience.

Rates

Rate for online classes : ₹500/hr
Rate for 5 hours of classes : ₹1,000
Rate for 10 hours of classes : ₹1,800
Classes offered by Ayan
Individual
The classes will be held
Taught subjects
  • Programming languages
Levels
  • Primary School
  • Middle School
  • Class 10
  • Higher Secondary School
  • Class 12
  • Adult education
  • Undergraduate
  • Masters
  • Postgraduate Diploma
  • Doctorate
  • Beginner
  • Intermediate
  • Advanced
  • Professional
  • For children

Ayan's CV

Ayan Basu
Email: , Phone: +91 (concealed information)

Experience Summary
• Around 13 years of rich experience in IT industry.
• Extensive experience in the field of Software Testing as Quality Assurance Lead (Offshore Coordinator).
• Rich expertise in Enterprise Data Warehouse Testing (ETL with Abinitio and OWB).
• Extensive experience in all stages of Software Testing Life Cycle (STLC) including Test Strategy Preparation, Test Planning, Test Scenario Identification, Development and Execution of Test Case/Script, Defect Reporting and Tracking.
• Deft in handling functionality testing, integration testing, system testing, user acceptance testing, End-2-End testing, regression testing and distinction of receiving training in automation testing of software applications, products and components.
• Proficient in Test Management Tools – HP ALM (Application Lifecycle Management) & defect tracking tool like IBM Clear Quest.
• Sound knowledge in SQL and expertise in Oracle 11g and DB2 database environment.
• Skilful in UNIX shell scripting and have basic knowledge of Mainframe.
• Proactively contribute to effort estimation and Knowledge Management activities.
• Participate in internal process and procedures improvement activities.
• Good analytical skills and issue resolution capabilities with high attention to detail.
• Highly developed inter-personal skills gained through working with Business Users, Analysts, Project Managers, developers and support team to implement effective end-to-end solutions.
• Ability to work effectively both alone with minimal supervision and in a team environment that spans different time zones and different countries to meet aggressive project timelines.
• Ability to work on multiple projects concurrently in an Onsite/Offshore delivery model.
• Self motivated to learn new technologies and a quick learner.
• Extensive working experience in the industry of Electronic Payments, Financial Institution and Telecom

Technical Skills

Hardware / Platforms Windows 98/XP/2007, Linux, Unix
Databases and DBMS Tools PL SQL, MS-Access, Oracle 9i/10g & 11g, DB2, Aqua Studio and Toad 8.5.3 for Oracle
Test Management Tools HP ALM
Programming Languages C, C++ and Core Java
ETL Tools Abinitio (GDE1.14.42, GDE 1.16.1.4, GDE 3.0.5.1, GDE 3.1.2.1, GDE 3.1.7.3)
And
Co-operating system (abinitio_v14p109, abinitio_v15_3p1,abinitio_v16_1p3, abinitio_v3_0_3p1, abinitio_v3_1_1p4 and abinitio_v3_1_2p5)
And
Oracle Warehouse Builder (OWB)
Version Control Systems MS Visual Source Safe (VSS)
Misc Microsoft Office Suite and Open Office


Functional
• Serving as Single Point of Contact / interface for customer co-ordination and ensure adherence to customer commitments.
• Participate in the review of project deliverables including Conceptual Approach, Business requirement specifications, Functional Design documents and technical design documents.
• Addressing clearly all interoperability risks and/or issues to management providing solutions and options.
• Identifying opportunities to improve processes and add additional value by insightful and thoughtful questioning, offering new ideas, defining best practices & documenting the Lesson Learned.
• Continuous knowledge transfer with client personnel by developing appropriate documentation and by giving presentations.
• Balancing multiple stakeholder needs as well as organizational goals and get involved in Configuration & Risk Management for Individual projects
• Complete team co-ordination involving task allocation amongst team members, offering guidance and frequent discussions to monitor progress of work.
• Strong time management skills, ability to multi-task & handle multiple test assignments & prioritize own work.
• Extensive experience in interacting with the project stakeholders through daily reports and daily calls, discussions, meetings and co-coordinating with a team that spans different time zones and different countries.

Education
Degree and Date Institute Major and Specialization
B.Tech in Computer Science and engineering
Janardan Rai Nagar Rajasthan Vidyapeeth, Udaipur, Rajasthan (India) Computer Science and engineering
Diploma in Mechanical Engineering,
Ramakrishna Mission Shilpamandira,
West Bengal State Council of Technical Education. Mechanical Engineering


Professional Memberships / Certifications
Professional Society / Certification Member Since / Date Certified
Oracle Application Software Developer (OASD) April, 2007 (duration – 9 months)
Oracle Certified Professional (OCP) February, 2007 (duration – 7 months)
Oracle Certified Associate (OCA) January, 2007 (duration – 5 months)
Certificate in Desktop Publishing (D.T.P) May, 2004 (duration – 6 months)
Certificate in Computer Aided Design (C.A.D) March, 2004 (duration – 6 months)
Certificate in Software Engineering. (C.S.E) June, 2001 (duration – 2years)
O’ Level from Doeacc May, 2001(duration –1 Year)
Certificate in Computer Programming & Application (C.C.P.A) May, 2000 (duration –1 Year)


Assignments
The details of the various assignments that I have handled are listed here, in chronological order.
1.
Project ISD-QA (CMLS)
Customer VISA Inc, CA, USA
Period Feb -2011 to Till Date
Description Visa Inc. is a global payments technology company that connects consumers, businesses, financial institutions and governments in more than 200 countries and territories, enabling them to use digital currency instead of cash and checks and facilitates electronic fund transfers.
Visa has a huge amount of data, including over 80 billion transactions made on over 2 billion cards at tens of thousands of merchants, providing the basis for insightful and innovative analytics that helps Visa and their clients to improve their products and market position. It has built one of the world’s most advanced processing networks, capable of handling more than 15,000 transactions per second, with reliability, convenience and security.

Various Projects I have worked in Visa under ISD-QA (CMLS)
• CMLS GBL – CMLS Global and Subscription processing – The CMLS Global application extract fields from both VIP and RSI transaction files created out of CSI and provides data to various applications based on downstream requirements. CMLS Global is a hub of data elements containing raw and enriched fields, using lookup tables and other sources it passes the data to many downstream applications such as GMBS, VCTR, VIP Reporting which in turn create reports and allow for online queries and research.

• EDW - VISA’s Business customers rely upon the BI Global warehouse as their primary reference to monitor the health and performance of visa products and services, track financial impacts, glean insights, and substantiate business decisions. In order to expand and integrate new business facts a new VISA Enterprise Data Warehouse (EDW) will be build which will store Global visa data centrally. Visa EDW platform provides a single version of truth with Global BI Data Model to streamline and enhance key data for consistent and accurate business intelligence in authorization and Clearing & settlement areas.

• CMLS VNTS – The CMLS VNTS (Visa Net Tokenization Services) application process the bulk token file from Issuer or Acquirer or Merchant or Wallet Provider or Payment Services Provider and send it to VIP for Token Vault Update. This application also Load the Web Services AP Log from Risk and Authentication to EDW DW.

• ATM Reporting - This provides Monthly ATM Business quality and exception reporting.

• RDW – Regional Data Warehouse – Central Data warehouse for AP and CEMEA region providing transactional and summary data and reports to corporate users and external clients.

• GDT – This project deals with Global Duplicate Transaction of US region only. Helps Visa to identify and calculate fine for each duplicate transaction.

Role Senior ETL/Abinitio QA Test Lead
Solution Environment Ab-initio, UNIX, ClearQuest, DB2, Mainframe and Aqua Data Studio 4.7
Responsibilities • Review and Analysis of the Requirement Documents & Design documents. Work closely with the Business Analysts, Lead Developers, Architects, Product Owners and others team members in developing a testing strategy.
• Formulating test plans, preparing test cases, executing the tests to verify ETL functionality adherence to business requirements through Abinitio, UNIX and DB2.
• Test Data configuration and recreation in QA.
• Debugging the log for any failure of the job and if valid issue found logging it as an issue.
• Preparing comparison tool in Abinitio for regression test.
• Fully documenting and reporting the Test Finding and giving the sign-off while working as SME in some of the areas.
• Participating in special assignments like Microstrategy Data Support, UAT, and Back population of EDW tables and provide ad hoc support as and when required.
• Onsite - Offshore sync up, discussions, meetings, providing execution instructions and issue resolutions.
• Prepare and track project schedules/ milestones/ weekly status reports and Interface with senior management to report on project milestones.
• Active Contribution towards preparation of Test Effort Estimates / Sizing. Estimating the QA timeline, resource allocation and tracking of efforts and issues.
• Defect review and prioritization, Defect Analysis and Root Cause Analysis, holding Defect Resolution meetings with Development team and Project Management. Controlling defects cancellation rate.
• Identify areas for improving efficiency through automation. Developed several Shell programs for running the full flow of an ETL process to minimize manual effort and ensuring reusability.
• Participate in KM initiatives, documenting Best Practices, Lessons Learnt for each project and update KM repository.
• Impart Technical & Domain Trainings to the team including fresher / new comers
• Ensure Compliance to Time Tracking activities, both Internal and External
• Testing High volume data processing using AbInitio ETL tool with performance tuning components and PDL.
• Mentoring team members to perform with greater empowerment and responsibility.
• Monitoring project progress, reporting the higher management and communicating to the corresponding stake holder and business

2.
Project TCAS REVAMP APPLICATION (Migration)
Customer ITC
Period Nov-2010 to Feb -2011
Description ITC is the market leader in cigarettes in India. With its wide range of invaluable brands, it has a leadership position in every segment of the market. For cigarette manufacturing & its production planning it uses the planning tool as TCAS Application system. The tool is quite old developed with Power Builder 5 & Oracle 8i. The technology is on the verge of migration as .Net & Oracle 9i with new set of requirement coming for production planning.
Role Team Member , Oracle Developer
Solution Environment Oracle 9i, Visual studio 2005
Responsibilities • Preparing process flow & data flow diagram.
• Extracting business logic from the current application.
• Point to Point mapping for the migration & building the scope for new requirements.
• Redesigning the ER model to keep the role level control & audit trail in the picture.
• Writing PLSQL programs to meet the new requirements with the existing application.

3.
Project Domestic country Data cleanse
Customer British Telecom
Period Mar-2010 to July-2010
Description British Telecom Global Services (BTGS) is the largest Telecom Services provider to service BT network requirements outside UK.
This project is to create a database and report to minimise the revenue loss of BT. BTGS is providing network services to different countries and MNCs. In order to do this BTGS is having tie up with different Service providers called suppliers. As per the contract BT is raising charges to its clients and suppliers are raising charges to BT. In this project we are to analysis of data between BTGS, supplier and customer. Finally we are producing report that shows the difference between BT & Supplier and BT & Client.
Role Team Member , Data Analyst
Solution Environment ORACLE 10G
Responsibilities Writing SQL query and PL/SQL packages

4.
Project BTGS Reuters Operations
Customer British Telecom
Period Dec-2009 to Mar - 2010
Description British Telecom Global Services is the largest Telecom Services provider to service BT network requirements outside UK.
This data warehousing project built an Enterprise Data warehouse for BT Global Services .The project involved pulling in data from multiple source systems which are Clarify/Siebel based tools for monitoring Customer Management and Network Operations.
The data from the source systems are replicated into tables of a Data Reception Area.
Oracle Warehouse Builder (O.W.B) is used to extract and transform the data (Source System Specific) loading into an intermediate area.
A generic process cleansed and standardized the data and loaded into the data warehouse. This data is further pushed into the data marts by a different piece of ETL code. The data marts are used by a front end dashboard for corporate level reporting and Business Objects for detailed reporting.
The entire design is based on a Corporate Information Factory model on a Star Schema approach.
Role Team Member
Solution Environment ORACLE WAREHOUSE BUILDER (O.W.B) 10G RELEASE 1 / Oracle 10.2 with Parallel Query. HP UX ITANIUM servers in a clustered environment consisting of five nodes and storage in SAN. Business Objects is used for reporting. A Java based dashboard used for displaying Key Performance Indicators.
Control-M used for triggering off processes, Unix used for controlling jobs. A generic Java based scheduler used for sequencing map executions. A common processes to cleanse and standardize the data.
Responsibilities Writing SQL query and PL/SQL packages

5.
Project Openreach EDW
Customer British Telecom
Period Feb-2006 to May-2009
Description Openreach was created as a stand-alone business providing fair and equal access to the network for all Communications Providers.
Openreach looks after the ‘first mile’ of network, from the exchange through to homes and businesses. Its customers are not the end users but those companies that supply them. Openreach does not compete with these providers – it delivers the means by which they all, on an open and even-handed basis, run their businesses.
This data warehousing project built an Enterprise Data warehouse for ORBIT .The project involved pulling in data from multiple source systems which were Siebel based tools for monitoring Faults, Orders and Service Request etc.
The data from the source systems were replicated into tables of a Data Reception Area.
Oracle Warehouse Builder (O.W.B) was then used to extract and transform the data (Source System Specific) loading into an intermediate area (DSA).
A generic process cleansed and standardized the data and loaded into the data warehouse. This data was further pushed into the data marts by a different piece of ETL code. The data marts were used by a front end dashboard for corporate level reporting and Oracle Business Intelligence (OBI) for detailed reporting.
Role Project Member
Solution Environment • HP-UX
• PL/SQL Procedure/Packages
• OWB(Oracle Warehouse Builder)
Responsibilities • Writing SQL query, PL/SQL Packages and Shell Scripts
• Creating Maps by using ETL tool OWB

6.
Project BTGS Datawarehouse (BTGS-DW)
Customer British Telecom
Period May-2004 to December-2005
Description British Telecom Global Services is the largest Telecom Services provider to service BT network requirements outside UK.
This data warehousing project built an Enterprise Data warehouse for BT Global Services .The project involved pulling in data from multiple source systems which were Clarify/Siebel based tools for monitoring Customer Management and Network Operations.
The data from the source systems were replicated into tables of a Data Reception Area.
Oracle Warehouse Builder (O.W.B) was then used to extract and transform the data (Source System Specific) loading into an intermediate area.
A generic process cleansed and standardized the data and loaded into the data warehouse. This data was further pushed into the data marts by a different piece of ETL code. The data marts were used by a front end dashboard for corporate level reporting and Business Objects for detailed reporting.
Role Team Member
Solution Environment ORACLE WAREHOUSE BUILDER (O.W.B) 10G RELEASE 1 / Oracle 10.2 with Parallel Query. HP UX ITANIUM servers in a clustered environment consisting of five nodes and storage in SAN. Business Objects is used for reporting. A Java based dashboard used for displaying Key Performance Indicators.
Control-M used for triggering off processes, Unix used for controlling jobs. A generic Java based scheduler used for sequencing map executions. A common processes to cleanse and standardize the data.
Responsibilities • Writing SQL query and PL/SQL packages
• Creating Maps by using ETL tool OWB.

Career Profile
Dates Organization Designation
Feb 2011 to Till Date RS Software (India Ltd) Assistant Technical Consultant
Nov, 2010 to Feb 2011 ITC InfoTech
(Through Infokall Enterprise Solution Ltd) Oracle Developer
Dec, 2009 to July 2010 Tech Mahindra Ltd.
(Through Infokall Enterprise Solution Ltd) Technical Associate
Aug, 2009 to Dec, 2009 Dream Institute Of Technology Technical Assistant
May, 2004 to May, 2009 TATA Consultancy Services Ltd. Assistant Systems Engineer
August, 2001 to May, 2004 Ramakrishna Mission Computer Centre Faculty

Personal Details
Date of Birth 18-01-1979
Nationality Indian
Address Vill+P.O. – Ramnagar, P.S.– Shyampur,
Dist – Howrah, PIN – 711312, West Bengal, India

Passport Details
Name as on passport Relationship Passport Number Date of Issue Expiry Date Place of Issue
Ayan Basu Self L5332974 09-10-2013 08-10-2023 Kolkata

Similar teachers

programming languages classes closeby? Here's a selection of tutor listings that you can check out.

Howrah
IT engineer with 22 years industry experience sharing knowledge to future generations
₹400
Palash
1st class free!

Why at all you need to learn this subject? By knowing this students will grow interest which is key to learning. Different...

Classes by webcam Face-to-face classes Approved profile
Howrah
Jadavpur University Bachelor of Computer Science Engineering. WBJEE rank 146. Want to teach
₹500
Ayan
1st class free!

Jadavpur University Bachelor of Engineering. WBJEE rank 146. Mathematics tuition and Computer Science tuition. Expert...

Classes by webcam Face-to-face classes Approved profile
Howrah
CSE student from St. Thomas' College of Engineering & Technology. Giving tution on computer programming languages from high school, Kolkata.
₹400
Dipam
1st class free!

I am trying to give my lecture in my own thoughts , not in proper definition in the book and catch the key points that makes...

Classes by webcam Face-to-face classes Approved profile
Software Engineer at Cognizant with more than 2 years teaching experience in Computer Science
₹300
Aditya
1st class free!

My teaching methods are mainly real life example based so that my students can relate to the problem and get the concept...

Classes by webcam Face-to-face classes Approved profile
Howrah
Having cracked 6 off campus jobs from a tier 3 college, now working as a Software engineer at Capgemini, giving tutions for programming languages like C, java etc and the best preparation strategy for
₹550
Rishita
1st class free!

Instead of beating around the bush, I focus on topics which have actually needed to crack interviews, I teach everything...

Classes by webcam Face-to-face classes Approved profile
Kolkata
Web developer with 3 years of experience in IT and Software development industry. Experience in Html, Javascript, Scripting languages. Worked in both agile and devops methodology
₹600
Md Aadil
1st class free!

My teaching method is very granular. I start from basics and then proceed with difficult and advance topics so that students...

Classes by webcam Face-to-face classes Approved profile
Howrah
Home Tuitions For Computer,English and Maths For ICSE and CBSE Students in Howrah
₹150
Vishal
  • (5 reviews)
1st class free!

I conduct regular tests for my students in order to make them prepare for their examinations well in advance.I also give...

Classes by webcam Face-to-face classes Approved profile Replies within an hour
Howrah
6 years working experience in Java, advanced Java. Teaching java and advanced Java. Location howrah shibpur.
₹500
Sourav
1st class free!

My classes will be regular teaching classes for students. Mainly looking for students from school , college students. Any...

Classes by webcam Face-to-face classes Approved profile
Howrah
Student in college would interact and make you understand about everything you ask with a promise
₹250
Gaurav
1st class free!

My teaching method is at first why the topic then what the topic is then how to use it and lastly what effects it can make

Classes by webcam Face-to-face classes Approved profile
Howrah
Computer science for ICSE, ISC, CBSE, BCA, BTech, MCA students by 22 years experience corporate trainer
₹800
Khurshid
  • (1 review)
1st class free!

I am giving training in the classroom as well as on Skype. I am a corporate trainer and giving training for school and...

Classes by webcam Face-to-face classes Approved profile
Howrah
If you want programming in depth, the you are at right place...
₹250
Abhijeet
1st class free!

Start teaching with basic overview about the topic I teach, then drill down each and every topic with clarity and depth via...

Classes by webcam Face-to-face classes Approved profile
Howrah
Today Computer Programming and understanding of programming language become very essential so I decided to teach that.
₹500
Avijit
  • (6 reviews)
1st class free!

My method is simple. I teach you every single thing of Computer Programming according to your need. Then you can clear any...

Classes by webcam Face-to-face classes Approved profile
Howrah
Lecturer in engineering college gives tutions in computer science and programming languages from high school to college level.
₹700
Sourav
1st class free!

My teaching methods in computer based. And I explain each and every part of a programming languages with practical. I also...

Classes by webcam Face-to-face classes Approved profile
Howrah
Myself completed engineering in CSE 2018 gives coaching now for engineering semester s and programming languages
₹1,000
MANISHA
1st class free!

My teaching method is shortcut tricks with basic concepts also

Classes by webcam Face-to-face classes Approved profile
Howrah
Just graduated engineering from a reputed college and teaching has been my passion from Math to Computer Languages
₹350
Akshay Kumar
1st class free!

I have studied from good teachers and bad teachers (who should not have been in this profession). I work on just two things....

Classes by webcam Face-to-face classes Approved profile
at his home at your home By webcam
1 hour Not available Not available ₹500
5 hours Not available Not available ₹2,500
10 hours Not available Not available ₹5,000
Unfortunately, this teacher is not available