RUPESH CHAVAN

Project 6 - SAS Development / ETL/ Market Risk (Ratnakar Bank Limited, Airoli)

• Leading team of around 4-5 including support plus development.
• As per business requirement working on different change requests of SAS Market Risk & Credit Risk. It includes requirement discussion, development, comparing pre and post instvals values, creating documentation, performing UAT, deployment to production.
• Working on Performance Optimization of DDS jobs.

Project 7 - SAS Development Lead/ ETL/ Market Risk (IDFC First Bank)

• Leading SAS Development and Support Team
• Successful migration of SAS Staging, DDS, Market Risk solution from one server to another including more that 20+ reports
• To overcome from daily Manual activity of Admin Team to check server space, status, and mount point utilization limit. Written SAS code and shell script, which generates status of multiple servers and triggers mail.
• Managing team of more than 10 including support plus development.

Project 4 - SAS Visual Investigator (Qatar Financial Investigation Unit)

• Involved in BRD discussion with business team and worked on BRD document.
• Completed ETL with loading data form different database sources of ministry, provided exception report to user on SAS Viya reporting tool.
• Worked on loading external tables, creating internal tables, defining relationship, and creating traversal in VI platform as per requirement.
• Successfully created Prioritization Matrix logic which will apply different business rules on input data and assign priority and score for each alert, so user can priorities work for High/Medium/Low scored alert.
• With the help of Alert table enrichment column, made required fields available to business user on the alert grid.
• Created more than 10 reports using SAS Viya platform.

Project 5 - SAS Visual Investigator (First National Bank, South Africa)

• Part of business requirement discussion, development, and deployment.
• Created more than 15 workflows.
• Triggered mail to specific user group by calling SAS code in workflow.
• Using SAS Studio functionality in SAS VI generated excel report file after 3 levels of approval
• Created workflows with multiple levels of approvals.

Project 2 - SAS Anti Money Laundering (HDFC Bank)

• Involved in implementation of AML in international branch of HDFC bank (Hong Kong)
• Involved into ETL activity.
• Successfully moved Credit Card data/prep/scenario into existing AML India live project.
• Written SAS code, which access logs from Meta server and shows last login details for logged users on AML front-end (Application Security Standard).
• To extract AML security proof attachments written sas code, to extract attachments from content server.
• Worked on Alert generation and generating Customer Risk Profiling process.
• Generated ASST (Application Security Standard) Reports, includes login details, dormant users, manager details, roles and responsibility.
• Worked on defects raised by Bank, involved in meetings with Bank to provide permanent solutions.
• Used pass-through into SCD job to increase performance.
• Also, part of DR movement activity which scheduled quarterly.

Project 3 - SAS Market Risk and Potential Future Exposure (IDFC First Bank)

• This was support plus development project.
• Daily task is to monitor data and check daily logs, to perform this task written sas code which reads log and drops mail with not acceptable solutions error.
• Created 2-3 complex reports based on Market Risk, used final solutions instvals table as input (RBS Summary, RCA3 Summary).
• Written macro for FTP solution handle exceptions.

Project 1 - Tata DOCOMO (SAS Campaign Management System)

• Designing jobs, source to target table mapping, deployment, and scheduling of jobs.
• Using transformations Extract, SQL join, Append, Table Loader, User written transformation, Data Validation, Transpose, Control transformation.
• Good hand on PROC SQL and SQL PASS THROUGH for writing queries of ETL, joining tables, adhoc analysis, testing and validation of datasets.
• Writing MACROS and generalized code for implementing incremental jobs for adhoc and Daily/Monthly ETL processing.
• Using SAS DI STUDIO transformations for designing, testing, and implementing incremental jobs for smooth and efficient ETL operation.
• Successfully deliver MBO Benefit posting product through SAS.
• New Segmentation logic built as per business requirement successfully. (Helpful for identifying view of any customer in one view)
• Created custom transformations, Parameterized job, Run jobs in parallel.
• Getting Data from Data source (Oracle) using libname as well as pass through method, to create SAS Datasets.
• As a Programmer involved in using SAS auto call Library, Macros, and Proc SQL.
• Created Information maps and Web reports as per business requirement.
• Created SAS stored processes deployed them on metadata and included them in SAS web report studio.