SUMMARY:

• Experience on the usage of tools such as Cognos 8.4 and 10 series (Framework Manager, Powerplay transformer, Report Studio, Query Studio, Cognos Connection, Cognos Workspace, Cognos Workspace Advanced, Event Studio, Drill - Through Definitions, Active Reports and Analysis Studio).
• Extensively worked on Transformer to build the model of the corporate data for building up of OLAP Multidimensional Cubes.
• Experience in Informatica providing Business Intelligence solutions using Informatica Power Center.
• Experience in RDBMS including Oracle 10.x/9.x/8.x,SQLServer2000 DB2 and Teradata 12.0, Technical and analytical skills with clear understanding of the difference in design goals of ER Modeling for OLTP and Dimension Modeling for OLAP.
• Ability to understand and effectively gather business requirements and transforming the same into technical design specifications
• Creation of High Level Design Document(HLD), Business requirement document (BRD), Data Flow Diagram (DFD), Test Cases, Guideline document, Best Practices and User Manual
• Experienced in full life cycle trouble reports (tickets) and change request (CR) management
• Strong team player, commitment towards learning, possesses excellent communication, and interpersonal skills
• Extensively used Java SDK to automation of repetitive non-UI tasks, such as scheduling large number of reports, changing permissions for many reports, etc
• Very good experience in creating web application using JSP, CSS and HTML for federal project
• Experience in creating Java script to automate the Cognos reports prompt page for user selections
• Experience in UNIX Shell Scripting

TECHNICAL SKILLS

• Cognos 10.2.1 BI
• Report Studio
• Powerplay Transformer
• Query Studio
• Cognos Workspace
• Cognos Workspace Advanced
• Event Studio
• Drill-Through Definitions
• Active Reports) Impromptu 7.3/6.5/6.0
• PowerPlay Transformer
• DecisionStream
• Cognos UpfrontIWR
• Cognos Visualizer
• Informatica
• Teradata (TD) Utilities (BTEQ
• FastLoad
• FastExport
• MultiLoad Update/Insert/Delete/Upsert
• TD Administrator
• TD SQL Assistant 7.1
• TD PMon
• TD Warehouse Miner )
• Microsoft SQL Server Reporting Services (SSRS)
• SAS 9.4PL/SQL
• JAVASDK
• Java Script
• VB VB Script Oracle10g
• MS-Access
• SQL Server
• MS-Excel
• Erwin & Windows.

PROFESSIONAL EXPERIENCE

Senior Cognos BI Developer/Analyst

Confidential , GA

Responsibilities:

• Involved in requirements and gathering for HCUR online reporting tool
• Created multiple layer reports providing a comprehensive and detailed report with drill-through capability
• Worked on framework manager to import metadata from multiple data sources and to create subject matter models and publish packages.
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Worked on creating list, cross-tab and chart reports using multiple queries in a single report and by using filters, calculations, conditional formatting and drill through options.
• Developed existing reports by implementing Prompts and Cascading Prompts for user to interact with reports.
• Worked on summary reports and detail Reports to display information based on user requirements.
• Created drill through reports and associated with the reports having Master-Detail relationship.
• Validated report results with the source data before and after deployment to production environment.
• Worked on formulating reports scheduling strategy in Cognos Connection factored upon data refresh cycles and server contention.
• Worked on creating power cubes with cube groups and applied security in viewing the cube in Cognos Connection using Analysis Studio.
• Configured Drill-Thru functionality from PowerPlay cubes into Report Studio Reports to view more detailed data.
• Monitored and optimized the performance of reports, and the server environment when required.
• Created reports in Report Studio that traverse to multi-dimensional report in Analysis Studio and Query Studio.
• Responsible for training the end-users in using Report Studio, Query Studio, Cognos Connection
• Automated the process of scheduling the large number of reports Using JAVA SDK.
• Used Java script to automate the report webpages refresh for user prompt selection
• Created a web portal for FEHBIT (Federal Project) using JAVA, Java script, JSP and CSS
• Wrote Unix shell scripting for SAS programs

Environment: Cognos 10/8.4 (Framework Manager, Report Studio, Query Studio), Cognos Powerplay7.4, MS SSIS, JAVA SDK, Java script, Sql Server2003/2008, Informatica 8.x, SAS9.2, ASOracle10g/9i, Windows 2000/XP.

Senior Cognos Developer/Admin

Confidential

Responsibilities:

• Involved in design and development of LDM and PDM in Erwin
• Designed Framework Manager Model with different views (Database View, Modeling View, Business View)
• Created Users and User Groups, assigned user privileges in Access Manager Administration
• Implemented security in Framework Manager in each level according to business users
• Created connections between database server and web server
• Published packages using Framework Manager to be used for report development
• Developed advanced and complex reports using Report Studio
• Created and fine-tuned existing multi-dimensional Power Cubes and published them through PowerPlay Enterprise Server
• Published cubes to Cognos Connection using Cognos Server Administration.
• Involved in the end user training sessions to help users to maneuver in the cubes and reports.
• Extensively used Benthic to test, debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions.
• Installed and Supported IBM WebSphere application server
• Provided installation for Cognos components and options for server placement
• Responsible for the daily Administration of the Cognos environment and support the Development of Reports for groups across the organization. Provided Cognos BI publishing and monitoring support
• Responsible to set up Database Connectivity for Reporting Database
• Supported and provided the Cognos environment to more than three business systems.
• Responsible to set up Database Connectivity for Content Store Database
• Created users and provided the authentication using Cognos Name space
• Created content standards for package development, keeping key metrics consistent and preventing redundancy
• Monitored schedules, creating jobs maintaining cognos portals using cognos connection
• Creating and maintaining data source connections, monitoring Report bursting
• Exported and imported packages between Development, Staging and Production environments
• Executing deployment of new cognos modules to meet business needs
• Developing and enforcing standards for cognos 8 content and server environment

Environments Used: Cognos 8.3/8.4 (Framework Manager, Report Studio, Query Studio), Cognos Powerplay7.4, Informatica 8.1.1, Oracle10g/9i, Windows 2000/XP.

Cognos BI/SSRS Reports Developer

Confidential

Responsibilities:

• Created Logical Data model and Physical Data model using Erwin.
• Created complex reports using SSRS.
• Wrote complex stored procedures, functions, packages, triggers, cursors, tables, views and other SQL joins and statements for reports
• Excellent report creation skills using Microsoft Reporting Services (SSRS)
• Worked with development teams in the design of physical databases and in modification
• Developed and modified PL/SQL code to make enhancements or resolve problems
• Administered the created reports by assigning permission to the valid user for executing the reports
• Designed Dashboard to project status of technical qualifications of scientists / researchers involved in the process of Pharmacology
• Created Drill Down and Drill Through reports from within the dashboard
• Designed three dimensional charts to project the status of courses undergone and certifications acquired by individuals at frequent intervals
• Displayed information of qualified personnel spread across different geographical locations by area of specialization
• Provided data suitable for analyzing personnel issues

Senior Cognos Developer

Confidential - PA

Responsibilities:

• Migrated 27 Impromptu Catalogs to Cognos 8 Framework Manager model to address various business needs of CCMIS.
• Used Impcat2xml migration utility tool to migrate all the catalogs.
• Migrated 32 IWR reports using the Migratetoc8 and Deploytoc8 tools.
• Published Framework Manager Package which feeds data for IQD files and reports.
• Created and administered Content Manager Portals used to publish reports integrated with the Executive Management Reports and Power Play Cubes.
• Exported framework package structure from Content Store to deploy the reports and data source in other environments.
• Maneuvered complex reporting structures with ease by designing reports with a combination of multiple list objects and cross tab objects.
• Tuned report studio reports for improved performance and less response time by taking advantage of options available within report studio.
• Published the package with the externalize query subjects for the data source to the Transformer model
• Created the transformer models and cubes with various rollups and capsized time dimensions.
• Created Transformer model with drill thru option from Published PowerPlay cube to Report Studio reports
• Worked with ETL Informatica team to get inputs to create Transform model

Environments Used: Cognos 8.2 (Framework Manager, Report Studio, Query Studio), Cognos Powerplay7.4, Informatica 8.1.1, Oracle9i, Windows 2000.

Sr Cognos Developer/ ETL Consultant

Confidential

Responsibilities:

• Provided installation, configuration for Cognos components in a multi-server environment (3 or more servers).
• Installed and configured Cognos 7.3 suite in the server.
• Responsible for the Cognos support to provide the server security to Technical developers.
• Set up configure the secured web through Configuration manager.
• Provided database connections and gave privileges to all technical developers.
• Responsible for migrating the Impromptu Reports and powerplay cubes in to the server.
• Responsible for scheduling and monitoring automated reports and powerplay cubes.
• Responsible for trouble shooting the errors from technical developers and users as well.
• Writing automated scripts to run the transformer models in the servers in order to create Powerplay cubes.
• Created automated scripts for different environments to run the automated reports.
• Provided on call support 24/7 to all developers and users as well.
• Responsible for data from data warehouse to front-end Cognos tools
• Provided support and training to technical developers about Cognos security and features.
• Created Power Play models using Power Play Transformer.
• Cognos ETL development support (DecisionStream).
• Responsible for data from data warehouse to front-end Cognos tools.
• Created Dashboards using Cognos Visualizer developer.
• Responsible for report testing.
• Installed Cognos 7.3 environment in all phases of the environment(DEV, UAT, PROD).
• Created security and user class for internal and external users.

Environment: Cognos 7.3 (Impromptu, PowerPlay, Cognos Visualizer), Cognos DecisionStream, Oracle8i/9i, Windows 2000.

Cognos/ETL Consultant

Confidential - IL

Responsibilities:

• Aggregated transactional data along dimensional hierarchies.
• Provided central application to update dimension definitions.
• Involved in ETL (Extraction, Transformation, Loading) process of the project using Cognos DecisionStream.
• Created necessary repositories to handle the metadata in the ETL process.
• Created the Source and Target Definitions using Cognos DecisionStream.
• Extensively used Impromptu in accessing the source data to build reports and to feed the transformer models.
• Implemented drill-through with report and query linking.
• Built multi-dimensional cubes with PowerPlay from data marts.
• Modified the reports per the change in requirements from the end users.
• Worked on Macros using Cognos Script Editor to automate the running of an application.
• Published reports on web using IWR through Cognos Shuttle Builder and refreshed reports using scheduler.
• Involved in the design and build of the Data Warehouse and Data Marts for different departments.
• Involved in installation of Cognos EP Series70 and upgraded Cognos 6x to Cognos EP Series 70.

Environment: Cognos 7.0/6.x (Impromptu, PowerPlay), SAS 8.0, Cognos DecisionStream, Teradata (TD) Utilities (BTEQ, FastLoad, FastExport, MultiLoad Update/Insert/Delete/Upsert, TD Administrator 7.1, TD SQL Assistant 7.1, TD PMon, TD Warehouse Miner 5.0),, Windows NT.

Cognos Consultant

Confidential - NJ

Responsibilities:

• Worked on performance and tuning on loading and fast access of OLAP Cubes by dropping Indexes, Renormalization, Vertical partition and aggression.
• Product wise profitability analysis, Cash flow analysis, outstanding analysis, Inventory turnover analysis, profit & loss statement analysis and Variance reports.
• Developed the Power prompts.
• Impromptu Administration:
• Catalogs creation and modification.
• Creation of user and changing their profile.
• Creation of standard filters, calculations, prompts and conditions in Catalog.
• Formulation of joins strategy.
• Adding columns in Catalog after they are added in already existing tables.
• Developing and Customizing Impromptu Reports:
• Used Cognos Distributed Shuttle Builder to build package of IWR Reports and published reports on web server.
• Provided Training and End User Support with my report and also knowledge transfer.

Environment: Cognos Impromptu6.0, PowerPlay, IWR, Transformer, Access Manager, HTML, SQL Server, Oracle, Upfront, UNIX.

ETL Analyst

Confidential, NJ

Responsibilities:

• Business Analysis and ETL Requirements Gathering.
• Involved in physical and logical modeling.
• Analysis and design of ETL processes.
• Involved in the development of several Informatica mappings and also tuned them for better performance.
• Extensively used the Reusable Transformations in different mappings.
• Extensively used the Expression and Aggregator transformations to kick of some of the stored procedures to populate the GUI tables.
• Developed post-session and pre-session script to concatenate out files.
• Extensively used update strategy and lookup transformations for updating the target tables, and also extensively used the debugger to check the data flow and the mappings were modified depending on the requirement.
• Extensively used ETL to load data to flat files (text) in a separate directory from Oracle database.
• Versioning of the mappings was done in the Development Environment to keep track of the changes in the mappings.
• Different sessions were run in the Server Manager and the log was studied to modify the mappings to obtain correct result from the transformation.

Environment: Informatica Power Mart 5.1.2(Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer), Oracle 8i, ERwin, Business Objects, MQ Series, AIX 4.2, Windows NT, Windows Professional.