Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Tools Used
Timeline
Generic

Jesan Rahaman

Bangalore

Summary

Over 10+ years of experience in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects on MSBI/PowerBI/Azure Data solutions. Hands on experience with Azure Data Factory, Power BI, Alteryx, Tableau Desktop, Tableau Reader and Tableau Server. Building up the automation pipeline for data flow from various sources Splunk, Hadoop to Oracle using Azure Data Factory. Hands on with building groups, hierarchies, parameters and sets to create detailed level summary reports and dashboards in PowerBI. Experience on Azure data Lake Storage, Azure SQL Database, Azure Databricks, Azure Logic Apps and Azure Data Factory using Azure Portal. Distributed Tableau reports using techniques like packaged workbooks, pdf, ppt slides through images, scheduled reports to authorized user community. Implemented Incremental loading in ADF pipelines for data ingested from various data sources like MS SQL ServerSQL Server, Splunk, Hadoop and Rest API’s.Rest API’s and Hadoop. Experience in extraction of data and setting up ETL processes from various sources (SQL servers, Hadoop – hive, Impala) and combining them for analysis into Tableau. Knowledge on labelling, annotations, data blending, data extract, publishing & re- using the data sources, quick filtering, applying filter and actions, setting up complex hierarchical structures, conditional formatting, grouping the rows and custom coding titles & captions. Design, develop ETL workflows and datasets in Alteryx (extensive use of macros and Alteryx gallery). High utilization of Alteryx gallery (schedule workflows) for end-to-end automation – from data gathering to data visualization. Used ACS (Alteryx connector for SAP) and salesforce connector extensively in Alteryx to extract data from SAP platform and put it in usable format for data analysis. Used SQL and SAS language for data extraction using In-DB tools and SAS sasb7dat archives.

Consultant with more than 9.7 years of cross-industrial experience in construction, engineering & healthcare. Highly experienced in design, development, implementation and maintenance of Business Intelligence apps. Experienced in data mining large data sets of structured and unstructured data, Data Acquisition, Data Modelling, Data Visualization and Enterprise Data Warehousing.

Overview

10
10
years of professional experience

Work History

Associate

JP Morgan Chase
09.2021 - Current
  • Involved in entire product lifecycle development from requirement gathering through implementation in production
  • Currently handling the entire BI process for Performance management under Life event operation, working as a SME for Currency Transaction Reporting
  • Developed and maintained end to end operations of ETL Data Pipelines, working with large datasets in ADF
  • Created Pipelines in Azure Data Factory using Linked Services/Datasets to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse
  • Lead the Alteryx Server Migration project and migrated 19+ jobs on Altery server with the team
  • Developed Views/Procedures as per requirement for Power BI Models
  • Worked on book of work related to action plans, ad-hoc reports, control reports and modification or break fixes required in Alteryx workflows/Tableau dashboards
  • Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time
  • Created multiple Power BI models and published to Web service for users to create report on top of the semantic models.

BI Consultant

Novo Nordisk India
07.2024 - 09.2021
  • Worked in the Financial Planning and Analytics Team
  • Projects include: Budget value stream - Tableau Dashboard, Anchor budget data pack- Tableau Dashboard, Finance data flow monitoring tool- Tableau Dashboard.

Business Analyst

TE Connectivity
03.2017 - 07.2019
  • Worked in the Supply Chain Analytics Team
  • Projects include: Inventory Management Tool- Tableau Dashboard, Plan Accuracy – Short term and Long Term- Tableau Dashboard.

Data Analyst

LG soft India Pvt Ltd
10.2013 - 03.2017
  • Worked in the Reporting Team
  • Projects include: Net Promoter Score- Tableau Dashboard, Wyrapp - Mobile app for line’s man - Retool App/MS Power App.

Education

B.Tech in Electronics and Instrumentation Engg -

SOA University

Skills

  • SQL and Databases
  • Business Intelligence Testing
  • SQL Database Management
  • Oracle Business Intelligence
  • Web-based reporting tools
  • Financial Data Analysis
  • Alteryx Platform
  • Project Management
  • Trend Data Analysis
  • Data Mining
  • Data Mapping
  • Data Acquisition
  • Power BI Tools
  • Data Warehousing
  • Data Mining Techniques
  • Data Compiling
  • Data Modeling
  • Regulatory Reporting Requirements
  • Business Requirements
  • Requirements Analysis
  • Data and Analytics
  • Model Development
  • Tableau
  • Database Management
  • Tableau Software

Accomplishments

  • Got featured in tableau community for creating and publishing a crisp and intuitive dashboard on Covid-19 pandemic.
  • Trained more than 80 analytics aspirants on use of data analytics using Tableau and Alteryx.
  • Successfully created mobile app for line engineers in TE connectivity
  • Designed and published one pager new letter for product supply

Tools Used

Power BI Desktop/Web, Tableau Desktop, Tableau Server, Reporting tools: Power BI, SAP BO, IBM Cognos, SAP Lumira, SSRS, ETL: Azure Data Factory, Alteryx designer 2019.2, Alteryx gallery, ACS connector, Salesforce connector, SSIS, Databases - Hadoop, MS SQL Server 2017, Oracle, SAP Hana, Languages: SQL, R/Python & SAS.

Timeline

BI Consultant

Novo Nordisk India
07.2024 - 09.2021

Associate

JP Morgan Chase
09.2021 - Current

Business Analyst

TE Connectivity
03.2017 - 07.2019

Data Analyst

LG soft India Pvt Ltd
10.2013 - 03.2017

B.Tech in Electronics and Instrumentation Engg -

SOA University
Jesan Rahaman