Avinash M Email & Phone Number

New Jersey, United States

• Developed and implemented stored procedures to streamline data processing tasks, improving operational efficiency and accuracy.
• Utilized SQL Server Integration Services (SSIS) to automate the extraction, transformation, and loading (ETL) of large datasets from various environments to on-premises systems.
• Designed and created interactive MDS dashboards in IBM to enable users to manage and visualize data effectively.
• Executed comprehensive data analysis processes, ensuring accurate data migration and transformation while maintaining data integrity.
• Performed data cleaning and validation to enhance the reliability and usability of datasets across multiple platforms.
• Automated data import and export processes, significantly reducing manual workload and minimizing errors in data handling.

Houston, Texas, United States

• Designed and implemented data pipelines to ingest large datasets from sources like AWS S3, HDFS, Kafka, and external APIs, automating data intake processes for seamless integration into Amazon Redshift and Snowflake.
• Utilized PySpark and Spark SQL to clean and transform raw data into structured, usable formats, applying transformations to enrich data, ensuring accuracy and consistency before storing in the data warehouse.
• Optimized Amazon Redshift and Snowflake data storage and retrieval for improved reporting and analytics, designing efficient schemas and applying data modeling best practices to enhance performance and scalability.
• Developed and orchestrated ETL/ELT workflows using Apache Airflow, automating data extraction, transformation, and loading processes, and configuring DAGs for seamless execution and monitoring of scheduled data jobs.
• Integrated Apache Spark with Kafka to process and analyze streaming data in real-time, enabling timely data updates for flight performance, customer service, and marketing insights.
• Leveraged AWS Lambda for event-driven data processing, automating data loads into Redshift when new files arrived in S3, and increasing operational efficiency through serverless architecture to minimize manual.

Dallas, Texas, United States

• Designed and implemented ETL pipelines for large-scale data integration, leveraging SQL Server, Oracle, Teradata, and DB2, ensuring seamless extraction, transformation, and loading (ETL) of data from multiple sources.
• Utilized PySpark and Python to automate data transformation and processing, enabling the ingestion of both structured and semi-structured data for energy-related analytics and reporting.
• Built and optimized data pipelines using Informatica PowerCenter and SSIS, automating data flows for energy data extraction, transformation, and loading into target data stores like Netezza, improving accessibility for.
• Worked with cloud technologies like AWS and Azure to integrate and manage data storage and processing, ensuring scalability and reliability for large-scale energy consumption and operational data analysis.
• Developed and maintained data models using ER/Studio, ensuring the proper design of data structures for efficient storage and retrieval, and improving performance for both analytics and reporting.
• Automated data validation and quality assurance processes using Python and SQL, developing scripts to identify and address data integrity issues, ensuring accurate reporting for business stakeholders.

• Participated in cost containment projects to achieve stated savings and explore new opportunities, driving cost reduction through data insights and analytics.
• Partnered with global stakeholders across Network, FWA, Clinical, and Operations to align analytics outcomes with organizational objectives and business needs.
• Prepared and presented strategic and tactical analytics using Tableau and QlikView to managerial and front-line partners, promoting improvements in customer experience and healthcare cost management.
• Presented data insights to identify key improvement opportunities, savings opportunities, and case management strategies, with a focus on reducing costs and improving clinical outcomes.
• Developed predictive models using Python (Scikit-learn, TensorFlow) to forecast medical costs, clinical outcomes, and care provider performance for more accurate decision-making.
• Developed insights into member and care provider performance, identifying key variables impacting healthcare outcomes and cost efficiency.

Hyderabad, Telangana, India

• Involved in creating logical and physical data analyst with STAR and SNOWFLAKE schema techniques using Erwin in Data warehouse as well as in Data Mart
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle, Netezza and Teradata
• Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch
• Writing and executing customized SQL code for ad hoc reporting duties and used other tools for routine
• Extensively used SQL to develop reports from the existing relational data warehouse tables (Queries, Joins, Filters, etc)
• Migrated SSIS packages from SQL Server to SSIS and Created Mappings for Initial load from MS SQL server 2005 to Netezza while performing data cleansing