DIPTAVO GOSWAMI

Email: adyruw@r.postjobfree.com

Mobile: +91-983*******, +91-798*******

Experience Summary

1.Having 13+ year of experience in Data Analysis with Telecom, Print Media, Retail, IT and Pharma.

2.Proficient in Business/Data Analysis, Campaign Management, Dashboard and MIS reporting.

3.Experience in Client Handling, VBA, SQL, Advanced Excel, visual reporting by Power BI.

Professional Qualification

Master’s in computer application (MCA) from West Bengal University of Technology

Technical Skills

Databases: Oracle SQL, MS Access, MySQL

Reporting/Dashboard Tools: Power BI, Tableau, Advanced Excel, MS Office Suite

Work Experience Details

1. Organization: True Blue LLP

Duration: Jan 2022 to present

Technologies and Tools: VBA, DTM Assist, SQL, Advanced Excel

Profile Summary: Service Delivery Engineer (Client is DELL Technologies)

Job Details:

Working as a team member in the FedEx project:

1.Weekly Consolidated Reports generation: Using DTM Assist and SQL

2.Automation using VBA of the weekly reports and adhoc reports

3.Maintaining Access database of all applications and their dependencies

4.Creating and maintaining packages with dependencies between apps and assets in DTM

2. Organization: Teamlease Digital

Duration: 1 year 6 months (Apr 2020 to Nov 2021)

Technologies and Tools: VBA, Javelin Incentive Manager, Flexview, IMD Dataview

Profile Summary: Data Consultant (Client is Novartis)

Job Details:

Working as a team member in the following projects:

1. Austria Sandoz: Month End Reports and Dashboard for 1A, Hexal & Sandoz BU

2. Eligibility Calculations for France Pharma – Trimester process

3. Sales Crediting for France Oncology – Monthly process

4. Incentive Calculations for France Oncology – Monthly process

5. Qualitative Bonus Calculations Pharma – Annual process

6. Meaningful Interaction Reporting for Top 11 countries – Monthly process

7.Automation of incentive workbook for QC and date conversion in correct format from source files

3. Organization: Datamatics Global Services

Duration: 5 Months (Sep 2019 to Feb 2020)

Technologies and Tools: MS Excel, SQL

Profile Summary: Senior Consultant (Client is DELL EMC)

Job Details:

1.Coordinating with Clients for approval and facilitate the scheduling process

2.Automation of excel reports using VBA and MS Access

4. Worked as a Freelancer

Duration: Aug 2018 to Sep 2019

Technologies and Tools: SQL, Advanced Excel

1. Worked as an online & offline faculty on statistics, data analysis and data management.

2. Data management project using SQL and Excel.

5. Organization: SAHAJ E Village Ltd

Duration: 10 Months (Sep 2017 to July 2018)

Technologies and Tools: BI Solutions, MySQL

Profile Summary: Business Analyst

Job Details:

1. Working with various LOBs and Transactions; Revenue Calculation from various states.

2. Finding variance between monthly targets and actual revenue.

3. Calculating incentive payouts as per the schemes for the sales team.

4. Creating minutes of the meeting during review and other internal meetings.

5. Preparing business data for the CEO.

6. Organization: ABP Pvt Ltd

Duration: 2 Years 4 Months (May 2015 to Sep 2017)

Technologies and Tools: SAP Reports, Power BI, MySQL, Excel

Profile Summary: Asst Manager Circulation

Job Details:

1.Extracting Monthly and daily sales, supply, and subscription data from SAP ECC & CRM modules for both trade & subscription.

2.Agent wise performance tracking and gap analysis.

3.MIS Reports and dashboards are created for Fresh Acquisition, Lapse, Renewal, Active Base etc.

7. Organization: Netxcell Pvt Limited

Duration: 3 months (March 2014 to May 2014)

Technologies and Tools: Query Builder, GreyBox- Campaign Management Tool, Excel.

Profile Summary: Campaign Manager

Job Details:

1. Revenue and Base Analysis of the campaigns daily via MTD and LMTD data.

2. Designing Campaigns for Aircel MUMBAI/Maharashtra using the Greybox tool.

Designing logic for the campaigns, given by the client using query builder and generate the target bases.

8. Organization: VODAFONE South Limited

Duration: 5 years 3 months (October 2008 to January 2014)

Technologies and Tools: Tableau, SQL, SAS Report, Oracle DB, Advanced Excel

Profile Summary: Marketing Data Analysis, Data Management and Reporting

Job Details:

1. Data Management: Extract data from remote Data Warehouse (Teradata SQL Client) using Teradata SQL Assistant (TSA) tool. Export and load the dumps to Oracle database using SQL Loader. Maintaining and tracking different transactions on daily/weekly/monthly tables in system database.

2. Report through BI Tools: Daily & monthly reporting for the business KPI’s like ARPU, Based Churn, Promotions via SMS, Acquisition & Retention of the subscribers on daily basis using Power BI, Cognos and SAS reporting tools.

9. Organization: Simplex Infrastructures Limited

Duration: 2 years 5 months (March 2006 to August 2008)

Technologies and Tools: Oracle10g Developer Suite, Oracle 10g Database

Profile Summary: Oracle Developer

Job Details:

1.Oracle 10g Developer Suite Programmer

2.PL SQL Programmer (Packages, Procedures, Functions, Triggers)

Academic Qualification

1. Completed MCA with 80% from West Bengal University of Technology in 2005.

2. Completed graduation (B.SC) with 55% from Calcutta University in 2001.

3. Completed Higher Secondary with 62% from C.B.S.E in 1998.

4. Completed Secondary with 75% from C.B.S.E in 1996.

Personal Details

Date of Birth: 04th April 1979

Father’s Name: Mr. T. Goswami

Languages Known: English,Hindi,Bengali

Marital status: Married

Home Address: 30 Narendra Nagar, Belgharia, Kolkata 700056

LinkedIn Profile: - https://www.linkedin.com/in/diptavo-goswami-76a83366/

(Diptavo Goswami)

Contact this candidate