SUMMARY

• Over 7+ years of professional experience in IT Industry with Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.
• Experience in Data Warehousing & BI environment on Cognos Suite8.4,8.3.8.2. 8.x /7.x/and Report Net 1.1/1.01. (Framework Manger,), Cognos Connection, Report Studio, Query Studio, AnalysisStudio), Cognos EP Series 7.x (Impromptu, Power Play, ImpromptuWebReports, Power Play Transformer, Report Net 1.1 MR3, Cognos Upfront).

Extensively worked on IBM Cognos 8 Framework Manger, creating model and implementing best practices while resolving the loops and query items, namespaces, DMR (Dimensional modeling with relational data) and packages.
Sound knowledge on Report Authoring Skills using (Report Studio, Analysis Studio and Query Studio.)

• Involved in Migrating the Cognos EP Series 7 to Cognos 8 Environment using Migration utilities.
• Experience with Installation and configuring Cognos 7 and Cognos 8 Environment.
• Good knowledge in people soft EPM,HRMS ,payroll, Time and Attendance.
•  Experience in developing new reports and customizing existing reports and change request processing.

Adept in designing Catalogs and Creating List Reports, Cross-Tab Reports, Sub Reports and Exception Reports using Cognos Impromptu.

• Developed Impromptu Reports and published into the web for end users using IWR.
• Good experience working with OLAP, Query tools with RDBMS environments.
• Designs and develops Cognos Power Play OLAP cubes using Transformer
• Developed Power Play Reports and published on the web for end users using Upfront.
• Installed and configured Impromptu, Power Play, Transformer, Upfront and IWR.
• Experience in Financial, Insurance &Pharmaceutical Industries.
• Extensive Experience in SQL Server, Oracle, Teradata and DB2 for building and implementing data warehouse.
• Highly experienced in developing decision support applications with Cognos and other business intelligence, ETL, and database tool suites.
• Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions. Strong experience with Client interaction, understanding business applications, business data flow and data relations.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

BI Tools Cognos 8.0/8.2/8.3/8.4 BI Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio,SAP BW.Business object,Crystal reports.
ReportNet1.1 (MR1/2) Cognos Connection, Framework Manager, Query studio, Report Studio, Cognos Configuration.
Cognos Series (7.x/6.x) Cognos Impromptu, Impromptu User, Impromptu Web Reports, Cognos Power Play Transformer, Power Play User, Power Play Web Reports, Power Play Enterprise server, Access Manager, Configuration Manager, Scheduler.
ETL Tools Informatica 7.x. Decision Stream.,Data Stage.
Languages C,JAVA,SQL,SDK,PL/SQL, HTML,Sharepoint, JAVASCRIPT,
Databases Oracle9i/8i,SQLServer2000,Teradata,SSIS,MS
Access, DB2.
Other Tools Erwin 4.1, Vision2000, MS-Office 2000/03, Microsoft Word, Excel and Power Point, Toad 
Operating Systems Windows 95/98/NT/2000/XP, UNIX, LINUX.

TRAININGS/CERTIFICATIONS
Certified IBM Cognos 8 BI Author

Confidential,Newark,NJ Oct’ 2010 to Till Date Senior Cognos Developer/Admin 
Responsibilities:

• Installed and configured (Server & Client) Powerplay Studio in Cognos 8.4.1
• Publish the cube as packages and test the functionality using cognos studios.
• Installation and configuring IBM Cognos 8.4.1 Environment.
• Implemeted security on Framework Manager models & cognos connection portal.
• Upgrade reports Using Upgrade Manager from Cognos 8.3 to IBM Cognos 8.4.1
• Created Cognos 8.4.1 Upgrade plan for higher regions and lower regions.
• Co-ordinated with vendor team (Paragon,Ironside IBM partner)
• Created High Level plan for tasks required for Infrastructure Build-out.
• Involved in process for control changes in 8.3 and keep 8.4 sync until the cut-over.
• Builded plan for Infrastructure Secuirty Assement documents.
• Provided Production support for several applications.
• Implemented Secuitry for new studios relese to the business.
• Tested and validated the report output against the database to measure performance of the Report.
• Worked on cognos 8 Transformer on UNIX box for cube build and deployment.
• Shared new content store & Metric store information with DBA Team.
• Review Data source connections,Models Layers and tested Upgraded Models.
• Implemented Automation process for cube build/FTP in Transformer server.
• Execute scripts for cube incremental update.
• Participating in code reviews ,technical reviews with team.
• Prepared Inventory for Cognos Framework Manager models,Reports.
• Particpated in weekly meeting on project updates.
• Trained end user on IBM Cognos studios ( Capabilities)
• Communicating complex technical information clearly, verbally and in writing.

Environment: IBMCognos 8.3,8.4.1,Framework Manager,Cognos go office, Report Studio, Analysis Studio, Query Studio,Powerplay Studio,SDK,AIX, Oracle10g, Informatica.

PROFESSIONAL EXPERIENCE

Confidential, Lousiville,KY Feb’10 – Oct 2010
BI Cognos Admin/Analyst

PPG Industries is a leader in its markets; is a streamlined, efficient manufacturer; and operates on the leading edge of new technologies and solutions. PPG being the world’s leading coatings and specialty products and services company, serving customers in construction, consumer products, industrial and transportation markets and aftermarkets.PPG has manufacturing facilities and equity affiliates in more than60 countries around the globe.

Responsibilities:

• Prepared functional requirements and non-functional requirements based upon the approved business requirements by following UML processes and standard procedures for developing use cases, use case diagrams and other supporting documentation.
• Substantiated the business requirements document,functional requirement documents and the Minor Document (MDD) to enhance the existing functionality of the system.
• conducted meetings with stakeholders and users to review/manage expectations and identify opportunities to improve the efficiency and productivity of the project.
• Facilitated UAT (User Acceptance Testing) for all the converted internal systems with business users, management group and team members.
• Installed and configured 8.3 enviroment.
• Converted Crystal reports into IBM cognos 8.4 reports.
• Schedule weekly meetings with end user and Project Team
• Worked on Informatica (ETL) Mappings,Mapplets and Transformations for migration of data.
• Developing Multi-Dimensional Analysis and building Power Cubes using Cognos Power Play and Transformer and created the drill through reports for the cubes
• Implemented drill-through from power play web to Cognos Server.
• Participating in code reviews ,technical reviews with database team.
• Performed Scheduling and Bursting of reports according to user requirements in Cognos connection.
• Implemented framework manager securities in various levels.
• Developed FWM models and Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts and multi-queries.
• Developed reports from DMR (Dimensionally Modeled Relational) using Cognos.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Developed dashboard reports as per the Business requirement .
• Communicating complex technical information clearly, verbally and in writing.
• Extensively provided end user Training on cognos capabilitites.

Environment: IBMCognos 8.3,8.4.,Framework Manager,Cognos go office, Report Studio, Analysis Studio, Query Studio,SDK, Oracle10g, Toad, Informatica,, Sql Server 2005,

Confidential, WalnutCreek, CA Sep’08 - Dec’09 
Cognos/BI Analyst

SAFEWAY one of the largest Food & Drug retailers in North America. Safeway Inc. is a progressive company founded on a simple value philosophy. The project was on Several Workbrain Application, Time and Attendance, Labour Forecasting and Schedule Optimization, Absence Management.

Responsibilities:

• Analyzing business user requirements with Unified Modeling language(UML)
• Implemented Framework manager security for Data access, Object level access and Package access.
• Co-ordinated with off shore team and distribute the assignment to team and vendor.
• Installed and configured IBM cognos 8.2.
• Created reports specification and documentation and schedule meetings for weekly updates.
• Integrated data in framework manager while importing metadata from different data sources.
• Developed Dashboard reports, chart reports, Cubes as per user requirements for them to make decisions on business users.
• Executed scripts to refresh the Power cubes on a daily and weekly basis.
• Involved in migration of catalogs, reports from Cognos Series 7.3 to IBM Cognos 8.4 using Migration Utilities.
• Created Cognos reports using the functionality of Actuate reports.
• Used Cognos go office objects to embedded into Excel spreadsheets and PowerPoint presentations for report components as tables, charts, graphics.
• Used Element tool for project bug tracking tool for knowing the status of issues.
• Organizing and scheduling the meeting with vendor to update on report status and tickets status. Further plans for project.
• Involved in performance tuning of existing reports and new reports.
• Extensively provided 24/7 production support for on going project.
• Provided security to the ReportNet in Access Manager through LDAP Server and configuration settings in Cognos configuration.
•  Performed User Acceptance Testing and performed troubleshooting.
• Worked on creating list reports, cross-tab reports and chart reports using Multiple Queries in a single report and by using Prompts, Filters, Calculations and Conditional Formatting in Cognos Report Studio.
• Used tabular SQL and tabular set to manually tune sql tuning and author complicated reports
• Created Informatica mappings in the Designer using various transformations and assigned them to the sessions.
•  Created informatica workflows,sessions and pulling the data from multiple sources.
• Did a proof of concept successfully for connecting Cognos 8.4 to SAP BW queries.
• Created cascading prompts, by assigning parameters created in SAP
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and product knowledge and Documentation and Training
• Deployed the reports from development to UAT environment and test to SIT environment and than into production environment.
• Extensively provided training for End user using query studio.
• Demonstrated IBM cognos tools.

Environment: IBMCognos 8.4.,Framework Manager, Report Studio, Analysis Studio, Query Studio,Cognos go office, DB2, Informatica.,SSIS,QTP, Actuate,Oracle10g,Linux,Toad,.

Confidential, ORANGEBURGH, NY Dec’07 – Aug’08
BI Cognos Developer

Verizonwireless is the nation’s leading provider of wireless communications. The company has the largest nationwide wireless voice and data network and 37.5 million customers. The project was on consolidated payroll.

Responsibilities:

• Gathered new requirements, analyzed the existing business requirements and interacted with business users.
• Designed models using Framework Manager and created joins, deployed packages to the Cognos Connection Portal
• Involved In Migration on Reports and Cubes from Reportnet to Cognos 8.3.
• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts and multi-queries. Bursted Reports against database.
• Deployed the packages and reports from development to test environment and test to production environment.
• Preparation of documentation for Cognos Framework Manager models, reports and
• Used tabular SQL to manually tune (sql tuning) and author complicated reports.
• Tested and validated the report output against the database to measure performance of the Report.
• Created ad-hoc reports and demonstrated for business users .
• Involved in performance tuning of reports.
• Scheduled the reports and bursted reports according to user requirements in Cognos.
• Created Data Dictionary for future reference.
• Extensively used the Tabular Set in the report generation.
• Developed Query Prompts, Calculations, Conditions and Filters in the reports.
• Created Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Executed scripts to refresh the cubes on a daily and weekly basis.
• Developed various dashboard reports, chart reports as per user requirements for them to make decisions on business users.

Environment: IBM Cognos 8.3- Framework Manager, Report Studio, Analysis Studio, Query Studio Cognos Transformer, Power play Window/Web,Teradata, Toad,Load runner, Oracle10g, Unix.

Confidential Oct’06 - Nov’07
Cognos Developer/Admin

UBS is a diversified financial services company that provides a broad range of banking, asset management, wealth management, and corporate and investment banking products and services. The objective of this project was to develop an efficient query system for generating reports for 9 existing applications and some cross application reports. The project also included reports for data validation in an ETL project.

Responsibilities:

• Designed models using Framework Manager and deployed packages to the Cognos Connection Portal.
• Created cude using power play transformer analyzer.
• Installed and configured Cognos 8 environment and maintain portal security.
• created user groups and provided login credentials for end users.
• Provided security to the ReportNet in Access Manager through LDAP Server and configuration settings in Cognos configuration.
• Importing data into SQL Server tables from other applications and environments.
•  Worked on IBM Cognos 8 reporting against Financial data cubes with non staged Data Source and Reporting
• Converted crystal reports to Cognos reports using migration tools..
• Collecting the data marts and creating model based on that data.
• Created database layer and business layer, defining appropriate relationship between query subjects.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Converted Actuate reports into Cognos reports and navigated functionality of reports validated and tested report in cognos environment.
• Checked the accuracy of data loaded into Teradata and assured the linkage of keys on the tables.
• Developed various Informatica Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Created calculated columns based on existing items in the model
• Extensively worked on Analysis Studio to develop multi dimensional analysis
• Designed PPES Transformer Models using Framework Manager IQD sources and built the cubes.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Triaged field incidents and worked as helpdesk support for report users.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports ,Cognos connection portal
• Environment: Cognos 8.2 - Framework Manager, Report Studio, Analysis Studio, Query Studio, Report net 1.1, Cognos Transformer, Actuate, Power play Window/Web,Informatica,Teradata, Impromptu7, Oracle, SSRS ,Unix.

Confidential Dallas, TX May’05-Sep’06
 BI/Cognos Developer

Bear Stearns is one of the largest global investment banks and securities trading and brokerage firms in the world. The project included creating some complex financial report and recreating some of the existing cubes. I was involved in identifying tables for creating business views and created models in frame work manager. Some of the reports were transaction report, marked to market value report, cash flow assignment report.

Responsibilities:

• Analyzing the User requirement for report generation.
• Published package from Report Net Framework Manager to Cognos Connection Server.
• Created folders, filters, prompts, and calculations in Report Studio/Query Studio and Framework Manager.
• Worked on Financial data and created reports using report studio.
• Developing Multi-Dimensional Analysis and building Financial Power Cubes using Cognos Power Play and Transformer and created the drill through reports for the cubes
• Involved in Create bursting reports for the web users.
• Created new Catalogs using the Impromptu software and used them for reporting purposes in Cognos Impromptu.
• Customized data by adding calculations, Filters, Prompts and Governor Settings.
• Created Time based reports using Cognos Impromptu and Cognos Power Play.
• Distributed copies of data in Local Snapshots, Remote Snapshots, Thumbnails and Hot files to improve the performance of reports.
• Generated .IQD files to feed Power Play Transformer Models to create Multidimensional cubes to generate Power Play reports.
• Developed Models based on the dimensions, levels and measures required for the analysis.
• Executed scripts to refresh the cubes on a daily and weekly basis.
• Published Cubes and Reports to Upfront through Power play Enterprise Server.
• Setup and maintain user ids, passwords and user classes using Access Manager.
• Develop clear and concise documentation on all work performed.

Environment: Cognos 8.0 , Report Net 1.1 MR3 ( Framework Manager, Report Studio, Query Studio), Cognos Impromptu, Power Play Client, Power Play Transformer, Power Play Connect, Power Play ‘\\\\
\\Transformation Server, Power Play Enterprise Server, Upfront, Cognos IWR, Oracle 9i, SQL Server 2000, , PL/SQL.

Confidential Jan’04-Apr’05
Sr. BI/Cognos ReportNet Consultant

Prime Therapeutics is a pharmacy benefits Solutions Company dedicated to providing innovative, clinically based, cost-effective pharmacy solutions for its clients and their members. The Project was to develop the reporting needs pertaining to Medicare Part-D and automate the reporting using Cognos Suite with respect to CMS regulations (Center for Medicare and Medicaid Services).

Responsibilities:

• Involved in working closely with Business Analyst to understand the business requirements and report specifications.
• Involved in the development of the Model using Framework Manager.
• Involved in Migrating catalogs, reports into report net using Migration utility tool.
• The Meta Data was standardized for easy writing of the reports by the users.
• Published packages with appropriate security settings to Cognos Connection.
• Involved in design and development of Joins, Filters and Calculations using Framework Manager.
• Worked on creating list reports, cross-tab reports and chart reports using Multiple Queries in a single report and by using Prompts, Filters, Calculations and Conditional Formatting in Cognos Report Studio.
• Mentoring Teradata Development teams, data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing
• Developed complex reports with drill-through options and Master-detail relationships using Cognos Report Studio.
• Migrating Models, packages and reports from Development to QA and then QA to the Production Environment.
• Tested and validated the report output against the database to measure performance of the Report.
• Performed Scheduling and Bursting of reports according to user requirements in Cognos connection.
• Provided End User Training and Support.

Environment: Cognos Report Net 1.1 (Cognos Connection, Report Studio, Query Studio, Framework Manager), Cognos Impromptu and Power Play, Oracle9i,,AIX,Teradata, Toad, Windows 2000.Unix.

Confidential, IL Mar‘03-Dec‘03 
Cognos Developer

The Investments Data Mart initiative\'s goal was to create a centralized reporting capability for users to perform transactional, analytical, and ad-hoc reporting and data analysis. Developed reports to highlight the various statistics like claims totals for each state, time based variant reports, city level drilldown reports, and predictive reports to estimate payments for future time periods based on current claim totals.

Responsibilities:

• Attended weekly meetings to understand and recommend the business solutions
• Installation and configuration of Cognos Report Net Environment
• Used Framework Manager to build models, packages and publish packages to the Report Net Server.
• Built models containing query subjects, query items, and namespaces from imported metadata.
• Modified packages to suit the business needs and improved the performance of the reports by defining filters and adding calculations.
• Conversion of existing PPES Impromptu Reports to report studio reports
• Developing Standard reports, Charts, Drill through reports, Master Detail reports Using Report Studio and ad hoc reports in Query Studio
• Created list reports, cross tab reports, chart reports using Report Studio.
• Created query prompts, calculations, conditions & filters, prompt pages, using Report Studio for several reports.
• Created Complex reports using custom prompts and Tabular Objects.
• Scheduling and distributing reports through Schedule Management in Cognos Connection.
• Developing Multi-Dimensional Analysis and building Power Cubes using Cognos Power Play and Transformer and created the drill through reports for the cubes
• Implemented drill-through from power play web to Cognos Server
• Associate with ETL team to build a data warehouse environment and provide constant updates about the necessary changes required

Environment: Cognos EP Series 7 (Impromptu, Power Play, Transformer, Access Manager, Upfront, IWR), ReportNet1.1 (Framework Manager, Report Studio, Query Studio), Oracle8i, 9i, SQL Server 2000.

Confidential Jun’02-Feb’03 Database Developer

HCRM (Health Care Resource Management) –
This project was developed based on total automation of hospital management. It was a comprehensive package, which dealt with inpatient, outpatient, laboratory, pharmacy, operation theatre and administration modules. My job was to work on outpatient, inpatient modules and reports related to above 
Responsibilities:

• Design and development of software related to materials management and finance.
• Documented database procedures in PL/SQL on SQL*PLUS.
• Material code and developed front end using Visual Basic.
• Documented database triggers, which would not allow change without proper authorizations in transactions viz. material return from plant goods issue, goods purchased through proper channels in purchasing department and goods receipt Physical inventory once saved in Oracle.
• Design and Implement Teradata BTEQ scripts
• Developed reports for purchase orders, sales orders, and goods issued and goods receipt. Coded database procedure to calculate average purchase price of material for current financial year for costing purpose.
• Conducted detailed study of the existing manual system.
• Good Experience in 3NF (Third normal form) data models
• Analyzed and designed the system along with senior members.
• Participated in unit testing and system testing.
• Interacted with users in implementation.

Environment: Visual Basic 5.0, Oracle 7.1, Developer 2000 (Reports), MS Access, SQL *PLUS, PL/SQL, UNIX,Teradata, Shell Scripts.