Gopal Tholambiya

Leading Reporting and ETL Projects. Working on SQL, DOMO, DundasBI, PowerBI, MySQL and ETL- Talend studio. Working with business users and operation team to understand business needs and address customer requirements using scrum agile methodology. Working with various types and stages of Software Development Life Cycle (SDLC) processes including requirements gathering & analysis, solution design, back-end data/ETL process design, development, QA, deployment, maintenance & troubleshooting of data/job issues. Created support documents and sent weekly status reports and daily updating assigned tickets and sprint on JIRA. Providing seamless solutions to maintain Pipeline jobs and reduce running time of job. Collaborated with the data scientist to design masking data architecture for demo.

Integration of data from various sources such as flat files, excels, API, Amazon S3 bucket, etc. using SSIS/ETL. Automation of ETL processes through scheduling and exception-handling modules. Creation of Views, Constraints, Triggers, Joins, Cursors, Indexes, Temp Table, Table Variable, Functions, CTEs, and stored procedures for migration/cleansing processes, reports, data integration, and data validation. Data Extraction, Transformation, and Loading (ETL) using Talend. Optimization of SQL queries and performance improvement by adding required indexes on tables. Proficiency in using SQL Server Management Studio (SSMS) and DataBricks. Development of visual reports, dashboards, and KPI scorecards using Power BI desktop. Connectivity to data sources for Business Intelligence and utilization of advanced functionalities like power query, Date dimensions, loops, and DAX concepts in data modeling. Regular communication with US manager and updating tasks in JIRA.

Developed and maintained web applications using Laravel, adhering to best coding practices and following MVC architectural pattern. Implemented Laravel's features such as routing, migrations, database querying, and authentication to build robust and scalable applications. Created Admin Panel.

Utilized Python libraries for data manipulation and analysis, such as Neural Network, Pandas and NumPy. Assisted in data visualization using libraries like Matplotlib to present insights and results effectively. Prioritized tasks and completed in order of importance.

Project: "Patient Health Monitoring System" - Programmed Arduino boards using C/C++ to collect and process real-time health data from various sensors, such as heart rate, blood pressure. Presented review paper on “Cyber Security with Data Security in Cloud Computing" in Journal of Network Security. Awarded as Best Patang Bazi student.