Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic
Mehul Pitroda

Mehul Pitroda

Data Engineer
Pune

Summary

Experienced technical expert with over 13 years of experience in esteemed organizations such as Synechron Technology, Bajaj FinServ, RBS Technology, Sopra Steria, and Nucleus Software Export Ltd. Specializes in PL/SQL programming with a strong focus on performance tuning and deep understanding of UNIX shell scripting. Has hands-on experience in Azure data engineering services like Azure Data Factory, Pyspark, and Power BI, leveraging strong analytical skills for requirements analysis and business process review. Proficient in DevOps tools including TeamCity, UrbanCode, and GitHub. Possesses knowledge in Oracle Forms & Report and the intricacies of the banking domain. Skilled in data modeling (logical and physical design of databases) with a solid understanding of cloud platforms such as Azure and AWS. Throughout career, consistently demonstrates exceptional teamwork, leadership abilities, and strong interpersonal skills.

Overview

14
14
years of professional experience
8
8
years of post-secondary education
4
4
Certifications

Work History

Associate Specialist Technology

Synechron Technology
08.2021 - Current
  • Working on Investment baking project designed to provide E2E trade/collateral/valuation reporting lifecycle for various jurisdiction.
  • Design and Develop Complex ETL pipelines for various sources and Develop MIS reporting.
  • Optimize the process for Large volume trades which gets booked by various Deal stores and get reported to regulators on the daily basis.
  • As a Techno functional DATABASE/UNIX DEVELOPER and Scrum master, I do requirement study with BA/Initiative manager and look into end to end delivery cycle and helps to prioritize tasks
  • assigning/guide, I also involve in post go live support and training of production team
  • Mentored junior team members in best practices for technology use, fostering a culture of continuous learning and improvement.
  • Collaboration with various stockholder for managing the delivery signoff .
  • Find out the Performance loopholes in production and Enable prod team to optimize those processes .
  • Logged updates on support tickets to communicate status to users and managers.
  • Post GO live support and training to Prod team
  • Implemented effective change management strategies to facilitate smooth adoption of new systems and processes among users.
  • Assisted in the recruitment process by screening candidates and conducting interviews, ultimately helping build a strong talent pipeline for future growth opportunities.
  • Developed innovative solutions for complex problems, resulting in increased client satisfaction.

Technical Lead Software Developer

Bajaj FinServ
12.2019 - 08.2021
  • Worked on Finnone Mortgage CAS , which is Core for all source system where raw data pushed by booking platform and pushed to CAS system.
  • I worked on CAS Performance migration project where Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly which helps to process significant volume growth of CD Loans.
  • I delivered enhancements comes Covid-19 like Flexi conversion and delivered this on record time following all the process.
  • Ensured data quality through cleansing and modeling of data , rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies. Responsible for
  • Form a process to rectify isolating problematic data sets, correcting errors via automated process and then re-running the data processing pipeline with the updated information
  • Collaborated with cross-functional teams to deliver high-quality software products on schedule.
  • Developed reusable components for various projects, reducing development time and increasing efficiency across the team.
  • Managed product releases from planning stages to deployment while minimizing risks associated with change management processes.
  • Maintain the delivery chain & code propagation in multiple environment.
  • Participated in code reviews, promoting best practices and ensuring adherence to coding standards.
  • Facilitate UAT and PROD support for releases.
  • Analyses the design & do the Gap analysis of deliverable


Software Designer

Royal Bank of Scotland
06.2015 - 12.2019
  • I worked on mortgage (GMS) project and involve on end to end release journey .developed daily Batch Jobs .
  • Fostered a culture of continuous improvement within the development team, by implementing the CI/CD process I configure and integrated release process via urban code deployment.
  • Conducted comprehensive code reviews as part of quality assurance measures, ensuring that only error-free code was incorporated into the final software product via dress rehearsal activity and preparing the Run book..
  • I work on code propagation to maintain delivery chain
  • Ensured seamless integration of new components into existing systems through thorough compatibility testing and documentation updates.
  • Contributed to overall business growth by consistently delivering innovative, high-impact software solutions that met or exceeded client expectations.
  • I worked on devops tools like team city to manage delivery chain and code propagation to minimize and automate the release process.
  • Managed project scope, schedule, status and documentation.

Requirement Analysis & Development

Sopra Group India
06.2013 - 06.2015
  • I involve in delivery of Investment Banking (Capita Prism project, France ) which is raw development project It has many core investment modules including register maintenance, Systematic Investment Plan and Corporate Action Group.
  • It also has feature for importing data from external resources through various files.
  • Coordination with Business Analyst for BRD and FRD preparation and designing Workflow of database.
  • Integration with various services and GUI for developed program unit,which act like a API's .
  • Getting sign-off from data architect on workflow design for various deliveries.
  • Stocks can be maintained for single company and also for group of companies.
  • Conducted root cause analysis on critical issues impacting business operations, recommending targeted solutions to mitigate risks and drive positive outcomes.

Development and Production support

Nucleus Software Export Limited
01.2011 - 06.2013
  • Development using PL/SQL and designing Workflow for application
  • Provided production support and co-ordination for getting sign-off on submitted deliverables
  • Interacting with clients for UAT testing & Sign-off activity
  • Responsible for database migration and purging
  • Optimized the EOD/BOD Processes for multiple client like ENBD/CFC by Analyzing the AWR reports and trace file.
  • I worked on FinnOne is a web-based global banking product designed to support banks and financial solution companies in dealing with assets, liabilities, core financial accounting and customer service.
  • I worked on various functional aspect to maintain the BAU process like approved of loans, disbursal's, accruals, billing, repayments, rescheduling, non performing assets tracking, provisioning, termination handling, document tracking and insurance tracking
  • I worked on developing critical features like fees and charges engine and integrated with the FinnOne General Ledger which was core of it's accounting.
  • I also worked on developing various features for personal loans, auto loans, housing loans and consumer loans, there by helping the lending organizations compete better solution.
  • I worked to integrated developed flow with the FinnOne General Ledger.

Education

MCA -

Bhilai Institute of technology
06.2006 - 06.2009

B.S.C - undefined

Shri Sankarachrya College
05.2003 - 05.2006

H.S.C - undefined

C G Board
05.2001 - 05.2003

S.S.C - undefined

M P Board
01.2001 - 05.2001

Skills

PL/SQL Developer

undefined

Certification

Certified Scrum Master

Accomplishments

  • Awarded “Employee of the Month” in June 2024 at Synechron.
  • Recognized with Hero Award Jan-2021 at Bajaj Finserv.

Timeline

Associate Specialist Technology

Synechron Technology
08.2021 - Current

Technical Lead Software Developer

Bajaj FinServ
12.2019 - 08.2021

Software Designer

Royal Bank of Scotland
06.2015 - 12.2019

Requirement Analysis & Development

Sopra Group India
06.2013 - 06.2015

Development and Production support

Nucleus Software Export Limited
01.2011 - 06.2013

MCA -

Bhilai Institute of technology
06.2006 - 06.2009

B.S.C - undefined

Shri Sankarachrya College
05.2003 - 05.2006

H.S.C - undefined

C G Board
05.2001 - 05.2003

S.S.C - undefined

M P Board
01.2001 - 05.2001

Similar Profiles

CREATE PROFILE
Mehul PitrodaData Engineer