Post Job Free

Resume

Sign in

Power Bi Sql Server

Location:
Detroit, MI
Posted:
February 07, 2024

Contact this candidate

Resume:

Satya Pooja Puvvada

VISA – H* EAD Michigan 248-***-**** ad3gbd@r.postjobfree.com www.linkedin.com/in/pooja-puvvada-15135711b/

Profile Summary

4.5+ years' experience as a Power BI developer utilizing data visualization, reporting, and data warehousing skills.

Developed interactive dashboards and paginated reports for various projects using Power BI Desktop, Report Builder, and DAX.

Implemented row-level security and automated workflows within Power BI environments.

Expertise in MicroStrategy for application development and enhancements (CIC, CAS Reporting, WEBU-NSR), creating grid reports, documents, dossiers, and intelligent cubes.

Proven data analysis, modeling, and performance optimization capabilities.

Comfortable working with diverse databases including Teradata, Amazon Redshift, and Microsoft SQL Server.

Technical Skills

Tools: Power BI Desktop, Power BI Report Builder, MicroStrategy Developer, MicroStrategy Object Manager, ServiceNow

Database: Tera Data, Amazon Red Shift, Microsoft SQL Server

Operating System – Windows, Linux.

Experience

POWER BI DEVELOPER TCS (ROLLS ROYCE) NOV 21 -MAR 22

Developed interactive dashboards for Induction Readiness Planning using Power BI Desktop and DAX visualizations. Dashboards included insights into employee qualifications, training completion rates, and potential roadblocks.

Created reports analyzing key performance indicators (KPIs) related to program effectiveness and participant progress.

Utilized DAX functions to perform calculations, create custom measures, and filter data for deeper analysis.

Collaborated with stakeholders to define requirements, gather feedback, and ensure dashboards met their needs.

POWER BI DEVELOPER CAPGEMINI (COCA-COLA) AUG 19 -NOV 21

Developed the MMD DSR application for Minute Maid Daily Sales Reporting using Power BI, Report Builder, and SQL Server.

Created paginated reports in PDF format for customer invoice validation, leveraging DAX expressions for data transformation and presentation.

Automated data refresh workflows in Power Automate to ensure reports are always up to date.

Implemented row-level security to restrict data access based on user roles and permissions.

Managed and maintained Power BI gateways for seamless data connectivity.

MICROSTRATEGY DEVELOPER CAPGEMINI (COCA-COLA) MAY 17 -AUG 19

Developed and enhanced various applications for Coca-Cola, including CIC (Consumer Interaction Center), CAS Reporting, and WEBU-NSR (Western Business Unit Net Sales Revenue).

Created grid reports, documents, dossiers, and intelligent cubes using MicroStrategy Desktop and Administrator.

Leveraged filters, prompts, and consolidations to enable users to generate ad-hoc reports based on specific needs.

Scheduled cube refreshes and optimized performance for efficient data processing.

Managed user profiles and access permissions through MicroStrategy Administrator.

Migrated packages between environments using Object Manager.

ADDITIONAL RESPONSIBILITIES

Performed data analysis, modeling, and performance optimization tasks for various projects, leading to improved data quality and accessibility.

Worked with diverse databases including Teradata, Amazon Redshift, and Microsoft SQL Server, demonstrating strong proficiency in SQL querying and data manipulation.

Designed and tested reports and dashboards, ensuring effective communication of insights and adhering to best practices for visual design.

Managed user access and performed package migrations within MicroStrategy, upholding data security and maintaining efficient workflows.

Projects

Real Estate Price Prediction using Data Mining Techniques: Utilized Kaggle datasets to predict real estate prices with random forests and neural networks, achieving high accuracy. This project emphasized the significance of precise algorithm selection and model optimization in data mining for real estate analysis.

Shelter Management System (SMS) Database Development: Developed a comprehensive database to support the operational efficiency of homeless shelters, focusing on client intake, bed availability, and service utilization. Enhanced data management and scalability facilitated improved decision-making and resource allocation for homelessness.

Certifications

RHCSA Certification in Red Hat Administration.

Graduate Certificate in Applied Data Analytics with a 3.8 GPA.

Achievements

Best Team Award at Rolls Royce for collaborative excellence and innovative problem-solving.

Xtra Mile Award at Capgemini for exceptional performance.

Recognized with multiple Client Appreciation for outstanding project contributions.

Key Skills

Data Visualizations

Data Modelling

SQL

Data Analysis

Mappings and Relationships

Performance Analysis

Data Warehousing

Project Delivery

Business Analysis

Designing Reports

Testing and Data Validations

Dashboard Designing

Education

MASTERS IN DATA ANALYTICS IN PROGRESS UNIVERSITY OF DETROIT MERCY, MI

GRADUATE CERTIFICATION IN APPLIED DATA ANALYTICS 3.8 GPA UNIVERSITY OF DETROIT MERCY, MI

BACHELORS IN COMPUTER SCIENCE & ENGINEERING 3.5 GPA RAGHU ENGINEERING COLLEGE, AP



Contact this candidate