SUMMARY:

• IT Professional with 8+ years of experience in analysis, design, testing, development, documentation and implementation of Business Intelligence Applications using Cognos BI tool.
• Expertise in various Cognos tools such as Cognos 8/10 BI Suite (Framework Manager, Report Studio, Cognos Connection, Metric studio, Query Studio, and Event Studio), Report Net, and Motio CI Access Manager.
• Experience in Cognos BI Server Installation and Configuration, configuring database server and web server connectivity for use with Cognos.
• Expert in creating metadata with relational model and dimensional model from data marts using Framework Manager.
• Expert in migrating reports from Brio Hyperion to Cognos and QMF Workstation.
• Efficient in developing of Dashboard reports for the Key Performance Indicators for the top management.
• Extensive experience in developing detailed functional documents and technical design for reports.
• Experience in building and maintaining Power cubes in Transformer using relational, dimensional and OLAP data sources.
• Expertise in deployment (import, export) of IBM Cognos Reports from Environment to another Environment.
• Experience in upgrading reports from Cognos10 to Cognos 11.1, 11.2.
• Experience with Cognos admin activities of creating new roles and user groups, performance tuning of Cognos server (dispatcher settings), periodic health check of Cognos BI server, periodic back up of Content store, saving the report file into external share drive and performance tuning of reports and packages.
• Experience in creating dynamic dashboards with analytical knowledge and best practice to meet the business needs.
• Strong experience on Cognos 10.x features like Conditional Blocks, Master Detail, and Drill through Bookmarks, Conditional Formatting, HTML, and Cascading Prompts.
• Experience in setting up Security prototype for Cognos Business Intelligence environment by incorporating data level, object level and package level and report level security.
• Adept at using relational databases like DB2 and Netezza with Cognos.
• Good knowledge of Tableau and SSRS reporting tool.
• Very good at Data Warehouse architecture and building Dimensional Models and writing SQL queries for data validations.

TECHNICAL COMPETENCIES:

BI Tools: Cognos … Cognos 10.x Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Framework Manager, Cognos Workspace Advanced, Cognos Workspace

Report Net: Cognos Series 8, Access Manager

SDLC Methodologies: Waterfall, Iterative, Agile/Scrum

Databases: MS SQL Server …, Oracle 8i/9i/10g, DB2, Teradata

ETL Tools: DataStage …., ODI 11g / 12c

QA Tools: Rational Clear Quest, Rational Clear Case

Languages: SQL, PL/SQL, HTML, DHTML

Operating Systems: Windows Family, AIX

Others: ISM (Integrated System Management) for Ticketing

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. Cognos Developer

Responsibilities:

• Worked in multiple phases of Software Life Cycle starting from the requirement analysis to production and post - production support.
• Created DMR model with Dimensions and Hierarchies for providing drill downs & ups in Analysis Studio.
• Created and published packages for different subject areas with best practice, using Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Wrote Technical Specification Documents (TRD) during design and development of FM models and reports.
• Created list, crosstab and chart reports and implemented drill-through conditions and Master-Detail relationships.
• Created multiple Report Pages using Page Breaks and grouping/sorting.
• Created Burst Reports, distributed and scheduled reports in Cognos Connection.
• Used various kinds of prompts like Value Prompt, Date and Time prompt, Cascading Prompts, etc. for better performance, also worked with customized prompts using HTML Items.
• Developed Multidimensional Models in Transformer and generated power cubes.
• Extensively used filters, calculations, conditional variables, multiple queries for data extraction in reports.
• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.
• Provided production support for existing Reports and Cubes. Users requested certain minor changes to formatting and calculations in report.
• Used Union, Intersection, Except, and Join between queries in query explorer.
• Developed several active reports of Dashboard with tab control in Report Studio.
• Deployed reports, models and cubes from Development to Test and Production environments.
• Developed Stored procedures and user defined functions using PL/SQL.
• Performed Unit testing and data validation of various reports that were developed in Cognos.

Environment: Cognos 11, 10.2.2 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace, Cognos Workspace Advance), QMF WorkStation, Framework Manager, DB2, SQL, Agile/Scrum

Confidential, Wilmington, DE

Cognos Developer

Responsibilities:

• Responsible for the complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management.
• Involved in the Installation of Cognos 10 and upgradation of Packages from Frame Work Manager, Reports from Report Studio from Cognos 8.4 to Cognos 10.
• Developed Framework Manager Models with Physical layer, Business Layer and Presentation Layer against the databases such as Oracle and SQL Server by creating Data Sources.
• Developed Crosstab reports, Chart reports, drill through reports, master detail reports.
• Created Interactive Reports using Active Reports and Business Insight in IBM Cognos 10.
• Created complex reports that involve query prompts, layout calculations, conditions, and filters.
• Worked with DBA to setup the new Databases and Modify Databases for Reporting Models.
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports.
• Managed scheduling of reports, public and my folders and distribution lists, users, groups and roles using Cognos Connection.
• Extensively worked on Analysis Studio to explore PPS business data to find trends and comparisons that answer their business questions.
• Created SQL views to avoid complex modular joins within reports and imported the views into Framework Manager.
• Create Run and Schedule Reports and Jobs using Schedule Management in Cognos Connection.
• Worked with the SharePoint team to create the Business Intelligence site to place the reports and dashboards into the web.
• Created Metadata Models and established the cardinalities in Framework Manager and Created Packages and Published to Cognos Connection.
• Worked on performance tuning and optimizing the queries to improve the performance of the reports and dashboards.
• Monitored Audit Reporting based on users, reports and packages.
• Provided the graphical representation of reports based on metrics like actual and target in Report Studio.
• Created Static Choice value prompts, Conditional Variables (Boolean and string) and Conditional Blocks associated with these variables to display/hide columns and queries based on user's selection in Prompt page.
• Developed different kinds of List reports using calculations and Drill Through, Drill Down in different formats (PDF, HTML, XML and Excel) which contains Filters and Multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option for Bursting of reports.
• Performed comprehensive Unit testing by comparing the Cognos reports against the database using TOAD.
• Involved in designing of Test Plans, Test Cases, and Executed Test Cases.
• Managed System and Integration testing as required to provide a Quality product.
• Provided technical assistance, training and mentoring to Users and Business Partners.

Environment: COGNOS 10/8.4(Report Studio, Query Studio, Analysis Studio, Active Reports and Business Insight), Oracle 11g, SQL Server 2008, LDAP, IIS 7, UNIX, Windows 2003/2007, TOAD, SharePoint

Confidential, Camden, NJ

Cognos Report Developer

Responsibilities:

• Worked with users and coordinated with Business Objects developers to understand and capture data/reporting requirements.
• Created Complex reports in Cognos 10.1 report studio including Drill through reports while replicating the reports from Business Objects.
• Worked on Modeling and Reporting against a Warehouse (OLAP) which is in the form of a Star Schema.
• Design, develop, and support of the overall Cognos Framework model.
• Implemented Security for package level, query subject level and the query item level.
• Developed Framework Manager Metadata model - relational and dimensional.
• Modified, 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, defining properties of each data items.
• Used Report Studio, Analysis Studio and Business Insights to create simple to Complex reports.
• Worked on Cognos 10.1 Business insight, Business Insight Advanced for creation of the Dashboard.
• Developed Reports using Conditional Formatting and Cascading Prompts. Developed List, Cross Tab, Charts, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports using report studio against multiple databases.
• Involved in requirement gathering from business users and prepared documentation to upgrade and migration reports and catalogs from Cognos 8.4.1 to Cognos 10.1.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports.
• Supported Business Users in generating Adhoc Reports using Query Studio.
• Developed Multi-dimensional models (cubes) using Transformer by developing various dimensions, measures, Calculations in Cognos.
• Created highly Complex Reports using OLAP Cubes as Data Source for Multi-Dimensional Analysis. Created complex reports using cubes in Analysis Studio.
• Extensively worked on cube refreshing on monthly basis & worked on Data Validations.
• Collaborate with Data Architect/DBA to develop/optimize the Star-schema model for the Cognos reporting tools (Power Play and Report Studio) and maintain optimal reporting tables and views within Cognos.
• Deployed the reports from development to testing and from QA to produce through deployment tool.
• Carried out UAT by developing test scenarios, test cases, test data to be used in testing based on business and user requirements.

Environment: Cognos 8.4.1/10.1(Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric Studio, Frame Work Manager), Microsoft Excel, MS SQL Server 2008 and Windows 2007

Confidential, Wilmington, DE

Financial Report Developer

Responsibilities:

• Designing mapping of process flow and interacting with analysts and core team members to select the proper system infrastructure.
• Design and review the processing steps and create processes for new system.
• Review project specifications, flow charts, process diagrams and system documentation for application operations and methodology.
• Create processes for new system and attend to ad-hoc issues related to day to day activities throughout project implementation and testing phases.
• Coordinating with other teams to improve the quality of work.
• Created prompts in report to restrict data fetch and ease data load.
• Extracted OM (Order Management) application data from an Oracle transactional system and Loading it into a SQL Server data warehouse.
• Developed complex reports including multipage-reports, graphical reports, formulae base and well-formatted reports according to user requirements.
• Created Aliases and Contexts for resolving Loops and Checked the Cardinality and Integrity of the Project / Framework Model.
• Worked on restricting the user access with help of Access Level privileges.
• Creation of repositories and security domain with user groups and security implementation.

Environment: Cognos 8.3 (Report Studio, Query Studio, Analysis studio, Metric studio, Event Studio, Frame Work Manager, Power play Studio, Cognos Connection), Oracle 10g, Cognos SDK, SQL server, Windows XP Professional, UNIX

Confidential, Metuchen, NJ

BI, Financial Adviser

Responsibilities:

• Collect, sort and analyze financial data. Financial plan creation, presentation and implementation focusing on tax efficiency.
• Asset management, structured products, annuities, life insurance.
• Extensive analysis with excel including VLookup, Pivot Tables, Macros.
• Maintained client bases, keeping current plans up-to-date and recruiting new clients on an ongoing basis.
• Contacted clients periodically and follow-up to bring new cases to the company.
• Resolved for any pending cases in the gathering information for the policy to be process.
• Develop a client base from a natural market list and referrals.
• Provide comprehensive financial plans that include life and health insurance and investment portfolios.