VIJAYA LAKSHMI INJAM
Summary
Dynamic Technical Lead with extensive experience at Schnucks, specializing in Apache Airflow and CI/CD pipelines. Proven ability to architect scalable data solutions and mentor teams, enhancing data governance and integration. Adept in Python and fostering collaboration, driving successful project outcomes in fast-paced environments.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Technical Lead
Schnucks
St. Louis
08.2023 - Current
- Implemented Apache Airflow Composer as the orchestration tool for managing and scheduling data workflows, ensuring reliable and scalable execution of ETL pipelines for Schnucks.
- Leveraged Apache Airflow's built-in operators and sensors to interact with various data sources and destinations, including Google Cloud Storage, BigQuery, Cloud SQL, and external APIs, enabling seamless integration with Schnucks' data ecosystem.
- Developed near real-time data pipeline using Kafka and Spark Streaming to ingest and transform client data from web log server.
- Implemented and optimized Continuous Integration/Continuous Deployment (CI/CD) pipelines using Jenkins, automating the build, test, and deployment processes to achieve faster time-to-market and improved software quality.
- Collaborated with development teams to ensure reliability, operability, scalability, performance, and security of database systems, architecting robust solutions to meet business needs.
- Led the development, maintenance, testing, implementation, and support of database technologies and associated software products, fostering collaboration between technology teams to achieve project objectives effectively.
- Utilized expertise in Database Replication to set up, configure, and troubleshoot both Physical and Logical Replication, ensuring data consistency and availability across distributed environments.
- Demonstrated advanced proficiency in security, backup/recovery, architecture, networking, and administration for assigned database disciplines, implementing best practices to safeguard data integrity and confidentiality.
- Trained and mentored team members on Apache Airflow best practices and development techniques, enhancing their ability to design and maintain data pipelines.
Technical Lead
Horizon Soft Solutions
St. Louis
11.2021 - 07.2023
- Developed the strategy and design for the continuous delivery framework and tools, serving as a subject matter expert on infrastructure CI/CD pipelines.
- Architected scalable, fault-tolerant data processing workflows with GCP services like Google Cloud Dataflow, Pub/Sub, and BigQuery, ensuring high availability and reliability.
- Designed and implemented end-to-end data pipelines on Google Cloud Platform (GCP) for efficient data integration and analysis.
- Led a cross-functional team in gathering requirements, designing architectural solutions, and implementing data pipelines to ingest, transform, and load (ETL) data from various sources into Schnucks' data lake.
- Implemented best practices for data governance, security, and compliance, ensuring adherence to industry standards and regulatory requirements in all aspects of data processing and storage.
- Optimized NoSQL database solutions using advanced data modeling and query strategies for efficient storage, retrieval, and analysis of large volumes of semi-structured and unstructured data.
- Designed and implemented data migration strategies and procedures, leveraging GCP services such as Cloud Data Transfer, Cloud Storage, and Cloud SQL to efficiently move large volumes of data from on-premises Oracle databases to GCP, reducing infrastructure costs and improving scalability for the organization.
- Transitioned log storage from Cassandra to Azure SQL Datawarehouse and improved the query performance.
- Performed normalization on PostgreSQL databases, applying advanced database design principles to eliminate data redundancy and ensure efficient data storage, integrity, and maintainability.
- Developed custom data processing algorithms and transformations to handle complex business logic and data validation requirements, ensuring data accuracy and integrity throughout the pipeline.
- Mentored junior team members in GCP technologies and best practices for building scalable and reliable data pipelines, fostering a culture of learning and continuous improvement within the team.
- Acted as the primary technical contact, providing expertise and guidance on data engineering best practices, performance optimization, and troubleshooting of data pipeline issues.
- Worked in a fast-paced agile development environment to quickly analyze, develop, and test potential use cases for the business.
Senior Data Engineer
LexisNexis
Alpharetta
11.2016 - 10.2021
- Designed, implemented, and maintained database solutions on the HPCC (High-Performance Computing Cluster) system at LexisNexis, supporting high-volume data processing and analytics for legal and information services.
- Optimized database schemas and queries for performance and scalability on the HPCC platform, leveraging HPCC's distributed computing architecture and parallel processing capabilities to achieve optimal query execution times.
- Developed ECL (Enterprise Control Language) scripts for data ingestion, transformation, and loading on the HPCC system, ensuring efficient and reliable processing of structured and unstructured data from diverse sources.
- Conducted data quality checks to ensure accuracy and reliability within the HPCC environment.
- Leveraged Azure Data Factory for data transformations, integration runtimes, Azure Key Vaults, triggers, and migrated data factory pipelines to higher environments using ARM templates.
- Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Views, Rules, Defaults and complex SQL statements.
- Managed database schema and version-controlled scripts in GitHub to ensure consistency and traceability.
- Developed PL/SQL programs and optimized stored procedures and queries to enhance retrieval speed and server efficiency in SSAS and SSIS.
- Building Looker data dictionary and creating metadata for all the tables to help in future enhancement of the model.
Sr. BI Analyst
Verizon
Alpharetta
01.2015 - 02.2016
- Developed SSRS reports using complex formulas and database queries to generate various ad-hoc reports for business intelligence.
- Experience with SSRS to author, manage, and deliver both paper-based and interactive Web-based reports.
- Designed SSIS Packages to transfer data between servers, load data into database, and archive data file from different DBMS using SQL enterprise manager/SSMS on SQL server 2008 environment.
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Implemented error handling and rollback processes in ETL loads to ensure data integrity during data migration.
- Collaborated with business analysts on Facets and QNXT claims processing teams to design end-to-end system for automatic employer group creation and new member enrollment.
- Creation and maintenance of SQL tables related to enrollment, billing, and group setup in QNXT.
- Configured benefits and contracts for Medicaid Expansion plans to ensure compliance.
- Performed a rigorous internal Claims Audit to ensure correct processing and payment.
- Led system updates for error resolution.
- Ensured CMS compliance regulations adhered to, managed Star Ratings, and met project revenue goals for the organization and its clients.
- Conducting work sessions with the business leaders, owners, IT owners, department team managers, and the software vendor for gap analysis.
- Development of test plan and test case scenarios; Leading training activities for new members of the Medicare Operations team.
- Wide knowledge of Facets Data Model in Membership and Billing.
- Maintained transactional replication between production and reporting servers.
- Audit and enforce database security, code and procedural standards.
Programmer Analyst
Young Innovations
Algonquin
10.2013 - 12.2014
- Developed and maintained business intelligence solutions using tools such as Microsoft Power BI, SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) to support data-driven decision-making across various departments at Young Innovations.
- Designed and implemented data models and ETL processes to extract, transform, and load (ETL) data from multiple sources into centralized data warehouses, ensuring data consistency, accuracy, and reliability for reporting and analysis purposes.
- Created interactive dashboards, reports, and data visualizations in Power BI, enabling stakeholders to gain actionable insights from complex datasets and make informed business decisions in real-time.
- Optimized BI solutions through performance tuning, query optimization, data indexing, and report caching, enhancing system responsiveness and accelerating report generation.
- Facilitated collaboration with business users and stakeholders to gather requirements and analyze data needs, delivering BI solutions that align with organizational goals.
- Designed SSIS Packages to transfer data between servers, load data into database, and archived data files from different DBMS using SQL enterprise manager/SSMS on SQL server 2008 environment.
- Stayed abreast of industry trends and best practices in business intelligence and analytics, continuously evaluating and recommending new tools, technologies, and methodologies to enhance BI capabilities and drive innovation at Young Innovations.
Systems Analyst
HealthSpring
Nashville
09.2011 - 06.2013
- Collaborated with business analysts on Facets and QNXT claims processing teams to design end-to-end system for automatic employer group creation and new member enrollment.
- Developed and maintained BI solutions for HealthSpring, leveraging tools such as Microsoft SQL Server, SSRS, SSIS, and Power BI to facilitate data analysis, reporting, and decision-making within the healthcare industry.
- Designed and implemented data warehouses and data marts to consolidate and integrate data from disparate sources, ensuring data consistency, accuracy, and accessibility for reporting and analysis purposes.
- Created and optimized SSRS reports and dashboards to visualize key performance indicators (KPIs) and healthcare utilization metrics, helping stakeholders monitor performance and identify improvement areas.
- Implemented ETL processes using SSIS to extract, transform, and load (ETL) data from electronic health record (EHR) systems, claims databases, and other healthcare data sources into the data warehouse, automating data integration and ensuring data quality and integrity.
- Collaborated with healthcare professionals, data analysts, and IT teams to gather requirements, define data models, and develop BI solutions that meet the needs of various stakeholders, including clinicians, administrators, and executive leadership.
- Conducted performance tuning and optimization of BI solutions, including query optimization, indexing, and partitioning strategies, to enhance system performance and scalability, enabling faster data retrieval and analysis.
- Trained and supported end-users on BI tools and platforms, including Power BI, SSRS, and SSIS, enabling effective data leverage for decision-making and performance improvement at HealthSpring.
Education
Masters - Information Security
University of Cumberlands
Williamsburg, KY05-2017
Masters - Computer Engineering
International Technological University
San Jose, CA05-2011
Bachelors - Business Management
Acharya Nagarjuna University
Vijayawada, AP, India04-2009
Skills
- Python and R programming
- C and C
- Java and PHP
- Scala and AWS
- Azure and Google Cloud Platform
- Tableau and Power BI
- GitHub and Bitbucket
- Apache Airflow and Looker
- Data Studio and Microsoft SQL Server
- Cloud orchestration
- Data governance
- Oracle and NoSQL databases
- MySQL and PostgreSQL
- Redis and Cassandra
- Docker and Jenkins
- PySpark and Hadoop
- Azure Databricks and HPCC
- Apache Spark and SparkSQL
- ETL development with Pentaho, Talend, Informatica PowerCenter, Amazon Redshift
Certification
- Generative AI Leader Certification
Timeline
Technical Lead
Schnucks
08.2023 - Current
Technical Lead
Horizon Soft Solutions
11.2021 - 07.2023
Senior Data Engineer
LexisNexis
11.2016 - 10.2021
Sr. BI Analyst
Verizon
01.2015 - 02.2016
Programmer Analyst
Young Innovations
10.2013 - 12.2014
Systems Analyst
HealthSpring
09.2011 - 06.2013
Masters - Information Security
University of Cumberlands
Masters - Computer Engineering
International Technological University
Bachelors - Business Management
Acharya Nagarjuna University