Praveen P.

● Actively participated in credit modelling CMBS deals (securitization and surveillance) by providing thorough loan pool analysis and due diligence. ● Automated sections of presale reports, data retrieval, and verification of trend watch reports through VBA and SQL, eliminating human error and minimizing report writing time by 60%. ● Fetched and analyzed loan data (vintages since 1993) from Trepp and internal databases to support research publications; Built tools to create a database of internal data and acted as a liaison between business and IT for new product development.

● Automated web scraping of publication details of 800+ researchers through R and VBA programming and built a database to perform research effectiveness analytics. ● Performed data cleaning, merging and transformations to make the collected data more usable.

● Programmed VBA macros to standardize monthly performance reports at project level reducing the compilation time from 3 days to 2 hours. ● Implemented Business Intelligence reports in Spotfire to pinpoint clients and business units that are responsible for increase in the cash collection period by creating a mini data mart and providing customization to view dashboards at 16 different classification levels. ● Implemented Business Intelligence dashboards in Spotfire using HTML, CSS, Iron Python and R for accounts receivables, order-to-cash revenue recognition and labor metrics, providing customization and effectively reducing the analysis time by 50% for internal finance teams. ● Led Spotfire training sessions; Acted as a business partner to IT teams on translating KPI related analytical requests into detailed data warehouse requirements; Analyzed and provided directions to transition existing BO reports to Spotfire and OBIEE.

● Assist students learn concepts of accounting

● Evaluated and developed undergraduate students in terms of competencies relevant to global leadership effectiveness. ● Analyzed and graded participants on written exercises, group discussions, role plays and psychometric assessments to address specific competencies.

● Identified a defect in interstitial ads on Android 2.3 user base (8% of entire customers) and persuaded cross functional teams to fix the issue. ● Reduced third party integration testing time from 7 to 3 days per release cycle after researching, designing and developing automation scripts for Android and iOS platforms.

● Initiated and developed automated testing for 5 different projects collaborating with stakeholders from New York, London, Denver, Gurgaon and Hyderabad, effectively saving $85k per year previously spent on manual testing efforts across various product lines. ● Convinced the management and introduced a new tool to detect the root cause of performance issues of S&P website in Japan when an administrative action was about to be taken by the Japanese Regulatory Board. The diagnosis helped improve the speed of the website by 300%. ● Designed and developed innovative automation solutions using .NET and OS Related tools to test a Microsoft installer, and thereby eliminated the repetitive manual efforts of testing on 24 different configurations, saving $7.5k per 2-month release cycle. ● Was the youngest and the only one from Hyderabad team to be chosen for brainstorming and decision making in the collaborative implementation of Unified Automation Framework. ● Led and represented the 15-member Hyderabad team during the development of Unified Automation Framework to come up with a standardized test automation framework across 6 cross functional, geographically dispersed teams of the organization. ● Implemented a HTML result reporting system that has minimized the result analysis time by 60%. The same system is later adopted by other teams in US and London. ● Was the first one to be chosen to supervise an intern just after completing a year in the organization. Trained and led a batch of 5 new joinees on automation testing and the processes followed in the organization.

● Carried out feasibility study, prepared requirements traceability matrices and designed a strategic test plan to implement test automation of an internal workflow tool by identifying the areas of reusability. ● Led walkthroughs with assorted project stakeholders to set expectations and milestones for the automation of testing process. ● Evaluated and identified a code coverage tool that has improved the testing coverage from 76% to 93% while testing the internal applications, and persuaded the management successfully to adopt the same. ● Reduced the testing time of an internal tracker application from 15 hours to 4 hours by automating the tests and enhancing the existing test automation framework, and held full responsibility for the defects and issues concerning the same.

Candidate for Master of Business Administration degree