We provide IT Staff Augmentation Services!

Bi Consultant Resume

SUMMARY

  • I have 15+ years of experience in Data Warehousing & Business Intelligence projects for Retail, Banking and Consumer Goods Sectors.
  • Good technical expertise in Tableau 2019.2/ 10.5/10.1/9.3 , Cognos Administration, Cognos Framework Manger, Cognos Query Studio, Cognos Report Studio, ROAMBI 3.x,4.1
  • Involved in end - to-end project activities from defining project roles and responsibilities, detailing project plans, requirements gathering and specification to implementation, testing and support.
  • Experience in developing Tableau Dashboards, Datasources depends on business requirements.
  • Experience in developing Business models using Framework Manager and published packages to Cognos Connection in Cognos 10 and 8 series depends on business requirements.
  • Experience with full Project/QA Life cycle (SDLC) from Requirement analysis to User acceptance Testing (UAT) for BI reports.
  • Highly skills in communicating the business process to stakeholders, development and technical teams as well as the end users.
  • Having good experience in L2/L3 Production Support and Maintenance Releases.
  • Efficient team member with effective co-ordination and communication skills coupled with Pro-activeness, dynamism, attention to detail and quick learning abilities.
  • Capable of working independently as well as in a team
  • Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation, enhancements and production support.

TECHNICAL SKILLS

Operating System: Windows 2008, Windows 10, Windows 7, Windows XP, Mac

Database: Oracle 8i/9i/10g, Microsoft SQL Server 2005, Teradata V2R5 /13/15, Snowflake 2.0 and Netezza

Reporting & ETL Tools: Tableau 10.5/10.1/9.3 , Cognos 11.0.6/10.2/8.4/8.2 (Framework Manager, Query Studio, Report Studio, Administration), ROAMBI 4.1/3.x, Business Objects 6.5, Alteryx 2018.1, Datastage 9.1

Database Client Tools: TOAD for Oracle, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential

BI Consultant

Tools: Tableau 2019.2/18.3/10.5 , Cognos 11.0.6, Teradata 15, Snowflake 2.0, Alteryx 2018.1

Responsibilities:

  • Developed Dashboards using Filters,Parameters, Action Filters and Calculated Fields.
  • Developed Dashboards using Line, Area, Gantt and Stacked Bar charts.
  • Restricted data for particular users using Row level security.
  • Developed Dashboards from multiple data sources using Data Blending.
  • Modified XML code to replace Tableau published server data source in TWB files.
  • Scheduling Dashboards/Data sources using Tableau Server.
  • Tabcmd commands has been used to take backup of Dashboards & Datasources.
  • Create and review product/project deliverables as per the software development life cycle methodologies.
  • Analyze the Business requirement documents provided by business analyst and develop the new reports or dashboards, modify existing Cognos/Tableau reports under tight deadlines.
  • Implement necessary changes in Cognos Framework manager package which is further used to develop Cognos/Tableau reports and dashboards.
  • Post development test the reports against Teradata & Snowflake database and work with business analyst to get the sign-off on the development work.
  • Deploy the reports from Global developments environment so that local teams can consume them and create necessary views in their environments.
  • Used Tableau Desktop, Alteryx for blending databases and creating different interactive views and dashboards.
  • Resolve the bug fixes raised by the business.

Confidential

BI Lead

Tools: Tableau 10.1/9.3, Cognos 11.0.6/10.2 Teradata 15

Responsibilities:

  • Developed Dashboards using Filters, Parameters, Action Filters and Calculated Fields.
  • Developed Dashboards using Bar,Line and Area Charts.
  • Scheduling Dashboards /Data sources using Tableau server.
  • Tabcmd commands has been used to take backup of Dashboards & Data sources.
  • Performed the functionality testing on Dashboards from 9.3 to 10.1.
  • Performed functional testing of Tableau Dashboards in MAC and iPad.
  • Involved in troubleshooting and performance tuning of reports and resolving issues within Cognos/Tableau Dashboard and Reports.
  • Implement necessary changes in Cognos Framework manager package which is further used to develop Cognos/Tableau reports and dashboards.
  • Involved in reviewing requirements and data sources from Teradata, excel for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Involved with UI Developer on favorites functionality in Sales Portal.
  • Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Confidential

Sr. BI Developer and Offshore Lead

Tools: Tableau 9.0, Microsoft SQL Server 2005

Responsibilities:

  • Extensively interacted with the stakeholders and the IT Department in finalizing the requirements.
  • Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and end users for Requirement gathering in Definition Stage.
  • Developed Dashboard reports using Bar, Line charts.
  • Developed data source for the users to create ad hoc reports.
  • Automated data refresh through Tabcmd commands once the data load is completed in ETL.
  • Attended Daily Stand-Up Meetings with the customer.
  • Involved in preparing unit Test Plans based on User Requirements Document (URD) and prepared the Test Cases.
  • Supported testing team during the performance testing on Tableau reports.
  • Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Confidential

Delivery Service Lead

Tools: Datastage 9.1, Teradata 13

Responsibilities:

  • Handled multiple Development projects and successfully implemented those projects.
  • Responsible for Project delivery, Weekly status report, Deliverable and Timesheet.
  • Responsible for resource allocation, implementation support and handing over the project to warranty team.
  • Create task in Rational Tool concert (RTC) and assign the tasks to each team member.
  • Conducted Weekly status meeting with the Client project manager and update the project and financial status.
  • Responsible for getting the sign off for SLA & OLA documents from the upstream and downstream stakeholders before the implementation.
  • SLA has been adhered in all the projects to get the pre-cab and cab approval for implementing the project.

Hire Now