Rahul Kumar Gupta

 RESUME Rahul Kumar GuptaEmail:- - OBJECTIVE Seeking to leverage my technical and professional expertise to grow in the new role in your organization. Being a hard-working person nurture my skills and knowledge that would empower me to assimilate and exhibit them throughout my career. EXPERIENCE (4 years) Current Organization EXL Pvt. Ltd. Tenure: Aug’19- till date Previous Organization Deloitte & Touche (USI) Tenure: Sep’18- Feb’19 Prior Organization Accenture India Tenure: Mar’17- Sep’18 (19 Months) Designation Sr. Analyst Skills Model Validation/Model Development Excel/Advance excel. Good Knowledge of Base SAS, SAS/SQL and SAS Macro SAS enterprise tool PROJECT DETAILS (EXL Pvt. Ltd.) TEAM Duration Role Environment Citi Retail Scoring (Model Validation/) 18 months Sr. Analyst SAS EG, Tectia (Linux), Windows 10, Citrix Project Role (EXL) Key Responsibilities Part of a Banking Domain client where we do model validation using SAS to figure out if the model is stable and sustain in the environment. Day to day activity consists of preparing MIS and Decks for assigned portfolio. I also do score accuracy where we need to make sure that the model development results and model validation results 100% match and there is no miscalculation in the codes. We have predefined codes for several activities like preparing MIS and some adhoc related work but for new projects and challenges we do the digging and make sure we achieve client target. validates and strategize uses of scoring models and scoring model related policies. Provides analytical support on analysis and benchmarking. Some of the key metrices I work on are PSI, KS and ROB through which we come to conclusion every quarter if the model is stable or not. I have been a part of projects like New age metrices where we did analysis on Covid-19 (US region) and developed recovery analysis and tracking of COVID-19 impact on the banking clients. Prepares business as usual and ad-hoc reports in accordance with the CITI retail scoring team’s priorities and requirements, running Score accuracy checks on the reports and checking key numbers from other independently created reports. Participates in a project of constant improvement of risk analytics, modeling and validation systems and optimization of reports. Works on constant improvement of reporting system and optimization of Credit MIS Reports. Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency PROJECT DETAILS (Deloitte) TEAM Duration Role Environment Engagement Data Analytics(EDA) 6 months Advisory Analyst SAS EG 7.1, Optix, Windows 10 Project Role (Deloitte) Key Responsibilities Imports CSV, Excel, and other data formats into SAS EG Translates business rules or other specifications into programming logic Implements DQC processes to identify errors in coding and exports results to Excel templates. Creating new SAS programs, update previous ones and run existing programs Extensive use of advanced excel and Base SAS functions, Proc Summary, Proc sort, Proc Sql, infile, Proc export and Macro to perform queries Creating customized reports of data analysis results i.e. Reconciliation Report Performs database management, including complex mergers involving different units of analysis. Manipulates existing datasets and extracts summaries performed on the datasets Perform data preparation and Optix then upload it to Optix and make Work papers. Managing all the data to the server Manipulate Journal Entries (JE) and Trial Balance (TB) Raw data using Base SAS. Manipulate data using prewritten SAS codes for data preparation. Preparation of work papers/documentation for the client/auditors i.e. Reconciliation Report, EDA Scoping memo and Inputs/reference for future use Experience in Analysis of data at various levels for internal and external usage PROJECT DETAILS (Accenture) TEAM Client Duration Role Environment Business Reporting & Governance Analytics (BRG) Mondelez 1.5 year Measurement and Reporting Associate Windows 10, SAS EG, Citrix and SAS BI tool Project Role (Accenture) Key Responsibilities Extract raw data from SAP and Imports Excel, text and other data formats into SAS EG Prepare Reports based on the data to provide business solution Discover the performance of operation and generate reports on the SLA performance Updated and optimized pre-written SAS programs with proper documentation(SOP) to make it more understandable Prepare various reports like POT(Paid on time), P&B(Parked and Blocked), FPY(First Pass Yield) etc. with the help of advanced excel and SAS programs Prepare daily, weekly and monthly reports/deliverables using ODS/Excel, Pivot tables and Existing Dashboards Prepare Dashboards at the end of the Month to provide analysis of trend of business progress Provide adhoc requirements to client and operations Performs database management, including complex mergers involving different units of analysis Experience in Basic VBA Experience in extracting, manipulating data and creating data sets from various sources like Excel and flat files EDUCATION Year Degree/Certificate Institute Percentage 2016 BCA Amity University/ AIIT 73.9% 2012 Class XII (CBSE) G.B Pant Sarvodaya Bal Vidayalaya 68.4% 2010 Class X (CBSE) P D Model School 84% COMPUTER/ TECHNICAL SKILLS Software skills Programming skills SAS 9.2 and SAS Enterprise guide EG 7.1 Optix Excel, Advanced Excel, MS- Office and Outlook Windows, Unix and SAP SAS Base, SAS SQL and SAS Macro SQL, VBA ACADEMIC ACHIEVEMENTS Merit Scholarship achieved in First year during Graduation. Class representative during graduation. EXTRA-CURRICULAR Completed Military Training Camp in Manesar, Gurgaon Participated in Technical club Participated in Art and craft-received 1st prize Played Football in college team PERSONAL DETAILS Father's Name:Subodh Kumar Gupta Date of Birth:- Gender: Male Permanent Address: J-66 Saurabh Vihar Jaitpur Badarpur, New Delhi-110044 Contact No: - Language : Hindi, English, French