SUMMARY

• Having 5+ years of professional IT experience as Business Intelligence developer using tools Microsoft Power BI, IBM Cognos and Informatica.
• Experience in Requirement Gathering, and BI Reports/Dashboards/Scorecards design and development using Microsoft Power BI and IBM Cognos.
• Strong knowledge on Power BI and Cognos to import data from various data sources such as Oracle, SQL Server Analysis Services (Tabular Model), MS Excel etc.,
• Expertise is enhancing and deploying objects in Informatica, Cognos and Power BI from development server to production server.
• Strong knowledge in Star schema and Snowflake schema.
• Extensive experience with Informatica Power Center, Cognos Report Studio, Cognos Transformer, Cognos Framework Manager and Power BI, SSAS Tabular model.
• Expertise in writing complex SQLs, Oracle Concepts (functions, procedures, packages).
• Developed Informatica jobs to Extract, Transform and Load (ETL) data into the Data Warehouse from Oracle ERP.
• Hands on experience in Performance Tuning and Query Optimization.
• Extensive hands - on experience in several Data Flow transformations including Expression, Joiner, Look up, Router, Filter, Union.
• Hands on experience in tuning Informatica mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, workflows, and sessions

TECHNICAL SKILLS

Languages: Oracle SQL, PL/SQL, DAX

BI Tools: Microsoft Power BI Report Server, Microsoft Power BI Desktop, IBM Cognos Report Net/ 8.4/10.1/10.2/11 Analytics and Informatica 8.1/8.6/9.1/10.1

Database: Oracle, SQL Server Analysis Services Tabular Model

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

Responsibilities:

• Develop complex Reports, Dashboard, Scorecards, design data models etc., using Microsoft Power BI and Cognos Analytics.
• Imported data from Oracle, Excel into Power BI to generate reports.
• Created dashboards like Sales Dashboard, Expense Dashboard, Marketing Dashboard, Order Analysis Dashboard, HR Dashboard, Sourcing Dashboard.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Published Power BI Reports to Power BI Report server.
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Published reports and dashboards using Power BI.
• Create reports and dashboards from variety of sources like Database, Excel, Salesforce etc.,
• Create and maintain integration from data sources using Informatica.
• 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.
• Create Cognos Transformer Cubes for analysis for different modules like Sourcing, Finance, Order Management, Commercial etc.
• Create Integrations using Informatica from Sources like Oracle ERP, Salesforce, and Files etc.
• Create ad-hoc reports in Cognos or Power BI for Data Analysis.

Confidential

Business Intelligence Developer

Responsibilities:

• 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
• 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 modifying to Existing Packages to fix any issues or for Report Enhancement.
• Create reports and dashboards from variety of sources like Database, Excel, Salesforce etc.,
• Create Cognos Transformer Cubes for analysis for different modules like Sourcing, Finance, Order Management, Commercial etc.
• Create ad-hoc reports in Cognos for Data Analysis.

Confidential

Senior Software Engineer

Responsibilities:

• 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.