Sandeep Virelli

About Sandeep Virelli

With over 13 years of IT experience, I specialize in software development, design, and implementation, with a strong focus on Data Engineering, Business Intelligence, Data Warehousing, and Database Applications.I have built data pipelines using Python and Databricks and bring hands-on experience with Azure and AWS cloud platforms. My expertise spans across ETL tools such as Microsoft SSIS, Azure Data Factory, Informatica PowerCenter, and Information Builders DataMigrator, along with reporting tools like MS SSRS. I also have extensive experience with MS SQL Server, Oracle PL/SQL and PostrgreSQL.Key highlights of my work include:Designing and optimizing ETL processes and automation frameworksBuilding robust data validation tools and data models for Policy, Claims, and Billing systemsDeveloping KPI dashboards for BI reportingLeveraging big data technologies like PySpark, Spark SQL, and Databricks for real-time and batch data processingBeyond technical expertise, I excel in team leadership, onshore-offshore collaboration, and managing aggressive delivery timelines. I am adept at backlog creation, user story refinement, and coordinating CI/CD processes. My strong analytical and troubleshooting skills enable me to deliver high-quality solutions independently or as part of a team.I am passionate about using data-driven solutions to drive business success and always eager to embrace new challenges and opportunities for growth.

Experience

1. Data Engineer

   ValueMomentum

   Mar 2023 — Present · Piscataway, NJ, US

   Engineered and optimized ETL processes using Azure Data Factory (ADF) and SSIS, enhancing operational efficiency by reducing processing time.Built data pipelines using Python, Azure Data Factory and Databricks notebooks, leveraging PySpark and Spark SQL for large-scale data processing.Designed the ODS and EDW layers, defining the data model for Policy, Claims, and Billing source systems.Created mapping documents with business rules to load data into ODS and EDW tables.Developed SQL scripts, stored procedures, and ADF pipelines for implementing complex business transformations.Built stored procedures and views for KPI dashboards for BI reporting.Implemented ADLS and AWS S3 for data storage and integration with downstream processes.Created backlog, user stories, performed refinement and estimations for sprint planning.Reviewed pull requests, coordinated, and resolved CI/CD build/release failures.Prepared E-R diagrams and solution design documents for architecture clarity.

Education

• Einstein Post Graduate College

  Master of Computer Applications (M.C.A.), Computer Engineering

  2007 — 2010

• Vivekananda Degree and PG College

  Bachelor's degree, BSC

Skills

• Data Warehousing
• Testing
• Microsoft Sql Server
• Software Development
• Informatica
• Sql Server Reporting Services (Ssrs)
• Ssis
• Etl
• Microsoft Excel
• Ssrs
• Sql
• Xml
• Extract, Transform, Load (Etl)
• Informatica Powercenter Client
• Sql Server Integration Services (Ssis)
• Business Intelligence
• T-Sql