SAI KIRAN B
Sydney,Australia
Summary
A dedicated and results-oriented BI Developer / analyst with three plus years of experience in designing and implementing business intelligence solutions. Seeking a position to pursue career by utilizing my problem solving, attention to detail and critical thinking skills to achieve organizational goals, developing software's and analyzing data that matters. I specialize in leveraging the capabilities of Power BI, Azure, data flows, SQL,, pipelines, ADF, Data Bricks, M Query, and DAX, to create robust and efficient data architectures in an Agile driven methodology.
Overview
5
5
years of professional experience
1
1
Certification
Work History
BI Developer
NHVR - National Heavy vehicle regulator
10.2022 - Current
- Successfully managed projects from conception to completion, applying high-level project management and advisory skills
- Worked and collaborated with a team of 10+ data engineering professionals to design and develop an automated ETL solution to load the data warehouse and process the cube for efficiency and also developing EDP enterprise data platform
- Strong command of SQL and database management systems, including Snowflake, MySQL, and Oracle, contributing to robust data handling capabilities
- Experienced in project management, configuration/support, Microsoft Office Suite, and proficiency in Microsoft Visio and MS Project for creating flowcharts, entity relationship and organizational charts
- Collaborating with stakeholders to gather requirements and deliver intuitive dashboards and reports that facilitate decision-making processes
- Managing and administer Power BI workspaces, datasets, data flows, and gateways within Power Bi service, ensuring proper data governance and security
- Experience in Data warehousing, Star Schema, Snowflake, Entity-Relationship Modeling and Dimensional Data modelling
- Designed and implemented robust data models, overseeing Extract, Transform, Load (ETL) processes to guarantee data accuracy and efficiency
- Employed Microsoft Azure tools such as Azure Data Factory and Data Bricks for efficient data processing
- Developing new AAS models and upgrading existing ones by leveraging statistical techniques to forecast trends and outcomes
- Facilitated workshops to enhance business uptake of BI reports, dashboards, and self-service literacy, fostering a data-driven culture
- Ensured data integrity by conducting regular audits, resolving discrepancies, and maintaining strict adherence to corporate security policies.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Supported end-users in understanding complex datasets through effective training sessions and documentation materials.
- Reduced manual reporting efforts by creating self-service dashboards for various user groups.
- Provided timely responses to ad hoc requests for information from management staff, allowing for informed decision-making based on accurate data insights.
- Designed and implemented tools resulting in a streamlined workflow, improving overall efficiency, and conducted comprehensive analysis, identifying and implementing improvements in business systems
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
- Served as a subject matter expert for all BI-related topics, providing guidance and support to key stakeholders throughout the organization.
- Standardized report formatting across departments, ensuring consistent presentation style and content structure that facilitated ease-of-use for all users.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
BI Analyst
AD Consulting
09.2021 - 09.2022
- Conducted in-depth analysis of complex data sets, translating findings into actionable insights that contributed to strategic business decisions
- Successfully managed end-to-end BI projects, ensuring timely delivery, high-quality results, and alignment with organizational goals
- Ran and improve the process of data product development and support product automation which include access requests, data refreshes, releases, source control, quality control, availability monitoring, knowledge management, including keeping product documentation up to date
- Extracted data from multiple data sources and converted them into one combined source for reporting purposes using ETL techniques
- Experience in presenting, facilitating group training, and translating business needs into technical solutions
- Gather, clarify, and document requirements, design solutions, developed code in SQL, Python, DAX, Microsoft BI stacks
- Involved in creating new stored procedures and improving existing ones
- Successful participation in multiple projects throughout the information system development life cycle with Proven ability to meet project deadlines and deliver high-quality solutions
- Developed robust SQL scripts to extract relevant information from large datasets quickly and accurately, expediting ad hoc report requests.
- Streamlined reporting processes by creating automated dashboards, resulting in improved efficiency and accuracy.
- Bridged communication gaps between technical and non-technical stakeholders by translating complex data concepts into easily understood terms, fostering a shared understanding of project goals and objectives.
- Developed and implemented data governance policies and procedures.
- Implemented effective change management strategies during technology transitions, minimizing disruptions to regular operations while maximizing user satisfaction levels.
- Reduced report turnaround times by automating manual procedures through the implementation of efficient ETL workflows.
Data Analyst
CommScope
06.2020 - 08.2021
- Provided technical support for new software systems by creating database structures and tables based on business requirements
- Performed data cleaning and data manipulations necessary for predictive models
- Successfully collaborated with diverse business units to support analytics and data initiatives
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Streamlined data processing for faster results by implementing advanced analytics tools.
- Designed custom tracking systems to monitor KPIs, ensuring alignment with organizational goals and objectives.
- Reduced operating costs by automating manual data processes using scripting languages such as Python or R.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
- Utilized advanced query optimization techniques to enhance database performance and reduce latency issues during high-traffic periods.
- Managed time efficiently in order to complete all tasks within deadlines.
- Cultivated interpersonal skills by building positive relationships with others.
Data Analyst
Monash University with AEMO
05.2019 - 06.2020
- Involved in analyzing large amounts of energy consumption data which can be used to predict peak demand
- Created SQL scripts for creating tables, views, stored procedures, loading data into the tables
- Applied strong analytical and organizational skills including thoroughness and attention to detail to accommodate changing priorities and work assignments.
- Increased data accuracy by implementing thorough data validation and cleansing processes.
Education
Master of Science - IT Data Analytics
Deakin University
Melbourne, VIC07.2018
Bachelor of Computer Science Engineering -
JNTU
06.2016
Skills
- Power BI, Tableau
- Stakeholder Management
- Statistical Analysis
- Descriptive Analysis
- Python, Jave
- Azure SQL, MySQL, MSSQL,Oracle
- Azure Stack
- Rapid Minor
- Data Bricks
- ETL development
- Snowflake
- Data Warehouse
- DevOps
- Microsoft BI stack
Websites
Accomplishments
- COSBOA Innovation Game challenge, Melbourne - December 2018
- Microsoft & IBM Hackathon - December 2017
Certification
- Power BI Data Analyst Associate
Timeline
BI Developer
NHVR - National Heavy vehicle regulator
10.2022 - Current
BI Analyst
AD Consulting
09.2021 - 09.2022
Data Analyst
CommScope
06.2020 - 08.2021
Data Analyst
Monash University with AEMO
05.2019 - 06.2020
Master of Science - IT Data Analytics
Deakin University
Bachelor of Computer Science Engineering -
JNTU
Similar Profiles
Andrew WilliamsAndrew Williams
Safety & Compliance Officer at National Heavy Vehicle Regulator (NHVR)Safety & Compliance Officer at National Heavy Vehicle Regulator (NHVR)
Hemanth KankipatiHemanth Kankipati
Graduate Data Engineer at National Heavy Vehicle Regulator(NHVR)Graduate Data Engineer at National Heavy Vehicle Regulator(NHVR)
Meryellen LimaMeryellen Lima
Administration Officer at NHVR - National Heavy Vehicle RegulationAdministration Officer at NHVR - National Heavy Vehicle Regulation
Gary McMurrayGary McMurray
Head of Property at County Property GroupHead of Property at County Property Group
Thao Vy NguyenThao Vy Nguyen
Front of House Staff at Nysam BakeryFront of House Staff at Nysam Bakery