Krunal Gujarathi
Database Consultant / Database Specialist / Data & Application Architect
Mumbai
Summary
Dynamic professional targeting Senior, Team Lead, or Managerial positions in Oracle Development, Project Management, Database Development, Data Modeling, Data Engineering, Data Architecture, and Application Architecture. Over 14.5 years of experience as a Senior PL/SQL Developer and Oracle Team Lead includes expertise in technical architecture, application architecture, enterprise solutions, and comprehensive database development across BFSI domains such as IPOs, order lifecycle management, payments, billing, accounting, taxation, and global regulatory reporting. Proven leadership in managing cross-functional teams while overseeing the full application lifecycle in Agile environments ensures effective support and incident resolution. Committed to aligning business objectives with technical execution to enhance operational efficiency and drive growth through strategic initiatives and innovative problem-solving. Strong advocate for data and AI solutions that automate operational activities, including daily health checks and regression test cases for continuous improvement.
Overview
15
15
years of professional experience
4
4
Languages
Work History
AVP, Application Lead
HDFC Securities
2024.10 - Current
- Leading the architecture and development of trading platforms (IPO, ORS, advisory apps) with secure, scalable Oracle backend systems.
- Managing project planning, release cycles, and API integrations with strict adherence to compliance and performance.
- Driving DevOps coordination, code reviews, and CI/CD pipelines while leveraging AI tools (ChatGPT, Gemini, Copilot) for automation and optimization.
- Analyzed data to identify areas of improvement, implementing changes that resulted in greater operational efficiency, which reduced 40% of manual efforts and the workload of one-third of man-days.
- Managed projects efficiently, ensuring timely delivery, and high-quality results with 95% success rates.
- Implemented and developed operational standards, policies and procedures.
Associate Specialist, Database Tech
Synechron Inc. (Client: UBS)
2024.01 - 2024.10
- Designed and optimized Oracle PL/SQL components for global market and regulatory reporting (ESMA, EMIR, FCA, MAS) for collateral and valuation.
- Developed data pipelines, backend packages, and technical documentation for large-scale investment banking systems, and applied multiple performance tuning techniques for high-scale data processing to process approximately 10,000 records per second.
- Achieved the highest level of efficacy in data processing, with less than 2% data discrepancy in each release, among all the teams working on different reports.
- Enhanced team productivity by streamlining processes and implementing efficient project management tools.
Sr. Software Engineer (Data Engineer)
TCS (Client: Nielsen Media)
2022.10 - 2024.01
- Built data pipelines and automated ETL using Python, PySpark, Hive, Sqoop, and AWS (S3, EMR).
- Developed PL/SQL procedures for processing audience measurement data at scale (Nielsen).
- Developed Python automation code leveraging AWS services (like CloudFormation, SNS, SQS, Lambda, Athena, RDS, etc.), Kafka streaming, PySpark, Hive, PL/SQL, and Unix shell script to generate different metrics required by the business to detect data anomalies and fraud detection.
- Applied automation and AI-assisted development for regression testing and documentation.
- Created automation frameworks, reducing manual testing and deployment by over seven man-days per cycle.
- Enhanced software functionality by identifying and resolving complex technical issues.
- Maintained comprehensive documentation of development work, facilitating knowledge sharing among team members.
Chief Manager (Database Lead)
Kotak Mahindra Bank
2022.01 - 2022.10
- Led a team in designing and developing Oracle PL/SQL components for NEFT, RTGS, and credit card platforms.
- Delivered low-latency, database-optimized solutions for payment systems; collaborated with Java and .NET teams for the consumption of given DB objects.
- Defined workloads, schema modeling, and internal specs for feature development.
- Managed a team of professionals to achieve organizational goals and maintain high productivity levels.
- Collaborated with API teams and developed the optimum DB objects as per the need, and performed SIT and security analysis before handing over the objects to API teams for integration.
- Reduced the payment processing timelines of the NEFT and RTGS modules by 30%.
- Migration of credit card objects to optimum DB-based objects to reduce the processing time on the website and mobile app, which helps reduce the processing time at the front end by more than 75%.
Technical Project Manager (Database Lead)
National Stock Exchange
2015.05 - 2021.12
- Developed optimized Oracle DB objects and stored procedures required for the daily processing of NSE finance application needs for accounting, billing, investment, and taxation.
- Act as an important team member in DB design, data modeling, application architecture to design the new appliation DB model which must be align with specific normalization(NF), SCD deatils and maximum efficiency.
- Leveraged many DB performance optimization techniques, such as query optimization, query rewriting, indexing, partitioning, bulk processing, and fragmentation, to achieve the highest level of performance, and optimized more than 70 processes to achieve more than a 50% performance improvement on average.
- Managed two teams (11 members) for Oracle development and production support in finance, billing, and taxation applications.
- Spearheaded migration from Oracle Forms to J2EE; ensured secure schema designs, and SDLC compliance.
- Delivered enhancements, UAT support, VAPT closures, CA closures, and release documentation aligned with audit and business goals.
- Participated in application audits and compliance reviews with leading auditing firms, such as Deloitte, PwC, and EY.
- Successfully managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals.
- Planned, designed, and scheduled phases for large projects.
Asst. Manager (Oracle Dev)
Reliance Communications
2015.01 - 2015.05
- Developed and maintained PL/SQL and Oracle Forms/Reports for telecom business systems (Clarity).
Sr. Software Engineer
KPIT (via Harjai Computers)
2014.10 - 2014.12
- Handled PL/SQL and Oracle Forms/Reports development for the Cummins BMS platform.
- Developed scalable applications using agile methodologies for timely project delivery.
- Collaborated with cross-functional teams to design innovative software solutions.
Software Engineer
Lemon Technologies
2011.09 - 2014.10
- Delivered PL/SQL and Oracle Forms solutions in finance, import/export, and inventory systems.
- Involved in the full SDLC, including requirements, development, testing, and production support.
- Developed scalable and maintainable code, ensuring long-term stability of the software.
- Consistently met project deadlines by effectively managing time and prioritizing tasks according to importance.
- Improved software performance by identifying and resolving bottlenecks in the code.
Education
Associate of Science - Data Science – Data Engineer track
IIIT-Bangalore
Bengaluru, India 2001.04 -
Bachelor of Science - Information Technology
L.J. Institute of Engineering & Technology, Gujarat University
Ahmedabad, Gujarat 2001.04 -
High School Diploma -
Dr. S&SS Ghandhy College of Engineering
Surat, Gujarat 2001.04 -
Skills
Databases: Oracle 19c/12c/10g/9i/8i, MS SQL, PostgreSQL, MySQL
NoSQL: Apache HBase, MongoDB (Basics)
Big Data: Hadoop, HDFS, Hive, HQL, Spark, PySpark, SparkQL, Sqoop, Kafka, Airflow, Redshift
Cloud: AWS (EC2, EMR, Athena, Redshift, RDS, S3, DynamoDB, Lambda)
Languages: SQL, PL/SQL, Unix Shell, Python, Linux
Timeline
AVP, Application Lead
HDFC Securities
2024.10 - Current
Associate Specialist, Database Tech
Synechron Inc. (Client: UBS)
2024.01 - 2024.10
Sr. Software Engineer (Data Engineer)
TCS (Client: Nielsen Media)
2022.10 - 2024.01
Chief Manager (Database Lead)
Kotak Mahindra Bank
2022.01 - 2022.10
Technical Project Manager (Database Lead)
National Stock Exchange
2015.05 - 2021.12
Asst. Manager (Oracle Dev)
Reliance Communications
2015.01 - 2015.05
Sr. Software Engineer
KPIT (via Harjai Computers)
2014.10 - 2014.12
Software Engineer
Lemon Technologies
2011.09 - 2014.10
Associate of Science - Data Science – Data Engineer track
IIIT-Bangalore
2001.04 -
Bachelor of Science - Information Technology
L.J. Institute of Engineering & Technology, Gujarat University
2001.04 -
High School Diploma -
Dr. S&SS Ghandhy College of Engineering
2001.04 -
Languages
English
Hindi
Gujarati
Marathi
Awards & Recognitions
NSE Productivity Champion Award (2021), Academic Star – IIIT Bangalore (2023), Appreciated for AI-driven automation frameworks (TCS/Nielsen, 2023)
Disclaimer
I hereby declare that the information furnished above is true and correct to the best of my knowledge and belief. Krunal Rajeshkumar Gujarathi
Core Competencies
System Engineering, Application Architecture, Data Modeling, Data Architecture, Oracle SQL & PL/SQL Development, Automation, Requirement Gathering & Analysis, Solution Design & Implementation, Test Planning & Estimation, Version control, git, SVN, Project Management, Configurations & Migrations, Product Lifecycle Management, Database Design and Modeling, Data Science & Engineering, Testing and UAT Support, Scrum/Agile Methodologies, SIT and solutioning, API testing and configuration, Integration Testing, UAT support, Test data creation, Internal Communications, Operations Management, Crisis Management, Distribution Strategy, Data-driven decision making, Problem-Solving, Strategic planning, Organization Improvement, Cross-functional collaboration
Awards & Recognitions
NSE Productivity Champion Award (2021), Academic Star – IIIT Bangalore (2023), Appreciated for AI-driven automation frameworks (TCS/Nielsen, 2023)
Disclaimer
I hereby declare that the information furnished above is true and correct to the best of my knowledge and belief.