We provide IT Staff Augmentation Services!

Sr Bi Consultant Resume

Northbrook, IL

PROFESSIONAL SUMMARY:

  • Around 10 years of experience in Software Design, Development of DWH, Business Intelligence Administration and Data Platforms.
  • Extensive Experience in Tableau 7.x/8.x/9.x/10.x as a Tableau Consultant and Lead BI/Data analyst.
  • Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
  • Skilled in Tableau Desktop for Data visualization, Reporting and Analysis.
  • Expertise in resolving the reports, dashboards, performance issues and implementing best practices using Tableau/OBIEE/Microstrategy.
  • Skilled in Understanding client Best - Practices & Report standards, ability to provide visualization alternatives, assist in developing reports.
  • Experience in Tableau application security/release management methods.
  • Troubleshoot existing reports, understanding of data connections to Oracle, MS-SQL Server and other Databases.
  • Experience in Data blending and Familiarity with Tableau mobile access options.
  • Experience in Improving Reports performance in Tableau/OBIEE/Microstrategy.
  • Experience in Tableau/OBIEE/Microstrategy Administration/development and architecture.
  • Experience in supporting enterprise wide deployment and developed object security.
  • Experience in formulating and executing practices for Tableau report development.
  • Experience in installing and configuring Tableau desktop along with silent mode features.
  • Experience in documenting and modifying user groups for Tableau reports.
  • Experience in tracking and monitoring server performance.
  • Experience in mapping of server nodes for Tableau server deployments.
  • Experience in creating server architecture and analyzing scheduling related issues.
  • Experience in connecting to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.
  • Proficient in Utilizing the JavaScript API to create a customized portal for the property management group.
  • Experience in creating schedules and publishing data sources on to server and make them automated for refreshes.
  • Experience as an OBIEE developer supporting medium to large data marts.
  • Experience in Tableau application security/release management methods
  • Database experience in Oracle 11g/10g, My-SQL, MS-SQL Server,Teradata etc...
  • Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files
  • Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
  • Experience in design, development and support of Oracle Business Intelligence (OBIEE)applications, experience in Data Modeling (Physical & Logical), Data Analysis and writing High level and Low levelDesign Specifications for both ETL and BI.
  • Experience in Software Development Life Cycle (SDLC) that include duties like providing technical documentation on design,testing and upgrade/migration works from development to production.
  • Extensive experience with ETL processes using Informatica Power Center tool.
  • Expertise in design and development of the three layers ( Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration Tool.
  • Experience in Configuring answers (ad-hoc querying, reports), Interactive Dashboards with drill-down capabilities, Delivers/iBots (alerts) and administered Web Catalog Objects.
  • Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment (MUDE).
  • Expertise in Financial, Sales/Marketing, Telecom, Retail and Healthcare domains.
  • In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems , utilizing Oracle RDBMS Methodologies.
  • Extensive experience working in Windows, UNIX, LINUX environments.
  • Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel, ability to provide timely solutions and work within specified time frames.

TECHNICAL SKILLS:

Languages: HTML, PL/SQL, SQL, XML, Java Script, JAVA, Shell Scripting.

Applications: Salesforce, Oracle SQL Developer, Google Analytics.

ETL Tools: Informatica 9.1/8.x/7.x., Alteryx,Talend.

Reporting tools: Tableau 10.x/9.x/8.x/7.x, OBIEE 11g, 10.x, Micro strategy, SAP BO.

Databases: Oracle 8i/9i/10g/11g/12c, MS Access, HADOOP, SAS, MS SQL Server, AWS, Teradata.

Operating Systems: Windows XP/7/8, MS-DOS, UNIX, Linux.

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0.

Packages / Tools: MS Office, Toad, Putty, Rapid SQL|, SharePoint

WORK EXPERIENCE PROFILE:

Confidential, Northbrook, IL

Sr BI Consultant

Environment: Tableau 10.x, Tableau Server, Micro strategy, Alteryx, Oracle 12c/11gR2, SQL Developer, SharePoint, MS-Access, MS Excel, AWS, HADOOP, MS Visio and JavaScript.

Responsibilities:

  • Responsible for leading the strategic design and maintenance of business intelligence applications.
  • Identify, research, and resolve technical problems.
  • Ensure that the use of business intelligence applications enhances business decision making capabilities.
  • Analyze User Requirements, propose appropriate solutions, evaluate, and recommend appropriate solutions with Tableau tool.
  • Develop self-service BI capabilities to automate the production and delivery of reports and analyze various departments, business groups in achieving their business plans.
  • Work with business partners and BI analysts to identify capabilities needed and Identify, address data quality gaps.
  • Map solution needs to available reporting tool set like tableau, developing prototype solutions for review with business partners.
  • Develop report logic using Tableau and other tools and Testing reports to ensure accuracy, and re-mediates defects.
  • Annotates reports, capabilities to create clear data definitions and guidelines for appropriate use of data.
  • Monitor the utilization, support user questions, and create enhancements to existing reports and capabilities in alignment with business needs.
  • Apply analysis on business initiatives to various groups across Confidential and Use statistical and analytical skills to produce analyses that support Confidential in managing the business and making business decisions.
  • Summarize the analysis by organizing findings into actionable conclusions, recommendations and Serving as subject matter expert on Confidential ’s data warehouse and use of the Tableau tool.
  • Identify and address data quality gaps. Define data enhancements to support reporting and analytical capabilities brought forth by business partners

Confidential, Pleasanton, CA

Sr. BI Consultant.

Environment: Tableau 10.x/9.x, Tableau Server, SSRS, Sybase, SSIS, Oracle 12c/11gR2, Teradata, SQL Developer, MS-SQL Server, SharePoint, HADOOP, Salesforce, MS-Access, MS Excel.

Responsibilities:

  • Installed and Worked on latest version of Tableau 10.5.
  • Designed, developed, and tested various Tableau dashboards such as Scorecard, marketing dashboards, usage reports and various Ad-Hoc reporting solutions using Tableau 10.0.1 and 10.3.
  • Worked on multiple Big Data technologies to integrate with Tableau and develop interactive dashboards, visualizations.
  • Perform data visualization development using Tableau to create complex, intuitive, innovative dashboards and reports.
  • Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.
  • Analyzed data requirements, application and processing architectures, while designing, developing, amending, and optimizing database designs to satisfy client needs.
  • Gathered functional and non-functional client requirements to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
  • Daily data pull and testing using SQL queries.
  • Developed dashboards using Custom SQL queries, and various data sources using data blending techniques.
  • Good SQL reporting skills with the ability to create SQL views and write SQL queries.
  • Performed End to end testing using SQL Queries in Oracle.
  • Provided training sessions to business users on how to use Tableau reports.
  • Developed POCs for business users displaying various functionality and visualization.
  • Update and maintain various release documentation, and JIRA tickets.
  • Maintained multiple versions of Tableau dashboards using SVN.
  • Schedule reports, administer users and user groups for workbooks, data sources and views in Tableau.
  • Worked with ETL team on designing Oracle tables for multiple projects, data analysis and SQL Query transform.
  • Analyzed the data using Statistical features in Tableau to develop trend analysis like context reports based on Daily, MTD, last one month, and YTD date fields.
  • Identified opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion.
  • Responsible for developing various data connections from data source to Tableau Server for report and dashboard development.
  • Responsible for writing views based on user and/or reporting requirements, wrote Teradata Macros and used various Teradata analytic functions.

Confidential, Pasadena, CA

Sr BI Consultant

Environment: Windows XP, Tableau 9.x/8.x, Tableau Server, Micro strategy, Alteryx, Oracle 12c/11gR2, SQL Developer, SharePoint, MS-Access, MS Excel, AWS,HADOOP, MS Visio and JavaScript.

Responsibilities:

  • Responsible for developing various data connections from data source to Tableau Server for report and dashboard development.
  • Responsible for writing views based on user and/or reporting requirements.
  • Responsible for creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Responsible for combined visualizations into Interactive Dashboards and publish them to the web. Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
  • Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution. Build and maintain 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 use custom images and geo coding to build spatial
  • Visualizations of non-geographic data. Created actions, parameters, Filter (Local, Global) and calculated sets for
  • Preparing dashboards and worksheets using Tableau. Effectively used data blending, filters, actions and Hierarchies Feature in Tableau.
  • Work directly with management, vendors, and third parties to ensure that Web site's financial transactions and database management applications operate at peak efficiency. Ensured projects were completed on time and within budget.
  • Tableau server maintenance, Tableau server backup activity. Consolidate multiple data silos that exist on campus to one location. Scheduled data extracts on a daily basis. Sophisticated stored procedures and triggers to provide complete technical solutions. Participated in test planning and test script definition. Resolved end user reporting problems through collaboration with IT and Operations. Environment Support to User community, Service Request & Resolution. Expertise in failed over activities in production Environments.
  • Managed multiple parallel projects to identify business goals, envisions the solutions, develop strategy; define project scope, implementation phases, estimate resources and timelines, experience with creating advanced reports in Salesforce.com and responsible for the quality of data within Salesforce
  • Data analysis and manipulation and Regularly perform data de-duping and cleanup procedures
  • Validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
  • Developed Feature Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports using Microstrategy.

Confidential, Los Angeles, CA

Sr. BI Specialist

Environment: Windows XP, Tableau 8.x, Tableau Server, Oracle Database 12c/11g, SQL Developer, MS-SQL 2008 R2, MS-Access, Salesforce, Google Analytics, AWS, SAP BO, MS Excel and JavaScript.

Responsibilities:

  • Responsible for Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Responsible for understanding the source systems to implement EDW.
  • Responsible for Data Modeling, Data Analysis, Data Integration and Data Visualization.
  • Experience in working with Tableau server to publish data sources, creating users and Tableau installation.
  • Responsible for creating Tableau models, architectures, frameworks and strategies based on business requirements.
  • Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
  • Responsible for Analyzing and trouble-shooting technical issues related to reporting.
  • Experience in creating Dashboards by connecting to different data sources like Google Analytics, Salesforce and different data sources.
  • Experience with creating advanced reports in Salesforce.com.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterization using Tableau.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
  • Responsible for providing Tableau training to business users and helping them in self-service Analytics.
  • Supported enterprise wide deployment and developed object security.
  • Formulated and executed practices for Tableau report development.
  • Installed and configured Tableau desktop along with silent mode features.
  • Documented and modified user groups for Tableau reports.
  • Participated in tracking and monitoring server performance.
  • Assisted in mapping of server nodes for Tableau server deployments.
  • Created server architecture and analyzed scheduling related issues.
  • Conducted platform performance tests and implemented Tableau platforms.
  • Documented and maintained system designs and Tableau technical aspects.
  • Evaluated performance test results and developed technical architecture.
  • Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.
  • Utilized the JavaScript API to create a customized portal for the property management group.
  • Consulted on Tableau server performance enhancements.
  • Upgraded from version 8.2 to 8.3 and server reconfiguration based on workbook complexity and data extraction.
  • Customized the Tableau landing page with site listing as icons and descriptions.
  • Configured data extraction by schedule, every business day at 6 am / 7 PM to enhance performance.

Confidential, Pleasanton, CA

Sr. Tableau Consultant.

Environment: Windows XP, Tableau 8.x, Tableau Server, Talend, Oracle Database 12c/11g, SQL Developer, MS-SQL 2008 R2, MS-Access, Salesforce Marketing Cloud, Google Analytics, Netezza, SAP BO, MS Excel and JavaScript.

Responsibilities:

  • Performed requirement analysis of large-scale business systems and translated requirements into Statement of Work, Business Requirement Documents, Use Cases, Functional Specifications, Project Proposals, Testing and Post Implementation Plans.
  • Responsible for gathering requirements and understanding the source systems to implement EDW/MDM/BI.
  • Responsible for Data Modelling and Data Analysis.
  • Responsible for development of Reports and Dashboards using Tableau.
  • Responsible for tool evaluation for Data Integration and Data Visualization.
  • Responsible for Building MDM/EDW.
  • Responsible for Building Sales, Marketing and Finance reports and dashboards.
  • Maintaining weekly/monthly/quarterly metrics for topics/projects
  • Experience in working with Tableau server to create data sources, creating users and Tableau installation and providing training to Business users in using Tableau.
  • Responsible for creating Tableau models, architectures, frameworks and strategies based on business requirements.
  • Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
  • Responsible for Analyzing and trouble-shooting technical issues related to reporting.
  • Responsible for presenting Weekly release status using PowerPoint.
  • Responsible for building Reports/Dashboards related to Sales, Marketing and finance using Tableau.
  • Responsible for converting all excel reports in to Tableau reports and dashboards.
  • Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.
  • Experience in working with Tableau Desktop and Tableau Server.(Versions 6,7 and 8.1)
  • Experience in creating Dashboards using Table calculations, Logical calculations, number calculations and creating parameters.
  • Experience in creating Different maps, dual axis charts.
  • Experience in creating Dashboards by connecting to different data sources like Google Analytics, Salesforce and different data sources.
  • Experience in working with Tableau server to create data sources, creating users and Tableau installation and providing training to Business users in using Tableau.
  • Managed multiple parallel projects to identify business goals, envisions the solutions, develop strategy; define project scope, implementation phases, estimate resources and timelines.
  • Experience with creating advanced reports in Salesforce.com.
  • Responsible for the quality of data within Salesforce
  • Regularly perform data de-duping and cleanup procedures
  • Audit, uncover and resolve data integrity issues
  • Support developments to enhance and improve data collected
  • Strong understanding of Salesforce.com best practices, security, and functionality.
  • Good Working knowledge on Excel, PowerPoint and Visio to generate reports, presentations and Process flows.

Confidential, Northbrook, IL

BI Tableau Analyst

Environment: Tableau 7.x/6.x,Oracle 11i, Informatica9.1/8.x, OBIEE 11g/10g, SAP BO, SQL, SQL*Plus, TOAD, Windows 2003/XP, UNIX.

Responsibilities:

  • Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
  • Created different views in workbook to visually analyze data.
  • Created extracts, published data sources to tableau server, refreshed extract in tableau server from Tableau Desktop.
  • Used different Mark types and Mark properties in views to provide better insights into large data sets.
  • Created External filter, internal filter and Context filter to improve performance. Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
  • Used dimension on Page shelf for a detailed analysis of the view by members of the dimension. Created parameters and quick filters. Created sets to display top products based on their sale.
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
  • Created Dashboards with interactive views, trends and drill downs. Published Workbooks and Dashboards to the Tableau server. Combined visualizations into Interactive Dashboards and publish them to the web.
  • Administration of Tableau and server maintenance, Tableau server backup activity. Consolidate multiple data silos that exist on campus to one location. Scheduled data extracts on a daily basis. Sophisticated stored procedures and triggers to provide complete technical solutions. Worked with all levels of development from analysis through implementation and support.
  • Created groups and users in Tableau server. Used commands in Tabcmd and Tabadmin utility tool.
  • Migrated Workbooks and Tableau upgrades/migration works. Implemented new features in Tableau to the existing Workbooks and Dashboards.
  • Created Business Model to support Ad hoc Reports for User Access based on Requirements. Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
  • Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
  • Managed Security privileges for each subject area and dashboards according to user requirements. Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations. Used the Catalog manager and maintained the web catalog to manage Dashboards and Answers. Responsible for documenting the OBIEE framework and track the progress.

Confidential

BI Developer

Environment: OBIEE 10.1.3.x/Siebel Analytics 7.x, Oracle 10g/11g, TOAD, SQL Developer, Informatica Power center 7.1.2/8.1, Windows Server 2003, SAS,MS VISIO.

Responsibilities:

  • Extensively used OBIEE Administration Tool for creating physical, business and presentation layers of repository.
  • Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots. Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
  • Installed and Configured OBIEE Environment in the Organization. Involved in the Installation and Configuration of Oracle BI Suite. Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers. And troubleshoot performance and solving issues related to BI team, Responsible to monitoring and fixing bugs in production box. Understand the Architecture and Server Configurations (Database, OBIEE Source System).
  • Did support and responsible for implementation, administration and configuration of OBIEE functionality. Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains. Developing Calculated Measures and assigning these Aggregation levels based on Dimension Hierarchies. Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively. Analyzed and validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and validating repository level calculations done in the business model.
  • Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Oracle BI Answers and assigning them to application specific dashboards. Configure the BI Publisher scheduler to schedule reports and view the saved. Created highly formatted reports using BI Publisher based not only on conventional data sources (such as Oracle Database) but also on various other data sources (such as Web Services, RSS feeds, and so on). Associated with Production support team in various performances related issues. Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
  • Used MUD environment during development of the project. Responsible for Creating the Physical Layer, Business Model and Mapping Layer and Presentation Layer in ANA Repository (.RPD) using Oracle BI Administration Tool.
  • Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions like Ago (), To Date based on the Requirements. Created Attributes and Metrics in the BMM layer. Created Aggregated Tables to improve the Performance of the Reports. Created Logical Tables, Logical Columns with Measures Calculated as per the Business need.
  • Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks. Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards. Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
  • Created Business Model to support Ad hoc Reports for User Access based on Requirements. Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
  • Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
  • Managed Security privileges for each subject area and dashboards according to user requirements. Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations. Used the Catalog manager and maintained the web catalog to manage Dashboards and Answers. Responsible for documenting the OBIEE framework and track the progress.

Confidential

Data Analyst

Environment: Oracle Database 8i / 9i, SQL*Plus, iSQL*PLUS, PL/SQL, Oracle 9i Data Guard, RMAN, Red Hat Linux AS 2.1, Win NT/XP, TCP/IP, UDP, HTTP / HTTPS, SQL*Loader.

Responsibilities:

  • Responsible for installation, configuration and administration of Oracle 8i/9i Database.
  • Responsible for Cloning and administration of Oracle database products in different environments.
  • Responsible for Performance tuning and Optimization.
  • Created Users, security, backup, recovery and tuning.
  • Carrying out specific Benchmark SQL Queries, Query execution plans and locking issues.
  • Writing SQL*Loader control scripts and stored procedures.
  • Loading data into database using SQL*Loader utility for telecom billing and processing the detail call records.
  • Written Database Triggers, Stored Procedures using PL/SQL.
  • Successfully created and debugged many PL/SQL procedures, functions and Packages for the application.
  • Analyzing requirement of client, generating and designing reports.
  • Creating Data Structures i.e. tables & views and applying the referential integrity.
  • Designing Data conversion/Interface with the use of SQL*Loader, and Open Interface, and convert data.
  • Managing Rollback Segments and Temporary segments.
  • Maintained Local Reports Server and local Test beds of oracle 9i on RHEL 3.0.
  • Ability to summarize millions of transactions within limited time.
  • Ability to move large quantities of data in and out of Salesforce by using Apex Data Loader.
  • Providing meaningful analysis based on available data.
  • Responsible for Analyzing and trouble-shooting technical issues related to data.
  • Responsible for preparing business case for new project or scope items.
  • Performed data Analysis to Assess Scope items.
  • Pulling data from various sources in Oracle, Access.

Hire Now