Pavan Alluri Email & Phone Number

Texas, United States

The work in the BI knowledge and Insight team involves currently working as Analyst / data scientist on various project to bring various health care systems data from such as Cerner, All Scripts, BMD, Centricity Business m Cactus. Siemens Invision etc. into Enterprise Data warehouse. Is responsible for gathering business and technical requirements, source system analysis, gap analysis, data profiling, requirements documentation for ETL development and report development. Work involves the use of various technologies Business objects, Tableau, Informatica, COGNOS, ORACLE, SQL Server, Mainframe etc. and tools such as TOAD, AGINITY and JIRA. Responsibilities involve performing UAT testing & report testing. Attending data model walkthroughs and providing feedback to assist modelling, architecture, ETL team on daily basis. Walkthrough of requirements mapping document and impact analysis with respect to any changes in the ETL process. Participation in Scrum meetings (agile methodology) and provide updates on stories.

Bengaluru, Karnataka, India

Involved in business requirement elicitation meetings with the users of the intended application to understand the required functionalities that the application would need to fulfill, to satisfy the client needs. Involved in data element identification from source systems to ensure that the designated warehouse data points would satisfy the ultimate functionalities of the application. Performed data profiling on identified data elements and presented the findings of data analysis to business for further requirements refinement. Ad-Hoc requests for time slices of production data and scenario based data-samples which helped business requirements fine-tuning. Working with upstream application teams to understand source data to effectively arrive at required data transformation rules. Conducted Requirement analysis and data profiling to ensure that the designated warehouse data points would satisfy the ultimate functionalities of the application. Conducted walkthroughs of the documented requirements for business sign-off. Responsible for communicating the signed off requirements to development and quality assurance teams for code design and functional test phases. Responsible for driving discussions during times of ambiguity around system design from a requirements perspective. Assisted to ensure all test scenarios that should be validated where made available to the project quality assurance committee. Was on point for the clarification of requirements during functional and user acceptance testing.

Gurugram, Haryana, India

WNS is Serviced Company providing support to Suncorp Group which is into insurance and banking in Australia. We do MIS reporting and improve customer services by delivering timely and accurate financial balanced reports. The aim of the project was to provide users with all claims and policies related information for analysis. Enhanced SAS programs using pass-through methods and Libname statements for extracting data from diverse sources. Worked on making changes in Tableau reports, ensuring alignment with evolving business requirements. Developed and executed SAS programs for extracting data from Data-mart, supporting business analysis and decision-making. Investigated system issues and implemented resolutions to reduce downtime. Improved company efficiency with the development of key performance indicators and tracking metrics.

Bengaluru, Karnataka, India

Mu-sigma business Solutions is a Service provider to US Bank for campaign management and reporting. Involved in generating reports for different portfolios for Balance Transfer and Non – BT Campaigns. This Process is done on a quarterly Basis for all portfolios. Developing SAS Programs to extract the data from Data-mart. Doing pre-processing Checks on History, Responder and Accounts file. Doing Audit Checks for generated Reports. Running SQL Queries for Analysis Team. Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement. Improved business processes by analyzing current practices and recommending optimization strategies.