Jitendra Singh Shekhawat Email and Phone Number

Building Serverless Datalake and Visualization on 911 call data • Worked with client to understand the requirements and onboard them with various AWS and related Datalake services.• Built, Architected and designed real time serverless data pipelines on 911 data in AWS.• Designed and implemented various stages in pipelines: Ingestion, Transformation, Visualizations using AWS native and serverless components. • Wrote infrastructure as code using AWS CloudFormation.• Ingestion Layer: Built API Gateway and Lambda functions to get data from various source system and store raw data in s3 bucket• Transformation Layer: Built various lambda function to perform transformations (Flattening Json > Filtering Records > Mapping Column Names > Mapping Field Values) on incoming data, stored/ retrieved mapping from DynamoDB. • Datalake /Visualization Layer: Designed/implementated how data is stored in S3 Partitions, how it is retrieved using glue crawler/ catalog and Athena, secure data using IAM/Lake formation and built various QuickSight Dashboards. Predictive Analysis of 911 Call Data • Proposed client that predictive modeling can be done on Datalake to find patterns between crime types, location.• Analyzed and interpreted the raw data of 911 calls.• Performed additional Data Transformation, Data Validation, Predictive modeling, Data Visualization for discovering meaningful business insights• Built, deployed and tested predictive models in Amazon Sagemaker and Python.• Performed data cleaning and ensured data quality, consistency, integrity using Pandas, NumPy.• Used machine learning algorithms such as linear regression, multivariate regression, Random Forests, K-means, & KNN for data analysis• Used RMSE/MSE to evaluate different models performance• Performed analysis of crime types that are associated in different regions.

• Lead design, architecture of any new development, existing applications – continuous improvement and automation. Technical Lead for all client interactions.• Prepare and Ingest disparate datasets for analysis and building machine learning models.• Subject matter expertise for all issues/ad-hoc queries, peer-reviews, & cross-team/client interactions regarding existing processes/applications.• Perform ad-hoc complex statistical analysis on customer data.• Perform Proof-Of-Concept to explore new metrics from customer data using machine learning, learn and share knowledge on topics like big data/Hadoop - HDFS, and Map Reduce.

• Lead developer/SME built JAVA applications with Advance Java concepts like Servlets &JSP, performed data analysis, code & data migration, setting up standards and documentations for MPED application.• Analyzed, developed, tested and managed different modules for the complete working of Madhya Pradesh Excise Department.• Providing enhancements to existing applications.• Lead a new team simultaneously providing KT to get everyone up to speed.• Gained Domain knowledge which in turn helped in providing multiple enhancements, bug fixes to all the existing applications.Tools Used: Java, SQL, Oracle 10.0

• Performed Google and Bing Analytics for PPC campaigns.• Performed Off Page SEO Techniques like Citation, Bookmarking, Directory Submissions, etc.• Worked on Web Technologies like Html, CSS, JavaScript, SQL• Individual Contributor with little to no-mentoring, internal awards. Successfully built and ran multiple PPC campaignsTools Used: Web Technologies like Html, CSS, JavaScript, SQL