OBJECTIVE

Obtain a responsible and challenging position with a progressive company where my work experience will have valuable application and utilization of my opportunity for advancement.

PROFESSIONAL HIGHLIGHTS

• Over Seven years of professional experience in BI Tools Cognos 8, Software Analysis, Designing Business Models, Development of code and Maintenance of complex reporting products.
• Excellent Business Analysis capabilities and skilled in approaching and gathering the end user requirements.
• Experienced in using various Cognos tools such as Cognos 10 BI, Cognos 8BI, ReportNet (Framework Manager, Report studio, Query studio, Analysis studio, Event Studio, Cognos Connection), Impromptu, PowerPlay, Transformer and Access manager.
• Experienced in sales, marketing and supply chain management.
• Experienced in generating several complex reports using Report studio, Query Studio, Event Studio and Analysis Studio in Cognos 8 & 10 Environment, Cognos ReportNet and Cognos Power Play reports in Series 7.
• Experience in creating models and implementing the Security using User Classes in Cognos Administration and creating IQD’s in Framework Manager to use in Cognos Transformer.
• Expert level skills in technologies like Business Objects, Business Objects Universe, Business Objects Dashboards, Informatica, Cognos and Oracle financial analyzer with fortune clients like GE Polymer shapes
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling. Worked on complete Life Cycle Development process, which includes analyzing business needs, documenting business information requirements, technical designs, development, integrating, Implementing and Production Support using Cognos as a BI tool.
• Strong knowledge of full lifecycle development methodologies, standards and procedures.
• Excellent communication, organizational and problem solving skills and ability to work individually or in a group.

EDUCATION

• Bachelor of Electronics & Communication from Confidential.

TECHNICAL SKILLS

• BI Tools: Cognos 8 & 10 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio),Cognos ReportNet (Report studio, Query Studio and Framework Manager), Cognos EP BI series(Cognos Impromptu, PowerPlay, Transformer, Impromptu Web Reports IWR)
• Operating Systems: Windows 98/2000/ XP /NT/7, UNIX and Linux.
• Languages: SQL, PL/SQL, C, C++, Java, VB, VB.Net.
• Databases: Oracle 8i/9i/10g, MS Access, SQL Server 2005.
• Other: MS-Office, Adobe Photoshop, Adobe Acrobat.

PROFESSIONAL EXPERIENCE

Project Name: Confidential_EDW Development
Client: Confidential, San Francisco California 
Duration: October 2011 to Till Date 
Role: Cognos Developer
Environment: Cognos 8.3 & 10, Report Studio, Framework Manager, SQL server 2008, Windows XP

Company Description

Confidential is a French brand and chain of cosmetics stores founded in Paris in 1970, and acquired by French conglomerate LVMH (Louis Vuitton and Moet Hennessy) in 1997. The Confidential chain includes more than 750stores in 17countries. Carrying over 250brands, along with their own private label, Confidential offers beauty products including makeup, skincare, fragrance, hair care, bath and body products, and hair and make-up tools.

Responsibilities

• Involved in gathering Business Requirements Reporting and Modeling.
• Interaction with the Management and Development teams for gathering requirements for creating the Framework Model.
• Validating Reports in Life cycle manager and comparing them in 8.4 and 10 environments and fixing the issues in cognos 10.
• Testing the SQL based reports and changing the SQL to fix the issues in cognos 10.
• Worked extensively on creating the Model using Framework Manager according to user requirements and publishing the package on Cognos Connection for reporting purposes.
• Created filters within the Model for improving the performance of the model.
• Developed Standard Templates, Reports, Charts, Drill Through Reports, Master Detail Reports and Bursting Reports Using Report Studio.
• Created Query Prompts, calculations, Conditions & Filters.
• Updating the existing store procedures to create reporting tables in the SQL server and update the FM model and use it to develop complex reports in the report studio.
• Developed Prompt pages, Multi Page Reports and Conditional Variables.
• Trained Users on Query Studio for Ad-Hoc Reporting.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Testing, Validating and improving Report Performance.

Project Name: Optima Citirisk reporting
Client: Confidential, Warren NJ 
Duration: April 2010 to September 2011 
Role: Cognos Consultant
Environment: Cognos 8.4, Cognos 10, Framework Manager, Cognos TM1, Powerplay Transformer, Sybase

Company Description

Confidential is one of the major financial industries in the global market. Citi as part of accessing the risk of their clients need to generate various risk related reports depending on the various feeds they get from the risk and finance sources. They established a very vast reporting system called optima risk reporting which is a centralized platform across the board for fulfilling the various reporting requirements as part of hedging their risk when interacting with various clients during the lending and trading process in the financial markets. Roles and Responsibilities

As a Cognos Consultant played the following responsibilities

• Analyze reporting infrastructure
• Analyze various reporting requirements
• Provide the cognos approach that needs to be used for various reports
• Decide on the summarized/datamart table structure to be used for various reports
• Model the cognos metadata layer for report development using framework manager
• Document the cognos business names to the database names mapping using framework manager model reports
• Merging various framework manager models into a single centralized FM model
• Re-pointing the existing reports to run against new denormalized table to improve performance with no changes to report structure
• Involve in cube/report development activities using report studio and powerplay/TM1
• Building up of adhoc reporting model and educate the users on how to use it
• Provide Scheduling solutions to run the reports automatically based on a Event in the background like when the data gets loaded, event studio was used for this.
• Automate various manual day to day reporting process done using excel
• Performance tuning of reports in production
• Handling day to day productions issues

Client: Confidential, Parsippany NJ 
Duration: February 2009 to March 2010 
Role: Cognos Developer
Environment: Cognos 10 / 8.3, ReportNet 1.1, Framework Manager, Oracle, SQL Server 2000, Windows XP

Company Description

Confidential USA LLC engages in the manufacture and supply of confectionery products in North America. The company was founded in 2003 and is based in Parsippany, New Jersey with a manufacturing plant in Rockford, Illinois, as well as an additional office in Toronto, Canada. Confidential USA LLC operates as a subsidiary of Cadbury plc.

Responsibilities
Cognos 10:

• Helped the admin group to install the C10 BI suite.
• Recreated the Cognos 8 reports using Active reports, upgraded other reports.
• Actively worked with IBM to resolve the issues with the new install.
• Created sample report dashboards for POC purposes.

Cognos 8:

• Gathered requirements from the different user groups, analyzed the requirements, created proper design documentations prior to development.
• Helped to set up the Cognos 8 environment (multi server install)
• Migrated contents from ReportNet to C8 using the deployment method.
• Fixed the migration errors, mostly involving JavaScript within reports, broken prompt pages and broken references to the packages and so on.
• Created and published Packages using Framework Manager, metadata modeling tool from various sources like IQDs and Erwin Models.
• Set up data level and package level securities.
• Created drill through between various reports in Report/Query/Analysis Studios.
• Developed C Level Dashboard focusing on the KPI trends over a certain time period.
• Developed complex reports using Tabular Joins, Pass through SQL
• Created map and combination chart reports to display geographical and graphical interpretation of the data.
• Conducted multiple sessions to train the end users on the usage of the self service reporting and the dashboards.
• Scheduled jobs based on database triggers in Cognos Connection.
• Familiar with development of Score carding and Metrics (KPIs) applications using Metric Studio.

ReportNet:

• Involved in analyzing and migrating contents from ReportNet to C8.
• Created Business detailed reports using Report Studio and ad hoc reports using Query Studio.
• Created reports involving dynamic sorting, dynamic grouping, conditional formatting, conditional variables, blocks, HTML items, hyperlinks.
• Created Complex reports using Tabular sets (Union, Intersect, Except), Tabular SQL
• Involved in Deploying the packages (exporting the packages) using the Deployment functionality under Cognos Connection Portal.
• Administered Security with Framework Manager (Data Access, Object Access and Package Access) using LDAP and NTLM.
• Troubleshooting the reports and documented the work for future reference.

Client: Confidential, San Diego, California 
Duration: October 2005 - January 2009
Role: Cognos Developer
Environment: ReportNet 1.1, Cognos PowerPlay Transformer, PowerPlay Enterprise Server, Oracle 9i, HTML and Windows 2000/NT.
Confidential, 
Headquartered in San Diego, California, is the largest component of Sony Corporation of America, the U.S. holding company for Sony\'s U.S.-based electronics and entertainment businesses. Project involved in design and development of data warehousing system for Sony Electronics. Designed and developed reports using the data model. Worked with the Sales and Manufacturing Departments of their several Products and generated various Reports like Custom Profitability Reports, Performance Plan Reports. 
Responsibilities

• Creation of standard filters, calculations and conditions for sales in different regions and different range of devices.
• Created advanced search using prompts to search for a particular product and products of particular range.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Developed Integrated Customer and Sales information System Data Mart.
• Responsible for designing and developing the sales reporting application.
• Extensively worked on understanding the business requirements and Involved in performance tuning for Reports.
• Developed Sales information system Cube, cube groups for this cube based on region.
• Extensively worked on PowerPlay Enterprise Server for cube deployment in Web.
• Coordinated in training sessions and demonstration of Cognos tools to End-users.
• Assisted users in troubleshooting their reports.