We provide IT Staff Augmentation Services!

Sr.cognos Analyst Resume

Chicago, IL

SUMMARY:

  • Certified IBM Cognos BI Designer and FM Modeler with over 10 years of experience in the area of Framework Manager, Query Studio, Report Studio and Cognos Connection.
  • Excellent working knowledge in development, designing, Administration and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 11.6./10.x.x./8 and Cognos Report Net.
  • Strong experience in creating and publishing packages in Framework Manager.
  • Expertise in Framework Manager Modeling (Database Layer,Physical Layer, Business Layer) and creating Packages and Complex Report building with Report Studio.
  • Strong Experience in developing Business models and publishing packages using Framework Manager along with Cognos Connection in Cognos 11/10/8 and Report Net1.x.
  • Expertise in OLTP/OLAP system study, analysis, E - R Modeling and developing Database schemas like Star Schema and Snowflake Schema.
  • Developed and successfully deployed multiple initiatives with Executive Dashboards with charts and reports with easy navigation into subsequent reports by drill down feature.
  • Extensively worked on Data Extraction with Oracle (8i, 9i and 10g), SQL Server & MS-Access.
  • Experience in Deployment (Export, Import) using Framework Manager into Cognos Connection.
  • Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.
  • Expertise in version up gradations of Cognos suite such as Cognos 8.4 and Migrating Cognos 8.4 reports into Cognos 10.2 BI.
  • Extensive one to one interaction with end users/Business analysts to identify their needs and wants, then translate the functional requirement into reporting requirements, design and business data flow.
  • Migrated the Framework Manager Models and reports from Cognos 8.4 to Cognos10 BI.
  • Designed the Transformer model and built the cubes using Power Play Transformer, explored the Cube data using the Report and Analysis Studio.
  • Trained on IBM Cognos TM1 architect.
  • Strong troubleshooting and production support skills and coordination/ interaction abilities with end users.
  • Actively involved in Change Management process for deployment approvals.
  • Provided Cognos training to Business Users.
  • Provided End to End solutions on BI Cognos projects.
  • Worked with Different Databases like Oracle8i/9i/10g, SQL Server 2000, DB2, MS Access.
  • Expertise in Tableau Desktop and Qlikview.
  • Sound knowledge in Financial, Sales and Distribution and Supply Chain Management (SCM)
  • Good Knowledge in Agile and Waterfall methodologies
  • Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Business Intelligence Tool: Cognos 11 BI tools (Dashboard,Report Studio, Analysis Studio, Query Studio, Cognos Connection), Framework Manager, PowerPlay Transformer, ReportNet ),Tableau desktop and Qlikview

ETL Tools : Cognos data manager, Informatica Power Mart v6.1/5.0 & Power Center v6.1/5.0

Databases: MSSQL Server 2012, Oracle 8i/9i/12g, MS Access, DB2,Teradata,AWS Redshift

DB Tools : SQL*Plus, SQL*Loader

Languages : SQL, PL/SQL, XML

Operating Systems : Windows 95/98/XP/NT

Business Domain: Sales and Distribution, FP&A, Banking and Supply Chain Management (SCM)

PROFESSIONAL EXPERIENCE:

Confidential,Chicago,IL

Sr.Cognos Analyst

Responsibilities:
  • Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
  • Generated Complex reports in Cognos 11 report studio including Drill Down reports from DMR modeled Frame work model.
  • Created Dashboards to present critical company data in a single report.
  • Created list reports & cross tab reports using cognos 11
  • Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio
  • Experience in developing Framework Manager Models and analyzed those models in analysis studio.
  • Gathered and analyzed business requirements from users and business community.
  • Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
  • Created Sophisticated Reports using Report Studio.
  • Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

Environment: Cognos 11 BI, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Oracle, SQL and Windows 2003.

Confidential

Cognos Lead

Responsibilities:
  • Coordinate with customer and to understand the requirements
  • Creating TS & FS design documents for model and reports based on the functional documents
  • Coordinate the review, presentation and release of design layouts, drawings, analysis and other documentation
  • Designed and developed the Cognos FM models, Reports
  • Developed the multiple types of reports like dashboard, list and charts by using Report studio and Analysis studio.
  • Developing the FM models, applying cardinality between different query subjects
  • Publishing packages for Cognos reports.
  • Involve the Folder, Report and data level security
  • Developing the multiple types of reports like dashboard, list and charts.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Developed and maintained QlikView Load Scripts across multiple data sources.
  • Designed, created and maintained QlikView applications.

Confidential,NJ

Cognos/Tableau Lead

Responsibilities:
  • Handling a team of 15 resources and ensuring that the deliverables are met on time.
  • Coordinate with customer and to understand the requirements
  • Creating TS & FS design documents for model and reports based on the functional documents
  • Coordinate the review, presentation and release of design layouts, drawings, analysis and other documentation
  • Analyzed & understand the existing Edge2 FM models & Reports
  • Involve the Reports & FM models mapping document
  • Developing the FM models, applying cardinality between different query subjects
  • Publishing packages for Cognos reports.
  • Involve the Folder, Report and data level security
  • Developing the multiple types of reports like dashboard, list and charts.
  • Involve the Cognos SDK coding
  • Involved the LDAP security for Cognos reports and Cognos portal tabs
  • Reviewing and providing signoff for the test cases and test outputs and sending it for business approval.
  • Handle the Daily status calls and Defect calls with the clients.
  • Responsible for effective communication between the project team and the customer.
  • Maintain very good communication & rapport with onsite coordinators. Encourage creativity, risk-taking, and constant improvement

Confidential

Cognos Lead

Responsibilities:
  • Participated in the workshops for gathering requirements.
  • Analyzed the impact on the reports due to the changes in the Source systems.
  • Involved in the Design discussions of the Mappings for data loading using Informatica PowerCenter 8.
  • Modified the Framework Manger Models to in corporate the new data elements.
  • Designed and developed the reports as per the requirements in Cognos 8.2.
  • Developed PowerPlay Cubes for better analysis of the data.
  • Implemented the security setup for reporting and User setup for BI reporting Access Manager and Sun one Directory server.
  • Implemented security into Cognos Transformer Models using Macros.
  • Published the Cubes to Cognos 8 Analysis Studio using Framework Manager.
  • Modified existing reports to in corporate the changes in the Source System.
  • Prepared Test cases for report validation.
  • Involved in Unit and Integration testing.
  • Responsible for code migration across environments ( DEV, SIT,UAT, Prod)

Environment: Cognos 8.2, Cognos Framework Manager, Cognos PowerPlay Transformer, Cognos datamanager, Oracle 10g,Windows 2000 Server.

Confidential

Cognos Developer

Responsibilities:
  • Creating design documents for model and reports based on the functional documents
  • Publishing packages for Cognos reports.
  • Creating different charts (Bar,Line), Cross tabs and List reports.
  • Creating multiple reports which include prompts, conditional blocks, conditional formats.
  • Writing java scripts to hide the headers,Export button to export report into different formats,applying expand and collapse buttons in list report.
  • Invalid on the Confidential to Confidential RBU Enhancements
  • Migrate reports from Oracle to Teradata environment.
  • Used Java Scripts in reports to hide and show objects.
  • Monitor testing Bugs and solve the issues
  • Investigate problems and analyze an impact of changes
  • Writing unit test cases for the developed reports
  • Involed in mapping users from LDAP.
  • Involed in giving capabilites/Acess to different user groups.
  • Involed in trouble shooting security realted issues.
  • Invloed in truoble shooting any congos enviornmental issues.
  • Invloved in deployment like import and export activites.

Hire Now