We provide IT Staff Augmentation Services!

Senior Cognos Architect Resume

Houston, Tx

Professional Summary

  • A proficient professional with 10+ years of experience with System Analysis, Development & Testing in the field of Data warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS), Customer OLAP, Reports Generation and Web development.
  • Adept at designing and development of data warehousing reports using COGNOS 10, COGNOS 8 (Report Studio, Query Studio, Analysis studio, Event studio).
  • Possess strong oral, written and organization skills, excellent time and project management skills and a strong ability to prioritize tasks. Self-motivated and industrious professional with good technical, communication and leadership skills.
  • Carries a positive attitude, enthusiastic and a firm believer of team work.
  • Involved in the full Project Life Cycle of the Data Warehouse Project and exposure to client interaction and user-requirement analysis.
  • Mentored and trained users for the successful execution of the project
  • Managed project teams of more than 6 members in an onshore-offshore model to successfully meet project deadlines and commitments
  • Experience spans all the phases of life cycle of software development such as Requirement Gathering, Requirement Analysis, Estimations, Planning, Coding, Testing and Post Production Support.
  • Experience in BI Tool Cognos 10 (Business Insight, Business Insight Advanced, Framework Manager and Report Studio).
  • Experience in working with Cognos 8.x. (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio and Cognos Connection).
  • Expertise in Framework Manager Meta Data Modeling (Database Layer, Intermediate Layer, Presentation Layer, Packages, Dimensional Data Modeling) and Complex Report building with Report Studio.
  • Deploying models and reports from Development to Production and administering users/groups/roles.
  • Strong Complex Reporting skills -- complex Drill-Through, Dashboards, Summary Reports, Burst Reports, ad-hoc reporting and advanced report authoring.
  • Experienced in preparing technical specification documents such as Global requirement Gathering Documents (GRG), New Product Development (NPD).
  • Experience in developing new reports and customizing existing reports and change request processing.
  • Expertise in creating complex reports in Report Studio (List reports, Cross-tab reports, Drill through reports).
  • Expertise in OLTP/OLAP System Study, Analysis, developing Database Schemas like Star Schema & Snowflake Schema used in Relational, Dimensional and Multidimensional modeling.
  • Proficient in coding using SQL, Scripting, Stored Procedures.

TECHNICAL SUMMARY: -
Languages/Tools
PL/SQL, SQL, JavaScript, AJAX, JQuery, HTML, DHTML, PHP, Perl, Flex

Databases
Oracle 9i & 10g, MS SQL, Server 2005 & 2008, MS Access, My SQL

Operating Systems
Windows NT/95/98/XP/Vista/7, Linux

OLAP/BI
COGNOS 10, COGNOS 8i (Report Studio, Query Studio, Analysis studio, Event studio, Transformer & Framework Manager

Functional
  • Responsible for Design & Enhance the Framework Model, Cognos Reports and Dashboards based on the business requirements.
  • Provide global Application Support for users across the countries. Direct Point of Contact for Super Users and participate in Business requirement analysis, Functional design documentation.
  • Interacting with offshore team for technical discussions and product delivery.
  • Troubleshooting and enhancing the existing reports with recommendations to suit the business requirements for existing/new reports.
  • Developed customized reports with Drill down and Charts
  • Performance tuning of the reports and prepare SQL Test scripts for COGNOS Reports
  • Migration of reports from Cognos 8.2 to 8.4, 8.4 to 10 & Cube Implementation using SSAS.
  • Responsible for training the team members with the new features of Cognos BI 10.x.
  • Developed complex reports using Report studio to assist organization's Decision making system.
  • Involved in Data Warehousing team to build the Star schema and Snowflake schema.
  • Created Data source query subjects, Model query subjects, Stored procedure query subjects as per the business requirements in the Framework Manager
  • Established Dimensional Modeling in Framework Manager by creating Regular dimensions, Measure dimensions, Hierarchies and Levels.
  • Enhanced the Packages by Refining Joins, Segmenting, Linking, and Nesting. Created specific Filters at package level.
  • Created & Published the Packages according to the business requirements.
  • Created Ad-hoc, List, Crosstab, Charts and Drill through Reports by using Query Studio and Report Studio.
  • Created Value prompts, Date Time prompts, Text box prompts, Cascading prompts and Tree prompts.
  • Scheduled Reports to run on a monthly, weekly, and daily basis.
  • Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
  • Developed Dashboards which can be easy for the users to understand and navigate.
  • Involved in the Deployment of reports from Dev to Stage & Production.
  • Involved in Conditional Formatting like highlighting the data and to show or hide the data.
  • Documented the complete production process and framework designs on the work performed.

PROFESSIONAL EXPERIENCE: -

Confidential, Houston, TX

Designation: - Senior Cognos Architect

Project Description: - Confidential will standardize and improve the quality and abilities of refinery blending and scheduling processes to increase profitability of the supply chain. This will include translating the optimized plan into feasible refinery and optimized tactical blend schedules that push refinery limits and improve response to unplanned events with better information visibility. The Refinery Release has the following deliverables within the 4 Chevron managed refineries: El Segundo, Richmond, Pascagoula and Pembroke.

Responsibilities:
  • Interacting with the key Business Associates for understanding the as-is process flow and new business requirements or enhancement activities.
  • Documenting the Business Requirements for report development, coding and passing it to Client Review.
  • Design & Enhance the Framework Model based on the business requirements.
  • Design & Enhance Cognos Reports and Dashboards.
  • Interact with Offshore team for technical discussions and product delivery.
  • Troubleshoot and enhance the existing reports with recommendations to suit the business requirements.
  • Performance tuning of the reports.
  • Prepare SQL Test scripts for COGNOS Reports.
  • Carrying out Unit testing based on the unit test plans and test cases.
  • Managing the deliverables to the client.
  • Up gradation from Cognos 8.2 to 8.4, 8.4 to 10.
  • Allocating tasks and delegating responsibilities to the team members for the successful execution of the project.
  • Daily reviews and status monitoring of the project.
  • Conduct Team Meetings and address the issues faced by the Team Members and come up with solutions for the same.
Environment: COGNOS 10, 8.4, 8.2, IBM AIX Server, SQL SERVER 2005 & 2008.

Confidential
Designation: - Senior Cognos Architect
Project Description: - The Confidential provides analysis of statistical demand forecast based on historical trends for Asia, Africa & US Regions. It provides visibility to data and metrics allowing for better decision making across the fuels value chain and provides reporting over Historical, Current & Projected Inventory and lists Bulk Movements and Exchange & Contract Information.
Responsibilities:
  • Interact with Business users to gather requirements for the model and Cognos reports.
  • Design & Enhance the Framework Model based on the business requirements.
  • Design & Enhance Cognos Reports and Dashboards.
  • Interact with Offshore team for technical discussions and product delivery.
  • Troubleshoot and enhance the existing reports with recommendations to suit the business requirements.
  • Performance tuning of the reports.
  • Prepare SQL Test scripts for COGNOS Reports.
  • Allocating tasks and delegating responsibilities to the team members for the successful execution of the project.
  • Daily reviews and status monitoring of the project.
  • Conduct Team Meetings and address the issues faced by the Team Members and come up with solutions for the same.
Environment: COGNOS 8.2. IBM AIX Server, SQL SERVER 2005.

Confidential
Designation: - Senior COGNOS Analyst & Project Lead
Project Description: - The goal of the project is to monitor Real time Data with Drill-Through capability to validate actual transaction Records. This helps in providing yearly trending for a rule and enhanced reject reporting capabilities. Ultimately it results in reporting the change in the Data Quality from day to day analysis. The business will be able to access the developed reports, through COGNOS Connection, which is the Web portal having access to Report Studio (Pre-defined Reports) and Query Studio (Flexible Reports).
Responsibilities:
  • Enhancement and development of existing/new reports.
  • Bug-fixes on the report.
  • Developed customized reports with Drill down and Charts.
  • Worked with Packages using Framework Manager.
  • Design & Enhance Dashboards.
  • Performance tuning of the reports.
  • Prepare SQL Test scripts for COGNOS Reports.
Environment: COGNOS 8.2, COGNOS TM1, SQL SERVER 2005, IBM AIX Server

Confidential
Designation: - Senior COGNOS Analyst & Report Writer
Project Description: - The Confidential project is a foundational element of the LYNX project. The vision of LYNX is to "Maximize Enterprise Value, From Crude to Customer" by providing a set of system solutions and processes that comprehensively manages the fuel supply chain-end-to-end. The purpose of the Information Architecture (IA) project is to support Supply Chain Management (SCM) consisting of data management, integration of systems & tools, and reporting functionality. It provides data availability for inventories, actual, plans, schedules, constraints, master data and look backs. It will also provide the visibility and data integration capabilities for critical information with limited event optimization that is deployed on a regional basis. Project Lynx creates a vision to Users for faster and better decision-making through greater visibility of the entire Supply Chain Operation.
Responsibilities:
  • Involved in the entire life cycle development process of the project which includes requirement gathering, technical specifications preparation and development of reports.
  • Involved in troubleshooting and enhancement of existing reports with thorough understanding of the data and making some recommendations to suit the business requirements of reports.
  • Worked with Packages using Framework Manager.
  • Worked as part of Assembly and Integration testing teams in identifying the potential Cognos & database defects and in resolving the same.
  • Performance tuning of the reports.
  • Prepare SQL Test scripts for COGNOS Reports.
Environment: COGNOS 8.2, TOAD 8.6, SQL SERVER 2005, IBM AIX Server
Confidential
Designation: - STI Developer

Project Description: - Shows reports of Inventory, Demand and Sales data across different optimization areas of Confidential. Can analyze data across optimization areas by using Google earth 3D functionality, which facilitates geospatial and visual analytic displays.
Responsibilities:
  • Understanding existing business and customer requirements.
  • Involved in development & modifications of layers, according to the user requirement.
  • Involved in testing the developed layers and fix the issues.
  • Involved in updating the modified layers into TFS.
  • Worked on Artifact, Datasources, Styles and on different kind of Geo-Features like Cylinder, Line-String, Polygon, and Placemark etc.
  • Worked on Search functionality of maps and Dashboards like Summary Dashboard, Simple Chart, and Data Series Chart etc.
  • Flex Script is used in design of ecosystems in STAD.
  • Worked on STAS Admin for creation of Users, Groups and Permissions, Ecosystem Group Mapping.
Environment: STAD 3.4.2, STAS 3.5.0, SQL Server 2008, Flex Script.

Confidential
Designation: - MSBI SSAS Developer
Confidential for the client to display the MSBI SSAS cubes functionality.
Responsibilities:
  • Understanding existing business and customer requirements.
  • Creating functional and technical documents.
  • Created a proof of concept on SSAS cubes based on existing Cognos reports.
  • Gave a presentation to the client on the cubes and their functionality.
  • Acted as one of the key members responsible for getting the MSBI work from the client.
Environment: MSBI SSAS, SQL Server 2008, Excel.
Confidential
Designation: - Cognos Developer
Project Description: - Confidential Communications is largest wireless voice and data communications services provider and the country's carrier operating on the world standard GSM technology platform. MTNL Communications is cable television provider offering cable television, high-speed Internet access, residential telephony services, voice communications services and broadband Internet connectivity to small, medium and large businesses across the country.This project is aiming to design a Data Warehousing system to analyze the business performance with the help of reports developed, and to take quick and efficient business decisions.
Responsibilities:
  • Interpreted complex Business specifications developed by the client and generated reports to meet customer specifications.
  • Development of Packages.
  • Enhancement and development of existing/new reports.
  • Bug-fixes on the report.
  • Maintenance and support of Client, Operational and Ad hoc reports.
  • Created Standard Reports using Report Studio like List Reports, Crosstab Reports and Chart Reports with drill through functionality and Ad-Hoc Reports using Query Studio.
  • Created reports using Cascading Prompts, Conditional Variables, Render Variables and Data Formatting properties.
Environment: COGNOS 8.4, Java Script, TOAD 6.5.0, Oracle 10g, Windows XP.

Confidential, Hyderabad
Designation: - Cognos Developer
Project Description: - Confidential is in distribution of food products. It supplies brand name and private-label foods and general merchandise to more than 500 retailers across UK, which sells their products in various regions and maintains all the Information.This project involved extracting the data from heterogeneous data sources like oracle and Flat files, transforming the data and then loading the data into the target Data Warehouse. The data warehouse is aimed at delivering analysis reports which should be on time to take effective decisions to bring more revenue to company with new policies.
Responsibilities:
  • Analysis of Business Specifications.
  • Development of Cognos Reports using Report Studio.
  • Enhancement and development of existing/new reports.
  • Bug-fixes on the report.
  • Developed different kinds of cognos reports like List Reports, Grouped Reports, Cross Tab Reports, Chart Reports and Drill-through Reports.
  • Worked on different kind of Prompts and customize the reports as per Client Requirements.
  • Preparation of Unit Test Cases and performed testing in the development environment.
Environment: COGNOS 8.4, Java Script, Oracle 10g, Toad.
Confidential, Chennai
Designation: - Cognos Developer
Project Description: - The aim was to provide a Decision support system, which helps Top management to take decision about their sales, purchases. To identify the key factors like the total sales revenue in week wise, month wise, quarter wise and year wise based on the region, sales channels and sales amount various reports were created.
Responsibilities:
  • Interacting with business Analysts, involved in identifying the needs and the requirements of the business manager.
  • Development of Cognos Reports using Report Studio.
  • Enhancement and development of existing/new reports.
  • Bug-fixes on the report.
  • Developed different kinds of cognos reports like List Reports, Grouped Reports, Cross Tab Reports, Chart Reports and Drill-through Reports using page breaks, conditional styles / blocking / layouts, drill-throughs, master-detail relations.
  • Worked on different kind of Prompts and customize the reports as per Client Requirements.
  • Preparation of Unit Test Cases and performed testing in the development environment.
Environment: COGNOS 8.2, Java Script, My SQL, IBM AIX Server.

Confidential
Designation: - Web Developer
Project Description: - Confidential is an Online Matrimonial service provider. It provides user who can register for free, and paid for different packages. Search millions of profiles, horoscope match, with online support. It combines 15 Major domains.
Responsibilities:
  • Interacting with business Analysts, involved in identifying the needs and the requirements of the business manager.
  • Development of different modules like Express Interest, Match Watch, Photo Watch, Cross Match Watch, Match Watch Archive.
  • Enhancement and development of existing/new features.
  • Preparation of Unit Test Cases and performed testing in the development environment.
Environment: PHP, PERL, HTML, Java Script, Ajax, My SQL, Apache, Linux.
Confidential, Chennai
Designation: - Web Developer
Responsibilities:
  • Interacting with business Analysts, involved in identifying the needs and the requirements of the business manager.
  • Development of below web sites
  • Sms5050.com
  • aepuk.con
  • Enhancement and development of existing/new features in web sites.
  • Preparation of Unit Test Cases and performed testing in the development environment.
Environment: PHP, PERL, HTML, Java Script, Ajax, My SQL, Apache Web Server, Linux.

Hire Now