Pawan Kumar Dandotiya

Software Engineer

Bengaluru, Karnataka, India3 yrs 8 mos experience

Most Likely To SwitchAI Enabled

Key Highlights

Expert in backend development and ETL pipelines.
Improved sales skills for over 200 representatives using AI.
Designed responsive interfaces enhancing user experience.

Stackforce AI infers this person is a Backend-focused Software Engineer with expertise in ETL and data processing technologies.

Contact

Skills

Core Skills

EtlData ProcessingGenerative AiSales ImprovementData StreamingFrontend Development

Other Skills

Systems DesignSoftware DesignMEDDPICCCHAMPOHApache AirflowSQLJiraScalaRedshiftS3Apache SparkHTMLCSSReactJS

About

I am a Software Engineer specializing in backend development. My expertise lies in ETL pipelines and AWS services. I am currently working on the latest data technologies like Spark, Scala, etc. At Mindtickle, developed call insights using frameworks like MEDDPICC, CHAMP, and OH, improving sales skills for over 200 representatives and leveraging Generative AI to generate actionable insights, enhancing the overall user experience. At Bidgely Technologies I contributed to streamlining data processing through Redshift, implementing efficient ETL pipelines using Apache Spark, and optimizing workflows. As a Software Development Intern at Flyzy, I enhanced user experience through the design of responsive interfaces. I am proficient in languages such as C++, good in problem-solving, programming, and a range of technical tools and skills, including Git, AWS services, Airflow, Looker, Jira, DBever, Redshift, ETL, Spark, Scala, and SQL.

Experience

3 yrs 8 mos

Total Experience

1 yr 2 mos

Average Tenure

1 yr 6 mos

Current Experience

Slice

Software Engineer

Dec 2024 – Present · 1 yr 6 mos · Bengaluru, Karnataka, India · On-site

Mindtickle

Software Engineer

Apr 2024 – Nov 2024 · 7 mos · Pune, Maharashtra, India · On-site

𝟏. 𝐒𝐞𝐥𝐥𝐞𝐫 𝐈𝐧𝐭𝐞𝐥
Enhanced an existing feature to fetch data from a 𝑺𝑸𝑳 𝑫𝑩 𝒕𝒐 𝑺𝒏𝒐𝒘𝒇𝒍𝒂𝒌𝒆 using a batch job by implementing resiliency.
Configured a DAG on Apache Airflow to run it periodically and in custom time ranges streamlining data processing.
𝟐. 𝐀𝐥𝐞𝐫𝐭𝐬 𝐚𝐧𝐝 𝐌𝐨𝐧𝐢𝐭𝐨𝐫𝐢𝐧𝐠
Created custom metrics using 𝑪𝒍𝒐𝒖𝒅𝑾𝒂𝒕𝒄𝒉 logs and set up monitors on these metrics enhancing operational excellence.
Identified issues for many customers, present in the system for more than 3 months, using these monitors for proactive resolution.
𝟑. 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐢𝐧 𝐂𝐚𝐥𝐥 𝐀𝐈
Developed summary and action items on recorded calls, created table schema in a 𝒎𝒖𝒍𝒕𝒊-𝒕𝒆𝒏𝒂𝒏𝒕 𝑷𝒐𝒔𝒕𝒈𝒓𝒆𝑺𝑸𝑳 𝒂𝒓𝒄𝒉𝒊𝒕𝒆𝒄𝒕𝒖𝒓𝒆.
Created business events for generating action items, implemented middleware to send events to Snowflake for multi-product analytics.
Enhanced the email flow to include summaries and action items in Post Recorded Call Emails.
Took ownership of developing call insights using 𝑴𝑬𝑫𝑫𝑷𝑰𝑪𝑪, 𝑪𝑯𝑨𝑴𝑷, 𝒂𝒏𝒅 𝑶𝑯 𝒇𝒓𝒂𝒎𝒆𝒘𝒐𝒓𝒌𝒔, improving sales skills for over 200 reps.
Utilised 𝑮𝒆𝒏 𝑨𝑰, POC on multiple prompts to ensure efficiency in generating actionable insights and enhancing overall user experience.

Systems DesignSoftware DesignETLData Processing

Bidgely

Software Engineer

Jul 2022 – Feb 2024 · 1 yr 7 mos · Banglore

𝟏. 𝐃𝐚𝐭𝐚 𝐒𝐭𝐫𝐞𝐚𝐦𝐢𝐧𝐠 𝐭𝐨 𝐑𝐞𝐝𝐬𝐡𝐢𝐟𝐭
Contributed to backend development with a focus on streaming data to Redshift tables.
Developed a Scala service for transferring data from S3 to Redshift, achieving a 70% reduction in analysis time.
Audited and resolved streaming issues, leading to a 50% decrease in operational efforts.
𝟐. 𝐄𝐓𝐋 𝐏𝐢𝐩𝐞𝐥𝐢𝐧𝐞 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭 𝐚𝐧𝐝 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨𝐧
Designed and implemented ETL pipelines using Apache Spark for efficient data processing.
Optimized ETL processes, resulting in a 60% reduction in processing time.
𝟑. 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐢𝐨𝐧 𝐒𝐮𝐩𝐩𝐨𝐫𝐭
Actively participated in resolving production incidents, showcasing a strong commitment to daily operations.

SQLJiraETLData Streaming

Flyzy

SDE Intern

May 2020 – Jul 2020 · 2 mos · Remote

Designed and developed a responsive login screen using HTML, CSS, Flexbox, and Media Queries, enhancing device compatibility and user experience.
Created reusable components with 𝑹𝒆𝒂𝒄𝒕𝑱𝑺, 𝑴𝒂𝒕𝒆𝒓𝒊𝒂𝒍-𝑼𝑰, 𝒂𝒏𝒅 𝑪𝑺𝑺 to improve development efficiency and maintainability.
Achieved a 500% increase in customer reach by optimising the platform for a seamless experience across devices.