Chandra Lekha

With over nine years of IT experience in software design, development, implementation, and support of business applications for various industries, I am a Big Data Engineer at Elevance Health, a leading provider of data-driven solutions for healthcare organizations.

As part of the data analytics and engineering team, I leverage Azure cloud services, such as Azure Synapse Analytics, Azure Data Factory, Azure Analysis Services, and Azure Data Lake, to extract, transform, and load data from multiple sources, create tabular models for business reporting, and optimize data quality and performance. I also have hands-on experience in Spark, Scala, Python, Tableau, Drill, Sentry, and SSRS, and have worked on data ingestion, pre-processing, feature engineering, text analytics, and data visualization projects. Through my work, I aim to deliver data-driven insights and value to Elevance Health and its clients.

9 + years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Insurance, Pharmaceutical, Financial, Telecom and Manufacturing Sectors. 

• Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). 
• Experienced in Cloud Azure Microsoft Azure services azure databases azure cloud HIPAA, Database developer Microsoft Azure like Azure SQL database, Azure Cosmos DB and Azure Data factory, Azure administer created various ETL pipelines and developed code using PySpark
• Proficient in writing SQL queries and developing SQL stored procedures.
• Experience in creating master and child packages, package configurations and logging. 
• Experience in Big data Hadoop, Hadoop Ecosystem components like MapReduce, Sqoop, Flume, Kafka, Pig, Hive, Spark, Storm, HBase, Airflow, Oozie, and Zookeeper. 
• Worked extensively on installing and configuring Hadoop ecosystem components Hive, SQOOP, HBase, Zookeeper and Flume.
• Worked in building application platforms in the Cloud by leveraging AWS, Azure, Databricks, and open-source technologies and with best engineering practices.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
• Leveraging Azure Synapse to build analytics ML model data pipeline
• Performed Data architect with Business Intelligence BI implementation skills: requirements/process analysis, conceptual and detailed design, relational conceptual, logical, and physical modeling and dimensional modeling star/snowflake schema, implementation of cube data warehouse, testing, training, and support. ETL Design, Scheduling, Deployment, and data loading using SSIS and Pentaho Integration Service.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.
• Expertise in Data Warehouse, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation, and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Good Knowledge in writing Spark Applications in Python (pySpark). 
• Working with data extraction, transformation and load using Hive, Sqoop and HBase. 
• Hands on Experience in designing and developing applications in Spark using Scala to compare the performance of Spark with Hive and SQL/Oracle. 
• Hands on experience on Streaming data ingestion and Processing. 
• Experienced in designing different time driven and data driven automated workflows using Airflow. 
• Highly Acumen in choosing an efficient ecosystem in Hadoop and providing the best solutions to Big Data problems. 
• Experience in configuring the Zookeeper to coordinate the servers in clusters and to maintain the data consistency.
• Acumen on Data Migration from Relational Database to Hadoop Platform using SQOOP. 
• Experienced in migrating ETL transformations using Pig Latin Scripts, transformations, join operations. 
• Good understanding of MPP databases such as HP Vertica and Impala. 
• Hands on experience in configuring and working with Flume to load the data from multiple sources directly into HDFS.
• Expertise in relational databases like Oracle, My SQL and SQL Server. 
• Strong analytical and problem-solving skills, highly motivated, good team player with very good communication & interpersonal skills. 
• Experience in developing data pipelines using AWS services including EC2, S3, Redshift, Glue, Lambda functions, Step functions, CloudWatch, SNS, DynamoDB, SQS. 
• Proficiency in multiple databases like MongoDB, MySQL, ORACLE, and MS SQL Server. 
• Worked as team JIRA administrator providing access, working assigned tickets, and teaming with project developers to test product requirements/bugs/new improvements. 
• Hands on experience in Test Driven Development (TDD), Behavior driven development (BDD) and acceptance test driven development (ATDD) approaches.
• Acumen on Data Migration from Relational Database to Hadoop Platform using SQOOP. 
• Ability to stretch myself to meet the project timelines, adapt to new technologies quickly, modify functionality for any requirement changes and support technical team in solving complex issues.
• Good experience in documentation, presentations and identifying new business opportunities.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, businesspeople, and developers across multiple disciplines.

Bachelor of Engineering – CMR Institute of Technologies, India (2009-2013)