Sri Harsha Kothapalli
Guntur
Summary
Adept Associate Principal Database Engineer with a proven track record at DB Consulting, Jocata Financial Advisory & Technology, I excel in SQL expertise and performance tuning. My experience includes enhancing database efficiency by over 30%, showcasing my analytical prowess and problem-solving skills. Skilled in data modeling and migration, I drive business growth through technological innovation and streamlined operations.
Overview
10
10
years of professional experience
Work History
Associate Principal Database Engineer
DB Consulting, Jocata Financial Advisory & Technology
03.2021 - Current
- Company Overview: Jocata Financial Services creates a digital ecosystem of technologies that deliver adaptive solutions for financial institutions at high velocity and scale, driving business growth, streamlined operations, risk-adjusted insights and regulatory compliance
- Website: [Not provided]
- Data Modelling as per the requirement of the client / business team and development team
- Creation / Updation, deletion and migration of tables across multiple servers
- Creation / Updation and Deletion of Procedures / Triggers / Functions / views for supporting the UI platform
- Managing the slow query logs or long running queries and further adding the indexes or redesigning the queries for better performance of the query
- Taking Dump and restore of databases or tables from DEV > QA > Pre-PROD > PROD environments
- Working experience in handling the project in Postgres server as well as MySQL server
- Jocata Financial Services creates a digital ecosystem of technologies that deliver adaptive solutions for financial institutions at high velocity and scale, driving business growth, streamlined operations, risk-adjusted insights and regulatory compliance
- Website: [Not provided]
Database Developer
Interakt Digital Solutions
08.2019 - 03.2021
- Company Overview: Email/SMS Marketing for Clients like HDFC, UTI, Royal Sundaram and Infogroup
- Website: [Not provided]
- Verification of campaigns scheduled for blast and monitoring of campaign approval and blast followed by report verification
- DB Manipulations such as create, update and delete respective for campaign report generation
- Maintain the list of the targeted customers in database received from the clients
- Create campaigns in Database and schedule the campaigns to target the audience
- Post successful campaign blast, gather all the campaign related details with the client
- Email/SMS Marketing for Clients like HDFC, UTI, Royal Sundaram and Infogroup
- Website: [Not provided]
Fraud Analyst
ADF Data Science Pvt Ltd
11.2015 - 07.2019
- Company Overview: The customer related application details and post approval details are stored in salesforce
- Our CC team interacts with our banking clients through SF
- Also, the cases raised by customers are assisted here
- Website: [Not provided]
- Creation of reports/alerts from the database linked to SF
- The cases raised by CC agents regarding clients are assisted here
- Email Communication to customers is made through salesforce
- Editing and updating the customer related data as well as loan data
- Generate daily/weekly and monthly reports regarding customers related data (disbursals and payments)
- The customer related application details and post approval details are stored in salesforce
- Our CC team interacts with our banking clients through SF
- Also, the cases raised by customers are assisted here
- Website: [Not provided]
Software Engineer Training
CMC (Merger with TCS)
05.2015 - 10.2015
- Company Overview: Website: [Not provided]
- Website: [Not provided]
Education
B.Tech -
NRIIT
01.2015
Intermediate -
Sri Chaitanya
01.2011
SSC -
St. Rosette
01.2009
Skills
- SQL expertise
- Performance tuning
- Data modeling
- Data migration
- Scripting languages
- Relational databases
- Backup and recovery
- Data analysis
- SQL programming
- Query optimization
- Database design
- Indexing strategies
- Database administration
- SQL and databases
Languages
- English
- Hindi
- Telugu
Disclaimer
I hereby declare that the above-mentioned details are true and fair to the best of my knowledge.
Date And Place
CURRENT_DATE, CURRENT_PLACE
Personal Information
- Father's Name: Venkata Ramana Rao Kothapalli
- Date of Birth: 12/08/94
Languages
Telugu
First Language
English
Proficient (C2)
C2
Hindi
Advanced (C1)
C1
Projects
- Jocata Financial Advisory & Technology – Database Engineer (Financial Services)
- Developed data models, created/deleted/migrated tables, and managed database objects (procedures, triggers, functions, views).
- Optimized database performance by handling slow queries, adding indexes, and redesigning queries.
- Managed database backups, restorations, and migrations across different environments (DEV > QA > Pre-PROD > PROD).
- Digital Solutions / Resulticks – Database Developer (Digital Marketing)
- Handled Email/SMS marketing campaigns, ensuring proper scheduling, approvals, and report verification.
- Managed customer databases, campaign creation, and execution for targeted audiences.
Performed database operations (create, update, delete) for campaign report generation and data maintenance.
- Applied Data Finance Private Limited / Personify Financial – Software Engineer (Salesforce, MySQL)
- Managed customer application details and post-approval processes in Salesforce.
Created database-linked reports/alerts and assisted in handling customer cases via Salesforce. - Maintained and updated customer and loan data, generating daily/weekly/monthly reports.
Timeline
Associate Principal Database Engineer
DB Consulting, Jocata Financial Advisory & Technology
03.2021 - Current
Database Developer
Interakt Digital Solutions
08.2019 - 03.2021
Fraud Analyst
ADF Data Science Pvt Ltd
11.2015 - 07.2019
Software Engineer Training
CMC (Merger with TCS)
05.2015 - 10.2015
B.Tech -
NRIIT
Intermediate -
Sri Chaitanya
SSC -
St. Rosette
Similar Profiles
MOHIT SURANAMOHIT SURANA
Associate Delivery Manager at Jocata Financial Advisory Pvt. Ltd.Associate Delivery Manager at Jocata Financial Advisory Pvt. Ltd.
Srilekha MSrilekha M
Senior Machine Learning Engineer at Jocata Financial Advisory and ServicesSenior Machine Learning Engineer at Jocata Financial Advisory and Services
P Sandeep KumarP Sandeep Kumar
Associate Engineering Manager at Jocata Financial Advisory LimitedAssociate Engineering Manager at Jocata Financial Advisory Limited