SHIVA SWAMY RAMU
Bengaluru
Summary
Data Engineer with 11 years of expertise in designing and deploying scalable data solutions across multiple industries. Skilled in GCP BigQuery, ETL pipelines, and data analysis, driving improved data operations and actionable insights. Proven ability to partner with stakeholders and implement best practices that enhance performance and operational efficiency. Dedicated to leveraging cloud technologies to optimize data workflows and support strategic business objectives.
Overview
11
11
years of professional experience
Work History
Technical Consultant
ValueLabs
Hyderabad, India
09.2021 - Current
- Analyzed and modified SQL queries, resulting in a 20% reduction in response times for improved system efficiency.
- Established best practices to enhance continuous process automation for data ingestion and data pipeline workflows.
- Streamlined migration process of Alteryx workflows to GCP BigQuery, ensuring seamless integration and improved performance.
- Automated Monthly Sales Report generation, increasing reporting speed by 80% through innovative process improvements.
Data Analyst
Sigma Aldrich Chemicals Pvt Ltd
Bangalore, India
10.2019 - 09.2021
- Designed and developed applications using QlikView and Qlik Sense, defining data modeling standards and best practices for enterprise data models.
- Integrated data from Salesforce, SQL Server, and Excel, performing data extraction and transformation for visualization in the main UI.
- Created dynamic filters and visualizations using various Qlik Sense objects, developed a master calendar, and conducted unit testing for functionality, performance, and security.
- Enhanced existing reports and dashboards based on business requirements, including script optimization and normalization.
Associate
KPMG
Bangalore, India
11.2018 - 09.2019
- Analyzed system requirements and designed QlikView dashboards, supporting existing applications and developing new reports.
- Collaborated with business teams to refine transformation and cleansing logic, and provided data-driven solutions for QlikView dashboards.
- Developed detailed design documents and worked closely with executives to create and enhance SQL Server data models.
Technology Analyst
Infosys
Bangalore, India
11.2014 - 11.2018
- Designed data models and QlikView dashboards based on business requirements, optimized existing models for enhanced performance, and developed interactive reports.
- Executed unit, integration, and regression testing, prepared test case documents, and performed proof of concept (PoC) independently.
- Prepared detailed design documents and SQL queries for data testing, ensuring effective delivery of reports and dashboards.
Education
Bachelor of Engineer - E&C
Visvesvaraya Technological University
05-2013
Skills
- GCP BigQuery
- Data Analysis
- Database querying
- Data extraction and transformation
- Airflow Composer
- Python
- Datawarehouse
- Data Modelling
- Qlik
- Power BI
Timeline
Technical Consultant
ValueLabs
09.2021 - Current
Data Analyst
Sigma Aldrich Chemicals Pvt Ltd
10.2019 - 09.2021
Associate
KPMG
11.2018 - 09.2019
Technology Analyst
Infosys
11.2014 - 11.2018
Bachelor of Engineer - E&C
Visvesvaraya Technological University