Feb 2017 – Oct 2025 · 8 yrs 8 mos · United States · Remote

• Optum Insight/Change Healthcaree
• Healthcare Data Platform Initiatives: Architected cloud-native data platforms on AWS and led large-scale ingestion and analytics of transactional (EDI, HL7, FHIR) and clinical data, enabling seamless flow and regulatory compliance.
• Cloud Infrastructure Design: Designed and deployed secure, high-availability AWS environments leveraging S3, EMR, Glue, Lambda, and MSK to support healthcare data integration and analytics.
• Data Pipeline Optimization: Accelerated delivery by 40% through reusable data transformation modules, a comprehensive testing framework, and orchestration frameworks, boosting engineering throughput and consistency.
• Data Product Development: Built and delivered data marts, analytical warehouses, and governed analytics-ready assets using Snowflake, Redshift, and Lake Formation to enable self-service analytics, ML workflows, and real-time decision support.
• API Development & Management: Developed real-time and batch APIs for data egress, contributing to cost optimization, innovation strategy, and resolution of critical incidents across pipelines.
• Generative AI & Automation Integration: Integrated LLMs, RAG, and generative AI into platforms, reducing engineer onboarding time by 25% and enabling ChatBot-driven pipeline creation.
• Cloud Cost Optimization: Delivered up to 60% cost savings through serverless architectures, managed services, code optimization, and intelligent resource allocation without sacrificing performance.
• Strategic Alignment & Collaboration: Participated in roadmap discussions, PI planning, agile ceremonies, and executive readouts, ensuring architectural coherence and cross-functional alignment.
• Leadership & Team Management: Directed and empowered a global team of 30+ engineers and product experts to deliver enterprise-scale solutions with > 99.9% uptime, rapid incident resolution, and seamless customer experiences.

Sep 2014 – Jan 2017 · 2 yrs 4 mos · Charlotte, North Carolina Area

• Responsible for analyzing ‘Data Process Documents’ provided by SoR (System of Record) SMEs.
• Responsible for reviewing Integrated Layer Mapping Document (ILMD) for Developers and Quality Assurance teams which portrays Source to Target mappings.
• Understanding the specifications of Profit View and interacting with the data architects and the end users for informational requirements
• Analysing SoR on their active platform, i.e.: Teradata, Oracle and HDFS Platform.
• Understanding each different sources and their internal structures and suggesting data model changes to accommodate different SoRs in the Integrated Layer.
• Writing queries in both Relational SQLs and HiveQLs based on partitioning, bucketing and distribution concepts for better performance and quick result sets.
• Hands-on Knowledge on MapReduce, Spark, Sqoop, Splice Machine.
• Responsible for creating and maintaining Reference Data for re-usability of data.
• Analyzing different streams of data and gathering technical and performance stats for Reporting Requirements.
• Developed complex SQL queries to analyze, validate and manipulate data to fulfill business requirement specifications and reporting requirements including identifying the tables and columns from where data is extracted
• Writing queries with complex joins, analytical functions, windowing functions, nested sub queries, common table expressions with levels, regular expressions to validate ETL processes.

Mar 2013 – Sep 2014 · 1 yr 6 mos · Greater Atlanta Area

• Responsible for gathering and document project validation requirements from Business Users.
• Responsible for developing Functional Requirements Document to ensure the delivery of quality software applications, reporting results to the project team.
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data architects and the end users for informational requirements
• Responsible for creating POC involving a scalable distributed data solutions using Hadoop to process approximately 50 billion records to provide Best Match algorithm.
• Hands on writing Map Reduce programs and using Hive for data extraction, transformation and aggregation from source.
• Responsible for analyzing different sources and preparing Source to Target data mapping documents for ETL developers.
• Trained on Apache Spark Concepts
• Analyzing different streams of data and gathering technical stats of accuracy and choosing the source based on accuracy
• Developed complex SQL queries to extract, validate and manipulate date to fulfill business requirement specifications and reporting requirements including identifying the tables and columns from where data is extracted
• Writing queries with complex joins, analytical functions, windowing functions, nested sub queries, common table expressions with levels, regular expressions to validate ETL processes and Micro Strategy reports.
• Reviewed Visualization reports using D3 to showcase the dealers/customer integration and mindsets.
• Performed Manual, Regression, Smoke and Integration Testing, including Data Integrity, validation for ETL data transformations.

Aug 2012 – Feb 2013 · 6 mos

• Responsible for preparing Technical design documents to develop comprehensive data warehouse for the business to analyze their Service Request and Incident Management system
• Responsible for creating functional requirements to develop Cognos cubes to utilize the data from the new data warehouse
• Creating and Testing Cognos Cubes by via drill up/down using different Dimensions and facts.
• Creating Ad-Hoc reports based on business scenarios and demonstrating to the end users
• Writing queries with complex joins, analytical functions, windowing functions, nested sub queries, common table expressions with levels, regular expressions to validate ETL processes
• Coordinating with the QA team to draw up the Test Strategy to test both ETL and Reporting processes.
• Helped the QA team by creating ad-hoc test cases from a business point of view and adding extra test cases based on learning’s from defects
• Validated prompts, filters, data, fonts, alignments, spell checks on the Cognos cubes.
• Validation of requirements document against Package and performing data validation on the packages
• Verification of layout and design Requirements of the cube against the User Functional Report Requirement Specification
• Submitted weekly bug or issue report updates to the Project Manager.
• Preparing and supporting the QA and UAT test environments
• Worked in agile methodology and attended daily SCRUM meetings.

Apr 2011 – Jul 2012 · 1 yr 3 mos · Chennai Area, India

• Prepared comprehensive test plan to validate the migration of decision support system from UNIX platform to LINUX platforms
• Identified report templates based on customer usage, traffic and prepared test cases based on metrics
• Data validation of the migrated environment by testing the dynamic multi-dimensional reports and checking the quality of the data with respective to the existing environment.
• Responsible for the requirements: ETL Analysis, ETL Testing and designing of the flow and logic for the Data warehouse project
• Created automated tool using server requests submitting via Methods written in Java and retrieving via VB.net to automate report submission to various environments and given users the ability to execute the same reports multiple times with different user ids and cross submitting them in different platforms
• Created and executed SQL queries to perform Data Integrity testing on an Microsoft SQL Server Database to validate the data for based on user criteria.
• Writing SQL queries and executing against the database (Teradata) and compare the raw output with that of the migrated report.
• Identifying the data validation scenarios and prepare the scripts and validate the data using automated utilities and tools.
• Identifying defects in the data during the testing, performing defect analysis,
• Preparing the status reports and also coordinates with the onsite and bridge the gap between onsite and offshore

Jun 2008 – Mar 2011 · 2 yrs 9 mos · Chennai Area, India

• Analyzing the client’s requirement and the mapping document of migrating data from Source to Target.
• Developing proof of concepts based on client’s requirements and showcasing them for approval.
• Creating/Modifying tables/columns based on the requirements
• Developing triggers and workflows to achieve client’s requirement
• Developing reports using document explorer and creating complex SQL views to be mapped in the reporting architecture.
• Developing on screen validation, data retrieval from SQL Server by writing functions, classes and methods using Java scripts
• Testing the SSIS package basing the mapping document.
• Performing Data Validation by analyzing data in both Source and Destination using SQL Queries.
• Coordinating with the onsite Team regarding clarifications in the Requirement.
• Defect Tracking, Reporting and Documenting.
• Test Status reporting on a daily/weekly basis.