Vba Excel

6 days ago


Thane, India WTW Full time

**Process Synopsis**

The R&A Ops team creates claims reporting tools & management reports using advanced Excel features as well as VBA coding. We create interactive models in Power BI that pull in data from data marts & make them available for use to the management. We also create projects in Oracle for use in time spent on each projects by colleagues worldwide

**Principal duties / responsibilities**
- Help the team in creating projects that are used by all Risk & Analytics (R&A) teams worldwide for time tracking
- Understanding data in terms of data availability for analytical reporting.
- Questioning data shortfalls with respective counterpart as required for analytical reporting.
- Cleanse the raw data as per SOPs
- Standardize the data sets so that they can be sliced/diced in any way required
- Using advanced excel features like slicers, nested formulae, macros to generate dynamic charts based on policy years and accordingly create macros to print those charts/graphs.
- Create automated standard or customized templates to reduce manual errors as well as speed up the turnaround times

**Education / Experience**
- Creating dashboards using visualization tools (Power BI experience an added advantage)
- B.Com / Pursuing CII (added advantage)
- Excellent written & oral communication
- Ability to read & comprehend information well
- Excellent advanced Excel and VBA programming skills
- Good analytical skills
- Able to work within a team to high standards in tight timelines
- Able to generate ideas or come up with logical solutions


  • Power Bi, Tableu

    1 week ago


    Thane H.O, Thane, Maharashtra, India Uni Entree Full time

    **Job Summary**: This role involves developing training materials, conducting hands-on training sessions, and providing ongoing support to learners. - Develop assessment tools to evaluate the effectiveness of training programs. Conduct assessments and provide constructive feedback to learners. - Weekend availability is necessary - Fluent in English One who...

  • Edp Officer

    2 weeks ago


    Thane, India Shikshadarpana Full time

    Process various forms for admission, test results, etc. - Manage and maintain previous & current data of students at the branches. - Analyzing data and make reports as per requirement. - Providing accurate and timely information as required. **Qualification, Skills and Experience**: - Graduate in any discipline with prior experience in desktop...

  • Junior Programmer

    1 day ago


    Wagle Estate, Thane, Maharashtra, India Vidatree TechnoVentures Private Limited Full time

    **Job Opportunity: Programmer with 1-2 Years of Experience (VBA Coding)** **Company**:Vidatree Technoventures Pvt. Ltd.** **Location**: Wagle Estate, Thane - Maharashtra, 400604 **Type**: Full-Time, (Monday to Friday WFO - Saturday WFH) **Experience**:1-2 Years** **About Us**: Vidatree is a dynamic and innovative company dedicated to delivering...


  • Thane, India Kotak Mahindra Full time

    Job Role: - Periodic extraction and publishing of MIS/Reports/Dashboard/Info graphs and Dumps - Ensure Data’s are provided to the top management on time and make certain the accuracy of data - Maintain Timely submission and circulation of Data to the stake holders of below mentioned data - Ensure data are provided for compliance and Audits and RCSA and...

  • Mis Executive

    3 days ago


    Thane, India O3Hire Full time

    **Responsibilities**: - Process various forms for admission, test results, etc. - Manage and maintain previous and current data of students at the branches. - Analyzing data and make reports as per requirement. - Providing accurate and timely information as required. **Requirements**: - Must know Desktop publishing(DTP) and Management information system...

  • Mis Executive

    1 week ago


    Kalyan D.C., Thane, Maharashtra, India Kohinoor Group Full time

    Dashboard Creation & Reporting - Advanced Excel Reporting - Coding & Automation: - Google Suite Integration **Skills & Qualifications**: - **Education**: - Bachelor’s degree in Computer Science, Information Technology, Business Administration, or a related field (Master’s degree preferred). - **Experience**: - 3+ years of experience in MIS...

  • Core Analytics

    1 week ago


    Thane, India WTW Full time

    **Process Synopsis** The Core Analytics-MATLAB team creates claims reporting tools & provides non actuarial loss data analytics across a number of LOBS, predominantly Workers’ Compensation. This is a 17 member team with a mix of skillsets that enable us to automate reports using advanced Excel features as well as VBA coding. We also support the actuaries...


  • Thane, MH, IN WTW Full time

    Description Understanding loss run claims data placement data in terms of data availability for analytical reporting Questioning data shortfalls with respective counterpart as required for analytical reporting Cleanse the raw data as per SOPs Automate processes using Python SSIS Standardize the data sets so that they can be sliced diced in any way...