SUMMARY:

• 9 years of experience in IT Industry in which 6 yrs experience in Business Intelligence tools like Cognos 8.4/Cognos 10.2 - (Report Studio, Query Studio, Analysis Studio and Framework Manager) Cognos 7.3 - (Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay, Transformer, PowerPlay Enterprise Server(OLAP), Upfront and Access Manager)
• Extensive exposure to various business sectors such as Telecom, Finance and Healthcare.
• Expertise in interaction with business users and as per their requirements, analyzed, designed and generated business reports.
• Extensive experience in Designing and Development of OLAP Models using Cognos Powerplay Transformer
• Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.
• Exposure to requirements gathering, design, coding, testing, and implementation
• Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Involved in24*7 production supporton reporting
• Experience in other reporting tool like Business Objects 6.5
• Experience with full life cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting system
• Having Good knowledge on data warehouse concepts
• Having knowledge in Tableau, Cognos TM1 9.5.2 and SSRS reporting tool
• Experienced with Multiple Relational Databases including Oracle, DB2 and SQL Server
• Experience in understanding and working with On-site Off-shore environment
• Excellent skills to analyze business needs, hardworking and result oriented as an Individual and in Team

TECHNICAL SKILLS:

OLAP Tools: Cognos 8x/10.2.1(Framework Manager, Query Studio, Report Studio, Analysis Studio, Cognos Connection, Cognos Workspace & Cognos Workspace Advanced)Cognos 7.3(Impromptu, PowerPlay, PowerPlay Transformer, PowerPlay Enterprise Server, Cognos Upfront, Access Manager), Business Objects 6.5 (Designer, Supervisor, Web Intelligence, BCA)

ETL: Informatica 8.x(Repository Manager, Designer, Workflow Manager, Workflow Monitor)

Job Scheduler: Tivoli 1.3/8.3

Database: MS-Access, Oracle 9i/10g/11g, SQL Server, DB2, Composite 6.2

Web Technologies: HTML, IIS 7

Operating Systems: Windows 7 Ultimate/NT/2000/2003 Server

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Environment: Cognos 10.1/10.2.1 (FM, Cognos Administration, Query Studio, Report Studio and Cognos Connection), Composite 6.2 and Oracle 11g

Responsibilities:

• Responsible to understand the business requirements of the customer
• Create and maintain installation documentation and architectural diagrams(physical, logical & dataflow process)
• Dealing with Tickets through HP-ALM
• Good in trouble shooting with quick turnaround in fixing the issues
• Perform Report package deployments
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports
• Identify, escalate and document production impact issues for the environment to confirmed
• Performed Admin task for user permissions, scheduling the reports
• Creating various jobs to clear the cache for prompt
• Organizing folder structure in Cognos connection
• Create report view/shortcuts
• Worked on performance tuning of existing reports and Supported various existing applications in production environment
• Doing Unit testing of Reports based on the BRD

Confidential, Denver

Environment: Cognos10.2.1(Framework Manager, Query Studio, Report Studio, Analysis Studio and Cognos Connection), Informatica 8.6 and SQL Server 2008

Responsibilities:

• Responsible to understand the business requirements of the customer
• Created Groups and Users and assigned privileges to the groups
• Responsible to provide resolution to all the Sev - 1 &Sev - 2 incidents.
• Dealing with Tickets through REMEDY & IPCenter
• Interaction with clients/business analysts to gather requirements of Change Request (CRs)
• Understanding existing business model and customer requirements.
• Created the reports using Cognos Report Studio. Functionalities like Queries, Drill Up, Drill down, Cross Tab, Master Detailed reports.
• Dealt with relational and dimensional model
• Created Active Reports using Data Button & Data Toggle Button Bar
• Created cascading prompts, drill through and exceptional highlighting facilities in report studio
• Created filters, calculations and prompts
• Creating various types of prompts in the prompt page
• Incorporated Layout Component in the new reports
• Implemented standards in Report design and appearance by following set of predefined rules while applying colours and fonts styles to the report structure
• Doing Unit testing of Reports based on the Report requirement specification
• Involved in report formatting and enhancing the exist reports as per client requirements

Confidential

Environment: Cognos 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio and Cognos Connection)and DB2

Responsibilities:

• Developed Complex Reports having many calculations, joins, unions, Conditional blocks, variables etc, using Report Studio.
• Created complex cross tab, Parent-Child reports to evaluate the business performance tasks
• Developed Complex Reports using Report Studio including conditional blocks, conditional formatting
• Developed reports for Exception Highlighting and Hiding sensitive data using Condition Variables
• Developed Dash Board Reportsbased on the requirement
• Burstingthe Reports in Cognos Environment and sending by mail
• Created multi page report based on multiple queries using Prompts and Parameters.
• Scheduled and distributed reports using Schedule Management in Cognos Connection
• Tested and improved Report Performance
• Interacting with the client on a regular basis
• Adding Users and assigning the users to groups.(Assigning Security)

Confidential, Sanjose

Environment: Cognos 8.2 (Framework Manager, Query Studio, Report Studio, Analysis Studio),Cognos 7.3( Impromptu, Cognos IWR, PowerPlay Transformer, PowerPlay, PowerPlay Enterprise Server, Upfront)and Oracle10g/11g.

Responsibilities:

• To make a Review and Create the Estimate for the assigned Request and then Analyze the Project plan.
• Interacting with Business Users for gathering Business Requirements to develop the reports
• Understanding existing business model andrequirements.
• Creating and Publishing packages to Cognos 8 Environment
• Created reports with customized data with calculations, filters and summaries
• Created ValuePromptsand Text Prompts to filter the Data in Report Studio
• Developed list, crosstab, chart, and complex reports involving multiple prompts, filters, multi-query reports using Report Studio
• Developed reports with Master-detail and Drill-through functionality to link one report to another
• Developed reports with various prompts including Cascading Prompts to dynamically select the values by the user
• Design, development, testing, and documentation of new Cognos reports and cubes
• Created Reports for Analysis and Decision Making using Impromptu 7.3
• Created IQD files in Cognos Impromptu 7.3 to build requiring Power Cube
• Created and Maintained Multi Dimensional Power Cube using CognosPowerPlay Transformer Model
• Deployed Cubes and Reports on PowerPlay Enterprise Server and also Published to Upfront
• Provided support to projects for new applications / report needs
• Maintenance and support of existing Cognos reports and cubes

Confidential, Sanjose

Environment: Business Objects 6.5.4 (Designer, Supervisor, Web Intelligence, BCA), Oracle 9i and Informatica 8.1

Responsibilities:

• BO User administration - Creation, password reset, Deletion, Granting and revoking user access in BO Supervisor
• Maintenance of Universes and implementing change requests in BO Designer
• Management of Categories in BO Supervisor
• Monitoring and support of reports scheduled in the Broadcast Agent
• Bug fixing of user-created reports
• Basic Server Maintenance and administration