Charanpreet Singh Email & Phone Number

• Worked with over 20 clients to provide data warehousing and CRM, Marketing automation, & lead nurturing• Build one of the largest data clusters in AWS that stores Covid testing and vaccination data for over 20 countries• Provided dashboards to monitor testing and vaccinations on daily basis• Worked with clients to build online tools for collecting leads and then channeling the leads to the right call center• Wrote APIs to connect most of the major SAAS systems currently in the market• Build database designs for over 10 startups ready to be scaled as they grow• Automated most of the redundant tasks to free up resources • Implemented InfusionSoft, Salesforce and Tableau instances for clients to automate marketing processes for qualifying leads and reporting . Automated sales funnel to nurture clients’ customers through each stage of the sales process, from warming up of cool leads to identifying when leads are hot• Developed and strategized email marketing campaigns to keep brand in front of the client’ customers• Built custom integrations with automated webinar software like webinarjam and automated texting and calling using apps• Deep analysis of digital data and recommendations for improvement• Custom dashboards, PowerPoints and reports provided on regular basis

Irvine, California, Us

• Developed an enterprise wide business intelligence framework that provided the appropriate tools and knowledge to optimize evidence-based decision-making• Responsible for the direction and oversight of analytics/reporting to support sales, marketing, financial, clinical, product development, and business strategy• Understood both internal and external stakeholder needs and anticipated questions and prepared solutions to address needs• Lead cross-functional team in developing and maintaining mid to long-range strategic road maps, created business cases, competitive analyses, and drove program alignment across multiple departments from inception to implementation• Translated strategic vision and road maps into executable programs and lead team in realizing successful implementations• Built up the data infrastructure and domain, developed reporting resources as well as performed ad-hoc analysis, scorecards, and KPIs• Developed and presented to multiple levels of senior leadership, cross-functional groups, peers, and functional groups of associates in support of special projects, strategic initiatives, and KPIs• Collaborated with internal stakeholders to create business plans and overcome challenges• Developed talent on the team to provide best-in-class capabilities. Met regularly with team members, hold their hands when needed while giving them enough independence and responsibility. Also was responsible for reviews and performance management.

Newport Beach, Ca, Us

• Research and analysis of the company’s markets, competition, and product mix• Conducting research studies on new market areas and future market conditions• Analyzing competitive environment, market penetration, market potential, and future trends• Performing analysis in the areas of product preferences, sales coverage, market size, competitor assessments, marketing practices and trends• Researching market conditions to determine potential sales of products or services.• Gathered data on competitors, analyzed their strategies, price, sales, and operations methodology.• Collected and maintained information on preferences of prospective customers and competitors.• Assisted in analyzing future products and recommendations for new products or services.• Compiling and analyzing statistical data on past sales and trends to forecast future trends.

Irvine, California, Us

• Implemented CRM (Infusionsoft), Tableau cloud, designed campaigns with automated texting, calling to qualify leads• Implemented Hubspot to track leads for in-house call center• Built IT Infrastructure, Data Warehouse and BI and Dashboarding tools (Tableau)• Designed and built predictive models in Tableau like customer churn model, forecasting model, predicting next order• Designed and built complex reports and visualization in Tableau• Analyzed data findings, determined data trends, projections, visualizations and made recommendations• Provided visual insights to management regarding market, physician, practice dynamics and patient• Continually scanned news data outlets to acquire knowledge on the market, physicians, funding, and competition• Regularly assessed competitive share of market and reports to management• Developed financial forecasts and assisted in forecasting market size with VP of marketing• Developed reports on key patient portal utilization, practice portal metrics and customer/patient satisfaction metrics. • Sourced and interfaced with third-party vendor outside of existing group, regarding surveys and market research

Washington, District Of Columbia, Us

• Responsible for development, management, maintenance and production of reporting and analysis systems • Developed and enhanced reporting solutions for sales staff and senior management• Collaborated with multiple departments to address analytical requirements for the execution of strategic initiatives• Analyzed campaign/promotions/events performance and assess incremental impact to business• Provide qualitative and quantitative business insights using data to drive business decisions• Develop, improve, and automate processes to create time saving opportunities to reduce non-value add work • Develop relationship across all operating companies and shared best practices with analysts and managers• Lead and partner on analytics projects by translating business questions/problems into structured analysis• Develop strong collaborative working relationships with key decision makers and functional groups across globe

San Diego - Us | Tokyo - Jp, Us

• Provided comprehensive reporting, analytical services to service and operation teams• Designed and developed standard reports and dashboards to monitor warranty and service performance• Develop hypothesis-driven analysis and statistical models to identify trends and key drivers in customer behavior• Worked with engineering teams to improve existing reports and automate operational reports• Prepared trend analysis and provided perspective on emerging trends and growth areas• Provided analysis to facilitate decision making and formulate strategic direction• Completed ad-hoc financial analysis and modeling for special projects and transactions• Trained and Motivated group of Analysts to perform job successfully

San Diego - Us | Tokyo - Jp, Us

• Responsible for managing and updating Sony’s Repair, and Survey database• Created and customized drill down reports using pivot tables and pivot charts in Excel and Access• Recovered costs for up to $500,000 every month by analyzing data and billing manufactures for recall issues• Responsible for bringing automation by writing VB Script and creating Macros for existing spreadsheets• Created queries in SAP business objects to extract data to be used for analysis

San Diego, Ca, Us

Assisted as GA and helped up to 50 students in a single semester

Worked in a team to build a model to assess customer's likelihood to purchase company's new productsAssisted project manager to study the impact of economy on company's sales trends

Lead a team of 5 to built a 4 bit ALU circuit simulation program using verilog hardware digital languageRecognized for excellent performance and finishing up project before authorized time

Masters Of Business Administration, Finance, Econometrics And Statistics

Bachelor Of Technology, Electronics & Communication Engineering