Johnny Dang Email & Phone Number

Los Angeles, Ca, Us

Oakland, California, Us

Compiled and analyzed data (from stored procedures, Salesforce, SAP HANA, and various SharePoint locations) to inform strategic business decisions for district managers and product. Conduct research for the corporate operations team and directors on best practices with benchmarks.Created job aids and QA tools, and pushed for formal deployment pipelines with actionable insights. Piloted the first feedback form application. Produce standard, custom, and ad-hoc construction KPI reports. Manage small to midsize projects single-handedly, ensuring on-time completion through Project Management tool JIRA.Helped found the mentorship program with office hours, onboarding question & document library, and SME pairing.Pushed to hire UX and worked 1-on-1 to develop templates, reducing report creation timelines by 40% (plug into pre-made visuals and QC). Created dataflows that siloed data points company-wide, to reduce SQL calls and overall cost. Championed performance & quality assessments, business process re-engineering, change management, and training initiatives (2 levels above) using LEAN principles, pushing emerging technologies, and implementing better practices.

Oakland, California, Us

• Data Analysis:o Compile and analyze data to inform strategic business decisions.o Develop and maintain data models for what-if analysis and other business purposes.o Creating dataflows and data automation pipelines.o Development of PG&E Construction reports & dashboards with operational insights including scheduling and capacity data.• Metrics and Reporting:o Track business metrics and produce standard, custom, and ad-hoc reports.o Create compelling data visualizations using Power BI to convey actionable insights effectively.• Budgeting & Forecasting:o Develop and contribute to budgets and forecasts, ensuring alignment with organizational goals.• Research:o Conduct research on best practices, providing internal and external benchmarks to support informed business decisions.• Quality Assurance & Business Process Improvement:o Perform quality assurance and business process improvement activities.o Develop, manage, or coordinate performance and quality assessments, business process re-engineering, change management, communication, and training initiatives.• Continuous Improvement and LEAN:o Contribute to the development, design, implementation, and continuous improvement of programs and initiatives.• Project Management:o Manage small to mid-size projects, ensuring timely and successful completion.• Mentorship Program:o Actively participated in a mentorship program, serving as a mentor to provide guidance and training to mentees.

Tulsa, Oklahoma, Us

San Diego, Ca, Us

• BI Migration from DOMO to Power BI.• Acted as the subject matter expert for the Power BI project throughout the enterprise.• Developed executive reporting for senior leadership.• Lead in designing, documenting, functionality, and evaluated information systems solutions, data security, integration, infrastructure and performance.• Worked with Oracle SQL database creating ETLs to Power BI processing millions of claims data.• Leveraged live Sales Force Data to Power BI.• Consolidated previous reports to minimize duplication across the migration to Power BI.• 1 on 1 Training with multiple staff members to promote self service reporting.• Hosted working meetings to assist peers with troubleshooting and debugging dashboarding issues.• Assisted in improving and maintiaining documentation for version control and future improvements required for developing BI reports.

Lenexa, Kansas, Us

Lenexa, Kansas, Us

La Crescenta, California, Us

Menlo Park, Ca, Us

BI Analyst

Costa Mesa, California, Us

Pasadena, California, Us

Pasadena, California, Us

• Generating monthly invoices for clients and customers in a timely manner.• Communicating information between the field workers and customers.• High volume of data entry into multiple billing programs.• Evaluating billing systems and implementing procedures to increase work proficiency for branch locations.• Auditing work logs and generated reports.

Monterey Park, Ca, Us

• Handling sensitive information.• Maintaining the flow of data between clients.• Routine encryption of specified data uploaded to multiple clients .• Using PGP keys for each client.• Working with clients to set up secure FTP sites. • Working under high levels of requests.