SUMMARY

• 8+ years of professional IT experience in Cognos BI & Data Warehousing, generating OLAP.
• Worked on multiple COGNOS BI (Financial & Banking, Healthcare, IT and Telecommunications, Insurance, Consultancy and Transportation) with strong technical skills.
• Experienced to work as a team member in TM1 and Tableau 9.2.
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design converting requirements specifications into functional specifications.
• Experience in interacting with clients for giving resolutions to the Cognos related issues or modeling enhancements and ability to transform business requirements into Cognos enabled reports, dashboards using both drill down and drill through alternatives.
• Expertise in Cognos 10.2.2, 10.2.1, 10, 8.4.1, 8.3, 8.2 and 8 (Report studio, Framework Manager, Workspace, Workspace Advanced, Query Studio, Analysis Studio).
• Designed and developed Complex Reports like (List Reports, Cross Tab Reports, Charts, Maps, Drill Through, Dashboard Reports, Master Detail Reports) using Report Studio, Workspace Advanced, Query Studio and Analysis Studio.
• Experience in Content Deployment, Scheduling and Automated Report Bursting.
• Extensively worked on Framework Manger in creating models, modifying relationships, resolving the loops and DMR.
• Designed and developed Dashboards to evaluate the company’s performance.
• Experience to design and develop Conditional Blocks and create reports using Variables (String and Boolean).

TECHNICAL SKILLS

Cognos Tools and Versions: Report Studio, Query Studio, Analysis Studio, Cognos Workspace Advanced and Framework Manager IBM Cognos 10.2.2/ 10.2.1/ 10/ 8.4.1/8.3/8.2/8

Other BI Software's: TM1, Tableau 9.2

Databases: SQL Server, MySQL, Oracle, Netezza, db2

Programming Skill: JAVA, MATLAB, C, C++, C#

Network Simulators: OPNET, AUTOCAD

Telecom Systems: CDMA, GSM, GPRS, UMTS, UTRAN, I - mode

Networking Systems: WLAN, VLAN, LAN, MAN, WAN

Protocol Skill: TCP, UDP, DHCP, ARP, PPP, SMTP, FTP, Spanning Tree

UTM Firewall Devices: Barracuda, gateProtect, Tech-Titan

Operating Systems: Windows, ios

PROFESSIONAL EXPERIENCE

Confidential, Texas

Responsibilities:

• Responsible for Development and Implementation of multiple report pages, prompts, calculations, nested queries, nested objects and variables working with applications and data.
• Analyzing and developing specific documents for reports as the requirements.
• Develop and Burst reports and send to different locations.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Create Database View and Business View separately and edit query items in Business View to do the report systematically.
• Created cubes using Framework Manager Packages.
• Developing the Dashboard reports using Cognos Report Studio. Redesigned and customized the report using Developer Tools.
• Worked with Stored Procedure Query Subjects in FM and Reports. Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Designed and developed framework models for report development. Extracted data from pdf, XML and Oracle Databases as source data.
• Maintain and handle multiple reports by Join, Union and Intersection.
• Developed Dash Board reports in Report Studio with Conditional Block.
• Validated the report by using SQL statements against the source systems. Imported Meta data from different data sources, created data models in Framework Manager.
• Created Database Layer and Business Layer, define appropriate relationship between query subjects based on the user requirements.
• Created Oracle PL/SQL Stored Procedures, Functions, Cursors using toad for use by Framework Manager Packages and Report Studio reports.
• Worked with a team of Tableau developers to design, develop and implement BI solutions and create Dashboard style of reports.
• Worked on TM1 Architecture and Perspective with a developers team.
• Provide data security through Framework Manager and single sign on security on users/groups at various levels after creating Roles and Groups at Cognos connection access manager.
• Create Joins based on Cardinality in Framework Manager and create Schemas.

Environment: IBM Cognos 10.2.2 and 10.2.1, Report Studio, Cognos Workspace Advanced, Query Studio, Framework Manager, Analysis Studio, MySQL, Tableau 9.2, TM1.

Confidential, NY

Responsibilities:

• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Involved in building complex reports using prompts and parameters in Report Studio and Query Studio.
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and Prompts.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and SQL Server.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, Multi-page, Multi-query.
• Created custom prompted reports in Report Studio, Bursting reports for sending to different user groups.
• Scheduled the reports to run at a certain time and also burst it to the users depending on their access level to the data.
• Generated complex reports involving conditional variables, dash boards, drill through, bursting, join, union, intersection.
• Tested the reports in the new data mart by creating the reports and verifying the output to be same as its being entered into database.
• Tested the joins, inbuilt filters and inbuilt calculations are working correctly. Documented all of the work for submitting it to the users for verification.
• Created reports in Analysis Studio to verify the data is correct against the drill through report in Report Studio.
• Published reports in PDF, Microsoft Excel, HTML and XML format.
• Building, publishing customized interactive reports and dashboards and report scheduling.
• Worked on Variables and Conditional Styles.
• Worked on large scale and data volume based applications.
• Tuned the performance, working on back end SQL and Framework Manager.
• Ensures network security with gateProtect Firewall Device.

Environment: Cognos 10.2.1. Framework Manager, Report Studio, Query Studio, Analysis Studio, SQL Server.

Confidential, Washington D.C.

Responsibilities:

• The project included creating Dashboards to show the financial information, key metrics for the higher management to keep track of the company progress.
• Create separate Business View and Database View to publish the data and work on it systematically.
• Created packages for various marketing ad hoc requirements
• Created new users in the access manager and assigned proper groups to those users in Cognos connection.
• Created Complex Reports using unions, intersections, joins, master detail relationships and conditional formatting.
• Performance tuned the queries to make the reports run faster.
• Created models in Framework Manager, packages including stored procedures as query subjects.
• Applied best practices in Framework Manager model design Database Layer, Business Layer and Presentation Layers.
• Scheduled and distributed reports through schedule management in Cognos connection.
• Involved in training the end users in Cognos connection on using the report studio, cubes in Analysis studio and running the canned reports.
• Configured Cognos Connection Portal/Folder setup to support all report access by various user groups.
• Worked with the Business Analysts to gather the business requirements.
• Involved in designing tables and working with the team to load those tables for various reporting requirements.
• Created SQL queries and performed Unit testing for all developed reports and documented the reports.
• Ensures network security with Barracuda Firewall Device.

Environment: Cognos 10.2.1 and 10. TM1, Framework Manager, Report Studio, Cognos Workspace, Query Studio, Analysis Studio, SQL Server.

Confidential

Cognos Developer

Responsibilities:

• Created different Data sources and created packages and published to the Cognos portal.
• Created Drill Through reports and Conditional Formatting by using Report Studio.
• Created reports like List, Cross tab and Dashboards by using Report Studio.
• Extensively worked on Complex Reports using page sets, drill through reports, master detail reports, conditional prompts.
• Developed Multi Page Report.
• Created user groups, roles to implement the Cognos security using Access Manager.
• Customized Cognos Connection Portal to personalize the homepage.
• Created the documentation for cubes & Reports.
• Testing and Validating the Reports
• Involved in analyzing the cardinality between query subjects.
• Customized data by adding Calculations, Filters, Prompts and Page Break.
• Developed all Cognos Framework Manager Meta data models to process and retrieve local server's data.

Environment: Cognos 8.4.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Oracle, Netezza.

Confidential

Responsibilities:

• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Involved in building complex reports using prompts and parameters in Report Studio and Query Studio.
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and Prompts.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and SQL Server.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, Multi-page, Multi-query.
• Created custom prompted reports in Report Studio, Bursting reports for sending to different user groups.
• Scheduled the reports to run at a certain time and also burst it to the users depending on their access level to the data.
• Generated complex reports involving conditional variables, dash boards, drill through, bursting, join, union, intersection.
• Tested the reports in the new data mart by creating the reports and verifying the output to be same as its being entered into database.
• Tested the joins, inbuilt filters and inbuilt calculations are working correctly. Documented all of the work for submitting it to the users for verification.
• Created reports in Analysis Studio to verify the data is correct against the drill through report in Report Studio.
• Used Java Script in HTML & XML to make web pages more interactive and dynamic.
• Worked on large scale and data volume based applications.
• Ensures network security with gateProtect Firewall Device.

Environment: Cognos 8.3 and 8.2, Framework Manager, Report Studio, Query Studio, MySQL.