Summary

• 10+ years of IT experience in analysis, development, administration, testing and implementation of Business Intelligence applications using Cognos Suite products.
• Experienced in various Cognos tools such as Cognos 8/8.2/8.3/8.4/Cognos 10.1 (Cognos Connection, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Metric Studio and Transformer 8.3/8.4/10.1), Report Net, Impromptu, PowerPlay Transformer, and Power Play Windows/Web and Cognos EP Series 7.
• Proficient in developing reporting applications employing Cognos 8/Cognos 10.1 components like Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced, Metric Studio and Cognos Connection.
• Experience in creating drill through and master detail, and multi page reports using Report Studio.
• Expertise in creating business models and designing packages using Framework Manager in Cognos 8/8.2/8.3/8.4/Cognos10.1.
• Proficient in deploying reports and packages from one environment to other environment.
• Involved in installation, configuration and upgrade of Cognos ReportNet to Cognos 8/8.2/8.3/8.4/Cognos 10.1.
• Efficient in developing OLAP Multi-Dimensional cubes including drill through functionality.
• Proficient in Developing Reports in Report Studio using Multidimensional Data.
• Developed transformer models using Powerplay Transformer 7.3/7.4 (OLAP) and also developed models using Cognos 8.3 / Cognos 8.4/Cognos 8.4.1/ Cognos 10.1 Transformer.
• Proficient in developing Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Acquired experience with full life cycle of Software Development (Planning, Analysis Design, Deployment, Testing, Integration and Support).
• Hands on experience working with databases Oracle 8i/9i/10g, MS SQL Server 2000/2005, and MS Access.
• Excelled in business analysis and gathering requirements definition and converting them to project deliverables.
• Strong experience with client interaction, understanding business applications, business data flow and data relations.
• Created Operations, Steps, Jobs, Schedules and Alert List using Envisn product AutoVisn Administrator and AutoVisn Operation Editor.
• Extensively worked on scheduling Weekly cubes, Monthly cubes and Quarterly cubes using Envisn Product AutoVisn Administrator and AutoVisn Operation Editor.
• Conducted Team Meetings every week and Updated the Status in weekly Meetings.
• Assigned tasks to Team Members.
• Good communication skills with strong ability to interact with end-users, customers, and team members.
• Solid analytical and dynamic troubleshooting skills. Possessing excellent communication skills and is able to work individually and as a team member.
• Self-motivated and enjoy working in a technically challenging environment.

Technical Skills

OLAP/BI Tools: Cognos Report Net 1.1MR1, MR2, Cognos 8/8.2/8.3/8.4/8.4.1/Cognos 10.1 (Cognos Connection, Framework Manager, Report Studio, Query Studio,Business Insight, Business Insight Advanced,Metric Studio and Transformer 8.3/8.4/Cognos10.1), Cognos EP Series 7.1(Impromptu Administrator, PowerPlay Transformer 7.3/7.4, Enterprise Server, Architect, Access Manager, Visualizer, Upfront, Cognos Query), Business Objects 5.1,Crystal reports.
Testing Tools: Mercury Interactive tools Win Runner, Test Director, Rational Clear Quest
ETL Tools: Informatica (Power Center/ Power Mart) Client Tools (Repository Mgr,
Designer, Server Mgr and Informatica Server).
Languages: Java Script, HTML, XML, SQL, PL/SQL and C.
O/S: UNIX, Windows 98/NT/2000
Tools: Dimensional Data Modeling, Star Join Modeling, Snow - flake Schema Modeling, Erwin 3.5.2/4.0, Microsoft Visio, SAS.
Databases:Oracle /8i/9i/10G, SQL Server 2000, MS Access

Educational qualification

• Master of Science in Computers
• Bachelor of Science

Professional Experience

Client: Confidential, Alpharetta, GA
April 2011 - Till Date
Role: Senior Cognos Developer/Writer/Administrator
Confidential, combined customer base includes thousands of healthcare organizations and over a million requesters throughout the United States.The release of information (ROI) industry was established in the summer of 1978 when HealthPort (founded as Smart Corporation) founder John Smart identified the need to address the administrative strain on healthcare facilities in releasing protected health information (PHI).
Further technological advancements were made to enhance its automated release of information system
and provide flexible service delivery options for customers. Among these innovations are a web-based logging and tracking system for release of information requests and a secure electronic delivery mechanism for health information. Additionally, HealthPort enabled healthcare providers to face the challenge of accounting of disclosures with a web-based capture and reporting solution.

Responsibilities:

• Interaction with business users to gather business requirements and designed functional and technical requirements documentation.
• Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to Cognos 10 server.
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Used Framework Manager to externalize query subjects in order to generate IQD data sources for Powerplay cube creation in Powerplay Transformer.
• Built and Published the Packages to Cognos 8 and Cognos 10 Server according to user requirements
• Experienced in creating different types of security in models using framework Manager.
• Secure Cognos Connection and setup Security by assigning user to the groups and roles defined in Cognos Namespace.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio
• Worked on Multidimensional Models and created Reports in Report Studio using Cubes as a data sources.
• Proficient in developing Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Used Go Dashboard to generate highly complex graphical reports.
• Migrated reports created in Cognos 8 into Cognos 10.
• Involved in installation, configuration and upgrade of Cognos 8 to Cognos 10.1.
• Worked on creating Prompts and Cascading Prompts Pages.
• Worked on summary reports and detail Reports, drill-thru reports.
• Created drill through reports and associated with the summary reports to get details.
• Validated report results with the source data and sanctioned the reports to production environment.
• Worked on scheduling and publishing the report to the Cognos Connection.
• Proficient in deploying Reports and Packages from one environment to other environments.
• Used conditional formatting to achieve identical results in different formats like HTML, PDF and EXCEL.
• Created users and giving authorizations to the system users depending on their roles.
• Developed transformer models using Powerplay Transformer (OLAP) and also developed models using Cognos 8.3 / Cognos 8.4 /Cognos 10.1 Transformer.
• Modified power cubes by adding new dimensions, levels and measures etc.
• Published cubes as packages to cognos connection using framework manager.
• Published cubes directly from Cognos 8.3/cognos.8.4 / Cognos 10.1 Transformer using new publish functionality.
• Worked on cognos production tickets to meet business requirements.
• Prepared Report documents once the development is completed.
• Installed and Configured Cognos TM1 Architest and Cognos Insight 10.2 and Cognos TM1 Application in Development Environment.
• Developed some Reports using Cognos Insight and published into Cognos TM1 Application and Cognos Connection.
• Conducted Team Meetings Every week.
• Assigned tasks to Team Members and Conducted Weekly Meetings with Team Members.
• Updated the Status in weekly Meetings.
• Trained end users on Query Studio for Ad-hoc reporting as well as involved in the Documentation.
• Developed Business Requirement Specs as a Business Analyst.
• Acted as lead in troubleshooting Report performance problems.

Environment:Cognos 8.4/Cognos 10.1(Cognos Connection, Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced, Metric Studio and Transformer), Oracle 9i/10g, TOAD 9.5, Query Analyzer.

Client: Confidential, Boston, MA
July 2005 - March 2011
Role: Cognos Developer/Administrator
Confidential, provides a wide range of services to health care providers, and other offices of the state government. The agency administers public assistance programs that provide eligible residents with subsidized health care and prescription medication. MassHealth provides health insurance to qualified Massachusetts residents. The program offers health care coverage for uninsured low-income adults who are not eligible for MassHealth or Medicare. The EOHHS is also responsible for providing community education about public health programs and resources.

Responsibilities:

• Interaction with business users to gather business requirements and designed functional and technical requirements documentation.
• Built and Published the Packages to Cognos ReportNet and Cognos 8 Server according to user requirements
• Experienced in creating different types of security in models using framework Manager.
• Secure Cognos Connection and setup ReportNet Security by assigning user to the groups and roles defined in Cognos Namespace.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio
• Worked on creating list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations, conditional highlighting
• Proficient in developing Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Used Go Dashboard to generate highly complex graphical reports.
• Migrated reports created in CRN 1.1MR3 into Cognos 8. This migration was handled on a report-by-report basis as the seamless migration resulted in a report feature conflicts between CRN 1.1MR3 and Cognos 8.
• Mapping CognosSeries 7 Security into Reportnet and setting up Users and User security using Cognos Access Manager.
• Worked on scheduling and publishing the report to the Cognos Connection.
• Proficient in deploying Reports and Packages from one environment to other environments.
• Created Operations, Steps, Jobs, Schedules and Alert List using Envisn product AutoVisn Administrator and AutoVisn Operation Editor.
• Extensively worked on scheduling Weekly cubes, Monthly cubes and Quarterly cubes using Envisn Product AutoVisn Administrator and AutoVisn Operation Editor.
• Created scorecards and metrics using Metric Studio
• Experienced in creating events using Event Studio.

Environment:Cognos 8/8.2/8.3/8.4/8.4.1/Cognos 10.1(Cognos Connection, Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced, Metric Studio and Transformer), ReportNet1.1 (Framework Manager, Report Studio, Query Studio), PowerPlay Transformer 7.4, Oracle 9i/10g, TOAD 9.5, Envisn Product AutoVisn (AutoVisn Administrator, AutoVisn Operation Editor), SQL SEVER 2000, ETL Tool, Query Analyzer.

Client: Confidential, Mill Valley, CA
Nov 2004 - May 2005
Role: Cognos Developer
Confidential, is an Internet based, technology enabled, full service Marketing Research Company focused on primary marketing research - concept tests, product tests, sorts (alternative tests), advertising research, trackers and a lot more. Zoomerang is an ASP online survey research tool, provides users with simple web based tools to build, customize, and send surveys via email and then quickly analyze the survey results. zTelligence is a user-friendly Internet based application, based on the Application Service Provider (ASP) model. Market Tools hosts zTelligence on their servers, and the clients can access the product over the Internet.

Responsibilities:

• Installed and Configured cognos ReportNet 1.1 MR3
• Worked on framework manager to import metadata from multiple data sources and to create subject matter models, create and publish packages to ReportNet server.
• Involved in design and development of Joins, filters, calculations, prompts and conditional variables in Packages in Framework Manager.
• Involved in scheduling and Administering Cognos ReportNet reports using Schedule Management in Cognos Connection.
• Peer Reviewed Design and Code of other Developers, prepared defects list and modified design docs and code as per defects list
• Worked on summary reports and detail Reports.
• Developed standard historical reports in Report Studio for use of Call center Mangers
• Worked on scheduling and publishing the report to the Cognos Connection.
• Very good experience in creating User Groups and Roles in Acess manager.
• Worked on Security access to clients (using Access Manager and ReportNet with LDAP also worked with Data Access, Object Access, and Package Access in Frame Work Manager).
• Created drill through reports with different parameters and associated with the summary reports to get details.
• Sql Tuning to enhance the performance of the reports.
• Created Prompts, Calculations, Conditions & Filters and creating New Jobs using Impromptu Administrator.
• Administered ReportNet server with the primary objective of tuning server performance to optimize speed and efficiency.
• Created Models by using various data sources in PowerPlay Transformer.
• Created User Classes and Users in Access manager and provided the user credentials
• Created extremely big OLAP cubes.
• Used PowerPlay Enterprise Server to publish the cubes and Impromptu reportsto the Upfront.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Deploying the packages and reports to production environment.

Environment:Cognos ReportNet 1.1 MR3, Cognos PowerPlay Transformer 7.3 (Windows / Excel / Web), Access Manager 6.5, Oracle 9i, Informatica 7.1.3, Siebel 4.9, Toad 8.5, Solaris, Windows XP.

Client: Confidential, Hyderabad, India
May 2001 to Nov 2004
Role: Cognos Developer
Lifeline is highly integrated and a complete solution for the entire health care industry ranging from a small clinic to a super specialty corporate hospital. Lifeline is Healthcare Information Resource Planning System Developed by AHSL Medical Systems Information Technology. This Package provides the complete integration of all the Hospital Services. Along with data reports, various types list reports, multi pages reports and graphical reports developed which will help the management in a great way to analyze and improve business/service.

Responsibilities:

• Involved in User Requirements, Analysis and Gathering
• Worked on Cognos Security Administration to restrict the Users.
• Developed standard Templates
• Created the Oracle Stored Procedures to extract the data from .DBF files
• Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports
• Creating Query Prompts, calculations, Conditions & Filters and Coditional Formating.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Testing and improving Report Performance.
• Created Models by using Impromptu Query Definition (IQD) in PowerPlay Transformer.
• Created User Classes and Users in Access manager.
• Created OLAP cubes and PowerPlay published cubes and Impromptu web reportsto Upfront.
• Written macro\'s to schedule the Power Cubes.
• Developed transformer models using Powerplay Transformer.
• Modified power cubes by adding new dimensions, levels and measures etc.
• Involved in Query Optimization and User accept testing on all the user reports
• Creating New Jobs using Cognos Connection.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Created users and giving authorizations to the system users depending on their roles.

Environment: Impromptu 7.1, Powerplay Transformer 7.1 , PowerPlay Enterprise Server 7.1, Access Manager, SQL Server 2000, Oracle 9i, DTS, Visio, Crystal Reports 9, MS-Excel and Windows 2003.