Abhisar Kumar Sinha
Pune
Summary
Technology professional with extensive experience at Tata Consultancy Services, UBS, Infosys, Principal Finance, and Tech Mahindra. Proven expertise in Oracle SQL, PL/SQL coding, Unix shell scripting, data science, artificial intelligence, feature engineering, and Hadoop administration. Successfully delivered solutions for clients in trade management, telecommunications, investment banking, and insurance sectors. Strong track record of leveraging technical skills to drive business results and enhance operational efficiency.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Assistant Consultant
Tata Consultancy Services
Pune
06.2022 - Current
- Maintained Trade Management derivatives system for Credit Suisse, focusing on stability and efficiency.
Resolved batch failures and performed report extractions to support operations.
Utilized PLSQL coding and Unix Shell Script for process automation.
Diagnosed errors in logs to ensure timely problem resolution.
Contributed to release management, scrums, and stability discussions.
Monitored system health using Geneos for proactive issue detection.
Applied data science and AI techniques to enhance automation, exemplified by ticket analysis tracker.
Authorized Officer
Union Bank of Switzerland
Pune
10.2019 - 05.2022
- Led technology initiatives in investment banking to enhance operational efficiency.
Identified errors and generated comprehensive reports for performance analysis.
Managed change requests and migration processes to support system upgrades.
Oversaw daily tasks and housekeeping activities to ensure system stability.
Handled Big Data management as Hadoop Administrator using Ambari.
Implemented automation solutions utilizing PL/SQL and Unix Shell scripting.
Technical Lead
Infosys Ltd.
PUNE
04.2017 - 10.2019
- Delivered technical support as technology lead, overseeing Change Management and Release Management processes.
Managed Incident Management, ensuring efficient resolution of technical issues.
Automated tasks using PLSQL and Shell scripts to enhance operational efficiency.
Optimized SQL queries to improve performance and reduce execution time.
Administered Hadoop ecosystem components including Yarn, Hive, Pig, Sqoop, and Zookeeper.
Implemented monitoring solutions to maintain system reliability and performance.
Coordinated cross-functional teams for successful technology implementations.
System Engineer
Principal Global Services
Pune
07.2015 - 03.2017
- Streamlined client manual tasks by developing SQL (Oracle) query to extract millions of records from database in 15 minutes
Software Engineer
Tech Mahindra Ltd.
Pune
07.2011 - 07.2015
- Executed manual monitoring of acute processes by accessing databases and servers.
Collaborated with team to program tasks using UNIX shell scripts.
Automated first-level DBA activities, including identifying database locks and terminating sessions.
Resized database file sizes and increased extents to optimize performance.
Monitored mount points to ensure system stability.
Managed release handling for system updates and maintenance.
Education
Bachelor of Engineering - Computer Technology
RTM Nagpur University
Nagpur, India06-2011
Skills
- Oracle SQL and PL/SQL coding
- Unix shell scripting
- HDFS ecosystem management
- Data science with Python
- Machine learning design
- Splunk monitoring
- AppDynamics performance management
- Geneos infrastructure monitoring
- Grafana visualization tools
- Change management strategies
- Incident management processes
- Python programming
- Solaris operating system expertise
- Middleware technologies
- Message queueing systems
- Enterprise messaging services
- Job scheduling tools
- Problem resolution techniques
- Troubleshooting methodologies
- Reporting tools proficiency
- Release management practices
Certification
- Certified by Microsoft on Azure Fundamentals
- AZ104
- AZ305
Projects
Italy and Hermes Pegaso ASM- implemented technologies for British Telecom, such as Clarify, Citrix, UNIX, Oracle 11g, Bridge Production 6.0, Easy Sell, SQL Developer, and PLSQL by collaborating with the Application Support Team
Cascade-India: Managed daily tasks and functions of British Telecom’s pricing website as well as web logic concerns and HTMLs.
NCDB-India: Operated as an ASG in NCDB application regarding single reference source that deliver pricing data and network changing to number of subsystems. PDB-India: Functioned as an ASG in the portfolio database application, which is based on the portfolio product model and deals with the product’s lifecycle management. Group proposal system and claims, solved data issues, and presented reports by SQL queries to users, also oversaw daily service requests, change requests, housekeeping, and incidents
Group Operations - Rhino/Topcat, supported investment banking for Union Bank of Switzerland as a technology lead,
Trade Management- currently supporting Trade Management derivatives system for Credit Suisse client as Assistant Consultant
Timeline
Assistant Consultant
Tata Consultancy Services
06.2022 - Current
Authorized Officer
Union Bank of Switzerland
10.2019 - 05.2022
Technical Lead
Infosys Ltd.
04.2017 - 10.2019
System Engineer
Principal Global Services
07.2015 - 03.2017
Software Engineer
Tech Mahindra Ltd.
07.2011 - 07.2015
Bachelor of Engineering - Computer Technology
RTM Nagpur University
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
Pravin WadicharPravin Wadichar
Technical Lead and Architect at Siemens Technology and Services Pvt LtdTechnical Lead and Architect at Siemens Technology and Services Pvt Ltd