Krishna Kumar Narayana Swami

• 18+ Years
• Domain Experience:

Banking & Financial Services (BFS), and Sales & Technology Domain.

• Technology

Tableau 2023.1, Amazon QuickSight, Business Objects 4.1(Designer, Webi Rich client, CMC

Infoview, Upgrade Management tool / Promotion

Management);; BIRST; SQL Server, Teradata, Oracle, Windows 10

• Roles
• Enterprise BI Platform support - BI Administrator, BI Architect
• BI Platform and BAU Support / BI Platform Team management
• PROJECT DESCRIPTION Capital One is a U.S.-based bank holding company specializing in credit cards, home loans, auto loans, banking and savings products
• It has various Business areas which uses Business
• Objects, Tableau, BIRST, AWS- QuickSight as part of BI Tool for generating the reports for their analysis and business purpose
• And so, BI Platform support team is the only centralized team who is responsible for the administrative, platform/BAU support and also engineering work related activities for all LOB's across Capital One
• Responsibilities
• Involved and working in all kinds of Admin, access, BAU & Platform support related tasks
• Platform maintenance & AMI rehydration activities tasks as well
• Majorly involved in handling regular BAU / user tickets and resolving all those tickets in the queue on a daily basis within SLA
• Executing/ Implementing different types of Changes Orders with regular cadence for deployment to PROD, for regular maintenance activities, and for regular rehydration activities and also activities that relates to fixing certain product issues as well as suggested by vendors and/or internal team/engineering suggestions
• In this project, I am responsible for coordination with Vendor for Product issues and providing support to developers who are in the LOB team
• Involved in helping users through slack, Zoom calls or proper channels for BIRST Platform setup, BIRST space creation, and AD group creation and all AllAccess related tasks and issues too
• Involved in helping users through slack, Zoom calls or proper channels for Tableau desktop installation, licensing issue, Site creation, and AD group creation and all AllAccess related tasks and issues too
• Involved in all the above mentioned relevant tasks for the Amazon QuickSight tool as well
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline proposed solutions
• Extensively involved in the decommissioning activities of BOBJ platform when capital one was planned to put this out in a burning ship as we don’t want to keep this for certain valid business reasons and picked up other trending BI Tools, the fews that were mentioned above here
• Below are the responsibilities that I have handled before BOBJ decomm activities, when
• BOBJ was one of the major BI tools in Capital one
• Migrated Universes, Reports and Securities from the Development to Production environment after System Integration Testing (SIT) and then followed by Business
• Acceptance Testing (BAT); also involved in publishing the Tableau dashboards too in PROD based on the request
• Worked closely with developers from various Business Areas to fix the issues related to the product
• Worked on security setup like creating new groups and granting access to folders, universes and connections
• Creating Spaces in BIRST and adding users to different roles like “Admin
• Designer, Developer and Consumer” based on the requirement need and depends on their certification level too
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implementing Folder and object level restrictions
• Created various access levels to restrict the data and created publications as well
• Worked on BOBJ usage reports to capture some key metrics related to BOBJ usage in R4
• Worked on the failed recurring schedules in R4 and fixed them
• Extensively worked with security issues and user maintenance
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports

• This project dealt with working for feature teams like Capital Market, SALS, CPCRM, Global
• Financing and so forth
• However I work here for SALS(50%) & CPCRM(50%)
• SALS - Special Assets and LGD System
• CPCRM – Counterparty Credit Risk Management System
• Worked here in Agile Methodology and followed SCRUM board for the first 6 months and moved on to KANBAN board for the rest of the months
• We accept requirements here as an intake form from the feature teams and create
• Story on our Agile Board in the corresponding swim lane(or LOBs) and will start the task from there based on the priorities and needs of the project that we agreed upon
• Involved in changes/enhancement of the BOBJ universe, tweaked the universe in the performance perspective, created multiple contexts and handled the universe and its mappings & join path in the better way
• Design & development of more than 10 WebI reports according to the business requirement and sample reports that’s been provided in the network portal
• Created necessary variables in few reports to handle few scenarios with multiple queries and multiple tabs in the report as per the requirement; and so had a good experience in ‘Merge’ options and reported the different dimensions of data in the same list reports
• Having user prompts mostly in all the reports, query-level filters too and also played with measure objects using many aggregate functions(like Total, Sub/Grand-Total
• Count, CountAll, Count with distinct and so on)
• Mostly played using context operators (In, ForEach, ForAll) to specify dimensions on calculating measures based on the report design and layout
• Involved in sorting/ordering of columns (mostly in all reports) and giving priority to sort ordering (mostly custom sorting) and other stuff as per the requirement
• Involved in creation of crosstab kind of reports using web Intelligence tools and created a complex layout out of it
• Also, giving priority to Defect fixing tasks too when it was identified by a user in production and has fixed many defects within a short period of time

• Project - Corporate Security Systems
• Responsibilities
• Involved in overall high-level requirement gathering directly in the field by closely interacting with the end-users
• Once after requirement gathering, involved in the creation of Dashboard Design with complex layout and involvement of more technical functionality.Experience in creating components such as Tab Control, Toggle Button, Charts(especially Bubble charts, Bullet charts, Pie charts,…), Spreadsheet Component, ScoreCard, List box
• Combo box, Gauge, Spinners, H/V Sliders, panels, canvas and so on…
• Handled Dynamic visibility in most of the cases according to the business requirements and scenarios
• Handled more excel functions too according to the dashboard needs

• Technology Business Objects 4.0, SQL Server / Teradata , Windows 7
• Roles Senior BO Universe
• Understanding of the Business Requirement provided in the functional Specification
• Involved in analysis and design
• Design & development of WebI reports according to the requirement and sample reports that’s been provided in the network portal
• Involved in Coding and Unit testing based on the certain case scenarios based on
• Audit, Audit type, project type and so on
• Involved in the enhancement of Universe according to the ad hoc request given as per the immediate reporting needs
• Mostly, giving priority to ad hoc data requests by writing ad hoc queries as per the user urgent business needs
• Also, giving priority to Defect fixing too when it was identified by a user in production
• Mostly played using context operators (In, ForEach, ForAll) to specify dimensions on calculating measures based on the report design and layout
• Created necessary variables in few reports to handle few scenarios with multiple queries and multiple tabs in the report as per the requirement
• So handled the reports with ‘Merge’ options and was well versed in that
• Involved in creation of crosstab kind of reports using web Intelligence tools and created a complex layout out of it., Technology Business Objects XI 3.1, Teradata , Windows 7
• Roles Project management role
• Responsibilities
• Involved in overall high-level requirement gathering directly in the field by closely interacting with the end-users
• Understanding of the Business Requirement provided in the functional Specification
• Involved in analysis and design
• Once after Requirement Analysis, did Project estimation (mainly involved in BO part and has given the estimation and values for all split-ups), Project proposal and so on…

• (on-site location for FICO)
• Technology ETL, Reporting, Teradata, Windows 7
• DM9 (Debt
• Manager 9 – Internal App
• Collection and Recovery Tool)
• Roles &
• Responsibilities
• Training completed (Given by Client in DM9 Tool mentioned above for 3 weeks)
• Self-Training on ETL tools also undertaken with client guidance through their internal web portal
• Later this project was put on hold for some time as the original client(US Government) has not been started sharing the project requirements, project estimation and project SOW and so on for certain reasons
• Finally, every resource from Cognizant has got released from the project.

• Project #- Citrix Online Business Intelligence(COLBI) System.
• CLIENT DESCRIPTION, is an American company that creates software for use on PCs and other devices to remotely connect to desktops, applications, and networks
• The company's products and services are related to server, application, and desktop virtualization; networking; cloud; and Software as a Service (SaaS)
• These products and services are used by approximately 330,000 organizations worldwide
• Citrix has headquarters in Fort Lauderdale
• Florida and Santa Clara, California
• Its other United States offices are in California and North Carolina
• Citrix research and development centers are located in the U.S., Australia, India, Japan, and the United Kingdom
• Citrix is organized into three units: Workspace Services, Delivery Network, and Mobility Apps
• Citrix licenses its services and products directly to clients, including IT professionals, SMEs, and through companies called value-added resellers that resell the products and services after adding additional features
• Citrix has a better product like the GoTo product line, which included GoToMeeting, GoToWebinar, GoToWebcast, GoToTraining
• GoToAssist and GoToMyPC
• Project Abstract
• Aim of the project is to develop Reports for Business teams based on products such as GoToMeeting
• GoToTraining, GoTo Webinar, GoToMyPC, Audio & Video products and so on using BI Tools
• Report will be delivered through BI Launchpad and Tableau Dashboards to the users and few can be run on demand and few can be scheduled as per the client’s request and sent email to the recipient (end users) automatically
• The purpose of Reports is to do analysis on the usage of the products (usage details), revenues (invoice details), analysis on customer data (customer & order details) and improving on the areas that we need to do and also celebrating the areas of success and so on
• We would be getting reporting requests from different departments such as Finance, Marketing, Client services, Operations, Product Management, Sales, Support and so on based on their business needs and demands
• Roles, Responsibilities
• Understanding of the Business Requirement provided in the functional Specification
• Involved in analysis and design
• Once after Requirement Analysis, mostly involved in effort estimation and formalization of change requests
• Design & development of many WebI reports according to the requirement and sample reports that’s been provided in the ticket
• Involved in Coding and Unit testing based on the certain case scenarios based on product and plan type
• Involved in the enhancement of Universe according to the adhoc request given as per the immediate reporting needs
• Experience in scheduling BO reports to run on weekly and monthly basis; and also run on an event basis according to the end user requirements
• Migrated Universes, Reports and Securities from the Development to Production environment after System Integration Testing (SIT) and then followed by Business
• Acceptance Testing (BAT)
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (9.1 / 2018.1) reports
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Involved in peer-review & preparation of unit test cases for all the deliverables.

• PNC-GIS, SuRPAS Modernization
• Technology Business Objects XI 3.1, Oracle 10g, Windows 7
• CLIENT DESCRIPTION The Bank of New York Mellon Corporation, commonly referred to as BNY Mellon, is an American worldwide banking and financial services holding company headquartered in New York City
• It was formed on July 1, 2007, because of the merger of The Bank of New York and Mellon Financial
• Corporation
• The Bank's primary functions are managing and servicing the investments of institutions and high-net-worth individuals
• BNY Mellon's two primary businesses are Investment
• Services and Investment Management, which offer services for each stage of investment, from creation through to trading, holding, management, distribution and restructuring
• Project Abstract, ) acquired PNC(Pittsburgh National Corporation)-GIS Bank for their business growth; and so we were into this project
• SuRPAS – stands for Shareowner and Retirement Plan Accounting System; and this was the first system developed by the third party, which lets brokers use a sub-accounting methodology for clearing mutual funds and this also supports a few more standard sub-accounting systems which the market currently has
• Module #1 – Tax Reporting System
• This project involves the conversion of RKS(Record Keeping System) into TRS(Tax
• Reporting System)
• In other words, the old system of getting reports using SQL query has been converted into the new system of getting reports using BO WebI Reports for Tax-based system, rule based system and so on
• Here we have maintained one universe named TRS; and involved in maintenance(changes) of the universe according to the reporting requirements
• Module #2 – Falcon Reporting System
• This project involves the conversion of legacy mainframe systems into BO reporting systems; wherein we have created BO WebI Reports(500 Reports) in a phase-wise manner
• Here we have maintained one universe, called UDMS_DATA
• Universe has been created already; but we are involved in the maintenance activity of the universe(enhancement/changes) according to the reporting requirements
• Roles Module #1 –
• Offshore Developer (One man Project, directly worked with clients from Offshore)
• Module #, 3 members including me, but the other 2 are working from Pune)
• Responsibilities
• I have been involved in understanding the old system, requirement gathering and analysis of business needs on call from clients and also involved in KT sessions to understand the project requirement and work flow of the data model in a better way
• Development of WebI reports according to the direct SQL query given in the requirement doc
• And acceptance criteria
• Involved in the enhancement of Universe according to the ad hoc request given as per the immediate reporting needs
• Development of WebI reports according to the BRD given and the acceptance criteria in module #2
• Having user prompts mostly in all the reports, query-level filters too and also played with measure objects using many aggregate functions(like Total, Sub/Grand-Total
• Count, CountAll, Count with distinct and so on)
• Created sections in more reports to group the report based on certain columns as per the requirement and also applied breaks too in the report wherever applicable
• Used context operators (In, ForEach, ForAll) to specify dimensions on calculating input and output contexts
• Created necessary variables in few reports to handle few scenarios as per the requirement
• Involved in fixing the defects reported by the business users in QA and implementing the fixes to the next region
• Involved in sorting/ordering of columns (mostly in all reports) and giving priority to sort ordering and other stuff as per the requirement
• Involved in peer-review & preparation of unit test cases for all the deliverables

• Client: S&P (Standard & Poor's, a division of McGraw-Hill), UK
• Project # - SP- Clarity-PST Timesheet
• Technology Business Objects XI R2 & XI R3, Informatica 8.1.1, Oracle 10g, Solaris 10
• Project Abstract A Timesheet tool project named "SP-PST-Clarity-Timesheet" is in need of seeking approval to enable analysts to track time against Ratings, Project and Support activities and finally will provide end users the reports in a well defined and expected manner
• This enables SF and C&G to enhance workforce planning by providing a unified timesheet entry system which captures analyst activities effectively and accurately with the ability to extract meaningful management reports
• According to BO perspective, we need to create a universe based on reporting schema and need to provide 7 reports covering analyst, team or department activity per week, month or quarter based on user parameters accordingly
• Roles Offshore BO Developer (One man Project, directly worked with clients from Offshore)
• Responsibilities
• Migrated Universes, Reports and Securities from the Development to Production environment after System Integration Testing (SIT) and then followed by Business
• Acceptance Testing (BAT)
• Worked on security setup like creating new groups and granting access to folders, universes and connections
• Scheduled reports to run on a weekly and monthly basis according to end user requirements
• Involved in testing universes and reports for correct mapping of the objects and data correctness
• Moreover involved in requirement gathering and analysis of business needs on call from clients and also involved in KT sessions to understand about the project requirement and work flow of the data model in a better way
• Involved in the creation of the universe by designing the structure, creating classes and objects, specifying joins/corresponding relations between the tables and resolving loops
• Development of WebI reports according to the mock-up, requirement and acceptance criteria
• Created mostly crosstab kind of reports using web Intelligence tools with
• Business Objects Universe as the Data Provider
• Having user prompts mostly in all the reports and query-level filters too and also played with measuring objects using many aggregate functions in the report as required.(like Total, Sub-total, Grand-Total, Count, Count all, Count with distinct and so on)
• Created sections in more reports to group the report based on certain columns as per the requirement
• Applied breaks too in the report wherever applicable based on the requirement
• Involved in analyzing and enhancing the universe frequently for various needs and changes in the data model within the business as this project involves a full development cycle including database creation, ETL coding and reporting
• Review of all the deliverables and involved in the Preparation of Unit Test Cases for all the deliverables

• Project # - FBRM (Fee Billing & Revenue Management)
• Technology Business Objects XI 3.1, Crystal, , MS SQL Server 2008, Windows XP
• Project Abstract
• Fee Billing is an online Revenue Management System, which evaluates the Security assets in
• Custody, estimates, projects and manages revenue, accesses, inquires, view status, approves and delivers the Advantage Invoices and Custom reports to its Clients
• The Scope of the project includes the development of new Business Object reports for the various process flows during the invoice generation such as Invoice Inquiry, Current Status, Invoice Approval and Invoice delivery; revenue management such as valuation, estimation, and projection of revenues
• The project includes various phases of development and maintenance such as requirement analysis, design, test, defect resolution, implement, maintain and enhance the system
• EURC, an in-house tool is used to set up the infrastructure of the system, Business Object XI R2 is used as the reporting solution for Invoice flow and process, Quality center would be used in defect management and
• ECMS, an in-house tool would be used for the change management
• Responsibilities
• Involved in creation of the universe, Created user defined objects in the universe based on the necessity in the project (mostly handled calculation, combining 2 columns into 1 and columns with decode function and so on been handled here)
• Created aliases in the universe model to resolve loops and handled the relations in an efficient way
• Created universe level filter, as this condition is common across all the reports
• I have been involved in requirement gathering and analysis of current business needs
• Also involved in the migration of converting current technology into business objects reports
• Involved in analyzing and enhancing the reports for various protocol changes within the business
• Responsibilities include maintenance and supporting of the applications
• Resolving Issues, Requirements Analysis, Design and Development
• Involved in troubleshooting the defects reported by the business users and implemented in the production system
• Involved in Universe Enhancements
• Created mostly all kinds of reports using web Intelligence tools with Business
• Objects Universe as the Data Provider
• Unit test case preparation and execution

• Project # – PRISM/NPM (New Performance Management) in VPR (Views Portfolio Reporting)
• Technology COGNOS ReportNet 1.1, Cognos 8.4, Oracle 9i, Informatica, Java, Windows XP
• Project Abstract
• New Performance Management (NPM) is also a part of VPR (Views Portfolio Reporting) project which is a Data warehouse system intended to build business data warehouses for JP Morgan, & Co
• The Scope of the project includes the migration activities which upgrades the reporting tools to the upper end version (migrating CRN reports to C8 reports)
• The project includes various phases of development and maintenance such as requirement analysis, design, test, defect resolution, implement, maintain and enhance the system
• EURC, an in-house tool is used to set up the infrastructure of the system, Quality center would be used in defect management and ECMS, an in-house tool would be used for the change management
• Involved in up-gradation of Cognos reports from Cognos Report Net to
• Cognos8.4
• As part of the project, involved in the migration of FrameWork from CRN to
• C8.4 and did through testing whether it acquires all relevant functioning after migration
• Coordinates with the offshore team and gets the work done at the scheduled time frames
• Also in parallel, involved in few of the migration and development kind of tasks with the team
• Developed a few reports in Cognos8.4(migration not handled here) as we need to merge two lower version reports into one higher version report
• (Ex., both account and composite reports have been merged into one higher version report as requested by the user)
• Performed unit testing and review
• We have delivered the reports in a phase-wise manner
• Whenever we completed a phase, we used to move those reports to SIT and QA for their testing and also we were working on defects too in parallel that was found by the testing team
• We also gave our support starting from SIT till PROD release based on required time frames
• I have been involved in the performance tuning of these Cognos8 reports later since most of the reports are not performing well due to product issues
• In Few cases, I have been involved in the performance tuning of the
• Cognos8 FrameWork too in order to gain performance
• Did few tweaks and finally we have improved some performance gain for most of the reports that were not performing well before

• JPMC WSS(JPMC US IS - Ascential and CAR) – Dallas, US
• Project # – VPR (Views Portfolio Reporting)
• Technology COGNOS ReportNet 1.1, Project Abstract
• View Portfolio Reporting (VPR) is a Data warehouse system intended to build business data warehouses (VPR) for JP Morgan Chase & Co
• VPR Data mart is the central repository of
• Investor Services information for ubiquitous Client access to their data for analysis and to report custody, accounting and Securities lending activities
• The scope of the project involves loading the data from the Main Frame into Oracle database using ETL techniques and tools (DATA STAGE), subsequently use the oracle data to generate the report with the aid of reporting tools like
• COGNOS and the interface for the users (Clients - JPMC) would be the JAVA Application through which they can initiate the running of reports and view the report output
• The project includes various phases of development and maintenance such as requirement analysis, design, test, defect resolution, implement, maintain and enhance the system
• EURC, an in-house tool is used to set up the infrastructure of the system, Quality center would be used in defect management and
• ECMS, an in-house tool would be used for the change management
• Created some standard reports like ‘List’ reports, ‘Crosstab’ reports, and reports using charts & ‘Toolbar’ etc in Custody, SecLending, Fund
• Accounting, FS, Investment Banking and so forth
• Specified the grouping level before the layout has been designed as per requirements
• Used filters like ‘Data’ filter and ‘Global’ filter
• Creation of report using more than one query and have used aggregate functions appropriately in the report as per the requirement
• Internationalization has been done in few reports as per the requirements and also used conditional formatting in the reports
• Breaks, Data rules, sorting are also applied in the reports
• Fixing many minor & major defects and also involved in many enhancements kind of tasks
• Involved in up-gradation of Cognos reports from Cognos Report Net to
• Cognos8.4
• Did self review of all the deliverables and involved in the Preparation of Unit Test
• Cases for all the deliverables too

• Client – Washington Mutual Bank, US.
• Project # – Managed Enterprise Reporting Shared Infrastructure (MERSI).
• Technology BO 5.x, XI R2, SQL server, Project Abstract
• Managed Enterprise Reporting Shared Infrastructure (MERSI) is a Data warehouse system intended to build business data warehouses for WAMU
• The purpose of this initiative is to implement a shared services approach to DW and BI applications
• Washington Mutual conducts business through Retail Banking & Financial Services, Home Loans, Commercial Banking, and
• Card Services
• The Scope of the project includes the migration activities which upgrades the reporting tools to the upper end version (migrating BO5.x reports to BO XI reports)
• The project includes various phases of development and maintenance such as requirement analysis, design, test, defect resolution, implement, maintain and enhance the system
• EURC, an in-house tool is used to set up the infrastructure of the system, Business Object XI R2 is used as the reporting solution for Invoice flow and process, Quality center would be used in defect management and
• ECMS, an in-house tool would be used for the change management
• Responsibilities
• Involved in migration of universes from BO 5.x to BO Xi R2 and also did unit testing for those stuffs accordingly
• Used Import wizard to import most objects in the universe repository
• Cross-verified Joins and cardinalities whether it’s been properly amended to the new structure of the universe (in higher version) after migration
• Migrated the reports one by one manually by opening the lower version report xml into the higher version report window, saving and validating the report
• Re-built few reports as the migration has not worked out properly on all functioning across versions
• Did some enhancement in the BO reports like addition of Charts and implementing Drill filters in the report as requested by users
• Involved in defect fixing as well, as some of the functions are not working properly in higher versions as in lower versions
• Involved in supporting other regions like QA too until the migration task turns live in production.