Phani Kumar Endaluru

Experience

• 

  Cognizant

  May 2007 - Jan 2014

  Senior Associate

  · Plan, design, deploy and maintain enterprise-level Business Intelligence and Data Warehousing applications· Prepare strategic dashboards and reports for analysis, optimization, streamlining and to improve leadership visibility in the key areas of operations· Educate prospective clients on the importance of Business Intelligence and make them use it effectively· Evaluate, review and recommend tools, technology and methodology and provide consultancy service to design and spell out best-practices for a new or existing business intelligence initiative of a client· Work with users to understand business process and to develop detailed design specifications for data collection, reporting repositories and processes, to ensure that BI functionality addresses user requirements· Provide reasonable and accurate estimates of time for projects based on information provided by client about technical and functional requirements· Design the ER model after gathering requirements· Designing universe model from scratch· Creating Ad hoc and shared reports for clients based on requirements· Analyze data in reports and provided Gap analysis to client for better data management· Schedule reports to Users Inbox or Email or Shared location· Maintain reports security by organizing users into right BI Role security groups Show less

• 

  Tech Mahindra

  Aug 2014 - Nov 2018

  Technical Manager

  ·Work with business users and functional experts from Supply Chain/Logistics and Finance processes related to US Local Models to understand business requirements·Prepare technical and functional design documents to demonstrate end-to-end business process solution to business users.·Performed unit, integration and regression testing of technical solutions being developed·Develop back-end ETL scripts in Qlikview by connecting to Oracle 11g database and develop front-end Qlikview reports as per business need·Developing, enhancing existing dashboards with new functionalities, re-engineering, maintaining and supporting Qlikview applications·Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure·Perform Qlikview Administrative activities of creating tasks, scheduling, loop and reduce and publishing of reports·Interacted actively with the Testing Team and performed Data Validation, Identified and analyzed the data irregularities and pointed out key solutions·Training and working with business users in resolving the issues faced during User Acceptance Testing and after Go-Live·Migration of Qlikview Reports to Qliksense 3.2 environment Show less

• 

  Accenture

  Nov 2018 - Jul 2023

  1.Studying source systems and process of existing data warehouse; understanding and documenting user requirements; preparing the functional specification document into the Data Model and modelling it into the Star/Snowflake Schema or any user specific schemas2.Determining ETL Data Architecture & strategies to ensure ETL processes and Data Warehouse Data Model are optimized for data reuse and scalability; understanding the EDW ETL & Data Architecture at a holistic level, and the data that is available across all operational systems feeding the EDW3.Performing impact analysis on existing ETL and EDW Data Model when new ETL logic or new source systems are introduced into the data warehouse, developing & maintaining DW ETL infrastructure4.Conducting peer review of codes; addressing & resolving business issues in case of non-performance of warehouse.5.Managing all the technology related requirements, including technical feasibility study, procurement and upgradation / migration of hardware, software, database & applications6.Utilizing data warehouse technical architectures, infrastructure components, data structures, Extract, Transform & Load (ETL) and reporting/analytic tools and environments in projects7.Monitoring building, management / maintenance of Enterprise Data Warehouses; collaborating with disparate data sources and transforming into a unified solution8.Reviewing & suggesting suitable improvements in data models; enforced data modelling standards, best practices in the design9.Guiding team in creating architectural case studies to help architects in designing solutions for new projects10.Liaising with clients and project managers for resolving technical project issues11.Developing innovative business solutions to improve revenue, quality and product performance and reduce cost by leveraging combination of domain knowledge, data science & data engineering skills Show less

  • Analytics Manager

    Dec 2022 - Jul 2023

  • Associate Manager

    Nov 2018 - Dec 2022
• 

  HSBC

  Jul 2023 - now

  Vice President Data Insights