Professional Summary:

Oracle certified Business intelligence professional with 5+ years of experience in Software Development using COGNOS 8.4 BISuite for Retail, PLM, Travel and Spend management and Digital Publishing applications
Highly Organized and excellent multi-tasking skills. Able to work independently and manage projects in parallel and experience in complete SDLC cycle.

Expertise in:

• Advanced Reporting using OLAP tool, Cognos 8 BI Suite- Report Studio, Query Studio, Analysis Studio
• Creating projects, models, Packages and publishing the packages in the Framework manager using various data sources.
• Cognos Administration
• Deployment of reports from QA to Production environment
• Bursting Reports for the planned and requested schedules
• Building multidimensional cubes using Cognos Power play Transformers
• Unit testing, Cross testing of Cognos reports
• Knowledge on Cognos Cafe, Cognos TM1.
• Developing database objects like Views, functions using Oracle (SQL, PL/SQL)
• Defect tracking tools like Rational- ClearQuest & Bugzilla
• Test management tools like HP-Quality Center
• Performing SQL operations using DDL statements
• Data verification using DML statements
• Practical understanding of data-warehousing (DW) and BI Design best practices and techniques
• Knowledge on VMware, MS Excel Pivot table
• Ability to work in a fast paced agile environment

Domain:

Retail, PLM, Travel and Spend Management, Digital Publishing

OLAP Tool:

Cognos8.4 BI Suite - Report Studio, Query studio, Analysis Studio, Framework Manager, Power Play Transformers, Cognos TM1

Database tools:

Oracle (SQL,PL/SQL), TOAD, SQL Server 2000/2005, Sybase, MS Access

Defect Tracking Tools:

Rational Clear Quest, Bugzilla 2.18, Jira3.1

Test Management Tools:

HP Quality Center 10.0

Other Tools:

Visual Source Safe, Rational- Requisite Pro.

OS Environments:

Windows 98/NT/2000/XP/7/Vista,Windows 2000/2003/2008 Server.

• Bachelors of Engineering (Computer Science).
• Oracle certified Associate (OCA) from Oracle Corporation.

• Awarded by “Hall of Fame Award” for the year 2008 for leading performance and developing the most complex report development for Century21, NY.
• Recognized and rewarded by “Going the Extra Mile” Award in project- Motricity.
• Honored by “Hall of Fame Award” for completing the critical & complex testing phase for project -Concur
• Award of Achievement certificate from SQL STAR INTERNATIONAL LIMITED, Bangalore for successfully completing the ORACLE Workforce Development Program in SQL and PL/SQL.

Professional Experience:

Client: Confidential,October 2011 PRESENTSan Francisco, CA

Senturus is an authority in crafting and implementing Business Intelligence and Planning solutions. Since 2001, Senturus has delivered full system solutionsinitiating a full IBM/Cognos suite to over 500 companies nationwide.

Project: Sephora(Retail Reporting)

Confidential, offers the largest and most diverse selection of beauty products on the Internet. From classic to hard-to-find brands to our own private label, Sephora Brand, you have easy access to over 13,000 products and more than 200 brands.

Responsibilities:

• Work with customers to gather requirements for projects.
• Ability to transform business requirements into deliverables with minimal supervision.
• Building the Cognos solution to meet product/project specific requirements
• Provide development and production support for the Analytics environment for Cognos.
• Author complex Report Studio reports working with the business customers
• Design and develop Business Intelligence reporting solutions
• Develop and maintain technical documentation

Technologies Used:
Cognos 8 BI Suite (Query Studio, Report Studio), Cognos Connection,SQL Server, Cognos Framework Manager.

Digital Publishing and Marketing Services

Confidential, is revolutionizing reading. With over 50,000 digital magazines and books, and e-stores localized in 15 languages, Confidential,.com is the largest online newsstand in the world. For consumers, Confidential, enables the ability to shop for, search inside, read, share and save digital content in new ways and on many devices.

Responsibilities:

• Analyze functional specifications to help determine design approach and creating the report page template
• Framework Manager Design - creating the projects, determining the Framework manager Model requirements for each report to be developed, including the query subjects and creating the relationship between them according to the requirement.
• Creating the packages and publishing in the framework manager using various data sources
• Used Cognos Transformer to build multidimensional cubes and used it in Cognos Power Play to build lists/ graphs and charts of Growth Market Sales Data
• Publishing the Power play Cubes using the Framework manager.
• Developing the Cognos reports using the Multidimensional cubes and also using Relational model.
• Have developed reports using Report studio, Query studio (Adhoc requirements).
• Bursting of reports for all the publishers’ publications and placing the bursted files using WINSCP which is accessible to all the Publishers.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Deployment of reports from QA to Production environment.
• Raised Cognos tickets to IBM support and continuous interaction till it is resolved.
• Used Query Explorer to create or modify queries and to perform complex tasks, such as defining Union, joins and writing SQL statements
• Participated in User Acceptance Testing for the reports developed and reported defects.

Technologies Used:
Cognos 8.4 BI Suite (Query Studio, Report Studio), Cognos Connection, Oracle (SQL, PL/SQL), Cognos Framework Manager, Powerplay Transformer, WINSCP.

Client: Confidential,

Advanced Retail Reporting

Advanced Reporting helps the organization to improve their ability to make timely, informed decisions in all areas—store operations, marketing, merchandising, IT and finance to align their corporate and store operations around critical revenue and profitability targets; and quickly adjust plans and resource allocations to achieve profitable growth. Also helps us to analyze key controllable expenses, and return on net assets.

Responsibilities:

• Analyze functional specifications to help determine design approach.
• Database
• Performing all SQL statements like Data Retrieval (Select), DML(insert, update, delete, merge) ,DDL (create alter, rename, truncate),Transaction Control(Commit, Rollback)
• Creating the Views and Functions using Oracle SQL, PL/ SQL.
• Using Cursors, Triggers in the PL/ SQL block of functions.
• Analyzing the explain plan when query is executed.
• Database design
• Creating Views and Functions using Oracle SQL, PL/SQL for the report package according to the report requirement.
• Creating Materialized Views for complex reports for the better performance of the reports.
• Framework Manager Design - creating the projects, determining the Framework manager Model requirements for each report to be developed, including the query subjects and creating the relationship between them according to the requirement.
• Creating the packages and publishing in the Cognos framework manager using various data sources.
• Report Design:
• Developed reports using Cognos Report Studio, Query Studio (which includes prompt page(s) and report page(s)) and Analysis studio.
• Created reports with prompts, cascading prompts for filtering out the data, filters and conditional formatting,
• Master-Detailed relationship.
• Creating Drill-through for lists and graphs with the same report as destination report and as well as with other reports.
• Created lists, cross tab, drill-through, reports that have multiple conditional blocks in the report page andalso reports in different formats like PDF, XML, HTML and CSV.
• Customized data by adding calculations, summaries and functions.
• Involved in importing and exporting of data (reports/package) from development to production using the deployment option in the Cognos connection portal.
• Created jobs and scheduled reports using schedule management tool to run daily/weekly and monthly basis and sending reports and report links to users through email.
• Worked on the change requests/patch comments timely.
• Performed Unit testing and benchmark testing for the reports.
• Handled the issues through the migrating reports process from Cognos 8.2 to Cognos 8.4.
• Creating the Cognos Specification Document (CSD) for the reports
• Presentation given for the various reports, a part of the internal training.
• Presentation given on various technical topics related to Cognos and Oracle.

Technologies Used:
Cognos 8.4 BI Suite (Query Studio, Report Studio, Analysis Studio), Cognos Connection, Oracle (SQL, PL/SQL), Cognos Framework Manager.

Client: Confidential, Role: Senior Cognos DeveloperDuration: 03/2007 - 10/2008

OMS Reporting

To analyze sales and item movement data to understand demand, optimize staffing levels, and improve in stock position, Cognos reports help us to analyze financial goals in terms of growth, profitability, key controllable expenses, and return on net assets.Reports covered areas like Product Information, Order Entry and Customer Service, Financial Processing, Retail sales, Gross Margin, Aggregated Orders, Cancellation, Supplier Order, Backorders, Data Analysis and Reporting, Financials etc.

Responsibilities:

• Analyze functional specifications to help determine design approach.
• Framework Manager Design - creating the projects, determining the Framework manager Model requirements for each report to be developed, including the query subjects and creating the relationship between them according to the requirement.Creating the packages and publishing in the framework manager using various data sources.
• Developed reports using Cognos Report Studio, Query Studio which includes prompt page(s) and report page(s).
• Performing all SQL statements (Oracle SQL, PL/SQL) during the development and also during the verification phase in order to see the correctness of the data displayed for the requirement.
• Created reports with prompts, cascading prompts for filtering out the data, filters and conditional formatting.
• Involved in developing reports with Master-Detailed relationship.
• Created lists, cross tab, drill-through, reports that have multiple conditional blocks in the report page and also reports in different formats like PDF, XML, HTML and CSV
• Customized data by adding calculations, summaries and functions.
• Creating Drill-through for lists and graphs with the same report as destination report and as well as with other reports.
• Worked on internationalization of the reports and also handled the issues when migrated from Cognos 8.3 to Cognos 8.4.
• Worked on the change requests/patch comments timely
• Performed Unit testing and benchmark testing for the reports.
• Creating the Cognos Specification Document (CSD) for the reports
• Presentation given for the various reports, a part of the internal training.

Technologies Used:
Cognos 8.4 BI Suite (Query Studio, Report Studio, Analysis Studio), Cognos Connection, Oracle (SQL, PL/SQL), Cognos Framework Manager.

Client:Confidential, Role: Cognos DeveloperDuration: 11/2006 -10/2007

Concur Travel and Expense Management

Confidential,is a leading provider of integrated travel and expense management solutions. By capturing and reporting on every aspect of Travel & Expense spend, Concur’s services provide detailed information to help clients effectively negotiate with vendors, create budgets and manage compliance.

Responsibilities:

• Analyze functional specifications to help determine design approach.
• Understand Business Requirement and Functional Requirement Specification for the report design approach.
• Creating Expense and Travel related reports with respect to various requirements from the business stakeholders.
• Designing the reports using Cognos Report studio and Query studio.
• Creating models, packages using Cognos Framework Manager. Publishing the Model packages from Framework manager so that it has to appear in Cognos connection for reporting.
• Database Verification using SQL queries (SQL server 2000/2005).
• Conduct internal product trainings
• Units testing of the reports developed.
• Cross testing of team members\' reports.
• Attend conference calls with business users and analysts to clarify the requirements.
• Logging the defects using Quality Center.
• Fixing the defects and validating the same.

Technologies Used:
Cognos 8 BI Suite (Query Studio, Report Studio), Cognos Connection,SQL Server 2005, Cognos Framework Manager, Quality Center.

Client: Confidential,| Role: Cognos DeveloperDuration: 12/2005 -11/2006

Consumer Products and Services

Confidential, is a leading provider of relevance-driven mobile merchandising, marketing, and advertising solutions, enabling mobile operators, enterprise brands and advertising agencies to deliver mobile optimized, consumer-centric experiences that drive interaction, content consumption and commerce across the mobile ecosystem.
Consumer Products: eReader Librarian, eReader.com, eReader Pro, ebooks.palm.com, palm.com

Responsibilities:

• Designing and developing BI applications using IBM Cognos BI Suite
• Analyzing the functional specification document for report design.
• Creating reports using Cognos Report studio in order to track the details/sales w.r.t their consumer products.
• Creating List reports, Crosstab reports and Charts.
• Creating the framework manager projects and publishing the same.
• Consult with business analysts, data base engineers and designers on procedures pertaining to new and existing reports.
• Performed Unit testing of the Cognos reports.
• Database Verification using SQL queries.
• Logged bugs using Bugzilla. Fixing the defects and verify the same.
• Ensure quality and integrity of all reports. Document all processes.

Technologies Used:
Cognos 8 BI Suite (Query Studio, Report Studio), Cognos Connection,SQL Server 2000, Cognos Framework Manager, Bugzilla.