Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Ravichandra Adda

Bengaluru

Summary

With 9 years of experience designing and developing SQL Server and Business Intelligence (BI) database applications, I have successfully managed teams of technical consultants across multiple projects. I am proficient in MS SQL, Integration Services (ETL - SSIS), SSRS, Python, Spark, Kafka, Hive, Redshift, Hadoop, and Apache Sqoop for data extraction, analysis, and troubleshooting. As a focused and problem-solving-oriented professional, I hold a Master's degree from Cleveland State University and a PG Diploma from IIIT-Bangalore.

Overview

9
9
years of professional experience

Work History

Architect

o9 Solutions Inc
Bengaluru, India
06.2021 - Current
  • Design, build, and deploy effective SSIS packages to validate, synthesize, and transform customer data for integrated business planning
    and analytics.
  • Review and analyze customer data along with its technical/functional intent and interdependencies.
  • Lead customer sessions in the technical design, data requirements gathering, and making recommendations on best practices, in case of inaccurate or missing data.
  • Managing a team of technical consultants, providing advisory, and training to the team.
  • Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery.
  • Independently develop, modify, test, and release features based on technical specifications.
  • Create bug fixes and address customer escalations to enhance operational efficiency and reliability.
  • Actively collaborated in design and code reviews, architecture discussions, and infrastructure evaluations.
  • Timely response and resolution of batch automation disruptions, to meet customer SLAs with accurate and on-time results.
  • Build relationships with key enterprise customers by addressing their issues and recommending best practices such as instance sizing, database settings, and extensions. Assist customers in conducting experiments and scaling with various configurations to optimize SQL Server instances for their specific workloads.
  • Engage with the SQL Server community and share database expertise.
  • Work with the R&D team to drive enhancements in the product.
  • Set up SOPs for the Customer Success team.

SQL - Consultant

Column Software Solutions Pvt Ltd.
Gurgaon, India
10.2018 - 06.2021
  • Created database objects - Schemas, Tables, Indexes, Views, User-defined functions, Cursors, Triggers, Stored Procedures, Constraints, and Roles.
  • Optimized the performance of existing queries with modifications in T-SQL queries.
    Created and scheduled SSIS packages to pull data from MS SQL Server and exported to various data sources like Excel Spreadsheets, Flat flies, etc., and vice versa using SQL Server Agent for daily, weekly, and monthly executions.
  • Implemented Transactional Replication between two servers.
    Expertise in configuring and creating SSIS solutions for ETL and BI processes for data integration and migration services.
  • Experienced in Package Configurations, Logging, Error Handling by using an Event Handler, and custom logging for SSIS packages
  • Involved in creating efficient stored procedures for DB jobs.
  • Responsible for gathering requirements from the customer for developing reports.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, and database links and formatted the results into reports.
  • Worked on existing complex SQL scripts to fix errors and change the procedures to match the requirements for various business reasons.
  • Extracted the data from Relational Database Servers using Apache Sqoop and saved it in various file formats in HDFS.
  • Performed data analysis using Python for more insights into the trends.
  • Worked on extracting the live-streaming data from the Kafka server and saving it in HDFS.
  • Exporting the data from the HDFS to HIVE/Redshift tables to perform data analysis using MySQL.

Sr. SQL and ETL Developer/Tech Lead

ITCommence Inc.
Irving, Texas
11.2015 - 09.2018
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other SQL code and SQL joins for applications.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and then loaded the data into the destination tables by performing different kinds of transformations using SSIS packages.
  • Worked on SSIS performance tuning using counters, Error handling, Event handling, and re-running of failed SSIS packages using Checkpoints.
  • Manipulating data using Microsoft SQL Server Integration Services (SSIS).
  • Review T-SQL code to verify it meets the standards for both performance and error handling.
  • Collected business requirements from users and translated them as Business Requirement Documents.
  • Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.
  • Actively supported business users for change requests.
  • Syncing data between SQL Server and Microsoft CRM dynamics using Kingswaysoft tool.
  • Involved in data cleanup from the database.
  • Worked closely with the testing team to debug critical issues.
  • Basic knowledge of webMethods development.
  • Experience in the SCRUM development process

SQL Developer - Internship

Techgene Solutions LLC
Irving, Texas
06.2015 - 10.2015
  • Created complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes, and SQL joins.
  • Worked with SQL queries for data manipulations, Data extraction, and Data Mapping.
  • Built SSIS packages for data extraction, transformation, and load.
  • Hands-on experience in generating reports using SSRS.
  • Handling the errors is SSIS and debugging the issues.

Education

Master of Science - Electrical Engineering

Cleveland State University
Cleveland, Ohio, USA
May '15

PG Diploma - Data Science - Data Engineering

International Institute of Information Technology
Bengaluru, Karnataka, India
Feb '21

Bachelor's of Technology - Electrical and Electronics Engineering

Gokaraju Rangaraju Institute of Engineering and Technology
Hyderabad, Telangana, India
May '13

Skills

  • T-SQL
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • Python
  • Apache Nifi
  • Hive
  • Redshift
  • Hadoop
  • Microsoft CRM Dynamics
  • Kingswaysoft
  • BMC Remedy
  • Spark
  • Apache Sqoop
  • o9 IBPL

Accomplishments

  • Received a Spot Award in June 2023
  • Promoted to Architect in March 2023
  • Received a Spot Award in October 2022

Timeline

Architect

o9 Solutions Inc
06.2021 - Current

SQL - Consultant

Column Software Solutions Pvt Ltd.
10.2018 - 06.2021

Sr. SQL and ETL Developer/Tech Lead

ITCommence Inc.
11.2015 - 09.2018

SQL Developer - Internship

Techgene Solutions LLC
06.2015 - 10.2015

Master of Science - Electrical Engineering

Cleveland State University

PG Diploma - Data Science - Data Engineering

International Institute of Information Technology

Bachelor's of Technology - Electrical and Electronics Engineering

Gokaraju Rangaraju Institute of Engineering and Technology

Similar Profiles

CREATE PROFILE
Ravichandra Adda