Mahendra Patle
Markit EDM Team Lead
Pune,Maharashtra
Summary
Experienced IT professional with over 10 years of expertise in all phases of the Software Development Lifecycle (SDLC), including analysis, design, development, testing, implementation, and maintenance. Adept at leading architecture and solution design for complex Market Data projects, focusing on Core and UI component development to meet critical business needs. Skilled in designing and implementing Master Data Management solutions for financial data categories such as security, price, issuer/organization, and index & rating. Extensive hands-on experience with the Markit EDM, managing the development lifecycle stages of data loading, staging, mastering, routing, and publishing while leveraging components like Solution, Core Matcher, Data Matcher, Data Constructor, Data Generator, Manager, Data Porter, Rule Builder, Workflow, Pages, and Elements. Proficient in XML data modeling and integrating Markit EDM with relational databases using optimized SQL queries, coupled with expertise in workflow automation using Autosys jobs. Successfully led the migration to Version 19.2 EDM, aligning technical designs with EDM standards to ensure smooth implementation. Highly skilled in SQL, including writing and debugging packages, stored procedures, triggers, and performance-tuned queries. A collaborative and detail-oriented leader, fostering positive team environments through coaching and cross-functional collaboration to streamline workflows and drive continuous improvement. Recognized for being self-motivated, independent, and a reliable problem-solver with strong technical and interpersonal skills.
Overview
10
10
years of professional experience
1
1
year of post-secondary education
2
2
Languages
Work History
Markit EDM Team Lead
Citco
Pune
09.2021 - Current
- Led the architecture and solution design for Market Data projects, including the development of core and UI components.
- Developed and deployed robust pricing and security solutions , addressing critical business needs and enhancing overall data management capabilities.
- Led the Version 19.2 EDM migration project , ensuring a smooth transition and successful implementation of the updated platform.
- Designed and implemented the Core Matcher from scratch, establishing both the Solution Service and Core Matcher Service to optimize data matching processes.
- Spearheaded the design and development of Master data management for security , price , issuer/organization , and index & rating .
- Directed the development lifecycle of Markit EDM , covering critical stages such as data loading, capturing, staging, mastering, routing, and publishing.
- Designed and implemented EDM solutions from scratch for key financial data sources like Reuters , MSCI , and Bloomberg , ensuring seamless integration and processing of data.
- Worked on various Markit EDM components including Solution , Core Matcher , Data Matcher , Data Constructor , Data Porter , Data Inspector , Rule Builder , Table Builder , View Builder , Data Generator , Data Manager , Illustrator , Workflow , Pages , and Elements .
- Designed and maintained XML data models , delivering end-to-end solutions integrating Markit EDM , relational databases, and SQL queries.
- Oversaw setup and scheduling of workflows using Autosys jobs , ensuring seamless execution of processes.
- Prepared and reviewed technical designs following Markit EDM standards , ensuring successful implementation of business requirements.
- Fostered positive team environment by promoting collaboration, open communication, and employee recognition initiatives.
- Enhanced team performance through coaching, regular feedback, and skill development opportunities, ensuring continuous improvement.
- Collaborated with cross-functional teams and department leads to streamline workflows, improve interdepartmental coordination, and achieve shared organizational goals.
Markit EDM & SQL Developer
HSBC
Pune
05.2019 - 09.2021
- Responsible for development of Data Porter, Data Inspector, Rule Builder, Data Matcher, Data Constructor, Solutions and all other components of Markit EDM (Cadis)
- Working on XML data models, supporting and developing end to end solutions using Markit EDM, relational databases and querying with SQL
- Exposure to Markit EDM architecture and solution designing
- Experience on Markit EDM Web client configuration Elements, Pages, Workflows
- Good understanding of Markit EDM best practices and solution diagrams
- Prepare technical design as per Markit EDM standards for implementation of requirements
- Involved in development of loading and capturing, staging, mastering, routing/publishing stages of Markit EDM
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
Oracle PLSQL Developer
IBM
Pune
03.2015 - 05.2019
- Understanding and Collecting requirements from Business Analyst and convert that requirement to SQL queries or PL SQL
- Involved in all phases of SDLC in analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
- Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications
- Writing or debugging Packages, Stored Procedures, Functions, Triggers, Cursors, Materialized views, index-organized tables, Global Temporary Tables, View, Partition table, Nested table
- Used collections, cursors to process huge volumes of data and bulk collect for mass update as performance improvement process
- Expertise in creating indexes on tables and partitioning table for SQL tuning purpose
- Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
- Responsible for performance tuning activities in project
- Increased application stability by troubleshooting and resolving complex PLSQL issues in timely manner.
Education
Bachelor of Engineering - Electronics & Telecommunication
Sant Gadge Baba Amravati University
Amravati, MH 01.2014 - 12.2014
Skills
Disclaimer
I affirm that the above information is true, and I bear the responsibility for correctness of above-mentioned information.
Timeline
Markit EDM Team Lead
Citco
09.2021 - Current
Markit EDM & SQL Developer
HSBC
05.2019 - 09.2021
Oracle PLSQL Developer
IBM
03.2015 - 05.2019
Bachelor of Engineering - Electronics & Telecommunication
Sant Gadge Baba Amravati University
01.2014 - 12.2014
Similar Profiles
Rosy UpadhyayRosy Upadhyay
SENIOR IT COMPLIANCE ANALYST at CitcoSENIOR IT COMPLIANCE ANALYST at Citco
Ben McMackinBen McMackin
Legal Officer at CitcoLegal Officer at Citco
Ravi Teja ReddyRavi Teja Reddy
Senior Fund Accountant at CITCOSenior Fund Accountant at CITCO