N.
RAMANAN Professional Experience
[email protected] Junior Technologist (BI Developer),
June2021 – Present - NRoot Labs Pvt. Ltd
6380994629 06/2021 – present | Chennai, India
linkedin.com/in/bi-nr Led a team of 15+ Business Intelligence (BI) experts to ensure project
•
completion on time and enhance team efficiency by 25%.
Directed Extract, Transform, Load (ETL) processes, increasing data accuracy
•
by 15%.
Applied SCD Type 1 for immediate data updates and SCD Type 2 for
Profile
•
historical changes, while leveraging views, CTEs, temporary tables, and custom
functions to optimize data handling, boosting BI efficiency and accuracy.
Experienced BI Developer with 2.5 Developed over 50 advanced SQL queries to fortify Power BI reports and
years of expertise in crafting data-
•
advance data-driven decision-making by 20%.
driven solutions using cutting-edge Oversaw 100+ Microsoft SQL Server Integration Services (SSIS) ETL
BI tools. Proficient in data
•
packages, improving data quality and reducing errors by 30%. Also designed
modeling, ETL processes, and SQL Server procedures, functions, and views for ETL.
transforming complex data into Managed the Power BI workspace, published 17+ reports, and instituted role-
actionable insights presented
•
based data access for 60+ users, resulting in a 40% increase in user
through intuitive visualizations. satisfaction.
Education Projects
Bachelor of Science, physics, YK Motors
SRMV College of Arts and Science
07/2023 – present
Coimbatore, India
Efficiently migrated a complex BI project, including Power BI reports, to a
•
new server, ensuring data accuracy and accelerating report speed by 25%.
Certificates Facilitated client calls, addressed change requests, and delivered customized
•
solutions.
Master Program (Data Scientist) Incorporated specific client features, such as Row-Level Security (RLS), in
•
Simpli Learn over 30+ clients.
Enhanced 25+ SSIS packages for improved performance, automated them via
•
SQL Server Agent, and added recovery measures.
Skills Oversaw and upheld scheduled jobs for consistent data processing.
•
Microsoft SQL Server Adamas Motors
06/2022 – present
SSIS Utilized SSIS for efficient data extraction from the Autoline Database using
SQL Server Integration Service
•
ODBC, implementing Incremental Load and Truncate strategies, reducing data
transfer time by 30%.
SSAS Integrated data from SQL Server and Excel sources, enabling the creation of
SQL Server Analysis Service
•
15 analytical reports and dashboards for data-driven decision-making.
Developed and executed 25 complex SQL queries in SQL Server Management
Power BI Fabric
•
Studio (SSMS) to extract, join, and consolidate data from multiple tables,
Power BI Service facilitating comprehensive reporting.
Created 10 comprehensive business intelligence dashboards in Power BI for
•
Power Apps daily trend analysis, performance comparisons, and actual versus target
assessments.
Data Warehousing Employed 20+ DAX queries, parameters, and formatting techniques to
•
enhance Power BI reports, resulting in more user-friendly and insightful
Python visualizations.
Managed the entire Power BI process, from report creation to publication and
Machine Learning
•
ongoing maintenance on the Power BI Service, ensuring accurate data and easy
accessibility.
Excel Scheduled 30+ reports and implemented critical administrative tasks, including
•
user/group management and row-level security measures, ensuring timely and
Dashboards secure access to reports.
Japan Motors Trading Company Limited
Autoline Sales- 7
01/2022 – 06/2022
Autoline Aftersales - 12 Tailored SQL queries to individual client needs, reducing data retrieval time by
•
Financial Analysis - 12 20%.
Automated ETL tasks by scheduling agent jobs, reducing manual data
•
CRM Analysis - 5 processing time by 50% and ensuring consistent and efficient data processing.
Utilized Power BI for data cleaning, sorting, pivoting, merging, splitting, and
Usage Metrics Analysis- 2
•
grouping, resulting in improved data quality and streamlined reporting
HR & Payroll - 2 processes.
Crafted 40 DAX calculations for more actionable insights and published
•
reports on app.powerbi.com with planned updates for ongoing accessibility.
