Rupesh Kumar

AWS Cloud migration project where we are building data lake for our enterprise business data, loading data in AWS S3 Bucket and then later used for Model Execution. Using AWS EMR cluster and AWS Athena to access the data for Business and data analytics. Design and implemented cross business (LOB) automated Model performance assessment (OPA) tool. This product managing all type of analytics, reporting, controls and governance using SAS codes and getting data from Teradata, Oracle, Hadoop and AWS Cloud.

• Maintaining robust data management platform to handle huge volume of data flowing from multiple source systems. • Use data and their analytical ability to find and interpret rich data sources, manage large amounts of data, merge data sources, ensure consistency of datasets, create visualizations to aid in understanding data and present and communicate the data insights/findings and produce and present results with dashboards

• SPOC for Risk & Client Analytics Application which was responsible of Enterprise Risk Model Creation and Evaluations. • Operational Reporting was done to make sure data is properly loaded for business ensure integrity of data is maintained • Ensure Run Book is properly maintained with all Operational Scenarios to ensure Knowledge management is maintained • Operational Risk in monthly management calls were highlighted to ensure there are minimum or no Manual Tasks in BAU environment

• The Reporting Technology underline used was SAS/BASE and MACROS and Teradata. • Built multiple direct marketing campaigns for multiple lines of businesses (Deposits and Small Business) and various adhoc data mining requests for business partners. • Custom data mart was also built for different line of businesses for suppressions while targeting right channel campaigns and automate their processes through SAS and Unix Shell Scripting.

• Responsible for Migration of Genesis System (Global Media Audit ) from Mainframe Technology to Java and SAS. It was Phased Migration Initiating from Denmark, Sweden, Holland, France, UK to Spain. This system later expanded to the whole of Europe • Involved in extracting, analyzing and auditing marketing data from the data-warehouse using SAS. • Developed Extraction Routines for raw data and Built Analytical Datasets.

• Design, Data Loading Development and Testing Pfizer Reporting System. • Extraction of raw data and construction of Analysis Datasets. • Extensive contribution in Report generation and writing QC macros. • Documentation of QA (Quality Assurance) processes. • Writing a generalized data checks Macro code in SAS for finding the data issue in raw datasets. • Involved in System Integration Testing and User Acceptance Testing.

Computer Science

Mathematics and Physics