Sourav Maity
Pune
Summary
19.6+ years’ experience in IT industry with experience in Design development and implementation, Product Support/Migration that includes 19+ yrs. in IT career. Data warehousing ETL Technologies such as IBM- Data Stage, DWH, BI, ETL. Oracle, DB2, Mongo DB, SQL. Snowflake Comprehensive understanding of the Data Modeling (conceptual, logical, and physical), create and deliver high-quality data models, by following agreed data governance and standards. Maintain quality metadata and data related artefacts which should be accurate, complete, consistent, unambiguous, reliable, accessible, traceable, and valid. Agile Methodology, PMP, ITIL Certified. Experienced on GCP, Cloud, Big Query & Cloud Shell along with Kafka Confluent. Worked as a Scrum Lead Master facilitates all the communication and collaboration between leadership and team players to ensure a successful outcome. Experienced in Agile SDLC, UAT and Production Support in Enterprise Environment. Closely worked with Domain Managers and business requester to understand the requirement & created HLD & LLD as per the requirement and created a backlog in the Project SOW document. Worked on several domains like Telecommunication, Retail, Banking & Financial Services Worked on major Clients like AT & T, Suncorp, IDEA Cellular Ltd., Bharti Airtel, QBE Foster, Bright Speed, STC, DCT-Westfield, TJX, TD Bank Canada, INDOSAT etc.
Overview
20
20
years of professional experience
1
1
Certification
1
1
Language
Work History
Associate Tech Specialist / BI Project Lead
Tech Mahindra Limited
- Client: STC
- Project Role: Associate Tech Specialist / BI Project Lead
- Client: SunCorp
- Project Role: Associate Tech Specialist / BI Project Lead
- Location: Bangalore/Bengaluru
- Skills/Technologies I have worked during my current company ‘Tech Mahindra Limited’ which are ETL tool called IBM-DataStage, GCP, Cloud, Big Query ,Python, Data Pipelining, Pub Sub, Kafka Confluent, BO Dashboard ( Reporting Application), Scrum Lead Master role, Jira, Data Modelling as a Data Modeler( Conceptual, Logical & Physical) , Big Picture ( Project work forecasting and updates for each Sprint Plan) , Project Planning & lead onshore and offshore teams. 5+ years of experience in data engineering, with a focus on cloud-based solutions. I have extensive experience on GCP, Cloud , BigQuery, DLQ, Pub/Subs, Dataflow. I have worked with Apache Beam, a unified programming model that allows developers to write efficient and robust batch and streaming data processing pipelines. In particular, I have built pipelines to perform analytics over large datasets stored in GCP Dataflow such as Google BigQuery, Google Cloud Storage, Google Pub/Sub, and others.
Project Leader/Test Lead
DCT-Westfield / Accenture
- Client/Company: DCT-Westfield / Accenture
- Projects: Claim ODS Replatform
- Assigned Role: Project Leader/Test Lead
- I had worked as a Team Leader\Project Leader in this project. I have been managing onshore and offshore teams. All HLD/LLD along with requirement gathering managing by me. I have been gathering business requirements and used to attend twice weekly meetings with clients. The purpose of this document is to provide a detailed design and approach to replace the Claim Center ODS from Microsoft Transact SQL to IBM Data Stage V11.5 In Netezza. Managing this tool for Test management scope. Test lead is the additional role performed by team in this project. To accomplish this data migration, the ETL (Extract, Transform, and Load) tool IBM Infosphere Data Stage V11.5 is used. This document will primarily focus on the Re-Platform of Claim center ODS in Netezza.
- Client/Company: TJX BI, TJX GMI / Accenture
- Projects: TJX BI and TJX GMI
- Assigned Role: Team Leader
Senior Data Engineer / Tech Lead
Tech Mahindra Limited
03.2019 - Current
- Client: INDOSAT
- Project Name - IOH ADMS ( DWH TSA Exit )
- Client: BrightSpeed
- Project Name - DWH TSA Exit
- Project Role: Associate Tech Specialist / Scrum Lead Master
- Location: Pune
Application Development Team Lead
ACCENTURE SERICE PVT. LTD.
02.2013 - 03.2019
- Client: TD Bank Canada
- Project - 1: TD MBNA Data Conversion
- Domain: Financial Services
- Client/Company: QBE Foster / Accenture
- Project – 2 : QBE AO
- Assigned Role: Application Development Team Lead
- Location - Bangalore
- Project & Assignment Description: I had worked as a Team leader for my client QBE AO (Australia Operation). This project has 3 types of work like AM (Application Management), AME (Application Management Enhancement) and AD (Application Development & use IBM-DataStage, Unix, SQL, Oracle SQL Developer, Team Management and Project forecasting involved with Senior Leader.
- Client/Company: TJX BI, TJX GMI / Accenture
- Projects: TJX BI and TJX GMI
- Assigned Role: Team Leader
Senior Technical Associate [TeamLead]
TECH MAHINDRA LIMITED
04.2012 - 02.2013
- CLIENT : AT & T
- Project : AERS Development
- Location: Pune
- Synopsis: ARES Development involved DW development for AT & T Client.
- Responsibilities: Starting this project for AT & T client. Worked as a Senior Technical Associate [TeamLead] and leading a team. I have involved gathering the estimation and I worked on gathering requirements, developing, and unit testing for all areas. I have given extremely tight deadlines for completion of this project, I had involved gathering the client meeting and gathering the business requirement to implement the stuff in Development and UAT as well as Production development systems with improvement of the data quality and efficiency of the deliverable. I have handled all developments as well as onsite team to deliver the project smoothly. I was also involved to server migration and up gradation part in IIS v8.7 servers. I have handled 3 projects simultaneously and used to attend all client meetings.
BI Transformation
IBM India Pvt. Ltd.
06.2010 - 04.2012
- CLIENT : IDEA
- Project : BI Transformation
- Synopsis : BI Transformation involved DW development for Idea Client. It was catering to Prepaid Customers across 22 circles / states in India. The Prepaid Data comprising of both Usage & Non-Usage Streams for every circle needed to be incorporated in the Idea Data warehouse and accordingly reports for the same were developed. These reports are now being used by Idea Higher Level Management for effective decision making to include flexibility in analyzing subscriber behavior and capability to enhance revenue through campaign management and cross-selling and up-selling products.
- Responsibilities: Involved in Creation of Design for Usage Level Stream in DataStage, involved in Interaction with Clients for Design & Requirement gathering, interacted with users during UAT and promoted the code to Production, Took part in Postproduction Support Activities. Handling entire DataStage team and distribute the work weekly basis. Reviewed DataStage jobs and implemented with proper performance tuning for all the DataStage jobs.
ETL Developer
Connectiva Systems India Pvt. Ltd
09.2006 - 06.2010
- Client: IBM-Bharti
- Project-1: RAS Phase -2
- In this Phase Revenue Assurance (RA) is about building controls to all the revenue leakage risks in Provisioning, Network monitoring, HLR, Intec Billing, Mediation, Order Management. The key process of the RA solution is to identify the cost drivers & root causes of revenue leakages. The system is based on RA Mediation (RAM), Massive Collection System (MCS) build on WAS environment, the ETL product – Datastage-7.5.2, Connectiva Platform- ONEREVIEW Analysis System for Reports. The scope comprises of Extraction, Transformation and Loading (ETL) of data from Switch, Interconnect, Rating (Arbor), Billing, IN, HLR, Mediation for all three LOB of Airtel (Wireless, Wireline, LDS). Here we are getting data on a daily, monthly and weekly basis.
- Role: ETL Developer
- Responsibilities: Understanding customer requirements, reporting requirements making feasibility studies, gap analysis and participated in solution architecture. Management & elementary administration of development DataStage server. Design, development and implementing DataStage jobs ranging from preprocessing shell-scripts, configuration files to job development and scheduling in Job sequence. Involving in Performance Tuning Jobs process identifying and resolve performance Issues. Guiding team members writing various PL/SQL Merge scripts, Cursors from reporting point of view. Reviewing various UNIT-Test docs prepared by dev-team and plan for other white-box testing then transferring the same to test environment. Co-ordinate with Product Development Team (off-site) and work closely with Development team (on-site) to ensure internal deliverables are in line with expectations and delivered on time. Installing DataStage Server (Enterprise edition-7.5.1A) on AIX platform and required DataStage level configuration file creation and setup of the Database [Oracle, DB2] connectivity and tested DS jobs. Doing DataStage administration activities for DataStage Server (Enterprise edition-7.5.3A on AIX platform and Oracle and Db2 connectivity as well as DataStage Configuration level file creation and DS job developed.
- Project-2: RAS Phase-1
- Client: IBM-Bharti
- Location: New Delhi , Noida & Gurgaon
- The project is a Revenue Assurance project for one of the biggest telecom providers in world BHARTI. Here Revenue Assurance (RA) is about building controls to all the revenue leakage risks in Switch to Mediation or from Mediation to Rating or from Rating to Billing processes. The project involves huge data coming from various Bharti sources, which then is extracted, transformed and loaded into a data warehouse following a snowflake Schema. Then further business objects universe is created so that users can create reports and find discrepancies. Now RAS Phase-1 is running on product support.
- Role: Technical Analyst
- Responsibilities: Identify business system requirements from various mapping (IA) docs and related Gap Analysis and developing application solutions for a complete business process. Co-ordinate and work closely with DataStage Development team to ensure internal deliveries are in line with expectations and delivered on time. Design, development and implementation of DataStage jobs ranging from preprocessing shell-scripts, configuration files to scheduling in Job sequence. Developed solutions for complex logic by writing routines and transform functions, modifying job control. Involving in Performance Tuning Jobs process identifying and resolve performance Issues. Scheduling and sequencing the jobs according to the requirement.
Education
MCA -
IGNOU
Skills
Proven ability to balance a changing workload
Willingness to innovate, experiment, and take risks
Ability to be flexible and adaptable in an evolving environment
Fast learner, Keen inclination towards learning new technologies and processes
Team & Independent Player with excellent Communication, Organizational and interpersonal Skills
Planning, initiating and successfully executing multiple concurrent projects
Guides, trains, instruct and assist others at lower levels on straightforward technical issues
Effective project reporting for top-level management Have Knowledge on SDLC process and end-to-end project DWH project management process
Resource Planning, Project deliverable and involved day-to-day meeting with client for requirement analysis
Complete lifecycle experience in scoping, designing, developing, deploying, and supporting enterprise scale business application software Managed 15 people engineering teams, including distributed offsite and onsite staff Experienced in fostering a motivational team environment resulting in greater team productivity
ETL: DataStage PX 75, 81, 85,87,90,19,12,113,115,117 along with DataStage Server Edition 752, Information Analyzer, Information Data Architect tool for Data Modelling
Informatica Power Center
OLAP: One Review (Connective’s OLAP Tool), SAP BO
Scheduling: Tivoli 13, Data Stage Job sequencer, Corn tab (UNIX), Control-M
Data Modelling: OLAP & OLTP , Data Analysis or Data Modelling (Conceptual, Logical, and Physical)
RDBMS: DB2 953, ORACLE 8i/9i/10g/11i, Netezza, Teradata, No SQL ( Mongo DB)
Operating System: Windows/98/2000 and XP, IBM AIX64 820, UNIX 53,61/65
Database Tools: Toad 76, AQT 81, SQL Loader
Language: SQL, C, Shell
Testing Tool: HP-ALM
DevOps Tools: Git
GCP, Cloud & it related services such as Big Query, Pub/Subs, Dataflow, DLQ, Cloud Shell, Cloud Storage, Cloud composer & others skills like Snowflake Kafka Confluent, Jira , Big Picture, Scrum Lead Master
Certification
IBM-DataStage, PMP, ITIL, GCP Cloud Computing L1, Generative AI : Prompt Engineering Basics & Preparing Professional Cloud Architecture certification.
Timeline
Senior Data Engineer / Tech Lead
Tech Mahindra Limited
03.2019 - Current
Application Development Team Lead
ACCENTURE SERICE PVT. LTD.
02.2013 - 03.2019
Senior Technical Associate [TeamLead]
TECH MAHINDRA LIMITED
04.2012 - 02.2013
BI Transformation
IBM India Pvt. Ltd.
06.2010 - 04.2012
ETL Developer
Connectiva Systems India Pvt. Ltd
09.2006 - 06.2010
Associate Tech Specialist / BI Project Lead
Tech Mahindra Limited
Project Leader/Test Lead
DCT-Westfield / Accenture
MCA -
IGNOU
Personal Information’s
Father’s Name - Late Mr. Rabindranath Maity Sex - Male Marital Status - Married Nationality - Indian Languages Known - English, Hindi and Bengali. Passport No. - T3334234 (Exp. Date 15th April 2029) I herewith declare that the above information's furnished by me are true, correct and complete to the best of my knowledge Date : 2026-03-19 Place : Pune
Domain Experience
Telecommunication, Financial Services, Retail , Banking