Badges
Certifications
Work Experience
Lead Data Analyst Operations
S& P Global•  April 2017 - Present•  Hyderabad
Collecting Ownership data from various sources like 13F, Fund portfolio, and stakes through secondary research. Formatting with advanced excel options to transform data for acceptable format. Responding to external client inquiries regarding the Ownership data. Utilizing Power BI advanced analytical tools of calculations, parameters, background images, maps, trend lines, groups, hierarchies, detail-level summary report sets, and KPI dashboards to communicate effectively across multiple departments by performing various QA tasks and evaluating workflow. Developed and reviewed SQL queries with the use of join clauses (inner, left, and right) to validate static and dynamic data for the best solution to client queries. Integration of Securities Data provided by different vendors into the database by providing linkages for the Security Identifiers (ISIN, CUSIP, SEDOL, and Ticker) with internal Identifiers. Validating and executing a wide variety of Corporate Actions such as M&A, takeovers, dividends, spin-offs, stock splits, rights issues, reverse-merger, symbol changes, name changes, and pricing data. Maintaining Index Constituent’s data, rebalancing them as per the changes notified by the vendor, and addressing the Client queries. Analyzing client data reports through specific tools such as Bloomberg terminals and IDC feeds.
Education
VJIM Bachupally, Hyderabad
PGDM in Finance and Analytics•  April 2015 - March 2017•  CGPA: 8.03
Calicut University, S.N.G.S. Pattambi
B.B.A in Finance•  June 2011 - May 2014•  Percentage: 85