PROFESSIONAL SUMMARY:

• Over 8 years of experience in IT Industry with experience in BI Software development, Administration, Analysis, design, testing, documentation and implementation of client server applications.
• Extensive experience in Cognos 10.x, 8.x (Framework Manager, Transformer, Report studio, Query Studio, Analysis Studio, Active Reports, Business Insight, Workspace and Metric Studio), Cognos Report Net and Impromptu .
• Experience in Installation, Configuration, Monitoring and Managing of Cognos BI Suite along with security setups for 10.x/8.x and other versions
• Expertise in Metadata Modeling - Create project, Prepare Metadata, Prepare the Business View, presentation view then Create and Manage packages, Set up security and publish the package into portal
• Expertise in Developing Simple, Complex, adhoc Reports and high impact dashboards using Report Studio in Cognos 8 and 10 BI Suites
• Good Knowledge on building multidimensional Cubes using Transformer.
• Proficiency in working with Relational Databases like Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 ,DB2, Teradata, Netezza and database access tools like TOAD and SQL Assistant
• Experience in ER Modeling, maintaining database schemas like Star Schema and Snowflake Schema used in Relational and Dimensional modeling. Knowledge in analyzing OLTP/OLAP systems
• Experience in Deployment(Export, Import) using Cognos Connection Portal in Cognos 10/8
• Good Knowledge on Data Warehouse ETL Tools including Informatica and IBM Data Stage,
• Involved in developing Informatica transformations and design process for data extraction and load.
• Worked on security access to clients using Access Manager and Provided Data Access Object Access, and Package Access in Frame Work Manager Performed analysis of reporting requirements: design, develop, implement and support Cognos-based reporting solutions for a variety of clients, Strong problem solving skills,
• Ability to develop strategies for clients and provide detailed documents to clients.
• Involved in creating Functional and Technical specification documents and worked on ETL Mappings for creating System Design Documents for Low Level Documentations.
• Experience in working with off-shore team, onsite support teams and ability to coordinate with team for better results.

TECHNICAL SKILLS

BI Tools: Cognos 10.2.2, 10.2.1, 8.x(Framework manager, Cognos Connection, Report Studio, Active Reports, Business Insight, Query Studio, Analysis Studio, Metric Studio, Portal Administration), Cognos SDK, Cognos ReportNet 1.x(Framework Manager, Report Studio, Query Studio), Cognos Enterprise 7 series (Impromptu, Power play, Upfront, transformer, Access Manager, Cognos Administration),Power play Transformer 7/8, TM1, JDA BA

Formal Methods: Agile Modeling, SDLC

Other BI Tools: Crystal Report 8.5. Business Objects XI R2.

Database Servers: Oracle 11g/10g/9i/8i, MS SQL Server2000/2005, MS Access

Data Modeling: Erwin, MS Visio

Languages: SQL, PL/SQL, C, XML, HTML

Web Servers: IIS, Apache, WAS, Web logic.

Web Technologies: JavaScript, XML, HTML, Front Page, ASP.NET, VBScript

Applications and OS: MS Office Suite (Word, Excel, Access, Visio), Windows 95/98/2000/2003/2007/ XP, Windows NT 4.0 Red Hat Linux, HP- UNIX.

RDBMS: Teradata, Oracle 11g/10g/9i/8.x, MS-SQL Server 2005/2000, DB2,and Netezza

ETL Tools: Informatica, Datastage and Data Manager

PROFESSIONAL EXPERIENCE:

Confidential, Ft. Worth, TX

Sr. Cognos Developer

Responsibilities:

• Involved in gathering Business requirements from business customers, analyzing and transforming them into business intelligence reporting specifications, Installation and Configuration of Cognos10.2 on windows for single server environment.
• Involved in creation of Relational and Multi-dimensional models such as packages and Cubes using Cognos framework manager and Transformer, then published them on to the server for reporting needs with Cognos version of 10.2.2.
• Work directly with business customers to build reports, dashboards, adhoc reports and portals with COGNOS reporting tools like report studio, query studio and analysis studio.
• Created Multi tab, Drill up/Down, Multi Query and multipage reports using report studio.
• Involved in creating Informatica transformations, scheduling jobs and data loading.
• Involved in developing, partitioning and deploying of transformer cubes, used analysis studio to analyze the cubes and create reports.
• Implemented security like object level and data level in metadata models and reports, created LDAP user groups in order to restrict the data visibility in reports .
• Involved in Unit testing, Integration testing and system testing of the reports and cubes in development, UAT and production environments.
• Involved in Performance tuning of models/reports/cubes for better quality product delivery.
• Created active reports and exported them to Cognos Mobile for user analysis.
• Trained the end users to effectively use the reporting tool to build and customize their Ad-hoc reports.
• Provided knowledge to the business how to use Cognos workspace and Cognos workspace advanced.
• Supported production environment by solving production issues and bugs

Environment: COGNOS 10.2.1/10.1 (Report Studio, Query Studio, Analysis Studio, Active Reports and Business Insight), Oracle 11g, DB2, SQL Server 2008, LDAP, Informatica, DB2.

Confidential, San Jose CA

Sr. Cognos Developer

Responsibilities:

• Responsible for the complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management.
• Written Technical Specification Documents (TRD) during design and development of FM models and reports.
• Involved in the Installation of Cognos 10 and upgradation of Packages from Frame Work Manager, Reports from Report Studio from Cognos 8.4 to Cognos 10.
• Developed Framework Manager Models with physical layer, Business Layer and presentation Layer against the databases such as Oracle and SQL Server by creating Data Sources.
• Developed Crosstab reports, Chart reports, drill through reports, master detail reports.
• Created Interactive Reports using Active Reports and Business Insight in Cognos 10.
• Created complex reports that involve query prompts, layout calculations, conditions, and filters..
• Extensively worked on Analysis Studio to explore PPS business data to find trends and comparisons that answer their business questions.
• Created SQL views to avoid complex modular joins within reports and imported the views into Framework Manager.
• Created Metadata Models and established the cardinalities in Framework Manager and Created Packages and Published to Cognos Connection.
• Worked on PowerPlay studio to slice/dice Cognos cubes, provided the graphical representation of reports based on metrics like actual and target in Report Studio.
• Created Static Choice value prompts, Conditional Variables (Boolean and string) and Conditional Blocks associated with these variables to display/hide columns and queries based on user's selection in Prompt page.
• Developed different kinds of List reports using calculations and Drill Through, Drill Down in different formats (PDF, HTML, XML and Excel) which contains Filters and Multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option for Bursting reports
• Using JDA BA software, created simple and complex reports for their analytical purposes.

Environment: COGNOS 10/8.4(Report Studio, Query Studio, Analysis Studio, Active Reports and Business Insight), Oracle 11g, SQL Server 2008, LDAP, IIS 7, UNIX, Windows2003/2007,TOAD,SharePoint.

Confidential, Dallas TX

Sr. Cognos Developer

Responsibilities:

• Understand complete Business scenario and company's financial legacy process flow to propose a cost effective BI solution with enhanced reporting methods .
• Migrated Ellie forecasting system from Business Objects XI to Cognos, Imported Business Objects universe into Cognos Framework Manager and tweaked filters and calculations.
• Rewritten several business objects (Webi and Deski) reports using Report Studio and Analysis Studio.
• Designed, developed, and supported Cognos BI content including reports, dashboards, cubes, packagesand presentation portals.
• Developed Cognos Framework Manager Models to accommodate new and existing business Requirements.
• Worked closely with BI Administrator, Business Analyst, Systems Analyst, DBA, and/or application Developers to build, optimize and support business projects Organized, created and maintained documentation of procedures and processes.
• Reporting, analysis, score carding, dashboards and business event management.
• Installation of Cognos 10 Suite and upgrade of Packages from Frame Work Manager, Reports from Report Studio from Cognos 8 to Cognos 10.
• Worked with DBA to setup the new Databases and Modify Databases for Reporting Models.
• Wrote SQL views and Stored Procedures to avoid complex modular joins within reports and imported the views into Framework Manager.
• Created Multidimensional cubes using Transformer and published them to the cognos Dev, UAT and PROD environments.
• Provided programming/system guidance and support to all team members

Environment: COGNOS 10/8.4(Report Studio, Query Studio, Analysis Studio, Active Reports and Business Insight), Informatica, Teradata, Netezza, Windows XP/2007. Business Objects XI R2(Web Intelligence and Desktop Intelligence) and Crystal Reports

Confidential, Pittsburgh PA

Sr. Cognos Developer

Responsibilities:

• Responsible for the complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management.
• Involved in the Installation of Cognos 8.4 and upgradation of Packages from Frame Work Manager, Reports from Report Studio from Cognos 8.3 to Cognos 8Migrated Impromptu 7.4 catalogs and Reports to Cognos 8.4 using Migration Utilitie.
• Created Universes and using designer and developed reports using Business Objects XI R/3 using Web Intelligence and Desktop Intelligence.
• Set the properties for dispatchers and services and organized them into configuration folders.
• Defined data sources and their associated connections in Cognos Connection.
• Designed the Cognos Portal pages and design enabling portlet interactions.
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports.
• Managed scheduling of reports, public and My folders and distribution lists, users, groups and roles using Cognos Connection in cognos 8.
• Created report links and parameters outside cognos and connected to cognos using Cognos SDK.
• Extensively worked on Analysis Studio to explore PPS business data to find trends and comparisons that answer their business questions.
• Analyzed the complexity of migrating IMR reports to Cognos 8.
• Tuned cube builds Impromptu Reports and ReportNet reports and servers for better performance.
• Involved and assisted Informatica Admin in Maintaining security and Granting access to users.
• Involved in design and development of Teradata BTEQ scripts .
• Created User groups, roles to implement the Cognos Security using LDAP.
• Created Metadata Models and established the cardinalities in Framework Manager .
• Generated IQD files by externalizing the Query Subjects to feed Powerplay.
• Developed Multidimensional Models in Transformer and generated power cubes.
• Administered ReportNet server with the primary objective of tuning server performance to optimize speed and efficiency.
• Provided Security (Data level, Object level and package access level), created database Signons and setup data Source permissions using Access Manager and LDAP directory server.
• Monitored Audit Reporting based on users, reports and packages..
• Providing the graphical representation of reports based on metrics like actual and target in Metric Studio and Report Studio
• Developed Complex reports from technical specifications like Dynamic Grouping, Dynamic Sorting, Conditional Formatting and Pre Select Columns.

Environment: COGNOS 8.3/8.4(Report Studio, Query Studio, Analysis Studio, Metric Studio), Business Objects XI R/3,Cognos 8.4 Go-Office, Oracle 10g,PL/SQL,TOAD, Microsoft SQL Server 2005, Informatica, Informatica Metadata Manager, Cognos SDK, Microsoft SQL Server 5.0 SSIS (Data Transformation Services),LDAP, Access Manager, IIS, Web Sphere, UNIX, Windows XP/2003, Crystal Reports 8.5

Confidential, Nashville, TN

Cognos Developer

Responsibilities:

• Primarily responsible for building, scheduling and maintaining Daily, Weekly, Monthly and Quarterly reports and support the Production support team to resolve issues in reports under tight time constraint and coordinated with business analysts and users for gathering business requirements.
• Involved in the Installation of Cognos 8.4 and upgradation of Packages from Frame Work Manager, Reports from Report Studio from Cognos 8.3 to Cognos 8.4
• Developed Framework Manager Models with physical layer, Business Layer and presentation Layer against the databases such as Oracle and SQL Server by creating Data Source
• Designed the Framework Manager Model according to the business requirements and published the package to Cognos Connection
• Set different Governors' for improving performance of reports
• Created DMR models to meet OLAP style of querying thus enable Drill UP/Down feature for Cognos Reports
• Created multidimensional cubes for analyzing the data using Transformer and Deployed Cognos PowerPlay cubes for Data Analysis
• Created user groups, roles to implement the Cognos security using LDAP
• Managed user IDs and user groups like providing privileges to the users and user groups in Access Manager. Created Master-Details Reports and set Page breaks for bursting the reports to corresponding departments
• Created dashboards in Cognos to communicate to corporate performance metrics
• Conditional rendering applied for hide and seek, alternative colors for Cognos reports
• Cognos Reports created with Cascade and Tree Prompts for advanced prompt selection Used Java Script in Cognos Report studio reports to Toggle, to set tool tip inside the Cognos prompts etc
• Developed Crosstab reports, Chart reports, drill through reports, master detail reports
• Developed different kinds of List reports using calculations and Drill Through, Drill Down in different formats (PDF, HTML, XML and Excel) which contains Filters and Multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option for Bursting of reports
• Involved in Installing and Configuring Report Net Server, Framework Manager, Report Studio, Query Studio and Cognos Connection Portal
• Created and modified tables and views against oracle database
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects
• Worked on query subjects, relationships within query subjects, importing views, tables, stored procedure in Frame work Manager
• Modified the Queries to enhance the performance of the reports
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio
• Provided support for managed reports and users

Environment: Cognos Report Net 1.1, Framework Manager, Cognos Connection, Query Studio, Report Studio, Cognos Series 7.x, Impromptu, Power play, Power play Transformer, Access Manager, Oracle 9i, UNIX and Windows 2000