Summary
Overview
Work History
Education
Skills
Accomplishments
Work Availability
Work Preference
Websites
Software
Timeline
CustomerServiceRepresentative
GANESH SIVAKUMAR

GANESH SIVAKUMAR

NSW

Summary

  • As a Business Analyst with over 10 + years of experience, I specialize in translating complex business requirements into actionable, results-oriented strategies that improve operational efficiency, drive growth, and foster innovation. My in-depth understanding of both business processes and technical solutions enables me to lead high-impact initiatives and ensure alignment between stakeholders and development teams.
  • Extensive experience in stakeholder management, team mentoring, business analysis, ETL and BI development, quality assurance, and application maintenance, driving impactful results across all phases of project delivery.
  • As a Technical Business Analyst, I have led stakeholder engagement, proof of concepts (PoCs), metadata preparation, and data profiling. I've also conducted impact assessments, developed business cases, use cases, and designs, while supporting project and program planning.
  • My technical proficiency includes tools such as Informatica PowerCenter, OBIEE, UNIX Shell Scripting, SQL, Oracle, and Teradata, along with hands-on experience in Ab Initio MBLT & MRT tools.
  • I have a proven track record of managing projects end-to-end, from ideation through delivery, within Agile frameworks. My experience also includes working with scheduling tools like Control-M and DAC, as well as installing and configuring platforms like Informatica (10.4.1), OBIEE (11g), and DAC.
  • Throughout my career, I've contributed to complex development processes involving ETL workflows, reporting solutions, SQL optimization, and Unix scripting. I've independently handled multiple projects, mentored team members, and fostered a collaborative environment to ensure successful outcomes.
  • A proactive team player with a passion for continuous learning, I'm always enthusiastic about exploring new technologies and expanding my knowledge.

Overview

10
10
years of professional experience

Work History

Tech Lead - DA

Sutherland Global Services
Chennai, India
11.2023 - 03.2025
  • Project Overview: The SOX project automates long-standing audit and sales reports by streamlining data integration from multiple systems using DataStage and Cognos, reducing manual effort, cost, and improving report accuracy and accessibility.
  • Led a cross-functional team of data engineers and testers, overseeing all phases of project delivery from planning to execution, ensuring seamless integration of technical solutions with business goals.
  • Managed project timelines, resource allocation, and stakeholder communication throughout the entire SDLC, driving efficient execution and successful project outcomes.
  • Analyzed business requirements and conducted analysis to design proof of concepts (PoCs), showcasing feasibility and providing actionable insights and recommendations to stakeholders for informed decision-making.
  • Created Business Requirements Documents (BRD) and Functional Requirements Documents (FRD), clearly defining project objectives, stakeholder needs, and technical specifications, ensuring alignment with business goals and enabling smooth development.
  • Developed ETL data flow pipelines using Informatica from source to target layers, defining data transformations to ensure data integrity and alignment with business needs.
  • Created and maintained detailed project documentation in Confluence, ensuring comprehensive tracking of project progress, technical specifications, and key decisions for easy reference and collaboration across teams.
  • Explained complex logic to the team, guiding them through the process and advising on best implementation strategies, while taking ownership of developing intricate logic and ensuring smooth execution.
  • Managed the end-to-end (E2E) process, identifying opportunities for data quality improvements, implementing best practices, and continuously enhancing data workflows to support business goals.
  • Demonstrated agility and flexibility in responding to changing business needs, proactively adjusting strategies to ensure timely and effective delivery of business solutions.
  • Possess strong knowledge of Data Warehousing concepts, including Star Schema, Snowflake Schema, SCD Types, Dimension and Fact tables, and CI/CD processes.
  • Spearheaded project proposals, estimations, and resource planning, while conducting monthly one-on-one meetings and performance feedback sessions to foster team growth and ensure successful project outcomes.
  • Collaborated closely with stakeholders throughout the entire project lifecycle, from initial requirements gathering to UAT sign-off, and provided comprehensive warranty support to ensure smooth post-delivery operations.
  • Sutherland Global Solutions provides business process outsourcing services.

Senior Business Analyst

HCL Technologies Ltd
Chennai, India
08.2021 - 10.2023
  • Project Overview: Served as a Technical Business Analyst for CBA's Balanced Scorecard (CDAO), leading the automation of executive reports in Tableau by analyzing data sourcing, enrichment logic, and reporting workflows across Hadoop, Hive, Teradata, Informatica, and Ab Initio for metadata management
  • Gathering requirements and translating them into accurate, actionable user stories/ Business requirement documents for Dev, QA team members.
  • Metadata preparation, Data Profiling and developed ETL data flow pipeline by using Informatica /Ab initio tool from the Source to Target layers and defining data transformations.
  • For New Source systems, created infrastructure setup (Firewall setup, Encryption Key, Stream, CI number Business Key logic and Target DB creations).
  • Experience in Gap Analysis, Data Profiling and finding dependencies between Upstream, Downstream in Github and Reference tables.
  • Prepared Evaluation Report in Impact Analysis, Data Kaizen E2E, OLA, SMP documents.
  • Good knowledge in Data Science & Data warehouse concepts like Star Schema, Snowflake, SCD Types Dimension, Fact tables and CI / CD processes Application.
  • Creating XLR requests and supporting RMT, Ops team for Higher Environment Code deployments and Job executions Involving in BVT Validations and sign-off.
  • Day-to-day project coordination, planning, and implementation across multiple project teams (Onsite/Offshore/Nearshore).
  • As a Proxy Scrum Master, Handling all sprint activities including maintaining backlogs, sprint closure and Retrospective meetings.
  • Project proposals, Project estimation & Resource Planning Monthly one on ones & Performance feedback.
  • HCL Technologies is a multinational IT services and consulting company.

Associate

Cognizant Technology Solutions
Chennai, India
08.2018 - 07.2021
  • Project Overview: As a Senior Associate for Zurich Australia (Insurance), I collaborated with business stakeholders to gather requirements and deliver ETL solutions using Informatica 10.4.1, including dimension/fact loads and metadata design, while supporting Agile delivery and coordinating across onshore-offshore teams..
  • Responsible for Managing Entire SDLC Activity for (ZIA, Ztrack) Systems.
  • Work with Stakeholder and SME to define scope and timelines.
  • Gather, design and demonstrate proof of concepts to business stakeholders on feasibility and implementations.
  • Evaluated project requirements, identified challenges and proposed alternatives if any using research and data.
  • Supported software code review, system integration and validation in line with company and regulatory requirements.
  • Upgraded and configured Informatica (10.4.1).
  • Cognizant is a multinational technology company that provides IT services.

Consultant

Ernst & Young
New Delhi, India
01.2018 - 07.2018
  • Project Overview: Worked with Pernod Ricard India as an ETL Developer, designing and implementing end-to-end data pipelines using Informatica, including SCD Type-2 mappings, data warehouse modeling (facts/dimensions).
  • Worked on designing fact and dimension logic with SCD-2 implementation using Informatica PWC from JD Edwards and flat file source.
  • Responsible for environment deployments, UAT coordination, and post-production support with admin activities
  • Handled missing data and hierarchy issues during target load creation, ensuring data integrity and accuracy.
  • Prepared comprehensive unit test cases and documented results to validate ETL logic and support quality assurance

Software Engineer

Verizon Data Services Pvt Limited
Chennai, India
03.2016 - 09.2017
  • Project Overview: Verizon Data Services provides data and telecommunications services.
  • Wrote and developed new and well-tested code for different software projects.
  • Integrated third-party applications into existing software, enhancing features and performance.
  • Created new implementation using Informatica and OBIEE.
  • Developed automation scripts to Deploy ETL Objects as part of DevOps Using GIT and Jenkins.
  • Verizon Data Services provides data and telecommunications services.

ETL - Engineer

Sify Technology Pvt Limited
Chennai, India
05.2014 - 02.2016
  • Project OVerview : Aggregated distributed data from multiple sources into an Oracle EDWH for calculating key sales, service, engineer, and financial metrics.
  • Created Facts and Dimension in DWH using ETL (Informatica 9.5.1).
  • Worked on OBIEE with data sourced from oracle and Sql.
  • Sify Technologies provides a range of IT services including telecom and data center services.

Education

MSC - Software Technology

VIT University
12.2014

BCA - Computer Application

Vels University
12.2012

Skills

  • Requirements Elicitation
  • Proof of Concept (POC) development
  • Gap Analysis
  • Data Profiling
  • Stakeholder Management
  • Process Optimization
  • ETL
  • Data Warehousing (DWH)
  • Business Intelligence (BI)
  • Unix
  • Excel, MS-Word, Microsoft PowerPoint
  • Test Estimation
  • Agile methodologies
  • Ab Initio Tools (Express IT,Control Center)
  • Informatica Power Center
  • OBIEE
  • Windows,Unix
  • Databases (DB) -Oracle,Hive,Teradata,MySQL,PL-SQL,SQl
  • Shell Scripting
  • Control-M,DAC

Accomplishments

  • Distinguished Performance awards for years 2022-23.
  • Received appreciations from Client for Cost reduction and Reliability.
  • Awarded as an outstanding contributor of the year by Verizon Wireless President.
  • Attended training in Data-Stage,R. Certified By Brain Bench For Data Warehouse.
  • Concepts Certified by VIT for Presenting paper in International Conference.

Work Availability

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

Work Preference

Work Type

Full TimePart TimeContract Work

Software

ETL - Informatica

OBIEE

ABinitio

Shell Shell Scripting

DAC,Control-m

Oracle,Mysql,SQL server,Hive,Terdata

Timeline

Tech Lead - DA

Sutherland Global Services
11.2023 - 03.2025

Senior Business Analyst

HCL Technologies Ltd
08.2021 - 10.2023

Associate

Cognizant Technology Solutions
08.2018 - 07.2021

Consultant

Ernst & Young
01.2018 - 07.2018

Software Engineer

Verizon Data Services Pvt Limited
03.2016 - 09.2017

ETL - Engineer

Sify Technology Pvt Limited
05.2014 - 02.2016

MSC - Software Technology

VIT University

BCA - Computer Application

Vels University

Similar Profiles

CREATE PROFILE
GANESH SIVAKUMAR