Amit Sonar
Mumbai, Maharashtra
Summary
Expertise in solving various business problems, with overall 14.7 years experience as an IT professional. Highly skilled Site Reliability Engineer with 3 years of experience in developing and implementing system monitoring and alerting tools, disaster recovery plans, and automation and configuration management tools. I have interest to work in AI/ML domain. I also have an experience in developing ML models , performing EDA on large data sets by participating in hackathons. 11.7 years of experience in developing solutions using ORACLE SQL PL/SQL and Informatica. I have passion for earling new skills and I am able to discover real solutions for real problems.
Overview
16
16
years of professional experience
Work History
Site Reliability Engineer
JPMorgan India Services Pvt Ltd
Mumbai
06.2022 - Current
- Developed and implemented monitoring solutions to improve system reliability.
- Performed root cause analysis of production incidents and provided recommendations for improvement.
- Collaborated with development teams to ensure proper release engineering practices are followed.
- Implemented automation tools to increase efficiency in deployment processes.
- Provided technical guidance on the design, implementation, and maintenance of cloud infrastructure.
- Monitored systems performance using various metrics such as latency, throughput, availability.
- Ensured high availability and scalability of applications across multiple environments.
- Troubleshooted complex issues related to application architecture and system configurations.
- Documented best practices and procedures for incident response activities.
- Conducted regular reviews of alerts generated by monitoring tools to identify potential issues.
- Performed capacity planning activities based on current usage trends and future projections.
- Participated in post-mortem reviews following major outages or incidents.
- Developed strategies for disaster recovery plans that ensured minimal downtime during an outage.
- Provided training sessions on SRE principles and best practices to team members.
Associate Technology
JPMorgan India Services Pvt Ltd
Mumbai
08.2015 - 06.2022
- Involve in the development, implementation of various database related tasks & stories
- Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL
- TRACE, TKPROF and AUTOTRACE
- Extensively used bulk collection in PL/SQL objects for improving the performing
- Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching
- Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL
- Data warehousing, ETL informatica
- Use of AJILE SCRUM methodology in the development work
- Developing various Oracle Applications using PL/SQL, SQL
- Plus
- Collaborating with users through all Software Development Lifecycle (SDLC) phases
- Gathering requirement from client
- Developing functional and technical specification
- Created Interface using Package, procedure and function
- Troubleshooting issues, and fixing bugs; Also, conducting quality reviews of code developed by other development staff.
IT Analyst
Tata Consultancy Services
Mumbai
06.2014 - 08.2015
- Optimized and modified the triggers, complex store functions, procedures, user base data type etc
- Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and implementation experience in complete SystemDevelopmentLifeCycle
- Responsible for the dealing with the clients for their requirements independently
- Dealing with and resolving problems and issues which arise
- Arranging & chairing weekly team meetings, focusing on targets & achievements
- Implementing new initiatives
- Ability to handle team of developers & co-ordinate smooth deliveries of project.
Sr. Software Engineer
Financial Software and Systems
Mumbai
05.2010 - 05.2014
- Involve in the development, implementation and support of the database of the server
- Optimized and modified the triggers, complex store functions, procedures, user base data type etc
- Responsible for the dealing with the clients for their requirements independently
- Involved in database migration from DB2 to ORACLE 11g
- SQL Query optimization and tuning
- Developing various Oracle Applications using PL/SQL, SQL
- Plus
- Use Oracle E-Business Suite applications, supporting data extraction, filtering, and validation
- Collaborating with users through all Software Development Lifecycle (SDLC) phases
- Creating extensions using Oracle recommended frameworks
- Reporting against Applications data model
- Writing technical design documents for conversions, extensions, interfaces, and reports
- Gathering requirement from client
- Developing functional and technical specification
- Created Interface using Package, procedure and function
- Troubleshooting issues, and fixing bugs; Also, conducting quality reviews of code developed by other development staff.
Graduate Developer
Lbi India Limited
Mumbai
12.2007 - 12.2008
- Responsible for team co-ordination for the project and delivery of the release
- Involved in development of the web application; enhancement of the application; UAT preparation of the application; Support for the application to the users
- Instrumental in the creation of the user defined applications, database classes, stored procedures and views and user controls
- Responsible for the testing, fixing the bugs and troubleshooting the technical problems
- Done Unit testing and system integration testing of the developed code
- Provided fixes to the issues identified in testing phase
- Prepared specifications, impact analysis document, and various kinds of reviews
- Interaction with client, Design, Development and bug management
- Responsible for the analyses of the requirements of the business, designing database tables.
Software Engineer
Nucsoft Limited
Mumbai
- Instrumental in analysis, designing and coding of the database including performance, diagnosis and troubleshooting of problem programs and designing solutions to problematic programming
- Developed the procedures, functions, triggers, packages, Forms and Reports
- Wrote SQL, PL/SQL, SQL
- Plus programs required to retrieve data using cursors and exception handling
- Handled the client problems and troubleshoot and fixed the bugs
- Supervised the development of software systems to form a basis for the solution of information processing problems
- Writing, editing, and debugging new computer programs for assigned projects, including necessary records and desired output
- Worked closely with upper management.
Education
Master of Science - Data Science
Liverpool John Moore University
Liverpool02-2023
Post Graduate Diploma - Data Science
International Institute of Information Technology
Bangalore01-2022
Bachelor of Engineering in Information Technology -
University of Mumbai
01.2007
Certified -
Certified -
Certified -
Skills
AI/ML
- EDA
- Regression Models(Linear,Logistics), Clustering Model(K means),
- Decision Tree Models, PCA, Boosting,Time Series Models
- Deep Learning - CNN, RNN,Tensorflow,Pytorch
- Python - NumPy,Pandas, Matplotlib,Scikit Learn
SRE(Site Reliability Engineer)
- Application Performance Monitoring tools - AppDynamics, Dynatrace
- Application Monitoring tool - Geneos
- Automation Testing tool - Fitnesse
- Data Visualization - Qliksense
- Monitoring and Logging - Grafana
- Autmotated Job Scheduling - Control - M
Oracle/Informatica developer
- SQL, PL SQL
- Query Optimization/Performance Tunning
- Informatica
AI ML Academic Projects
- EDA on credit application data using Python numpy, pandas
- Linear regression model for prediction of bike rental daily count based on the environmental and seasonal settings.
- Lead Scoring case study using logistic regression model to predict whether a lead would be successfully converted or not to enroll for online courses for an education company.
- Building a model using logistic regression to solve the business problem for leading telecom operator in India and south east Asia by predicting customer churn.
- Using advance regression, build a regularized regression model to understand the model important variable to predict the house prices in Australia.
- Building a GAN model to generate artificial MRI images of different contrast level from existing MRI
References
References available upon request.
Timeline
Site Reliability Engineer
JPMorgan India Services Pvt Ltd
06.2022 - Current
Associate Technology
JPMorgan India Services Pvt Ltd
08.2015 - 06.2022
IT Analyst
Tata Consultancy Services
06.2014 - 08.2015
Sr. Software Engineer
Financial Software and Systems
05.2010 - 05.2014
Graduate Developer
Lbi India Limited
12.2007 - 12.2008
Software Engineer
Nucsoft Limited
Master of Science - Data Science
Liverpool John Moore University
Post Graduate Diploma - Data Science
International Institute of Information Technology
Bachelor of Engineering in Information Technology -
University of Mumbai
Certified -
Certified -
Certified -
Similar Profiles
SNEHA PHATAKSNEHA PHATAK
Operational Risk Transformation Specialist at Deutsche Bank India Pvt. Ltd.Operational Risk Transformation Specialist at Deutsche Bank India Pvt. Ltd.
Vaibhav AgrawalVaibhav Agrawal
Senior RPA Lead at JPMorgan Services India Pvt LimitedSenior RPA Lead at JPMorgan Services India Pvt Limited
YASHANTH KSYASHANTH KS
AVP at JPMorgan Services India Pvt. Ltd.AVP at JPMorgan Services India Pvt. Ltd.
SANOOP VPSANOOP VP
HSE Officer at MAHWS OIL FIELD SERVICES -Private limitedHSE Officer at MAHWS OIL FIELD SERVICES -Private limited
Abhishek Suresh ThakurAbhishek Suresh Thakur
Business Development Executive at Jaro EducationBusiness Development Executive at Jaro Education