Nagarjuna Pokuri
Data Analyst
Bangalore ,Karnataka
Summary
4+ Years of progressive experience with a strong background in data analysis, data modeling, and data visualization. Proven track record of designing and implementing business intelligence solutions to provide actionable insights for decision-making. Skilled in creating visually appealing dashboards and reports, optimizing data models for performance, and collaborating with stakeholders to understand and meet their data needs. Proficient in Power BI, DAX, SQL, and ETL processes. Strong analytical and problem-solving abilities with excellent communication and collaboration skills.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
1
1
Certification
2
2
Languages
Work History
Consultant
Fractal Analytics
Bangalore
09.2021 - 12.2022
- Supported clients with business analysis, documentation, and data modeling.
- Used Power BI Gateways to keep dashboards and reports up to date.
- Published reports and dashboards using Power BI.
- Responsible for analysis, design and testing of reports required.
- Work closely with stakeholders to understand their data needs and deliver solutions that meet their requirements.
- Set up role-based security for dashboards to control access to sensitive data.
- Write Python scripts to perform advanced data analysis, data cleansing, and preprocessing within Power BI.
- Advanced SQL techniques for complex queries, sub queries, and joins
- Create and manage database tables and views, defining appropriate data types, constraints, and relationship
- Connect SSRS reports to various data sources such as SQL Server databases, Oracle, Excel, or other data repositories.
- Assist in data migration projects by developing SSIS packages to move and transform data between different databases
Business Intelligence Developer
Searce
Bangalore
05.2021 - 09.2021
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Planned, designed, and implemented diverse business intelligence solutions.
- Write and optimize SQL queries to retrieve, update, and manipulate data efficiently.
- Use SQL to perform complex data operations, aggregations, and joins.
- Integrate Python scripts into Power BI to load and refresh data.
- Estimated work hours and tracked progress using Scrum methodology.
- Deploy and manage SSRS reports to reporting server, ensuring proper access control and security settings
- Conducted data modeling, performance and integration testing.
- Experience in creating calculated measures and columns with DAX in Power BI desktop.
- Experience in Custom visuals and Groups creation.
- Create and manage SSIS packages for data movement and transformation.
- Optimize and troubleshoot SSIS packages for performance and reliability
- Handled massive quantities of business intelligence data, personally managing as much as [Number] terabytes
Power BI Developer
Innosoft Datalinks
02.2020 - 05.2021
- Gathering business requirements, analyzing and developing reports as per requirements
- Developed different visualizations like Bar and Column charts, Pie chart, Scatter, Maps and Tree maps
- Experience designing dashboards and strong commitment to efficient data presentation. knowledge of Power BI best practices for design and visualization.
- Worked on Power BI administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to users and adding them to specific groups and Projects, Scheduling Refreshes and Subscriptions in Power BI Server.
- Strong hands-on experience in writing SQL queries
- Deploy SSIS packages to SQL Server and manage their execution.
- Monitor and troubleshoot package failures and performance issue
- Deploy reports to SSRS server for access by end-users.
- Define and manage user roles and permissions for SSRS.
- Ensure that sensitive data is appropriately protected within SSAS environment.
- Utilized Power BI server to publish and share reports with business users
- Creating Users, Groups and Projects on Power BI server
Data Analyst
HDB Financial Service
Bangalore
05.2019 - 02.2020
- Identified patterns and trends in large data sets and provided actionable insights.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Generated standard and custom reports to provide insights into business performance.
- Optimized data access and storage to improve performance of analytics systems.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Created dashboards to monitor and track key performance indicators.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- Analyzed transactions to build logical business intelligence model for real-time reporting needs.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Collaborated with stakeholders to identify business needs and data sources.
- Produced monthly reports using advanced Excel spreadsheet functions.
BI Developer Trainee
Techies Infotech
Bangalore
10.2018 - 05.2019
- Wrote and optimized Dax functions to assist business intelligence practices.
- Prepared targeted documentation, specifications, and resources to analyze business data.
- Assessed platform statistics to create customized, data-intensive BI analytics.
- Monitored and optimized dashboards performance.
- Generated reports, updated spreadsheets, and presented results.
- Improved data gathering, analysis, and visualization procedures with strategic optimizations.
- Planned, designed, and implemented diverse business intelligence solutions.
- Collected data from wide-ranging sources.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
Education
Bachelor of Science - Computer Science
Acharya Nagarjuna University
Guntur 06.2013 - 07.2017
Skills
Power BI Desktop
Dax
Data Modeling
Visualizations
SQL
MySQL
SQL Server
Snowflake
Azure SQL DB
SSAS
SSRS
SSIS
SharePoint
Python
MS Office
Data Analytics
Certification
Microsoft Certified Power BI Data Analyst Associate
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Consultant
Fractal Analytics
09.2021 - 12.2022
Business Intelligence Developer
Searce
05.2021 - 09.2021
Power BI Developer
Innosoft Datalinks
02.2020 - 05.2021
Data Analyst
HDB Financial Service
05.2019 - 02.2020
BI Developer Trainee
Techies Infotech
10.2018 - 05.2019
Bachelor of Science - Computer Science
Acharya Nagarjuna University
06.2013 - 07.2017