We provide IT Staff Augmentation Services!

Bi Architect Resume

Tinley Park, IL

SUMMARY:

  • 9 Plus years of professional experience as IT consultant in Administration, Architecture, Design, Development and Deployment of data warehousing and business intelligence applications using Cognos 10 BI Suite, Cognos 8 BI Suite, Report Net, and Cognos Series 7.
  • Experience in developing and maintaining Framework Manager Models both Relational and Dimensionally Modeled Relational (DMR) models.
  • Experience on Cognos 10.2.2, 10.1.1 and Cognos 8 with Framework Manager, Analysis Studio, Cognos Connection, Report Studio, Query Studio, Active Reports, Dash boards, Workspace/Business Insight and Workspace/Business Insight advanced.
  • Experience in migrating reports from Cognos Series 7 to Cognos 8.4.1 and Cognos 8.4.1 to Cognos 10.1.1 and Cognos 10.1.1 to Cognos 10.2.2 and also troubleshooting and fine tuning the migrated reports
  • Expert in creating and publishing packages in the Framework Manager from various data sources in Report Net. Generated different kinds of reports in Report Studio, created templates and multilingual reports.
  • Experience in installation, configuration and administration of Cognos 8.3/8.4/ 10.1.1/10.2.2 in a distributed environment.
  • Experienced in implementing Cognos SDK and integrating Cognos with the corporate Reporting Portals.
  • Experience in configuration and setting up security (users/groups/roles and access privileges).
  • Experience in designing Complex Power play Transformer Models for building the cubes including Externally Rolled up measures
  • SQL Query writing and PL/SQL programming.
  • Expertise in Performance tuning of the existing Cognos Reports and Cubes.
  • Working knowledge on different data sources ranging from flat files, Oracle, PL/SQL Server, and DB2 databases, and SQL Server.
  • Highly motivated and focused problem solver with a passion to improve business processes by implementing innovative business solutions.
  • Extensively worked in interacting with Business Users to collect User Requirements.
  • Knowledge in SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re - building indexes and also used the Explain Plan and SQL Tracing.
  • Experience in writing, testing and implementing SQL/PL/SQL, Stored Procedures, Triggers and Functions.
  • Experience in writing sql queries, stored procedures, and table views.
  • Experience in working with different operating systems like Windows 2000/2003, Windows XP Professional, Windows NT, UNIX, Linux
  • Knowledge in Tableau, BIRT, Qlikview, Jaspersoft, Pentaho, Power BI, Talend, GE Informatics
  • Highly motivated, result oriented professional with a short learning curve and strong communication skills.
  • Web-based application development, framework object development experience.

TECHNICAL SKILLS:

BI Tools: Cognos 11/10.2.2/10.1.1/8.4/8.2/8.0 , Cognos Report Net 1.1, Report Studio, Query Studio, Framework Manager, Workspace and Workspace Advanced, Analysis Studio, Metric Studio, Event Studio, Cognos Impromptu, Cognos Transformer, Cognos SDK, Cognos Scheduler

Cognos Admin Tools: Meta Manager, Motio CI, Motio PI

Operating Systems: Windows 2000/2003, Windows XP Professional, Windows NT, UNIX, Linux

Languages: C, SQL, PL/SQL

Databases: SQL Server 2000/05/08, Oracle 8i, MS-Access

SQL Tools: SQL Assistant 6.2, SQL plus, SQL Query Analyzer

Database Tools: SQL Developer

Data Modeling Tools: MS Visio

Scheduling Tool: Opalis Integration Server

PROFESSIONAL EXPERIENCE

Confidential, Tinley Park, IL

Confidential,BI Architect

Responsibilities:

  • Experienced in writing Complex Report Studio reports using various prompts like Value Prompts, Date & Time Prompts, Text Box Prompts, Cascading prompts.
  • Complex reporting applications typically employed multiple query joins, cascading prompts, cube or relational drill-through, bookmarks, page sets, and embedded SQL functions. Developed reports producing multi-tabbed Excel outputs and PDFs with table of contents and bookmark links.
  • Experienced in testing and validating data in new or converted reports generated in Cognos 10.1.1/10.2.2 report studio against the SQL DB.
  • Worked with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
  • Created project requirements & design documentation.
  • Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
  • Designed, developed and delivered project solutions to specified requirements on schedule following appropriate IT methodologies.
  • Involved in implementation of complete life Cycle Phases of data warehousing projects.
  • Experienced in setting up the Complete Cognos Environment End to End using Windows 1-Tier and N-Tier Architecture (Distributed Environment).
  • Experienced in Installations, Configuration and maintaining the Cognos Software with additional set up like installation of Fix Packs, Patches, Configuration Changes, and fine tuning the settings for performance.
  • Experienced in Cognos upgradation from Cognos 10.1.1 to Cognos 10.2.2 version in a Distributed environment.
  • Experience on Cognos Administration activities includes Trouble shooting and diagnostic support.
  • Experienced in maintaining user accounts/securities in Access Manager. Managed scheduling of reports, maintenance of public and individual folders, distribution lists using Cognos connection in Production.
  • Provided after-hours and weekend support to ensure Cognos environment stability for internal/external client access and provided extensive support during month-end and monitoring the system performance.
  • Experienced in creating tabs, page lets to edit/change the Cognos portal home page appearance.
  • Interacted with client users to understand/solve their queries to change/add new fields in existing reports.
  • Maintenance of IIS, www services, Cognos configuration and regenerating the cryptographic keys.
  • Maintaining Framework Manager Models, Transformer Cube Models and cubes, migrating .mdl cube files from one server to another server and converting .mdl file into .pyj format to build cubes.
  • Migrated Transformer cubes from old servers to new servers and setup daily and monthly cubes for the better performance.
  • Experience in creating triggers and batch files for Transformer cube automation.
  • Experienced in Motio CI in Cognos Version Control, release management, automated testing, and setting up test scripts to monitor Cognos Dispatcher/Report Server performance. Strong knowledge on Motio PI.
  • Experienced in MetaManager in tracking the user securities, listing out all the Cognos scheduled reports, creating useful reports and documentation using content store documenter.
  • Experienced in creating Opalis Integration Server (Job Scheduling Tool) policies and troubleshooting and maintaining the Opalis.
  • Experienced in database backups, creating maintenance plans and recovery and migration. Knowledge on database security, HA (High Availability) solutions like; mirroring, Always-On Availability groups, Log shipping, database replication, performance tuning and clustering.

Environment: : Cognos 10.2.2, Cognos 10.1.1, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos workspace, Cognos Workspace Advanced, Framework Manager, Motio, Meta Manager, Windows XP, SQL Server 2008, Opalis Integration Server.

Confidential, Tinley Park, IL

Sr lead BI developer

Responsibilities:

  • Experienced in writing dashboard reports, complex Report Studio reports, Analysis Studio reports, setting up agents and events in Event Studio.
  • Experienced in preparing Framework Manager Models, Cognos Transformer Models, Cube building.
  • Created various List Reports, Cross Tab Reports, Chart Reports, Repeater Drill-Down and Drill-Through Reports, Master-Detail Relationships in Report Studio.
  • Complex reporting applications typically employed multiple query joins, cascading prompts, cube or relational drill-through, bookmarks, page sets, and embedded SQL functions. Developed reports producing multi-tabbed Excel outputs and PDFs with table of contents and bookmark links.
  • Created Heat Help Desk Ticket dashboards internally for Conifer - BI Development and EDMG.

Environment: : Cognos 10.1.1 Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Business Insight, Cognos Business Insight Advanced, Framework Manager, Meta Manager, Windows XP.

Confidential, Portland, OR

Business Intelligence Developer

Responsibilities:

  • Experienced in working directly with the end users, gathering business requirements and preparing confidential’s and also involved in preparing Data Dictionary.
  • Interact with the Line of Business for requirement gathering by participating in Joint Application design/development sessions to understand and document business requirements and development process.
  • Experienced in writing and understanding SQL queries.
  • Installation and Configuration of the Cognos 10.1.1 multi-server environment
  • Designed the Logical model that conforms to Data Modeling (Star schema, Snow Flake schema concepts), Different views (Import, Business, External) as per Business requirement
  • Involved in testing and validating data in new or converted reports generated in Cognos10.1.1 report studio against the SQL DB.
  • Created various List Reports, Cross Tab Reports, Chart Reports, Repeater Drill-Down and Drill-Through Reports, Master-Detail Relationships in Report Studio.
  • Implementation of Active Reports for each client for summarized data transactions
  • Created Complex reports using various prompts like Value Prompts, Date & Time Prompts, Text Box Prompts, Cascading prompts.
  • Used Render variables and data items to hide confidential information in the reports.
  • Provided drill-thru report functionality with drill thru to a different report in Report Studio.
  • Used variable like String and Boolean for all conditional formatting and rendering requirement.
  • Created Conditional Block reports to dynamically hide or show reports objects and provide the end user the option to view the data in different formats.
  • Developed complex reports, multi-query reports and sub select queries to meet the client requirements.
  • Involved in Deploying reports, packages from Development to Production environment.
  • Managed scheduling of reports, maintenance of public and individual folders, distribution lists using Cognos connection in Production.
  • Involved in implementing Business layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
  • Developed Standard Reports, Charts and Master Detail Reports using Report Studio.
  • Created a custom prompt page by enabling system driven cascade options, dynamic dimension selection and conditional display of prompts.
  • Create additional reports on an ad-hoc basis as requested by business users.
  • Training and guiding end user to help understand BI reports and reporting parameters.
  • Designing SharePoint site, providing report links for easy access to the end users.
  • Member of BI change control process, approving changes deployed from CognosDev to CognosUAT and Prod environment.
  • Send weekly BI team updates to the project manager.

Environment: : Cognos 10.1.1 Report Studio, Query Studio, Analysis Studio, Cognos Business Insight, Cognos Business Insight Advacned,Framework Manager, Share point, SQL Server 2008, Windows XP.

Confidential, Addison, TX

Reporting Analyst

Responsibilities:

  • Interacted with Business Users to prepare and update the Business Process Requirements and Software System Requirements.
  • Participated in daily meetings for project implementation in agile methodology.
  • Build Adhoc reports to support the business finance and administration part of the business from all supported EPM/EMR platforms
  • Designed, built & maintained an automated doctor productivity system measuring Visits, wRVU, & Gross Charges that tracked, trended, & compared current period to prior years and to current budget done to the doctor level. The information was retrieved from the billing system GE Centricity.
  • Effective involvement in Analysis and Design Phases, Enterprise reporting design, estimation and development.
  • Worked with stake-holders from Finance, Billing and Provider organizations to understand reporting and analysis requirements
  • Worked extensively in administering servers, optimizing performance, and set access permissions in Cognos 10.1.1.
  • Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
  • Designed the Logical model that conforms to Data Modeling (Star schema, Snow Flake schema concepts), Different views (Import, Business, External) as per Business requirement
  • Worked with the Conformed dimensions, Balanced/Un-Balanced Hierarchies, ragged Dimensions.
  • Setting up Cardinality (minimum, maximum & optional), Determents to avoid double counting, and supporting loop joins, optimize data source, and identify dimensions and facts.
  • Implemented Framework manager security for Data access, Object level access, Package access and Row level access.
  • Developed some custom report templates based on user requirements
  • Developed the Drill Through Reports, Master Detail Reports Using Report Studio and Query Studio.
  • Working experience with different date functions in Report Studio.
  • Created the Bar charts and list reports using Cognos Report Studio and Analysis studio.
  • Modified Power Cubes by adding new Dimensions, Levels and Measures.
  • Developed Dash Board reports in Report Studio.
  • Writing the Java Script in Report Studio Reports to display default values in value prompt.

Environment: Cognos 10.1.1/8.4/8.4.1 Framework Manager, Cognos Connection, Cognos Administration, Report Studio, Query Studio, Analysis Studio, Cognos Business Insight, Cognos Business Insight Advanced, SQL Server 2005/2008, Windows XP

Confidential, Flint, MI

Cognos Developer

Responsibilities:

  • Analyzing Requirement Specification document and preparing the Technical Specification document as per the Business requirement.
  • Setting up the Cognos 10.1.1 BI environment to Client locations by Installing and configuring all the Cognos 10.1.1 BI Components, Access Manager, Query Studio, Report Studio, Analysis Studio and LDAP directory server.
  • Involved in building models, packages using Framework Manger and published the packages to the Cognos Connection for the report authors.
  • Created the Multidimensional model using the framework manager.
  • Created multiple complex lists, cross tab, and chart reports, which involved lot of conditional formatting and different report outputs which include Excel, PDF and HTML.
  • Designed summary and detail reports which involves the key functionalities of the report studio like conditional blocks, conditional layouts. Designed reports which involve drill down, drill up and drill through functionalities in report studio.
  • Developed some analysis reports using analysis studio and defined some Drill-Through Definitions to report studio reports.
  • Responsible for troubleshooting Cognos BI Server issues.
  • Modified Power Cubes by adding new Dimensions, Levels and Measures.
  • Creating Analyses from the published cubes using Analysis Studio as per the Business needs.
  • Creating the scripts for the automation of cube building and publishing
  • Designed dimension maps and developed Transformer models and cubes in Power play Transformer.
  • Designed Cognos Transformer models using Impromptu Query Definition according to user needs.
  • Developed Dash Board reports in Report Studio using MDX Functions.
  • Writing the Java Script in Report Studio Reports to display default values in value prompt.
  • Worked on Cognos Administration in assigning Users, Groups, and User roles with access permissions.
  • Authored Complex Dashboard reports to show the number of reports runs per every hour and Number of Concurrent logins.
  • Experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production.
  • Trained Users on Query Studio for Ad-Hoc Reporting.
  • Unit testing, Integration testing and System testing of the reports in Development, Performance and production environments.
  • Maintained the configuration and change control of all Cognos application environments and associated documentation.
  • Bug fixes to the existing reports and problem Resolution to the issues raised by the users.
  • Continuously review the application architecture and suggest changes for improved performance.

Environment: Cognos 10.1.1/8.4/8.4.1 Framework Manager, IBM Cognos SDK, Cognos Connection, Cognos Administration, Cognos Go Dashboard, Report Studio, Query Studio, Analysis Studio, IIS Web Server, ORACLE 11g, SQL, Toad

Confidential, Philadelphia, PA

Cognos developer

Responsibilities:

  • Interacted with Business Users to prepare and update the Business Process Requirements and Software System Requirements.
  • Effective involvement in Analysis and Design Phases, Enterprise reporting design, estimation and development.
  • Installation and Configuration of the Cognos 8.3 multi server environment
  • Worked extensively in administering servers, optimizing performance, and set access permissions in Cognos 8.
  • Administered secured function and features in Cognos 8 that has to be available for users based on the Job title.
  • Developed Framework Manager Models having multiple data sources and published as multiple packages based on requirement.
  • Migrated Impromptu reports to Report Net using migratetocrn command and deployed migrated reports to Report Net using deploytocrn command.
  • Involved in migrating reports from Cognos Series 7 to Cognos 8.3 and also troubleshooting and fine tuning the migrated reports
  • Designed the Logical model that conforms to Data Modeling (Star schema, Snow Flake schema concepts), Different views (Import, Business, External) as per Business requirement
  • Worked with the Conformed dimensions, Balanced/Un-Balanced Hierarchies, ragged Dimensions.
  • Setting up Cardinality (minimum, maximum & optional), Determents to avoid double counting, and supporting loop joins, optimize data source, and identify dimensions and facts.
  • Involved in adding business rules by defining different kinds of calculations and filter.
  • Implemented Framework manager security for Data access, Object level access, Package access and Row level access.
  • Developed some custom report templates based on user requirements
  • Developed the Drill Through Reports, Master Detail Reports Using Report Studio and Query Studio.
  • Working experience with different date functions in Report Studio.
  • Created the Bar charts and list reports using Cognos Report Studio and Analysis studio.
  • Modified Power Cubes by adding new Dimensions, Levels and Measures.
  • Developed Dash Board reports in Report Studio using MDX Functions.
  • Writing the Java Script in Report Studio Reports to display default values in value prompt.
  • Multidimensional reports were created using Analysis studio.
  • Created Parameter Maps and Parameter variables for using the same package with different applications.

Environment: Cognos 8.3/8.4,Cognos SDK, SQL Server 2005, SQL developer, Windows 2003 Server

Hire Now