SUMMARY

• 7 plus years of diversified experience in Information Technology.
• Over 5 years of experience in Business Intelligence (Cognos ) using wide range of tools.
• Experience in working in all the phases of Software Development Life Cycle (SDLC).
• Experienced in various SDLC methodologies like Agile, Waterfall and iterative.
• Involved in Installation & Configuration of Cognos in distributed environments on Solaris.
• Expertise in Cognos 10.x/8.x BI suite (Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Configuration), Framework Manager, PowerPlay Transformer, PowerPlay client.
• Experience in publishing PowerPlay cubes to Cognos 8 and reporting using Analysis Studio and Report Studio.
• Expertise in OLTP/OLAP system study, developing models and publishing packages using different schema concepts.
• Good experience in reviewing Business Requirement Specifications, Software Requirement Specifications, unit test cases and system test cases.
• Experience in Transformer model design and Power play cube building.
• Experienced in building Dashboard and Multidimensional reports.
• Experience in dimensionally modeling relational data sources (DMR) using Cognos 8 Framework Manager.
• Extensive experience in working with databases like Oracle, Sybase and SQL Server.
• Excellent SQL writing skills.
• Strong Knowledge of different ETL Tools like Informatica, Oracle Data Integrator.
• Excellent Web Technology skills such as XML, Servlets, JSP, JavaScript, HTML, VB Script.
• Ability to prioritize multiple tasks while meeting deadlines.
• Ability to adapt and learn new technologies and get proficient in them very quickly.
• Good communication skills to maintain productive work relationships with management, clients, team members and other groups.

TECHNICAL SKILLS

Data Reporting Tools: Cognos 8.2/8.3/8.4/10.1 Reporting Suite (Framework Manager, Report StudioQuery Studio, Analysis Studio, Event Studio and Transformer), Cognos 8 CPM(Metric Designer, Metric Studio), Access Manager, Cognos Series7, Cognos ReportNet 1.1/1.2

Operating Systems: Windows 95/98/2000/2005/ XP/NT, Sun Solaris, Linux

Languages: C, C++, Java, PL/SQL

Web Technologies: HTML, XML, CSS

Scripting Languages: Java script, VB script,SQL

Server - side Technologies: Servlets, JSP

Framework: Struts 1.1, JFP 4.0

MS-Tools: Word, Excel, PowerPoint, OutLook, Visio, Sharepoint

Databases: Oracle 11g/10g/9i/8i, SQL Server 2005, MS Access,Sybase

Configuration Management: Rational ClearCase, Motio CI

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr.Cognos Developer

Responsibilities:

• Review and Analyze Business requirements.
• Developing and modifying reports using Report Studio.
• Providing support to users for Query Studio reports.
• Create and modify models using Framework Manager
• Unit Testing reports built using Report Studio and Query Studio
• Migrating reports from legacy system.
• Tuning report queries for better performance

Environment: Cognos 10 Framework Manager, Report Studio, Query Studio, Sybase IQ

Confidential, Herndon, VA

Cognos Developer

Responsibilities:

• Reviewed and Analyzed Business requirements.
• Created reports in Report Studio using Relational and Dimensional Models.
• Created reports with advanced prompting using tokens, filters and Conditional Formatting.
• Create Dimensional and Relational Models in Framework Manager
• Generated IQD’s for cube models in Framework Manager
• Created cube models using PowerPlay Transformer
• Created agents using Event Studio to enable event based scheduling.
• Created Multi dimensional Analysis reports using Analysis Studio
• Created drill through definitions for Cube packages and Relational Packages
• Created reports with drill through functionality in Report Studio
• Created reports with Master Detailed Relationships.
• Created reports with Multiple queries.
• Unit testing Reports against the DB by writing SQL queries

Environment: Cognos 8.4, Cognos Transformer 8.4, Active Directory, Oracle 11g, Windows Server 2005,SQL developer, IIS, Tomcat, Data Stage 7.5 .

Confidential, Secaucus, NJ

Cognos Developer/Administrator

Responsibilities:

• Involved in Installation & Configuration of Cognos in distributed environments on Solaris
• Involved in business requirement discussions and reviewed business requirement documents with the business team to understand the architecture and functionality of the application
• Created Framework Manager projects using XML’s generated by Erwin Models as data sources
• Create ROLAP/DMR (Dimensionally Modeled Relational) models using Framework Manager
• Created reports from DMR models using Dimensional Functions.
• Generated IQD’s for cube models in Framework Manager
• Created cube models using PowerPlay Transformer
• Created Event Studio agents to enable event based notifications
• Created adhoc reports using Query Studio and Report Studio
• Created Analysis style reports using Analysis Studio
• Created Reports with advanced prompting, filters and Conditional Formatting and Master Detailed Relationships
• Designed and Developed Analysis Type reports using Multi Dimensional data sources
• Created drill through definitions for Cube packages and relational packages
• Created reports using Multi Dimensional data sources
• Involved in migration of cubes from series 7 to cognos 8.4
• Performed basic administrative tasks such as adding users, scheduling reports etc.
• Developed shell scripts to build Power Cubes on server in batch mode
• Developed JavaScript snippets as part of conditional formatting
• Troubleshoot Cognos Server Environment for the better performance
• Unit testing of cube Analysis and Reports against the DB using SQL.
• Managing the dispatchers and services in distributed Environment
• Created SQL scripts to provide raw data to users.
• Troubleshoot the server Environment by using logs

Environment: Cognos 8.2/8.3/8.4/10.1 , Cognos Transformer 7.4/7.5/8.4/10.1 , iPlanet, Oracle 10g, Sybase, Solaris 10,SQL developer, Toad, Tomcat 4.0, Apache Webserver 2.0.55,Erwin.

Confidential, Malden, MA

Cognos Developer

Responsibilities:

• Analyzed and Reviewed business requirements with users
• Built Models in Framework Manager, Imported metadata from different data sources into these models
• Developed Complex list reports, crosstab reports and customized reports using Report Studio
• Developed ad-hoc reports in Query Studio
• Worked with dimensional modeling of relational data sources (DMR) using Cognos 8 Framework Manager and create cubes using Framework Manager.
• Designed and Developed Analysis Type reports using Multi Dimensional data sources
• Created Analysis reports from Cubes using Analysis Studio
• Created Batch scripts to schedule cube builds
• Created Jobs to schedule reports
• Created Reports with bursting functionality
• Administered Security using Cognos Access Manager
• Created drill through reports/drill through definitions and implemented conditional formatting in reports
• Designed Power Cubes using Cognos Transformer
• Wrote SQL queries to validate data in Cognos reports with database
• Responsible for documenting all the processes and provide training manuals

Environment: Cognos 8.2, Framework Manager, Report Studio, Query Studio, Analysis Studio, Toad, Event Studio, Oracle 9i/10g, Windows NT/2000, IIS,Web Logic Application server,Cognos Transformer 7.3/7.4.

Confidential, Bellevue, WA

Cognos Developer

Responsibilities:

• Reviewed Business requirement documents with the business team to understand the architecture and functionality of the application
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements
• Business view and published the packages using Framework Manager onto Cognos Connection.
• Implemented Security with LDAP and group level security in Cognos Connection Portal
• Created Jobs to Schedule multiple reports in Cognos Connection
• Created list reports, cross-tab reports and chart reports using multiple queries in a single report, drill trough reports and conditional formatting to highlight the business needs
• Reporting Powerplay cubes in Analysis Studio and Conditional formatting of cube reports in Report Studio
• Used different objects like Conditional Blocks, Tables, HTML item, Hyperlink etc to create complex reports
• Extensively worked on scheduling and deployments
• Involved in designing and developing cognos power cubes in Transformer
• Created procedures, views, tables and functions to support reporting needs
• Trained end users on Query Studio for Ad-hoc reporting as well as involved in the Documentation

Environment: Cognos 8 Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos Series 7 Transformer, Toad, JavaScript, Oracle 9i/10g,MS SQL Server 2005, Windows NT/2000.

Confidential, Virginia Beach VA

Cognos Consultant

Responsibilities:

• Designed models using Framework Manager and deployed packages to the Report Net Servers
• Implemented Framework manager security for Data access, Object level access and Package access
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager
• Involved in migration of Catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager
• Created Dashboard reports using the Cognos Report Studio and Metric Studio
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database
• Created custom templates and custom tool boxes for the use of reporting
• Extensively worked on Analysis Studio to develop multi dimensional reporting
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP)
• Writing the Batch script to update the cube on daily basis
• Designed Power Play reports to provide summarized results by measures and dimensions
• Created custom prompted reports in Report Studio, Bursting reports to different user groups
• Database analytical skills with ability to apply skills to develop reports in Crystal
• Moved Packages and reports from development to QA and then Production servers
• Developed Power Play Reports based on the cubes and published to Report Net Server
• Deployed Cognos OLAP Cube from Testing Environment to Production Environment using Batch script
• Involved in writing Stored Procedures and functions in Oracle PL/SQL
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports

Environment: Cognos 8 BI, Report Net, Framework Manager, Oracle 9i, DB2, Report Studio, Transformer 7.3, Analysis Studio, JavaScript, PeopleSoft.

Confidential

Java Developer

Responsibilities:

• Responsible in design and development of Click-to-pay Services in Visual IDE Tool Software (Rational Application Developer) with Java Struts framework using Unified process development methodology
• Designed and developed software user interfaces with Java Swing components and software code using Rational Application Developer
• Designed and developed software saved data format in XML
• Designed class objects hierarchy and relationship, state and process UML model using Borland Together J modeling tool
• Responsible for Release management and tracked using Clearcase
• Worked with project managers in implementing the UP process of the software development life cycle
• Worked with QA team in producing development test-cases and test-plan

Environment: Java/J2EE, Struts1.1, JFP4.0, Oracle8i, Websphere6.0.2.15, Rational Application Developer v6.0, ClearCase, SVN.

Confidential

Java Developer

Responsibilities:

• Designed, developed and maintained Cerner Health Facts web application using Java Servlets
• Developed data access object with ODBC, JDBC and Oracle PL SQL
• Implementation of the code from JSF to struts framework
• Unit tested the application code
• Fixed and resolved code defects in the application
• Wrote technical design documentation

Environment: Oracle 8i, RAD, Java, Struts1.1, JSF, Solaris, Windows XP.