Nijo Jose

Phone: 212-***-**** X-***

Email id: aczdy5@r.postjobfree.com

PROFESSIONAL SUMMARY

* ***** ** ** ********** in Software development and data warehousing using both ETL and BI Reporting tools.

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

3 Years of progressive experience in Tableau 8 & 9 versions for Business Analysis, Reporting and Dash-boarding for enterprise applications and experience on Tableau server side.

2 Years work Experience in using ETL Tool INFORMATICA.

Expertise in Reports and Dashboards that are published on the Tableau Server

Experienced and fully engaged in Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications and providing production support.

Experience in design and development of interactive data, data visualizations, graphical dashboards and reports using any tools like Tableau.

Extensive Knowledge on Tableau Desktop, Tableau Public, Tableau Reader and Tableau Server.

Experience in creating user, groups, projects on tableau server.

Handled Tableau server side for user permissions, grouping, scheduling reports

Scheduled data extracts and subscriptions on a daily basis.

Comfortable with advanced tableau topics such as complex calculations, table calculations, Filters, parameters, data blending, extract optimization.

Experienced in Designing & Formatting Dashboards using Tableau.

Good Understanding and experience related to BI/Data warehouse concepts

Good Hands on Knowledge of any ETL tool/Database and exposure to SQL.

Experience in working with data warehousing ETL Tool INFORMATICA.

Excellent skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Cursors, DDL/DML Triggers, Temporary tables, User Defined Data types (UDF) and Functions.

Experience in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, back-up/recovery, running Database Consistency Checks (DBCC).

Supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems.

Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.

Expert in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.

Proven track record in testing, quality assurance, and networking.

Working within an Agile cross-functional team with a Lean UX approach to deliverables.

Developing business requirements, dashboard development, and data verification and analysis

Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.

Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS

BI Tools

Tableau 8,9, Qlikview

ETL TOOL

Informatica Power Center 9/8

Language

SQL, PL/SQL, Teradata

RDBMS

Oracle 9i, 10g,11g

Web Technologies

ASP.NET, HTML, HTML5, AJAX, Web-Services.

Scripting Language

XML, CSS, Java Script, AngularJS

Database

Oracle, MS SQL Server, MS Access, DB2.

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++, Scala, Matlab

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, Far Hills, NJ

BI Developer (Tableau) March 2015 – Till Date

CoSport, a subsidiary of Jet Set Sports is one of the leading provider 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

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

Created dashboards to showcase summary of package sold to individuals within one of the specific sales market channels.

Collaborate with data architects for data model management and version control.

Created reports to show the marketing trend between the customers showcasing their trial programs and the timing of conversions. and also developed in-house reports for management decisions.

Worked with business unit managers to translate client requirements into technical specifications.

Created multiple reports for Financial analyzing like Credit Refund Report, E-commerce Daily Unsold Report, Accommodation Inventory etc.

Delivered reports to Business team on a timely manner.

Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboard using KPI's.

Installed Tableau Server 9.3 in Dev, QA, UAT and Prod environments. • Installed patches on the server and documented upgrade plan from tableau 8.3 to 9.1

Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.

Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.

Used Sheet filters to produce multiple chart types in a single view.

Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.

Designed multiple Dashboards, helping them to convert from manual reporting

Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.

Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues.

Implemented advanced geographic mapping techniques and used custom images and geo coding to build spatial visualizations of non-geographic data.

Updated, setting up, and configuring of Tableau Server for Data warehouse purpose.

Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.

Resolved end user reporting problems through collaboration with IT and Operations

Environment: Windows 7, Tableau 8,9 Tableau server, SQL Developer, SQL-PLUS, MS-Excel, SQL Server, SharePoint

ETS, Princeton, NJ Jan 2014 – Feb 2015

Role: Tableau Developer/Administrator

ETS works with education institutions, businesses and governments to conduct research and develop assessment programs that provide meaningful information they can count on to evaluate people and programs. ETS develops, administers and scores more than 50 million tests annually in more than 180 countries at more than 9,000 locations worldwide. We design our assessments with industry-leading insight, rigorous research and an uncompromising commitment to quality so that we can help education and workplace communities make informed decisions.

Responsibilities:

Interact with Business users and understanding their requirements.

Developing, Designing and supporting interactive Tableau Dashboard reports.

Recommending Dashboards per Tableau visualization features.

In addition to the above mentioned standard reports, business uses will request for adhoc intra-day reports which was also developed using Tableau.

Delivering reports to Business team on timely manner.

Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau.

Also developed in-house reports for management decisions.

Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Involved in migration Project of legacy reports to Tableau.

Designed multiple Dashboards with the help of tableau features like Sets, Parameters, Quick Filters, Actions, Bins etc.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Designed Story boards for better visualization.

Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues.

Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

Ensured projects were completed on time and within budget.

Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.

Handled Tableau server side for user permissions, grouping, scheduling reports

Scheduled data extracts on a daily basis.

Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.

Resolved end user reporting problems through collaboration with IT and Operations

Environment: Windows 7, Tableau 8.1, 9 Tableau Servers, SQL Developer, SQL-PLUS, MS-Excel, Oracle, 10/11g.

SolutionsMax Technology Services Pvt Ltd, India

Informatica Developer July 2012 – Dec 2013

TrackNTraceMax CRM is a 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 upload and management of data (Secondary, Tertiary and Aggregation before Sale or Distribution of drugs) to central portal of Government of India.

Responsibilities

Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.

Used reverse engineering in Erwin 4.x to understand the existing data model of the data warehouse.

Worked with creating Dimensions and Fact tables for the data mart.

Created Informatica mappings, sessions, workflows, etc., for loading fact and dimension tables for data mart presentation layer.

Have implemented SCD (Slowly Changing Dimensions) Type I and II for data load.

Did performance tuning of Informatica components for daily and monthly incremental loading tables.

Developed Mapplets, reusable transformations, source and target definitions and mappings using Informatica 7.1.

Developed mapping using parameters and variables.

Created complex workflows, with multiple sessions, Worklets with consecutive or concurrent sessions.

Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.

Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.

Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.

Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.

Worked with Informatica Debugger to debug the mappings in Informatica Designer.

Involved in creating test plans, test cases to unit test Informatica mappings, sessions and work flows.

Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.

Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

Environment: Informatica Power Center 8.1, Workflow Manager, Workflow Monitor, TOAD 8.6.1.0, SQL Developer, Flat files, XML, Oracle 10g/9i

TopScore IT Solution, INDIA Oct 2010 – Jun 2012

Computer System Analyst

Systems Analyst Job Purpose: Implements computer system requirements by defining and analyzing system problems; designing and testing standards and solutions.

Responsibilities

Defines application problem by conferring with clients; evaluating procedures and processes.

Maintain and support systems for data warehouse and business intelligence (BI) initiatives, including software, servers, and networks.

Perform data analysis, testing, debugging, audits, disaster recovery, and problem resolution.

Develops solution by preparing and evaluating alternative workflow solutions.

Controls solution by establishing specifications; coordinating production with programmers.

Validates results by testing programs.

Ensures operation by training client personnel; providing support.

Provides reference by writing documentation.

Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.

Accomplishes information systems and organization mission by completing related results as needed.

EDUCATION AND TRAINING

Bachelors in Computer Science & software engineering – Vinayaka Mission University, INDIA-2009

Tableau, Qlikview

Informatica

Oracle SQL

AngularJS

CCNA (Computer Networking)

Selenium (Automation Testing)

Contact this candidate