NEEMA MELAYIL

Cell#: 703-***-****

Email: admw06@r.postjobfree.com

•8 Years of Total experience in Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms

•Having 5+ years of experience in Tableau Desktop 8.1/9.2/9.3.6/2018.3/2019.1/

2020.3, Tableau Server and 3 years of experience in

SAP SD (ECC 6.0, 5.0 R/3) and Microsoft Dynamics CRM combined.

•Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

•Experience in using Tableau functionalities for creating different Filters, Actions, Charts, Interactive dashboards with Page and dashboard Prompts.

•Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.

•Involved in troubleshooting of performance issues which were associated with Tableau reports.

•Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.

•Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

•Worked on Data blending, Cross DB Join and increased the dashboard performance by extracting data.

•Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps, Overlapping Bar graphs, Bullet graphs, Donut chart, Word cloud and Highlight tables.

•Provided Production support to Tableau users and Wrote Custom SQL to support business requirements

•Experience in Developing visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.

•Experience in developing dashboards with multiple data sources and performing data blending

•Worked on database systems like Oracle 9i/11g, SQL Server 2014/12.0, Amazon Redshift

•Knowledge in Alteryx for creating the extract and publishing to the server.

•Utilized Tableau server to publish and share the reports with the business users.

•Interacting with client and collect business requirements, prepare functional Specifications, understand their reporting needs and good knowledge in Business Process Flow

•Knowledge in Tableau integration with R for deep statistical analysis and R functions

•Working knowledge of different types of Sales Documents, Delivery Documents, Item Categories, and Schedule Line Categories, SAP SD Queries.

•Worked for overseeing the company's requirements, development, testing and deployment of Microsoft CRM projects.

•Highly motivated, Goal oriented Team player with good communication, presentation, analytical and interpersonal skills.

EDUCATIONAL QUALIFICATION

Bachelor's degree

B.TECH in Electronics and Communication Engineering from MES College of Engineering, Calicut University, India, June 2009

TECHNICAL SKILLS

BI/Visualization Tools : Tableau Public, Tableau Desktop 8.x,9.x,10.x,

2018.x,2019.x,2020.x Tableau Server,Power BI

ERP/CRM Tools : SAP SD R/3 4.6C, 4.7, ECC 5.0, 6.0, Microsoft Dynamics

RDBMS : MySQL, Oracle, SQL,Amazon Redshift

ETL tools : Tableau Prep,9.1,Alteryx Designer 10.6.

Programming Languages : C, C++

Tableau Public Profile: https://public.tableau.com/profile/neema.melayil#!/

PROFESSIONAL EXPERIENCE

Johnson and Johnson

Trenton,New Jersey

Tableau Developer

Nov 2019-Present

Implementation Partner:Sogeti USA

Project: Non-Personal Promotions Analytics

Responsibilities

•Involved in reviewing business requirements for the Project NPP and analyzing data sources and building custom SQL queries to prepare the required data from different data sources

•Pulled 28 Views from the Schema that was present in the Amazon Redshift to create the Extracts.

•Created 28 Dashboards for the 28 Data sources and also involved in designing Homepage that will navigate to the Dashboards

•Design and Developed Dashboard visualization that involve Line Chart to show Trends, Tabular Chart for Brands, Vendors associated with the datasets.

•Prepared dashboards using Calculated fields to get the Rolling 24 Months Data

•Generated Dashboards with Quick filters, Parameters and Actions to handle views more efficiently

•Created Dashboards by creating Filter Actions and URL actions using Field and Filter Values in URL actions

•Applied Actions for Home button to navigate the Trend Reports to the Landing Page.

•Create Dynamic Measures Selection in the Viz. by creating Calculated fields and Parameters.

•Worked on Web Authoring to create Self Serve Report so that user can create their own report and save it in a particular Location

•Designed Homepage in such a way that Users can navigate to the Trend Reports, Self Serve and Self serve saved reports.

•Formatting the visualization by following Best Practices for Designing Views and Dashboards using Color legends, Custom tooltips, Highlighting to have the all 28 Dashboard Consistent.

•Taking Care of Tableau server tasks: Published Data Sources, Trend Reports, Home Page, Scheduling reports as per user requirements,Scheduled Extract Refreshes,Prioritised the refreshes and monitoring server activities.

•Involved in Testing, Migration, Production Support also done the Documentation.

Environment: Tableau 2018.3, Tableau Prep Builder,SQL Workbench, Amazon Redshift.

National Institutes of Health (NIH)

Maryland

Oct 2017-Nov 2019

Tableau Developer

Project: NIAID – Grants Management

Responsibilities

•Responsible for understanding user requirements, creating custom SQL by understanding data flow and Database design, Developing Tableau visualization and data testing.

•Created Dashboards visualization to oversee the current budget for all initiatives and projects across all missions, divisions and mechanisms.

•Developed new reports and made enhancements to the existing Grant Management reports, which are used by the NIAID budget office to manage, monitor and keep track of grants .

•Design and Developed Dashboard that involve Bar graph, Pie chart, Line, Stacked Bar,Bubble chart and Detail reports using Tableau Desktop.

•Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau.

•Worked on a report which provides complete fund control capability for the NIAID budget by providing a complete picture of available funds and expenditures at any given point of time.

•Generated Dashboards with Quick filters, Parameters, sets and Actions to handle views more efficiently

•Worked on an EOY report which is heavily used during the end of fiscal year, which helps Budget and Grant management to close the budget books for the Fiscal Year.

•Formatting the Dashboard by following Best Practices for Designing Views and Dashboards using Color legends, Custom tooltips, Highlighting.

•Created multiple visualizations for special projects to help the Budget office team to track fund distribution.

•Used Alteryx for creating the extract and publishing to the server.

•Used Sample tool,Multi row formula tool and Transpose tool in Alteryx to create tde file

•Taking Care of Tableau server tasks: Publishing reports, changing data sources, Scheduling reports as per user requirements and monitoring server activities.

•Worked on database tools to understand data and create an effective custom SQLs to improve tableau report performance.

Environment: Tableau 9.2.9,Alteryx Designer 10.6,MS SQL server, Microsoft Excel 2013

Enterprise Software Solutions Lab

Bangalore, India

Feb 2014 to April 2015

Tableau Developer

Responsibilities

•Analyzing the Customer Data and interaction with business analysts/users for requirement gathering

•Involved in reviewing business requirements and analyzing data sources and building custom SQL queries to prepare the required data from different data sources

•Created Data Extracts using Filters and Custom SQL queries and Edit the Data source filters as required to extract the data

•Design and Developed Worksheets/views that involve different charts Bar chart, Donut chart, Map reports.

•Created interactive Dashboards by creating Filter Actions and URL actions using Field and Filter Values in URL actions

•Created Insurance information Worksheets for GSK Vaccines Reimbursement support center

•Generated high detail-oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geocoding

•Utilized Advance features of Tableau like Calculation fields, Parameters, Reference lines, Understanding the data fields by changing Data types and Field properties

•Building the Data viz. by creating Groups, Sets, Filters, Quick Filters, compare multiple measures using Blended and Dual axes, Organize the Data Window by creating Hierarchies and Folders.

•Experience in developing dashboard by creating custom hierarchies for drill down analysis.

•Create Dynamic Sorting of Measures in the Viz. by creating Calculated fields and Parameters using Integer and Logical Functions

•Developed storytelling dashboards in Tableau Desktop and Published Dashboard, Worksheets on Tableau Server which allowed end users access the data views

•Extensively used analytical features in Tableau like trend lines, forecasting in many tableau reports

Environment: Informatica Power Center 9.1, Tableau 8.0, SQL, MS Access, MS Excel

Enterprise Software Solutions Lab

Bangalore, India

April 2013 to Feb 2014

Tableau Developer

Responsibilities

•Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

•Preparing Functional design document, Requirement document and Technical design document for reports.

•Developing data models to create reports and Dashboards.

•Developing Worksheet using Parameters, Calculated fields, Groups, Sets and Hierarchies.

•Developing Tableau Dynamic Report Design Using Parameters

•Created ad hoc reports to users in Tableau by connecting various data sources.

•Handled Tableau admin activities granting access, managing extracts and Installations.

•Published Workbooks by creating user filters so that only appropriate teams can view it.

•Analyzed the source data and handled efficiently by modifying the data types.

•Used excel sheet, flat files, CSV files to generate Tableau ad hoc reports.

•Generated context filters and used performance actions while handling huge volume of data.

•Generated tableau dashboards with combination charts for clear understanding.

•Prepare daily status reports, Weekly status reports and Task completion reports.

•Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

•Creating rich Dashboards using Tableau Dashboards and applying actionable insights

•Environment: Tableau 8.0, Oracle, SQL, MS Access, MS Excel

SS ERP Research Foundation

Nicholas Piramal India Ltd

Bangalore, India

March 2012 to Feb 2013

Functional Consultant SAP SD

Responsibilities

•Understanding business process, study and analyze workflow to design solutions

•Worked on Partner determination for master data as well as Sales document level.

•Configured Pricing Procedure depending upon the Sales Document Flow.

•Configured Customer Card

•Configured Output and Material Determination

•Given training to the end users.

•Environment: Implementation (SAP SD R/3 ECC 6.0)

Eicher Motors Limited

Bangalore, India

Functional Consultant SAP SD

April 2011 to March 2012

Responsibilities

•Handling Sev1, Sev2, Sev3 and Sev4 SAP tickets in line with the SLA timelines set by the client

•Conversion of HD Tickets to Change Tickets if configuration required

•Monitoring Remedy Tool and ticket assignment to concern team

•Identification of Root cause to reduce repeated tickets and document preparation maintenance

•Worked with ABAP programmers in Giving Functional Specifications for Preparing Reports and Developing Enhancements

•Integration with MM and FICO on Creation of Third party Order Processing.

•Preparation of FSD and TSD

•Maintaining weekly Tracker

•Query generation as per the User requirement

•Environment: Support (SAP SD R/3 ECC 6.0)

Wheel India Ltd

Bangalore, India

Functional Consultant CRM

June 2010 to Apr 2011

Responsibilities

•Implementation of custom MS Dynamics CRM plug-ins and workflows.

•Development of various CRM-related scripts and utilities.

•Extending Microsoft Dynamics MS Dynamics CRM Functionality through the SDK.

•Creating SSRS reports for sales and financial data using joins and pivot tables.

•Leading client training and participating in solution demonstration efforts- Providing expertise in integration of third-party solutions into the Microsoft GP platform

•Understanding business process, study and analyze workflow to design solutions

•Configuring the Sales and Marketing Module as per the Business Process Requirements.

•Configured Pricing and Discounts.

•Customization of Dealer records

Contact this candidate