We provide IT Staff Augmentation Services!

Senior Business Intelligence Developer Resume

CA

SUMMARY:

  • Around 17 years of IT experience in analysis, design, development and implementation of Business Intelligence Reporting and Analytics using, Oracle, MS SQL Server, DB2, Redshift, IBM Netezza as backend databases on Windows 2008/2003/2000 platforms.
  • Experience in all aspects of BI enterprise Reporting, Analytics, Dashboards, Key Performance Indicators and Metadata Modeling using Cognos, Tableau and Business Objects.
  • More than 15 years of experience in Cognos BI tools like Cognos Analytics 11/Cognos BI 10 (Framework Manager, Report Studio, Workspace Advanced, Analysis Studio, Query Studio, Cognos Connection), Cognos 8 BI/8.1.2/8.2, ReportNet 1.01/ 1.1, Cognos 7.4 (Power Play, Transformer, PowerPlay Enterprise Server, IWR, Impromptu Administrator, Upfront, Visualizer, Access Manager, Server Administration, Report Administration).
  • Experience in building sophisticated metadata models from various data sources using Cognos Framework Manager. Implemented reports bursting, row level security based upon the value such that a user sees only rows that are allowed.
  • Experience in Cognos Transformer to build Multidimensional Cubes and performed incremental Cube updates. Solving Analytics Users & Business Users report problems, and provide accurate data for day - to-day decision-making.
  • Experience in technical architecture, creating complex BI Reports & Dashboards. Cognos Server Administration, root cause analysis, promoted best practices, customize Cognos Portal, and Report Templates.
  • Effectively used Data Blending, optimized Tableau Reports, provide various Dashboards and Views using Tableau Desktop that were published to the business stake holders and executive decision makers for further data analysis.
  • Experience in advanced Tableau functionality, provide self-service environment and Tableau security administration.
  • Experience in Business Objects best practices in the areas of Universe Design, Report Development, Business Objects Administration, managing Business Objects Repository and WEBI reports.
  • Excellent Verbal, Written, Presentation, and Interpersonal Communication skills.

SKILLS:

BI & OLAP Tools: Cognos Analytics 11.0.9 and Cognos 10.2.2 (FrameworkManager, ReportStudio, AnalysisStudio, WorkspaceAdvanced, QueryStudio, EventStudio, CognosConnection).Cognos Series 7.4 (Power Play, Transformer, PowerPlay Enterprise Server, Impromptu Administrator, IWR, Access Manager, Report Administration, Server Administration, Upfront, Visualizer).Tableau 10.4 (Tableau Desktop, Tableau Server, Tableau Online), Tableau Server Administration.BusinessObjects 6.5 (Reporter, Designer, Supervisor, BCA, Web Intelligence (WebI).

Tools: SQL Workbench, Aginity Workbench, ERwin PLSQL developer, TOAD, SQL* Plus, SQL* Loader, SQL Server Management Studio, Microsoft Visio.

Databases: MS SQL Server, Oracle, Redshift, IBM Netezza, IBM DB2.

Methodology: Agile, Waterfall, Star Schema, Snowflake Schema.

Languages: SQL, PL/SQL.

OS: Windows 2008 R2/2003

EXPERIENCE:

Confidential, CA

Senior Business Intelligence Developer

Responsibilities:

  • Regularly worked with project team members, business users and decision makers on a day-to-day basis to present solutions/options to problems. Review and make recommendations for improving processes to metadata models, cubes, dashboards and reports.
  • Utilized advanced Report development techniques and created complex Reports and Dashboards in Report Studio.
  • Good in translating business requirements into technical requirements including BI Reports, Dashboard layouts, KPI’s, and data mappings.
  • Created Agents, Tasks and Notifications in Event Studio from aggregated/summarized Metadata models to notify decision-makers when the data meets predefined thresholds and alert any report Job Failures.
  • As an Administrator troubleshooting problems with Cognos environment, Configuration Tuning, Load Balance, customized Report Templates, Portlets, Skinning Cognos Portal and maintain Cognos servers.
  • Worked on implementation of Cognos Analytics v11.0.3 in development and QA environments and involved in proof of concept and testing the upgrade activities for Cognos 10.2 reports.
  • OnCall 24x7 Production Support for all BI Tableau, Cognos servers, Cubes and Reports.
  • Strengthened Framework Manager modeling experience due to utilization of Cognos BI Best Practices. This included activities such as adding Determinants into Framework model where necessary, eliminating loop joins, custom SQL queries, modeling metadata as a star/snowflake schema, and so forth.
  • Created Dimensional Modeling (DMR) using Framework Manager, organized into Dimensions, Hierarchies, Levels and Measures to enable Drill functionality in Reports.
  • Worked with Cognos Transformer to create Models, performed incremental Cube build on large size data and generate Power Cubes by Externalizing Query Subjects using IQD as data sources in Cognos Framework Manager and other data sources like manual Impromptu Query Definition, CSV, Packages and Reports.
  • Implemented Dimensions, Levels, Alternate Hierarchy, Measures, assign security to Power Cubes, Custom views and User Class Views in the OLAP Cube design and development.
  • Created Email based Burst Reports and implemented row level security based upon the value such that a user sees only rows that are allowed.
  • Created Active Reports which are highly interactive and standalone Dashboard style reports.
  • Created Slicing & Dicing, Multidimensional comparison reports using Cognos OLAP capabilities of Analysis Studio and drill through targets to Reports.
  • Developed various Audit related reports in Report Studio to provide Audit details to management.
  • Generated Tableau Dashboards with Combination Charts, Scatter Plots, Stacked Bars, Pareto Charts etc.
  • Used custom SQL, Level-of-Detail (LOD) expressions, filters, parameters and calculated fields within Tableau Reports to facilitate data analysis and data visualizations.
  • Developed and reviewed custom SQL queries with use of joins clauses from multiple data sources in Tableau Desktop to validate and reconcile data.
  • Scheduled data extract refresh on Tableau Server for daily, weekly and monthly increments based on business needs to ensure that the workbooks show the most up-to-date data.
  • Worked with Tableau Desktop by connecting various data sources, combining multiple data sources using data blending, Data Extracts, Live Datasets and managing queries.
  • Published data sources using service account to Tableau Server to effectively manage and store data sources.
  • Used Control-M/Enterprise Manager tool for various Job batch processing & Serena Dimensions for version control.
  • Worked in Agile SCRUM development process. Used Jira & Serena TeamTrack for deployments and defect tracking

Environment: Cognos Analytics 11 & Cognos 10.2/Cognos 8.2 (Report Studio, Query Studio, Analysis Studio, Workspace Advanced, Framework Manager, Event Studio, Cognos Connection), Tableau Desktop 10.2.6, Tableau Online, Tableau Server/Administration, Jira, Confluence, Serena Team track, Serena Dimensions, SQL Workbench, Aginity Workbench, Redshift, Netezza, MS SQL Server 2008 and Windows Server 2008.

Confidential, CA

Cognos BI Consultant

Responsibilities:

  • Provided recommendations for strategic business decisions, managing stakeholder expectations, and analyzed complex multiple data sources to make sure it meets all reporting requirements.
  • Promoted best practices, prepared and implemented Cognos BI Standard Operating Procedures (SOPs) to streamline the reporting process.
  • Development of various complex Reports, Dashboard reports, Drill Through, Drill Up and Drill Down reports using Cognos Report Studio.
  • Created Dimensional Modeling using Framework Manager, organized into Dimensions, Hierarchies, Levels and Measures to enable Drill functionality in reports and also able to analyze Dimensions with Hierarchies and Levels to work in Cognos Analysis Studio.
  • Used Cognos Connection for organize objects, security, scheduling, and distribute reports.
  • Created email based Burst reports and implemented row level security based upon the value such that a user sees only rows that are allowed.

Environment: Cognos 8.2 BI (Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos Connection), ERwin Data Modeler 4.1.4, SQL Server DTS, MS SQL Server 2000 and Windows Server 2003.

Confidential, CA

Cognos BI Administrator

Responsibilities:

  • As an Administrator implemented various performance tuning techniques to increase processing efficiency, troubleshooting problems with Cognos environment, including Maintenance Release Upgrades, Configuration Tuning, and Auditing Report usage.
  • Involved in design phase of Data Mart modeling. Review and make recommendations to proposed Data Model prior to implementation.
  • Building an integrated ORACLE ERP Business Metadata model using Cognos 8.1 Framework Manager and accommodate data layer, intermediate layer and business layer for future growth.
  • Created complex reports using Cognos Report Studio features like Charts, Master Detail, Sections, Bookmarks, Conditional Blocks/Variables and embed JavaScript Code in an HTML item for navigation between the report views.
  • Using Query Studio created ad-hoc reports and data validation reports. Using Report Studio creating Business reports with custom Query Joins, Unions, Parameters, Prompts, and reusing a Layout objects.
  • Used Cognos Connection for organize objects, security, scheduling, deploy & distribute reports.
  • Created Dimensional Modeling (DMR), organized into dimensions, hierarchies, levels, and measures to enable Drill functionality in reports and able to analyze Dimensions with hierarchies & levels to work in Cognos Analysis Studio.
  • The Data Warehouse databases designed with Star Schema and Snowflake Schema.

Environment: Cognos 8.1 BI (Report Studio, Query Studio, Analysis Studio, Event Studio, Framework Manager, Cognos Connection), Cognos PowerPlay 8.2, Javascript, HTML, WinCvs, TOAD, Oracle 10.2.0.3 and Windows 2003.

Confidential, CA

Cognos BI Consultant

Responsibilities:

  • Building integrated Business Metadata Model using Cognos 8 Framework Manager and accommodate Data Layer and Business Layer for future growth.
  • Conducted training for Users on new Cognos BI components and provided technical knowledge to projects.
  • Created reports using Report Studio features like Master/Detail, Sections, Charts, Conditional Blocks, Conditional Variables, Advanced Conditional Styles and Conditional Layout.
  • Created new User accounts on Access Manager, worked on creating and defining various groups and roles on the Cognos Portal to streamline user access. Managing Cognos Connection for security, scheduling & distribution etc.
  • Created Business Models, calculated Measures, Multidimensional OLAP Cubes using Transformer and enhanced/modified existing Power Cubes as per the business requirement and applied security in Transformer Model.
  • The Data Warehouse was focused on building Dimensional Data Model using Ralph Kimball's methodology.

Environment: Cognos 8 BI (Framework Manager, Report Studio, Cognos Connection), Cognos Series 7 Version 3 (Impromptu Administrator, IWR, PowerPlay, Transformer, PowerPlay Enterprise Server, PowerPlay Web, Access Manager), MS SQL Server 2000 and Windows 2000.

Confidential, NY

Cognos BI Consultant

Responsibilities:

  • UsedFramework Manager to create Metadata Model from PeopleSoft’s ELM and HRMS Payroll data sources. Applied data level security and managed business-related metadata’s for the report authoring in ReportNet.
  • Extensively used Cascading Prompts, Conditional Variables, Subqueries, Page Set and Multiple Queries in Report Studio to deliver complex reports for business users to make strategic business decisions.
  • Managing Cognos Connection for security, deployment, scheduling & distribution of reports etc.
  • Discussed business requirements & mapped business needs using Cognos OLAP capabilities of Transformer and created Multidimensional reports, slicing and dicing using PowerPlay
  • For generating PowerPlay Cubes used (IQD) Impromptu Query Definition Manually, and Externalizing Query Subjects using IQD as data sources in Cognos Framework Manager.

Environment: Cognos ReportNet 1.1 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos 7.3(Impromptu Administrator, PowerPlay Transformer, PowerPlay Enterprise Server, Access Manager, Server Admin), Oracle 9i, TOAD and Windows 2000.

Confidential, IL

Senior Decision Support Systems Analyst

Responsibilities:

  • UsedFramework Manager to create Metadata Models from multiple data sources like PeopleSoft’s HRMS, EPM, and Oracle. Applied security and managed business-related metadata’s for the report authoring in ReportNet.
  • Developed complex reports using Master Detail relationships, Charts, Cascading Prompts, Report Variables, Subqueries, in Report Studio to deliver complex reports for business users to make strategic business decisions.
  • Worked with IWR report auditing to assess report activity, system performance of Impromptu Web Reports servers.
  • Created Cognos Transformer Models based on the Dimensions, Hierarchies, Levels, and Measures required for the business needs and analysis to build Multi-Dimensional Cubes, by creating business categories, alternate drill-down and Cube Groups.
  • Performed Server Administration and Report Administration. Migrated IWR to ReportNet ReportStudio Reports.
  • Successfully Migrated Impromptu Metadata Catalog to Cognos ReportNet environment.
  • Modified PowerCubes as per the user requirement by adding new Dimensions, Levels, Measures and Calculated Measures etc., Published Cubes and Reports to Upfront through PowerPlay Enterprise Server administration.
  • Saved business view of the data and publish the PowerPlay Portable Reports (PPX) to Upfront.
  • Creating the PowerPrompts applications through effective planning, to see Impromptu report from a single point of source just by applying different filters based on user’s selection criteria.
  • Created User Classes that matches needs of user community and provide users with focused view.
  • Written Macros, Batch files for automating tasks & Job Scheduling with Control-M
  • Generating Hot files and running an event on IWR servers based on Data Mart refresh and also generating the Models, refreshing the Cubes.
  • Deploying Cubes and PPX reports for the PowerPlay Enterprise Server.
  • Provided technical assistance, training and mentoring to Users and Business Partners.
  • Used Access Manager Administration to implement Authentication, Security to various User Classes for Cognos applications.

Environment: COGNOS ReportNet 1.1 (Framework Manager, Report Studio, Query Studio, Cognos Connection), COGNOS Series 7 Version 2 (Impromptu Administrator, IWR, Power Play, Transformer, Enterprise Server, PowerPlay Web, MS Visio, Access Manager, Configuration Manager, Server Administration, Report Administration, PowerPrompts, Notice Cast, Script Editor, Upfront), Control-M, MS SQL Server 2000, and Windows 2000.

Confidential, WI

Cognos Developer

Responsibilities:

  • Responsible to design & Implement Catalogs, reports using Cognos Impromptu Administrator. Involved in Publishing and managing of these Reports on Impromptu Web Reports Server.
  • Used Transformer to build Multidimensional Cubes, Alternate drill down, special categories. Created Models based on the Dimensions, Levels and Measures required for the analysis.
  • As per client requirements developed reports from ODS layer, in order to view latest data.
  • Published Cubes and Reports to Upfront through PowerPlay Enterprise Server Administration and personalized access to information using Cognos Upfront.
  • Optimizing reports by limiting the execution time of queries and balancing the client/server load.
  • Developed Visualizer Charts to make better decision making through Dashboards.
  • Implemented Business Metrics using Cognos Impromptu, PowerPlay and Visualizer.
  • Created Architect models including Joins, Prompts, and Filters.
  • Used Cognos Query for ad hoc reports and Users design Custom Queries on the Web.
  • Installing, Configuring and Performance Tuning Cognos EP Series 7 as BI tool.
  • Setting Access Manager Security for Users, User Classes to access the applications.
  • Train users in use of Cognos Cubes and Report functionality.
Environment: COGNOS Series 7 (Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay, Transformer, Enterprise Server, PowerPlay Web, Access Manager, Deployment Manager, Upfront, Server Administration, Report Administration, Architect, Visualizer, Cognos Query, CognosScript Editor), TOAD, Oracle 8i, and Windows 2000.

Hire Now