J Jain

IT professional with 11.7 years of experience in SQL, PL/SQL, Python, MS SQL Server, SSIS ETL, ER diagram design, data flow analysis, data modeling, and database design. Strong expertise in Oracle PL/SQL, MS SQL Server, DB design, data modeling, and query tuning using PL/SQL Developer. Hands-on experience in developing Stored Procedures, Functions, Packages, Triggers, Views, and Materialized Views.

Experienced in SSIS package migration (v14–v19), upgrades, deployment, job scheduling, data validation, and troubleshooting. Strong knowledge of SQL performance tuning using Explain Plan, Cost-Based Optimization (CBO), and query optimization techniques. Experienced in requirement gathering and impact analysis, including object analysis, object decoupling, data manipulation, code review, unit testing, deployment validation, and production support.

Experienced in Agile/Scrum methodology, including sprint planning, user story analysis, and Jira tracking. Domain experience in BFSI, Banking, and Supply Chain.

Senior Data Engineer - Tata Consultancy Services (TCS)

(2025-05 - 2025-09)

Project: Orion Advisor Solutions (BFSI)

• Developed and optimized procedures, DB objects, ER diagrams, and data models.
• Performed requirement, impact, and data flow analysis for enhancement requests.
• Used hotkeys and snippets; performed code reviews, unit testing, and deployments.
• Participated in Agile ceremonies including sprint planning and daily stand-ups.
• Improved query performance using SQL tuning techniques.
• Collaborated with cross-functional teams for successful project delivery.

SSIS ETL Developer - Tata Consultancy Services (TCS)

(2024-05 - 2025-04)

Project: MetLife 1.2 DNA

• Performed SSIS migration, upgrades, validation, and Python automation.
• Managed IWS job scheduling and monitoring using Python.
• Conducted data validation and integration testing using SQL and Python scripts.
• Troubleshot SSIS package failures and performed log analysis using Python.
• Built complex SQL queries and Python scripts for ETL data processing.

MS SQL Developer - Tata Consultancy Services (TCS)

(2023-02 - 2024-04)

Project: Century Distribution Systems

• Developed and maintained SQL Server DB objects and data models.
• Worked on query optimization and performance tuning.
• Supported production issues and deployment activities.

MS SQL Developer - Foray Software Pvt Ltd

(2021-10 - 2023-01)

Project: Century Distribution Systems

• Developed SQL procedures, DB objects, DB design, and data modeling using SSMS.
• Involved in application development activities, including object analysis, ER diagram design, DB design, data modeling, object decoupling, debugging, data manipulation, testing, and implementation for CDS projects.
• Designed, enhanced, and developed new SSRS reports for transactional and business reporting requirements.
• Performed SQL query optimization and database performance tuning.
• Provided production support and issue resolution.
• Participated in Agile/Scrum activities and Jira tracking.

Oracle PL/SQL Developer - NCR Corporation India Pvt Ltd

(2012-12 - 2021-10)

Project: Cheque Truncation System (CTS)

• Developed PL/SQL objects and data models using PL/SQL Developer.
• Strong knowledge of Oracle 10g/11g/12c, SQL, and PL/SQL.
• Performed SQL performance tuning using Explain Plan and CBO techniques.
• Used views and materialized views to improve query performance.
• Monitored system performance through daily alerts and logs.
• Handled onsite activities, issue resolution, and status reporting.

Bachelor of Technology (B.Tech) - Information Technology - Anna University (2010)