Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic
Satham Hussain Ahamed Gani

Satham Hussain Ahamed Gani

#175, Middle Street, Jegathapattinam Post, Pudukkottai Dist, Tamilnadu

Summary

Senior ETL Developer with more than 11 years of professional experience in Software industry specializing in Data Engineering and Data Warehousing platform with expertise in Data Analysis, Design, and Implementation of Databases such as Teradata, IBM DB2, IBM Netezza and AWS Redshift & ETL processes using Informatica PowerCenter application. Proficient is writing, optimizing and tuning SQL queries. Domain Experience in major sectors such as Banking, Retail and Insurance.

Overview

11
11
years of professional experience

Work History

Senior Software Engineer

Tech Mahindra LTD
Bengaluru
02.2018 - Current
  • Involved in data model reviews with internal data architect, business analysts, and business users with an explanation of the data model to make sure it is in-line with business requirements.
  • Understood the requirement specifications, prepared the functional and technical design documents.
  • Well versed with Teradata Utilities such as MPP (Massively Parallel Processing), BTEQ, FLOAD( Fast Load), MLOAD (Multi Load)..,
  • Written documentation to describe program development, logic, coding, testing, changes and corrections, optimized the mappings by changing the logic and reduced running time.
  • Included error-handling and exception handling by logging in the error tables and sending an alert message via e-mail to the concerned distributions list.
  • Responsible for retrofitting the code to qa environment, and extending the support for the qa and uat for fixing the bugs.
  • Responsible for batch monitoring and break fix in the production environment.
  • Responsible for escalation management during the production support along with fixing the bugs.

Senior Project Engineer

Wipro Technologies
Chennai
09.2012 - 02.2018
  • Analyzed the business requirements and designed ETL solution and developed the code using informatica power center.
  • Partnered with cross-functional teams to implement advanced analytics on customers and products.
  • Working on integrating customer data from multiple data sources to achieve consistency in data and providing a single source of truth for business decision making.
  • Gathering the business requirements from the business users and performing an extensive data analysis on the internal host system.
  • Working closely with the business analysts to create mapping documents.
  • Designing complex and custom ETL code based on the requirements of the external vendor and internal host.
  • Modifying the schema XSDS based on the changing requirements.
  • Work with the external vendors technical team closely on the changes in the design of the interface.
  • Working with the bank's network team and external vendor to establish connectivity between the systems.
  • Performed troubleshooting if any issue arises.

Education

Master of Science - Software Engineering

BITS -PILANI
WILP (Work Integrated Learning Program)
12-2016

Bachelor of Science - Mathematics

Jamal Mohamed College
Tiruchirappalli, Tamilnadu, India
05-2012

High School Diploma -

Government Boys Higher Secondary School
Manamelkudi, Pudukkottai Dist
03-2009

High School Diploma -

Government Higher Secondary School
Kottaipattinam, Pudukkottai Dist
04-2007

Skills

  • Informatica Power Center 8x/9x
  • Teradata (14XX, 15XX & 16XX)
  • IBM DB2 (Toad, Coginiti)
  • IBM Netezza (IBM Certified)
  • IBM CDC (Change Data Capture)
  • Amazon Web Services, AWS Redshift (Aginity)
  • AWS S3 (Simple Storage Service)
  • AWS DMS (Database Migration Service)
  • AWS SCT (Schema Conversion Tool)
  • Oracle
  • Teradata
  • Unix Shell Scripting
  • MS Excel VB Macro
  • Automation Scripting using Power Shell
  • Control-M job Scheduling
  • Jenkins Pipeline Automated Deployments
  • Bitbucket/Stash/Sourcetree
  • JIRA Boards
  • Agile development methodology
  • Requirements Gathering
  • Troubleshooting/debugging
  • Technical Writing
  • ETL Design and Development
  • Data warehousing/Data Integration/Data mapping
  • Performance Tuning/Optimization
  • SQL / PLSQL /OLAP
  • Reporting Tools
  • Data Profiling
  • Problem Solving/Adaptability
  • Team work/Creativity
  • Algorithm Development
  • Conflict Mediation
  • Project Budgeting
  • Project Planning & Management
  • Tools Customization
  • Data Extraction/Analytics
  • Technical Analysis
  • Software Development Lifecycle (DEV, Testing & Deployment)
  • Operational Support (L1, L2, L3 & L4)
  • Project Documentation
  • Virtualization/Technological Integration
  • Quality Assurance
  • Team/Project Leadership Abilities
  • Pipeline Maintenance/Best Practices
  • Oral and Written Communications
  • Database Design/Data Synchronizations
  • Review of Designs/Resource Allocation
  • New Employee Mentoring/Technical Support
  • Design Reviews/Scope Development
  • Unit Test Cases/Usage Scenarios

Languages

Tamil
First Language
English
Proficient
C2
Arabic
Intermediate
B1

Timeline

Senior Software Engineer

Tech Mahindra LTD
02.2018 - Current

Senior Project Engineer

Wipro Technologies
09.2012 - 02.2018

Master of Science - Software Engineering

BITS -PILANI

Bachelor of Science - Mathematics

Jamal Mohamed College

High School Diploma -

Government Boys Higher Secondary School

High School Diploma -

Government Higher Secondary School

Similar Profiles

CREATE PROFILE
Satham Hussain Ahamed Gani