NISHCHITHA J
Bangalore
Summary
Detail-oriented Data Migration Specialist with expertise in ETL processes. Utilizes SQL and Perl scripting for efficient data migration, applying advanced techniques in Oracle and SQL Server Management Studio. Manages diverse data sources to ensure effective integration with Teamcenter and other systems. Skilled in data analysis and transformation, enhancing overall data integrity.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Assistant System Engineer
Tata Consultancy Services (TCS)
Bengaluru
2024.02 - Current
- Extracted and migrated large datasets from Oracle databases to SQL Server (SSMS) for downstream analysis and transformation.
- Streamlined data migration workflows through SQL queries and Perl scripting, enhancing efficiency and minimizing manual effort.
- Worked extensively with SQL Server Management Studio (SSMS) for query optimization, data validation, and performance tuning.
- Oversaw data management from multiple source systems, ensuring accurate and timely loading into Teamcenter.
- Executed data analysis, cleansing, and transformation to enable seamless integration with Teamcenter and other enterprise systems.
- Developed and executed scripts to migrate CAD data into Teamcenter using Perl.
- Utilized Excel for data validation, reporting, and exploratory data analysis.
- Applied Python (NumPy, Matplotlib) for data cleaning, transformation, and visualization.
- Created interactive dashboards and reports using Power BI to support business insights and decision-making.
Education
B.E - Information Science Engineering
Acharya Institute of Technology
PUC or 12th - PCMB
P.R.N Amratha Bharathi PU College
Hebri, UdupiSkills
- ETL processes
- Database Management(SSMS and Oracle)
- Shell scripting(Automation)
- Data transformation
- Python for Data Processing (Pandas, Numpy)
- Data Visualisation (Power BI)
- Excel proficiency
- Perl scripting
- Data integration
Certification
Oracle Database 12c: Advanced SQL
Database Developer Oracle Professional Certification
Zero to Hero in Tableau: Data Visualization using Tableau
Python for Data Science – Infosys Springboard.
Database Developer Oracle Professional Certification
Zero to Hero in Tableau: Data Visualization using Tableau
Python for Data Science – Infosys Springboard.
Accomplishments
• Received appreciation for automating ETL processes in projects, significantly improving efficiency. • Recognized for effectively analyzing data before and after ETL, ensuring data integrity and accuracy. • Received an on-the-spot award for actively participating in the Engineering Expo.
Projects
- Data Cleanup of Teamcenter, Analyzed data and deleted older versions of datasets to maintain data integrity and optimize storage.
- DRM (Data Rights Management), Implemented data stamping based on priority to ensure proper data handling and security.
- Data Migration from Varipdm and SWPdm to Teamcenter, Currently working on migrating data from Varipdm and SWPdm to Teamcenter, ensuring seamless integration and data consistency.
Languages
English, Hindi, Kannada
Hobbies and Interests
Dance, Painting, Sketching, Cooking, Crafts, Crochet
Timeline
Assistant System Engineer
Tata Consultancy Services (TCS)
2024.02 - Current
B.E - Information Science Engineering
Acharya Institute of Technology
PUC or 12th - PCMB
P.R.N Amratha Bharathi PU College