Praveen T Email & Phone Number

India

Data Integration and ETL Standardization - Health Care Client: Largest US HealthCare PRoviderSpearheaded the documentation of business requirements, technical specifications, and implementation of ETL standards, demonstrating leadership and precision. Conducted comprehensive Data Analysis, ensuring data validity and integrity through the crafting and execution of SQL queries.Developed PL/SQL code in alignment with business requisites, adhering to established standards and regularly pushing the code to the ADS environment for seamless integration.Engaged in daily Scrum calls, providing updates and clarifying any issues to maintain project momentum.Conducted thorough unit testing of code, followed by raising pull requests in ADS for Architect review.Orchestrated code deployment to the UNIX development environment for real-time data generation and System Integration Testing (SIT).Designed job flows using the Univiewer tool, facilitating streamlined scheduling of PL/SQL jobs.Facilitated SIT support and orchestrated migration to the Production environment, backed by comprehensive backup strategies.Provided round-the-clock support for all jobs in Production, effectively managing and mitigating any potential disruptions.Implemented performance tuning strategies to optimize runtimes for various jobs, thereby enhancing efficiency.Actively participated in Incident Management and Problem Management processes, contributing to root cause analysis, resolution, and detailed reporting.

India

During my tenure as a technical lead developer, I played a pivotal role in orchestrating the seamless migration of diverse SQL Server objects to the Snowflake platform. I undertook the transfer of substantial volumes of data warehouse data, ensuring its accuracy and integrity within the Snowflake Cloud DB environment. This encompassed the successful conversion of approximately 400 procedures, 600 views, and 150 functions from SQL Server to the Snowflake format, attaining optimal functionality and performance.Additionally, I took charge of facilitating client onboarding in the new Snowflake environment, streamlining their transition for enhanced operational efficiency. I meticulously transformed around 60 report procedures, skillfully adapting them from SQL Server to the Snowflake framework while preserving their analytical capabilities.My responsibilities extended to offering comprehensive support during both Systems Integration Testing (SIT) and User Acceptance Testing (UAT) phases, ensuring the robustness and reliability of the system. Leveraging Apache Airflow, I expertly scheduled Snowflake jobs, orchestrating processes with precision and optimizing resource allocation.In the face of challenges, I demonstrated my analytical acumen and problem-solving abilities, promptly identifying and implementing effective solutions to encountered issues. My commitment to project transparency and progress was evident through my active participation in Scrum calls, where I provided valuable updates and insights to the team.Overall, this project allowed me to showcase my technical proficiency, project management skills, and collaborative mindset as I played a pivotal role in the successful migration and optimization of critical systems within a dynamic and evolving technological landscape.