We provide IT Staff Augmentation Services!

Ibm Cognos Bi Developer Resume

TX

SUMMARY

  • Comprise excellent knowledge in Cognos 10 BI Suites, which includes Report/Query Studio, Framework Manager, Cognos Workspace, Active Reports, Transformer, and Cognos connection.
  • Expertise in creating Dashboards in Cognos Report Studio/Cognos Workspace.
  • Experience in star schema, snowflake schema, data requirement analysis, design, development, testing, documenting and implementation of business applications.
  • Strong fundamentals in OLTP/OLAP technology.
  • Good knowledge in Cognos 10 architecture and administration functions including Content Store
  • Excellent project management, communication, presentation skills and a very good team player

TECHNICAL SKILLS

  • BI Tools: Cognos 10.2, Cognos8.3,8.4, Cognos Connection, Report Studio, Metric Studio, Framework manager, Cognos Workspace, Transformer, Business Objects, Crystal Reports, Tableau 9.2
  • RDBMS: Oracle 11g/10/9i/8/7,MS Access 2002/2003, SQL Server 2014/12/00
  • Database Tools: Toad, SQL Navigator, SQL Loader, MySQL, SQL Management Studio, Rapid Sql
  • Other: TFS, JIRA, Microsoft Project, Cost Point, Maximo, CBS, CRM, Remedy

PROFESSIONAL EXPERIENCE

Confidential Taylor, TX

IBM Cognos BI Developer

Responsibilities:

  • Designed Cognos packages based on fact and dimensional tables for use with Cognos Advanced Workspace users.
  • Performed detailed data analysis for designing, documenting and developing well - designed Cognos framework manager packages that are intuitive and easy to use.
  • Ensured the BI environment is optimized to address all business requirements by establishing the framework and enforcing the standards used by all BI application developers.
  • Applied knowledge about existing corporate data models and business rules, leveraging stronge dimensional data modeling experience.
Confidential

Senior System Integration Analyst

Responsibilities:

  • Responsible for creating, enhancing and maintaining Framework Manager models to support business requirements
  • Managed and overlooked work performed by off shore team for all reporting needs.
  • Worked with business users to design and develop Cognos BI 10.1 or 10.2 reports using Report Studio and Cognos Workspace with data drill-down and slice-and-dice options.
  • Designed and developed test plans for unit testing, integration testing and user acceptance testing.
  • Served as a subject matter expert in a specific area or areas of business processes and systems.
  • Provided of Performance Tuning: Methodology, Mapping Design & Cache Management with Memory Optimization.
  • Experience in building complex reports, dashboards, and scorecards.
  • Designed, developed and deploy new OLAP cubes, reports and dashboards.
  • Expertise in Report Studio, Analysis Studio, Query Studio, & Transformer
  • Troubleshoot performance related issues for reports, Framework Manager Packages.
  • Participated in developing, validating reports with business requirements. Tested the report functionality.
  • Worked closely with the Reporting team - participated in design meetings and helped in developing processes.
  • Involved in development, implementation innovative IT solutions to maximize operational efficiency and effectiveness.
  • Designed and developed Customer Care Billing Historical Reports - Used Framework Manger for modeling the data and Report Studio for interactive reports.
  • Involved in system migration. Migrated reports to QA and Production environments.

Confidential

Senior Technical Consultant

Responsibilities:

  • Extensively worked Framework modeling and complex report building.
  • Strong experience in developing business models and publishing packages using Framework Manager
  • Developed and successfully deployed multiple initiatives with executive dashboards with charts and reports with easy navigation into subsequent reports by drill down feature.
  • Managed maintained projects, meetings and documentation.
  • Involved in ETL design.
  • Managed / created custom calendars.
  • Designed framework model - Dimensional Modeling - Star Schema design.

Confidential, TX

Responsibilities:

  • Extensive experience using Cognos BI Reporting Tools including and not limited to Framework Manager, Report Studio, Query Studio and Cognos Workspace.
  • Designed framework model - Dimensional Modeling - Star Schema design and implemented in drill down reports.
  • Utilized Cognos Workspace for dashboards and implemented throughout the Sales.
  • Designed and developed Active reports - Cognos Mobile.
  • Implemented and enforced security for the BI environment.
  • Participated in design meetings for data requirements for the sales team.
  • Supported Tableau reports and converted them into Cognos Reports.
  • Created Technical, Functional and Unit Test documents

Confidential, TX

Business Intelligence Analyst/ Developer

Responsibilities:

  • Managed BI projects from requirement gathering, database modeling to entire project completion.
  • Performed capacity planning required creating and maintaining cubes in the BI environment.
  • Deployed, implemented and enforced security for the BI environment.
  • Ensured the integrity of the data in the BI environment.
  • Designed, constructed and scheduled the creations of cubes.
  • Designed framework model - Dimensional Modeling - Star Schema design.
  • Setup and maintained documentation and standards.
  • Developed and successfully deployed multiple initiatives with executive dashboards with charts and reports with easy navigation into subsequent reports by drill down feature.
  • Created Technical, Functional and Unit Test documents.
  • Design, developed Active report for the executives.

Confidential, TX

Business Intelligence Consultant

Responsibilities:

  • Created Models using different data sources and Developed packages from the model according to users’ requirement in Cognos Framework Manager.
  • Published packages from Framework Manager to Cognos connection for report creation in Report Studio and Query Studio.

Confidential TX

Sr.Technical Business Analyst

Responsibilities:

  • Involved in full project life cycle implementation (Requirements gathering to production phase).
  • Involved in creating Metadata models (Using multiple data sources) .
  • Created ETL mappings (fact & dimension builds) for initial load and daily updates.

Confidential, Tx

Business Intelligence Developer

Responsibilities:

  • Experience in managing service business that does work with the government sector.
  • Collected, processed, analyzed and reported on metrics and quality control data to meet specific customer reporting requirements.
  • Extensively involved in designing Metadata Model using Framework Manger.
  • Created user groups and roles as per the company standard and integrated Active Directory for authentication.
  • Designed and Developed AdHoc query packages and trained the end users on how to develop reports in Query Studio.
  • Worked on database migration project (converting reports from MS SQL Server 2005 to Oracle 10g).

Confidential, Texas

Analyst/Report Developer

Responsibilities:

  • Designed and developed reports using various tools.
  • Supported applications with Oracle as backend, for the software department.
  • Provided documentation for alterations to current state systems and future project designs.
  • Created and maintained user accounts. Trained end users.
  • Used Oracle SQL queries extensively and created all program-level ad-hoc reports.
  • Provided advisory support for project and resource management system for R&D programs and projects.
  • Supported and facilitated upcoming product and system programs from E-1to E5.
  • Contributed to planning, including product creation process (PCP), program structures (PRS), work breakdown structures (WBS) and code categories for project.

Hire Now