Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Affiliations
Timeline
Generic

Utkarsh Singh

Chandigarh

Summary

Finance professional with experience in Bloomberg data analysis, SQL querying, and manual job execution. Updating scripts as per modifications.

Strong networking skills and customer empathy. Skilled in incident management and root cause analysis.

Proficient in maintaining SSL certificates and providing excellent customer support, maintaining BRM.

Adhering with SLA's, timely response for BAUs

Data analysis and validations perfomed to ensure smooth running of business processes.

Coordinating with stakeholders to keep them informed of the planned and sudden changes. Data governance and quality checks performed.

Adhering to compliance. Resourceful Production Support Engineer known for high productivity and efficient task completion. Skilled in incident management, system troubleshooting, and process optimization to ensure seamless operations.

Optimistic approach, excel at problem-solving, communication, and teamwork to address challenges and improve systems reliability and adaptable.

Overview

5
5
years of professional experience

Work History

Production Support Engineer/Data Engineer

Fincor Management Advisory Services Private Limited
Chandigarh
12.2022 - Current
  • Verified data integrity by executing SQL queries and running manual jobs, source data: Bloomberg.
  • Checking SFTP server for file authentication: FileZilla.
  • Comparing FTP directory to check whether data is loaded correctly and also verify the kind of data.
  • Incident Management, Server maintenance, Configuration Management, Application monitoring.
  • Hands-on knowledge working on data integration tools, i.e. Apache NiFi.
  • Hands-on experience on cloud technology: Cloudera Data Platform and Microsoft Azure.
  • Basic knowledge of Apache Airflow.
  • Acquired foundational Unix skills.
  • Evaluated pipeline data for flaws in processing times
  • Demonstrated expertise in MSSQL and HUE, adjusting SQL scripts to meet requirements
  • Checking users' access for data stability on MSSQL.
  • Checking mapping of users on hue: policy applied.
  • Manually executed jobs, created dashboards, and set downtimes in Datadog
  • Performing unit testing to monitor implemented changes
  • Working knowledge of Postman tools, sending post and get requests.
  • Adapted to view problems from multiple perspectives
  • Incident Management and Monitoring: performing health check of different systems: data warehouses, cluster and nodes, configuring changes.
  • Analyzing root cause analysis of failure.
  • Created Business Continuity Plan.
  • Basic hands-on experience with cloud technologies: Azure.
  • Ensured BRM with stakeholders, business users, and change communications ran smoothly.
  • Maintaining SSL certificates for warehouses and clusters.
  • Ensured rapid resolution of business-as-usual issues
  • Addressed recurring problems by coordinating with the 3rd-tier support.
  • Analyzing DAGS in airflow, investigating logs to check for issue.
  • Monitored tasks in Active Batch ensuring smooth job flow
  • SLA adherence, incident management, L1/L2/L3 support.
  • Working on a day-to-day basis to create runbooks for applications.
  • Debugging issues, communicating with different teams to get updates regarding any job failure issues, or any other issue.
  • Collaborating and coordinating with different teams to get the issue addressed and resolved, handling operations for the business.
  • Executed timely maintenance on existing Nifi flow versions
  • Collaborating with different teams to gain and own full knowledge of a product.
  • Provided on-call support for critical production systems.
  • Monitored system performance, identified issues and implemented solutions.
  • Documented process flows and configuration changes
  • Performed Root Cause Analysis to identify underlying causes of incidents.
  • Coordinated with development teams to ensure timely resolution of incidents.
  • Deployment of new releases into the production environment.
  • Scheduled maintenance activities during off peak hours.
  • Performed troubleshooting tasks on complex distributed systems.
  • Analyzed logs from multiple sources to identify patterns or trends in system behavior.
  • Participated in post-incident reviews to document lessons learned from outages and failures.
  • Generated reports on system availability, performance metrics and SLAs compliance.
  • Ensured that all IT infrastructure is up-to-date with latest security patches and upgrades.
  • Worked closely with other teams to resolve cross functional issues.
  • Ensured compliance with industry standards and best practices while performing duties.
  • Deployment tools used: Octopus.
  • Provided training and guidance to junior members within the team on production support activities.
  • Mentored new engineering and production team members.
  • Trained new employees on company and safety standards, providing assistance and remediation with issues.
  • Adhered to regulations and procedures for health, safety and environmental compliance.

Production Support Engineer/Data Analyst

Capgemini
Bangalore
06.2019 - 11.2022
  • Experience in monitoring jobs, analyzing issues for job failure, running jobs manually: Azure Databricks.
  • Evaluated and updated Python scripts for optimal data processing
  • Strong focus on analytical activities.
  • Providing excellent customer support.
  • Finding dogs and analyzing different jobs in the code and checking for the required results.
  • Monitored each task in Airflow to sustain job flow
  • Manage daily updates on Confluence pages for various applications
  • Coordinated with multiple teams for updates on job failures
  • Checking out the logs for different jobs in case to debug the issue
  • Collaborating with different teams to get the issue addressed and resolved
  • Used Git for version control and pushed, merged the branches to Bitbucket
  • Collaborating with different teams to gain and own full knowledge of an application and its use cases.
  • Logged daily efforts effectively
  • Guiding teammates through diverse processes.
  • Reassess unresolved ticket inquiries
  • Demonstrates exceptional work ethic and intelligence in tasks
  • Participated in daily stand-up meetings for ongoing project updates
  • Skilled in applying cloud solutions effectively
  • Environment: Databricks, Airflow, Astronomer, Python, SQL, Excel, Jira, Bitbucket, Confluence, Word
  • Worked extensively on HTML5, CSS3, Bootstrap, AngularJS, and Node.JS for designing and developing dynamic web pages.
  • Created modular front-end elements with AngularJS
  • Involved in implementing various screens for the front end using AngularJS and used various predefined components from NPM (Node Package Manager).
  • Environment: AngularJS, HTML5, CSS3, Bootstrap, JavaScript ES5 and ES6, NPM, GitHub, Visual Studio, and Jenkins.

Education

Bachelor of Technology - Information Technology

SRM Institute of Science & Technology
Chennai, India
05-2019

Skills

  • Incident Management and Release management
  • Service Level Agreements
  • Incident Management
  • Server maintenance
  • Configuration Management
  • Application monitoring
  • Apache Nifi
  • MS SQL/ Hive/ Hue
  • GitHub
  • Azure Portal (Basic)
  • Datadog
  • Cloudera Data Platform
  • SFTP server/ FTP directory
  • Confluence
  • Jira
  • Python
  • WINDOWS 10
  • Astronomer/Airflow(Basic)
  • Excel
  • Env Key
  • System Troubleshooting
  • Database Administration
  • Backup and recovery
  • Capacity Planning
  • Vendor coordination
  • Disaster Recovery
  • Continuous integration
  • Octopus

Accomplishments

  • Invited for business visit to Cardano UK for business meet to discuss potential business meetups.

Languages

Hindi
First Language
English
Upper Intermediate (B2)
B2
French
Beginner
A1

Affiliations

  • In my current job, I was responsible for improving our customer support process, which led to a 25% increase in customer satisfaction. This shows my drive for excellence and determination to always seek improvements
  • I 'm highly adaptable and can comfortably work in various environments
  • I’m committed to continually developing my skills and knowledge in my field
  • I have developed strong leadership skills throughout my career, allowing me to effectively guide teams and make strategic decisions.
  • I have a strong background in both technical support and customer service, which enables me to give clients a seamless support experience while effectively troubleshooting and resolving any issues they encounter.

Timeline

Production Support Engineer/Data Engineer

Fincor Management Advisory Services Private Limited
12.2022 - Current

Production Support Engineer/Data Analyst

Capgemini
06.2019 - 11.2022

Bachelor of Technology - Information Technology

SRM Institute of Science & Technology
Utkarsh Singh