SUMMARY:

• Over 5 years of Data Warehousing experience using Cognos suite of products.
• Worked extensively on Cognos 8.4 including Framework Manager, Report Studio, Query Studio, Event Studio and Transformer.
• Experienced with Multiple Relational Databases including Oracle, SQL Server and Access.
• Involved in building models, projects and packages using Framework Manager.
• Created Adhoc and Standard reports as per user requirements using Query studio and Report Studio.
• Created Events and Alerts as per business requirements using Event Studio.
• Worked closely with Business users to understand the requirements to cater their reporting and multidimensional cubes.
• Exceptional problem solving skills.
• Good understanding of architectures and highly motivated to keep abreast with the latest BI technologies and trends.
• Effective communication skills and presentation skill.
• Able to work independently and collaboratively in Team environment. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

EDUCATION:

• Masters in Information Technology

TECHNICAL SKILLS:

Reporting Tools: Cognos Series 8 and 10 (Framework Manager, Report Studio, Query Studio, Event Studio Transformer) Cognos Series 7 
Programming/ Scripting Languages: SQL, PL/SQL, HTML
Databases: Oracle, DB2, SQL Server, MS Access
Operating System: Windows 7, XP, Vista

EXPERIENCE:

Confidential, RI Jan 2012 to Current
Cognos SCI Consultant

Confidential isthe leading independent national distributor of natural, organic and specialty foods and related products.
The Company currently distributes throughout the United States and to more than 40 other countries.

Responsibilities:

• Created Model using Cognos 8 Framework Manager.
• Set up User Classes, Users in Access Manager and defined their Membership to the Cognos content.
• Designed & Developed complex reports using Cognos 8.4.1 Report Studio.
• Designed & Developed alerts in Event Studio.
• Worked closely with the database team to optimize the reports.
• Involved in the requirement walk through with the Business Users/Analysts.
• Assisted end users build their custom Adhoc reports using Query Studio and also help them develop standard reports using Report Studio.
• Created Drill through report for providing detail level information.
• Exported/Imported report content from one environment to another.
• Was actively providing support for existing production reports and also addressed any issues on timely manner.

Environment: Cognos 8.4.1 (Report Studio, Query Studio, Event Studio), Framework Manager, Access Manager, DB2, Oracle, TOAD, WinSQL

Confidential, MA Feb 2011 to Dec 2011
Cognos Developer 

BJ's Wholesale Club, is a leading operator of membership warehouse clubs in the Eastern United States. The Company currently operates over 190 Clubs in 15 states from Maine to Florida and employs more than 24,000 Team Members.

Responsibilities:

• Created Data source connection in Cognos portal.
• Created Model using Cognos 8 Framework Manager.
• Created cubes using Cognos Transformer 8.4.1 and published the package to the cognos portal and built reports based on it.
• Created DMR for operational reporting requirement that provided up to date information about the membership of the company.
• Set up User Classes, Users in Access Manager and defined their Membership to the Cognos content.
• Designed & Developed complex reports using Cognos 8.4.1 Report Studio.
• Worked closely with the database team to optimize the reports.
• Involved in the requirement walk through with the Business Users/Analysts.
• Assisted end users build their custom Adhoc reports using Query Studio and also help them develop standard reports using Report Studio.
• Created Drill through report for providing detail level information.
• Exported/Imported report content from one environment to another.
• Was actively providing support for existing production reports and also addressed any issues on timely manner.

Environment: Cognos 8.4.1 (Report Studio), Framework Manager, Transformer, Access Manager, DB2, Oracle, TOAD, WinSQL

Confidential, Boston, MA Aug 2009 to Jan 2011 BI Cognos Developer 

Project's involved:

• Health Informatics Reporting (HIA)
• Online Benefits Reporting (OLB)

Responsibilities:

• Secured the Cognos Connection (Portal) to display content based on the user roles and permissions.
• Built Complex reporting using Parent/Child Tabular Model Concepts in Report Studio.
• Used Impromptu Query Definition (IDQ's) as data source for creating Multi-Dimensional Cube
• Created report based on Multi-dimensional cube.
• Developed complex prompting strategies.
• Create packages/models for Production and ADHOC reporting using the framework manager.
• Defined column joins dynamically in the framework manager based on the prompt selected by the user.
• Interacted with users to understand the ADHOC & production needs and develop report.
• Involved in optimizing & troubleshooting Cognos Reports & SQL queries.
• Provided documentations for the reports created.

Environment: Cognos 8.1 (Report Studio), Cognos ReportNet 1.1(Report Studio, Query Studio, Cognos Connection), Cognos Configuration, Framework Manager, Access Manager, Cognos Server Administration (Series 7), Oracle, DB2, WINSQL, Toad, Access, Mercury Quality Center

Confidential July 2006 to June 2009
Cognos Developer 

Responsibilities:

• Involved in Installing/configuring Cognos7.4 in the corporate IT infrastructure
• Build security for the power play cubes for clients.
• Created/updated catalog, Created Impromptu Reports, Drill through Reports, Power Play Cubes.
• Created Alternate drill downs in the required models.
• Created power play reports and cubes using Cognos version 7.1 and published in the web environment, Responsible for the defect free delivery and quality control for the whole project
• Formatted the reports as per the business requirements.
• Used the Drill Down/Up function to analyze data.
• Used Toad to populate tables, to write views on how data should be brought into the tables.
• Involved in testing the developed model and Reports for final deployment.
• Trained end users in working with Cognos user module provided technical expertise.

Environment: Cognos 7.4 , Cognos ReportNet 1.1 (Report Studio, Query Studio, Cognos Connection), Cognos Configuration, Cognos Query, Framework Manager, Access Manager, Impromptu Administrator, Cognos Server Administration, Power Play Enterprise Server, Oracle 9i, MS SQL server 2000, Windows NT, MS Office 2003.