Sanjay Bagga, Cbap®, Pmp® Email & Phone Number

Ch

In summary, I am working at the intersection of data analytics, user experience, and product development by brainstorming and designing applications and BI reports through analysis of multinational premiums and claims data. I am leading projects and development activity by partnering with the product leads to define the product roadmap, and with Multinational management to design scalable IT solution. Drive analytics capability through our current business intelligence tool set, using the DevOps best practices.

Plainsboro, New Jersey, Us

Teaneck, New Jersey, Us

- Partnered with stakeholders from Property and Casualty teams to drive continuous improvement in gathering & aligning business requirements and IT requirements to provide better and more efficient financial reporting of monthly, quarterly and annual premium and claims activity- Worked with the actuaries to understand the risk profiling process of a geocoded location and development of the predictive models for pricing and risk assessment, mapping then on a geospatial graph to expose the locations with higher risk, hazardous neighborhoods and loss history, using SSIS and Machine Learning algorithms to map the insured location of a new claim to an already geo coded location in the database- Compiled the existing pricing models for Home and Auto in SAS and developed the relevant modeling variables and the regression models, producing the same output in Python- Decoding the logic underneath the multiple macro layers of SAS models and deciphering the business rules embedded in the variable creation modules, using structured and non-structured set of data in Python - Analyzed an integrated portfolio of 122 reports for Global Finance to augment decision making with data analysis of Premium and Claims data- Defined requirements to allocate US IBNR, to report incurred loss ratios, needed to report gross profitability, retained vs lost business growth, for accurate producer commission payouts, for USD 20+ Bln annual premiums.- Lead and manage offshore development team while helping them in understanding requirements and getting solutions delivered on-time with maximum business value

Teaneck, New Jersey, Us

- Lead a team of 15 Analysts and senior associates to deliver on-time and correct deliveries meeting an annual SLA of 98% for errors- Coordinated with business stakeholders and onsite delivery team to align expectations with requirements and finished products and solutions for projects involving IT operationalization using internal and external data of Environmental business- Designed cognizant proprietary tools such as a BUSINESS INSIGHTS GENERATOR, which can be used on any data to automatically generate key observations and insights on seasonality checks, market events, geography change, peaks and troughs, variations due to natural causes, promotional response, and competitor analysis, using SQL, SAS, MS Excel and Tableau- Developed dashboards to provide insights into sales growth & pattern, using analysis techniques - 6v6 trend, cyclic trends, behavioral trends & forecasts- Tracked the activity across various sales and distributions channels – Customer Reps, Telemarketing Reps and Digital Media by massaging and analyzing sales data in SQL Server and forecasting future activity using various techniques such as moving average, weighted score, ANOVA, outlier analysis, correlation, principal component analysis, z-test, t-test, etc.

Teaneck, New Jersey, Us

- Responsible for data processing involving querying of enterprise data, multidimensional slicing and dicing, analyzing Life Sciences data at different levels, using SQL and ORACLE tools- Gathered and analyzed user requirements to automate or improve existing systems and review workflow and scheduling limitations- Handled QA and QC of each deliverable, optimized sample allocation which involved analyzing and experimenting with data to calculate samples to sales ratio and decile information, thus assigning optimum number of samples that should be given to each physician- Analyzed and forecasted sales for digital marketing channels by processing large chucks of data, defining KPIs and building leadership dashboards- Developed dashboards to provide insights into sales growth and pattern, using forecast and trend analysis techniques 6v6 trend, cyclic trends, using SQL

Zug, Ch

- Responsible for performing consumer migration analytics, involving studying a specific market channel, clustering and correlating multiple prospects attributes, such as portfolio reach, multi-brand reach, forecasting consumer behavior, in order to provide better targeting and improved promotions. - Developed and designed business and data analytics dashboards and 200+ auto-executive summaries using SQL, Toad, SAS and Excel. - Analyzed Churn/Attrition Rate by performing root-cause analysis that lead to customer attrition, assessed opportunities to cross-sell/up-sell, and identified ‘White Spaces’ by evaluating opportunities that explore into areas adjacent to but outside the traditional business boundaries - Fostered a community of analysts within Custom Insights & Analytics, by sharing best practices and mentoring other analysts

Bangalore, Karnataka, In

- Gathered, analyzed and documented functional requirements, executed assignments in cleaning, de-duping and polishing data that require multiple SQL queries and procedures to extract the data using SQL developer- Developed code and reviewed functions for upgrade of ERP system (EBS) from 4.6 to 6.0- Optimized modules that were built on SAP ABAP by automating the code run, sharing best practices and mentoring other analysts, which lead to 70% reduction in run time

Master Of Business Administration, Finance, Marketing, It

Bachelor Of Technology (B.Tech.), Information Technology

Senior School