SUMMARY

• 7 Years of IT experience in analysis, design, development and implementation of Client/Server, Data Warehouse/Data Mart and Business Intelligence using Oracle, MS SQL Server as backend on Windows XP and UNIX, AIX Platforms.
• Experience in Software Development Life Cycle (SDLC), Data Requirement Analysis, Design, Development, Testing, Documenting and Implementation of Business Applications.
• Experience with BI Tool Cognos 10.x, 8.x (Framework Manger, Cognos Connection, Report Studio, Query Studio, Analysis Studio), ReportNet 1.1, Cognos EP Series 7.x (Impromptu Web Reports, Power Play Transformer, Power Play, Enterprise Server (PPES)).
• Expertise in data Modeling with Framework Manager - Importing the sources and establishing relationships and implementing layers concept.
• Experience in building Complex Reports to customize the functionality in prompt pages, Master detail Relationships, Drill troughs, Customized Prompts and Conditional Formatting in Report pages using Report Studio.
• Involved in testing couple of use case using TM1 tools Architect, Perspective, Web and Turbo Integrator.
• Experience on Transformer Models for building Multidimensional Cubes.
• Strong knowledge and understanding in Data warehouse and Data Mart Architecture, OLTP/OLAP study and analysis, with Sound knowledge in Snow Flake and Star Schema.
• Excellent Working knowledge with Property Insurance, Financial, Telecommunications and pharmaceutical Industries in the business process and their inter dependencies.
• Experience in Production/Customer Support, Deployment, Development and Integration.
• Experience in Migration of Cubes, Reports and Packages.
• Excellent communication and interpersonal skills with Strong experience in client interaction and understand business application, data flow and data relations.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows XP, AIX

RDBMS: Oracle 11g, 10g/9i/7.3, SQL Server, MS Access

Languages: SQL

Modeling Tools: Erwin 4.0

ETL Tools: Informatica, Data Stage

BI Tools: Cognos 10x, Cognos 8.x Suite, ReportNet, Brio Intelligence 5.0, Business Objects, Qlikview

Planning Tools: Cognos TM1 9.5

PROFESSIONAL EXPERIENCE

Confidential, CT

Sr Cognos Developer

Responsibilities:

• Worked extensively on creating Models using Framework Manager and publishing the packages on Cognos Connection for reporting purposes.
• Created DMR models using Framework Manager.
• Created Dashboards Reports in Report Studio using Dimensional Model (DMR) developed in Framework Manager
• Created filters and prompts with in the Model for improving performance of the Model.
• Troubleshoot the Error Codes in Case Statements and debug from DB
• Analyzed and develop requirements specification documents for reports as per client requirements and planned business Process
• Tested reports in Query Studio for upgrading it to Cognos10.1
• Performed activities such as Cardinality Setups, determinants to avoid redundancy, data validation checks during staging, and data loading, ensure clear query paths by resolving ambiguous relationships (loops)
• Performed Systems Administration activities for Cognos Planning and CognosBI applications
• Solely responsible for DB optimization to show improvements on performance by analysis of relational data by creating aggregate tables at multiple levels within and across hierarchies in the dimension tables using DATA MANAGER
• Created reporting and dashboards with IBM Cognos BI and multidimensional TM1 cubes.
• Schedule reports with different selection scenarios to obtain the runtime and errors.
• Perform Reports Data Validation by comparing Cognos generated SQL using Toad
• Helping technical team to understand and to convert the business needs (BRD) into system requirements by coordinating with the business on a non-technical level, and with the System Analyst on technical level.
• Developing Test scripts to perform business flow testing in UAT environment.
• Coordinate with Data Modelers to review and correct the cardinalities from FactTables to DimensionTables.
• Prepared recommendation reports for calculation, and case statements to move into the framework manager from reports to improve Report performance.

Environment: Cognos10.1 and 8.4 (Report Studio, Workspace advance, Query Studio, Analysis Studio, Framework Manager), PowerPlay, TM1,Transformer, Access Manager, Informatica 9.1, Nateeza, Oracle 11g, Post Gres, DB2, Windows XP.

Confidential, Leesburg, VA

Cognos TM1 Devloper

Responsibilities:

• Analyzed the functionality and Business Requirement and transformed the Functional Design Document into Technical Design Document.
• Built Relational Models for Reporting and DMR for OLAP Style Analysis and Reporting using Multi Layer Approach and Modeling best Practices to meet the reporting requirements.
• Involved in Design and Development of Security Architecture to meet the Business needs.
• Ensured Ambiguous Relationships are resolved and implemented Model enhancement techniques to improve Model Performance.
• Manage TM1 data through TM1 Reports (Active Form & Slice).
• Created and arranged different TM1 rule statements and performed complex calculations for cubes at N&C levels
• Created ad-hoc queries from multidimensional views for analysis.
• Developed Cubes, Reports, and Dashboards using Cognos BI.
• Created Dynamic Reports from Worksheets and Cube views using different functions (DNEXT, DFRST and ELCOMP).
• Worked on replicating the cubes between servers, sharing data between cubes and linking asymmetrical cubes.
• Created ETL (Extraction, Transformation & Loading) processes in TM1 performing business rule mappings of relational data into dimensional model.
• Deployed the TM1 data into production environment.
• Created Model Query Subjects, Data Source Query Subjects, Stand alone and Embedded Filters to implement the Complex business Logic.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Developed Hierarchies and Measures to support Adhoc Reporting, Multi-Dimensional Reporting.
• Developed TM1 application to gather and consolidate data in support of the footnotes in the annual report.
• Worked with SQL server Analysis service (SSAS).Integration (SSIS) and Reporting services (SSRS) for creating ETL solutions/models and reports.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Developed various operational drill-through and drill-down reports using SSRS.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed List, Cross Tab and Chart Reports for different Views of Data.
• Implemented various reporting Techniques like Drill up, Drill down and Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail and secured the Reports and Folders to specific user groups.
• Deployed Packages, Reports to Test Environment using Content Administration.
• Involved in creation of MultiQuery and MultiPage Reports in report Studio.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups.
• Involved in install and configuring Cognos components in Distributed environment.
• Involved in Deployment of Cognos Content from between DEV/QA/UAT/PROD.
• Involved in Customizing Cognos portal and Performance tuning of models/reports.

Environment: Cognos 8.4/8.2 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio),TM1, Powerplay Transformer, Dash Board, Cognos TM1 9.5.2 DB2, Oracle 9i, SQL Server 2000, SSIS,SSAS,SSRS, Cognos Access Manger, AIX, Windows 2003 Server.

Confidential, Plano, TX

Systems Analyst (Cognos Developer)

Responsibilities:

• Interacted with business users to gather business requirements and designed functional and technical requirements documentation.
• Imported data sources from Heterogeneous databases based in SQL Server 2005, DB2 UDB and Oracle.
• Migrated existing Brio Intelligence Reports to Cognos 8.3 Environment.
• Developed models and Reports for various business units such as Business Services/ Sales/ Billing/ Revenue/Credits and Adjustments.
• Used Framework manager to manage metadata for authoring reports.
• Updated FM Models and projects to add the new query subjects as per requirements and implemented security at various levels in Framework Manager.
• Models were used to create packages and publish the packages to the Cognos Connection.
• Created charts, lists, crosstabs, Master-detail, drill through reports for Cycle variance, ILI Back Billing, IP Flexing, Credit -Adjustments projects using Report Studio and ad- hoc reports using Query Studio.
• Customized the reports by applying filters, calculations, conditions, prompts (text box, tree, value, search and result, time, date, interval) and Cascading Prompts in Report Studio.
• Extensively created burst reports in Report Studio as per the User groups.
• Developed dashboards/metrics for higher management and business users to analyze the business.
• Created templates, standard reports and Ad-hoc reports using Query Studio and Report Studio.
• Designed Transformer models by creating dimension maps, levels and measures using Powerplay Transformer.
• Used the Transformer models to create Cubes and generated Powerplay reports.
• Created Special time categories within Transformer models to provide enhanced reporting capabilities.
• Used drill down and drill through functionalities to give a detailed and analytic report using Analysis Studio.
• Scheduled and distributed reports to the end users by schedule management in Cognos connection.
• Provided technical assistance, training and mentoring to Users and Business Partners.

Environment: Cognos 8.3 BI, Brio Intelligence 5.0, Oracle 10g, SQL Server 2005, Toad, SQL plus, Windows XP

Confidential, Deerfield, IL

Cognos developer

Responsibilities:

• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security, using Directory Server.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Used filters for efficient data retrieval.
• Share point reports maintenance and Schedule management for the daily email reports.
• Creation of Power Play models and cubes Using Power play Transformer and Testing the report by comparing data with Cube data by using powerplay web explorer and the validity of the data it retrieves from the database.
• Migrating Powerplay Client HTML reports that are tabular and pivot oriented and convert them to pictorial/dashboard oriented reports for executive management sales.
• Experience with conditional blocks and conditional layouts.
• Creating Dash Board Reports from cube using Report studio MDX Functions and adding it to the portal page using HTML Items.
• Modifying the existing report based upon the change request by the user.
• Customizing Cognos Connection Portal based on user specifications.
• Created business models based on power cubes, published to the portal and created daily, Monthly reports based on published package.
• Generated IQD files in Framework manager and designed Power play models in Transformer as sources of Metric Extracts.
• Developed Metric Extracts in Metric Designer as a Cube Sources.
• Developed Scorecards, Metric Types and Metrics in Metric Studio.
• Loading data into Metric Studio from Cube Sources.
• Deployment of reports from Development to Production.
• Production Support and Troubleshoot/Test issues with existing reports and cubes.
• Migration to the Cognos 8 platform in a distributed environment (reports/cubes/models/IQD’s).
• Interacting with the Cognos support team and creating & following-up the cases in the Cognos support site.

Environment: Cognos 8.2 suite (Framework Manager, Report Studio, Analysis Studio, Query Studio), Power play Transformer, SQL Server 2005, Power play cubes.

Confidential

IT Analyst (Sr. Cognos Developer)

Responsibilities:

• Involved in requirements gathering to understand the business flow and provide better solution.
• Prepare functional & technical design documents.
• Design and develop metadata model in Cognos Framework Manager.
• Creating the cognos reports using Report Studio by adhering to the standards.
• Extensively used prompts, master-detail query relationships, grouping and sorting features of Report Studio to generate efficient and user-friendly reports.
• Production Support of existing dashboards.
• Enhancements and performance improvement of the existing executive dashboards.
• Implemented iframes using JavaScript to improve performance of the dashboards.
• Creating the Unit Test Plans for the deliverable.
• Deployment activities between environments.
• Review of Delivery to ensure adherence to standards.
• Involved in end user training.

Environment: Cognos 8.1, SQL Server 2008, Windows XP

Confidential

Cognos developer

Responsibilities:

• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created standard and Ad hoc reports using Cognos Impromptu designed catalogs and defined User Classes, security and privileges.
• Created User Classes who needed to access the data in the catalog.
• Assigned password to User Classes, assigned various kinds of accesses to Tables and Folders.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality.
• Created Multidimensional reports by implementing Multi Dimensional Cubes using PowerPlay and Transformer.
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and PowerPlay reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Created Impromptu Web Reports and published them on the Web server and later on Upfront.
• Deployed cubes and reports on PowerPlay Enterprise Server and also Published to Upfront.
• Monitored the PowerPlay cubes using PPES.
• Used Access Manager to meet the security requirements of the reports and cubes on the Upfront.
• Troubleshoot Cognos Server Environment for the better performance.

Environment: Cognos EP Series 7, Oracle 8i, Window 2000, Informatica 6.0