We provide IT Staff Augmentation Services!

Bi Consultant Resume

0/5 (Submit Your Rating)

VA

SUMMARY

  • Over 7 years of experience in Software Design, Development, Implementation, Maintenance and production Support of Business Intelligence and Database Solutions and platforms.
  • In - depth knowledge on Tableau Desktop, Tableau Server and Tableau Viewer.
  • Ability to design and display Graphic rich visualizations with Filters, Drill Downs and Parameters.
  • End to end experience in Installation and configuration, designing and deploying data visualizations using Tableau.
  • Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to requirements specifications.
  • Extensiveexperience in troubleshooting, performance tuning and supporting Business reporting platforms.
  • Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.
  • Experience in Tableau software Installation in Single and clustered environments.
  • Hands on experience in configuration and administration of Tableau Server
  • Involved in Tableau platform upgrades from 6.x to 7.x and 7.x to 8.x
  • Provided 24X7 Operational/Application support for business critical applications.
  • Established Standards and Best Practices for EnterpriseTableauEnvironment, application on boarding and development processes.
  • Extensive working experience in writing Packages, Procedures and Functions.
  • In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
  • Strong team member with good communication and analytical skills.
  • Excellent problem solving, troubleshooting and decision-making skills.

TECHNICAL SKILLS

BI Tools: Tableau 6/7/8, Qlik View, Crystal Reports XI/2008

RDBMS: Oracle 12C/ 11g/10g/9i, MS SQL Server 2003/2005, MS Access

RDBMS GUI Tools: SQL Developer, Toad

Languages: C, C++, PL/SQL, Batch programming, VB Script, DBMS

Operating System: Windows, Linux

Other Tools: MS-Office, putty

PROFESSIONAL EXPERIENCE

Confidential, VA

BI Consultant

Responsibilities:

  • Involved in Requirements analysis for order provisioning dashboards Review, Design, Development.
  • Participated in project planning sessions with management and end users analyze business requirements for real-time and historical reports and dashboards.
  • Designed and developed intuitive Tableau Dashboards against Order Provisioning System to bring visibility on Order provisioning process and performance.
  • Built Tableau visualizations by connecting to various Data Sources Relational Databases(Oracle, SQL Server)
  • Built reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
  • Designed and deployed interactive reports with Drill Downs, Drop down menu option, Parameters and Linked reports using Tableau.
  • Created variety of visualizations and dashboards according to business requirement specifications.
  • Experience withActive Directory Integration within Tableau Environment for automated user provisioning.
  • Performance tuning, Trouble shooting and support of existing system.
  • Involved in Installation, Configuration and maintenance, server monitoring and capacity planning activities.

Environment: Tableau 7x/8x, Oracle 11g, SQL Developer

Confidential, DC

BI Consultant

Responsibilities:

  • Involved in gathering information on source system.
  • Generate reports/metrics for upper management to review.
  • Establish various data connections to different data sources like Oracle, API sources, SharePoint and flat files.
  • Created different types of dashboards based on user requirements.
  • Built reports using Views, Functions and Tables.
  • Creation of business rules for quality criteria through collaboration with stakeholders.
  • Collaborated with stakeholders to clarify business requirements
  • Ensure reports performance to the best and applied various strategies for long running visualizations.
  • Built different types of reports like Histograms, Tables, Pie charts, Staked Bars.
  • Participated in project sessions and generated Daily reports, Weekly Reports, Monthly Reports are done according to the End User and Upper Management requirements.

Environment: Tableau 6x/7x, Tableau Server, Oracle 10g, SQL Developer, Windows, UNIX

Confidential, MA

BI Consultant

Responsibilities:

  • Interacting with clients and gathering the requirement, Understanding the business requirement.
  • Converting the business requirements graphic rich visualizations
  • Built Pilot project and demonstrated capabilities of Tableau Visualizations to business users.
  • Conducted various discussions with Management in order finalize target visualizations.
  • Designed and deployed complex visualizations involving parameters, drill downs and complex business logic.
  • Performed Unit testing of visualization by comparing data in dashboards vs Data in Data Warehouse.
  • Built visualizations against OLTP and OLAP(Star and Snow Flake) Schemas
  • Provided 24X7 supports as a TableauAdministrator including technical support, troubleshooting, report design, monitoring system usage.
  • Developed various database objects like Tables, Views and Stored Procedures, Functions, Packages by using SQL*Plus, PL/SQL in Oracle.

Environment: Tableau 6, Windows, Oracle, SQL, PL/SQL

Confidential

SQL Developer

Responsibilities:

  • Understanding the business process/requirement and translate them into technical requirements.
  • Created Database Objects like Tables, Views, Synonyms and Sequences.
  • Extensively used of PL/SQL Stored Procedures, Functions, Triggers and Packages.
  • Tested the entire application in testing environment and exported to Production.
  • Done the documentation and provided on-site production support.

Environment: Oracle, SQL, PL/SQL, Windows

Confidential

SQL Developer

Responsibilities:

  • Creating and altering Tables, Views.
  • Creating Primary Keys in the tables at the design time
  • Finding appropriate solutions for those requirements in an easy way and preparing low level technical approach documents for them.
  • Handled Maintenance, Development support activities.
  • Documenting the Database activities and involved in System Documentation.

Environment: Oracle, Windows, Clear Case

We'd love your feedback!