Sarika Ravichanthiran

• Over 9 years and 6 months of experience in the IT industry.
• Strong technical skills in Teradata and Informatica.
• Extensively worked on data extraction, transformation, loading with teradata, flat files using INFORMATICA
• Expertise in writing large/complex queries using SQL.
• Proficient in performance analysis,monitoring and SQL query tuning using Explain Plan, Collect Statistics, and SQL in Teradata.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Well versed with all stages of Software Development Life Cycle i.e. Requirement(s) Gathering& Analysis, Design/Redesign, Implementation and Testing.
• Having basic knowledge on Unix, Amazon Redshift and AWS Lambda.
• Worked in version control technologies such as Git and wincvs.
• Good knowledge on Agile Methodology and the scrum process.
• Good understanding of business in the Aviation domain and Banking domain.
• Proven expertise in understanding specifications and standards to successfully deliver projects in a timely, cost- effective manner.

• Developed and maintained the Control IT portal for reporting business exceptions.
• Created business reports for reconciliation and revenue analysis.
• Implemented projects using agile methodology in sprint cycles.
• Proficient in using GIT for version control.
• Involved in all phases of the software development life cycle, from requirements gathering to deployment.
• Utilized IBM Tivoli as the job scheduler tool.
• Successfully handled all aspects of application development, testing, deployment and live implementation.
• Conducted sit-down sessions with the team to gather requirements effectively.
• Created and loaded tables and views, utilizing Teradata for data warehousing.
• Created scripts using FastLoad and Multiload to efficiently load data into the Teradata data warehouse.
• Implemented business rules using SQL scripts, Macros, and stored procedures in Teradata.
• Updated numerous BTEQ/SQL scripts, ensuring appropriate DDL changes were made, and completed unit and system tests.
• Responsible for Extracting, Transforming, and Loading data from Oracle into the Data warehouse.
• Implemented various transformations such as expression, aggregator, lookup, sequence generator, joiner.
• Conducted testing of Informatica objects to validate test data and reviewed mappings.
• Created, built, and scheduled workflows and sessions using the Workflow Manager.

B.E. CivilEngineering                                                                                                                                                Coimbatore Institute of Technology (CIT),Coimbatore                                                                                                                                                                CGPA 9.42/10.00