Abhishek Sharma
Melbourne,Australia
Summary
Results-driven Business Intelligence professional with 15 years of expertise in data analysis, data visualization, and project management. Proven track record in designing and implementing comprehensive BI solutions, leveraging advanced data analytics and visualization tools. Adept at translating complex data into actionable insights, driving strategic decision-making.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Senior BI Developer
Royal Melbourne Hospital
03.2021 - Current
- Collaborated with stakeholders to translate business requirements into technical specifications.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Developed interactive dashboards and reports using Power BI to provide real-time insights into key business metrics.
- Developed complex DAX calculations and measures to enhance data modeling and analysis capabilities in Power BI
- Migrated SSRS reports to Power BI.
- Implemented complex data transformations and built efficient data pipelines to ensure accurate and timely data visualization in Power BI.
- Conducted performance tuning and optimization of Power BI reports, improving overall query response time and enhancing user experience.
- Collaborated on a machine learning pilot project with Melbourne University researchers.
Senior BI Developer
Monash Health
12.2018 - 03.2021
- Responsible engaging non-technical users, clinicians, nurses in data analysis projects through effective communication and collaborative workshops to extract meaningful requirements
- Responsible for developing DAX measures within Power BI, creating dynamic and interactive reports through advanced data modelling techniques
- Maintained dashboards, data refreshes, and report publication in Power BI
- Managed security and control access to the published report on reporting portal
- Developed various reports related to COVID monitoring and contact tracing
- Work collaboratively with colleagues, line manager and clinical informatics team to develop best practices around data validation, management, and analysis
- Responsible for training and grooming a resource in writing queries and report development.
BI Reporting Manager
Accenture
01.2014 - 11.2018
- Improved reporting accuracy by streamlining data collection and analysis processes.
- Enhanced team productivity through effective delegation of tasks and clear communication of expectations.
- Developed comprehensive financial reports for senior management, driving informed decisionmaking.
- Implemented new reporting tools and software, increasing efficiency in the report generation process.
- Lead a 10-member high performance team and successfully managed the delivery of various reports
- Mentored junior team members, fostering professional growth and improved performance within the department.
- Consistently met deadlines with well-organized work plans and efficient time management skills.
- Conducted thorough quality checks on all reports before submission, minimizing errors and increasing credibility among stakeholders.
- Participated in regular training sessions to stay current on industry trends and best practices in financial reporting.
Business Intelligence Developer
Accenture
12.2012 - 07.2014
- Developed reports, visualizations, workspaces, and interactive Business Intelligence (BI) reports, tailored to various user groups across the business, and transforming raw data into actionable insights for various stakeholders
- Created SSIS Packages dealing with different data sources(SQL Server, Flat Files, and Excel) and loaded the data into target data sources by performing different kinds of transformations
- Created reports on MS BI SSRS tool
- Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments
- Scheduled jobs to execute SSIS packages – developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks
- Assist the Project Manager with estimation and project planning
- Project Planning and Tracking, Configuration Management (CVS tool), Code Reviews, troubleshooting & Defect prevention.
SQL Developer
Accenture
12.2011 - 12.2012
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Increased data retrieval efficiency by designing optimized views tailored to specific reporting needs.
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Developed robust SQL scripts to extract relevant information from large datasets quickly and accurately, expediting ad hoc report requests.
- Collected data from wide-ranging sources.
- Designed customized data collection models for specific visualization tasks.
- Created Report design documents and test cases.
- Mentored junior developers on best practices in SQL development, fostering a collaborative learning environment within the team.
- Managed database security by implementing appropriate access controls, maintaining compliance with industry regulations and company policies.
Report Developer
Oracle Cerner
11.2006 - 11.2011
- Created Reporting Specifications documents for several reports for the various hospitals
- Providing SQL queries and reports to assist with creation of various clinical dashboards
- Developed a library of reusable SQL queries, expediting the creation of future reports and minimizing redundancy.
- Provided training and support to junior team members, enhancing their technical skills and understanding of reporting best practices.
- Enhanced data accuracy within reports by performing thorough data validation checks.
- Standardized reporting layouts across various departments.
- Increased user satisfaction by providing prompt responses to ad hoc report requests, addressing specific needs in a timely manner.
- Assisted in the migration of legacy reports to newer platforms.
- Conducted regular audits of report usage statistics.
- Developed thorough documentation for all created reports, contributing to a comprehensive resource library for team reference and training purposes.
- Participated in regular meetings with stakeholders to present findings and discuss potential improvements for upcoming report iterations.
- Maintained the security and publication of the reports on the reporting portal for end users.
Education
Bachelor of Engineering - Computer Science and Engineering
University BDT College of Engineering
Skills
- Business Intelligence (BI)
- Data Analysis
- Data Warehousing
- ETL development
- Power BI
- MS SQL Serve
- Star Schema Design
- Dimensional Modeling
- Strong data visualization
- Data Modeling
- SQL (Structured Query Language)
- KPIs (Key Performance Indicators)
- Performance Optimization
- Data Governance
- Data Quality Assurance
- Data Security
- Storytelling with Data
- T-SQL
- Query Optimization
- QlikView
- Azure SQL
- MS Project
- MS Sharepoint
- Javascript
- HTML
- CSS
- Cerner CCL
- BIRT Reporting tool
- SAP Infoview
- JIRA
- HP Quality Centre
- Project management capabilities
Certification
Azure Data Fundamentals (DP-900)
Azure Data Engineer Associate (DP-203)
PMI Project Management
Timeline
Senior BI Developer
Royal Melbourne Hospital
03.2021 - Current
Senior BI Developer
Monash Health
12.2018 - 03.2021
BI Reporting Manager
Accenture
01.2014 - 11.2018
Business Intelligence Developer
Accenture
12.2012 - 07.2014
SQL Developer
Accenture
12.2011 - 12.2012
Report Developer
Oracle Cerner
11.2006 - 11.2011
Bachelor of Engineering - Computer Science and Engineering
University BDT College of Engineering
Similar Profiles
Melissa SerratoreMelissa Serratore
Enrolled Nurse at Melbourne Health - Royal Melbourne HospitalEnrolled Nurse at Melbourne Health - Royal Melbourne Hospital
Gillian WisemanGillian Wiseman
Patient Services Assistant at Royal Melbourne Hospital - Royal ParkPatient Services Assistant at Royal Melbourne Hospital - Royal Park
Tom TasevTom Tasev
Supervisor at Melbourne Health - Royal Melbourne HospitalSupervisor at Melbourne Health - Royal Melbourne Hospital
Vimonluk SimarattanayotinVimonluk Simarattanayotin
Environmental Services Housekeeper at The Royal Melbourne Hospital - Royal Park CampusEnvironmental Services Housekeeper at The Royal Melbourne Hospital - Royal Park Campus
Agam JohalAgam Johal
Optical Assistant at Specsavers, CroydonOptical Assistant at Specsavers, Croydon