Shobhit Gupta

• Created interactive Power BI dashboards/reports
• Worked on Power Query in order to clean/transform the data
• Importing data from different data sources such as SQL Server, excel, etc in Power BI
• Created calculated columns by using DAX functionality
• Gathering and understanding the functional requirement from customer and do the analysis of the requirements to assess feasibility of design.
• Daily sync-up discussions with client team on status of assignments
• Worked on the issues/defects and new requirements raised by business as well as testing team during SIT and UAT cycles
• Worked mainly on reporting side using BI Power BI, Cognos 10.2, Cognos 11.0.6 & 11.2.2 Analytics Tools (Report Studio, Query Studio) and having experience on Framework Manager, Cognos connection, Power Query, Power BI.
• Installed and configured Cognos 11.2.2 on permisis as per project requirement for different environment
• Migrated reports/packages from C10 to C11
• Worked on Framework Manager related enhancements
• Learnt and fixed Java Script related report issues during migration
• Taken care of Admin related activities for all Cognos Env

• Gathering and understanding the functional requirement from customer and do the analysis of the requirements to assess feasibility of design

• Developing Complex conditional functional reports to fulfill the customer requirement

• Take care of full lifecycle of the project starting from taking transition from business team to build/test

• Daily sync-up discussions with client team on status of assignments

• Worked on the issues/defects and new requirements raised by business as well as testing team during SIT and UAT cycles

• Worked mainly on reporting side using BI Cognos 10.2, Cognos 11.0.6 Analytics Tools (Report Studio, Query Studio) and having experience on Framework Manager, and Cognos connection

• Tools and Technologies

IBM Cognos, Cognos BI Report Development, Oracle SQL Developer, Microsoft SQL Server 2012.

• Worked on automating the failed report re run based on audit tables using batch

• Worked on migrating the Cognos environment from one version to another and also migrated to the cloud environment

• Worked on Data Source, Model Query Subjects in Framework Manager

• Experience in Cognos Administration like User creation & change of user roles in Active Directory

• Knowledge on data warehouse concepts like Star schemas, Snow flake, Dimension and Fact tables

• Worked on Power BI

• Responsible for developing Power BI dashboards/reports based on customer requirements

• Gathering requirements from customers

• Importing data from different data sources and flat files in Power BI

• Worked on Power Query in order to clean/transform the data

• Microsoft Power BI, IBM Cognos, Cognos BI Report Development, Cognos BI Platform Administration, Cognos BI Architecture, Microsoft SQL Server 2016

• Design Developed & Deployed different types of Reports like List, Crosstab, Drill-Through Reports & some advanced features like Conditional Formatting, Render Variable, Cascaded Prompts, Filters etc using Cognos 10.2.2, Report Studio, SQL Server 2008 R2 and Oracle 10G. Involved in Data modeling and Package creation using Framework Manager.