PROFESSIONAL SUMMARY:

• Provide accurate and reliable operational metric reporting. Design insightful business intelligence reports for the business and act as the liaison to work with the IT team and IT stakeholders.
• Finance BI reporting and revenue reconciliation with accounting. In depth knowledge of business analysis concepts, best practices and procedures, data modeling and ETL, data warehousing, SQL, and Hadoop.
• Oracle ERP implementation and general knowledge on requirements between modules: Accounts Payable, Accounts Receivable, General Leger, Order Management, SCM, Procurement, Inventory, and Siebel CRM.
• VBA scripting in MS Excel and MS Access to perform mass data manipulation and macro automation. Generate various datasets using vlookup and pivot tables to slice and dice and visualize the story from the dataset.
• Design Tableau reports and perform ad hoc analysis and design dashboards with connections to data source. Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Scatter, Bullets, Heat/Tree Maps
• Excellent communication and collaborations skills with all levels of staff and across multiple regional teams.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

BI Data Analyst

Responsibilities:

• Automating the cotton pricing and quoting process with flow optimization and Excel scripting. Getting daily China cotton and Pakistan cotton prices from the textile data source and import them into the Excel pricing model file.
• Using Power BI to construct cotton pricing trends and project future pricing movements (supply) and based on the planning of clothing order backlog (demand), recommend to the purchasing group what is the optimal time and quantity of cotton to purchase weekly, quarterly, and annually.
• Aggregate and send out weekly news updates to primary business stakeholders from local, national and international news sources on upcoming events in the pipeline which could affect cotton pricing.

Confidential, San Jose, CA

BI Data Analyst

Responsibilities:

• Deep understanding of the business drivers and our organizational imperatives to be able to articulate our business to stakeholders, IT, Ops and other relevant internal organizations
• Work closely with the PMO Project and Program Manager to create a framework for driving consistent project execution and reporting through best practice and to engage stakeholders. Present project status to department manager and director with Tableau charts and graphs report current adoption status by department.
• Responsible for the day to day running and operational tasks within the SAE program office, helping to create a program framework that is self - sustaining, repeatable and easily maintained.

Confidential, Santa Clara, CA

Data Steward

Responsibilities:

• Master Data Management - Assist in the application and implementation procedures of data standards and guidelines on data ownership, coding structures, and data replication to ensure integrity of data sets
• Review and identify Key Data Elements with subject matter experts and perform ranking and functional lineage mapping. Develop and document Dashboards and Workflows for Collibra.
• Setup data governance rules and document Collibra Connect integration flows using Mulesoft ESB to enable Service creation, Service mediation, Message routing, Data transformation, and Service orchestration.
• Perform quantitative analysis with math and statistical techniques to assess performance, predict trends and determine allocation of resources. Methods include regression analysis, linear programming and data mining.

Confidential, Santa Clara, CA

BI Data Analyst

Responsibilities:

• Collect and aggregate home sales statistics from the MLS and organize the information into buckets for analyzing.
• Using JMP Pro to perform statistics Multivariate Linear Regression Analysis on the sales datasets in the Bay Area.
• Analyze and interpret market analysis results in each reginal local area and customize home sale strategy.
• Articulate the implication of findings and discuss/review prospective properties with buyers. Review the pros and cons of each home and visit/review/inspect the subject properties that fits buyers’ criteria.
• Attend Bay Area Realtor association meetings and sessions to fill in local real estate market trend.

Confidential, Mountain View, CA

BI Data Analyst

Responsibilities:

• Review BI reporting metric requirements with BI manager and map out data sources by reviewing SQL coding to obtain the table name and column names. Review data requirements and data sources with Confidential ’s internal IT teams to perform gap analysis for the ARA modular cell phone project.
• Partner with the Design Manager with effective team communication and proactive problem-solving skills
• Gathering information and distribute them amongst team members and encourage cross-team collaboration

Confidential, Palo Alto, CA

BI Analytics Insights Consultant

Responsibilities:

• Work with India team to take over Excel dashboard reporting process for North America Partner Sales and replicate/transfer the reporting process to local team. Train and guide less experienced junior business analyst.
• Use Excel PowerPivot to analyze datasets and perform analysis of product sales and revenue attainment
• Write SQL script to pull information from various sources and validate key sales figures with finance team. Publish and send out weekly partner sales updates and percent attainment against quarterly goals.
• Automate Excel dashboard reporting by building BI reports with the Confidential reporting team. Users can subscribe to various scheduled reports and receive updates on sales figures.

Confidential, Santa Clara, CA

BI Web Developer

Responsibilities:

• Experience working with product designers/UX as well as cross-functional teams
• Responsible for designing, coding and modifying company websites. Create visually appealing sites that feature user-friendly design and clear navigation. Write java and SQL codes to perform internal inventory transfers.
• Scope reporting requirements for the Manpower Resource Allocation Program. Having regular meetings to review report format, update frequency, data source, user input schedule and manager sign off workflow.
• Regular meetings with business stakeholders and executive management to up keep system functionality.

Confidential

Principal Engineer

Responsibilities:

• Interacting with senior-level executives and government officials at luncheons for event planning and press release announcement details.
• Define and develop a website for the Manila Economic Culture Office for Taiwanese nationals to submit Philippine tourist visa applications on-line. Approx. 600 applicants per day, users can upload pictures and make electronic payment and the system will send out approved travel authorization by email with PDF attachment.
• Project manage the MECO e-Visa scope and prepare Project Execution Plan. Conduct conference room pilot and user acceptance testing with MECO staff. Collect payments from MECO when deliverables are signed off.

Confidential, Union City, CA

Finance BI Consultant

Responsibilities:

• Design and track quarterly sales objectives using MS Access database. Align quarterly US sales region mapping and goal attainment with zip code Field Reps assignment. Measure customer data accuracy in CRM and work with vendors to migrate to a single source of truth platform. Work with business process owners.
• Collect and manage Microstrategy business intelligence reporting requirements. Work with business process owners on setting expectations and perform root cause analysis on data discrepancies.

Confidential, Mountain View, CA

Finance Analytics Consultant

Responsibilities:

• Work in Finance Global Business Intelligence to standardize Marketing Reporting process on ecommerce platform: Number of ad impressions and clicks with customer life cycle analysis and 30 day revenue metrics.
• Document marketing metrics definitions of the Marketing Monetization Report (MMR) and the Advertiser Activation Report (AAR) with documentation and go over and review these definitions with users when questions arise. Outline details of Global BI ETL data flow and schema to enable the global BI community to self-serve
• Ability to identify problems and work towards solutions: Develop SQL scripts and query the Hadoop NoSQL database using python. Optimize SQL scripts by removing redundant process and consolidating procedures. Transform dataset into actionable BI visualization with analytical business trends and drill-down charts.
• Create single source of truth tables with Marketing predictive modeling datasets for global finance projections. Host weekly BI Office Hours to mentor other marketing campaign analysts’ questions on marketing data queries

Confidential, Sunnyvale, CA

Finance BI Consultant

Responsibilities:

• Supported Sales/Marketing users and managers by designing custom real-time OBIEE dashboard to track Global Tech Refresh program. Interface with marketing product managers, BI analysts, business stakeholders and engineers to document requirements in the BRD. Following Agile or Waterfall methodologies for implementation.
• Prepared cleaned up and aggregated sales/marketing data files for importing into Tableau
• Worked with Application Architecture team to validate table joins and manage Data Warehouse plans to expose new columns. Performance tuning dashboards by identifying SQL statement(s) in long running reports; Checking table join structure, sub-queries, views/union methods…etc. and provide technical team with design guidance and resource estimates to achieve the desired dashboard performance.
• Design, build, optimize, launch and support new and existing data models and ETL processes in production for the OBIEE dashboard to achieve fast and accurate reporting by validating with business stakeholders.
• Defined requirements and acceptance criteria. Conduct Unit Testing and User Acceptance Testing. Prepare test scripts, document data validation procedures and generate eBI dashboard documentation.

Confidential, San Jose, CA

Finance Analyst

Responsibilities:

• Customer Operations - World Wide Reverse Logistics (WWRL); Identify Voice of the Customer methodologies to measure Net Promoter Score, Customer Churn, Acquisition Cost, Satisfaction Score, and Customer Effort Score.
• Oracle install base data to calculate Cisco service contract dollars to a Net Annualized Value. Customer segmentation: Commercial, Enterprise, Federal, and Service Provider based on Dun/Bradstreet classification.
• Project the quarterly service contract renewal value for each business segment for management headcount and staff allocation planning. Providing quarterly top performing renewal Service Account Managers list for division.
• US Theater Operations - Customer segmentation analysis for sales coverage; Tie out Finance revenue reporting
• Align quarterly US sales region mapping and goal attainment; Provide actionable insight to business by translating meaning behind the data into an actionable story. Track various performance metric for improvement.
• US Channels Distribution - Data validation and milestone requirements for migration to Everest Oracle 11i.
• Built custom database to provide Single Source of Truth ad-hoc reporting and monthly Market Share analysis

Confidential, Scotts Valley, CA

Business Analyst

Responsibilities:

• Performed mechanical design for 300mm wafer handling mechanism. Business travel to Taiwan at the new installation sites and ensure the system is running smoothly. Using computer-aided design to create 3-D models with animation on the mechanism movement and ensure space clearance and FEA stress requirements are met.

Confidential, Santa Clara, CA

Business Analyst

Responsibilities:

• Gas panel design for the 300mm common platform for the CMP, CVD, Etch, PVD, and RTP systems. Visiting local vendors to inspect tolerance levels and perform FEA analysis on the panel for earthquake stress analysis
• Performed mechanical design with computer-aided drafting Mechanical Desktop to re-design and retrofit current platform assembly. Working with other engineers on their design works in the pipeline and ensure the current framework has room to grow and can handle future upgrades.

Confidential, San Jose, CA

Manufacturing Engineer

Responsibilities:

• Performed engineering drafting and subassembly design and quality control to increase accuracy and productivity. Wrote and maintained CNC programs for Mitsubishi Laser cutting machine.
• Developed Visual Basic Application (VBA) to calculate MFC configurations. Setup CAM manufacturing process.