KRISHNA POLAVARAPU
Cary
Summary
BI Infrastructure Architect with extensive experience at Deutsche Bank, focusing on strategic tool implementation and cloud infrastructure design. Demonstrated success in optimizing BI systems and improving data visualization capabilities. Proficient in Cognos and Tableau, with a strong ability to lead cross-functional teams and achieve substantial cost savings.
Overview
21
21
years of professional experience
4
4
Certifications
Work History
BI Infrastructure Architect/ BI Lead Admin / Cloud Engineer
Deutsche Bank
Cary
12.2016 - Current
- The objective is to reduce the license cost to the bank by reducing the multiple BI tools and identifying the strategic BI tools across the bank. As part of the program, IBM Cognos and Tableau tools were identified as bank strategic tools and converting the business use cases from non-strategic to strategic.
- Maintain and transform all strategies in operational plans according to business priorities and within budget.
- Lead cross-functional project teams and collaborated with business partners to determine and translate business requirements into technology and training solutions.
- Reviewed low demanded BI strategic tools in the bank and presented the demand to the CIO group.
- Working with business groups in the bank and show case the strategic tools features and functionalities to convert the applications to the strategic solution.
- Design, implement and maintain all Google Cloud infrastructure and services within a managed service environment.
- Design, Deploy and maintain enterprise class security, network and systems management applications within an Google Cloud environment.
- Perform data migration from on premises environments into Google Cloud.
- Strong knowledge with Web Services, API Gateways and application integration development and design.
- Strong knowledge of data migration (to public cloud) practices and technologies.
- Installed IBM Cognos &Tableau application in HA environment in Google Cloud.
- Experience in installation/configuration of HA Tableau environment.
- Enabled Kerberos authentication to use SSO in Tableau environments.
- Experienced in developing automation scripts to remove inactive users on the server.
- Developed visualization dashboards connecting to different data sources like SAS, SAP HANA and Impala data source.
- Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau using multiple measures like individual axes, blended axes, and dual axes.
- Used calculated fields extensively for different logics for trend, extended price calculations for the different cost types.
- Connected to Tableau postgres SQL database to create customized interface for Tableau workbooks to provide native intranet style.
- Installed PowerBI report server in POC environment.
- Experienced in installation/configuration of tiers in the distributed environment.
- Environment: Tableau 2023.3/2020.4.4/2020.1.7/2018.1/10.5 Tab Migrate, Postgres SQL, IBM Cognos 10.2 FP6.
BI Platform Admin / Developer
Deutsche Bank
Cary
08.2013 - 12.2016
- Upgraded dbReport application from version 8.4 to 10.2.2, enhancing infrastructure and server operating systems across UK, US, and Singapore regions.
- Developed dashboards utilizing calculations, parameters, groups, sets, and hierarchies in Tableau.
- Managed server architecture updates for task scheduling efficiency.
- Increased backgrounder task capacity by adding an additional node to primary node.
- Employed calculated fields for trend analysis and extended price calculations across various cost types.
- Configured users, groups, projects, and data connection settings as Tableau administrator.
- Exported datasets to sandbox SQL Server database for report generation.
- Facilitated training sessions on Cognos suite and guided users in self-service reporting solutions.
Lead Developer
Marriott International
Bethesda
06.2012 - 12.2012
- In the hospitality industry, hotel properties could be managed by either the corporate organization (i.e. Marriott International) or by a franchisee on behalf of Marriott International. The end user of the application (our associates), are linked the property(s) that they represent. The ability is to set the Revenue Goals to the Property, Manager and Salesperson levels.
- Technical and functional understanding of the process / requirements. Created Procedures and Functions for report performance as per user requirement. Hands on experience on Upgrading from Cognos 8.4 to Cognos 10.1.1 and deployment across the Environments.
- Evaluated existing Star Schemas and Developed relational models using Framework Manager for the purpose of new report requirements.
- Created Summarized tables on Netezza.
- Created Powerplay Cubes to load Prompt pages which improve the performance while scheduling the reports.
- Created Ad-hoc, Canned reports with business rules according to user requirements.
- Participating in the User meetings to analyze and prepare the reporting and analysis requirements of users.
- Environment: Cognos 10.1.1, Cognos 8.4, Cognos SDK, Framework Manager, Report Studio, Query Studio, Cognos Connection, Informatica Powercenter 9, Clear Case, Netezza 9, IBM DB2.
Sr. Cognos Developer
CNSI
Pierre
02.2007 - 10.2010
- Technical and functional understanding of the process / requirements. Written and modified Oracle SQL scripts with DDL, DML for data validation and test scenarios.
- Installed and managed IBM Cognos infrastructure for state of SD.
- Upgraded Cognos 8.2 environment to 8.4.1 and applied released patches to the platform.
- Development of Framework models for the purpose of Complex Solutions.
- Developed Models, Created Packages, Reports and Dashboards as per the design Considerations.
- Created reporting and business rules according to user requirements.
- Reviewed the existing BI Architecture and proposed the changes to meet the new business requirements and for long-term planning.
- Worked with business users to perform data analysis.
- Created Dashboards, Scorecards, Complex List, Cross tab Reports using Multiple Prompts, conditional formatting.
- Modified the queries of existing views/materialized views which cause lack of performance.
- Used java Scripting to validate the prompts in the reports.
- Deployed Cognos content like packages, project folders and reports from lower environments to production environment.
- Administered the Cognos jobs and Schedules periodically for different entities.
- Created the Events using Event Studio to track when a change in the Procedure codes.
- Implementing different levels of security at FM as per user requirements.
- Tuned the performance of the Cognos for quick runtime of reports.
- Provided end-user training for the Adhoc reporting and using new reports and dashboards.
- Trained business users to develop/use reports using Report Studio/Query Studio.
- This project SD MMIS(South Dakota Medicaid Management Information System) is a part of The SD Department of Community Health (SDDCH) which acts as the fiscal intermediary for several health insurance programs including Medicaid, Adult Benefits Waiver (ABW), Children's Special Health Care Services (CSHCS), the Refugee Assistance Program (RAP), Maternity Outpatient Medical Services (MOMS), and the Repatriate Program.
- Environment: Windows XP, Solaris, LDAP, Cognos 8.4.1/8.2 BI, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Go Mobile, Data Stage 7.5, Cognos Connection, Clear case, Clear Quest, Putty and Oracle 10g/11g.
Programmer Analyst/Cognos Developer
Cognizant Technology Solutions
Pune
06.2006 - 01.2007
- Gathered the user requirements from end users and worked on designing the Metadata Models in Framework Manager and published them to the Cognos connection for the report authors.
- Responsible for setting up business knowledge sharing sessions with business.
- Involved in preparing functional and technical specifications for user requirements.
- Created the technical specifications and the Unit test plans for the ETL builds after analyzing the data model and functional specification.
- Created derivations at Transformation model level.
- Created complex models for cubes and fixed issues raised during externalization of IQD’s.
- Dimensionally modeled the metadata using star schema and allow end users to build their own analysis.
- Responsible for Dimensionally Modeling the data in FM as per requirements.
- Responsible for preparing effort estimate and Defect Causal Analysis.
- Involving in building cubes using query subjects in FM and published them to Cognos8.
- Managing scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in Cognos8.
- Ethicon Endo-Surgery, Inc. (EES), Company develops and markets a broad portfolio of advanced surgical instruments and medical devices for minimally invasive and traditional surgery.
- Environment: Cognos ReportNet V1.1, Oracle 9i, Cognos Transformer 7.2.
Consultant – Application Developer
Abbott
Mumbai
01.2005 - 06.2006
- Extensive interaction with business users to gather and document end user requirements.
- Analyzed the data with DBA to create catalogs in the Impromptu.
- Installation and configuration setup of PowerPlay & Impromptu.
- Design, development and maintenance of Decision Support Systems, using the Cognos Suite of BI tools, building cubes, generating reports.
- Developed Multi-Dimensional Analysis and Business Metrics Reports using Cognos Power Play and Power Cubes using Cognos Transformation Server.
- PowerPlay Reports were created in. PPR & .PPX; aided as Production Support for the Existing Sales Reports and cubes.
- Expertise in creation of Transformer Cubes by saving the impromptu reports as IQD (Impromptu Query definition).
- Performed data operations including Sum, Average, Intersection, etc., and formatting like Exception Highlighting, Sorting, and Ranking etc.
- Designed, Developed and Tested Operational, Analysis and Graphical Reports using Cognos BI.
- Created Hot Files to be used as Lookup tables to prepare reports and reduce querying time.
- Prepared documentation published ad-hoc reports from various systems as required.
- Developed catalogs, multiple queries with complicated reports and query definition. files using various join and filter conditions in Impromptu.
- Abbott’s SCM system provides the primary information for monthly Sales and Operations Planning for all Abbott International (AI) Marketing Affiliates, Planning Centers and related Manufacturing Supply Sites in 100+ countries.
- Environment: Cognos Impromptu V7.1, Power Play 7.0, Transformer Cognos Architect, Cognos Upfront, Cognos Scheduler, Access Manager, Oracle 9i, DB2, MSSQL, PL/SQL, Erwin.
Education
Master of Computer Applications (MCA) -
University of Madras
TN, India01.2004
Bachelor of Science - Computers
Nagarjuna University
AP, India01.2000
Skills
- System engineering and administration
- Business intelligence and data warehousing
- Regulatory applications management
- Project reporting and evaluation
- Cost tracking and stakeholder advising
- Agile and waterfall methodologies
- Team management and productivity maintenance
- Infrastructure optimization strategies
- BI training procedures and techniques
- Tableau and IBM Cognos installation, configuration, and development
- Metadata modeling and report writing
- Tableau installation, configuration, and upgrades
- Dashboard development and data visualization
- Analytical reporting and KPI identification
- Strategic planning initiatives
- High availability infrastructure solutions
- GCP cloud services expertise
- Alteryx installation and configuration skills
- Power BI installation and configuration expertise
- IBM Cognos, Tableau, SAP BO, Lumira expertise
Certification
IBM Certified Developer – Cognos 8 Business Intelligence Metadata Models in 2009.
Timeline
BI Infrastructure Architect/ BI Lead Admin / Cloud Engineer
Deutsche Bank
12.2016 - Current
BI Platform Admin / Developer
Deutsche Bank
08.2013 - 12.2016
Lead Developer
Marriott International
06.2012 - 12.2012
Sr. Cognos Developer
CNSI
02.2007 - 10.2010
Programmer Analyst/Cognos Developer
Cognizant Technology Solutions
06.2006 - 01.2007
Consultant – Application Developer
Abbott
01.2005 - 06.2006
Master of Computer Applications (MCA) -
University of Madras
Bachelor of Science - Computers
Nagarjuna University