Being a part of the State Street Global Advisors team at TCS, I have developed domain expertise in data modeling, data visualization, reporting using SAS & SQL and data analysis using advanced MS Excel and Python. Working collaboratively with Portfolio Managers I have developed technical solutions to forecast the performance of funds and perform quantitative analysis on them.My responsibilities and accomplishments in this role include:- Enriched data quality of reports… Show more Being a part of the State Street Global Advisors team at TCS, I have developed domain expertise in data modeling, data visualization, reporting using SAS & SQL and data analysis using advanced MS Excel and Python. Working collaboratively with Portfolio Managers I have developed technical solutions to forecast the performance of funds and perform quantitative analysis on them.My responsibilities and accomplishments in this role include:- Enriched data quality of reports, re-engineered existing data marts consolidating data objects in single transactional view used as the data source - Presented critical insights to Investment managers, designing Dashboards with drill-down capabilities providing data breakout with different KPI measures - Strategy & Region - Developed Summary Reports aggregating data across different demographic factors like country, company & industry helping Asset Managers in the statistical analysis of funds & decision making - Designed SAS scripts to perform Data Ingestion by automatically fetching Daily FX Rates from Reuters FTP server & loading it to the database; utilized to analyze currency exposure of assets - Optimized performance of Real Estate Reports building our customized data-marts; modeling Efront Client Facing Raw data & saved ~ 18,000 USD - Worked closely with Financial Stakeholders to build standardized Investment Risk Models; identifying current & future trends; outlining guideline plan for investments - Streamlined Data Reconciliation & Validation process by consolidating raw data from multiple sources & modeling it to generate comparison reports; providing a solution for integrity & accuracy of daily cashflows Show less

As part of the Software Trainee program, I was trained for 5 programming languages - Shell Scripting, SQL, Java, JavaScript, HTML, and CSS. The program was meant to help me transition to the corporate world.My accomplishments include: - Developed an end - to - end web application using JDBC API, Java, SQL, HTML, and CSS. - Awarded ILP Kudos award - Recognized for outstanding performance in the training program.