Jayanthinathan Mohanrajan
Senior Consultant - Data Analysis
Chennai
Summary
Data Analyst Consultant with around 9+ years of experience in data and analytics space. Proficient in data analysis and interpretation with excellent skills in Data Visualization, Data Modelling, Data Integration, SQL, and Python. Seeking a position in Information Architect space to utilize expertise and contribute to the success of a dynamic team.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Senior Consultant - Data Analyst
AstraZeneca
Chennai
07.2020 - Current
- Stack Used: SQL, Python, Power BI, ER Studio Data Architect, AWS Redshift, Collibra
- Projects: Fx (Foreign Exchange) Forecasting, Workforce Planning and Reporting, Manufacturing Accounting, Alexion Integration, HR Data Products Cataloguing
- Extensively involved in understanding business requirements and doing Data Analysis.
- Creating Data Profiling and Data Quality Checks for all Data that has been involved in projects.
- Involved in process of creating High Level Bus Matrix and contribution towards Low level Bus Matrix.
- Involved and contributed towards creation & updation of both Conceptual and Logical Data Models.
- Identified and documented detailed business rules and use cases based on requirements analysis via Source to Target Mapping documents.
- Involved in Cataloguing HR Data Products in Collibra.
- Involved in creation of Data Products and have good understanding on Data Mesh Architecture and FAIR Assessment Principles.
- Created end to end Reconciliation script in both SQL and Python for data reconciliation between systems.
- Involved in creation of Data Contract, which act as single source of truth for project level data.
- Created Dashboard in PowerBI for managing FAIR Data Products (Which will be used to track FAIR score at enterprise level)
- Created Dashboard for EIA to help Resource Management.
- Have done a POC using Apache Spark and deployed it on Azimuth for converting JSON files to CSV dynamically which will reduce the manual effort by 80%.
Program Analyst
Cognizant Technology Solutions
Chennai
10.2018 - 03.2020
- Stack Used: Informatica PWC, Informatica BDM, AWS Redshift and MS SQL Server
- Handled Analysis, Design, Development and Deployment of ETL pipeline using Informatica 10.2 and 10.1.
- Experience in sales prediction of company sales.
- Experience in developing mappings by decoding existing R-Code for data analytics.
- Experience Data Quality checks using BDS tool.
Software Engineer
Softura Pvt Ltd
Chennai
12.2015 - 10.2018
- Stack Used: Informatica PWC, MS SQL Server, SSRS and Angular
- Involved in ETL development & enhancement activities.
- Involved in developing required Reports in SSRS and deploying them into server.
- Involved in writing complex Stored procedures and Functions for Application.
- Involved in web development using dot net and Angular JS
Education
Bachelor of Engineering: Computer Science -
Anna University
Chennai 05.2011 - 05.2015
Skills
Data Anlaysis
SQL
Python
Data Modelling
Business Intelligence (PowerBI)
Data Integration (Informatica)
Time Series Forecasting
Certification
Python Programmer
Timeline
Python Programmer
06-2024
Senior Consultant - Data Analyst
AstraZeneca
07.2020 - Current
Informatica Cloud Specialist
03-2020
Program Analyst
Cognizant Technology Solutions
10.2018 - 03.2020
Software Engineer
Softura Pvt Ltd
12.2015 - 10.2018
Bachelor of Engineering: Computer Science -
Anna University
05.2011 - 05.2015
Similar Profiles
Jasmine JohnsJasmine Johns
Project Management Associate (Medical Affairs) at AstraZenecaProject Management Associate (Medical Affairs) at AstraZeneca
Courtlyn WheelerCourtlyn Wheeler
Pharmaceutical Sales Specialist at AstraZenecaPharmaceutical Sales Specialist at AstraZeneca
Meghna MehtaMeghna Mehta
Global Marketing Director, IO Lung at AstraZenecaGlobal Marketing Director, IO Lung at AstraZeneca