SUMMARY:

• Over 8+years of professional IT experience in Cognos 10.2/10.1.1/8.4, 8.3, Cognos Report Net, Framework Manager, Query Studio, Report Studio, Analysis studio, Metric Studio and Cognos Connection.
• Expertise wif Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building wif Report Studio.
• Worked in BI for major health insurance and financial companies.
• Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.
• Experience developing complex reports using drill - through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos.
• Expertise in creating Dashboard reports using Java Script in Report studio.
• Experienced in building scorecard reports and dashboard reports using metric studio.
• Expertise in building Multidimensional Cubes, Scorecards, Dashboards and Report Studio complex reports for higher management.
• Experience in Extraction Transformation Loading (ETL) Process, Creation of Data Marts using Decision Stream and Informatica.
• In-depth noledge on SQL queries and working wif SQL Server 2000/2005/2008.
• Extensive experience wif Cognos security (LDAP, Active Directory, Access manager, object level security, data security).
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8.X Environment.
• Profound noledge in Transformer model design and Power play Cube building
• Extensive experience on production support and troubleshoot/test issues wif existing reports and cubes.
• Ability to translate business requirements into technical specifications and interact wif end users to gather requirements for reporting and trained them in Ad-hoc components.
• Implemented Tree Prompt, complex dimensional reporting using teh MDX commands in Cognos.
• Work Experience on multiple platforms like Windows XP, Windows 2000/NT, Sun Solaris, IBM AIX, UNIX shell scripting.
• Good interaction wif clients, understanding Business Applications, Business Data Flow and Data Relations.
• Excellent understanding of Software Development Life Cycle and dimensional modeling techniques using Star and Snow-flake Schema Modeling
• Strong noledge on Internet based reporting and strong Analytical skills and attention to detail
• Providing support during theUser Acceptance Testing.
• Good experience in working wif web servers like IIS, Apache, IHS etc.
• Excellent team player and Superior organizational and time management skills
• Excellent Inter-personal skills and a quick learner. Ability to get along wif teh team well, proven leadership qualities and client co-ordination.
• Possessed excellent communication skills and inter-personal skills.

TECHNICAL SKILLS:

BI Tools: Cognos 10.2.1/10.1.1/8.4.1/8.3, Report Net 1.0/1.1(Report Studio, Query Studio, Cognos connection, Framework Manager), Cognos Impromptu 7.x, Cognos Transformer & Power Play7.3/7.4, Impromptu Web Reports (IWR),Cognos visualizer 7.0, Cognos Query, Cognos Upfront, Cognos Power Play, SQL server reporting services(SSRS),SQL Server Analysis Services(SSAS),MS Excel 2007.

ETL: Informatica Power Center 8.x, SQL Server Integration Services (SSIS)

Databases: Oracle 11g, 10g, 9i, MS SQL server, MS Access, DB2

Database Tools: TOAD, SQL Server Management studio, and Enterprise Manager

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: C, C++, SQL, PL/SQL, T-SQL, HTML, JavaScript and XML

Web Servers: Apache web server, and Microsoft IIS 4.0

OS: Windows 2000, Server 2003, XP, VISTA, Windows NT 4.0, Linux, and UNIX

Other tools: Microsoft office suite

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Cognos Developer

Responsibilities:

• Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developed Technical Design Documents.
• Developed logical & physical modeling as per business requirements using ERWIN 3.5
• Designed and developed snowflake/starschemas for better understanding of models using ERWIN.
• Designed DMR models 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 departments like claims, billing, members/subscribers in Report Studio
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Created Burst Reports and Multilingual Reports based on groups of users &Ps for our Asian, African and European partners
• Created Drill Through Reports & Master Detail Reports for Accounts Department.
• Used Union, Intersection for creating queries.
• Created dashboards, portlets for various HR and payroll related reports. E.g. investments related to 401K plan were displayed as dashboards showing their investments, returns, losses, dividends earned, etc.
• Developed reports on risk analysis by comparing teh internal data wif teh Experian risk analysis data. dis enabled teh Sr.management to take better risk decisions.
• Created complex reports dat had multiple pages, wif multiple lists, charts, graphs, etc.
• Created complex reports in Cognos mainly dealing wif Member Data, Claims data and Provider Data.
• Created score cards using Metric Studio.
• Wrote Procedures and triggers in Oracle for file handling, data validation, Inserting data etc.
• Wrote and executed teh test cases for various reports dat were developed in Cognos.
• Involved wif making changes in teh reports generated as business requirements changed and carry out validation and verification of teh reports.
• Created models in Transformer, built cubes and published cubes to Analysis Studio
• Carried out performance tuning of reports, model and database. (Indexes, partitions)
• Interacted wif ETL team to gather teh requirements for teh reporting.
• Involved wif teh Solutions Architect and teh QA team for validation and verification of teh development.
• Worked on a POC for 10.2.1 dynamic cubes which is an In-memory technology dat got introduced in teh new version. dis is in par wif transformers wif better performance.
• Exceptionally good and experienced in handling teh problem and troubleshooting.
• Trained End users to operate teh reports.

Environment: Cognos 8.4, Transformer, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, and UNIX.

Confidential - Wilmington, DE

Cognos Developer

Responsibilities:

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Involved in gathering business requirements.
• Analyzed teh business requirements and developed a model using Cognos framework manager and published packages for reports development.
• Developed list reports, crosstab reports and chart reports using report studio.
• Modified teh prompt pages using HTML Scripts.
• Created Complex reports using Multiple Drill through, Conditional Layout.
• Created New Jobs using Cognos Connection.
• Scheduled Reports through Schedule Management in Cognos Connection.
• Defined, stored and maintained security information using Access manager.
• Coordinated all communications wif teh Database Management team.
• Unit testing of teh reports to ensure teh correctness of teh data and responsible for resolving issues after QA testing.
• Developed, managed, and coordinated all user acceptance testing.
• Involved in business users in Cognos Query Studio. Documented teh whole reporting process.
• Responsible for creating DMR model for simple adhoc reporting and analysis.
• Experience in writing SQL, T-SQL, PL/SQL Packages, Stored procedures, Functions, Triggers as per teh business needs.

Environment: Cognos 8.4 Framework Manager, Report Studio, Query Studio, Event Studio, Cognos Connection,Windows 2003 Enterprise Server, IIS Web server, and oracle 10g.

Confidential - Newark, NJ

Senior Cognos Developer

Responsibilities:

• Developed teh Complex ADR catalog, Set up joins.
• Developed 150 reports along wif teh team by following teh industry standards for formatting.
• Developed teh complex State Group Cube wif teh Structure teh Users wanted Transformer.
• Designed and Developed most complex Report named Monitoring and supported it.
• Maintained teh access manger structure from Development to QA to Production
• Interacted wif teh users to gather teh Powerplay requirements for Cubes. Developed teh standard Powerplay reports.
• Interviewed business community to identify business, data, and delivery requirements.
• Designed models in Framework Manager.
• Updated & administered teh security privileges at object level and data level for teh user profiles in Framework Manager.
• Worked wif Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and PROMPTS depending on user requirements.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio
• Created reports containing multiple data containers like List, Cross-tab and Repeater tables
• Created dashboards for a managerial overview wif drill up and drill down capabilities.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Worked on TOAD for Oracle database systems for creation of adhoc queries and for improving various performance issues.

Environment: Cognos 8.2, Transformer 8.3, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 RTM SDK.

Confidential - Dallas, TX

Cognos Developer / Cognos Administrator

Responsibilities:

• Coordinating wif Database team in setting up teh required Materialized views, Aggregated and De-Normalized tables for teh Reporting and Analysis needs.
• Managed Core Project, Responsible for delivery and resource allocation etc.
• Creating Teradata views and imported views and employed relation between views.
• Developed DMR modeling using Cognos 8 Framework manager.
• Enhanced teh model, Tested and Created replacement IQDs’ using Framework Manager.
• Created Dimension IQD’s and Fact queries in Frame work Manager.
• Created Projects, Models, and Packages using CognosFramework Manager and deployed packages on Cognos Connection.
• Installed and configured Cognos 8.2 BI and worked wif Cognos 8 BI modeling, Report Studio.
• Responsible for Access permission and administrating teh server.
• Created different packages which contains teh information about teh customer like,cust name,address,ph no,plan used,mins used,mins remaining,rollover minutes.
• Implemented security in reports according to employee groups and roles according to teh requirement.
• Involved in Creating Content store, installation and Configurations of teh Report Net.
• Experience in Deployment (Export, Import) using Cognos Connection Portal in Cognos 8.2 and Report Net.
• Tuned cube builds Impromptu Reports and Report Net reports and servers for better performance.
• Migrated numerous existing Cognos 7.4 impromptu catalogs to Cognos 8.2 Framework manager.

Environment: Cognos Report Net 8.1/8.2,Framework Manager, Report Studio, Query Studio, Analysis Studio), Transformer, Power Play Enterprise Server, Cognos Impromptu, LDAP, Access Manager, IIS, Informatica, PeopleSoft, server 2005,Oracle 9i,TOAD.

Confidential

Associate / Cognos BI Developer

Responsibilities:

• Involved in analysis of teh specifications provided by teh clients along wif team members and team lead.
• Developed new module as per teh business requirements.
• Executed SQL commands, wrote PL/SQL commands, Stored Procedures for teh existing intranet applications.
• Design and develop new modules.
• Involved in System Integration testing and Unit testing.

Environment: MS SQL Server 2005, SQL, PL/SQL, Oracle 9i, Visual Studio, ASP.Net, VB.Net, and Visual Source Safe