SUMMARY:

• Expertise in Framework Manager Cognos BI and Created, modeled and published packages in Framework Manager from multiple databases for use with Report Studio, Query Studio and Analysis Studios.
• Report Authoring using Cognos 10.2.2 10.1 8.4 8.3 , 8.2 Suite, Cognos Series 8.0 and Cognos Report Studio, Query Studio and Analysis Studio.
• Cognos Analyst Developer gathers requirements, design, develop.
• Good exposure in Interacting with Business users to get requirements, to fix issues or train users on ad - hoc reporting.
• Development, maintenance and support of Cognos Reports. Cognos Transformer Cubes using Transformer
• Working Confidential Cognos knowledge of Relational Databases - Sybase, Microsoft SQL Server, and PL/SQL.
• Knowledge on Tableau, Active Report Cognos version 11.
• Initial Security set of security objects is created and stored in the Cognos user account, the groups All Users and Everyone, Report Studio.
• Examples of the secured features are User Defined SQL and Bursting Secured Functions and Features.
• Distribution Lists and Contacts on the Configuration tab in Confidential Cognos Administration to manage distribution lists and contacts.
• Capabilities and User Interface Profiles on the Security tab in Confidential Cognos Capabilities and User Interface Profiles on the Security tab in Confidential Cognos Administration to manage the secured functions and features and the Report Studio user interface profiles.
• Scheduling functionality for items that can be run, such as reports.
• Allowing users access to the object, denying users access to the object, or keeping it hidden from all users.
• Experience in working with various databases that include Oracle, SQL Server Databases.
• Strong knowledge on Data Warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Thorough understanding of System Development Life Cycle (SDLC) experience from requirement analysis through Design & Development.
• Versatile industry experience in Finance, Marketing, Retail, Chemical, Insurance and Sales.
• Strong Analytical skills, Details - Oriented and ability to multi-task.
• Self motivated, creative, work with minimal supervision, debugging and crisis management.
• Excellent interpersonal and oral and verbal communication skills.

TECHNICAL SKILLS:

BI Tools: Cognos 8.1/8.2/8.3/8.4/8.4.1 10.1 10.2.1 10.2.2 BI (Report Studio, Query Studio, Analysis Studio, Frame Manager, Metric manager, Cognos Connection),Cognos Series 8 (Impromptu, Power Play, Transformer Upfront).

Migration 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

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

Data Modeling: Physical and logical, Star schema, snowflake schema, Normalization.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Cognos Developer/Tableau Developer/Power BI

Responsibilities:

• Tableau Developer, Data Visualization, Watch the drivers when they do the delivery how many deliver are done.
• Working with various databases that include Oracle, SQL Server Databases.
• Development, maintenance and support Administration to manage distribution lists and contacts.
• In Cognos Report Studio using prompts and parameters in Report, Microsoft Word, Excel.
• Testing and Validating the Reports.
• Create a security filter and apply it to a specific query subject.
• Administrators with the Modify All Users and Modify All Resources rights can also change any Cognos domain user passwordProfessional Experience:

Confidential, New Orleans, LA

Sr Cognos Report Developer

Responsibilities:

• Report Studio Involved in designing and creating various reports in Report Studio.
• Creating/updating Relational Model and publishing packages using Framework Manager
• Created reports like List, Cross tab and Dashboards.
• Created, modeled and published packages in Framework Manager from multiple databases for use with Report Studio, Query Studio and Analysis Studios.
• Developed, maintained and supported Cognos Reports, Data Visualization.

Environment: Cognos 10.2.2 Oracle 11g.

Confidential, New Orleans, LA

Cognos Report Developer

Responsibilities:

• Report Studio Involved in designing and creating various reports in Report Studio.
• Authored report using Cognos 10.2.2 10.1 8.4 8.3 , 8.2 Suite, Cognos Series 8.0 and Cognos Report Studio, Query Studio and Analysis Studio.
• Experience in Project life cycle activities on development and maintenance projects.
• Experience in Design, Development & Build activities in Cognos Suite of Products. Hands-on development mentality, with a willingness to troubleshoot and solve complex problems, across teams, functions and regions leading to increased efficiency and accuracy in reporting and data.
• Customized data by adding Calculations filters at Report level.
• Create a security filter and apply it to a specific query subject.

Environment: Microsoft SQL Server 2005, Oracle 10g Cognos 10.2.

Confidential, Forth Worth, TX

Cognos Developer/Business Analyst

Responsibilities:

• Modify Report Studio Involved in designing and creating various reports in Report Studio.
• Customized data by adding filters at Report level. Worked a team towards finishing the tasks and achieving project deadlines Report.
• Design and implementation of BI reports and dashboards using Cognos.
• Frame Work Manager and created daily, weekly and monthly reports using those packages
• Experience in building Complex Reports using prompts and parameters in Report
• Conditional Formatting by using Report Studio Created Drill Through reports.
• Development and maintenance projects.

Environment: Seed, UAT, Cognos 10.1 Oracle 10g.

Confidential, Monroeville, PA

Cognos Report Developer

Responsibilities:

• Administrators with the Modify All Users and Modify All Resources rights can also change any Cognos domain user password, where as non-admin Cognos.
• Crystal reports migration to Cognos
• Report Studio conditional prompts. Developed Customized data by adding Calculations filters at Report level.
• Report. Conditional Formatting by using Report Studio, Data Visualization.
• Created reports like List, Cross tab and Dashboards.

Environment: Cognos 10.1 SQL Server 2008, DB2, Oracle 10g.

Confidential, Albany, NY

Cognos Developer/Admin

Responsibilities:

• 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. Keeping it hidden from all users, who has access to that package.

Environment: COGNOS 10.1 SQL Server 2008, DB2, Oracle 10g.

Confidential, NJ

Cognos Developer

Responsibilities:

• Worked with project managers, Business Analyst and end users to understand business requirements and translating them to technical specifications
• Oversaw transition from Cognos 8.4.10.1
• Creating/updating Relational Model and publishing packages using Framework Manager
• 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.
• Experience in building Complex Reports using prompts and parameters in Report
• Cognos Multidimensional Cube development using Cognos transformer and Report generation on Cognos cubes. Power Play reports were created from the various Cubes created for the user.
• 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),DB2, Oracle 10g.

Confidential, New York, NY

Cognos Developer

Responsibilities:

• 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
• 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
• Developed Prompt pages and Conditional Variables.
• SQL Server and New Jobs using Cognos Connection, Production Support issue resolution for users.

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:

• Created Framework Manager Packages defining the cardinalities and namespaces
• Modeled Metadata and add business rules such as filters and calculations.
• Developed Dimensional Models for Cognos 8 Analysis StudiosDefined security over packages, package level access and object level access to allow users to create calculations over the query items.
• Developed complex reports in report studio in PDF and EXCEL format to meet the specifications given in the business requirements.
• Developed Prompt pages and Conditional Variables. cascading prompts, conditional variables in the report
• Created multipage reports with master-detail relationships, Query Prompts, Calculations, Conditions & Filters
• 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, Irvine, CA

Cognos Developer

Responsibilities:

• Created Drill Through reports and Conditional Formatting by using Report Studio.
• Created reports like List, Cross tab and Dashboards by using Report Studio.
• Drill through reports, master detail reports, conditional prompts.
• Created user groups, Roles to implement the Cognos security using Access manager.
• Customized Cognos Connection. 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, Cognos Connection, Report Studio, Query Studio), SQL server 2005

Confidential, Denton, TX

PC/Desktop/Network Support Specialist

Responsibilities:

• 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.
• Also conditionally formatted reports and reports using set operators.
• Create user groups and user roles, assigning capabilities, deploying reports and scheduling reports Helping QA team in testing of the reports and models.

Confidential, Austin, TX

Manager

Responsibilities:

• 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.