We provide IT Staff Augmentation Services!

Sr.bi Consultant /business Analyst Resume

Lynnfield, MA

OBJECTIVE:

Seeking a challenging position in an organization to increase my technical skills and expertise in Data Warehousing tools like Cognos 8x 10.2 (Report Studio, Framework manager), Cognos 10 .2and Oracle database

SUMMARY:

  • Cognos IBM Certified Professional with 10 +years of total IT industry experience analysis, design, testing, development and implementation of client/server applications
  • Having 11+ years of Data Warehousing technological experience in BI Reporting tool Cognos series
  • Experienced in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using Cognos 8.4 &10.2 Suite ( Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Go office), CRN 1.2, Cognos IMR 7.1.2.4, and Analysis Tools such as Cognos Transformer & Power Play .
  • Have 3+ Years’ Experience Tableau BI Report
  • 5 Years Experienced in OLAP Tool Transformer for build the Cube and MDX Reporting
  • Having Tableau Expertise in Administration, designing, development and deployment.
  • Have experience Administrative experience in Tableau Upgrade 8.3 to 9 .1
  • Administered user, user groups, and scheduled instances for reports in Tableau
  • 5+ Years’ Experience in Dashboard
  • Extensive experience in Tableau as a Developer/ Administrator.
  • Experience in Tableau server installation in Stand - alone/ cluster installations
  • Extensive Knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating users, sites and projects.
  • Create ODC Connection to database
  • Developed dash boards with rich Graphic visualizations, Drill Down and Drop down menu options, Parameterized using Tableau.
  • Experience implement SSO in Web service
  • Involved in installation of Tableau desktop 8.0, Tableau server Application software.
  • Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
  • Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 8.1.
  • Created incremental refreshes for data sources on Tableau server. Creating users, groups, projects, Data connections, settings as a Tableau administrator Cluster Setup
  • Extensively worked on Tableau Administrator and Tableau Server Implement Active Directory
  • Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
  • Quick learner and excellent Team Player, ability to meet project deliverables on time
  • Handled service requests for modification or changes in existing Report studio reports, Impromptu reports which are in Upfront
  • Understanding in using Oracle queries and awareness in SQL server
  • Strong development and analytical skills, proficiency in root cause data analysis, and Experience in Cognos 8.4 to 10.2 Migration, Created Power cubes Using Power play Transformer and published as package for Studios.Experience in Cognos And Tableau Production Support project
  • Handled Offshore and onshore team And requirement gathering .and interacting with end user resolving problem, Good understanding of business process in Life sciences (Insurance and health care )Other Banking finance
  • Extensive Knowledge on other BI Report Business Object And Qlikview Reporting Tool
  • Good understanding of ETL process and RDBMS Concepts
  • A self-starter willing to tackle new and challenging problems and able to work in a fast-paced environment, with strong problem solving skills

TECHNICAL SKILLS:

BI Tools: Cognos 7EP,Report Net MR 1.1,Cognos 8x,Cognos 10.1, 10.2, LCM (Life Cycle Manager, Business Object, Qlik View, Tableau

Management: Stakeholder Communications, Delivery Management, Software Management, Team Management, Account Management, Vendor Management

Databases: Oracle 9.x/10g/11g, SQL Server, MySQL, DB2, Informix

Domain: Insurance, Healthcare, Banking, Compliance and Federal Reporting Financial, Sales Manufacturing, HR

ETL: Knowledge on Informatica power center 9X, Data Stage, Remedy, Alteryx

PROFESSIONAL EXPERIENCE:

Confidential, Lynnfield, MA

Sr.BI Consultant /Business Analyst

Responsibilities:

  • Define, Create, and manage business specifications, technical specifications, and other project documentation for applications development.
  • Performed and documented gap analysis.
  • Create both logical and physical design of a database and ran the reports .
  • Created various Prompts, Conditions and Filters to improve the report performance By means of Detailed and summary filters, created various reports in Report Studio reports
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
  • Data Source creation and modification, Monitors performance on the application and Scheduling Reports according to the client Request
  • Participate in the Business and Specifications requirements gathering sessions and convert it into Design specifications. The Design specifications ranges from High level Design to Application level designs and (Cross) Application Interface agreements specifications.
  • Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
  • Handled Tableau admin activities granting access, managing extracts and Installations.
  • Generated Dashboards 5zwith Quick filters, Parameters and sets to handle views more efficiently.
  • Published Workbooks by creating user filters so that only appropriate teams can view it
  • Assist in business requirements gathering process, including working with end
  • Users to interpret functional requirements into report specifications. Involving in writing complex SQL
  • Queries to verify data from Source to Target Performed data validation testing writing SQL queries

Environment: Tableau Desktop 9.3 Tableau Server 9.3, Oracle SQL, Alteryx

Confidential, NY City

BI Team Lead/Business Analyst

Responsibilities:

  • end user reporting Handling supporting requirements by developing Reporting solutions on the Tableau and Cognos BI platform. This role will work within the Corporate IT department and support day to day reporting needs for multiple businesses
  • Involved in Development, Production Support, Upgrade, Testing. Updated the System Requirement Specification (Ticket) with the change requests.
  • Connected Tableau server to publish dashboard to a central location for portal integration.
  • Handling Tableau server Administration to publish dashboard to a central location for portal integration.
  • Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
  • Data blending implemented on EMPI databases and generated interactive dashboards. Created adhoc reports to users in Tableau by connecting various data sources.
  • Handled Tableau admin activities granting access, managing extracts and Installations.
  • Generated Dashboards 5zwith Quick filters, Parameters and sets to handle views more efficiently.
  • Published Workbooks by creating user filters so that only appropriate teams can view it
  • Implement Tableau 8.3 to 9.0 Upgrade.
  • Handling Installation and server maintained and back up, User security, coordinate Different Project team
  • Played role Onsite SME handling offshore team. Requirement gathering and involved Business Analysis, document creation, report functional documents.
  • Design and support public folder reporting via Cognos Report Studio, Query Studio, including any user defined delivery methods.
  • Accommodate new and existing business requirements. Assist in business requirements gathering process, including working with end Users to interpret functional requirements into report specifications. Provide support Analyzed the Report Test Data used for Unit and Integration Testing
  • Used Set function manual and automation.
  • Created Advanced grouping function.
  • Handling Performance Recording and analyzer
  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Created various Prompts, Conditions and Filters to improve the report performance By means of Detailed and summary filters, created various reports in Report Studio reports

Environment: Tableau Desktop 8.3Tableau Desktop 9.0 Tableau Server 9.0, Informatica9.0 Oracle SQL, Cognos 10.2,, MS Office Suite, Alteryx

Confidential, Lake Oswego

BI Team Lead

Responsibilities:

  • Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
  • Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Used Sheet filters to produce multiple chart types in a single view.
  • Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types and Used Set function manual
  • Created Advanced grouping function.
  • Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
  • Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
  • Using alteryx for Data Belding And Data Transposing,
  • Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Analyzed the source data and handled efficiently by modifying the data types.
  • Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
  • Generated context filters and used performance actions while handling huge volume of data.
  • Generated tableau dashboards for sales with forecast and reference lines. User Java Script API to customize the views, selects, filters, date and time.
  • Generated tableau dashboards with combination charts for clear understanding.
  • Played role Onsite SME handling offshore team. Requirement gathering and involved Business Analysis, document creation, report functional documents.
  • Connected Tableau server to publish dashboard to a central location for portal integration.
  • Created visualization for logistics calculation and department spend analysis..
  • Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Environment: Tableau Desktop 8.0 / 8.2V/8.3 Tableau Server 8.0/8.2V/8.3, Alteryx version 4.0.2.1 MS Office Suite, Oracle SQL MS Excel, q1

Confidential

Sr. BI Tableau Developer

Responsibilities:

  • Participate in the Business and Specifications requirements gathering sessions and convert it into Design specifications. The Design specifications ranges from High level Design to Application level designs and (Cross) Application Interface agreements specifications.
  • Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
  • Worked extensively with MS Visio and Rational tools to document requirements
  • Created the AS-IS and TO-BE process flow diagrams
  • Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
  • Developed business, functional and/or technical requirement specifications adhering to standard requirement templates.
  • Define, Create, and manage business specifications, technical specifications, and other project documentation for applications development.
  • Performed and documented gap analysis.
  • Create both logical and physical design of a database and ran the reports .
  • Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart and refresh strategies
  • Analyzed existing business requirements in Tableau.
  • Designed and developed various Weekly and Monthly reports showing detailed information that could be used to send information to diverse group of users, clients, and managers.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.

Environment: Cognos 8.4.1,Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential

BI Sr. Consultant

Responsibilities:

  • Worked with users and coordinated with application developers to understand and capture data/reporting requirements. Also worked on complete life cycle of Cognos BI Project (Installations, Security, Configurations, Migration and deployment).
  • Created Dash Boards for multiple views of Reports from multiple data sources. And Crosstab reports using DMR Models, also improved the turnaround time by tuning some of the functionalities.
  • Designed Cognos Power Cubes to provide analytical solutions for complex business requirements.
  • Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc. Used Union/Join objects in Report Studio
  • Worked on complex reports involving Drill-Through Definitions, Multi-query, and Master/Detail relationships. Involved in creating security and deployment (exports and imports).
  • Worked on performance tuning of reports and testing at different stages.
  • Setting up different security groups and giving them required permissions to specific reports.

Environment: Cognos 10.1/10/8.4, Report Studio, Framework Manager, Query Studio, Event studio, Power play Studio, Analysis studio, Powerplay transformer 8.4 Oracle10g, and windows.

Confidential

BI Sr. Consultant

Responsibilities:

  • Developed several Impromptu reports with Prompts, Filters, Conditions and Calculations.
  • Designed and developed Catalogs, developed different types of reports such as List reports, Group reports, and Cross Tab reports. Customized the reports using List Frames, Form Frames, and Chart Frames and sub reports are extensively worked on understanding the business requirements and designing Cognos applications.
  • Created Filters within the Model cognos 8.4.1Developed various standard reports like list reports, cross tab reports and Drill through reports using report studio.
  • And Involved in performance tuning of the Reports and unit testing of the reports.
  • Created master/detail, drill through reports to link two or more reports.
  • Created various Prompts, Conditions and Filters to improve the report performance By means of Detailed and summary filters, created various reports in Report Studio reports
  • Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports Cognos access is given to users through Active Directory. Added user classes based on the requests.
  • Performed Unit testing and preparation of test cases

Environment: Cognos 7(Impromptu,) Cognos 8.4.1, Cognos 10. Report Studio, Framework Manager

Confidential

BI Sr. Consultant

Responsibilities:

  • Built the Model using Framework Manager Model and worked extensively on creating the Model and publishing the package for Reporting purposes.
  • Developed Prompt pages and Conditional Variables, Created Prompts like value, Textbox, Date & time and cascading prompts,
  • Created New calculations according to the report specifications,
  • Involved in performance tuning of the Reports and Involved in unit testing of the reports.
  • And Developed various standard reports like list reports, cross tab reports and Drill through reports using report studio,
  • Worked extensively on creating the Model and publishing the package for Reporting purposes

Environment: Cognos 8.4 (Query Studio, Reports Studio, and Framework Manager, Informatica)

Confidential

BI Sr. Consultant

Responsibilities:

  • Confidential Cognos migration project aims at upgrading all the reports from 7.1 and 7.4 and Also from 7.4 to Cognos 8.4 version. Approximately 410 Reports has to be Upgraded to 7.4 and then to Cognos
  • 8.4 as a part of this migration The scope of this project Includes Development, Unit Testing and Regression testing. Adobe Professional is used to compare the PDF outputs from 7.4 version reports with IWR Upfront and the same is been used to compare the outputs of Cognos 8.4 with Impromptu 7.4 reports. Comparison tool.
  • Confidential Cognos Upgrade
  • Confidential is a web-based application that captures transactions overnight from several source systems within BMO Capital Markets and loads them into one central Oracle database. From this database, authorized users may generate reports or perform any necessary maintenance to deal records, using their Internet browser.
  • This project deals with upgrade of the Cognos reports from 7.1 to 7.4. The scope of this project is to Upgrade and Regression test. Around 410 reports are to be migrated consisting of different set based on the functionality and line of business.
  • Adobe Professional is used to Compare/Test the reports between 7.1 and 7.4. Also Excel comparison is used to ensure the accuracy of the data. Reports run from the client versions are saved in PDF and then same has to be compared with the PDF outputs of Cognos Upfront reports which are in 7.1 versions.
  • Worked extensively on creating the Model and publishing the package for Reporting purposes.
  • Created Filters within the Model, Developed various standard reports like list reports, cross tab reports and Drill through reports using report studio
  • Developed Prompt pages and Conditional Variables, Created Prompts like value, Textbox, Date & time and cascading prompts, Created New calculations according to the report specifications
  • Involved in performance tuning of the Reports, and unit testing of the reports

Environment: Cognos 8.4 (Query Studio, Reports Studio, and Framework Manager, Cognos Impromptu 7.1, 7.4)

Hire Now