Saikumar Chimakurthi

• Designed and implemented advanced control systems, enhancing automation efficiency and optimizing production processes.
• Developed and maintained Talend ETL jobs to integrate data from various sources into data warehouse systems, supporting business intelligence across multiple departments.
• Conducted unit testing and collaborated with Testers for systems integration testing of ETL processes.
• Released and deployed Talend ETL code to GitLab, enabling continuous integration (CI) and deployment (CD) pipelines.
• Built and maintained CI/CD pipelines using Jenkins, reducing deployment times and enhancing operational efficiency.
• Worked with existing Unix (Perl) scripts designed for data loading processes, ensuring smooth execution and troubleshooting issues as needed.
• Leveraged AWS S3 for secure storage and efficient retrieval, managing data transfers between cloud storage and data warehouse systems to support seamless data integration.
• Performed development operations, troubleshooting, and bug-fixing to ensure code reliability.
• Set up and configured essential tools (Talend, Control-M, and Teradata) and required infrastructure for seamless data operations.
• Mentored team members and provided guidance on best practices in ETL and automation processes.
• Monitored and optimized code lifecycle processes, and reverse-engineered code for data migration documentation.
• Interpreted specifications and data flows, modifying ETL code to align with evolving business models.

• Designed, developed, and maintained Talend ETL jobs for data integration, ensuring accurate and timely data movement into data warehouse systems.
• Deployed Talend ETL code to GitHub for continuous integration and deployment.
• Managed daily, weekly, and monthly data operations tasks, updating and maintaining documentation to ensure process accuracy.
• Supported ITIL processes, resolving incidents, and conducted post-incident reviews for continuous improvement.
• Oversaw offshore vendor support, ensuring productivity and adherence to performance metrics.
• Contributed to achieving 99% uptime for Data and BI platforms through proactive maintenance, certificate tracking, and regular system health checks.
• Proposed and implemented innovative solutions to recurring issues, enhancing overall platform efficiency.

Data Mining and Machine Learning

• Dealt with supervised and unsupervised machine learning techniques, exploratory and confirmatory statistical methods, and predictive analytics using python.
• Managed over 50 students per session answering their questions and clarifying their doubts with ease.
• Dealt with coding and data wrangling which includes data pre-processing too.
• Investigated problems such as clustering, classification, dimensionality reduction, and maximum likelihood estimation in applications across range of industries.

Interactive Application Design.

• Helped acquiring hands-on skills in MATLAB, scripting language allowing students to quickly implement various image- processing techniques and applications of artificial intelligence.
• Effective problem solving through logical approach.
• Utilized Excel for student marking and grading.

Data and Information Management

• Collaborated key implementation and management concepts, including transaction management and concurrency control, database backup and recovery, and security will be investigated using SQL queries.
• Retrieving and manipulating data from Oracle DB.
• Data ingestion and ETL transformations using PL/SQL.
• Worked with variety of data sources both structured and unstructured such as, flat files and relational databases.
• Utilized oracle with Tera Term for practical purposes along with WinSCP for file transfer.

• Performed data wrangling and integrated datasets for web applications.
• Conducted troubleshooting and performance analysis for website functionality, recommending enhancements.
• Derived insights from data to support business objectives and presented findings to the data team.

• Analyzed performance trends to project future capacity needs and identified bottlenecks to improve query performance.
• Resolved Teradata connections issues and ODBC driver configuration issues.
• Performed query tuning by redefining primary indexes.
• Analyzing DB logs to investigate and fix user lock issues.
• Worked extensively and supported for successful implementation of Disaster Recover Server through Data Mover which consists a lot of data analytics including dimension and fact tables.
• Created dashboards in tableau for visualizing tables.
• Designed, Reviewed and suggested efficient modifications to various DDLs through BitBucket (GIT).
• Experience working with ETL processes SSIS and BTEQ.
• Responsibility taken for redesigning Backup and Restore jobs (DSA).
• Multi-Value Compression Analysis using Nexus Chameleon tool.
• Performed Space Management for PermSpace through UAT, Production Backup table cleanup.
• Teradata DBA activities like Maintenance activities, Creating and managing user accounts, Archive/Recovery operations, database creations, managing roles and privileges, Teradata Administrator, Teradata SQL Assistant and Viewpoint Tools for monitoring and control the system.
• Generating the Daily/Weekly/Monthly Health & Status reports to assess current performance management practices and recommend improved processes.
• Created TD scripts for the DBA needs. Incidents creation/update in TAYS site.
• Worked actively during software upgrade from Teradata 15.10 to Teradata 16.20
• Utilized confluence for design documentation, updating requirements. JIRA for setting up resource accesses, dependencies of tasks and permissions.
• Monitored and enabled load jobs using Teradata Framework (TJC) including Data Mover.
• Created different environments for testing and development.
• Created alerts for system monitoring and smooth running of daily batches.
• Implemented Role & Profile based access.
• Knowledge in Teradata Parallel Transport like FastLoad, MultiLoad, FastExport and Tpump.
• Handled high volume of tickets with less resource availability.
• Implemented/modified automation scripts using Perl and shell scripting which helped in reducing DBA work load.
• Cross team collaboration with Informatica ETL team.