Still Struggling with Tech Hiring? Discover Olibr's Solution Now!
Login / RegisterDeveloperClient
Login/Register

Ilayasoundari Ilayappan

BI Manager

  • Bengaluru, KA
  • 13 years

Available From: Available

    Candidate's About

    I have 14 years of experience in designing and implementing dashboards across the data warehousing domain. Presently working as a BI Team Lead at Google with experience in delivering valuable insights through data analysis, driving growth and record-setting profit improvements. Skilled in end-to-end data migration and reporting, with proficiency in Agile methodologies. Have strong leadership skills.

    Work & Experience

    T

    Team Lead

    Nov 21 - PRESENT

    Technology

    • Icon
      Power BI
    • Icon
      Tableau
    • Led the RefX SLS BI Team and defined BI strategy, managed and developed ongoing and ad-hoc activities and reports
    • Presented KPI quality reports to stakeholders on a yearly, quarterly, monthly and weekly basis
    • Defined the BI strategy, roadmap activities, and assigned and developed reports in Google Data Studio using Agile methodologies
    • Identify training gaps in repor...
    Read More
    S

    Senior Advisor - Tableau/Power BI Platform Team

    Nov 20 - Oct 21

    Technology

    • Icon
      Power BI
    • Icon
      Tableau
    • Delivered all projects using best practice methodology, managing risk, governance, quality assurance, issue resolution, and reporting
    • Liaised with Business Managers and Technology Teams to design, develop, deploy and enhance Tableau/Power BI dashboards
    • Established processes and created administration-related monitoring dashboards using Tableau metadata Global Platform and a...
    Read More

    Tableau/Power BI Platform Team Dashboards Development

    Senior Advisor

    • Created admin-related monitoring dashboards using Tableau metadata
    • Acted as the single threaded owner and contributed to company, organizational and team-level goals
    • Managed cross-functional project teams, planned, organized and executed complex projects across multiple organizations and stakeholders to enable the launch of projects and processes
    • Reviewed the design and development of end-to-end BI visualization reports using Tableau/Power BI
    • Involved in migration projects from traditional reports in Excel to Tableau/Power BI
    • Interfaced with business managers and technology teams to design, develop, deploy, and enhance Tableau/Power BI dashboards, and built processes like License Management, Service Tickets Handling for the BI Tools team and Governance process definition for Tableau/Power BI dashboards to enhance performance
    • Coordinated and collaborated with onshore teams across the globe to understand and design the dashboards, and suggested the right BI tool for their requirements efficiently
    • Acted as a global platform advisor for Power BI/Tableau, monitored, governed, and enhanced Power BI/Tableau frontend platform at a global scale
    • Supported global, regional consolidation & migration projects and worked with tracking tools like ServiceNow, JIRA, and Confluence
    • Worked on Agile based projects and delivered dashboards in a very short sprint time
    • Power BI
    • Tableau
    • Jira
    • Confluence
    • ServiceNow
    View Details
    S

    Senior Business Analyst – Corporate Communication Digital Dashboard

    May 20 - PRESENT

    Technology

    • Icon
      Power BI
    • Icon
      Tableau

    Tools

    • Icon
      Jira
    • Created a framework of digital dashboards for the Corp Communications team to analyze page traffic and understand user engagement to provide user-engaging and beneficial content on VMware web pages
    • Gathered VMware web page data from Adobe analytics and Google Analytics tools, and provided solutions in Tableau reports and stories

    Corporate Communications Digital Dashboards

    Senior Business Analyst

    • Worked closely with management (Stakeholders and Business Users) to prioritize among evolving business insight needs and developed digital dashboards in Tableau to consistently meet business needs
    • Developed the framework of digital dashboards for the Corp Communications team to analyze page traffic and understand user engagement to provide user-engaging and beneficial content on VMware web pages
    • Collected VMware web page data from Adobe analytics and Google Analytics tools and provided solutions in Tableau reports and stories
    • Tracked and explored engagement analytics related to the top Executive posts (with max followers) across various mediums like Social, Source, Newsroom, and Radius
    • Tableau
    View Details
    L

    Lead Developer (Legal BI Team)

    May 19 - May 20

    Technology

    • Icon
      Tableau
    • Icon
      Power BI
    • Prepared mock-ups, prototype reports, and developed visualization requirements by collaborating with business teams and users, publishing reports to server, troubleshooting, performance tracking and data source management
    • Performed data quality testing by comparing the output of dashboards/reports with database/source systems
    • Completed and delivered 5 end-to-end projects in...
    Read More

    DELL Technologies, India – Legal BI

    Lead Developer

    • Created mock-ups, prototype reports, and developed visualization requirements by working with business teams and users, publishing reports to server, troubleshooting, performance tracking and data source management
    • Served as the primary Tableau developer and Subject Matter Expert (SME) and worked closely with statistical programmers and statisticians to ensure data view tables and data sources were accurate and efficient
    • Conducted data quality testing by comparing the output of dashboards/reports with database/source systems
    • Implemented Tableau mobile dashboards with the help of Tableau mobile application
    • Completed and delivered 5 end-to-end projects in a short span of time
    • Worked on different business units such as Tier 3 - Case management, Political action committee and Disbursements, Total Data Management – contract management, Legal Business - Risk Management, T360
    • Delivered a POC on Tableau Mobile and demoed existing dashboards to stakeholders and business users and developed reports in Power BI
    • Featured in the DELL portal for delivering successful BI projects
    • Power BI
    • Tableau
    View Details
    D

    Data Management Analyst (APAC Marketing Ops Analytics and Data Management)

    Jul 15 - Apr 19

    Technology

    • Icon
      Tableau
    • Icon
      Power BI
    • Delivered standard and ad-hoc reports (weekly/monthly) to stakeholders, analyzed complex data for reporting and provided performance (trend) analysis, and provided weekly Lead management reviews
    • Created the APAC Marketing Domain - Lead Flow KPI Dashboard
    • Collaborated with FMMs to receive inputs/recommendations or changes in process or system and took appropriate action
      • ...
    Read More

    NetApp Inc. – APAC Marketing Ops Analytics and Data Management

    • Assisted with the daily operation of the APAC Marketing and APAC Field Marketing Teams to ensure smooth and efficient workflow and provided reports for marketing activities in collaboration with marketing managers and employees from other functional areas as a Marketing Data Management Analyst at NetApp Inc.
    • Provided data support and consolidation for quarterly proactive opportunity loads
    • Monitored and measured KPI performance and analyzed business trends
    • Consolidated regional metrics and reporting
    • Created Field Facing Reports and Targeting Sales Campaign Leads Report
    • Produced ad-hoc reports to support business insights and decision making
    • Reported on Marketing funnel performance and provided recommendations to optimize the customer experience across marketing platforms
    • Ensured measurability within the WW/standard dashboards and tools
    • Executed list uploads of standard templates and formats
    • Audited the Lead process and tracked lead status to ensure no lead was left behind
    • Ensured leads in SQL and SQO stages had valid contact and account association
    • Managed data quality and governance of key attributes
    • SQL
    View Details

    MarketOne, India

    Marketing Report Analyst

    • Delivered standard/ad-hoc reports (weekly/monthly) to stakeholders
    • Analyzed complex data for reporting and provided performance (trend) analysis
    • Collected requirements on reporting from FMMs and provided to Demand center Manager
    • Audited dashboard results against source platforms (Eloqua and Ascend)
    • Supported measurement and tracking of new KPIs
    • Involved in the Lead Association process
    • Associated the Leads to Opportunities based on inputs from FMMs
    • Tableau
    View Details

    Trigent Software Ltd.

    Tableau Developer

    • Understood and translated stakeholder requirements into performance metrics, reports, and dashboards; developed streamlined reporting and automated scorecards from various source systems
    • Developed reports and dashboard requirements in OBI and Tableau
    • Fulfilled ad-hoc requests for data extracts, data manipulation, data cleansing, and analysis from Marketing Users
    • Led statistical analysis and test data methodologies on Marketing data and delivered intelligence to the Marketing Ops team for demand generation opportunities
    • Liaised with FMMs to receive inputs/recommendations or changes in process or system and took action
    • Provided Lead management reviews on a weekly basis
    • Created Purchase Requests in the iProcurement tool
    • Tableau
    View Details
    T

    Technical Associate

    Nov 10 - Apr 12

    Technology

    • Icon
      Power BI
    • Icon
      Tableau
    • Troubleshot and resolved technical issues reported by customers
    • Configured, maintained, and troubleshot network equipment, such as routers and switches
    • Performed software installations, upgrades, and patches
    • Monitored and maintained system performance and security
    • Documented technical procedures and guidelines
    • Worked with senior engineers to identify...
    Read More

    3i InfoTech Limited

    Marketing Report Developer

    • Developed and maintained marketing reports and dashboards to support business decisions and objectives
    • Worked closely with marketing team members and stakeholders to gather and understand requirements for report development
    • Created and implemented reports that met business needs and aligned with company goals
    • Utilized data visualization tools such as Tableau, OBI, and Power BI to design and develop reports
    • Participated in code reviews to ensure the quality and maintainability of the report development
    • Troubleshot and debugged reports to resolve issues
    • Stayed up to date with new technologies and trends that could benefit the marketing team and the organization
    • Collaborated with other teams to ensure data integrity and accuracy in the reports
    • Provided training and guidance to junior team members on report development best practices
    • Continuously improved the report development process and methodology
    • Tableau
    • Power BI
    View Details

    XChanging

    Senior Software Engineer

    • Designed, developed, and maintained software solutions for the company
    • Collaborated with cross-functional teams to gather and understand requirements for software development
    • Implemented software solutions that met business needs and aligned with company goals
    • Participated in code reviews to ensure the quality and maintainability of the codebase
    • Troubleshot and debugged code to resolve issues
    • Stayed up to date with new technologies and trends that could benefit the company
    • Mentored junior engineers and provided guidance on software development best practices
    • Continuously improved the software development process and methodology
    • Participated in performance tuning and optimization of codebase
    • Worked with agile development process and Scrum team meetings
    • Worked on multiple projects simultaneously and deliver them on time
    • Tableau
    View Details
    S

    Senior Software Engineer (VMware Marketing Team – APAC Regions)

    Jul 07 - Oct 10

    Technology

    • Icon
      Tableau
    • Icon
      Power BI
    • Developed and maintained software solutions for the marketing team to support their efforts in the APAC regions 
    • Collaborated with marketing team members, stakeholders, and other teams to gather and understand requirements for software development 
    • Designed and implemented software solutions that met business needs and aligned with company goals 
    • Part...
    Read More

    Education

    K

    Masters in Computer Applications

    Kongu Engineering College
    2005 - 2007
    K

    B.Sc. Information Technology

    Kongu Engineering College
    2002 - 2004

    Certificates

    S

    Scrum CSM Certified

    Scrum
    S

    PSPO I

    Scrum

    Achievements

    • Featured in DELL Portal for delivering the successful BI projects in 2020.
    • Received the 'Pat on The Back' Award in 2009.
    • Bagged the Best Performer Award for the quarter twice in 2008 and 2009.
    • Implemented Tableau mobile dashboards with the help of Tableau mobile application.
    • Performed data analysis and framed the entire story package in building the Political Action Committee Dashboard For Dell Legal BI Project
    • Evaluated the existing SalesForce system (Source for the Marketing Team) and updated knowledge gaps by preparing the KPI reports and dashboards in Tableau.
    • Successfully led and completed the prestigious VMware Corporate Communications project within a short time of 6 months.