Gowtham. A

Operations Associate

Chennai, Tamil Nadu, India14 yrs 2 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

14+ years of experience in data analysis
Expert in data visualization and modeling
Strong advocate for data-driven culture

Stackforce AI infers this person is a Data Analyst specializing in Business Intelligence and Healthcare Integration.

Contact

agowtham027@gmail.com LinkedIn

Skills

Core Skills

Business IntelligenceData ModelingData VisualizationData EngineeringData IntegrationHealthcare IntegrationSoftware Development

Other Skills

Microsoft Power BIDAXDBTSQLSSIS/ETLTIBCO SpotfirePower BISQL Server Integration Services (SSIS)SpotfireSQL ServerOracleSAPExcelETLC#

About

Lead Data Analyst | Transforming Data into Strategic Insights | Expert in Visualization, Modeling & Analytics With 14+ years of experience in data analysis, I specialize in turning complex datasets into actionable insights that drive business growth and operational efficiency. My expertise spans data visualization, advanced analytics, and data modeling, supported by proficiency in Power BI, Spotfire, SQL, dbt, Snowflake, ETL (SSIS/SSRS), and Python. I excel at presenting data in clear, impactful ways to inform strategic decision-making. Industry-Specific Expertise: Oil & Gas: Deep understanding of operations, enabling data-driven optimizations. U.S. Healthcare & Logistics: Domain knowledge that ensures relevant, high-impact analytics. Throughout my career, I’ve led high-impact projects that optimize processes, enhance customer experiences, and improve business performance. My approach blends technical expertise with business acumen, ensuring analytics align with organizational goals. I thrive in fast-paced, Agile environments and am passionate about continuous learning, always exploring new tools and methodologies to refine my craft. A strong advocate for data-driven culture, I love collaborating with cross-functional teams to deliver measurable results.

Experience

14 yrs 2 mos

Total Experience

3 yrs 6 mos

Average Tenure

4 yrs 8 mos

Current Experience

Tata consultancy services

2 roles

Lead BI and Data Modelling Specialist

Promoted

Mar 2024 – Present · 2 yrs 2 mos · On-site

Currently working for client Santos, a leading pioneer in the Oil and Gas industry, as a Senior Data Professional, where I am responsible for the following:
Responsibilities:
Performed a Business Analyst role, working closely with stakeholders to gather end-to-end business requirements and advise technical teams on data mapping and solution design.
Architected, designed, and developed end-to-end BI solutions, building reusable and scalable data models by applying data warehousing best practices.
Prepared effort estimates and actively participated in the full SDLC, from requirements and design through development, testing, and deployment.
Demonstrated strong expertise in Power BI, DAX, DBT, data warehousing, TIBCO Spotfire, SQL, SSIS/ETL, and Power BI Report Builder.
Led and mentored a team of five members, providing technical guidance, code reviews, and delivery support across BI and data initiatives.
Actively involved in both project and BAU activities, leading service delivery under BAU engagements to ensure platform stability and SLA adherence.
Created and maintained SOPs, technical documentation, and requirement documents for the services led.
Gained strong domain expertise in the Energy (Oil & Gas) sector, supporting business operations across the ANZ region.
Leveraged DBT and Snowflake to build reliable, analytics-ready data models supporting enterprise reporting and self-service BI.
Implemented CI/CD pipelines using Azure DevOps for build automation, version control, and automated testing.
Applied advanced DAX and SQL development and optimization techniques, utilizing DAX Studio to improve report and query performance.
Implemented Row-Level Security (RLS) in Power BI to support data governance, compliance, and secure access.
Authored best-practice guidelines and development standards for Power BI, DBT, and TIBCO Spotfire development.

Microsoft Power BIDAXDBTSQLSSIS/ETLTIBCO Spotfire+2

Senior Business Intelligence Consultant

Sep 2021 – Mar 2024 · 2 yrs 6 mos · On-site

Led the design and development of interactive Spotfire dashboards, integrating data from SQL Server, Oracle, SAP, and Excel to deliver actionable business insights and reporting solutions.
Automated dashboard workflows using IronPython scripting and scheduled refresh jobs, ensuring timely, accurate, and consistent reporting across multiple environments.
Created reusable information links, calculated fields, and advanced expressions, enabling complex business analysis and scalable reporting frameworks.
Directed performance optimization, tuning, and deployment across Dev, Test, and Prod environments, enhancing report efficiency, reliability, and user experience.
Partnered with business stakeholders, analysts, and cross-functional teams to gather requirements, translate business needs into technical solutions, and drive analytics strategy.

Microsoft Power BISQL Server Integration Services (SSIS)Business IntelligenceData Visualization

Infosys

Technical Lead

Jun 2019 – Sep 2021 · 2 yrs 3 mos · Chennai, Tamil Nadu, India · On-site

I worked as a Tech Lead at Infosys, where I was responsible for leading technical initiatives and managing project delivery. Below is a summary of my key responsibilities:
Responsibilities:
Delivered end-to-end ETL solutions, supporting data ingestion, transformation, and loading across multiple source systems.
Performed end-to-end SQL development, applying data warehousing concepts to design reliable, scalable, and high-performance data models.
Demonstrated strong expertise in SQL performance tuning and optimization techniques.
Supported a logistics client (XPO), integrating HR data, SAP data, and multiple source applications using ETL tools.
Designed and delivered end-to-end Power BI solutions to enable data-driven decision-making for business stakeholders.
Migrated TIBCO Spotfire reports to Power BI, significantly reducing licensing costs and improving platform standardization.
Developed paginated reports with automated weekly and monthly email distribution.
Automated data orchestration and refresh processes using SQL Agent jobs and DBT orchestration to ensure data freshness and reliability.

Microsoft Power BISQL Server Integration Services (SSIS)Data EngineeringBusiness Intelligence

Cognizant

Product Specialist

Nov 2014 – May 2018 · 3 yrs 6 mos · Chennai · On-site

I worked as Associate engineer at Cognizant
Developed SQL scripts, including stored procedures, functions, and triggers, to support QNXT application integration.
Designed, configured, and supported ETL workflows, including job monitoring and issue resolution, to ensure reliable data pipelines.
Optimized complex SQL queries using SQL Profiler and performance-tuning techniques to improve database efficiency and response times.
Worked across multiple QNXT modules such as Member, Provider, and Claims, ensuring accurate data integration and processing.
Contributed to add-on development using C# and .NET to extend QNXT functionality and support system integrations.
Designed and delivered interactive Power BI dashboards across QNXT modules to enable data-driven insights and operational reporting.

Microsoft Power BISQL Server Integration Services (SSIS)Data IntegrationBusiness Intelligence

Acl digital

HL7 and SQL Developer

Jan 2011 – Oct 2014 · 3 yrs 9 mos · Chennai · On-site

Software Engineer | Healthland (Healthcare Client)
Developed a large number of SQL stored procedures and functions to construct and transform HL7 messaging formats.
Worked extensively with SQL Server 2005, including cursors, triggers, DML/DDL operations, transactions, and scripting.
Designed and developed Windows-based HL7 applications to integrate and transform HL7 messages to downstream endpoint systems.
Built VB6 applications supporting HL7 TAM and related healthcare integration processes.
Utilized the Mirth Connect integration engine for HL7 message processing, configuring channels, transformations, and endpoint IPs.
Created and maintained design and technical documentation to support application development and support activities.
Contributed to ASP.NET application development for healthcare laboratory systems.

C#HL7 StandardsHealthcare IntegrationSoftware Development