Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

Hello, I’m Mokirala Jyothi Rao, a data analytics professional with 6.9 years of experience in the US and Canada fixed income markets. I build data-driven solutions using SQL, Advanced Excel, and Power BI to extract insights, validate data, and generate client-ready reports. I also work with reference data, corporate actions, and complex financial instruments to ensure data integrity and informed decision-making.\n\nRecently I’ve expanded into Power Apps to automate internal data quality review processes and drive efficiency. I enjoy collaborating with operations teams to translate business needs into scalable applications and robust data workflows that shorten turnaround times and reduce manual effort.…Hello, I’m Mokirala Jyothi Rao, a data analytics professional with 6.9 years of experience in the US and Canada fixed income markets. I build data-driven solutions using SQL, Advanced Excel, and Power BI to extract insights, validate data, and generate client-ready reports. I also work with reference data, corporate actions, and complex financial instruments to ensure data integrity and informed decision-making.\n\nRecently I’ve expanded into Power Apps to automate internal data quality review processes and drive efficiency. I enjoy collaborating with operations teams to translate business needs into scalable applications and robust data workflows that shorten turnaround times and reduce manual effort.

Mokirala Jyothi Rao





Hello, I’m Mokirala Jyothi Rao, a data analytics professional with 6.9 years of experience in the US and Canada fixed income markets. I build data-driven solutions using SQL, Advanced Excel, and Power BI to extract insights, validate data, and generate client-ready reports. I also work with reference data, corporate actions, and complex financial instruments to ensure data integrity and informed decision-making.\n\nRecently I’ve expanded into Power Apps to automate internal data quality review processes and drive efficiency. I enjoy collaborating with operations teams to translate business needs into scalable applications and robust data workflows that shorten turnaround times and reduce manual effort.…Hello, I’m Mokirala Jyothi Rao, a data analytics professional with 6.9 years of experience in the US and Canada fixed income markets. I build data-driven solutions using SQL, Advanced Excel, and Power BI to extract insights, validate data, and generate client-ready reports. I also work with reference data, corporate actions, and complex financial instruments to ensure data integrity and informed decision-making.\n\nRecently I’ve expanded into Power Apps to automate internal data quality review processes and drive efficiency. I enjoy collaborating with operations teams to translate business needs into scalable applications and robust data workflows that shorten turnaround times and reduce manual effort.

Available to hire

Hello, I’m Mokirala Jyothi Rao, a data analytics professional with 6.9 years of experience in the US and Canada fixed income markets. I build data-driven solutions using SQL, Advanced Excel, and Power BI to extract insights, validate data, and generate client-ready reports. I also work with reference data, corporate actions, and complex financial instruments to ensure data integrity and informed decision-making.\n\nRecently I’ve expanded into Power Apps to automate internal data quality review processes and drive efficiency. I enjoy collaborating with operations teams to translate business needs into scalable applications and robust data workflows that shorten turnaround times and reduce manual effort.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Language

English

Fluent

Hindi

Fluent

Telugu

Fluent

Work Experience

Freelance Consultant (Power BI & Apps Development) at Genpact Private Limited

March 1, 2023 - October 1, 2025

Developed and deployed Power Apps solutions to automate internal data quality review processes, significantly reducing manual effort and improving turnaround time. Designed intuitive user interfaces for data submission and validation forms within the Power Apps environment. Collaborated with operations teams to gather requirements and translate business needs into functional, scalable Power Apps applications.

Data Researcher II (Data Analytics & Reference Data) at ICE India Private Limited (NYSE: ICE)

November 1, 2019 - March 1, 2023

Developed and executed complex SQL queries to extract, transform, and compile large datasets from the production database into data quality and client-facing reports. Identified, analyzed, and resolved critical data quality issues, implementing safeguards to maintain data integrity. Maintained reference data for complex fixed income securities, including Mortgage-backed, Asset-backed, Convertibles, and Callable/Exchangeable products. Worked on remediation projects for data expansion and ensured consistency in data quality by running and analysing Quality Check (QC) reports. Processed regulatory and offering documents (Final Official Statements, Prospectus, 6K, 8K) to ensure 100% data coverage at the security level.

Process Associate (Data Analytics & Quality Control) at Genpact India Private Limited

December 1, 2018 - November 1, 2019

Monitored and enhanced data quality within the legacy database used by major clients, adding analytical inputs as required. Utilized Advanced Excel for extensive data manipulation, validation, and creating comprehensive QC reports to prevent issues like data duplication or degradation. Identified and implemented process improvements by streamlining the sourcing of regulatory documents (8K, 6K, FWP) from EDGAR to ensure timely data updates. Sourced and analysed terms & conditions from vendor sources (Bloomberg, Reuters) to achieve 100% data coverage for convertible and preferred securities. Contributed towards meeting Turnaround Time (TAT) and improving team accuracy and productivity.

Power Apps Developer at Genpact Private Limited

March 1, 2023 - October 1, 2025

Data Researcher II (Data Analytics & Reference Data) at ICE India Private Limited (NYSE: ICE), Hyderabad

November 1, 2019 - March 1, 2023

Developed and executed complex SQL queries to extract, transform, and compile large datasets from the production database into meaningful data quality and client-facing reports. Identified, analyzed, and resolved critical data quality issues, implementing safeguards to maintain data integrity. Maintained reference data for complex fixed income securities (including MBS, ABS, convertibles) and supported remediation projects for data expansion to ensure 100% data coverage at the security level. Managed day-to-day client challenges through precise research and timely communications. Processed regulatory and offering documents (Final Official Statements, Prospectus, 6K, 8K) to ensure comprehensive data coverage.

Process Associate (Data Analytics & Quality Control) at Genpact India Private Limited, Hyderabad

December 1, 2018 - November 1, 2019

Monitored and enhanced data quality in the legacy database used by major clients, providing analytical input to improve data integrity. Utilized Advanced Excel for extensive data manipulation, validation, and QC reporting to prevent duplication and degradation. Identified and implemented process improvements by streamlining regulatory document sourcing (8K, 6K, FWP) from EDGAR and ensuring timely data updates. Sourced and analyzed terms from vendor data (Bloomberg, Reuters) to achieve 100% data coverage for convertible and preferred securities. Contributed to improvements in Turnaround Time (TAT) and team productivity.