SUMMARY:

• Having more than 8 years of IT experience in Software Design, Development, and Analysis, Teradata, Testing, Data Warehouse and Business Intelligence tools.
• Hands on experience in Cognos Analytics 11,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)
• Experienced in Installation and Configuration of Cognos BI Products in Distributed environment on Windows
• Expertise with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Integrated Remedy with Cognos reporting tool using cognos API,
• 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 dat 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).
• 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.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Experienced with MS SQL Server BI Tools like SSIS, SSRS and SSAS.
• Involved in creation of packages, Data and Control tasks, Reports and Cubes using MS SQL Server BI Tools.
• Ability to translate business requirements into technical specifications and interact with end users to gather requirements for reporting.
• Trained end users in Ad-hoc components like workspace and created documentation on the same.
• Worked closely with business users in refining the product requirement backlogs and documenting the same.
• Good understanding of business process in Financial, Insurance and Healthcare areas.
• Involved in infrastructure design for the cognos environment and security setup for different groups as per business requirement.
• Creating training material on all the Ad-Hoc training
• Worked on all the basic administrative tasks like deployments, routing rule setup’s, user group setup, folder level securities etc.
• Have deployment knowledge of IBM Cognos report in Application servers like WAS.
• Have knowledge on handling securities and administration functionalities on IBM Cognos 10.x
• 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 SKILLS:

OSWindows: Mac, Linux

OLAP tools: Cognos 11.0.13/10. x/8.x (Report Studio, Motio,Frame work manger, Analysis Studio, Business Workspace, documentum Content Server/Docbase,Metric Designer, Metric Studio, Business Workspace advanced), Transformers, Impromptu Administrator, Powerplay Transformer, Powerplay, Oracle 11g,Was 8.x, Documentum architecture and Content Server 6.X and 7.X, Teradata

RDBMS: Stored Procedures, Database Triggers, and Packages.

PROFESSIONAL EXPERIENCE:

Confidential, Indian Land, SC

Sr. Cognos Developer

Responsibilities:

• Involved in gathering Business requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developed Technical Design and Functional Design Documents.
• Involved in discussions with business stakeholders to understand project goals and requirements in order to quickly deploy reports and analytics dat enable better decision making.
• Strong understanding of Business Intelligence and Data Warehouse database concepts, Star schema and developed Report Studio queries dat uses the relationships between fact tables in the Data Warehouse database.
• Integrated Remedy with Cognos reporting tool using cognos API.
• Used Motio CI to validate and Motio PI to make bulk changes to reports whe migrating from 10.2.2 to 11.0.13.
• Developed Cognos reports from stored procedures and reverse engeenered the SQL.
• Involved in creation of Relational and Multi-dimensional models using Cognos framework manager and created packages, published to the server for reporting needs.
• Work directly with business customers to build portals, reports, dashboards with the COGNOS BI suite (Framework Manager, Report Studio and Transformer).
• Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements .
• Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, OLAP cubes and integrating with SharePoint.
• Install and configure Content Server for 7.X on Unix/Linux/Solaris environment
• Experienced in implementing best practices on Cognos Dashboards, Scorecards, Portal, report design, development and testing.
• Design and develop Teradata presentation layer according to users' requirements
• Train end users on Teradata OLAP connector
• Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.1
• Created a dashboard on a relational framework model and performed the tuning at the database level for optimal performance.
• Experienced with Administration and Security Setups within Cognos.
• Created Multidimensional Power Cubes using Transformer and created Drill up/Drilldown reports using Report Studio and Analysis Studio.
• Created Drill through, Burst and Master Detail Reports. Created Active reports and dash board reports for the business needs and Cognos Mobile.
• Involved in Installation and Configuration of Cognos 11 version and Cognos Mobile and checking on the Issues on Client and Server side.
• Practiced new features in cognos 11 version in sandbox.
• Created self service reporting in cognos 11 version.
• Trained end users in creating the dashboards using the business Insight/workspace.
• Created Multi tab, Drill up/Down, Multi Query and multipage reports using report studio.
• Experienced with Offshore/Onshore business models for development activities and involved in daily calls for coordinating the work to offshore team and help them to understand and implement.
• Involved in Performance tuning of models/reports/cubes for better quality product delivery.

Confidential, Charlotte, NC

Sr. BI/DW Developer

Responsibilities:

• Involved in gathering Business requirements from business customers, analyzing and transforming them into business intelligence reporting specifications. Developed Technical Design and Functional Design Documents.
• Involved in discussions with business stakeholders to understand project goals and requirements in order to quickly deploy reports and analytics dat enable better decision making.
• Strong understanding of Business Intelligence and Data Warehouse database concepts, Star schema and developed Report Studio queries dat uses the relationships between fact tables in the Data Warehouse database.
• Integrated Remedy with Cognos reporting tool using cognos API.
• Used Motio CI to validate and Motio PI to make bulk changes to reports whe migrating from 10.2.2 to 11.0.13.
• Developed Cognos reports from stored procedures and reverse engeenered the SQL.
• Involved in creation of Relational and Multi-dimensional models using Cognos framework manager and created packages, published to the server for reporting needs.
• Work directly with business customers to build portals, reports, dashboards with the COGNOS BI suite (Framework Manager, Report Studio and Transformer).
• Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements .
• Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, OLAP cubes and integrating with SharePoint.
• Install and configure Content Server for 7.X on Unix/Linux/Solaris environment
• Experienced in implementing best practices on Cognos Dashboards, Scorecards, Portal, report design, development and testing.
• Design and develop Teradata presentation layer according to users' requirements
• Train end users on Teradata OLAP connector
• Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.1
• Created a dashboard on a relational framework model and performed the tuning at the database level for optimal performance.
• Experienced with Administration and Security Setups within Cognos.
• Created Multidimensional Power Cubes using Transformer and created Drill up/Drilldown reports using Report Studio and Analysis Studio.
• Created Drill through, Burst and Master Detail Reports. Created Active reports and dash board reports for the business needs and Cognos Mobile.
• Involved in Installation and Configuration of Cognos 11 version and Cognos Mobile and checking on the Issues on Client and Server side.
• Practiced new features in cognos 11 version in sandbox.
• Created self service reporting in cognos 11 version.
• Trained end users in creating the dashboards using the business Insight/workspace.
• Created Multi tab, Drill up/Down, Multi Query and multipage reports using report studio.
• Experienced with Offshore/Onshore business models for development activities and involved in daily calls for coordinating the work to offshore team and help them to understand and implement.
• Involved in Performance tuning of models/reports/cubes for better quality product delivery.

Confidential, NE

Cognos Developer

Responsibilities:

• Interviewed business community to identify business, data, and delivery requirements.
• Designed models in Framework Manager.
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Worked with 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 models in Transformer, built cubes and published cubes to Power Play server.
• 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.
• Experience with oracle as the target for the data marts.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment.
• Trained End users to operate the reports.
• Optimized and modified the triggers, complex store functions, procedures, user base data type.

Confidential, Union, VA

Cognos Developer

Responsibilities:

• Gatheird functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications.
• Developed Technical Design Documents.
• 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 &Preferences for our Asian, African and European partners.
• Created Drill Through Reports & Master Detail Reports for Accounts Department.
• Created dashboards, portlets for various HR and payroll related reports..
• Developed various HR .Created complex reports dat had multiple pages, multiple UI items like lists, charts, graphs, etc.
• 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.
• Wrote and executed the test cases for various reports dat 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.
• Worked on the database performance by creating the indexes and partitions.
• Created models in Transformer, built OLAP cubes and published cubes to Analysis Studio
• Involved with the Solutions Architect and the QA team for validation and verification of the development.
• Exceptionally good and experienced in handling the problem and troubleshooting.

Confidential, Reno,NV

Cognos Developer

Responsibilities:

• Interviewed business community to identify business, data, and delivery requirements.
• Designed models in Framework Manager.
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Worked with 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 models in Transformer, built cubes and published cubes to Power Play server.
• 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.
• Experience with oracle as the target for the data marts.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment.
• Trained End users to operate the reports.
• Optimized and modified the triggers, complex store functions, procedures, user base data type.

Confidential

SQL Server Developer

Responsibilities:

• Interviewed business community to identify business, data, and delivery requirements.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.