We provide IT Staff Augmentation Services!

Sr. Business Intelligence Consultant Resume

Reston, VA

SUMMARY:

  • Analytical, adaptable professional with extensive experience analyzing, designing, developing and implementing Business Intelligence solutions in various verticals such as Media, Insurance Banking, Financial, and Healthcare.
  • Expertise in designing and deploying rich graphic visualizations using requirement analysis, gap analysis, change management, impact analysis, capacity planning, proposal development, design validation, technical leadership and mentoring.
  • Team player with extensive experience in SDLC methodologies including Agile, Waterfall.
  • Accomplished communicator skilled in building and strengthening relationships across functions to drive cohesive, strategic operations.

EXPERRTISE AREA:

  • BI Solutions
  • Data Warehousing
  • Self - Serve Analytics
  • Self-Serve Analytics
  • BI Solutions
  • ETL Solutions
  • Data Modeling
  • Lifecycle Management
  • Testing Methodologies
  • Troubleshooting
  • Agile/Scrum, Waterfall
  • Cross-Team Collaboration
  • Data Migration
  • Report Migration

TECHNICAL PROFICIENCIES:

Tools: Tableau Desktop 10.X/9.X/8.X7.X, 2018.X,2019.X Tableau Server, Tableau Reader, SAP, BO, SSRS, SSIS, SSAS, Business Objects, ThoughtSpot, MicroStrategy 9.4.1-10.1,Alteryx 2018.X,2019.X

Operating Systems: Windows XP, Windows Server 2003/2008, UNIX, Windows 10

RDBMS: Oracle, SQL Server, MS Access, SharePoint

Languages: SQL, HTML, C

Methodologies: Complete Software Development Lifecycle, Waterfall, Agile

Calculations: Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop, and advanced functions (ATTR, DATEDIFF, STR, Ifs, nested Ifs, OR, NOT, AND, SUMIF, COUNTIF, LOOKUPs, and QUICK TABLE calculations).

Visualizations: Bar Graphs, Scatter Plots, Pie-Charts, Geographic Visualization, Local and Global Filters, Gantts, Bubbles, Histograms, Bullets, Heat Maps and Highlight Tables.

Data Modeling: RDBMS, Logical and Physical Data Modeling,3NormalForm (3NF) and Multidimensional Data Modeling Schema (Star Schema, Snow-Flake Modeling, Facts, and Dimensions), Physical and Logical Data Modeling for Data Warehouse/Data Marts.

Miscellaneous: Dynamic Fields, Dynamic Sort, Data Blending, Hadoop Hive Cluster, CA Autosys, Drill Down/Drill Up reports, Individual Axes, Blended Axes, Dual Axes

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. Business Intelligence Consultant

Technical Scope: MicroStrategy Architect, MicroStrategy 9.4.1-10.1, Alteryx 2019.X, Tableau 2019.X,2020.X ThoughtSpot, SAP BO,Netezza

Responsibilities:

  • Collaborate with business users to perform gap analysis of client requirements, prepare business requirement documents, and convert business requirements into Report Development Documents.
  • Design and develop various analytical reports/dashboards from multiple data sources by blending data into a single worksheet, using advanced features within Tableau software to link data from different connections into one dashboard and filter for multiple views simultaneously.
  • Publish developed dashboards and reports on Tableau Server so end users can access data easily from anywhere, including mobile devices and iPads.
  • Lead BI Consultant, selected to train lenders, brokers, business owners on the functions and advantages of MicroStrategy documents and dashboards, enabling a smooth end-user transition to new software system.
  • Selected by senior management team to design MicroStrategy mobile Reports, Tableau reports, ThoughtSpot reports creating attributes, facts, metrics, filters, custom groups, and templates using MicroStrategy Desktop, Tableau desktop. And ThoughtSpot web.
  • Extensive experience working in both ad-hoc and standard reporting environments.
  • Designed and build schema objects using MicroStrategy Architect, ThoughtSpot,SAP BO

Confidential, Springhouse, PA

Sr. Business Intelligence Consultant

Responsibilities:

  • Interact with business users, gather client requirements, update the sources, test existing dashboards.
  • Interacted with stake holders daily and Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop
  • Worked with business users and Documented functional needs of proposed project by reviewing business requirements.
  • Developed Tableau Data visualization using heat maps, Scatter Plots, Geographic maps, Pie and bar charts, Symbol maps, Horizontal bars, Histogram, Packed bubbles.
  • Worked on Alteryx tool to merge the data from multiple sources and to get data from API Call.

Confidential, Reston, VA

Sr. Business Intelligence Consultant

Technical Scope: MicroStrategy Architect, MicroStrategy 9.4.1-10.1, Alteryx 2019.X, Tableau 2019.X, ThoughtSpot, SAP BO,Netezza

Responsibilities:

  • Trained Lender, Brokers, Business users on self-serve analytics.
  • Worked on SAP BO reports migration to Tableau and ThoughtSpot.

Confidential, Pittsburgh, PA

Sr. Tableau Consultant

Technical Scope: Tableau Desktop 9.0/8.1/8.2, Tableau Server/Administrator, Oracle Developer, Business Objects, SQL, PL/SQL, MS-Excel, MS Project.

Responsibilities:

  • Prepared dashboards using calculations, parameters, calculated fields, groups, sets, and hierarchies in Tableau.
  • Created data-blending in case of merging two datasets.
  • Analyzed source data and modified by data type. Generated context filters and used performance actions while handling large data volume.
  • Facilitated load testing and benchmarking of developed product with the set performance standards.
  • Tested SQL scripts for report development, Tableau Reports, Dashboards, Scorecards and effectively resolved all performance issues.
  • Designed Test Cases and documented Test Results. Performed report tuning, cashing, specifying query governing thresholds, and report optimization.
  • Teamed effectively with ETL Developers for testing, mapping data, and identification of data models to translate and migrate data. Interfaced with users to facilitate instruction and adaptation to new systems using documented business requirements, deployment plans and user guides.
  • Liaised with Development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing and technical delivery.
  • Attend client meetings to provide clarification and serve as subject matter expert.
  • Participate in onsite and offshore coordination to ensure achievement of deliverables.

Confidential

Tableau Consultant / Analyst

Technical Scope: Tableau Desktop 9.3, Tableau Server, Tabadmin, Tabcmd, Tableau Data Engine, SSRS, SSAS, MS Office Suite (Excel), SQL Server R2, Oracle.

Responsibilities:

  • Built all aspects of Tableau scorecards and dashboards, publishing them to Tableau Server enabling end users to understand data quickly with usage of quick filters for on demand, needed information.
  • Participated in user requirement gathering and design meetings.
  • Interacted with offshore BI Development Team for work distribution and translation of business needs into reporting and analytic requirements, ensuring data accuracy and report reliability.
  • Designed and developed interactive dashboards and published Tableau reports utilizing parameters, calculated fields, table calculations, user filers, action filters and sets to handle views more efficiently.
  • Created Bullet Graphs to determine profit generation by using measures and dimension data from Oracle, SQL Server, and MS Excel.
  • Created complex ad-hoc reports, sub reports, linked reports, charts, drill through, and drill down reports. Generated Tableau dashboards with forecast and reference lines. Implemented action filters, parameters, calculated field and set for preparing dashboards and worksheets in Tableau.

Confidential

Tableau Consultant / Analyst

Technical Scope: SAP BO, SSRS, SSAS, Teradata Tableau Server, MS Office Suite (Excel), Oracle, SQL, PL-SQL, TSQL, SQL Server 2005/2008/2012 , Erwin r8.2, SQL Developer, Oracle Data Modeler.

Responsibilities:

  • Designed Microsoft SSIS ETL framework to perform tasks synchronously and/or asynchronously.
  • Worked on MDX Cubes for data analysis.
  • Design and maintain SSRS reports and stored procedures for SSAS cubes as data sources.
  • Created scheduled and extracted data into Tableau Data Engine. Built and published customized interactive reports and dashboards, reporting scheduling using Tableau Server.
  • Created Tableau score cards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charges using show me functionality.
  • Reviewed business requirements and analyzed data sources from Excel, Oracle, SQL Server for design, development, testing, production rollover of reporting and analysis projects. Documented and published test results, troubleshooting and escalating issues to ensure product functionality. Prepared various test documents for ETL process in Quality Center. Identified, assessed, and intimated potential risks associated with scope, product quality and schedule.
  • Generated reports using SQL and Oracle databases used for comparison with legacy system and created temporary tables to store data from legacy system.
  • Identified Objects and relationships between objects to develop a logical model and translate model into physical model using Forward Engineering in ERWIN.
  • Developed Data Mapping, Data Governance, Transformation, and Cleansing Rules for Master Data Management.
  • Developed and monitored workflows, holding accountability for performance tuning of staging and 3NF workflows.
  • Designed Data Marts using dimensional modeling and wrote PL/SQL ETL packages with Oracle PL/SQL to extract data from relational data.

Hire Now