Sonu Kumar Gupta

Sonu Kumar Gupta Email and Phone Number

Cognos Developer @ Delhi, India
Delhi, India
Sonu Kumar Gupta's Location
Delhi, India, India
About Sonu Kumar Gupta

Sonu Kumar Gupta is a Cognos Developer at BCML.

Sonu Kumar Gupta's Current Company Details
BCML

Bcml

Cognos Developer
Delhi, India
Sonu Kumar Gupta Work Experience Details
  • Bcml
    Cognos Developer
    Bcml
    Delhi, India
  • Ability Quiver Pvt Ltd
    Cognos Developer
    Ability Quiver Pvt Ltd
  • Ability Quiver Pvt. Ltd.
    Cognos Bi Consultant
    Ability Quiver Pvt. Ltd. Jul 2024 - Present
    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.
  • Capgemini
    Cognos Developer
    Capgemini May 2019 - Oct 2023
    India
    IBM Cognos developer, Developing Reports like List, Chart, Crosstab. Also worked on Framework Manager.
  • Bank Of America Merrill Lynch
    Cognos Bi Developer
    Bank Of America Merrill Lynch May 2019 - Oct 2023
    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 Health Care
    Report Analyst
    Anthem Health Care Apr 2014 - May 2019
    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

Sonu Kumar Gupta Education Details

Frequently Asked Questions about Sonu Kumar Gupta

What company does Sonu Kumar Gupta work for?

Sonu Kumar Gupta works for Bcml

What is Sonu Kumar Gupta's role at the current company?

Sonu Kumar Gupta's current role is Cognos Developer.

What schools did Sonu Kumar Gupta attend?

Sonu Kumar Gupta attended Goel Institute Of Technology And Management, Lucknow, Goel Institute Of Technology And Management, Lucknow.

Not the Sonu Kumar Gupta you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.