PROFESSIONAL EXPOSURE

• Above 8+ years of experience in IT and Software Development Life Cycle (SDLC).
• 7 years of expertise in gathering requirements, documenting, analyzing, designing and development, testing and implementing BI solution.
• Experience with Cognos suite of tools like Cognos 8 version (8.2, 8.3, and 8.4), ReportNet version and Cognos 7 Series (7.1, 7.2, and 7.4).
• Interacted with end users and business clients to gather there report requirements.
• Prepared project relevant documents- Report Specifications, Report testing documents, Report roll-out documents and ETL specifications.
• Captured meeting minutes and prepared agenda for the BI project.
• Hands on experience in installation and configuration of Cognos 8.x BI server and Cognos 8.x BI Modeling.
• Configured Cognos Configuration and Cognos Connection to create cognos environment. Involved in creating and monitoring Jobs and Schedule.
• Publishing Packages and IWR onto cognos connection and Upfront respectively.
• Worked intensively on Framework Manager creating projects, models and packages in three layers Database view, Business view and Presentation view.
• Created both regular models and DMR models defining objects, query subjects, levels, filters and prompts.
• Created catalogs, folders, joins, filters and calculations for Impromptu catalogs.
• Prepared Hotfiles and .IQD files in Cognos 7 series.
• Have profound knowledge on Snowflake schema, Star schema of Enterprise Data Warehouse and department specific Data Marts.
• Closely interacted with the ETL team to understand and monitor data loads.
• Hands on experience with Report Studio, Query Studio, Analysis Studio, Impromptu Administrator and Power Play Transformer.
• Created complex reports like master-detail relationship, drill-through, burst reports, conditional formatting and cascading reports.
• Created series 7 reports like simple list, crosstab, drill-through and sub-reports.

TECHNICAL SKILL SET

• BI Tools: IBM Cognos BI (8.1, 8.2, 8.3, 8.4), ReportNet 1.1, Cognos series 7
• Reporting Tools: Impromptu 7.x, Power Play 7.x, Iwr, ReportNet 1.1
• ETL: Informatica 8.1/ 8.6
• Database: Oracle 8i/9i/10g, MS SQL Server 2000/2005, Teradata, MS Access
• ERP: SAP BW, SAP BI 7.0
• OS: Windows VISTA/XP/NT/98/95, UNIX, Linux (Red Hat, Fedora, Ubuntu)
• Languages: C, C++, SQL, PL/SQL, JAVA, Shell Scripting, HTML, XML, XQUERY
• Other Tools: Erwin 4.0, MS Office suite, SQL*Plus, TOAD, Visio 2003, BPWin

EDUCATION

• Bachelor of Science in Computer Science

Confidential, Ontario, CA

Sr. Cognos (Architect and Developer)/ BI Analyst August 2008 - To-Date

Confidential, is a retail apparel manufacturing industry that has its store penetration across 12 major cities in United States. The wide spread business of ABRG captures huge data from its day to day business transactions and processes. The huge business data is captured in Retek Data warehouse. This data warehouse is further utilized for their Business Intelligence analysis.

• Project demanded my interaction with various business heads as a BI analyst, to gather report requirements from different business departments like Allocation, Finance, Real Estate, Sales and Distribution and Store Operations.
• Having developed the report specifications analyzed the existing environment of OLTP, OLAP (Oracle Retek DWH) system and Cognos models in Framework Manager.
• For better understanding of the environment was involved with the Informatica ETL team and also interacted with the Erwin data modelers.
• Actively involved with the entire BI life cycle- report requirements gathering, documentation (business and functional specifications), analysis of existing resources, report and model development in Cognos Framework Manager, testing reports (QA and data validation), production (migrating reports from QA to production) and maintenance (job and scheduling).
• Followed the best practice of creating project and models in three layered approach using Framework Manager - database layer, transformation layer and presentation layer.
• As a metadata modeler actively participated in creating RDW project and based upon it created models for various departments like Sales, marketing, allocation and finance.
• Customized packages and published them onto cognos connection (c8.4 server) as per the reporting requirements.
• Enhanced the models (LDO and ABRG) by running the metadata wizard and including different query subjects and establishing cardinalities accordingly.
• Created regular and measure dimensions in the Framework Manager model using three types of query subjects - data source, model and stored procedure.
• Created both simple and complex reports like list reports, crosstab reports, drill-through reports, master detail reports, burst reports, conditional block reports, dashboards reports and cascading prompt based reports.
• Worked intensively on On-Demand reporting environment and used tabular SQL.
• Enhanced report performance by tuning the reports using filters, prompts, sorting and grouping as and when required.
• Performed data profiling and data validation of report output by manually verifying and executing SQL code in Toad.
• Monitored daily, weekly and monthly jobs and also involved in creating jobs and schedules as required.
• Prepared Status Report as part of documentation for those reports that are moved into production after performing UAT.
• Educated the end users on Query Studio about Ad hoc reporting.

ENVIRONMENT
MS Windows XP Professional SP2, Cognos 8.4, Cognos Reportnet 1.1 (Report Studio, Query Studio), Informatica 8.1, Teradata, Oracle 10g, Erwin 7.0, JDA, Oracle Retek, SQL Server 2005, Toad, Citrix, ABRGLDAP, IIS Web Server

Confidential, Buffalo, NYC

Senior Cognos ConsultantSep 2006 - Jul 2008

Confidential, is a strongly capitalized commercial bank that provides a wide range of personal wealth management, commercial banking, and corporate banking. Private Banking Wealth Management System (PBWM) is an intranet system designed to support Private Banking front office and back-office operations.Its end users are HSBC internal users namely back office operation staff, Private Banking Relationship Managers, as well as securities dealers. This Projects objective is to develop various reports for the personal wealth management division of the HSBC Bank. Various reports are developed like Daily activities Report by Portfolio, Income by Product etc

• Involved in Installing and Configuring Cognos BI 8.2. Planned to set up three different environments for Cognos BI 8.2 products Development, Testing, and Production.
• Involved in Creating Content Store using MS SQL Server 2005.
• Interacted with the Business users and documented their query, business analysis and reporting needs.
• Created Physical Layer, Transformation Layer and Business Layer in FM Manager.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection. Worked with Dimensions, Measures and Levels to develop models for working in Analysis Studio.
• Used DMR based cubes to get the report data and verified the Multi-Dimensional Expressions (MDX) query formed in Report Studio.
• Created Folders, Filters, Prompts, and complex Calculations in Framework Manager and Report Studio.
• Extensively used Analysis Studio, Query Studio and Report Studio for Report design in Cognos BI version 8.2
• Involved in creating Security, and Deployment (exports and imports).
• Created reports using Free Form SQL in Report Studio as per user's requirement.
• Created charts, lists and cross tabs using Report Studio and Ad hoc reports using Query Studio.
• Designed multidimensional reports in Cognos 8 Analysis Studio.
• Converted some existing reports in MicroStrategy by entirely creating reports into Cognos 8.2 functionality.
• Developed complex reports like Conditional Block Reports, Drill-Through Reports, Master-Detail Reports, Burst reports and Multilingual Reports using Report Studio and Query Studio.
• Created standard and Ad hoc reports using Cognos Query Studio.
• Administration involved Installation and configuration of COGNOS servers, implementing security, managing users, user groups and roles in the organization.
• Trained MicroStrategy developers on Framework Manager, Report Studio, Query Studio, Analysis Studio
• Trained business users to use Query Studio for Adhoc reporting.

ENVIRONMENT
Cognos BI 8.2 (Report Studio, Query Studio, Analysis Studio), Cognos Connection, Frame Work Manager, Access Manager, MicroStrategy, Data Stage, Windows XP Professional SP2, ERP (PeopleSoft HRMS), Windows Server 2003/NT, Oracle 10g, MS SQL Server 2005, Toad.

Confidential, Fairfield, NJ

Cognos Developer/ AdministratorMay 2005 - Jul 2006

Confidential, is a contract-sales provider that provides service to drug-developers, medical-device developers with sales force. A Data-warehouse was created to improve the performance of the internal business process of the organization by facilitating managers and key decision makers to view, analyze and improve the profitable and quality services of the company. As a Cognos Developer I created OLAP cubes with multiple dimensions and drilldown reports and analysis is done using optimization models to improve the overall performance of the organization.

• Installed and Configured Cognos BI 8.1 and worked in different environments.
• Extensively used Analysis Studio, Query Studio and Report Studio for Report design in Cognos BI version 8.1
• Designed multidimensional models in Framework Manager of Cognos BI 8.1. Modeling environment which consisted of two different layers Import Layer and Presentation Layer.
• Understood data and business logic underlying the business requirements.
• Involved in creating a Content store using Oracle 9i.
• Created Projects, Models, and Packages using Cognos Framework Manager and published Packages to Cognos Connection.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Worked along with the networking team to tune the performance of the Teradata Production database.
• Developed processes on both Teradata and Oracle using BTEQ (Teradata) and SQL*Plus.
• Tuned and optimized Teradata queries.
• Created charts, lists and crosstab reports using Report Studio and ad hoc reports using Query Studio.
• Created dashboard reports for executives and various other departments.
• Installed and Configured ReportNet 1.1 MR2.
• Tuned Cube build time, Impromptu Reports and ReportNet reports and servers for better performance.
• Provided security to the ReportNet in Access Manager through LDAP Server and configured settings in Cognos configuration.
• Administration involved implementing security, managing users, User groups and roles in the organization. Worked on bursting reports for the web users.
• Implementation of Impromptu reports and PowerPlay cubes using multiple queries.
• Optimized Catalogs by using and tuning Database Interaction, Client/Server balancing, Database functions, Table Weighting, Qualification, and Governors Settings.
• Imported power cubes from the PowerPlay enterprise server to ReportNet Cognos connection server.

ENVIRONMENT
Cognos BI 8.1 (Report Studio, Query Studio, Analysis Studio), Cognos Connection, ReportNet 1.1 MR2, Frame Work Manager 1.1 MR2, Impromptu 7.2, PowerPlay 7.2, Access Manager, Windows XP Professional, Windows Server 2003/NT, MS SQL Server 2000, Oracle 9i,Teradata V2 R5/R4, SQL*Plus.

Confidential, San Jose, CA

Senior Cognos Developer Oct 2003- Mar 2005

Confidential, with its wide range of products enables interactivity between information and people through various processes. Adobe provides services to various sectors of the industry spread across the world. Adobe Sales and Marketing unit utilized the Cognos Suite for transforming the existing reporting system's information into models and cubes in order to prepare rapid delivery of Ad-hoc and Complex reports. The Cognos system generates reports for forecasting, Pipeline and Actuals in sales and marketing. The scope of the project is Architect building and Report Authoring including whole Business Intelligence life cycle process.

• Installation of ReportNet 1.1 and Framework Manager 1.1, setting Cognos configuration and integrating different components were part of the project.
• Content Store was created in MS SQL Server 2000.
• Communicated with the business users to comprehend the requirements.
• Designed the reports and catalogs using Impromptu Administrator as per the requirements.
• Extensively used PowerPlay Transformer to convert the data into power cubes.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Designed and modeled Cognos Transformer cube and reports according to user needs.
• Created standard filters, calculations, prompts and conditions in Catalog
• Created multiple dimensions, Alternate drill through and special categories in Transformer.
• Creation of a multiple layer report providing a comprehensive and detail report with drill-through facility in PowerPlay.
• Conducted periodic training for Power users on slicing and dicing, drill down technique for extensive usage of the reports.
• Trained Users in Query Studio for Ad-hoc reporting
• Installed Cognos ReportNet and Framework Manager in an interim environment as a proof of concept.
• Involved in migration of catalogs from Impromptu to ReportNet using Migration Utility Tools.
• Created customized BI reports linking various databases, to meet the user requirements.
• Designed models using Framework Manager and deployed packages to the ReportNet Servers.
• Developed List Reports, Charts, Drill-Through Reports, Master-Detail Reports, Bursting reports and Multilingual Reports using Report Studio and Query Studio.
• Created standard and Ad hoc reports using Cognos Query Studio for on-demand reporting.
• Created Reports to evaluate the business performance based on various financial indicators.
• Created Lists, Groups and Cross-tab reports with drag and drop functionality.
• Report Tuning is performed by using filters, prompts and editing Cognos SQL manually.

ENVIRONMENT
ReportNet 1.1, Frame Work Manager 1.1, Impromptu 7.1, PowerPlay 7.1, IWR, Upfront, Access Manager, Migration Utility Tool, Microsoft IIS, Windows 2000, Oracle 8i, MS SQL Server 2000, HTML, MS Access, Toad.

Confidential, Portland, OR

Cognos DeveloperNov 2002- Aug 2003

Confidential, manufactures equipment that helps handling goods. Equipment like warehouse trucks, counterbalanced trucks, container handling trucks, etc. All trucks are marketed under three brand names; Hyster, Yale and Sumitomo-Yale. One of the companies' mottos is to be industry's lowest cost producer of the lift trucks and components. This project involved for Inventory Control reporting for Vehicle Manufacturing unit. The task involved of building decision support reports using Cognos PowerPlay and Power cubes. Develop OLAP cubes using Cognos to aid management in performing the following tasks.

• Track various parts stock availability and forecasting for manufacturing Forklift trucks
• Created reports to monitor sales forecast, inventories on-hand, and periodical performance.
• Developed data marts using Cognos Transformer to create OLAP cubes.
• Mapping the business needs and accordingly creating the cubes using Cognos PowerPlay Transformer.
• Used multiple Data sources, Data marts, and designed various kinds of reports in Impromptu Administrator.
• Designing and developing Excel 2000 spreadsheets, data extraction from Access 2000.
• Designed and created custom reports in Cognos PowerPlay like drill through, list, cross tab and chart reports.
• Created joins, filters and calculations for Impromptu catalogs.
• Created alternate drill through for Power cubes.
• Optimized the cube performance and the report response time.
• Published cubes and OLAP reports using Upfront Server.
• Provided systems support to users and other developers.

ENVIRONMENT
Impromptu 7.0, PowerPlay 7.0, Upfront 7.0, Access Manager, Impromptu Web Reports server (IWR), PowerPlay Enterprise Server, Windows 2000, Oracle 8i, MS SQL Server 2000, Toad.

Confidential, India

Data Warehousing Programmer Nov 2001 - Oct 2002

Confidential, provides healthcare IT products and services by developing IT solutions for the Healthcare Industry. The project, Bio Medical Maintenance was part of the Hospital Information System (HIS). This module allowed placing requests for new equipment (Auto Analyzers, Blood Gas Analyzers, and Coulters) with the Hospital Laboratory Information System. This encouraged to build a Data warehouse and deliver mission critical reports relevant to medical equipment Inventory.

• Reports such as Inventory tracking reports, forecast on Inventory allocation reports, and Vendor Analysis reports are created.
• Studied and analyzed user and system requirements.
• Created Impromptu catalogs and various reports using Impromptu Administrator.
• Tuned cube builds, Impromptu Reports and servers for better performance.
• Provided end user training so that users can generate their own reports using Impromptu and PowerPlay.
• Created advanced reports using Cascading prompts, Cross tab, Sub-reports, Public and Burst reports.
• Expert knowledge in Extraction, Transformation and Loading (ETL) Process.
• Built Dimension tables and Fact Tables.
• Experience in writing Triggers and Stored procedures using PL/ SQL for Incremental updates.
• Integrated various sources in to the Staging area in Data warehouse.
• Designed Data mart using Star Schema for faster effective querying. Worked with Erwin tool as part of data modeling.
• Extensively used Impromptu in accessing the source data to build reports and to feed the transformer models.
• Creating multidimensional cubes using PowerPlay Transformer.
• Implemented Drill-Through with report and query linking.
• Creating Business ranking and Variance reports.
• Data Mart is accessed for building Cubes for analysis and for various reporting purpose.

ENVIRONMENT
Cognos 7.0(Impromptu Administrator, PowerPlay), Windows 2000, Oracle 8i, Informatica, Erwin, Toad, SQL, PL/ SQL, Windows NT