SUMMARY:

• A DW & BI Consultant with 10 Years of experience, having a skill set Of IBM Cognos BI, Oracle (SQL & PL/SQL) and UNIX and also trained in other BI tools like QlikView and Tableau.
• Experienced in multiple SDLC & Agile Methodologies in implementation of Data Warehouse reporting solutions.
• Strong Working experience on Life Science, Pharmaceutical, Health Care and Insurance domain.
• Experienced in developing/architecting BI Solutions supporting Client and Customer requirements adhering to data warehousing principles and methodologies.
• Experienced in gathering specifications for data and report requirements and effectively translate them into Business requirement & functional design specifications.
• Performed the functional and technical design, and scope the level of effort needed to deliver a solution.
• Expertise in translating business needs into end user Interactive Reports and help to make business decision based on the analysis.
• Expertise in IBM Cognos Report/Dashboard Development & Administration, Access Manager, Framework Manager, Transformer Cube Development and Modeling, Cognos Mobile BI, Active Reports and other Cognos tools.
• Strong in Data Modeling Concepts and worked with Data Architects, ETL team to build DW and Data Marts supporting Dimensional modelling required for Reporting.
• Design and Implementation of Security at FM Model, Package and Report Level.
• Excellent Knowledge on Prompt Macros, Parameterized URL, Trigger Based Scheduling and Prompt based on JavaScripting.
• Experienced in Cognos Active BI Reporting for Mobile Users, Advanced Event Studio Schedule Management.
• Extensive experience in creating Transformer models for Power cubes & Dynamic Cubes Models for DMR modelling and reporting needs.
• Extensive experience in troubleshooting issues in multi - server Cognos environments.
• Experienced in Cognos Application Support & administrative roles like deployments, access management, and security implementation.
• Experienced in Onsite/Offshore model and successfully managed the offshore team.
• Served as liaison between IT team and business users as a Business Intelligence Analyst.
• Good knowledge in OLTP/OLAP System Study, Analysis, and ER Modeling, Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Experience in creating complex and efficient Stored Procedures, Tables, Views, Materialized Query Tables, Indexes, and SQL.
• Excellent quality of adapting to the latest technology with the analytical, logical and innovative knowledge to provide excellent software solutions.
• God understanding of ETL Concepts and tools like Informatica and DataStage.
• Ability to work in a team environment or independently and handle multiple tasks concurrently.
• Strong analytical, interpersonal and communications skills.

TECHNICAL SKILLS:

BI Tools: IBM Cognos Analytics, Cognos 10.x/8.x/CRN/Series 7, Confidential, Query Studio, Framework Manager, Analysis Studio, Event Sutdio, Power Play Transformer, Access Manager, Cognos Series 7 Client Tools.

Other BI Tools: QlikView and Tableau

Databases: Oracle 11g/10g/9i/8i, Teradata,DB2,MS-SQLSERVER, MS Access

Languages: SQL, PL/SQL, C,C++,Java

Scripting Languages: Java Scripts, UNIX Shell Script.

Database Utilities: TOAD, SQL Developer, SQL* Plus, SQL Loader, Import and Export.

Other DW Tools: Informatica and DataStage

Operating System: Windows, UNIX, iOSOther Tools: Visio, Subversion, WinSCP, Putty, SQL Plus, Erwin, HP ALM

PROFESSIONAL EXPERIENCE:

Confidential, Berkeley Heights, NJ

Sr. BI Cognos Developer

Responsibilities:

• Design and develop BI Reporting Solution to providing insights and auditing of Migration of Policy, Billing, commissions, claims and workflow management data to the client’s new data management Application.
• Working closely with all levels of business, with varying levels of technical knowledge, to gather accurate and actionable business and technical requirements.
• Design the Reconciliation and Audit report components to identify anomalies & discrepancies between source and migrated target system data.
• Design and develop reconciliation reporting dashboards, making use of latest Cognos Visualization providing policy migration executive summary to higher management.
• Identify and propose eloquent reports that can accommodate needs of reconciliation and migration analysis.
• Develop Cognos Framework manager models using Cognos 10.2.2.
• Develop and design event studio Jobs and operational Scripts to burst and distribute reports accordingly.
• Setup automated report trigger schedules based upon ETL Jobs completion and creating the required UNIX scripts.
• Develop Unix Scripts to move the report outputs from Cognos Server to the Target Server.
• Design and Automation of QC Creation Propose for the issues observed during the reconciliation process.
• Worked on HTML code using JavaScript coding for Prompt validations and Image controls.
• Write Complex SQL queries required for creating Summarized/Aggregate Reporting Tables.
• Designed Database Tables, Indexes, Keys, and Stored Procedures in Oracle to meet reporting requirements
• Created Active Report Dash board providing an executive management summary of Migration Statistics.
• Developed Technical Specification documents for all newly developed and modified processes.
• Developed unit test cases and perform unit testing of assigned components.
• Verified and reviewed the code, test results and test plans and provided inputs to the team.
• Non-Functional requirement assessment and solution design.

Environment: Cognos 10.2.2, Confidential, Framework Manager, Oracle, SQL Developer.

Confidential, Pleasanton, CA

Sr. BI Cognos Architect

Responsibilities:

• Design a reporting solution for variance reporting based on Internal Management Reports Of Operations (IMROP), account families, management hierarchies and functional hierarchies.
• Gather & analyze Business requirement from Business Analysts. Implement report prototype layouts and conduct review meeting with business end users.
• Design a BI solution encompassing dimensional modeling, analytics, and multi-source data integration using Cognos Dynamic Modelling Concepts.
• Develop Cognos dynamic cube models and complex dimensional reports.
• Developed filters, calculations, prompts, conditions, and created various reports, using Cognos Confidential  for users
• Created Dashboard reports, drill through reports, and drill up/down reports using cubes as a data source in Cognos Confidential .
• Involved in Extraction, Transformation, and Loading (ETL) solutions using Data Stage.
• Design and develop complex crosstab reports using different features like Cross tabs, slice & dice, Drill- through capabilities, Conditional styles, Page Sets etc.
• Developed interactive Dashboards using Cognos Active reporting for NPR Project Usage.
• Implement report bursting logic in reports.
• Developed Complex Active Reports and dashboards using Cognos Workspace Advance.
• Developed Active reports for users to use offline and on mobile devices.
• Implemented Burst Functionality to distribute reports effectively.
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, Master-detail & conditional formatting reports.
• Developed Complex Multilingual, Multiple Data source Framework Manager Models.
• Implement report prototype layouts and conduct review meeting with business end users.
• Involved in the Unit Testing of the reports and preparing the Test cases.

Environment: Cognos 10.2.1, Cognos Dynamic Cubes, Analysis Studio, Confidential, Framework Manager, Oracle, SQL Developer.

Confidential, WestPoint, PA

Sr. BI Cognos Developer

Responsibilities:

• Deliver reports for GHH business users to enable them to check different aspects of activities (FCPA & HCP) & their results. These reports will enable and support global compliance with the U.S. Foreign Corrupt Practices Act (FCPA), and with Confidential 's Corporate Policy.
• Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications.
• Responsible for Design and delivery of Reports.
• Experience abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, and stored procedures.
• Prepared Technical Design of the reporting application needed by the Users.
• Validate and analyze the business requirements listed out by the Business Users
• Developed complex reports from lists, Cross-tabs through Complex dashboards, Conditional formatting, Drill through, &master/detail reports for End users.
• Created Complex dashboards and published to Cognos Connection portal.
• Created prompts, Calculations, Filters, Developing Prompt pages and Conditional Variables using  Confidential .
• Developed FM model for Adhoc reporting to be used by end users and also for the Confidential developers to build standard reports.
• Review the report construction, SDCL documents and provide feedback to offshore on daily basis.

Environment: Cognos 10.2.1, Confidential, Framework Manager, Oracle, SQL Developer.

Confidential, Lansdale, PA

Sr. BI Cognos Technical Developer

Responsibilities:

• Design and Deliver BI reporting applications for Managed Markets Business and for GHH business users.
• Design Managed Markets reporting application specific to ModelN focusing on areas like contract Management, Sales, Pricing, Rebate and Payments.
• Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications.
• Managed the onshore & offshore BI Teams to yield successful results and met the deadlines for every project.
• Conduct regular meetings with Business SME’s and key stakeholders to review the development progress and get feedback.
• Tracked and reported the project progress to customers and management by Weekly status reporting.
• Developed Technical Design Documents.
• Assisted the technical team overcome the technical challenges by providing inputs after code reviews and also getting the Cognos/IBM support for any issues if required.
• Built Relational Models for Reporting using Multi-Layer Approach and Modeling best Practices to meet the reporting requirements.
• Developed multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages.
• Created and supported Cognos Transformer models and cubes. Involved in implementation of security at transformer level by creating custom views.
• Performance tuned the reports by analyzing and comparing the turnaround times between SQL and Cognos.
• Worked in Design and Development of Security Architecture to meet the Business needs
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Implemented canned reports based on External Data Concept in Cognos.
• Customized Report User Selections criteria/Prompt Pages using HTML and JAVA scripts.
• Involved with the Solutions Architect and the QA team for validation and verification of the development.
• Trained End users to operate the reports.

Environment: Cognos 10.2.1, Confidential, Framework Manager, Transformer Model, Cubes, Oracle 10g, Teradata, TOAD for Oracle

Confidential, Whitehouse station, NJ

Sr. BI Cognos Developer

Responsibilities:

• Cognos 7/CRN to Cognos 10 Migration of multiple reporting applications.
• Responsible for Assessment & Feasibility evaluation of the reports to be migrated
• Analyze the Impromptu Catalogs and IMR files and identify the process to convert them to Cognos 10 FM Models and reports respectively.
• Assessed the scope for migration and used different approaches of Lift & Shift, Compress & Optimize wherever necessary for migrating catalogs and IMR and ReportNet applications.
• Gather Requirements around the Change requests from business users and implement Migration Strategy to incorporate those changes.
• Identify various risk and issues involved in the migration for reports and define the contingency and mitigation plan.
• Developed Cognos Framework FM Models and Confidential reports.
• Created multiple paged, multiple-query reports using multiple prompts for showing selective data on user input.
• Developed Adhoc Models for application that required Adhoc reporting.
• Trained End users explaining them the features for Cognos 10, Query Studio as an Adhoc tool and provided them the steps to execute the reports.
• Scheduled reports in the Cognos Connection portal to use off-peak hours effectively.
• Coordinated the development effort through offshore team.

Environment: Cognos 10.1.1, Cognos ReportNet, Cognos Series 7, Oracle 10g, TOAD for Oracle.

Confidential, Whitehouse station, NJ

Sr. BI Cognos Developer

Responsibilities:

• Implementation of Cognos Mobile Dashboard to be used for Offline access on iPad by Senior Sales Executives.
• Design and development of 4 Dashboards for National, Director, Manager and Territory levels.
• Understand the structure and hierarchy of Sales Force/ physicians in Canada Edge System.
• Gather Requirements and analyze the feasibility of implementing those for iPad reporting.
• Work with business to understand their KPI’s and level of data required to be displayed on the iPad reports.
• Setup Reporting Bursting to iPad App for ~ 500 users across 14 Sales Divisions.
• Design the UI for Dashboards considering the size limitations of Active Reports.
• Lead the BI Team and Co-ordinated with offshore team to ensure successful project delivery.
• Design and Implement the Materialized Views and Security Strategy.
• Design and Implement the Report Bursting Logic.
• Created Complex Active Reports using Tab Controls, Decks & Conditional highlighting of chart bars.
• Coordinated the development effort through offshore team.
• Weekly Status Report to the Customer and Management Team.
• Involved thoroughly in UAT phase with business users to identify and fix defects.
• Train End Users to operate the reports on iPad.

Environment: Cognos Mobile 10.1.1, Active Reports, Cognos Mobile BI iPad App, Oracle 10g, TOAD for Oracle

Confidential, Whitehouse station, NJ

BI Cognos Administrator

Responsibilities:

• Administer and Support Cognos environments and applications through an integrated Service delivery Model for managing operations in the Organization and Support Services through defined, Standardized and ITIL Compliant processes.
• Setup Cognos Server using various deployment methods like Single Server and Multi-Server installation on Windows and AIX environment, Also implemented Vertical/Horizontal Scaling of web server.
• Performance tuning at different levels and implementation of failover techniques.
• Customization of Cognos Interface.
• Application level Enhancements, Changes and Release Management
• Account & Administration management; User Management for Cognos 8/10, CRN, Cognos Series 7 and IWR environments.
• Performed Cognos Content Migration deployments of Packages, Reports to Higher Environment using Content Administration.
• Created users and changed their profile as per the requirement
• Worked on administration activities in Cognos Connection and security implementation among Cognos Applications. Performed administrative roles in Cognos Connection and set security permissions, configured and maintained users, groups and roles using Cognos Administration.
• Monitor the Remedy Support System for incoming Incident Tickets and analyze the issues reported by users in those incident tickets and resolve the issues within the agreed SLA.
• Involved in the other Cognos administration activities like creating new data source connections, defining dispatcher routing rules, monitoring the cube build process etc.
• Prepare SOP documents for all the tasks carried out in the project and share within the team.
• Generating ad-hoc reports from audit database regarding usage, user count, report or cube build failure tracking etc. when demanded by projects.
• Executed the Six sigma project which enabled us to reduce the support ticket received by our team and helped reduce total efforts spent.
• Requirement Gathering and Estimation for Change Request Received.
• Transformer Cube enhancements and Schedule Maintenance.
• Coordinated the development effort through offshore team.
• Prepared Weekly Status Report to the Customer and Management Team.

Environment: Cognos 10.1.1/8.4, Cognos ReportNet, Cognos Series 7, Oracle 10g, TOAD for Oracle, Putty, WinSCP.

Confidential

BI Cognos Developer

Responsibilities:

• Understand the Migration requirements of the Client's New Complaint Management system (IQ); analyze existing system functionalities and business rules.
• Customer interaction, understanding business applications, business data flow, data relations to gather the requirements and create functional and Technical specification documents.
• Prepare Framework Manager Model and create various calculations, Filters to suit for Query Studio to create Ad-hoc reports.
• Created various Reports using Confidential with multiple Charts and objects, used different types of Aggregate functions to display detail and summarized values at different grouped levels.
• Created reports having Filters, multiple Prompts (Select & Search prompt, value prompt etc) and provided option for Bursting of reports.
• Design and development of Cognos canned reports, and related summarized tables.
• Tuning and implementing the best practices to develop the summarized tables using Materialized Views.
• Extensively involved in writing SQL queries (Sub queries and Join conditions).
• Implemented Conditional formatting for highlighting rows and columns, and hiding individual rows.
• Performed comprehensive Unit testing by comparing the Cognos reports against the database using SQL in Toad and documented the same.
• Coordination in training sessions and demonstration of application tools to End-Users.
• Ensuring that risks and issues are identified. Troubleshoot technical, performance and data quality issues through review & analysis of report, query design or underlying data structures
• Support the SIT/UAT cycles and Post production Support for any bug fixes/issues.

Environment: Cognos 8.3, Confidential , Framework Manager, Oracle 10g, TOAD for Oracle