Vivek Makan

• Responsible for Data, Analytics and Workforce management functions within the New Customer Engagement (NCE) function. Managing Member Sales/Claims Data across the MHA portfolio and created a central function within Operations to manage the following aspects of the customer life-cycle; Applications, Decision Making, On boarding, Engagement and Retention.
• Leading a global team of data analysts, data scientists, data engineers, business analysts and data visualization specialists.
• Driving business strategy with data-driven insights derived techniques ranging from ad-hoc reporting to advanced customer analytics.
• Optimizing the omni-channel customer on-boarding experience by identifying customer pain points, driving self-service adoption and increasing engagement.
• Lead the entire Cloud (Azure) Migration including 100+ servers and related applications. Creating Data Pipelines in Azure Data Factory to get data from multiple sources into Azure BLOB storage
• Managing data integrity team and data certification process for Originations, as part of firm-wide data governance program.
• Increasing revenue by from under $200M to $250M over a period of three years.
• Working on Next-Best-Action capability to optimize the customer experience across all interaction channels; Phone, Web, Mobile, Email and Branch.
• Founding member of the firms Big Data Analytics team setup to commercialize internal data and explore advanced technologies such as; Hadoop, Massively Parallel Platforms (MPP) and other analytical tools.
• Led a cross-LOB team to develop a cross-channel customer experience analytics platform with advanced behavior based segmentation (personas) to optimize call center operations.
• Designed solutions to enhance cross-sell/up-sell opportunities between Sales Teams and Contract Operations leveraged both market-basket analysis and product propensity modeling.
• Managing a Portfolio of Data & Analytics projects to ensure appropriate prioritization, resourcing, budgeting and business impact. Executing D&A strategy roadmap

• Simultaneously managed large initiatives in Marketing Analytics, Business Intelligence, Profitability, and Customer Relationship management, across Research & Sales divisions.
• Experience across the entire Research technology platform includes; client portals, document publishing & regulatory systems, client intelligence, financial modeling, and research outsourcing.
• Led the creation of the analytics team; Proficient in POWERBI Reporting, Azure SQL and Azure managed instances
• Managed a multi-skilled team of MHA business and technology employees and partner vendors such as IBM ,Talend, Salesforce.com and Microsoft to deliver a marketing platform that supports real-time resource allocation and targeted marketing.
• Led the division's exploration of text mining to derive client and market insights and the testing of big data platforms (Hadoop) for large scale modeling efforts.
• Built decision support system to provide data, capture insights, and deliver balanced scorecards with performance metrics that combine financial objectives with customer, process and employee perspectives.
• Centralized the business intelligence ecosystem from diverse data silos into a unified data warehouse.
• Established a data integrity team to manage and measure the quality of all data assets.
• Architect and engineered VPN Tunnel and Express Route for Hybrid Cloud
• Lead the strategic initiative to implement hybrid cloud, to cut technical debt by 85% in one year delivering RTO and RPO for 'Disaster Recovery' and 'Business Continuity'
• Collaborate with FP&A team for Cloud budgeting and expense reviews

· Managed primary distribution monitoring process known as the “Depletions” system which tracked daily inventory movements to and from distributors

· Implemented BI solution for different BU nationwide

· Creation, maintenance, management of all technical designs, blueprints, sketches, and drawings in compliance with ISO standards

· Implementing integrated technology-based solutions and identifying integration opportunities for a similar package of services.

Migrating to new technology platforms to better target customer health interventions and improve the usability of online portal platforms.

• Designed and built Emblem Health's Investment Data Analytic System (MIDAS) that ensures Analytics models conform to accounting and forecasting standards and generated $2mm p.a.
• Led the creation of analyst model-tagging tool and integration to a central data warehouse.
• Key Contributor to design phase of a 12 project to help complete the redesign of a business partner SQL server Data Warehouse
• Installation, Configuration and Administration of Cognos BI Suite- Single/Multi-Thread windows and Unix environments
• Generate large and complex data extracts for Analytical Data scientists by utilizing various database schema such as MS SQL server, Oracle and Netezza

• Led a multinational team to ensure Y2K compliance for BASF technologies. ♦ Delivered eBusiness applications to drive process efficiency.
• Oversaw the analysis

· management, and delivery of business intelligence solutions
with involvement in all stages of the development lifecycle.

· Established partnerships with stakeholders and conducted effective demand
management and prioritization of projects

· Responsible for data analysis, designing, developing, and testing reports in Cognos 11.x for the various disciplines within organizations in accordance with standard team processes

· Using the ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse.

· Led in SSIS development, upgrade to SSISDB. Financial process automation & report creation

Created SSRS reports (Tabular, Param, Cascade, Drill through, Sub, Matrix). Query Perf Tuning