SUMMARY:

• Over 9 years of experience in software development wif specialization in Data Warehousing, System design, Maintenance, Quality Assurance.
• IBM certitied Cognos BI author wif over 8 years of hands - on experience wif the Cognos Reportnet suite (Framework Manager, Cognos Connection, Report Studio, and Query Studio) on Windows, UNIX as both a developer
• Sound noledge and experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production
• Results-oriented data warehouse expertise wif Fortune 500 global deployments including diverse domain noledge in Healthcare, Pharmacy, Insurance, Automobile, and Telecom.
• Strong understanding of relational database design concepts and in depth noledge of Cognos 8, Cognos Reportnet, OLAP solutions, Cognos Impromptu, Transformer, Power Play, Cognos Script Editor, IWR, Cognos Query, Cognos Upfront, Cognos Architecture, Cognos Security.
• TEMPHas a very good expertise wif Cognos BI Server administration, Access Manager, LDAP integration, Active Directories and System/User Security.
• Expertise in building and creating Namespaces, Query Subjects, Calculated Fields, Filters, Joins, Packages and design and development of Enterprise Planning (EP) application.
• Strong working experience on Ascential Data Stage, SQL, PL/SQL, Stored Procedures and Triggers. Performed Debugging, Troubleshooting and performance Tuning.
• Managed developing new data sources using Cognos portal, configuring and testing data source connections and publishing data sources to Cognos 8.x to be accessed by Report Studio, Analysis Studio and Query Studio along wif Dashboard, Scorecard analysis.
• Experience in designing models wif Framework Manager involving Relational Models and Dimensional models.
• Experience in Security Implementation in Cognos8, Reportnet, on various levels such as User level, Object Level, Row Level Security Implementation.
• Developed OLAP applications using Cognos suite of tools and extracted data from the enterprise data warehouse to support the analytical and reporting for all Corporate Business Units.
• Ability to meet deadlines and handle multiple tasks, decisive wif strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS:

Business Intelligence Tools: Cognos 8 BI (Framework Manager, PowerPlay Transformer, Analysis Studio, Report Studio, Query Studio, Event Studio, Metrics Studio, SDK), Cognos ReportNet v.1.1. MR2 (Framework Manager, PowerPlay Transformer, Report Studio, Query Studio, SDK), Cognos Series7 v.7.3.MR3 (PowerPlay Enterprise Server, PowerPlay Transformer, Impromptu, Impromptu Web Reports, Upfront, NoticeCast, Visualizer, Cognos Query, Architect-BI, Metrics Manager, Web Services), Cognos Access Manager

Databases: DB2, Oracle10.x/ 9.x/8.x/7.x/6.x, MS SQL Server 2000/7.0/6.5, Teradata

ETL Tools: IBM Infosphere 8.2, Datastage 8.2/7.5,7.4, Informatica 8.1

Languages/Scripts: SQL, PL/SQL, C, C++, Oracle 9i/10g

Operating System: Windows XP/2000/ NT/ 98/ 95, MS-DOS, UNIX

Front End: Visual Basic (6.0/5.0), HTML, AJAX

PROFESSIONAL EXPERIENCE:

Confidential, Waukegan, IL

Business Intelligence Consultant

Responsibilities:

• Gathering the Report requirements from the Users to Design the FM Model and developing the Dashboards, and Complex reports.
• Held regular meetings wif business to understand their reporting requirements and gave demos on BI prototypes.
• Involved in developing URS, FRS, System design documents, Unit Test cases and routed them appropriately using Packer Tracker Application.
• Worked on complex Cognos reports dat involves dynamic, prompt displays and data items selections.
• Created complex reports, dashboard reports using Business advance Insight
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports.
• Built BI application on complex data warehousing architecture.
• Created a Framework Manager Models wif calculated columns, filters and Macros from various data source and created packages according to the client requirements.
• Worked on data warehousing architectures such as point in time schemas and work follow systems used by Regulatory and Quality applications.
• Replicated the reports in to Cognos those were previously based on Microsoft Office Access data base.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Coordinating wif Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Coordinated wif the ETL team regarding Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.
• Created Framework models and Published to Cognos Connection so dat Users can query in Query Studio and Report Studio.
• Creation of standard filters, prompts, calculations, and conditions in Framework Manager
• Imported Cubes into Framework Manager and published them as packages to Cognos connection for analysis in Analysis Studio.
• 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.
• Developed a BI application using VBA for Excel to track employee program dat is monitored by leaders of the employee including directors, divisional vice presidents.
• Developed scripts to extract the data from ISO train application to Microsoft VBA Excel for the reports.
• Worked wif Offshore teams to fix issues related to production support

Environment: Cognos 10.1,Cognos 8.3(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Cognos Series 7.5, MS-SQL Server 2008,Microsoft Access 2010, Oracle 11i,10g, Informatica 8.1, Forefront Identity Management (FIM) 2010,VBA Excel

Confidential, Waukegan, IL

Cognos Consultant

Responsibilities:

• Involved in the complete cycle of Project Plan, Design, Development, and Testing, End User and Post Production Maintenance of the system.
• Tested the Report/Cube Performances, Security, Batch Process, Report schedules in the new Cognos 8.3 environment.
• Using Conditional Variables and governing the rendering of the prompts on the prompt page.
• Designed the Dashboards in Report Studio, which encompass disparate Query Subjects, Conditional Formatting and parameters
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio.
• Used Data Manager to maintain Fact and Dimension intergrity.
• Developed financial reports from JD Edwards/Microsoft access data sources.
• Involved in setting up the Security to Cognos FM packages, Folders and Reports in Cognos Connection by granting up Read, Write, Execute and Traverse Permissions based on user requirements.
• Participated in requirements gathering process to bridge gap between user needs and tool functionalities
• Deployed Packages, Folders and Reports from one environment to another.
• Used Data Manager designer specify processing rules set.
• Involved in Upgrade Cognos 8.3 Environment to Cognos 8.4 and Deploying and testing all the Reports.
• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Performed Cognos administrative functions such as creating user accounts, user classes and roles using Access Manager.

Environment: Cognos 8.3(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Data Manager), Cognos Series 7.5 (Impromptu, PowerPlay Transformer and all Server Administration), DB2, MS-SQL Server 2005, Infosphere-Datastage 8.0, Oracle 10g.

Confidential, Wilmington, DE

Cognos BI Senior Developer

Responsibilities:

• Involved in gathering new Business Requirements for end users and also came up wif standard Requirement gathering documents evolved due to the merger of AIG and 21st Century Auto.
• Involved in creating Proof of Concept document for an application.
• Analyzed the present manual reporting system from various data sources and automated by building generic tables using PL/SQL stored procedures.
• Interacted directly wif end-user of 21st century team in West Coast to halp them in better view reports wif more information in terms of Correct Data.
• Built the multi dimensional cubes in PowerPlay Transformer 7.4 to direct them in Analysis Studio 8.3.
• Created relational and dimensional relational data models using Data modeling tool Erwin
• Created the Oracle stored procedures to populate the data in to the generic summary tables.
• Built Multi-platform, server-based ETL engine processes large volumes of data using Decision stream.
• Used Cognos enterprise planning, developing budgets and forecasting future performance wif sophisticated modeling instead of spreadsheets
• Involved in using Teradata utilities Teradata Administrator, SQL Assistant, UNIX scripting, Ascential DataStage, Data Modeling
• Prepared high level summary reports for Sales, Human Resource and Product management departments.
• Built the Dashboards using Cognos 8 and Java Script (html).
• Participate in the QA testing process from test development, test review, test execution and test analysis
• Created Dimensionally Modeled Relational (DMR) models in Framework Manager.
• Worked on Modeling the Metadata in Framework Manager wif various security features and published packages to Cognos Connection Portal.
• Created Complex, multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting..
• Created report against dimensionally modeled relational sources directly in the Teradata Warehouse and online analytical processing (OLAP) sources.
• Used various cube optimization techniques to reduce cube build time in PowerPlay Transformer
• Identified various dimensions and measures required for the generation of a cube.
• Performed Extract-Laod-Transform (ELT) to create datamarts using Oracle Data Integrator.
• Troubleshoot various existing reports dat had issues and Fixed Remedy tickets from production system
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs.
• Linked different projects in the Framework manager to create complex reports which TEMPhas query items for both the projects.
• Use the OLAP tool to “slice and dice” report data for additional analysis using Webfocus managed reporter.
• Created BI application dat leverages Teradata’s high-performance normalized models
• Created Cognos multidimensional cubes for users to be able to get business information from Cognos Power Play.
• Developed and modified Power Play reports and graphs wif different layouts according user requirements.
• Developed various types of reports such as list report, cross-tab report, dashboard reports and drill through dat cover the entire range of enterprise reporting requirements using Report Studio and distributed it to end users.

Environment: Cognos 8.4, Power Play 7.4, Power Play Transformer 7.4, Windows NT, Decision Stream, Oracle 10g, Framework manager, SQL Server 2005, Erwin 7, MS Visio Datastage 7.5, Toad 8, Teradata 12, Micro-Strategy 8,Webfocus(Developer studio, managed reporter, and Report caster),Teradata11,Peoplesoft,Oracle Data Integarator .

Confidential, Detroit, MI

Cognos Consultant.

Responsibilities:

• Thorough understanding of the data and making some recommendations to change the data structure to suit the business requirements of cubes and reports.
• Came up wif standards for naming conventions of reports, packages, cubes, transformer models etc.
• Built Framework Manager Models/ packages based on data warehousing best practices, so dat it could be compatible for reports.
• Involved in creating Unit Test Plans and tan debugging and testing the jobs.
• Worked extensively on different types of stages like Sequential file, Lookup File set, ODBC Stage, and several other stages for developing Parallel Jobs.
• Involved in the implementation of UNIX shell scripts to process the Flat Files and to invoke the Datastage jobs.
• Secure Organization data by setting access permission like Read, Write, Execute, and Set Policy using Cognos BI series 8.
• Created Business view using the namespaces, folders and segments in the project.
• Developing Standard Reports, list, cross tab, charts, drill-through Reports by using Report Studio, Query Studio and also delivered reports in different formats like PDF, XML, HTML and CSV.
• Experience in Coordinating wif the team members for meeting the project deadlines.
• Involved in the implementation of UNIX shell scripts to invoke the Datastage jobs.
• Prepared reports and presentations for weekly management meeting to update senior Ministry staff on project deliverables, progression and timelines.
• Trained team members wif project noledge and business processes

Environment: Cognos 8.2, Power Play 7.3, Power Play Transformation Server Version 7.3, Windows NT, Oracle 9i, DB2, Framework manager, Access Manager, Upfront, UNIX, Data Stage 7.5.1,Data manager, Decision Stream.

Confidential, Charlotte, NC

Cognos BI Consultant

Responsibilities:

• Worked on 6 different projects dat involved requirement gathering, creating project plans, managing project, creating Power Play OLAP Cubes, Multidimensional Power Play Reports, Reportnet Framework Manager Packages, List, crosstab reports using Report QL, Datastage.
• Implemented Cognos 8, Developed Dimensional Models for Cognos 8 Analysis Studios, and Migrated Power Play cubes to Cognos 8.
• Designed multidimensional reports in Cognos 8 Analysis studio
• Built Reportnet packages for many daily and monthly usage reports using Framework Manager 1.1 MR1, MR2 and MR3 for different projects.
• Implemented Security in Reportnet Packages.
• Involved in Cognos Client/Server implementation.
• Scheduled Reportnet Reports to deliver through e-mail in PDF and Excel formats.
• Created Drill Through between Parent (Summary) and Child (Detail) Reportnet Reports.
• Created dimension maps and multidimensional cubes using Impromptu Query Definition in Power Play Transformer.
• Created DMR models in FWM.
• Created many crosstab, ranked, graph and business mix reports by using Power Play 7.3.
• Created many Power Play web views (cross-tab and chart) according to the end users demand.
• Created drill throughs from Power Play Cube to Detailed Reportnet reports.
• Implemented divisional security in Transformer Cube Models by using commands like apex and exclude.
• Migrated Cubes, Power Play Reports from Cognos Series 7 to Cognos 8.
• Created user classes, signons for different users and set security for reports and cubes using Access Manger.
• Give access to the target projects both in Cognos Connection and Upfront.
• Used Cognos DataManager for developing ETL jobs.
• Trained divisional users to use multiple dimensional Power Play reports, cubes and Reportnet Reports through webex and in class rooms.
• Experience in solving complex problems, team coordination and motivation skills as well as the ability to communicate successfully.
• Created guides for different projects to efficiently use Power Play Cubes, reports and Reportnet Reports.

Environment: Cognos 8, Reportnet Version 1.1 MR3, Power Play 7.3, Power Play Transformation Server Version 7.3, Access Manager, Windows NT, Oracle 9i Studio,Framework manager, PowerPlay Transformer, PowerPlay, Access Manager, Upfront, PL/S.

Confidential, Elk grove, IL

Cognos Reportnet Developer

Responsibilities:

• Study the existing CRN environment and draft the Design Document for the Sales Analytics project..
• Revise the Requirement Specifications wif the users for better customer service, accessibility issues and feasibility in CRN.
• Involved in understanding the Business in all Departments wifin AAP.
• Created reports for various departments like HR, Sales, and Production etc.
• Logging Support cases wif Cognos and follow-ups.
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Developed procedures, functions and database triggers using wif PL/SQL.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security, using LDAP. Implemented and administered different levels of security and report bursting, using Cognos Reportnet, Access Manager.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Assisted in Cognos migration projects: From Impromptu 7.3 (Catalogs) to Reportnet 1.1 MR2.
• Involved in administration, development and support of existing & new (20+) Catalogs and query definition files using various joins and filtering conditions using Impromptu administrator.
• 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.
• Built Power Play Reports based on these cubes and published to Reportnet Server.
• Provided technical support and administration for the existing Cognos Power Play Cubes.
• Developed numerous drill-through Power Play and Reportnet reports.
• Published IWR reports and Power Play cubes on the portal using Cognos IWR report administrator and Power Play Enterprise Server.
• Involved in intensive end user (both Managers and business users in Report studio and Query studio) wif excellent documentation support.
• Assisted in deploying the Cognos Reportnet Reports through their Reporting Portal.

Environment: Cognos Reportnet1.1 MR2 (Framework Manager, Report Studio and Query Studio), Power Play 7.3, Transformer 7.3, Power Play Enterprise Server 7.3, Impromptu 7.3, Oracle 9i (SQL, PL/SQL), Win 2K Server.