Suraj Rastogi Email and Phone Number

Portfolio Intelligence-Senior Business analyst • Produce consistent and ensure timely delivery of analytics support to minimize losses and maximize profits through Root Cause Analysis, Trend Analysis, and Account management analysis.• Construction of the monthly Credit card data infrastructure through Base SAS and SAS/SQL by blending multiple data warehouses.• Analysis on Bonus and rewards points based on the spending behavior of the cardholders.• Analysis of Transaction amount with alert amount to identify the relationship among them.• Analysis of the monthly Banking data to compute the monthly trends of their customer and business with different product offerings with multiple approaches.• Measuring the new accounts through trend analysis in terms of their performance and purchases.• Trouble shooting and Debugging various SAS complex codes and errors to ensure data availability.• Analysis of payments trends and customer behavior.• Automated the data reports prepared through TWS (Tivoli Scripts).• Engage in business initiatives to measure the impact of changes.• Coordinating with the offshore team and help to improve their strategies based on the day to day analysis.• Worked on credit card data to predict consumer attrition trends and behavior using logistic regression technique. SKILL USED: SAS EG 7.1, SQL, Excel

• Prepare reconciliations (primarily cash, accrual and prepaid accounts) on regular basis in sas, Excel and prepare detailed analysis on monthly basis.• Detailed analysis of various advisers in different BU’s.• Reporting on Daily and weekly basis for different advisers in Ameriprise.• Prepare analysis on charge backs and schedule database maintenance to cross check the data base accuracy.• Customer segmentation depending on various BU’s to cross /sell the different products