SUMMARY

• An analytical self - starter with over Ten years of experience, seeking a challenging position as a Developer/Business Systems Analyst in field of Business Intelligence (Cognos 11, Cognos 10, Cognos8.4, Cognos Report Net and Power play, Tableau 10.3, Tableau 10.5).
• 13+ years of IT experience in development, testing, documentation and maintenance.
• 11+ years of hands on experience in Cognos tools including Cognos 11, Cognos 10, Cognos 8, Impromptu, Impromptu Web Reports (IWR), Power Play, Transformer, Upfront, Power Play Enterprise Server (PPES), Access Manager, Cognos Report Net, Scheduler, Visualizer, Cognos Server Administration, and Cognos Decision Stream and also worked as an Analyst to interact with the ETL teams.
• Created and managed reports in Zero-footprint environment using Report Net
• Built and published packages in Framework Manager.
• Migrated Impromptu catalog to Report net using Report net Migration utility
• Designed and optimized catalog(s) to maximize performance.
• Created Business Mix Reports using Cognos Impromptu and Cognos Power play.
• Developed OLAP solutions using Power play published Reports using PPES.
• Implemented security for Cognos applications using Access Manager
• Automated Reports and generated Documents using Scheduler
• Installed and Configured Cognos tools for various requirements

TECHNICAL SKILLS

BI Tools: Cognos 10.1.1, Cognos 10.2.1, Cognos 10.2.2, Cognos 8.4/8.3/8.2 (Framework Manager, Analysis Studio, Report and Query Studio, Event studio), Tableau 10.3 and Tableau 10.5, Report Net 1.1 (Framework Manager, Report and Query Studio)Cognos 7.0/7.3 (Impromptu, Power Play, Transformer, Access Manager, Scheduler, IWR, PPES).

Databases: Oracle 10g/9i/8i/7.x, SQL server2000, UDB-DB2, and MS Access

Web Servers: Sun One 5.2, Microsoft Internet Information Server (IIS) 4.0/3.0, Netscape Directory Server

Programming skills: C, C++, HTML, Visual basic, SQL, Pro*C, CAD-CAM

Microsoft Tools: MS Excel, Word, Visio, PowerPoint and Access

Operating Systems: Windows NT/2000, Sun Solaris

Applications: Clarity Application

Others: Adobe Acrobat suite, Macromedia Flash, Photoshop, Crystal Reports, Toad.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Systems Analyst/Sr. Cognos Developer

Responsibilities:

• Worked in a team to convert the OLTP Model to a Star Schema (Kimball) model in order to enhance the reports with more capabilities like creating Trending Reports in Cognos.
• Analyzed the current model & data to transform it in to new tables (Star Schema) for the advanced report authoring purposes.
• Lead the team of developers to convert the Flat file source data to Oracle mart and subsequently to be used for the reporting purposes.
• Extensively used Cognos Framework Manager to create new model from scratch to support the existing reports as well as the new reports that are being created.
• Worked with ETL team to design the star schema model that involves Type 2 slowly changing dimensions.
• Worked with Framework manager to create the underlying layers and integrated with the existing business layer to reduce the effort of rewriting the existing reports in Cognos.
• Worked on migrating the Cognos 10.2.1 reports and packages to Cognos Analytics (Cognos 11.0.6 and eventually to Cognos 11.0.10.0)
• Created Analytical Report using Tableau 10.3 with the dimensional data.
• Successfully integrated and implemented Motio Ci and Motio PI versioning tool with Cognos 10.
• Created schedules for the scorecards and dashboards using Cognos Event Studio.
• Created and implemented the SQL Scripts for monitoring the load process of the tables during the migration process.
• Created Materialized views to source the dashboard reports to fine tune the performance.
• Implemented the Report Reference feature in the Cognos Report studio to reduce the redundant report creation.
• Extensively used conditional formatting in the reports to enhance the features of show/hide data items in Report Studio.
• Involved in the discussion with business to identify the requirements and provide the scope of the reporting capabilities of the Cognos Suite.
• Worked with the administration team to migrate the reports, packages across the environments using default migration method as well as using Motio CI migration tool.
• Worked extensively in creating portal tabs for the business users to create place holder for all the reports that are implemented.
• Involved in Analysis of the data (issues) during the migration of the data from OLTP to Kimball Process creating unit testing SQL queries.
• Worked extensively in gathering Requirements, design sessions, development efforts during development phase and coordinated with the QA/UAT teams during testing phase of the project.

Environment: s worked: Cognos EP 11.0.10/ 10.2.2/10.2.1/8.4 (Framework Manager, Analysis Studio, Report and Query Studio, Access Manager, Map Manager) Oracle 11g,Oracle 10g, Windows 2007,MS Access.

Confidential, IL

Sr.Cognos Architect/ Sr Cognos Developer

Responsibilities:

• Involved in the requirement gathering for the new reports and dashboards to be developed.
• Worked in setting Cognos environment (Architecture) for the department and Implemented Report Studio for transactional reports and Cognos Power play cubes and transformer for the Dimensional and Analytical Reports.
• Worked as a Reporting Architect to Identify and set up the Cognos 10.2.2 and Tableau 10.3 versions for the Relational data sources and Dimensional Data sources respectively.
• Working in a validated environment, completed creating new dashboard and migrated to higher environment for UAT.
• Required to create Functional Requirement document by analyzing the existing reports (SQL) in Business Objects to be converted to Cognos 10.2.2

Environment: s worked: Cognos EP 10.2.2 (Framework Manager, Report and Query Studio) Teradata 14.10, Windows 2007, MS Access.

Confidential, NJ

Sr.Cognos Developer/ Sr.BSA

Responsibilities:

• Worked with End Users to support the existing reports and create new reports on request.
• Created the security for the reports and migrated reports and packages across environments. Also involved in creation of the data sources and maintenance.
• Worked with the reports with complicated Java scripts to provide the user desired reports pages and Prompt pages.
• Worked with the Cognos 10 sandbox environment to explore the new features of the tool and enhance the migrated reports and dashboards.
• Involved in upgrading the reports from Cognos 8.4 to Cognos 10.1.1 and subsequently to Cognos 10.2.2.
• Created Dashboards Using Report Studio, Analysis studio, Query studio and Transformer.
• Worked as Analyst to work with Business team to generate requirements and also created requirement documents for the data movement to the data warehouse from multiple sources..
• Worked with reporting tool called ‘Spotfire’ to create Slice & Dice Dashboards (Dimensional) for the users.
• Worked with Framework Manager to create Optimized Model for transactional reports.
• Worked on creating the Materialized views and Indexes to source Dashboard reports to enhance the performance.
• Created the Training/Flash card documentation for the end users for the Cognos Reports and Dashboards.
• Created SQL Queries for the reports, also for the business validation of the reports as a Business systems analyst.

Environment: s worked: Cognos EP 10.2.2/10.2.1/8.4 (Framework Manager, Analysis Studio, Report and Query Studio, Access Manager, Map Manager) Oracle 11g,Oracle 10g, Windows 2007,MS Access.

Confidential, New York, NY

Sr.Cognos Developer/ Sr Systems Analyst

Responsibilities:

• Worked in the Business Team to support the existing reports and create new reports
• Worked with Clarity Application and integrated it with Cognos to create reports out of the Clarity data.
• Worked with administration team to create the complete security set up for the reports.
• Modified the reports with complicated Java scripts and Multiple Queries to improve the performance.
• Worked with admin team to upgrade the reports from Cognos 8.4 to Cognos 10.
• Worked with the Cognos 10 sandbox environment to explore the new features of the tool and enhance the migrated reports and dashboards.
• Created Dashboards Using Report Studio, Analysis studio, Query studio and Transformer.
• Used java scripts in the reports to enhance the Prompt Features.
• Worked with Business users to get the requirements for the modifications of existing reports and create new reports.
• Worked with reporting engine called ‘Axis Compass’ to create Dashboards for the users.
• Worked with Framework Manager to create Optimized Model for creating reports with Application database.
• Analyzed to create a Data warehouse for the Clarity environment reporting, and created sample reports and dashboards from the reporting database instead of Application database.
• Involved in creating the training documentation for the end users for the Cognos Reports.
• Worked with Cognos Administration team in creating data sources, migrating reports and models, involved in setting up the standard procedures and the SLA’s for the requests from the users.

Environment: s worked: Cognos EP 8.4/8.3/8.2 (Framework Manager, Analysis Studio, Report and Query Studio, Data Manager, Access Manager, Map Manager) Oracle 9i,Oracle 10g, Windows 2003,MS Access.

Confidential, Cleveland, OH

Sr. Cognos Developer

Responsibilities:

• Worked with Business Analysts to acquire the requirements for the Development.
• Created relational reports from the Framework models as well as the dimensional reports from the cubes which are used as data sources.
• Used Transformer 8 and created cubes using the existing packages as data sources.
• Created Dashboards for the Executives Using Report Studio and Transformer.
• Used java scripts in the reports to enhance the Prompt Features.
• Worked on Dimensional reporting using Report studio and Cubes

Confidential, VA

Sr. Cognos Consultant /Systems Analyst

Responsibilities:

• Gathered requirements from BSA’s and created System requirements for the developers.
• Used Erwin Modeling tool to reverse engineer the relationships for the data models.
• Used the Existing Erwin models Directly as Data sources in framework manager.
• Successfully used Composite for Cognos to create single data source from multiple databases.
• Used the SQL from the Existing reports to create IDQ’s and used the cubes as data sources to create Dashboards in Cognos 8.
• Used Cognos 8.4 and imported BW cubes to framework to created dashboards.
• Involved in the Development of the New Models in the framework and subsequently reports from the framework.
• Assisted the team with enterprise data warehousing, data marts, and data transformation.
• Created IQD’s manually and used the Cubes as data sources to create Dashboards in Cognos 8 Report studio.
• Created ad hoc reports using Query studio and complex reports using Report Studio in ReportNet. Scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in ReportNet
• Created packages combining data from different data sources using Framework Manager
• Migrated Impromptu catalogs and re-written the entire Impromptu reports to Cognos ReportNet
• Converted the MS Access Queries to Report net reports and cubes.
• Used MS Access to create prototype queries for the Clients and converted those to Cognos adhoc model.
• Generating various reports List Reports, Grouped Reports, Cross tab Reports, Chart Reports, and Drill -Through Reports in Cognos 8.
• Migrated reports from Reportnet 1.x to Cognos 8.2 and subsequently to Cognos 8.4.
• Migrated Impromptu catalogs to Cognos 8 using Migration Utility.
• Used Upgrade Manager Tool to validate the migrated reports in the new environment.
• Resolved major issues like Conditional formatting, JavaScript, Dimensional information in the Queries during the migration from reportnet to Cognos 8.
• Migrated Business Objects Universe to Cognos Framework manager and written reports from the Model.
• Migrated reports from Crystal version to Cognos 8.4.
• Used Java scripts in the reports to automate the refresh process of the reports and used in the enhancement of the prompt pages.
• Used IQD’s files generated in Framework manager in Power play Transformer as Data sources
• Created appropriate manual levels in the Transformer model and Optimized the cube performance and the report response time.

Confidential, Gaithersburg, MD

Sr Cognos developer

Responsibilities:

• Created Cubes and Packages which including Dimensional modeling in Cognos 8.
• Worked extensively with Report studio, Analysis studio and query studio in Cognos 8 to demonstrate the features available for the users.
• Optimized Framework Manager Performance by editing governor settings, selecting appropriate query processing and rollup processing methods and reusing cached data when running reports.
• Migrated the Business Objects universe and reports to Cognos 8.2.
• Involved in creating customized prompt pages using Javascripts as per user requests and also created prototype reports for the users
• Worked with reports involving Drill through from Report studio to Analysis studio and Report studio to Report studio in Cognos 8
• Provided better features in the reports by creating new filters in the Framework Manager Models.
• Created reports to show information analytically using analysis studio.
• Generated metadata model for dashboard reporting by importing metadata from other framework manager models and data sources, and created dashboard reports in report studio.
• Responsible for performance tuning and trouble shooting in the development environment.
• Responsible for the documentation of all the processes and created data dictionary.
• Involved in creating multiple data sources to pull data from different databases to create reports which include sales information as well as Customer Marketing Profile.
• Created IQD’s manually writing SQL.
• Used SAP BW Cubes as data sources in framework Manager and created dimensional models.
• Created reports in Analysis Studio for HR team using Demographical information.

Confidential, Duluth, GA

Sr Cognos developer

Responsibilities:

• Involved in data gathering during the business analysis and planning phase of the project.
• Created ETL Documents and gathered information about the tables in order to generate tables in the Data warehouse.
• Created Cubes and Packages which include Dimensional modeling in Cognos 8.
• Worked with the existing cubes and modified according to the User requests.
• Involved in the Migration of Cognos Reportnet reports to Cognos 8.2 and used Upgrade Manager for the Validation.
• Migrated Crystal reports to Cognos 8.2
• Created IQD’s using framework manager to be used in the cubes which are used as Offline sources for the technicians on the field.
• Created IQD’s manually writing the SQL and used them as the data sources.
• Involved in creating multiple data sources to pull data from different databases to create reports which include sales information as well as Customer Marketing Profile.
• Assisted in working with multiple interfaces to created Inventory and sales order entry through Microsoft CRM.
• Had Exposure to Decision Stream as It was one of the ETL tool used.

Confidential, Atlanta GA

Cognos Developer / Business Analyst

Responsibilities:

• Involved in the entire report project life cycle from Assessment, development and Production support of end user reports.
• Customized end-users Cognos Connection with appropriate reports and security measures.
• Used Framework Manager to create data packages combining data from a number of data sources.
• Modeled Metadata using Framework Manager for end user keeping in mind Entity Relationship Model.
• Re-written and Migrated Impromptu reports, Report net Reports to Cognos 8.
• Used Migration Metadata Utility for migrating impromptu Packages to Cognos 8.
• Analyzed and re-written the web-Focus reports using Cognos 8
• Created BI reports using Report Studio and performed ad-hoc queries using Query Studio.
• Performed scheduling and maintenance of reports using Cognos Connection.
• Implemented Drill-Through to provide users with more detailed information.
• Participated in meetings with the user to validate the results of the development, during various stages of report development and before deployment.
• Re-written Access Database queries in Cognos 8 and developed reports based on it.
• Created and used unions and joins on queries to display desired result into the report.
• Extensively used Cognos Financial to understand the financial performance, cash flow, vendor relationships, and more.
• Generated various Crosstab reports, Pie Chart, Bar Graph in Report Studio.
• Involved in writing the reports by writing the SQL behind.

Environment: Cognos EP Series 7.0/7.3 (ReportNet 1.1, Framework Manager, Impromptu, PowerPlay, Transformer, Access Manager, IWR, Upfront, Architect), Cognos 8.0 (Framework Manager, Analysis Studio, Report and Query Studio, Cognos Financial) Oracle 8i, Windows 2000.

Confidential, Portland, Oregon

Cognos Reportnet Developer/Analyst

Responsibilities:

• Develop and design technical specifications and developed test plans.
• Involved in bug resolution and enhancements of existing solutions and ensuring that servers/services are functioning properly.
• Involved in building data dictionaries, cubes, and reports in Cognos..
• Created and managed projects in Framework Manager.
• Created packages combining data from different data sources using Framework Manager
• Migrated Impromptu catalogs and re-written the entire Impromptu reports to Cognos ReportNet
• Involved in scheduling reports and sending reports via email to several business users.
• Used Impromptu Query Definition files generated in Framework manager in Power play Transformer as Data sources
• Created appropriate manual levels in the Transformer model
• Optimized the cube performance and the report response time

Environment: Cognos ReportNet 1.1(Framework Manager, Report Studio, Cognos Connection, COGNOS Configuration), COGNOS PowerPlay Transformer 7.3, UDBDB2 and Windows 2000.

Confidential, Marietta, GA

Cognos Developer/Analyst

Responsibilities:

• Created and published Packages by importing meta data using Framework Manager
• Package creation involved Data source query subjects, Model query subjects and stored procedure query subjects.
• Involved in bursting and scheduling of reports.
• Generated various reports including List, Grouped, Cross tab, Chart and Drill -Through Reports.
• Used various filter options while generating reports and used conditional formatting.
• Creating Public Folders, Private Folders, My pages and custom views in Cognos Connection.
• Scheduled, Distributed and Administered Reports.
• Involved in setting up Groups/Roles to secure the Models and packages.
• Designed Power Cubes with appropriate alternate drill down paths and dimensions to enable slicing and dicing to explore data comprehensively.
• Created reports to drill through from PowerPlay to ReportNet.
• Created multidimensional cubes with appropriate dimensions, manual levels and categories from Impromptu Query Definition files in PowerPlay Transformer.
• Optimized cube performance by partitioning and caching.
• Extensively used different types of prompts, conditional highlighting, formatting, and calculations to develop meaningful and user friendly reports, pertinent to the business requirements.

Environment: Cognos ReportNet 1.1(Framework Manager, Report Studio, Cognos Connection, COGNOS Configuration).

Confidential, Hartford, CT

COGNOS Developer

Responsibilities:

• Involved in data gathering during the business analysis and planning phase of the project.
• Created Impromptu catalog and hotfiles in order to generate reports.
• Extensively used cascading prompts, drill-through, sub-reports, and summaries, conditional formats, grouping features of Impromptu to generate efficient and user-friendly reports.
• Published Impromptu reports using Impromptu Web Reports server to Upfront Web Portal.
• Modified already created Impromptu Catalogs to reflect changes in the business.
• Worked on Auditing for Impromptu Web Reports to keep track of the reports.
• Provided better search features in the reports by creating new filters in the catalog.
• Created multidimensional cubes using appropriate dimensions and manual levels and categories from Impromptu Query Definition files in Power Play Transformer.
• Implemented drill-through from Powerplay cubes to Impromptu reports.
• Created Trend over Time Reports and Forecast Reports using Power Play.

Environment: COGNOS Impromptu 7.0 COGNOS Power Play Transformer 7.0, COGNOS Visualizer, SQL, PL/SQL, Windows 2000, Terminal server, Oracle 8i, MS Excel.