Pavan Alluri Email and Phone Number

10+ years of experience in IT ranging from Business, Systems and Data Analysis, Application Enhancement & Production Support of complex data warehousing applications in the P&C Insurance industry. Highly skilled in working with stakeholders to elicit, analyze, specify and validate business and solution requirements to meet business needs. Able to bring together a diverse stakeholder group, drive consensus and create a shared understanding between the customer community and the solution delivery team while maintaining alignment with Business and IT Strategies. Experienced working face to face with business stakeholders at onshore client location to clearly understand business requirements for past 4 years. Experienced in working with large Data warehouse databases and data marts. Worked closely with COGNOS developers to better understand how efficiently data can be provided to them at the semantic layer for their reporting needs. Experienced in using SQL for Data Profiling & Analysis. Experienced in using SAS for purposes of Data Profiling and Analysis. Experienced in working with multiple data warehouse projects utilizing Star and Snowflake schemas. Experienced in analyzing source data structures to validate business rules to ensure efficient and error free data transformation in the ETL code. Experienced in presentation of Data Analysis findings for Functional Requirements clarification to the business and other Subject Matter experts. Experienced in creating Requirement Artifacts such as Functional Requirements Document, Attribute Mapping document, Requirement Traceability Matrix, Data profiling package. Experienced in working with data models around data warehouses and data marts to understand source data and how data needs to be landed in the target database. Experienced in Business Requirements clarification with Subject matter experts - along with maintaining multiple interaction points with functional areas such as QA, DBA, ARCH and Project Tech leads. Worked closely to assist Project Manager to estimate Project Scope after understanding Business Requirements and extent of work. Experienced in working on Ad-Hoc data analysis queries from business users regarding anomalies in production data. Has worked as a part of a data warehouse production Support team to provide Ad-hoc data extracts from data marts. Strong analytical skills and the ability to handle multiple tasks as well as projects independently or in a team. Strong written & verbal communication and collaboration skills.