Pei Chen Email & Phone Number

San Diego, California, United States

• Partner with internal stakeholders to define requirements and then design and implement the solution
• Acquire and abstract primary or secondary data from existing internal or external data sources
• Interpret data results to manage business outcomes
• Partner with internal teams and customers to review data and provide recommendations on business opportunities and improvements
• Develop graphs, reports, and presentations of project results
• Perform basic statistical analyses for projects and reports

Atlanta, Georgia, United States

• Sr. Data Analyst responsible for building BI reports for ResMed’s Customer Insights and Sleep Innovations teams. Generate ad-hoc and monthly reports, facilitate data integration from Brightree into ResMed, and create.
• Partner with ResMed Customer Insights and Sleep Innovations teams to define requirements, design, and implement solutions to various data requests.
• Build from scratch and enhance existing enterprise dashboards and ad-hoc reports using MS SQL queries and Sisense Analytics Platform.
• Constantly learning and growing business knowledge of both Brightree and ResMed companies to better identify appropriate data sources and logic needed for executive decision making.
• Work with ResMed BI team to integrate Brightree data into ResMed’s data warehouse (Snowflake).

Greater San Diego Area

• Sr. Data Analyst responsible for building BI reports for Silvergate’s compliance, Fintech, and lending departments. Fully automated manual reports to eliminate user errors and improve efficiency. Proficient in SQL and.
• Build from scratch and enhance existing enterprise dashboards and adhoc reports using Cognos BI report builder, with data analysis and validation performed using SQL queries.
• Develop deep understanding of the Bank’s databases, identify appropriate data sources, relationships and logic needed to produce quality and reliable reports to satisfy business needs and requirements.
• Constantly discovering and testing reporting tool capabilities, such as external data source function and SQL query integration, to improve report writing opportunities.
• Automate existing business reports and reduce the overhead of manual processes by at least 75%, as well as eliminating human errors while improving data integrity.
• Act as liaison and subject matter expert between business and vendor on data inquiries and inconsistencies.

Greater San Diego Area

• BI Data Analyst II responsible for building BI reports for Bridgepoint’s compliance, marketing, and admission departments through Agile (Scrum) methodology. Proficient in Visual Studio (Team Foundation Server), and SSRS
• Responsibilities included business requirements gathering, report design and development, data analysis, and data validation.
• Acted as the data domain subject matter expert, and the point of the contact for business on all data questions from schema design to data hygiene.
• Took ownership of BI team’s peer code review process, and conducted reviews on all user facing reports and stored procedures as part of QA sign-off.
• Fully automated all manual and/or ad-hoc reports from Excel to SSRS format; resulting in a reduction of repeated requests.
• Managed BI team’s project priorities based on business impact through collaboration with key stakeholders.

La Jolla, CA

• Business Analyst for Strategic Partnerships business unit within BofI Federal Bank in La Jolla, CA. Act as both a functional and technical expert of Microsoft SQL Server Management Studio and Report Builder..
• Acted as both a functional and technical expert of Microsoft SQL Server Management Studio and Report Builder. Responsibilities included business requirements elicitation, report building, data analysis, data validation.
• Main contact in data integration projects with third-party service providers, from specification file development to unit testing, coordinated with internal IT to generate new ETL (extract, translate, load) process.
• Gained insights to the data and was accountable for answering any data questions and proposals to ensure data accuracy and behavior.
• Upon discovering data discrepancies, performed various validations and tests to confirm root cause or discrepancy pattern. Then worked with the appropriate party(-ies) for resolutions.
• Performed data mining and data analysis of over 100 million records in data warehouse. Compiled findings in reports (SSRS and Excel formats) and presented them to users for various business purposes and analyses.

Lake Forest, CA

• Became both the functional and technical expert of various systems including project accounting and financial planning applications.
• Facilitated unit testing, issue tracking, and user acceptance testing in change and release management process.
• Collaborated with developers in requirement gathering and testing of Oracle Business Intelligence Enterprise Edition (OBIEE) reports.
• Troubleshoot and resolved process, functional and technical issues related to Project Accounting and Timecard modules within Oracle E-Business suite.
• Provided user support, security and other ad hoc requests for Engineering Operations Department.

Boston, MA

• Acted as both a functional and technical expert of various systems including financial and performance review applications.
• Collaborated with business leads and internal clients/users on business requirements elicitation and documentation. Acted as the liaison between the business and IT teams.
• Developed and enhanced Excel based reports using VBA macro, SQL stored procedures, and Microsoft SQL Reporting Services for Business Intelligence.
• Automated existing business reports and reduced the overhead of manual processes by at least 50%.
• Facilitated testing, defect resolution, and user acceptance in change and release management processes. Performed post-resolution analysis to ensure that problems have been resolved.
• Participated in the full life cycle of in-house performance review project from inception to delivery, including design, development, testing, and sign-off.