SUMMARY:

• Over 6 years’ experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, and Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Finance, Insurance, Networking and Manufacturing.
• Proven experience at building, motivating and working under professional teams and supporting client relationships.
• Experienced in implementing large - scale applications with leading technologies in Business Intelligence and involved in complete software development life cycle (SDLC).
• Handling complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management.
• Very Good experience on Cognos Tools - Cognos 10 Suite (Framework Manager, Cognos Cube Designer, Report Studio, Analysis Studio, Workspace Advanced, Event Studio and Cognos Connection), Cognos 8.4 (framework Manager, Report Studio, Metric Studio, Power Play Studio and Query Studio), Cognos Report net 1.1 Mr3, Cognos EP Series 7.3(Impromptu, IWR, Power Play Transformer and Power Play Windows/Web, upfront).
• Experience in reports migration from Cognos impromptu 7.3, Cognos 8 and Business Objects to Cognos 10.2.1.
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Sound Skills in Report Development, Modeling (Relational, DMR) in Cognos 8.
• Sound Skills on Developing Score Card Applications using Metric Manger and Metric Studio.
• Worked on Dash Board Report building using Report Studio.
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications.
• Expert in creating List, Crosstab, Drill through Reports, reports with cascading prompts, filters, and calculations using Cognos.
• Good understanding of ETL tools like Data Stage on of Cognos reports, cubes, and decision support applications using Cognos series 8 business intelligence tools.
• Experience in Troubleshooting Cognos problems and tunes for performance.
• Extensive experience in Multiple Relational Databases including SQL SERVER and ORACLE.
• Experience with Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers.
• Experience in Administering the Servers - Installation, configuration, roles, Privileges and Performance Tuning of the Servers.
• Expertise in OLTP/OLAP/OOAD System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Excellent Presentation and communication skills, Team Player, Quick learner, Organized and self-motivated. Enthusiastic to learn new systems and technologies and fast adaptability to new platforms and environment.

TECHNICAL SKILLS:

Reporting Tools: CognosBI Tools including Report Studio,Query Studio, Analysis Studio, Metric Studio,Cognos7.1/7.3EP series,CognosGO(Search, Office, Dashboard), CognosCAF, Crystal Reports, Power Analyzer 7.1

Data Management Tool: CognosArchitect7.x,CognosFrameworkManager.ETL Tools Informatica, Data Stage

Operating Systems: Windows, XP, UNIX

Data Modeling Tools: RDBMS/DBMS D DB2, Oracle 8i, 9i, 10g, PL/SQL, DB2 MS Access, TOAD for MySQL

Web Servers and Application server: Java Web Server, IIS 4.0/5.0, Apache Web Server, Tomcat 4.01

Programming Tools: C, C++SQL, PL/SQL

Programming Languages: HTML, XML, JAVA

PROFESSIONAL EXPERIENCE:

Confidential - San Francisco, CA

Sr. Cognos Developer

Responsibilities:

• Installation and configuration of Cognos 10.2, 10.1.1 in both Non Prod and Prod environments.
• Analyzed the business requirements and developed models using Cognos framework manager & Adaptive warehouse and published packages for reports development. Installed client tools for developers.
• Widely used Report Studio to create various types of reports like List, Cross tab, Chart, Sectioning, Drill through, Drill up/down, Master detail etc.
• Developed Standard Reports, Charts, and Drill through Reports and Burst Reports Using Report Studio.
• Generation of reports using Conditional Styles, Conditional Blocks, Render Variables.
• Bursted and Scheduled the reports according to the user requirement.
• Migrate ETL code from Environment to Environment and validate the changes.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Created source to target mapping documents for both Cognos 8.4 and also for Cognos 10.1.1 applications.
• Created few Active Reports and demonstrated Active Report functionality to users.
• Trained business users in query studio and report studio, suggested business users how their information can be effectively displayed by using different graphs and charts in Dashboards. (Conveying information they need concisely).
• Responsible for upgrading reports from Cognos 8.4 to Cognos10in (Dev, UAT, QA) and Production environments and validated using life cycle manager.
• Maintain AW and Framework model's to support for Reporting application in both Cognos 8.4 and Cognos 10.1.1.
• Troubleshooting data related issues in the reports.
• Worked on Cognos Security to restrict the users and created different Group's / Roles and assign the user's to specific Groups.
• Renewed cognos related cryptographic keys in both Cognos 8.4 and 10.1.1 applications.
• Renewed SSL/Webserver s for accessing the Cognos application.
• Involved in resolving many critical production related issues.
• Customized Cognos Connection Portal to personalize the homepage.
• Provided access to users from data perspective and add the user security to have access to the Orgs.
• Performed monthly maintenance activities like refreshing data, loading new data into tables and also used to deliver the reports to users according to the requirement.
• Unit Tested the Reports and verified the report output's with business requirements.
• Worked on all Production issues and incidents related to the reports/data.
• Provide support to all Cognos issues and maintain knowledge on all new techniques and prepare reports for all warehouse functions.

Environment: Cognos 10.2, 10.1.1 and Cognos 8.4 (Adaptive warehouse, Adaptive Analytics, Framework Manager, Report Studio, Query Studio, Business Insight, Business Insight Advanced), Oracle 11g, Windows 2003 and windows 2008 servers.

Confidential - Irving, TX

Cognos Developer

Responsibilities:

• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager
• Developed Models and packages according to the business users' specifications.
• Developed customized packages to be used by the query studio users, as per the business specifications
• Enhanced the existing models and reports for better representation, better formatting, performance and new requirements to end users.
• Implemented Row Level security using predefined Peoplesoft tables in framework model.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, conditional formatting, Filters, multi - page, multi-query reports to meet the business user requirements while increasing the accuracy and amount of data presented.
• Experience in distributing reports using bursting, email, scheduling.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos
• Creating User Classes and restricted the user access with the help of User Class Privileges.
• Created the documentation for all the developments and Installations.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Involved in the end user sessions on Query studio, and Cognos Connection.

Environment: Cognos 8.3 BI, Series 8 Framework Manager, Report Studio, Query Studio, Analysis Studio, Oracle 9i, TOAD, Windows 2003 Server, Windows 2000 Server, IIS, Active Directory Server

Confidential - Hartford, CT

Cognos Developer

Responsibilities:

• Designed meta model in Framework Manager 10.1by Creating database layer and business layer, defining appropriate relationship between query subjects in Framework Manager and then deployed packages into Cognos connection portal.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Designed and maintained Qlikview applications.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager. Model.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query in Cognos 10.1/8.4 Report Studio.
• Involved in Bursting Reports against database.
• Worked on creating advanced Tableau dashboard, using Intermediate MSBI Tabular models.
• Created custom templates and custom tool boxes for the use of reporting.
• Involved in creating cubes using Transformer and experience with analysis studio to analyze the cubes.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Moved Packages and reports from development to QA and then Production servers
• Deployed the cube from Testing Environment to Production Environment using Batch script.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved into move to Deployment to UAT and Production.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Involved in writing Stored Procedures and functions in Oracle PLSQL.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Cognos 10.1/8.4 BI, Oracle 11g, DB2 0, Framework Manager, Report Studio 1Transformer, Analysis Studio, Cognos XML, Generic/Cognos JavaScript, BATCH SCRIPT.

Confidential

BI Programming Analyst

Responsibilities:

• Gathered and understand business requirements and translate into IT solutions with the use of Cognos.
• Developed rapid-prototype or proof-of-concept reporting solutions and demonstrating those solutions to business users to make them familiar with all capabilities of the IBM Cognos product suite.
• Upgraded the existing packages and reports from Cognos 8.3 to Cognos 8.4 and developed new reports and build new frame work models in Cognos 8.4.
• Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location
• Architected solutions for budgeting and planning applications using tools TM1, Cognos Enterprise planning and Cognos BI
• Created multidimensional models from various data sources and then distributed as Cognos cubes with security using TM1 and Cognos Transformer
• Designed automated solutions for creating Cognos Cubes using macros and batch files.
• Generated SQL/MDX and analyzed Cognos SQL, Native SQL to trouble shoot the report issues and Developed reports in Reports studio using MDX functions.
• Engineered and expanded existing IBM Cognos BI model for capturing financial drivers and Metrics.
• Built original tool set in Microsoft Excel and PowerPoint, then rebuilt system using IBM Cognos Planning and BI tools.

Environment: Erwin, Oracle Designer, Oracle Warehouse Builder, Oracle 9i, Informatica, SQL, Java, Jscript, and IBM Cognos OLAP/BI Tools 8.X (Enterprise Planning, Controller, Analyzer, TM1, Framework Manager, Report Studio, Metric Studio and Cognos Connection), Cognos 7.x (Power Play, Transformer), Power Play Enterprise Server, Windows Server.