BI Solution Manager

• Apr 2021 - Present

Business Intelligence Developer

• Sep 2019 - Jan 2020

Sr. Business Intelligence Engineer - Business Intelligence Sup

• Feb 2019 - Aug 2019

• Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective to derive software designs and performance solutions. • Design, implement, execute and debug manual test cases and automated test scripts using a variety of testing techniques. • Track a data element from source to transformation to target. • Designs and develops relational and multidimensional data models and optimizes the data-mining performance function including the use of data modeling tools. • Creates and implements BI reporting solutions, Extract Transform Load (ETL) solutions using best practices and methodologies; identifies root causes of issues with data quality and other related issues. • Designs and codes new software or enhances existing software and integrates into new or modified systems and/or operational environments. • Works with a reporting team optimizing the ETL/data pipeline process to ensure that business requirements are met. • Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions. Show less

Business Intelligence Analyst

• Aug 2017 - Jan 2019

• Department: Enterprise Information Management. Title: Business Intelligence Developer. • Design, develop and implement the ETL process using SSIS to ingest information from various data sources, the majority of the data source is the Syteline ERP system. • Design, develop and implement Store Procedures, Views, Functions and other artifacts in TSQL for sourcing data and building the enterprise data warehouse (EDW). • Design, develop, implement and maintain SSRS report models and reports. • Design, develop and implement multi-dimensional SSAS cubes for forecasting and analytical purpose. • Design, develop and implement Tableau data visualization solutions to satisfy business requirements based on ERP system (OLTP) and EDW (OLAP) structure. • Corporate with Business Analyst (BA) and Subject Matter Expert (SME) to achieve the requirement gathering, designing, analysis, confirmation and manipulation. • Work with SME throughout the organization to identify opportunities for leveraging company data to drive business solutions. Mine and analyze data from EDW to drive optimization and improvement in areas of operational excellence, driving growth and other PCNA initiatives. Applied performance tuning on cubes, report models, reports, stored procedures, views and jobs. • Provide assists to SME to set up BI&A environment, ensure users’ experience. Provide training material to maximize the value of BI&A products. • Develop, maintain and implement automation processer Macro Scheduler to deal with ERP data ad-hoc entry and manipulate request. • Coach and mentor PCNA BI team members on the various aspects of BI development. Show less

Graduate Assistant

• Feb 2015 - Dec 2016

Provide assistant service for department needs. Tutoring for all level students in their courses requirement' grading study material (quiz, work, exam); Monitoring examinations. Provide assistant service for department needs. Tutoring for all level students in their courses requirement' grading study material (quiz, work, exam); Monitoring examinations.