Sindhuja Raman
Chennai
Summary
A highly skilled IT Assistant Consultant with over 10 years of experience in data integration, ETL development, and process optimization. Adept in Python, PERL, and various database technologies, including Oracle and MySQL. Expertise in designing and implementing ETL pipelines, automation, and developing data-driven solutions to improve operational efficiency. Proven track record in project management, process improvements, and delivering high-quality results in both local and international environments.
Overview
11
11
years of professional experience
Work History
Assistant Consultant
Tata Consultancy Services
07.2014 - Current
ETL/DB Developer
Citibank
04.2021 - Current
- ROCK is a unified portal containing key metrics to facilitate 360* view on data components that are critical for overall data strategy, controls, compliance and surveillance to the data stakeholders and partners.
- Working in ETL pipelines (Data Integration) to extract, transform and load various data from the sources for ROCK portal.
- Handling Oracle DB to store the processed data from source files.
- Developing many Views and Stored procedures to populate Data in ROCK Portal.
- Developing python scripts to process source files.
- Working in Unix environment for various project activities.
- Working on Git Version control for project management.
- Have profound experience in data analysis, development activities, unit testing and maintenance.
- Handling production deployment processes.
- Working on various process improvements and have optimized many processes to improve the performances.
- Have been associated with the hiring processes for my team.
Developer
CITI ICG GRU
04.2020 - 04.2021
- Global Reconciliation Utility (GRU) is responsible for reconciliations across multiple lines of business across 92 countries.
- Worked on various Recons that involved different sources.
- This involves a large amount of data to be handled in Oracle DB.
- Created many Stored Procedures in Oracle DB to fetch various Recon details and their breaks.
- Developed various Unix shell scripts to fetch the recon breaks from Oracle DB and send it as a report to source team.
- Worked on many process improvements in the project and developed many shell scripts to automate various processes in the project.
- (This involved python and Unix shell scripts).
- Handled many internal CITI tools for reconciliation processes.
Developer
Alcatel-Lucent Enterprise
11.2014 - 03.2020
- ALE International, SAS, operating as Alcatel-Lucent Enterprise, is a French company headquartered in Colombes, France, providing enterprise communication services.
- They deliver communications and infrastructure solutions to help engineers, operations, executives and customers connect in a digital world.
- In the Project.
- Collaborated with the client to understand their requirement and developed a Metrics portal to manage various change request details that are being handled in the project.
- Developed Python scripts to retrieve data from JIRA/ClearQuest, calculate the data and store them in the database(MySql).
- Experienced in creating database tables, retrieving data, manipulating and maintaining the data using SQL database.
- Developed GUI using ExtJS for displaying the compiled metrics data from SQL database in the form of graph structure in the Metrics portal.
- Managing the Metrics Portal and developing various Python scripts to monitor it.
- Developed PERL scripts to act as wrapper scripts in order to handle Mercurial repositories.
- Migrated the entire OXE (major product of Alcatel lucent) production processes from SOLARIS to LINUX server.
- Produced more than 100 tools to support the process migration.
- (Tools such as GCC cross compilers, Gmake, Glibc, Gzip, flex, bison, as-grind, etc.).
- Experienced in creating and scheduling Automation jobs in Jenkins.
Education
B Tech - Electronics and Instrumentation Engineering
SASTRA University
Skills
Project Management: JIRA, Clear Quest
Language: Python, PERL, ExtJS, C, C, HTML
Framework: Rest API, CSS
Operating Systems: Unix, Windows, Linux
Version Control: Mercurial, Git
ETL Tool: Talend Studio
CI tool: Jenkins
- Agile methodologies
- Deployment processes
- Unit testing
- Software lifecycle
- Problem-solving skills
Database: MySQL, PL/SQL, Oracle
Others:
Accomplishments
- Awarded "Star of the Quarter" in the excellence category for outstanding contribution to client’s business outcomes.
- Received on the spot team award for spontaneous and quick solutions to various project related activities.
- Received Fresco play award for having maximum learning score board in the project under the learning awards category.
- Received Star of the Quarter for successfully completing process improvements in the project within 6 months from joining the team.
- 6-time Star Recognition for being the best performer of the month.
Timeline
ETL/DB Developer
Citibank
04.2021 - Current
Developer
CITI ICG GRU
04.2020 - 04.2021
Developer
Alcatel-Lucent Enterprise
11.2014 - 03.2020
Assistant Consultant
Tata Consultancy Services
07.2014 - Current
B Tech - Electronics and Instrumentation Engineering
SASTRA University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Herbert Jeffrin MHerbert Jeffrin M
Specialist - Global Funds Control at Bank of New YorkSpecialist - Global Funds Control at Bank of New York