Aryan Singh
Delhi
Summary
Experienced Data Analyst with over 8+ years in data management and warehousing. Proficient in designing Power BI dashboards, writing complex SQL queries, and handling Power BI administrative tasks such as RLS (Row-Level Security) and Active Directory access. Contributed to finance reporting, order management, and continuous improvement dashboards. Skilled in uncovering data insights, supporting strategic initiatives, and collaborating with business stakeholders. Committed to leveraging data-driven strategies for enhanced business performance and continuous improvement.
Overview
1
1
Certification
Work History
Business Intelligence Developer
Hitachi Vantara
Pune
- Designing, creating and implementing BI solutions and translating business goals into technical specifications
- Creating dashboards and interactive visuals using BI tools
- Developed custom reports and deployed them on server using Power BI
- Experience in writing SQL queries, stored procedures, triggers, constraints and indexes using various DDL and DML Commands
- Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions
- Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI
- Created the KPI to show the difference between actual and forecast data
- Worked with table and matrix visuals, worked with different level of filters like report level, visual
- Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.
Business Process Analyst
Rockwell Automation
Noida
- Identifying process gaps with the stakeholders and providing Issue diagnosis, Resolution and Next Issue Avoidance
- Championing for customers and finding most optimal solutions thereby maintaining the Continuous Improvement Plans
- Communicate with all project stakeholders to ensure timely delivery of projects
- Enterprising with other teams to achieve business goals
- Conduct business requirement discussion with cross functional business stakeholders and users to understand business flow, gather requirements and prepare Business Requirements Documents
- Driving Automation projects such as power BI dashboard, Creating Automate flow through Power automate finding opportunity in multiple segments where we can reduce the human efforts to applying RPA
- Core functionalities covered Procurement PDN PO, invoice clearance, orders blocks
- Processing Returns Customer Invoicing Deliver Forecast Reports, Order Processing, Daily management on business projections for order booking management and invoicing
- Working on new order part clearing blocks & Cancellation request on ordered parts
- Well acquainted in SAP, ECC, MM module.
Sr.Analyst
R1 RCM
Noida
- Collects data from internal and external customers relating to low to mid-level complexity systems and reporting issues impacting service delivery Create best-practice reports based on data mining, analysis, and visualization
- Automate report requests wherever possible
- Prioritize business requirements and keep business satisfied with the prioritization
- Discuss with business stakeholders and take initial request to a level of maturity from which the development team can pick it up
- Coordinate and provide the necessary support to assigned projects.
Claim Executive
Religare Health Insurance
Noida
- Ensuring that quality of response to customer issues is as per set standards; conducting process reviews to enable strict adherence to process parameters and systems
- Working on quality improvement projects for achieving continual improvements in service levels
- Taking care of all activity related to claim processing & respond to them within assigned Tat as well as handling their query related to the deduction or rejection
- Endorsement policy assign policy issuance.
Education
Post Graduate Program in Business Analytics & Intelligence (PGP-BA&I) -
Amity University
07.2022
Business Analytics -
Harvard Business School
01.2022
B.A -
CSJM University Kanpur
06.2014
Skills
- Power BI
- SQL
- Python
- Power Automate
- SAP & CRM
- SQL
- Azure Data Factory
- Azure Active Directory
Personal Information
- Date of Birth: 11/14/91
- Gender: Male
- Nationality: Indian
- Marital Status: Married
References
References available on request.
Hobbies and Interests
- Playing Volleyboll
- Cricket
Certification
- PL-300 Microsoft Data Analyst
Timeline
Business Intelligence Developer
Hitachi Vantara
Business Process Analyst
Rockwell Automation
Sr.Analyst
R1 RCM
Claim Executive
Religare Health Insurance
Post Graduate Program in Business Analytics & Intelligence (PGP-BA&I) -
Amity University
Business Analytics -
Harvard Business School
B.A -
CSJM University Kanpur
Similar Profiles
Sarath Chandu VatturiSarath Chandu Vatturi
Senior Technical Consultant at Hitachi VantaraSenior Technical Consultant at Hitachi Vantara
NIJIN M CHATHOTHNIJIN M CHATHOTH
Senior technical Consultant – SAN Infra management at Hitachi VantaraSenior technical Consultant – SAN Infra management at Hitachi Vantara
SANDEEP PRAKASHSANDEEP PRAKASH
Senior Director / VP, Product Management at Hitachi Vantara (Pentaho)Senior Director / VP, Product Management at Hitachi Vantara (Pentaho)
Tracy SchlessmanTracy Schlessman
Sr Manager District Sales at Hitachi VantaraSr Manager District Sales at Hitachi Vantara
Dhruv UpadhyayDhruv Upadhyay
Application Engineer at Quadrafort TechnologiesApplication Engineer at Quadrafort Technologies