Data Analyst Power Bi

Data Analyst

Pallavi Vennapusa

Email: *********************@*****.***

Phone: +1-512-***-****

Professional Summary

Detail-oriented and results-driven Data Analyst with over 4 years of experience in data collection, analysis, and visualization.

Proficient in SQL, Python, and advanced Excel to deliver actionable insights and drive business decisions. Strong

communicator with the ability to present complex data trends to non-technical stakeholders.

Professional Experience

Graduate Research Assistant-Texas A&M University 1 year 6 months

Role: Data Analyst

Responsibilities:

• Extracted real-time data from over 1,000 VPP Microcontrollers every 5 seconds and integrated it into a central database

with 99% accuracy.

• Cleaned 500,000+ records, ensuring 95% data completeness by handling missing values and removing corrupted data.

• Analyzed 2 million data points, identifying trends, and visualizing 5% decrease in battery efficiency over 6 months.

• Created 3 interactive dashboards in Power BI, enabling a 15% reduction in system downtime through real-time

performance monitoring.

• Generated weekly reports on metrics like battery voltage and SOC, leading to 3% efficiency improvements in system

usage.

• Documented 30 data flows and analysis methodologies, presenting findings at 2 university symposiums to an audience

of 100+ participants.

Environment: VPP Microcontrollers, Real-time data, Central database, Power BI, Data cleaning, Data analysis, Battery

efficiency, System downtime, SOC (State of Charge), Data flows, Data methodologies, University symposiums, Reporting,

Metrics, Efficiency improvements, Interactive dashboards

DXC TECHNOLOGY - Bengaluru, India Jan 2022 – Jan 2024

Role: Data Analyst

Responsibilities:

• Implemented Agile Methodology for the development of an internal application, enhancing team collaboration and

ensuring quicker delivery cycles.

• Designed and prepared a data warehouse using Star/Snowflake schema in Snowflake, employing Snow SQL for efficient

data storage and retrieval.

• Utilized SSIS ETL transformations to streamline data processing and deployment, migrating ETL packages from lower to

higher environments.

• Demonstrated strong expertise in Oracle SQL and relational databases, writing complex queries, and optimizing

performance through query tuning and monitoring.

• Generated detailed reports and validated graphical data visualizations using R, ensuring accuracy and actionable

insights.

• Involved in migrating a quality monitoring tool from AWS EC2 to AWS Lambda, creating logical datasets to manage data

quality in Snowflake warehouses.

• Built and maintained Tableau dashboards for core business KPIs, saving 10 hours per week of manual reporting work

and driving efficient decision-making.

• Created and optimized PL/SQL Stored Procedures, Functions, Packages, and Triggers, with extensive use of cursors and

user-defined objects for robust database management.

• Used Python and SQL for data manipulation, performed data cleansing, and built models using deep learning

frameworks for predictive insights.

• Automated complex business processes with Python, Automation Anywhere, and Power Automate, improving

operational efficiency by 30% in a matrixed environment.

Environment: Agile Methodology, Internal application development, Data warehouse, Star/Snowflake schema, Snow SQL,

SSIS ETL transformations, ETL package migration, Oracle SQL, Relational databases, Query tuning, R (Data Visualization), AWS

EC2, AWS Lambda, Quality monitoring tool, Tableau dashboards, KPIs), PL/SQL, Python, Data cleansing, Deep learning

frameworks, Power Automate.

Salesforce - Intern Feb 2021 – Dec 2021

Role: Salesforce Administrator

Responsibilities:

• Managed and configured Salesforce for 50+ users, including user setup, role assignments, and security settings to ensure

smooth platform access.

• Customized Salesforce objects, fields, and page layouts, and implemented process automation using Workflow Rules

and Process Builder, streamlining business operations.

• Developed custom reports and interactive dashboards, tracking key sales and marketing metrics, leading to improved

decision-making and performance insights.

• Performed data imports, exports, and updates using Data Loader, ensuring data accuracy and integrity across the

Salesforce platform.

• Trained 25+ users on Salesforce features and best practices, driving a 20% increase in user adoption and productivity.

• Implemented Salesforce CPQ (Configure, Price, Quote), reducing sales cycle time by 15% through automated quoting

and approval workflows.

• Integrated Salesforce with third-party systems, ensuring seamless data flow across business functions like marketing,

sales, and customer support.

Environment: security settings, process automation, Workflow Rules, Process Builder, custom reports, interactive dashboards,

sales and marketing metrics, user training, Salesforce CPQ, Configure, Price, Quote, sales cycle time, marketing, sales, customer

support.

Technical Skills

Programming Languages: SQL, PL/SQL, R and Python

Statistical Software: BI Server Base SAS, SAS Enterprise Guide and SAP

Databases: MS Access, Oracle, Sybase, SQL Server, DB2, Snowflake

Libraries: Scikit-Learns, Keras, Tensor flow, NumPy, Pandas, Matplotlib, Seaborn

Software Packages/Tools: MS Office (Word, Excel, PowerPoint), MS Project, Micro strategy, SQL Navigator,

, Microsoft Power BI, Spark

Operating Systems: Windows, DOS, UNIX

Web Technologies: HTML/DHTML, CSS, Django, JavaScript, VBScript, ASP, Front Page

Visualization tools: Tableau, Power BI, QlikView

Education

Texas A & M university - Kingsville, TX

Master of Science - Computer Science Engineering

Gandhi Institute of technology and Management- Bengaluru, India June 2018 – Apr 2022

Bachelor of Technology - Computer Science Engineering

Contact this candidate