System Engineer

Ajin DS

Tata Consultancy Services

+91-908******* / ajindavidraj @gmail.com /Chennai, Tamil Nadu.

PROFESSIONAL SUMMARY

Results-driven SQL Developer & Application Support Engineer with 4+ years of experience in Rally (Agile Central), PPM, Power BI, Oracle SQL, automation, and enterprise production support. Skilled in SQL/PLSQL development, API & OData integrations, reporting modernization, workflow automation, and L2/L3 support. Experienced in Power BI dashboard development, release management, incident resolution, and Agile application support across Development, Test, and Production environments.

TECHNICAL SKILLS

Programming & Databases: Oracle SQL, PL/SQL

Integration & Automation: REST API, OData Integration, Workflow Automation

Cloud & Infrastructure: AWS EC2, IAM, VPC, EBS

Tools: ServiceNow, PPM, Rally, OpenText, Microsoft Excel, Power BI, MS Access

Methodologies: Agile, Incident Management, L2/L3 Production Support WORK EXPERIENCE

Project Portfolio Management (PPM) – Application Support & Development 03/2022 - Present

Worked on PPM application support, development activities, system enhancements, and production support.

Performed L2/L3 production support, incident troubleshooting, root cause analysis, and SLA-based issue resolution.

Developed optimized SQL queries, custom reports, and HTML portlets to improve reporting efficiency and business operations.

Automated operational workflows using OData integrations and self-service solutions, reducing manual effort by 60% and improving reporting accuracy.

Migrated legacy MS Access reports into automated Power BI dashboards and real-time analytics solutions.

Collaborated with development and infrastructure teams during monthly releases and critical deployment activities.

Rally (Agile Central) – Support & Development

12/2024 - Present

Worked on Rally (Agile Central) application support, development activities, and production support.

Developed dynamic refresh processes in Power BI to enable real-time business reporting and story tracking.

Managed user access, project creation, and application configurations for multiple business teams.

Supported Talbot to Rally migration activities including data validation, issue resolution, and post-migration monitoring.

Provided end-user support, operational guidance, and on-call support for high-priority issues. KEY PROJECTS

Project Portfolio Management (PPM) & Rally

Dynamic Power BI Reporting & Story Tracking Automation

Developed dynamic data refresh mechanisms in Power BI for near real-time Agile story and project tracking.

Built interactive dashboards to monitor sprint progress, defect metrics, backlog status, and team performance.

Integrated Rally API data sources and automated reporting workflows to eliminate manual data extraction processes, significantly reducing reporting effort and improving reporting consistency across projects.

Implemented backend python automation logic and data transformation processes to improve reporting accuracy and performance.

Enhanced business visibility by providing automated analytics for management and operational teams.

Rally Migration & Data Validation Project

Participated in enterprise-level Azure DevOps to Rally migration activities across multiple business projects.

Performed large-scale data validation and reconciliation activities to ensure migration accuracy and data consistency.

Analyzed and resolved migration-related issues including project hierarchy mismatches, user access inconsistencies, missing Agile artifacts, and configuration-related defects identified during migration testing and production rollout.

Supported deployment validation, post-migration monitoring, and stabilization activities to ensure successful transition, system reliability, and minimal business disruption after migration completion.

Worked collaboratively with cross-functional teams including development, infrastructure, QA, and business stakeholders during migration planning, execution, issue resolution, and post-production support activities.

PPM Automation & Workflow Enhancement Project

Developed self-service automation solutions, custom workflows, and OData integrations within the PPM environment to streamline operational activities, improve reporting efficiency for 500+ users, and reduce manual intervention across business processes.

Designed and enhanced custom HTML portlets, validation logic, workflow configurations, and reporting functionalities based on evolving stakeholder requirements and business process improvements.

Automated recurring operational and reporting activities using Power BI, SQL, and backend automation processes, significantly reducing manual effort and improving process turnaround time.

Performed workflow optimization and application enhancement activities to improve system usability, operational efficiency, and overall user experience within the PPM platform.

Supported deployment validation, production implementation activities, and post-release monitoring across Development, Test, and Production environments to ensure successful delivery of enhancements and application stability.

Enterprise Reporting Modernization Project

Modernized legacy MS Access-based reporting systems by migrating manual reports into scalable and automated Power BI dashboards to support enterprise reporting and operational analytics requirements.

Developed optimized SQL queries, backend datasets, stored procedures, and reporting logic to improve reporting performance, data processing efficiency, and dashboard responsiveness for large business datasets.

Implemented automated reporting and scheduled refresh solutions to eliminate dependency on manual data preparation and improve report availability for business users and leadership teams.

Delivered interactive dashboards and visualization solutions for operational tracking, project monitoring, resource analysis, and management reporting to support strategic business decision-making.

Worked closely with business teams and reporting users to understand analytical requirements, improve report usability, and provide scalable reporting solutions aligned with organizational objectives.

Production Support & Release Management Project

Provided L2/L3 production support for enterprise PPM and Rally applications by performing incident analysis, issue troubleshooting, defect resolution, and root cause analysis activities within SLA timelines.

Supported monthly release activities, deployment validation, environment monitoring, and weekend implementation support to ensure successful application releases and stable production environments.

Investigated and resolved application, database, reporting, and user access-related issues across Development, Test, and Production environments while coordinating with multiple support and development teams.

Monitored production application health, validated production changes, and performed post-release verification activities to ensure system stability, performance reliability, and minimal business impact.

Collaborated with development, infrastructure, QA, and business teams to manage high-priority incidents, critical production issues, and continuous service improvement initiatives for enterprise applications. EDUCATION

B.E - Mechanical Engineering

Velammal Engineering College/ 2017 – 2021 / First class with distinction – CGPA 7.4 AREAS OF EXPERTISE

Oracle SQL & PL/SQL

Rally & PPM Administration

Development Activities

Power BI & Automation

API & OData Integrations

Incident & Problem Management

Reporting & Analysis

Validation & Testing

Documentation & Support

ADDITIONAL SKILLS

Strong stakeholder communication and collaboration skills

Experience in knowledge sharing and technical presentations

Strong analytical and troubleshooting abilities

Ability to work in Agile and cross-functional teams ACHIEVEMENTS

Received "Star of the Month" award 3 times for outstanding team contributions

Awarded "On-the-Spot Recognition" for active project involvement

Appreciated by clients for prompt responses and timely deliveries

Contact this candidate