VEERALAKSHMI
Oracle Certified PLSQL, ETL Developer
Coimbatore
Summary
Technical lead directing Oracle database work across development, integration, and support activities. Shapes architecture, design, and troubleshooting for systems built on PL/SQL, Oracle tools, and cloud data services. Connects delivery teams with stable data solutions that support business reporting and operations.
Overview
5
5
Certifications
14
14
years of professional experience
Work History
Assistant Manager
EY GDS
06.2022 - Current
Senior software engineer
GoAugment Pvt LTD
04.2020 - 06.2022
Associate
Cognizant
08.2019 - 04.2020
Senior developer
GoAugment Pvt LTD, Coimbatore
01.2018 - 07.2019
IT Analyst
Tata Consultancy Services, Chennai
06.2012 - 04.2018
Education
HSC -
- SSLC-91.1%
- GPA: 92.83%
Bachelor of Engineering -
04-2012
- First class with distinction.
- GPA: 81%
Skills
Oracle PL/SQL -llg -19c
MS-TSQL
Data Warehousing
AWS -S3
C#
Code review standards
Mentorship
Stakeholder management
Release management
Sprint planning
Performance tuning
ETL development
Data integration
SQL query optimization
Database troubleshooting
Data modeling
Dimensional modeling
Batch job scheduling
Query performance tuning
Certification
1Z0-071 ORACLE Certified SQL ASSOCIATE
PROFESSIONAL EXPERIENCE
- Oracle PL/SQL development & ETL
- Developed Complex database objects like Packages, Procedure, Table with partitions, Triggers and User defined functions and effectively made use of Table functions, Indexes, Materialized views, external tables, collections and analytical functions
- Developed a framework to decommission the existing business key and updated with new keys on huge historical fact tables which has partitions and sub-partition using partition exchange mechanism and column rename approach
- Experience in creating mapping and procedure integration in Oracle data integrator and automated the process work flow.
- Experience in creating Data Flow diagrams, Data dictionaries, and applying database normalization techniques, as well as entity relationship modeling and design methods
- Worked in Setting up topology, building objects in Designer, Monitoring Operator, using different type of Knowledge modules, Agents etc
- Experience in creating data lineage that gives details about the end to end details of different kinds of source and target tables in the data warehouse
- Experience in Job scheduling and monitoring using DBMS Cron jobs scheduler and BMC control M
- Experience in using Unix and Python scripting for File handling and automation of daily data flows in the system.
- Worked in data collection, created data pipelines for ETL , Netezza Data warehouse Expertise in Client-Server applications development using Oracle
- Expertise in Client-Server applications development using Oracle 19c/12c/11g, PL/SQL, SQL, TOAD and SQL Loader
- Worked in ORACLE Text search that supports free flow text search in applications.
- Experience in performance tuning with tools like OEM, Oracle performance Views, Execution plan, indexes Partitioning, Indexing strategy and hints
- Experience in Data Migration using SQL loader, import/export ,external tables and data pumps
Oracle PL/SQL To MS-SQL Migration
- Involved in Migration of Data and all objects like procedures, Functions, triggers, Complex queries with analytical and aggregate function using T-SQL programming from PL/SQL
- Successfully done migration using tools like SSMS, SSIS
- Automated the QA validation process for validating the data migration
Web app Development
- Experience in creating web application development end to end using ASP. Net Core, MVC, Entity framework, Dapper ORM , React JS and SQL server, MySQL Databases
- Implemented Security protocol to the application using Auth0, OAUTH2
- Experience in Rest API development and AWS API’s endpoint integration with C# and Python.
- Created orchestration of apps for deployment using Docker
Managerial
- Proven experience in handling clients , Team management and creating artifacts which supports project development
- Lead a team of 5 members and Co-ordinated project release and deployment
CLIENTS WORKED WITH
- Raymond James, USA
- Nielsen OGRDS, USA
- Evident Change, USA
- Landmark Groups, UAE
AWARDS & RECOGNIZATION
Best team player award by TCS., Received a sport award and recognized with EY appreciate points
Timeline
Assistant Manager - EY GDS
06.2022 - Current
Senior software engineer - GoAugment Pvt LTD
04.2020 - 06.2022
Associate - Cognizant
08.2019 - 04.2020
Senior developer - GoAugment Pvt LTD, Coimbatore
01.2018 - 07.2019
IT Analyst - Tata Consultancy Services, Chennai
06.2012 - 04.2018
Viveka Matric Higher secondary school - HSC,
Thiagarajar college of Engineering - Bachelor of Engineering,