Ajay Durairajan
10 Years Of Professional Experience
Chennai
Summary
Senior Consultant , EY
Seeking a Architect position at an organization to implement and augment my knowledge, creative problem solving ability while being innovative and transforming all my abilities towards the delivery of outstanding performance and growing along with the organization.
Overview
12
12
years of professional experience
1
1
year of post-secondary education
3
3
Languages
Work History
Business Intelligence Architect
Tiger Analytics
02.2023 - Current
- Providing BI solution to HealthCare giant in US using BI tools such as Power BI and Tableau
- Leading the BI team of 5 people and guiding them on technical blockers and also connecting with client to understand the requirement
- Using Snowflake as the datasources developed more than 15 executive KPI dashboards which will provide summary to the C level people in the org
- Provide Out of the box solutions like generating metadata from Power BI reports , finding unused columns in the report which saves cost and effort for the clients
Senior Consultant
EY
3 2021 - 02.2023
- Lead a Visualization team and migrated over 80 Cognos reports to Power BI
- Created paginated reports from scratch and modeled the Power BI dataset as per the requirements
- Managed a team and delivered 40 plus Power BI reports from scratch
- Alerted the end users when the threshold has passed using Power Automate
- Expert in writing complex DAX formulas and was able to use it effectively which helped in the modelling
- Tuned the long running reports and brought down the size 4 times from its original size
- As part of L&D team took multiple sessions on Power BI and trained many people to become certified
- As part of COE team have developed multiple POC's on new features in the Visualization area
Business Intelligence Consultant
Cognizant Technology Solutions
06.2019 - 03.2021
- Primary role is to develop Power BI reports end to end and provide insights on the data to the stake holders from Accounts Department.
- Connect with clients from Accounts Department to understand the requirement and either pass it to Development team with BRD/FRD or develop end to end
- Migrated existing Qlikview and Cognos reports to Power BI
- Expert in writing DAX formulas and created various measures and columns
- Created Paginated reports from scratch
Manager
HDFC Ltd
07.2018 - 05.2019
- Identified number of cross sell products that are used by customers on weekly basis.
- Helped MD to identify how many Savings Account are sourced or has to be sourced for Current Accounts.
- Developed process that helps in focusing initial payment made by customers on their accounts.
- Extensively worked in SQL server , SSIS and Power BI
Technology Analyst
Infosys Technology Limited
01.2018 - 07.2018
- Provided technical and functional recommendations based on project requirements.
- Worked with end users on understanding their functional issues and provided insights using Power BI
- Created Power BI reports from scratch as per the requirement
- Connected to sources like SQL , Excel , CSV in import mode
Business Intelligence Developer
Walkerscott Ltd
05.2017 - 01.2018
- New package creation, modifications and deployments in SSIS
- Building Multidimensional , Tabular models from scratch, Dynamic Role Creation, Deployments using SSAS
- Debugging Power BI issues with gateways, Configured both Personal and On-Premise Gateways
- Created Power BI reports from scratch
Senior Systems Engineer
Infosys Technology Limited
10.2012 - 04.2017
- Services Information Repository - Reports are developed in Dot net where Data Sources are metadata tables , PPE (SQL Job).
- Global Resource Management- Data source is obtained using informatica, stored in SQL server DB and Reported using Power BI.
- Bagged 2 awards for best performance during this tenure
Education
Post Graduate Certification - Business Intelligence And Business Analytics
Greatlakes Institute Of Management
Chennai 01.2016 - 01.2017
BE - E.C.E
Panimalar Engineering College
Chennai, TN Sep 2008 - 04.2012
Skills
SQL Server
SSAS
Power BI
Power BI Report Builder
Excel
ThoughtSpot
Python
Tableau
Snowflake-DBT
Tools Developed
Created a customized tool using WPF which will get Metadata from the below Visualization tools which in turn will be used for rationalization and migration
- Power BI
- Qlikview
- Tableau
- Cognos
External Certifications
- Power BI Data Associate (DA-100,PL-300)
- Power Platform Fundamentals (PL-900)
- ThoughtSpot Professional Certification
- ThoughtSpot Cloud Architect
- Data Visualization Bronze and Golde badges
Timeline
Business Intelligence Architect
Tiger Analytics
02.2023 - Current
Business Intelligence Consultant
Cognizant Technology Solutions
06.2019 - 03.2021
Manager
HDFC Ltd
07.2018 - 05.2019
Technology Analyst
Infosys Technology Limited
01.2018 - 07.2018
Business Intelligence Developer
Walkerscott Ltd
05.2017 - 01.2018
Post Graduate Certification - Business Intelligence And Business Analytics
Greatlakes Institute Of Management
01.2016 - 01.2017
Senior Systems Engineer
Infosys Technology Limited
10.2012 - 04.2017
Senior Consultant
EY
3 2021 - 02.2023
BE - E.C.E
Panimalar Engineering College
Sep 2008 - 04.2012