We provide IT Staff Augmentation Services!

Business Analytics Resume Profile

5.00/5 (Submit Your Rating)

Business areas

  • Strategic planning: Management consulting at McKinsey. Developed business and IT strategy for banking, insurance, consumer electronics clients Strategist at enterprise software company BroadVision
  • Marketing analytics/data mining/predictive modeling: Pharmaceutical extensive analytics work for brand management, such as segmentation, targeting, lift/ROI analysis, promotion driveranalysis, persistency/compliance anlaysis. CPG industry marketing mix modeling for ROI, price, promotion issues. SAS, Unix, Excel/VBA, Oracle.
  • Marketing management software development: Built marketing budget brand performance dashboard systems for many pharmaceutical clients with SAS, R, QlikView, Excel/VBA, ASP.NET, C , MS SQL, Oracle, etc.
  • Independently developed commercial mobile app and backend 2cdoc in play store, itunes store for doctor marketing: Azure mobile services, HTML5, JAVASCRIPT, CSS, SQL, Visual Studio/Cordova, SQL, Azure.
  • Database Marketing and CRM: Proposed and implemented full CRM processes and createdstatistical propensity models for largeinsurance company.Generate 30 revenue growth from previous flat year.
  • Software product managementfor enterprise software representing 50 company revenue.
  • Sales force and managed care Sanofi, Merck, Allergan, Schering-Plough, Orgaon, Techpool,etc
  • Sales force effectiveness: sales force size/structure/targeting,and incentive compensation. SAS, Excel/VBA.
  • Sales force and managed care management software development and analytics: many large scale projects in this area With combined business and technical consulting skills, proposed sold solutions, designed and implemented sales force CRM, performance management/business intelligencedishboard.SAS, Saleforce.com, Siebel, Oracle, MS SQL, ASP.NET, C , Javascript, CSS, HTML.
  • Finance/FP A/Forecasting amazon.com, Sanofi, Merck/Serono
  • In-market product forecasting for block buster drug 3B revenue/yr .
  • Forecasting and FP A solution development- IBM Cognos TM1 as developer/administrator, Excel/VBA

Software development andstatistics skills, market research data knowledge

  • Partnership: my own consulting firm is a partner of IBM and SAS.
  • Project management: PMP certified. Extensive experiences in business intelligence, analytics, data warehouse.
  • Requirement analysis strong needs identification and highly structured requirement documentation skills developed through consulting and commercial software product management experiences.
  • SAS my own firm as SAS consulting partner. SAS certified. SAS base, macro, SQL, BI, DI .
  • TM1 IBM certified CognosTM1 developer. Created multiple systems and built TM1/Excel/VBA apps.
  • Web/mobile ASP.NET, C , HTML5, CSS, Javascript, JQuery,Azure Mobile Services, Cordova,Geocding, social sign-in, etc.
  • MS SQL SQL, SSIS, SSAS,SSRS , Oracle, Cognos, ASP.NET, C , Excel/VBA based business intelligence applications
  • Statistics: correlation, linear regression, logistic regression/scoring, cluster analysis, etc.
  • Industry data: IMS NPA, NPS, Xponent, DDD, Plantrak, etc , Wolters Kluwers, MMIT, SDI A. C. Nielsen, IRI.

Experiences

Confidential

  • Provide pharmaceutical client with business analytics and software consulting services.
  • Achieved highest revenue in account history 3.7MM in first year while client company cutting cost by 25 .
  • Team leadership: lead team in client projects for managed care, brand, and sales force. Significantly improved team's capability by attracting high caliber people to the team. Hand-on work in SQL, Excel/VBA, QlikView.
  • Personally analyzed large scale IMS Anonymized Patient-level Longitudinal data, discovered large opportunities.

Confidential

  • Founding principal of new consulting business focusing on maximizing sales force and marketing performance in the pharmaceutical industry through automation and analytics
  • Fully responsible for the entire business of the consulting practice.Conducted marketing research. Formulated business strategy.Sold software development and analytics consulting projects. Achieved 190 of sales goal for 2011.
  • Built a high performance team. In client's words, a united team with strong sense of responsibility and high professional devotion, perfectly organized and highly efficient, full of energy and positive optimistic spirit

Confidential

  • Focus on business analytics and software development.
  • Representative clients: Merck, Schering-Plough, Organon, Sanofi-Aventis, Novartis, Serono, Amazon.
  • Departments: business analytics, secondary market research, forecasting, IT, and finance

Business analytics for sales/marketing/managed care leadership to plan, track, and optimize performance. Covered broad spectrum of business issues through innovative data analysis/mining, communicated complex analysis to senior management, and established strong creditability with sales and marketing leaders. Technologies and statistics - SAS, Oracle, MS SQL, Excel/VBA, t-test, chi-sq, linear and logistical regression, survival analysis.

  • Recommended KPI metrics to sales force and brand management team to track performance, financial results, sales force activity, competitor promotion investments, etc
  • Prioritized sales calls and non-personal marketing promotions through segmentation, profiling, targeting with SAS, Excel/VBA, Oracle PL/SQL.
  • Developed physician brand switch propensity model for launch product. SAS, logistical regression.
  • Refocused sales force efforts on high priority physicians through value/call alignment analysis for newly acquired business unit. SAS, Excel/VBA, Oracle PL/SQL.
  • Investigated impact of sales force restructuring on revenue/market share based on request from sales force head. SAS, Excel/VBA, Oracle PL/SQL.
  • Analyzed impact of sales reps changes on territory performance. SAS
  • Evaluated relative effectiveness of sales messages to physicians. SAS, linear regression
  • Analyzed compliance/persistence for specialty pharmacy product. SAS, survival analysis

Software development

  • Designed and implemented a mobile/web system to help doctors acquiring new patients marketing . The system consists of cloud based backend Azure , doctor web site, and consumer mobile/web app. Consumer app is available at Google Play and Apple itunes stores. Tech: Javascript /HTML/css, Azure, SQL, GIS.
  • Developed web, mobile, Excel/PowerPoint front-end software systemsfor performance management, sales activity tracking, and incentive compensation for sales force, marketing, managed care.
  • TM1 forecasting solution Functioned as TM1 administrator/developer of forecasting group.
  • TM1 cost accounting solution - Designed and implemented a set of TM1, Excel/VBA cost tracking solutions.
  • TM1 cost allocation solution Developed and support FP A team on cost allocation system.

Forecasting: Managed forecasting of blockbuster CV drug with sales > 3B

Confidential

  • Marketing Mix Modeling: analyzed ROI for key marketing mix elements price elasticity to guide price strategy development assortment analysis to optimize retail practice for many of the world's top brands. Managed projects with 70 people off-shore teams.
  • Programming: SAS, Unix, ksh, perl, C. Manipulate large data sets, Bayesian statistics, regression analysis.

Confidential

  • Pioneer of one-to-one targeted marketing, sales, and customer services in web software.
  • Corporate strategy: formulated corporate growth strategy from 100MM to 1B , gained senior management and board buy-in.
  • Product management: Managed portal product prioritized pre-built portlet integration needs through secondary market research Analyzed market demand and competitive dynamics. Created business plan, requirements documents MRD/PRD for integration with SAP, Siebel, MS Exchange, Lotus Notes.

Confidential

  • Led CRM project to rejuvenate insurance company's revenue growth. Developed up-sell hypothesis based on sales force interviews validated hypothesis through data mining created target lists based predictive models designed and implemented new sales force management processes. Increased sales by 30 in pilot regions.
  • Crafted international business unit growth strategy for air transportation technology company. Identified product/ market opportunities. Evaluated competitive landscape. Formulated partnership strategy.
  • Assisted senior corporate management of global conglomerate on divest/re-invest decision of Chinese consumer electronics subsidiary. Assessed market potential and competitive position. Developed cost curve.
  • Developed corporate IT strategy and enterprise architecture for leading insurance company to reinvigorate sales growth and defend market share. Defined target application and infrastructure portfolio, organization structure, budget.
  • Led cross function team and developed detailed IT system requirements for commercial loan lending management processes at major bank.
  • Sales Engineer for global 20 financial service banking and insurance accounts.
  • System Engineer for HP-UX and MC/ServeGuard high availability cluster expert.

We'd love your feedback!