Professional Summary:

• I have * Years of experience in IT industry and in the field of Business Intelligence and Data Warehousing.

• Strong experience in Framework Manager, Report Studio, Analysis Studio and Query Studio using IBM Cognos 10.2 and Cognos Analytics 11.

• Strong experience in creating Relational & Dimensional packages using COGNOS Framework manager.

• Experience in OLTP/OLAP System Study, Maintaining Database Schemas like Star Schema and Snowflake Schema used in Relational and Dimensional modelling.

• Strong experience in Cognos project migration from Cognos 10.2.2 to Cognos Analytics 11.

• Experience in Framework Manager for creating models, folders and publishing packages.

• Knowledge on creating Cubes and DynamicCubes using Power Play Transformer and Cube Designer.

• Experience in providing Security to models and reports in terms of Data level security, Object level security and Package level security.

• Good experience in developing different kinds of reports including List, Cross-tab, Charts, Conditional Block, Prompts, and Bookmarks Reports in Report Studio.

• Good experience in developing reports using SQL.

• Strong experience in creating drill through, master detail, burst reports using Report Studio.

• Experience in creating Dashboards using Workspace and Workspace advanced

• Good experience in creating Active reports.

• Knowledge on Data Warehousing Concepts and Database concepts.

• Involved in conversion of reports from MS Access to Cognos.

• Experience in working with multiple Relational Databases including Oracle 10g/11g, SQL Server.

• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.

• Strong experience in Data Warehousing and ETL using Informatica

• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.

• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

• Prepared SQL Queries to validate the data in both source and target databases.

Educational Summary:

• Bachelor of Commerce from Dr C V Raman University, Kota, Bilaspur, (C G ).

Professional Experience:

• Working as a Software Engineer in Tata Consultancy Services, NOV 2017 to Till Date.

Technical Summary:

BI Reporting Tools: Cognos 10.2 and Cognos Analytics 11 (Framework Manager, Query Studio, Report Studio, Cognos connection, Cognos Administration).

Databases: Oracle, SQL Server.

OS: Windows

Others: MS Office

Work Experience

3 Years

Project Handled

Project 1:

Title:AmericanModern InsuranceGroup, Inc.

Position: Cognos Developer.

Technologies: Cognos 11.0.13 (Report Studio, Cognos Connection,Query Studio, Framework Manager), SQL Server 2005.

Duration: May 2019 to till date

Project Description:

American Modern Insurance Group, Inc. is Insurance company. They also provide travel and pet insurance. Among its companies is American Family Home Insurance Company, but it is not affiliated with the mutual insurance company American Family Insurance.

The company also serves the commercial insurance needs of landlords, as well as of dealers and communities within the manufactured housing market. It also provides services and products to protect lender interests, including mortgage fire, debt cancellation, vendors single interest, collateral protection insurance, renters insurance, credit life and flood insurance.

Roles and Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.

• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.

• Perform day-to-day support activities & work in the Cognos Support team and development project teams to understand business requirements, models and reports design. Transition the same knowledge to the team for full support.

• Design, Develop and Publish packages using Framework Manager.

• Involved in conversion of reports from MS Access to Cognos

• Developed various types of simple and complex reports by using report studio.

• Developed List, cross tab, drill through, master-detail, chart and complex reports.

• Developed Reports using Conditional Formatting, Created Filters, Tree Prompts, Cascading Prompts, query Calculations & Layout Calculations as per the Requirement.

• Worked closely with business users to fix defects, enhancement of reports/Cubes during UAT.

• Worked on Production Issues.

• Scheduled reports/Jobs based on user requirement.

• Modifying the existing reports based upon the change request by the user.

• Extensively used Conditional Blocks to hide/display the report contents (list, crosstab, charts) based on user selection in the prompt.

• Deployed reports from one environment to other like Development to Testing, Testing to Production

• Unit testing and Peer review at developer level.

Project 2:

Title: Franklin Madison Group (FMG).

Position: Cognos Developer.

Technologies:

Cognos 10.2 (Report Studio, Cognos Connection,Query Studio, Framework Manager), SQL Server 2005.

Duration:Nov 2017 to Mar 2019

Project Description:

FMG is a leading third-party agent, administrator and marketer of AD&D and other insurance products that provide security for customers and offer incremental touchpoints for the clients and we help financial institutions bring overall financial well-being to their consumers.

• Clients: Clients are the banks and Financial Institutions

• Customers: Customer of Banks and FI

• Carriers: Top-rated insurance companies

FMG Products: I am working on bellow FMG products.

• AD&D(Accidental Death and Dismemberment)

• HAP(Hospital Accident Protection)

• Recuperative Care

• Term Life Insurance

Roles and Responsibilities:

• Created Models in Framework Manager and Published to Cognos Portal page for creating reports.

• Designed Star Schema Framework Model’s with no circular loops or ambiguous joins by creating aliases.

• Differentiated Query subjects as Facts, Confirmed and Role-playing dimensions for easy understanding.

• Implemented package level security in Framework and Folder level security in Cognos Connection.

• Used Determinants for Time/Date Dimensions to avoid double counting.

• Authored various types of reports like List, Chart, Cross tab, Repeater, Burst, Master- Detail, Forms, Native SQL Reports, Interactive reports, Visualizations in Report Studio and Dashboards in Cognos Workspace Advanced.

• Created reports involving Multi Fact, Multi-Pages, Multi-level Drill thru, Conditional Drill thru, Conditional rendering (of report output format and report pages), Conditional Blocks, Page break, variable expressions (String and Boolean), Layout component references and various prompts (value, search & select, date & time and cascading prompts).

• Formatted Reports using Data format options, advance sorting, group/level span, Dynamic headers/titles/columns, conditional formatting, style variable’s, sectioning and layout components (to display runtime information).

• Used Report functions, Date/String/summary functions and Data type conversion functions in report logic.

• Worked on improving the performance of reports for faster execution.

• Created financial cube models in Transformer using reports and package as data source.

• Experience in creating custom views, partition cubes, scheduling cubes.

• Used Java Scripting to hide/show prompts and for dynamic sorting.

• Review the reports with the team members and fix any issues.

• Documented each report with the technical specifications and any changes involved, for future reference.

• Maintained FM model versions using in-built version control tool.

• Worked closely with business users to fix defects, enhancement of reports/Cubes during UAT.

• Scheduled reports/Jobs based on user requirement.

• Deployed reports from one environment to other like Development to Testing, Testing to Production

Contact this candidate