Sathish K

Project Name: PRA (Passenger Revenue Accounting) Data Transformation.

Domain Name: Airline.

Led a project to optimize the airline's data platform using Azure and Databricks, enhancing passenger revenue accounting, and financial reporting.

• Developed ETL pipelines for seamless data flow to data lake storage.
• Developed a data pipeline to extract data from external data sources and data formats such as semi-structured and structured.
• Developed for data ingestion and transformation from the Bronze Layer to the Silver Layer in structured format for data analytics and reporting.
• Worked in data cleaning, data validation, data transformation, and ingestion in the Silver Layer using Databricks Notebook.
• Proficient in optimizing large data processing using Spark and SQL.
• Automated the pipeline with Databricks workflows.
• Used GIT version control for ADF pipeline to maintain the pipeline changes, and export it as an ARM template for Azure DevOps CI/CD.
• Collaborated with stakeholders to gather the business requirements and deliver scalable solutions.
• Generating reports from the silver data lake and transforming it into a periodic report.
• Automated the report delivery system through email services using the ADF pipeline.

Technologies Used:

Azure Data Bricks, Azure Data Factory, T-SQL, PySpark, Python, MS SQL Queries, blob containers, Unity Catalog, Data Lake, Parquet.

Project Name: On-Prem to Azure Cloud Migration.

Key Insights and Responsibilities of the Project:

• Developed ETL pipelines using ADF for seamless data flow to the data warehouse.
• Worked in star schema data modeling for efficient data processing in Spark.
• Developed a data cleansing notebook for generic purposes across the data ingestion in the data lake.
• Implemented a data validation notebook to ensure data integrity and accuracy.
• Handled complex logic in Databricks notebook to achieve expected results efficiently.
• Reduced the data redundancy by using a star schema and optimized the processing of large datasets with incremental loading from external sources.
• Automated the data pipeline for continuous data ingestion on a daily/hourly basis from on-premises data sources to Azure Data Lake.
• Gathered requirements from stakeholders to design data models and reports.
• Developed complex SQL queries to analyze large datasets for trends and insights.

Technologies Used:

Azure Data Bricks, Azure Data Factory, T-SQL, PySpark, SQL Queries, Azure SQL Database, blob containers, Data Lake, Parquet.

Project Name: Global Resiliency Portal for Reporting.

Domain: Insurance.

Responsibility as a Senior Developer of the project:

• Understanding the requirements of the client and thoroughly understanding the project requirements, as well as developing or enhancing the web page.
• Front-End Development: creating the user interface and ensuring a positive user experience. This involves writing HTML, CSS, and JavaScript code, AngularJS, and the .NET Framework.
• Back-End Development: Implementing the server-side logic of the application. This includes writing server-side code in languages like Angular.js, Web API, and MS SQL Server.

Project Name: RRD Hub.

Key Insights and Responsibilities of the Project:

• Developed web applications and APIs for seamless integration with mobile applications on Android and iOS platforms.
• Implemented RESTful services with JSON for efficient request and response handling.
• Spearheaded the development of modules, including Leave Request, Cab Request, and Salary Advance.
• Ensured smooth communication between web and mobile platforms for various functionalities, such as the Project Request Form and the Travel Request.
• Utilized Firebase Cloud Messaging (FCM) technology to send mobile notifications, enhancing user engagement and experience.
• Collaborated with cross-functional teams to meet project deadlines, and deliver high-quality solutions.

Project Name: Sulekha.com Vendor Portal.

Key Insights and Responsibilities of the Project:

• Developed an application for managing employee personal details, and updating information via a portal.
• Utilized Web API, AngularJS, and MVC for application development.
• Implemented features, including admin pages, employee personal information forms, work experience, current roles, team and level information, and education details.
• Utilized SQL Server as the backend, incorporating stored procedures, functions, and views.
• Generated SLA reports on a daily, weekly, and monthly basis to track performance metrics.

Project Name: Win Application.

Key Insights and Responsibilities of the Project:

• Maintained product information, stock availability, sales data, material distribution, customer feedback, and sales and marketing team performance for hotel management software.
• Developed a comprehensive web application using ASP.NET, C#, ADO.NET, WCF, and web services, supplemented by a Windows service.
• Implemented the WIX Installer to package the Windows service for installation.
• Responsible for developing and maintaining hotel management software, ensuring accurate and efficient record-keeping.
• Utilized stored procedures extensively to manage data operations, and ensure database integrity.

Project Name: Offline-Enabled Product Information and Inventory Management

Domain: Inventory

Key Insights and Responsibilities of the Project:

• Developed a comprehensive solution for maintaining product information, stock availability, and material distribution, ensuring uninterrupted operation, even in offline environments.
• Utilized SQL Server as the primary database, but implemented offline functionality to accommodate clients with intermittent internet connectivity.
• Recognizing the client's internet challenges, we integrated an offline module to ensure seamless workflow continuity during internet downtime.
• Temporarily stored data using MS Access while offline enables users to continue working without interruption.
• Implemented synchronization mechanisms to seamlessly transfer data from MS Access to SQL Server once the internet connection was restored.
• Facilitated automatic syncing of offline data to the SQL Server database upon re-establishment of the internet connection, ensuring data availability online.