Aug 2014 – Dec 2018 · 4 yrs 4 mos · Saket New Delhi · On-site

• Monitor and analyze insurance portfolios to inform business decisions, optimize risk management, and ensure regulatory compliance.
• _Key Responsibilities:_
• 1. Data extraction and analysis (claims, premiums, losses)
• 2. Portfolio performance monitoring (loss ratios, combined ratios, IR , persistency etc.)
• 3. Risk identification and assessment
• 4. Data visualization and reporting (dashboards, reports)
• 5. Regulatory Reporting
• 6. Business decision support (pricing, underwriting, reinsurance)

Jul 2011 – Aug 2014 · 3 yrs 1 mo

• Responsibility included analysis & reporting on online advertise accounts(Google Adwords ,google analytics,facebook , yahoo , display media & other advertising platform)
• Preparing Daily / Weekly / Monthly /Quaterly / Half Yearly ? Yearly reports for all projects basis of different-2 project metrics.
• Creating new format,dashboard & report automation using Advanced Excel , VBA , Macros & SQL Server.
• Managing all online advertising database in SQL Server.
• Create reports & analysis on online advertising data from various sources.
• Responsible for generating all internal and external reports along with the detailed analysis and accuracy.
• Worked on google analytics,google adwords ,yahoo bing , MSN online media tools
• Preparing account budgting forecasting & Media Performance Summary sheet for all project.

Jul 2011 – Aug 2014 · 3 yrs 1 mo

• Worked for Clients : - MaxBupa ,airtel ,Paytm ,Intuit , NetAmbit , Cleartrip , Bacardi , Apollo ,Benq India Homes etc..
• Responsibility : -
• ▪ Support Reporting Desk in all phases (reporting , Analysis, format designing, data analysis , planing, budgeting ,forecasting,report automation & technical support).
• ▪ Managing all internal & external reports (Daily / Weekly / Monthly /Quaterly / Half Yearly ? Yearly reports) for all projects.
• ▪ The report generation & report automation include extensive use of SQL and Macors ,VBA & Advance Excel.
• ▪ Pull and analyze reports on online advertising data from various sources (Google Adwords,Google Analytics,Facebook,youtube,Media Mind,yahoo,Media..etc..)
• ▪ Report on different types of engagement metrics and analyze performance across many sites. Combine data analysis and client feedback to configure, operate, and optimize complex campaigns to meet client objectives.
• ▪ Support in client review & project analysis of the team’s deliverables.
• ▪ Responesble for accuracy & timeline for entire reports.
• ▪ Analyzing different media platforms to understand media efficiency and ROI for individual clients.
• ▪ Producing charts and graphs and preparing presentations with analysis and recommendation commentary for management and client review.
• ▪ Support and drive automation and standardization of various reports / projects.
• ▪ Run and Develop Queries- SQL Server, Macros and VBA.
• ▪ Giving types of analysis - campaign ,keyword & Adgroupo level, device ,placement level, geographical analysis,Search query level analysis etc.
• ▪ Working on Google Anlytics for website & campaign level analysis include (organic ,paid ,Direct ,Refreal Traffic).
• ▪ Full fill the client and operation's reports requirements, Analyse the data trend,highlight point which are harmful for business.

Sep 2008 – Oct 2011 · 3 yrs 1 mo · Okhla,New Delhi

• Worked for Clients : - Seagate Technology(Asia Pacific, Australia,Newzeland, Taiwan or South Korea) , Kirloskar Brothers Limited ,Dominos Pizza,Reebok,Baja Discover India.
• Responsibilities:-
• Responsible for Analysing QOQ and YOY Sales Data (“Product and Region Specific”)
• Analysis on Distributors & dealers performance according his monthly, Qtrly, yearly transaction & tag the loyalty of Distributor & dealers.
• Managed Entire event & promotional activity Database.
• Data selection as per client requirement for event & any promotional scheme.
• Analysing on sales & survey database.
• Managed backend execution of Redemptions and relationship program.
• Design the database structure in MS Office & SQL Server.
• SQL Quaries writing , Creating updating ,using import & export wizard in SQL Server.
• Worked on reporting formats & report automation.
• Giving types of Report & Analysis of the various project.
• Responesble for accuracy & timeline for entire reports.
• Daily / Weekly / Monthly /Quaterly / Half Yearly ? Yearly reports
• Well versed with MS Office, SQL, and HTML Coding
• The report generation include extensive use of SQL and excel.
• Run and Develop Queries- SQL Server, Macros and VBA.
• analyse and managed large volumes of data
• Support in client review & project analysis of the team’s deliverables.
• Worked on weekly Demand Generation (DG) report for segate tech.
• Handled 8 people’s team & managing two data entry agency.

Sep 2008 – Apr 2010 · 1 yr 7 mos · Okhla,New Delhi

• Managing Entire Database for various projects.
• Daily / Weekly / Monthly /Quaterly / Half Yearly ? Yearly reports
• Data Cleaning , Data Formatting , Sourcing Database, Sorting Database, Dedupting Database.
• Management process Viz. Database Management, Database sourcing, profiling, email-fax blast,sending invite, handling Returns, reporting, daily updating of progress.
• Manage large volumes of data.
• Report desging and report automation.
• Database segmentation

Aug 2007 – Sep 2008 · 1 yr 1 mo · Gurgaon

• ARCIS-e is one of the Leading Companies engage in Sales, Collection, Credit Verifications, & Loan Processing for Citibank & Citi-financial.
• Updating yearly , monthly, weekly and daily reports for financial consumers durable & personal loan.
• Managed entire database.
• Created daily , weekly ,monthly reporting format.
• Worked on sales report for client.
• Worked on budging forecasting.
• Prepared sales & operation TAT Report on day to days basis.
• MIS for day to day productivity of work for consumer loan & personal loan.
• Worked on quality & accuracy report of Data Entry Operators, TVR Executives & Credit Officers.