Summary
Overview
Work History
Education
Skills
Software
Key highlights/Projects
Extra-Curricular
Languages
Disclaimer
Timeline
Generic
SUNIL C

SUNIL C

Advisor, Business Intelligence
Bengaluru

Summary

OBJECTIVE

To optimally utilize my present Skills & abilities, expertise and knowledge in the organization and at the same time to grab opportunities for constant learning and career development to excel in corporate career & aiming for constant professional as well as personal growth.

CAREER SUMMARY

  • Currently working with DELL in Data Engineering and Business Intelligence team as an ADVISOR, Business Intelligence from April – 2013 to till date.
  • DEBI Reporting Skills: Excel reports, SQL, Data Mining and Tableau designing, Visualization and Dashboard development
  • Power BI report designing using basic DAX and power query.
  • Database/Software skills: SQL, DBEAVER, SQL Server, Oracle 9 & 11i, Green plum, PG Admin, Big Data Lake (BDL) and Dell Data Lake (DDL).
  • Reporting tools: Hands on experience on Crystal, Xcelsius, Tableau and Salesforce.
  • Tableau Skills: Creating/Designing the Interactive dashboards in Tableau Desktop versions like 8.1, 8.2, 9, 9.1, 10.1 and latest Tableau 2023.1 version.
  • Computer skills: MS-Office, Excel, Word, Access and PowerPoint. Basics in programming using Pascal, C & C++.
  • Worked in Accounts Receivables (AR) team, DELL|EMC as Senior Financial Analyst from April – 2008 to April – 2013.
  • Subject Matter Expert in Accounts Receivables process.
  • Expertise in Invoicing, Cash -application, Reporting, Bank reconciliation and Journal Ledger.
  • Business Travel to Sydney, Australia on EDISON Project (ANZ Transition) during my tenure in AR team .
  • High performing individual with a proven track record of achieving business targets with high drive for results, with the ability to develop good relationship with customers and communicate effectively with all levels of decision makers.
  • Graduate in Bachelor of Science (B.Sc - PMCs). Total Work Experience of 16 Years 3 Months in Software and Services. 1year 2 months in Banking and Financial services.

Overview

18
18
years of professional experience

Work History

ADVISOR, Business Intelligence

DELL INTERNATIONALS SERVICES INDIA PRIVATE LIMITED
4 2013 - Current

Job Description :

DEBI team is responsible for managing reports, Dashboards & automation for various organizations and implements business intelligence gathered from various processes and systems. Also manages tableau reporting activities for financial, Professional Services, Remote & Field organizations.

Key Responsibilities:

  • Manages process and reporting activities to include financial, productivity, quality compliance, training, and/or efficiency, etc. Analyzes data to provide decision support to senior management.
  • Identifies key operational and performance metrics to measure business performance and drives reporting activities. Measures performance of the organization against strategic and tactical operational metrics. Develops business models, business cases and forecasting tools in support of various strategic initiatives.
  • Identifies operational inefficiencies as well as best practices and drives improvement initiatives with senior management and operations teams. Acts and customer advocate for processes, metrics, measurements, and tools developed for management of the business.
  • Acts as a liaison and interfaces cross-functionally to maintain communication between business groups.
  • Developing custom SQL queries, Designing TCE dashboards, CSAT and KPI's using Tableau Desktop and tracking the indicators behavior and optimizing the exiting queries.
  • Presenting the performed Analysis, Reports and Dashboards to the end user and executives through Tele Presence, Meetings and Conference call.
  • Working with various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups and Parameters in Tableau Desktop.
  • Creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Bubbles, Histograms, Bullets, Heat maps and Highlight tables in Tableau Desktop.
  • Working with large dataset in Green plum and building Dashboards using the large dataset in Tableau. Monitoring Global Service reporting mailbox.

Senior Financial Analyst

DELL|EMC
04.2008 - 02.2013

Job Description :

Accounts receivable team is responsible for generating invoices & keeping an up-to-date billing system by applying cash based on payment made by customers using Oracle11i Software. Keeping a check on monthly receivables by performing Journal entry, Bank & cash reconciliation activity while making sure that billing & reporting activities are carried out per specified dates to avoid collection errors.

Key Responsibilities:

  • Importing report from catalyst/oracle on daily basis & generating Invoices & posting/mailing invoices as per customer requirement file as per the set time based on company standards.
  • Downloading statements on daily basis to have clear picture on daily cash collections & cash application.
  • Cash reconciliation by tallying Applied & unapplied Register with Receipt Register, Unapplied Register & Transaction Register. Issue Debit and Credit Memo.
  • Bank reconciliation on every month end by passing Journal entries, filling necessary templates & sending it to In-country AR Manager for a Month/Quarter end closure approval.
  • Responsible for customer query mails on Invoices and cash posting & so on.
  • Mentoring team members on communicating with Order Management team & PAS team for Incorrect Customer details & customer's authorization to ensure invoice processing without any discrepancies.
  • Solely responsible for Australia - New Zealand invoicing, cash application & Bank reconciliation.
  • Associated with Greater China, Southeast Asia & European Middle East Africa countries invoicing, cash & Bank reconciliation.
  • Preparing Excel Dashboard reports for the team on daily, weekly, monthly & quarterly. Preparing Tactical deck & taking tactical calls.
  • Preparing month end reports on APJ & EMEA countries for calculation on accuracy & SLA.
  • Business Travel to Australia (Sydney) on EDISON Project (ANZ Transition) during my tenure in AR team.

Executive Trainee

SHRIRAM GROUP OF COMPANIES KARNATAKA PRIVATE LIMITED
03.2007 - 04.2008
  • Worked as Assistant Branch Manager in General Insurance, Banking & Legal department
  • Responsible for maintaining Front Office Staff and Legal Staff
  • Responsible to assign targets to team on Cash deposits and collections
  • Responsible for Maintaining Chits, Deposits, General and Life Insurance products and train new team members
  • Responsible to organize weekly/monthly/quarterly meetings with Branch Managers, RO and ED to update on the branch progress.

Education

Bachelor of Science - Computer Science

Sharada Vilas College
Mysore University, Karnataka, India
04.2001 -

Skills

Tableau report developer

Software

Flexible to work in cross-culture business environment

Ability to manage multiple priorities and assignments

Capable of resolving problems effectively

Result oriented, honest & hard working, confident and trustworthy

Key highlights/Projects

  • EDISON Project : A business travel to Australia(Sydney) during Q2 2010 on ANZ Invoicing, cash application & bank reconciliation transition. Successfully completed the KT with process documentation and trained new team members on this process with 100% accuracy and productivity.
  • GREEN Belt Project : Cross functional training on business process like Order Management, Professional Account Service and Accounts payable. Assisted team manager on Automation of Invoicing process and presentation on Greater china and ANZ invoicing and cash application process.
  • BDL to DDL Migration : Successfully migrated our core data assets, dashboards, and reports from BDL to DDL. In partnership with IT, and ensuring minimal customer interruption, Involved in planning, testing, and re-building and effectively collaborated across functional areas to ensure a seamless transition.
  • A&E Consolidation : Preparing for the A&E integration and 11i decoupling by doing pre-work to remediate dashboards before go-live. Participated in the testing of the production data with thorough reviews against data quality, expected data trends, and applied business knowledge to differentiate between data flows and process changes.
  • Attended Lean Six Sigma Yellow belt, Communication Skills, team effectiveness, Problem Solving & Decision Making, Advanced MS Excel, MS Access trainings.
  • Achieved Rewards & Recognition award for Best performance during Q3 2008, Q1 2010, Q2 2014, Q4 2016, Q3 2018, Q1 2021 and Q2 2024.

Extra-Curricular

A professional cricketer who has represented Mysore University, Zone, Karnataka U-22, BEML, Central Excise and reputed 1st division clubs in Bangalore.

Represented Mysore University in Badminton and Volleyball.

Active Member in Rotary Club Cubbon Park, Bangalore.

Active Professional Cricket Coach during weekends.

Currently playing for TEAM INDIA Masters in INDOOR Cricket.

Awarded as BEST ATHLETE during my school and college academics.

Captain for DELL|EMC Corporate Cricket team.

Languages

English
Bilingual or Proficient (C2)
Kannada
Bilingual or Proficient (C2)
Hindi
Advanced (C1)

Disclaimer

I hereby declare that the above said information is true and correct to the best of my knowledge and belief.

Timeline

Senior Financial Analyst

DELL|EMC
04.2008 - 02.2013

Executive Trainee

SHRIRAM GROUP OF COMPANIES KARNATAKA PRIVATE LIMITED
03.2007 - 04.2008

Bachelor of Science - Computer Science

Sharada Vilas College
04.2001 -

ADVISOR, Business Intelligence

DELL INTERNATIONALS SERVICES INDIA PRIVATE LIMITED
4 2013 - Current
SUNIL CAdvisor, Business Intelligence