Home

POLAVARAPU KRISHNA CHAITANYA - Tableau cognos developer , Power BI Developer

[email protected]

Location: Cary, North Carolina, USA

Relocation: Remote only

Visa: GC

Resume of KRISHNA POLAVARAPU Ph: 770-709-4679 [email protected] http://linkedin.com/in/krishnapolavarapu KEY SKILLS . 17 years of extensive experience in Data Warehousing environment with Analysis, Design, Implementation of Business Intelligence systems, Reporting tools and OLAP environments. Evaluation of project various stages to track cost and advise the stakeholders on under-utilized infrastructure there by saving the operational cost. Developed and implemented BI training procedures. Work on all aspects of the engineering of the service, including such topics as performance, testing, HA, dashboard design & tuning. Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards. Develop dashboards and visualizations that empower decision makers. Perform peer review of code and testing in order to detect and minimize application problems. Develop and provide training to team members and staff on basic utilization and advanced proficiencies, up to and including training others to provide backup to this role/function. Develop dashboards and visualizations that empower decision makers. Perform peer review of code and testing in order to detect and minimize application problems. Develop and provide training to team members and staff on basic utilization and advanced proficiencies, up to and including training others to provide backup to this role/function. Experience in installing, upgrading and maintaining Tableau 9.x, 10.x, 2018.x, 2019.x, 2020.x, 2021.x and 2022.3 on multi server nodes with high availability Setup. Excellent knowledge on Tableau Architecture and new features. Active participant in Tableau Center of excellence helping users in guiding with best practices and user training/demos. Extensive experience in using Tab admin and Tabcmd utilities. Configured SSL and SSO Setup for Tableau platforms. 9 years of extensive experience in installation/configuration/upgrade and development of Tableau environment (10.4/10.5/2018.1/2019.1.7/2020.1) along with Dashboard development. 15+ years of experience in installation/configuration and development of Cognos in SUSE Linux 11 and windows 2008 R2. Extensive experience in system architecture, design, implementation, administration, support, and development of business applications. Delivered business intelligence solutions utilizing the Cognos tool suite, SAP Business objects, Qlik and Tableau. Prepared project status reports and addressed BI issues.. Strong experience with Cognos administration, metadata modelling, planning, tuning, and report writing. Extensive knowledge about business processes, requirements and regulations. Proficient in designing and creating various data visualization dashboards, worksheets and analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization utilizing Tableau visualizations according to the end user requirement. Experience in Alteryx installation/configuration of workers (engine) in HA environment. Competent in application of BI strategies and techniques to practical situations. Strong analytical and problem-solving skills. Maintains high productivity by completing 95% of assigned tasks within budgeted hours and within schedule. Ability to build and maintain good relations with staff and external associates. EDUCATION & CERTIFICATIONS Master of Computer Applications (MCA) from University of Madras in 2004, TN, India Tableau badges on Developer & Server Admin. Google Certified Professional Data Engineer Certified AWS Cloud Practitioner. Certified in Alteryx Designer core. IBM Certified Developer Cognos 8 Business Intelligence Metadata Models in 2009. Cognos Report net Product User in 2006. TECHNICAL SKILLS BI Tools : Tableau 2022.3.8, 2020.4.6, IBM Cognos 8, 10 & Cognos Analytics. Knowledge on Cognos ReportNet 1.1 and Cognos 7 Series, SAP BO 4.2 (webi, Lumira), Power BI ETL : IBM Cognos Data Manager, IBM Data Stage Operating Systems: Windows, Linux Databases : Google BigQuery, AWS Redshift, Dremio, Postgres, Oracle 9i & 10g, SQL Server 2010, Netezza. PROFESSIONAL EXPERIENCE Work History: Organization Client Role Project Start Date End Date Deutsche Bank Deutsche Bank BI Lead Admin / Developer / Cloud Engineer BI Sell Option/TCop 08/2013 Present Sage IT Marriott International Sr BI Consultant SGR/PGR 10/2010 07/2013 Sage IT CNSI BI Consultant SD State Medicaid 01/2007 10/2010 Cognizant Technology Solutions Johnson & Johnson Programmer Analyst Johnson & Johnson 06/2006 01/2007 Teamware Solutions Abbott Laboratories Software Engineer Abbott Laboratories 01/2005 06/2006 12/2014 Present, Deutsche Bank, Cary, NC Project: BI Sell Option / TCoP(Tableau Center of Practice) / Tableau /PowerBI Role: BI Lead 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, SAP BO and Tableau tools were identified as bank strategic tools and converting the business use cases from non-strategic to strategic. Responsibilities: 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. Managing the Tableau platform and installed/configured High Availability (HA) tableau infrastructure in Prod & DR environments. Automated the repetitive admin tasks at platform level and reduced the L2 & L3 support group cycles. Experience in developing automation scripts to remove inactive users, unused content on the server. Developed visualization dashboards connecting to different data sources like Oracle, SQL Server, Hive, Postgres and different other data sources. Responsible for design, develop, model and create data structures to integrate and prepare for reporting solutions and broader business intelligence application. Responsible for mentoring Tableau developers and perform code reviews to ensure best practices are followed to ensure dashboards are designed as per the standards. Responsible for designing Tableau dashboards and visualization to provide interpretation & Insights on client data which helps bank to adhere to KYC & other regulatory requirements. Experience in Installation and configuration of PowerBI Gateway servers. Clustered the PowerBI in multiple regions. Define and refine data standards/reference architectures for use by specific project teams in developing technical designs. Support data tractability, integrity and validation documentation along with ETL code, data dictionaries, profiles and code repository management. Leading and working towards the decommission of non-strategic business intelligence tools by the end of the year. Involved in the Bank Engineering days and showcased the BI tools and features. ITAO for the BI applications. Doing poc s to host Business intelligence platforms into google cloud. Environment: Tableau 2022.3.8, 2020.4.4/2020.1.7/2018.1/10.5 Tab Migrate, Postgres SQL, PowerBI 1.16, IBM Cognos 10.2.2 FP6. 08/2013 12/2014 Deutsche Bank Cary, NC Project: BI Platform IBM Cognos Role: BI Platform Admin / Developer Deutsche Bank is upgrading dbReport application from v8.4 to v10.2.2. This upgrade will consist of all new infrastructure, more current OS systems on the servers in three global regions UK, Us and Singapore. dbReport platform is all applications to on-board into platform and allow applications to develop their own reporting and analytical solutions. Including IBM Cognos and Business objects as bank strategic Business Intelligence tools, Deutsche bank adopted Tableau as Visualization tool and planning to expand the tableau services across the organization. Responsibilities: Strong experience with Cognos installation, Tuning and administration. Technical and functional understanding of the current Architecture. Upgraded the platform from Cognos 8.2/8.4 to Cognos 10.2.2. Extensive experience in developing Dashboards and reports using Report Studio, Active reports, Workspace Advance. Business partnership and vendor management. Guided business users in developing reports and self-service solutions. Provided training to users on Cognos suite (report studio, workspace advance). Strong experience in working with business users and understanding the requirements. Participating in the User meetings to analyze and prepare the reporting and analysis requirements of users. As part of ZIP(Zero intervention production), designed the process of content migration from lower to higher environments using IBM Udeploy. Managed and mentor the vendor resources L2 (Production) L3 (dev&uat) who supports the business intelligence platforms. Environment: Cognos Analytics (11), Cognos 10.2 suite, Cognos 8.4, Oracle 11g, Control-M, Udeploy, Tableau 10.4 10/2010 12/2012 Marriott International, Bethesda, MD Project: SGR/PGR Role: Cognos Lead Developer 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. Responsibilities: 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 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. Supported business and Team members in the training on Cognos 10.1.1. 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. 02/2007 to 10/2010 CNSI, Pierre, SD Sr. Cognos Developer 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. Although coverage, limitations, and administration may differ, billing procedures and reimbursement methods are essentially the same. The Reporting environment deals with various modules like provider, Claims, Security, Eligibility, Prior Authorization, Financials and Siebel CRM Responsibilities: Technical and functional understanding of the process / requirements. Reviewed the existing BI Architecture and proposed the changes to meet the new business requirements and for long-term planning. Involved in design & implementation of Datawarehouse. Implemented the reporting solution using IBM Cognos business intelligence tool. Installed and managed IBM Cognos infrastructure for state of SD. Upgraded Cognos environments from existing to latest versions and applied released patches to the platform. Development of Framework models for the purpose of Complex reporting solutions. Developed Models, Created Packages, Reports and Dashboards as per the design Considerations. Implemented the security at the different layers in Cognos. Worked with business users to perform data analysis. 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. 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. 06/06 to 01/07 Cognizant Technology Solutions, Pune, India Programmer Analyst/Cognos Developer 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. The company focuses on procedure-enabling devices for the interventional diagnosis and treatment of conditions in general surgery as well as in gastrointestinal health, gynecology and surgical oncology. EES mission is to help physicians around the world transform patient care through innovation. Ethicon Endo-Surgery (EES) is in the process of implementing an Enterprise-wide Data warehouse (EDW) and Business Intelligence (BI) Reporting. The EDW team has identified a need for a plan to facilitate the process of development and change control. It provides EDW development team personnel the information they need. Responsibilities: 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. Environment: Cognos ReportNet V1.1, Oracle 9i, Cognos Transformer 7.2. 01/05 to 06/06 Abbott, Mumbai, India. Consultant Application Developer 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. The system provides 24 months of strategic forecasting/planning information for product families. The Abbott Laboratories Global SCM Group has identified a set of improvements to enhance and stabilize its current SCM environment. Responsibilities: 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. 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. Keywords: artificial intelligence business intelligence active directory information technology golang trade national procedural language Maryland North Carolina South Dakota Tennessee