S&P Global – Data specialist (Jan 2023 - Present)

•         Developed and Maintained Financial Data Validation Scripts: Created and maintained Python scripts to validate and analyze financial data, ensuring compliance with financial reporting standards.

•         Acted as primary technical point of contact (POC) for python initiatives, guiding developers on implementation standards, review logic, resolving technical blockers, and ensuring alignment with business requirement.

•         Utilized data parsing techniques to convert JSON data into Pandas DataFrames for efficient data manipulation and analysis.

•         Implemented error handling mechanisms using try-except blocks to manage exceptions and ensure smooth execution of data processing tasks.

•         Developed custom checks for financial metrics such as Average Shares, Total Liabilities, and Net Income, ensuring data integrity and consistency across reporting periods.

•         Enhanced Data Comparison and Reporting: Designed functions to compare current and historical financial data, identifying discrepancies and ensuring accurate financial reporting.

•         Employed advanced logic to determine prior fiscal periods for accurate historical comparisons.

•         Generated detailed error reports highlighting discrepancies in financial data, including mismatched values and missing mappings.

•         Automated Financial Data Checks: Automated the process of checking for misspelled words in financial reports and ensuring that key financial metrics are consistently reported.

•         Integrated spell check functionality to identify and correct misspelled words in financial data entries.

Key Technologies: Python, Pandas, JSON, Data Analysis, Financial Reporting, Error Handling, Data Validation.

S&P CAPITAL IQ (INDIA) PRIVATE LIMITED – Lead Data Analyst (Feb 2015 - Dec 2022)

•         Experience in Fundamental Analysis, Financial Research and Balance Sheet and Income Statement, Cash Flow analysis.

•         Collection, Standardization, and validation of corporate annual, semi-annual, or quarterly financial data from companies’ published reports.

•         Delivered on predefined individual and team targets including delivering outcomes with quality and excellence.

•         worked within defined parameters and with supervision to ensure quality and performance to set standards.

•         Keeps up to date in knowledge of content sets. Builds industry knowledge by understanding industry trends and reporting standards.

•         Provides input and ideas for new collection methods and product enhancements related to the covered content sets. Troubleshoots problems or issues and provide support to the team.

•         Processing of various Securities Exchange Filings which includes the Annual (10-K), Interims (10-Q), 20-F, 40-F and Press Releases (8-K) Filings.

•         Content collection of financial statements of US Companies like Income Statement, Balance Sheet, Cash Flow Statement and Per Share Statements of the companies.

•         Analysis of Extraordinary items & their impact on the Earnings per Share.

•         Responsible for the interpretation, analysis and updating of financial related data on publicly traded companies from various sources.

•         Analyzing the financial statements and procure the information in the area of employee stock benefit schemes, stock options and warrants, repurchase schemes and assets under management.

•         Content collection of Asset under management data from various financial statements of Banks, Insurance, Brokerage and from other financial services companies.

•         Maintaining quality standards by providing necessary updates & contributing as a team member towards necessary enhancement in the process and tool.

•         Worked with cross functional teams to provide Root Cause Analysis to identify the solutions in problem area.