Adesh Bora

About Adesh Bora

Data Engineering, GenAi & Business Intelligence Manager with 10+ years of experience harnessing the power of massive data volumes to drive impactful business decisions at Amazon. Proven track record of leading high-performing teams, developing cutting-edge analytics solutions, and delivering actionable insights that optimize operations and propel strategic growth. Adept at navigating complex data landscapes across diverse business domains, including retail, finance. Expertise in building robust data pipelines, cutting-edge analytics solutions, and delivering measurable business impact-Skills : Data Ingestion: Sqoop Data Processing: PySpark, Spark SQL, Hadoop, MapReduce, Pig Programming Languages: SQL, Python, ScalaDatabases/DataWarehouses: Hive, Oracle, MySQL,Snowflake, Redshift, Athena, RDS Schedulers/Version Management: GIT, AirFlow Data Visualization: Tableau, Quiksight Cloud: AWS ETL & ELT: SSIS, Markit EDMMisc: Unix Shell Scripting, MSBI (SSAS, SSMS, SSRS), GitHub Actions-Rewards & Recognitions :** Successfully completed Lean Six Sigma Yellow Belt Certification to Improve Timely Delivery for WBRs. Using the ACES DMAIC (Define-Measure-Analyze-Improve-Control) approach, improved the WBR SLA met% from 62% to 95% in 2023. Also reduced manual efforts involved in on call by 540 hrs pa.** Awarded with Amazon Rookie Award.** Awarded as Star of the Quarter, Star of the Month for designing and developing end to end data pipelines that improved processing speed by 40%.** Awarded as TCS ILP Kudos, TCS on the Spot Award.

Experience

1. Data Engineering, Analytics & Gen Ai

   Amazon

   Jul 2023 — Present · Bengaluru, IN

   Engineered GenAI solutions with Amazon Bedrock to automate financial analytics, including creating a vector-based knowledge base and chat agents for data analysis and narrative generation. Streamlined BIE and DE workflows by developing GenAI-powered tools for automated BRD and architecture diagram creation, SQL generation, and code review and optimization. Led and empowered a high-performing team of 7 data professionals (5 Business Intelligence engineers, 2 Data engineers), driving successful project completion and achieving increased data processing efficiency by 20%. Accelerated sales and revenue by 30% for Amazon’s South Africa Launch through actionable financial reports, KPIs and interactive QuickSight dashboards. Collaborated with 35+ cross-functional stakeholders across Finance, Retail, Engineering, and Business domain. Achieved a remarkable 33% improvement in SLA met rate (from 62% to 95%) in 2023, while also reducing on-call burden by 540 hours annually. I was honored with a certification for excellence by the Amazon Finance VP for this impactful contribution. Revamped a scalable data architecture for reporting solutions, serving over global users. This included data warehouse layers, data pipelines, and interactive QuickSight dashboards, providing timely and actionable insights to diverse stakeholders. Spearheaded a data architecture redesign, consolidating existing pipelines (ETL/ELT) by 50%, resulting in a 20% improvement in Redshift efficiency and performance. Launched Operational Excellence initiatives, utilizing AWS CloudWatch to analyze Redshift performance, disk space, and CPU utilization week-over-week. Optimized long-running queries and vacuums, resulting in a 25% improvement in cluster performance and reduced Redshift and AWS costs. Developed the Redshift performance monitoring dashboard, providing detailed insights for the Redshift cluster optimization.

Education

• JSPMs Jayawantrao Sawant College of Engineering, Handewadi Road, Hadapsar, Pune 28.

  Bachelor of Engineering (BE), Information Technology

  2008 — 2012

Skills

• Xml
• Java
• Oracle
• Data Mining
• Requirements Analysis
• Etl Testing
• Shell Scripting
• J2ee Application Development
• Data Migration
• Sql
• Unix
• Microsoft Office
• Extract, Transform, Load (Etl)
• Html
• Data Analysis
• Data Warehousing
• Mysql
• Macro
• Core Java
• Pl/Sql
• Netezza
• C
• Cadis
• Servlets
• Aginity
• Etl Tools
• Javascript
• Markit Edm
• C++
• Jsp
• Software Development Life Cycle (Sdlc)