SUMMARY:

• 13 + years experience in the Hi - tech industry in Silicon Valley. Experience in Program Management and developing multitude of metrics with a variety of departments. Manipulate large amounts of data and automate the reporting process.
• Project productivity reporting to Sr. Managers. Drive initiatives and develop schedule of deliverables Develop metrics, dashboard & KPIs. Develop business models to analyze data. Automate the data gathering processes. PMO Exp. Documents requirement, process and procedures. Create procedures & tools to aid decision making. Measure stakeholders’ engagements & s. Keep stakeholders informed of goals, status & vision. Manage and communicate System or BI Development. Ensures that projects meet strategic imperatives. Oversee, analyze project productivity and activities.

TECHNICAL SKILLS:

Technology: Tableau server & administration, Power Query. Build professional metrics on Tableau and Excel. Excel Expert, automate with VBA, Macros. Microsoft Project, PowerPoint, Access, Power Pivot Oracle, SAP, Business Objects, QAD Mfg/ Pro, Agile SQL, Essbase, Noetix, Lotus Notes, Web Ex, WMS

WORK EXPERIENCE:

Confidential, Milpitas, CA

Program Manager (Contract)

Responsibilities:

• Create, develop and maintain all the BI metrics and dashboards and KPI for warranty cost for the IoT Product Families. Created Tableau Dashboards of products to show the cost of warranty in different scenarios. Extract, Transform and Load (ETL) large data sets using Power Query for streamlining data. Lead and drive the warranty Cost reduction initiative and help stakeholders plan what actions to take per product. Use Power Pivot, Power Query, SQL, Tableau and Excel VBA to automate the gathering process & create reports. Ad hoc reports and mapping different data source output into a meaningful master data source.
• Create Metrics on compliance testing on New Product Introduction (NPI) and Sustaining Product to analyze duration trends. Track software releases to identify target dates goals attainment of each milestone through different products. PMO team working in the development of new IoT products working closely with Engineering, Marketing, Supply Chain Team, and Services.

Confidential, San Jose, CA

Business (Logistics) Analyst (Contract)

Responsibilities:

• Do the migration of large data sets into new processes and systems, consolidating data into a central database. Manage large data sets. Create, develop and maintain all the BI metrics and dashboards and KPI. Take part of the system integration and development team in helping coordinate processes with stakeholders.
• Use Power Pivot, Power Query, SQL, Access Tableau, Excel VBA to automate the gathering process & create reports. Created VBA procedures and many tools that aids the decision making and transaction process for the team. Collect business requirements, make documentation and train the team on the tools of my creation. Make sure to track all logistic movements, shipments, invoice, POs, transactions and time of arrival from vendor to site. Keep tracks of all deliverables that might affect the system integration and deployment via MS Project and Smartsheet. Create and update the Bill of Materials (BOM) and make sure all parts arrived to site by projects end.

Confidential, San Jose, CA

Program Manager / Analyst (Contract)

Responsibilities:

• Develop metrics for change management engagements, adoption, s, deployments and communications. Tableau server knowledge, administer and give permissions, develop in depth metrics. Transform old report and metrics into a dynamic Tableau business intelligent reports and dashboards. Use Excel VBA to automate reports, dashboards, Metrics and to create tools for data gathering. Work for the Service Change Leadership team to meet deliverables & help in service transformation. Ad hoc reports and mapping different data source output into a meaningful master data source. Collect business requirements for reports, metrics, dashboards, KPI etc. Make communications engagements and stakeholders engagement reports and Metrics. Take raw data and transform it into a meaningful source of information for decision making. Assisted in workshop development, metrics, and assisted hosting workshop engagements.

Confidential, Redwood City, CA

Sr. Analyst (Contract)

Responsibilities:

• Automated, enhanced and customized customer, internal and contract manufactures metrics by customer contractual requirements, this entails detailed analysis from Install Base and Oracle Contract MFG System. Streamline PowerPoint presentations in preparedness of ad hoc request from customers and CMs. Warranty Analysis, FRU Analysis, Ad Hoc Projects, failure analysis level 1 and level 2, financial reporting. Documenting procedures to be able to enhance, improve and lean out current processes. Resolving customer’s issues with RMA concerns of discrepancies, root cause, corrective actions, lead time attainment of their finish goods in coordination with contract manufacturers. Validate MAC ID to see if its link up to any Sales Order for receipt. If not assign it to an open Sales Order in Oracle for receipt and to continue with the RMA process to get it done in proper time frame. Continue the Install Base Management clean up. This is an on-going labor intensive activity.

Confidential, San Jose, CA

Business Analyst (Contract)

Responsibilities:

• Aided with daily meetings with Program and Product Managers in tracking and forecasting the build revenue in accordance to the build guidance and the on time shipments and LTA. Run critical metric and revenue reports to help run the business of Global Supply Chain Management. Conduct and develop analytical work to understand business drivers effecting build and metrics on daily/weekly/monthly. Participation in projects to enhance tools and aid productivity. Use analytical tools to create scenario models and trends to aid executive decision making. Run Daily, On Time Shipments, Daily Build Revenue, Lead Time Attainment and Schedule reports. Run Dashboard updates and charts for all product families, Business Units, and Organizations for Cisco. Streamline procedures and processes for automation. Plus Ad Hoc reports when asked. Update the PowerPoint Presentations for Weekly, Monthly and Quarterly reports.

Confidential, San Jose, CA

Analyst (Contract)

Responsibilities:

• Create dashboards & metrics on inventory, invoices, POs, Warranty, Cost, WIP, movements, variances, accruals, reversals, late goods issues, On Time Shipments (OTS) by working with the worldwide RVO’s and management team. Review old processes and update to new processes to get to our objective efficiently. Validate contract inventory cost by 3rd parties. Review and validate contract manufacturing cost. Run ad hoc reports requested by management plus 3rd Party Logistics Measurements reports. Track all invoices; create monthly Key Performance Indicators and Measurement reports. Work with the 3rd party Logistics Team to reconcile invoicing from the hubs worldwide. Work with the team to provide a World Wide Aging report for all hubs and Logistic Centers Monthly and quarterly reports that summarizes the segment per hub by geography plus Pareto charts Initiate a Write off & Write on inventory in SAP plus invoice and sales order price reversal.

Confidential

Cost Analyst

Responsibilities:

• Analyzed, rolled, troubleshot, and verified the cost for BOM roll up. Debugged several product families assigned at quarter end and Journalized month-end activity for the Finance Team.

Confidential

Supply Chain Analyst

Responsibilities:

• Support of Supply Chain Management team in developing and maintaining in depth metrics to measure performance.

Confidential

Engineer Material Project Coordinator

Responsibilities:

• Support In engineering manufacturing projects to coordinate and provide materials within a timely manner.

Confidential

Jr. Test Engineer

Responsibilities:

• Testing for the Advance Storage Department on NPI and OEM products while running scripts and collecting test data.. Other Experience available upon request.