Systems Analyst with 5+ Years in BI & Data Analytics

DUHITA RANE

Systems Analyst

*/** **** ****** *****, Akota Road, Vadodara, Gujarat, India • *************@*****.***• +91-735**-***** LinkedIn: https://www.linkedin.com/in/duhita-rane-721451177 Portfolio: https://sites.google.com/view/duhita-rane/home PROFESSIONAL SUMMARY

Detail-oriented Systems Analyst / Data Analyst with 5+ years of experience in data analysis, SQL development, BI reporting, and data visualization. Proven expertise in MS SQL Server, Power BI, SSRS, and ETL processes to deliver actionable business insights. Adept at optimizing database queries, building Power BI dashboards, data modeling, and workflow automation. Strong collaborator with cross-functional teams to translate business needs into scalable technical solutions.

Core Competencies: SQL Development Data Analysis Data Visualization KPI Dashboards Etl (SSIS) Data Modeling Database Optimization Report Automation Business Intelligence Healthcare Data Analytics Python Tableau Excel VBA Data Governance

PROFESSIONAL EXPERIENCE

Altera Digital Health Vadodara, India

Systems Analyst Jun 2021 – Present

• Manage and support multiple client accounts by providing comprehensive data solutions.

• Design and execute SQL queries, stored procedures, and functions using MS SQL Server.

• Write and maintain Arden syntax rules using the MLM compiler for critical healthcare applications.

• Create interactive SSRS reports and Power BI dashboards to provide actionable insight to the clients.

• Document system processes, workflows, and user requirements to maintain transparency and facilitate smooth project handovers.

• Conduct system testing and validation procedures to ensure the quality and performance of developed solutions.

• Participate in regular client meetings to gather feedback and implement enhancements proactively.

• Provide training and support to end-users for reporting tools like Power BI and SSRS.

• Collaborate with cross-functional teams including developers, QA, and business analysts to understand project requirements and translate them into technical solutions.

• Create, maintain, and optimize SSRS reports and Power BI dashboards.

• Utilize basic SSIS packages for data integration tasks. Key achievements:

• Successfully reduced SQL query processing time by 25% through optimization initiatives.

• Developed SSRS reports and Power BI dashboards for client healthcare analytics.

• Successfully completed high-priority projects on time, receiving recognition from clients.

• Worked on legacy systems to improve workflow and automated workflow reporting using MLM and SQL. Mits Infotech Vadodara, India

Junior Software Engineer Jan 2020 – May 2021

• Developed and optimized SQL Server stored procedures and functions for retail and educational software solutions.

• Document system processes, workflows, and user requirements to maintain transparency and facilitate smooth project handovers.

• Conduct system testing and validation procedures to ensure the quality and performance of developed solutions.

• Participate in regular client meetings to gather feedback and implement enhancements proactively.

• Created customized reports for clients, enhancing data visibility and decision-making.

• Contributed to the development of student result generation systems. EDUCATION

Dr. Babasaheb Ambedkar Open University Ahmedabad, India Post Graduate Diploma in Computer Application Sep 2020 – Sep 2022 Navrachana University Vadodara, India

Bachelor of Computer Application Jun 2015 – Jun 2018 CERTIFICATIONS & COURSES

Data Analytics Course

IIM Skills Sep 2024 – Apr 2025

Topics: Excel + VBA, Tableau, SQL, Python, Power BI, R, Alteryx INTERNSHIPS

Martian Technocrats Vadodara, India

Trainee Software Engineer Sep 2018 – Nov 2019

• Developed dynamic websites using ASP.NET with C#.

• Designed SQL queries and integrated backend databases with MS SQL Server.

• Applied HTML and JavaScript to enhance client-facing features. Enlighten Infosystems Vadodara, India

Android Developer Intern Jan 2018 – May 2018

• Built the "Mobile Care" application to diagnose and resolve mobile device issues.

• Tuned and optimized SQL queries to improve performance in the production environment. TECHNICAL SKILLS

• Databases: MS SQL Server, T-SQL

• Reporting & Visualization: Power BI Desktop, SSRS

• Programming: Python, SQL, C#, Arden Syntax

• ETL Tools: Basic knowledge of SSIS

• Other Tools: Excel, VBA, Tableau, Alteryx

LANGUAGES

English Gujarati Hindi Marathi

Contact this candidate