NAGESWARARAO PATTI
NORTHBAY,ON
Summary
Data & Systems Analyst with 3 years of experience in enterprise ETL development, data migration, and relational database management. Skilled in SQL, data validation, source-to-target mapping, and business logic verification across complex database systems. Adept at analyzing business requirements, resolving backend data defects, and supporting cross-functional teams during client data onboarding.
Overview
2
2
Languages
1
1
Certification
3
3
years of professional experience
Work History
ETL Developer
Tata Consultancy Services
Hyderabad, India
08.2021 - 07.2024
- Executed end-to-end data migration and ETL workflows using Informatica PowerCenter and SQL, successfully integrating complex legacy datasets into target database schemas.
- Performed rigorous data validation, audit checks, and reconciliation procedures to ensure source-to-target data integrity, eliminating formatting discrepancies and missing values during data onboarding.
- Authored and optimized complex SQL queries, stored procedures, and database views to analyze business requirements and build accurate reporting logic.
- Collaborated closely with internal developers, QA teams, and business stakeholders to identify, troubleshoot, and resolve database defects and data pipeline anomalies.
- Designed interactive Power BI reporting dashboards and verified key performance metrics to support financial, payroll, and operational reporting requirements.
- Maintained comprehensive system documentation, data mapping dictionaries, and bug-tracking logs to enhance implementation and support efficiency.
Education
Graduate Certificate - Cybersecurity
Canadore College
North Bay, ON01-2026
Graduate Certificate - Information Technology
Algoma University
Brampton, ON01-2025
Skills
- Data Operations & Migration: Data Migration, Data Validation, Source mapping, ETL Development (Informatica PowerCenter), Requirements Analysis, Process Automation
- Databases & Querying: SQL, Microsoft SQL Server (MSSQL), Database architecture
- Error handling
- Data cleansing
- Python programming
- Data modeling
- Analytics & Reporting: Power BI, Data Analytics, Dashboard Design, Business logic verification
- Tools & Platforms: ServiceNow, Jira, Database management systems
Languages
English
Full Professional
French
Limited Working
Certification
Cisco Junior Cybersecurity Analyst, Certified Malware Analysis Beginner (CMAB), PIPEDA Training Certification
Software
SQL,ETL
Timeline
ETL Developer
Tata Consultancy Services
08.2021 - 07.2024
Graduate Certificate - Information Technology
Algoma University
Graduate Certificate - Cybersecurity
Canadore College