Manager Project

Professional Experience Summary

IBM Cognos Architect / Senior Developer on Business Intelligence & Analytics projects with more than 12 years of experience in Data Analytics and Data Visualization practice. Experienced in all phases of Software development life cycle including Requirement gathering, Architecture, Modeling, Design & Development and Testing & Implementation.

Expert in designing Business Models to meet the complex reporting requirements using Cognos Analytics & its BI suite of products like Report Studio, Query Studio, Analysis Studio, Event Studio, Framework Manager, Transformer cubes, Dynamic Cubes, Workspace Advanced, Cognos Mobile, Cognos for MS Office, Active Reports, Data Modules and Cognos Analytics dashboards. Well versed in Cognos Architecture, Installation & Maintenance, Content & User administration.

Strong understanding of Relational & Dimensional modeling concepts including Star and Snowflake schema. Strong working experience in Dashboarding, Scorecarding, Story creation, Offline reporting using the latest Cognos Business Intelligence suite. Proficient in creating Geospatial visualizations using the latest Map box integration in Cognos 11.x

Experienced in Tableau, Business Objects, SSRS, WebFOCUS.

Strong working experience in writing SQLs in databases like Teradata, Netezza, Oracle, DB2, SQL Server. Good working experience in ETL tools like Informatica for data loading and other transformations into reporting tables. Basic understanding and training done on HTML/CSS & Angular5.

Cross domain experience in projects working across Banking and Financial, Insurance, Retail, Pharmaceuticals, Telecom & Media and Supply Chain domains.

Flexible in managing multiple projects. Good in leading & mentoring team members. Self-initiative, excellent analytical and communication skills, ability to work independently

Present Employer

Education background

IBM Corporation, United States of America

Designation: Managing Consultant

Working as Architect/ Lead Business Intelligence Consultant for projects involving reporting solutions implemented using technologies like Cognos Analytics, Tableau, Informatica and other similar tools. Involve in application development, design and development of reports, testing and implementation

Bachelor of Technology in Computer Science and Engineering

Assignment History

02/2017 - To date

16 months

Client: Verizon LLC

Project: Collections Analytics

Project Description: The objective of the project is to enable Verizon drive transformation in its collections function leveraging analytics capabilities for U.S Enterprise customers. Verizon domestic collection organizations is aspiring to transform its collections function by implementing ‘action based’ analytics. Various dashboards and scorecards to be developed using Cognos Analytics to perform reporting and analytics and thereby drive customer focused collections strategy.

Role: Cognos Architect

Responsibilities:

• Design and develop 5 dimensional models to support all the reporting needs in scope of SOW.

• Gather requirements on reports to be automated that are currently generated manually or using spreadsheets and understand the visualization needs.

• Work with DBA/ Data architect to optimize the reporting tables.

• Design and develop Visualizations of Dashboards and Scorecards for Verizon collection Managers and Supervisors Using Cognos BI and Tableau.

• Develop packages using Framework Manager using Star schema model to support all the 5 models.

• Develop Dynamic cubes for executive Dashboards.

• Convert SQL based reports to Cognos reports and dashboards.

• Design and develop reports involving drill thru functionality, conditional rendering and other report studio features.

• Create Data modules for Adhoc consumption of reporting needs for high level users.

• Use bursting of reports for scheduling of reporting needs and distribution of monthly reports

• Use data security and folder security for analyst level user reporting and consumption.

• Create Visualizations using latest Cognos dashboards for viewing SPSS outputs and Analytics.

• Provide User Training to business users to support all the reporting post production implementation.

07/2016 - 01/2017

7 months

Client: JRI America

Project: Enterprise Prudential Standards

Project Description: The Enhanced Prudential Standards (EPS) for Foreign Banking Organizations (FBO) requires Sumitomo Mitsui Banking Corporation and JRI America – New York Branch, and the consolidated U.S. Operations to create an automated process to monitor intraday liquidity risk exposures including daily timestamped cash inflows and outflows.

Role : Cognos Lead & SME

Responsibilities:

• Gather reporting requirements for 3 regulatory reports to be developed

• Create Technical Design Specification documentation

• Map data lineage information from existing CDW DataMart to the fields in the reports.

• Create test tables in the database and load with dummy data for testing out POC of requirements in development environment.

• Develop reports from CUBE data source.

• Develop the reports using Cognos BI 10.2.2 report studio, event studio, cognos scheduler.

• Use conditional rendering and macros/java scripting in reports to implement client specific prompting needs.

• Use RAVE visualization for complex graph requirements.

• Manage Cognos team to deliver reports on time.

• Peer review all the Code before implementation

• Build test cases and Unit test the reports in QA

• Support User Acceptance Testing (UAT)

01/2016 - 06/2016

6 months

Client: Vitamin Shoppe

Project: VSI WMOS Implementation

Project Description: The project establishes a foundational warehouse management system for all Vitamin Shoppe facilities replacing multiple platforms and aging warehouse management systems. Implemented using the Manhattan Associates Open Series (WMOS) product, this product will allow easier integrations to The Vitamin Shoppe’s current and future enterprise systems enabling a flexible and agile software solution in addition to its Reporting, data management and inventory management.

Role : Sr Cognos Developer

Responsibilities:

• Involved in the requirement gathering of the VSI Inbound Outbound and Warehouse management reports.

• Create the Technical specification documentation.

• Design SCI Cognos reports based on the VSI requirements.

• Create transformer Cube for Quantity analysis.

• Design Workspaces based on the subject areas like, Inventory, Replenishments, Inbound, Outbound etc.

• Develop Geospatial reporting visualization for Inventory needs.

• Modify the existing base framework given by the Manhattan SCI team and create a Framework Model that is suited for the current reporting needs.

• Involved in effort estimation of additional Cognos reports that needs to be created.

• Develop new report studio reports based on the Functional specifications provided.

• Provide advice on existing reports that can be pulled from the application screens instead of creating a SCI report.

• Actively involved in Quality assurance activities related to Project ensuring the delivery of quality process and adherence to client standards.

• Involved in planning of scheduling of reports based of different business area needs.

• Create a report status tracker and provide development activity status and risks to the manager on a weekly basis.

09/2015 - 12/2015

4 months

Client: Clover (dairy)

Project: Clover Kolabo Project

Project Description: The objective of Clover Collaboration project is to lay the foundation for a new Enterprise Demand Signal warehouse. The solution will extract, transform and load all the various sources of data in a truly integrated and harmonized manner for downstream demand and cross-enterprise usage. The foundational warehouse will be used to derive business value through 3 key areas, Post event analysis, business reports and operational dashboards. The foundation will provide the data to support the project for 9 reports and a comprehensive dashboard using Cognos BI Reporting system.

Role : Cognos Technical Lead

Responsibilities:

• Gather reporting requirements for the 9 reports and 3 Dashboard pages to be developed

• Create Technical Design specification for the reports and dashboards in scope

• Map data lineage information from existing PEAT datamart to the columns in the reports

• Create Framework Manager design document to support the reporting components

• Update the security deck provided by the IBM SA team with the Security features available in Cognos BI.

• Configured Cognos environment for Netezza data source to established connections

• Install Framework manager and perform basic Administration activities

• Create dummy tables and load with dummy data in CLOVER_COGNOS schema for testing out POC of certain requirements in development environment.

• Create a Framework manager and publish the package.

• Create Dashboard technical design specification document

• Develop Promotional Calendar view, Drill down view, Trend View dashboard pages and test out the required functionalities. Simulate drill down feature via Drill through.

• Build and test user security in Peer view dashboard page & Drill down view dashboard page.

• Create tables in reporting Schema using latest DDLs posted in CLOVER_MART schema by ETL team

• Picked up the data files from box.com for getting the sample data to be loaded into the dimension tables. Have to up data from multiple files, merge them into one and then load the data.

• Once dashboard pages & reports are created, establish drill though connection between dashboards and reports, and tested the navigation.

• Enable breadcrumb navigation. This would allow the user to see on a graph what level they are in and they can navigate to any previous level, by clicking on the breadcrumb which is a hyper link.

• Managed responsibilities and priorities of the Clover blue print phase and development phase

• Participate in all meetings w.r.t requirement gathering from IBM SA team

• Communicate any changes / updates from the IBM SA side to the team at NAAC Dublin.

• Review the work and deliverables created by the other Cognos developer in the team before passing it on to the SA team

06/2015 - 08/2015

3 months

Client: Chicago Bridge & Iron Company

Project: CB&I POC - Quantity Analysis

Project Description: Chicago Bridge and Iron or CB&I is the most complete energy infrastructure focused company in the world and a major provider of government services. The purpose of Project is to leverage the use of project data that is available, reliable, and valuable to validate and expand the information available to gain new insights to better understand and respond to project performance trends. The scope of the POC will be limited to FreeportLNG, and CameronLNG projects.

Role : Sr Cognos Consultant

Responsibilities:

• Explore and establish an effective process for organized and integrated view of quantity data across different projects by leveraging the three base line projects information, Peru LNG, Kearl and PNG, in Project Management Control Sytem (PMCS)

• Measure and compare project estimate accuracy (original budget quantity to actual/final result) of the two targeted projects (Freeport and Cameron LNG projects) against baseline projects at the desired level of detail contained in PMCS system.

• Create Cognos Visualizations as the reporting framework to showcase the above objectives

• Gather POC requirements from the CB&I team and document it

• Create draft graphs for POC charts for quick presentation with client representative

• Create Cognos Framework Manager model to support the POC reports

• Create dimensional model for the Quantity hierarchy within Cognos framework manager using DMR

• Create Cognos reports using RAVE Visualization engine for POC1 and POC4

• Provide Cognos solution with Cognos Active Reports to show advanced Visualizations

• Create folder hierarchies in Cognos environment as per project need

• Create security within Cognos for access control and folder restrictions

• Participate in all meetings w.r.t POC requirements from CB&I team (which I am invited).

• Communicate any new ideas related to visualizations to the team.

04/2014 - 05/2015

14 months

Client: Glaxo Smith Kline (GSK)

Project: Promotional Spend Compliance Reporting

Project Description: GSK originally contracted IBM to develop an Aggregate Spend solution in support of the Sunshine Act passed as part of the Patient Protection Affordable Care Act. This would replace their existing AggSpend reporting tool. After this PSC Solution was implemented in 2012, GSK contracted IBM to deliver additional releases to develop Solution enhancements and added new scope of work to support new reporting requirements. This includes enhancements for CMS reporting and additional reporting requirements like Data quality management, Spend analysis etc.

Role : Cognos Lead Developer

Responsibilities:

• Involve in planning and estimation of PSC TRACS reports to be developed

• Review reporting requirements in Business Requirement document

• Develop new Cognos reports & Charts based on the requirements provided by the End users and Business partners.

• Migrate Cognos reporting environment from Cognos BI 8.4 to Cognos BI 10.2.1 FP4

• Administer Cognos reporting environment for Client which includes giving/restricting users access to different folders and other security features using Cognos Administration.

• Manage & Lead Offshore development team activities for project release TRACS 6.8, 7.0 & 7.1

• Scheduling Cognos reports in Cognos connection based on different business area needs.

• Provide SME opinion on whats do-able vs non do-able from a technical perspective

• Develop Technical specification document

• Create Unite Test documentation

• Develop QA Test scenarios documents for R6.8, R7.0 & R7.1 reports and components

• Involved in performance tuning of Cognos reports.

• Involved in writing Windows batch scripting for Cognos batch execution

• Involved in writing Oracle stored procedures for batch processing needs

• Provide best practices on Cognos report creation and scheduling

• Creating ad-hoc reports for BI team as per need.

• Debug issues faced by the BI team and provide issue resolution

• Educate the BI team on new Cognos features

• Create package dictionaries and mapping document

• Involve in Websphere fix pack update and learning IBM Websphere application as it was critical to Cognos upgrade implementation.

01/2014 - 06/2014

6 months

Client: Tiffany & Company

Project: WMOS Implementation

Project Description: The project establishes a foundational warehouse management system for all Tiffany & Co facilities worldwide installing or replacing multiple platforms and aging warehouse management systems, implemented using the Manhattan Associates Open Series (WMOS) product. This product will allow easier integrations to Tiffany’s current and future enterprise systems enabling a flexible and agile software solution in addition to its Reporting, data management, inventory, management and shared services support structure.

Role : BI Consultant & Cognos Lead

Responsibilities:

• Involved in the requirement gathering of the Warehouse distribution management reports.

• Create the Technical specification documentations and get signoff.

• Modify the existing base framework given by the Manhattan SCI team and create a Framework model that is suited for the current reporting needs.

• Involved in effort estimation of the new Cognos reports that needs to be created or migrated.

• Design & Develop new report studio reports based on the Functional & Technical specifications

• Coordinate and lead the Offshore team on the report development activities.

• Supervise the development of new reports created and review the reports for quality assessment.

• Provide advise on enhancement of cognos reports for better performance and good design for maintenance.

• Involved in assisting the team in quick defect fixes and problem resolution for unit testing defect fixes.

• Actively involved in Quality assurance activities related to Project ensuring the delivery of quality process and adherence to client standards.

• Involved in planning of scheduling of reports based of different business area needs.

• Create a status tracker and provide development activity status and risks to the manager on a weekly basis.

04/2013 - 12/2013

9 months

Client: Northwestern Mutual LLC

Project: Peoplesoft Re-Implementation project

Project Description: Northwestern Mutual Peoplesoft General Ledger system was undergoing a major version upgrade. All the General Ledger process flows and Business rules related to the

PeopleSoft (PS) General Ledger (GL) has to be re-implemented to the Future state from the current state and all the reporting solutions has to be implemented using Cognos reporting solutions.

Role : Business Analyst & Cognos Lead Developer

Responsibilities:

• Involve in planning and estimation of the new set of Cognos reports that needs to be created/ converted as part of the reimplementation project.

• Involved in the requirement gathering of the future state account mappings and assist in Technical specifications.

• Supervise the development of new Cognos reports and Cognos for office workbooks reports based on the requirements provided by the Report owners and Business partners.

• Provide advise on enhancement of cognos reports for better performance and good design for maintenance.

• Work with the Client’s infrastructure team to migrate the changes to production servers

• Assist in creation and updation of test scripts for unit testing the cognos reports developed in development environment.

• Involved in leading and assisting the team in quick defect fixes and problem resolution of system testing defect fixes.

• Actively involved in Quality assurance activities related to Project ensuring the delivery of quality process and adherence to FPS standards.

• Developed reports with complex master detailed queries, conditional filters, calculations, cascading prompts and conditional formatting etc using Report Studio.

• Involved in the formatting, conditional formatting and rendering of the cognos reports.

• Involved in planning of scheduling of reports based of different business area needs.

07/2012 - 03/2013

9 months

Client: NAPA Auto Parts (Genuine Parts Company)

Project: EDW Implementation

Project Description: The Genuine Parts Company BI Group is looking to expand the set of store data that it currently captures to encapsulate more of the enterprise’s data; resulting in a centralized

repository. The project involved using multiple products from the Cognos BI suite of products to be effectively used for implementing the reporting solution.

Role : Senior Cognos Consultant

Responsibilities:

• Work with client Data Analysts to get the complete knowledge of the data and Data mart database design as part of gather requirements and designing templates.

• Design and develop Cognos Framework Manager model and Publish on to Cognos Connection.

• Create prototypes of new Cognos reports and Dashboards based on the requirement formulated by the business owners

• Assist in development of complex reports containing list, crosstab, nested cross tab, master-detail, chart which involved multiple prompts, filters, calculations, multi - page, multi-query reports against multiple databases.

• Design and develop multidimensional OLAP Cubes and provided drill-through targets to another Cube, PowerPlay Portable reports.

• Involve in User interactive JAD sessions ( Joint Application Design sessions) to understand the exact requirement which serves their business need.

• Support the existing Reports and Cubes in Production

• Involve in performance tuning of existing Cognos reports.

• Suggest Report enhancements of the existing reports which would improve the readability of the reports to help the higher management for faster decision making.

• Involve in User Acceptance Testing of the created reporting objects

• Install and Administer Cognos Environment and implement security.

• Work with ETL Architects/Developers to design database objects

necessary for reporting needs.

06/2011 - 06/2012

13 months

Client: First Data Financial Services

Project: Global Product Development (GPD) Reporting

Project Description: The FDCS project involved building Cognos reports for the Corporate management group (Project managers and Resource managers) as part of the GPD (Global Product Development) department to provide an at-a-glance view of the operational data, primarily using Cognos Dashboard reporting tools.

Role : Cognos Team Lead

Responsibilities:

• Create planning and estimation documents for the enhancements/ projects and present it for approval to the project manager.

• Involved in the development of new Cognos reports, cubes and dashboards based on the requirements given by the corporate management group. Support the existing reports in Production.

• Provide options on enhancement of the reports, which would make it easier for the higher management to look at the data in new and better way.

• Involved in performance tuning of some of the Cognos reports.

• Deploy the enhancements in staging servers for Acceptance Testing by the end users; and get sign-offs from necessary business partners

• Migrate the enhancements/project to production environment, adhering to FDC standards

• Work with the Client’s infrastructure team to migrate the changes to production servers

• Actively involved in Quality assurance activities related to Project ensuring the delivery of quality process and adherence to standards

• Developed reports with filters, calculations, cascading prompts and conditions using Report Studio.

• Created complex master detailed reports with complex

formatting.

• Experience in generating Burst Reports to user’s folders.

• Involved in tuning of the reports to improve the performance.

• Created various Dashboards using Cognos Go! Dashboard.

04/2009 - 05/2011

26 months

Client: Massachusetts Mutual Life Insurance Company

Project: Murex Accounting & Derivatives Reporting

Project Description: Babson Capital Management (Massachusetts Mutual Entity) has different applications that provide functionalities in the areas of Loan processing, Derivative processing, Trade

management etc. Cognizant has undertaken to transition Babson’s nine applications under the Asset management domain. One of these applications being Murex.

Role : Senior Developer & Onsite Co-ordinator

Responsibilities:

• Involved in learning domain level knowledge, which is critical to the project execution.

• Actively involved in the Development & Unit Test of Informatica PowerCenter mappings, Execution of Informatica scripts to migrate data to System testing environments and Validation of migrated data, Review the design and code of the Informatica Scripts to be

migrated.

• Involved in the development of new Cognos reports based on the requirements given by the business partners, Debug issues in existing Cognos reports and provide fixes.

• Communicate with the internal business users to gather and document the requirements for Cognos reports in version 8.4 BI.

• Developed and Published Packages in Framework Manager.

• Created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.

• Maintained Content Manager for Cognos8.4.

• Created calculations and filters in the Framework manager model.

• Modified packages to generate reports for better analysis.

• Create Drill through and Master Detail reports using Conditional Formatting, Conditional Page layout, Sections, page Breaks.

• Scheduled bursting reports and distribution of Cognos 8 reports using portal administration.

04/2008 - 02/2009

11 months

Client: Key Bank (Investment Banking company)

Project: FACTS Re-Implementation

Project Description: FACTS is ‘Financial Alerts and Case Tracking System’. The application is used for tracking all the fraudulent activities happening in any banking related transactions for KeyBank, like ATM Card fraud, Check fraud etc. The system captures the occurrence of any such activity and generates a report called Suspicious Activity Report (Cognos Report).

Role : Cognos Lead Developer

Responsibilities:

• Expertise in creating multiple drill-through, and master-detail reports.

• Building nested child tabular, tabular set, tabular SQL and tabular model Reports.

• Created variables for conditional formatting the report to highlight the deviation of data.

• Involved in support, design, validation, and testing of reports.

• Scheduling reports and ensures periodic tests are performed.

• Responsible for all the Reporting activities in the project which includes design, development, testing and support.

• Interacted with clients and worked on understanding the business requirements.

• Involved in Sprint planning, scope and execution

• Involved in trouble shooting the issues and bug fixes.

• Involved in the development of custom ETL program to update

the Reporting datamart with the application transaction data from Filenet Content Engine(CE).

• Involved in the scheduling of ETL program to run daily to update the reporting datamart with the day to day transaction data.

• Frequent code reviews done with the Cognos Business Intelligence COE.

• Ensuring quality standards for the deliverables.

• Involved in rigorous testing for ensuring the Data Integrity.

• Involved in creation of documentation of the processes, bug fixes and reports.

• Involved in support of User Acceptance Testing (UAT)

• Reporting and Updating the status of the work to the Project Manager on daily/weekly basis.

01/2008 - 03/2008

3 months

Client: Key Bank (Investment Banking company)

Project: Cognos Cubes Conversion

Project Description: Keybank has many applications using the Cognos 7 environment for building the cubes for several analysis, decision making and reporting purposes. In an effort to streamline and automate the process of cube build, there was a need to migrate it into Cognos 8. There were 5 cubes which were successfully migrated in this process.

Role : Cognos Developer

Responsibilities:

• Responsible for migration of cubes

• Involved in Batch scripting and Process-automation.

• Involved in sprint planning and execution

• Interacted with clients and worked on understanding the business requirements

• Delegated jobs to offshore for a smooth transition.

• Involved in trouble shooting the issues

• Ensuring quality standards for the deliverables.

• Involved in support of User Acceptance Testing (UAT) for all the completed applications.

• Involved in the creation of documentation of the overall process.

• Reporting and Updating the status of the work to the Project Manager on weekly basis

10/2006 - 12/2007

15 months

Client: Key Bank (Investment Banking company)

Project: Cognos Migration Project (BO2COGNOS)

Project Description: In Keybank, As part of consolidating the existing Reporting infrastructure running on various products from different BI vendors, Key intends to convert its Business Objects

Applications to Cognos 8. The objective of this project is to migrate all the reports in the identified 25 applications from Business Objects v 5.1.7 to Cognos v 8.1.

Role : Cognos Developer

Responsibilities:

• Responsible for migration of reports.

• Involved in conversion and testing.

• Analyzing the functional requirement from BO reports for model and report generation.

• Built Model, created new joins, built filters, prompts, merge query subjects in to new query subject, determine hierarchy and dimension information in Framework Manager.

• Published packages from Framework Manager to Cognos connection for report creation in Report Studio and Query Studio.

• Created various list, grouped list, crosstab, and nested crosstab reports using ReportNet Report Studio and used Query Studio to create ad-hoc reports.

• Implemented filters, calculations, prompts, conditions, and created various reports using Report Studio.

• Developed calculated columns to focus on summarized data.

• Expertise with creating page breaks, drill-through, and master/ detail reports.

• Scheduling and distributing reports in Cognos connection.

• Involved in support of User Acceptance Testing (UAT) for all the completed applications.

• Involved in generating load runner scripts

• Involved in support of Load Testing and UAT

• Reporting and Updating the status of the work to the Project Manager on daily basis

09/2005 - 09/2006

13 months

Client: Central Statistical Organization, Ireland

Project: Data Management System

Project Description: The Data Management System originates from the need to migrate the existing survey-processing systems in the CSO (Central Statistics Organization, Ireland) from the VMS-based environment to a client/server environment.

Role : Programmer Analyst

Responsibilities:

• Development & Unit Testing of Informatica PowerCenter mappings for the selected set of surveys to implement suggested changes in the mappings of Metadata tables.

• Execution of Informatica scripts to migrate data to System testing environments and Validation of migrated data.

• Involved in requirements gathering, Data Analysis and Assessment.

• Review the design and code of the Informatica Scripts to be migrated.

• Actively involved in Quality Assurance activities related to Project

• Data validation of migrated data in the UAT environment.

• Involved in trouble shooting and Debugging of issues.

• Involved in ensuring the quality process and adherence to standards

Contact this candidate