Professional Summary

• More than 7 Years of experience in software industry with focus in the areas of Data warehousing/Business intelligence using Cognos Cognos 10.x/8.x
• Expertise in Cognos with particular emphasis on Reports and Queries
• Expertise in creating complex reports like Executive Dashboards, Cross tab reports, Top ten reports, ad-hoc reports, Charts and Score card reports using Report Studio
• Strong knowledge in Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, Physical and Logical Data Modeling, Fact and Dimension tables
• Expertise in Report Net Framework Manager, Query Studio, Report Studio, Cognos Connection
• Strong experience in generating various reports Dashboards, Master-Detail and others using ReportNet
• Usage of Query Studio to build ad hoc Business reports and Report Studio to build advanced reports multi-page, multi-query reports against multiple databases
• Extensively worked on understanding the business requirements and designing Cognos applications
• Created complex statistical and financial reports, trend over time reports, ranking and forecast reports, Extensive Dashboards using Report Studio
• Proficiency in Report Authoring using Cascading prompts, conditional formatting, drill-through reports, bursting Reports
• Strong knowledge on Internet based reporting and strong Analytical skills and attention to detail
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Expert in all stages of Software development life cycle SDLC which includes requirement analysis, design, development, testing and documentation.
• Expert in Unit testing, Cross testing of Cognos reports.
• Excellent understanding of dimensional modeling techniques using Star and Snow-flake Schema Modeling.
• Proven problem solving skills with excellent analytical, communication and interpersonal skills
• Excellent team player and superior organizational and time management skills
• Knowledge of Access Manager to implement Security among Cognos applications
• Provided extensive End User Training and Support
• Technical Skills
• BI Tools : Cognos 10, Cognos 8.4, Cognos 8.3, Cognos 8.1, Cognos ReportNet Report Studio, Cognos Connection, Cognos UI, Analysis Studio, Event Studio, Query Studio, Framework Manager
• Operating Systems : Windows NT/98/2000/XP/7
• Databases : Oracle, MS SQL Server, IBM DB2

PROFESSIONAL EXPERIENCE

Client: Cigna Healthcare, Bloomfield, CT Feb/2013 To Date

Position: App Development Sr. Specialist

Cigna Healthcare is a leading provider of healthcare insurance products with over 29 Billion in revenues. Cigna and its predecessors have been offering health insurance for more than 200 years. With approximately 35,000 employees worldwide serving over 75 million customers globally, Cigna has pioneered in the area of health insurance by keeping its customers satisfied with its services. Cigna's focus on customer service and continuous product development generates lot of requirements when it comes to IT-related services. Business Intelligence tools are utilized to better manage the business and stay ahead of the competitors.

Responsibilities:

• Developed stand-alone applications in Cognos environment from beginning to the end.
• One of the projects involved migration of a reporting system from Crystal Reports/Visual Basic environment to Cognos.
• Two of the projects involved developing reporting tools for the business users to report to the Department of Health and Human Services HHS as part of new health care laws.
• Assisted the system analysts in troubleshooting the design specifications in one of the projects where the original documentation was not available.
• Designed and developed the SQL queries to satisfy the design specifications.
• Developed additional requirements while modeling queries in Framework Manager.
• Designed and created various models and published packages in Framework Manager.
• Developed advanced reports using Report Studio including some master templates.
• Developed various report types ranging from simple lists, crosstab, chart, drill-through, Master-Detail and Conditional formatting reports.
• Created Complex, multi-page reports involving prompts, Cascading prompts, Conditional rendering and Conditional formatting.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Developed reports using Cognos 10.1.1 in various environments.
• Tested and validated the report output against the database to measure performance of reports.
• Identified various dimensions and measures required for the generation of a cube.
• Performed troubleshooting and fixed existing reports that had issues in production.
• Deployed packages, folders and Content store from a development environment to test and then to QC and Production environments.
• Presented the features available in Query Studio and obtained user requirements to develop training modules.
• Trained business users to utilize Query Studio for ad-hoc reports that they wanted to develop as a verification process in their reporting requirements to Department of HHS.

Environment:

IBM Cognos 10 Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Connection , SQL Server 2008, IBM DB2.

Confidential

Position: Sr. Cognos Developer

Confidential multinational banking and financial services corporation which was founded in Pittsburgh, Pennsylvania. It is one of the largest bank-holding company in United States by assets. It is a diversified financial services company with operations around the world. Business Intelligence data models are developed in Cognos Framework Manager and Power Play from the data warehouses. Analytical reports and cubes are developed and provided for marketing and business users.

Responsibilities:

• Gathering the requirements and prepare report design documents.
• Planned an approach for documenting, categorizing and packaging the requirements.
• Involved in Designing and creating various models and Publishing packages in Framework Manager.
• Developed advanced reports using Report Studio.
• Developed various report types ranging from simple lists, crosstab, chart, through complex dashboards, drill-through, Master-Detail and Conditional formatting reports.
• Created Complex, multipage reports involving prompts, Cascading prompts, Conditional rendering and Conditional formatting.
• Created custom prompted reports in Report Studio, bursting reports to different user groups.
• Developed reports using Cognos 10.1.1 in various environments.
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making.
• Performance tuning on power-cubes to reduce Query time and partitioned Cubes.
• Tested and validated the report output against the database to measure performance of reports.
• Developed Complex dashboard reports for various reporting requirements.
• Identified various dimensions and measures required for the generation of a cube.
• Extensively worked on updating reports from Cognos 8.x to Cognos 10.1 Environment.
• Performed Troubleshoot on various existing reports that had issues and resolved tickets from production system.
• Developed complex PL/SQL stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.
• Deployed packages, folders and Content store from a development environment to test and then to QC and Production environments.
• Extracted data from different Sources like Oracle, DB2, Teradata and Flat Files.

Environment:

IBM Cognos 10/8.4 Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Connection , Cognos Report Net 1.1 MR2 Framework Manager, Report Studio and Query Studio , Power Play Transformer 7.4, Power Play Enterprise Server 7, Oracle 10g SQL, PL/SQL , SQL Server 2005.

Confidential

Role: Sr. Cognos Developer

Confidential is the largest wireless company in the United States, with more than 54 million subscribers who use the nation's largest digital voice and data network. The Company offers an integrated set of telecommunications services, including local, long distance, data and a full suite of Internet services. Here we were involved in creating different kinds of dashboards and reports on Payments and billings, Corporate Sales, Referral programs, Loyalty Relationship and also exporting them to excel spreadsheets.

Responsibilities:

• Worked on Report studio for building different kinds of Reports like Employee Information, Fast Query Builder which will let the user to select the data items and filters dynamically which they want to see in the Report output using Java scripts.
• Developed List, cross tab, chart and complex reports which involved in Multiple Prompts, multi-query against Relational Data.
• Interacting with the End users to gathering the reporting requirements.
• Creating multiple queries in a single report, Drill-through reports and used Master Detail Relationship within the list.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Participated extensively in testing the new packages for the Data Accuracy.
• Created templates, standard reports, and Ad-hoc reports using Query Studio and Report Studio.
• Created Complex, multipage reports involving prompts, Cascading prompts, Conditional rendering and Conditional formatting.
• Trained professional authors to write complex reports using Report Studio and trained power users to use Query Studio for Ad-Hoc reporting.
• Designed developed reports from the Data warehouse using Cognos 10.1 Report Studio, Analysis Studio reports.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/subtract queries in Report Studio.

Environment:

Cognos 8.4 Framework Manager, Report Studio, Query Studio, Cognos Connection , Cognos 10.1, Java Scripts, PowerPlay Transformer 7.4, Cognos EP Series, Enterprise Server, SQL Server 2005, Windows XP

Confidential

Sr. Cognos Consultant

Confidential is technologically advance innovative company has gained a worldwide reputation for elegance, luxury and superior quality. Project dealt with the implementation, maintenance, and administration of the Cognos 8.4 BI. It includes building various types of reports and Models for Merchandising, Sales Audit, Warehouse Management, and Inventory Optimization Departments using Cognos 8.4. The reports were built for the data extracted from Data Warehouse which gets data from Escalate E1 Retail System and also includes history.

Responsibilities:

• Closely worked with Business Users to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers
• Developed requirement specification documents with inputs given from Power users and also designed report mockups when required
• Worked on modeling the metadata extracted from multiple databases and established joins and cardinality to meet the business needs
• Developed required models for reporting using advanced Framework Manager Techniques to meet all the reporting requirements.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers
• Created security filters at the Framework level to restrict data access created very effective and user friendly prompts which gives users flexibility to analyze the data in all possible ways and at the same time achieved tremendous performance time.
• Used Capabilities features to customize the security features and provided required security for Different groups of users
• Created exports and imports for the Deployment of reports within servers Test, Stage and Production.
• Worked closely in achieving performance tuning Created Jobs and scheduled some of the complex reports periodically during the off-peak times to effectively utilize the resources using Schedule Management in Cognos Connection
• Created various ad-hoc reporting templates list reports, chart reports, cross tab reports for power users in Query Studio
• Worked with users throughout the testing phases to assure that data being generated matched current merchandizing, accounting reports.

Environment:

COGNOS 8.3/8.4 Frame work Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Configuration , Transformer, Power Play, Access Manager, Oracle 10g, SQL Developer, TOAD, MS SQL Server 2005, IIS Manager, Escalate Retail ERP, Windows 2003 and Linux.

Confidential

Cognos ReportNet Consultant

Description: Confidential is one of the three divisions at Indiana Department of Environmental Management IDEM which undertakes the responsibility to ensure that every public water system in the state will provide water that is consistently safe to drink and protect other lakes and streams throughout the state and keep a check on the pollution levels. The data collected helps the agency to keep a check on the pollution and water quality measure of all the lakes across the state of Indiana.

Responsibilities:

• Actively involved in meetings with the user group and designed Business Requirement Documents BRD .
• Responsible for creating packages which connect to different data sources, establishing relationships in model, and publishing packages to ReportNet server.
• Created IQD's in Framework manager and used them as data sources for building cubes.
• Involved in Deployment and Administrative maintenance of the cubes, packages and reports in development, test and production environment.
• Created Filters, Prompts, Calculations both at package level and report level.
• Created various reports using drill through, cascaded prompts, conditional formatting and master detail relationship.
• Setup security both at package level, query subject level in Framework Manager, object level in the portal and also at the cube level.
• Design, development and implementation of Impromptu Catalogs for various organizational cubes as well as detail drill-through reporting.
• Used Cognos Connection for security, organizing, scheduling and distributing reports.
• Created Hot Files and Snap Shot in Impromptu.
• Involved in upgradation of Cognos Impromptu Reports to Reportnet 8 suite
• Was member of team to do a proof of concept on Cognos 8 BI
• Migrated impromptu catalog and its corresponding reports to Reportnet Package and Reports respectively using Cognos Migration Utility
• Compared Cognos 8 BI analysis tool to Cognos 7.3.
• Was responsible for configuration of Cognos 8 BI portal in test environment.

Environment:

Cognos 8 BI, Cognos ReportNet 1.1, MR2, Cognos PowerPlay 7.3, Framework Manager, Cognos Impromptu, Impromptu Web Reports IWR , Oracle 9i, SQL Server2000, Unix, MS Excel, MS Word, Visio, MS Outlook, Windows XP Professional.

Confidential Cognos Consultant

• Confidential is a growing pharmaceutical company they manufacture, sale, and distribution of Forest-branded ethical prescription products in the United States. Forest Laboratories, drives the research, development, and clinical evaluation of our pharmaceutical products and provides ongoing scientific support for their commercialized products
• Project dealt with involved with end users and project managers to define reporting requirements for various medical research and processes using Cognos reporting tools Cognos Reportnet, Power Play, and Impromptu . Used a variety of reporting packages to produce, schedule, and distribute defined reports

Responsibilities:

• Designed, developed and implemented an Enterprise-wide Reporting system using Cognos ReportNet.
• Involved in gathering Business Requirements for New Models.
• Imported metadata from various sources such as Relational Databases and ReportNet models into the Framework Manager.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Planned and Created professional reports in Report Studio and Ad-hoc reports in Query Studio.
• Used Report Studio to build multi-page, multi-query reports against multiple databases.
• Created Calculations, Conditions and Filters.
• Integrated various Customized Prompt, Conditional Variables in the report and designed multi-List reports operated by choice prompts adding flexibility to the report.
• Implemented security by creating Namespaces and User Classes using Access Manager.
• Performed proof-of-concept projects in ReportNet Framework Manager, Report Studio, Query Studio and Cognos Connection .
• Scheduled reports to run on a monthly, weekly, and daily basis using ReportNet.
• Trained users in Query Studio and provided sample.
• Demonstrated reports for understanding the Report layouts and functionality.

Environment:

ReportNet 1.1 MR2, Cognos Connection, Report Studio, Query Studio, Frame Work Manager, Access Manager, LDAP Server, Cognos Scheduler, Cognos Configuration, IBM DB2 UDB, SQL, HTML, Windows NT/2000, Visual Basic.