SUMMARY:

• 10 years of analytics and BI experience using T - SQL in DW environment
• 4 years of big data experience on Cosmos platform and familiar with AWS and Azure services
• Certified for Python, R Programming, Machine Learning, Apache Hadoop Essentials, Hive and Pig
• Used Python build linear regression and SVM/RandomForest/LogisticRegression Models

PROFESSIONAL EXPERIENCE:

Sr. Data Science Consultant

Confidential,Redmond,Washington

• Led marketing campaign analysis in commercial, consumer and free-services for Office 365 business practice and provided training on Cosmos Scope & campaign analytics to marketing automation engineers
• Performed A/B testing and conducted campaign experiments, evaluated campaign effectiveness for control and treatment groups with email response rate
• Managed campaign executions and provided data support, sizing analysis for relationship managers
• Built PowerBI dashboard and report at Nintex for their marketing team to demonstrate lead opportunity source and marketing performance by channel; integrated data from GA, FB and Marketo with GDC data on SQL Server; created visuals, datasets, queries, conditional columns and measures
• Architected data solution for WDG team using Jarvis & ODIN data source to drive marketing campaign through Microsoft Marketing Automation Platform (Iris) to promote EMS product of Cloud and Enterprise team
• Collaborated with consumer and commercial teams to launch a new reporting metric system SCOTCH, integrated ETL works, deployed SSIS packages and scheduled jobs

Sr. BI Consultant

Confidential,Bellevue,Washington

• Provided data mining and analytics support for Revenue and Relevance team at Bing.com which aims to improve advertisement revenue through algorithm optimization
• Responsible for Weekly Business Review, Scorecard and KPI reporting automation; analyzed Bing and Yahoo Ads performance in terms of revenue, advertiser, campaign and search traffic based on dimensions such as market classification, sales location, entry point, device and publisher
• Built stored procedures, created and scheduled daily ETL jobs on SQL Server to support internal reporting web portal; set up alerts on SQL Server Agent to monitor data availability and data quality
• Mined search data from multiple data sources such as Cosmos (Scope script), SQL Server and OLAP cubes to provide business insights and performed ad hoc analytical projects
• Triaged and resolved reporting issues, optimized reporting automation process, validated data quality on multiple BI stacks to assure data accuracy and completeness; engaged with pipeline engineers to troubleshoot instrumentation problems to avoid traffic loss and to assure normal traffic for multiple verticals

Sr. Database Marketing Consultant

Confidential,Redmond,Washington

• Led Federal & GEM migration analytics and reporting projects for product management team under AT&T Business Service; collaborated with marketing team and sales leaders to facilitate migration campaign execution
• Provided the team with analytics about the most recent churn rate, usage trend, service revenue shares at segment, account and region level; performed daily reporting
• Built Heat Map for senior level VPs to advocate future migration campaigns for sub-markets which may have upcoming spectrum carves and with high CRU user bases; collaborated with network team to gather and update sub-market spectrum data and carving plan information
• Optimized reporting productivity in Business Object through new report creation and efficient query
• Delivered 2G migration monthly scorecard to majorly reflect 2G account reduction, migration/churn rate and device composition

Sr. Reporting Consultant

Confidential,Bellevue,Washington

• Performed reporting projects for Confidential PHP team to support strategy setting and operation
• Executed marketing campaigns including Growth, Flexpay and Winback to promote Premium Handset Protection plan to over 60,000 target customers every week and achieved 4% to 8% lift
• Executed Open Enrollment to expand customer base, worked on customer segmentation to define target customers
• Executed Retention campaign and reached out 1 million customers to evaluate 6 different marketing messages, worked with program manager and SMS marketing team to accomplish the project ahead of deadline
• Created and delivered Leadership Scorecard for Customer Care and Telesales, monitored PHP take rate in retail channels to drive channel performance competition

Business Intelligence Consultant

Confidential,Redmond,Washington

• Designed and deployed SSRS reporting packages for MBR streaming & Content Delivery Network performance metrics to support operation teams in Xbox, Zune and Windows Phone
• Built T-SQL stored procedures on testing and production servers to facilitate reporting automation; maintained routine reports; worked on reporting trouble shooting and performed ETL and DBA tasks
• Delivered weekly and monthly scorecards using T-SQL, Excel and PowerPoint to partners regarding CDN performance and user profile; improved reporting through automation
• Collaborated with development teams to collect reporting requests; performed ETL tasks to ensure data availability and reporting accuracy

Strategy Analyst

Confidential,Wilmington,DE

• Worked in analytical team at Confidential Collection Strategy Group and reduced debt loss by optimizing segmentation and pricing strategy; collaborated with operation and agency management team to execute new strategies; built scorecards on placement volume, account balances, liquidation rate and settlement rate
• Analyze unit collection and built segmentation for WaMu post charged-off credit card to optimized segment service fee, collector yield and settlement rate based on the calculation of unit collection
• Built a financial model to perform NPV analysis for Chapter 13 accounts sales revenue to optimize asset management; provided recommendations to senior management
• Delivered monthly and weekly metrics reports on consumer and small business demand deposit accounts production, account balances, debit card transactions and service revenues
• Analyzed debit card reward program’s 9 million households’ profile in 15 states and performed one of the most comprehensive household comparisons between WaMu and Confidential