Experience Summary:

• Over 7 years of IT experience in developing Data Warehousing/BI applications using Cognos BI and ETL Tools.
• Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using IBM COGNOS
• Hands on experience in Cognos 10/8 Suite (Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Report net 1.1.MR3, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Power Prompts, and Analysis Tools such as Cognos Transformer & Power Play 7.x/6.x, Cognos Visualiser 7.0, Access Manager and Server Installation & Maintenance.
• Experienced with full life cycle and Methodology for implementing Data warehouse and Business Intelligence reporting system.
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Good Knowledge on Cognos 8 Planning.
• Installed and Configured Cognos 8.3 in single server Environment.
• Experience in the installation and administration of Cognos ReportNet 1.0/1.1MR2 in a distributed environment.
• Strong experience in Business Analysis, Data Analysis, Data Modelling and Erwin in Data Warehousing environment.
• Expertise in relational and dimensional modelling.
• Expertise in Report building using Report Studio and Analysis Studio.
• Experience in Transformer model design and Power play cube building.
• Experience in Installation and configuring the Cognos 8 and CRN environment and implementing third security tools Tivoli directory Server and Sun One with Single Signon.
• Developed OLAP solutions using Cognos suite of tools.
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Good Knowledge on Cognos TM1 9.5 (TM1 Architect,TM1 Prespective for MS Excel,TM1 Web,TM1 Contributor,TM1 Turbo Integrator), Developing TM1 cubes, Cognos Power Cubes, and Cognos dashboards.
• Import the data from ODBC and Text files using TM1 Turbo integrator.
• Using turbo integrator to identify and map dimensions and data from an external data source to or existing source.
• Created regularly scheduled automated jobs to load TM1 data structures
• Strong experience in writing SQL Queries. Experience in Oracle 10g/9i/8i, PL/SQL, Stored Procedures, Functions, Triggers, SQL Server 2000/2005.
• Having knowledge on ETL tools like Informatica.
• Worked with senior academic and administrative officers in support of financial management.
• Experience in interacting with end users to gather requirements for reporting.
• Coordinated with the client representative to resolve any functional and technical issues faced by the project team.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.

Education: Bachelor of Technology in Electronics and Communication Engineering.

Certifications: IBM Cognos 8 BI Certified professional

TECHNICAL EXPERTISE:

COGNOS 10/8 (Framework manager, Metric Manager ,Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio, Metric Studio, Cognos EP Series 7.3, Business Objects 5.1, Cognos Impromptu 7.3, Power Play 7.3, COGNOS TM1 9.5 (TM1 Architect, TM1 Prospective for MS Excel, TM1 Web, TM1 Contributor, TM1 Turbo Integrator

Operating Systems:

Windows 95/98/NT/XP/2000,UNIX

Languages:

C,SQL,PL/SQL

Database/ETL Tools:

Oracle 8i,9i,10g,11g, MSSQL Server 2000, 2005, DB2, Informatica, Datastage,

MS Applications:

Advanced Excel, Word, Advanced PowerPoint, Visio.

PROFESSIONAL EXPERIENCE:
Confidential, MI Sep 10- Present
Domain: Health Care
Sr. Cognos Developer
Confidential,is one of the leading Pharmaceutical company. ProHELPDESK is the primary component of a larger pharmacy benefits management solution, ProPBM. The ProPBM system provides online, real-time claims adjudication, network editing, reliable reporting, and system flexibility. The key system features include Benefit Design Flexibility (BDF), Member Eligibility, Help Desk Tools and Centralized Prescription History

Responsibilities:

• Developed Technical Design Documents.
• Interacted with users for gathering requirements.
• Involved with the Solutions Architect and the QA team for validation and verification of the development.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Designed models in Framework Manager.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Created list, crosstab and drill through reports for Markets like OAB,IMM,MIG,TCI in Report Studio.
• Created Burst Reports .
• Created Drill Through Reports & Master Detail Reports for different Departments.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio.
• Created metrics, score cards using Metric Studio.
• Import the data from ODBC and Text files using TM1 Turbo integrator.
• Using turbo integrator to identify and map dimensions and data from an external data source to or existing source
• Deployed the TM1 applications to TM1 web and Contributor
• Using Turbo Integrator to Create Dimensions, Populate Cubes etc
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.
• Wrote queries in Oracle, Sql server for data validation and for development etc.
• Wrote and executed the test cases for various reports that were developed in Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Carried out performance tuning of reports.
• Used Union, Intersection, joins, except for creating queries.
• Developed various reports – MTD, QTD, YTD, last fiscal year, current fiscal year reports,
• Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.
• Exceptionally good and experienced in handling the problem and troubleshooting.

Environment: Cognos 10/8.4 Suite (Cognos Connection, Framework Manger, Metric Manager, Metric Studio, Report Studio, Query Studio, Analysis Studio, Cognos Insight,Cognos Office Connection),COGNOS TM1 (TM1 Architect,TM1 Prespective ), Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, SQL Navigator, Unix.

Confidential, RI May 09 – Aug 10
Domain: Insurance
Sr Cognos Developer
Confidential, staff assists policyholders in implementing safety and return-to-work programs that are customized for their particular business. We are dedicated to providing continuous coverage and have the largest claim staff dedicated to workers\' compensation.

Responsibilities:

• Interacted with end Users to identify key dimensions and measures that were relevant quantitative metrics in the analysis.
• Worked efficiently as a team player and interacted well with the ETL Architects and Database Architects in challenging and solving the issues.
• Collecting the metadata and creating models using Framework manager.
• Created Relationships between tables and created different layers like Database layer, Business layer and Dimensional layer.
• Created Packages and published for Report Studio reporting. Created Business Detailed reports using Report Studio and Ad-hoc reports using Query Studio.
• Assigned security at different levels Package level, data level, Object level.
• Granted and revoked permissions (Write, Read, Execute, Set Policy, Traverse) to Users and Groups.
• Creation of Master Catalogs and Reports using Impromptu and Power play.
• Exported and Imported Packages.
• Created multiple layer report providing a comprehensive and detail report with Drill through facility.
• Converted consumer related reports from Crystal Reports to Cognos (Impromptu and Power play reports).
• Responsible for definition, deployment and monitoring of important organizational metrics using Cognos Metrics Manager.
• Extensively used Power play Transformer to move relative data mart data into power cubes.
• Built models using Framework Manager a Report Net Tool.
• Worked on securing Cognos Connection and Cognos Administration and setup Report Net security by assigning users to the groups and roles defined in Cognos Namespace
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Scheduling large amounts of jobs such as reports or event notifications.
• Tested and improved Report Performance.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Office Connection), Oracle 10g, Cognos Access Manger, Windows 2003 Server, IIS Web Server, SQL Server 2005, Informatica 7.2 Clear quest ,DB2,Unix.

Confidential,Cypress, CA Aug 08 – Apr 09
Domain: Health Insurance
Sr. Cognos/ETL Developer

Responsibilities:

• Involved in Requirement gathering from End Users.
• Extracting the data from different Data Sources and loading to data mart usingCognos Decision Streamas ETL
• Design and build Cognos Decision Stream Fact Builds to extract, cleanse and
• Query data from an Oracle Data Warehouse
• Created Business Requirements and High-level design documents.
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• 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.
• Created packages in Framework Manager to publish cubes to Analysis Studio.
• Created Power play cubes using Transformer (Power play).
• Data retrieval, Multidimensional analysis, Power Play structure.
• Changing filters, layers and measures.
• Created Multi-Dimensional reports using Power Play.
• Created Business Mix reports and Top ten reports.
• Designed and developed multi dimensional cubes, Visualizations.
• Queried data from different database tables as per the requirement.
• Joined the different table as per the requirements.
• Created reports in HTML format for easy navigating of data from web browser.
• Customized data by adding calculations, summaries and functions.
• Created List Reports, Cross Tab Reports and Drill Through reports.
• Generated reports using Cognos Impromptu tools querying database.
• Created Filters, Conditions and Prompts in Catalog.
• Developed Impromptu Web Reports (IWR) and published them into Upfront.
• Presenting complex data summary report.

Environment: SQL Loader, SQL, PL/SQL, DB2, Oracle 8.x, Cognos Impromptu 7.0, Impromptu Web reports (IWR), Decision Stream, Power Play, Transformer, Toad, Windows 2000/ UNIX, IIS Web Server, SQL Server 2005, SSIS.


Confidential,Detroit (MI) Jun 07- Jul 08
Cognos Consultant

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Giving estimation of efforts required
• Imported metadata from multiple data sources to build a HR model and publishing packages in Framework Manager to the Report Net server.
• Extensively worked on relationships (cardinality) between query subjects to better represent the logical structure of the business and the user requirements.
• Created list reports, cross-tab reports and chartØ reports using multiple queries in a single report.
• Created various Report Studio reports using calculations, filters, prompts and conditional formatting, drill through.
• Validated report results with the source data and authorized the reports to production environment.
• Scheduled Reports and Jobs to run periodically.
• Worked on securing Cognos Connection and setup Report Net security by assigning users to the groups and roles defined in Cognos Namespace.
• Created several drill through to several reports for providing better functionality.
• Provided technical assistance, training and mentoring to Users and Business Partners.
  Environment: Cognos Report Net 1.0, Internet Information Services (IIS) 5.1, MS SQL Server, Windows 2000, Impromptu 7.1 Transformer 7.1 and Power play windows and Web.

Environment: Cognos Report Net 1.0 Impromptu 7.1 Transformer 7.1 and Power play windows and Web. Oracle 9i, PL/SQL, TOAD, Windows 2003.

Confidential,Hyderabad, India Apr 06 - May 07
Domain: Financial
Oracle Developer
The system has centralized database to maintain all relevant information regarding Credit Information. The transaction data will be ported to this centralized database from the branches either through data import or through manual entry. The system allows the user to generate various kinds of reports and queries. Master Information, Transaction entry, Data import, Report module, Query module

Responsibilities:

• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Extensively used PL/SQL to extract data from different tables with 20 Million records in some of the tables
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used.
• Incorporated validation rules for promotion history table and updating tables.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Environment: Oracle 8i, PL/SQL, SQL*Plus, UNIX.

Confidential,Ahmedabad, India Jan 05- Mar 06
Oracle PL/SQL Developer / Team Member

Confidential,Ahmedabad India is the leading manufacturer of pigments and Dyestuffs. ICI is dedicated ISO-9001 Company. The company has been serving its valuable clients for the past 50 years. It is well supported by qualified techno-commercial professionals for better customer service and application support.. We continuously upgrade our product to meet the new challenges in the modern Hi-tech world. The aim of this project was to enhance certain modules of the inventory management system for Indian Chemical Industries.

Responsibilities:

• Clarified the requirements by talking to the user groups and accordingly modified the functional and technical specifications
• Developed / modified Oracle PL/SQL codes like stored procedures, functions, triggers etc based on technical and functional specification documents
• Developed / modified scripts to create tables, views and executed them using SQL Plus
• Developed / modified scripts to rectify data errors and executed them using SQL Plus
• Ran batch jobs for loading database tables from flat files using SQL Loader
• Prepared unit test cases and executed the same.

Environment: Oracle 8i, PL/SQL, SQL*Plus, UNIX.