Gayathri Rajendran
San Antonio,TX
Summary
Accomplished, results-oriented, and innovative senior ETL Lead with 13+ years of experience and proven track record at TATA CONSULTANCY SERVICES LTD, specializing in DataStage development and data transformation. Demonstrated expertise in Agile methodologies and strong problem-solving skills, leading to enhanced data accuracy and customer satisfaction. Excelled in fostering cross-functional collaboration and innovative solution design, significantly improving system reliability and operational efficiency.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Senior Technical Lead
TATA CONSULTANCY SERVICES LTD
Chennai, India / San Antonio, TX
08.2021 - Current
- Created comprehensive documentation for system designs, ensuring clarity of purpose and facilitating seamless maintenance activities.
- Collaborated with cross-functional teams to design and implement effective software solutions related to data , resulting in increased customer satisfaction.
- Collaborated with clients to determine project specifications and scope. Contributed innovative ideas during brainstorming sessions that led to successful execution of key initiatives.
- Responsible for Processing FTS transactions, Wire Transactions, Fraud Alerts, OFAC screening, Message Alerts, Notifications, Case Alert Management Systems using batches and Realtime queues.
- Identified and resolve issues related to data extraction, transformation, and loading to ensure data accuracy.
- Worked on building data warehouses (Snowflake, Netezza, Hadoop) based on the organization’s data storage needs to facilitate efficient data retrieval and reporting.
- Demonstrated problem-solving skills by troubleshooting systems, analyzing root causes, and implementing effective fixes. Successfully resolved critical incidents to minimize downtime and ensure smooth operations.
- Proactively monitored applications using Splunk/Kibana, dashboard using elk openshift and tracking their performance metrics (such as response time, resource utilization, and error rates) to detect anomalies or deviations. Addressing performance issues promptly to help maintain system reliability.
- Coordinating with vendors involving managing relationships, negotiating contracts, and ensuring that vendor deliverables align with business needs.
- Handled User incidents in service now and improved the performance metrics from 85 to 93% and reduced the redundant works but creating know articles.
Senior Developer
TATA Consultancy Services Ltd
San Antonio, TX / Chennai India
06.2015 - 07.2023
- Checked client code for bugs and weaknesses using approved troubleshooting methods.
- Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
- Provided technical support using knowledge of complex technology to solve problems and support new projects.
- Managed ETL technological issues for assigned projects, increasing customer satisfaction ratings.
- Created proofs of concept for innovative new solutions.
- Identified issues within databases, performed troubleshooting and implemented effective solutions.
- Developed reusable components for common ETL tasks, reducing development time and promoting consistency across projects.
- Collaborated with cross-functional teams to gather requirements, ensuring effective and accurate data integration solutions.
- Reduced error rates in ETL workflows by implementing comprehensive error handling and logging mechanisms within DataStage jobs.
- Developed polished visualizations to share results of data analyses.
Lead Developer
Tata Consultancy Services Ltd
Chennai India
03.2011 - 05.2015
- Recruited in-demand talent to expand and diversify development staff.
- Reduced system downtime by proactively identifying and resolving software bugs and performance issues.
- Contributed to successful project delivery within tight deadlines through effective time management and prioritization of tasks based on business value.
- Streamlined development processes through the implementation of effective version control, continuous integration, and automated testing practices.
- Participated in regular code reviews to maintain quality standards while providing valuable insights into areas for improvement or optimization opportunities.
- Managed team of 5 junior engineers on projects in development and support.
Developer
Infosys Technologies
Chennai India
12.2008 - 02.2011
- Requirement analysis based on System Requirement Documents to cover functionality, operations, technical issues and scope of work.
- Analysis and evaluation of alternatives to formulate mode of implementation of system.
- Modeling new requirements into high-level design. Involved in developing DataStage jobs.
- Developed Proof of Concepts (POC) for performing lookups in Server jobs.
- Designed Data model for project which includes Audit logic, PL-SQL procedures which are used in project.
Education
Bachelor of Engineering (B.E) in Computer Science -
Madha Engineering College, Anna University
Chennai India06.2008
Skills
- Expertise in DataStageV115 development, Data Transformation Methods and Data Migration
- Experience with Agile and SDLC methodologies
- BMC Control-M Expertise and Job Scheduling Optimization
- Handled multiple Databases like Oracle ,DB2, Snowflake, Netezza, MS SQL with strong PL-SQL knowledge
- Strong Unix Shell Scripting knowledge, ServiceNow incident reporting, Kibana/ELK and Splunk log monitoring and Message Queues
Certification
IBM Infosphere Datastage 8.1
Timeline
Senior Technical Lead
TATA CONSULTANCY SERVICES LTD
08.2021 - Current
Senior Developer
TATA Consultancy Services Ltd
06.2015 - 07.2023
Lead Developer
Tata Consultancy Services Ltd
03.2011 - 05.2015
Developer
Infosys Technologies
12.2008 - 02.2011
Bachelor of Engineering (B.E) in Computer Science -
Madha Engineering College, Anna University