Abhishek Shelke

Project 1: Data Integration & Power BI reporting

Technology: AWS Glue, Amazon Redshift, AWS S3, AWS Step function, AWS Lambda

• Data Integration: Acquiring data from four distinct sources, namely Lego, SAP, Webportal, and Snowflake.
• Data Mapping: Developed a document outlining the mappings from source systems to target systems, ensuring data consistency and accuracy during the integration process.
• ETL: Implemented a PySpark job to extract data from AWS S3, transform it as necessary, and load it into the staging layer of Amazon Redshift.
• Data Warehousing: Constructed stored procedure jobs to move data from the staging layer of Amazon Redshift to the data warehouse layer.
• Reporting and Analytics: Developed materialized views tailored for Power BI dashboards, providing efficient and optimized data structures for quick and effective data visualization and analysis.

Project 2: Churn Prediction Model

Technology: Azure Databricks, PySpark, SQL

• Analyse the data, search for keys to join the different tables.
• Create the materialized views and use them in initial datasets.
• Prepare initial datasets using raw data transforming to meaningful features for training machine learning models from different table joins.
• Derive new features weekly monthly as per ML team requirements.
• Prepare final datasets for the Churn prediction model.

Project 1: Data Analytics for Travel Domain

Technology: AWS Glue, Lambda, S3, Athena, MongoDB

• Using files stored in S3 as a source to transform the data.
• Validating file and data quality using the configurations stored in MongoDB
• Monitoring the process status, logs, errors and performance using CloudWatch
• Performing different transformations on data according to the business rules by using Lambda/Glue and pushing them to the target.
• Writing and altering the processing scripts in Pyspark and Python as per business requirements.
• Worked on different POC reporting back to the team with Presentation.

Technology: Staad Pro, AutoCAD

• Creating structural model of a building house in StaadPro, apply loading as per ISI Codes.
• Analysis and design of structural members.
• Preparing AutoCAD drawing.
• Periodic Construction site visits.

• Structural design and analysis of various residential, commercial building.
• Assisted in developing comprehensive AutoCAD drawings for various residential, commercial projects, ensuring accuracy and clarity.
• Modeling of Structures in STAAD PRO, apply loading as per Indian Standard Codes.
• Periodic Site Visits and Inspection of Water Tanks, Residential and Commercial projects.
• Coordination with Architect & Client.
• Proof Checking of Design Calculations.

• Conducting Structural Audit of Residential buildings with visual inspection, non-destructive testing, and analysis of the building's condition.
• Preparing Structural Audit report indicating testing results, assessment of the building's condition, highlighting any major issues and final remarks on whether the structure is safe for occupation and any actions needed to ensure safety and longevity..
• Preparing AutoCAD drawing.