Nivetha Ravichandran
Data Engineer
London,West Drayton
Summary
Competent IT professional with 7+ years of experience as an Oracle SQL PLSQL, ETL(Informatica),Unix shell scripting in banking domains. Worked primarily in the banking domain was involved in the development and deployment of the projects. Application development with all stages of System Development Life Cycle (SDLC): design, analysis, coding, and testing
Overview
7
7
years of professional experience
1
1
Certification
4
4
years of post-secondary education
Work History
Analyst Programmer
Indian Overseas Bank
Chennai, Tamilnadu
08.2014 - 04.2021
- Analysed and understood Business requirement document (BRD) and Data mapping document (DMD)
- Created database objects like table, views, sequence, synonyms, stored procedures, functions, and packages;
- Created PLSQL procedures to load Oracle target table’s data and we populate data to product using function
- Created Dynamic SQL script in PL/SQL to build SQL statements dynamically at runtime
- Used SQL
- Loader and created the External Tables in order to load data from flat files into oracle tables
- Extensively used Bulk Binding and Collections for manipulating the large amount of data and enhance performance
- Used Informatica PowerCenter for (ETL) extraction, Transformation, and Loading data from heterogeneous source systems into the target database
- Utilized Data mapping document, Implements Business logic to ETL tables
- Optimized and enhanced the existing procedures and SQL statements for the better performance
- According to transformation logic, we used various transformations like Filter, Sorter, Aggregator, Lookup, Expression, Filters, Router, Update Strategy, Joiner, Normalizer etc in the Mappings
- Expertise in slowly changing dimensions to maintain historical as well as incremental data using Type I, Type II and Type III strategies
- Attended walk through, Code review and Status meeting to discuss the status of the project
- Designed Report Layout using RDW Product
Analyst Programmer
State Bank of Mauritius
Chennai, TamilNadu
01.2019 - 03.2021
- Analysed the business requirements of the project by studying the Business Requirement Specification document
- Created/Modified database objects like packages, procedures, functions, and triggers and handled errors using Exceptions
- Loaded Input files or flat files in various formats like .CSV,.XML
- Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL
- Loader
- Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables
- Created and modified several UNIX shell scripts/ Dos Batch files according to the changing needs of the project and client requirements
- Imported dump file into one temporary table and then extract ETL tables
- Used Informatica ETL tools to extract the data from a different source to oracle database
- Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target
- Monitored transformation processes using Informatica Workflow monitor
- Provided few enhancements to the existing ETL’s as per the requirement
- Developed ETL flows to get data from Operational Data Store and loading it to target using the ELT tool Oracle Data Integrator using different Knowledge Modules., During my break from work to care for my growing daughter, I gained valuable experience in childcare and managing my time
- Participated in team projects, demonstrating an ability to work collaboratively and effectively.
Project Trainee
Ramco Systems
Chennai
01.2014 - 12.2014
- Worked in Ramco Banking MIS (Management Information System)
- Learned new materials, processes, and programs quickly.
- Troubleshot minor issues with office tools and equipment, escalating more serious problems to supervisor.
- Shadowed senior team members to learn all related jobs and tasks.
Education
Bachelor of INFORMATION TECHNOLOGY - Information Technology
Adhiparasakthi Engineering College, Anna University
Melmaruvathur, TamilNadu 08.2009 - 04.2013
Skills
- Created Schema, Users, Tables, Constraints, Indexes, Procedure, Functions, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Pro les, anonymous blocks, directories, sequences, synonyms
- Tuned SQL queries using EXPLAIN PLAN, Hints and SQL
- Plus Auto trace report for query optimization
- Used Materialized Views, Packages and Dynamic SQL
- Used SQL
- Loader, Import/Export, UTL_FILE, DBMS_XMLQUERY, DBMS_PIPE
- Performance Tuning of Oracle Applications using TKPROF
- Developed monitoring and notification tools using Python
- Proficiency in defining ETL design and integrating data from disparate source systems and disparate data formats, including requirement gathering, source system analysis, data quality, slowly changing dimensions, mappings, SQL, and performance tuning
- Conversant in planning and designing Informatica ETL Code, testing, and deploying code in various environments; hands-on experience in ensuring the integrity of project data, including data extraction, storage, manipulation, processing, and analysis
- Good experience in working on Linux/Unix like environments and has very good knowledge on various commands and UNIX shell scripting
- Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables
- Configured and created the MQ Queue mangers, message queues, channels, process definitions and triggers
- Ability to work independently as well as in a team and able to effectively communicate with customers, peers and management at all levels in and outside the organization
SKILL SET
- Application Development/Support
- AML/KYC
- Banking and Supply chain domain
- Performance Tuning
- Data Loading
- Business Requirement Document (BRD)
- Integration Testing
- ETL Tools
- Data Mapping Document (DMD)
- Unit Testing
- User acceptance testing
- Validation testing
TECHNICAL SKILLS
- Operating system - Linux, Unix, Windows 10/8/7
- Oracle SQL, PL/SQL, Unix Shell Scripting, Informatica 96, MS SQL Server
DATABASES
- Oracle 11G, MySQL, SQL Server 2016, IBM Data Studio
DEVELOPMENT TOOLS
- Oracle Data Integrator 12C, PLSQL Developer, SQL Developer, ETL tool, EDK designing tool, Report( ER)
- Oracle 12C, SQL, PL/SQL Developer, ETL Informatica (96) tool, RDW (Ramco Decision works)
- Payroll Organization
- Ramco Banking ADF (Automated Data Flow)
- Oracle 11g, SQL, PL/SQL Developer, SQL Loader, Unix, ETL Informatica (96), RDW (Ramco decision works)
- Analysing Specification documents and Creating design and design in ireport
- Validate data on the reports against the source
- Prepare Test Case Document for Testing the Application from all aspects
- EDK designing tool, Report(ER), SQL server 2012
Accomplishments
- Attended and certified in “JAVA PROGRAMMING” and “MICROSOFT VISUAL BASIC”, a non-formal course conducted by Adhiparasakthi Engineering College.
Certification
Completed SOFTWARE TESTING course (CSTP) at STC technologies
Work Preference
Work Type
Full TimePart TimeContract WorkWork Location
RemoteImportant To Me
Work from home optionHealthcare benefitsWork-life balanceCompany CulturePersonal development programsTimeline
Analyst Programmer
State Bank of Mauritius
01.2019 - 03.2021
Analyst Programmer
Indian Overseas Bank
08.2014 - 04.2021
Project Trainee
Ramco Systems
01.2014 - 12.2014
Bachelor of INFORMATION TECHNOLOGY - Information Technology
Adhiparasakthi Engineering College, Anna University
08.2009 - 04.2013
Completed SOFTWARE TESTING course (CSTP) at STC technologies
Similar Profiles
Manoj NagarajanManoj Nagarajan
Senior Customer Service Associate at Indian Overseas BankSenior Customer Service Associate at Indian Overseas Bank
RASHI KUMARIRASHI KUMARI
Assistant Manager at Indian Overseas BankAssistant Manager at Indian Overseas Bank
PRAHLAD KUMARPRAHLAD KUMAR
Advance or Credit Manager at Indian Overseas BankAdvance or Credit Manager at Indian Overseas Bank