Anil Chhatani Email & Phone Number

Pune, MH, IN

Pune, Maharashtra, India

Pune, Maharashtra, India

• Currently playing role of feature lead which include role of individual contributor and leading team of 7 members.
• Designed and implemented the solution of various functional feature required by business which includes modelling, ETL and transforming data.
• Designed & implemented the solution to run the batch within the SLA which earlier was taking days to complete, now running in few hours.
• Analyse the SQL monitor report to analyse the details SQL execution and identified the performance bottleneck and fix the same.
• Developed Oracle PL/SQL Procedure /function/packages and triggers as per requirement.
• Reviewed database query performance and provide performance and tuning expertise for query tuning, optimizing data model design as well as table, index, and view design.

Pune Area, India

• Worked for Barclays in Investment banking domain as technical lead.
• Role includes individual contributor and technical mentoring team.
• Migrated complete ADB system into MOTIF application which includes following.a) Analysis of existing ADB application and its DB objects.b) Analysing impact of migrating ADB code into MOTIF.c) Creating ADB objects into.
• Did the code migration independently from Perforce to GIT which includes learning and exploration of new tool (GIT).
• Fixed the performance issue highlighted in BMR reporting using.
• Performance tuning of SQL long running queries.

Pune Area, India

• Worked for Credit Suisse in banking domain as technical lead.
• Designed and developed common ETL solution using batch script and PL/SQL to source data from multiple databased (Sybase/ SQL server) into ORACLE on daily basis.
• Reviewed existing report processing provide performance tuning expertise for query tuning, which bring down processing time from 2.5 hours to 15 min.
• Tuned long running queries of report and batches using tools like explain plan.
• Leaned new data visualization tools like Tableau & Visokio.
• Migrated existing dashboard developed from Visokio to Tableau.

Pune Area, India

• Part of C-POS application team as Sr. Oracle PL SQL developer.
• Worked on coding using PL/SQL in cPOS application inventory module.
• Done the performance tuning of long running report queries of inventory module using tools like explain plan.
• Designed and developed process for activating tele verification service on postpaid numbers using ORACLE PL/SQL and CMS batch and Unix shell scripting.
• Involved in solution designing of new change request.
• Developed several work around script to work number activation flow smoothly till permanent closure of problem

Pune Area, India

• Part of MH-circle team as ORACLE PL SQL developer.
• Designed and developed process for serving below purpose using Unix shell script and Oracle PL SQL and SQLa) To read data from upstream application into CPEMS application.b) To write data to billing system (BSCS) from.
• Performance tuning of long running report queries using tools like explain plan.
• Designed and develop Java front end which is used by Users to generate report on ad-hoc basis. Front is flexible enough to configure new reports easily.
• Created PL/SQL procedures to generate report from front end. Procedure takes use_id as parameter so multiple user can generate same report at a same time.
• Writing SQL queries and procedure/packages for ad-hoc report requirements.