Gopal Ramachandran

• Played a key role in optimizing our stored procedures for migration to a new front-end system which reduced the time taken by legal team members to access these reports by 80%. • Automated and scheduled the Reporting System using python to optimize operational efficiency and reduce operational costs by $100,000 a year • Played the role of a key point of contact in maintaining and updating the stored procedures to ensure that reporting keeps pace with the ever-changing immigration guidelines • Created and Maintained Dashboards in Power BI which assisted the managing Partners and equity partners of the firm take strategic decisions • Spearheaded the creation of company-wide data reconciliation reports to help isolate data issues for internal purposes • Peer-reviewed the codes of other analysts to ensure high standards of reporting and optimization

• Create, update and maintain reports as per the requests of business units using SQL and excel • Schedule and automate existing/new reports in PowerBI • Identify data analomies in reports and work with business units to rectify them. • Create Monthly business Review presentations of business unit for executive meetings. • Used R programming language to identify areas to improve on in terms of reducing customer complains. • Built a model using azure machine learning which would reduce the REO transaction losses by 7 %

* Worked for two clients - an e-commerce giant and a pharmaceutical giant * Tasked with a host of real life problems which utilized data mining and developing dashboards based on this to derive actionable insights. * Tools worked on include SAS , Tableau , Excel and VBA

A month long Industrial Training with Steel Authority Of India [SAIL] as part of the degree requirements