Rupesh Kumar Dwivedi

About Rupesh Kumar Dwivedi

AWS Cloud Certified •Significant experience in analytical roles (e.g. business analysis, data science, data analytics) •Experience developing production-level code in SAS & Python •Advance level SAS consultant which include Architecture Design and implementation for complex problem. •Experience in forecasting and drawing insights from data •Experience monitoring data quality, Data Architect, Process Engineering and building data validations. •Data Integration from multiple sources & Data Governance •SQL programming with the ability to perform effective and efficient querying involving multiple tables and subqueries •Experience working with and creating databases and visualizations in Tableau using all relevant data to inform decisions •Strong problem solving, quantitative and analytical abilities •Experience building and maintaining ETL pipelines •Experience in working within Agile methodology •Consulting, Business Analysis,Project Management, Business Communication and Business Transformation •Experience in developing end to end business intelligence solutions, including: data warehousing, Big Data Hadoop and business intelligence tools, techniques and technology. •Proven track record of exceeding stakeholders’ expectations for major engagements, throughout the system life cycle, from business process analysis, solution envisioning, requirements management to UAT & support stages •Extensive experience of working with clients across diverse geographies including the United Kingdom, United States, APAC and EMEA countries •Well versed in management and documentation of key artifacts including Product Requirement Document, Product Backlog, User Stories, User Journeys, Functional Specification Document and System Requirement Specification •Superb coaching and mentoring skills and able to motivate and lead others in a team environment •Hands on experience on Reporting & visualization tools like Excel & Tableau •SQL Skills: ability to prepare and execute moderately-complex SQL •Ability to interpret, analyze & understand complex data sets. •Process/Data Automation/Governance •SAS, SAS Viya, SQL, Python, Pyspark, Bigdata - Hadoop, Spark, Tableau, Teradata, Oracle, Advanced MS Excel, MS Word, MS PowerPoint, Macros, AWS Cloud, AWS Athena, AWS S3, Confluence, JIRA •German language Level A1 Certified.

Experience

1. Senior Associate Data Science & Analytics Ccb Risk at Jpmorgan Chase & Co

   JPMorganChase

   Oct 2018 — Present · Bengaluru, IN

   As Senior Analytics professional my roles are\\\\n\\\\n• Working in implementation of models in Common Model Deployment System (CMDS) and Real Time Model system using production data.\\\\n• Prior to implementation input/output variables validation and check for accurate data import and translation.\\\\n• Implementation of advance Statistical Data Quality (SDQ) rules with Population Stability Index (PSI) for model attributes/features for anomaly detection.\\\\n• 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 Model Execution.\\\\n• Using AWS EMR cluster and AWS Athena to access the data for Business and data analytics.\\\\n• Design and implemented cross business (LOB) automated Model performance assessment (OPA) tool with SAS/Tableau which saved $1 MM/year for JPMC. This full proof product managing all type of analytics, reporting, controls and governance using automated SAS codes and getting data from Terada, Oracle, Hadoop and AWS Cloud.\\\\n• Performing Exploratory Data Analysis (EDA) using Python.\\\\n \\\\n\\\\n \\\\n \\\\n\\\\n \\\\n

Education

• Savitribai Phule Pune University

  M.C.A, Computer Science

• Chatrapati Sahuji Maharaj Kanpur University, Kanpur

  Bachelor of Science - BSc, Mathematics & Physics