Nijo Jose

** ***** ***, ******** ********, NJ ***52

ac8ewd@r.postjobfree.com

804-***-****

PROFESSIONAL SUMMARY

More than 5+ years of experience in Business Intelligence development, using applications including Tableau and SQL Server BI (SSRS, SSIS).

Excellent exposure in developing Tableau Reports for Olympic Management Systems (OMS) Application.

In-depth knowledge on Tableau Desktop and Tableau Server in various versions of Tableau 10.4, 9.0, 8.0 and Tableau 7.

Experience in Business Analytics, Business Intelligence, Data visualization, Data Analysis, Design, Development, Implementation and Testing of Data visualization and Tableau architecture.

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

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

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

Experienced in Tableau support across enterprise (Dev, Staging and Production), troubleshooting, report design and monitoring of system usage.

Very Good Understanding and Experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.

In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment

Strong working knowledge in software development methodologies like Agile, Waterfall across the span of various projects

Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Team player, motivated, able to grasp things quickly with analytical and problem-solving skills.

TECHNICAL SKILLS

BI Tools

Tableau Desktop 10.X, 9.X, 8.X, Power BI, Business Objects

ETL TOOL

Informatica Power Center

Language

SQL, PL/SQL, Teradata

RDBMS

SQL Server 2005, 2008, Oracle 9i, 10g,11g

Scripting Language

XML, CSS, Java Script, AngularJS

Development Tools

Microsoft Visual Studio .NET 2005/2008/2010

Operating Systems

Windows 7, 8,10/NT/2000/XP/2003

Programming Languages

VB, .Net, Java, Python, C++, R

UX design tools

Sketch, Zeplin

Data Modeling Tools

ERwin r7.1/7.2/7.3/8.0

Networking

Ethernet, TCP/IP, VPN, LAN/WAN

PROFESSIONAL EXPERIENCE

Jet Set Sports (Co-Sports), Far Hills, NJ

Tableau Developer/Administrator May 2015 – Till Date

CoSport, a subsidiary of Jet Set Sports is one of the leading providers of Olympic hospitality packages. CoSport has the rights to market and sell consumer hospitality and premium ticket packages, individual tickets and hospitality management services in Australia, Austria, Bulgaria, Canada, Norway, Sweden, the United States and other EU/EEA countries.

Goal of the project was to have the details of all the orders and transactions. These reports were developed for Executive business management, financial and profitability analysis, Sales force management, Marketing Campaign and product analysis.

Responsibilities

Creates multiple reports for Olympic Management System such as Finical reposts, Guest Registration reports, inventory reports, general reports, etc.

Creates dashboards to showcase summary of package sold to individuals within one of the specific sales market channels. The sales are divided into one of the three currency values such as USD, EUR and AUD.

Develops clutter free Tableau dashboards for various product lines and departments

Created and implemented new data models to support evolving business

Creating Tableau dashboards according to the business needs.

Worked on latest versions of Tableau 10.x.

Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.

Created interactive data visualizations in Tableau, using relational and aggregate data source

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Uses advanced concepts - blending, LOD to meet the customer requirements.

Uses dashboard filter actions, forecasting, table calculations to meet user requirements.

Experience in setting up and using background image as Map

Works with the data architects and ETL team to finalize the data model and transformations for the data mart

Utilizes distribution services to create event based and time-based scheduled reports to deliver via email, history list and file devices, and made use of the bursting feature.

Performs administrative tasks including changing project configurations and creating DSNs, database instances, events, schedules, users, user groups and assigning security roles for the project.

Monitors user connections, caches, jobs and DSS logs to rectify issues.

Develops various SQL scripts and batch scripts to load files and to create tables and views for the BI layer.

Develops SQL scripts and reports for the Centers for Medicare & Medicaid (CMS) Audit Reporting project.

Experienced in developing Web Services with Python programming language.

Performed data integrity checks, data cleaning, exploratory analysis and feature engineer using R and Python.

Formulated procedures for integration of R programming plans with data sources and delivery systems.

Worked on data cleaning, data preparation and feature engineering with Python including NumPy, SciPy, Pandas, Matplotlib, Seaborn and Scikit-learn.

Experience in working with SDLC methodology Agile Scrum.

Experience in maintaining Scrum Artifacts such as Product Backlog, Sprint Backlog, Burn down chart and Burnup chart.

Experience in facilitating scrum ceremonies and maintaining Scrum Artifacts like Product Backlog, Sprint Backlog, Burn down chart and Burnup chart

Solving P1 issues for the users in the production.

Ensure that the Installation, support and management of WebLogic within the environments are in line with corporate standards.

Lead a small team and worked towards the deadlines of the company.

Support JIRA Project Administration involving custom, complex projects, workflows, security schemes, custom fields, dashboards and reports configurations, JQL filters, Dashboards, Gadgets.

Implement a number of different data source types that allow customers to connect to different sources of data. Those data sources include connecting to Slack, Microsoft OneDrive, Microsoft Excel Online, and JIRA.

Fostered strong company culture using corporate chat tools such as Yammer.

Involves in the project for the conversion of all existing SSRS reports to Tableau.

Conducts code reviews and reviews meetings with end users and the QA team before deploying the reports/codes into test environment.

Environment: Tableau Desktop 10.5 Tableau Server 10.5, Microsoft SQL, MS Excel

SolutionsMax, Hyderabad, India

Tableau Developer July 2013 – Feb 2015

TrackNTraceMax CRM is an enterprise solution developed by SolutionsMax for handling the DGFT (Directorate General of Foreign Trade) compliance activities. The application is well-designed and flexible database architecture helps store required data right at the plant. Facility to create xml files (prospective solution for data flow to the central portal). On demand, uploads the management of data (Secondary, Tertiary and Aggregation before Sale or Distribution of drugs) to the central portal of Government of India.

Responsibilities

Solving P1 issues for the users in the production.

Ensure that the Installation, support and management of WebLogic within the environments are in line

Involved in business requirement gathering and designed functional Specifications.

Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.

Developed and maintained high level overview of the project and design flows using MS Visio.

Worked on Business Intelligence standardization to create database layers with user friendly views in oracle that can be used for development of various Tableau reports/ dashboards

Created, published customized interactive reports and dashboards using Tableau.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Effectively used data blending feature in tableau and defined best practices for Tableau report development.

Administered user, user groups, and scheduled instances for reports in Tableau.

Executed and tested required queries and reports before publishing.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.

Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.

Provided support for Tableau developed objects and understand tool administration.

Created Custom Hierarchies to meet the Business requirement in Tableau.

Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.

Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0

Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

Environment: Microsoft SQL Server 2005/2008, Management Studio, Database Engine Tuning Advisor, Dynamic Management Studio, SQL Profiles, Microsoft Outlook 2003/2007, DBCC and DMV, Windows Server 2003 and 2008

ACADEMIC PROJECTS

Jan 2013 - May 2013

Agile Testing for CRM at Amisoft

Oct 2012 - Dec 2012

Website building for Portal Training using JSP and MySQL

EDUCATION

Bachelor’s in computer science and Software Engineering – Vinayaka Mission’s University, INDIA, 2013

Contact this candidate