Ravindra Shekhawat

Experience

• 

  IBM

  Feb 2010 - Jun 2013

  Application Developer

  Project Name: ETL Hub, NSG Analytics & NRT SystemClient : Bharti AirtelLocation : GurgaonDescription of the project :ETL Extraction, Transformation, and Loading are done by using IBM InfoSphere Streams.Maintaining the Data warehouse system and generating various KPI useful for business purposes.NSG (Network Service Group) handles the network related issues faced by Bharti customers. The requirement is to enhance the existing BI system on Enterprise Data Warehouse for BI Mobility.NRT is a Near Real-Time System made for targeting customers on a real-time basis using Streams.Responsibility : Development of an ETL system using IBM Infosphere Streams.Migration of old ETL system to a new real-time system.Targeting customer on a real-time basis using Streams.Development of various Shell script, KPI's.Technologies Used: IBM InfoSphere Streams, DB2, SQL, Shell scripting, Cognos. Show less

• 

  DTAC

  Jul 2013 - Dec 2013

  Software Engineer

  Client : DTAC, ThailandProject : CMP (Contextual Marketing Platform)Role : Streams & Campaign DeveloperTeam Size : 7Environment : IBM Streams, IBM Unica Campaign, Interact, Oracle, IBM Power System.Project Duration: July 2013 – December 2013Roles and Responsibilities:• Design, development, and support for the real-time campaign, batch and interact campaign.• The order handling process in DTAC will be integrating with CMP for choosing the relevant campaign for the subscriber at the time of ordering a DTAC Product.• Responsible for processing the data from the set of sources defined as part of the scope and performs aggregation and analytical operation on the data to trigger events.• Create, execute and monitor campaigns.• Publish dashboard on a daily basis which includes a summary of all campaigns launched Show less

• 

  I2S Business Solutions

  Jul 2013 - Jun 2017

  Unica Campaign & Big Data Developer

  Client : Celcom, MalaysiaVendor : IBM MalaysiaProject : Next Best ActionRole : NBA Development and Support Team Size : 15Environment : IBM Streams 3.2, IBM EMM 8.5, Cognos, DataStage, Netezza, Oracle.Project Duration : Jan 2014 – June 2017Roles and Responsibilities:• Involved in the installation of IBM Streams, IBM Unica. • Development of real, batch & interact Campaign.• Configuration of IBM Streams & IBM Unica API.• Integrated with LDAP Server for Authentication and Authorization.• Setup cluster for high availability system which processes 0.5 billion CDR per day.• Created Schedules, Triggers, and dashboard system for Real-time Campaign Monitoring.• Setup of the real-time system that processes all types of CDR including prepaid, post-paid, roaming, Semi-Structured, Structured, Parser. Client : DTAC, ThailandProject : CMP (Contextual Marketing Platform)Role : Streams & Campaign DeveloperTeam Size : 7Environment : IBM Streams, IBM Unica Campaign, Interact, Oracle, IBM Power System.Project Duration: July 2013 – December 2013Roles and Responsibilities:• Design, development, and support for the real-time campaign, batch and interact campaign.• Order handling process in DTAC will be integrating with CMP for choosing the relevant campaign for the subscriber at the time of ordering a DTAC Product.• Responsible for processing the data from the set of sources defined as part of the scope and performs aggregation and analytical operation on the data to trigger events.• Create, execute and monitor campaigns.• Publish dashboard on a daily basis which includes a summary of all campaigns launched Show less

• 

  Celcom Axiata Berhad

  Jan 2014 - Dec 2018

  Senior Consultant

  Project Name : NBA Client : Celcom Location : Kuala LumpurRoles and Responsibilities:• Involved in the installation of IBM Streams, IBM Unica. • Development of real, batch & interact Campaign.• Configuration of IBM Streams & IBM Unica API.• Integrated with LDAP Server for Authentication and Authorization.• Setup cluster for high availability system which processes 0.5 billion CDR per day.• Created Schedules, Triggers, and dashboard system for Real-time Campaign Monitoring.• Setup of the real-time system that processes all types of CDR including prepaid, post-paid, roaming, Semi-Structured, Structured, Parser. Development and support for different types of the campaign including real-time campaign, A batch campaign using IBM InfoSphere Streams and IBM Unica Campaign.Monitor different types of events based on the data and requirements.Maintain/Publish the dashboard for daily activity and jobs.Part of daily activity is doing housekeeping, sending alerts and notifying the users.Automate the system with the help of various shell/python/Perl scripts.Work on service request, new change request and PMR.Technology Used : InfoSphere Streams, Python, Unica Campaign, Unica Interact, UMO, Unica Marketing Platform, IBM WebSphere, Oracle , Unix, Shell scripting, Redis NoSQL DB, Perl. Show less

• 

  SMS Outsourcing Services Sdn Bhd

  Jul 2017 - Jan 2019

  Senior Consultant

  Project Name : NBA Client : Celcomvendor : TCSLocation : Kuala Lumpur• Provide end to end support for IBM Unica products-Campaign, Interact and Marketing Operations.• Involved in the installation of IBM Unica. • Development of real, batch & interact Campaign.• Configuration of Unica API.• Integrated with LDAP Server for Authentication and Authorization.• Review campaign daily cycles and ensure completeness.• Troubleshoot issues faced by users, campaign managers and provide them with timely resolution.• Monitoring day to day activities of the system, application health check.• Provide daily reports based on the campaigns run daily and as per the request of the business users.• Provide support for the defects raised by the business users.• Analyze the campaign runs to check for the targets.• Checking of Unica Interact logs.• Deploying Interactive channels.• Maintaining the servers for Unica Campaign, Interact and Marketing operationsTechnology Used : InfoSphere Streams, Python, Unica Campaign, Unica Interact, UMO, Unica Marketing Platform, IBM WebSphere, Oracle, Unix, Shell scripting, Redis NoSQL DB, Perl.Responsibility: NBA Support and DevelopmentProject Name : Digital Transformation, ITSM Portal, Celcom Agent Adaptive Desktop.Client : Celcom -MalaysiaEnvironment : UIPath, SQL Server.Role : Senior DeveloperRoles and Responsibilities: • Setup the Orchestrator, Robot, Studio in UIPath.• Automate the Siebel Website.• Read and write to Excel.• Read and Send email from the mail server with and without Attachments.• Extracting the data from the web application and Write back to Excel.• Worked on different recorders (Desktop, Web).• Created Custom Logs to understand the process Execution. Show less

• 

  Freelancer

  Mar 2019 - now

  Freelance Consultant

  Currently working as a freelancer.Working on HCL UNICA campaign Marketing tool, python, shell scripting.