Deepmala Baswal Email & Phone Number

Raleigh, North Carolina, United States

 Working as a functional POC between Business and Product Development team for Digital Marketing and Strategy team which involves end to end activities such as gathering the business requirements, analyzing the requirements, developing the plan and scope for new product development and launches, identifying the KPI/metrics as per the industry standards, finalizing on the business rules for KPI’s to be measured and developing the user acceptance criteria with the business. Currently leading the new Tableau, Google looker studio Marketing KPI dashboards in the team across various types of marketing data such as AE, CLM, SFMC engagement data across various Therapeutic areas and brands. The creation of these dashboards involves discussion with the business leaders and understanding their requirements, KPIs/metrics business is envisioning to build, data discovery and gap analysis, identifying if required data/attributes are available in usable form, frequency of the data refresh in these marketeer dashboards and performing analytics which helps answer business questions important for decision making across Customer Reach, Channel Performance, Content Impact

Raleigh-Durham, North Carolina

Working as a Data Analyst in Cisco Managed Services group, Customer Experience. In my current role, I am providing analytics solutions to leading investment bank of US on Cisco products and services.Providing dedicated end to end support in Data Analytics space to one of the leading investment banks of U.S., understanding customer requirements and offering solutions in order to enhance customer experience by providing useful performance insights through Dashboards/Analytical reports on IT products and services.Working in collaboration with Service Delivery Manager’s to deliver the desired outcomes highlighting and measuring operational performance trends on a regular basis ensuring continued success of the offered solutionsProviding analysis through reports/dashboards, presentations for Business Reviews between Senior Leadership Team of Cisco and BankUsing a set of tools such as MicroStrategy, Splunk, Cognos etc. and Bank internal databases to pull raw data and process and customize the data in order to generate meaningful insights through data visualization/dashboards leading to data driven business decisions

Bengaluru, India

Managing multiple US client accounts and responsible for providing reporting solutions and analytic support to internal stakeholders on various requirements like data trending and analysis, identifying and analysing performance metrics, market analysis, forecasting & business insights for the US pharmaceutical market to drive strategic business decisions in the business unitHandling various US client accounts in terms of reporting, Insights and ad-hoc analysisWorking knowledge of SQL, SAS and Tableau for developing performance reports/analysisCreation of Source of Business and Patient level reports for renowned pharmaceutical companies in the US; thus, analyzing various Source of Business metrics and generating actionable insights for customers to drive better business decisionsDeveloping comprehensive MS-Excel Dashboards/Analytical reports to capture different KPI’s, tracking prescription, sales and marketing activities for various US marketsExperience developing interactive dashboards and reports using visualization tools such as TableauWorked on various ROI and Customer Conversion Analysis projects to evaluate the results of marketing campaigns for brands promoted on various digital channels by studying customer engagement on test v/s control group and calculating ROI effectiveness; thus, providing recommended action to optimize ROIAnalyzing various US data sets, conducting logical accuracy and consistency checks, for regular reporting support and ad-hoc projects like sales, prescriber & patient level analysis, claims, brand pricingGood hands on experience in IQVIA tools like SMART, Dataview, SDI Datamart, NPA Market DynamicsPossess good knowledge of healthcare data such as Sales and Prescription, Longitudinal Patient level data, Promotional, payer, Rx and Dx, patient's persistence and compliance , claims databasesExperience of working on IQVIA US databases (NSP, DDD, NPA Market Dynamics, IPS, APLD, Xponent)

Noida Area, India

Successful project execution for online business vertical (B2C ecommerce) through active involvement across multiple areas such as product development, sales and branding activitiesEvaluating and reporting the performance of digital marketing campaigns and providing recommendations to improve or increase businessDeveloping weekly/monthly review dashboards and presentations highlighting overall program performance

Noida, India

Business Analysis and Competition Benchmarking: Worked closely with the leadership team to conceptualize the business requirements and providing solutions based on secondary research and market analysis. Prepared benchmarking reports, performance reports, competitor analysis to execute business initiatives and enable smarter business decisions Digital Marketing Analytics: Mapping marketing activities with revenue and customer engagement metrics and providing recommendations on marketing initiatives. Evaluating the effectiveness of marketing campaigns. Study and analyze the website traffic metrics such as unique visitors, pageviews, returning visitors, CTR, time spent etc. for product and competitors by using digital analytical tools such as ComScore, Google Analytics and Vizisense. Performance tracking of sales initiatives, revenue and various product metrics for management reporting to drive business growthAnnual Operating Plan & Performance Reporting – Coordinating and putting together the Annual Operating Plan presented to the investors in the group. Monthly and quarterly reporting of business performance (MIS) to the investors

Gurgaon, India

Responsible for providing consultation and solution to On-shore partners on various requirements like data gathering, data analysis, market analysis, reporting contents & business insights to help them acquire a better understanding of the market behaviour, business context and insight in the pharmaceutical marketCreation of dashboards, reports and monitors for tracking KPIs of brands, sales force, departments such as sales trend analysis, market share, sales growth, share of voice and promotional spend studyEstablished a new engagement under Consumer Healthcare division at GSK to support Sales Force Teams across US and EuropeProviding consultancy on key areas of Sales Force for implementation of marketing strategies and better utilization of sales force resources Customer Profiling Segmentation and Targeting ValidationProviding support to European markets in terms of reporting, Insights and ad-hoc analysisProjects analyzing the performance of new therapy areas, products pre-and post-promotion by tracking the performance (in terms of sales) of upcoming areas and products under them after the promotional activities started for themShare “Best Practices” among teams and mentor team members on new projects, opportunities and career pathExhibited initiating and leadership skills through transition of various reports from onshore team to GSK Knowledge Center and mentoring team members Demonstrated Planning skills through active participation in framing project plans and delegating task to team members and thereby ensuring smooth delivery of stakeholder’s deliverables Responsible for building and maintaining client relationships & ensuring client satisfaction through conceptualization of projects and providing solutions through establishment of continuous communication and comprehensive documentation to European partners

Gurgaon, India

Market and Commercial Analytics:Provided knowledge and analytical support to top most Pharmaceutical Company GlaxoSmithKline’s European Business. This role encompassed data understanding, requirement analysis, regular creation of sales and marketing dashboards, scorecards and analytical reports. Typical projects include quantitative analysis with focus on forecasting, competitive intelligence, data analysis, and promotional spend analysis. The analytical reports were primarily utilized by the Business Planning, Sales and Marketing departments for effective decision making and formulating strategies for business growthConceptualization of projects to build analytical models, dashboards and presentations for tracking performance indicators of brands, sales force, departments such as sales trend analysis, market share, sales growth, share of voice and promotional spend study based on MS-Excel, VBA, MS-Access providing business insights to our On-shore partnersGathering client requirements, business needs and project objectives with comprehensive documentation and developing dashboards based on different KPI’s using advanced MS Excel and VBAOne of the few selected members for onshore visit to GSK House, London to undergo a training of a new tool to track medical representative’s performance and impart the same to an offshore teamTransition of various reports from onshore team to GSK Knowledge Center and mentoring team members

M.B.A. - Business Leadership Program

Bachelor Of Business Studies (B.B.S.), Management