PROFESSIONAL SUMMARY:

• EIGHT years of BI Business Intelligence experience gathering requirements and developing projects and reports for Financial, Telecommunication, Transportation, Retail and Insurance industries.
• Extensively used Cognos 10i product suite in recent projects.
• Expert in Production Support
• Strong experience in Cognos ReportNet Framework Manager, Report Studio.
• Knowledge of Cognos Metrics Manager, Notice Cast, Decision Stream.
• Used Scheduling tools Maestro and Appworks to schedule the jobs.
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
• Installed and configured various components, such as the Framework Manager and Content Manager.
• Expert knowledge in COGNOS BI Series Impromptu, Impromptu Web Reports, Upfront Portal, Access Manager and Power Prompts.
• Strong experience in Dimensional Data modeling, Star Schema/Snowflake modeling, FACT Dimensions tables, Physical logical data modeling.
• Involved in the full Project Life Cycle of the Data Warehouse Project.
• Exposure to client interaction and user-requirement analysis. Knowledge of SDK.
• Experienced in Ralph Kimball's methodology and Inmon's approach.
• Experienced in working Databases like Oracle, MS SQL Server 2000/2005/2008, DB2.
• Trained Business users for Ad-Hoc reporting
• Have excellent problem solving, time management skills, communication skill, good organizational skill, self-motivated, hard working, ability to work independently or cooperatively in a team and eager to learn.

TECHNICAL SKILLS:

• Cognos Suite: Cognos 10 8 BI 8.1, 8.2, 8.3 and 8.4 Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Report Net1.1 MR1, MR2, MR3 /1.02 Query Studio, Report Studio, Framework Manager, SDK , Cognos Impromptu, Power Play Transformer, Impromptu Web Reports IWR 7.x/6.x, Upfront Server Administration, Power Play Enterprise Server 7.x/6.x, Access Manager, Cognos Script Editor, Cognos Scheduler, Visualizer, Metrics Manager
• Data Modeling: Erwin 4.0/3.5
• ETL: Informatica PowerCenter, Power Mart, Data Stage, DTS, SQLServer Integration Services.
• Databases: Oracle 10G/9i/8i/, SQL Server 2008, SQL Server2005, Server2000, DTS, DB2, MS-Access.
• Languages: SQL, PL/SQL, UNIX Shell scripting.
• O/S: Windows7/XP, DOS.
• Other Tools: TOAD, SQL Loader, Maestro, Appworks

PROFESSIONAL EXPERIENCE

Confidential

Sr. Cognos BI Developer/Analyst

Symplicity specializes in database driven, web-based applications, enterprise information systems architecture and development, network design and management, systems and software engineering, network integration and management, information security and enterprise systems management.

Responsibilities:

• Developed complex DMR and relational models in Framework Manager Model.
• Performed Cognos administrative tasks including security, user accounts, software installations and deployments.
• Created filters within the Model for improving performance of the Model.
• Involved in Performance Tuning Deployment of Cognos Reports
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and multiple Prompts in Dash Boards.
• Created Dashboards for a better understanding of the business performance metrics by using Business Insight Advance, Active Reports.
• Used Analysis studio to drill down on cubes and perform business analysis
• Expert in Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio
• Used Cognos Connection to administer and scheduling reports to run at various intervals as well as the ReportNet Server.
• Bursting Reports and Multilingual Reports Using Report Studio.
• Provided day-to-day support for all COGNOS Report studio users.
• Communicated report development progress and issues to management and team members.
• Ensured compliance with standard software development practices, processes and enterprise standards
• Tested and validated the Report output against database to measure performance of reports.
• Managed Report Deployments from one Environment to another.
• Environment: Cognos 10.1 BI Report Studio, Query Studio, Active Reports, Analysis Studio, Business Insight Advance, Framework Manager, Cognos Connection, Cognos Power Play, Cognos Transformer, Cognos SDK, Access, Excel, MSSQL 2008, SSIS

Confidential

Cognos BI Developer/Analyst

Responsibilities:

• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various business's needs Folders, Filters, and Macros
• Design and Developed the Framework manager models using Store procedures, Relational tables, Views and published in to server.
• Designed Reports using most of the Report studio features Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through,Drill Down ,Drill Up .
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports using Cognos.
• Created complex Dashboards with Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio
• Used Analysis studio to drill down on cubes and perform business analysis
• Expert in Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio
• Created prompts, Calculations, Filters, Developing Prompt pages and Conditional Variables using Report Studio.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Provided day-to-day support for all COGNOS Report studio users.
• Assist in end user acceptance testing.
• Worked on complex reports using Tabular Objects, Static Prompt conditions
• Environment: Cognos 10.1 BI Report Studio, Query Studio, Active Reports, Analysis Studio, Framework Manager, Cognos Connection, Cognos Power Play, Cognos Transformer, Cognos SDK, Access, Excel, MSSQL 2008, SSIS

Confidential

Cognos Developer

Responsibilities:

• Created views in the SQL Database for complex reports.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Trained Users on Query Studio for Ad-Hoc Reporting.
• Developed Prompt pages and Conditional Variables.
• Developed Multi Page Reports.
• Created Query Prompts, calculations, Conditions Filters.
• Developed Dashboard reports in Business Insight, Business Insight Advance and Active Reports.
• Developed Standard Reports, Charts, Drill-Through Reports, and Master Detail Reports using Report Studio.
• Created Cube for Multidimensional analysis for BI Analytics Department for quick approach to drill-down and drill-up through various levels of data.
• Created Embedded/Standalone Filters within the Model for improving the performance of the Model
• Worked extensively on creating the Model and publishing the package on Cognos Connection for Reporting purposes.
• Designed the Model according to the Business Requirements by creating a Presentation Layer.
• Actively involved with the business users and Development teams for gathering information for creating the Framework Model.
• Environment: Cognos 8.4 BI Suite, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, SAP BW, MS SQL Server 2005, Oracle 10g, Microsoft Access, Microsoft Excel.

Confidential

Cognos Developer

Responsibilities:

• Set-up, maintain, monitor, and support Cognos security groups and accounts.
• Created Various Complex and Simple Impromptu Reports and published reports to Upfront. Involved in Creation of Simple Reports using Cognos Query.
• Created various Cubes in Power Play Transformer and created various reports related to Cubes in Analysis Studio and Cognos Power Play.
• Created Models in Frame work manager. Created various filters and calculations in framework manager models.
• Expert Migrating catalogs into report net using migration utility
• Expert in Migration of Impromptu Reportset to Cognos ReportStudio
• Worked on Security permissions in Cognos Connection portal at Package Level, giving permissions to end users for report studio and query studio, Object Security at Frame work Manager Level.
• Scheduled Reports using Scheduling Management. Configured Email Server Information at Production and Development Servers.
• Deployed Models and reports from Development Server to Production Server using Content Administration.
• Improved Performance of Reports and Trouble Shooting of various issues at Servers, Cognos Connection Portal and reports.
• Used Data Stage to Perform ETL process.
• Environment: Cognos8 BI MR2, Toad 9.0.1.8, Oracle 9i, Cognos Series 7 Version 2, Impromptu 7, Power Play 7, Access Manager 7, Data Stage

Confidential

Cognos BI ReportNet Developer

Responsibilities:

• Involved in Installing and Configuring ReportNet Server, FrameWork Manager.
• Configured Cognos8 with Cognos 7 series Namespace to integrate security.
• Involved in understanding the Business in all Departments.
• Involved in Strategic Planning for Cognos ReportNet Framework Model.
• Built Models and published Packages utilizing Framework Manager.
• Created database connections for different data sources.
• Created Reports Simple Complex using QueryStudio and ReportStudio for training purpose.
• Created, organized and formatted reports, folders and other contents on Cognos Connection portal.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Environment: Cognos ReportNet 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Microsoft Access, Excel, Appworks, Oracle 9i, MS SQL Server 2005

Confidential

Responsibilities:

• Developed and design an e-commerce Business infrastructure with Software Development Lifecycle, supply chain issues, and managerial functions with strategic planning.
• Created a research project on the avoidance of Network Downtime, Focus on bandwidth management and load balancing in corporate networks.
• Research material contained variety of devices including load balancers, and algorithms.
• Troubleshoot and maintain software utilities and programs.
• Prepared internal and external reporting materials for Senior Management meetings.
• Developed reports, charts, and project schedules required to support the Planning and Scheduling Team work.
• Environment: Microsoft Access, Excel, MS SQL Server 2000