Summary of Qualifications:

• Over Eight 8 years of IT experience in Software Design, Development, and Analysis, Testing, Data Warehouse and Business Intelligence tools.
• Hands on experience in Cognos 10.2, 10.1, 8.x Query Studio, Report Studio, Analysis Studio, Business Insight/Workspace, Business Insight/Workspace Advanced, Metric Studio Score carding , Framework Manager, Cognos Connection , Cognos ReportNet 1.1, Cognos Impromptu, Cognos Power Play Transformer, Cognos Power Play, Cognos Scheduler, Cognos Access Manager, Upfront.
• Involved in gathering the requirements from the end user and translated them into the technical specifications.
• Expertise with Framework Manager Modeling Physical Layer, Business Layer, Packages and Complex Report building with Report Studio.
• 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.
• Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Extensive experience with 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.
• Created Active Reports with Tabbed Inter-phases and with Interactive Behavior of value based chart highlighting.
• Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, functions, packages.
• Expertise in Oracle 10G, 9i and MS SQL Server 2005 2008.
• Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Ability to translate business requirements into technical specifications and interact with end users to gather requirements for reporting
• Good understanding of business process in Financial, Insurance and Healthcare areas.
• Good work ethics, detail oriented, fast learner, team oriented, flexible and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills

Technical Competencies:

Hardware: IBM PC Compatibles and NT servers

OS: Windows, UNIX, Linux

OLAP tools: Cognos 10.x,8.x Report Studio, Frame work manger, Analysis Studio, Business Workspace, Business Workspace advanced , Transformer 8.3, Impromptu Administrator, PowerPlay Transformer, PowerPlay, ReportNet, Oracle

ETL Tools: Informatica 6.0, 7.1, 8.1, 8.6, Data stage 7.5

Databases: Oracle 7.x/8.x/9.x/10g, SQL Server 2005 2008, SQL Loader, Teradata

RDBMS: Stored Procedures, Database Triggers, and Packages

Languages: C, C , Java, COBOL, VB, .NET, PHP, Assembly language

Multimedia: Adobe Photoshop, Flash, Dreamweaver

Tools: Make, RCS, AutoSys, Clear Case, Toad, BTEQ

Miscellaneous: TCP/IP Sockets, Sun RPC, XML

Version Control: CVS

Professional Experience:

Confidential

Role: COGNOS Developer / Administrator

Roles Responsibilities:

• Prepare Technical Design Documents based on Functional requirements and implement most complex business requirements using BI tools.
• Develop List, Crosstab, and Chart Reports in Report Studio using Framework Manager Package, SQL and PL/SQL.
• Design and develop complex drill through, master detail and Burst reports using IBM Cognos 10.1.1 functionality.
• Develop new relational and dimensional Framework manager Package using OLTP and OLAP data source and maintain existing packages to meet the business requirement.
• Experience migrating reports from OBIEE to Cognos 10.2.
• 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 Preferences 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 401Kplan were displayed as dashboards showing their investments, returns, losses, dividends earned, etc.
• Developed various HR reports MTD, QTD, YTD, last fiscal year, current fiscal year reports, employee taxable, paid time offs, holidays, sick leaves, workers compensation report WCR etc. These reports were mainly on employee level but I also developed scorecard and dashboard reports which were mainly developed for the departmental heads and regional heads.
• Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.
• Develop dashboards using IBM Cognos 10.2.1 Business Insight Advanced.
• Design and develop IBM Cognos Power Cubes on windows platform to fulfill business requirement which helps management and customers in making key business decisions based on cube analysis.
• Set up automation for IBM Cognos10.2.1 daily and monthly cube build process.
• Develop complex reports using Tabular Set and Tabular SQL to meet business requirement.
• Design and develop reports using of Conditional Blocks and Conditional Styles to fulfill complex business requirement into a single report and to highlight key data.
• Use various prompts like value, text and date prompts with customization for all the reports developed in IBM Cognos 10.2.1
• Publish Cognos power cubes as data source and packages to IBM Cognos10.2.1 connection.
• Help off-shore development team members to overcome technical challenges in using IBM Cognos tools and develop system process documentation and debugging procedures.
• Prepare Business logic for existing reports.
• Help end users to understand Data warehouse and BI Tools.
• Good Experience working on the ESRI Maps 4 and 5.
• Worked on content including ArcGIS Online Base maps, demographics, and landscape.
• Worked on Geo spatial Mappings using ArcGIS 10.1

Environment: Cognos 10.2/10.1.1 ,Transformer, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, ArcGIS

Confidential

Role: COGNOS Developer / Administrator

Roles Responsibilities:

• Work directly with business customers to build portals, reports, dashboards with the Cognos BI authoring suite Framework Manager, Report Studio and Transformer.
• Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, cubes and integrating with SharePoint.
• Manage Cognos metadata, Folder structure and utilize Cognos 10.2 advanced features.
• Responsible for implementing best practices on Cognos Dashboards, Scorecards, Portal, report design, development and testing.
• Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.1.
• Created Burst Reports and Multilingual Reports based on groups of users Preferences for our Asian, African and European partners.
• Created Drill Through Reports Master Detail Reports for Accounts Department.
• Creating OLAP cubes using Transformer, creating Framework models.
• Developed various Management reports MTD, QTD, YTD, last fiscal year, current fiscal year reports, and employee taxable. MTD, QTD, YTD, Clients, Costumers, sales, shops, Products, etc.

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

Confidential

Role: COGNOS Developer/Cognos Administrator

Roles Responsibilities:

• Developed Technical Design Documents.
• Developed logical physical modeling as per business requirements using ERWIN 3.5
• Designed and developed snow flake /star schemas 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
• Created complex reports in Cognos mainly dealing with 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.
• Created models in Transformer, built cubes and published cubes to Analysis Studio
• Carried out performance tuning of reports.
• Migrated content from 8.4 to 10.2 environments
• Worked on Cognos dynamic cubes to replace the existing OLAP cubes and repoint the reports to hit the in memory cubes developed.

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

Confidential

Role: Sr. Cognos Consultant/Analyst

Roles Responsibilities:

• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the 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 the 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 Cognos Framework Manager and deployed packages on Cognos Connection.
• Installed and configured Cognos 8.4 BI and worked with Cognos 8 BI modeling, Report Studio.
• Responsible for Access permission and administrating the server.
• Created highly Customized reports in Cognos 8.2 Report Studio and some of the Ad-hoc reports in Query Studio.
• Used HTML and Java Scripts for Advanced reporting purpose.
• Gathered information like attempted calls, type of call long distance, local , length of call, originated number, destination number, rates, time of call for creating report for billing of a customer.
• Implemented security in reports according to employee groups and roles according to the requirement.
• Involved in Creating Content store, installation and Configurations of the ReportNet.
• Implemented Tree prompt and MDX Commands in Cognos.
• Developed Portlets and dashboards reports according to the user requirements.
• Tuned cube builds Impromptu Reports and ReportNet reports and servers for better performance.
• Implemented Data Security using LDAP in Framework Manager 8.2.

Environment: Cognos ReportNet 8.1/8.2,8.4,Framework Manager, Report Studio, Query Studio, Analysis Studio , Transformer, PowerPlay Enterprise Server, Cognos Impromptu, LDAP, Access Manager, IIS, Informatica, PeopleSoft, server 2005,Oracle 9i,TOAD

Confidential

Role: Cognos Developer/Consultant/Analyst

Roles Responsibilities:

• Involved in requirement gathering during the business analysis and planning phase of the project.
• Built Framework Manager Models and established the cardinalities to suit the business needs.
• Created list, cross tab, chart reports including report studio features such as filters, calculations, prompts, Conditional Formatting, sections and Page Breaks.
• Developed various report formats, which were approved by the business Users.
• Created Drill- through and Master -Detailed Reports with Prompts List. Cross tab .
• Involved in Cognos Administration using Cognos Connection for security implementation, scheduling, distributing reports and performance tuning.
• Developed various complex models in framework manager which included the tables from two different data sources i.e. SQL SERVER and ORACLE.
• Developed Adhoc reports using Query Studio.
• Configure, support and maintain online BI applications and SQL reporting.
• Involved in performance tuning for Reports and Framework model.
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Resolved issues resulting from User Acceptance Testing UAT .
• Provided extensive end user support and training on Ad-hoc reporting using Query Studio.
• Documented Entire Data Flow, Program Development, Logic, Testing, Changes and Corrections.
• Conducted the training session for the employee and users

Environment: Cognos 8.4 Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformer SQL Server, Oracle10 g, Toad.

Confidential

Role: SQL/Cognos Developer

Roles Responsibilities:

• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Created the deployment scripts after the development is done for every project.
• Developed and customized Impromptu Reports and PowerPlay Reports.
• Used Cognos Impromptu tool to create standard and ad-hoc reports.
• Customized catalogs and created user profiles to grant user permission for accessing data from different database tables.
• Customized data by adding Filters, Prompts, Calculations, Summaries, and Functions.
• Developed Multi-dimensional Cubes using PowerPlay.

Environment: Cognos ReportNet 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Cognos Transformer 7.x, Impromptu 7.x, PowerPlay 7.x, Cognos Upfront, Cognos Script Editor, Microsoft Excel, Oracle 9i, MS SQL Server 2000