Nagarjuna Vantala

Experienced Engagement Manager with proven skills in data analysis and modeling, risk assessments and utilization management. Talented project manager, team leader and rollout coordinator. A BI Reporting Specialist with 10+ years of experience in Business Analytics, BI Solution Development, Data Visualization, Data Analytics and Business Support activities. Proficient in Implementation of end to end analytic solutions using any BI and Reporting tools.

LAUNCH PEROFRMANCE

An analytical solution built for a emerging pharma client to enable their dale sand marketing team with the insightful data in US region.

• Field Dashboards: iPad application for pharma sales reps to track their performance and activity (Datasets Used IQVIA, Veeva, MMIT)
• HQ Dashboards: Web application for home office users to track sales performance (Datasets Used Cardinal Integri Chain, PRC , Veeva, MMIT)
• Marketing Dashboards: Web application for marketing team to analyse their campaign performance (Datasets Used Google Analytics, Adwords, DCM, Facebook, Bing, Biopharm, Deepintent, DoubleVerify)

IRP MANAGEMENT TOOL

Created a portal based out of ClicData and Power BI which enabled pharmacy managers/controllers to submit product inventory and quantity sold on weekly basis.

• Built summary report for leadership to provide visibility into the weekly sales and inventory available at various pharmacies
• Created a dashboard to show credit line information along with current payment dues
• SAM and Pharmacy user will have slightly different view based on security
• Field Dashboards: Power BI based mobile application for pharma sales reps to track their performance and activity
• HQ Dashboards: Power BI based web application for home office users to track sales performance
• Executive Dashboards: Power BI and ClicData based web application for C-level executives to see overall performance of newly launched drug
• IC Dashboards: Power BI based iPad application for sales reps to track their quarterly Incentive Compensation based on different plans

COMPARE.COM

Compare.com came about out of a desire to make finding the best price on car insurance a much easier, much quicker process. Our team started reaching out to car insurance companies throughout the U.S. and the response was encouraging. Today, we work directly with multiple national and local car insurance brands to bring you the best prices in car insurance.

• Implementing SSIS ETL process for refreshing LOB Databases from OLTP system to DWH server.
• Implementing of XML shredding process for data loading into staging system.
• Extracting data from multiple sources like CSV and SQL server and transforming, cleansing, validating data and loading into DWH Destination.
• Creation of Stored Procedures, Views and writing T-SQL queries.
• Writing the SQL Queries for contests as per the requirements and optimizing of Stored Procedures.
• Developing and demonstrate POC on ETL strategies.
• Creating packages using SQL Server Integration Services and transformations like Slowly Changing Dimension, derived column, conditional split, aggregate, lookup, sort, merge join, union all, merge, and data conversion to load data into Dimensions and Facts.
• Scheduling the ETL Packages (Hourly, Daily and weekly) Using SQL Server Jobs and Monitoring scheduled jobs for failures.
• Interacting with Business Analysts and line managers for clear understanding of requirements for implementation phase.
• Deploying and generating reports on to the server using the Reporting Services Report Manager.
• Generated various reports with drilldowns, drill through, calculated members, and dropdowns from the cubes by connecting to Analysis server and SQL Server from SSRS.
• Developing Dashboards and workbooks using Tableau.
• Implementing business reports using SSRS and Tableau.

• Six Sigma Certified on the Month of Dec’16
• ITIL certified on the Month of Dec’17
• AGILE certified on the Month of Dec’18