Praveen Vudutha Email & Phone Number

Glendale, Ca

• Provided technical expertise throughout all phases of the system data integration life cycle, including requirements gathering, analysis, design, implementation, and support, across both Waterfall and Agile platforms..• Led and developed data strategies and transformations for data migration from On premise SQL server to Snowflake database, Migration of data pipelines from Informatica to Matillion, Airflow and DBT• Designed, updated, and maintained complex software and data integration programs for LegalZoom IT using a diverse technology stack, including Snowflake, Airflow, DBT, Matillion, Fivetran, SSIS, SSRS, ServiceNow, Microsoft SQL Server, and Amazon Web Services.• Integrated data from multiple sources to enhance accessibility and retrieval across various user interfaces, including Salesforce and Salesforce Marketing Cloud.• Developed and supported protocols for data governance, privacy standards, data quality, integration, management, and ETL processes.• Established and executed ETL workflows using tools such as Airflow, DBT, Fivetran, Python, AWS, Snowflake, Microsoft SQL Server/SSIS, and Matillion• Created and maintained tableau dashboards for Marketing, Finance, fulfilment and contact center teams.• Worked on Tableau Administration supporting publishing dashboards scheduling data extracts and creating access groups and maintain tableau user licenses.• Conducted data system integration tests and validation/verification runs of new software applications to ensure optimal data processing and seamless integration with key enterprise management systems.• Coordinated stakeholder reviews and feedback to refine development work and ensure alignment with business needs.• Played a pivotal role in creating Unified Data Model, unifying data from Legacy business processes and newly introduced business processes ensuring seamless data flow to downstream data warehouse and reporting models

Fremont, Ca

• Conducted detailed data analysis of requested business data elements and data sources, documenting data source definitions, source-to-target mappings, and logical structures for data warehouses and data marts.• Developed exception-handling strategies within SQL Server databases to manage and resolve data discrepancies effectively.• Performed analysis on XML files to support data integration and transformation processes.• Designed, developed, and tested SSIS packages, with a focus on performance tuning to optimize data flow and transformation processes.• Managed unit testing, system testing, and integration testing of SSIS mappings to ensure accurate and reliable data processing.• Oversaw code deployments from development to QA and from QA to production environments, ensuring smooth transitions and minimal disruption.• Developed data quality goals, metrics, and key performance indicators to enhance data integrity and reporting accuracy.• Utilized Tableau for BI reporting, including Tableau Desktop, Tableau Server, and Tableau Reader, to create and manage interactive worksheets, graphs, charts, and dashboards.• Created and configured classes with Dimension, Detail, and Measure objects in Tableau, specifying hierarchies and defining joins and cardinalities to ensure comprehensive data analysis.

Torrance, California, United States

• Built ETL processes for populating analytics data using Informatica and Oracle-based data warehouses, ensuring accurate and efficient data integration.• Designed, developed, and tested ETL mappings with Informatica, incorporating performance tuning to optimize data flow and transformation.• Implemented error handling mechanisms using error tables and unique violation tables to manage and resolve data issues effectively.• Applied slowly changing dimension (SCD) methodology to track and manage historical data changes, ensuring accurate historical analysis.• Developed automated platforms for referential integrity checks, data validation, and sanity checks, improving data accuracy and consistency.• Built scenarios and logic for data quality checks to ensure high standards of data integrity.• Conducted requirement gap analysis and data profiling, and managed code migration processes from development to QA and from QA to production environments.• Created and managed data feeds for Hyperion, supporting sales performance reporting with accurate and timely data.

Hillsboro, Oregon, United States

• Analyzed existing systems and developed design documentation for migration strategies, ensuring a clear and effective approach for data transitions.• Performed detailed data analysis for both business-requested data elements and source systems, documenting data definitions, source-to-target mappings, and logical structures for data warehouses and data marts.• Created complex SSIS mappings including filters, update strategies, joiners, stored procedures, SQL transformations, unions, and expressions, capturing high-quality data from internal and external sources.• Conducted unit, system, and integration testing of mappings and workflows, ensuring the accuracy and reliability of data transformations.• Developed various data transformations to support data loading processes, enhancing data processing efficiency.• Created and Published multiple reports and dashboards in Tableau• Developed test cases and SQL queries to perform comprehensive validations, ensuring data integrity and correctness.• Implemented Slowly Changing Dimensions (SCD) for Type 1 and Type 2 to manage historical data changes and maintain accurate historical records.• Created complex SSIS packages with effective control and data flow elements, including robust error handling to manage data issues.• Developed reports using SQL Server Reporting Services (SSRS) for customized and ad-hoc queries, supporting detailed data analysis and reporting needs.• Scheduled and conducted regular reviews and validations with stakeholders, ensuring their sign-off for production releases and maintaining alignment with project requirements.

Hyderabad, Telangana, India

• Created and modified PL/SQL scripts for efficient data conversions, ensuring accuracy and integrity during data migration processes.• Developed SQL queries to extract data from multiple sources using database links, facilitating comprehensive data retrieval and integration.• Prepared detailed design documents for integrations and transformations, providing a clear blueprint for development and implementation.• Ensured data quality by validating and verifying data extracted from various sources, maintaining high standards of accuracy.• Developed validation scripts for various business use cases, ensuring data meets the required criteria and standards.• Designed and created tables and scripts for data mart tables used in reporting, supporting efficient data storage and retrieval.• Scheduled regular reviews and validations with stakeholders, securing sign-offs for production releases to ensure compliance and quality.• Provided production support for code and functionality deployed to production, addressing issues and ensuring smooth operation.

Hyderabad, Telangana, India

• Conducted requirement analysis and designed comprehensive test strategies and plans to ensure effective coverage of all testing needs.• Collaborated with development teams and designers to understand requirements and project timelines, facilitating seamless project execution.• Developed test scenarios for data integration, functional, and regression use cases, ensuring thorough testing across various application functionalities.• Created and developed test cases and related SQL scripts for integration, functional, and regression testing, aligning with project requirements.• Executed test cases and captured results for integration, functional, and regression tests, documenting outcomes and issues.• Ensured data quality by validating and verifying data extracted from various sources, maintaining accuracy and consistency.• Logged bugs and created detailed bug reports, working closely with developers to facilitate timely resolution.• Communicated project status and provided reports to Managers and stakeholders, keeping them informed of progress and issues.• Scheduled and conducted User Acceptance Testing (UAT) and regular reviews with stakeholders, ensuring that testing sign-offs were obtained for production releases.

Mysore, Karnataka, India

• Performed requirement analysis and designed comprehensive test strategies and plans to ensure thorough coverage of all test scenarios.• Collaborated with development teams and designers to understand requirements and project timelines, ensuring alignment and effective communication throughout the project lifecycle.• Developed test scenarios for data integration, functional, and regression use cases, covering a wide range of functionalities and business processes.• Created test data for various scenarios, including Number Porting, Address Changes, New Connections, and Service Cancellations, to ensure accurate and realistic testing.• Executed test cases and captured results, providing detailed documentation of outcomes and discrepancies.• Logged bugs and created bug reports, working closely with developers to facilitate resolution and track progress.• Prepared and presented test and bug reports to Managers and stakeholders, highlighting key findings and status updates.• Scheduled and conducted User Acceptance Testing (UAT) and regular reviews with stakeholders, ensuring that testing sign-offs were obtained for production releases.

Bengaluru, Karnataka, India

• Developed an end-to-end audit plan for Quote to Cash processes, including Quote and Order Creation, Order Management, and Post-Purchase Service Sales, ensuring comprehensive coverage and effectiveness.• Collaborated with operations team managers and stakeholders to establish audit percentages and quality expectations, aligning audit practices with organizational goals.• Performed daily quality audits on cases processed by various operational teams, maintaining a high standard of accuracy and compliance.• Created and communicated daily audit results to the Audit Team and Operations Team Managers, providing clear insights into audit findings and performance metrics.• Developed training and education plans based on audit results, addressing identified gaps and enhancing the skills of operations team members.• Scheduled and conducted regular review meetings with operations teams to discuss areas for improvement, emphasizing the cost of poor quality and promoting best practices.