Pranav Reddy Padala

• Led Project Architecture and Delivery, overseeing the end-to-end design and implementation of the Sotatercept data processing framework, ensuring alignment with business objectives and stakeholder requirements.
• Architected and Developed a config-driven Spark framework for loading reporting tables, enhancing data processing efficiency and accuracy.
• Implemented ETL Processes utilizing Databricks, Airflow, and AWS S3, resulting in streamlined data orchestration and improved reporting capabilities.
• Architected and Developed Notification Framework to automate job completion alerts, ensuring timely communication of processing results and enhancing operational responsiveness.
• Designed and Developed modular Databricks Notebooks that integrate base and metric queries, optimizing the extraction and transformation of metric data for reporting.
• Managed Configuration Management through dynamic JSON configuration files, allowing for flexible parameterization of ETL jobs based on environment and workflow specifications.
• Enhanced Data Integrity by incorporating comprehensive logging mechanisms to track job successes and failures, facilitating easier troubleshooting and audit compliance.
• Collaborated with Development Teams using GitHub for version control and Jenkins for CI/CD pipelines, fostering a collaborative environment and ensuring streamlined code deployments.
• Developed Best Practices for data governance and quality assurance, implementing audit columns in reporting tables to maintain data lineage and traceability.
• Conducted Architectural Reviews and provided technical guidance, mentoring team members on best practices in data architecture and ETL design.

Dec 2021 – Present

• Developed and maintained a robust PySpark-based framework for business metrics, enabling users to configure KPIs aligned with integration strategies and business objectives.
• Engineered Python solutions for integrating legacy systems with external tools, enhancing operational alignment and streamlining data processes with external partners.
• Served as the Spark Data Architect for a comprehensive BI solution on AWS, ensuring scalable and secure data architecture that supports integration with partner systems.
• Led BI and mobile reporting initiatives across technologies such as Python, PySpark, SQL Server, and Power BI, delivering insightful reporting solutions that meet stakeholder needs.
• Managed an offshore development team of 16, overseeing task assignments and deliverables while facilitating onboarding on integration tools and technologies.
• Prepared detailed effort and cost estimates for various integration projects, consistently delivering solutions within budget and timeline, while aligning with client expectations.
• Contributed to five RFPs, securing multimillion-dollar contracts by effectively demonstrating integration capabilities and value propositions to potential clients.

• Designed integration architecture for the insight generation module of the Verso chatbot, aligning technology solutions with client engagement strategies and enhancing user interaction.
• Led a team of Python developers for the Verso project, driving technical excellence and ensuring the implementation of effective integration solutions.
• Participated in business development efforts, conducting POCs to showcase integration capabilities, which bolstered client confidence and secured new projects.
• Revamped existing integration frameworks, delivering scalable solutions to support the growing demands of partner collaboration and ensuring alignment with IT strategy.
• Documented technical and functional specifications to clearly outline integration processes and requirements, fostering consistency across partner integrations.
• Received impact recognition award for being one of the top performers in the organization

• Developed a data ingestion framework using Python and PySpark, enabling seamless onboarding of data from diverse sources and establishing a reliable integration platform.
• Designed and implemented on-premise data warehouses for US pharmaceutical clients, ensuring robust data integration and accessibility for analytics.
• Created a PySpark algorithm for identifying critical data points, enhancing the efficiency of insight generation in integration projects.
• Collaborated on ETL processes to maintain data integrity and optimize pipeline stability, ensuring seamless data flow for business intelligence applications.
• Developed an NLP interface on Power BI, facilitating user-generated ad-hoc reporting and improving data accessibility for partners.