RAAGHUL RAJAN
SENIOR IT ANALYST
Chennai
Summary
Dynamic and organized Business Data Analyst with 4.5 of experience utilizing a variety of programs to generate data-driven insights and improve organizational processes. Expert in creating and optimizing databases, forecasting trends & patterns, as well as designing capability-driven data visualizations
Overview
6
6
years of professional experience
6
6
years of post-secondary education
Work History
Senior IT Analyst
Dahnay Logistics
1 2023 - Current
- Implemented Customized Power BI reports for Staffs in various departments resulting increase in data analysis efficiency
- Designed and implemented data models, resulting in improvement in report accuracy
- Designed and developed over 40 Power BI reports and dashboards using variety of data sources
- Ability to retrieve data from SQL server using SQL queries including filtering, sorting, and joining data
- Experience in data manipulation tasks such as updating existing records, inserting new records, and deleting unnecessary data
- Familiarity with SQL data manipulation language DML and DDL statements
- Proficiency in using SQL functions for data transforming and manipulation
- Understanding of SQL join types (eg.,INNER, JOIN, LEFT JOIN, RIGHT JOIN) and their appropriate usage
- Presented and communicated actionable insights in a way tailored to the specific staffs and business needs
- Connecting data sources, importing data, and transforming data for business intelligence
- Developing visual reports, KPI Scorecards and dashboards using Power BI tool
- Understand business requirements to set functional specifications for reporting applications
- Be experienced in tools and systems on power BI, Power Query and DAX code
- To create dashboards and visual interactive reports using Power BI, Identify KPI's with clear objectives and monitor them consistently
- To analyze data and present it through reports that can help in decision making.
IT Business Analyst
DHASH IT Solutions
07.2018 - 12.2021
- Study current ERP systems and applications developed by Dhash IT solutions
- Analysis on ERP systems being used in the current market
- Follow all project management framework standards, procedures and documentation
- Collaborate, Create and document future state business processes and workflows
- Works with project managers, establishes and manage the software development lifecycle (SDLC) for IT
- Assist in providing verification support during monthly production releases
- Provide clarifications on the requirements to developers and tester in Dhash IT solutions
- Follow all project management framework standards, procedures and documentation
- Monitor internal and client and use of available business tools for company policy compliance
- Monitor and report on client problems and issues
- Performing end to end testing and providing signoff
- Manage development and execution of test plans and defect tracking for large scale projects
- Develop plans for project tasks, including scheduling and coordinating activities of other team members to produce deliverables
- Prepare help guides for newly introduced features.
Education
MBA -
Dr. G.R.Damodaran College of Science
05.2015 - 05.2017
Post Graduate Diploma in Entrepreneurship Development - undefined
Dr. G.R.Damodaran college of science
09.2015 - 05.2017
Bachelor of Computer Applications - undefined
Dr. G.R.Damodaran college of science
08.2011 - 05.2014
Skills
Report Tool: Power BI
Project management tools: MS Office, Jira, Asana, Trello
UX Prototyping: Figma
UML Flows: Drawio
UI Wireframing: Balsamiq
SDLC: Agile
Database: MS SQL
Domain: E-Commerce, Finance, ERP
Disclaimer
I hereby declare that the above furnished information are true to my knowledge and belief.
Timeline
IT Business Analyst
DHASH IT Solutions
07.2018 - 12.2021
Post Graduate Diploma in Entrepreneurship Development - undefined
Dr. G.R.Damodaran college of science
09.2015 - 05.2017
MBA -
Dr. G.R.Damodaran College of Science
05.2015 - 05.2017
Bachelor of Computer Applications - undefined
Dr. G.R.Damodaran college of science
08.2011 - 05.2014
Senior IT Analyst
Dahnay Logistics
1 2023 - Current