Mayur Jaiswal

· Tesco business has decided to rollout new tills across the stores replacing the current third party tills. Sales information related to new Tesco tills are captured through micro services. Since this data is not available through the traditional sources like RTS & MJIJ, there is a need to fill this gap & make all the data available for business.The focus is to fill the gap for sales in the first phase.Due to the complexity to bring the data directly from micro services to Teradata directly, new Tesco tills data is brought to Hadoop first & data is then transferred to Teradata through Sqoop export mechanism.

• The project involves all the activities starting from analysis/design and requirement till code deployment to production.

• Role and Responsibilities:

• Involved in understanding the business requirements by having calls with our onsite team. • Interaction with Onsite team and client on regular basis for updates, Capacity planning, Activity planning and issue resolution.

• Involved in performance tuning for Teradata query.

• Defect analysis and fixing.

• Analyze the system impact and identify solutions.

• Developed UNIX scripts & Teradata BTEQ scripts etc. to load, validate & transmit data through different channels.

• Responsible of End-to-End Project deployment.

• Providing technical/business solutions to business user

O2- Aura 4P CBD/DR

Project Objective:

• The project involves all the activities starting from analysis/design and requirement till code deployment to production. Customer need the data from warehouse which they will use for analyze or predict the behavior of users and will give the offer to users accordingly so we have to provide the data for 11 entities to customers and they will use the data for

Predictions. Data is available in Warehouse so we have to apply the business logic according to Design document /ICD and populate the 11 tables and extract the data sand send to the O2ICC Target server.

Role and Responsibilities:

• Involved in understanding the business requirements by having calls with our onsite team. • Interaction with Onsite team and client on regular basis for updates, Capacity planning, Activity planning and issue resolution.

• Involved in performance tuning for Teradata query.

• Defect analysis and fixing.

• Analyze the system impact and identify solutions.

• Developed UNIX scripts & Teradata BTEQ scripts etc. to load, validate & transmit data through different channels.

• Building Ab Initio graphs for extract the data from sources table through Fast Export. • Preparing Weekly/Daily status report and communicating with Clients on the same. • Responsible of End-to-End Project deployment.

• Providing technical/business solutions to business users

CRM_TECH_DELIVERY

Project Objective:

• CRM is a development as well as support project, which has multiple projects consisting development of various channels for campaign management like Direct Mail, Email, Out Bound Tele-marketing and Statements with Teradata as Backend Database. The project involves all the activities starting from analysis and requirement till code deployment to production and development in new data warehouse along with support and maintenance of existing applications with channel migration. This also includes providing technical/business solutions to business users/campaign execution team.

Role and Responsibilities:

• Involved in understanding the business requirements by having calls with our onsite team. • Interaction with Onsite team and client on regular basis for updates, Activity planning and issue resolution.

• Involved in performance tuning for Teradata query.

• Defect analysis and fixing.

• Analyze the system impact and identify solutions.

• Developed Mainframe scripts & Teradata BTEQ, MLOAD, Fast load scripts etc. to load, validate & transmit data through different channels.

• Building Ab Initio graphs for capturing data from various sources like using all components

(ROLLUP, SCAN, REFORMAT, etc..)

PPI_UPLIFTSOFTWARE

Project Objective:

• Project objective is to create a PPI application for client that contains valid data information. This project objective is regarding customer complaints. We process on customer complaints and apply the business logic for complaints. This project takes customer complaints from source database and applied validation on complaints and loads the data from source to target.

The data is used for further processing report.

Role and Responsibilities:

• Involved in understanding the business requirements by having calls with our onsite team • Participated in preparing design documents on basis of FRS.

• Participated in development and working on many applications/Modules.

• Involved in Designed and developed complex Mappings, used transformation. • Involved in coding and unit testing. Designed and developed complex UNIX scripts, M Load, bteq script, fast export in Teradata.

• Involved in performance tuning for Teradata query.

• Reviewed code with quality tool.

• Provided warranty support and production support for SIT and UAT. Tracking defects in quality centre.