SUMMARY

• Cognos Certified Professional with 9+ Years of total IT experience in the design, modeling, development and testing of database and Data Warehouse applications.
• 8 years of Data Warehousing experience using Cognos v10.x (Framework Manager, Report Studio, and Query Studio), Impromptu 7.x/6.6/6.x, PowerPlay, Transformer, Impromptu Web Reports, Upfront, Cognos DecisionStream, Scripting, Informatica PowerCenter v8.x/7.x.
• Strong experience in Installation, Configuration, Monitoring and Management of Cognos on both UNIX and Windows platforms.
• 8 years of experience using Oracle, Developer 2000, PL/SQL, SQL*Plus, Win NT 4.0, Linux.
• Experience in Oracle PL/SQL programming (Collections: Nested tables/VARRAY, Functions, Procedures, Packages, Triggers, Indices and database objects) and Shell Scripting (C Shell, K Shell, Bourne Shell)
• Expertise in working with JAVA technologies like JSP, EJB, RMI, XML,CORBA etc.,
• Expertise in working with Client/Server applications using VB, Oracle, SQL Server

TECHNICAL SKILLS

BI Tools: Cognos 10/8 BI Series, Cognos Metrics Manager, MicroStrategy

ETL Tools: Informatica PowerCenter, Cognos Decision Stream, OWB, Ab - Initio

Programming: VB, Java, C, Pro*C, SQL/SQR, PLSQL, C++

Internet Technologies: HTML 4.0, VB.NET, JavaScript, ASP

Java Technologies: EJB, RMI, CORBA, JSP

Front End: Developer 2000, Visual Interdev, and Visual Basic

Databases: Oracle (8i, 9i, 10g), Sybase, DB2, SQL Server

Operating Systems: Windows 95/98/00/NT 4.0, UNIX (Solaris, HP)

PROFESSIONAL EXPERIENCE

Confidential, Orangeburg, NY

Senior Cognos Developer

Responsibilities:

• Gathered report requirements from Business Users and converted them in to technical documents
• Installation and configuration of the Cognos 10.2 in Development environment.
• Experience in building models using Framework Manager & creating simple to complex reports in Report Studio.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Designed & Implemented List, cross tab, chart, drill through, master-detail and complex reports with Multiple Pages/Prompts in Report Studio.
• Created multi-page reports based on multiple master queries to show the data on different pages when the master record changes in a report using Report Studio
• Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Created optional filters/prompts in report studio using Java Script and HTML.
• Implemented Cognos SDK code for extracting the report schedules defined by power users.
• Upgraded FM models, reports from Cognos Version 8.4 to 10.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Involved in creating the User Training manual to help the Business Users understand the reporting architecture.
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Environment: Cognos 10.2.1 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos GO Mobile v10.2, Cognos SDK, JSP, HTML, Java, Shell Script, Oracle 10g, SQL Server.

Confidential, Warren, NJ

Senior Cognos Developer

Responsibilities:

• Discussed with clients about their present reporting system and understand their current reporting issues to meet their needs.
• Built POC reports to showcase how to achieve client needs using real time scenarios.
• Demonstrate the flexibility of Cognos using Cognos Report Studio, Analysis Studio and how Cognos could help them to meet their reporting needs.
• Performed the distributed installation and configuration of Cognos 8.3 on new servers in Production, Testing and Development environments.
• Fact and Dimension tables were used in the Cognos FM model for Package building.
• Built new packages using Cognos Framework Manager and converted the existing reports from Excel to Cognos reports using Cognos Report Studio.
• Used ROLAP and OLAP models as source to create reports using Report Studio.
• Built complex reports using SQL scripts.
• Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly.
• Deployed the Cognos Content from Development environment to UAT/Production environments
• Closely worked with Cognos Support team for troubleshooting complex issues.
• Responsible for creating the Cubes and Reports and scheduling them accordingly.
• Extensively used PowerPlay Transformer to move relative data mart data into PowerCubes.
• Maintained users, groups, and roles and assign them respective privileges as per business needs.

Environment: Cognos 8.4 (Report Studio, Analysis Studio, Event Studio, Metric Studio, Query Studio), Cognos PowerPlay Transformer v7.4, People Soft ELM v 9.1, SQR, PL/SQL, Web Sphere application server, Java, Shell Script, Oracle 10g, MS Excel 2007, MS Access 2007, Win 2K, HP-UNIX

Confidential, Nutley, NJ

Senior Cognos Developer

Responsibilities:

• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Installation, Configuration and Maintenance of Cognos Application on Development and UAT Environments.
• Customized Cognos Connection with appropriate reports and security measures.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created multi-page reports based on multiple master queries to show the data on different pages when the master record changes in a report using Report Studio.
• Conceptualize and formalize several list, crosstab, master-detail, drill-down and bursting reports to be developed, using Report Studio, and made available to the users.
• Bursted the reports in Cognos Connection based on the RDT number.
• Developed a renaming utility using SDK to rename the bursted reports for better distribution of the reports to various user groups.
• Define the security structure for the complete user community, by adding roles and groups to the Cognos Connection directory and mapping all the users to one or more of these roles/groups.
• Deployment of reports, packages, users and sometimes the complete content store from one environment to the other.
• Created various IQD package in Framework Manager and used this IQD’s in PowerPlay transformer to create various models and build cubes
• Migrated reports from MicroStrategy to Cognos 8 environment.
• Developing multi-dimensional analysis and business metrics reports using Cognos PowerPlay and Power Cubes using Cognos Transformation Server.
• Prepared detailed user manual(s), for different package(s), explaining the business rules behind all the fields in the package.
• Trained business users on how to create ad-hoc reports using Query Studio.

Environment: Cognos 8.2 BI Series (Report Studio, Query Studio, Analysis Studio, Metric Studio), Framework Manager v8.2, Series7.3 (Transformer, PPES and all Server Administration), Python, Informatica Power Center v7.1, Toad v7.6, Java, JSP, Oracle 9i, DB2, MS Access,UNIX (AIX)

Confidential, Hartford, CT

Cognos Developer

Responsibilities:

• Developed 45 ReportStudio reports.
• Gathered business requirements by conducting user interviews and documented their query, business analysis and reporting needs.
• In Framework Manger Database layer resembles mostly Star Schema (sometimes worked with views and stored procedures) and business view includes user understandable tables and columns.
• While creating Framework Manager Model, worked on different possibilities like segmentation, links and shortcuts etc., to get the best model for the business.
• Created stored procedures and views and imported into Framework Manager to create some complex reports.
• Extensively used conditional block sections for creating multiple queries in a single Cognos ReportNet Reports for reuse and layout.
• Responsible for creating the Cubes and Reports and Scheduling them accordingly.
• Integrated Cognos PowerPlay Cubes and Reports with Cognos Connection.
• Responsible for publishing PowerPlay Cubes to upfront using PPES to provide end users with a single, Web-based point of personalized access to reports.

Environment: Cognos 8, Series7 (PowerPlay Transformer, PPES, Access Manager, Upfront and all Server Administration), Informatica Power Center v6.2, Tomcat 5.1 application Server, Java, DB2, PeopleSoft HR/Financials, UNIX (AIX)

Confidential

Software Engineer/Cognos Developer

Responsibilities:

• Designed the reports and catalogs using impromptu as per the requirements.
• Extensively used PowerPlay Transformer to convert the data into power cubes.
• Modified Power Cubes by adding new Dimensions, Levels and Measures. Designed Cognos Transformer cube models using reports modeled according to user needs.
• Installed Cognos ReportNet and Framework in an interim environment as a proof of concept.
• Involved in migration of catalogs from Impromptu to ReportNet using Migration Utility.
• Created customized BI reports linking various databases, to meet the user requirements.
• Designed models using Framework Manager and deployed packages to the ReportNet Servers.
• Created standard and Ad hoc reports using Cognos Query Studio.
• Developed technical document.
• Developed Templates, standard Reports, Master Detail Reports.
• Created Complex mappings using Connected/Unconnected Lookup, Aggregator and Router transformations for populating target table in efficient manner.
• Created Mapplets and used them in different Mappings.
• Created events and tasks in the work flows using workflow manager.
• Provided production support by monitoring the processes running daily.
• Created Schema objects like Indexes, Views, and Sequences.

Environment: Cognos ReportNet 1.x, Impromptu 7.0, Power Play Transformer7.0,Power Play Web 7.0, Upfront 7.0, Access Manager, Power Play Enterprise Server, Oracle 9i(SQL,PL/SQL), Windows NT,UNIX, Informatica Power Center 6.1, Oracle, DB2