We provide IT Staff Augmentation Services!

Sr. Bi Consultant Resume

Redmond, WashingtoN

SUMMARY

  • 10 years of business and data analytics experience.
  • 7 years of reporting and BI development experience using T - SQL in DW environment
  • 3 years of SAS work experience in banking and telecom industry
  • 4 years of big data experience in Cosmos environment
  • Certified for R Programming, Machine Learning, Apache Hadoop Essentials and Apache Pig

TECHNICAL SKILLS

Visualization Tools: Tableau, PowerBI

Programming Language: Python, R, Scala, SAS

Big data and Database: Hadoop, Cosmos, Spark, MS SQL Server, SSRS, SSIS, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Redmond, Washington

Sr. BI Consultant

Responsibilities:

  • Led marketing segmentation analysis in commercial, consumer and free-services for Confidential Office 365 business and provided analytical training for Marketing Operation team at Centric
  • 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.
  • Built CXMReporting database from scratch, acquired and managed ExactTarget email marketing data. Owned and administrated CXMReporting dev and production servers, redesigned database schema and reconstructed database tables to facilitate analytical work
  • Designed and built views on big data platform Cosmos for commercial tenant, admin, subscriptions, offer and usage based on WDG Jarvis data to facilitate marketing campaign execution through Iris ( Confidential Marketing Automation Platform), and this platform was utilized by many Confidential teams such as Cloud & Enterprise and Office Team
  • Analyzed marketing campaign effectiveness by looking at trial conversion rate, subscription renewal rate, email response rate and compared those ratios for treatment and control groups
  • Collaborated with consumer and commercial teams to launch a new reporting metric system SCOTCH, integrated ETL works, deployed SSIS packages and scheduled jobs
  • Managed reporting works, created stored procedures for 5 consumer reporting metrics and 6 commercial reporting metrics and supported Office 365 Marketing Dashboard and PowerBI reporting
  • Requested development resources and reengineered file transfer process to save 20 hours per week

Confidential, Bellevue, Washington

Sr. BI Consultant

Responsibilities:

  • 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 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

Confidential, Redmond, Washington

Sr. Database Marketing Consultant

Responsibilities:

  • 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 as well
  • 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 improved T-SQL query performance
  • Delivered 2G migration monthly scorecard to majorly reflect 2G reduction, migration/churn rate and device composition

Confidential, Bellevue, Washington

Sr. Reporting Consultant

Responsibilities:

  • Delivered reporting and analytics services for PHP team to support strategy setting and resolve operation issues
  • Performed data management tasks to make sure daily transaction logs were well processed and monitored data loading process using SSRS; worked with ETL team to make sure data availability and accuracy
  • Created and delivered Leadership Scorecard for Customer Care and Telesales, monitored PHP take rate performance in retail channels, investigated data discrepancy using T-SQL and provided investigation result to related parties
  • 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
  • Selected over 1 million customers for Retention campaign to evaluate 6 different advertising strategies, worked with program manager and SMS marketing team to accomplish the project ahead of deadline; provided campaign result analysis
  • Executed Open Enrollment to expand customer base, worked on customer segmentation to define target customers and built summary report using T-SQL and SAS

Confidential, Redmond, Washington

Business Intelligence Consultant

Responsibilities:

  • 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 using SSRS; worked on report trouble shooting heavily and performed ETL and DBA tasks when needed
  • 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

Confidential, Seattle WA/Wilmington, DE

Strategy Analyst

Responsibilities:

  • Performed analytical work for Chase Credit Card Collection Strategy Group and reduced debt loss by optimizing segmentation and pricing strategy; collaborated with operation and agency management team to execute new strategies
  • Created SAS and SQL scripts to extract data from data warehouses to generate scorecards regarding credit card placement volume, account balances, liquidation rate, settlement rate and so on
  • Used SAS to 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
  • Utilized Excel modeling function to perform NPV analysis for Chapter 13 accounts sales revenue and built a quantitative model to optimize asset management; provided recommendations to senior management
  • Utilized SQL and SAS to deliver monthly and weekly metrics reports on consumer and small business demand deposit accounts production, account balances, debit card transactions and service revenues
  • Used SQL to pull the customer information from database; 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 Chase

Hire Now