Muthu Kumar P
Summary
Technical lead with a cumulative work experience of 10 years of ETL experience and having extensive experience in Banking domain has enabled me to hone my skills in the areas of Data Warehousing (ETL) and Data mining with extensive experience - Oracle ,PL/SQL, Teradata, Datastage (ETL), Autosys, Python and UNIX.
Overview
13
13
years of professional experience
Work History
Technical Lead
Tata Consultancy Services
01.2016 - Current
- Technical Lead for 15 members team in the project, working in onsite Singapore for four years and responsible for project implementation without any issues in Production and having good knowledge about banking domain.
- Well-versed knowledge in Data warehousing, Data Modelling and ETL and Reporting
- Has been Enthusiastic, Proactive, and Good Team player for challenging jobs
- Keep tracking of extra activities involving the space requirement that is very critical on daily basis to ensure 100% data load
- Written complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
- Involved in modifying various existing packages, procedures, functions according to the new business needs
- Created indexes and partitions to get better performance
- Handling Critical release activities, reviewing Changes and Releases that happening in production and implementations every month
- Effectively handling issues raised by business for all Apac – Emea countries
- Handling Audit deliverables across countries
- Have received continuous three A bands in TCS
- Received On the spot and Star of the Team award thrice, Best Performance Improvement Project - Unit Level for the work done in the projects, best team award twice
- Got Appreciation for fine tuning long running queries running during batch
- Dealing with high value customers under Citi Private banking sector.
- Deploy the code changes via U deploy portal
Support Engineer
Wipro Technologies
11.2011 - 12.2015
- Leading the 3 member team to develop and support CITIBANK DWH for India
- Optimization and fine tuning the long running jobs
- Involved in Enhancement, Development, Testing, Implementation in UAT and PROD and Support
- Code Promotion PROD (Raising CR for Lib, DBA and PCO activities)
- Defining daily, weekly and monthly schedules and co-ordination with PCO
- Space maintains Unix Server as well as Oracle Server
- Closing of incident then and then to avoid SLA breach
- Awarded ARCHMEDES Award for Technical and domain innovation at CITI ITO-G2C DABI DWH project
- Appreciation from Client for Excellency in Deliverables and ensuring meeting SLA
Education
B.E - ECE
M. Kumarasamy College of Engineering
01.2011
Skills
- SQL
- Unix shell scripting
- Abinitio
- C Language
- Python
- Datastage 115
- Oracle
- Teradata
- Toad
- Teradata SQL Assistant
- COGNOS 10/11
- HTML
- XML
- Basics of Jscript
- Tivoli
- Autosys
- LEAN
- Six Sigma
Extracurricular Activities
Volunteer in Purpose For Life – have taught underprivileged school students in corporation schools in weekends as part of Purpose For Life programmes.
Hobbies and Interests
- Playing Cricket
- Football
- Running
- Swimming
Technologysummary
SQL, UNIX, C Language, Python, Datastage 11.5, Oracle, Teradata, Toad, Teradata SQL Assistant, COGNOS 10/11, HTML, XML, Basics of Jscript, Tivoli, Autosys, LEAN, Six Sigma
Timeline
Technical Lead
Tata Consultancy Services
01.2016 - Current
Support Engineer
Wipro Technologies
11.2011 - 12.2015
B.E - ECE
M. Kumarasamy College of Engineering
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Srikanth SSrikanth S
Technical Lead at Infovision Labs India Pvt Ltd (Client : Verizon)Technical Lead at Infovision Labs India Pvt Ltd (Client : Verizon)