Professional Summary

• Highly Skilled Professional with over Six years of experience in System Analysis, Design and Development of Database systems, Data Warehousing and Client-Server Technologies
• Over five years of experience with IBM Cognos10.x/8.x, ReportNet 1.x and IBM Cognos Tools such as Impromptu 7.x/6.x, and Analysis Tools such as Cognos Transformer & PowerPlay 7.x/6.x, Access Manager, Netscape Directory Server and Server Installation & Maintenance
• 1 year experience working with IBM Cognos10 including upgrading recently to 10.1.1 from Cognos8.4
• Over 4 Years of experience in working with IBM Cognos8.x
• Experience in installing and configuring Cognos Reportnet1.01/1.1 and Cognos8.4
• Experienced in metadata modeling in Framework Manager and Impromptu Administration
• Experience in Data Warehousing tools including DataStage, Informatica, and Data Modeling Tools like Erwin using Oracle, MS SQL Server databases
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling
• Provided technical and functional consulting to corporate and divisional users for IBM Cognos
• Extensive work on Data Extraction with Oracle, SQL Server & MS-Access
• Extensive experience in working on Oracle, Teradata, DB2, SQL Server, Access Databases
• Expertise in SQL Query Performance optimization and overall database tuning
• Exceptional analytical and problem solving skills, Ability to communicate effectively at all levels of the development process

Technical Skills

BI Tools: IBM Cognos 10.1/10.1.1, IBM Cognos8.1/8.2/8.3/8.4, Cognos7.x,
ReportNet1.1, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Framework Manager, Cognos Connection, Cognos Impromptu 7.3/7.4, Cognos Transformer & Power Play7.3/7.4, Impromptu Web Reports (IWR), Cognos Query, Cognos Scheduler
ETL: Informatica Power Center 8.6/9.1
Databases: Oracle9i/10g/11g, MS SQL server 2005/2008 R2, TeradataV2R6.0/6.1, IBM DB2 9.1
Database Tools: TOAD, Query Analyzer
Data Modeling: Erwin and Visio
Languages: Java, SQL, PL/SQL, T-SQL, HTML, and XML
OS: Windows XP/7 Windows Server 2003/2008 R2 and RHEL5.0

Experience
Confidential,ND
Project: Work Management and Accounts Payable Reports
Role: Sr. IBM Cognos Consultant Aug’10 –Present

Description:
BEPC is one of the largest electric generation and transmission cooperatives in the United States supplying electricity to 126 rural member systems in 9 states. This project aims at creating work management reports for three major facilities – LOS, LRS & AVS. Work Management reports deal with work-order task, status and overall reporting of jobs being done by plant workers at these three major stations.
Responsibilities:

• Responsible for project requirements gathering and technical documentation including enhancements and revisions to reports
• Lead migration project to upgrade Cognos development and production environments from IBM Cognos 8.4 to 10.1
• Performed extensive validation of reports using Lifecycle Manager during the upgrade from 8.4 to 10.1 version
• Generated custom offsite reports using IBM Cognos 10.1 Active reports having interactive filters, multiple tabs and different views for the same data like pie-charts, bar graphs, crosstabs and lists
• Used Business Insight to develop regional dashboards for different locations and also trained business managers in adding more widgets and customizing their own dashboards
• Experimented with Business Insight Advanced tool to generate ad hoc interactive power generation reports with drilldown and drill-through capabilities for senior managers
• Responsible for creating Dimensional modeling using framework manager
• Setting up configuration, dispatchers and services to get Active reports ready to Burst to plant managers
• Schedule deliveries of interactive dashboard Reports to a small set of regional users
• Provided with all the existing capabilities to schedule and burst reports and further to distribute Active reports
• Responsible for converting a standard Cognos report to an Active report
• Setup Conditional drill-through capabilities available in IBM Cognos Report Studio to let users see only particular retailers based on their selection
• Created cascading prompts to view various locations in different states for each quarterly work management report
• Designed and applied data level and package level security in framework manager to display data only for particular regions by setting up groups and pre-defined roles
• Manually recreated prompts for reports after upgrading using lifecycle manager
• Responsible for deployment of packages and reports across both DEV and PROD environments

Environment: IBMCognos 8.x (Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager), Impromptu Administrator 7.3, Powerplay, Transformer, AQT, Toad, DB2, SQL Server, Oracle 9i, Windows

Confidential,CT
Project: Cognos Center of Excellence Operations
Role: Cognos Consultant Jul’09-Apr’10

Description:
Cognos COE operations is part of Bank of America’s “BI and Analytics” core group that comes under “Technology Service and Fulfillment” group, is responsible for day-to-day Production operations of two Cognos BI based applications CRE and RAZOR.
Responsibilities:

• Used Cognos Schedule Management to schedule Jobs to be triggered for next business day
• Developed User sessions summary report with crosstabs and graphs using Cognos Report studio
• Performed Daily health Check, monitoring and handled communications to business users for two Cognos BI applications CRE and RAZOR
• Performed failure diagnostics and if need be resubmitted burst jobs manually
• Troubleshoot Cubes execution, kill any failed cubes and resubmit them for further processing
• Assisted in migration of cubes from Cognos 8.2 to 8.3 by updating Unix deployment shell scripts
• Involved in Transformation of Cubes from SQL Server to Teradata. Externalized Query Subjects to iqd’s in Cognos Framework Manager 8.2. Published these packages to Cognos Portal. Built cubes in Transformer using FM model
• Involved in devising a security authentication matrix for users using Cognos Portal Directory and Access Manager
• Responsible for adding users to groups, granting and revoking SSO access control permissions using Cognos Access Manager
• Responsible for deployment of Packages and reports from UAT to PROD using Cognos Content Administration
• Responsible for management of SLA scorecard Metrics for Operational performance and stability
• Involved in Performance tuning settings for Cognos Server Administration
• Involved in recycling Websphere Clusters. Regenerating Cryptographic keys

Environment:IBM Cognos 8.1/8.2/8/3 (Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager), Transformer, Access Manager, UNIX AIX, Teradata Query Analyzer, SQL Server, Windows, Websphere application server, Tivoli Maestro Job scheduling Console 8.3.

Confidential,ND
Project: Work Management and Accounts Payable Reports
Role: Sr. Cognos Consultant Mar’08 –June’09

Responsibilities:

• Responsible for requirement gathering and technical documentation
• Responsible for migrating Cognos 7.3 Impromptu reports and Powerplay 7.4 to Cognos 8 Report Studio
• Analyzed data sources, filters, relationships and meta data for reports developed in Cognos Impromptu
• Extensively designed multi-prompt pages & cascading prompts in Report Studio for columns like discipline, job type, unit, system code in LOS Work Management reports
• Created date prompts parameters to filter based on start and end dates given by the user
• Generated lists, crosstabs reports in Report Studio to display work-order related information based on prompts
• Created sections, headers, footers to display group information related to each specific job type
• Created Data Items, Query calculations & used aggregate functions, rollup aggregate functions in columns to display totals for distinct work orders
• Associated page with query, assign group span data to columns to display related work order information
• Extensively used grouping, sorting, detailed filters while developing reports
• Performed extensive formatting to convert text to report expression, alignment, padding, size & overflow, report functions, data formatting
• Analyzed and compared reports between Impromptu and re-created reports in Report Studio
• Developed Work Management, Accounts Payable reports with Value Prompts, filters, Query calculations, Date Prompts, Text box Prompts, Aggregate and Rollup aggregate functions.
• Responsible for recreating Powerplay 7.4 reports to Cognos 8.2 Analysis Studio.
• Created crosstab, nested rows and columns , stacked sets
• Created item based calculations, filter values using context, hiding rows and columns, page breaks

Environment: IBMCognos 8.x (Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager), Impromptu Administrator 7.3, Powerplay, Transformer, AQT, Toad, DB2, SQL Server, Oracle 9i, Windows

Confidential,OK
Project: CIS Banner
Role: Sr. Cognos Consultant Aug’06 –Feb’08

Description:
OneOK is a gas and energy distribution company serving both industrial and residential customers in three states – Oklahoma (Oklahoma Natural Gas), Texas (Texas Gas Service) and Kansas (Kansas Gas Service). CISBanner is a customer billing information system. Cognos suite of Business Intelligence Reporting products is used as part of CISBanner.BI Reporting is used in these business functions - Billing, Tax calculations, Deposit Collection, Credit History, Gas leakage servicing, Meter Reading and Customer default reports
Responsibilities:

• Responsible for requirement gathering and technical documentation
• Responsible for creating Content store, multi-server/ single server installations and configurations of cognos8
• Responsible for gap/data analysis, technical design, implementation and deliverables
• Active Team Player with Cognos Framework Manager design (Regular, and DMR Models) and publish package to the Cognos Portal
• Performed Relational data modeling (DMR) in Framework Manager for Analysis Studio reporting
• Designed regular dimensions, and measure dimensions to build OLAP/DMR model in the framework manager
• Developed powerplay transformer model and cube design with single or multiple data sources
• Responsible for Cognos security, scheduling and deployment of reports from development environment to SIT, UAT and production
• Responsible for upgrading content store from Cognos8.1 to Cognos8.2
• Worked on multi query reports, drill-thru, prompts, bursting, union query, SQL joins, and tabular SQL in the report studio
• Developed model query subjects, stitched query subjects, data source query subjects, and stored procedure query subjects in the framework manager
• Worked on parameter mapping, parameter files for data level security in the framework manager
• Effectively scheduled all reports and sending emails to users using Event Studio in cognos8
• Created impromptu query definition (iqd) in the Framework Manager, created transformer models, power cubes, and published into the cognos connection portal from framework manager
• Used star schema grouping, segmenting, and linking (Multi-user environment)
• Provided user training on query studio and cognos tool functionality

Environment:IBM Cognos 8(Cognos Connection, Metric Studio, Report Studio, Framework Manager, Analysis Studio), Cognos ReportNet 1.1 MR2 (Framework Manager, Cognos Connection, Report Studio and Query Studio), PowerPlay 7.3, PowerPlay Transformer 7.3, PowerPlay Web Explorer, Impromptu Administrator 7.3, Access Manager, Cognos Server Administration, Migration Tools, Oracle9i, Windows and Unix

Confidential,CT
Project: Credit Risk Control Management
Role: Cognos Consultant Nov’05-Jul’06

UBS AG is a leading global financial services firm with three main groups – Investment Bank, Global Asset Management and Global Wealth Management & Business Banking. Credit Risk Control Management is a group-wide global initiative to streamline and provide a unified risk view to senior management by appropriately identifying and classifying risk data aggregated from different divisions. Cognos Business Intelligence tools are extensively used to achieve the goals of this initiative.

• Interact with the Business users for requirements gathering
• Analyzed and created functional specifications and technical specifications to implement business logic for the user requirements to generate Framework Manager models and Cognos reportnet reports
• Created and maintained Projects, Models, and Packages using Cognos ReportNet
• Published packages from ReportNet Framework Manager to Cognos connection server
• Created folders, pre-filters, pre-prompts, and complex business calculations in Framework Manager and Report Studio
• Created complex reports using list, Cross tab, drill-thru reports, Master-Detail relationship, Prompts, filters, page-break and calculations
• Created reports from the multiple data sources, and conditional formatting
• Extensively worked on performance tuning in ReportNet
• Developed SQL queries and PL/SQL Stored procedures, functions
• Imported power cubes from the powerplay enterprise server to reportnet cognos connection server
• Created IQD’S with Cognos Framework Manager and created power cubes in Powerplay Transformer
• Deployed reports from Dev, to QA and Production environment
• Environment: IBM Cognos8.1/Cognos ReportNet 1.1 (Framework manager, Report Studio, Query Studio), Deployment Tools, Cognos BI Series 7.3, Impromptu, PowerPlay, PowerPlay Transformer, Cognos Server Administration, PowerPlay Web Explorer, Toad, Oracle 8i, Windows and Unix

Environment: IBM Cognos8.1/Cognos ReportNet 1.1 (Framework manager, Report Studio, Query Studio), Deployment Tools, Cognos BI Series 7.3, Impromptu, PowerPlay, PowerPlay Transformer, Cognos Server Administration, PowerPlay Web Explorer, Toad, Oracle 8i, Windows and Unix
Education and Training:
BS in Computer and Electrical Engineering
Certified Cognos BI Author in cognos8