Amrit Priadarsy
Sr. Data Analyst
Hyderabad
Summary
Personable business professional bringing successful 8 years of career in Sr. Data Analyst roles within large and fast-paced corporations. Release-planning specialist trained in advanced Excel modeling. Creative solutions architect with real-time problem-solving flexibility.
Data Analysis, Managing end-to-end Power BI project, Expertise in Power BI Admin #Architecture #Data-Modeling #DAX #M #Gateway #Admin 8+ years of experience in the IT, Retail, Agriculture & Checimal industry in all aspects of Power BI application including analysis, design, development, configuration, customization, validation, security and deployment. Power BI Architect, planning and designing. Performance tuning of Power BI reports Expert in development and analysis of Power BI report. Proficient in creating dashboards and interactive visual reports.
Overview
8
8
years of professional experience
Work History
Sr. Data Analyst
HCL Technologies Ltd
02.2022 - Current
- In this organization the clients are in the Agriculture & Chemical sector.
- All the projects are on development and support of reports on Power BI (Pro, Premium capacity), SQL, Snowflake.
- Working on Power BI Desktop and Services.
- Handling overall Power BI admin work.
- Performance tuning of the report.
- Creating efficient Data Model in Power BI.
- Writing SQL, Oracle and Snowflake query for fetching data from databases.
- Using advance & dynamic RLS for high security of data.
- Discuss and design the road map of the project with the stakeholders.
- Analyze data and develop required Dashboards as per specifications and Publish it within the scheduled time
- SQL, Oracle and Snowflake queries optimization
- Manage Azure active directory for the guest users
- Managing Access and permission of users for reports and gateway connections
- Proactively identified areas for process improvement, implementing changes that led to significant time savings for the team.
- Manage Gateways and connecting it to different sources.
- Defining key performance indicators (KPIs) with specific objectives to achieve business goals.
- Development of Paginated report.
- Connect and Worked on paid visuals.
- Developed many Reports / Dashboards with different Analytics Views.
- Develop trend graph for YOY and MOM business analysis.
- Provide recommendations to update current reports to improve reporting efficiency and consistency.
- Analyze business information to identify process improvements.
- Built dashboards for measures to forecast call, trend line
- Built Power BI workspace and Data model.
- Handle Power BI Services & Admin works for company & clients.
- Also worked on the database migration from SQL to Azure SQL.
- Documenting requirement and tracking it’s progress through Salesforce.
- Technologies Used: Power BI, MSSQL, Oracle, Snowflake, SharePoint, Advance Excel, Azure DevOps, ServiceNow, Salesforce.
- Mentored junior developers, fostering professional growth and enhancing team productivity.
- Optimized code performance for improved user experience and system efficiency.
- Conducted thorough testing to identify and resolve bugs, ensuring optimal report performance.
- Developed scalable applications using agile methodologies for timely project delivery.
- Collaborated with cross-functional teams to design innovative solutions.
- Led architecture discussions, driving innovation in software design and implementation strategies.
- Streamlined development workflows, increasing team efficiency and reducing time spent on repetitive tasks.
- Managed multiple projects simultaneously while maintaining strict deadlines and high-quality standards.
- Provided technical support using knowledge of complex technology to solve problems and support new projects.
- Analyzed data to identify root causes of problems and recommend corrective actions.
Sr. Data Analyst
Open Mind Service Pvt. Ltd
08.2021 - 02.2022
- In this organization the clients are predominantly in the Health care.
- Lead the BI team.
- Major Projects: Develop trend graph for MOM business analysis, Developed Call Center Analysis Dashboard, Call Center Metrics report, Health Care Unit wise analysis report, Health Care Specialization analysis, Unit & Doctors wise analysis.
- Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
- Assisted in the development of a centralized data repository to improve accessibility and collaboration among teams.
- Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
- Contributed to overall organizational growth through continuous improvement of data analytics capabilities and processes.
- Spearheaded the implementation of dashboard visualization tools, providing actionable insights for stakeholders and decision makers.
- Handle Power BI Services & Admin works for company & clients.
- Share the dashboards with RLS
- Worked with DB team on DB migration from MS SQL Server to Azure SQL.
- Identified untapped revenue opportunities by conducting thorough market research and competitor analysis using collected datasets.
- Trained junior analysts in best practices for statistical modeling techniques, fostering professional growth within the team.
- Improved data accuracy by implementing stringent data validation processes and quality control measures.
- Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.
- Optimized report performance, implementing indexing strategies and partitioning techniques to reduce query times.
- Evaluated new software solutions for suitability within existing infrastructure while keeping an eye on cost effectiveness.
- Enhanced business intelligence capabilities with the development of advanced analytical models and forecasting tools.
- Streamlined data analysis workflows for increased efficiency and faster decision-making processes.
- Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
- Enabled accurate trend analysis through meticulous data cleansing and standardization procedures.
- Established robust security protocols to protect sensitive company information from unauthorized access or potential breaches.
- Provided guidance on data governance policies to ensure compliance with industry regulations.
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.
- Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
- Generated standard and custom reports to provide insights into business performance.
- Optimized data access and storage to improve performance of analytics systems.
- Created data models to support decision-making processes.
- Created dashboards to monitor and track key performance indicators.
- Provided technical support for troubleshooting analytics and reporting issues.
- Deployed predictive analytics models to forecast future trends.
- Utilized data visualization techniques to present and explain complex data sets.
- Implemented business intelligence solutions to increase operational efficiency.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Developed complex dashboard and reporting tools to track business performance metrics.
Data Analyst
SUPR DAILY (Swiggy)
10.2019 - 09.2021
- Project is to have the analysis reporting done on the various modes of operation and delivery
- High demand for the data analytics to have near term information
- Some of the reports worked and enhanced are as below
- Developed & Share Hub Performance dashboard
- Developed & share Managers Performance dashboard
- Developed & share DE, Sorters, Supervisor Performance report
- Developed & share Milk wastage dashboard
- KPIs for analysis of the trends and growth
- SLA of Hub & Route & DE report
- Analyzing Estimation and Indent Placement
- Complaint Analysis report
- SKU wise Warehouse & Hub wastage dashboard
- SKU shortage dashboard
- Find out DE having issues or not working perfectly by analyzing the data
- Provide recommendations to update current MIS to improve reporting efficiency and consistency
- Analyze business information to identify process improvements Technologies used: Power BI, Periscope, MSSQL, PostgreSQL, Excel LEADs Engineer (Executive) Worked with multiple clients both in support and development of applications/reports on Power BI, Involved in the admin role of the Power BI
- Some of the high-level activities done are
- Preparing Sales dashboard
- Managers & stores Performance dashboard
- Provided the production support and solved the production issues immediately after they are noticed
- Worked on KPIs
- Roaster dashboard
- Developed Reconciliation dashboard
- Data base performance dashboard
- Product wise sales dashboard
- Timesheet report
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Excel & Power BI
- Developed YTD, QTD and MTD analysis dashboard
- Analyze business information to identify process improvements for increasing business efficiency and effectiveness
- Participate in cross-functional meetings to resolve recurring client issues
- Generate and distribute management reports in accurate and timely manner
Executive
LEADs Engineer
04.2016 - 10.2019
- Preparing Sales dashboard.
- Managers & stores Performance dashboard.
- Worked on KPIs.
- Roaster dashboard.
- Developed Reconciliation dashboard.
- Data base performance dashboard.
- Timesheet report.
- Product wise sales dashboard.
- preparing dashboards and worksheets in Excel & Power BI.
- Developed YTD, QTD and MTD analysis dashboard.
- Analyze business information to identify process improvements for increasing business efficiency and effectiveness.
- Participate in cross-functional meetings to resolve recurring client issues.
- Generate and distribute management reports in accurate and timely manner.
- Develops SOP documentation to allow for smooth operations and easy system maintenance.
- Provide recommendations to update current .reports/dashboards to improve reporting efficiency and consistency.
- Technologies Used: Power BI, Adv. Excel, MySQL.
Education
Electronics & Telecommunication
CSVTU
Bhilai, India01.2018
Skills
- Power BI Architecture
- Working knowledge of Power BI Pro, Premium Capacity, Premium Per User
- End-To-End Power BI Report Development and deployment
- DAX and M query
- Working with stake holders and business user to understand the requirement
- Installation of Power BI Gateway application on server
- Managing Power BI Admin work
- Reporting : Power BI, Advance Excel, Periscope
- Operating Systems : Windows, Linux
- Databases : MS SQL Server, Oracle, PostgreSQL, Snowflake
- Project Management Tool : Azure DevOps, Salesforce
- Geographic Trend Tracking
- Operations Analysis
- Operational Modelling
- Variance Analysis
- KPI Tracking
- Risk Assessment
- Data Modeling
- Information Processing
- Business Intelligence
- Statistical modeling
- Advanced analytics
- ETL processes
- Data Security
- Data Quality Assurance
- Data Mining Techniques
- SQL Expertise
- Competitive Analysis
- Strategic Planning
- Data Acquisition
- Data Mapping
- Business Process Mapping
- Gap analysis
- Financial Planning
- Market Analysis
- Workflow Analysis
- Business Analysis
- Process Development
- Data Compiling
- Data Synthesizing
- Systems Analysis
- Procedure Development
- Predictive modeling
- Model Development
- Decision-Making
- Excellent Communication
- Trend Data Analysis
- Time management abilities
- Technical Design Documentation
Accomplishments
- Develops SOP documentation to allow for smooth operations and easy system maintenance
- Provide recommendations to update current reports/dashboards to improve reporting efficiency and consistency Technologies Used: Power BI, Adv
- Excel, MySQL Strengths:
- Sound Technical Expertise and Problem-Solving skills on Power BI and Power BI Admin
- Good Communication, Presentation, and Interpersonal Skills
- Ability to initiate and drive meetings and bringing team into a consensus.
Interests
Date of Birth: , 31st Dec’89
Hobbies: Learning something new
Languages
Languages
English
Advanced (C1)
Hindi
Advanced (C1)
Timeline
Sr. Data Analyst
HCL Technologies Ltd
02.2022 - Current
Sr. Data Analyst
Open Mind Service Pvt. Ltd
08.2021 - 02.2022
Data Analyst
SUPR DAILY (Swiggy)
10.2019 - 09.2021
Executive
LEADs Engineer
04.2016 - 10.2019
Electronics & Telecommunication
CSVTU
Similar Profiles
MOHAMMED RAHAMATHULLAMOHAMMED RAHAMATHULLA
Technical Specialist at HCL Technologies ltdTechnical Specialist at HCL Technologies ltd
AVIJIT LAHAAVIJIT LAHA
Test Lead at HCL Technologies LtdTest Lead at HCL Technologies Ltd
Muthuraman SubramanianMuthuraman Subramanian
Associate Consultant – HCL Shared Services at HCL Technologies LtdAssociate Consultant – HCL Shared Services at HCL Technologies Ltd
YASIN PURINATH KYASIN PURINATH K
Lead Engineer at HCL Technologies LTDLead Engineer at HCL Technologies LTD
Prakash GadhamsettyPrakash Gadhamsetty
Assistant Consultant at Tata consultancy services limitedAssistant Consultant at Tata consultancy services limited