Business Intelligence Data Analyst

PRIYANKA POLISETTY

**** ******* **, ** ***** • 757-***-**** • *******.**@*****.***

Professional Summary

Around five years of experience in data management, business intelligence, and reporting, I have developed a strong proficiency in SQL, SSRS, SSIS, and advanced Excel functionalities. I have designed and implemented efficient ETL workflows using SSIS, optimized SQL queries and stored procedures, and created complex, interactive reports and dashboards in SSRS to provide actionable insights to stakeholders. My experience includes performing data modeling, integrating BI assets into CRM systems, and ensuring secure, high-performance reporting environments. I have also worked extensively with Power BI and Tableau to create interactive dashboards and visualizations that provide real-time insights for business stakeholders. I’ve also streamlined data extraction and reporting processes through the use of advanced Excel functions like VLOOKUP and PivotTables, reducing manual effort and improving efficiency. Additionally, I have contributed to the development of data governance policies, designed scalable applications for data analysis, and maintained data warehouses to support strategic decision-making. My ability to collaborate with cross-functional teams and translate business needs into technical solutions has consistently helped deliver meaningful business insights and drive operational improvements.

Skills

Data formatting

Defect tracking

Data filtering

Gap analysis

SQL

Business intelligence tools

MS Excel

ETL processes

Power BI

V lookups

SAS

SSIS

Database management

Tableau

Teradata

SSRS

Work History

Infinite Computer Solutions, Data Analyst, 12/2022 to 08/2024 Client: RNDC, Grand Prairie, TX, USA

Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

Produced monthly reports using advanced Excel spreadsheet functions.

Used statistical methods to analyze data and generate useful business reports.

Worked extensively with SQL Server Management Studio (SSMS) and performed data extraction for SSRS reports and other BI tools.

Utilized data visualization tools to effectively communicate business insights.

Developed customized reports, summarizing and presenting data in visually appealing format.

Created dashboards to monitor and track key performance indicators.

Designed and implemented efficient ETL (Extract, Transform, Load) workflows using SSIS to automate data migration and integrate data from multiple sources (SQL Server, Excel, flat files) into a central data warehouse

Optimized data access and storage to improve performance of analytics systems.

Created data models to support decision-making processes.

Generated ad-hoc reports to evaluate specific business requirements.

Utilized excel functions such as Vlookup and Pivot tables to consolidate large datasets and streamline reporting processes, reducing manual effort.

NTT Data. BI Developer Analyst, 07/2021 to 04/2022 Client: Guardian life insurance, Vienna, VA, USA

Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.

Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.

Designed and implemented efficient database schemas, optimized SQL queries, and managed indexing strategies to improve database performance.

Optimized BI reporting capabilities for secure server environment.

Designed customized data collection models for specific visualization tasks.

Improved report performance by optimizing SQL queries, indexes, and report execution plans, reducing report generation time

Skilled in troubleshooting SSRS report issues and ensuring data accuracy while maintaining high performance in large datasets.

Conducted data modeling, performance and integration testing.

Utilized SSIS tools and techniques to identify bottlenecks and optimize package performance, resulting in a 20% reduction in execution time for large data loads.

Integrated stored procedures with SSRS and other reporting tools to deliver real-time, dynamic reporting solutions.

Designed and implemented scalable applications for data extraction and analysis.

Maintained proficiency with latest database technologies SQL.

Troubleshot and resolved complex database issues, identifying performance bottlenecks using execution plans and SQL Profiler. Implemented query optimization strategies such as indexing, partitioning, and query rewriting to improve application performance and scalability.

HCL Technologies, Data Analyst, 02/2020 to 07/2021 Client: Deutsche Bank, New York, NY, USA

Performed audits of subsidiaries to protect shareholders and potential investors from fraudulent or unrepresentative financial claims.

Cultivated positive relationships with vendors to deliver timely and cost-effective supply of services and materials.

Maintained overall safe work environment with employee training programs and enforcement of safety procedures.

Frequently inspected production area to verify proper equipment operation.

Collected data from wide-ranging sources like (SQL, Excel).

Designed, developed, and deployed interactive and highly visual reports using SSRS, enabling stakeholders to gain actionable insights from business data.

Optimized BI reporting capabilities for secure server environment.

Created data analysis tools to allow teams to query acquired information for unique details.

Utilized data visualization techniques to present and explain complex data sets.

Collaborated closely with business analysts and end-users to gather reporting requirements and translate them into customized SSRS reports, ensuring that reports align with business needs and deliver accurate, real-time data insights.

Assisted with creating data cubes and OLAP models to improve data analysis.

Created dashboards to monitor and track key performance indicators using Power BI.

Created data models to support decision-making processes.

Developed and maintained data warehouses and data marts to support business operations. Education

Master of Science: Electrical, Electronics And Communications Engineering, 06/2019 JNTU - Ananthapur

Bachelor of Science: Electrical, Electronics And Communications Engineering, 06/2017 JNTU - Ananthapur

Certifications: AZ900(Azure Fundamentals)

Contact this candidate