Panasonic North America (PNA) maintains the production quality Tax accounting information on large spreadsheets, which are created for each Fiscal Year. Panasonic aims to convert the existing process to TM1 applications and create a centralized Tax accounting system.

• 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.

• 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.

• 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.

• 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.

• 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.