Balu Babu Email & Phone Number

London, England, United Kingdom

• Successfully executed the migration of data from Postgres to Arango, ensuring the smooth transfer of information from a relational data store to a graph data store.• Implemented an Extract, Transform, Load (ETL) process for diagnostic data into the graph database (ArangoDB).• Demonstrated expertise in managing and administering the graph database for the product framework.• Optimized Arango queries to enhance product performance and efficiency.• Led the successful transition of data diagnostics from Python to AQL, resulting in a remarkable 33% improvement in product efficiency.• Created OpenAI chatbot functions to respond to inquiries regarding Data Maturity Assessment for organizations.

Chennai Area, India

• Identifying data sources and developing data pipelines and models for asset/adviser retention risks, asset segmentation, and advisor performance.• Extracting necessary information from transaction tables in Unitrax, third-party providers (morning-star, fundata), regulatory bodies, etc using Fivetran data connectors and ingesting it into staging tables of a cloud-data warehouse (Snowflake) for downstream processing.• Data cleaning and transformation using the Data Build Tool and SQL to build clean data models for analytical processing and business intelligence.• Performance improvement of data pipelines by optimising SQL queries.• Assisting Data Analysts in creation and publishing of customised reports and interactive dashboards.• Spearheaded the migration of 93 Powerhouse software components to SQL stored procedures and SEQUEL reports in 6 months, saving $300,000 by retiring the Powerhouse license.• Conducting daily standups, sprint plan meetings, and retrospective meetings.

Chennai Area, India

• Develop, enhance, test, implement, and support mainframe software components for healthcare insurers Independence Blue Cross (IBC), Highmark, and Blue Cross Blue Shield (BCBS).• Identified bugs in the ID card generation batch cycle and introduced batch splitting by carefully analysing the business flow to improve ID card generation for IBC by 33% and BCBS by 67%.• Introduced independence in batch processing of ID cards for each health insurer, saving time for bug fixes and resolution by 33% for IBC and BCBS.• Maintaining ID card transactional databases and implementing yearly policy updates to software related to Medicare and Medicaid and paid policies.• Preparing effort estimates for maintenance and development projects.• Keeping high standards during code peer review and source comparison activities.

Chennai Area, India

• Writing technical specification documents such as MDD (Miniature Development Document) and SRS (Software Requirement Specification) by referring to business specifications.• Reduced the Financial advisory on-demand reporting time by 14% by querying the customer activity tables using SAS.• Review MDD and SRS and proposed code changes with subject matter experts and business analysts at review meetings. • Participating in risk assessment and mitigation meetings about the modules owned and providing necessary workarounds and mitigation plans for each risk.

Chennai, Tamil Nadu, India

• Maintaining daily transactions, current positions, and balances of stocks for client and house accounts in RTA databases, and reconciling positions with balances at the end of the day.• Participating in risk assessment and mitigation meetings about the modules owned and providing necessary workarounds and mitigation plans for each risk.

Chennai, Tamil Nadu, India

• Performing source code validation and source comparing activities for developments and enhancements of software components developed by the team.• Collaborating with the User Interface team and QA team to create a software implementation and production rollout plan.

Master Of Science - Ms, Data Science, Distinction

Completed projects in Machine Learning and Data Mining. Built a chatbot for Surrey Estate & Facilities using Natural Language Processing..

Bachelor Of Technology (B.Tech.), Electrical, Electronics And Communications Engineering, 67%