Develop Reports, Dashboard, Scorecards, design data models etc., using Microsoft Power BI and Cognos Analytics.● Imported data from SQL Server into Power BI and Cognos to generate reports.● Handled Data Analyst responsibilities such as Organizing, Creating and analyzing the current BI reports to find value or opportunities for improvement.● Created traditional and analytical BI Reports for different stakeholders like HR, Finance, Supply Chain.● Write complex SQL queries to get data extract from SQL Server for data analysis.● Create Data Models in Power BI and Cognos Framework Manager for user ad-hoc reporting.● Create design documents for databases created in Microsoft Access.● Analyze data and deliver a final business solution to the operations team through a Power Bi experience● Migrate reports/forms created in Microsoft Access to IBM Cognos or Microsoft Power BI.

● Development of Reports, Scorecards, and Dashboards required for the business development using Cognos.● Created Reports to Monitor Sales using Flash Reports, Customer Trends and Technology Trends.● Write complex or simple SQL to extract data from Data Warehouse to help the business users with their one-time analysis.● Create, Maintain and Support the ETL loads in Informatica with sources like Oracle ERP, Salesforce etc.● Support and maintain the existing environment by resolving issues from Client.● Test the jobs with different test cases and for performance● Worked as Team Member for a Project to create and develop a New Data Warehouse solution using Informatica and Cognos.● Worked as BI Report Developer using Cognos.● Resolving the Service Calls raised by users as per SLA. ● Direct interaction with the clients for understanding the functionality, business logic and requirement. ● Created documents and Unit Cases to support the Development.● Production job monitoring.● Supporting the application and providing impeccable solutions to make sure the application availability and performance● Create New Cognos Packages for Reports and also modifying to Existing Packages to fix any issues or for Report Enhancement.● Develop complex SQL queries to get data extract from Data Warehouse for various data analysis to different teams like Sales, Finance, Projects and Order Management etc.● Develop complex Reports, Dashboard, Scorecards, design data models etc., using Microsoft Power BI and Cognos Analytics.● Create reports and dashboards from variety of sources like Database, Excel, Salesforce etc.,● Create and maintain integration from data sources using Informatica● Work with business users to understand challenges and build data analytics solutions to address those challenges● Create Integrations using Informatica from Sources like Oracle ERP, Salesforce, and Files etc.

● Understanding the functional requirements.● Creation of detailed report definition documents and Mapping design documents.● Development of new Cognos reports and Informatica Mappings based on functional requirements.● Enhancement in existing Cognos reports.● Testing the reports and Informatica Jobs.● Interact with the TSG team for Change promotion.● Supporting the application and providing impeccable solutions to make sure the application availability and performance.● Resolving the Service Calls raised by users as per SLA.● Direct interaction with the clients for understanding the functionality, business logic and requirement. ● Providing instant solutions for critical business scenarios.● Production job monitoring, Break fix and permanent fix for redundant issues.● Involved in Designing Framework Manager.● Involved in Designing and creating reports for the whole project.● Created multiple reports in Cognos using Lists & Crosstabs