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.
• 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

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.

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.

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

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.

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.

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.

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.