RICHIE BERLIN

Professional Summary:

Over *.*+ years of IT Experience in design, analysis, development and implementation of various applications in Client/Server OLAP environment using BI Tool in Banking, Healthcare, Trading and Financial industries.

Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau 8, 9, 10 - Desktop, Server.

Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.

Managed cross-functional teams through Software Development Life Cycle.

Possess strong knowledge of database management in writing complex SQL queries, resolving key performance issues.

Wide experience in identifying dimensions, attributes, hierarchies and calculating measures and dimension members.

Expertise in analysis, design and implementation of data warehousing applications using Oracle, db2, Share Point, Sap Hana, AWS, Cloudera Hadoop.

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Text Chart, Dual Axis Charts, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and other visualizations and making use of actions, other local and global filters according to the end user requirement.

Setting up Tableau data sources. Filters, Sets, blending, joins for optimum performance and

Preparing Dashboards using calculations, parameters in Tableau.

The ability to interact professionally with a diverse group, including executives, managers, Directors and VP’s.

Play Business Analyst role gathering requirements with the client and document it before start working on the report.

Responsible for Developing Dashboards and preparing ad-Hock Reporting.

Scheduled the reports as per business requirements.

Working on excel macro’s, VLOOKUP’s and other main functions in excel, etc.

Document issues in Confluence (KEDB) and resolve Change, incident, Problem, Deployment Request tickets maintaining SLA

Performed automation and making sure the file is placed properly in the proper destination.

Onsite experience - Travelled Dubai for Developing Visual report for each phase of the migration project, Data Migration, production testing and supporting

Technical skills:

Data Bases : Oracle 10g/11g/12c, Sap Hana, Share Point, Cloudera Hadoop, AWS, DB2, Access DB

Oracle Developer : TOAD, SQL plus, SQL Developer

UNIX : Putty

Ticket Tracking : JIRA, BMC Remedy

Job Scheduler : Batch Processor, Ops Wise,

Monitoring Tool : Nagios

Languages/Utilities : SQL, PL/SQL, UNIX.

Business Intelligence tool : Tableau Desktop 8, 9.3, 10.4 & Tableau Server

Professional experience 1:

Company Name : Techno soft Global Services (p) ltd

Role : Sr. Software Engineer (Tableau Consultant)

Client : Thryve Digital

Environment : Tableau Desktop & Server 10.4, Oracle 12c, Share Point, Sap Hana, Access DB, DB2, Excel flat file.

Duration : Jan 2019 to Present

Roles & Responsibilities:

Enhancement of existing excel pivot report into the latest tableau version

Data cleansing and joining multiple data sources with complex join conditions (To display the records changing it from impossible to possible).

Development report documentation, WSR (Weekly status reporting), phase model work routine to complete each target in each phase on or before the deadline.

Excellent ability in writing specifications and gathering requirements from the users to develop reports as per the needs of the client and maintain documentation of the reports for future reference.

Created Reports Specification Documents, Technical Specification Document.

Generated Test Cases for each report specification corresponding to each module.

Created adhoc reports to users in Tableau by connecting various data sources.

Understanding of relational database structures, theories, principles, and practices.

Communicating with the onshore team to do the requirement with in the stipulated deadline.

Created report schedules on Tableau server.

Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Blended data from multiple databases into one report by selecting primary key's from each database.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Developed reports which would be driving the company’s Projects (1300+) to keep track of their release dates, On Track, Off Track, Form Not Submitted Status and ensuring if proper compliance is met.

Interact professionally with a diverse group, Including Executives, Managers, Directors, and LOB.

Environment: Oracle 12c, Toad, Tableau Desktop & Server 10.4, Share Point, Sap Hana

Professional experience 2:

Company Name : Cron Crew Technologies

Role : Sr. Software Engineer

Project : Keystone Bank Limited

Environment : Tableau Desktop & Server 10.3, Oracle 12c

Duration : Nov 2018 to Dec 2018

Roles & Responsibilities:

Excellent ability in writing specifications and gathering requirements from the users to develop reports as per the needs of the client and maintain documentation of the reports for future reference.

Built reports using multiple data providers, external data providers and used merge dimension functionality.

Ability to quickly adapt to new technologies and different project environments.

Understanding of relational database structures, theories, principles, and practices.

Created drill down and drill up in worksheets in tableau.

Involved in creating a dual-axis bar chart with multiple measures.

Created report schedules on Tableau server.

Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.

Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

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.

Blended data from multiple databases into one report by selecting primary key's from each database for data validation.

Environment: Oracle 12c, Toad, Tableau Desktop & Server 10.3

Professional experience 3:

Company Name : Wirecard

Role : Sr. Software Engineer

Project Name : Tranzware

Client : 20+ financial institutions all over the world

Environment : Tableau Desktop & Server 10.3, Oracle 11g & 12c, Sap Hana, Cloudera Hadoop

Duration : September 2017 to November 2018

Onsite: Dubai (3 months) - December 2017 – March 2018 (Visual report generation for each phase of the migration project, Data Migration, Testing including Support)

Roles & Responsibilities:

Experience in design and development of Tableau visualization solutions.

Hands on development assisting users in creating and modifying worksheets and data visualization dashboards.

Working on generating various dashboards in Tableau server using various sources such as SQL Server/Teradata/Oracle / MS Excel.

Experience in creating users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Preparing Dashboards using calculations, parameters in Tableau.

Wide-ranging experience in Tableau Desktop, Tableau API’s and Tableau Server in various versions of Tableau 9.3 and Tableau 10

Visualization of Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Context Filters, Sets, groups etc.

Excellent ability in writing specifications and gathering requirements from the users to develop reports as per the needs of the client and maintain documentation of the reports for future reference.

Built reports using multiple data providers, external data providers and used merge dimension functionality.

Ability to quickly adapt to new technologies and different project environments.

Understanding of relational database structures, theories, principles, and practices.

Created drill down and drill up in worksheets in tableau.

Involved in creating a dual-axis bar chart with multiple measures.

Created report schedules on Tableau server.

Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.

Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

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.

Blended data from multiple databases into one report by selecting primary key's from each database for data validation.

Involved in license management SLA's with Tableau support.

Prepared proof of concept for best practices in Tableau deployment.

Developing a Dashboards and preparing ad-hoc Reporting.

Environment: Oracle 11g & 12c, Toad, Putty, Batch Processor, Jira, BMC Remedy, EP (Visa’s Edit Package), MFE (MasterCard), Tableau Desktop & Server 10.3

Professional experience 4:

Company Name : Sailburg Software Solutions

Project Name : ANZ

Client : ANZ Groups

Role : Sr. Software Engineer

Environment : Tableau Desktop & Server 9.3-10.3, Oracle 10g and 11g

Duration : October 2015 – August 2017

Roles & Responsibilities:

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Mastered the ability to design and deploy rich Graphic visualizations using Tableau.

Create views and dashboards on end client's sales data. Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily by CEO and CFO.

Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.

Scheduled extract refresh and subscriptions.

Created Reports Specification Document

Generated Test Cases for each report specification corresponding to each module.

Created adhoc reports to users in Tableau by connecting various data sources.

Connected Tableau server to publish dashboard to a central location for portal integration.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

Creating users, groups, projects, Data connections, settings as a tableau administrator.

Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity and customized views on Server Analysis.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc.

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

Generated tableau dashboards with combination charts for clear understanding.

Creating data blending in case of merging two different datasets.

Created Cascading dashboards, data extracts Action filters for better performance of Tableau.

Created many parameters, quick filters, sets and shapes for better navigation in Tableau dashboard

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

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

Developed Tableau workbooks from multiple data sources using Data Blending.

Performed Unit Testing, Integration Testing and Performance Testing.

Used the inner join, outer join, cross join while writing the complex SQL Queries.

Involved in solving day-to-day problems, giving support to the users.

Environment: Oracle 10g, 11g, Tableau Desktop & Server 9.3,10.3, BMC-Remedy, TOAD, SQL Developer, Putty - UNIX.

Professional experience 5:

Company Name : Sailburg Software Solutions

Project Name : ANZ Banking and Trading

Client : ANZ Group

Designation : Software Engineer

Environment : Tableau Desktop & Server 8, 9-9.3, TOAD, Oracle 10g

Duration : February 2013 to October 2015

Roles & Responsibilities:

Extracting data from different sources, connecting them and prepared different charts and used the same to create dashboard

Creating data blending in case of merging two different datasets.

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

Find efficient ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

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

Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.

Design and development of various reports and dashboards that can be easily accessible through Tableau App in I pads, iPhones, and other smart mobile phones.

Migrated data from flat files to tables using Sql*loader.

Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.

Worked on ETL tools for data migration.

Reporting and monitoring the deliverables during each phase of project.

Developed several reports and documents that help track down a claim.

Environment: Tableau Desktop & Server 8, 9-9.3, Oracle 10g, 11g, SQL, PL/SQL, TOAD, UNIX, BMC remedy.

Certifications:

1Z0-051 Oracle Database 11g: SQL Fundamentals 1 (Completed)

1Z0-144 Oracle Database 11g: Program with PL/SQL (pursuing)

Academic qualifications:

Bachelor of Information Technology from SRM University, Chennai, Tamil Nadu, India - 2012

(Richie Berlin)

Contact this candidate