SUMMARY:

• Experience in creating complex reports, drill through reports, dashboards, master - detail, list, crosstab, charts using report studio.
• Experience in Framework Manager Modeling (Database Layer, Business Layer, Presentation Layer).
• Experience in developing multi-dimensional model design and cube building using Cognos Transformer.
• Experienced in performance tuning and optimizing of the reporting solution.
• Experience in developing TM1 applications / cubes in support of business needs and develop TI processes and TM1 rules in Cognos TM1.
• Experience in databases such as Oracle 10g/9i/8g, SQL SERVER 2000/2005, DB2 and Teradata
• Experience in writing SQL, PL/SQL, T-SQL as per business requirements.
• Experience in Designing and developing the information links, Data Source, Columns, Joins, Filtering and Procedures in TIBCO Spotfire.
• Experience in Installing & Configuring Cognos Application & Web Server.
• Experience in Cognos Administration tasks like creating new namespaces, assigning roles and giving Cognos access to new users.
• Experience in Workspace Insight and Workspace Insight Advanced.
• Have a knowledge on Property and Casuality insurance.
• Experience in interacting with the end users to gather and document requirements and suggesting them the capabilities of Cognos tool to effectively display the information they need.
• Strong knowledge in data warehousing concepts (Star schema, Snow Flake Schema, Fact constellation schema).
• Good knowledge in Financial Concepts like Risk analysis, Debt & Equity Financing, Risk & Portfolio Management, Planning, Forecasting & Budgeting.
• Strong knowledge in analyzing financial statements and Financial Data.
• Familiar with Generally Accepted Accounting Principles (GAAP).
• Have knowledge on Cognos Mobile.
• Have Knowledge on Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Strong proficiency with excel skills (VLookup, HLookup, INDEX, Pivot tables, etc.)
• Strong ability to analyze user requirements.
• Proficient in building front-end BI applications according to specifications.
• Strong analytical, conceptual, and problem-solving abilities.
• Ability to understand organization's goals and objectives.

TECHNICAL SKILLS:

BI Tools: Cognos 8,10 BI Suite (Framework Manager, Cognos connection, Query Studio, Report Studio and Analysis Studio), Cognos Workspace Advanced, Cognos Transformer, Business Insight, Cognos TM1, SAP Business Objects, Cognos Active Reports, Cognos SDK, SSRS, TIBCO Spotfire 4.5.

Programming skills: C, C++, Core Java, HTML, JavaScript, SQL, PL/SQL, T-SQL.

Databases: MS SQL Server, Oracle 10g, 11g.

ETL Tools: Informatica Power Center, IBM DataStage, SSIS.

Operating Systems: Windows XP/VISTA, UNIX.

Other Tools: MS Excel, MS Word, MS PowerPoint, MS Outlook, TOAD, SharePoint.

PROFESSIONAL WORK EXPERIENCE:

Confidential, Orangeburg, NY

Cognos lead

Responsibilities:

• Managing BRD and coordinating with the off-shore team.
• Interacted with business users to gather requirements for the new Wireline Staffing dashboard.
• Created dashboard with Pie, Column, Crosstab, Combination & Trending graphs. Enabled drill thru facility to these graphs.
• Trained business users in query studio and report studio, suggested business users how their information can be effectively displayed by using different graphs and charts in Dashboards. (Conveying information they need concisely).
• Implemented data security to dashboard enabling users to view data based on their designation.
• Created new Framework manager models and published packages with Data security.
• Created new user groups in Cognos Administration and implemented security based on these user groups for the new Learning Dashboard.
• Created a Learning Dashboard with multiple tabs and passed parameter values between tabs enabling global prompts.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Created Multi-Dimensional Cubes using Cognos Transformer.
• Automated jobs and updated packages using Cognos SDK.
• Migrated reports and packages from Cognos 8.4 to Cognos 10.2.

Environment: Cognos 8.4 & 10.2 BI suite (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio and Event Studio),Cognos SDK, JavaScript and HTML, Oracle 10g, Cognos Transformer, Windows 7, MS Outlook, SQL,TOAD, XML and HTML.

Confidential, Juno Beach, FL

Cognos BI Developer

Responsibilities:

• Interacted with users and understood the Tax laws & rates for various jurisdictions to develop Use & Sales Tax reports.
• Coordinated with Accounts team and created Invoice Reports, PBOOK transaction reports, Authorization Limits reports.
• Created 30 Ad hoc reports for Accounts Payable Department.
• Created Drill Through reports, List reports & reports involving Multiple Prompts.
• Consolidated existing Cognos reports.
• Developed new Cognos reports from the SQL ad hoc and COBOL reports.
• Developed excel & web reports in Cognos TM1.
• Resolved defects in Cognos TM1 cubes.
• Worked on defects related to the existing reports.
• Increased report performance by minimizing the usage of outer joins, OR clause in filters and recommended Information Management team for summary tables and indexes when necessary.
• Created MS Access reports for LTAM (Long Term Asset Management) department.
• Recommended Query subjects and Joins for new Framework Manager Packages.
• Prepared Software Requirement Specification (SRS), Software Classification Determination (SCD) documents for the new Cognos reports.
• Created test plans and documented Impact Analysis and Software Production Release (SPR) forms.
• Used TOAD for Oracle for validating the report output.

Environment: Cognos BI (Report Studio &Query Studio),Cognos TM1, JavaScript, Oracle 10g, TOAD, SQL, SharePoint, HP Quality Center, Informatica Power Center, MS Access, MS Outlook and Windows XP Professional.

Confidential, South Brunswick, NJ

Cognos Consultant

Responsibilities:

• Interacted with the Business users and documented their requirements and Reporting needs. Understood data and business logic underlying the requirement.
• Implemented Star Schema Grouping based on reporting requirements and subject areas.
• Build Subject area Packages and Published Packages to the Report Server using Framework Manager.
• Modeled metadata from MS SQL server data source for use in Report studio and Query Studio using Framework Manager.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Migrated reports from Cognos EP Series 7 (7.3 and 7.4) to Cognos 8 BI 8.4.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Designed and created Multi-Dimensional Cubes using Cognos Transformer.
• Created and performed testing strategy and test plans for any changes/upgrade to Cognos Reports.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Involved in migrating reports from Development to Testing and from Testing to Production Environments, creating Connect Strings and synchronizing the Connect Strings and Connection Objects in Dev, Test and Prod environments.

Environment: Cognos 8 BI suite (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio and Event Studio), JavaScript and HTML, MS SQL server, Cognos EP Series 7, Cognos Transformer, Informatica Power Center 8.X, Windows XP Professional, SQL, XML and HTML

Confidential, San Antonio, TX

Business Intelligence Developer

Responsibilities:

• Involved in Designing models using Framework Manager and deployed packages to the Report Servers.
• Implemented Star Schema Grouping and Dimensional Hierarchy in Framework Manager Model.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Multi-query, Cubes in Report Studio.
• Created custom prompt reports and dashboards in Report Studio.
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Created Multi-Dimensional Cubes using Cognos Transformer.
• Created reporting and dashboards with IBM Cognos BI and multidimensional TM1 cubes
• Created cubes and dimensions using Turbo Integrator.
• Migrated catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Implemented third party authentication tool like LDAP to add user groups and roles.
• Developed the mapping specifications from the business requirements and the data model. Involved in data modeling and design of the data warehouse.
• Setup and configured ETL runtime environment in Dev, TST, QA instances for efficient, time-constrained batch loads.
• Validated and unit tested reports by writing manual SQL against the database.

Environment: Cognos 8 BI Suite (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Impromptu 7.4,Cognos Power Play 7.4, Cognos Transformer 7.4, Cognos TM1,Informatica Power Center 8.X, Oracle 10g, SQL, VB Script, XML and HTML.

Confidential

Software Engineer

Responsibilities:

• Interacted with the Business users and documented their requirements and Reporting needs. Understood data and business logic underlying the requirement.
• Implemented Star Schema Grouping based on reporting requirements and subject areas.
• Build Subject area Packages and Published Packages to the Report Server using Framework Manager.
• Modeled metadata from MS SQL server data source for use in Report studio and Query Studio using Framework Manager.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, and complex reports which involved Multiple Prompts in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Developed Dashboard reports to display all the information related to environment using Summary reports.
• Worked on Analysis Studio to develop multi dimensional reporting.
• Created Multi Dimensional Cubes using Cognos Transformer.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Created and performed testing strategy and test plans for any changes/upgrade to Cognos Reports.
• Validated and unit tested reports by writing manual SQL against the database.

Environment: Cognos 8 BI suite (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio and Event Studio), JavaScript and HTML, MS SQL server, Cognos Transformer, Informatica Power Center 8.X, Windows XP Professional, SQL, XML and HTML.