We provide IT Staff Augmentation Services!

Business Intelligence Analyst Resume

2.00/5 (Submit Your Rating)

EXPERIENCE SUMMARY:

  • Over 13 Years of working experience in IT as Data Analyst, Reporting and Business Intelligence Analyst.
  • Efficient in developing data management Reports using Reporting Tools Tableau, SAP Business Objects, Inquiry Frame Work(IFW), Oracle - SQL & PL/SQL .
  • Extensive Experience of Interaction with Client & Business Users for gathering the Business Requirements and Functional Specifications.
  • Expertise in Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
  • Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud
  • Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices.
  • Experience in developing Metric dashboard using calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
  • Used JavaScript API to integrate Tableau visualizations into web application.
  • Extensively worked on setting up of Sites, Projects, groups, Users, Schedule refreshes & subscriptions.
  • Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
  • Have been involved in Full Life Cycle Data warehousing projects using SAP Business Objects, Tableau, Inquiry Frame Work(IFW), & Oracle in designing, enhancing and supporting, business requirement.
  • Extensive Experience in writing Oracle- SQL, building Universe, retrieving data using personal data files, Freehand SQL methods and creating complex ADHOC reports.
  • Exposure of Production Support environment - Project implementation life cycle, troubleshooting, root cause analysis and issue resolution, enhancements, Migration, problem management and maintenance of Data Warehousing applications and tools.
  • Experience of managing & leading the team.
  • Extensive Experience to handle multiple tasks and work independently as well as in a team.

SKILLS SUMMARY:

Domain: Banking, Health Care and HRMS

Programming Languages: SQL, PL/SQL

Operating System / ERP Version: Windows 7/8/10, XP, Linux

Tools: / DB / Packages / Framework / ERP Components: Tableau Desktop, Tableau Server, Tableau Online, Tableau Public, Tableau Reader, SAP Business Objects, Inquiry Frame Work(IFW) Oracle 8i,9i,10g,11g,12c,SQL Server 2008, SQL Developer, Microsoft Visio, MS Project, Big Data - Hadoop, Informatica Power Center, Abinitio

Hardware Platforms: Intel Series

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Analyst

Responsibilities:

  • Understand the Requirements and Functionality of the application from specifications.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
  • Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
  • Converted existing SSRS reports to tableau dashboards.
  • Created different KPI using calculated key figures and parameters.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's.
  • Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
  • Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
  • Createdcustomized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
  • Worked onmotion chart, Bubble chart, Drill down analysis using tableau desktop.
  • CreatedExternal filter, internal filter and Context filterto improve performance.
  • UsedData Blending, groups, combine fields, calculated fields, and aggregated fieldsand spotlighting to compare and analyze data in different perspectives.

Technology & Tools: Tableau Desktop, Tableau Server, Tableau Online, Tableau Public, Tableau Reader, SQL Developer, Oracle, Java

Confidential

Business Intelligence Analyst

Responsibilities:

  • Involved in reviewing business requirements and analyzing data sources from Excel/IBM DB2 Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Worked with the program manager, business analysts and developer to transform data into actionable intelligence through graphics and analytics.
  • Created Tableau reports for all Regulatory modules such as Provider, Member, claims in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Created KPI dashboards to identify the delays in web service responses, delay in record insertions into the DB, production down times, system health check status.
  • Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
  • Built few reports in Tableau for the management team to track the performance of representatives and their current business situation which is used as a single source of truth.
  • Developed data visualization using Cross tabs, Heat maps, Box and Whisker charts, Pie charts and Bar charts.
  • Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
  • Responsible for creating calculated fields, geo coding and hierarchies using Tableau Desktop.
  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Supported Tableau reports in production by performing daily health check on multiple dashboards and extracts to ensure that the dashboards are running properly, and the extracts are refreshed.
  • As a Tableau administrator, created report schedules on Tableau server, created groups, onboarded new users, assign/update user roles.
  • Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Technology & Tools: Tableau Desktop, Tableau Server, Tableau Online, Tableau Public, Tableau Reader, SAP Business Objects, Inquiry Framework, SQL Developer, Oracle

Confidential

Data Analyst

Responsibilities:

  • Single handedly taken care of the Application from Offshore and Resolving Various Issues Which are reported by Client in direct communication with client.
  • Developed and created classes with Dimensions, Detail and Measure objects.
  • Created complex reports by using hard coded method.
  • Created Standard daily, weekly and monthly reports.
  • Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula e etc.
  • Involved in Analysis, Development, and Testing.
  • Handled two Migration projects Business Objects XIR2 to Business Objects XI 3.1.
  • Played as the team lead for a small group in some of the projects.

Technology & Tools: SAP Business Objects, Toad, Sql Developer, SQL Server 2008

Confidential

Data Analyst

Responsibilities:

  • Lead the project from off shore.
  • Involved in Analysis, Development, and Testing.
  • Created logical and Physical Data Models.
  • Review the data model with functional Team.
  • Developed the daily, monthly and weekly reports.
  • Developed Inventory and TAT reports based on business days.

Technology & Tools: SAP Business Objects, Toad, SQL Developer, SQL Server 2008

We'd love your feedback!