Sonu Kumar Gupta Email & Phone Number

Delhi, India

Putnam Investments began with a simple concept: a balance between risk and reward is the mark of a well-rounded financial program. Manage money with a focus on consistent results for individuals and institutions worldwide, and this prudent approach continues.Responsibilities / ContributionsOptimized Cognos reports for optimal performance and reliability.Developed actionable insights through customized reports and dashboards.Assist stakeholders in gathering specifications for reporting and transforming them into effective reports.Utilized IBM Cognos Analytics to develop and maintain complex reports and dashboards to meet business requirements.Analysis of the specifications provided by the clients in SAP BO tools.Using Framework Manager tool of Cognos, develop the model to fulfil the Business RequirementsDeployment of Reports and Package into different environments (Export, Import and Copy to Clipboard)Created List, Grouped List, Cross tab, Chart reports with simple drag and drop functionality.Created and managed sections in the reports and also formatted reports as per the need.Extensively worked with filters and prompts on report data in Report Studio.Implemented conditional formatting in the reports to highlight the exceptional data.Used conditional blocks to hide the objects.Work with complex reports like master-detail and drill through reports.Developed the specific reports with concept of cascading and value prompts by using Report Studio.Creating prompt pages and parameters.Created Dashboard Reports. To display multiple reports in single page.

India

IBM Cognos developer, Developing Reports like List, Chart, Crosstab. Also worked on Framework Manager.

This project has the requirement for creating Reports & dashboards on top of relational and dimensional data. This Project provides the ability to business partners to monitor sales summary on their Channels. Project request included adding few relational tables and updating existing, Migrating reports and packages from 10.2 to 11.1 R7. These additional items allowed business users flexibility in viewing and analyzing different performance metrics.Responsibilities / ContributionsUsing Framework Manager tool of Cognos, develop the model to fulfil the Business RequirementsDeployment of Reports and Package into different environments (Export, Import and Copy to Clipboard)Migration of all reports from Cognos 10.2.2 to Cognos Analytics 11.1.7.Created List, Grouped List, Cross tab, Chart reports with simple drag and drop functionality.Created and managed sections in the reports and also formatted reports as per the need.Extensively worked with filters and prompts on report data in Report Studio.Implemented conditional formatting in the reports to highlight the exceptional data.Used conditional blocks to hide the objects.Work with complex reports like master-detail and drill through reports.Developed the specific reports with concept of cascading and value prompts by using Report Studio.Creating prompt pages and parameters.Created Dashboard Reports. To display multiple reports in single page.Developed Standard Reports, List, Cross-tab reports Using Report Studio and Query Studio.Created Cascading prompts and worked with various prompt controls like Value prompt and Date & Time prompt.Resolving Performance issues related to Reports.Performed Unit testing of reports writing SQL statement at backend/DB and validating against Cognos report studio reports.

Anthem, Inc., is a provider of health insurance in the United States. Anthem is a leading health company dedicated to improving lives and communities, and making healthcare simpler. Through its affiliated companies, Anthem serves more than 117 million people, including more than 45 million within its family of health plans. One in eight Americans receives coverage for their medical care through Anthem's affiliated plans.Responsibilities / ContributionsCreated List, Grouped List, Cross tab, Chart reports with simple drag and drop functionality.Created and managed sections in the reports and also formatted reports as per the need.Extensively worked with filters and prompts on report data in Report Studio.Implemented conditional formatting in the reports to highlight the exceptional data.Analyzed and designed the reports to build in Cognos Environments.Work with complex reports like master-detail and drill through reports.Developed the specific reports with concept of cascading and value prompts by using Report Studio.Creating prompt pages and parameters.Created Dashboard Reports. to display multiple reports in single page.Developed Standard Reports, List, Cross-tab reports Using Report Studio and Query Studio.Extensively used Conditional Blocks to hide/display the report contents (list, cross tab, charts) based on user selection in the prompt.Distributed Reports through Bursting, E-mail and uploading to folders

B.Tech, Electronics And Communications Engineering, A

Activities and Societies: Volleyball, Cricket, Singing, Painting, All other extra curricular activitesI was good student in college times.

Bachelor Of Technology - Btech, Electronics And Communications Engineering, A