PRANAVE K V
Associate Technical Architect
Bangalore
Summary
Associate Technical Architect with 8+ years of experience in planning, building, debugging and optimizing data intensive pipelines (ETL/ELT) using varied data integration or migration tools, tackling challenging architectural and scalability problems, collecting and sorting data in the healthcare, supply chain management, e-commerce and asset management field. Currently, working as a Associate Technical Architect in o9 Solutions
Overview
8
8
years of professional experience
Work History
Associate Technical Architect
O9 Solution
04.2023 - Current
- Collaborate with stakeholders to understand business requirements and design effective ETL solutions.
- Work closely with cross-functional teams, including data scientists, business analysts, and IT professionals, to understand data requirements and deliver solutions.
- Conduct performance analysis and tuning of ETL processes to ensure optimal data processing and load times.
- Identify and resolve performance bottlenecks in collaboration with the development and infrastructure teams.
- Provide technical guidance and mentorship to junior ETL developers.
- Ensure compliance with industry regulations and best practices related to data management.
- Maintain comprehensive documentation for ETL processes, data models, and architecture.
- Ensure that documentation is up-to-date and accessible to relevant stakeholders.
Senior Technical Consultant
O9 Solutions
10.2021 - 04.2023
- Leading a team of 6 technical consultants & data engineers
- Analyzing business requirements from customers, capacity planning, plan, design and develop ETL pipelines for data integration (streaming and batch)
- Increased the ETL batch execution by ~30% by refactoring database objects and optimizing legacy SQL procedures and objects
- Developed an ETL template that can be used for multiple solutions (Supply Planning, Demand Planning, Control Tower)
- Rewritten the legacy ETL system built in DTS and Python to SSIS
- Increased the accuracy of data load by ~60% by designing, developing and implementing a data profiling layer into the pipeline which is capable of proactively analyzing the data against multiple rules ensuring the sanity of the data loaded into the platform.
Senior Software Engineer
WebMD
06.2020 - 10.2021
- Created data pipelines for WebMD master Asset Inventory DWH from different search engine analytical data sources using Pentaho Data Integration
- Automated the manual data reconciliation process between the different sources, increasing the data accuracy and efficiency by 90%
- Reverse Engineered existing ETLs in SSIS and converted it to PDI jobs
- Improved the DWH efficiency by refactoring and optimizing the Vertica projections and scripts
- Introduced several reusable generic PDI jobs and transformations that allowed saves up to 50% on development time.
Senior Implementation Engineer
CareStack
08.2018 - 10.2019
- Create, Validate and Execute ETL plan to board newly acquired client to Carestack PMS
- Increased the efficiency of the legacy reporting platform by approximately 30% using query optimization, indexing and database refactoring
- Data Warehouse design for Analytics (Insurance, Treatment, Income Allocation, etc.) using Dimensional Model
- Developed an internally distributed data migration tool to migrate data from Sybase to MSSQL server using BCP API and C# ASP.NET (Cutting down 60% time consumption)
- Developed a custom logging mechanism for Implementation Automation Tool using NLog (3rd party library)
- Converted existing logging mechanism to Asynchronous file logging & database logging which enables the developers to view the ETL logs real-time.
Conversion Engineer - Implementation
Envestnet
08.2017 - 07.2018
- Design, develop and implement ETL plans to migrate custodian data to Envestnet platform
- Use SSRS to generate customer reports (Income allocations, Daily Journal, Account Statements, SMA assets transactions and other reports)
- Automated the manual data load activity using SSIS and SQL and hence reduced the load time by ~40%
- Optimized the legacy report generation SQL scripts to uplift the performance close to real-time.
Software Engineer
Neologix Software Solutions
01.2016 - 08.2017
- Application Development in PHP and C# ASP.NET (MVC 4)
- Data migration from MYSQL to SQL Server
- Web and Desktop application C# ASP.NET
- Payment gateway integration
- SMS gateway integration
- Documentation in each phase of SDLC.
Education
Bachelor of Technology - Computer Science And Programming
Kerala University
Kerala 04.2001 -
Skills
C#undefined
Awards
- Immaculate Attendance award - Envestnet
- Pinnacle Award - Envestnet
- Key Contributor - Neologix Software Solutions
Timeline
Associate Technical Architect
O9 Solution
04.2023 - Current
Senior Technical Consultant
O9 Solutions
10.2021 - 04.2023
Senior Software Engineer
WebMD
06.2020 - 10.2021
Senior Implementation Engineer
CareStack
08.2018 - 10.2019
Conversion Engineer - Implementation
Envestnet
08.2017 - 07.2018
Software Engineer
Neologix Software Solutions
01.2016 - 08.2017
Bachelor of Technology - Computer Science And Programming
Kerala University
04.2001 -
Similar Profiles
Revanth S MRevanth S M
DevOps Engineer I at o9 solutions LtdDevOps Engineer I at o9 solutions Ltd
Shaik NayeemShaik Nayeem
Accounting Specialist at O9 SolutionsAccounting Specialist at O9 Solutions
Vishnu VinodVishnu Vinod
Senior Product Manager at O9 SolutionsSenior Product Manager at O9 Solutions
Muskan JainMuskan Jain
Associate – Bid Management at Subex Ltd.Associate – Bid Management at Subex Ltd.
Lakshmi Durga KogantiLakshmi Durga Koganti
Technical Writer at Cisco Systems Inc. Ltd.Technical Writer at Cisco Systems Inc. Ltd.