We provide IT Staff Augmentation Services!

Bi (tableau, Cognos) Architect Resume

Albany, NY

SUMMARY

  • Having Overall 15 years of IT work experience.
  • Experience in Business Intelligence tools - Tableau Desktop 2020.4,10.x/9.x, Tableau Server, and Cognos BI suite 11.x/10.x/8.4x
  • Hands on experience on Tableau Desktop versions 2020.4, 10.3/10.2/9.3/9.2 , Tableau Reader, Tableau Server, Cognos BI suite 11.x/10.x/8.4x.
  • Produced attractive visuals/dashboards to convey the story inside the data.
  • Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Involved in trouble shooting of performance issues which were associated with Tableau reports.
  • Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
  • Migrated reports from Cognos 8 BI (8.4) to Cognos 10 BI (10.1 and 10.2), Cognos 10 BI (10.2.2) to Cognos 11 BI (11.0.5),
  • Reviewed the Cognos Framework Manager model developed in development environment by other team members. Upgraded reports from 8 BI Series to 10 BI Series and 10 BI Series to 11 BI series.
  • Extensive experience in cube building using power play transformer.
  • Strong knowledge and experience in Data warehousing concepts and Dimensional modeling and Relational modeling.
  • Extensively worked on Cognos Framework Manager, DMR modeling (Regular dimensions, Measure dimensions and set of scope).
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP report environment.
  • Experience in creating reusable transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter and Rank) mappings using Informatica designer and processing tasks using workflow manager to move data from multiple sources into targets.
  • Successful track record in project life cycle implementations.
  • Experience creating Cognos dashboards and complex reports.
  • Experience writing reports with IBMCognosAnalytics
  • Experience building and maintaining IBMCognosAnalytics Framework Manager models
  • Experience building and maintaining Transformer Power Cubes
  • Experience on Multi-dimensional cubes on Transformer.
  • Strong communication to provide training to end users
  • Have ability to understand XML and modify based on the requirements.
  • Experience and work with data quality control.
  • Experience using technical specifications like Tableau and Cognos to develop reports and advanced analytics.
  • Experience in Cognos Reporting using Medicaid.
  • Developing Framework Manager models by leveraging Cognos recommended design techniques
  • Created project plans with predetermined benchmarks, milestones, dependencies and risk indicators.
  • Good knowledge and experience in different domains like Baking, Healthcare, Pharma, Retail, Insurance, Manufacturing and Finance.
  • Expertise in system analysis, requirement gathering, functional studies, design, coding, testing and application Maintenance.
  • Strong experience in writing SQL queries for data validations.
  • Perform Data Analysis and Data Modeling Solutions as per Client need based on established best practice methods of Cognizant's Artificial Intelligence Analytics - Business Intelligence Business Unit Practice strategy.
  • Interaction with different Business teams i.e. Business User team, Admin team, ETL team, Systems Analyst, Source system team, DBA
  • Good knowledge in data warehousing concepts and possess analytical skills
  • Good Knowledge in SQL/PLSQL
  • Developed dimensional reports using MDX functions against DMR models and cube data sources.
  • Used Java script in Cognos report studio to customize the reporting functionality to meet the business requirement.
  • Strong experience in deployment (Dev to QA and QA to Prod) and migration.
  • Extensively worked with business users to gather the business requirement and Prepared Business requirement document (BRDs) based on the business conversations.
  • Prepared Functional design specifications (FDS) and technical design specifications (TDS).
  • Worked and handled offshore teams to communicate the business conversations and meet the project deadlines.
  • In every project followed data warehousing and IBM best practices.
  • Strong communication, interpersonal, time management and technical skills.
  • Strong experience in unit testing, functional testing.
  • Prepared knowledge transfer documents in end of each project and provided end user training.
  • IBM Certified in IBM Cognos 10 BI Administration, Metadata Modeling and Report Authoring.
  • Multinational (USA, India, Germany, Kuwait, UK and Philippines) exposure in different BI projects.

TECHNICAL SKILLS

Tableau & Cognos BI Reporting and Administration: Tableau Desktop 2020.4,10.x/9.x, Tableau Server, Cognos BI suite 11.x/10.x/8.4x

Cube designer: Power play Transformer, Dynamic cubes

ETL: Informatica, Data stage

Programming and Scripting: C++, SQL, PL/SQL, JAVA

Script Technology: JavaScript HTML

Operating Systems: Windows 2003/2008 R2/2012 server, Windows Professional, Linux and Unix.

PROFESSIONAL EXPERIENCE

Confidential, Albany NY

BI (Tableau, Cognos) Architect

Responsibilities:

  • Understanding the business requirements and analyzing the feasibility of those requirements.
  • Working with other designers, end-users, and managers to determine the scope and need for different data visualization tools.
  • Design the set-up and security of applications, dashboards, and other tools made using Tableau software.
  • Document new data mart requests, modifications, and accompanying reports.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.
  • Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security.
  • Interacted with the existing database developers and DBA to understand the existing schema.
  • Establishing connections to Data Sources.
  • Adding or Creating Dimensions, Measures and Calculations.
  • Performing Data Modeling in Tableau Desktop.
  • Used advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
  • Defined best practices for Tableau report development.
  • Developed Dashboards using calculations, parameters in Tableau.
  • Work as part of a team on activities such as unit, system and user acceptance testing, data validation, documentation, and knowledge transfer.
  • Support improvements in business process and OCFS Data Warehouse reporting which deals with social service-related data to meet OCFS reporting needs
  • Respond to data requests.
  • Created complex reports by using Cognos 11 Analytics.
  • Developed Framework Manager Packages.
  • Modified and maintained COGNOS models
  • Perform deep dive analysis to effectively translate broad data sets into actionable results, present findings, and recommendations
  • Work collaboratively with client success team, clients, consultants, and specific geographic market across our book of business.
  • Define, create, document and implement ad-hoc reports/analytics.
  • Experience in data requirement elicitation, validation, reporting design, and quality assurance.
  • Utilize existing reporting utilities to optimize internal/external customer analytics and strategy
  • Delivering key reports and dashboards with interpretation; contribute to the development of hypotheses and actions and communicate data findings effectively to individuals and groups
  • Working directly with external and internal clients to gather and analyze requirements and translate into the design of applications, reports or other required output.
  • Ability to identify multiple solutions and assessing them for both technical and business suitability.
  • Resolved issues resulting from User Acceptance Testing (UAT).

Confidential, New Jersey

Senior Tableau Developer

Responsibilities:

  • Collaborated with Program office, subject matter experts, and IT teams to define the business requirements and transform them into functional, non-functional, and technical requirements.
  • Reviewed the application code, packages developed by business partner and created BRM documents and Bus matrix to design the data model for reporting system.
  • Connected to different data sources like Excel, Text/CSV, Folder, SharePoint, Oracle, and transformed the data to perform ETL duties like Data cleaning and Data shaping as per the requirements
  • Combine data sources by joining multiple tables and using data blending.
  • Responsible to develop reports and dashboards using Tableau Desktop and publish them using Tableau Server
  • Build the advanced chart types and visualizations like Pie chart, column chart, bar charts, Bullet graphs, Tree map, Scatter plot graph, Histogram graph, Box-Whistle graph, Word Cloud & Bubble charts.
  • Using advanced Statistics and Forecasting like (Trend Lines, Forecasting).
  • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
  • Used Trend Lines, Reference Lines and statistical techniques to describe the data.
  • Responsible for dashboard design.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Developed reports in Power BI Desktop and created Dashboards in Power BI Service by applying different visualizations such as Column, Bar, Line, Clustered, Area, Pie, Donut, Matrix, Slicer, Treemap, Gauge, Map, Card, and KPI etc.
  • Created business-oriented Reports and Dashboards by applying Visual, Page, Report and Drill through filters and fully customized them by using Conditional formatting, Selections, Buttons, and Bookmarks.
  • Created Row-level security on datasets and implemented them in the Power BI Service.
  • Utilized Power BI Gateways to keep reports and dashboards up to date with on-premises data sources.
  • Built Dataflows in Power BI Service and created shared Datasets for a multi developer design environment.
  • Created Workspaces and content packs for business users to view the developed reports and Dashboards.
  • Created customized Paginated reports using Power BI Report builder
  • Building the necessary staging tables and worktables on oracle development environment.
  • Developed Mappings, Mapping configuration tasks and replication tasks to extract, validate and transform data according to the business rules.
  • Created validation rules, workflow rules, roles, profiles, users, sharing rules as per requirement.
  • Extensively worked in performance tuning of the programs. ETL procedures and processes.

Confidential, Rochester NY

Cognos Architect

Environment: Cognos 11.0.5/10.2.2 , Oracle 11g, Informatica 9.5, Control M Scheduler, Windows 2012 server

Responsibilities:

  • Prepare the project plan for Upgrade from Cognos 10.2.2 To Cognos 11.0.5 version.
  • Project Setup, installation-configuration and implementationof Cognos BI 11.0.5 Suite.
  • Upgrade from Cognos 10.2.2 version To Cognos 11.0.5.
  • Verify the source environment and target environment use life cycle manager.
  • Implement the security levels in framework manager level.
  • User Security implementationusing Cognos Authentication Manager with Active Directory Server
  • Data Source creationin Cognos Connection, package migration across development and production environment
  • Application maintenancetasks like reconfiguring content store, User ID creation and maintenance, assigning privileges to objects.
  • Configured Active directory name space to Cognos.
  • Administered tasks such as Scheduling, Deployment, and Dispatchers.
  • Maintenance and troubleshooting of Cognos OLAP environment.
  • Interact with the Business users for requirement gathering.
  • Deployed data from one environment to another environment.
  • Understanding the business requirements and analyzing the feasibility of those requirements.
  • Created Dashboards by using Cognos 11 Analytics.
  • Created a Framework Manager Models with multiple Namespaces, calculated columns, filters and created packages to suit the reporting needs of the client
  • Wrote simple to complex SQL queries in the process of unit testing of the reports.
  • Worked on MDX functions.
  • Created cubes using Power Play Transformer.
  • Created List reports, Crosstab reports and Drill through reports and Complex reports as per the user requirements.
  • Used Conditional block, Condition Style and render variable while developing reports
  • Developed complex mappings in Informatica to load the data from source files using different transformations.
  • Extensively worked in performance tuning of programs, ETL procedures and processes. performed unit testing of the mappings. Involved in writing the test cases and also assisted the user in performing UAT.
  • Documented ETL development standards as per client requirement.

Confidential, NY

Tableau Technical Lead

Environment: Tableau, QlikView 10, SSIS, SQL Server 2008, IBM DB2, Windows XP

Responsibilities:

  • Understanding the business requirements and analyzing the feasibility of those requirements.
  • Participating in user meetings to analyze and prepare the reporting and analysis requirements of users.
  • Responsible to work with the Business Analysts and Business Users for the requirement gathering for report generation.
  • Using advanced Statistics and Forecasting like (Trend Lines, Forecasting).
  • Use Trend Lines, Reference Lines, and statistical techniques to describe the data.
  • Responsible for dashboard design.
  • Combine data sources by joining multiple tables and using data blending.
  • Very strong with Tableau Desktop for data visualization, Reporting and Analysis, Dual Axis Maps, Scatter Plots, Geographic Map, Do nut charts, Pie Charts and Bar Charts.
  • Used ETL (SSIS) to develop jobs for extracting, cleansing, transforming, and loading data into data warehouse.
  • Involved in performance tuning of TSQL queries and stored procedures.
  • Involved in Unit Testing and prepared the Test cases.

Confidential, Connecticut, NY

Senior Tableau Developer

Environment: Tableau 8.0 Desktop, MS SQL Server 2008R2/2005, Windows 7/XP, Data Stage7.5

Responsibilities:

  • Understanding the functional and technical specification.
  • Experience with the design and development of Tableau visualization solutions.
  • Building, publishing customized interactive reports and dashboards, reports scheduling using tableau server.
  • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Effectively used data blending feature in tableau. Defined best practices for Tableau report.
  • Resolved issues resulting from User Acceptance Testing (UAT).
  • Developed and supported ETL jobs using IBM Data stage 7.5 tool.
  • Developing ETL solutions, using data stage 7.5, Teradata and Unix shell scripting methods.
  • Understand the project scope, identify activities/tasks, task level estimates, schedule, dependencies, risks and provide inputs to client tech lead for review.

Hire Now