Bi Consultant Resume
DC
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