Excel Guru, Advance Excel Function (Pivot Tables, Charts, Macro), VBA Guru, SQL Server, Data Analyst, Tableau, Power BI, Dashboard and Visualization, XML, Access Guru, Database Management
Highly analytical and process-oriented data analyst with in-depth knowledge of database types; research methodologies; and big data capture, curation, manipulation and visualization. Furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth.
Experience:
SR. DATA ANALYST (November 2012 - Present):
AT&T INC
Collect, clean, and store factory production test data and convert into actionable meaningful insight to measure and highlight quality of manufactured products.
Utilized MS SQL data warehousing program, Tableau, Excel and Power BI (dashboard & visualization tools) for data intelligence, analysis and creating visually impactful dashboards.
Provide daily, weekly, monthly and quarterly production quality reports and dashboards for various level of management groups highlighting quality issues.
Improved quality and reliability of manufactured products by highlighting critical production issues on real-time basis to internal quality teams through daily production quality reports and dashboards.
Improved manufacturing yield of products to 99.5%, reducing H/W related customer complaints, truck rollouts, and service calls, saving company close to 1.5 million dollars annually.
NOVEMBER
DATA ANALYST (November 2011 - October 2012)
AT&T INC
Established uniform secure communication link between DIRECTV and global supplier factories for easy, encrypted data transfer.
Architected and designed databases and table structures in MS SQL Server to capture production test data from global factories across various suppliers.
Identify and intimate resolution to data base issues by investigating and resolving data anomalies.
Provide daily, weekly, quarterly production quality reports and dashboards to upper management highlighting production issues across factories.
Work Terms
M - F (12:00 PM - 9:00 PM PST)
SAT - SUN (8:00 AM - 2:00 PM PST)
Attachments (Click to Preview)
-