Shilpa Kannari
Truganina,VIC
Summary
Reliable and Energetic Data Analyst with 5 plus years of experience interpreting and analysing data in order to drive successful business solutions, which includes Power BI and DAX experience. Proficient knowledge in mathematics and analytics. Excellent understanding of business operations and analytic tools for effective analyses of data.
Overview
9
9
years of professional experience
Work History
Data Systems Analyst
The Y NSW
11.2021 - 02.2024
- Handled stakeholders from different business units for requirement gathering, creating dashboard and enhancing the reports
- Dealt with third party vendors in creating ADF pipelines, datasets and developed reports
- Had experience working on Amazon Redshift, links, Qikkids, Xap and ICP software
- Worked closely with Finance and Accounting team and have some knowledge on Oracle
- Generated reports based on SQL, Excel and SharePoint sources
- Executed DAX and Power Queries to get required output
- Extensive experience working on different visuals
- Expertise in data gathering, analyzing, visualizing and validating the data after creating the dashboards
- Managed importing data to SQL server and design dashboard based on client requirement
- Implemented auto scheduled and auto refresh in SQL server and in Power BI to make the process automate.
Data Analyst
Idle Brain Technologies
08.2020 - 09.2021
- Gather Business Requirement/User Stories, review and prepare Technical Documents and Technical Designs
- Strategic expertise in data collection, analysis and visualization
- Develop SQL queries/scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
- Develop Power BI reports, KPI reports and dashboards from multiple data sources using data blending
- Migrating existing reports on to BI platform
- Extensive use of DAX queries to create Measures and Calculated Columns
- Use techniques Filters, Slicer, Hierarchy, Drill through, Custom Visualizations
- Proficient use of MSSQL Server, SSIS, SSRS and Power-BI to develop the solutions
- Daily routine with sprint planning meetings, Scrum meetings, daily stand-ups, Sprint Reviews and Retrospectives meeting at the end of the sprint.
Junior Data Analyst
MicroSpark Software Solutions
01.2017 - 06.2019
- Proactively contribute to the ongoing development, and continuous improvement of the BI applications through user interaction
- Gather business requirements for new and existing reports / dashboards
- Designing, developing and testing Power BI reports / dashboards from a range of sources
- Investigate and combine data from a range of sources to populate dashboards
- Proactively problem-solve reporting / dashboard / data integrity issues
- Provide support to the business in relation to Power BI issues
- Participate and present in Sprint review sessions with Business SMEs
- Provide Power BI training to business users
- Provide regular updates to project lead following an agile methodology.
HR Executive-Recruitment
Intone Networks
11.2014 - 10.2015
- Responsible for the complete lifecycle of Recruitments
- Responsible for candidate recruitment to meet the staffing needs of the company's clients
- The priorities of these efforts are market driven and set by management
- Initial screening and validating the profiles based on qualification, years of experience, number of implementations, consistency in projects and team size
- Involve in the entire recruitment process from sourcing to placing a consultant
- Personal interaction with the candidates and scheduling analytical and technical interviews
- Sourcing, candidates through Naukri, Monster, Times jobs
- Coordinating and helping team members to understand the requirement to source the right profile
- On-boarding the new joiners and assisting them be oriented into the division
- Interviewing the candidates, negotiating with the salary etc.
Education
MBA -
Osmania University
Hyderabad, IndiaSkills
- Power BI
- Microsoft SSMS
- Team Foundation Server/SSDT/Visual Studio 2017
- Microsoft SQL Server
- Microsoft Azure
- ADF Pipelines
- Amazon Redshift
- Advanced user of MS Office Suite – Excel, Outlook, Word & PowerPoint
References
Available upon request
Timeline
Data Systems Analyst
The Y NSW
11.2021 - 02.2024
Data Analyst
Idle Brain Technologies
08.2020 - 09.2021
Junior Data Analyst
MicroSpark Software Solutions
01.2017 - 06.2019
HR Executive-Recruitment
Intone Networks
11.2014 - 10.2015
MBA -
Osmania University
Similar Profiles
Louisa MCKAYLouisa MCKAY
Executive Leader Purpose and Impact at The Y NSWExecutive Leader Purpose and Impact at The Y NSW
Christopher DawsonChristopher Dawson
Pool Lifeguard at The Y NSWPool Lifeguard at The Y NSW
RAJANIKHIL MALARAMUTHANRAJANIKHIL MALARAMUTHAN
Intern at Unions NSW - Health Services Union (NSW/ACT/QLD)Intern at Unions NSW - Health Services Union (NSW/ACT/QLD)