Download PDF

Summary

Rajesh Rajamani has 11 years of experience in solution design for Automation , BI reporting and Analytics. He works on projects with special focus in Robotic Process Automation , Data Analytics and Business Intelligence . He is a programming enthusiast and  is an expert programmer with Python , R , VBA , C #.net and proficient Database architect with SQL and noSQL databases such as MongoDB and Graph DB .His expertise in Data Visualization includes proprietary tools such as Tableau 10.4 , Microsoft Power BI , SQL Server Reporting Services and open source tools such as Pentaho BI , D3.js , dc.js 

Work History

May 2016Present

Senior Consultant - Knowledge Services

Intelenet Global Services
  • Consulting SME for Robotic Process Automation , Analytics and Insights .

Projects worked:

Text Miner :  A multi-channel text mining system with NLP and Machine learning . Provides sentiment analytics / content enrichment and theme extraction for customer comments 

Role : Solution Design , ML - algorithm development 

Tools used : Python ,d3.js , dc.js  , SQL Server , NLTK 

Medical Record Analytics : Uses advanced integration with Unified Medical Language System , ICD 10 Coding standards to provide Analytics on medical records for 

Role : Solution Design , ML - algorithm development , Database design and management 

Tools used : Python , Visual Studio 2015 , Mongo DB 3.4 , Apache SPARK

Apr 2014May 2016

Manager - Business Intelligence

Intelenet Global Services
  • As a Consulting Subject Matter Expert for Business Intelligence provide strategy & design support for MI transformation across verticals.
  • Solution Architecture & Application support for internal data-portal.
  • Analytics support for clients on-demand and as part of Value Added Services model.

Projects worked:

BI Transformation - Leading Logistics major US

Project Objective:

  1. Provide subject matter expertise on Business Intelligence transformation
  2. ETL- Transformation design from client's mainframe database

Tools Used:

  1. SQL Server 
  2. EasyTrieve COBOL
  3. JCL for MainFrame

MI Transformation : Leading e-retailer UK

Project Objective:

  1. Leading  e-retailer in UK with extensive footprint in UK market in fashion , electronics , household consumer goods.
  2. Voice , Social Media and Email channels for customer interaction 
  3. 14 service lines and 43 KPI's 
  4. Challenges in Performance Insights management  due to legacy technologies.

Solution Strategy and Design:

1.Systematic reconciliation process of existing reports and technology

2. Agile transformation model to sustain BAU reporting and design a sustainable BI and DW architecture using Teradata , MySQL and SAS Base  programming.

In a span of 9 months achieved 98% on-time report delivery on business reports and deployed a Performance Management Dashboard for visual management. Earned stake-holder and client appreciation for the transformation and was declared a  Key Critical Resource as part of the Business Continuity and Development strategy.

Tools Used:

  1. TeraData Manager 
  2. SAS 9.2
  3. Tableau Server

 

Train Operation Performance Analytics : Leading Train Operating Company - UK

Project Objective:

  1. Leading train operating company in UK with more than 150 + stations , 98 daily services. 
  2. Dropping satisfaction rates in Passenger Focus survey
  3. Needed to turn-around for better customer service and improved satisfaction scores

Analytics Support:

  1. Performed Descriptive Analytics to focus on trends in challenge areas spanning stations, trains and operations
  2. Identified process gaps using sampling techniques to evaluate transactions.
  3. Highlight on actionable insights focusing customer experience improvement across areas.
  4. Provide comparison study of processes used by competitors using on-ground tests by  using passenger services and workflows.
  5. Predictive modeling to identify variables that influenced customer satisfaction .
  6. Prescriptive actions for client to undertake across operation areas.

Tools Used:

  1. R Programming .
  2. ARIMA , Holt Winters , Signal De-composition for Forecasting , Linear Regression 
  3. SQL Server Analysis Services
  4. Microsoft Power BI

 

 

Jun 2010Mar 2014

Assistant Manager - Business Intelligence

Intelenet Global Services


  • Subject Matter Expert for MI-Transformation
  • Analytics support for clients and internal stake-holders
  • Application Support for Organization KPI aggregation tool.

Projects worked:

Utility Debt Recovery Strategy Design- Energy Retailer, Australia

Project Objective:

  1. Campaign strategy for Debt Recovery Management
  2. Risk Scoring model with available variables
  3. Reporting design

Solution Support:

  1. Perform descriptive trend analysis to identify variables for Risk Scoring
  2. Design scoring model for customer classification
  3. Gross Flow Reporting deployment for campaign effectiveness measurement

Our strategy and scoring model resulted in improved Debt recovery for our client. Worked with clients at our Melbourne office to oversee the final deployment and support.

Tools Used:

  1. R- Programming
  2. Random Forest , Linear Regression
  3. SQL and Microsoft Excel

Our strategy and scoring model resulted in improved Debt recovery for our client. Worked with clients at our Melbourne office to oversee the final deployment and support.

Application Architecture Design - Organizational Data-warehouse - Loading Station

Project Objective:

  1. Internal performance management framework based on guidelines
  2. Web-based application for data  collection , organization and reporting
  3. Standardization of KPI measurement

Solution Support:

  1. Web based application design.
  2. Deployment on cloud for access over internet in secure channel.
  3. Extensively configurable module for users to upload data.
  4. OLAP Cubes on SQL Server Analysis Services.

Tools Used:

  1. SQL Server Integration & Analysis Services
  2. ASP.net Framework


Jul 2007May 2010

Team Leader - MIS

Intelenet Global Services


  • Performance Reports for Debt Recovery clients U.K. & U.S.A
  • CRM performance optimization
  • Reporting Automation

As part of the US Debt Management vertical responsible for a team of 3 executives and deliver performance reports for Operations management. Dialer strategy support to operations. Transitioned MI delivery for 3 clients from US and 1 from Australia. Upgraded existing reporting system to a web-based model.


Sep 2005Jul 2007

Executive - Credit Card Operations

GE Money - India

Daily reconciliation of payments received for credit cards

Outstanding list management for all of South-India

Managing 4 MIS associates for performance reports on Risk management.

Month-end Cash recon.

Liaison with Central Performance Excellence team for Regional reports

Education

Jul 2006May 2009

Master of Computer Applications

Annamalai University , Chidambaram , Tamilnadu.

Masters in Computer Applications

Jun 2001May 2005

Bachelor of Science - Applied Chemistry and Information Technology

Annamalai University , Chidambaram , Tamilnadu.


Major in Chemistry and Information technology from Directorate of Distance Education

Certifications

Oct 2015Dec 2015

Six Sigma - Green Belt

Indian Statistical Institute

Six Sigma - Green Belt Certification

Jun 2015Jul 2015

Data Science with R- Programming

SimpliLearn

Certified Data Scientist with R Language.

Skills

Visualization

Tableau Desktop and Server,Microsoft Power BI,Microsoft SSRS and SSAS,

D3.js , DC.js

Database

SQL Server , MySQL , MS Access , mongo DB , Graph DB

Programming

R, Python , Excel VBA , COBOL for Mainframes