Summary
Overview
Work History
Education
Skills
Interests
Timeline
Generic

Jeffry Prince J

Analyst Programmer - SQL/JIRA Administrator
Chennai

Summary

Experienced Analyst Programmer with 5+ years in backend development and technical support, specializing in Microsoft SQL Server, JIRA administration, and Ramco ERP tools. Proven expertise in database development, automation using stored procedures, and streamlining workflows in JIRA, ERP Tools. Highly skilled in managing data integrity and system configurations, with hands-on client support and onsite experience.

Overview

3
3
Languages
7
7
years of professional experience

Work History

Analyst Programmer – Jira Administrator

Ramco Systems
12.2023 - Current
  • Administer JIRA projects, including SLA configuration, workflow creation, field management, and queue updates
  • Performed re-indexing, post-function scripting, and calendar configurations for project-specific workflows
  • Managed Confluence for project documentation and internal team references
  • Created users on Active Directory and JIRA Internal Directory
  • Worked on Issue Types, Workflows, Screens, Custom Fields, Permissions, and Notification Schemes for JIRA Projects
  • Created new permission scheme so end users only see the projects they need to see
  • Implementing Jira workflows using advanced features such as Post functions, Conditions and Validators
  • Managing Groups and Role management based on projects
  • Importing bulk issues into Jira Projects using CSV files
  • Created Custom workflows, custom screens and custom fields on JIRA
  • Optimized custom dashboards, advance filters and formula-based fields
  • Automated events, email Notification Schemes, and Assigned Project Roles in JIRA
  • Streamlined Customized Dashboards, JQL Filters and shared with teams and used them on gadgets
  • Managed Spaces, Pages, Child Pages and Templates in Confluence
  • Developed JIRA SLA mail notification system using SQL Server
  • Resolved workflow breakage and queue configuration issues in JIRA
  • Confluence
  • Created spaces, templates, layouts for the users and groups
  • Managed space permissions and global permissions for the users
  • Participated in Version and license up-gradation with the team
  • Configuring the global Permissions, user, group and anonymous permissions

Analyst Programmer – Backend Developer

Ramco Systems
08.2022 - 12.2023
  • Designed and implemented complex stored procedures, views, and functions for business-critical applications
  • Conducted detailed query performance analysis using SQL Profiler and optimized long-running SQL statements
  • Automated data integrity checks and alert mechanisms using SQL Jobs and mail triggers
  • Collaborated with application development teams to support backend integration and schema design
  • Created stored procedures and scheduled the jobs to trigger mail alerts of the reports in both excel and Mail(Design) to the top management as per requirement

Programmer – Backend Developer (ERP Support)

Ramco Systems
04.2019 - 08.2022
  • Created and optimized stored procedures, views, and triggers in MS SQL Serv
  • Developed reports using Crystal Reports and Ramco DW tools
  • Supported production systems and optimized long-running SQL queries
  • Performed database backup, restoration, and cross-server migration
  • Managed ERP modules: Warehouse & Production Management
  • BrahMos Aerospace Missile(Project) – Onsite support at Hyderabad
  • Ascend Telecom Pvt Ltd(Project) – Onsite support at Bangalore

Education

Bachelor of Engineering - ECE

St. Joseph’s Institute of Technology
Chennai, Tamil Nadu
01-2018

Higher Secondary - undefined

Zion Matr.Hr.Sec.School
Chennai, Tamil Nadu
01-2014

Secondary Level - undefined

Zion .Matric.Hr.Sec.School
Chennai, Tamil Nadu
01-2012

Skills

Database Management: SQL Server, SQL Server 2016, 2014, 2012, MongoDB

Performance Tuning: SQL Profiler, Query Optimization, Indexing, Execution Plans

Database Design: Tables, Views, Stored Procedures, Triggers, Functions

Reporting & Analysis: Crystal Reports, DW Reports

Data Integrity & Maintenance: Backup/Restore, Job Scheduling, Monitoring Scripts

Automation: Email Triggers, Batch Scripts

Ticketing System : rTrack(JIRA), rTask(RAMCO Product), rTrackLITE(RAMCO Product), rTrackPlus(RAMCO Product)

MS Excel

Root-cause analysis

Decision-making

Time management

Workflow Analysis

SQL and databases

SQL programming

Interests

Photography, Cricket, Learning New Technologies

Timeline

Analyst Programmer – Jira Administrator

Ramco Systems
12.2023 - Current

Analyst Programmer – Backend Developer

Ramco Systems
08.2022 - 12.2023

Programmer – Backend Developer (ERP Support)

Ramco Systems
04.2019 - 08.2022

Secondary Level - undefined

Zion .Matric.Hr.Sec.School

Higher Secondary - undefined

Zion Matr.Hr.Sec.School

Bachelor of Engineering - ECE

St. Joseph’s Institute of Technology
Jeffry Prince JAnalyst Programmer - SQL/JIRA Administrator