Subhani S.

Subhani S.

B.tech / Engineering Graduate with 8 years of experience as Cognos TM1 Developer

Hyderabad , India

Experience: 8 Years

Subhani

Hyderabad , India

B.tech / Engineering Graduate with 8 years of experience as Cognos TM1 Developer

8 Years

Now you can Instantly Chat with Subhani!

About Me

B.tech graduate with 8 years of experience in data warehouse technologies like IBM Cognos Analytics and IBM Cognos Planning Analytics. I have good experience in creating data warehouse models, writing SQL queries and writing Macros for Excel.

...

Show More

Skills

Portfolio Projects

Panasonic for North America

Develop IBM Planning Analytics App for Taxroll Model

Company

Panasonic for North America

Role

Software Architect

Contribute

Gathering the requirements and converting them into model and develop the dashboard and reports.

Description

  • Understanding user specification requirements and convert them into business logic.
  • Creating dimensions and cubes structures in the model.
  • Applying business rules and TI processes to cubes.
  • Creating PAX/Perspective reports.
  • Creating dashboards in workspace.
  • Automating the dimension load processes using chores.
  • Adding user groups and security to the model.
  • Server management.
  • Performing System Integration test, Unit test on modules.
  • Preparing user requirement specification document.

Show More Show Less

Skills

Cognos

Omnitracs BI Carve out

Company

Omnitracs BI Carve out

Role

Software Architect

Description

  • Involved in design and development of Complex reports using Report Studio.
  • Analyzing the data along with ETL team to know where the data elements come from & what data is required for the report development.
  • Having stand-up calls with the user almost on daily basis to support the report requests.
  • Built list and crosstab reports, which have complex business logics by developing queries (native SQL) and firing them onto Cognos report studio.
  • Calculations, conditions, filter etc... are developed at the query level only.
  • Used advanced concepts of report studio like conditional formatting, master – detail relationships.
  • Involved in designing detail filters, summary filters, grouping and associations, Calculations and develop the report with client specific guidelines for report development.
  • To understand the functional requirements provided by the report users and Worked on bug fixes & enhancements in Cognos BI.
  • Deployment of Cognos BI packages & reports to QA & PROD environments.

Show More Show Less

Skills

Cognos

Trade Automation 15

Company

Trade Automation 15

Role

Software Architect

Contribute

Cognos Developer

Description

  • Gathered reports requirements with Business Users and converted them into project documentation.
  • Installed Cognos Framework Manager in an interim environment as a proof of concept.
  • Designed, developed and maintained catalogs according to the business requirements.
  • Developed Project Files, Models and packages according to the business specifications using Framework Manager.
  • Developing reports for new migrated environment Trade Automation ’15.
  • Performing unit test on reports.
  • Creating prompts, parameters and filters to reports.
  • Performing performance test on reports.
  • Trouble shooting of Production issues.
  • Applying drill through definitions on reports.
  • Involved in designing and creating the Model and Packages in Framework Manager.
  • Preparing technical documents.

Show More Show Less

Skills

Cognos

Operational Reporting and Business Intelligence Tool (ORBIT)

Company

Operational Reporting and Business Intelligence Tool (ORBIT)

Role

Backend Developer

Contribute

Cognos Developer

Description

  • Designing reports for various business segments like Customer Installation, OptumHealth care solutions using packages.
  • Involved in designing and creating the Model and Packages in Framework Manager.
  • Creating report templates for various product types.
  • Requesting to publish new package to Tier III.
  • Creating report query, report groups, sorts, custom sorts, subtotals, Query Processing, Filters, prompts, calculations and preparing output formats.
  • Maintaining report folders and version of reports.
  • Developing on-demand and self-service reports. 
  • Customizing existing reports according to business requirements.
  • Involved in creating cubes using IBM Cognos Transformer.
  • Creating views to cube.
  • Created Ad-Hoc reports using Query Studio.
  • Scheduling reports.
  • Performing unit and performance testing on reports.
  • Writing queries, validating data and formatting reports.
  • Preparing technical documents.

Show More Show Less

Skills

Cognos

Ika Claim System Production Support and Maintenance

Company

Ika Claim System Production Support and Maintenance

Role

Backend Developer

Description

  • Involved in writing the queries to retrieve the date from schema objects to produce the RTP reports.
  • Analyze, translate and define business requirements into technical solution
  • Data Modeling and Data Analysis
  • Design and Publish packages to Cognos portal using Framework Manager
  • Involved in design and development of Complex reports using Report Studio.
  • Creation of reports like cross tab reports, Charts, Drill Through reports.
  • Assignment of developed code for review and incorporating the review comments.
  • Deploying the code from Development environment to test environment and from there to PROD
  • Fixing the defects raised by Users.
  • Provide developer support to Quality Assurance and User Acceptance Testing teams till the code moves to production.

Show More Show Less

Skills

PL/SQL SQL VBA
Share:

Verifications

  • Profile Verified

  • Phone Verified

Available Timezones

  • Dubai [UTC +4]

  • New Delhi [UTC +5]

  • China (West) [UTC +6]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]