Anshul Lavaniya
Unix,PLSQL Developer
Bangalore
Summary
An enthusiastic, highly-motivated and hardworking individual having 7.5 years of Experience in- Unix and Shell scripting, SQL, PLSQL, core Java, C programming development and application support in banking and insurance domain, Worked as data migration lead, using PLSQL, elementary knowledge on Informatica Powercenter and big data – Hadoop, doing certification in Business analysis. Keen to gain experience in the IT sector with a view to progress a successful career within a thriving organization. Enjoy working as part of a team, and have the necessary skills and attributes to succeed in challenging and demanding situations. Worked with Capgemini technology solutions for 6 years (April 2014 – May 2020)
Overview
9
9
years of professional experience
6
6
Certifications
1
1
Language
Work History
Data Migration consultant, developer (Senior Consultant)
HCL
03.2022 - Current
- Semi Industry
- Project: Axcelis
- Role: SQL- PLSQL development and support, Writing and executing scripts, functions, procedure
Database developer and support consultant Project
Capgemini
04.2014 - 05.2020
- Type of Industry:
- FSSBU (Financial services and strategic business unit)
- Project
PLSQL developer
02.2019 - 05.2020
- Worked closely with the client/OSC to discuss various ideas/solutions, issues and timelines
- Involved in Coding and testing
- Shell scripting, monitoring, Holiday monitoring
- Monitoring and debugging of failed jobs in the nightly cycles and other daily cycles of batch jobs
- Performance tuning, Data Migration
- Software / Languages, now tool, Excel
- Type of Industry:
- FSSBU
- Project Description, Putty, Service now tool, MS Excel, Toad for oracle11g Transcend front end, Serena dimensions
- Type of Industry:
- FSSBU
- Project Description:
- Genworth : TIA
Database developer and support consultant Project
Guardian Life Insurance
04.2015 - 01.2019
- Worked closely with the client/OSC to discuss various ideas/solutions, issues and timelines
- Preparing analysis, design and testing documents of the application
- Involved in Coding and testing
- Responsible for development of shell scripts for holiday monitoring and daily nightly cycles for updating of transactions into the database
- Monitoring and debugging of failed jobs in the nightly cycles and other daily cycles of batch jobs in Unix system
- Report generation as required from business through SSIS, SSRS, SQL, PLSQL
- Involve in SIT quality check for the bot after integration of modules as per the company best practices
- Job scheduling and maintenance
- New job scheduling and designing
- Worked with client side for UAT testing.
Database developer and support engineer, Project
10.2014 - 04.2015
- Worked closely with the client/OSC to discuss various ideas/solutions, issues and timelines
- Preparing analysis, design and testing documents of the application
- Involved in support ticket solving related to TIA front end and back end.
Education
JAVA/J2EE Internal Training in -
with Capgemini Six Sigma - Yellow Belt Certification in - undefined
Business analysis -
Self
Bachelor of Engineering - Information Techology
RGTU, Bhopal
Skills
Anshul LavaniyaTitlePLSQL development and support consultant, UnixLocationBangalore
PLSQL, Unix & Shell Scripting, C programming, Core Java
Functional: Strategic/Tactical Planning, database development and support with banking and Life insurance domain, Good Communication and Interpretation skills, excellent software development life cycle understanding,Technical: ORACLE 11g, 12C DATABASE, SQL, PLSQL, SSIS, Unix, Linux, application support and development, Core Java, business analysis with Banking and Insurance domain, performance tuning, data migration production support and analysis, software testing
Certification
SQL, PLSQL
Multi Instrumentalist, Can play, Guitar(electric, acoustic), Mandolin, Drums, Bass ; Badminton
Musician : Can Play Guitar - Acoustic & electric, Bass, Mandolin, Drums.
Was U-19 Badminton national Player, played in 2008, hyderabad (School games not open state)
Timeline
Data Migration consultant, developer (Senior Consultant)
HCL
03.2022 - Current
PLSQL developer
02.2019 - 05.2020
Database developer and support consultant Project
Guardian Life Insurance
04.2015 - 01.2019
Database developer and support engineer, Project
10.2014 - 04.2015
Database developer and support consultant Project
Capgemini
04.2014 - 05.2020
JAVA/J2EE Internal Training in -
with Capgemini Six Sigma - Yellow Belt Certification in - undefined
Business analysis -
Self
Bachelor of Engineering - Information Techology
RGTU, Bhopal