Accomplished Senior Developer with 12+ years of IT experience, Expert in Oracle SQL,PL/SQL,PostgreSQL, GCP and proficient in performance tuning and database migrations
Overview
13
13
years of professional experience
Work History
Senior Developer
IG Infotech
10.2021 - Current
Writing PLSQL procedures, functions and triggers as per business requirements.
Identify the areas of performance bottlenecks and resolve them.
Creating load processes to load upstream data (Kafka, Oracle Golden Gate, Other databases, files) to various DB environments.
Creating file gen processes to generate regulatory and internal reports using process frame works.
Responsible for module wise database migrations from Oracle to PostgreSQL.
Responsible to solve data storage issues and defining data retention policies.
Monitoring OGG replication and fixing replication issues.
Responsible for sprint wise deployments.
Solving incidents, tasks and PBIs.
Mentored junior developers, promoting a culture of continuous learning and knowledge sharing within the team.
Senior Consultant
Capgemini
01.2015 - 10.2021
Worked on IKEA Retail Web on ecommerce domain.
Writing complex SQL queries based on requirements.
Writing or enhancing PLSQL procedures, functions and triggers as per business requirements.
Moving database objects to destination database like tables, constraints, Indexes, views, sequences, synonyms and all other DB objects and solving the issues during migration activities.
Preparing meta data solution design documents for data masking and cleaning activities for test data management.
Responsible for release wise database deployments.
Responsible for data cleanup activities.
Responsible for doing DB refresh in 50+ lower environments using DATAPUMP.
Monitoring Databases using OEM and Ignite tools.
Technical Specialist
Tech Mahindra
10.2013 - 01.2015
Worked on Sales Quote Engine on telecom domain.
Writing SQL queries, PLSQL procedures, functions and triggers as per requirements.
Analyze the existed data models as part of data consistency adding integrity constraints to stabilize the database.
Systems Development Associate
ACS Xerox
01.2012 - 10.2013
Designed, planned, organized and directed orientation and training programs for employees or customers.
Completed projects in alignment with target deadlines and financial objectives.
Presented information using variety of instructional techniques or formats, such as role-playing, simulations, team exercises, videos and lectures.
Administered government-supported community development programs and promoted department programs and services.
Education
Master of Science - Computer Applications Development
Jawaharlal Nehru Technological University
Kakinada, India
04.2001 -
Skills
Oracle SQL, PL/SQL, PostgreSQL, MySQL
Timeline
Senior Developer
IG Infotech
10.2021 - Current
Senior Consultant
Capgemini
01.2015 - 10.2021
Technical Specialist
Tech Mahindra
10.2013 - 01.2015
Systems Development Associate
ACS Xerox
01.2012 - 10.2013
Master of Science - Computer Applications Development
Jawaharlal Nehru Technological University
04.2001 -
Similar Profiles
Shreeja MangathilShreeja Mangathil
Lead Manager-Program/Project Management at IG InfotechLead Manager-Program/Project Management at IG Infotech