IT Analyst Resume San Jose, CA - Hire IT People

SUMMARY

7+ years of experience in MS excels in pivot tables, formulas, charts, and graphs analysis in data and Root - Cause issues with its clients
+3 years of Salesforce data migration experience, proficient using SF CRM tools
4+ years experiences in reporting using Tableau and Business Objects SAP, manually edited queries to create report tables
Partially edited SQL queries for data reports
Worked across enterprise, commercial and public sector to become key measurement from the source in Oracle tool, Qlickview, SalesForce.com, CCW, converted these data source into Single Source of Truth (SSOT)
Updated SharePoint Community, update content and structure
Create visual communication for data architect, easy for audiences to understand
Capable of integrating multiple data sources, processing data analysis and building interactive spreadsheet
Worked cross-functional leadership to reduce gap and discrepancy in key sales booking amongst Customer Registry, Global Service, and Sales Hierarchy, market segment
Identified and implemented key data metrics for hierarchy management to improve business for Cisco
Developed policy, process, framework, diagram, using MS OneNote
Performed data validation to align business intelligence, back-house data cleanup to remove duplications

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

IT Analyst

Responsibilities:

Worked and update ISO standards for Network Services Documentation
Performed CIO Upload for Tableau executive Dashboard review, created documentation for each service with steps
Produced service metrics trend reports using SAP Business Objects, EIO ( Excellence in Operation), excel and Tableau, from multi-dimensional perspective
Created ISO standard diagrams where to gather these metrics using MS OneNote, which requires multiple, complex steps to gather comprehensive data source uploading to each service.
Managed SharePoint Community to update the Service content, update structure, rooster and update money figure
Managed side projects that interacted with different internal partners, shared Network Services knowledge and narrated stories about Network Service incidents
Provided root-cause analysis for High Priority Remedy Incidents where large amount of money involved
Produced Network Services documentation that displays financial information, circuit diagram, service agreement, and circuit financial statements

Confidential,San Jose, CA

Business Analyst

Responsibilities:

Implemented Salesforce data source using MS Excel (in all skills and functions) for validation, into Single Source of Truth (SSOT)
Identify Organization business entity and clean up back house data in terms of duplication
Validated and pulled data, compared to different data set of the sources from SAP, Saleforce.com, CCW, and Qlickview tool
Developed and implement agenda to governance policy and framework for the local language workflow, the important metrics are: Sales bookings, Global Ultimate Ids, company name and address
Made critical judgment by comparing complex Chinese company names and address and interpreted into English
Resolved duplicated data error, and eliminated duplicated Cisco accounts

Confidential, San Jose, CA

Business Analyst

Responsibilities:

Delivered and implement policy framework to target partner/customers presale and after-sales workflow customer satisfaction
Pulled data from SalesForce.Com to generate data source
Edited SQL query reports using MS Access
Identified for continuous process improvements key measurements for Customer Satisfaction Program in sales hierarchy and sales bookings

Confidential, Milpitas, CA

Business Analyst

Responsibilities:

Performed data mapping integration used Oracle ERP, SAP and SFDC tool. Researched and provided supporting evidence for Cisco customer's/partners’ company history, merger/acquisition, from data reports using MS Excel, pivots, formulas and SQL. I managed to cleanup duplicated Organization Entity and certified these business entity under Customer Registry, the highest level of business intelligence for Confidential .
Assisted the Google map team develop the GPS project, enhance the project by adding map labeling and analyzed historical data for GPS system. Used excel to provided analysis to labeling historical data and status. Keep track of data management using MS Excel, and presented in PowerPoint from conference meeting. Provided training and instruction to users about the map application