Sukesh Gajawada Email & Phone Number

Dallas, TX, US

Durant, Oklahoma, United States

• Mastered a wide array of Azure technologies, including HDInsight, Databricks, Data Lake, Blob Storage, Data Factory, Synapse Analytics, Azure SQL Database, and SQL Data Warehouse, to streamline cloud operations and.
• Designed and automated custom input adapters using Spark, Sqoop, and Oozie, significantly enhancing data ingestion from RDBMS to Azure Data Lake, showcasing a blend of innovation and efficiency in data handling.
• Played a pivotal role in the creation of automated workflows for daily incremental data loads, facilitating seamless data transition from traditional RDBMS systems to more scalable data lake solutions, thus optimizing.
• Executed comprehensive ETL (Extract, Transform, Load) processes, utilizing Azure Data Factory, T-SQL, Spark SQL, and U-SQL for Azure Data Lake Analytics, ensuring efficient and scalable data movement and transformation.
• Engineered and deployed data pipelines in Azure Data Factory, targeting enhanced ETL processes from diverse sources such as Azure SQL, Blob storage, and Azure SQL Data Warehouse, thereby ensuring data integrity and.
• Crafted and deployed JSON scripts in Azure Data Factory, leveraging SQL Activity for efficient data processing and integration, highlighting technical proficiency and advanced deployment capabilities.

• Designed scalable data pipelines using Python, ensuring efficient data extraction, transformation, and loading (ETL) processes across various data sources to support data warehousing and analytics, processing over 10.
• Developed big data solutions utilizing Apache Spark, optimizing data processing performance for large datasets and enabling real-time analytics capabilities to enhance data-driven decision-making.
• Successfully executed query optimizations on AWS, utilizing Amazon RDS and Amazon Redshift, to improve database and data warehouse performance.
• Utilized AWS Athena to manipulate CSV data files stored in AWS S3, applying Scala queries for proficient data extraction and transformation, showcasing versatility in data handling methodologies.
• Formulated and implemented Python solutions to extract data from AWS S3 and populate it into SQL Server, directly supporting business team requirements through effective data integration strategies.
• Managed Cassandra databases, ensuring high availability, fault tolerance, and efficient data storage and retrieval mechanisms, which improved the reliability and performance of data-driven applications.

Hyderabad, Telangana, India

• Conducted in-depth data analysis using Python and SQL to extract insights from complex business datasets, identifying key trends and operational inefficiencies and presenting findings to senior management, leading to.
• Designed and maintained scalable MongoDB databases to effectively manage and store large volumes of operational data, implementing data validation rules and indexing strategies, enhancing query performance and data.
• Developed comprehensive dashboards and reports using Tableau and Matplotlib, visualizing critical KPIs and business metrics for 5 key departments and driving data-informed decisions across departments, increasing.
• Engineered robust ETL pipelines using Talend and Azure Data Factory, integrating data from multiple sources into a centralized data warehouse, streamlining data workflows, reducing data processing time, and enhancing.
• Leveraged big data technologies, including HDFS and Azure Databricks, to process and analyze large-scale datasets, applying advanced analytics techniques to uncover valuable business intelligence and contributing to.
• Collaborated closely with cross-functional teams in an Agile environment to identify and implement process improvements, utilizing MS Excel for ad-hoc analysis and reporting, optimizing business operations, and.

• Engineered data pipelines using Informatica PowerCenter and AWS Glue to extract data from multiple banking systems, including core banking, credit card, and loan management platforms, as part of the Financial Data.
• Deployed a high-performance Oracle database on AWS RDS as the central repository for integrated financial data, implementing security measures and optimizing query performance to handle 50+ concurrent users.
• Coded sophisticated Python scripts for data cleansing and transformation, incorporating algorithms for normalization, deduplication, currency conversion, and format standardization across diverse financial datasets.
• Architected a scalable AWS Redshift data warehouse with an optimized schema to facilitate complex analytical queries on large-scale financial data, enabling rapid analysis of historical trends.
• Constructed an extensive suite of interactive Power BI dashboards for financial reporting, featuring real-time updates, drill-down capabilities, and customizable visualizations for various stakeholder groups.
• Orchestrated Hadoop and Impala clusters to process 2 PB of historical transaction data, implementing partitioning strategies and query optimization techniques for petabyte-scale datasets.

• Extracted historical inventory and sales data from Cipla's ERP system, 5 supplier databases, and 3 warehouse management systems, then integrated this data into a centralized MySQL database hosted on AWS RDS using.
• Executed SQL techniques to streamline data queries, enhancing overall data analysis efficiency and generating actionable insights for informed decision-making.
• Created interactive data visualizations using Tableau, effectively supporting strategic decision-making processes within the organization.
• Used Python scripting to automate data collection, transformation, and analysis tasks, enabling efficient handling of large datasets and complex calculations.
• Performed comprehensive data cleaning and preprocessing using NumPy and Pandas, addressing missing values, outliers, and inconsistencies and extensive exploratory data analysis to uncover critical insights into.
• Designed interactive Power BI dashboards providing real-time visibility into inventory levels, forecast accuracy, and supplier performance metrics, complemented by detailed MS Excel reports summarizing key insights for.

Master Of Science - Ms, Information Technology Management, 3.82

Bachelor Of Technology, Electronics And Instrumentation Engineering

Activities and Societies: Convergence Core Team

Education record

Activities and Societies: Literary Secretary