Tarit Bakuli
Kolkata
Summary
Having over 20 years of experience in the IT industry, I have extensive experience in the fields of database technologies, data modeling, data transformation, migration, ETL design, and cloud technologies.
Creative architect with a background in developing innovative and sustainable design solutions for diverse projects. Skilled in leveraging technical knowledge of building codes, materials, and construction processes to meet client needs effectively.
Extensive experience in architecting, designing, developing, and performance tuning data warehouses, data lakes, data marts using Sales, Billing, Invoice, Collection, Dunning, Sales, CRM etc subject areas in medium and large-scale legacy and Google Cloud platforms for various telecom, IT, and retail clients in Indonesia, India, and USA.
Interacted with clients to understand the requirements, to produce solution architecture, and to build and deploy the solution.
Overview
28
28
years of professional experience
1
1
Certification
Work History
Application Architect
IBM India Pvt Ltd
12.2024 - Current
- Alberta Health Services is Canada’s first and largest provincewide, integrated health system, responsible for delivering health services to more than 4.5 million people living in Alberta.
- My role is architecting, POC, design, and getting the solution reviewed, and getting approval from the IBM AMS and AH (Client's) Solution Architecture Team.
- Solutioning the requirements from business and IT, creating solution documents, and getting approval from project stakeholders.
- Develop and deliver the solution to Production, and hand over to the Run Manage team.
- Analyze and plan to enhance and streamline the existing MDM system
- Support the migration of the CloverDX application to the IBM DataStage equivalent application.
- Environment: IBM DataStage, Java, DB2, Erwin Data Modelling, MDM
Data Warehouse Architect and Solution Designer
IBM India Pvt Ltd
05.2024 - 09.2024
- Designed and architected the TO-BE DWH landscape, modeling, mapping, and data flow solution for customer, billing, sales, trade, campaign, contract, etc., subject areas in the Google Cloud platform for IOH – Indosat Ooredoo Hutchison, Indonesia.
- Developed a data lake and DWH application to process near real-time and batch data, and load it into the data lake, BigQuery DWH, and data marts. Created Tableau and Looker reports, and dashboards.
- Contributed to preparing the test strategy, test cases, test plan, and supported system testing, UAT, and performance testing.
- Leveraged technical skills in collaboration with the client and Datametica (vendor partner) team to identify the major issues and rectify the Raven tool.
- Environment: Google Cloud (Composer, Dataproc, Dataflow, Airflow DAG, UDF (User Defined Functions), files, GCS bucket, etc.), Python, Raven code conversion tool of Datametica,
Tech Lead (DWH/BI Platform)
Tech Mahindra Ltd
11.2011 - 05.2024
- L2 and L3 support for 3 Hutchinson’s DWH, ADW, MIS Applications from Jakarta (Indonesia) and India
- Design, develop, and deliver DWH and Angie MIS-related projects, CRs, and RRs related to prepaid and postpaid customers, quality assurance, reconciliation of transactions, rating, billing, invoicing, collection, dunning, sales, network performance etc
- Mentor, guide, and support the DWH Managed Service team in SRs and during critical situations.
- Support BI Practice, Presales (RFP/RIF response, and defend)
DWH Development and Configuration Lead
3 Hutchinson, Indonesia
11.2011 - 12.2022
- Manage team of 15+ DWH team to support Project, CR, RR related to DWH/ADW, MIS
- Solutioning, Design, Build and Deliver ETL jobs, Scripts, GP /PostgreSQL, Shell Script for production for varied business requirements
- Design and schedule report generation scripts in Crontab in Unix box on daily basis
- Performance tuning and SQL query enhancements to achieve performance targets
- Managing the incidents (TT) and the SR tickets
- Coordinating with Other OSS/BSS, Client’s BU, IT team
- Documentation, Status Reporting as applicable
- Achieve Delivery and Billing Milestones, Invoicing
- Environment: Greenplum, PostgreSQL, Unix-Shell Scripting, IBM DataStage, SAP Business Objects, Tableau, Oracle PL/SQL, Java SDK for BO
DWH Tech Lead
Etisalat India
Mumbai
04.2009 - 09.2011
- Implementation of Active & Enterprise Data Warehouse for EDB’s Operational, Analytic and DSS Reporting
- Architecting and solutioning DWH, ODS and MIS components
- Design, Build, Delivery of Teradata’s CDM (Logical and Physical), Build and orchestrating DataStage ETL jobs, build SAS EBI , OBI Reporting
- Designed Automation, QC, Alert & Monitoring
- Built Operational and Functional Dashboards
- Implemented Data Quality, Data Reconciliation and Audit process automation
- Participate in Requirement gathering sessions with Client’s Business and IT users, analyse, feasibility study, guide and recommend the best approach and roadmap
- Design testing strategy, test approach, Stress testing of the newly developed system, Integration and handholding with other OSS/BSS systems
- Performance tuning and SQL query enhancements to achieve performance SLAs
- Documentation
- Achieve Delivery Milestones
- Achieve Billing Milestones and Invoicing
- Environment: IBM IIS DataStage ETL version 8.5 PX, SAS EBI 9.2 (OLAP Reporting), Teradata, OBI Apps (Sales, Marketing, Service analytics), Teradata CLDM
Project Leader
Tata Tea Limited
Kolkata
11.2006 - 03.2009
- Project management, Advisory role to BU
- Team management, technical support and guide team
- Client interactions, conduct user meetings and workshops at different client locations in India
- Architecting and solutioning SAP BW DWH, Enable Multi- Dimensional Cubes, out of box Pipelines and Reports
- Develop custom canned, prompt reports and dashboards for all departments
- Environment: SAP BW Net weaver 2004s SP-18, ABAP, Oracle 10, Windows 2003 on HP Rack RX600
DWH Consultant
Tata Consultancy Limited
04.1997 - 03.2009
- Lead and Manage Project team
- Planning, Execution and Management of different Projects
- Requirement Gathering workshop, Blueprint, Designing, Build, Test and QA, Implementation and Support
- Documentation, Status reporting, User Signoffs
- Achieve Delivery, Billing Milestones and Invoicing, dispute resolution
Project Leader
Experian, CA, USA
Orange County
03.2003 - 10.2006
- Build new DWH/MIS system for Customer Profiling (Business) to build a customized MDM to support DSS and Order fulfilment], Data cleansing, profiling, data merging, enhancement, data standardization (name, address, phone number), building single truth data, automation
- Environment: Informatica, BO 5.1, Oracle 9i, Windows NT, 2K, Solaris 8, DB2 UDB 8.1, C, SQL, DataStage Basic (for server routines and Batches), IBM DataStage EE (Parallel v7.5), Quality Stage
Education
Master of Schience - Physics
Calcutta University
Kolkata, IndiaSkills
- Data warehousing
- Data integration
- Data modeling
- ETL development
- Data quality
- System architecture
- Problem solving
- Analyze data
- Performance improvement
- Data analytics
Certification
- Google Associate Cloud Engineer
- Enterprise Design Thinking Practitioner
- Data Integration Sales Foundation
- IBM Garage Foundations
- IBM Garage Essentials
- IBM Consulting way
Timeline
Application Architect
IBM India Pvt Ltd
12.2024 - Current
Data Warehouse Architect and Solution Designer
IBM India Pvt Ltd
05.2024 - 09.2024
Tech Lead (DWH/BI Platform)
Tech Mahindra Ltd
11.2011 - 05.2024
DWH Development and Configuration Lead
3 Hutchinson, Indonesia
11.2011 - 12.2022
DWH Tech Lead
Etisalat India
04.2009 - 09.2011
Project Leader
Tata Tea Limited
11.2006 - 03.2009
Project Leader
Experian, CA, USA
03.2003 - 10.2006
DWH Consultant
Tata Consultancy Limited
04.1997 - 03.2009
Master of Schience - Physics
Calcutta University
Similar Profiles
MUKESH KUMARMUKESH KUMAR
Automation Lead at Kyndryl Solutions Pvt. Ltd, IBM India Pvt. Ltd, Client: Airtel IndiaAutomation Lead at Kyndryl Solutions Pvt. Ltd, IBM India Pvt. Ltd, Client: Airtel India
Sameer P. MulgundSameer P. Mulgund
Network Reliability Engineer IBM Cloud at IBM, IBM India Pvt LtdNetwork Reliability Engineer IBM Cloud at IBM, IBM India Pvt Ltd
Anjan BhaumikAnjan Bhaumik
Scrum Master/Team Lead/workload Manager/Security Delivery Specialist at Kyndryl Solutions Pvt Ltd (Previously IBM India Pvt Ltd)Scrum Master/Team Lead/workload Manager/Security Delivery Specialist at Kyndryl Solutions Pvt Ltd (Previously IBM India Pvt Ltd)