Summary
Overview
Work History
Education
Skills
Accomplishments
Websites
Languages
Projects
Disclaimer
Timeline
Generic

BISWA RANJAN MAHAPATRO

Bengaluru

Summary

Dedicated and accomplished Senior Technical Specialist with over 14 years of experience in Software Industry. Proven track record of delivering high-quality technical solutions and driving project success. Seeking to leverage expertise in Business Intelligence, Data Analytics, Data Engineering and Data Warehousing to contribute effectively to the organization.

Overview

15
15
years of professional experience

Work History

Senior Technical Specialist

Sony
10.2021 - Current
  • Sony offered job as its employee due to quality and efficiency of work while serving Sony as client from previous organization.
  • Took complete responsibility of Global Power BI Support group to troubleshot issues of all Power BI Developers and users across all region of Sony.
  • Defined enterprise processes and best practices and tailored enterprise processes for applications.
  • Improved systems with addition of new features and infrastructure.

Technical Specialist

UST Global
08.2019 - 10.2021
  • Demonstrated strong organizational and time management skills while managing multiple projects.
  • Worked effectively in fast-paced environments.
  • Skilled at working independently and collaboratively in team environment.
  • Monitored and tested application performance to identify potential bottlenecks, develop solutions and collaborate with developers on solution implementation.

IT Engineer II

HP Inc
09.2015 - 08.2019
  • HP offered job as its employee due to quality and efficiency of work while serving HP as client from previous organization.
  • Participated in system development life cycle from requirements analysis through system implementation.
  • Produced reports on success rates and remedial requirements.
  • Developed solutions to Identify and correct system faults to minimize operational system downtime.

Senior Software Engineer

KPIT
01.2012 - 09.2015
  • Designed and implemented new Reporting solutions for Supply Chain, Manufacturing, Sales and Marketing operations.
  • Delivered unit-tested systems within customer-prescribed timeframes.
  • Collaborated with management, internal and development partners regarding software application design status and project progress.
  • Tested and deployed scalable and highly available software products.

Software Engineer

Acliv
02.2011 - 01.2012

IT Engineer

WTI
10.2009 - 12.2010

Education

B Tech - Information Technology

National Institute of Science & Technology
Berhampur, Odisha
08.2008

Skills

  • Microsoft Power BI
  • Microsoft SQL Server/Azure SQL
  • SQL/T-SQL
  • Azure Databricks
  • ADLS Data Lake/ADLS Gen2
  • Amazon Redshift
  • MSBI
  • Tableau
  • CDP Treasure Data
  • Azure Data Factory
  • Azure Synapse Analytics

Accomplishments

  • Microsoft Certified: Power BI Data Analyst Associate
  • Microsoft Certified: Azure Data Engineer Associate
  • Microsoft Certified: Azure Data Fundamentals
  • Microsoft Certified: Azure Fundamentals
  • Awarded Most Valuable Employee of the Quarter for FY23 Q4

Languages

English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)

Projects

Project #1: Global Customer Data Platform Reports

It collects and   unifies first-party customer data from multiple sources to build a single,   coherent, complete view of each customer and then makes that data available   to marketers to create targeted and personalized marketing campaigns.

Technology.

Team Size: 14 Members

Role: Architect, Technical Lead, Developer

Technology: 

  • Power BI for Data Modelling and Report Development
  • Azure Databricks for performing Data Engineering operations
  • Azure Data Lake for Storage of Data from multiple sources
  • Treasure Data for Unification of Customer Data



Project #2: SEAP MARCOM Reports

Analyze messages and media that marketers use to communicate with target markets and help   marketers better understand their audiences so they can target ads more   effectively.

Technology

Team Size: 14 Members

Role: Architect, Technical Lead, Developer

Technology: 

  • Power BI for Data Modelling and Report Development
  • Azure Databricks, Power Automate for performing Data Engineering operations
  • Azure Data Lake for Storage of Data from multiple sources
  • Adobe Analytics for collection of Site Visits data


Project #3: SOMEA Data Platform Reports Analyze the   actual sales data by different regions, product groups and time frames and   compare them against the budgeted and forecasted sales amount and quantity to   derive important business metrics, such as marketing attribution, ROI, and   overall sales and marketing effectiveness. Team Size: 14 Members

Role: Architect, Technical Lead, Developer

Technology: 

  • Power BI, BI Excel for Data Modelling and Report Development
  • Azure Databricks, SSIS for performing Data Engineering operations
  • SQL Server for Storage of Customer Data from multiple sources


Project #4: Data Visualization Global Platform Support

This is a   Global BI Platform to provide assistance on all Power BI related queries to   different types of Power BI consumers such as Power BI Developers, Business   Analysts and all end users who build/view Power BI Reports

Team Size: 5 Members

Role: BI Specialist, Technical Lead, Developer

Technology: 

  • Power BI
  • Tableau


Project #5: SEU SMART Reports

Reporting Suite for Sony Europe Business to understand the Sales and Marketing level actual   and planned investments for the ongoing period and journal postings for the future.

Team Size: 5 Members

Role: BI Specialist, Technical Lead, Developer

Technology: 

  • Power BI, BI Excel for Data Modelling and Report Development
  • Informatica Cloud for performing Data Engineering operations
  • Amazon Redshift for Data Warehousing
  • AWS S3 for Data Storage

Disclaimer

I do hereby declare that the above particulars of facts and information stated are true, correct and complete to the best of my belief and knowledge.

Timeline

Senior Technical Specialist

Sony
10.2021 - Current

Technical Specialist

UST Global
08.2019 - 10.2021

IT Engineer II

HP Inc
09.2015 - 08.2019

Senior Software Engineer

KPIT
01.2012 - 09.2015

Software Engineer

Acliv
02.2011 - 01.2012

IT Engineer

WTI
10.2009 - 12.2010

B Tech - Information Technology

National Institute of Science & Technology
BISWA RANJAN MAHAPATRO