SUMMARY

• More than ten years of working experience in business intelligence.
• Proficient in Cognos 8/10 BI tools such as Framework Manager, Report Studio, Analysis Studio, Query Studio and Cognos Workspace
• Hands on experience building multi-dimensional cubes with various OLAP tools such as TM1, Transformer and Cube Designer.
• Strong understanding of data warehousing concepts.
• Experienced in Cognos administration.
• Substantial exposure to overall software development life cycle with good knowledge of processes like version control, bug tracking and requirements gathering.
• Experienced in finance, insurance, pharmaceutical, retail, and market research industries.
• Ability to learn quickly with strong analytical skills.

SKILLS

• BI Cognos 8/10 BI Suite Report Studio, Query Studio, Analysis Studio, Event Studio,
• Framework Manager, Transformer , Cognos ReportNet 1.x Suite, Cognos Series 7.x
• Suite Impromptu, Impromptu Web Reports, Impromptu Administrator, PowerPlay,
• PowerPlay Enterprise Server, Cognos Query, Access Manager , Cognos TM1, Cognos
• TM1 Executive Viewer, Cognos Workspace, Cognos Workspace Advanced, Lifecycle
• Manager, Dynamic Query Analyzer, Cube Designer, Cognos Insight, Cognos Go-
• Office, Crystal Reports
• Database Oracle, SQL Server, DB2, Access, Composite, Netezza
• Tools Toad, SQL Plus, iSQL Plus, Query Analyzer, DB Visualizer, Execute Query,
• SQL Loader, Subversion, DataStage, Autosys, Oracle SQL Developer, Oracle SQL
• Developer Data Modeler, Quality Center, Aginity Netezza Workbench, Esri Maps
• Designer
• Languages Visual Basic, Java Script, HTML, XML
• Web Servers IIS, Apache, iPlanet
• OS Windows, UNIX, Linux, VMware

EXPERIENCE

Sr. Cognos Developer

Confidential

Confidential the primary subsidiary of Westfield Group, is a multi-line provider of business property liability insurance, personal lines insurance including auto, homeowner's and specialty , agribusiness insurance, and surety bonds.

• Worked with the business to understand their needs.
• Built multi-star framework and DMR models.
• Combined several frameworks into a master using linking and model metadata source.
• Combined Cube, DMR and relational data sources to create complex reports.
• Used conditional prompts, tree prompts, layout component references, unions, conditional rendering and multi-level conditional drill-through.
• Built reports on the XML data.
• Created complex dashboards/status boards with multi-level drill-through involving conditional joins, java scripting and macros.
• Worked on using dimensional functions as a part of OLAP reporting.
• Built active reports with functionalities such as cascading prompts, drilling, exploding pie, scrolling text, dynamic sorting, and hiding/showing columns.
• Enabled drill thorough from cube to cube and cube to relational.
• Integrated google maps into the reports to locate agencies.
• Used transformer features such as external rollups, allocation, partitioning, time state rollups, custom views, alternate hierarchies and relative time categories for cube builds.
• Automated multiple cube build processes by using batch files.
• Tuned reports as well as cubes to meet the SLAs.
• Involved in upgrading Cognos servers from 8 to 10.1.
• Managed user groups for security as well as scheduling.
• Integrated Westfield Enterprise Glossary with Cognos.
• Deployed reports, packages, models and cubes between environments.
• Set up routing rules to divert power users to a different dispatcher.
• Trained users on Cognos Workspace and Workspace Advanced.
• Worked on Esri maps as a part of POC to incorporate advanced mapping solutions.
• Enabled Dynamic Query Mode to improve performance of the DMR reports.
• Built secure Dynamic Cubes using Cube Designer.
• Used Dynamic Query Analyzer to understand in-memory and database aggregates.
• Worked with IBM's guardian group as a part of Cognos lab services.
• Involved in regression testing of upgraded Cognos 10 reports.

Environment: Cognos 8.4/10.1/10.2 Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformer , Cognos Connection, Lifecycle Manager, Cognos Workspace, Cognos Workspace Advanced, Dynamic Query Analyzer, Cube Designer, Cognos Insight, Esri Maps Designer, Windows 2003/2008/XP, VMware, DB2 9.7, Netezza 6, SQL Server, DB-Visualizer, IIS 7.0, Active Directory, LDAP, Access Manager, Quality Center

Cognos Developer

• offering market research and services in more than 100 countries to a number of clients like Kraft, Procter and Gamble, Coke etc.
• Worked closely with the business analysts to understand the business requirements.
• Used Framework manager to build multi-star models over composite views.
• Published relational packages for report studio reports and DMR packages for ad-hoc reporting using CAF .
• Defined and built hierarchies for various dimensions as a part of DMR modeling.
• Involved in setting up Framework manager automation using datastage.
• Developed list reports, charts, drill-through reports, and master-detail reports using report Studio
• Developed complex reports with joins, unions, SQL, calculations, and conditional formatting.
• Developed operational models and reports for showing custom reports usage statistics.
• Integrated Cognos reports with Nielsen's answers portal and data selector.
• Integrated Application Data Framework ADF widgets into the reports for advanced functionality.
• Upgraded reports and models from Cognos 8.2 to Cognos 8.3.
• Installed Cognos 8.4 and tested reports and model by upgrading from Cognos 8.3.
• Participated in beta testing of Cognos 10.1 Cognos Colorado Beta exclusive to Nielsen
• Used TM1's Turbo Integrator to build dimensions and cubes
• Defined rules and scheduled processes.
• Created basic reports using TM1 Web, TM1 Perspectives and TM1 Executive Viewer
• Troubleshot various reporting and modeling issues raised during production.
• Provided informal training for CAF , Query Studio and TM1 Executive viewer.
• Worked on cascading style sheets CSS to change the default Cognos styles.
• Customized Cognos Connection according to the company's specifications.
• Involved in basic administrative tasks like giving access privileges, setting up connections and audited databases.
• Worked on the performance tuning of the reports.
• Assisted with the design, implementation and tuning of metadata database for Nielsen's Data selector.
• Wrote Stored Procedures and Packages for data load, backup and restore.
• Used Autosys and UNIX scheduling for running datastage jobs and Oracle scripts.

Environment: Cognos 8.2/8.3/8.4/10.1 Framework Manager, Report Studio, Query Studio, Analysis Studio, Go-Office , Cognos Connection, Windows 2003/XP, Unix, VMware, Oracle 9i, Netezza 4.6, Cognos TM1 9.4, Cognos TM1 Executive Viewer 9.4, Excel 2003, DB-Visualizer, Execute Query, Oracle SQL Developer, Toad, Oracle SQL Developer Data Modeler, Composite Information Server 4.6, Composite Studio 4.6, IIS 6.0, DataStage 7.5.3, Active Directory, Autosys, Quality Center, Aginity Netezza Workbench

Cognos Developer,

Confidential a wholly-owned subsidiary of Forest Laboratories, Inc., manufactures, distributes and sells Forest-branded ethical prescription products in the United States and Puerto Rico. Scope of this project was to create reporting infrastructure and test the reports for the sales and marketing department of the company for analyzing their performance.

• Conducted user interviews and documented their queries, business and reporting needs.
• Imported metadata from various data sources into Framework manager.
• Created database layer, physical layer, and presentation layer.
• Defined appropriate relationships between the data source and model query subjects.
• Developed list, cross tab, chart, master-detail and drill through reports which involved multiple prompts, conditions, filters and calculations.
• Created dashboards for immediate visibility into key performance indicators KPIs .
• Involved in improving the performance of the reports.
• Built multi-dimensional models and cubes in Transformer using IQDs.
• Reduced the cube build times drastically and increased runtime performance.
• Designed multidimensional reports in analysis studio.
• Built dimensions and cubes from ODBC data sources using TM1's Turbo Integrator.
• Used TM1 rules to define new calculations according to the business requirements.
• Improved performance of the cubes using Skipcheck and feeders in the rules.
• Worked with TM1 architect client to create, analyze and manage business data stored on TM1 servers.
• Used TM1 Web to create Websheets that support Excel capabilities on the Web.
• Created reports in excel using TM1 Perspectives for excel.
• Evaluated TM1 and transformer cubes performance.
• Scheduled reports to be delivered through e-mail in PDF and excel formats.
• Bursted reports into different directories to meet the data security needs.
• Configured and integrated Access Manger with other Cognos products for security.

Environment: Cognos 8.1 Framework Manager, Report Studio, Query Studio, Analysis Studio , PowerPlay Enterprise Server 7.3, Transformer 7.3, PowerPlay 7.3, Cognos Scheduler, Cognos Connection, Access Manager, Cognos TM1 9.1, Cognos TM1 Executive Viewer 9.1, Windows 2003, SQL Server 2005, MS Access 2003, Active Directory, Query Analyzer, IIS 6.0

Cognos Developer

Confidential , now a part of AT T, was the nation's largest independent rural wireless provider operating in several regions of the United States with a subscriber base of 700,000. Dobson Cellular Systems was a subsidiary of Dobson Communications operating under the brand name Cellular One.

• Interacted with the users for understanding and gathering business requirements.
• Built Framework manager models and established the cardinalities to suit the business.
• Developed and published packages in Framework manager.
• Implemented security for data access, object level access and package access.
• Assisted in creating executive dashboards for management level reports using Report Studio.
• Developed templates, list reports, charts, drill through reports, master-detail reports, and multilingual reports using Report Studio.
• Created complex, multi-page reports involving prompts, cascading prompts, conditional rendering, and conditional highlighting.
• Worked on scheduling and publishing the reports onto Cognos Connection.
• Performed report testing's.
• Involved in bursting reports using Report Studio and Cognos Connection.
• Created Query Studio reports with groups, sections, filters, and calculations.
• Migrated reports and catalogs from Impromptu to ReportNet.
• Created multi-dimensional cubes using Cognos TM1 Turbo Integrator.
• Assigned access to TM1 objects by setting up security at various levels.
• Used TM1 executive viewer for building ad-hoc reports over the cubes.
• Involved in performance tuning of reports and cubes.
• Scheduled processes using chores.

Environment: ReportNet 1.1 MR1/MR2 Framework Manager, Report Studio, Query Studio , Impromptu 7.3, Impromptu Web Reports 7.3, Impromptu Administrator 7.3, Upfront, Cognos TM1 8.4.5, Cognos TM1 Executive Viewer 8.4.5, Cognos Scheduler, Cognos Connection, Windows 2003, Oracle 10g, Novell eDirectory, Apache 2.0, SQL Plus, Toad

Cognos Developer

Confidential Vuitton was established in 1987 and enjoyed an exceptional reputation as a world leader in luxury goods. The company possesses a unique portfolio of some 50 prestigious brands worldwide and is present in 12 countries in Asia.

• Worked closely with clients to gather and document business requirements.
• Created metadata models that include calculations, filters, parameter maps, and session parameters used by report authors.
• Created dashboards based on the business requirements.
• Developed complex reports that include conditional blocks, conditional layout, sections, mater-detail relationships, prompts, and tabular set.
• Created ad-hoc reports for the business users
• Created stand alone calculations and filters for Query Studio users.
• Extensively used PowerPlay features such as alternate drill-down, drill through, category creation and calculated columns to create PowerPlay cubes.
• Created PowerPlay cubes with incremental updates.
• Created macros in PowerPlay for performing various tasks.
• Published cubes and reports onto Cognos Connection.
• Customized Cognos Connection as per the company requirements.
• Created user classes, signons for different users and set security for reports and cubes using Access Manger.

Environment: ReportNet 1.0 Framework Manager, Report Studio, Query Studio , PowerPlay Enterprise Server 7.0, Transformer 7.0, PowerPlay 7.0, Cognos Scheduler, Cognos Connection, Access Manager, Windows 2000, Oracle 9i, iPlanet, Apache 1.3, SQL Plus, Toad 6.3

Cognos Developer,

Confidential Manufacturers Insurance Company NJM and its subsidiaries offer a variety of property/casualty insurance products, including personal, automobile and homeowners insurance in New Jersey and Pennsylvania. It also provides flood insurance through a FEMA program.

• Created catalogs and reports using Impromptu.
• Developed various kinds of prompts such as type in, pick list and cascading prompts.
• Installed and configured ReportNet on development server.
• Used exceptional highlighting to avoid overlooking of critical figures.
• Involved in migration of projects from Impromptu to ReportNet.
• Deployed packages, folders and reports to different environments.
• Created cubes and cube groups along multiple dimensions in Transformer.
• Performed tuning of power cubes to reduce query time by partitioning the cube.
• Involved in scheduling, bursting and distributing reports by email.
• Used Access Manager to administer security for all the catalogs.
• Created and set security for news boxes and news items in Upfront.

Environment: ReportNet 1.0 Framework Manager, Report Studio, Query Studio Impromptu 7.0, Impromptu Web Reports 7.0, Impromptu Administrator 7.0, PowerPlay Enterprise Server 7.0, Transformer 7.0, PowerPlay 7.0, Cognos Scheduler, Upfront, Cognos Connection, Access Manager, Windows 2000, SQL Server 2000, Query Analyzer, iPlanet 4.0, iPlanet Directory Server

Cognos Developer

• Confidential the border of US and Mexico, LNB has a customer base spanning two nations.
• Created catalogs from multiple databases with the help of hot files
• Created standard filters, calculations, prompts and conditions in catalog
• Involved in analyzing joins to improve performance of reports
• Developed multi-dimensional models using Transformer
• Created reports using PowerPlay for Windows
• Worked on PowerPlay Enterprise Server to publish PowerPlay reports to Upfront
• Scheduled Impromptu and PowerPlay reports using Cognos Scheduler
• Implemented security and granted privileges according to user classes using Access Manager

Environment: Impromptu 7.0, Impromptu Web Reports 7.0, Impromptu Administrator 7.0, PowerPlay Enterprise Server 7.0, Transformer 7.0, PowerPlay 7.0, Cognos Scheduler, Upfront, Access Manager, Windows 2000/NT, Oracle 9i, MS Access 2000, SQL Plus, Apache 1.3, OpenLDAP