Lohithaksh A Email & Phone Number

Kansas City Metropolitan Area

• Orchestrated the seamless integration of AWS and Salesforce, architecting robust cloud-based data solutions.
• Worked on the optimization of AWS Redshift clusters for high-performance analytics, fine-tuning query execution and data distribution strategies.
• Harnessed S3 for secure and resilient storage, implementing data partitioning and bucketing strategies for peak query efficiency.
• Implemented AWS Data Catalog to meticulously manage metadata, ensuring comprehensive data lineage and facilitating effortless data discovery.
• Spearheaded a successful migration initiative, transferring vital on-premises data to AWS Redshift, resulting in a 30% surge in data accessibility and a 20% reduction in query response times.
• Implemented automated cataloging and documentation processes, streamlining data discovery by 25% and fortifying data governance.

Rhode Island, United States

• Design, develop, and maintain data infrastructure and pipelines to support data analysis and reporting for CVS Health's various lines of business.
• Collaborate with cross-functional teams, including data scientists, business analysts, software engineers, and project managers, to understand data requirements and translate them into scalable and efficient data.
• Identify and evaluate new technologies and data platforms to improve data processing and storage capabilities and ensure data quality and integrity.
• Develop ETL processes to extract, transform, and load data from disparate sources into a common data repository.
• Implement data modeling and visualization techniques to provide insights and support decision-making across the organization.
• Ensure data compliance with regulatory requirements and industry best practices, including HIPAA and other privacy laws.To develop a data-driven solution that identifies high-risk patients for proactive intervention.

• Developed Spark applications in Scala on Hadoop cluster to deliver data domain asset models, including core data pipeline frameworks and required user defined functions (UDFs)
• Built Spark based applications for both batch and streaming requirements
• Contributed to the development of a metadata solution to log business and technical metadata
• Implemented data and system controls for managing data quality
• Created/maintained an integrated and regression testing framework using GIT and CI/CD tools
• Wrote unit and integration tests with a goal of full critical path code coverage with a robust logging and reportingResponsible for building, optimizing and maintaining the data pipelines and aiding in building the.

Columbus, Ohio, United States

• Build, test, and maintain data pipelines for tools used by partners and the internal team
• Respond to pipeline connectivity and syncing issues
• Establish and maintain tool integrations with databases and trackers
• Regularly write scripts and workflows to automate data processes
• Establish best practices for data storage through the creation and maintenance of our data warehouse
• Using tools such as Google Data Studio, develop and maintain real-time reporting on program metrics and progress to goal, including but not limited to voter contact attempts, contacts, survey responses, and other.

Pataskala, Ohio, United States

• Onboard data sources to our cloud platform
• Active collaboration with data specialists to shape datasets fit for purpose
• Strong understanding in working with large and complex data sets
• Performed data analysis to ensure data is correctly used in our data quality KPIs and reports
• Ensuring that our platform functions seamlessly and is optimized for efficiency and security according to the teams DevOps principles
• Securing the platform is stable from an operational perspective

Hyderabad, Telangana, India

• Analyzing large amounts of datasets to determine optimal way to aggregate and report on these datasets.
• Developed Spark Applications by using Scala and Implemented Apache Spark data processing project to handle data from various RDBMS and Streaming sources.
• Worked with the Spark for improving performance and optimization of the existing algorithms in Hadoop using Spark Context, Spark-SQL, Spark MLlib, Data Frame, Pair RDD's, Spark YARN.
• Used Spark streaming to receive real time data from the Kafka and store the stream data to HDFS using Scala and NoSQL databases such as HBase and Cassandra.
• Used Kafka for live streaming data and performed analytics on it. Worked on Sqoop to transfer the data from relational database and Hadoop.
• Loaded data from Web servers and Teradata using Sqoop, Flume and Spark Streaming API.

Hyderabad, Telangana, India

• Developed & Executed SQL queries in support of quality measurement programs, in support of data and root cause analysis.
• Intake, load and integrate large volumes of raw, complex health care data from various health plans and disparate sources.
• Maintain, repair, manage, and update databases; provide programming for projects on an ongoing basis
• Develop active Data Quality monitoring and measurement, establishing and publishing KPIs and SLAs
• Involved in Data Quality and Data Governance Strategy & amp, Implementation.
• Understood Logical and Physical data models to build standard reports using SQL Server queries.