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. • Employed advanced data modeling techniques, including Entity-Relationship Diagrams (ERD), through tools like Erwin, guaranteeing a lucid representation of intricate data structures.

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 solutions.• 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 and care management.

•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 data ecosystem for delivering enterprise data for wide consumption including developing data models, corresponding data architecture documents and API's.Focused on providing data in a ready-to-use services form for analytics groups and data scientists who are interrogating information for predictive analytics, machine learning and data mining purposes.

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 program-generated data. Data Engineer responsible for acquiring, curating, and publishing data for analytical or operational uses. Data should be in a ready-to-use form that creates a single version of the truth across all data consumers, including business users, data scientists, and Technology. responsible for providing critical insights and feedback on both table’s voter contact, voter registration, civic engagement, and other programs. This includes regular, automated reporting on program metrics, analysis of program-generated data in order to glean mission-critical insights and publicly available datasets .

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•Designing and implementing database objects•Communicating data insights and recommendations to key stakeholders, internally and externally.Worked with a wide range of data sources and information domains. Was an important link between the data specialist, who focus on shaping the requirements for the datasets in the platform, and the stakeholders around us that we collaborate with to onboard and shape the data that the team requires.

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. • Developed MapReduce/Spark Python modules for machine learning & predictive analytics in Hadoop on AWS. Implemented a Python-based distributed random forest via Python streaming. • Involved in designing and deploying multi-tier applications using all the AWS services (EC2, Route53, S3).

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.