Vinay Pagadimarri

Lloyds Banking building a new DWH to bring data from multiple sources onto a single platform. As a part of foundational data product program my work as IT Business data analyst is to analyse the data coming from multiple sources and establish the Business data controls, conduct data profiling, and draw a data lineage pipeline. The end goal is creating the data mapping sheets to the data engineers by working with source SME’s and as well as Business stakeholders and technical architect team to draw up the most feasible and cost effective design solution to bring in the data and make it accessible to downstream for curation.

Built Data Product roadmap based on the source data analysis and mapping to strategic goals set by consumer.

• Data modelling of foundational data products - Build physical data model from logical data model.
• Interoperability between foundation data products to build lean data models.
• Data Analysis: Perform data analysis to identify patterns, trends, and insights that support informed decision-making and drive business strategies.
• Work with Product Owner and attend Business workshops as well as stakeholder meetings to understand what the product would be and what information would be crucial to build it.
• Mentoring the team on process flow such for initiatives.
• Understand and translate meeting understanding into documentation for larger audience.
• Metadata Management using Collibra.
• Data controls at Group data level- Environment, Access, Data quality- Source & curation layer.

• Optimized product metrics and share features in product which will improve affiliate & player acquisitions
• Anticipate in discussions with cross-functional upstream (BI, DF, testing, reporting teams) for feature developments and participated in technical discussion for new feature development
• Perform data analysis to identify patterns, trends, and insights that support informed decision-making and drive business strategies
• Translate business requirements into functional specifications and system design documents
• Collaborate with technical teams to ensure accurate implementation of solutions
• Building strong relationships with stakeholders at various levels of organization
• Facilitate meetings, workshops, and interviews to gather requirements and validate proposed solutions
• Capturing requirements and maintaining required documentation such as (BRD, FRD) using word/excel or any other requirement management tools (Confluence etc.)
• Consume business process, information and technical architecture briefs and prepared agile sprint release plan to design, build, deploy and validate
• Streamlined business processes migration of legacy system platforms to Anthem (CII Evolve)
• Define business customer requirements (user stories, use cases) and platform requirements for platform feature set
• Determine release goals for Product Increment and prioritize assigned features according to business and platform value, adjusting throughout implementation as required for quarterly road map planning and stay aligned with PI plans for feature set
• Used critical thinking to break down problems, evaluate solutions and make decisions
• Driving scrum teams and conducing ceremonies (Grooming, planning, reviews and retrospective)
• Triage incident and categorize them to defects or change requests.

• Interacting with Clients/Stakeholder from initial engagement to delivery of application solutions on Provider data display on UHC provider Portals
• Prototype and wire frames designing
• Migration of reports from Tableau to Power BI with detail information
• Analyzed tableau reports and post analysis must create the source reports in Power BI
• Created data model in Power BI by referring to the Tableau reports
• Data validations and data cleansing using SQL server
• Working with Clients from initial engagement to delivery of application solutions on Provider data display on UHC provider Portals
• Elicit and gather business requirements and converting to functional solution requirements
• Communicating with informatics specialists, product managers and developers to ensure translation of requirements to IT solutions.

• Working with Clients from initial engagement to delivery of application solutions on Provider data display on UHC provider Portals
• Data validations and data cleansing using SQL server
• Having good knowledge on Data Management Center (DMC) tool, Extract Process work flow (ETL)
• Have worked on new source project setups and on new Extract project setups in Open Enrollment Period
• Solved the complex project setups and developed innovative solutions as per client request
• Research data source issues with internal resource persons as needed
• Have been Part of End to End analytics of product deliverables.

• Collect business requirements and produce reports accordingly
• Used varied types of reports in process of producing business reports
• Designed and developed ETL process to import data from various sources like Flat-File, Excel and also Relational Databases
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task etc
• Planned, defined and designed data based on the business requirements
• Created various Database Objects - Tables, Indexes, Views, and Roles
• Created SSIS process design architecture and flow of data from various sources to target Generated matrix reports, drill down, and drill through, sub reports, chart reports, multi parameterized reports
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS) to generate all daily, weekly, monthly and quarterly Reports including current status.