Summary

• IBM Cognos Certified Professional Reports Designer BI Data warehouses with more than 8 years of IT consulting experience in designing , developing and deploying BI and data warehousing applications
• Experience in working on full Enterprise Datawarehouse Implementation with good exposure to data modeling , design and build Metadata layer, Analysis and Dashboard using Cognos
• Excellent in ETL/BI tools Informatica , Cognos Data Manager ,SSIS ,Data Stage 7.1r ,Cognos 8.x BI Suite, Cognos TM1
• Experience in Data Integration for JDE ERP ,Data Governance , Data Migration , Data Quality and Data Synchronization
• Expert in Dimensional Modeling, complex report development in Report Studio with cascading prompts, Complex queries, charts, etc. , Ad-hoc reporting in Query Studio, Scheduling and bursting
• Experience in Oracle 9i PL/SQL programming, SQL Server 7.0/2000/2008 databases
• Provided extensive End User Training and Support
• Effective communications/presentation skills for technical and non-technical audiences
• Team Player, effective under pressure, creative , strong desire to keep up with latest technologies

Professional Experience :

Responsibilities:

• Built complex Cognos reports using Cognos 8 and Cognos 10 suites.
• Responsible for Cognos Administration , estimation , development , defining test cases and deployment of BI Packages/Reports in multiple environment
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Developed Models in Framework Manager both Relational and Dimensional
• Created cubes in Transformer using Framework Manager IQD's, packages and reportstudio reports as a source
• Performance tuning the by analyzing and comparing the turn around times of Diff SQLs
• Implementation and design of Datamarts , Framework Manger and Reports/Dashboards with HTML/Java Script MDX Functions.
• Implementation of an internal application of L T Infotech Life Knowbots on SSIS SSRS

Environment:

Oracle Data Integrator

Cognos 8/10 Suite Analysis Studio, Report Studio, Framework Manager,Transformer , MS SQL Server, Oracle 9i , JDE- World, JDE-E1

Confidential

Responsibilities:

• Worked with business analyst and users to analyze requirements and business rules
• Performed Cognos user training on Framework Manger and Report Studio.
• Created and maintained Cognos jobs with Framework Manger and Reports/Dashboards.
• Created, supported Cognos Transformer models and cubes to support timely sales operations.
• Performed Cognos administration such as creating user accounts, user classes and roles using
• Abstract the complexity of existing system into manageable BI/DW model
• Creation of Physical and logical data model for Datamarts.
• Implementation and design of Datamarts with DataStage

Environment:

IBM DataStage Sever Edition 7.1r

Cognos 8 Suite Analysis Studio, Report Studio, Framework Manager , MS SQL Server, Oracle 9i , JDE- World, JDE-E1

Confidential

Responsibilities:

• Responsible for handling ETL team from requirement gathering part to design and development of data Marts
• Responsible for logical designing of mart using DB Designer
• Automate manual manipulation of the data done by users using ETL - Data Manager
• Design Data Marts Data Manager to deliver data to Cognos planning system for retail team
• Design Data specification templates for documentation
• Create functional specification based on the discussion with multiple functional teams
• Developed Cubes in TM1 Transformer , implemented Processes in Cognos TM1 Trubointegrator
• Business Rule and Process turbo Integrator TI implementation
• Import the data from ODBC and Text files using TM1 Turbo integrator.
• Created reporting and dashboards with IBM Cognos BI and multidimensionnal TM1 cubes
• Performance tuning of various queries and understanding the need of indexes

Environment:

Cognos 8 Data Manager

Cognos 8 Suite Analysis Studio, Report Studio, Framework Manager , MS SQL Server, Oracle 9i , JDE- World, JDE-E1

Confidential

Responsibilities:

Enterprise Data Warehousing EDW :

• Responsible for development and implementation of Data warehouse where in all the necessary marts building from scratch as well as maintaining the existing ones using Informatica Power Center 8.1
• Responsible for developing various mapping History Loads as well as ongoing loads for different business units , transformations and mapplets for migration of data using Informatica Power Center 8.1
• Created ETL Specification for all the mappings after discussing requirements with the team of business users
• Responsible for logical designing of the mapping
• Involved in performance tuning of various mappings with other team members
• Developed support documentation for user workshops
• Implementation to convert Impromptu reporting to Report Studio / Analysis Studio reports

Global Acquisitions/Integrations:

• Design and Developed an ETL/Business process to incorporate acquisitions in the GIS marts for sales reporting using Cognos ETL Tool Cognos 8 - Data Manger
• Designed templates for the Integrations for acquired sites to submit their data to GIS marts
• Worked on prominent Global Integrations with Invitrogen like BioSource, Cascade, Dynal, etc
• Mapping of Customers and SKUs from sales data of the acquired sites to Invitrogen GIS standards

Special Business Projects:

• Worked on various special projects to improve existing data marts and reporting performance for the Sales/Finance/Marketing teams
• Worked as a BA and also developed various Transformer cubes/reports.

E1-GIS Implementation:

• Analyzed the mappings/Builds of the sales data in the Existing data marts and re-mapped the new tables to create new data marts using Cognos 8 - Data Manger
• Worked as a Business Analyst in the ERP update project from JDE World to E1 specializing on GIS end-user reporting and ETL modifications Cognos 8 - Data Manger
• Worked extensively in developing and accommodating new data marts
• Analyzed and developed various logics to implement the changes in the business process

APAC Cognos 8 Implementation:

• Worked with Cognos 8 team to implement reporting in for the Asia Pacific Region
• Created Framework Manager models for Global and APAC regional marts
• Worked extensively in Dimensional modeling in Cognos 8 to deploy cubes in Analysis Studio

Environment:

Informatica Power Center 8.1 , Cognos 8 Data Manager

Cognos 8 Suite Analysis Studio, Report Studio, Framework Manager , Cognos Series 7.3/7.4 Impromptu, PowerPlay, Transformer, Access Manager, Upfront , MS SQL Server, Oracle 9i, JDE- World, JDE-E1, Toad, Cognos Decision Stream / Data Manager, Informatica, MS Visio / Project

Confidential

Responsibilities:

• Identified the relationships and cardinality for the new tables to create impromptu catalogs
• Created Transformer model using IQDs to create a multidimensional cube with manual categories for time dimension, adhering to requirements
• Created an array of PowerPlay, PowerPlay for Excel reports per requirements
• Developed a Framework Manager model in ReportNet for the same, creating a business view with shortcuts, model query subjects, calculations, embedded filters etc.
• Performed troubleshooting for a wide range of issues in the migration process

Environment: Cognos Series 7.3 Impromptu, PowerPlay, Transformer, Access Manager, Upfront ,

ReportNet 1.1, IBM AS/400, Visual Elk 8.1/9.2, Windows NT

Responsibilities:

• Improved the usability of the reports by creating both report level and catalog level prompts
• Developed Business Mix Reports, Financial Reports using PowerPlay
• Worked in a team to build Multidimensional Cubes from the Data marts
• Using PowerPlay for Excel, generated reports by connecting to cubes through Excel and performed complex calculations in formatting the reports
• Deployed cubes using PPES and published OLAP reports using Upfront Server

Environment: Cognos Series 7.1, Power Play Enterprise Server, IWR, SQL Server 2000