Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

SAKTHI GANESH S

Summary

Results-oriented individual with a passion for continuous learning and innovation. Known for leveraging analytical thinking and creativity to solve problems and deliver high-impact solutions in fast-paced environments.

  • Over 17 years of experience in IT with 9 plus years of experience managing and leading DW/BI teams.
  • Strong technical knowledge on relational and Dimensional data modelling (Star and Snowflake schema).
  • Experience in database design, data analysis, data cleansing and data transformation using ETL tools.
  • Create and maintain source to target data mapping documents and which includes source to stage & stage to dimensions/fact.
  • Strong T-SQL Programming skills including Tables, Stored Procedures, Views, Indexes, Triggers, functions etc.
  • Experience in query optimization & performance tuning using Execution Plan, SQL Profiler
  • Reviewed peers' code and provided best practices to rewrite the code and optimize it.
  • Experience in monitoring and making recommendations for performance improvement in databases. This involved index creation, index removal, index modification and adding scheduled jobs to re-index and update statistics in databases
  • Good experience of analyzing source and target data relationships
  • Designing and deploying of SSIS packages as per the end-user request and experience in Logging, Error-handling by event handler for SSIS packages
  • Worked on Logical and Physical database modelling using Visio tool
  • Domain experience in Retail, Healthcare, Campus Management
  • Good team player and can work independently
  • Good experience in creating Azure Data Factory pipeline.
  • Excellent Client interaction background and offshore-onsite team co-ordination.
  • Experience in MuleSoft ESB.

Overview

22
22
years of professional experience
1
1
Certification

Work History

Senior Technical Architect

Sonata Software
09.2016 - Current
  • Handling two DW projects for more than 6 years
  • Data Modeler: Designed and developed a common data model from scratch for different business units and merged them into a single SSAS cube
  • This data model includes many dimensions and a fact table
  • The fact table currently supports millions of records with good query performance
  • Collaborated with business stakeholders and onsite lead before finalizing the data model
  • Created a standardized ETL load process for all the data provider from source to stage and to Dimension/fact tables
  • Implemented the SCD2 methodology for accessing the history of a few dimensions
  • Designed a data warehousing solution to load Sugar CRM data to EDW system
  • This ETL process will read data from various modules from Sugar CRM to SQL Database using a console application and load the data into the Fact and Dimensions table in the CRM data mart
  • This process helps business users with quick decision-making and improves reporting speed and accuracy
  • Created stored procedures, packages and jobs using MS-SQL Server
  • Worked on performance tuning, performance monitoring and enhancement of various projects
  • Provide production support related issues when the team need any help
  • Helping the Tableau and Reporting team if they require in Data Model related queries
  • MuleSoft Integration: Currently working on a MuleSoft project to create a common engine to handle multiple clients
  • Develop REST APIs using Anypoint API designer
  • Created System API and Process API Used Database, Request, HTTP connectors

Module Lead

Aspire System
09.2012 - 08.2016
  • Project Name: SCA Planner, Bedrock
  • Involved with Database Architecture team to re-architect the database for durability and performance
  • Created tables, indexes and constraints
  • Developed and review Stored Procedures, Trigger, Views for the new developments
  • Involved SSIS package design, development, Performance tuning and QA deployments
  • Involved DB/SSIS related troubleshooting
  • Created new SSRS reports as per the end-user request
  • Managed DEV/QA/Production SQL Server 2012
  • Identifying slow running queries
  • Reorganization of data and index pages and fragmentation of Indexes using SQL
  • Unit Testing the created Stored Procedures, functions and SSIS packages
  • Responsible for monitoring/Capture CPU usage and send analysis report to onsite team
  • Responsible to capture unused/missing and suggest remove/adding

Senior Database Developer

Talisma Corp Pvt Ltd
03.2011 - 09.2012
  • Review DB objects such as Store Procedures, functions, DDL, triggers, and Views etc.
  • Performance tuning
  • Working closely with On-Site DBA and Project Manager
  • Working with Client Support - DB related issue
  • (Performance tuning, data analysis and ad-hoc query for report)
  • Working with Application Developers when they need any support for DB related issues

Senior Software Engineer

Tesco HSC
10.2007 - 03.2011

Software Engineer

Covansys India P. Ltd
04.2007 - 10.2007

Software Engineer

US Technology
10.2006 - 03.2007

Software Engineer

Baba Technical Innovation Inc
02.2005 - 09.2006

Programmer

Glink Software Services
01.2003 - 01.2005

Education

MCA -

Bharathidasan University
01-2001

B.Sc Computer Science -

Adhiparasakthi College Of Science
01-1998

Skills

  • RDBMS: MS-SQL Server 2016/2019, MySQL
  • BI Tools: MSBI (SSIS, SSRS, SSAS)
  • Proficient in T-SQL,SSIS,SSAS Performance Optimization, Java Script, C#Net, Python (Intermediate)
  • Experience in MuleSoft ESB
  • Cloud Technology: Azure, ADF, Snowflake (Intermediate)
  • Anypoint Platform: RAML, Runtime Manager, MuleSoft ESB 4, API Design, Dataweave
  • Data Modeling

Certification

  • 70-461 - Querying Microsoft SQL Server 2012
  • 70-462 - Administering Microsoft SQL Server 2012 Databases

Accomplishments

    Received the Best Employee of the Year award after visiting the USA for a data warehousing project

    Received the Best Trainer award for providing T-SQL training to both freshers and mid-level professionals

Timeline

Senior Technical Architect

Sonata Software
09.2016 - Current

Module Lead

Aspire System
09.2012 - 08.2016

Senior Database Developer

Talisma Corp Pvt Ltd
03.2011 - 09.2012

Senior Software Engineer

Tesco HSC
10.2007 - 03.2011

Software Engineer

Covansys India P. Ltd
04.2007 - 10.2007

Software Engineer

US Technology
10.2006 - 03.2007

Software Engineer

Baba Technical Innovation Inc
02.2005 - 09.2006

Programmer

Glink Software Services
01.2003 - 01.2005

MCA -

Bharathidasan University

B.Sc Computer Science -

Adhiparasakthi College Of Science

Similar Profiles

CREATE PROFILE
SAKTHI GANESH S