SUMMARY

• Over 12 years of overall experience and 7+ years in Cognos Business Intelligence
• Expertise in Cognos BI Modeling and Report Authoring using Cognos 10.2 10.1 8.4 8.3,8.2 Suite, Cognos Series 8.0 and Cognos Report net
• Extensive Experience in Design Framework Model (Database Layer/Business Layer/Presentation Layer), DMR Model using Cognos 8 Framework Manager
•  Cognos Analyst Developer gather requirements, design, develop
• Experience in advanced reporting like List, Cross tab, Repeater, charts and Dashboards using cognos8 report studios and ad hock reporting using cognos 8 Query Studio. Administrators with the Modify All Users and Modify All Resources rights can also change any Cognos domain user password, where as non - admin Cognos
• Good exposure in Interacting with Business users to get requirements, to fix issues or train users on ad-hoc reporting. Expertise in design and reports including Dashboard reports development of highly complex query
• Experience in design, development, maintenance and support of Cognos Reports
• Planned / constructed OLAP models and Cognos Transformer Cubes using Transformer
• Experience in EDI implementation practices, data flows of electronic documents
• Working knowledge of Relational Databases - Sybase, Microsoft SQL Server

SKILLS:

BI TOOLS: Cognos 8.1/8.2/8.3/8.4/8.4.1 10.1 BI(Report Studio, Query Studio,Analysis Studio, Framew Manager, Metric manager, Cognos Connection),Cognos Series 8(Impromptu, Power Play, Transformer Upfront), Access Manager,Report Net 1.1 MR3, MDXMigration Tools: MigS7,Mig Deploy

Operating Systems: Windows 2000/2003/ Vista/ 2008, Windows 7

Software Packages: MS- Office, Microsoft Word, Excel and Power Point vision

Databases: MS SQL Server 2005/ 2008, Oracle 11g,10g/9i/8i/7, MS Access

Database tools: SQL*Plus 3.3/8.0,PL/SQL Developer Load

Data Modeling: Physical and logical, Star schema, snowflake schema, Normalization.
EXPERIENCE HIGHLIGHTS:Confidential, Albany, NY

Cognos Developer/Admin

• Transformer build cube for Report Analysis Studio and Report Studio
• Created Drill Through reports and Conditional Formatting by using Report Studio
• Created reports like List, Cross tab and Dashboards by using Report Studio
• Extensively worked on complex reports, drill through reports, master detail reports, conditional prompts. Developed Multi Page Reports
• COGNOS 10.1 10.2 SQL Server 2008, Oracle 10g 11g

Confidential, NJ

Cognos Developer

Responsibilities:

• Participated in discussions with the senior management to create the business requirements,  Cognos Architect design, develop
• Work with project managers, Business Analyst and end users to understand business requirements and translating them to technical specifications
• Oversee transition from Cognos 8.2 8.4.10.1
• Creating/updating Relational Model and publishing packages using Framework Manager
• Apply OLAP functionalities, drill-down/drill-up in Analysis Studio and Report Studio
• Involved in designing and creating various reports in Report Studio.
• Customized data by adding filters at Report level.
• Worked extensively with report distribution using bursting
• Experience in Developed business intelligence Dashboard report for application portfolio.
• Created different types of reports like List, Cross-tab, Chart Drill-Thru, Master Details, cascading prompts
• Created Business views, namespaces, model query subjects in Framework Manager Model for easier report development and to enhance multi user environment.
• Proven experience in building Complex Reports using prompts and parameters in Report
• Extensive use of conditional formatting while developing reports in Report Studio
• Cognos Multidimensional Cube development using Cognos transformer and Report generation on Cognos cubes.
• Involved in creating OLAP hierarchy, Dimensions, formulas & power cubes using Transformer and published the Cubes.
• Power Play reports were created from the various Cubes created for the user. Explorer and Reporter reports were created based on the requirements of the user and the project.
• Worked as a team towards finishing the tasks and achieving project deadlines.

Environment: Cognos 8.4/8.3/8.1 (Framework Manager, Report Studio, Query Studio, Transformer), Oracle 10g.

Confidential, New York, NY

Cognos Developer/Admin

Responsibilities:

• Worked in building Relational models and multi Dimensional packages and published packages to Cognos Connection using Frame Work Manager and created daily, weekly and monthly reports using those packages
• Created different types of reports like List, Cross-tab, Chart Drill-Thru, Master Details, Cascading using different prompts
• Created Drill Through reports and Conditional Formatting by using Report Studio
• Ensured the quality of the data and reviewed it periodically, planned strategies to ensure the data quality on the Framework Manager
• Maintained and generated complex reports with the help of Cognos 
• Upgrading the software according to the business requirements from 8.0 to 8.4.
• Performed Cognos administration, creating user accounts and roles using Access Manager
• Built and maintained Cognos reporting security
• Processed, summarized data in the application layer and generated summaries of data 
• Debugged the reports and Cognos Metadata
• Extensively worked on complex reports using tabular sets, drill through reports, master detail reports, conditional prompts. Developed Multi Page Reports
• Developed Prompt pages and Conditional Variables. Authored numerous reports in Cognos Studios, customize prompts/reports and developed several custom Cognos SDK applications Created and Schedule.

Environment: Cognos 8.1/8.3, Framework Manager, Cognos Connection, Report Studio, Query Studio, SQL Server 2005, Windows XP/ 2000.

Confidential, Boston MA

Cognos Developer

Responsibilities:

• Analyzed Business functional requirements and documented technical specifications.
• Created Packages with various security settings and published to Cognos Connection.
• Created Framework Manager Packages defining the cardinalities and namespaces
• Modeled Metadata and add business rules such as filters and calculations.
• Implemented Cognos 8 distributed environments
• Developed Dimensional Models for Cognos 8 Analysis Studios, Migrated Power Play cubes to Cognos 8 Framework Manager
• Created DMR models in framework manager in order to create multidimensional reports in analysis studio and report studio
• Defined security over packages, package level access and object level access to allow users to create calculations over the query items. Created Roles and Groups and assigned permissions to users in Cognos Name space for security
• Migrated Power play 8.0 Cubes to Power play 8.1
• Reviewed the existing Impromptu environment and made the necessary changes to them so that the migration to Cognos 8 would be successful
• Subject Matter Expert in designing the migration strategy from Impromptu to Cognos 8
• Developed complex reports in report studio in PDF and EXCEL format to meet the specifications given in the business requirements.
• Integrated various conditional prompts, cascading prompts, conditional variables in the report. Developed Prompt pages and Conditional Variables.
• Created multipage reports with master-detail relationships, Query Prompts, Calculations, Conditions & Filters
• Recommended Indexes to improve the performance of the report.
• Used conditional formatting to discard the unwanted columns in the report.
• Created Public, Private Folders, My pages and custom views in Cognos Connection.
• Securing Cognos Connection and setup Cognos security by assigning users to the groups and roles defined in Cognos Namespace.
• Implementing the plan to migrate from Cognos 8.1to Cognos 8.2

Environment: Cognos Series 8.0 (Report Studio, Analysis Studio, Framework Manager Query Studio), Oracle 9i, Microsoft SQL Server 2005/2008

Confidential, CA

Cognos Developer

Responsibilities:

• Participated in discussions with the senior management for business requirements
• Created different Data sources and Created model using different Data Sources and created packages and published to Cognos
• Created Drill Through reports and Conditional Formatting by using Report Studio.
• Created reports like List, Cross tab and Dashboards by using Report Studio
• Extensively worked on complex reports using tabular sets, child tabular models, drill through reports, master detail reports, conditional prompts. Developed Multi Page Reports. Technology experience including Data Warehouse Design, Analysis, Architecture, Dimension Modeling, Business Intelligence strategy, Development, Testing, Implementation, Training and Documentation.
• Created user groups, Roles to implement the Cognos security using Access manager.
• Customized Cognos Connection.
• Created the documentation for cubes & Reports. Testing and Validating the Reports
• Managed Scheduling of Reports
• Customized data by adding Calculations, Filters, Prompts and Governor Settings.
• Production Support which involves solving user problems.

Environment: Cognos (Framework Manager, Cognos7.0 Connection, Report Studio, Query Studio), SQL server 2005.

Confidential, Denton, Texas

PC/Desktop/Network Support Specialist

• Respond to user support requests in Track-IT. Maintain PC/Laptops images, maintain hardware, supplies and software inventories. Setup new employees' hardware, software, access permissions, upgrade and replace old hardware, repair and maintain existing hardware. Support Windows XP, Vista, Windows TCP/IP networking, minor LAN hardware architecture (link speeds, NIC configuration), PC hardware installations (ie. CD-ROM drives, video cards, RAM Sims etc) local and network printer installation and configuration, and troubleshoot and diagnose issues with all the workstations issues
• Experience utilizing Remote Desktop, Team Viewer 5/6, UltraVNC 1.0.8.2 and Log Mein 4.1.13 to solve hardware and software issues. Review and make recommendations for standard corporate computing system hardware. Troubleshoot and identify issues related to application deployment and address them directly or through coordination with other teams. Virtualization of applications

Confidential, Austin, Texas

Manager

• Purchasing and Selling Foods, Auto Parts also Managing 13 Employees, Inventory Control, Book keeping, Banking and also dealing with the Customer. Also
• Provides technical support for Desktops/Laptops and associated networks. Installs, troubleshoots, services, and repairs personal computers, network equipment such as servers, modems. Provides personal computer/Laptops hardware and software support. Installs, services, and repairs personal computers and installs attendant software. Connects personal computers and terminals to existing data networks.
• Maintains trouble logs. Instructs users in the use of personal computers and networks. Investigates information, network, and communications needs of users, and makes recommendations regarding software and hardware purchase
• Maintain PC images, maintain hardware, supplies and software inventories. Setup new employees' hardware, software, access permissions, upgrade and replace old hardware, repair and maintain existing hardware

Confidential, Sunnyvale, CA

• Technician in a Fabrication area; wafer aligning and use of chemicals, Computer Programmer.