Shubham Mandlekar
Skill Score
Rookie (2/6)
150
Industries
Finance Tech Professional and Business Services
Contact
Cloud Data Engineer | Banking and Insurance Services | Big Data and Cloud | Visual Storyteller

• Skilled, resolute & dynamic data engineer with close to 4 years of experience in big data, ETL & reporting with a demonstrated history of working in the banking and insurance services
• Extensive knowledge in Spark, Hive, Hbase, Python, SQL (Snowflake), AWS, Tableau, Excel & DWH concepts
• Fluent in communicating functional and technical information for effortless business decision making.
• Experience working in Agile framework (Scrum & Kanban) by participating in all ceremonies in scrum cycle.
• Strong engineering professional with a Masters degree in Management Information Systems from University at Buffalo, SUNY.

Skills
Evaluated for Product Manager and Data and AI PM role archetype
Performance by Category
Communication
0%
Strategy
0%
Design
0%
Technology
0%
Execution
0%
Go-to-market
0%
Performance by Skill
Skill Progression
Experience

Cloud Data Engineer

• Conceptualized, designed and developed a robust ETL pipeline for ingesting and publishing terabytes of data daily
across variety of data platforms with big data and DWH on cloud increasing agility, elasticity and data processing.
• Collaborated with Product Owner, Business Owner, development and testing team for analyzing requirements,
designing and developing pipelines along with creating meaningful dashboards for the users.
• Developed an in-house data testing tool in PySpark to reconcile, validate and provide logs via email after each stage in
the data pipeline reducing development and testing time along with monitoring efforts by 70%.
• Built XML shredding tool in PySpark to convert XML into Avro for consumption and analysis using EMR and S3 as POC.
• Performance analysis and fixing issues for Spark jobs to optimize execution time and reduce cost of resources.

Data Analyst

• Performed ETL operations on customer data for executing marketing campaigns to drive customer acquisitions, engagement and management using SQL, python and cloud services.
• Engaged with Intent owners and product managers to understand business intent for incoming marketing campaigns to create BRD and Approval documents to establish groundwork and initiate technical duties.
• Modernized the execution of campaigns designed for leadership team for technology, optimization and cost savings standpoint using SQL, python, Snowflake, AWS database services and Tableau.
• Interfaced with fulfillment team, tech team and digital infrastructure team to identify the appropriate channel of communication for each campaign and handed off campaign data in the respective format.

Masters Student

BUSINESS ANALYSIS USING KINESIS AND ELASTICSEARCH SERVICE HOSTED ON AWS
Built an end-to-end log analytics solution to ingest, process & load FIFA 19 data using Logstash and Elasticsearch.
Aggregated the indexed data and visualized it in Kibana based on business need using Dashboards and Canvas.

COMPREHENSIVE LOG ANALYTICS WITH APACHE SPARK USING PYTHON
Ingested & loaded sample NASA log dataset using pyspark; parsed & extracted information using regular expressions.
Analyzed & visualized the wrangled data to capture insights on log stats, status & hosts to improve server.

E-COMMERCE DATABASE MANAGEMENT SYSTEM (DBMS)
Physicalized conceptual, logical & physical data models in Redshift and provided a User Interface.
Divided the system into sections and created backups in different regions thereby creating a fault-tolerant system.

DATA VISUALIZATION REPORT ON BUREAU OF LABOR STATISTICS(BLS) DATA USING TABLEAU
Prepared meaningful datasets by cleaning & refining data based on business understanding.
Analyzed data based on major parameters to create meaningful & insightful visualizations.

SYSTEM ANALYSIS DESIGN OF GREEN COMMUTE DIGITAL DASHBOARD SYSTEM
Gathered business requirements & user expectations to develop Business Process models (Activity, Sequence & Use Case Diagrams) using Visio & UML to articulate clear business requirements.
Followed Agile (Scrum) & SDLC to elicit & document FRD, PRD, process flow diagrams & business cases for the system.

BUSINESS PLAN ON ENERGIZE ELECTRIC VEHICLES (EV) CHARGING STATIONS
Created strategy document for business case, market needs, customer analysis, market strategy & competitors.
Worked on Product Release Roadmap documentation consisting beta, launch, marketing and end-of-line plan.
Prepared wireframes, interactive mockups and prototypes to validate & capture all user functionalities.

Data Developer

• Established an enterprise-level data model which minimized inter-dependencies between 15 different sources for faster generation of BI weekly reports, and thus reduced latency by half.
• Designed business required logical and physical data models for 8 different projects in ER Studio and Teradata and applied ETL through Teradata Utilities.
• Created and presented comprehensive documentation (mapping sheets, data models and implementation plan) for 5 projects, thus tracked events and facilitated effortless knowledge transfer to other employees.
• Incorporated performance tuning of SQL queries compliant with data warehouse architecture and hence upgraded performance by 20% and reduced live maintenance checks to minimum.
• Initiated meetings with Solution Architects and Directors to obtain Barclays UK management level approval for Implementation Plan in order to deploy and guarantee timely delivery of project.
• Drove and Accomplished tables compliant with standards, proper data loading, accurate testing and live implementation for reports to showcase required data to stakeholders throughout the project life cycle.
• Performed data profiling for various projects to assess business requirements provided, and conducted meetings to finalize requirements for data modeling and quantify the task of completing the project.
• Developed Data Lineage to help identify flow of data, transformations and track errors to the root.
• Delivered projects by following Agile and Scrum methodologies.

Project Internship

Under the guidance of Mr. Shekhar Malani, my project partners and I worked on a major project in final year. We got the opportunity to understand the basics and get practical knowledge in automotive electronics.

Degree Programs

Master of Science – MS, Management Information Systems, General

Bachelor of Engineering (BE), Electronics and telecommunication

Licenses and Certifications

No Licenses or Certifications Found.