SUMMARY

• 15 plus years of IT experience in Data Warehousing as an Architect, Lead and Senior Consultant in multiple industries (Finance, Insurance, Pharma, University, Health...)
• Strong abilities and Hands on experience in requirement gathering, analysis, design, development, testing, implementation and production support of BI applications.
• Expertise in using various IBM Cognos BI Suite (Framework Manager, Report Studio, Query Studio, Cognos workspace, Cognos Workspace Advanced, Cognos Active Reports, Cognos Microsoft EXCEL and Dashboard), Cognos Powerplay Transformer.
• Good Knowledge in building Active reports for users to use offline and on mobile devices.
• Expertise in defining the multi - tiered Cognos Architecture, Performance tuning, Security infrastructure and Deployment.
• Experience in working with Big Data Hadoop Eco Systems (HDFS, MapReduce/YARN and sub components Hive, SQOOP, PIG)
• Familiar with Hive Optimization Techniques (Partitioning, Bucketing, Map join, columnar input format).
• Familiar with Shell Scripts in loading data dynamically for Multi-Level Partitioning.
• Worked on all stages of Software Development Life Cycle including Enhancements and Training End Users.
• Experience on TIBCO Spotfire Analytics BI Reporting and expertise in designing and implementing Relational Database model.
• Experience in Installation, Configuration, Group setup, User Administration, Performance monitoring, Troubleshooting issues.
• Experience in creating Complex Spotfire Dashboards or Reports Using Tibco Spotfire Professional.
• Served as a bridge between the onshore and offshore teams, handling the majority of the communication.
• Efficiently managed time to work on different projects and delivered the reports on time.
• Outstanding team player, ability to work quickly based on the Priority, managed multiple projects and able to work independently.

TECHNICAL SKILLS

Reporting Tools: Cognos 11 / 10.x, Framework Manager, Cognos Workspace, Cognos Workspace Advanced, Cognos Active Reports, Dashboards, Cognos for Microsoft Excel, Cognos SDK 8.4, Cognos TM1, Powerplay Transformer, Tibco Spotfire 7.x/6.X, Webplayer, Spotfire Professional,, SSRS.

Database: Oracle 11g, MS SQL Server 2012, DB2.

Big Data Ecosystem: Hadoop Map Reduce/YARN, HDFS, Hive, Pig, and Sqoop

Operating System: Windows / UNIX

Programming Languages: C, C++, SQL, Shell Script, Python

Others: TOAD, Clear Case, Clear Quest, ServiceNow, GWCC

PROFESSIONAL EXPERIENCE

Confidential, Bala Cynwyd, PA

Sr. Cognos Consultant

Environment: Cognos 11 / Cognos 10.x (Framework Manager, Report Studio, Query Studio, Workspace Advanced), SQL Server 2012, Guide Wire Claim Center, Service Now, Hive, SQOOP, Tibco Spotfire 7.x, Tibco Spotfire Professional, Excel, SSRS.

Responsibilities:

• Designed the FWM to bring DWH data from 2 different data sources and designed the FWM model (TMA).
• Created different Query for each data set and combined in report studio using Joins and Union.
• Created Dashboard Reports using different types of charts and other report layouts to show multiple results together in the same place.
• Compared the report results against database for data issues and assisted QA team for invalid test cases.
• Developed complex Reports using different features like Drill through, Master detail relationship and cross tab tables, complex List grouping with multiple page breaks (FICOH)
• Compared the Cognos report result with GWCC.
• Re write: Converted the reports from one package to another package and tested the report result against database and also with the existing reports (PHLY Sakura Reporting)
• Defects are tracked in different Quality Control system: ServiceNow, Quality Control - Application Life Cycle Management, Foot Prints.
• Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Spotfire.
• Experience of creating Groups and then set up Users, Groups and Licenses as Spotfire Administrator and restrict the group members to access only particular folders in the library as Library Administrator.
• Worked on development of Dashboards for Key Performance Indicators for top management.
• Updated the report based on the BRD changes and defects raised.
• Efficiently managed time to work on three different projects and delivered the reports on time.
• Document and upload all the changes in the Defect Tracking System and as well as in the report for Future Reference.
• Involved in Importing and exporting data into HDFS and Hive using Sqoop.
• Involved in creating Hive tables, loading data and writing hive queries.

Confidential, Teaneck, NJ

Sr. Technical Consultant

Environment: Cognos 11/ 10.x (Framework Manager, Report Studio, Query Studio, Workspace Advanced), Cognos Active Reports, Dashboard, IBM Cognos for MS-EXCEL, SQL Server 2012 and Cognos TM1.

Responsibilities:

• Designed and Implemented new dashboards using portlets page and Cognos workspace Advanced.
• Developed Active reports for users to use offline and on mobile devices.
• Developed Monthly Profit & Loss presentation Reports using IBM - Cognos Analysis for Microsoft Excel.
• Developed Actual vs Budget, Actual vs Forecast Variance Analysis Reports for different time periods for different country groups.
• Successfully designed and implemented security on different levels.
• Scheduled daily Sales reports to respective sales representatives effectively.
• Developed Sales and Gross Margin Analysis Report in Cognos and verified against Cognos TM1 Cubes.
• Responsible for developing high level and detailed architecture and design documents.
• Developed Highly Interactive Reports for various Business groups using Cognos Active reports.
• Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Managed Level 1 support for day to day operations and issue of Enterprise data warehouse.
• Developed complex Reports using different features like slice & dice, Drill capabilities, Master detail and cross tab tables with multiple page breaks.
• Managed Package Migrations and Deployments from one Environment to another.

Confidential, NY

Cognos Senior Specialist

Environment: Cognos 10.2, Framework manager, Cognos SDK, DB2, SQL Server 2012, Rational Clear Case / Clear Quest.

Responsibilities:

• Responsible for delivering the BI solutions using the IBM Cognos 10 suite (Framework Manager, Report Studio, Query Studio).
• Responsible for developing high level and detailed architecture and design documents.
• Collaborate with technical resources to build and improve Agency wide Cognos reporting solutions.
• Working with different functional groups to translate business requirements into Business Intelligence report solutions.
• Updated Models using Cognos framework manager for reporting systems, end user ad hoc report needs.
• Acting as a First point of contact for any Production CHRMS Reports and advice suggestions and solutions based on the severity of the issue.
• Worked on Performance tuning of the CHRMS reports (both PMS and PPMS reports).
• Built a new mock-up Project for merging PMS and CityTime systems.
• Took training on Cognos SDK for analyzing NYCAPS report for ESS (Employee Self Service) system.
• Updated Clear Quest and Clear Case for all report moves from Development to UAT and Production environment.

Confidential, South Orange, NJ

Cognos Architect

Environment: Cognos 10.2, Framework manager, Oracle 9i, TOAD 8.5, Banner, Operational Data Store (ODS), Data Cookbook, Service Now .

Responsibilities:

• Worked with Project Manager in creating Planning and Estimation for the models and reports.
• Designed and built POC (Proof of Concept) reports in Cognos 10.2 and Oracle as the data source, to improve confidence level of the client.
• Actively involved with business users and Development teams for gathering information for creating the Framework Model.
• Documented the mapping document from Banner database to ODS (Operational Data Store).
• Designed the Model according to the Business Requirements, by importing the metadata from ODS.
• Created Data level security, Object level Security in the model, to secure the package from different Groups.
• Created filters within the Model for improving the performance of the Model.
• Migrated Financial Aid oracle reports (SQL) into Cognos report and verified the result against Banner Database.
• Developed complex reports with prompts, Conditional Variable, Mater-detail relationships, drill through, and reports using complex calculations.

Confidential, New York, NY

Cognos Architect /Administration and Development

Environment: Cognos 10.2, Framework manager, SQL Server 2008, Oracle 9i, TOAD 8.5, Rational Clear Case / Clear Quest.

Responsibilities:

• Played a key role in Requirements Gathering and Technical Design.
• Prepared Effort estimation and Design Documentation.
• Involved in Daily execution of the project, issue escalation, work allocation, review of deliverables and quality assurance.
• Developed and implemented various security enhancement and SQL Performance Tuning.
• Used Cognos Connection for organizing, security, scheduling and distributing reports. Created multiple layer report providing a comprehensive and detail report with Drill through facility.
• Involved in the Cognos up-gradation from 8.3 to 10.2
• Migrated all the manual reports from Multiple System to One System (TED) using Cognos Reports.
• Able to analyze, optimize and troubleshoot the native queries generated by ReportNet during report generation.
• Experience in installation, administration and maintenance of the Cognos 10.2
• Modified stored procedure, removed macro and implemented cube automation using Script.
• Managed 5 members offshore team, served as a bridge between the onshore and offshore teams, handling the majority of the communication.

Confidential, New York, NY

Lead Consultant - Cognos Reports Development

Environment: Cognos 8.4, Framework manager, Cognos Report Studio, Teradata and Oracle 10g

Responsibilities:

• Created stored procedures for Cognos Security implementation.
• Created various adhoc reports for the Business and modified existing SQL code to generate new reports
• Expertise in using Framework Manager to construct the metadata and infrastructure for star schemas and dimensional models.
• Managed 8 members team based on the onsite and offshore model.
• Worked closely with offshore team in coordinating the report development and testing
• Working with data warehouse users and report authors to develop system requirements, specifications, and designs.
• Worked closely with end users to understand and validate requirements and build reporting solutions that produce accurate, timely information in a format appropriate for the information consumers.
• Responsible for setting up the Dev and prod environment.
• Responsible for enhancement and maintaining the existing Cognos Reports.