Bala Alagarsamy

• Optimized large volume of healthcare claims processing application using Oracle database technologies enhancing system efficiency and meeting stringent SLA's
• Design and publish KPI's in Power BI connecting to Oracle data
• Designed scalable client portal applications with multiple product lines using Microservices, Java and Oracle Objects/Collections in OpenShift
• Led a disaster recovery project from technical requirement to implementation in OCI (Oracle Cloud Infrastructure)
• Implemented streamlined ETL processes and data pipeline utilizing Java and Oracle for efficient data integration and retention, complying with HIPPA needs
• Led Integration efforts after the acquisition for two high-growth product offerings, bringing ~$300M additional revenue
• Architected Interoperability for Post to Pre Payment integrity solutions for Realtime transaction processing
• Designed and Architected Medical Policy Testing solutions for Quality and accuracy
• Provided Data SME support for HiTrust, SOC and data de-identification projects
• Designed a scalable solution for Opportunity Analysis for Sales and client engagement that involves large data volume
• Led architecture design for scalable software solutions, enhancing system performance and reliability.
• Mentored junior engineers, fostering skills development and promoting best practices in coding standards.
• Spearheaded cross-functional collaboration to define project requirements and deliver innovative software products.
• Developed automated testing strategies, improving code quality and reducing deployment risks.
• Implemented Agile methodologies, streamlining development processes and increasing team productivity.
• Analyzed system performance metrics, identifying areas for optimization to enhance user experience.
• Directed technical reviews of software projects, ensuring alignment with organizational goals and compliance standards.
• Advocated for the adoption of modern technologies, driving continuous improvement within the engineering team.
• Completed code debugging, software troubleshooting, root cause analysis, and program reviews.
• Maximized system uptime through proactive identification of potential issues using advanced monitoring tools and rapid resolution of incidents.
• Collaborated with team to analyze system solutions based on client requirements.
• Worked closely with global customers spanning to troubleshoot software problems.

• Designed and developed a prominent product, the Asset Health Center (AHC), to predict and prevent critical asset failures by providing proactive health and performance insights to maximize productivity, safety, and return on investment
• Designed and architected data models and In-house ETL using PL/SQL to load data from source, staging area into the warehouse and the BI Layer in Oracle database
• Created cubes/summary tables utilizing analytical functions to support dashboard presentation, leveraging custom tools supplied by the company
• Enhanced data load efficiency for large volumes of NRT Sensor data by developing and optimizing existing data models
• Ensured successful delivery of quality products on time through effective management and leadership of a high-performance product development team

• Served as a Technical Analyst in the Wholesale Group, providing production support and expertise in data structures, interfaces, and code using Oracle 11g, PL/SQL, Perl, and Unix scripts
• Analyzed and resolved interface and data load issues, enhancing system reliability
• Developed detailed ER diagrams for billing systems through reverse engineering, improving understanding of entity relationships
• Collaborated with support teams to ensure smooth operations and continuity in service delivery
• Optimized issue resolution processes, significantly reducing downtime through proactive monitoring and troubleshooting initiatives.
• Enhanced system documentation, delivering a comprehensive resource for future troubleshooting and code enhancements

Designed and implemented interface file generation packages using PL/SQL to communicate various statuses between HealthPort and third-party vendors

• Led end-to-end database design while creating physical and logical models, ensuring data integrity and efficient processing
• Developed and optimized file layouts for sending and receiving interface files, providing crucial insights to management on the status of medical record requests
• Coordinated with cross-functional teams to streamline database operations and improve system reliability
• Enhanced PL/SQL performance, significantly reducing data processing time and increasing system throughput

• Led design and development of a data warehouse project targeting consumer and logistics groups to enhance supply chain management at AT&T
• Facilitated requirements gathering and conducted comprehensive analysis for Fact and Dimension schema design
• Developed PL/SQL scripts for ETL processes using advanced analytical functions. Created migration scripts to support seamless data movement and transformation. Prepared environment for generating OBIEE reports to provide actionable insights
• Utilized Oracle database versions 10g and 11g, employing tools such as ER-Win and Toad to maintain efficient workflow
• Architected robust data models that optimized data retrieval and analysis
• Delivered ETL solutions, optimizing data accuracy and reliability in reporting initiatives

• Designed and developed large-scale data warehouse models, utilizing advanced PL/SQL packages to execute ETL operations and communicate between applications via Oracle Advanced Queue
• Led efforts in developing portal management systems, integrating secure single sign-on (SSO) solutions, and synchronizing user directories for enhanced system accessibility. Executed extensive data migration to the new Oracle 11g database environment, improving data integrity and enabling reporting
• Streamlined data loading processes, achieving more efficient ETL operations utilizing custom PL/SQL procedures
• Enhanced reporting capabilities by designing OBIEE dashboards for streamlined financial analysis
• Pioneered the development of a custom interface for seamless data integration between PL/SQL and J2EE technologies, improving application interoperability. Developed executive-level dashboards using Java portlets, enabling better decision-making through consolidated insights