Jitendra Lodwal
PostgreSQL & Greenplum DB Developer
Hyderabad,Telangana, INDIA
Summary
Accomplished Sr. Data Architect with extensive expertise at Trigent, specializing in PostgreSQL and Greenplum. Demonstrated success in database migration and performance optimization, significantly enhancing data management capabilities. Proficient in requirements gathering and technical documentation, facilitating successful business intelligence initiatives while ensuring data integrity across complex systems.
Overview
15
15
years of professional experience
Work History
Greenplum Consultant
Omantel
Muskat, Qatar
- Freelance Collaboration with Omantel (Qatar) on Greenplum Migration
Sr.Data Architect
Trigent
Bangalore
10.2023 - Current
- Designed scalable data architectures to enhance business intelligence initiatives.
- Developed logical and physical data models for organizational database systems, ensuring scalability.
- Served as technical project manager at PlanITROI, creating PostgreSQL database models on Azure VM.
- Led MSSQL database migration and code development as Database lead architect for North40 project.
- Contributed as MSSQL developer for Degreed solutions, optimizing database functionalities.
Greenplum & PostgreSQL Data modeler & Database administrator
Finbots.ai
Hyderabad
07.2022 - 09.2023
- Company Overview: Finbots.ai, India
- Conducted data modelling reviews and provided recommendations for improving data modelling best practices.
- Worked closely with database administrators and developers to ensure the successful implementation of data models.
- Conducted data profiling and analysis to identify data quality issues and implemented data cleansing strategies.
- Designed and maintained a comprehensive data dictionary, ensuring data consistency and accuracy across the organization.
- Worked on data migration tool like Ora2PG, AWS data migration services.
- Migrate Oracle workloads into Cloud SQL for PostgreSQL by using Database migration service.
- Migration using AWS DMS schema conversion service for converting Oracle codes object and schemas into PostgreSQL compatible format.
- Finbots.ai, India
Greenplum / PostgreSQL Infrastructure and development engineer
JPMorgan Chase
Hyderabad
01.2017 - 05.2022
- Company Overview: JPMorgan Chase, Hyderabad
- Greenplum/Postgresql Tech. Support & ETL (Informatica support) transformations development.
- Managing database, migrating between Oracle, Greenplum and SAP warehouse (Development & Providing Support and maintenance for Greenplum database).
- Greenplum/Postgresql table creation and maintenance of database, schema, Views, External table, Partition table.
- Prescheduled Vacuum and Analyze, Creating and managing users and their privileges, creating and managing Resource queue & Threshold.
- Table partitioning on the best granular level and maintenance.
- Creation and managing Gpfdist for proper data loading & creation of external table & troubleshooting errors during data load.
- Loading data in to physical table’s using External table, Copy & GPload Utility (script).
- Maintain database log, Database Backup and restore using parallel and non-parallel backup and restore method.
- Automating Backup Using GP cron dump utility. Database Catalog Maintenance.
- Database migration from Development server to Production server, and synchronizing them between two Different versions, according to available utility.
- Successfully migrated an older version of Greenplum 3.x.x to 4.x.x to 5.x.x to 6.x.x.
- Installation of Greenplum performance Monitor.
- Successfully installation & setup of new greenplum server with 4.1.0.0 version, 5.x.x version, 6.x.x version.
- Greenplum & Posgresql installation, New patches Upgrade in existing database, Version Upgrade (include Major upgrade & Migrate, Minor Upgrade).
- Segment Recovery, database performance testing, and managing workload. Troubleshooting.
- Developed CTAS Script for maintaining the growth of table size.
- Developed cronscript for Cleaning and Transforming the error from flat files and source.
- SQL script for loading data into Data warehouse schema in Greenplum using Informatica Power Center 8.5.1.
- Pearl script to clean data and load in to final table, Shell script writing according to requirement.
- Writing and managing Crontab & Crontjob, Reports creation, Maintaining & scheduling them through crontab.
- JPMorgan Chase, Hyderabad
Lead Architect (Greenplum / PostgreSQL)
Wipro Infotech
Juffair
11.2015 - 01.2017
- Engaged with stakeholders to collect requirements and establish project scope.
- Functioned as PostgreSQL database architect for Batelco in Bahrain.
- Supported Pivotal’s technical needs as Senior Greenplum Resource at Wipro.
Greenplum/PostgreSQL Consultant
ServisCo Pty. Ltd.
Melbourne
08.2011 - 09.2015
- Collaborated with AMbank, Malaysia as Greenplum Consultant to enhance data management capabilities.
- Consulted for OCBC NISP Bank, Indonesia, optimizing database performance as Greenplum Consultant.
- Served as Greenplum Consultant for National Stock Exchange in Mumbai, India, improving analytical processes.
Project Associate Greenplum
Cognizant Technology Solution
04.2011 - 07.2011
- Company Overview: Bangalore
- Bangalore
Greenplum Engineer
Nokia Siemens Network
02.2011 - 04.2011
Greenplum developer & DBA
Future Knowledge Service
10.2009 - 01.2010
- Company Overview: Ahmadabad (INDIA)
- Ahmadabad (INDIA)
Tech. Consultant
Sitar Technologies
Melbourne
02.2008 - 03.2009
- Company Overview: through Sitar Technologies in Australia
Tech. Consultant
Data Grid solutions
08.2007 - 11.2007
- Company Overview: Bangalore
- Bangalore
Education
M.C.A - Master of computer application
Punjab Technical University
03.2007
M.Sc (IT) - Master of science (IT)
Punjab Technical University
09.2005
M.C.M - Master of computer management
D.A.V.V University
05.2004
B. Com - Bachelor of commerce
D.A.V.V University
04.2002
English Steno -
M.P Board
03.1999
Skills
- PostgreSQL and Greenplum
- Data warehousing and ETL
- Shell scripting
- Database migration and administration
- Performance optimization
- Technical documentation
- Requirements gathering
Interested In Relocation
Anywhere in India or Abroad
Passport Status
G3456295, Valid : 2026
Current Company & Designation
Trigent Software Pvt. Ltd. as Senior Data Architect (PostgreSQL/Greenplum/MSSQL Infrastructure & Operations)
Personal Information
- Current CTC: 40,00,000/- INR Annual (Fixed)
- Expected Salary: As per company norms
- Notice Period: 1 month (Negotiable)
- Date of Birth: 10/16/82
- Marital Status: Married
Languages
Hindi
First Language
English
Upper Intermediate (B2)
B2
Disclaimer
- I hereby declare that the particulars given above are authentic and true to the best of my knowledge.
References
References available upon request.
Timeline
Sr.Data Architect
Trigent
10.2023 - Current
Greenplum & PostgreSQL Data modeler & Database administrator
Finbots.ai
07.2022 - 09.2023
Greenplum / PostgreSQL Infrastructure and development engineer
JPMorgan Chase
01.2017 - 05.2022
Lead Architect (Greenplum / PostgreSQL)
Wipro Infotech
11.2015 - 01.2017
Greenplum/PostgreSQL Consultant
ServisCo Pty. Ltd.
08.2011 - 09.2015
Project Associate Greenplum
Cognizant Technology Solution
04.2011 - 07.2011
Greenplum Engineer
Nokia Siemens Network
02.2011 - 04.2011
Greenplum developer & DBA
Future Knowledge Service
10.2009 - 01.2010
Tech. Consultant
Sitar Technologies
02.2008 - 03.2009
Tech. Consultant
Data Grid solutions
08.2007 - 11.2007
M.C.A - Master of computer application
Punjab Technical University
M.Sc (IT) - Master of science (IT)
Punjab Technical University
M.C.M - Master of computer management
D.A.V.V University
B. Com - Bachelor of commerce
D.A.V.V University
English Steno -
M.P Board
Greenplum Consultant
Omantel
Similar Profiles
Rizwan Abdul RahmanRizwan Abdul Rahman
Digital Transformation Project Manager at OmantelDigital Transformation Project Manager at Omantel
Jamal Al WahaibiJamal Al Wahaibi
Geographic Information System Specialist at OmantelGeographic Information System Specialist at Omantel
Zahid Hussain SyedZahid Hussain Syed
Expert – Manager FP&A and Investments at OmantelExpert – Manager FP&A and Investments at Omantel
Mohd SulemaanMohd Sulemaan
Engineer-2nd at VerizonEngineer-2nd at Verizon
Naidu PentakotaNaidu Pentakota
Assistant Manager - Maintenance at TotalEnergies Marketing India Pvt LtdAssistant Manager - Maintenance at TotalEnergies Marketing India Pvt Ltd