SUMMARY:

• Software Professional with 6+ years of experience with Business Intelligence tools like Cognos 8 Report Studio, Analysis Studio, Metrics Studio, Query Studio, Framework Manager, Power Play and Transformer, Access Manager, Cognos Series 7.0 and Cognos Report net.
• Planned and constructed OLAP Power Play Transformer OLAP/CUBE 7.3/6.0 for Data modeling of the corporate Data for building multi dimensional cubes.
• Expertise in Analysis and developing Database Schemas like Star Schema & Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Created, modeled and published packages in Framework Manager from multiple databases for use with Report net, Report Studio and Query Studio and Analysis Studios.
• Strong background in building relational model and dimensional model in framework manager.
• Expertise with Framework Manager, Cognos BI 8.4/8.3/8.2/8.1/8.0/CRN, Cognos Connection, Report Studio, and Query Studio, Event Studio, Metric Studio and Analysis Studio.
• Experience in working with various databases that include Oracle, SQL Server Databases.
• Experience in Created reports like List, Cross tab and Dashboards by using Report Studio.
• Experience in design, development, maintenance and support of Cognos Report Studio and Cognos Power Play reports.
• Good exposure in Interacting with Business users to get requirements, to fix issues or train users on ad-hoc reporting. Expertise in design and reports including Dash board reports development of highly complex query.
• Thorough understanding of System Development Life Cycle (SDLC) experience from requirement analysis through Design & Development.Self motivated, creative, work with minimal supervision, debugging and crisis management. Excellent interpersonal and oral and verbal communication skills.

SkillS:

BI TOOLS:

Cognos 8/8.2/8.4, Report Studio, Query Studio, Analysis Studio,
Event Studio, Framework Manager, Cognos Connection),
Cognos EP Series7/7.1/7.3 (Impromptu, Power Play,
Transformer, Access Manager, Power Prompts, Cognos Query), Report Net

Operating Systems:

Windows 2000/2003/ Vista/ 2008, Windows 7

Software Packages:

MS- Office, Microsoft Word, Excel and Power Point.

Databases:

MS SQL Server 2005/ 2008, Oracle 11g,10g/9i/8i/7, MS Access

Data Modeling:

Physical and logical, Star schema, snowflake schema, Normalization.

PROFESSIONAL EXPERIENCE:

Confidential,Pittsburgh, PA Jan 2011- Current
Cognos Developer
Confidential,emphasizes the development and delivery of innovative programs to positively affect the personal health of its members. Gateway Health Plan® maintains a healthcare delivery system that ensures the availability of high quality medical care for the Gateway member, based upon access, quality and financial soundness. Gateway Health Plan® is a managed care organization that provides service to members eligible for medical assistance in Pennsylvania. Gateway’s mission is to provide accessible, quality health care services to its member.
Responsibilities:-

• Involved in creating/updating Relational Model and publishing packages using Framework Manager.
• Involved in modeling (star schema / snowflake schema) as for the user requirement using Framework Manager also created models using different hierarchies.
• Involved in creating Metadata models using Framework Manager and publishing the packages to Cognos Connection.
• Implemented security for Data access, Object level access and package access in Framework Manager.
• Expert in setting up project/folders across multiple environments (development, test, production).
• Designed and Developed List & Cross Tab reports, Charts, Drill through Reports, Master Detail Reports using Report Studio. Worked on Query Studio.
• Proven experience in building Complex Reports using prompts and parameters in Report Studio.
• Formatted reports for various Output formats.
• Technical Design of Reports, Report bursting and Report Distribution.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Multidimensional and Relational modeling in Framework manager.
• Created Detail filter, Summary filter and calculated query item in the metadata model.
• Developed standard Reports, Master Detail Reports using Report Studio and Query studio.
• Created reports having Filters, multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option of bursting of reports.
• Provided training to end users on Query Studio to create Ad-hoc Reports. Scheduling and maintenance of the reports on the timely basis.
• Involved in analyzing the cardinality between query subjects.
• Customized data by adding Calculations, Filters, Prompts and Governor Settings.
• Worked as a team towards finishing the tasks and achieving project deadlines.
• Deployed the reports to test and production environments.
• Production Support which involves solving user problems.

Environment: Cognos 8.4/8.3/8.2/8.1 (Framework manager, Report Studio, Query Studio and Metric Studio), Cognos Power play Transformer 8.4,Access manager, Data Manager, Oracle 11g, TOAD 8.6,Onbase 7.0, Microsoft SQL Server 2005/2008,Windows XP.

Confidential, New York, NY April 2009- Nov 2010

Senior Cognos Developer

• Morgan Stanley is one of the world\'s largest diversified financial services companies, with a reputation for excellence in advice and execution on a global scale. Morgan Stanley has earned recognition as a leader in every aspect of financial services and as one of the most admired companies in any industry. Morgan Stanley has served as the preeminent financial advisor to companies, governments and investors from around the world.
  

Responsibilities:
Reporting

• Experience installing Cognos 8 BI and architecting and delivering data warehousing using Cognos 8 BI suite.
• Requirements gathering and specification writing after interfacing with Business Users, Line of Business and Other Stake Holders.
• Work with project managers, Business Analyst and end users to understand business requirements and translating them to technical specifications.
• Oversee transition from Cognos 8.2 to 8.4 and Experience installing Cognos 8 BI.
• Involved in creating/updating Relational Model and publishing packages using Framework Manager.
• Apply OLAP functionalities such as drill-down/drill-up in Analysis Studio and Report Studio.
• Involved in designing and creating various reports in Report Studio.
• Customized data by adding filters at Report level.
• Worked extensively with the Distribute the reports and dashboards widely with the right content distributed to the right recipient by executing a single report.
• Experience in Developed business intelligence Dashboard report for application portfolio.
• Expertise in OLTP/OLAP system study, analysis and developing Database schemas like Star Schema and Snowflake Schema.
• Customizing Cognos Connection Portal based on user specifications.
• Created different types of reports like List, Cross-tab, Chart Drill-Thru, Master Details, cascading using different prompts.
• Created Business views, namespaces, model query subjects in Framework Manager Model for easier report development and to enhance multi user environment.
• Proven experience in building Complex Reports using prompts and parameters in Report Studio.
• Formatted reports for various Output formats.
• Technical Design of Reports, Report bursting and Report Distribution.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Multidimensional and Relational modeling in Framework manager.
• Worked as a team towards finishing the tasks and achieving project deadlines.
• Developed test plans, scripts and test cases for Unit, Integration, Regression, UAT.

Power Play:

• Cognos Multidimensional Cube development using Cognos Power play transformer and Report generation on Cognos Power play cubes.
• Involved in creating OLAP hierarchy, Dimensions, formulas & power cubes using Cognos Power Play Transformer and published the Cubes.
• Power Play reports were created from the various Cubes created for the user. Explorer and Reporter reports were created based on the requirements of the user and the project.

Environment: Cognos 8.4/8.3/8.1 (Framework Manager, Report Studio, Query Studio, Metric Studio, Event Studio, Cognos Connection, Power play Transformer),Oracle 11g, MS Excel 2003, SQL Server 2005,Windows XP.

Confidential,New York, NY Feb 2008 - March 2009

Cognos Developer

The Goldman Sachs is a global investment banking and securities firm which engages ininvestment banking, securities,investment management, and otherfinancial servicesprimarily with institutional clients. The firm providesmergers and acquisitionsadvice,underwritingservices,asset management, and prime brokerageto its clients, which includecorporations,governmentsand individuals. I was working in finical department as cognos developer.I was involved in gathering business requirement process, Design and support public folder.

Responsibilities:

• Communicated with the Business users to comprehend the requirements. Cognos Data Modeling using Framework Manager.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Scheduled Cognos8 Reports to deliver through e-mail in PDF and Excel formats also Distributing reports.
• Migrating reports from Cognos 8.2 to Cognos 8.3.
• Created Prompts, and Cascading Prompts. Worked on multiple Report pages and multiple Prompt pages.
• Implemented Security through Framework Manager and assigned users to the groups through Cognos connection
• Involved in creating Metadata models using Framework Manager and publishing the packages to Cognos Connection.
• Apply OLAP functionalities such as drill-down/drill-up in Analysis Studio and Report Studio.
• Maintaining the Users, Groups and Roles on Access Manager and Cognos reporting security.
• Created Reports to evaluate the business performance based on various financial indicators.
• Developed complex reports, Scorecards and Job sets.
• Created reports having Filters, multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option of bursting of reports.
• Involved in modeling (star schema / snowflake schema) as for the user requirement using Framework Manager also created models using different hierarchies.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups.
• Created New Jobs using Cognos Connection.
• Developed standard Reports, Master Detail Reports using Report Studio and Query studio.
• Provided training to end users on Query Studio to create Ad-hoc Reports.
• Creation of dashboards and analysis studio reports in Cognos 8.
• Integrated Access Manager with Cognos 8.3 and developed User accounts, groups and authentication.
• Developed Prompt pages and Conditional Variables.
• Modified relationships between different database tables and building Models using Framework Manager.

Power Play:

• Developed multi-dimensional OLAP cubes in Power Play Transformer using various data sources and published in Cognos Connection.
• Power Play reports were created from the various Cubes created for the user. Explorer and Reporter reports were created based on the requirements of the user and the project.

Environment: COGNOS 8.2/8.3, Power Play Transformer 8.2/8.3, Framework Manager, Report Studio, Query Studio, Cognos Connection, SQL Server 2005,Oracle 10g,MS Excel 2003.

Confidential,NJ Apr 2007 – Jan 2008 Cognos Consultant

Confidential, is a global research-driven pharmaceutical company. Merck discovers, develops, manufactures and markets vaccines and medicines to address unmet medical needs. The aim of this project is to provide numerous computer-generated reports and custom analysis to Merck with actionable conclusions, including demographic breakdowns such as size of vendor and number of contracts negotiated with Merck per year and also created report on stock information, Annual reports, proxy statements, Stock holder services.

Responsibilities:

• Worked in building Relational models and multi Dimensional packages and published packages to Cognos Connection using Frame Work Manager.
• Created different types of reports like List, Cross-tab, Chart Drill-Thru, Master Details, cascading using different prompts.
• Created packages in Framework Manager and published to the Cognos connection and created daily, weekly and monthly reports using those packages.
• 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 tabular sets, drill through reports, master detail reports, conditional prompts. Developed Multi Page Reports.
• Developed Prompt pages and Conditional Variables.
• Created New Jobs using Cognos Connection.
• Designed, developed and implemented an Enterprise Wide Reporting system using Report Studio, Query Studio, Analysis Studio, and Framework Manager.
• Involved in setting up Hierarchies, performing Drill and Slice & Dice operations and creating Cross Tab Reports.
• Prompt Reports were created in Impromptu so that the user can type in and get the required data for analysis.
• Production Support which involves solving user problems.

Power Play:

• Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, Power Play reports.
• Decreased the Cube build times drastically and increased runtime performance.

Environment: Cognos Series 8 (Report Studio, Analysis Studio, Framework Manager, Query Studio), Power Play Transformer, Oracle 9i, Microsoft SQL Server 2005/2008.

Confidential,Dallas, TX Aug 2006 -March 2007
Cognos Developer / Analyst
Prudential Financial companies serve individual and institutional customers worldwide. Prudential Financial wanted to consolidate all their Data into a single Data Warehouse and upgrade their reporting methods by providing Ad-hoc reporting facility to their power users by implementing Cognos Report Net in their organization.

Responsibilities:

• Participated in discussions with the senior management to create the business requirements.
• Created different Data sources and Created model using different Data Sources.
• Created packages in Framework Manager and published to the Cognos connection and created daily, weekly and monthly reports using those packages.
• 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 tabular sets, child tabular models, drill through reports, master detail reports, conditional prompts. Developed Multi Page Reports.
• Extensively worked on building Transformer Models – dimension hierarchy, drill-down paths, calculated measures, roll up’s, Performance Tuning.
• Created calculated fields and Manual Level dimensions and sub-dimensions in Transformer
• 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 and cubes.
• Managed Scheduling of cubes and Reports and executed scripts to refresh the cubes on a daily and weekly basis. Involved in analyzing the cardinality between query subjects.
• Customized data by adding Calculations, Filters, Prompts and Governor Settings.
• Production Support which involves solving user problems.

Power Play:

• Developed reports in Cognos Impromptu, Power Play, and Impromptu Web Reports.
• Integrated Cognos Power Play cubes and Reports with Cognos Connection.

Environment: Cognos (Power Play/Transformer, Impromptu, Framework Manager, Cognos Connection, Report Studio, Query Studio), Report Net1.1/1.2, Oracle9i, SQL server 2005.

Confidential,Mumbai, India June 2005 – July 2006
Report net Consultant

Johnson & Johnson Ltd. is themost comprehensive manufacturer of healthcare products, selling more than100 different productsin theconsumer, pharmaceutical and professional market. The project involves design and development of Inventory/Transaction data mart for implementing foreign trade zone trade program in J & J India.

Responsibilities:
Reporting

• Involved in understanding the Business and all Departments within Prudential Financial.
• Interaction with the Management and Development teams for gathering information for creating the Framework Model.
• Designed the Model according to the Business Requirements by creating a Presentation Layer.
• Built the Model using Framework Manager.
• Worked extensively on creating the Model and publishing the package on Cognos Connection for Reporting purposes.
• Used conditional formatting and conditional blocks to display different sets of data based on different conditions in Report Studio.
• Built models using Framework Manager, a Report Net Tool.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Extensively worked on Query Studio for Ad-Hoc Reporting
• Created filters within the Model for improving the performance of the Model.
• Developed Prompt pages and Conditional Variables.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Created Catalog in Impromptu Administrator to create Reports, Created Cubes by using Cognos Power Play for analysis.
• Optimized the cube performance and the report response time.
• Created Stored Procedures for Updating and Inserting data into the database.

Environment: Cognos 8.0 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos 7.3 (Power Play, Transformer, Power Play Enterprise Server), Oracle 9i, MS SQL Server 2000, Windows 2000.

Confidential,Mumbai, India Aug 2004 -May 2005
Developer

Responsibilities:

Extensively worked in full life cycle development of the project including requirements gathering, developing Site Requirement Specifications documents, and developing Detail Software Design documents. Involved in the Installation and Configuration of Report Net 1.1. Designing the model and packages in Framework Manager. Created and published packages in Framework Manager from various data sources. Involved in implementing security features for Report Net reports.

• Worked on Power Play Enterprise Server to publish Power Play reports on web. Performed Reporter Operations such as Sum and Average, Intersection, etc., Developed reports for departments like Production, Planning, Manufacturing, and Procurement.
• Created reports ranging from ad-hoc to complex reports using drill through, conditional formatting and cross tab reports.
• Developed Power Play Transformer models using .iqd files externalized from Framework Manager.

Environment: Cognos Report Net 1.1 (Frame work manager, Cognos Connection, Report Studio, Query Studio), Impromptu, Power Play Transformer, Oracle 8i.

EDUCATION:
Bachelor of Engineering in computer science.