Summary
Overview
Work History
Education
Skills
LNGG
Timeline
PROFILE SUMMARY
Disclaimer
Generic

ANKIT LOKHANDE

Nagpur

Summary

Talented Technical Lead adept at integrating resources into business operations and developing innovative technical solutions to diverse issues. Strong history of managing highly effective teams to execute complex projects within stringent timeframes.

Overview

11
11
years of professional experience

Work History

Technical Lead

Sycamore Informatics
03.2025 - Current

Technology Lead

Ephicacy India Pvt Ltd
03.2024 - 02.2025
  • Showcasing nearly 11+ years of experience in Production/Application Support, with a robust understanding of UNIX, SQL Queries, Shell Scripting, Networking, Storage, and ITIL.
  • Currently providing second level support to end users, involved in operations of daily, weekly, and monthly production issues, and reporting to business owners.
  • Accumulated expertise in incident management, change management, writing and modifying Unix Shell Scripts, and SQL Queries.
  • Revised application management guideline documents and managed production and application servers, ensuring adherence to standards and optimal performance.
  • Successfully updated Application Management guideline documents, leading to a reduction in downtime and ensuring minimal impact on revenue.
  • Proactively monitored production and application servers, resulting in an increase in operational efficiency and a reduction in issue resolution time.
  • Project: SCE [Statistical Computing Environment]
  • Client: Alcon, Daiichi, PMI
  • Role: Production/Application Support Engineer
  • Project Description: At the core of the Sycamore software-as-a-service (SaaS) solution is Sycamore's proprietary technology platform that can acquire and deliver content, data, and metadata that is readily consumable by users and systems. Utilizing Big Data, Private Cloud, in-memory processing, Application Programming Interfaces (APIs). The Sycamore SCE is an integrated programming environment tailored for Clinical and Statistical programming. It features:
  • Built-in repository for storing programs, data, results (e.g., TFL) logs, and documents.
  • Task management by authorized users, linking tasks to deliverables, and assigning tasks manually or via defined workflows.
  • Collaborative user interface for task state management, progress tracking, and approval of deliverables.
  • Integrated tasks and workflow capability streamline programming task management.
  • Versioning and dependency tracking ensure lineage and traceability of programming artifacts.
  • Flexible directory structure and support for desktop and built-in editors adapt to organizational needs.
  • Data exchange hub facilitates outsourcing models and manages tasks and deliverables across vendors.
  • CDISC standards adherence and metadata-driven processes support data transformation and analysis pipelines with the Sycamore MDR.

Technology lead

Infosys Limited
08.2022 - 03.2024
  • Provide service to one of the leading TELECOM firms in Belgium by providing application support where the main area of expertise revolves around PLSQL, UNIX, ORACLE 11G, MYSQL. The application mainly involves product configuration which is done via Kenan and provisioning systems.
  • Responsible for Product Configuration
  • Product Configuration involves configuration of new products which includes creation of Plans, Discounts, Data Bundles, Credits, Special Services, 5G/4G enablers. Rate Changes (Voice/SMS/MMS/DATA) for existing products as per Business requirement. Archiving and re activation of old products for customers. Migration of Customers from one group to another as requested by clients.
  • Analysis of Jira
  • Analyzing the Jira inflow and Jira request and assignment of the same as per the delivery. Planning the task for the team of 3
  • Development & Testing
  • Development of Product involves shell scripting of various tables as per the chronology which also involves extraction of existing data from the database analyzing the same and basing our new products keeping in mind the existing structure and future requirement. Later deployment of the scripts via Unix servers in 3 environments (DEV/UAT/PROD). Testing involves creation of a test report via manual testing of all the tables for the product configuration, generation of test invoices (KENAN BILLING) for client approvals and sample activation of products for a smooth delivery of products into production.
  • Incident Management
  • Daily Incident analysis via (Hp service manager and ServiceNow) and report generation to keep a track on the inflow of incidents raised against the team providing solutions for the incidents by connecting with the downstream application for the betterment of the service.
  • SKILLS: SQL, Unix shell scripting
  • TOOLS USED: Jira, dB visualizer (Sybase), PL SQL (Oracle), $universe, Putty, PNI Gui, Configuration Viewer, Reference Data Central, Univiewer Console, File Zilla, Hp Service Manager, SNOW

HCL Technologies Ltd.
07.2019 - 08.2022
  • CPB provides financial services to high net-worth Individuals. CPB is operating from NAM, EMEA, APAC regions. Inview leverages Citi Private Bank’s sector wide front office technology and provide best in class solutions to deliver a cutting edge, tailored platform will be an amalgam of analytical information, market feed along with action items /alerts that will deliver a technologically advanced experience to private bank clients. The overall goal of inview Banker is to provide Bankers with quick & easy access to client & firm information via intuitive navigation.
  • Roles Performed :
  • Providing support to team in all 3 regions (APAC, EMEA, and NAM). Experienced in data analysis for solving customer issues.
  • Analyzing the issues and resolving the same, proposing a workaround to maintain business continuity and ensuring minimum business downtime. Identifying the critical issues and taking prompt and effective actions spontaneously.
  • Providing the end user communication for critical issues like service delays/disruption with ETAs. Daily system and application health checks are performed to ensure the smooth running of the application. Handling user queries related to reports, daily job schedules and providing the solutions within the specified SLAs.
  • Communicate workarounds to be followed to L1 and L2 till the issue/work order gets complete/resolve. Raising issues to development team and working with them closely for permanent fixes through calls.
  • Conduct technical training for Service Desk resulting in a more efficient triage and support of issues
  • Documenting re occurring issues and their solutions and provide solutions for feature occurrence
  • Strictly following ITIL standards for Incident and Problem management and adhere the entire Team
  • Developing internal tools, utility to avoid major time spent in cross flow
  • ENVIORNMENT: Oracle11g, Oracle12c, SQL Developer, Sql Server 2008, Linux, Service now, Windows, AIX

Nelito Systems
06.2018 - 06.2019
  • TRS Application:
  • 1. Working on TRS application.
  • 2. Responsible for the writing SQL queries for updating the data into the database to update the reporting purpose tables.
  • 3. Need to provide data reports of transactions and end user account level data to different departments of bank such as Audit, Compliance and operations.
  • 4. Analyzing and loading the data in the database on every month and doing reconciliation of the data.
  • ENVIORNMENT: Oracle11g, SQL Developer, Toad, Sql Server 2008, Linux, Service now

Clover Infotech
12.2017 - 06.2018
  • Working on Finacle application.
  • Apply patches to resolve the issues by writing Sql queries and debugging stored procedure or transaction logs to resolve the issue.
  • Need to provide data reports of transactions and end user account level data to different departments of bank such as Audit, Compliance and operations.
  • Doing RCA on IMPS transactions which are done by users and are not credited to the beneficiary accounts.
  • Solving the issues of IFSC code, beneficiary addition not working, issues of recharges which are done by users.
  • Working on EOD/BOD part of collection application.
  • ENVIORNMENT: Oracle11g, SqlDeveloper, Toad,Finacle,sql server 2008, Linux, Ehelpline

Think apps solutions
12.2015 - 10.2017
  • TECHNICAL RESPONSIBILITIES.
  • Kaleidoscope:
  • Maintaining & enhancing the database tables, triggers, cursors, materialized views procedures, functions and packages to meet business requirements.
  • Working on Kaliedoscope application having(I2E,YES FTP,SMS ENGINE,LMS) module
  • Tablespace Management, User Management , Create Role , Giving Previliges to roles
  • Monitoring Batch Processes & Database Sessions in timely manner
  • Deploying Database Patches in UAT, Production Environments.
  • Creating Database Dumps as per Team requirement, Migrating Schema dumps between environments used for testing.
  • Solving implementation problems in PL/SQL and database related issues.
  • Coordinating with different teams to resolve live issues
  • Fixing the bugs & debugging the Reports through LogiX
  • Monitoring daily ETL through ODI (Oracle Data Integrator) tool.
  • Performing ad-hoc activity.
  • Upload the bulk data through manual batch Loader
  • Solving the Incident & Service Ticket and provide RCA (root cause analysis)
  • Flexcube:
  • Working on FCR (Flex cube) Module.
  • Apply patches to resolve the issues by writing plsql queries and debugging stored procedure or transaction logs to resolve the issue.
  • Need to provide data reports of transactions and end user account level data to different departments of bank such as Audit, Compliance and operations.
  • ENVIORNMENT: Oracle11g,SQL
  • Plus,SQLDeveloper,Toad,Flex Cube (v6.2, 11.6), Linux, Ehelpline, LogiX, ODI tool

HDFC BANK
08.2014 - 10.2015
  • KEY RESPONSIBILITIES
  • Maintaining & enhancing the database tables, triggers, cursors, materialized views procedures, functions and packages to meet business requirements.
  • Working on Kaliedoscope application having(I2E,YES FTP,SMS ENGINE,LMS) module
  • Tablespace Management, User Management , Create Role , Giving Previliges to roles
  • Monitoring Batch Processes & Database Sessions in timely manner
  • Deploying Database Patches in UAT, Production Environments.
  • Creating Database Dumps as per Team requirement, Migrating Schema dumps between environments used for testing.
  • Solving implementation problems in PL/SQL and database related issues.
  • ENVIORNMENT: Oracle11g,SQL
  • Plus, SQLDeveloper, WindowsXP, CMDB, CAService Desk,CA AccessControl, LogiX, ODI tool

Education

Bachelor of Engineering - Information Technology

Rashtrasant Tukdoji Maharaj Nagpur University

HSC - undefined

State Board of Maharashtra

SSC - undefined

State Board of Maharashtra

Skills

  • Agile methodology
  • Issue investigation
  • Test-driven development
  • Performance optimization
  • SQL development
  • Data migration
  • ETL development
  • ITIL processes
  • Shell scripting
  • DB2 database management
  • Vulnerability assessment
  • Data warehousing

LNGG

English
Hindi
Marathi

Timeline

Technical Lead

Sycamore Informatics
03.2025 - Current

Technology Lead

Ephicacy India Pvt Ltd
03.2024 - 02.2025

Technology lead

Infosys Limited
08.2022 - 03.2024

HCL Technologies Ltd.
07.2019 - 08.2022

Nelito Systems
06.2018 - 06.2019

Clover Infotech
12.2017 - 06.2018

Think apps solutions
12.2015 - 10.2017

HDFC BANK
08.2014 - 10.2015

HSC - undefined

State Board of Maharashtra

SSC - undefined

State Board of Maharashtra

Bachelor of Engineering - Information Technology

Rashtrasant Tukdoji Maharaj Nagpur University

PROFILE SUMMARY

  • Showcasing nearly 11+ years of experience in Production/Application Support, with a robust understanding of UNIX, SQL Queries, Shell Scripting, Networking, Storage, and ITIL.
  • Currently providing second level support to end users, involved in operations of daily, weekly, and monthly production issues, and reporting to business owners.
  • Accumulated expertise in incident management, change management, writing and modifying Unix Shell Scripts, and SQL Queries.
  • Revised application management guideline documents and managed production and application servers, ensuring adherence to standards and optimal performance.
  • Expertise in utilizing productive tools such as SQL Plus, JIRA, ServiceNow, and Autosys.
  • Successfully updated Application Management guideline documents, leading to a reduction in downtime and ensuring minimal impact on revenue.
  • Proactively monitored production and application servers, resulting in an increase in operational efficiency and a reduction in issue resolution time.

Disclaimer

I hereby declare that information furnished above is true to best of my knowledge.

Similar Profiles

CREATE PROFILE
ANKIT LOKHANDE