Summary
Overview
Work History
Skills
Work Availability
Quote
Timeline
Generic
Salai Balaji S.N.

Salai Balaji S.N.

Chennai

Summary

  • 11 years of Experience in design, analysis, development and implementation of Various applications in environment using BI Tools.
  • Experience in Data Warehousing and Business Intelligence area in various domains.
  • Strong hands on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Good experience on in dashboards designing with large data volumes from various data sources ( Sql server , teradata etc).
  • Experienced in Analyzing the BI Needs, interpreting business user requirements and translating them into reports.
  • Good rapport with clients, understanding Business Applications, Business Data Flow and Data Relations.
  • Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.
  • Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.
  • Ability to handle multiple tasks concurrently and meet the deadlines.
  • Experienced in working with Banking, FMCG, Healthcare, Insurance clients & provided significant Analytical Insights

Overview

11
11
years of professional experience

Work History

Assistant Manager - Operations & Technology

Citibank
07.2019 - Current
  • Part of a global team & currently handling 2 major markets (Indonesia and Philippines) sales incentive computation based on the scorecard business model.
  • Developed SAS codes for computing the sales actuals for the various Citi wealth products.
  • Handling sales compensation program across 2 major international markets with a total of 350+ employees worth of 100+ multimillion payouts
  • Managed the Discretionary payout compensation for 350+ employees during COVID crisis.
  • Created standalone DataMart & used it for developing interactive Tableau dashboards for more insights.
  • Supporting Business in calibration of capacity planning, new incentive models using data analytics
  • Responsible for Audit control activities for Indonesia and Philippines & also for capacity planning for both markets incentive compensation program
  • Primary contact for issue resolution, involves research and analysis on sales incentive computation.
  • Effectively serving as the compensation lead to the senior management team on providing significant insights thru Tableau Dynamic Dashboards
  • Developed and maintain operational guidelines for staff.
  • Supervised operations team to support operational excellence and excellent customer service.
  • Monitored key performance metrics to identify areas for improvement.
  • Assisted in recruiting, hiring and training of team members.


Environment: SAS, Python, Teradata, Tableau Desktop/Server with DB (SQL, SAP Hana, Oracle, Teradata, DB2)



Technical Lead

LTI Mindtree
06.2018 - 06.2019
  • Understanding the Project requirements & involved in Estimation support to Managers.
  • As a Team lead handled 6+ resources & helped the team on development projects for clients COLGATE, PEPSICO, P&G etc...
  • Worked extensively on improving the performance of Tableau workbooks thru Performance recording logs & query analyzer.
  • Hands-on with Solution driven Story’s & dashboards by developing different chart types, created parameters, Sets & Combined Sets, Types of filters, Calculated fields.
  • Experienced in Context filters, Quick table calculation, Date & String functions, Data forecasting, Dual axis, Trend lines & bands etc.
  • Created rich dashboards with enough user level security to restrict the data by group level & user level.
  • Experienced in Tableau server reports backup restoration in case of failures, server upgrade and server performance tuning for optimization.
  • Administer user, user groups, and scheduled instances for reports in Tableau.
  • Prepare Dashboards using calculations, SETS, GROUPS, parameters ,Filters in Tableau.
  • Proof-read all documents and maintain accuracy of information and preparing SOP. Responsible for Developing Dashboard and preparing ad-Hoc Reporting.


Environment: SAS, Tableau Desktop/Server, SQL, SAP Hana, Oracle, MS Access, IBM DB2, Amazon S3, Teradata



Senior Software Engineer

HCL Technologies
01.2016 - 12.2017
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.
  • Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.
  • Converted existing BO reports to tableau dashboards.
  • Created different KPI using calculated key figures and parameters.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using TableauDesktop.
  • Involved in creating a dual-axis bar chart with multiple measures.
  • Implemented data blending to blend related data from different data sources.


Environment: Tableau Desktop , Tableau server, SQL Server 2012, IBM DB2, MS Access,Windows 2007 server, MS Office 2007, IBM DB2, Amazon S3


Programmer Analyst

Cognizant Technology Solutions
02.2013 - 12.2015
  • Carried out predictive & classification network & regression analysis on 3 million + Insurance data..
  • Proven working Knowledge in Regression (Linear & Logistics) Algorithms
  • Utilized the result to understand the direction & interest of insurance customers.
  • Worked on connecting to different DB including MS Access, Excel, SQL Server, IBM Db2
  • Developed visual analytics worksheets using Drilldown, Grouping, sorting, created sets, Filters etc.…
  • Have extensive knowledge in creating Trend lines, forecasting, clustering of data to get insights on insurance data.
  • Have work knowledge on using R within tableau environment, integrating them.

Skills

  • BI Tools: Tableau Desktop, Tableau Server, Tableau Prep, MS Excel, Power BI
  • Databases: Oracle 11g/10g / 9i, MS SQL Server 2005 / 2000, MS Access, Teradata, Mongo DB, IBM DB2, SAP Hana
  • Languages: C, C, SQL, SAS, Python
  • Applications: MS Word, MS Excel, Outlook, FrontPage, PowerPoint
  • Operating Systems: Windows 2000/2003/ Vista/ 2008, Windows 7, UNIX

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Quote

Each small task of everyday life is part of the total harmony of the universe.
Saint Thérèse de Lisieux

Timeline

Assistant Manager - Operations & Technology

Citibank
07.2019 - Current

Technical Lead

LTI Mindtree
06.2018 - 06.2019

Senior Software Engineer

HCL Technologies
01.2016 - 12.2017

Programmer Analyst

Cognizant Technology Solutions
02.2013 - 12.2015
Salai Balaji S.N.