Ajish Cherian Email & Phone Number

South San Francisco, California, Us

Seattle, Wa, Us

Seattle, Wa, Us

Cincinnati, Ohio, Us

Consulting for a Fortune 50 consumer goods company with Stock-Keeping Unit analysis using R and designing a logistic regression model to determine which brands should be discontinued with visualizations in TableauConsulting for an architecture firm with trend analysis of their successful projects and building a model that identifies highly profitable project proposals

Cincinnati, Ohio, Us

Assisting with under-graduate course “Business Analytics II” including Regression, Classification, Simulation and Optimization by delivering lectures, grading exams and maintaining office hours

New York, Ny, Us

Working in the Securities Cross-Reference R&D team developing reference data products pertaining to equity, debt, derivative and exotic financial instruments. Provide analytics support to the content research team and improved operational efficiency with Oracle & Microsoft SQL Servers, Advanced Excel, Access and VBA.Corporate Hierarchy Management- Developed an application that extracts unstructured corporate hierarchy data from sources like company filings at SEC website - Made the process 80% efficient and reduced the maintenance cycle enabling the team to keep much updated information in the system than before- Application was built with an inbuilt supervised learning mechanism learns from the manual changes made by the researchers and automates the steps on next similar instanceFinancial Pricing Analytics- In a bid to keep best pricing source from three different sources, mapped historical pricing information for complete equity listings- Historical pricing information for these securities constituted to more than 300GB of data and with the proposed mapping more than 70% of the manual load was automated- Project also included mapping dividend and stock split information also, and ensured that the final database consists of in-sync adjusted pricing information and such corporate actions Analytics Backing to Client Support Team- Provided analytics support to client support team ensuring that the high-priority projects get delivered as soon as possible- Support provided to product datasets such as GICRS, BECRS, Corporate Hierarchy, Index Pricing and Constituent Lists, Pricing and Corporate Actions

New York, Ny, Us

Financial Cross Reference Analytics- Developed web analytics portals that downloads and analyzes third party vendor FTP files with total size exceeding 100GB saving login cost by more than $0.3M- Framed foundation for S&P Global Feed Product - Global Instruments Cross Reference Services (GICRS) from the master database with more than 3M financial securities and 20M cross-reference identifiers- Enhanced automated security linking procedures by proposing better workflow/data ingestion plans (reduced manual work by 60 %)- Worked on various third-party data vendors such as SIX Telekurs, Bloomberg, Interactive Data Corp, Factset, CUSIP Bureau, Reuters, Exchange Data International, SNL Financial, QuantHouse, Xignite and many others. - Prepared flow charts and documentation of data architectures built over time by different technology teams for cross reference products by diving into complex codes. This enabled identification of various gaps and required logic enhancements that improved the firm's product offering.- Exposed to datasets of wide range of security types like Equity, Depositary Receipts, ETF/Mutual funds, Corporate Bond, Sovereign debt, Commercial Paper, Municipal Bonds, Equity rights/warrants and Structured Finance products like ABS, MBS, CLO, CMOs.Employees Reporting BI Application- Built a BI application equipped with inbuilt regression modelling for employees and managers to assess individual and team’s performance, and to provide much accurate ETA for upcoming projects or tasks at a very granular level- Developed application also contained a gamification module with which employees could challenge each other to perform better and win medals. This helped in introducing a fun element in everyday work together with bringing more transparency on individual’s and teams’ performance.- Application introduced automation for calculations on performance evaluation and assisted managers in understanding employee-wise as well as project-wise performance

New York, Ny, Us

Corporate Actions Content Analysis- Identifying world-wide corporate actions such as Mergers/Acquisitions, IPOs, Reverse Mergers, Bankruptcy among others, on the basis of price fluctuations and security status changes- Analyzing and adjusting securities information in Reverse Merger cases in the SP Global universe to ensure that client gets the transparent view of the transaction- Automating processes through VBA, Natural Language Processing, Software Robots, etc.- Analyzing effects of corporate actions on the daily pricing and stock sentiments.Index Price Maintenance- Ensuring precise index price calculations on the basis of constituent pricing- Tracking and analyzing constituents’ price fluctuations that could affect index pricing- Maintenance of dividends and stock splits information from around the globe so it reflects accurately onto the world equity indices- Created excel dashboards to assist researchers with calculations of adjusted pricing and index pricing taking daily equity pricing together with respective dividends and stock split

Mumbai, Maharastra, In

Analyzed financial and market sales data collected from primary and secondary sources to understand how middlemen work in pharmaceutical industry’s aluminum sheet deals. Findings from the report helped increase client base for the firm and reduce cost for small and medium pharmaceutical companies.

Bangalore, Karnataka, In

Master’S Degree, Business Analytics

B.Tech., Computer Science

Mba, Finance