PROFESSIONAL PROFILE

• Over 10+ years of experience in Enterprise Data Warehousing, OLAP, and Report Generating Systems.
• Excellent Knowledge in Data Warehousing Concepts.
• Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema,Fact and Dimension tables.
• Involved in the Design, Development and Administration Phases.
• Involved in Implementation and Identifying the New BI Tools for Business Improvements.
• Expert in Business Intelligence Applications using Cognos Tools such as Cognos 8 BI, (Framework manager, Analysis Studio, Powerplay Studio, Report studio, Event Studio ,Query studio), Transformer, Reportnet, Impromptu, PowerPlay, Impromptu Web Reports (IWR), Access Manager and Server Administration on Cognos 8.4, Cognos 10.1,Roambi, QlikView and IWR servers.
• Created Various Dashboard Reports for different Business Areas based on Powerplay Cubes and DMR's.
• Developed Dashboard Reports using AJAX.
• Involved in the Migration of FM Models, Transformer Models and reports from Cognos 8.3 to Cognos 8.4.
• Experience in writing PL/SQL.
• Created TM1 Cubes using Turbo Integrator.
• Implemented POC using TM1.
• Involved in installation Cognos 8.4 Suite on UNIX and Windows.
• Extensively worked on Cognos 8 Dimensional Functions on OLAP Datasource.
• Extensively worked with large Databases in Production Environments.
• Strong in Transformer for Data Modeling of Multidimensional Cubes using Star Schema.
• Worked on Creating Categories, Sub Categories, Terms and Report Paths in Business Glossary (8.1.1) and importing the files to the Business Glossary for creating the Definitions which can be used as Glossary in the Cognos 8.4 reports.
• Created Framework Manager Packages following best practices in multi-user Environment.
• Created various SQL Scripts to be used in Framework Manager and also for the verification of the Data.
• Created Powerplay Cubes based on the Cognos 8 Packages and Reports.
• Develop UNIX-based Transformer models.
• Involved in the Atomization of the cubes on UNIX Server.
• Install COGNOS suite of tools and configure gateways and dispatchers.
• Strong Enterprise Data Warehouse and OLAP skills using COGNOS Tools PowerPlay Transformer, ReportNet and COGNOS 8.
• Extensively worked on the Conditional Formatting of the reports using the Render and Conditional Variables.
• Used drill through, prompts, filters, and complex calculations in Cognos 8.
• Experience in dimension mapping, creating dimension views to implement the data security and generating, grouping and partitioning cubes.
• Involved in the Cognos 8.4 Administration like Creating Datasource Connections, Publishing Powerplay cubes to the server as a Package and Publishing FM Packages and Assigning the security for Business User Community and also Deployment of Packages and reports from Development to Production Servers
• Extensive Unix Shell Scripting knowledge.
• Extensive experience in ETL Tools-Data stage and Informatica.
• Load balance Cognos Servers such as PPES and IWR Servers..
• Catalog Development and Management, making IQD files, regular reports, and drill thru reports in Impromptu.
• Experience in creating the Catalogs and implementing the Security using User Classes in Impromptu Administrator.
• Maintain security through Access Manager and LDAP Server.
• Handle online interactive and batch programming.
• Write Macros using Cognos Script Editor and Visual Basic.
• Publish and mirror cubes and publish IWR reports using Administrator tools.
• Schedule cube builds and IWR Public Reports using Cognos Script, Visual Basic, and Autosys.
• Experience in building and maintaining multi-dimensional cubes in Powerplay.
• Provide Cognos user support and troubleshooting.
• Monitor Cognos Production Servers, taking backups and batch processing of the user requests.
• Extensively worked on migration projects such as upgrading servers to newer version of Cognos tools and upgrading Cognos reporting (worked on upgrades 7.1 to 7.3).
• Extensively worked on the documentation of the application design and deployment.
• Certified as ORACLE Associate.
• Certified in COGNOS.

TECHNICAL SKILLS

BI Tools: Cognos 10.1, Cognos 8.4, Cognos 8.3, Cognos 8.1(Report Studio, Analysis Studio, PowerPlay Studio, Event Studio, Metric Studio, Query Studio), Cognos 8.1.1 Business Glossary, ReportNet 1.1, Cognos Tools Suite (Series 6 and EP Series 7.0/7.1/7.3MR2), SDK, Impromptu, PowerPlay Transformer, PowerPlay Enterprise Server, Access Manager, Upfront, IWR Admin Tools, Qlik View..
ETL: Datastage, Informatica and Oracle Warehouse Builder.
Programming Languages: SQL, PL/SQL (Cursors, Stored Procedures, Triggers, Packages and Functions), and UNIX Shell Scripting.
Databases: Oracle 8i, 9i, 10g and Microsoft SQL Server.
Reporting Tools: Oracle Discoverer, Oracle Administrator and D2K Reports.
Operating Systems: WINDOWS 95/98, WINDOWS- NT/2000/XP Professional, MS-DOS and UNIX.

EMPLOYMENT HISTORY

Confidential, Rochester, NY, USA
Cognos Architect May' 10 - Present

Project Description:
The Supply Chain tracks all the orders, Back Orders and Fill Rates of the Organization in all the 3 Lines of Business (Pharma, Surgical and Vision Care). The Dashboard reports and cubes provide the essential information to the High level users, this will in turn helps in manufacturing the goods within time and also track the Order status of the Shipped goods to the vendors.

Responsibilities:

• Participating in the User meetings to analyze the user requirements and Design the layout for the Cognos Implementation.
• Involved in Implementing and analyzing the new tools for the Improvement of Business by helping the Customers in taking the decisions faster in User Friendly Views.
• Design the Model for Supply chain Business and analyzing the indexes and Keys.
• Implemented the Star Schema and Snow Flake Model.
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Powerplay Transformer Models and Cubes.
• Created dimension views and Custom views to implement the data security in the Powerplay Transformer Model.
• Designed the Dashboard Templates and Created Various Dashboard reports for the Business Users.
• Experience in writing SQL and PL/SQL to validate the Business logic.
• Involved in the User Performance and Business logic testing for the Dashboard Reports.
• Involved in the Cognos Administration like creating new Datasource Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.
• Working on the Functionality of the Cognos10.1 Active Reports.
• Involved in Creating POC for TM1Cubes.
• Installation of TM1 on 64-Bit Windows Server.
• Involved in Performance Tuning of the reports.
• Created Multiple Power cubes from Single Model.
• Created a Framework Manager Models with Multiple Namespaces.
• Created DMR's in the Framework Manager.
• Configured Roambi to cognos 8.4 Environment.
• Created Roambi Dashboard reports on Cognos reports.
• Involved in analyzing the New Dashboard tool QLIKVIEW.
• Created Dashboards using the QLIKVIEW.
• Created Dashboard reports from the OLAP source.
• Created PL/SQL to bring the data into the Data warehouse tables and implemented the business logic.
• Automation of Cube Builds using the batch scripts.
• Experience in writing the Cognos Dimensional Functions.
• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting using the Rendering and Conditional Variables.
• Created Powerplay cubes using multiple datasources, which are retrieved by Cognos Packages and Reports.
• Collecting and sharing best practices and tips in Framework Manager modeling, security setup, Report Authoring.
• Addressing the Performance and other Production issues with the Cognos 8 reports and Powerplay cubes.
• Created various SQL for the test cases and also used some User-Defined SQL's In Framework Manager.
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.

Environment:
Cognos 8.4 (Framework Manager, Report Studio, Query Studio,
Analysis Studio, Event Studio, Powerplay Studio), Cognos 8.4 Transformer, Cognos 9.5 TM1, PL/SQL, Oracle 10g, Qlik View 9.
Platform:
Windows 2000/2003/XP.

Confidential, Washington, DC, USA
Cognos Architect Mar' 08 - Apr '10

Project Description:
The EDW is a centralized information repository for the various systems in the Bank. Data Warehouse provides Reporting/OLAP solutions to diverse user communities with the help of Cognos business Intelligence suite of tools. The project works on the Headquarters/Country Offices model.

Responsibilities:

• Gathering the Report requirements from the Users to Design the FM Model and developing the Dashboards, Cubes and Complex reports.
• Designed the Dashboard Templates and Created Various Dashboard reports for the Business Users.
• Design the Model for Different Business Areas and analyzing the indexes and Keys and creating star schema.
• Participating in the User meetings to analyze and prepare the reporting and analysis requirements of users.
• Designing, Constructing, Testing and Deploying the Cognos Framework Manager Models, Packages, Reports and Powerplay Models.
• Created a Framework Manager Models with calculated columns, filters and Macros from different data source and created packages to suit the reporting needs of the client.
• Created dimension views and Custom views to implement the data security in the Powerplay Transformer Model.
• Involved in installation Cognos 8.4 Suite on UNIX and Windows.
• Created Multiple Power cubes from Single Model.
• Experience on Running the SDK Scripts on Security.
• Created Dashboard reports from the OLAP source.
• Implemented the Dashboard reports with the various Cognos Dimensional Functions.
• Developed Dashboard Reports using AJAX.
• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting using the Rendering and Conditional Variables.
• Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, Tree prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.
• Created Powerplay cubes using multiple datasources, which are retrieved by Cognos Packages and Reports.
• Extensively worked on the OLAP Datasource Reports.
• Created UNIX shell scripts for atomization of the Cubes Refresh using the Crontab on the Cognos AIX Server.
• Involved in Performance Tuning of the reports.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Involved in the Cognos Administration like creating new Datasource Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.
• Collecting and sharing best practices and tips in Framework Manager modeling, security setup, Report Authoring, Stress testing and Performance tuning.
• Addressing the Performance and other Production issues with the Cognos 8 reports and Powerplay cubes.
• Created various SQL for the test cases and also used some User-Defined SQL's In Framework Manager.
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.

Environment:
Cognos 8.4/8.3, (Framework Manager, Cognos Connection, Report Studio, Query Studio,
Analysis Studio, Event Studio, Powerplay Studio), Cognos 8.4 Transformer, Cognos 9.4 TM1, Cognos 8.1.1, Business Glossary,SDK, Data stage 6.0, Oracle 10g,Teradata, SQL Server, TOAD.
Platform:
AIX, Windows 2000/2003/XP.

Confidential, New Jersey, NJ, USA
Sr. Cognos Consultant Jun' 06 - Mar' 08
General/Ledger system

Project Description:
The DBG Data warehouse is a centralized information repository for the Domestic Brokerage Group (DBG) of AIG. The Decision Support Systems built upon DBG Enterprise Data Warehouse provides Reporting/OLAP solutions to diverse user communities with the help of Cognos business Intelligence suite of tools i.e. Cognos 8, Powerplay, etc. The project works on the Onsite/Offshore model with the offshore team supporting from India.

Responsibilities:

• Participating in the User meetings to analyze and prepare the reporting and analysis requirements of DSS users.
• Worked on General/Ledger System.
• Migrating the existing Cognos Impromptu Catalogs to Cognos 8 Models.
• Enhancing the Powerplay, Framework Models and Reports to meet the changing business requirements.
• Involved in Designing the ETL Mappings
• Created Complex Cognos 8 reports with the large amount of data.
• Create IQDs using Framework Manager.
• Created dimension views and User Class views to implement the data security in the Powerplay Transformer Model.
• Created Powerplay reports for the Client Managers.
• Created various Powerplay reports for the Different user groups.
• Created various Crosstab reports and Drill through reports as per the user requirements using conditional formatting.
• Extensively worked on Expense and Claims Cubes.
• Worked on Incremental Upload Cubes.
• Effectively Co-ordinated with the Off-shore team.
• Created various cubes using multiple datasources.
• Involved in Performance Tuning of the reports.
• Addressing the Performance and other Production issues with the Cognos 8 reports and Powerplay cubes.
• Defining the Users, Group and Roles in LDAP using Cognos Access Manager.
• Installed Cognos 8 On Windows 2000 Server and Configured the Dispatcher and Gateway.
• Created Stored Procedures and Functions using PL/SQL.
• Created Packages in SSIS.
• Created SSIS Mappings in loading data from the source to Datawarehouse.
• Used SQLLDR to load the data from the flat files to the Database.

Environment:
Cognos 8(Framework Manager, Report Studio, Query Studio,
Analysis Studio), Cognos EP Series 7 (Impromptu, Powerplay, Powerplay Transformer, IWR,
Upfront, Access Manager), Informatica, Oracle 10g, SQL Server, DB2 7.0, SQLLDR,
Genio 4.6, TOAD & Sun One Directory Server.
Platform:
Sun Solaris, Windows 2000/2003/XP.

Environment: ReportNet 1.1 (Framework Manager, Cognos Connection, Report Studio, Query Studio), LINUX, Oracle 10G, SQL Server, MS Access, Windows 2000 server/Xp Professional.

Confidential, Portland, OR
Report Developer Jun'04-Jun'06

Project Description:
Paragon: Freightliner headquartered in Portland is one of the largest heavy-duty & medium-duty truck manufacturing Company. Paragon datawarehouse provides information for Truck sales, Parts purchasing, inventory, Material management, forecasting and planning. The SAP interfaces will be loaded into the data-warehousing environment as flat files. The data warehouse database is with DB2. The main PARAGON application is based on Freightliner truck sales, customers/Vendors, and parts purchasing from dealers.

Responsibilities:

• Created technical specifications based on the given functional documents to design and create new reports.
• Imported metadata from other sources using Framework Manager, created models,packages and published packages to the ReportNet Server.
• Created different types of reports like List and Crosstab reports using drill through and with conditional formatting.
• Created reports with Drill through functionality, Graphs, Hyperlinks, and HTML items as per the user requirements.
• Planned and Created professional reports in Report Studio and ad hoc reports in Query Studio and trained users to use Query studio.
• Developed various reports using prompts like value prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.
• Developed and tested the new and existing reports as per the requirements.
• Involved in Performance Tuning of the reports.
• Developed various ad-hoc reports for management.
• Involved in fixing the bugs and enhancing performance of existing reports.
• Created IQDs using framework manager and created PowerPlay models to build the cubes.
• Created various cubes with full load and incremental load.
• Developed cubes with security.
• Created and tested PowerPlay cubes for Forecast and Planning and after market parts.
• Scheduled reports on weekly and monthly basis, also created views according to user requirements using Cognos Connection.
• Involved in production support to fix the problems in production environment.

Environment: ReportNet 1.1 (Framework Manager, Cognos Connection, Report Studio, Query Studio), PowerPlay 7.3, Transformer 7.3, Quest for DB2, Informatica 7.1.3, PowerConnect, 64-bit DB2 8.1, AIX, SQL Server, MS Access, PowerPlay Enterprise Server Administration, Access Manager Administration 7x, Windows 2000/Xp Professional.

Confidential, India
Report Developer Dec'00-May'04

Confidential, Hyderabad, India

Project Description:
Confidential, is India's leading Private Basic Service Operator and the pioneers of CDMA mobile services. It provides products and services like CDMA mobiles, Post Paid Internet Services, Plain Old Telephone Services and Public Telephone booths. TTSL currently offers services under the brand name \'Tata Indicom\' in 20 circles in India. With the growing business and competition, a central place for analyzing the data coming from different operational systems is apparent and hence an Enterprise Data warehouse. Successful implementation of EDW will support management decisions in proactively analyze business and make forecasts.

Responsibilities:

• Enhancements of COGNOS Impromptu.
• Design and Develop OLAP Cubes using Cognos Power Play Transformer.
• To map Business requirements into System functionality
• To design and develop ETL mappings in Oracle Warehouse Builder.
• Written Unix Shell scripts.
• To write Shell Scripts for automating ETL processes
• Design Model using the Macros.
• Security is provided for accessing the Cubes and also for accessing the Data.
• Developed PLSQL Procedures.

Environment: Oracle, Cognos Suite (Series 6 and Series 7.0 of Impromptu, PowerPlay, PPES, Upfront, Architect, Cognos Query, Access Manager, IWR Admin Tools, PowerPrompts), IIS 5.0, Win NT, Unix, SQLLDR,SQL,PL/SQL and Oracle Warehouses Builder.