SUMMARY:

Seek Project Manager or Data Analyst opportunity to achieve business success

SKILLS:

Data Analytical Tools: Power BI, Excel, Tableau, Qlik (Qlikview), SSAS, SQL, Business Objects, Azure Machine Language

Data Visualization Tools: Power BI, Excel, Tableau, Qlik (QlikView), SSRS, Cognos, Charts & Boards

Data Mining Tools: SSAS

Data Platform: SQL Server, DB2

Big Data Tools: Azure, AWS, Hadoop, Hive, Cosmos

Applications: Office, Azure, Confidential Flow

WORK EXPERIENCE:

Confidential, Redmond, WA

Responsibilities:

• Gather report requirements and translate to technical solutions.
• Dynamically architect and implement reporting & dashboard solutions using Power BI & Charts & Boards.
• Provide monthly editorial summary of Edge Business KPIs and Feedbacks to GMs & VPs within internal Confidential groups, such as WDG, Bing, Office.
• Managing and Publishing various Power BI Dashboards understanding business goals and guardrails in the following area
• Usage, Feedback, Reliability & Performance.
• Monitoring & Familiarity with Cosmos pipeline - executing jobs and managing processes
• Certified Power BI Champion evangelizing Power BI to internal users helping them solve business challenges.
• Rewarded top contributors by PBI Senior PM Maria Balsamo in 2017.

Confidential, Redmond, WA

Responsibilities:

• Design and Manage end to end Reporting Solution.
• Create and Program Manage enterprise project “ Confidential ” Agile Revenue Reporting Tool.
• Build, implement and completely automate various data platform for project Confidential .
• Platform includes MS Sales, BMX Pipeline, SMIT, PCMIT. Reporting solutions includes Power BI Suite (PV, PP, PQ, Q&A), Excel Pivot, Reporting Services, and SharePoint Services.

Confidential, Bellevue, WA

Responsibilities:

• Corporate Analytics and Partner Marketing Team - Architect Database Solution & Program Manage Reporting Infrastructure as Business Intelligence go-to-guy.
• Create highly visible corporate dashboards and reporting suites using QlikView & Tableau.
• Create advanced ETL automation using various components within Talend Studio & SSIS.
• Engage with Global Partner Account Managers in creating, managing, optimizing business reporting solutions, especially helping Confidential -TripAdvisor business exceed 50% Contribution Margin over plan.
• Create complex Tier-Bidding algorithm utilizing A/B Testing methodology to optimize Contribution Margin that drove successful business results for Confidential Partner Marketing.
• Experience with Omniture Tag and setting up Partner/Placement Mapping Process

Confidential, Seattle, WA

Responsibilities:

• Architect solution & Manage reporting infrastructure on Business Intelligence team
• Manage 30+ ad serving clients including CapitalOne, Levis, Starwood, Victoria Secret, Disney... etc. using SQL Server
• Develop custom reports using Amazon Web Services, Elastic Map Reduced, Talend Studio
• Advanced ETL using various components within Talend Studio, such as AWS to S3 File Transfer, TAC Integration, SSIS Integration... etc.

Confidential, Seattle, WA

Responsibilities:

• Data Warehouse Architect on Ad-Publishing Services Team
• Manage enterprise reports for more than 30 clients
• Design data warehouse schema based on business requirement; translate requirement into functional specs; build custom solution; deliver custom reporting solutions
• Develop using SSIS ETL process; SPROC, T-SQL development using SQL Server; OLAP Data Warehouse design and development using Analysis Services; Reporting Services, Excel Pivot, Dundas, PerformancePoint, Business Scorecard Manager for reporting delivery.

Confidential, Bellevue, WA

Responsibilities:

• Data Warehouse Development using SQL Server
• T-SQL Development for Search & Directory, Mobile Business Units
• ETL Design and Implementation using Business Objects Data Integrator
• Report specifications gathering and implementation using Cognos ReportNet 8.0, Framework Manager, and Transformer

Confidential, Seattle, WA

Data Warehouse Architect

Responsibilities:

• Gather Report Requirements, and create Enterprise Reports using Confidential Reporting Services and SQL Server 2005 "Yukon"
• Collaborate and continual development of Data Warehouse architecture to improve data flows within Windows Metadata Internet Services (WMIS)
• Create Music and Movie Business Intelligence Reports based on Web usage around EPG, ETM, WMC Data.
• Maintain more than 300 Jobs on Data Warehouse for WMIS Reporting Daily Build
• Create IIS Log Parsing Program with automation into Data Warehouse using Visual C#.NET
• Customize reports with complex parameters, filters, data point calculations, sub report, grouping, drilldown etc.
• Create many sophisticated charts (line, bar, stacked, area, bubble, pie) with visualize trend and data analysis

Confidential, Bellevue, WA

Database Architect / Reports Analyst

Responsibilities:

• Create Enterprise Reports using Confidential Reporting Services and produce Business Intelligence
• Develop Confidential PSS Product Feedback internal application
• Create and Analyze Enterprise Reports for Confidential Interchange SMSP Team
• Reports Consultant on various Ascentium Projects

Confidential, Seattle, WA

Data Warehouse Architect

Responsibilities:

• Develop Data Warehouse application using SQL Server and Analysis Services with complete software cycle
• Integrate Analysis Services with MSInsight internal app as reporting tool for all End Users on daily basis
• Program Manager all Voyager reporting requests including Role Guide, integration and implementation of solutions for Partners
• Gather business requirements, functional specs, and business intelligence for reporting solutions
• 9 SQL Servers, 12 IIS Servers, 2 Media Servers, and 3 Cluster Server that covers both corpnet/extranet
• Setup, config, manage, user support, and monitor servers with MSE and SiteScope applications

Confidential, Seattle, WA

Financial Analyst and Database Developer

Responsibilities:

• Extensive skills in developing SQL Server Application by writing T-SQL scripts to install SQL Server, creating Data Warehouse schema with Data Center Standard databases to extract MSSales data, developing complex Store Procedures to automate import, and providing enterprise solution for comprehensive Financial Analysis
• Install and administer Campaq Data Center Standard Servers with Nuke and Pave using Altiris Application
• Financial Analyst for many DQM (Data Metric Quality) driven reports on MS Finance Team
• SQL Server design, implementation, backup, replication, security, maintenance, optimization, log shipping
• Create complex Access Form|Macros integrating VBScripts & Data Transformation Package
• Program business logics using Erwin diagram and create Indexes, Triggers, SP, to optimize database efficiency
• Integrate different sources of data (Excel, Access, SQL Server, OLAP Cubes, and VB.Net)
• Generate MSR Reports plus various data sources using Excel Pivot Table
• Rich knowledge of MSSales, Taxonomy, DCS, and Channels of Operation with SSIT Team
• Miscellaneous administration and troubleshooting on Win2K Server
• Exceptional problem-solving skills, organizational skills, and very detailed-oriented

Confidential, Seattle, WA

Network Security Administrator and Database Developer

Responsibilities:

• Design Vulnerability Tracking System for tracking vulnerable machines on Confidential Corpnet for Corporate Security team.
• Scan IP on the Corpnet for vulnerable machines using dir, ping, ipconfig, nbtstat, nslookup, route, tracert etc.
• Store info of vulnerable machines in SQL Server with Access front-end connectivity
• Create advanced Access User Interface for efficient manipulation of data
• Use TCPIP, Subnetting and Routing knowledge to assign appropriate Network IP for DTAP users (Direct Internet Tap) on various Confidential internal subnets.
• Process Service Request (SR) with MSE, and provide support for DTAP users

Confidential

International Office Sales Department Investment Analyst

Responsibilities:

• Provide Financial Analysis, and research for local investors buying European and American funds
• Understanding comprehensive international business structure and research database for investment
• Create Access Database from Confidential Daily Analysis Report for Investment Executives
• Attend conference meetings regularly and Translate Financial Reports from English to Mandarin

Confidential, Seattle, WA

Financial Analyst, System Support, Access Database Developer

Responsibilities:

• Designed client database records using Access database incorporating VB programming
• Created SQL Queries to sort out client records for Investment executives
• Produced Stock and Mutual Fund reports from database catering to individual clients need