Responsibilities:

• Worked with users and coordinated to understand and capture data/reporting requirements.
• Strong skills in visualizing the data and knowledge on ETL tools like Informatica & Data Stage.
• Developed complex reports using drill-through, dynamic prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos BI 10.2.2 and Cognos Analytics 11, 11.0.11 versions.
• Worked as a Cognos Planning Analyst, running macros as an application support.
• Maintaining tasks monthly and writing technical documents.
• Worked in designing and building packages in Framework manager and able to modifying/update the package according to the business rules and publish it
• Developed Reports using Report Studio, Query Studio and build packages in Framework Manager
• Developed complex reports using drill-through, dynamic prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos BI 10.2.2 and Cognos Analytics 11, 11.0.11 versions.
• Designed Executive Dashboards and scorecards with multiple tabs and worked on improving the performance of reports by tuning the queries, stored procedures.
• Worked on Dynamic Cubes model in Dynamic Cube Designer 11.0.11 and built Dashboards, drill-up and drill-down reports. Implementing security on the models by metadata, packages for different users, refreshing the cube on daily basis.
• Developed Data Modules and Data sets and used them to build the dill-through and visualization reports like bar, chart and dual-axis charts in Cognos 11.0.10.
• Build dashboards in Cognos 11.0.10.
• Created reports using Value prompts, Date & Time prompts, Text box prompts, Cascading prompts and Tree prompts.
• Enhancements for the existing Reports based upon the change requested by the user.
• Redesigning the Framework Packages according to the user requirement and build reports.
• Worked on reports by using Conditional Formatting like highlighting the data and to show or hide the data.
• Developed reports using Workspace and Workspace Advanced.
• Handling the issues related to data, reports, framework packages etc., and opening the ticket and resolving the issue using Service Now.
• Build reports using report studio, query studio and analysis studio.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Validated reports using IBM Cognos Data studio and performance tuning.
• Extracted information by writing queries upon user requests.
• Monitoring/tuning/troubleshooting of BI Applications, scheduled reports, jobs and Adhoc reports
• Preparing technical, functional documentation, user manuals and providing training to users.
• Carried out Bursting and scheduling of reports in Report Studio for monthly and weekly reports.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements

• Worked with users and coordinated to understand and capture data/reporting requirements.
• Gathered Business Requirements, interacted with the Users and Project Manager to get a better understanding of the Business Processes.
• Worked as a Cognos Planning Analyst, running macros and as an application support.
• Experience in designing and building packages in Framework manager and able to modifying/update the package per business rules and publish it
• Developed Reports using Report Studio, Metric Studio and build packages in Framework Manager.
• Perform assigned activities involving decision support systems, query and reporting, online analytical processing. Develop insightful business intelligence reports (KPIs, metrics, Adhoc queries), dashboards. Clean and transform data as required to deliver actionable information.
• Implementing analytical tools/solutions to improve the performance, resiliency, availability, scalability and globalization needs.
• Worked on databases Oracle 11g/10g, TOAD, SQL Server 2008/2005, IBM® Data Studio Version 3.1.1.0, full client
• Monitoring/tuning/troubleshooting of BI Applications, scheduled reports, jobs and Adhoc reports
• Preparing technical, functional documentation, user manuals and providing training to users.
• Coordinating with all customers and users to translate all workflow requirements to efficient data points.
• Modified the existing Reports based upon the change requested by the user.
• Redesigned the reports by using Conditional Formatting like highlighting the data and to show or hide the data.
• Build cubes in Transformer and active reports.
• Handling the issues related to data, reports, framework packages etc., and opening the ticket and resolving the issue using Service Now.
• Build reports using report studio, query studio and analysis studio.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Validated reports and extracted information by writing queries using TOAD and query tuning to improve the performance.
• Extracted information by writing queries in TOAD upon user requests.
• Build reports in Workspace and Workspace Advance
• Carried out Bursting of reports in Report Studio for monthly and weekly reports.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements

• Worked with Business Users and co-ordinate with them to understand and capture data/reporting requirements.
• Provided cardinality, check data usage, identifiers in the database view.
• Developed reports for the rolling time period and match back sales report.
• Carried out Bursting of reports in Report Studio for monthly and weekly reports.
• Created folders, filters, power prompts, and complex financial calculations in Framework Manager and Report Studio.
• Planned an approach for documenting, categorizing and packaging the requirements.
• Involved in Designing and creating various models and Publishing packages in Framework Manager for the Alteryx Architect.
• Create, publish, and modify applications enterprise-wide from a single platform.
• Involved in data analysis and data modeling to manage the data.
• Involved in management of ticket handling related to data issues and report enhancement.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• and Created Scorecards and Metrics using Metric studio.
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making.
• Performance tuning on power-cubes to reduce Query time and partitioned Cubes.
• Tested and validated the report output against the database to measure performance of reports.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau. Between the files for the report development.
• Importing/exporting the data
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Created action filters, Donut chart, Pareto chart, Bar graphs and Histograms, parameters, LOD expressions and calculated sets for preparing dashboards and worksheets in Tableau.
• Created customized and interactive dashboards using multiple data sources.
• Publishing the reports to the server and granting privileges and adding new user groups to the server.
• Performed unit testing on dashboards
• Developed Complex dashboard reports for various reporting requirements.
• Built DMR and Cubes in Transformer, packages, reports, etc., as a data source.
• Identified various dimensions and measures required for the generation of a cube.
• Developed reports using analysis studio to show the performance of the business metrics.
• Performed Troubleshoot on various existing reports that had issues and fixed Remedy tickets from production system.
• Developed Active reports for the users and build cubes using Transformer and developed reports.
• Build reports around financial data and insurance data.
• Validated reports using TOAD and performance tuning.
• Trained business users on how to build a simple ad-hoc reports and the functionality of built reports.
• Build reports in Metric studio to compare the metrics for different departments.
• Ability to write high level complex queries at the front end to build the reports.
• Deployed the reports and package from Development to Testing and then Testing to Production environments.