Bunty Kher
Business Intelligence Analyst @Pacific Gas and Electric Company
Signup · Get unlimited contacts
WORK HISTORY
Business Intelligence Analyst @Pacific Gas and Electric Company
Oakland, CA, US
Engineered an automated transformer compatibility solution by developing ETL pipelines to process SAP data and building a Power BI dashboard powered by rule-based compatibility logic, reducing mobile transformer deployment time from 12 hours to 20 minutes and restoring power to customers during critical outages• Partnering with Substation Operational Readiness to develop Power BI dashboards and Power Apps integrating SAP, TOA, and SharePoint data to monitor equipment health and maintenance, boosting preventive maintenance compliance by 30% and cutting catastrophic failure risk by 25%• Built and automated ETL pipelines with Airflow and SQL Server to ingest real-time TOA data via APIs, reducing data latency by 90% and improving predictive maintenance accuracy and decision-making
EDUCATION
Gujarat Technological University (GTU)
Bachelor of Engineering - BE, Computer Science
Mumbai University Mumbai
P.G. Diploma, Filmmaking
Montclair State University
Master of Science - MS, Business Analytics
ABOUT BUNTY KHER
Passionate Business Intelligence Analyst professional over 8+ years experience with a strong background in utilizing Microsoft Power BI, Tableau and Looker. Skilled in extracting and applying valuable information throughout the entire data analysis process, including data distillation, data storytelling, data visualization, and exploratory data analysis. Experienced in Developing Power BI Apps (Dynamic & Ad-Hoc Dashboards) and leading qualitative and quantitative research initiatives to provide clear focus and direction for brand growth, Internal team productivity and increase efficiency.I\'m known for providing outstanding service in high-pressure situations and for having the ability to use software tools to solve complicated problems, integrate developing technologies, visualize data, and maintain clear communication. Out-of-the-box thinker who is at ease working in teams or independently to ensure that results continually exceed business objectivesSkills:• Data Visualization: Microsoft Power BI, Tableau, Google Data Studio• SQL: Microsoft SQL Server, SQL Server Management Studio (SSMS), PostgreSQL, MySQL, Snowflake• Programming Languages: Python, SQL, M Query Language, DAX (Data Analysis Expression), TCL• Data Engineering: AWS, Azure, Google Cloud Platform (GCP), Snowflake• Data Modeling and ETL: Kimball’s fact and dimensional modeling, Star Schema, ERDs, Power BI, Tableau, DOMO• Data Partner Exp: Nielsen, Mediahound, Parrot Analytics, Variety Insights, IMDB• CRM & ERP: Epicor, INFOR, DC• Project Management: Microsoft Planner, Jira• Project Management Style: Agile, Scrum, Kanban, Waterfall• Marketing Analytics: Google Analytics 360 suit, Google Trends, Facebook Ads, Hootsuite, Nielsen, Brand24, Survey Monkey• Entertainment & Data: Mediahound, Parrot Analytics, Variety Insights, Celtx, Script coverage, Story Trait Analysis, Research (SVOD, Theatrical, Television shows analysis)• Microsoft Office: Excel (Phstat, Data Analysis), Power Point, Word, Visio, Power Automate, Team, SharePoint 4. Certifications :i) The Data Science of Media and Entertainment ii) International Entertainment and Sports Google Analytics
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.