PROFESSIONAL SUMMARY:

• Worked as a Senior Cognos Developer/Architect in developing Cognos Applications such as Report Net, Powerplay Enterprise Server (PPES), Scheduler, Access Manager, Dashboard, Transformer, Impromptu, Impromptu Web Reports (IWR), Upfront
• Experience in Cognos BI and Report Studios with Framework Manager, Analysis Studio, Cognos Connection, Report Studio, Query Studio, Transformer, and Cognos Configuration.
• Strong understanding of relational, multidimensional database design concepts and in depth knowledge of OLAP
• Expertise in designing of Multi - Dimensional Cubes and Analysis
• Expert in creating and publishing packages in the Framework Manager from various data sources. Generated different kinds of reports, created templates and multilingual reports.
• Created Standard filters, calculations, single select, multiselect cascading prompts, conditions and Master-Detail Relationship Report.
• Expertise in Creating Dashboards and Prompt Pages in Cognos Report Studio and Analysis Studio.
• Designed a wavelet-based system for the development of the multidimensional cubes in order to reduce the spatial storage and retrieval time also created MDX based reports for faster retrieval of data.
• Experience in production support and performance tuning with servers and reports.
• Created and published Models on to Cognos Connection Portal.
• Scheduled the reports and performed report bursting.
• Created new jobs in Cognos Connection for scheduling a group of reports.
• Experience in developing applications using Oracle 9.x/8.x/7.x, Reports, SQL * Loader, SQL, PL/SQL, SQL Server, and MS Access.
• Expert in writing complex SQLs and also creating views and Tables in database.
• Provide technical and functional consulting to corporate and divisional users for Cognos.
• Hands on experience in Star and Snowflake schema design and De-normalization techniques.

TECHNICAL SKILLS:

Reporting Tools: Cognos 10.2/10.1/8.4/8.3/8.1/7.4/7.3 (Powerplay, Transformer, Reporting Studios, Access Manager, Scheduler, Impromptu, IWR, PPES), Cognos Studio, Access Manager, IWR, Power Play Enterprise Server, Visualizer, Scheduler, Power Prompts, Notice cast), Cognos Impromptu Administrator 6.x/7.x, Power Play 6.x/7.x, Upfront, Power play Transformer, Access Manager, Impromptu Web Report Server (IWR) and Power play Enterprise Server.

ETL Tools: Informatica Power Center / Power mart 6.

Databases: Oracle 10g/9i/8i/7.x, SQL server 7.0/2000, Teradata, Sybase, MS Access.

Database Tools: TOAD 9.0, Oracle SQL Developer

Languages: Java, Java Script, HTML, XML, VB 5/6, VB Script, SQL, PL/SQL, MDX, C and C++

Operating System: UNIX (Sun Solaris, HP US), Windows 95/98/NT/2000/XP

GUI: Developer/2000 (Forms 4.5/5.0, Reports 3.0/2.5)

TECHNICAL EXPERIENCE:

Confidential, Washington, DC

Cognos Lead (Techno and Functional)

Responsibilities:

• Expertise in the entire project life cycle from discussion with the users, presentation, installation, development, testing and production of end user training
• Working in parallel on two projects (departments) for the company to design the Cognos Structure, Reporting and Ad-hoc tool which would be useful in doing a detail analysis of the Data
• Interacted with the Business Analysts for gathering the requirement to prepare creating new reports and modifying existing reports as per day to day changes for the user requirements.
• Analyzed the current business process, assess opportunities for redesigning these processes.
• Used Query Studio for creating adhoc reports using simple queries.
• Created complex reports using Report Studio including conditional blocks, conditional formatting.
• Created Complex Dashboard reports in Report studio based on the user requirements
• Modified all existing PIR family reports instead of more than fifty queries to one query to build the reports.
• Rewrite all existing HSES Cognos reports to improve performance and optimizing reports with one query instead joining multiple quires to build the report.
• Developed reports to generate multiple reports at one time running using repeater queries.
• Developed PIR reports related to annual Head Start survey that includes program, enrollment, medical, dental and family information at National, State, Grant, and program levels.
• Developed Financial reports that included cash needs, various refunding status, and other reports used to monitor the Grant renewal process.
• Created operational reports that support managing enrollment and monitoring ARRA Grants.
• Developed several history reports regarding meetings and monitoring the risk management process.
• Developed complex reports combining data from HSES several different domains
• Implemented customizing cognos connection hides and disables tool bar button for user groups on Cognos viewer menu.
• Tested reports using Cognos query studio and validate data to meet business requirements before deploying reports in to the testing environment.
• Used Cognos Connection as Web Portal for managing reports Developed Prompt pages and Conditional Variables. Created Multi-Dimensional cubes using PowerPlay transformer.
• Created Query Prompts, Cascading Prompts, Calculations and Conditions & Filters.
• Updated old reports to meet current reporting standards.
• Created Drill Through between Parent (Summary) and Child (Detail) Reports Involved in performance tuning and Production Support.
• Created Standard filters, calculations, single select, multi select cascading prompts, applied rendering variables to the prompts leverage, conditions and Master-Detail Relationship Report.
• Provide escalation support for issues raised through helpdesk related to using reports, errors encountered in reporting environment, and refinement of reports.
• Created daily Adhoc reports as per user requirements and exporting the data in excel or csv format and implementing prompts in the adhoc reports to the users to provide input data run the reports based on their required data.
• Worked extensively on the new features which came with Cognos.
• Created folders, filters, prompts, and complex calculations in Report Studio.

Environment: Cognos 10.2/10.1.1/8.3 (PowerPlay, Transformer, Framework Manager, Query Studio, Analysis Studio, Report Studio), ROLAP, OLAP, SQL Server, Oracle9i/10g, PostGres, LDAP, UNIX.

Confidential, Augusta, GA

Cognos BI Developer / Administrator

Responsibilities:

• Installed and configured Cognos 8 BI and worked with Cognos 8 BI modeling, Report Studio and Analysis Studio.
• Setup the Cognos samples and created a Pilot project in Cognos 8 BI.
• Worked with Cognos 8 BI modeling, Report Studio and Analysis Studio.
• Interact with the Business users and documented their query, business analysis and reporting needs. Understood data and business logic underlying the requirements.
• Created ESAM Model and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Created charts, lists and crosstab’s simple and complex reports using Report Studio and ad hoc reports using Query Studio for ESAM users.
• Created repeaters, Master Detail Reports, Cascading Reports, Bursting Reports, Query Prompts, Calculations, Conditions and Filters in Report Studio.
• Administration involved Installation and configuration of COGNOS servers, implementing security, managing users, user groups and roles in the organization. Worked on bursting reports for the web users.
• Optimized Catalogs using Database Interaction, Client/Server balancing, Database functions, Table Weighting, Qualification, and Governors Settings.
• Used multiple data sets like Oracle/SQL/External within same package and report based on those datasets.
• Scheduled run on a monthly, weekly, and daily basis using Cognos Scheduler.
• Involved in creating security, and deployment (exports and imports).
• Used Transact-SQL for incorporating stored procedures, exception handling, and logical flow control purposes.
• Documented to describe entire flow of the applications, program development, logic, coding, testing, changes and corrections.

Environment: Cognos 8BI(Framework Manager, Analysis Studio, Report Studio, Query Studio, and Cognos configuration),Cognos Series 7 Version 4 (Impromptu Administrator, IWR, Power Play, Transformer, Power Play Enterprise Server, Power Play Web, Access Manager, Upfront), Access Manager, Oracle9i/10g, SQL Server-2000/2005, TOAD 9.0,LDAP, IIS, UNIX and Windows 2003 Server,XP.

Confidential, Boston, MA

Cognos 8 BI Developer/ Administrator

Responsibilities:

• Worked with Cognos 8 BI modeling, Report Studio and Analysis Studio
• Created Multidimensional power cubes Sales Datamart Invoice, Orders, North American Sales Rep Cube and published packages Cognos connection through Framework Manager.
• Optimizing the cubes using by the optimization rule of partition and implemented the securities on the cube by setting Dimension views, user view classes using Apex, Exclude, Suppress, Summarize, and Cloak.
• Created user defined SQL/MDX in the report Report Studio and Power play transformer.
• Created Orders, Invoices cubes Sales Data mart and published packages in FM and created reports.
• Installed Report Net Migration Tool and migrated Impromptu catalogs.
• Interact with the Business users and documented their query, business analysis and reporting needs. Understood data and business logic underlying the requirements.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Tuned cube builds Impromptu Reports and Report Net reports and servers for better performance.
• Created charts, lists and crosstabs, using Report Studio and ad hoc reports using Query Studio.
• Provided security to the Report Net in Access Manager through LDAP Server and configuration settings in Cognos configuration.
• Involved in client and server Installation of Cognos Controller Version 2.1 and configuration.
• Administration involved implementing security, managing users, user groups and roles in the organization. Worked on bursting reports for the web users.
• Developed various dimensions, measures and calculation in Cognos Transformer and designed user defined functions for Cognos reports.
• Implementation of Impromptu reports and Power Play cubes using multiple queries.
• Involved scheduled the cubes update the data.
• Optimized Catalogs using Database Interaction, Client/Server balancing, Database functions, Table Weighting, Qualification, and Governors Settings.
• Imported power cubes from the Power Play enterprise server to Report Net Cognos connection server.
• Scheduled Impromptu and Power Play reports to run on a monthly, weekly, and daily basis using Cognos Scheduler.
• Used Transact-SQL for incorporating stored procedures, exception handling, and logical flow control purposes.

Environment: Cognos 8.3BI(Power Play Transformer, Framework Manager, Report Studio, Query Studio, and Cognos configuration), Impromptu Web Reports, Cognos Transformer 7.4, Cognos Power Play 7.4, PPES, Cognos Access Manager, Upfront, VBIS,DB2, SQL Server 2000, Oracle 10g, Unix, Windows NT/2000,Windows API, TOAD.

Confidential, Dallas, TX

Cognos BI Developer

Responsibilities:

• Setup the Cognos samples and created a Pilot project in Cognos 8 BI
• Installed Report Net Migration Tool and migrated Impromptu catalogs.
• Migrated Impromptu reports to ReportNet using migratetocrn command and deployed migrated reports to ReportNet using deploytocrn command.
• Interact with the Business users and documented their query, business analysis and reporting needs. Understood data and business logic underlying the requirements.
• Involved in Creating Content store, installation and Configurations of the ReportNet.
• Involved in creating security and deployment (exports and imports).
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Created charts, lists and crosstabs, using Report Studio and ad hoc reports using Query Studio.
• Provided security to the ReportNet in Access Manager through LDAP Server and configuration settings in Cognos configuration.
• Administration involved Installation and configuration of COGNOS servers, implementing security, managing users, usergroups and roles in the organization. Worked on bursting reports for the web users.
• Developed various dimensions, measures and calculation in Cognos Transformer.
• Implementation of Impromptu reports and PowerPlay cubes using multiple queries.
• Optimized Catalogs using Database Interaction, Client/Server balancing, Database functions, Table Weighting, Qualification, and Governors Settings.
• Imported power cubes from the PowerPlay enterprise server to ReportNet Cognos connection server.
• Scheduled Impromptu and PowerPlay reports to run on a monthly, weekly, and daily basis using Cognos Scheduler.
• Used Transact-SQL for incorporating stored procedures, exception handling, and logical flow control purposes.

Environment: Cognos 8BI(Framework Manager, Analysis Studio, Report Studio, Query Studio, and Cognos configuration), Cognos Impromptu 7.0, Impromptu Web Reports, Cognos Transformer 7.0, Cognos PowerPlay 7.0, PPES, Cognos Access Manager, Upfront, SQL Server 2000,Teradata,Unix, Windows NT/2000.

Confidential, Boston, MA

Cognos Developer

Responsibilities:

• Involved in Installation of Cognos Tools.
• Developed Reports in Cognos Impromptu, PowerPlay and Impromptu Web Reports (IWR).
• Developed a Standard template for data warehousing requirement specification collection of requirements for development under COGNOS environment.
• Developed Catalog definition, design, and presentation and user classes/security. Identified the data sources required.
• Involved in all aspects of impromptu, from connecting to the corporate database to setting up effective catalogs, joins, folders, and filters, to ensure that adequate security procedures are in place. Associate Impromptu Reports to drill through from one report to another.
• Setting up appropriate User Class and security for the different groups of people who use the catalogs.
• Involved in the design development and implementation of Cubes for various purposes.
• Implementation of Impromptu reports and PowerPlay cubes using multiple queries.
• Developed multidimensional power cubes with Cognos PowerPlay.
• O ptimized the Catalog by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings.
• Worked with Access manager Administrator to provide security and Multi-user access.
• Created Snapshots to minimize data processing when the network traffic for the database is heavy.

Environment: Cognos Impromptu7.1, Cognos PowerPlay7.1, Cognos PowerPlay Transformer,7.1, Access Manager7.1, Cognos Upfront7.1, Impromptu Web Reports 7.1(IWR), Configuration Manager7.1, Oracle 8x, SQL, Data