Lakshmanan V

Software Engineer

Bengaluru, Karnataka, India7 yrs 11 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

6+ years of experience in IT and services industry
Proficient in PL/SQL and Oracle Database management
Expert in ETL processes and data auditing

Stackforce AI infers this person is a Backend-heavy Fullstack developer with expertise in SaaS and data management.

Contact

Skills

Core Skills

Pl/sqlOracle DatabaseSnowflakeData Analysis

Other Skills

BMC Control-MCommunicationData ArchitectureDatabasesETLExplain PlanJSONJavaJiraMSSQLOracle 11gOracle E-Business SuiteOracle FormsOracle ReportsPerformance Tuning

About

Having 6+ years of experience with a demonstrated working in the information technology and service industry Skilled in SQL, Snowflake,Oracle 12c/19c Database, PL/SQL Development.Handled performance tuning by using Index and Explain planAuthored SQL Queries like Joins and Sub queries, Analytical functions, group functions. Recorded and tracking the errors and bugs found in the code during the Unit test in the quality tracking tool Git, Repo.Developed Snow SQL Snowflake existing codes which requires for new standalone software applications based on the requirements provided by business. Monitored and executed ETL jobs in Snowflake.Orchestrated in Snowflake AWS cloud data warehouse to maintain the data for audit and reporting purpose.

Experience

Tata consultancy services

Software Engineer

Feb 2022 – Present · 4 yrs 1 mo · Bengaluru, Karnataka, India

Proficient in PL/SQL and creation and modification of database objects like Tables, and Indexes.
Acquired Proficiency in Oracle applications using to upload the manual data through Oracle Forms and Oracle Reports any job failure issues will get the logs in EBS applications.
Created indexes and tables as part of performance tuning exercise
Knowledge about ETL process and have experience and understanding about Informatica.
Developed DB (PL/SQL) Snowflake existing code which requires for new standalone software applications based on the requirements provided by business.
Auditing the data in daily reports Revenue and Billing information and validated if any issues occurs.
Hands on experience in creating and modifying PL/SQL Packages, Procedures and Functions.
Having good understanding working with Collections, bulk collect, Dynamic SQL, Triggers.

PL/SQLOracle DatabaseETLPerformance TuningSnowflake

Xforia global talent solutions

Senior Consultant

Feb 2021 – Aug 2021 · 6 mos · Greater Chennai Area · On-site

Aditi consulting

Consultant

Dec 2019 – Jan 2021 · 1 yr 1 mo · Greater Bengaluru Area

American it resource group

Consultant

Jun 2017 – Jul 2018 · 1 yr 1 mo

365 media

Associate

Apr 2014 – Jun 2015 · 1 yr 2 mos · Coimbatore, Tamil Nadu, India

Executed Jobs in Java from Linux server.
Orchestrated closely with development team and testing in Oracle Database data and reporting to the QA team.
Maintained stores data differ from pricing data analysis and big data pricing information.
Identified Bugs individually reported by developers.
Scheduling and Monitoring team and Dev, QA & Functional team

JavaOracle Database