Bairam Khan Gaffar

Skill: - 6Sense, PathFactory, Celebrus v8, v9, Celebrus Data Collection, Semantic Configuration, Data Loading, Personalization, Data Processing

HCL Technologies Ltd (Teradata Corporation-Project)

Https://www.hcltech.com

Https://www.teradata.com

Designation – Senior Consultant –Marketing Technologies

Location – Bengaluru-India

Real-Time Customer Data Platform, Customer Journey Analytics, Data Orchestration, 6Sense Developer and Admin.

Currently working on 6Sense Platform (70%) and PathFactory Platform (30%). My duties on 6Sense are gather business requirement and configure the same in 6Sense platform.

Troubleshooting if any data discrepancies and keyword groups.

Integrating Salesforce and Eloqua for Account and campaign information to fetch and create prospects / leads.

Successfully completed Teradata Celebrus suite v9.7.0minor upgrade and SSO Configuration

Providing Teradata Celebrus Application Professional support to Teradata.com business users, liaising with project managers and stack holders to get business requirement then converting into Technical

Good understanding of new age digital technologies

Deep understanding of Client industry trends, strategic objectives, business metrics and business challenges across the value chain

Identify, quantify & prioritize all opportunities for client e. Assist in building a Business Case (ROI/IRR/Sensitivity analysis)

Ability to keep abreast of industry trends across Sales & marketing, consumer, commerce, Supply chain and Finance areas and apply them in existing and new product offerings

1-1 managed DC Migration project from scratch, includes Firewall port finding, solution designing, process designing, process implement, Database backup, restore, Implementation, Project Documentation, and handover

1-1 managed Architecting and Deployment of Celebrus v9.2 version upgrade.

Successfully Implemented various Personalisation Trigger and action rules per business need.

Celebrus Personalisation rule creation, DEV implement test and move to production.

Celebrus campaign tracking design, new requirement analysis, GDPR Implementation

Handling DoD error / Requirement investigation

Producing Teradata report as required by ETL team, processing data as per the business requirement

Liaising with BI Team, helping them to understand data source, business process.

Developing new Celebrus semantic configuration based on new business scenario.

Teradata vantage Associate Certified, Teradata Vantage CX Implementation

Celebrus - (A Division of D4t4 Solutions)

https://www.celebrus.com

Designation - Product Specialist

Location – Chennai

I’m using different tools and skills to Analyze customer Online/Offline data to create, Investigate and test hypotheses used to identify patterns in large.

• Installs, Scaling and Monitoring – Installed and set-up system and scaled according to volumes of traffic, richness of data and load throughout different areas of system. Building monitoring requirements to ensure system and data integrity as well as identifying when further scaling is needed.

• Consultancy/Requirements Gathering – Visited customers on-site to do various types of consultancy work: from basic requirements gathering, identifying new areas of reporting, improving current reporting as well as identifying problem areas and helping customers gain a better understanding of products and various reporting features available.

• Training – Delivered customer training on a number of different Celebrus courses for customers hosting website in various sectors (banking, insurance, retail, gaming, government). Adjusted the practical exercises to focus on various aspects of the course tailoring to the role of the attendees within their business.

• Database Management – Developed database management skills: setting up replication; data-dumps; installing new instances of MySQL; handling merge tables; data table repairs/maintenance; data cleansing.

Duties & Responsibilities:

-> Deployment, commissioning, Architect Celebrus Data services in AWS cloud.

-> Managing Customers On cloud Celebrus Services in AWS EC2. Creating dedicated / Shared EC2 Instances based on client requirement.

-> Hands-on Experience in Azure / Physical or VM Instance Migration to AWS EC2

-> Consulting and creating dedicated S3 buckets for Data Transfer to Client environment

-> Consulting and creating Amazon RDS for Data warehouse solutions

-> Working directly with the customers to deliver Celebrus services and data into their environment.

-> Answering support query raised by Celebrus partners and end customers either by email or phone calls.

-> Providing remote support for the client hosted Celebrus Systems.

-> Understanding and reproducing the bugs reported by Celebrus customers and partners.

-> Getting engaged with Celebrus client on monthly catch-up call to answer product related queries and support their changing configuration requirements.

-> Working on enhancement requests raised by Celebrus Clients. (Via- “Jira”, “Mantis” Tracking system - which includes analyzing, prioritizing, and troubleshooting technical inquiries)

-> Take ownership of critical issues, enlist proper representation from other resolver groups and drive towards resolution

-> Monitoring Daily check activities, taking necessary actions if there any issue in production servers

-> Creating Scenarios within Configuration Server to identify and create business events and managing configurations.

-> Creating Marketing Personalisation configuration based on client requirement

-> Creating user behaviour level personalisation in Celebrus RTE Engine

-> Installing Celebrus servers and implementing its various services.

-> Reviewing and testing Configurations done by client and providing the necessary updates or the changes that must be done.

-> Testing the functionality of all the Celebrus Components.

-> Supporting Client with regex and SQL based queries.

-> Sharing knowledge with team.

-> Fine-tune client requirement and advise possibility with Product o/p

-> Client-side JavaScript Tagging, testing

-> Creating business configuration based on client requirement

-> Creating custom events and configurations

-> Supporting customers 24/7/365 using pager duty (post office hours as per SLA)

-> Working in multiple shifts (UK / US shift)

-> co-ordinating with end customer and Internal support team, Development team

-> Writing collection side rules (HTML Element rules, var state DOM property rules, Add Exception /obscured events)

-> Processing Data on both [Batch / Real-Time engine] and pushing processed data to Data Warehouse (Teradata, Redshift, Oracle Cloud Versions)

-> Querying Processed Date to retrieve Business reports, Good SQL query knowledge / PLSQL concepts in Oracle 11g DB

-> Working Knowledge in Oracle 11g SQL, PLSQL-Functions, Procedures, Cursor, Triggers, MySQL, Teradata, Mongo DB (Installation, reporting)

-> Working Knowledge in Linux / Windows Environments

Projects:

Client - Qantas Airways

Location - Sydney (Australia)

Duration - 4-months (on-site)

Work With:

In (Mascot) Qantas head office I was closely working with Qantas loyalty team and C2 Data warehouse Team for below website tracking

WEB:

Qantasepiqure.com.au (e commerce website)

Qantasstore.com (e commerce website)

Qantasgolfclub.com.au (golf course booking site)

Qantaspoints.com.au (points redeem site)

Qantas.com (Air ticket booking site)

MOBILE:

Qantas Money (Native IOS /Android)

Qantas Points (Native IOS /Android)

Project Architecture:

Installed “Two” clusters one from AWS and another Qantas Internal Network

AWS Cluster Collects User raw events and transfer to Processing Engine, Based on Semantic Configuration Rule Process Engine Process Raw events and create a CSV file to load IBM-Sterling (SFTP)

IBM-Sterling Push those data to another cluster and upload to Teradata D/W

Role in Project:

Requirements Gathering, Creating Requirement Document for end-user approval

Server Installation both (AWS / Q-Internal Clusters) on Distributed Architecture

Writing shell script to push / copy / record collected raw events

Develop Celebrus Java script to Tag-Qantas Websites

Used – DTM (Adobe) for Tagging and Testing Java script event triggers

Testing Events Capture in Collection Server

Writing Collection Rules based on Business requirement

Writing Semantic Configuration rule in Configuration Server side

Test / Debug / Analyse Processed events before push to D/W

Writing Post Completion Technical Document and End User Training

Other Projects / Support Worked with:

Delta Airlines:

Closely working with Delta Airlines Stakeholders, Good Understanding of multiple architecture Celebrus systems, attending weekly call with Stakeholders for Mantis Ticket Progress Update, Moving Real-Time Data to Delta Offshore ETL systems, and developing shell script for Data Load to sterling systems. ‘Dedicated’ resources for Delta Celebrus system profess / Celebrus patch version update / support issue handling.

P&O Ferries:

Multiple Data Enrichment Configurations / Data Collection support / Data Loading Developments

BFSI – HSBC (worldwide), Nationwide (Insurance), Lloyds Bank (UK) Bank of America (USA), UBS (Singapore /Swiss), Taishin Bank, O-Bank, Westpac, ANZ, Danske Bank, Deutche Bank, CompareTheMarket.com (CTM-UK)

Oracle Knowledge:

Good in PL-SQL Exception Handling

What I did with APH Solutions: http://www.aphsolution.com

Role - SEM Specialist

Location - Chennai

Worked in a dual role (GA- Analyst /&/ Project Co-ordinator)

Supporting UK’s football ticket booking site’s Campaign Tracking / GTM custom tagging / Google Analytics Reporting

ADTC – Abudhabi Dawteen Council (Mobile App’s Development Project Co-ordinator)

ADTC App was developed in (Native - IOS, Android, and Windows)

My role more into co-ordinating with client, gather new requirement, daily Progress meeting, engaging with developer meeting, validate bug reports from testing team

Creating change request document, Follow-up with web services team

https://www.metainfotech.com

Designation - Sr. Technical Support Engineer

Location – Mumbai-India

Here is the Place I’ve learned What is Analytics, why people looking more into it, what needs to run an application smooth, how to act if business process application goes into problem.

Was working with WebTrends Analytics Product from version (7.0d, to 8.5a 8.7d, 9.2b) and Real Time Engine v10 - https://www.webtrends.com

Started my Career with Installation, Implementation, Troubleshoot, WebTrends Analytics product

Soon I picked up how Analytics App works, generates meaningful report, then started working on custom report configurations using WebTrends

Since Meta is the only Partner / Reseller for WebTrends in India which gives options to work in different vertical and become product specialist in WebTrends

I had been with implementation, MS-SQL, DB Backup and restoration, MySQL DB Migration, Performance Tuning, WebTrends Application Upgradation, Version Migrations, Custom Reporting, Requirements gathering and apply changes to analytics report.

Reprocessing Data, Profile creation, profile configuration, WebTrends Tag Builder (JS Tag Creation), Implementation in server side and testing logs / SDC data from client side.

Validating Tag Implementation, TEST run for DB fine-tune

SDC data collection installation in Windows / Linux Environment

User access / privilege rule configurations

Report Exporting and schedule report via email, SFTP

Working on iDashboards application, Creating meaningful Dashboards

Projects:

Client – Axis Bank

Location - Mumbai (India)

Duration – 1.6 yr.

Work With: Axis Bank campaign management team and Digital Marketing team,

WebTrends V9.2b with Smart source data collector, reporting to Digital Marketing Team

Consulting and solution fine-tune, producing weekly & Monthly Report of city wise unique traffic, Promoting New schemes through Mail Campaign, understanding Client Behaviour in Web & Social

Public Sector:

Worked with NIC- (National Informatics centre-Delhi) https://www.nic.in/

Key Roles:

Tracking Gov Public Websites like Passport.gov.in AICTE, and INCOME TAX site etc. Making Report State wise

Understanding User Experience & behaviour in website, Tracking Web Server Issue & Pages Issue and reporting to Technical Team the same to fix, Tracking PDF & Document Download & upload related to public reference.

Travel Sector:

Worked with EZEEGO1.com & Clear Trip

Reporting with Digital marketing team for tracking ticket Price Offer & campaign, with WebTrends Analytics V9.2b, tracking user conversional Funnel, Paid & organic Search tracking, understanding user frequent keywords & reference Page. Tracking user experience in website, tracking issue with Ticket booking Forms, users frequent path Analysis, content Analysis. Ad’s tracking.

Insurance Sector:

Worked with TATA AIA, ICICI Prudential, SBI life

Key roles:

Reporting to Middleware Team & Business Analysis Team, tracking registered user & Agents, tracking buy policy through online, promoting new scheme in Social & Email Campaigns, tracking unique visitors from state wise, city wise who interested & looking for Buy Insurance policy, Tracking Free cote of policy and tracking pdf download from site.

Media Sector:

Worked with Star TV Network & Malayala Manorama:

Reporting to Digital Team worked closely with 3rd party vendor, Server Management Team, almost all the mobile & web site tracking experience of Star TV.

Key Roles:

Tracking day to day hit and visitor Trend, tracking user liked &Favorite Videos & TV Serials, Tracking User Subscription Path, and interest, tracking user Navigation and onsite search, tracking how long user played, paused video (or) Audio in Flash Player, User Trend, tracking live cricket match video view, hits to the site, user trend and Ads click through, tracking user forward and reverse Path Analysis, Tracking mobile sites navigation etc.

Technology& Consulting Sector:

Worked with Mahindra & Mahindra, IBM, KPMG

Key Roles:

Consulting and Tracking Intranet & internet sites, like Microsoft share point Portal tracking, since share point is not easy to track like normal website, and has good experience in tracking IBM Web Sphere Portal, worked in IBM for IDEA Cellular Project (Pune)

Client Management:

Good Experience with Client Management (Account manager), Consulting, and End user Training, Technical Meeting, POC of the Product, Product Demo, Product evaluation, Creating dashboards, e-meeting, good team player

iDashboards skill:

Creating Meaningful Charts & Dashboards for Business user, good in data source connectivity, ODBC, JDBC, Excel, MS SQL, MySQL.

Key Role:

Connecting different data sources from excel, SQL, ODBC, JDBC, etc. and making dashboards for business user, (i.e.) hotel wise booking in rooms, employee expenditure, Quarter, Half, Annual expense.

Achievements:

1. Got confirmation & promotion within six months of joining.

2. Best employee of the month oct-2011 & jun-2012 & Feb-2013.