GAUTHAM S.U
Chennai
Summary
Innovative architect with a strong background in residential and commercial design. Demonstrated expertise in creating architectural plans, collaborating with clients to understand needs, and delivering aesthetically pleasing and functional designs. Possess strengths in project management, spatial problem-solving skills, and knowledge of construction processes. Previous work has consistently resulted in client satisfaction and creation of sustainable, cost-effective building solutions.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Data Architect
Philips India
Chennai
06.2020 - Current
- Analyzed business requirements for data solutions to ensure compliance with enterprise architecture guidelines.
- Investigated problems related to the production environment including performance issues, query tuning.
- Worked with various stakeholders to gather requirements for dashboard reporting needs.
- Coordinated with developers in deploying changes into production environments.
- Created training materials on best data engineering standards and practices
- Assisted with recruitment efforts by interviewing potential candidates and providing input on hiring decisions.
- Held weekly staff meetings to review project updates, discuss issues, and brainstorm solutions.
- Collaborated with other departments to ensure alignment of goals across teams.
- Mentored newly hired interns on best data engineering practices and enabling them to on-board to projects
- Tools Used: Azure Databricks, Azure Data Factory, Pyspark, Unity Catalog, Data Governance, Azure DevOps
Technology Analyst
Infosys Limited
03.2018 - 06.2020
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
- Optimized existing queries to improve query performance by creating indexes on tables.
- Created stored procedures for automating periodic tasks in SQL Server.
- Developed and implemented data models, database designs, data access and table maintenance codes.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
- Build interactive reports for stakeholders for monthly review board for cost aspects
- Tools Used: SSIS, T-SQL, Power-BI, Azure Data Factory, SSAS
Senior Software Engineer
Mindtree Limited
09.2015 - 03.2018
- Created complex reports such as drilldown, sub-reports, matrix and charts to meet the business needs.
- Generated ad hoc queries for creating custom reports based on user requirements.
- Maintained data integrity while designing and developing new report structures in SSRS.
- Designed, developed and maintained report models, data sources, datasets and report parameters in SSRS.
- Involved in creating stored procedures and views for better performance of the reporting system.
- Prepared test cases for validating accuracy of results obtained from generated reports.
- Assisted in troubleshooting various issues related to report development process in SSRS.
- Tools Used: SSRS, SQL
Associate Consultant
Capgemini India Pvt Ltd
01.2013 - 08.2015
- Deployed SSIS packages from development environment to QA, UAT, Production environments successfully.
- Coordinated with business users and project manager throughout the software development life cycle.
- Debugged errors encountered during development or testing phases of ETL processes.
- Configured error handling for all SSIS packages by establishing connection managers, event handlers and logging to track package execution status.
- Utilized C# scripting extensively in Script Tasks to implement business logic while creating SSIS packages.
- Tools Used: SSIS, T-SQL
Education
B.Tech - Information Technology
Dhanalakshmi College of Engineering, Chennai
Chennai06-2012
XII -
SBOA Mat & Hr. Sec. School, Chennai
Chennai05-2008
X -
SBOA Mat & Hr. Sec. School, Chennai
04-2006
Skills
- Data Warehousing
- Data Analytics
- Data Modeling
- Warehouse models
Certification
- Databricks Certified Data Engineer Associate
Languages
Tamil
First Language
English
Proficient (C2)
C2
Personal Profile
- Father's Name : N SUNDARARAJAN
- Date of Birth : 27-MAY-1991
- Address : 311, Block-B, TVH Park Villa, Vinayaga Nagar, Thoraipakkam, Chennai-600097
Timeline
Data Architect
Philips India
06.2020 - Current
Technology Analyst
Infosys Limited
03.2018 - 06.2020
Senior Software Engineer
Mindtree Limited
09.2015 - 03.2018
Associate Consultant
Capgemini India Pvt Ltd
01.2013 - 08.2015
B.Tech - Information Technology
Dhanalakshmi College of Engineering, Chennai
XII -
SBOA Mat & Hr. Sec. School, Chennai
X -
SBOA Mat & Hr. Sec. School, Chennai
- Databricks Certified Data Engineer Associate
Similar Profiles
Akshathaa SAkshathaa S
PMO Manager at Philips IndiaPMO Manager at Philips India
Sumit MahajanSumit Mahajan
Product Sourcing Engineer at Philips IndiaProduct Sourcing Engineer at Philips India
Srinivas YadavSrinivas Yadav
IT Remote Support Specialist at Philips IndiaIT Remote Support Specialist at Philips India